Aaron Phillips, MBA

Experience

• 

  Geisinger

  Sept 2006 - Sept 2011

  • Served as administrator for Onyx application, including SQL data extraction for all insurance segments, data maintenance and security administration.• Performed advanced SQL query writing, including use of cursors, complex data marriage from multiple systems and creation of stored procedures.• Served as administrator for ACom3 commissions paying application, including report building and distribution for SQL data extraction and analysis.• Scheduled report runs, click-through and drilldown functionality, and integration with core systems. • Developed innovative tools to streamline sales processes with the assistance and guidance of Sales Operations Efficiency Manager.• Managed RFI/RFP process in Sales, including incoming request distribution, application security administration and report production. Show less • Designed and implemented new, easy to use, RFI/RFP Extraction system to enable the RFI/RFP response database to be constantly maintained with the most up-to-date information.• Developed multiple Sales and Marketing reports using SQL, SSRS, COGNOS and Crystal XCelsius to support senior and executive level decision makers.• Developed and automated Gold and Individual Reporting packages for Medicare and Individual product lines to improve workflow and efficiency.• Served as administrator for Onyx application, including data extraction using SQL language for commercial and individual insurance segments, data maintenance and security administration.• Performed quality monitoring for Telemarketing department to ensure proper procedures for customer contact. Show less

  • Sales & Marketing Systems Supervisor

    Oct 2010 - Sept 2011

  • Sales & Marketing Systems Analyst

    Sept 2006 - Nov 2010
• 

  Sanofi

  Sept 2011 - Apr 2012

  Manager, Reporting

  • Managed reporting and information governance projects through completion of business requirement documents, project plans, etc.• Partnered with various departments to build comprehensive reporting and/or business solutions.• Maintained and executed reports that resided outside of automated systems with the goal of working toward automation of each separate item.• Implemented various reporting solutions for sales and marketing, such as annual promotion dose forecast, through the use of MicroStrategy business intelligence software. Show less

• 

  Geisinger

  Apr 2012 - Sept 2014

  Sales Systems Manager

  • Managed Sales Systems Analytics and Data Entry teams, including delegation, prioritization and review of all assignments. • Trained all staff on appropriate procedures and system tools available for analytics and report building as well as affected end stakeholders.• Provided first line of technical support for all Sales and Marketing applications, coordinating with IT staff to prioritize and resolve SRs and Trouble Tickets.• Created workflow management tools, including new business quoting checklist script, interactive dashboard, and cycle time statistics reports, which streamlined processes and improved turnaround time of requests.• Served as co-lead for Health Insurance Exchange implementation project, including training of departments throughout the organization. Show less

• 

  Sanofi

  Sept 2014 - Jun 2022

  ▪ Assisted with development of strategies and roadmaps through collaboration and partnership with various business and Information Technology and Solutions teams.▪ Managed vendor relationship, workload, and priorities for the business intelligence team within the Information Technology and Solutions group.▪ Partnered with Commercial Operations business units to define, design, develop, and implement business intelligence solutions including dashboards, reports, self-service analytics tools, and two-way data view/capture tools.▪ Lead eCommerce and eBusiness projects, from requirements gathering through implementation, including coordination of resources in a highly matrixed organization with cross-functional teams.▪ Provided first line technical expertise for Business Intelligence, eCommerce and eBusiness, web, and mobile applications for Commercial Operations.▪ Partnered with various departments and business units to investigate emerging technologies, functional gaps within existing tools, and industry trends in order to provide innovative and optimal technical solutions. Show less

  • Program Manager, North America, Digital Business Data and Analytics

    Jul 2019 - Jun 2022

  • Deputy Director, Information Technology and Solutions

    Sept 2014 - Jul 2019
• 

  Regeneron

  Jun 2022 - now

  Associate Director - Product Management, Commercial IT