Fte Software Developer & Integrator I Resume
Phoenix, AZ
SUMMARY:
- Extensive ETL DataStage experience in data warehouse. Forte has been performance tuning, optimizing efficiency significantly decreasing processing time. Committed to quality thorough work with minimal defects and adaptable to fluid business needs. Adept at generating formal documentation throughout the project life cycles.
TECHNICAL SKILLS:
Hardware: Unix, Linux, AIX, IBM MVS Operating System
Programming Languages/utilities: DataStage (ETL), Netezza, Oracle, Teradata, PL/SQL, UC4 Scheduler, Unix scripting, DB2, JCL, TSO, ISPF, Zeke, Panvalet, Datatrieve, Changeman, Control M, SPUFI
PROFESSIONAL EXPERIENCE:
Confidential
FTE Software Developer & Integrator I
Responsibilities:- DataStage ETL Development and production support for Life & Health product data warehouse
Confidential
Sr DataStage Developer
Responsibilities:- DataStage ETL Development and production support for IBM internal sales data warehouse
- DataStage Administration - installing and setting up Operations Console, project plan for 11.5 upgrade
Confidential, Phoenix, AZ
Sr DataStage Developer
Responsibilities:- DataStage ETL Development for batch health care data warehouse upgrading 7.5 parallel jobs to 8.7; analysis on current system to change from FTP to CFT file transfer protocol within DataStage Optum Framework
Confidential, Charlotte, NC
Sr DataStage Developer
Responsibilities:- DataStage ETL Development for online banking data warehouse transforming unloaded mainframe DB2 data into server Cassandra database tables
Confidential, Harrisburg, PA
Sr ETL Developer
Responsibilities:- DataStage ETL Development for sales and pricing applications - Wrote and tested 100 new Netezza table load jobs - created DDL for new target tables - tested and validated source/target tables matched - data analysis for vendor profitability system as well as Progress source code analysis to define new Netezza target system
Confidential, Charlotte, NC
FTE DataStage Architect
Responsibilities:- DataStage ETL Development for Confidential credit card - modified Oracle table load DataStage jobs to optimize for speed and accuracy - UAT support of loading the pre-prod Oracle tables on a daily basis - assisted other developers with production issues and recommended solutions - converted 8.5 Credit Card jobs to 9.1
Confidential
Data Warehouse Developer
Responsibilities:- Developed new mainframe, Unix scripts and DataStage ETL process product quotes used to send as emails. This has an estimated savings of $400K a year postage and handling
- Performance work to several Datastage process cutting runtime from 6 hours to 30 minutes
- Developed business object, Web Intelligence and crystal reports for supporting manufacturing/marketing business decisions.
- Awarded company award for developing a sales quote ETL system saving company $200K a year
- SAP Business Object universe admin, development and maintenance
- Data warehouse production support
- Sharepoint document and report publishing
Confidential
Data Warehouse Developer
Responsibilities:- Airline Revenue Acctg Project - Redesigned several long running COBOL/DB2 accounting Data warehouse Oracle feeds, reducing run-time and/or resources from 50%-80%, new development work against complex accounting system to bring in expanded feeds for reservation data from EDS conversion project
Confidential
Sr. Consultant
Responsibilities:- ESA SAP data warehouse project - work on converting sales order data to SAP Oracle PL/SQL data warehouse, working with business customers to identify data sources, data mapping, organize meetings, coordinate with SAP/Oracle technical team developers retirement project - developed system to pull Honeywell data from many sources (libraries, scheduler dbs, jcl, files) to document data flow for systems analysis substantially cutting down data gathering time by 80%
- Technical lead on 13 aerospace site disaster recovery plan (DRP) project
Confidential
Sr. Programmer Analyst
Responsibilities:- Developed Walker financial balance sheet and income statement in company specific format/breakdown saving the entire department two weeks manual work quarterly using COBOL against DB2 tables.
- Modifications to COBOL Walker General Ledger system, including DB2 optimizing and program code database call changes speeding up run time (some from 10 hr run time to 2 hrs) aiding in department’s monthly close process
- Worked directly with the corporate financial department to support their on-going needs; acted as liaison between IT department and finance as well as other Amerco companies relating to the hundreds of data feeds throughout the month
- Created system documentation both technical and end-user application on previously undocumented, complicated processes for month-end closing
Confidential
Data Warehouse Developer
Responsibilities:- Coordinated creating an Oracle-based test system for use as rapid development tool to provide faster turnaround on development efforts for mandated legislative reporting
- Reviewed contractor VB programming work to ensure it met State contractual and mandated reporting requirements
- Participated in reporting requirements gathering meetings as set forth in legislative mandated procedures/policies