SUMMARY

• About Thirteen years of experience in software design and development in data integration projects building Data marts using IBM Infosphere Datastage.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse/Data Marts using Ascential DataStage (Designer and Director).
• Expertise in handling disparate Data sources likes Oracle, Teradata and DB2 UDB
• Full Life Cycle Experience including requirement analysis, design, development, testing, implementation and documentation.
• Strong experience in performance tuning of IBM Infosphere DataStage PX jobs.
• Expertise in real time processing websphere stages.
• Experience in Data modelling.
• Excellent knowledge in SQL and UNIX Shell Scripting.
• Have exposure to data modeling, design and programming, testing and troubleshooting skills with strong analytical background.
• Excellent presentation, technical documentation, communication and interpersonal skills

TECHNICAL SKILLS

Concepts: Data Warehousing, Software Engineering

ETL Tools: IBM InfoSphere Information Server 11.3,8.7,8.5, 8.1.x, IBM Websphere DataStage 8.7,8.5, 8.0, 7.5x2, 7.1, Quality Stage 7.5/7.0, Fast Track, Information analyzer.

Databases: Oracle DB2, SQL Server, Teradata

Operating Systems: Windows 98/NT/2000, UNIX (AIX & Solaris), Redhat LINUX

Schedulers: Autosys, Control M, Tivoli

Programming: PL/SQL, UNIX Shell Scripting, Linux Shell scripting, JCL

Data Access Tools: Toad

Application Packages: MS Office, MS Visio, MS Project and Rational rose.

Data Modeling tools: ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Infosphere Datastage Developer

Environment: IBM InfoSphere Information Server 8.5, SQL Server, DB2, Linux Shell Scripting, Autosys

Responsibilities:

• Prepared the Source to Target Mapping from Source to staging and staging to Warehouse tables.
• Prepared ETL Design documents
• Develop the ETL processes for extracting data from external sources.
• Scheduled the jobs using DataStage director.

Confidential, Windsor, CT

Datastage Developer

Environment: IBM InfoSphere Information Server 11.3, Oracle, Linux Shell Scripting, Teradata.

Responsibilities:

• Prepared the Source to Target Mapping from Source to staging and staging to Warehouse tables.
• Prepared ETL Design documents
• Develop the ETL processes for extracting data from external sources.
• Scheduled the jobs using DataStage director.

Confidential, Plano, TX

Infosphere Datastage Developer

Environment: IBM InfoSphere Information Server 8.5, HP Vertica, DB2, Linux Shell Scripting, Teradata, Autosys, xml, JSON.

Responsibilities:

• Prepared the Source to Target Mapping from Source to staging and staging to Warehouse tables.
• Prepared ETL Design documents
• Develop the ETL processes for extracting data from external sources.
• Scheduled the jobs using DataStage director.

Confidential, Oakbrook, IL

Infosphere Datastage Developer

Environment: IBM InfoSphere Information Server 9.1/11.3, SAP BW, Unix Shell Scripting, Teradata, ERWIN, SQL Server, Control M

Responsibilities:

• Prepared the Source to Target Mapping from Source to staging and staging to Warehouse tables.
• Prepared ETL Design documents
• Developed Datastage jobs to load data from Alchimetrics source files to SQL Server staging tables.
• Used stages Sequential File, Transformer, Remove Duplicates, Sort, Data Sets, Hash File, Join, etc. while developing the code
• Develop the ETL processes for extracting data from external sources.
• Scheduled the jobs using DataStage director.

Confidential

Infosphere Datastage Developer

Environment: IBM InfoSphere Information Server 9.1/11.3, Unix Shell Scripting, Oracle, Java, PL/SQL,JCL Programming, ERWIN

Responsibilities:

• Responsible for the overall development and delivery of the applications
• Involved in Production support.
• Translate business requirements into Datastage design
• Develop the ETL processes for extracting data from external sources
• Used stages Sequential File, Transformer, Remove Duplicates, Sort, Data Sets, Hash File, Join, etc. while developing the code
• Monitoring the Cycle in SIT, UAT and Production regions

Confidential

Infosphere Datastage Developer

Environment: IBM InfoSphere Information Server 8.5, Parallel extender Unix Shell Scripting, DB2, OLAP Technologies, PL/SQL Programming

Responsibilities:

• Responsible for the overall development and delivery of the applications
• Translate business requirements into DataStage design
• Develop the ETL processes for extracting data from external sources
• Develop jobs to validate the source files

Confidential, NJ

Datastage Developer

Environment: Infosphere Data stage EE 8.1, Parallel extender Unix Shell Scripting, DB2, Sybase, OLAP Technologies, PL/SQL Programming, ERWIN

Responsibilities:

• Responsible for the overall development and delivery of the applications
• Translate business requirements into DataStage design
• Develop the ETL processes for extracting data from external sources
• Develop jobs to validate the source files

Confidential, NYC

Datastage Developer

Environment: Datastage EE 8.1, Parallel extender, Oracle, Peoplesoft, ERWIN, PL/SQL, Connectdirect

Responsibilities:

• Requirement gathering, analysis by interacting with clients and Subject Matter Experts.
• Build the Infrastructure and Framework for handling the audit fields and reading real time data
• Involved in Defining, documenting the Scope of the project.
• Generate, interpret mapping documentation, and translate into detailed design specifications.
• Collaborate with Technical architects and subject - matter experts to design comprehensive solution.
• Prepared High level and Low level design documents.
• Worked with Data Modelers, Information Architects in defining the relations between Dimensions and Facts in the Confidential Model.
• Defining ETL standards, processes and Best Practices.
• Experienced in sourcing data from SQL Server and targeting to Sql Server and DB2.
• Review ETL jobs design and development for compliance to development standards.
• Assist in defining a test plan for functional/quality assurance testing of ETL jobs.
• Mentor and guide the team to develop better ETL Solution.

Confidential, NC

Datastage Developer

Environment: Datastage EE 8.1, Server 7.5, Quality Stage, DB2, Control M, SAP Plugin, IDOC.

Responsibilities:

• Requirement gathering, analysis by interacting with clients and Subject Matter Experts.
• Involved in Production support.
• Generate, interpret mapping documentation, and translate into detailed design specifications.
• Collaborate with Technical architects and subject - matter experts to design comprehensive solution.
• Prepared High level and Low level design documents.
• Worked with Data Modelers, Information Architects in defining the relations between Dimensions and Facts in the Confidential Model.
• Defining ETL standards, processes and Best Practices.
• Used Complex Flat file stage to read GDG files (COBOL Copybooks).
• Review ETL jobs design and development for compliance to development standards.
• Assist in defining a test plan for functional/quality assurance testing of ETL jobs.
• Mentor and guide the team to develop better ETL Solution.

Confidential, NJ

Datastage Developer

Environment: Data stage EE 8.1, Parallel extender, Quality Stage, Unix Shell Scripting, DB2, VSAM, OLAP Technologies, SQL Programming, Redhat LINUX, PL/SQL

Responsibilities:

• Responsible for the overall development and delivery of the applications
• Translate business requirements into DataStage design
• Setting the new project in datastage and configuring the project
• Develop the ETL processes for extracting data from external sources
• Develop jobs to validate the source files

Confidential, NJ

Datastage Developer

Environment: Data stage EE 8.0, Parallel extender, PL/SQL, Unix Shell Scripting, RDBMS (Oracle), Flat file, Windows, Autosys, VSAM, DB2, JCL.

Responsibilities:

• Responsible for the overall development and delivery of the applications populating data in HUB
• Translate business requirements into DataStage design
• Setting the new project in datastage and configuring the project
• Develop the ETL processes for extracting data from external sources
• Develop jobs to validate the source files
• Automated the Datastage jobs sequence in autosys.

Confidential, CT

DataStage Developer

Environment: Data stage EE 7.5, Unix Shell Scripting, DB2, EDI834.

Responsibilities:

• Responsible for the overall development and delivery of the Claims system.
• Translate business requirements into DataStage design
• Develop the ETL processes for extracting data from vendor files.
• Develop jobs to validate the source files.

Confidential, MO

Datastage Developer

Environment: Data stage EE 8.0, DB2, Autosys.

Responsibilities:

• Responsible for the overall development and delivery of the Mortgage reporting module
• Translated business requirements into DataStage design
• Developed the ETL processes for extracting data from Mainframe Files
• Developed jobs to validate the source files
• Developing the scheduling scripts for executing the DataStage jobs

Confidential, NJ

Programmer Analyst

Environment: Datastage 7.0, DB2, Oracle.

Responsibilities:

• Met with the business users to understand the existing applications
• Documented the knowledge shared by Subject Matter Experts
• Prepared the system appreciation document.
• Supported and maintained Infopoint applications

Confidential

Programmer Analyst

Environment: Operating System: Oracle, Unix, DB2

Responsibilities:

• Involved in scope definition, requirements gathering analysis, logical and physical model changes of the database.
• Involved in Requirements Analysis, coming up with the Requirements documents and UTP and UTS along with coding and testing the modules.
• Worked as a module lead and was responsible for overall deliverables of the team.