EXPERIENCE SUMMARY:

• Over 8+ Years of software experience in Data warehousing Applications design, development, Testing and Test Management.
• Expertise in ETL Design & Development using Datastage (8.1/7.5.2) Designer, Director and Administrator.
• Expertise in DataStage issue resolution, debugging and application performance tuning.
• Experience in performance tuning of Datastage jobs
• Experience in extracting data from Oracle.
• Experience in Producing project design documents Mid Level Platform Application design Document(MLPD), Detailed Platform Application Design Document (DPAD)
• Proficient in Oracle SQL, PLSQL, UNIX Shell Scripting
• Worked on databases Oracle 8i/9i/10g, Teradata V2R6.2.
• Expertise in performance tuning by using Explain Plan, Creating appropriate indexes, queries optimization, utilizing table spaces, partitioning schemes in oracle.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Involved in development of Test cases, executing the Unit/UAT Test cases.
• Involved extensively in Unit Testing, System Testing and Regression Testing.
• Experience on Defect tracking tools like HP Quality Center.
• Involved in daily interactions with the Business to understand their requirements and act in a Business Liaison role.
• Setting up Defect calls for tracking and closing the defects.
• Experience in producing project estimation, timeline scheduling, resource forecasting, communicating key milestones to IT management and clients, Task scheduling and status tracking.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Experience in leading and mentoring team members on both functional and technical aspects.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Able to work independently and collaborate proactively & cross functionally within a team.

Technical Skills:

Operating System

Windows All Versions, IBM AIX Unix

Programming Languages

SQL,PL/SQL, UNIX Shell Scripting

Databases

Oracle9i, 10g

ETL Tools

Datastage 8.1 / 7.5.2

Tools

PL/SQL Developer, Toad

Testing Tools

HP Quality Centre 11.0

PROFESSIONAL EXPERIENCE:

Client: Confidential, Dallas, Texas April'07 to May'12
Role: Datastage Designer / Lead Developer.

Technology & Tools Used: IBM WebsphereDatastage 8.1 Designer, Director, Administrator, Oracle 10g, Teradata, IBM AIX UNIX 5.1 , TOAD, PLSQL Developer, Connect Direct File Transfer Tool, IBM Mainframe

Responsibilities:

• During my tenure in Lloyds as Datastage Designer and Lead developer I have predominantly worked in Datastage modules of the projects related to Financial Data processing, Business Performance Management, Sales Marketing Analysis and Reporting, e-Statements which has extensive usage of Datastage 8.1.
• Participated in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, Production support and Documentation.
• Involved in gathering business requirements and providing development and testing estimation, timelines and resource forecasting.
• Responsible for preparing Mid Level Platform Application Design (MLPD) and Detailed Platform Application Design (DPAD) Documents based on Business Requirement specification document, giving walkthrough to Document review panel members, clients and obtaining sign offs from the CIO and other Subject Matter Experts from the Client Organization before proceeding with the build activity.
• Involved in preparing the coding standards documentation for Datastage Development.
• Involved in designing complex Parallel Datastage jobs, sequencers.
• Involved in working with SAP Ledger downstream systems by sending SAP reference files and loading processed data to the SAP tables.
• Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, SCD, Change capture, Copy, External filter, External Source, Pivot, Complex Flat File Stages, etc
• Used Datastage XML input stage for processing banks hierarchical files
• Coordinated with UNIX admin and service delivery team in procuring the UNIX environment and to create Datastage Unix environment file system and directories.
• Involved in extracting the data from various sources like Flat files, Oracle and Teradata databases.
• Involved in developing Key Data validation and splitting modules using Datastage in Financial Data processing project for various sources files coming from different source systems.
• Used multiple invocation techniques for running jobs in various instances so as to reduce the time and expediting the processes.
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Utilized slowly changing Dimensions for tracking changes to dimensions over time
• Used Data stage Administrator for defining environment variables and project level settings.
• Utilized the stages of Job Sequence such as User Variable Activity, Notification Activity, Routine Activity, Terminator Activity, etc.
• Involved in developing error logging shared containers and extensively used in various Datastage jobs to gather the error logs in a business defined format, which facilitated the business in analyzing the erroneous files and fixing them quickly.
• Responsible for validating the Datastage jobs, sequencers against the pre-defined ETL design standards.
• Involved in developing Connect direct jobs for transferring files to the downstream systems and for pulling files from the source systems as well.
• Involved in Datastage jobs bug fixing and supporting testing team during various stages of testing.
• Involved in tuning Source extract SQL scripts used in ETL jobs to meet the business SLAs.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Prepared the DDL's for the staging/work tables and coordinated with DBA for creating the development environment.
• Developed Ksh shell scripts for automating Datastage jobs and Housekeeping activities.
• Created Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
• Created Unix Shell Scripts to read the Parameter Files and passing these values to the job during runtime.
• Experience in preparing and reviewing Functional Test Plans and Master Test Plans for various stages of the testing activities
• Responsible for preparing various test scenarios and validating the data as per the business rules.
• Involved in preparing and executing System Testing and System Integration test cases
• Provided support during User Acceptance Testing by running jobs and providing fixes.
• Co-ordinate the offshore development, testing and implementations using implementation plans.
• Responsible for doing the peer reviews, Planning and estimating the project requirements and to report the status to business managers.

Client: Confidential, August'06 to February'07
Role: Senior Datastage Developer.
Technology & Tools Used: IBM WebsphereDatastage 8.1 Designer, Director, Administrator,
Datastage 7.5.2, Oracle 10g, Teradata, IBM AIX UNIX 5.1, TOAD, PLSQL Developer.

Responsibilities:

• Involved in Gathering Business Requirement and producing inputs to MLPD and DPAD.
• Involved in all phases of project cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, support and Documentation.
• Responsible for preparing ETL Documentation for the developed processes.
• Investigation of possible Terrorist/Money laundering transactions happening in the system for the tickets raised by the business
• Responsible for handling Production Support tickets.
• Automated SQL queries using UNIX scripts for loading large volume of data during data migration activities in AML Project
• Involved in tuning many Oracle scripts and other ETL processes used in this project.
• Responsible for doing the peer reviews, Planning and estimating the project requirements and to report the status to business managers.
• Created Documentation for the developed jobs where appropriate documents were not available.
• Provided production support and bug fixing during various stages of the testing
• Involved in Designing and Developing of Datastage Parallel Jobs, Sequencers and Shared Containers
• Performance Tuning of Datastage jobs and Oracle SQL queries.
• Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, SCD, Change capture, Copy, External filter, External Source, Pivot, etc.
• Used multiple invocation technique for running jobs in multiple instances to speed up the process.
• Involved in writing oracle PLSQL Stored Procedures, SQL scripts
• Developed Ksh shell scripts for automating Datastage jobs and Housekeeping activities.
• Created Shell Scripts to automatically notify Business Exceptions and Rejects during the Loads and file processing stages.
• Created Unix Shell Scripts to read the Parameter Files and passing these values to the job during runtime.
• Responsible for preparing Unit test cases and validating the data as per the business rules.
• Provided support to the testing team during System Testing , System Integration Testing and User Acceptance testing

Client: Confidential, India March'04 to August'06
Role: Datastage / Oracle Developer.
Technology & Tools Used: Datastage 7.5.2, Oracle 10g, Teradata, IBM AIX UNIX 5.1 , TOAD, PLSQL Developer.

Responsibilities:

• Understanding Business Requirements
• Developing Datastage jobs using the MLPD, DPAD and Business Requirement Specification document.
• Extensively used Job Stages like Datasets, Sequential file, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, Change capture, Copy, External filter, External Source, Pivot, etc.
• Developing Oracle SQL, PL/SQL queries and DDL's for the Database creation.
• Performance tuning of SQL Queries.
• Developing UNIX scripts for automating Datastage jobs.
• Extensively used Datastage Designer & Director.
• Writing and executing test case for unit testing
• Providing support to QA team during System Testing and System Integration Testing.
• Coordinating with UNIX Admin and DBA's for Datstage UNIX environment creation and Database creation
• Engaged in Production Support tasks.
• Documenting the changes for future reference.