SUMMARY:

• A visionary consultant with expertise in IBM Datastage Parallel v11.5/9.1 and Cognos v10.2.2, data warehousing and integration, data modeling, text analytics, and project management who has led projects developed at onsite and offshore locations
• Delivered DW & BI solutions using IBM InfoSphere DataStage v11.5/9.1 Parallel following Kimball DW and Inmon DW methodologies on DB2, Oracle 12c/11g/10g, SQL Server 2005, Netezza, Informix, Teradata, and BI tools such as Cognos 10.x/8.x/7
• Industry functional knowledge in Financial/Wealth Management, Student Loans, Housing /Mortgages, Retail, Defense Supplier Management, Energy/Utilities, Health Insurance/Healthcare, Manufacturing, Enterprise Feedback Management, Human Resources
• Background in mainframe environment: IMS DB/DC, COBOL, DB2, CICS, SAS
• Worked in ETL environments using various job schedulers such as Autosys and Control - M

TECHNICAL SKILLS:

ETL Tools: IBM DataStage (v11.5/9.1 Parallel & v8.7 Server)

BI Tools: Cognos 10.2.2

Languages and Scripts: PeopleSoft platform, Oracle PL/SQL, SQL Server T-SQL, DB2 Stored Proc, COBOL, SAS/SAS SCL, Java, JavaScript, Perl, C++, HTML, XML

Databases: Oracle 11g/10g, Netezza, SQL Server 2005, DB2 v10.5, Informix 3.82

Miscellaneous: LINUX 2.6, AIX 5.3, ERwin 9.5, E-R Studio 6.5, Sybase Power Designer 15.3, AutoSys, Control-M, PeopleSoft EPM 8.9 and HCM 8.3

PROFESSIONAL EXPERIENCE:

Confidential, Salem, OR

ETL Developer

Responsibilities:

• Mastered all existing data model concepts and Datastage code within a few weeks to become a highly reliable technical and functional resource
• Loaded source data extracts produced by DOJ to the highly relational target database using IBM Infosphere v11.5 Parallel ETL in a Windows 2012 environment using DB2 source/target and IBM Data Studio 4.1.2 for database querying and DB2 stored procedures for validation
• Corrected defects identified and researched issues following strict data lineage analysis standards to track down root cause of the data reject/error
• Established and implemented Referential Integrity rules in Datastage ETL

Confidential, Raleigh, NC

Senior ETL Developer

Responsibilities:

• Converted existing Hadoop environment queries to DataStage v11.3/.5 Parallel jobs and performed day-to-day maintenance of existing DataStage v11.3/.5 Sales and Finance mart jobs and sequences in a dimensionally modeled environment in a LINUX environment, SQL Server/Oracle sources and Oracle targets

Confidential, San Antonio, TX

Consultant

Responsibilities:

• Analyzed existing Datastage v9.1 Parallel project jobs and sequences that extract ServiceNow data residing on the Cloud, extracted into SQL Server collection tables using Java connector stage, and loaded into Netezza dimensional DW
• Performed fit-gap analysis of ServiceNow data based on source-to-target mappings and existing Datastage code; Created a reverse-engineered data model in Erwin 9.5 for ServiceNow reporting SQL server database and analyzed the same for dimensional modeling purposes

Confidential, Pennington, NJ

Datastage Specialist

Responsibilities:

• Designed and developed IBM Datastage v9.1 Parallel ETL jobs and sequences to generate alert records for Risk Management Supervision (RMS) system running on LINUX 2.6.32 as operating platform, Autosys as scheduler, consuming/generating data in various forms such as DB2 database, Web Services, flat files, complex flat files, and XML files.
• Wrote LINUX scripts whenever necessary for job execution, record count reconciliation and file archival/handling

Confidential, Iselin, NJ

Sr. Datastage Architect

Responsibilities:

• Designed and developed IBM Datastage v11.5 Parallel processes to maintain a highly complex custom-made MDM environment labeled Plan Recordkeeping Institutional Services Management (PRISM) comprising of insurance and retirement plan information running on LINUX 2.6.32 as the operating platform and Autosys as the scheduler interacting with files, database tables, XML files and Java APIs, with an Oracle 11g target database

Confidential, Marlborough, MA

Lead Datastage Designer/Developer/Onshore Coordinator

Responsibilities:

• Led and deployed a project from end-to-end by gathering requirements from customer representatives, creating source to target mappings and detailed specifications, designing and developing IBM Datastage ETL processes executed by AIX scripts to convert and reconcile Purchase Order data between multiple systems using Datastage v8.7 Parallel running on an AIX platform and connected to DB2, Oracle, SQL Server, and Netezza databases
• Coordinated change management and deployment using PTC Change Mgmt and deployment using Project Portfolio Mgmt (PPM)

Confidential, Charleston, WV

Datastage Designer/Developer and Cognos Developer

Responsibilities:

• Designed and developed IBM Datastage Parallel v8.7 processes on an AIX platform, the databases SQL Server 2008 R2, Oracle 10g on Tivoli Workload Scheduler (TWS)
• Implemented high-performing, flexible, and reusable Datastage ETL processes by means of Runtime Column Propagation (RCP) to create metadata-free Datastage jobs using Change Capture (CC) and Checksum features in a parameterized environment using PL/SQL scripts to perform data archival
• Maintained Cognos 10.2.1 Financials DW reports on the PeopleSoft EPM 9.1 platform

Confidential, Southfield, MI

Datastage Developer

Responsibilities:

• Developed and maintained highly complex ETL processes using DataStage Parallel v8.5 running on a Windows platform
• Developed complex PL/SQL scripts to write files dynamically by reading layout from a control table
• Designed and wrote highly complex SQLs to read data from high-volume and intricate Health Care Reform/Affordable Care Act tables

Confidential, Washington, DC

Datastage Developer

Responsibilities:

• Maintained highly complex ETL processes using DataStage Parallel v8.7 running on a LINUX platform to extract Federal Student Loan data from flat files and Oracle tables and populate dimensionally modeled star-schemas on an Oracle 11g data warehouse
• Wrote shell scripts to process, archive, and audit files

Confidential, King of Prussia, PA

Datastage Developer

Responsibilities:

• Designed and built highly complex ETL processes using DataStage Parallel v8.7 running on a UNIX platform using Oracle databases and file sources that stored Confidential ’s critical multi-national financial data consisting of Mutual Funds and Exchange-Traded Funds

Confidential, Philadelphia, PA

Datastage Analyst

Responsibilities:

• Developed ETL using DataStage Parallel v8.7 on an Oracle and Linux platform with sources in various RDBMSs such as SQL Server, Oracle, DB2, and Informix to populate star schemas for clinical data marts designed using Sybase PowerDesigner 15.3
• Supported the DW/ETL production environment and documented ETL best practices

Confidential, Ridley Park, PA

Datastage Consultant

Responsibilities:

• Mentored senior Confidential employees and peers in understanding the DW architecture and ETL
• Developed ETL for Confidential ’s Supplier DW on DataStage Server v8.7 following Kimball Methodology in an Oracle Change Data Capture(CDC) staging environment integrating data from a dozen Confidential locations across the country with different data formats and data sources
• Improved performance of ETL processes by 25 - 35%
• Built and maintained tables, views, materialized views, PL/SQL procedures, and monitored/tuned database performance on Oracle 11g /10g; Developed shell scripts for Autosys scheduler jobs on AIX 5.3

Confidential, Reston, VA

Responsibilities:

• Developed Cognos v8.4 reports for top clients such as BestBuy, Sage Software, AOL, McDonalds, GAP and United Airlines
• Developed Confidential Mining Platform (CMP) processes
• Developed online web surveys on Vovici EFM framework using complex Javascripts
• Designed and built PL/SQL scripts/anonymous blocks, Perl scripts, tables, views, materialized views and stored procedures on Oracle 10g platform

Confidential, Reston, V A

Responsibilities:

• Designed and built data warehouses on a variety of Financial, Mortgage, and Manufacturing data sources using DataStage Server v7.5.2 and T-SQL on dimensional and relational data models built with Erwin 7.1
• Pioneered real-time ETL, CRC, usage of environment variables, and FTP improving the ETL processing time by 30 - 50%
• Provided Production Support on a 24/7 basis as the primary on-call support person and assisted in upgrades such as DataStage v7.5.2, SQL Server 2005, and Hyperion 8.3

Confidential, Peoria, IL

Lead Onsite Coordinator/Developer/Data Modeler

Responsibilities:

• Designed and implemented Cognos ReportNet platform from ground-up by building the data model in Framework Manager, queries and reports in Report/Query Studio
• Developed DataStage Server v7.5 ETL connecting to Oracle 10g/9i and DB2 on a UNIX platform and provided production support on a 24/7 basis

Confidential, Eagan, MN

Lead Onsite Coordinator/Developer

Responsibilities:

• Worked on various mainframe projects using COBOL DB2,IMS DB/DC, CICS, SAS