data warehouse analyst resume example with 2+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • :

Highly motivated and solution-driven data analyst with over 5 years of project experience and 2 years of working experience in data analysis, modeClaireg, and visualization. Strong analytical and troubleshooting skills with a proven track record of successfully identifying and solving complex business problems. Expert in delivering customized IT solutions to improve system designs and boost business operations. Proficient in a variety of data analysis tools including Python, SQL and R. Strong communication and presentation skills with the ability to effectively translate insights to both technical and non-technical audiences.

  • Analysis and ModeClaireg
  • Relational Databases
  • PPE Use
  • Database Programming and SQL
  • Data Quality
  • Clear and Concise Communication
  • Attention to Detail
  • Informatica Platform
  • Requirements Definition
  • Data Integrity Validation
  • Compatibility Testing
  • Query Tools
  • Analytical Problem Solving
  • Technical Support
  • Business Intelligence Systems
Data Analyst, 11/2022 to Current
Anthem, Inc.Eagan, MN,
  • Supported data warehouse to improve the consistency and data reporting including data sources, definitions, formats, validation, cleansing, and verification
  • Utilized historical user behavior records to calculate RFM value, value group portraits, and user lifecycle value to support better customer maintenance and advertising
  • Notable Project: Ecommerce Project for Flower Subscriptions
  • Developed models using machine learning algorithms like KNN, CNN, and XGboost to predict activation rate trends as well as ensemble models to predict new user conversions for support of fission schemes
  • Provided reports with performance evaluations of confusion matrixes, assessment of membership retention and loss risks, aiming at lowering user churn rate by 17% for next year.
Business Analyst, 08/2022 to 10/2022
General ElectricButte, MT,
  • Led analysis and troubleshooting of Sage X3, including identification of functional requirements, testing, and debugging
  • Delivered solution-based Crystal Reports to minimize manufacturing gaps and resolve cost discrepancies
  • Developed SQL models & scripts to maintain data integrity and built data pipeClairees for S&OP
  • Integrated big data records count in the millions from multiple data sources into data repository
  • Integrated millions of big data records from disparate data sources into a central repository
  • Notable Project: Package Dimensioning Project
  • Proposed a system framework that would optimize warehouse operations and reduce shipping costs by 30%
IT Consultant, 02/2021 to 08/2021
DeloitteLouisville, KY,
  • Delivered BA/BSA/DA functional system support and functional specification documentation to clients on a stakeholder-requirement and critical metric basis
  • Developed visualization solutions such as implementation road maps to development team to facilitate requirement translation
  • Performed Unit/Integration/System/UAT testing, as well as documented bug lists and user manuals
  • Integrated system functionality with user-friendly interfaces and API integration with third-party tools
  • Managed millions of datasets by cleaning, retrieving, reorganizing, and categorizing product master information
  • Notable Project: Siemens Digital Transformation
  • Contributed to the planning, analysis, design, implementation, testing, and integration of SDLC processes throughout the project lifecycle
  • Facilitated a front-end tech stack migration and back-end system development, saving Siemens 20% in tech costs and increasing user retention by 40% with new ecommerce products and ERP systems go-live
Data Analyst (Part-time), 06/2019 to 08/2020
Company NameCity, State,
  • Improved inventory and order management protocols for Amazon Ecommerce stores using SQL Server to increase order efficiency by 200%
  • Ensured the integrity of the database and prepared data analysis reports for sales purposes
  • Provided support to CRM with product questions in order to maintain high levels of customer satisfaction
Python Data Analyst - Home Warranty and Real Estat, 02/2018 to 05/2018
Company NameCity, State,
  • Researched determinants of customer onboarding and renewal rates by leveraging visualization and hypothesis testing
  • Created user personas based on aggregating data from marketing tools like Google Analytics and Salesforce
  • Identified ROI of channels and advised client on entry into new market through analysis of projected effect of market expansion
R Data Analyst - S&P 500 Financial Performance & I, 09/2017 to 12/2017
Company NameCity, State,
  • Provided reports with visual insights of KPI and ROI illustration based on the transaction data of S&P 500 index to client investors
  • Implemented supervised and unsupervised models using R scripts to identify variables that affect YTD, providing short-term and long-term investment advice to clients
Python Data Analyst – Room Booking Analysis, 03/2015 to 05/2015
Company NameCity, State,
  • Analyzed booking rates to support the decision-making process for new feature launches and improvements to guest booking experiences
  • Performed AB test to verify root causes for low occupancy rate based on 8k+ booking records
  • Assembled statistical hypothesis testing to identify probable outcomes of feature change in terms of KPIs
Education and Training
Master of Science: Business Analytics, Expected in 05/2022 to Brandeis University - Waltham, MA,
Bachelor of Science: Business Administration, Expected in 05/2020 to University of San Francisco - San Francisco, CA
Additional Activities
  • Volunteer: Boys Hope Girls Hope Academy - [CA, 2019]

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Brandeis University
  • University of San Francisco

Job Titles Held:

  • Data Analyst
  • Business Analyst
  • IT Consultant
  • Data Analyst (Part-time)
  • Python Data Analyst - Home Warranty and Real Estat
  • R Data Analyst - S&P 500 Financial Performance & I
  • Python Data Analyst – Room Booking Analysis


  • Master of Science
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: