SUMMARY

• Over 8 years of experience with Data Warehousing, ETL, Mapping, Data analysis, and modeling.
• Over 8 years of experience with Datastage 11.3/8.5/8.0/7.5 (Datastage Designer, Datastage Manager, Datastage Director).
• Proficient in Data analysis, Data modeling, Database design and Data migration.
• Experience in extracting data from various database sources like Teradata, Oracle 11g/10g, DB2, Flat files, SQL server.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Used Fast load and Multi load techniques to load and manipulate Teradata.
• Experience in using different types of stages like Transformer, Aggregator, Merge, Join, Lookup, Sort, Shared containers for developing jobs.
• Used Datastage Director extensively to run, schedule, monitor, debug and test the application on development and to obtain the performance statistics.
• Developing Datastage jobs using the star schema and snowflake schema modeling and conversant with Data Warehouse concepts like fact tables and dimension tables.
• Modeled Parallel as well as Server jobs using various stages of Datastage.
• Proficiency in Data Warehouse concepts and principles involving Star schema, Snow Flake modeling, identification of fact and dimension tables.
• Experience in designing Sequences, Exception handling and have used various stages like exception handler, sequencer, terminator stage.
• Diverse knowledge of data dependencies using Metadata of Datastage and preparing job sequences for existing jobs to facilitate scheduling of multiple jobs.
• Experience with Performance Enhancement and Trouble Shooting of Datastage jobs.
• Experience in working on operating systems like UNIX and Windows.
• Experience in writing SQL queries, stored procedures and functions.
• Expertise in writing UNIX shell scripts and scheduling them.
• Knowledge with Informatica.
• Participated in discussions with the Project Manager, Business Analysts and Team Members on technical or business requirements
• Excellent communication and presentation skills.

TECHNICAL SKILLS

ETL Tools: Datastage 11.3/8.5/8.0/7.5 (Administrator, Director, Designer), Server and Parallel jobs, IBM Infosphere, Quality Stage.

Data Warehousing: Data Marts, OLTP, OLAP, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snow Flake schema, Slowly Changing Dimensions.

Database: Oracle 11g/10g/, SQL Server, Teradata 13, DB2 9, Informix11, DB2 UDB, Netezza.

Programming Languages: SQL, PL/SQL, C, C++, UNIX shell scripting.

Packages: MS Office.

Operating Systems: Windows XP/Vista, Windows 2000/2003, IBM AIX.

Reporting tools: Crystal Reports

Other Tools: Tidal, SQL*Plus, SQL Loader, TOAD, Teradata SQL Assistant, QMF.

Web Technologies: HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. ETL Developer

Responsibilities:

• Involved in two Datastage upgrade projects and a conversion project from WBI to Datastage.
• Designing the jobs for the necessary interfaces to support East Peoria Go Live Project.
• Coordination of the data movement from SAP to Mainframe and transforming the data as per the requirement.
• Code review the jobs for different Teams.
• Worked on Migration project from Cluster to GRID environment.
• Worked with BAPI's and IDOC's to read the data or to load into them.
• Integrating data from different databases like Teradata, DB2 and flat files and loading them to the target systems.
• Experience in reading or sending through WebServices.
• As a Migrator, involved in migrating the jobs to different environments and maintained the versions in CVS versioning tool.
• Experience in creating and debugging the Tidal jobs.
• Involved in configuring the connections of the IDOC's in the environments.
• Experience in writing UNIX scripts to manipulate the files.
• Built environmental variables and involved in building the new project with these by exporting them and importing.
• Good coordinator in getting Teams together for completion of the Project on time.
• Increasing the performance of the already existing interfaces to read in huge amount of data.
• Monitoring of the tickets in Remedy and take appropriate action.
• Migrating the jobs from Cluster to Grid environment and configuring them with respective variables to make them run on the environment.
• Used SAP Logon Pad to run different transactions and created some Test data for the outbound Idoc's.
• Involved in Data Profiling and to suggest how the data is related and the best way to extract it.
• Provide support to the Production jobs and take action as per the priority.
• Break Fix for the jobs and the necessary documentation to be done when moving them to the Production.
• Defined Tidal jobs and scheduled the DataStage jobs to run at different calendars.
• Coordinating with the Functional team to gather the information and to test the jobs for SIT, Regression or UAT.
• Monitoring HPQC for the defects and to resolve them in the order of priority.
• Fix the Defects which are assigned and modify the jobs with the new changes proposed as per the Functional Specification for the Release's.

Environment: IBM Infosphere Datasatge 11.3/8.5, IBM DB2, Oracle, Teradata 13.11.03, CVS, SAP, Tidal, AIX UNIX, SQL, Putty, Tidal, Windows XP.

Confidential, IL

Sr. ETL/Datastage Developer

Responsibilities:

• Involved in loading data to Star Schema from EDW.
• HIPPA standards are maintained in involving the extraction of the data.
• Huge volumes of data is loaded to the dimensions through Teradata Fastload or Multiload techniques.
• The data is analyzed and profiled for the mapping purpose.
• As a Sr. Developer was involved in defining the number of jobs and in the development of the design of the jobs.
• Used different stages of the Datastage like Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Row Generator, Peek from various databases.
• Data is read from Teradata tables and different load techniques were involved in reading the data from these.
• Involved in integrating the data from different States for the company.
• Involved in performance tuning and Unit testing of the jobs.

Environment: IBM Infosphere Datasatge 8.5, Teradata 13.11.03, Teradata SQL Assistant, Unix AIX, QMF, SQL, Putty, Windows XP.

Confidential, AR

Sr. ETL/Datastage Developer

Responsibilities:

• Developed jobs to extract data from different databases for SAMS and Confidential from different countries to support BI reports.
• As a lead member of ETL Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications.
• Involved in Pharma and Merchandise projects.
• The data extracted is validated and analyzed for any data quality issues.
• Data is extracted from Teradata or loaded into Teradata tables using Connector.
• Teradata is queried through Teradata SQL Assistant to determine the consistency of the data.
• Used Datastage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• The data extracted needs to be aggregated or looked up or joined depending on the requirements.
• Experience in developing jobs to maintain the history of the data.
• Used Teradata tables as reference table to get the data.
• Involved in writing SQL queries.
• Used SVN Checkout for migrating the jobs to different stages.
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Created shared containers to simplify job design.
• The jobs are optimized by staging the data in datasets.
• Involved in writing the UNIX scripts for deleting the datasets or for moving the files from one location to another.
• Experience in developing purge and the maintenance jobs.
• Knowledge with XML packages.
• Involved in Unit and System testing.
• Experience in migrating the objects from DEV to QA and PROD environments.
• Experience in designing the Diagnostic jobs for verifying the connections of the databases.
• Used FTP to transfer the logs to the desired location for the access to the team.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.
• Experience in coordination with offshore team.
• Experience in Unit testing of the jobs.

Environment: IBM Infosphere Datasatge 8.5, Teradata 13.11.03, DB2 9, Informix 11, Teradata SQL Assistant, UNIX AIX, QMF, Putty, SQL, Windows XP.

Confidential, FL

Sr. ETL/Datastage Developer

Responsibilities:

• Implemented Change Data Capture for Datastage jobs to process only incremental Loads.
• Developed Parallel Extender jobs for loading Target Database.
• Exported and imported DataStage components using DataStage Manager. Used DataStage Designer to develop DataStage jobs, scheduled the jobs through DataStage Director.
• Involved in extracting and integrating data from SAP systems using Server Pack for SAP R/3.
• Participated in Design, Source to Target Mappings between sources to operational staging targets using Star Schema.
• Involved in extracting the data from XML files and loading into the databases.
• Involved in reading data from XML using different XML stages.
• Extensively used Lookup, Join, Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Row Generator from various databases.
• Used stage variables in performing derivations and set up conditions to filter records based on the constraints.
• Performed Unit and System testing on the jobs designed.
• Queried the databases through SQL to check for the consistency of the data.
• Created Datastage jobs, batches, job sequences and tuned them for better performance.
• Developed jobs with multiple Look - ups and maintained the integrity of the data mart in accordance with the requirement.
• Knowledge with PeopleSoft EPM.
• Documented jobs using annotations and following naming standards for code maintenance.
• Involved in meetings with team members to resolve the issues and optimize the performance.
• Handled error messages from the XML stages.
• Worked extensively on performance tuning.
• Knowledge with Oracle 11g.
• Used PL/SQL for writing stored procedures and triggers.

Environment: IBM Infosphere Datastage 8.5.1/8, SQL Server2005, SQL, PL/SQL, SAP, Oracle 10g, UNIX, Windows XP, XML, Autosys.

Confidential, WA

ETL/ Sr. Datastage Developer

Responsibilities:

• Used DataStage as an ETL tool to extract data from sources systems to Target system.
• Designed complex DataStage mappings between sources (external files and databases) to Operational staging targets using Oracle as the target database in Data Warehouse.
• Involved in integrating data from Teradata using utilities like Multiload, Fastload.
• Involved in giving access to the developers.
• Used DataStage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• The data loaded is verified.
• Developed several transformations in the process of building Data warehouse database.
• Worked on retrieving data from different legacy systems such as Oracle, DB2.
• Used Lookup transformations to manipulate the information.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Involved in integrating data from different sources like Oracle, Netezza.
• The procedures are called through STP stage. The procedures are customized as per the job requirements.
• Worked on Universe Database to create Hash Files, Intermediate files while ETL process.
• Interacted with User Groups/ Corporate Testing Groups/Business people.
• Developed shell scripts to automate file manipulation and data loading.

Environment: Ascential DataStage 7.5, Designer, Manager, Netezza, Sybase, Oracle 9i/8i, DB2, PL/SQL, SQL Loader, Business Objects 5.0, AIX, UNIX, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Extensively used DataStage as the data migration/transformation tool for Corporate Data Warehouse application.
• Designed the logical and physical data warehouse schema. Analyzed source systems and creating a mapping to the target database schema.
• Extensively used Fast Load, Multi Load utilities in Teradata.
• Extracted data from Teradata applied Transformations and loaded in to Oracle Database.
• Involved in Design Development and Deployment of DataStage Server and PX jobs, and used FTP stage extensively.
• Extensively worked with Parallel Extender using Parallel Processing.
• Extensively used DataStage Designer to design and develop Server and PX jobs to migrate data from transactional system (Oracle 9i) into the Data Warehouse.
• Worked closely with Business Analysts to understand business rules and developed Prototype jobs. Created many parallel jobs and parameterized the jobs for optimization.
• Extensively developed Server/PX Shared Containers for Reusability.
• Used DataStage Director to monitor the Job run statistics.
• Extensively used DataStage Manager to Export/Import DataStage Job components and Import Plug in Table Definitions from Oracle database.
• Created Unix Shell Scripts as wrappers to automate the process of running DataStage jobs and to track DataStage Job logs and Script logs.
• Provided Support to various groups to design and develop ETL job flow using DataStage and Shell Scripts.
• Worked closely with Data Analysts to make sure the data is accurate and consistent for table loads.

Environment: Data Stage 7.5, UNIX, Windows, Sun Solaris, DB2 UDB, Oracle 9i, Teradata, SQL, SQL* Loader, and Windows NT.