SUMMARY:

• Accomplished IT professional with extensive experience in software development and support, including the installation, deployment, and support of large and small applications and maintenance, utilizing structured development methodology, application database performance tuning, data integration, and software upgrades.
• Focused on Data Management with Extract, Transform, Load (ETL) using Confidential DataStage, including Infosphere Information Server (IIS) installation, configuration, administration, upgrading, and applying patches to IIS, DB2, and Websphere.
• Excellent communication and customer relationship skills have significantly enabled mission - critical projects to complete within time and budget.
• Data Warehouse / ETL build with Confidential Infosphere Information Server (IIS) DataStage with DB2, Oracle, Netezza / Pure Data, SQL Server sources, and targets
• Install, configure, administer, upgrade, patch Confidential Infosphere Information Server (IIS) including DataStage, Websphere, and DB2
• Migrate DataStage applications on IIS release upgrades
• Confidential Data Studio, DB2 Stored Procedure Builder, DB2 VisualExplain
• Database build / maintenance with DB2 UDB on Linux, Unix, and Windows
• Confidential Data Studio, DB2 Stored Procedure Builder, DB2 VisualExplain.
• Confidential Z/OS programming and testing techniques utilizing DB2, COBOL, JCL and TSO-based tools (FILEAID/DB2, STARTOOL, ENDEVOR, SPUFI, SDSF).

PROFESSIONAL EXPERIENCE:

Confidential

IT Specialist - ETL Developer

Responsibilities:

• Built jobs to stage and load data to a target using DataStage Server V11.3 and Oracle source to Netezza / Pure Data target.
• Built generic extract jobs for 150 source tables, load to 120 target tables including change data capture for Type 1, Type2 and hybrid tables, audit and controls, scheduling for 650 jobs and sequences.
• Served as DataStage Developer, building jobs to stage and load data to a target using DataStage Server V7.5.2 and DB2 on zOS, as well as DB2 UDB V9.5 on zLinux.
• Resolved issues with EBCDIC - ASCII conversion for packed mainframe data and ODBC connections to mainframe.
• Upgraded PeopleSoft EPM from v8.8 to v9.0 with respect to delivering DataStage ETLs. Built custom ETLs built for DB2 / Informatica to Oracle / DataStage. Delivered approximately 110 ETLs and about 33 custom ETLs.
• Upgraded delivered ETLs for Oracle and UNIX environment and tested them to load EPM datamart. Built custom ETLs based on Informatica mappings to trap lookup failures and log to error table.
• Functioned as Data Integration / DataStage ETL Developer team lead and DB2 DataBase Specialist at large city school system. Project endeavored to build an ODS that houses City school, staff, student data with associated course, class, grade and assessment information. Object of ODS is to provide school, teacher, and student level information on student performance.
• Brought on board as Data Integration Lead to study source data, build ETL jobs with DataStage to stage source data to DB2 UDB platform for analysis, build ETL jobs to move the data to model database. Initially the chosen database platform was DB2 UDB on AIX. Subsequently, the staging database and ODS was migrated to Oracle.
• Led team that built metadata for approximately 85 source data files to DB2 and Oracle staging tables. Built DB2 ODS for a pilot roll-out. Three DB2 test versions of ODS were rolled out before production in Oracle.
• Oversaw DataStage ETL development and responsible for DB2 Administration with Control Center, DataStage install, configuration, and administration on Windows and AIX, Oracle navigation with TOAD. Led team of 3-5 DataStage developers and worked with Data Analysts and customer IT.
• Served as ETL Lead Developer Consultant at a premier cancer research hospital for build and population of Phase 1 of a Patient datamart. P roject initially utilized DataStage Server Edition for Windows (V7.5), migrated to Parallel Edition. D ata sources on DB2 Z / OS V7.1. T arget is DB2 UDB V8.1 on AIX. B uilt initial load ETL jobs for 14 subject areas such as Patient Demographics, Tumor, Hospital Stay, Diagnosis, Lab, Surgery, Protocols, Pathology Reports, etc.
• Provided guidance in design fo r change-data-capture for these subject areas from Z / OS sources. This second iteration build of the ETL jobs includes performance tuning with custom SQL.
• Participated in design for exception and error reporting in ETL jobs as well planning migration to Websphere DataStage Enterprise (Parallel) Edition.
• Provided DB2 support for creation and maintenance of target database on UDB for AIX, build / install stored procedures and Visual Explain for OLAP / query tuning purposes.
• DataStage Developer Lead Consultant at a large Healthcare carrier Self-Service Applications Center of Excellence to build a National Insurance Sales Support datamart.
• Built / maintained / enhanced over 100 ETL modules, utilizing DataStage / MVS to load DB2 tables from delimited files with medium-to-high complexity transforms and database lookups.
• Provided technical leadership to development and deployment team on DB2 issues, DataStage template design, testing, and quality assurance for Z / OS implementation with Endevor code asset management.
• Data Specialist Consultant at Healthcare carrier Quality Engineering Services to support planning efforts to configure and build a Single System Platform (SSP) that would include development, testing, and quality assurance regions.
• Performed as D eveloper with DataStage for an evaluation Proof-of-Concept. Developed multiple DataStage jobs to process DB2 structures, manage code on CA-Endevor and execute against Test / QA databases.
• Built data masking routines, database joins, data stream splits, and data transformation. Worked with DBA group evaluating DB2 access paths generated by DataStage.
• Provided consulting input to data movement tools (ETL), DB2, data scrubbing, test data tools availability / functionality. Participated in application domain modeling and database access definition planning exercises.
• Applications Database Specialist, Solution Architect, and Infrastructure Support Specialist for development environment at a Healthcare carrier. Performed DB2 performance tuning on application with aid of Visual-EXPLAIN, advised SQL coding changes to developers.
• Performed data model review, DDL generation, database sizing using ERWIN / ALLFUSION Data Modeler, created tablespaces and tables, including DB2 UDB Summary tables. Developed SQL scripts to extract consistent data from production servers and load to test servers.
• Performed analysis and consulting support to gather data transformation information for extract, transform and load of a Unified Claim datamart.
• Performed oversight of ETL development activities on AIX V4, DB2 UDB EE V7.2.
• Performed development of SQL scripts and Stored Procedures to update EDW.

Confidential

Responsibilities:

• Implementation Specialist for an ERP Software vendor with detailed exposure to all phases of project life-cycle from Preliminary Analysis to System Installation.
• Primary focus on technical implementation, performance tuning and integration to external software.
• Concentrated on the design, programming and implementation of new CICS/DB2 and VSAM product releases. Tasks included SQL coding and verification with EXPLAIN, INDEX definition and performance tuning with a view to facilitate efficient access to DB2 tables in the standard product.
• Product knowledge in the areas of Purchasing and Materials Management with concentration on Inventory Control and Accounting alonqwith detailed exposure to Material Requisitions, Purchasing and Accounts Payable. Special focus on special projects such as integration to EDI, multi-platform integration using LU6.2/APPC and cross-product interface architecture.
• In-depth involvement in upgrade activities to new DB2 release, Millennium enablement, user and technical workshops.