Senior Business Intelligence Analyst Resume Example Mckesson Corporation

SENIOR BUSINESS INTELLIGENCE ANALYST

Summary

Senior Business Intelligence Analyst versed in data mapping and translating operational needs into technical solutions in high-pressure environments. A passion for data that activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating and managing relationships to draw connections across departments and subject matters that drive solutions. Proficient in leveraging analytics and reporting tools using effective design to provide insights and engage users.

Experience

Mckesson Corporation - Senior Business Intelligence AnalystMorristown , NJ01/2019 - Current

Coordinate with project managers across multiple initiatives to align strategy with future project goals and develop timelines.
Oversee and supervise vendor partner and liaison between team and business executives.
Coordinate strategic flow of business intelligence data to users. Establish and oversee quality standards, streamline gathering requirements, evaluate progress toward important milestones and facilitate on-time delivery of ETL feeds from various source systems.
Provide advisory services governing data migration from legacy systems to up-to-date technology that will deliver significant improvement in productivity.
Prepare business requirements to provide scope of work for technical team and create documentation stories in Jira.
Test validity, accuracy and consistency of new and existing intelligence data and resources. (Snowflake, Sales Force, Tableau, Teradata, Oracle BI)
Compile current business intelligence data into reports and present findings to senior leadership.
Deploy Tableau dashboards tailored to strategic account manager's book of Customers.
Maintain a library of templates and reusable knowledge assets to track customer trends enterprise wide, measure effectiveness of field programs and special promotions.
Improved the number of automated reports (vs manual) by 43% in 18 months.
Manage sales territory alignment analysis and reporting each fiscal period.
Collaborate on a Customer and Product Attrition predictive model that analyzes customer sales trends, Sales team contact points and customer behaviors.
Explain technical concepts to non-technical staff members in easy to understand language and concepts.
Create training materials and hold training sessions with multiple levels in the sales organization.
Conduct root cause analyses on data integrity issues and coordinate with the appropriate IT teams to correct.
Coordinate and implement permissions measures to protect sensitive enterprise data.

Advance Auto Parts - Professional Sales AnalystCity , STATE10/2016 - 01/2019

Developed and refined specific customer segments based on firmographic information, customer performance and customer decision criteria.
Drove performance report development and crafted insightful KPIs to give field sales managers visibility to their team's weekly results.
Collaborated with team members (corporate and field) to identify metrics, program requirements, logical data models, develop solutions, meet deadlines and produce appropriate reporting.
Conducted analysis to support Professional programs and made actionable recommendations to all levels of management. (Most frequently, Directors, VPs and EVPs).
Created and maintained SharePoint site for the Professional Department (60+). Set and maintained permissions for sensitive reports and documents for field and corporate team members (130+)
Improved customer satisfaction of AAP's top three Professional customers by finding creative solutions to problems, delivering reporting consistently and within deadlines. Recognized by senior leadership for providing exceptional customer service.
Leveraged Excel to compile data gathered from multiple source systems. Used complex formulas and key data elements to map the sources together.
Listened to field sales team needs and assisted with identifying metrics and producing appropriate reporting.
Kept customer information confidential and handled details accurately.
Partnered with vendor to custom-build Reporting and Analytics data sources in Tableau.

Advance Auto Parts - Senior Inventory Analyst/ Inventory AnalystCity , STATE11/2012 - 10/2016

Planned, ordered and maintained weekly Engine Management inventory in 10 distribution centers (65K+ DC SKUs) including planogram rollouts and store drop ins
Managed and analyzed best use of more than $137M annual budget and $279M in annual sales over four business categories (4.4% and 4.3% of total company respectively)
Managed and analyzed forecasts and in stocks daily at DC level to meet sales demand
Detailed maintenance and monitoring of JDA(AWR) data integrity to increase efficiencies in ordering and forecasting
Created/ran SQL and OBI Answers queries to analyze data trends and make buying decisions
Cultivated and maintained relationships with vendors, co-workers, product directors, and field team members
Maintained engagement in the SKU life cycle and category strategy of SKU base
Managed Spark Plug promotional buys and implementation
Managed domestic to direct import transition on 560+ SKUs, ordered for both domestic and direct import, manipulated lead times, created projections and managed overall timelines

Advance Auto Parts - Creative Retail Packaging SpecialistCity , STATE09/2009 - 11/2012

Maintained a UPC and Part Number library for all domestic and import private label products.
Project management of domestic packaging projects and re-label projects in 10 distribution centers, 3,000+ stores for 100-1,000 SKUs for most projects.
Worked closely with the Global Sourcing Taiwan team, PIM team, and Ecommerce team gathering digital assets, enhanced content and attributes for private label products, attributes and packaging design.
Managed conference materials and packaging procurement for the Global Sourcing and Merchandising teams.
Prepared packaging design artwork for printing (copy write, edit, proof, color management, etc.).
Reviewed competitors' samples, industry trends, new packaging guidelines, etc.

Activities and Honors

Team Member Network, Knowledge Network Chapter Lead

Skills

Tableau/Tableau Dashboard development
Sales Force
Data and Sales Operations Analysis
Microsoft Office Suite and Access
Oracle Business Intelligence (BI)/SAP BusinessObjects
Snowflake Data Warehouse
Requirements Analysis
Project management/Jira/Confluence
Strategy/Innovative problem solver

Education/Training
Leader/Team builder
Read/Modify SQL
Diversity and Inclusion Ally
Team Member Network Chapter Lead
Budgeting/Forecasting
Inventory/JDA AWR and ASR Replenishment systems
Merchandising/Retail
Packaging design

Education and Training

Bachelor of Science: Business ManagementBrigham Young University2006Political Science Cluster (12 credit hours, GPA: 3.81

Business Intelligence Certificate: BusinessWake Technical Community CollegeCity12/2018

Resume Overview

School Attended

Brigham Young University
Wake Technical Community College

Job Titles Held:

Senior Business Intelligence Analyst
Professional Sales Analyst
Senior Inventory Analyst/ Inventory Analyst
Creative Retail Packaging Specialist

Degrees

Bachelor of Science : Business Management
Business Intelligence Certificate : Business

Senior Business Intelligence Analyst Resume Example

DISCLAIMER

How this resume score could be improved?

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes