SUMMARY

• More than 8 Years of IT experience in complete Software Development Life - Cycle(SDLC) of various projects including requirement gathering, system designing, data modeling, application development, enhancement development and support
• Around 7 Years of ETL experience in populating and maintaining Data warehouse and Data marts using DataStage 9.1/8.5 /8.0/7.5/7.1/7.0 (Parallel Extender)
• Experience in developingParallel Jobs, Mainframe Jobs, Shared Containers, Server jobs,Sequence JobsandQuality Stage Jobsusing DataStage
• Experienced in using DataStage Client components like DataStage Administrator, Manager, Designer and Director in Data Warehousing development.
• Worked with Data modeling(Star and Snowflake Schema), Conceptual, Logical, Physical mode, fact tables, dimension tables, Data migration, Data Profiling, Data cleansing, Slowly Changing Dimension, Surrogate key assignments, ETL Processes for data warehouses.
• Used Enterprise Edition/Parallel Edition stages like Datasets, Aggregator, Merge, Join, Lookup, Sort, Pivot, Transformer stage, Filter stage, Modify, Copy, Change Capture, Row Generator and many other stages in accomplishing the ETL Coding.
• Created Mapping Specifications using FAST TRACK tool.
• Experience in Metadata Workbench and Information Analyzer.
• Experience in designing Sequences, Exception handling and have used various stages like exception handler, sequencer, terminator stage.
• Used DataStage Director extensively to run, schedule, monitor, debug and test the application on development and to obtain the performance statistics.
• Experience in working on operating systems like UNIX and Windows.
• Created various parameters and parameter sets for multi-instance jobs and environment variables to be used across the project.
• Experience in Scheduling Jobs using various third party tool like Autosys.
• Extensively worked coordinating with offshore team distributing the work, keep tracking development status and monitor day to day activities.
• Experienced in writing Database Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Experienced in Database Design/Development inTeradata, Oracle 11g/ 10g/9i/8i, DB2 8.x/7.x, SQL Server 2005/2008, Sybase 11/10, VSAM and MS-Access 97/200x.
• Excellent inDocumentation,End-User Trainingand Knowledge Transfer.

TECHNICAL SKILLS

ETL Tool: IBM Infosphere Information Server 8.5/8.0/7.5/7. x, DataStage PX(Parallel Extender), Quality Stage, Fast Track, Business Glossary, Metadata Workbench, Information Analyzer

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, Sybase, Teradata V2R12

Data Modeling Tool: Erwin 4.0/3.5

OLAP Tools: Business Objects, Cognos, Web focus

Languages: SQL, PL/SQL, C, C++, Unix shell scripting, COBOL

Other Tools: TOAD0, Autosys, Control-M, CA SCM, MS Access, Putty

Operating Systems: Windows 2003/NT/XP, MVS Os/390, UNIX AIX/SOLARIS/LINUX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL/DataStage Consultant

Responsibilities:

• Involved in requirements gathering and source data analysis and identified business rules for Data Transformations.
• Designed and developed various ETL jobs to extract, transform and load data from different source systems like Oracle, DB2, Sybase, SQL Server, CSV files and XML files into Datamart Databases and external systems.
• Used DataStage Designer and Director for creating and implementing jobs.
• Created Datastage jobs using different stages like Filter, Funnel, Look up, Join, Merge, Peek, Checksum, Row Generator, Change Data Capture, CFF, XML, Transformer, Aggregator, Sort, Remove Duplicates, Complex flat file, Stored procedure, XML and Database stages.
• Developed Routines, Sequencers and shared containers for reusability and improve the performance in DataStage Parallel Jobs.
• Involved in extracting data from xml sources, binary files using complex flat file and flat files.
• Developed Autosys jil scripts to schedule the jobs in Autosys scheduling tool.
• Involved in writing UNIX shell scripts to automate DataStage jobs/processes and file movement.
• Involved in developing Oracle stored procedures, functions and complex SQL queries.
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Prepared migration process structure for all different environments such as Dev, QA, UAT and Prod
• Created Mapping Specifications using FAST TRACK tool.
• Planned version control of production source code using CA Software Change Manager (SCM) and worked on Rational Quality Manager (RQM) bug tracking tool.

Environment: IBM InfoSphere DataStage 9.1/8.5, Oracle11g/10g, DB2, Sybase, SQL Server 2008, SQL, PL/SQL, Autosys, COBOL, Toad, WinSCP, Web Focus, SCM, RQM, Mainframe, UNIX (Sun Solaris) and Windows.

Confidential, Atlanta, GA

DataStage Developer

Responsibilities:

• Prepared Technical Design Document before building the project.
• Used DataStage Manager for importing Metadata from repository and for creating new job categories and data elements.
• Worked with Teradata while migrating data into oracle 11g using Datastage.
• Extracted data from different source systems and processed using ETL and loaded into the Datamarts.
• Used different stages like Aggregator, Merge, Join, Lookup, Sort, Pivot, Hash, Transformer stage, Filter stage, Modify, copy, Change Capture for fulfilling the project requirements.
• Developed Job sequencers using various stages like JobActivity, Sequencer, Routine Activity, Wait For File Activity, Nested Condition, Exception Handler and Notification Activity
• Worked on Datastage client Components like Datastage Designer, Datastage Manager and Data stage Director.
• Involved in migrating ETL jobs to different environments for Testing.
• Developed Autosys Jil scripts to schedule the jobs in Autosys scheduling tool
• Created Unix Shell scriptsto automate the business processes.
• Used several shell scripts for calling in before and after sub-routines.
• Scheduled the DataStage ETL batch jobs on a daily, weekly and monthly basis through Autosys.
• Prepared Run Documents and Mapping Documents for future use.

Environment: IBM InfoSphere DataStage 8.5/8.1, Teradata, Oracle11g/10g, SQL, PL/SQL, Autosys, Toad, WinSCP, Web Focus, SCM, RQM, UNIX (Sun Solaris) and Windows.

Confidential, Fremont, CA

ETL Consultant

Responsibilities:

• Involved in requirements gathering, data Analysis, impact analysis and system analysis
• Involved in design, development and implementation of Data Warehouse strategies, procedures and recommendations in several areas like enforcing data consistency, data quality, performance enhancement, process improvement, future roadmaps etc.
• Consistently implementing industrybest practicesin the application for ETL design, development standards and procedures.
• Designed and implemented several wrappers to execute the DataStage jobs, create job reports out of the DataStage job execution results from shell scripts
• Developed the audit components, which identify the source and target table records to audit each load.
• Created various parameters and parameter sets for multi-instance jobs and environmental variables to be used across the project.
• Involved in the Performance Tuning of the DataStage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or databases
• Developed efficient mappings for data extraction/transformation/loading (ETL) from different sources to a target data warehouse.
• Worked on Master Data Management(MDM) and Quality Stage
• Developed/Enhanced ETLProcesses to load the data from different source systems including Oracle, SQL Server,DB2, Teradata, MS Access, MS Excel, Flat files into Oracle Datamart using DataStage.
• Developed and maintained several highquality documents, data models, dataflow diagrams, and production support manuals for Datamart.

Environment: IBM Information Server/DataStage 8.1/7.5 Oracle 10g, MS SQL Server 2005, Teradata V2R12, Cognos, MS Access/Excel, XML, Toad, Erwin, AutoSys, Windows 2003/XP and UNIX(AIX).

Confidential, Pleasanton, CA

ETL Developer

Responsibilities:

• Involved inbusiness analysis,data analysisand requirements gathering.
• Developed Job specifications forServer Jobsand Mapping documents.
• Used DataStage Manager for importing Metadata from repository and for creating new job categories and data elements.
• Used different processing stages (Join, Merge, Funnel, Filter, Aggregator, Sort, FTP, and Transformer), file stages (Lookup, File Set, Data Set and Sequential File) and Native Database stages.
• Designed and used ODS (operational data store) and integrated data from multiple sources for reporting purpose.
• Created Unix Shell scriptsto automate the business processes.
• Worked with IBM Information Analyzer.
• Used several shell scripts for calling in before and after sub-routines.
• Scheduled the DataStage ETL batch jobs on a daily, weekly and monthly basis through Autosys.
• Defined and importedmetadata from different sources like Oracle, DB2 and Sequential files.
• Prepared documentation for ETL processes and production support.

Environment: IBM DataStage 7.5 (Designer, Manager, Director), Parallel Extender (PX), Oracle 9i, DB2 ERWIN, MS Access, Toad, UNIX and Windows.

Confidential, Irvine, CA

DW Developer

Responsibilities:

• Actively involved in team discussions to solve the issues in mapping document.
• Prepared Technical Design Document before building the project.
• Used DataStage Manager for importing Metadata from repository and for creating new job categories and data elements.
• Extracted data from different source systems and processed using ETL and loaded into the Datamarts.
• Used different stages like Aggregator, Merge, Join, Lookup, Sort, Pivot, Hash, Transformer stage, Filter stage, Modify, copy, Change Capture for fulfilling the project requirements.
• Developed Job sequencers using various stages like JobActivity, Sequencer, Routine Activity, Wait For File Activity, Nested Condition, Exception Handler and Notification Activity
• Worked on Datastage client Components like Datastage Designer, Datastage Manager and Data stage Director.
• Involved in migrating ETL jobs to different environments for Testing.
• Developed Autosys Jil scripts to schedule the jobs in Autosys scheduling tool
• Created Unix Shell scriptsto automate the business processes.
• Used several shell scripts for calling in before and after sub-routines.
• Scheduled the DataStage ETL batch jobs on a daily, weekly and monthly basis through Autosys.
• Prepared Run Documents and Mapping Documents for future use.

Environment: IBM DataStage 7.5/7.0, Oracle 9i, DB2, Mainframe, Sybase, SQL, Autosys, UNIX and Windows.

Confidential, Pleasanton, CA

Data Warehouse Developer

Responsibilities:

• Used DataStage Tools like DataStage Designer, DataStage Manager and DataStage Director.
• Got the source data in the form of Oracle tables, Sequential files and Excel sheets.
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping
• Imported metadata from repository, created new job categories, routines and data elements.
• Scheduled running testing and debugging of jobs.
• Involved in the Performance Tuning of the DataStage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations, increasing the reading as well as the writing speed while fetching or loading data to files or databases.
• Developed parallel jobs in SMP architecture using Parallel Extender for the speed in performance
• Worked on programs for scheduling data loading and transformations using DataStage from source systems to Oracle 8i using PL/SQL.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Datastage Repository.

Environment: DataStage 7.0, Oracle 8i, SQL Loader, Toad, Putty, Remedy, DB2, UNIX, Windows

Confidential

SQL Developer

Responsibilities:

• Created tables, views, indexes and user defined functions.
• Designed the database to fasten certain daily jobs.
• Involved in performance tuning of SQL queries and Stored Procedures.
• Created data model, logical design, and physical design of the database.
• Developed complex stored procedures to create various reports.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created Database maintenance plans for Database Backups.
• Tested Backup and Recovery Strategies.

Environment: MS SQL Server 2000, Windows 2000, Enterprise Manager