SUMMARY

• Eight (8) Years of Dynamic career reflecting pioneering experience and high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM WEBSPHERE DATASTAGE 8.5,8.0.1 and 7.5 versions.
• Has extensive working experience in Data stage and Oracle 10g SQL, Teradata and UNIX
• 6 months of hands on experience on Informatica Power Center 6.0.
• Experience in designing/developing complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and Normalizer.
• Strong experience in designing parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML.
• Analyzed data with discrepancies through error files and log files for further data processing and cleansing.
• Created Test Plans and Test Scripts for unit testing and integration testing
• Worked on performance tuning and enhancement of Data Stage job transformations.
• Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems.
• Experience in Tuning Data Stage jobs
• Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, CDC (Change Data Capture) and Surrogate Key Generator in the process of loading Dimension and Fact tables.
• Extensively worked on Job Sequences to control the execution of jobs flow using various activities like Job Activity, Email Notification, Sequencer and Exec Command.
• Involved in understanding business process and coordinating with business users to get specific user requirements.
• Hands on Experience on Data stage Administrator.
• Work experience in Life Sciences and Man Log domains.
• Worked under UNIX environment.
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Good verbal and written communication skills.
• Good interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment.

TECHNICAL SKILLS

Data Warehousing: IBM Web Sphere Data Stage 8.5/8.01/7.5 (Designer, Director, Manager, Administrator), Parallel Extender, Info Sphere Information Analyzer, Informatica Power Center 6.0.

Data Modeling: Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions, Physical and Logical Data Modeling.

Databases: Oracle 10g/9i, Teradata 14.00/13.0,MS Access

Tools: TOAD, SQL*Developer, SQL*Plus

Programming: SQL, PL/SQL, Unix Shell Scripting, C, Java

Scheduling Tools: Autosys, Cron

Version Control: CVS, PVCS, AccuRev 5.3

Others: MS Excel, MS Office, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

ETL Lead Developer

Responsibilities:

• Involved with Business users and ETL Leads from different teams to implementETL Frame WorkusingDataStage Parallel jobs and migration of data from various sources.
• Extracted data from various sources likeOracle Database, Flat Files, CSV filesand loaded to target warehouse.
• Performed OLTP/OLAP System Study, understanding Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
• Point of contact for Prod Support system in triggering the loads and ensure the data is available to the reports team
• Analyse the PROD data in case of discrepancies if any, to get the defect/bug fixed.
• Implemented various strategies forSlowly Changing Dimensionsusing Data stage Parallel jobs.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup file Set, Remove Duplicates, Change Data Capture,Switch,Modify, and Aggregator.
• Developed Job Sequences for automating and scheduling the DataStage Jobs.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata).
• Created Shell scriptsfor scheduling the Datastage jobs using wrappers.
• Involved in preparing test cases and Reporting bugs in the design / configuration and fixing
• Involved in preparation of scripts and their deployment in Development and System Test environments.
• Extensively worked on scripts to schedule jobs to run from Autosys.
• Extensively used Basic Teradata Query Utility (BTEQ) for executes SQL commands.

Environment: IBM Web Sphere DataStage 8.5 Parallel Extender, Web Services (Designer, Director, Manager), Teradata 14.00, ORACLE 10g, UNIX, Windows, Auto sys.

Confidential

Sr. ETL Developer

Responsibilities:

• Extracting, Transforming and Loading data into Teradata tables using DataStage as ETL tool by applying various business rules.
• Used DataStage Manager for importing metadata from repository, creating new job categories and new table definitions.
• Extensively worked on difference source systems for extraction of data, DB2, CFF,Mainframe, .csv are some of the heterogeneous sources.
• Extensively involved in analyzing the data for each load (Weekly/Monthly) and working with the Business group to modify or re-define the transformation rules due to discrepancies in the data.
• Creating and using the data sets for testing and debugging the jobs.
• Creating Sequencers for executing the jobs in batch and combining different job interfaces.
• Creating email notifications in Sequencers for emailing the error logs, exceptions and job status.
• Writing Shell Scripts and scheduling Jobs using Autosys.

Environment: IBM Web Sphere DataStage 8.5/8.0.1 Parallel Extender, Web Services(Designer, Director, Manager), Teradata 13.0, ORACLE 10g, UNIX, Windows, Auto sys, PVCS.

Confidential

ETL Developer

Responsibilities:

• Involved in design POC for the Data mart to have less impact on down streams
• Involved in design POC of loading the data to fact table in parallel to make the load to finish in less time
• Involved in design and development in Data stage jobs and test the same.
• Involved in preparation of scripts and their deployment in Development and System environments.
• Involved in preparation of the UAT test scripts and executing the same in System Test
• Worked as a Module Lead for this project
• Involved in UAT/OAT support with the production support team.
• Preparing HLD documents such as Deployment document, SOP document.
• Key member handling the UAT, Implementation and Warranty Support
• Analyze the business requirements and the type of input (data) needed for the tool.
• Understood the source systems and collected requirements from business users.
• Interacted with the project / business team to understand the business process, and data requirements.
• Interacted with the Business Analyst for design of Fact and Dimension tables.
• Involved in Jobs development using Data Stage Designer tools (Designer, Director Manager) to create the Jobs, and schedule them on Data Stage Director.
• Extracting data from ORACLE Database and apply transformation logic and Interacted with business users in gathering project requirements and created mapping documents.
• Fetched data from EBCDIIC format to convert into ASCII format using FTP protocol.
• Created complex jobs for cleansing, transforming and loading data into warehouse.
• Involved in design of Data Mart for analytical processing as part of decision support.
• Also involved in Production Support, Maintenance, Enhancements and Change Control implementations.
• Used most of the Stages such as the ODBC, Aggregators, lookups, Filters, Surrogate Keys, and Update strategy.
• Created local and shared containers to facilitate ease and reuse of jobs.
• Took the backups of the Jobs developed using DataStage Manager Export/Import utility.
• Involved in development of job sequencing using DataStage Sequencer.

Environment: Ascential DataStage 7.5, Designer, Director, Manager, Oracle 9i, PL/SQL, Toad, CVS

Confidential

ETL Developer

Responsibilities:

• Analyzed the Functional Requirement documents and explained the desired functionality to the developers.
• Involved in writing Test Plan and Test Cases for different Stages and Plug-ins.
• Worked on different Processing stages like Lookup, Aggregator, Change Capture, Copy, Sort, Merge and Joins.
• Created and Executed Parallel Jobs, Server jobs and Sequence Jobs using DataStage.
• Written and executed Database queries for verification of dataflow.
• Scheduled the Jobs using DataStage Director.
• Involved In Sanity Testing, Functional Testing, Regression Testing, Integration Testing and System Testing.
• Actively participated in doing the Major / small / Emergency projects which comes as a new development or enhancements project request.
• Developments of complex jobs using Datastage for ETL.
• Fine-tuning of the job for faster loads.

Environment: DataStage7.5, Web sphere, Oracle 9i, Unix.

Confidential

ETL Developer

Responsibilities:

• Understanding existing business models & customer requirements.
• Importing Source/Target tables form the respective databases and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Changed various mappings using transformations like Lookup (Connected and Unconnected), Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation for applying PI logic in Everest Mappings.
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center 7.1.2.
• Generation of Reports using Business Objects 6.0
• Involve in documenting the existing logic.
• Involve in Code Reviewing and Code Rework.
• Involved in Unit Testing.
• Involved in System Integrated Testing.

Environment: Informatica 6.0/7/.1.2, Oracle 8i.