EXPERIENCE SUMMARY:

• Over 10 years of Real - time experience in IT Industry (Data Warehouse, Business Intelligence and Databases) with extensive knowledge in Developing, Designing, and implementing using IBM Infosphere Information suite products like Datastage, Director, Admistrator, Mainframe, UNIX, SQL and windows in various industries such as Banking, Investment Banking, Finance, Insurance, Retail.
• 7+ years of experience in Data Warehouse using IBM Websphere Datastage version 8.x / 7.x Using components like Administrator, Manager, Designer and Director. Experience in Quality Stage.
• 3 years of experience in Mainframe coding, testing and support using various tools such as File-Aid, Endeavor, OPC Scheduler, NDM, TSO/ISPF.
• Expertise in all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical design, code development, testing, implementation and maintenance of Business applications with Dimensional Data Warehouse/Data Marts.
• Experience in integration of various data sources like DB2/UDB Enterprise Stage, Oracle, SQL Server, Netezza and Flat files into the Staging Area.
• Worked with various Stages in IBM WebSphere DataStage like ODBC Connector, Dataset Stage, Database stages, Join, Sort, Aggregator Stage, Lookup Stage & various other stages.
• Experience in using Quality Stage to improve data quality through a sequence of data cleansing mechanisms.
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling and implementation of STAR, Snowflake schemas and slowly changing dimensions.
• Utilized DataStage Import and Export Utilities to migrate the code from Development environment to QA and then to Production Environments.
• Worked on UNIX scripting.
• Good Knowledge and Hands on Experience interfacing IBM WebSphere with DataStage.
• Involved in Metadata Management.
• Good knowledge on WINSCP3 and PUTTY to edit, move or copy files on the server.
• Working experience in interacting with Business Analysts and developers to analyze the user requirements, functional specifications and system specifications
• Worked with Business Users and has clear understanding of Business Procedures and ability to work as an individual and as a part of a team.
• Excellent Analytical and Logical programming skills with a good understanding at the Conceptual level and Possess Excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals.
• Worked in Waterfall & Agile methodology, and capable of executing the dynamically changing requirements in various sprints while still maintain a well-defined process.
• Experience in design environment as well as production support group to monitor, support and quickly identify the issues and fix the process in the production environment.
• Good domain knowledge in Banking especially in Wealth Management, have good knowledge on Managed products within wealth management division and Health Care.
• Possess excellent skills in dealing with the Customers and Business Users.
• Experience in creating the BRD’s, HLD and LLD for the project.

TECHNICAL SKILLS:

Databases: DB2, Oracle 11g, SQL Server 2008, Netezza

Programming Language: SQL, UNIX shell scripting, Cobol, JCL, SAS

ETL Tools: Datastage 8.x/7.x, Enterprise and Server Edition, Quality Stage

Data Modeling Tools: MS Visio 2003/2000, CA Erwin Data Modler

RDBMS Tools: TOAD 8.5, QTODBC

Operating Systems: Windows Server, Windows XP, Windows 2000, Windows 7, UNIXIBM Mainframe

Version Control: Endeavor, TFS, Changeman, Librarian

Scheduling Tools: Autosys, OPC Scheduler, CA-7 Scheduler

Other tools: WINSCP3, PUTTY, Cognos Report Studio, SPUFI, Endevor, File Aid, NDM, TSO/ISPF

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

DataStage Technical Lead/Consultant

Environment: IBM WebSphere DataStage 8.7 / 8.1 / 7.5.2, MS-Visio, CA ERwin Data Modler, Red Hat Linux, IBM DB2 UDB, Oracle 11g, Netezza, IBM Mainframe

Responsibilities:

• Participated in Design, and Coding, Testing, support and Documentation of SDLC including Client and business users Interaction.
• Prepared implementation strategies for the existing enhancement changes & migration changes and provide support during the implementation of the programs in production.
• Analyzed the present database model and participated in investigation of data subject areas and document data flows.
• Integrated various sources and targets into the staging area for Integrating and Cleansing data.
• Architecting IBM DataStage ETL solution and Metadata Management activities.
• Created ETL mapping documents.
• Responsible for Design and Developing ETL Jobs for processing inbound and outbound data and integrating that data into the clients back end solution.
• Designed various Datastage Jobs using Transformer, Database connector Stages, and Dataset Stage, Complex Flat files, Sort, Aggregator Stage, Lookup Stage, and Output Stage with various other stages.
• Used DB2 Stages to Read Data and Transformed into Target SQL tables using various Transformation Rules (Business Rules).
• Developed Unix Shell Scripts to execute the data stage jobs and control the job flow and update the real time job run information in the log files.
• Designed and developed Job Sequences using various Components like Job Activity, Notification Activity, and Wait for File Activity, Terminator Activity, and Exception Handler.
• Developed FTP jobs to transmit the Data files to the target Data warehouse and Legacy Mainframes.
• Used Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Reviewed the jobs developed by other developed and have coordinated status meetings and have
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.
• Generate metrics of projects using project data from IRIS (Integrated Relationship Information System).

Confidential, Pennington, New Jersey

DataStage Technical Lead

Environment: IBM WebSphere DataStage 8.7, 8.1/7.5.2, MS-Visio, CA ERwin Data Modler, Red Hat Linux, IBM DB2 UDB, Oracle 11g, Netezza, IBM Mainframe

Responsibilities:

• Participated in Design, and Coding, Testing, support and Documentation of SDLC including Client and business users Interaction
• Analyzed the present database model and participated in investigation of data subject areas and document data flows
• Integrated various sources and targets in to the staging area for Integrating and Cleansing data.
• Architecting IBM WebSphere DataStage ETL solution
• Created ETL mapping documents
• Responsible for Design and Developing ETL Jobs for processing inbound and outbound data and integrating that data into the clients back end solution
• Designed various Datastage Jobs using Transformer, Database connector Stages, and Dataset Stage, Complex Flat files, Sort, Aggregator Stage, Lookup Stage, and Output Stage with various other stages.
• Used DB2 Stages to Read Data and Transformed into Target SQL tables using various Transformation Rules (Business Rules).
• Developed Unix Shells Scripts that execute the data stage jobs and control the job flow and update the real time job run information in the log files.
• Designed and developed Job Sequences using various Components like Job Activity, Notification Activity, and Wait for File Activity, Terminator Activity, and Exception Handler
• Developed FTP jobs to transmit the Data files to the target Data warehouse and Legacy Mainframes
• Used Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Reviewed the jobs developed by other developed and have coordinated status meetings and have
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.
• Generate metrics of projects using project data from IRIS (Integrated Relationship Information System).

Confidential, Phoenix, Arizona

Technical Lead

Environment: IBM WebSphere Datastage 8.1/7.5.2, Quality Stage, MS-Visio, CA ERwin Data Modler, Red Hat Linux, IBM DB2 UDB, Oracle, Netezza, IBM Mainframe, C Programming

Responsibilities:

• Attending SRE’s (System Request Enhancements) and PSI’s business requirement walkthrus and performing business requirement analysis.
• Impact analysis, sizing on SRE’s and PSI’s on Work Order System and Daptiv.
• Participated in Design, and Coding, Testing, support and Documentation of SDLC including Client Interaction.
• Productionized on the need basis as communicated by business using Remedy thru ACM production turnover process.
• Architecting IBM WebSphere Datastage ETL solution
• Created ETL mapping documents
• Responsible for Design and Developing ETL Jobs for processing inbound and outbound data and integrating that data into the clients back end solution
• Transformer, DB2/UDB Enterprise Stage, and Dataset Stage, Complex Flat files, Merge, Sort, Aggregator Stage, Lookup Stage, and Output Stage with various other stages.
• Used DB2 Stages to Read Data and Transformed into Target SQL tables using various Transformation Rules (Business Rules).
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed Unix Shell Scripts that execute the data stage jobs and control the job flow and update the real time job run information in the log files.
• Used Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Developed FTP jobs to transmit the Data files to the target Data warehouse.
• Scheduled jobs using UNIX Script in Autosys.
• Involved in documentation to describe program development, logic, coding, testing, changes and corrections.
• Attending daily scrum meetings and provides the status on the projects being worked to business and management.
• Feasibility & Impact Analysis for the process improvements recommended.
• Providing support for the production applications and impact alerts.
• Working in areas to provide SLA in the daily, weekly & monthly runs.
• Analyzing the scope of improvement in the areas to minimize processing times & optimize the solution without affecting any of the deliveries.
• Involved in the automation process of the manual jobs.
• Co-ordinate the requirements with team to perform a smooth execution of the project.

Confidential

Module Lead

Environment: IBM WebSphere DataStage 7.5, IBM DB2, Quality Stage, MS-Visio, Autosys and Windows XP Professional

Responsibilities:

• Extensively used DataStage Tools like DataStage Designer, DataStage Manager and DataStage Director.
• Got the source data in the form of Oracle tables, Sequential files and CSV Files.
• Developed processes to extract the source data and load it into the data warehouse after Cleansing, Transforms and
• Integrating.
• Imported metadata from repository, created new job categories, routines and data elements.
• Scheduled Running Testing and Debugging of jobs.
• Worked on programs for scheduling data loading and transformations using Data stage from source systems to
• SQL on DB2 database
• Worked on sales data, which comes from different countries.
• Created Unix Shell scripts that control and execute a set of jobs.

Confidential, Herndon, VA

Module Lead

Environment: IBM WebSphere DataStage 7.5, IBM DB2, Quality Stage, MS-Visio, Autosys and Windows XP Professional

Responsibilities:

• Extensively used DataStage Tools like DataStage Designer, DataStage Manager and DataStage Director.
• Got the source data in the form of Oracle tables, Sequential files and CSV Files.
• Developed processes to extract the source data and load it into the data warehouse after Cleansing, Transforms and
• Integrating.
• Imported metadata from repository, created new job categories, routines and data elements.
• Scheduled Running Testing and Debugging of jobs.
• Worked on programs for scheduling data loading and transformations using Data stage from source systems to
• SQL on DB2 database
• Worked on sales data, which comes from different countries.
• Created Unix Shell scripts that control and execute a set of jobs.