PROFESSIONAL SUMMARY:

• 8 years as an IT Professional with expertise in Requirement Analysis, Design, Development and Implementation of Data warehouse and Data Integration Projects.
• Experience in ETL Architecture, Development, enhancement, maintenance, Production support, Data Modeling, Data profiling, Reporting including Business requirement, system requirement gathering.
• Experience in Designing, Developing, Documenting, Testing of ETL Jobs and mappings in both Sequence jobs and Parallel jobs using DataStage to populate tables in Data Warehouse and Data marts.
• Experience in using various versions of IBM InfoSphere DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Experience in Data Modeling (Entity Relationship) for OLTP and OLAP and Data Warehousing environment.
• Experience in developing complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Sequential File, Aggregator and Modify Stages.
• Experience in writing, testing and implementation of the Triggers, Procedures, Functions at Database level and form level using PL/SQL.
• Experience in troubleshooting of DS jobs and addressing production issues like performance tuning and fixing the data issues.
• E xperience in maintaining the versioning and deployment instruction documents while moving the code to various environments.
• Experience in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
• Experience in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Experience in integration of various data sources like Oracle, Teradata, DB2, Netezza, SQL Server, MS Access and Flat files into the Staging Area.
• Experience with UNIX shell scripting for File validation.
• Experience with Version control utility such as TFS, PVCS and SVN T ortoise.
• Extensive knowledge in Automation scheduling tools like AutoSys, Control - M and TWS.
• Experience in Financial and Health care organizations involving increasing volume and complexity of data.
• Experience in Converting the Business Logic into Technical Specifications and experience in loading high volume data, and performance tuning.
• 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: IBM InfoSphere DataStage v 9.1/8.7/8.5/8.0.1/8.1 , Ascential DataStage 7.5, Quality Stage, Information Analyzer (Profile Stage), and Fast track, Business Glossary and Metadata Workbench, PG Admin III.

Databases: Oracle 11g/10g, Teradata, DB2, Netezza, SQL Server 2008

Languages: SQL, UNIX Shell Scripts, C, C++, HTML, XML, VB 5.0/6.0, .NET

Data Modeling: Erwin 3.5.1/4.2, Power Designer 6.0/9.5, MS Visio

Other Software: TOAD, Microsoft Office, Secure CRT, SQL Server, Teradata SQL Assistant

Versioning Tool: PVCS, SVN tortoise

Scheduling Tools: AutoSys, Control-M, Tivoli Workload Scheduler

Operating Systems: IBM UNIX AIX5.2, HP UNIX 10.2,Windows 9x/2000/NT/XP, 2003/2008 Windows Server, Solaris 2.8/SunOS5.8, Red hat Linux AS

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. ETL DataStage Developer

• Prepared the required application design documents based on functionality required.
• Used DataStage Parallel Extender stages namely Sequential, Lookup, Change Capture, Funnel, Transformer Stage, Column Export stage and Row Generator stages in accomplishing the ETL Coding.
• Developed Teradata SQL Queries to Load data from Teradata Staging to Enterprise Data warehouse
• Extensively worked on Error Handling and Delete Handling.
• Designed and developed the jobs for extracting, transforming, integrating, and loading data using DataStage Designer.
• Used the DataStage Director and its run-time engine to monitor the running jobs.
• Involved in performance tuning and optimization of DataStage mappings using features like partitions and data/index cache to manage very large volume of data.
• DataStage Development activities for loading data into data warehouse using SQL, ORACLE, DB2, Netezza Database and Working on DataStage Version's and UNIX.
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Extracted the data from the data warehouse using Business Object for reporting purposes.
• Used Surrogate Keys to keep track of Slowly Changing Dimensions (SCD).
• Extensively used Pivot stage to pivot the source data to achieve required table structures like converting data from rows into a column.
• Used Extensively Tivoli Workload Scheduler to schedule the jobs and to monitor the jobs.
• Developed unit test plans and involved in system testing.

Environment: IBM InfoSphere Information Server 9.1/8.7/8.5, HP UNIX, Teradata, Netezza, C/C++ and T W Scheduler

Confidential, Tampa, FL

Sr. DataStage Developer

• Involved in meetings with the Business Analysts to collect the requirements, analysis and implementation of it and prepared Specification documents for EDW process
• Worked with Project Lead, Technical Lead and Functional analysts to understand the functional requirements and from there designed the Technical specifications
• Developed the jobs that generate output csv files.
• Extensively worked on plug-ins like stored procedures.
• Extensively worked with Join, Look up and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes
• As a DataStage Developer I created both Parallel and server jobs and also Sequence jobs.
• Used the Client components Designer, Director and Administrator
• Created the user variables that required for the jobs.
• Also used UNIX scripts in file moving, scheduling jobs, removing null from the Flat files.
• Implementing performance-tuning techniques along various stages of the ETL process.
• Following up deployment process of DataStage code migration on different environments (Development, Test and Production) with admin team.
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins
• Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.

Environment: IBM InfoSphere Information Server 9.1/8.7/8.5, HP UNIX, Oracle 11g, C/C++, PVCS, Secure CRT, Red hat Linux AS

Confidential, Detroit, MI

DataStage Developer

• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using DataStage Server/PX combination of jobs.
• Sourced data from various sources like DB2 UDB, Flat Files and CSV files
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Remove Duplicates, Filter, Dataset, Lookup File Set, Change Data Capture, Switch, Modify, Aggregator, DB2 Enterprise, and DB2 API.
• Involved in developing DataStage Designer- Server and PX jobs for Extracting, Cleansing, Transforming, and Integrating /Loading Data into Data Warehouse
• Developed User Defined subroutines using Universe BASIC to implement some of the complex transformations, date conversions, code validations and calculations using various DataStage supplied functions and routines.
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing (Pipeline and partition parallelism), Restorability techniques to improve job performance while working with bulk data sources.
• Created projects using DataStage Administrator.
• Changed user group assignments.
• Unlocked the jobs from administrator and director.
• Extensively used DataStage Director to Monitor and check the run statistics of the Jobs.
• Extensively used DataStage Manager to Export/import DataStage components.
• Extensively used SQL tuning techniques to improve the database read performance through DataStage Jobs and used Frame Work approach to improve transformation and loading steps.
• Involved in Unit Testing, System Testing, Integration and Performance Testing of the jobs.
• Involved in the Execution and creation of Test Plans Test scripts and job flow Diagrams
• Worked closely with Data Quality Analysts and Business Users for data accuracy and consistency after table loads.

Environment: IBM InfoSphere Information Server 8.1, oracle 10g, DB2 UDB 9.1 Enterprise Edition, Redhat Linux, Autosys 4.5, Connect Direct Putty, Microsoft Visio, Microsoft Project server, Microsoft Portal, Clear Quest,, Microsoft Office(Excel, Word and Power point), Acrobat distiller, Clear Case.

Confidential

Jr. IT Developer

• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into Database (DB2 UDB RDBMS).
• Worked with DataStage Manager to import/export metadata from database, jobs and routines between DataStage projects
• Used DataStage Director to schedule, monitor, cleanup resources and run job with several invocation ids.
• Used DataStage Administrator to control purging of Repository and DataStage client applications or jobs they run, cleanup resources, execute TCL commands, move and manage or publish jobs from development to production status
• Wrote Batch Jobs to automate the System Flow using DS Job Controls with restart-ability to of jobs in a Batch.
• Developed user defined Routines and Transforms by using DataStage Basic language
• Used TCL commands in DS Jobs to automate Key Management of surrogate keys and used DataStage Command Language 7.0
• Developed DataStage server jobs using Sequential File, Hash File, Sort, Aggregator, Transformer, ODBC, Link Collector/Practitioner stages
• Designed several DataStage parallel jobs using Sequential Lookup File set, Join, Merger, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter and Pivot stages.
• Extensively used Teradata Load and Unload utilities such as Multi Load, Fast Export and Bulk Load stages in Jobs for loading/extracting huge data volumes
• Developed various SQL scripts using Teradata SQL Assistant and used some of them in DS Jobs with BTEQ Utility and some used in Teradata Stages as SQL override
• Involved in Unit testing, System and Integration testing
• Wrote UNIX shell Scripts for file validation and scheduling DataStage jobs

Environment: DataStage 7.1/7.5,/8.1 Teradata V2R5.0, IBM AIX 4.1.8