Andrew Sims

Senior Analytics Manager, Pharma at CoverMyMeds
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Columbus, Ohio Metropolitan Area, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Eric Vore

Andy was my go-to person for Microstrategy reporting and Pivot Tables at LBrands. I don't think I ever had a question in either of those areas that he didn't know a solution for.

Douglas Wysocki

Andrew worked directly for me at L Brands (La Senza Brand). He was a value to the team and to the organization as a whole. I hope to work with Andrew again in the future. He has the skills and the drive to handle any situation and drive results. A true leader within the organization.

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Tableau Author
    Tableau Software
    Apr, 2020
    - Nov, 2024
  • Tableau Consumer
    Tableau Software
    Nov, 2019
    - Nov, 2024

Experience

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Senior Analytics Manager, Pharma
      • Jul 2021 - Present

      • Led the growth of the Pharma Reporting Team from 3 Associate Data Analysts to a diverse group of 10+ memberso Positions managed include Data Engineer, Tableau Analyst, Senior Data Analyst, Data Analyst, Associate Data Analyst, and Consultant• Implemented a Kanban style task management system to track output, gauge bandwidth, and monitor backlog• Established an in-depth code review process to ensure data accuracy• Built out extensive documentation for all team functions including Data Ops, Reporting, Privacy, and Onboarding & Training

    • Analytics Manager, Pharma
      • Feb 2021 - Jul 2021

    • Senior Product Analyst
      • Jan 2019 - Feb 2021

      • Utilized SQL Server Management Studio (SSMS) to gather, analyze, and optimize data for various products, projects, and ad hoc requests• Constructed numerous Tableau dashboards to visualize each of the data outputs which were constructed in SSMS• Collaborated with numerous cross-functional teams to build the initial data structure of several new products• Led exploratory initiatives with new tools including Salesforce and Smartsheets• Assisted multiple business units and the Account Management team with ad hoc analyses • Optimized our external reporting suite using Visual Basic Applications• Worked with our Project Managers and Developers on new product set up to ensure all analytic requirements were being met and the data was validated

    • Retail
    • 500 - 600 Employee
    • Central Planning Manager, Reporting
      • Apr 2018 - Jan 2019

      • Align with leadership on reporting and tool needs to support business decisions• Develop, automate, and maintain a brand-wide reporting suite used by numerous cross functional partners including Planning, Merchandising, Allocation, Store Operations, Ecommerce, and International• Complete various ad hoc data requests for senior leadership in an accurate, timely fashion• Support various team meetings with reporting and deck preparation• Managed several direct reports on a variety of projects including the development of new tools and report enhancements

    • Senior Central Planning Analyst, Reporting - La Senza
      • Jun 2014 - Apr 2018

      • Creation and execution of company wide reporting using complex spreadsheets, databases, and code modules within Microsoft Access and Excel• Detailed analytics and data mining in various systems and software applications such as MicroStrategy• Cross functional alignment with various business partners including Planning, Merchandising, Store Operations, E-Commerce, and Allocation• Direct analytical support to Executive Leadership Team (ELT) to influence business decisions

    • Demand and Deployment Analyst - La Senza
      • May 2013 - Jun 2014

      - Constructed key business reports using Microsoft Excel and Microsoft Access to drive business decisions and weekly meetings- Built various tools to assist Canadian stores with core inventory replenishment- Managed inventory for all real estate activities including store openings, closures, and relocations; involved DC coordination, determining build/decline factors, and inventory strategies- Led specialty deployment projects including depth testing, Never Lose a Sale, Replenishment Hotline, and White Glove; involved elaborate reporting, store/field communication, and detailed analysis- Supervised inventory flow and activities for E-Commerce

    • France
    • Personal Care Product Manufacturing
    • 700 & Above Employee
    • Retail Analyst
      • Mar 2012 - May 2013

      • Feature optimization at Wal-Mart by analyzing product mixtures, proposed store lists, and piece counts. • Tracking various promotions including item rollbacks, endstand displays, and cross category programs through Microsoft Excel templates which I constructed. • New item creation and set up for conversion items and additions. • Various other reports and forms with a heavy concentration on analytics. • Feature optimization at Wal-Mart by analyzing product mixtures, proposed store lists, and piece counts. • Tracking various promotions including item rollbacks, endstand displays, and cross category programs through Microsoft Excel templates which I constructed. • New item creation and set up for conversion items and additions. • Various other reports and forms with a heavy concentration on analytics.

    • United Kingdom
    • Manufacturing
    • 700 & Above Employee
    • Customer Demand Replenishment Planner
      • Jul 2011 - Apr 2012

      • Inventory management and order creation for Sam's Club account, responsible for Dry Grocery and Perishable categories. • Maintain proper inventory levels at Sam's Club distribution centers to avoid out of stocks and to prevent high on hands. • Direct customer facing and responsible for numerous reports primarily from Retail Link. • Manage new item launches and promotional execution.

    • Customer Support Analyst
      • Jun 2010 - Jul 2011

      • Order management between Unilever distribuition centers and Sam's Club distribution centers.• Responsible for the following catergories: personal care, dry grocery, and Slim-Fast. • In charge of scheduling delivery appointments, maintaining customer case fill, and on time deliveries.

    • United Kingdom
    • Manufacturing
    • 700 & Above Employee
    • Customer Support Analyst - Internship
      • Jul 2009 - Dec 2009

      • Order management between Unilever distribuition centers and Sam's Club distribution centers. • Responsible for the following catergories: personal care, dry grocery, and Slim-Fast. • In charge of scheduling delivery appointments, maintaining customer case fill, and on time deliveries. • Order management between Unilever distribuition centers and Sam's Club distribution centers. • Responsible for the following catergories: personal care, dry grocery, and Slim-Fast. • In charge of scheduling delivery appointments, maintaining customer case fill, and on time deliveries.

Education

  • University of Tennessee-Knoxville
    Bachelor, Logistics, International Business
    2008 - 2010
  • Pellissippi State Technical Community College
    Associate, Business Administration
    2005 - 2007

Community

You need to have a working account to view this content. Click here to join now