SUMMARY:

• A visionary consultant with expertise in business intelligence, data warehousing, data integration, data modeling, text analytics, and project management who has led projects developed at onsite and offshore locations with 15+ team members who have appreciated and recognized him as a worthy peer, leader, and mentor
• Domain knowledge - Financial/Student Loans/Mortgages, Retail, Defense Supplier Management, Energy/Utilities, Health Insurance/Healthcare, Manufacturing, Enterprise Feedback Management, Housing, Human Resources
• Delivered DW & BI solutions using IBM InfoSphere DataStage v11.5 Parallel & v8.7 Server following Kimball DW and Inmon DW methodologies on Oracle 11g/10g, SQL Server 2005, Netezza, Informix, Teradata, and DB2 and BI tools such as Cognos 10.x/8.x/7
• Improves continuously by self-training and learning from mentors, supervisors, and peers

SKILL:

ETL Tools: Expertise in IBM DataStage (v 11.5/9.1/8.7 Parallel & v8.7 Server)

BI Tools: Cognos 10.2.2/10.2.1 , Crystal Reports 8.0, PeopleSoft Query

PeopleSoft: SQR/PeopleCode/Application Engine, 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, Confidential 5.3, Putty 0.62, Reflection v6.0 for Unix, WinSCP 5.1.6, Filezilla 3.9.0.5, ERwin 7.2, E-R Studio 6.5, Sybase PowerDesigner 15.3, AutoSys, Control-M, PeopleSoft EPM 8.9 and HCM 8.3

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Application Programmer Specialist

Responsibilities:

• Designed and developed ETL processes to generate alert records for Risk Management Supervision (RMS) system running on Datastage v9.1 Parallel with LINUX 2.6.32 as operating platform, Autosys as scheduler, consuming/generating data in various forms such as DB2 database ( Confidential -Management Information Decision Analysis and Support), Web Services, flat files, complex flat files, and XML files.

Confidential, Iselin, NJ

Sr. ETL Architect

Responsibilities:

• Maintained a highly complex custom-made MDM environment labeled Plan Recordkeeping Institutional Services Management ( Confidential ) comprising of insurance and retirement plan information running on Datastage v11.5 Parallel interacting with files, database tables, XML files and Java APIs, with LINUX 2.6.32 as the operating platform and Autosys as the scheduler, with an Oracle 11g target database
• Analyzed existing ETL code, designed and implemented new solutions reducing ETL code to manageable size and improving performance
• Gathered requirements from business analysts, preparing technical design documents and delegating work to onsite and offshore team members while adhering to Confidential Agile methodology of maintaining epics, stories, and tasks
• Provided production support, trouble-shooting, and ETL performance improvement tips
• Performed code reviews on work done by other team members and provided feedback for more efficient and effective ETL development; Applied rigorous quality assurance testing standards on all unit, system, and acceptance testing ensuring correctness and accuracy of data loaded and achieving absolute customer delight

Confidential, Arlington, VA

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, coordinating with onshore-offshore teams to build Datastage ETL processes executed by Confidential scripts to convert and reconcile Purchase Order data between multiple systems using Datastage v8.7 Parallel running on an Confidential platform and connected to DB2, Oracle, SQL Server, and Netezza databases
• Coordinated change management and deployment using Confidential Change Mgmt and deployment using Project Portfolio Mgmt (PPM)

Confidential, Charleston, WV

ETL Designer/Developer and Cognos Developer

Responsibilities:

• Coordinated with offshore and onsite teams in a “right from scratch” project from concept to implementation stage
• Designed data integration processes in an environment involving Datastage Parallel v8.7, Unix, SQL Server 2008 R2, Oracle 10g and industry-standard sources such as GIS, OSI/PI, MAXIMO, and Navigates
• 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

ETL 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

ETL Datastage Developer

Responsibilities:

• Maintained highly complex ETL processes using DataStage Parallel v8.7 running on a LINUX platform to extract Confidential 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 with Control-M as the scheduler and 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

ETL 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
• Shared Datastage tips/tricks from previous experience with Datastage lead, earning recognition from the lead and the manager
• Supported the DW/ETL production environment and documented ETL best practices

Confidential, Ridley Park, PA

DW/ETL 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
• Provided Production Support on a 24/7 basis and improved performance of ETL processes by 25 - 35%
• Worked on Oracle 11g/10g, DB2 UDB, SQL SERVER 2005, and Teradata running on Confidential 5.3 platform ; 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 Confidential 5.3

Confidential, Reston, VA

BI Consultant

Responsibilities:

• Developed intelligent customer experience reports for top clients such as BestBuy, Sage Software, AOL, McDonalds, GAP and United Airlines using Cognos 8.4
• Developed Confidential Mining Platform (CMP) processes to convert data from text to structured data using data sources such as RDBMSs, spreadsheets, and flat files
• 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, VA

Data Warehouse Administrator

Responsibilities:

• Designed and built data warehouses on a variety of Financial, Mortgage, Settlement Services, and Manufacturing data sources using DataStage Server v7.5.2 and SQL Server stored procedures (T-SQL) on dimensional and relational data models built with Erwin 7.1
• Pioneered real-time ETL, CRC, usage of environment variables, and automation of downloading files from FTP websites 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