SUMMARY

• Over 8 years of experience in IT industry especially in client/server business systems analysis, design, development, testing, implementation, maintenance and support.
• 4 years of experience with a strong knowledge base in Extraction Transformation Loading (ETL) applications for Data Warehouses using IBM Datastage v8.1/ v7.5.1 (formerly Ascential Datastage)
• 4 years of PL/SQL experience includes working with Packages, Procedures, Functions, Triggers, Cursors, and Views
• I am an IBM Certified Solution Developer - - WebSphere IIS DataStage Enterprise Edition V7.5
• Experienced in developing Test Cases, Test Plans.
• Experience in reviewing, refactoring, testing, and documentation of the applications.
• Experience in Mainframe, COBOL and JCLs.
• Experience in Business Objects Data Integrator.
• Team lead experience that included managing project tasks, resource management, work allocation, sizing and scoping, application architecture and facilitating the quality related tasks to bring the projects to CMM Level-5.
• Demonstrated success managing multiple and simultaneous projects to completion within constraints of time, scope and budget.
• Good communication and leadership skills, including ability to work effectively with managers from widely varying disciplines.

TECHNICAL SKILLS

ETL tool: IBM DataStage 8.1/7.5 (Designer, Director, Manager, Administrator)

Languages: Oracle PL/SQL,SQL, C, UNIX shell scripts, COBOL, CICS, Natural

Development Tools: TOAD,QMF,Web sphere Transformation Extender, Web sphere Message Broker, Business Objects Data Integrator, Visual Studio 6.0

Databases: Oracle Database 8i, 9i, 10g, 11g,DB2

Version Management: Visual Source Safe, Dimension, Sharepoint

GUI: ORACLE D2K with FORMS 5.x/6.x, REPORTS 5.x/6.x, VISUAL BASIC 5.0

Operating Systems: WINDOWS,UNIX,MVS

PROFESSIONAL EXPERIENCE

Confidential - Iselin, NJ

Sr. ETL Developer

Responsibilities:

• Involved in design phase meetings for Business Analysis and requirements gathering for enhancements.
• Worked with business functional lead to review and finalize requirements and data profiling analysis.
• Designed various mappings (Source-to-Staging) using DataStage to link between different source systems and data warehouse for loading data into warehouse.
• Provided Production support and troubleshooting during the support period for the project
• Supporting existing processes in Datastage and legacy systems.
• Provide on-call support for any production issues.
• Collaborate and co-ordinate with various teams across Confidential to convert inter-dependent TFI code.
• Responsible for autosys job scheduling and monitoring.
• Responsible for any enhancements requested by business partners.
• Responsible for any Change Request Implementation, code-migration, code-review related activities.

Environment: Datastage 8.1, Oracle 11g, SQL, Toad, UNIX Shell Scripts, PVCS

Confidential, New York

Sr. ETL Developer

Responsibilities:

• Designed complex Datastage mappings between sources (external files and databases) to the into the target Data Warehouse (Oracle as the target database).
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Responsible for unit test documentation, design documentation, build-to-run transition documents, deployment and post production job monitoring.
• Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
• Involved in unit, performance, Regression and integration testing of data stage jobs
• Evaluate, redesign and modify existing Job logic to improve overall system performance
• Responsible for applying changes to existing DataStage code based on change requests

Environment: Datastage 8.1, DB2, Oracle 10g, SQL, PL/SQL, Toad, PVCS

Confidential - San Bruno, California

Datastage Developer/Offshore Lead

Responsibilities:

• Bottom-line responsibility for overall management of the project.
• Prepare/Update project plan, Weekly reports, defect analysis report and closure reports.
• Task scheduling and assignment within project.
• Project tracking and monitoring.
• Customer interaction, Customer liaison and issue resolution.
• Project team management and issue resolution.
• Requirements Analysis and High Level Design.
• Detailed design.
• Created design documents and system architecture based on the requirements gathered from project stake holders.
• Created estimates and planned the project deliverables based on time and resources.
• Ensured that all the enterprise procedures, such as system testing, change management and promotion procedures are followed.
• Created source to target mapping documents from staging area to Data Warehouse and from Data Warehouse to various Data Marts.
• Used DataStage to extract data from source systems such as Oracle, Flat files, XML to target data warehouse
• Designed and developed DataStage Shared Contained jobs for all the common modules (e.g. Audit and error handling) to allow reusability of code.
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Staging/Target tables.
• Used DataStage Director to schedule running the server jobs, monitoring scheduling and validating its components.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.
• Involved in unit, performance, Regression and integration testing of data stage jobs
• Evaluate, redesign and modify existing Job logic to improve overall system performance.
• Involved in maintenance, feature enhancement and provide support for processes and applications in use.
• Created and monitored scheduling scripts to run the ETL jobs for the client.
• Used Quality Center to track defects.

Environment: DATASTAGE 7.5.1(PX&Server), Oracle10g/9i, UNIX, SQL, PL/SQL, Dimension Version Manager, TOAD, Flat Files, XML’s, VSS, Sharepoint and Mainframe tool RACF for Scheduling.

Confidential - New Jersey

Lead developer

Responsibilities:

• Worked as a lead developer, actively interacted with business owners, gathered the requirements, and created system design and architecture.
• Involved in creating project plan, Weekly reports, defect analysis report and closure reports.
• Analysis, coding, development and testing of Maps in WebSphere Transformation Extender WTX 8.1
• Involved in Writing and executing Test plans and Test cases.
• Used MS Visio to create interface diagrams
• Created the complex SQL queries to fetch data from the multiple tables based on the Test cases.
• Involved in Defect prevention & Error handling.
• Managing the Configuration Items for projects in VSS and facilitating the quality related tasks to bring the project to CMM Level-4.

Environment: WebSphere Transformation Extender WTX 8.0/8.1., IBM Web Sphere Message Broker, Windows, VSS, MS Project

Confidential

Lead developer

Responsibilities:

• Bottom-line responsibility for overall management of the project.
• Prepare/Update project plan, Weekly reports, defect analysis report and closure reports.
• Task scheduling and assignment within project.
• Project tracking and monitoring.
• Customer interaction, Customer liaison and issue resolution.
• Project team management and issue resolution.
• Requirements Analysis and High Level Design.
• Detailed design.
• Code walk-through of complex programs.
• Review of System Test Plans.
• Completion of Integration testing.
• Issue logging and tracking at application level.
• Invoicing and billing for the project.
• Tracking and monitoring of the Project and Infrastructure.
• Resource allocation in consultation with the DM.
• Review of effort estimates of major enhancements.

Environment: SQL Server 2000, MS Visual Studio.NET. 2003, MS Visio, VSS

Confidential

Production Support Analyst

Responsibilities:

• Involved in the GDF application Enhancements.
• Defect analysis and repair.
• Data analysis and fixing data quality issues.
• Designing of the new functionality.
• Effort estimation, Change management and Scheduling.
• Coordinating the team of 6 people.
• Coordinating the Testing with other applications for SIT.
• Coordinating the User Acceptance Testing.

Environment: Business Objects Data Integrator, Oracle, Control M, Tivoli job scheduler.

Confidential

Production Support Analyst and Developer

Responsibilities:

• Providing steady state Production Support.
• Fixing the defects and releasing to production.
• Migration of application from ORACLE FORMS 5i to 6i.
• Doing enhancements to the application.
• Bringing the number of dockets down and making the system stable.
• Application DBA, User Administration and Release Management
• Carrying out the requirement analysis for the BI.
• Designing of the new functionality.
• Coding and Implementation of the Changes.
• Test planning and testing of the enhancement.
• Facilitating the quality related tasks.

Environment: Oracle Forms, Oracle PLSQL, ProC, C++, Shell scripts,MQ Series, MS Visio, VSS, DB2, CICS, Cobol, and Natural