SUMMARY:

• Over 9+ years of experience in Analysis, Design and Development and implementation of Relational Database (OLTP) and Enterprise Data Warehousing Systems (OLAP) using IBM Websphere DataStage, ORACLE, DB2 UDB, SQL Sever and Teradata.
• Over 8 years of experience in Ascential DataStage Server and Enterprise edition (Parallel Extender).
• Strong working experience on Ascential Datastage 7.5.2/7.5/7.1/7.0/6.0 , IBM InfoSphere DataStage Parallel and Server 8.1, 8.0.1, 8.5,8.7, SQL, PL/SQL, Stored Procedures and Triggers. Performed Debugging & performance Tuning.
• Expertise in Translating business requirements into Data Warehouse and Data Mart design and developing ETL logic based on the requirements using DataStage.
• Expert in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin 4.0.
• Worked on various operating systems like UNIX, Sun Solaris and Windows.
• Designed and developed jobs using Parallel Extender for splitting bulk data into subsets and to dynamically distribute data to all available nodes to achieve best job performance.
• Expert in System Integration Testing, UAT, Implementation, Maintenance.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension Type II phenomenon, surrogate key assignment and change data capture.
• Good experience on multiple Operating Systems (Windows NT/2000/9x, UNIX, AIX), Shell Scripting.
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Worked extensively on different types of stages like Join, Lookup, ODBC, XML Pack (XML Input, XML Output, XML Transformer), Hashed File, Aggregator, Transformer, Merge, Sort, Pivot, FTP, Change Data Capture, Filter, Modify, Shared Containers (Server, Parallel) for developing jobs.
• Used the DataStage Director extensively to run, schedule, monitor, debug and test the application on development, and to obtain the performance statistics.
• Good working knowledge of various Databases like Oracle 10g/9i/8i/7.x, DB2 UDB and SQL Server.
• Unique ability to understand long - term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills and Used Agile Development Methodology for project requirement gathering in advance.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere DataStage 8.1, 8.0.1,8.5,8.7 Ascential DataStage 7.5.2/7.1/7.0/6.0 , Informatica, SQL*Loader, Quality stage, Profile Stage, Bulk Loader.

Databases: Oracle 10g/9i/8i, SQL Server, Teradata, DB2 UDB, MySQL, MS - Access

Data Modeling: ERwin 4.0/4.1

Programming Skills: Shell Scripting, K-Shell, C, C++, SQL, PL/SQL, Mainframe Cobol

Scripting Languages: Unix Shell Scripting GUI Toad

Operating Systems: UNIX, Win 95/NT/98/2000/XP,MS-DOS, Sun Solaris 2.x, IBM AIX 4.2.

PROFESSIONAL EXPERIENCE:

Confidential

Onsite Techinical Lead/Sr.DatastageResource

Responsibilities:

• Working on production issues on daily run on multiple projects in EDW,PDW,HRIT,RMB
• Deploying production code on monthly changes and emergency changes.
• Working with different teams(network,unix,database) on patching on datastage server.
• Provided access to datastage resources using datastage webconsole and administration feature.
• Weekly implementation(maintenance) on datastage production server by using datstage start and stop scripts.
• Created knowledge documents related to project and to run the project.
• Shell Scripts were written to schedule the job and clean up files from archive Directory.
• Improved the performance of the jobs by using Performance Tunings.
• Review of Technical, Business Transformation Requirements Document and ETL Documents.
• Implementation of datastage verison from 8.x to 11.x
• Working with the end users in finalizing the requirements and assisted in preparing the Functional Requirements Documents.
• Created Interactive Dashboards for the business users to analyze the future of the commodities in present market and new trading opportunities.
• Provided Tableau pdf reports to users on weekly /monthly basis.
• Working with different teams in an Agile environment
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, ORA Bulk, Transformer, Merge, Join, Lookup, Sort and Containers (Server, Parallel) for developing job.

Environment: DataStage8.x,11.x, Oracle, Toad, Microsoft visio studio 2008/2010,Windows NT 4.0/2000, IBM AIX 4.2,DB2, Tableau Desktop 8.x.

Confidential

Sr.ETL Developer/ TM1 Onshore Support Resource

Responsibilities:

• Created Design Documents and Unit Test cases with test Results Documents.
• Developed jobs using DataStage to extract data from different operational Sources, performed business operations on data like Cleansing, Transforming and Load (Initial/Incremental) into Target DWH.
• Involved in unit testing, system testing, UAT and integration testing.
• Provide technical/user documentation and .
• Participated in the review of Requirements Documents and mapping documents.
• Working on TM1 Hierarchy activity on monthly basics and Working closely with BA and TM1 Developer on TM1 releases,Working on GL/Non GL,BI weekly Files on respective business days.
• Developed JOBS to load the data into the Warehouse environment.
• Performing Weekly and Monthly Deposit cube load in TM1 and providing technical support to TM1 users on TM1 problems and Support to Hyperion.
• Involved in Daily status call with offshore for project status and update the weekly status report to the Manager.
• Provide TM1 technical guidance and oversight to client resources teams while developing / maintaining client technology solutions.
• Involved in Requirement gathering and daily meeting with BA for updates.

Environment: IBM InfoSphere DataStage 8.5,TM1, SAP BO, Oracle, MSOffice, PowerShell script, Hyperion.

Confidential

Sr.ETL Developer

Responsibilities:

• Involved in Requirement gathering and daily meeting with BA for updates.
• Creating STT documents and Review the specs with BA team.
• Involved in preparing Mapping documents for data Extraction, Transformation and Loading.
• Created Logical process flows and physical process flows of business requirements using Visio.
• Participated in discussions with Team leader, Group Members and Technical Manager regarding any technical issues and project status.
• Designing of the data stage jobs as per the requirements.
• Working on Unix scripts to trigger the jobs and archive the files.
• Working with different payers data and loading data in to Universal database.
• Used the DataStage Director for monitoring the jobs and debugging the Issues.

Environment: IBM InfoSphere DataStage 8.7/8.5 (Parallel), Teradata Oracle, SQL Server,AIX.

Confidential

Onshore Lead /ETL Developer

Responsibilities:

• Involved in Business Requirement for building Data stage Jobs.
• Involved in the analysis & design of the Data Warehouse model with Facts and Dimension Tables.
• Involved in daily meetings with the client for requirements and provide services to meet the required SLAs.
• Involved in daily meetings with the Offshore and onshore for project status and update the weekly status to the project manager.
• Involved in HLD and LLD documents and daily and weekly status calls.
• Improved the performance of the jobs by using Performance Tunings.
• Involved in unit testing, system testing, UAT and integration testing.
• Provide user documentation and to the team.

Environment: IBM InfoSphere DataStage 8.5/8.1 (Parallel),Informatica, OBIEE, Teradata Oracle, SQL Server.

Confidential, CA - Vacaville

ETL Tech Lead /DataStage Administrator

Responsibilities:

• Involve in the business meeting with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Involved in Business Requirement gathering sessions
• Developed jobs using Data Stage to extract data from different operational Sources like Flat Files, fixed & delimited Files and performed business operations on data like Cleansing, Transforming and Load (Initial/Incremental) into Target ITDH.
• Used Before and After Stage subroutines to further enhance performance of the system and pre and post SQL in the OCI stage.
• Developed jobs using DataStage to extract data from different operational Sources like XML, CSVand COBOL Files.
• Developed JOBS to load the data into the Warehouse environment.
• Basically involved in providing Support to the built Application.
• Designing of the ETL jobs as per the client’s requirements.
• Worked on issues when the Data stage server is down and Provide access to new users.
• Create new projects and worked on Support DR activities.
• Integrate the data from the Source system into the target database.

Environment: IBM InfoSphere DataStage 8.5 (Server and parallel), Business Objects, Oracle 10g and AIX UNIX

Confidential, CA - Sunnyvale

Sr. DataStage Consultant

Responsibilities:

• Interacted with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Developed jobs using DataStage to extract data from different operational Sources, performed business operations on data like Cleansing, Transforming and Load (Initial/Incremental) into Target DWH.
• Involved in daily meetings with the client for requirements and provide services to meet the required SLAs.
• Created Design Documents and Unit Test cases with test Results Documents.
• Developed JOB using DataStage for Data Cleansing, Extraction and Transformation.
• Developed JOBS to load the data into the Warehouse environment using the Slowly Changing Dimension techniques.
• Check the output according to the specifications using Unit Test.
• Developed JOBS using Data Stage for Data Cleansing, Extraction and Transformation as per ETL Specifications and Performance Tuning of the JOBS.
• Basically involved in providing Support to the built Application.
• Designing of the ETL jobs as per the client’s requirements.
• Involved in Unit, Integration, system, and performance testing levels and Involved in Performance tuning at source, target, jobs and system levels and Testing Jobs with Unit Test plan.
• Integrate the data from the Source system into the target database.

Environment: IBM InfoSphere DataStage 8.1, OBIEE, Oracle, Win 2000/NT and AIX UNIX

Confidential, CA - San Ramon

DataStage Consultant

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems
• Involved in preparing technical design/specifications for data Extraction, Transformation and Loading.
• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into database tables.
• Worked with DataStage Manager to import/export metadata, jobs, and routines from repository and also created data elements.
• Created Technical Specs and SQL document for the DataStage Jobs.
• Implementing performance-tuning techniques along various stages of the ETL process

Environment: IBM InfoSphere DataStage 8.1.0, DataStage 7.5, SQL Server, Oracle 10g, Shell Scripts, Win 2000/NT and AIX UNIX .

Confidential, Weehawken - NJ

ETL Developer

Responsibilities:

• Involved in Design, Source to Target Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
• Participated in the review of Technical specs, Business Transformation Requirements Documents and high level process maps.
• Used local and shared containers to increase Object Code Reusability and to increase thru put of the system.
• Import/Exported source code and executables using DataStage Designer Client
• Created data jobs to extract data from different source files, transform the data using stages like Transformer stage, Aggregator to classify rows from a single input link to groups, Remove Duplicate stage to remove duplicate rows, Sort stage to sort the data in a particular order, Copy stage to copy data into more number of links, Modify stage to alter record schema of its input data set, Filter stage to filter the data, Join stage and then load to data warehouse.
• Extensively wrote user-defined SQL coding for overriding for Auto generated SQL query in DataStage.

Environment: IBM InfoSphere DataStage 8.0, Business objects, SQL Server, Oracle, Win 2000/NT and AIX UNIX