Summary:

• Over 8 yearsof overall IT experience with 6 years of experience on Extraction, Transformation and Loading ETL processes using IBM DataStage 8.7/8.1/ 7.x
• Extensive knowledge of Data Warehousing, business intelligence, ETL processing and Data Modeling
• Experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage.
• Designing and developing jobs using DataStage Designer DataStage Director and DataStage Administrator.
• Extensively used DataStage Designer to design and develop server and parallel jobs to migrate data from transactional systems Sybase, DB2UDB and flat files into the Data Warehouse.
• Expertise in Designing Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset, lookup file set, modify, aggregator, Transformer.
• Knowledge in Extraction, cleansing and modification of data from/to various Data sources like Oracle, XML files,Flat files and Comma Delimited files.
• Extensively worked on DataStageParallel Jobs using Various Stages like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, and Remove Duplicate Stages.
• Experience working with Pentaho Data Integration Tool
• Practical Understanding of Data Modelling concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience in Data warehouse development life cycle and Design of Data marts
• Worked with DB2, SQL, SQL PLUS, Oracle PL/SQL, Stored Procedures, Table Partitions, SQL queries, and loading data into Data Warehouse/Data Marts.
• Good knowledge of Database concepts such as indexing, views, schemas and other database objects in both Oracle and DB2 databases.
• Conceptual knowledge of Pentaho Report Designer, Hyperion and Cognos.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

Technical Skills:

• ETL Tools:InfoSphere Information Server 8.7/8.1 Data stage, Quality stage Information Analyzer , Ascential Data stage 7.5/7.1 Designer, Director, Manager, Administrator , Pentaho, SQL Loader
• Environment: Linux, Unix, DOS, ESXi VMWare , Windows Server 2003/2008, Windows NT 4.0/ 2000/ XP/ 7, IBM AIX, IBM- PC Compatibles
• Databases: Oracle 10g/11g, MS SQL 2005, DB2 9.x
• GUI: Autosys 4.5/11.3,Toad for Oracle, SQL Navigator, Visual Basic 5.0/6.0, IBM Datastudio
• Languages: SQL, T-SQL, Oracle-PL/SQL, C/C , VB Script, Perl script
• Applications: MS proxy server, NetApp Storage, VMWare View, vSphere, Putty, Erwin r7, SAP 7.30

Professional Experience:

Confidential

Sr. ETL Developer

Roles and Responsibilities

• Involved in meetings to understand the process Timberland used in the past and attempt to integrate with VF's operations.
• Worked with SAP team to help us source data from SAP systems using datastage using SAP R/3 plugin
• Create jobs to source from SAP environment and store the data into DB2 tables
• Use BSEG to dump data and create MSEG jobs to filter out the required data into transactional datastore
• Used APAB codes autogenerated by datastage to extract data from SAP systems
• Used SAP developer 7.30 for validating and testing the data that comes into DB2
• Involved in meeting to gater requirements for creating reports.
• Understand the requirements of each department and transform data as per users requirement of each department.
• Pivoted a csv file with 824 columns into 72 columns for Forecast and Planning reports.
• Integrate with the Cognos team to generate required reports.
• Transformed MQTs of Timberland into Datastage jobs

Environment: IBM Infosphere Datastage 8.5 Designer, Director, Administrator , IBM DB2/UDB, SAP Developer 7.30, ESP scheduler, Cognos, Unix, IBM Datastudio

Confidential

Sr. Datastage Developer

Roles and Responsibilities

• Write technical procedures and documentation for the applications including operations, user guide, etc
• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Participated in meeting with business users and subject matter experts to understand business requirement and design banking metrics.
• Worked with DataStage designer to design jobs with various stages, like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, and Remove Duplicate Stages
• Sourced data from MSSQL, Oracle, XML and .csv files and performed calculations and manipulation to the data.
• Created tables in oracle and stored the data from the jobs.
• Work with banking team to understand their requirement and views of the report then worked with SQL Reporting team and provide input for the report.
• Migrating parallel jobs from Datastage 7.5 to Datastage 8.1 and Datastage 8.1 to Datastage 8.7 as per requirement.
• Migrated JIL scripts from legacy versions of Autosys to Autosys 11.3
• Worked along side in creating of Dimensional Model for reporting system using Erwin r7
• Working on a project of migrating MSSQL server to Oracle 11g environment.
• Converted all the MSSQL queries and DDLs of old SQL server to Oracle
• Created tables, views and indexes for the new Oracle server.
• Worked on complex queries and used SQL navigator to write queries
• Worked with business users to validate and compare results against Source system's data and re-load data, if we found any discrepancy.
• Involved in creating Unit Test Plans and System test plans for debugging and testing

Environment: IBM Infosphere Datastage 8.7/8.1/7.5 Designer, Director, Administrator , DB2, Oracle, MSSQL, PL/SQL, flat files, csv files, UNIX, JIL scripts, Autosys 11.3, SSRS, MS Visio, MS-Office, IBM-AIX, SQL Navigator, Putty, Erwin r7

Confidential

ETLDatastage Developer

Roles and Responsibilities

• Involved in scrum meeting for daily status and interacted with Business Analyst to get the business rules.
• Performed requirement analysis with the Team Lead for beter understand the requirements
• Designed and Developed Parallel jobs to extract data from different sources that include Oracle 11g, MSSQL, sequential files, comma separated files and apply business rules to transform the data.
• Developed Parallel and Server jobs for the entire cycle from pulling source of records to loading into target, where we first load to staging Layer, then Integration Layer and then semantic layer.
• Extensively used Oracle Connector stage, Oracle Enterprise stage, Stored Procedure Stage, sequential stage and Data set.
• Implemented slowly changing dimension type -2 using SCD stage in 8.1, Change Capture Stage in 7.5.
• Used Processing stages Join, Lookup, merge, Transformer, Surrogate key Generator, Modify, Filter, Funnel, Copy, Sort, Aggregator and Remove Duplicate Stages during ETL development.
• Extensively worked on Sequences in the project using Job activity, Execute Command, User Variables, Start loop, End loop, Sequencer, Exception Handler, Terminator activity.
• Implemented the Add checkpoints, automatically handle activities concepts in sequences.
• Implemented the multiple instance option, before job sub routine, after job sub routines.
• Developed Parallel Shared Containers for the jobs to store the common logic and use them across different parallel jobs in the project.
• Worked with Pentaho reporting team to create reports.
• Created Parameter sets in the project developed Unit Test Cases for the jobs.
• Extensively worked on performance tuning of parallel jobs, reducing the number of stages, using appropriate stages and partitioning techniques.
• Extensively used Information Server Manager to build and deploy packages from Dev environment to Integration Testing environment.
• Used Autosys to schedule the jobs.
• Worked on Pentaho Data Integration as the company was planning to replace Datastage with PDI
• Defined test scenarios and making sure all funcationalities are working accorsing to the planned scenario.

Environment: Ascential Datastage 7.1/7.5 Designer, Manager, Administrator, Director , Pentaho Data Integration, Oracle 9i/10g, MSSQL Server 2005, UNIX, Windows Server 2008/2003, PL/SQL, SQL, T-SQL, C/C , Visual Basic 6.0, Sun Solaris, ESXi VMWare , MS proxy server, NetApp Storage, VMWare View, vSphere, Putty, Toad, Pentaho Report Designer

Confidential

Oracle/ETL Developer

Roles and Responsibilities

• Understanding existing business model and Translate Business Requirements into ETL jobs.
• Implemented Extract, Transformation, and Load ETL functionality for Enterprise Data Warehouse and Data Marts using Datastage designer.
• Handled Complex Transformations of large volumes of Data from multiple Data sources using Datastage Designer.
• Developed various Datastage jobs, Shared containers, Routines and Transformations to migrate data from various Legacy systems to the new database.
• Involved in creating Unit test plans and System test plans for debugging and testing individual datastage jobs and Entire system.
• Worked with Datastage Manager to import and export jobs, while moving code into Production Env.
• Worked with Datastage Director to Run jobs, Monitor and check log files.
• Implemented Slowly Changing Dimensional tables in different Data Marts.
• Involved in implementation of UNIX shell scripts to process and copy Flat Files among different servers, to invoke PL/SQL scripts and DataStage jobs.
• Set up roles, grants and privileges for the application and database users.
• Involved in Building Data warehouse Using SQL, PL/SQL and SQL Loader
• Prepared Production Support documents, Monitoring production jobs, Resolve data issues and document them.

Environment: Ascential Datastage 6.0 XE , Oracle 9i, PL/SQL, SQL Loader, MS SQL, UDB, UNIX, Shell Scripting, Autosys, Windows NT 4.0/2000, Visual Basic 5.0