● Designed and developed dozens of Talend jobs sourcing from HDFS to load to an S3 data lake     and Redshift. This required routine navigation of HDFS to manage files for source inputs and     transformation to reusable lookups for intake during Talend development● Integrated Tableau with Hive database via EMR for front end development. Solution entailed     profiling and analyzing transactional data, writing HiveQL on Beeswax, to develop business     requirements and create architecture documents● Deconstructed DataStage sequences, Korn shell scripts, and Teradata architecture to create data     flow diagrams and job dependencies to be replicated in Talend

● Managed multiple projects simultaneously while responsible for updating project plans, tracking     budget, and staffing resources● Designed ETL architecture for new implementation including database layers,     Audit/Balance/Control (ABC) processes, and dynamic parameter generation● Conducted requirement gathering with SMEs and created business mapping documentation to     ensure data transformations meet the needs of the client ● Lead team of developers to create over 100 Informatica mappings and assisted when necessary     on the most complex systems● Constructed multiple new Statements of Work and presented them to the client, resulting in new     activities sold

Spectrum HealthUnited Benefit Data Integration / Anesthesia Reporting Projects● Assisted in design and alterations of an existing data model to pull transactional data into a     relational model● Independently designed and created an Informatica code base to load a completely new data     mart for integration with Business Objects● Joined a behind schedule project mid development, performed data and code analysis, and     made necessary alterations to complete the task on time● Quickly learned a new tool, Oracle Data Integrator, to edit and create interfaces as the sole     technical resource

Wellmark Blue Cross Blue ShieldPharmacy Analytics / Sales Dashboard Projects● Created logical design documents, detailed design documents, and process step flow diagrams     for offshore ETL resources ● Assisted in the development of Informatica mappings to extract data from various sources,     transform it through multiple database layers, and load into production● Utilized pushdown optimization and Teradata Parallel Transporter functionalities to ensure     quick processing time to reduce strain on the Integration Server● Created multi-step Korn shell scripts to operate functions within the process and execute     Informatica workflows with necessary dependencies● Ensured all code was successfully implemented into production region while having zero defects     in user acceptance testing

Aviva USAData Provisioning Project July 2012 - November 2013● Utilized Informatica to create complex ETL mappings for monthly release to production.● Pulled data from various sources, including flat files, XML files, Oracle, and DB2 to load the     target.● Constructed DDL and DML SQL scripts to alter and manage databases as necessary.● Navigated variety of databases utilizing complex SQL and programming, including DB Visualizer     and Oracle SQL Developer.● Managed and resolved defects during testing phases through use of HP Quality Center.● Monitored nightly cycles in ESP client and troubleshot any issues related to data provisioning     project, including failed workflows.● Created and updated design documents in Visio to track mapping changes.