Arpita Shah
Iselin,NJ
Summary
Data-driven forecasting analyst with 7 years of experience in the healthcare industry. Proven ability to analyze large amounts of data, identify sales opportunities, and provide actionable insights to optimize sales strategies and increase market share. Offering exemplary client relationship and support skills.
Overview
17
17
years of professional experience
Work History
Sales & Forecasting Analyst III
Horizon BCBSNJ
07.2016 - Current
- Owned, update and maintain Midsize forecasting model to provide membership status to the sales team and senior leadership.
- Developed SAS processes that standardized and streamlined Enterprise-wide enrollment data inputs, automated manual tasks and improved end-to-end time for report distribution from 48 hours to 2 hours
- Migrated a complex fee forecasting process from MS Excel to SAS, improved processing time from 48 hours to 2 hours and significantly upgraded the utility of the information for downstream customers
- Established SAS processes that reports data inconsistency and communicated these data errors with the responsible teams to fix them
- Proficient in structured and un-structured data cleansing to automate reports for senior leadership and sales teams
- Developed integration between large historical and future datasets to bridge the gap within the forecast models that offered highly robust data reporting and analytical insights to the business partners
- Published comprehensive weekly and monthly reports comparing actual enrollment performance to forecasted business plans and highlighting target gaps, trends, and variances to budget
- Manage & maintained enrollment databases in SAS and Tableau dashboard for quick ad-hoc reporting and high level overview of key Business Metrics
- Architected multiple SAS processes using the Plan, Build, Operate model and trained colleagues to efficiently analyze business data
- Coached and mentored multiple teammates in SAS programming as an SME that enhanced employee development and improved bench strength
Informatics Analyst II
Horizon BCBSNJ
11.2012 - 07.2016
- Collaborated with customers to understand and analyze their requirements/data, identify, deliverables, resolve any issues/queries regarding the output
- Produced monthly member risk score information by joining ImpactPro risk score to member enrollment file
- Provided weekly individual enrollment report and detailed file to different departments at Horizon
- Developed process and templates to pull data from Horizon Marketing Database for member and prospect that can be joined to member enrollment file
- Created a self-serve process for marketing team that outputs a pdf file with SAS-GIS map of NJ which pin points OCS partners (tier 1, tier 2, tier 3 hospitals) and an excel file which contains zip codes and city within desired radius from the hospital
- Developed simple to complex SAS stored processes that would serve as self-serve reports for customers
- Independently learned and developed comprehensive reporting package in SAS Web report studio Report & SAS BI dashboard to include summary report linked to detailed report with graphical summaries for various customers
- Cleaned up and integrated multiple large data sets in SAS Enterprise guide to produce innovative summary and graphical reports
- Provided, created, tested, and deployed a solution to password protect detailed SAS Web report studio reports
- Produced heat maps of New Jersey and linked those to all the SAS Web applications for visualization of member enrollment by different counties
- Trained and assisted multiple teams to create simple, drill down, and linked SAS Web report studio reports, SAS BI dashboards, stored processes and portal pages
- Scheduled and deployed jobs in SAS Data Integration Studio and SAS management Console
- Assisted with migration of SAS Web Report studio report and SAS BI Dashboards from the old SAS environment to the new environment
- Created a member enrollment Tableau dashboard that answered day to day queries on member enrollment
- Worked on multiple requests to analyze member data and its deliverables simultaneously on day to day basis
- Created permanent and temporary user defined formats in SAS Enterprise guide that is used by team members
- Reconciled and evaluated premium rates for individual and small group market segments
- Researched and developed automated solution to assign individual field name to the many generic field names in SAS Enterprise guide
- Enhanced existing SAS Enterprise guide projects to run efficiently and enable automation when required.
Informatics Analyst I
Horizon BCBSNJ
02.2011 - 11.2012
- Created, validated and generated member enrollment reports, lists and graphical summaries for internal customers on daily basis
- Utilized SAS and its web applications to develop and automated complex reports requested by client managers
- Developed complex SAS codes and created stored processes to deliver reports continually
- Enhanced existing and formed new SAS code template that generates output for mailing health members
- Accessed and analyzed data from extracts created from data warehouse
- Edited a template for data manipulation to produce the desired data sets needed for the reporting
- Delivered a portal page that included SAS Web report studio reports linked to stored processes and detailed report for a project that contained reporting of 5 years’ worth of data.
Validation Specialist
Immunomedics, INC.
11.2007 - 02.2011
- Planned, developed and executed IQ/OQ/PQ protocols and wrote summary reports for any new GMP equipments in Manufacturing, Cell Culture, Microbiology, and Quality Control departments
- Ensured compliance with the Change Control system for validated state of the GMP equipments Project lead for implementing 5-year revalidation policy for GMP refrigerators, freezers, and incubators through out the facility as the SOP
- Maintained validated state for autoclaves and depyrogenation ovens by performing annual revalidations and validation of new loads
- Developed and executed cleaning validation protocol in Cell Culture Manufacturing Department
- Generated company’s standardized operating procedures (SOPs) and other documentation as determined appropriate
- Developed and executed software validation protocol for the Empower software for the new High Performance Liquid Chromatography (HPLC) in the Quality Control department
- Reviewed & organized Log sheets and temperature charts, and monitored the Purified Water System
- Performed investigation and wrote non-conformance report (NCRs)
Engineer
Merck Manufacturing Division
06.2006 - 06.2007
- Completed Validation Reference Manual for Pedvax Chemistry and Alum/Buffer
- Project lead for combining annual Clean-In-Place (CIP) studies on the tanks in Recombivax, saving significant money for the company
- Project lead for the execution of the Steam-In-Place (SIP) re-validation on the alum tank
- Identified a gap in Continuing Validation (CVAL) studies of flex hoses in Recombivax department and sealed it by writing protocol and executing CVAL study on it
- Planned, executed, and evaluated continuing validation activities to maintain regulatory compliance for processing equipment including tanks, autoclaves, and freezers
- Developed and executed continuing validation protocols by utilizing the company’s standardized operating procedures (SOPs) to ensure consistency
- Participated on cross-functional teams consisting of manufacturing, automation and QA personnel prior to execution of validation activities
- Prepared validation final report packages and related documents for the accomplished studies and followed them through approval cycle
- Performed and wrote investigation of non-passing validation studies
- Conducted customer meetings to investigate on-passing validation studies and to discuss and implement the improvements for validation process
Education
Masters of Science in Biostatistics -
New Jersey Institute of Technology
12.2011
Bachelor of Science in Biomedical Engineering & Minor in Applied Mathematics -
New Jersey Institute of Technology
06.2006
Skills
- Strong customer focus
- Expert in process improvements
- Excellent time management & organizational skills
- Highly proficient in data analysis using SAS programming, MS Excel & Access, Tableau
- Robust business acumen for report creation and data management
Technical Expertise
- Language: SAS, SQL, R
- SAS Tools: SAS/Enterprise Guide SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS /Graph, SAS/OLAP Server, SAS EBI, SAS add-in MO, SAS Enterprise Miner
- Business Intelligence: Tableau, SalesForce, SAS BI platform, SAS Management Console, SAS Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio
- Database: MS-Access, DB2
- Microsoft Office: Word, Excel, PowerPoint, Outlook
Strengths
Data Analysis
Analyzed simple to complex data to identify sales trends and opportunities, resulting in improved decision-making.
Communication
Effectively communicated complex data insights to cross-functional teams, resulting in improved decision-making.
Training
Pathway to Leadership, 2020
Communication Series, 2021
Financial Markets, 2022
Python (On going)
Timeline
Sales & Forecasting Analyst III
Horizon BCBSNJ
07.2016 - Current
Informatics Analyst II
Horizon BCBSNJ
11.2012 - 07.2016
Informatics Analyst I
Horizon BCBSNJ
02.2011 - 11.2012
Validation Specialist
Immunomedics, INC.
11.2007 - 02.2011
Engineer
Merck Manufacturing Division
06.2006 - 06.2007
Masters of Science in Biostatistics -
New Jersey Institute of Technology
Bachelor of Science in Biomedical Engineering & Minor in Applied Mathematics -
New Jersey Institute of Technology