• Ensuring the best possible data accuracy by envisioning the strategy for storing and reporting ofCommercial data such as IQVIA, SP, SD, Title for Commercial data and marketing activity, website activityand other data sources for Omnichannel that meets the needs of all commercial stakeholders• Develop and maintain automated data quality monitoring processes that takes advantage of machinelearning and other statistical techniques to quickly identify and correct data issues• Document data architecture and identify and deploy systems improvements with a focus on increasedefficiencies• Communicating data standards across a variety of stakeholders including Third Party Vendors andMarketing agencies and ensure that standards are met

-Created an alert system utilizing regression analysis to warn for odd Financial chargeback activity-Utilizing IQVIA claims/Rx data to provided the Business Development Team with understanding of market treatment patterns and potential patients. In addition, using claims and National Sales level data to estimate projection factors to understand average peak year sales.-Enhanced and Streamlined multiple data flow processes for the Forecasting Team to expedite monthly/ weekly reporting and Budget/LBE processing-Developed an innovative Product level report, using claims data, to assist the sale’s team get insight by account, doctor, and anesthesia type-Created insightful product specific Tableau dashboards to assist Sales and Marketing teams-Utilized Drug Distribution Data (DDD) and HCOS data to help the PSP Sales team identify and profile accounts for 3 product relaunches-Collaborated with our SNOWFLAKE Datamart vendor to enhance and streamline the Tableau Online reporting process as well as enhancing our SAS/R to SNOWFLAKE connection utilizing ODBC drivers-Teamed up with the SAP ERP team to enhance our current downstream ETL Process in SAS to include more robust financial and inventory data including the addition of Generic/PSP data

-Led a variety of sub-national data analytics projects to support Marketing and Sales-Created and optimized custom SAS/R programs designed to address key business questions/ needs-Conducted advanced statistical procedures including advanced regression, cluster analysis, time-series and text mining-Developed concise and compelling Tableau dashboards to answer key business questions-Day-to-day contact across Commercial organization for: inputs into forecasting models, target lists, segmentation schema and all other related items-Provide recommendations and specifications from an analytics perspective with respect to Business Intelligence and Data Management technology strategy in order to ensure robust processes that deliver timely and high quality data across the organization

-Applied critical thinking skills as well as advanced analytics to analyze large datasets to detect patterns and identify trends and nuances-Worked closely with colleagues to understand their objectives, refine requirements, and design views for downstream Tableau dashboard reporting-Write, deploy and maintain SQL code and other database objects

-Worked closely with business partners to design, develop, and analyze reports/ dashboards in Tableau to measure clinical outcomes, network performance, and methodology levers-Collected, organized, and analyzed large datasets to gathered insights and determine actions to improve patient care and lower costs-Investigated key business problems through advanced analytics, quantitative analyses of utilization and healthcare data to discover patterns, identify trends and uncover new predictive indicators

-Manipulated large datasets in SAS to drive statistical analysis, design processes and automate marketing and sales reporting requirements-Developed and implemented segmentation of prescribers by finding homogenous groupings for a specific branded product-Created response curves to provide recommendations on optimal sales force allocation-Developed average ROI and marginal ROI using regression analysis-Combined internal specialty account data with IMS HCOS affiliations mapping to analyze branded performance at the account level

-Implemented a sales, finance, and warranty reporting system-Enhanced the service system to streamline invoice processing-Verified the accuracy of the sales contract submissions and liaise with banks

-Increased business by creating target lists to identify new business opportunities-Implemented a hybrid tracking system for monthly/ yearly sales reporting-Produced in-depth forecasting and business trend analysis

-Prepared monthly, quarterly payable/ receivable/ aging report/ invoices/ cash calls and bordereaux-Applied cash receipts and issued wires, balanced monthly bank statement and provided the Finance Department cash flow reports with daily, weekly and monthly cash flow projections-Schedule F preparations

-Created a livestock Rating model to expedite pricing for the Equine office in Kentucky-Handled the Workers’ Comp Reserve Review which included choosing loss development factors-Compared our data to the industry data to help assist with factor accuracy

-Distributed Help Desk tickets to the appropriate parties in the Application Development Group-Helped in completing the WINS Annual User Re-certification for FIC purposes-Assisted Project Managers with filing project documents for audit purposes-Worked with users to complete the managed desktop user acceptance for in-house applications