SUMMARY:

• Over 14 years of experience in IT and extensive 8 years experience in ETL tool using IBM Websphere Datastage (Ver 8.5/8.1/8.0.1/7.5/7.1/6.0 ) InfoSphere Information Server Edition.
• Experience in integration of various data sources like Sybase, MS Access, Oracle, DB2, SQL Server and Teradata.
• Extensively worked with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources
• Worked extensively in Analysis, Design, Development, Implementation, Testing of various applications using Datastage, Oracle, DB2, SQL Server, Windows NT\2000 and UNIX environments.
• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on Reporting Application Life Cycle Development.
• Familiar in using highly scalable parallel processing infrastructure, using Datastage parallel Extender.
• Worked with the Data Architect for creating Star Schema and Extended Star Schema for Data Warehouses using Erwin.
• Excellent knowledge of studying the data dependencies using Metadata of DataStage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs.
• Strong experience in high - end programming experience using SQL, PL/SQL, ANSI SQL, SQL*Plus, SQL*Loader, Unix Shell Programming/Scripting.
• Proficient in tools such as Visual Studio .NET, Visual Studio 6.0, SourceSafe, Visio and MS FrontPage.
• Creation of scripts for collection of statistics, recreating of indexes and creation of indexes for enhancing performance for data access.
• Efficient in several capacities, including software version control, Installation, Administration, Open Deploy Configuration, Analyst Programmer, and finding solutions to business problems.
• Possess outstanding communication skills, resulting in excellent rapport with employees, peers and executive management.

SKILLS:

ETL Tools: IBM Infosphere Datastage 11.3/8.7/8.5/8.1/8.0.1/7.5/7.0/6.0 (Designer, Director, ManagerAdministrator), Parallel Extender, Integrity, MetaStage, MetaBrokers, Informatica PowerCenter 8.0/5.1.1 (Designer, Server Manager, Repository Manager)

Reporting Tools: Cognos 7.0/6.6/5.0 (Impromptu, Transformer, Power Play Reports, Scheduler, IWR, PPWR, Upfront, Architect, Access Manager)

RDBMS: Oracle 10g/9i/8i/8.0/7.0, Sybase Server 11.5.1/11.0.3 , MS SQL Server 6.5/7.0/2000 , DB2 UDB, MS Access 2000/97. Netezza Database

Tools: Erwin 4.1/3.5, Autosys, SQL*Loader and SQL Navigator

Scripting/Lang..: C, C++, HTML, VBScript, JavaScript, SQL, PL/SQL and XML

GUI: Visual Basic 6.0/5.0/, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0)

Web Technologies: ASP.Net, C#, VB.Net, XML/XSL, ASP, JavaScript, VBScript, ADO.Net, ADO, DHTML, HTML, CSS, Visual Basic, Microsoft Visual Interdev 6.0, Microsoft Front Page 2000, Active X, VBA, PHP, Win Form, BizTalk Server 2000.

Operating Systems: UNIX (AIX 4.2/4.3,5.2,Linux, Sun Solaris2.6/2.8,5.0 HP-UX), MS DOS 6.22, Windows 3.x/95/98/2000/XP, Win NT 4.0.

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

Business Analysis/DataStage Developer

Responsibilities:

• Actively participated in the team discussions regarding the modeling, architectural and ETL design of ASPEN and used Microsoft Word 2010 for design documents.
• Involved in understanding of business processes and coordinated with Compliance Business Team to get specific user requirements.
• Co-ordinated with different teams and external Vendors for data source requirements
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Worked with Datastage Administrator for creating projects, defining the hierarchy of users and their access
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Designed and developed datastage jobs using DataStage 8.7 and loaded the data into the Netezza database.
• Perform handshake between Confidential and vendor server to have Secure FTP connection by sharing SSH keys and implemented the FTP/SFTP process using Unix scripts to upload files on vendor FTP site
• Worked with DataStage Administrator for setting up project
• Develop written Technical Specifications describing details necessary to build ETL jobs based on logical and physicaldatamodels and business functional objectives
• Develop and unit test ETL jobs according to requirements in the Technical Specifications
• Resolved data related issues and remediated code based on enhanced requirements
• Prepared the QMP documentation (Unit Test and Pre-Code/Post-Code Checklist) for the code migration to production.
• Perform reconciliation of records between vendor and client, and presented to compliance team for any discrepancies
• Ran complex queries to create custom reports to help business to understand and analyze expenses
• Coordinated and performed KT sessions with external vendor

Confidential

Lead DataStage Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with Business Team to get specific user requirements.
• Studied the existing data reports with a view to know whether they support the required reporting
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Perform handshake between Confidential and vendor server (SHA) to have Secure FTP connection by sharing SSH keys and implemented the FTP/SFTP process using Unix scripts to download files
• Designed and developed datastage jobs using DataStage 8.5 and loaded the data into the Netezza database and created report extracts
• Reports were emailed to business as well as posted to internal server for external vendor usage (Data Design Consulting) via DataStage
• Develop written Technical Specifications describing details necessary to build ETL jobs based on logical and physicaldatamodels and business functional objectives
• Develop and unit test ETL jobs according to requirements in the Technical Specifications
• Resolved data related issues and remediated code based on enhanced requirements
• Prepared the QMP documentation (Unit Test and Pre-Code/Post-Code Checklist) for the code migration to production.
• Coordinated and performed KT sessions with external vendor

Confidential

Senior DataStage Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with Project Manager to get specific user requirements.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Assisted the Lead developer for fixing any DataStage and SQL code issues
• Perform handshake between Confidential and vendor server (SHA) to have Secure FTP connection and implemented the SSHPass/FTP process using Unix scripts to download files
• Implemented a UNIX process to upload files under respective folders to the FTP server based on daily, weekly, monthly and quarterly schedule and send email notification to both internal and external business stakeholders.
• Designed and developed datastage jobs using DataStage 11.3 and loaded the data into the Netezza database
• Created ETL purge process for history tables
• Used Unstructured stage to read spreadsheets from Data Team and loaded to Netezza table(s)
• Develop and unit test ETL jobs according to requirements in the Technical Specifications
• Resolved data related issues and remediated code based on enhanced requirements
• Prepared the QMP documentation (Unit Test and Working Practice Instruction) for the code migration to production.
• Mentor the new on-boarding team member(s)

Environment: DataStage 11.3, LINUX 2.6, IBM Netezza 6.0.3, Aginity Workbench for Netezza, Microsoft Visio, WinSCP, Control-M, MS Office 2010

Confidential, Northbrook, IL

DataStage Lead Developer

Responsibilities:

• Production support multiple projects and co-ordinate with offshore team to make sure the deliverables are met
• Debug and resolve emergency issues in production environment
• Lead offshore team by conducting design and code walkthrough’s.
• Handled the communication between onshore and offshore development team
• Analyze existing data to identify, propose solutions and gap analysis for potential problems
• Used DataStage (PX) version 8.1/8.5 Designer and Director to import/export DS components/ metadata, move/rename/monitor DS jobs and for other repository maintenance work
• Worked as DataStage Administrator to create new projects and provide access to users
• Support week end activities not limited to DataStage patch upgrade, stop and restart DataStage Engine
• Used DataStage Director to run and monitor the jobs for performance statistics.
• Worked with database objects including tables, views, indexes, schemas stored procedures, functions, and triggers
• Implemented the LFTP process using Unix scripts
• Created and maintained the UNIX Shell scripts to automate DataStage batch jobs
• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and worked on Job Sequences to control the execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command. Load data into data warehouse database
• Monitoring of the main sequence was done through Active Batch Scheduling tool by calling Unix scripts
• Resolved data related issues and remediated code based on enhanced requirements
• Prepared the QMP documentation (Unit Test and Pre-Code/Post-Code Checklist) for the code migration to production.
• Coordinated and performed KT sessions with external vendor

Environment: DataStage 8.1/8.5, LINUX 2.6, Oracle 10.2, IBM Netezza 6.0.3, Aginity Workbench for Netezza, Active Batch V8 Admin, Oracle SQL Developer, TOAD, Microsoft Visio

Confidential, Chicago, IL

DataStage Solution Designer/Developer

Responsibilities:

• Actively participated in the team discussions regarding the modeling, architectural and performance issues of PNET4 and used Microsoft Visio for design documents.
• Designed and developed datastage jobs for a given client as a part of POC using DataStage 8.1 in order to set up a common framework for all the remaining DataStage Jobs (Custom Objects)
• Wrote detail level design documents for engineering team to build datastage jobs
• Involved with DBA’s to create reference tables using for lookups
• Developed complex SQL queries in Oracle 11g.
• Performed code reviews depending on the client standards
• Co-ordinate directly with BSA and managers on issues and requirements
• Assisted developers in developing datastage jobs and writing shell scripts
• Worked with DataStage Administrator for setting up project and resolving issues with performance of datastage jobs
• Perform and documented POC by designing SharePoint Site to upload the Transmission Data Repository (TDR) data accessed by the NDM/Client Application Support (CAS) team
• Assess and monitor potential sources of impacts due to Planned Release, DBCR(s), Production Defects and communicate any cross impacts against the existing pool of Custom Objects to Custom Objects stakeholders across the SDLC
• Set up checkpoints for cross impacts Confidential end of core release design and build phase
• Support BSA Team as architecture SME in the course of their activity creating FRDs
• Support and mentor Engineering in the course of code & build
• Support QA Team as Architecture SMEs and in consultation for remediation approach(es)
• Participate in deployments in support and/or leadership roles
• Custom Object Design Activity Log via a SharePoint site
• React to defect assignments within SLA
• Mentor the new on-boarding members
• Champion best practices across SDLC
• Champion the Customer Experience within scope of influence
• Champion Process Hardening within scope of influence
• SMEs on Big-Picture PaymentNet4 Business Processes
• Drive to completion raised issues or matters requiring multi-disciplined approach
• Created various SharePoint Sites for Communications CO Cross Impacts (SP), Legacy CO Design Tracking & Cross Reference and CO Design Activity Log
• Involved in Ongoing Synthesis of Release and Project Management Timelines for the migration project of DataStage Jobs from 8.1 to 8.5

Environment: DataStage 8.1/8.5, AIX 5.3, Java J2EE, Oracle 11g, Rational ClearCase, Rational ClearQuest, HP Quality Center, SQL Developer, TOAD, Microsoft Visio

Confidential, Bentonville, AR

Senior ETL Datastage Consultant

Responsibilities:

• SFTP the Essbase CSV files to datastage server for analyzing the format and reading the file
• Used Data stage to extract data from Teradata and CSV files and loaded data into SAP BI using SAP BW Load Pack stage 4.3.1.
• Designed and developed data stage jobs for multiple countries data using ODBC, Aggregator, Sequential file, Transformer stages, Filter stages, multiple rows Lookup, Teradata Enterprise stage.
• Worked and extracted data from XML using XML Input and XML Transform stages.
• Used IBM Information Server 8.0.1 for splitting the data into subsets and to load data, utilizing all available processors to achieve job performance.
• Involved in creation of parallel jobs using Information Server to improve the performance of jobs.
• Developed job sequencers and implemented restartability using various checkpoints.
• Extensively worked on DataStage Director, DataStage Designer and DataStage Administrator.
• Involved in writing datastage jobs with support to Audit, Balance and Control process for the aggregated amounts from the source and target.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing. Logged errors into Informix database.
• Wrote Technical Unit Test cases for functional testers and uploaded them to HP Quality Center 9.2.
• Shell scripts were written to run the sequencers and copying files from root directory to destination directory.
• Wrote technical and data processing documentations for backend systems.
• Migrated jobs from DEV to QA box for testing purposes.
• Mentor offsite and onsite colleagues and provided suggestions regards to datastage job designs.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: IBM Information Server 8.0.1, AIX 5.3 (UNIX), Putty 0.58, INFORMIX 9.5, Teradata MS Visio 2007, MS Office 2007, Queryman (Teradata SQL Assistant) 12.0, HP Quality Center 9.2, Windows Vista Enterprise Edition & XP

Confidential, Des Moines, IA

Senior Data Stage Solutions Engineer

Responsibilities:

• Developed code to process large volumes of data (terabytes) using Data stage/Orchestrate.
• Participated in the high-level design of the ETL system and mapping of business rules
• Involved in writing scripts with support to ABC process
• Developed low-level design to depict the functionality of each individual system.
• Developed the functions to manage the Extract, Transform and Load of the ODS using a combination of Korn Shell scripts, DataStage IBM Information Server 8.0.1
• Analyzed the source and the target systems to aid the design of the Operational Data Warehouse
• Created XML output files using XML stages.
• Developed various datastage jobs using ODBC, Merge, Funnel, Filter, Aggregator, Sequential file, Transformer stages, Change Capture, Modify, Pivot, Row Generator, Column Generator
• Developed ETL extraction routines to extract data from flat files using korn shell scripts
• Conducted performance analysis and optimized the Datastage/Orchestrate jobs
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution
• Conducted the Unit testing and System testing of the individual modules
• Mentoring team on how to program Datastage/Orchestrate parallel jobs, development of presentation materials and training
• Performed HIPPA training Confidential BCBS.

Environment: IBM Information Server DataStage 8.0.1, SunOS 5.1(UNIX), Putty 0.6, DB2 UDB 9.0, SQL Server 2000, Oracle 10g, Mainframe COBOL Files, KEA-X 6.0, ERWIN 4.1, MS Visio 2003,WINSQL, Windows XP

Confidential, Herndon, VA

Senior ETL Designer/ Developer

Responsibilities:

• Used Data stage and scripts to extract data from ARES production server and loading data into oracle database.
• Designed and developed data stage jobs for DMT, OPTICS, ARES interfaces.
• Used IBM Information Server 8.0.1 for splitting the data into subsets and to load data, utilizing all available processors to achieve job performance.
• Using data stage to maintain consistent data and values by shielding the legacy structures.
• Development of DataStage jobs using various stages including Aggregator, Join, Transformer, Sort, Merge, Filter, Funnel, Surrogate Key generator, Modify
• Developed job sequencers and implemented restartability using various checkpoints.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing.
• Using datastage director to schedule and run jobs on daily, weekly, monthly.
• Shell scripts were written to check the record count and copying files from root directory to destination directory.
• Wrote technical documentation and data processing documentation for backend systems.

Environment: IBM Information Server 8.0.1, AIX 5.3 (UNIX), ORACLE 10g, ERWIN 4.1, MS Visio 2007, MS Visual SourceSafe 2007, MS Office 2007, TOAD, Windows XP

Confidential, Chicago, IL

Data Stage Developer and Analyst

Responsibilities:

• Analyzed the source and the target systems to aid the design of the Operational Data Warehouse.
• Participated in the high-level design of the ETL system and mapping of business rules
• Developed ETL extraction routines to extract data from DB2 database using SQL and korn shell scripts
• Migrated projects from Development environment to Test environment
• Development of DataStage jobs using various stages including Row-generator, Column generator, Change Capture, Lookup, ODBC, Link Partitioner, Link Collector, Head, and Peek
• Conducted performance analysis and optimized the Datastage/Orchestrate jobs
• Developed code to process large volumes of data (terabytes) using Data stage/Orchestrate
• Developed low-level design to depict the functionality of each individual system.
• Developed the functions to manage the Extract, Transform and Load of the ODS using a combination of Korn Shell scripts, DataStage 7.5.1, Orchestrate Parallel Extender
• Conducted the Unit testing and System testing of the individual modules.
• Aiding the system and production support to fix the post-release glitches.
• Monitored the Production run scripts and jobs for Datastage Project.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Mentoring team on how to program Datastage/Orchestrate parallel jobs, development of presentation materials and training
• Performed training to get HIPPA certificate.

Environment: IBM Ascential DataStage 7.5.1 A, AIX 5.2 (UNIX), Mainframe DB2, ASG-Zena 2.3.1, ERWIN 4.1, Ms Visio 2003, DB2 Developers Workbench 9.1, SecureCRT 4.0, SecureFX 4.0, Lotus Notes 6.5, WINSQL, Windows XP

Confidential, Saint Louis, MO

Data Stage Developer

Responsibilities:

• Involved in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Worked closely with data modeler, business system consultants and data population developers, and multiple business units to identify key information that will enhance business decision-making.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates Business Rules and Functionality Requirements into ETL procedures.
• Developed DataStage jobs between source systems and various other systems for data migration.
• Experienced in creating Custom Routines (Transform function) used across the project.
• Complicated jobs were developed to include changing business rules and perform quality checks on data received from external vendors.
• Created ETL execution scripts for automating jobs.
• Wrote routines to schedule batch jobs to obtain data overnight from various locations.
• Created UNIX shell scripts to be used in conjunction with files.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Analyzed the performance of the jobs and project and enhance the performance using the required techniques.
• Unit tested the mappings to check for the expected results.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Responsible for finding the data type mismatch between the source and the target.

Environment: Ascential DataStage Server 7.5/7.1 (Manager, Director), Parallel Extender, DB2 UDB, Server 2000, AIX UNIX, Mainframe DB2, Windows NT