Nuevo Laredo, Tamaulipas, MX
+52 1-867-***-**** • firstname.lastname@example.org • 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.
• ETL Development & Consulting
• SQL / Database Development
• Project Management/Leadership
• Data Analysis / Integration
• UAT / QA / Unit Testing
• Client/Stakeholder Relationships
• Knowledge Sharing
• SDLC / Agile Development
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.
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
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
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
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