Senior ETL Developer Resume Example
Love this resume?Build Your Own Now
SENIOR ETL DEVELOPER
Summary
I am looking for a company where I can apply my skills for the benefit of my company, coworkers and myself.
Highlights
| Databases: Oracle 12g, Oracle 11g, SQL Server 2008 R2, SQL Server 2005Operating Systems: Red Hat Linux, Unix, Windows Enterprise, Windows Server 2008Languages: SQL, Bash, Korn, Bourne, C Shell, VBA, Java, HTML, PerlSoftware: Informatica, PL/SQL Developer, SQL Developer, MS SQL Server Enterprise Manager, GoldenGate, ER/Studio, SharePoint, Automate 10, DataStage, Business Objects, Crystal Reports XI, Enterprise Manager, MS Office Suite (Word, Outlook, PowerPoint) |
Experience
Senior ETL Developer
March 2010 to January 2016Epam Systems Inc － Pittsburgh , PA
March 2010 to January 2016Epam Systems Inc － Pittsburgh , PA
- Analyze and correct any long running or failing Informatica ETL jobs to ensure optimal performance in three environments (data integration, consolidated data store and data warehouse) For long running jobs I was able to reduce run time by over 50% and for workflows that were failing chronically, I was able to eliminate the failures Extensive use of advance SQL to validate mapping datasets when coding, to troubleshoot production issues and to use in POC for all projects Architected complex solutions for several different business units to gather and report on survey data Identified and documented needed process to install Goldengate software on Windows servers cutting down on installation time from five weeks, or more, down to two weeks Provided training and mentorship to four non-Informatica ETL developer groups, saving money on vendor training of 21 individuals Responsible for maintaining coding standards for all other developer's code going to production Fully involved in all aspects of software development release cycle, using AGILE development On average, coded over 24 releases per year effectively providing at least one release every two weeks, meeting project deadlines 90% of the time For data access auditing purposes identified the need to create a new data model.
- using ER/Studio, to track approvals Lead developer to provide instruction on upgrade of Informatica 9.1 to 10 SME for all aspects of Informatica administration, reducing the need to contact Production Support team.
ETL Developer
January 2008 to February 2010Abt Associates － Cambridge , MA
January 2008 to February 2010Abt Associates － Cambridge , MA
- Analyzed and corrected any long running Informatica ETL jobs to ensure optimal performance in three environments (data integration, consolidated data store and data warehouse) Lead developer for all new jobs for the consolidated data store environment Provided development of five critical, highly visible, and complex data integration projects One of two lead developers who designed a solution to automate Informatica deployments.
- Effectively reducing the time needed to deploy code by over 30 minutes Wrote all technical documentation on release process, provided this documentation to release team, allowing for release team to immediately own the release processes Developed Linux Bash script to clear orphaned cache files, CPU utilization issues, and process locks Trained Production Support the installation of Informatica PowerCenter 9.1 to include domain, repository service, integration service and node setup As part of company switch from using Datastage to Informatica, helped to converted over 800 DataStage jobs to Informatica jobs Wrote Automate jobs, for SFTP of files to and from Apollo servers.
March 2005 to January 2016Bickford Senior Living － Springfield , IL
Report Developer
March 2005 to December 2007C.H. Robinson Worldwide, Inc. － Auburn Hills , MI
March 2005 to December 2007C.H. Robinson Worldwide, Inc. － Auburn Hills , MI
- Analyze requirements from each business unit and created over 40 reports using Crystal XI to pull data from SQL servers Optimized existing report run times by updating SQL statements allowing reports to run at least 30 minutes faster Consistently created ad-hoc reports to meet department and user objectives Effectively communicated with business departments reducing the time to produce Actively used Query Analyzer to verify data integrity on reports.
Developer
October 2001 to October 2003Cleaver Brooks － Milwaukee , WI
October 2001 to October 2003Cleaver Brooks － Milwaukee , WI
October 2001 to October 2003Bickford Senior Living － Wabash , IN
- Designed, developed and implemented a VBA software program that reported cell phone call usage.
- Worked closely with the client to customized software updates before project hand-off to technical support.
- Created technical documentation for implemented software solution along with training to technical support personnel.
Programmer/Analyst
July 2000 to July 2001Boise , ID
July 2000 to July 2001Boise , ID
- Created a predictive perishable item ordering program, written in Perl, for distribution warehouse ordering.
- Estimated savings cost to each warehouse distribution center was over $500,000.00 per year.
- Created a Korn Shell program to verify item pricing for auditing purposes this reduced the time spent by managers manually comparing shelving prices to system prices.
- Analyzed and maintained company's proprietary server side programs.
July 1996 to July 2001Bickford Senior Living － Clinton , IA
Support Analyst II
July 1996 to July 2000Boston , MA
July 1996 to July 2000Boston , MA
- Created a Korn shell based web monitoring system to track three areas of concern on stores Unix servers (locks, high CPU usage, and orphaned PIDs), allowing support personnel to be proactive, instead of reactive.
- This reduced inbound calls to the Support Desk.
- SME for SCO Unix administration.
- Specialized in Informix database administration, to include monitoring database logs for errors and correcting issues by clearing lock issues, creating indices and updating extents.
Signals Intelligence Analyst
September 1988 to August 1991Bickford Senior Living － Fort Dodge , IA
September 1988 to August 1991Bickford Senior Living － Fort Dodge , IA
September 1988 to August 1991
Education
Bachelor of Science : Information Technology, June 2008University of PhoenixInformation Technology
Associate of Applied Science : Microsoft Database Administration, September 2004Chandler-Gilbert Community CollegeMicrosoft Database Administration Informatica PowerCenter 9.x, Level 2 Developer, March 2015 Informatica PowerCenter 8.x, Level 1 Developer, Crystal Reports XI - Report Design II, April 2006 Crystal Reports XI - Report Design I, April 2006 Informix - Managing and Optimizing Informix Dynamic Servers, November 1998 Informix - Advanced Structured Query Language, October 1998 Informix - Structure Query Language, October 1998 Informix - Relational Database Design, September 1998 Introduction to SCO Unix
SCO OpenServer Administration I, June 1997 : May 1997
Skills
ad, AGILE, Apollo, auditing, Automate, Bash, Business Objects, C, CPU, Crystal, Crystal Reports, client, data integration, data warehouse, database administration, Databases, database, DataStage, documentation, ETL, HTML, Informatica 9.1, Informatica, Informix, instruction, Java, Korn Shell, Linux, Managing, access, money, MS Office Suite, Outlook, PowerPoint, SharePoint, Windows, Word, Enterprise, Operating Systems, Oracle, developer, PL/SQL, Perl, personnel, pricing, processes, coding, Red Hat Linux, Relational Database Design, SCO, SCO Unix, Servers, Shell, script, software development, MS SQL Server, SQL, Structured Query Language, SQL Server, switch, technical support, technical documentation, phone, troubleshoot, Unix, Unix servers, upgrade, VBA, Windows Server, written
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Length
- Measurable results
- Strong summary
- Typos
Resume Overview
School Attended
- University of Phoenix
- Chandler-Gilbert Community College
Job Titles Held:
- Senior ETL Developer
- ETL Developer
- Report Developer
- Developer
- Programmer/Analyst
- Support Analyst II
- Signals Intelligence Analyst
Degrees
- Bachelor of Science : Information Technology , June 2008
Associate of Applied Science : Microsoft Database Administration , September 2004
SCO OpenServer Administration I, June 1997 : May 1997
Similar Resumes
