Summary

• 7 years of IT experience in full life cycle implementation of Data Base and Data Warehousing solutions including Data Modeling RDBMS/Dimensional , Design, Mapping, Extraction, Migration and development of ETL components and integrating with external systems.
• Highly adaptive and a proven ability to work in a fast paced multi tasking environment with excellent time management and analytical skills.
• Extensively worked with IBM Information Server 8.0.1/Ascetical DataStage Enterprise Edition PX/7.5/7.0, Websphere DataStage IIS Suite 8.X , Server Edition 5.X.
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration.
• Extensive experience in low level and high level design mapping document for designing DataStage jobs.
• Excellent knowledge and experience to implement STAR and Snowflake schemas, and slowly changing dimensions in Datamarts.
• Excellent knowledge and experience to load data in Conformed Dimensions and Fact table in Datamarts.
• Experienced in Conceptual, logical and physical design of relational databases in MS Visio and ERWin.
• Involved in the design of ETL architecture, code reviews of DataStage jobs and implemented best practices in DataStage jobs.
• Created DataStage Parallel/Server Jobs to Fact and Dim Tables.
• Extensively worked to Design the DataStage parallel jobs, Server jobs, job sequences and Shared Containers to implement the business requirements and design specifications.
• Extensively used reusable objects and interfaces.
• Extensively worked with XML File to extract the data using DataStage.
• Experience with SalesForce.com.
• Extensive experience in designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.
• Extensively worked with DataStage administrator to create a project, define global variables etc.
• Experience with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Performed debugging, troubleshooting, monitoring and performance tuning using DataStage.
• Experience in source systems analysis and data extraction from various sources like Flat files, SalesFroece.com, Oracle 8.x/9i/10g/11g, DB2, UDB 9.0, MS SQL Server 2005/2008.
• Extensively worked to load data into Teradata using Teradata utilities BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, and TPUMP.
• Created database objects like Tables, Indexes, Views, Trigger, Stored Procedure, User Defined Functions etc.
• Extensively worked to write complex SQL using joins, sub queries and function.
• Experience to create Indexes to improve query performance.
• Designed and Developed UNIX shell Scripts for archiving/pursing files, FTP files, pursing dataset and scheduling Data Stage jobs.
• Experience in writing DataStage batch routines using DataStage Basic Language.
• Experience in writing complex SQL to extract data from source system and data validation etc.
• Extensively worked with writing the test scripts, test plans and test cases for testing of the project.
• Experience to migrate ETL code in different environment like DEV, QA and PROD through SVN version control tool.
• Proficient in using DataStage Director and Autosys to schedule Jobs.
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Experience in designing, creating, processing of cubes using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Excellent communication, client interaction, analytical, interpersonal, problem solving skills, fast learner, hardworking and strong ability to perform as part of a team.
• Providing 24/7 data warehouse production support in time pressured business environments.

Technical Skills

IBM DataStage 8.1/7.1/7.5/EE Parallel Extender, DataStage Server Edition, Oracle 11g/10g/9i/8i/8.0/7.0, SalesForce.com, DB2 UDB, MS SQL Server 2005/2008, SSAS, MS -Access 2000-2010, Windows XP/2007, Teradata, UNIX/AIX, Autosys, T-SQL, PL/SQL, UNIX Shell Scripting, TOAD, Erwin 4.0, Visio 2010

Professional Experience

Confidential DataStage Developer

Responsibilities:

• Interacted with end users in finalizing the requirements and documented the Program Specifications for the ETL jobs
• Designed mappings document between sources to targets, using Star Schema, Implemented logic to Slowly Changing Dimensions.
• Created meta model for data mart using ESP.
• Prepared LLD for ETL process.
• Developing ETL Interfaces for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Surrogate Key, Aggregator, Transformer, Row Generator stages.
• Extensively worked with Join, Look up Normal and Sparse and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Created and used parameter set in parallel jobs.
• Developed share container for reusable purpose.
• Parameterized DataStage jobs and also created multi-instance jobs.
• Created Master Job Sequencers to control sequence of Jobs using job controls.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Data stage Parallel jobs.
• Created multi-instance jobs with RCP.
• Created multiple configuration files and defined logical nodes, scratch disk, Resource scratch disk and pools
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Exported and imported ETL code in different environment.
• Wrote complex SQL, PL/SQL, Stored Procedure, Function, Trigger etc
• Wrote complex query to extract and validate data using Squirrel.
• Implemented de-dup and duplicate check logic for remove duplicate.
• Developed UNIX Shell script to file watcher, FTP files, pursing files etc.
• Documented ETL test plans, test cases, and validations based on design specifications for unit testing.
• Experience with Scheduling tool Autosys for automating the ETL process.

Environment: Websphere DataStage 8.5, 8.1, 7.5, DB2 UDB, Oracle10g, Server 2008/2010, SSAS, IIS, MS Access, UNIX/AIX , MSOffice Suite, Erwin 4.1, MS Visio 2010, Toad, Autosys.

Confidential Sr. DataStage Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Prepared source to target mapping document according to business requirement.
• Prepared low level design document for ETL Process.
• Created ETL best practices and standard document.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Developed complex Data Stage jobs for loading data into data mart using aggregate, filter, funnel, Change Capture ,join, remove duplicate , lookup, modify, dataset, sequential file, Surrogate Key, Transformer, Decode, etc
• Used appropriate partitioning method in DataStage jobs.
• Implemented type 2 slowly changing dimension.
• Extensively used data stage stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively worked with Join, Look up Normal and Sparse and Merge stages.
• Created a parallel job to implement business rules and transformations.
• Implemented de-dup and duplicate check logic for remove duplicate.
• Defined Stage variables for data validations and data filtering process.
• Parameterized DataStage jobs and also created multi-instance jobs to achieve reusability.
• Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities and Trigger.
• Extensively worked with Job sequences using Job Activity, Email Notification, Sequencer, Wait for File activities to control and execute the Data stage Parallel jobs.
• Extensively wrote Routines and Transformer functions.
• Worked on performance tuning to address very critical and challenging issues.
• Used job monitor, score dump, peak stage, performances analysis, resource estimation to tune data stage parallel job.
• Implemented Audit, balance and control table for ETL process.
• Used Data Stage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Created multiple configuration files and defined logical nodes, scratch disk, Resource scratch disk and pools.
• Wrote complex query to extract and validate data.
• Extensive experience in writing Transact-SQL DDL/DML queries.
• Experience to create database objects like Tables, Indexes, Views, Trigger, Stored Procedure, User Defined Functions etc.
• Extensively worked to write complex SQL using joins, sub queries and function.
• Experience to create Indexes to improve query performance.
• Experience in designing, creating, processing of cubes using SSAS.
• Experience to set up database connectivity from DataStage to source/target database server.
• Wrote UNIX shell scripts to pursing dataset, FTP files.
• Defined UNIX -shell scripts for file watcher and file archiving process.
• Extensive experience in SVN.
• Develop a UNIX script to integrate IIS and SVN to Commit ETL code in SVN repository.
• Developed Autosys Jil to schedule DataStage jobs.
• Migrated jobs from development to QA to Production environments.
• Involved in component integration testing, system integration testing and UAT.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and Measures.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Optimized cubes for better query performance.
• Identified the Measures and Dimensions from the Excel Sheet.
• Involved in release activity.
• Created detail task for release activity.
• Provided 24/7 production support in time pressured business environments.

Environment: Websphere DataStage 8.5, 8.1, 7.5, DB2 UDB, Teradata, SQL Server 2008/2010, SSAS, MS Access, UNIX/AIX , MSOffice Suite, Erwin 4.1, MS Visio 2010, Toad, Autosys, SVN.

Confidential DataStage ETL Developer

Responsibilities:

• Interacted with business analyst to understand the business requirements and in identifying data sources.
• Involved in understanding the scope of application, present schema, data model and defining relationship within and between the groups of data.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Prepaid source to target mapping documents with Transformation rules.
• Converted Logical Mapping Document into source to target Physical Mapping Document for ETL.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse and Datamarts.
• Extensively worked to load data into Teradata using Teradata utilities BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, and TPUMP.
• Implemented start schema and snowflake schema dimension model.
• Developed DataStage jobs to implement slowly changing dimension.
• Imported Metadata from various Application Sources Database tables, SalesForce.com, flat files, XML files into DataStage
• Created DataStage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, etc.
• Defined stage variables for data validations and data filtering process.
• Extensively used parallel stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Extensively worked with Surrogate key generator to generate surrogate key.
• Created multiple configuration files with multiple nodes.
• Developed re-usable components using shared containers for local use or shared use.
• Used schema files, RCP in DataStage jobs.
• Developed multi-instance jobs.
• Parameterized DataStage jobs and also created multi-instance jobs to achieve reusability.
• Extensively wrote Routines and Transformer functions.
• Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities and Trigger.
• Extensively used sequence job stages like job activity, Email Notification, Sequencer, Wait for File activities, start loop end loop, execute command activity, user variable activity, routine activity etc..
• Worked on performance tuning to address very critical and challenging issues.
• Created and modified database tables and indexes. And also granted permission to insert, update delete and select statement.
• Developed UNIX Shell script to run DS jobs, FTP and Name change of the files.
• Developed complex store procedures and queries using temp tables and joins.
• Performed Unit testing, Integration testing, System testing of Data stage Jobs and sequences. Also created test cases.
• Migrated jobs from development to QA to Production environments.
• Used Autosys job scheduler for automating delta run of DW cycle in both production and UAT environments.
• Co-ordinate with SIT and UAT team to fix the Test Problem Reports.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Environment: WebSphere DataStage 8.1, 8.0 Parallel Extender , SalesForce.com, Teradata, DB2 UDB 9.0, Oracle 10g, , MSOffice Suite, UNIX/AIX, Erwin 4.1, MS Visio, Toad, MS Access.

Confidential ETL DataStage Developer

Responsibilities:

• Worked with Business customers to identify the different sources of data in operational systems and developed strategies to build data warehouse.
• Designed mappings document between sources to targets, using Star Schema, Implemented logic to Slowly Changing Dimensions.
• Extensively worked to design and developing Parallel jobs, server jobs and job sequences.
• Used Parallel Extender for distributing load among different processors by implementing pipeline and partitioning of data.
• Developed ETL Interfaces for extracting, cleansing, transforming, integrating, and loading data into data warehouse.
• Extensively used DataStage Active and Passive stages in DataStage jobs.
• Developed ETL coding to load data into data warehouse and data mart using aggregate, lookup, modify, filter, join, remove duplicate , dataset, sequential file, Surrogate Key, funnel, Change Capture, Transformer, Copy, Decode, etc
• Extensively used the CDC Change Data Capture stage to implement the slowly changing Dimensional.
• Implemented de-dup and duplicate check logic for remove duplicate.
• Extensively used sequence job stages like job activity, Email Notification, Sequencer, Wait for File activities, start loop end loop, execute command activity, user variable activity, routine activity etc to developed job sequence to Control and execute DataStage Jobs.
• Designed and developed exception handling and auditing process in packages.
• Created shared containers to reuse ETL code.
• Created multi-instance jobs with RCP.
• Extensively used delivered custom routines.
• Developed UNIX Shell script to file watcher, FTP files, pursing files etc.
• Wrote complex query to extract and validate data.
• Documented ETL test plans, test cases, and validations based on design specifications for unit testing.
• Co-ordinate with SIT and UAT team to fix the Test Problem Reports.
• Experience with Scheduling tool Autosys for automating the ETL process.

Environment: Data Stage 8.1/7.5, UNIX, Oracle 10g, DB2 UDB 9.0, Manual Testing and Test Director, Autosys, Toad, WinSQL, MS SQL Server 2000/2005.

Confidential SQL Server Developer

Responsibilities:

• Worked as a Database Developer for Development, Test and Production servers with MS SQL Server 2000 on Windows 2000/NT 4.0.
• Extensively worked on Customer Information Management Database.
• Creation of Database Objects - Tables, Indexes, Views, Roles.
• Creation of Customized Stored Procedures, Triggers, Cursors.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Developed, deployed and monitored DTS packages to transfer data of customer, personal financial history information from various ODBC driver files to SQL server database.
• Performed Data transfer Import Export using BCP.
• Extensively worked on trouble shooting and performance tuning of DTS packages.
• Created Linked Servers to connect OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Involved in job scheduling using MS SQL server Agent.
• Monitored the performance of Database Server Tuning for Better Performance.
• Performed Full Back up, Recovery and Restoration.
• Optimization of SQL statements for customer summary reports.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL server databases.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2000, writing store procedure, triggers and T-SQL queries, and Windows XP