o Business Analyst/Solutions Architect on IQVIA Analytics Engine project.o Translated business owners’ BRDs into FRDs for developers and maintained Confluence library of these documents.o Collaborated with analytics staff to clarify FRD requirements for developers.

o Data Modeler on Human Data Science Cloud Daas project using ERWin: analyzed data files and data dictionaries when available to map data elements to Global Data Model. Communicated with local office data owners to define data elements within context of data files.o As software engineer, set up ETL for Human Data Science Cloud Daas project utilizing IntelliJ to create hql files and Airflow to automate pipeline.o Led small off-shore engineer team as Lead Engineer; including code review/quality control to make sure standards were being followed, loading new files to HDFS, and facilitating communication between the off-shore staff and the program manager and scrum master.

o Interviewed/hired and managed department staff of 10+ comprised of software developers, production support staff, data analysts, QA, and business analysts. Also included off-shore resources.o Responsible for architecture, ETL, data and software engineering, data visualizations/Business Intelligence, QA, and release management. Full system lifecycle owner.o Subject Matter Expert for all company prescriber and real-world usage data.o Product Owner/Engineer of in-house standard and custom reporting tool built on VB.Net and SQL Server to empower users across the company by providing an easy and automated way to access Enterprise data, data files for their programs, as well as dashboards and other aggregate reports of program data. Pushed thousands of reports to clients weekly reducing turn-around time from weeks per report to days.

Database design; application development; web design; data analytics.o Provided IT consultation, data analytics, and system development to PSKW. Started ETL project to load pharmacy claims.

o Continued Senior Manager responsibilities and grew staff to include a manager and Senior Analyst/Programmer.o Architected the Universal Customer Database – an Oracle data warehouse all Medimedia divisions in one silo with the purpose of physician profiling and capturing physician promotional preferences.o Assisted with budgeting for the group -- @ $2 million worth of data costs, hardware, resources.

o Managed a staff of 2 senior data analysts and 2 data analysts who performed list match services and file preparation for load to Oracle for sampling programs.o VRT (Validation Review Team) member and manager for the department; worked under regulated environment.o Authored, trained staff, and monitored compliance to work instructions and SOPs.

o Within Oracle data warehouse, used patient-level prescription data to designate a custom TPM metric: describes a patient as a new patient, a continue patient, a restart patient, or a switch patient.o KOL databases. Created Access databases that functioned like web pages. Data driven screens with search and drill-down capabilities from physicians to KOLs to Facilities.o Microstrategy reporting on data warehouse.

o Built reports in MS Access and MS SQL Server; analyzing prescription data, formulary status by payor aligned to territory level for all products in the therapeutic class.o Data Entry databases: Created custom Access and SQL (asp front-end) data entry databases to capture survey information as well as rebate program information.

o Analyzed job requirements and did testing on final deliverable to verify that the product met specifications.o Validated that data on deliverable was correct by taking raw data and analyzing it to get to the same answer as the developer within MS Access.

o Relayed job specifications to a staff of 6-10.o Responsible for providing example of assembly of jobs to quality control; set up and printed mail merges using MS Word and MS Excel/text files; ran envelope printer for large print jobs.