Consult with management and the product owners to recommend and implement ETL and relational database solutions. Develop and edit technical and user documentation using various tools. Create data models. Provide data scrubbing, data wrangling, record linking/fuzzy matching, data aggregation, and data analysis services. Also, offers an address and string parsing service. Key Accomplishments: Recommended and implemented a new record linking/fuzzy matching solution to a client - using SSIS. Performed Quantitative Analysis in MS SQL Server, Oracle, Postgres, and MySQL databases.  Train developers, product owner, and other stakeholders on the functionality of newly designed solutions.

Developed, enhanced, and supported ETL solutions for medical claims and provider data. Led efforts to implement quarterly data refreshes across multiple applications - in an Agile Scrum development environment. Maintained the data scraping, data scrubbing, data wrangling, data aggregation, and fuzzy matching processes. Created dashboards in Excel for Analytics department. Key Accomplishments: Processed datasets with over 1 million records from 50+ external sources and distinct formats – including Blue Cross Blue Shield, Blue Cross, American Hospital Directory, Milliman, and Dun & Bradstreet. Converted legacy SAS programs to database objects.  Maintained a web-based content management system with 99% accuracy. Uncovered and resolved a production bug that was previously unresolved for five years. Developed and maintained algorithms that performed data scrubbing, data wrangling, data aggregation, and record linking/fuzzy matching on over 100 million records.  Reviewed and documented all the backend processes of a legacy ETL system in preparation for its reengineering. Consulted with Director of Analytics and Vice President of Operations to define business requirements.

Designed, developed, tested, deployed, and provided production support for occupational health management applications. Developed and maintained database objects for SQL Server, Sybase, and MS Access. Maintained SSIS ETL processes and deployment to data warehouse. Met with stakeholders and advised on options, risks, costs vs. benefits, impact, and LOE (Level of Effort). Performed feasibility studies and sought opportunities to apply advanced technology to existing and new processes. Led knowledge sharing efforts by creating technical and user documentation for new and existing processes.Key Accomplishments: Ensure 100% accuracy of occupational health claim data submitted to the state of Florida via EDI process – 837 format. Planned and implemented enhancements to ensure HIPAA compliance for applications and products. Ensured a 99% accuracy of ETL algorithm that assignments of ICD-9, CPT codes, and CMS1500 data. Trained new developers on existing processes to ensure consistent practices and outcomes. Supported web applications to ensure availability to users 24 hours/7 days a week.

Maintained marketing promotions database that segmented/selected subscriber data for email, direct mail, donor/gift, billing, renewal, and A/B test marketing campaigns. Managed promotional material for each marketing campaign. Collaborated with end users and external client to gather business requirements for system enhancements, selections, and master file corrections. Performed UAT testing on system enhancements. Coordinated Masterfile conversion of new clients. Performed data analysis on marketing campaign and provided the results to the clients.Key Accomplishments: Led the Masterfile inconversion of 15+ new clients, including National Geographic Society and Time Inc. magazines, with a combined total of over 10 million subscribers. Segmented and selected the subscriber records in each database with a 98% accuracy  Key stakeholder in the reengineering project of a legacy donor/gift marketing system with over 100 million subscribers.