ETL Developer/Data Modeler Resume Pembroke, MA - Hire IT People

SUMMARY:

An experienced ETL developer and data modeler with over a decade of work experience in all aspects of data warehousing, database development, ETL development, and the software development lifecycle (both Agile and Waterfall).

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential, Pembroke, MA

ETL Developer/Data Modeler

Responsibilities:

Worked with DataStage 8.7. Modified existing ETL jobs to process new data types; including adjusting columns, derivations, and business logic as needed.
Modified existing and created new job sequences to include e - mail driven error reporting. Performed full sequence and job-level unit testing and coordinated with test staff on larger system tests.
Took over primary development and support for multiple large and highly critical ongoing batch jobs (jobs that run daily, generally multiple times per day).
These applications were mission-critical for the client and represented vital tax information for both individuals and businesses where errors or issues would need to be dealt with quickly and efficiently.
Well regarded by both client and other consulting staff on both a personal and professional level. Frequently a first point-of-contact by other staff seeking help with difficult issues (both in troubleshooting and in new development).
This reputation was earned in part by being honest about where problems or challenges exist, regardless of where they were or how they came to be, and in part by being approachable and available regardless of the time of day or day of week.

Confidential, St. Louis, MO

Senior Technical Consultant

Responsibilities:

Worked with DataStage (8.5 and 8.7). Modified existing real-time ETL jobs processing patient data to work in batch mode, created and maintained sequencers to run jobs.
Created and presented DataStage training materials for client users.
Created and maintained Autosys job schedules (JIL scheduling scripts) that included conditional job execution branching execution of jobs.
Wrote UNIX shell (bash shell) scripts that would be invoked by Autosys to run the DataStage jobs and sequencers created and map DataStage exit codes to Autosys-understood exit codes.

Confidential, Charlotte, NC

Senior Database Engineer

ETL specialist on a team developing an internal employee fraud data warehouse.
Mapping source systems and source data to eventual desired reports.
Work alongside data modelers in constructing the layout of tables in a snowflake schema.

Confidential, Greenville, SC

Senior Database Engineer responsible for supporting a large and diverse team of business users and java developers.
Work included managing complex data migrations, performance monitoring and tuning, altering table structures (including indexes and triggers), and PL/SQL development ranging from anonymous blocks through permanent packages and procedures.

Confidential, Troy, AL

Senior Consultant

Responsibilities:

Team Lead in charge of 4 ETL developers working on a project for a client that is a major retailer in the hardware, home, and garden sector.
Promoted to team lead of production support and QA testing teams in 2011. ETL Development and Testing using Business Objects Data Integrator. Oracle 10g DB environment.
Development of ETL utilities and tools in PL/SQL to handle routine reporting, data quality checks, and business-approved data corrections.
Provided tier 2 production support on high importance, business-critical jobs responsible for processing and transforming several million rows of data per evening.
Promoted to team leader three months after starting.
Optimized the performance of a file delivery job reducing its execution time from 4-6+ hours down to less than one hour with no loss of quality. Optimized the performance of ETL code transferring raw sales data to the financial and accounting data warehouse. This improved processing efficiency so the job ran in 60% of its prior 4-hour benchmark. Coordinated and managed response to a serious client system outage over a weekend in an effort to get critical business systems restored and functioning properly, receiving client accolades in the process of doing so.

Confidential, Augusta, GA

Application Engineer

Responsibilities:

Developed and maintained ETL processes using a combination of Cognos Data Manager and SQL Server (DTS Packages and Procedures).
Provided support to the user community in developing and improving the efficiency of ad-hoc SQL queries.
Administrator for Tivoli Workload Scheduler

Confidential, Mauldin, SC

Database Developer

Responsibilities:

Developed and Tested complex ETL applications using Oracle and PL/SQL. Led the migration to using PL/SQL over anonymous SQL blocks over a two-year period of time starting late in 2001 and finishing in early 2003. Co-led an initiative to implement a series of "best practices" in PL/SQL development.
This included the abundant use of metadata tables in dynamic SQL statements to fully parameterize ETL loading code.
This greatly reduced the amount of time required for new development from 3-4+ weeks down to less than 1 or 2 weeks at most.
Collected, combined, and enhanced a series of disparate stored procedures and packages into a single "Load Package" written in PL/SQL.
Frequently mentored teammates and acted as an expert in the area of Unix Shell Scripting.
Winner of the "Shining Star" award for contributions to the development of and migration to a new "Enterprise Data Warehouse" that replaced three older legacy data warehouses.
Responsible for creating and maintaining database objects such as tables and views in EDW environment.
Interact with business customer to identify business requirements.
Preparation of business requirement document, technical specification, functional specifications, and data transfer specifications, source to target mapping and logic identification.
Production support included monitoring the data warehouse ETL jobs, analyze and resolve data issues.