Continued...

Donnie Purvis

Nuevo Laredo, Tamaulipas, MX

+52 1-867-***-**** • adb8i0@r.postjobfree.com • LinkedIn ETL Consultant

Adaptable IT professional with more than 10 years across ETL, system development, and analyst roles Technically sophisticated professional who has more than 8 years of experience in designing and developing ETL solutions, from the acquisition and staging of data to transforming data for users and systems - while working remotely. Extensive technical capabilities and talents. Background spans healthcare management and magazine fulfillment services settings. Seeking remote opportunities.

Core Competencies:

• ETL Development & Consulting

• SQL / Database Development

• Project Management/Leadership

• Data Analysis / Integration

• UAT / QA / Unit Testing

• Client/Stakeholder Relationships

• Knowledge Sharing

• SDLC / Agile Development

Professional Experience

Self Employed

Consultant, 2/2018-Present

Develop, enhance, implement, and support ETL solutions. Perform UAT, QA, and Unit Testing for ETL solutions. Create data models for new and existing processes.

Consortium Health Plans

ETL Consultant/Operations Analyst, 10/2012 – 1/2018 Developed, enhanced, and supported ETL solutions for medical claims and provider data. Led efforts to implement quarterly data refreshes across multiple applications. Managed data integration, data cleansing, standardization, aggregation, and migration to subsystems. Spearheaded the development and maintenance of business logic for data processing jobs in Test and Production environments.

Key Accomplishments:

Developed and maintained ETL solutions for large datasets from 50+ external sources – including Blue Cross Blue Shield, Blue Cross, American Hospital Directory, Milliman, and Dun & Bradstreet.

Led the conversation of legacy SAS programs to Oracle database objects.

Maintained a web-based content management system with 99% accuracy.

Ensured the security of competitor’s data at 100% accuracy.

Uncovered and resolved a production bug that was previously unresolved for five years. Genex/Network Synergy Group

IT Consultant/System Developer, 3/2008 – 8/2012

Designed, developed, tested, deployed, and provided production support for occupational health management applications. Developed and maintained database objects for SQL Server, Sybase, MS Access. Maintained ETL processes and data warehouse. Met with stakeholders and advised on options, risks, costs vs. benefits, impact, and LOE (Level of Effort). Donnie Purvis

Page Two

Performed feasibility studies and sought opportunities to apply advanced tech to existing and new processes. Led knowledge sharing efforts by creating technical and user documentation for new and existing processes. Key Accomplishments:

Managed 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 that electronic assignments of ICD-9 and CPT codes have a 100% accuracy.

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. Time, Inc.

Analyst, 1/1999 – 3/2008

Set up database to capture results from email, direct mail, donor/gift, and promotions sent to 2M+ subscribers. Collaborated with end users and external client to gather business requirements for system enhancements, selections, master file corrections, and system enhancements to mainframe and client /server applications. Key Accomplishments:

Led the Masterfile inconversion of 15+ new clients, e.g. National Geographic and Time Inc. magazines, valued at

$10M+

Key stakeholder in the reengineering of legacy marketing system. Technical Proficiencies

Databases: Azure SQL Server, Azure Cosmos DB, MongoDB, Apache Hive, Cassandra, Sybase, MS SQL Server, ORACLE, PostgreSQL, MS Access

Programming

Languages:

PowerBuilder, VB.Net, ASP.NET, ASP Classic, HTML, XML, VBA, Java, JavaScript, Datawindow.net, SAS, Perl, T-SQL, PL/SQL, SQL, COBOL, DAX, Python, DocumentDB SQL, CQL, HiveQL, Pig Latin

Other: Talend, SAS Dataflux 8.0, SSMS, SSIS, DTS, SSRS, MS Visual Source Safe, GIT, SQL Server Agent, Execute Package Utility, SQL Server Profiler, MS Visual Studio, SQL++, MS Office 360, MS Map Point, Notepad++, Putty, JIRA, UltraVnc, Citrix, VPN, Apache Spark, Power Query, PowerPivot, MS Azure Storage Explorer, MapReduce, Apache Pig, Oozie, Sqoop Education

Associate of Science in Computer Science (2008)

Hillsborough Community College, Tampa, FL

Contact this candidate