SUMMARY

• Over 7 plus years of experience that includes Business/Requirement Analysis experience in Data Warehousing, Development, Database design and administration, Report Writing, Technical writing.
• Over 7 years of Strong design/development/Testing experience with DataStage, OLAP tools and Data Warehousing (DW).
• Extensive experience in usage and developing strategies for Extraction, Transformation and Loading data from various sources into Data warehouse and Data Marts by using Ascential Data Stage (Designer, Director, Manager and Administrator)
• Worked as a part of a Data Warehousing team that implemented an ODS and Data Marts for storing of Enterprise wide data for the needs of critical reporting assessed by the Company.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Mining, Data Analysis, Decision Support System (DSS) and GUI applications.
• Proficiency in using ERwin tool for creating physical and logical data modeling.
• Experience in integration of various data sources like Oracle, PeopleSoft, IBM DB2, Teradata and SQL Server2000/2005 into staging area.
• Worked with Teradata Loadutilitieslike MultiLoad, FastLoad,BTEQ, And Fast Export.
• Worked on extracting/loading data from/to SAP database using SAP R/3 Package
• Worked with Data Stage Server and Parallel Jobs of DataStage 7.5/8.1/8.5/9.1
• Extensively used parallel extender Joins, Merges, lookups and sorts, Modify, switch, row generator, column generator, funnel, pivot, copy stages etc. for the development of DataStage Jobs.
• Performed Debugging, Troubleshooting, Monitoring and Performance Tuning for DataStage Jobs (server and parallel).
• Experience in usage of Tivoli, Control M and AutoSys job scheduling
• Experience in usage of DataStage and QualityStage, Information Analyzer for maintaining, cleansing and Profiling of Source data.
• Production support for Server and PX jobs on weekly rotational basis.
• Experience in usage of Clear Case and Microsoft visual safe source.
• Extensively tested the ETL’s and used Rally and Test Director for Defects and maintenance.
• Customized the delivered ETL’s from PeopleSoft as per the requirements.
• Created Technical Documents and Business Requirement Documents and Report Design Documents for Document Library.
• Extensively worked with DBA’s, Users, and Clients for issues.
• Experience in Data Mining through exposure to OLAP, OLTP, database administration, data warehouse development, System analysis, Design methods, development, maintenance and implementation.
• Experience in usage of Shell Scripting, perl scripting and loading the data by using SQL Loader.
• Excellent Knowledge of SQL, PL/SQL, Stored Procedures, Function, and Triggers.
• Excellent in communication, presentation and interpersonal skills.
• Worked co - coordinating with offshore team distributing the work, keep tracking development status and monitor day to day activities

TECHNICAL SKILLS

ETL Tools: IBM Information Server 9.1/8.5/8.1/7.5 (DataStage, Information Analyzer, Quality Stage, Profile Stage, MetaStage), Ascential DataStage EE/7.5x - (DataStage Manager, Designer, Director, Administrator, Parallel Extender)

Operating Systems: Windows 2000/NT 4.0 Server, Unix, AIX, HP-UX, Sun Solaris, Windows 95/98/2000/XP and DOS.

Database: Oracle 11g/10g/9i, UDB DB2 9.0, Teradata v2R6 (version 12), SQL Server, Sybase12.0/12.5 and PeopleSoft (HCM/EPM)

Languages: SQL, PL/SQL, SQL*Plus, UNIX Shell Scripting, Perl Scripting

Data Modeling Tools: ERwin 5.1 onwards, Microsoft Visio.

Web/App servers: Netscape Suite, HTML. WebFOCUS.

DB Tools: SQL*Loader, Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD), Toad, PL/SQL developer, Rally, Tivoli, Accurev, ServiceNow, Autosys, Control M, Test Director, ClearCase, Quality Center.

Methodologies: Star Schema, Snow Flake.

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Sr. DataStage Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and project coordination.
• Involved in creating functional and scope documents for ETL processes.
• Integrated data from different sources like
• Estimation, HLD and LLD design documentation.
• Performed detailed data profiling and investigation using Quality Stage.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
• Developed Data Stage parallel jobs to load data from sequential files, flat files and DB2 Server.
• Used Information Analyzer for column analysis, primary key analysis and foreign key analysis.
• Used Quality stage for data profiling, standardization, matching and survivorship.
• Used Data Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts like Account arrangement, involved party.
• Created parameter sets to group Data Stage and Quality Stage job parameters and store default values in files to make sequence jobs and shared containers faster and easier to build.
• Extensively worked on extracting data from Teradata databases and transforming and loading them into Fiserv Db2 BDW.
• Extensively developed real time and near real time BI systems using the DataStage ETL tool, Teradata utilities.
• Penned transformation routines to transform the data according to business requirements.
• Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the production support people better understand the job runs.
• Migrated jobs from the development instance to testing environment.
• Performed Unit and Integration testing and validated the test cases by comparing the actual results with expected results.
• Worked on performance tuning and enhancement of Data Stage job transformations.
• Resolved data issues during the testing processes and reloaded the data with all the necessary modifications.
• Analyzed and enhanced the performance of the jobs and project using standard techniques.
• Used the Data Stage Director and its run-time engine to schedule and run the parallel jobs, testing and debugging its components and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Created data stage scheduler Scripts to schedule UNIX Shell scripts.
• Extensive usage of Toad for analyzing data and writing SQL Scripts, PL/SQL scripts performing DDL operations.

Environment: IBM InfoSphere Information Server 9.1/8.7(Data Stage, Quality Stage), IBM DB2, Cerner, IBM FastTrack, Flat files, Microsoft Visio 2010, SQL, PL/SQL, Toad, AIX Unix.

Confidential, Oakland, CA

Database/ETL Consultant

Responsibilities:

• Responsible for high level design and responsible to attend meetings for collecting functional requirements, technical.
• Involved in all the phases of Software Development Life Cycle (SDLC) in Data Warehouse Implementation.
• Designed and developed DataStage jobs to extract student curriculum data from PeopleSoft Education Modules.
• Extensively worked on developing ETL jobs using Parallel Extender and DataStage/QualityStage Designer using stages like Oracle Connector Stage, Oracle Enterprise Stage, Oracle API Stage, Transformer Stage, Join and Lookup stages, Surrogatekey Generator Stage, Funnel and Peek etc.
• Responsible to keep track of all the ETL process flows and implementations that took place in the EDW.
• Extensively worked on designing the ETL process and creating source to target (STT) mapping.
• Worked on Change Data Capture (CDC) and Slowly Changing Dimension (SCD) stages.
• Worked on XML stages for reading data from XML files and converting the data into required format and apply transformations.
• Used Data Stage Manager for importing metadata from repositories, new job categories, import and export .dsx files, routines and shared containers
• Created and modified UNIX Shell Scripts such as Job Archival scripts, file watchers, Email notification Scripts etc. Also, worked on creating scripts that control the run of the Datastage jobs, etc.
• Extensively worked with DataStage Director to run, schedule, monitor and reset DataStage and QualityStage jobs.
• Extensively used Designer to importing/export datastage objects.
• Created JIL files for running jobs through Autosys.
• Extensively worked on Autosys to schedule DataStage jobs.
• Involved in Production support and in migration of jobs, scripts from Dev- IT-QA-Prod.

Environment: IBM Infosphere Datastage 8.5(Parallel Jobs), IBM Fast Track 8.5, IBM DB2,IBM Cognos, Oracle 10g, PeopleSoft, EPM, XML, Cobal FIles, Toad, DB Visualizer, Windows XP, Linux, Microsoft Office.

Confidential, San Francisco, CA

DataStage/ ETL Consultant

Responsibilities:

• Gathering and Analyzing project requirements to populate Enterprise Data Warehouse (EDW) from disparate source systems.
• Translating the business requirements and writing Functional Specification Documents, Technical Specification Documents and ETL Mapping Documents.
• Coordinating with Offshore team, sharing the business requirements, assigning the tasks and scheduling weekly status meetings.
• Responsible for Confidential analysis and enhancing the existing ETL.
• Designed and Developed ETL jobs for Teradata migration project.
• Used Teradata MultiLoad/TPump/Fast Export stages in Datastage job design.
• Prepared Unit Test Plans and Unit Test Results, Job Docs for the ETL batch jobs to be scheduled.
• Extensively worked extracting data from SAP OLTP system using ABAP Extract Stage, IDoc Stage.
• Created UNIX shell scripts for the ETL batch to be run on Daily.
• Worked on the code migrations from Dev to QA to PROD.
• Involved in QA testing, UAT Testing and fixing issues and bugs during the Integration Testing Phase.
• Working on the Production requests, Change tasks and environment readiness for the Phase 1 Project Deployment.
• Creating Weekly Status Reports with the Project plan and Implementation dates.

Environment: IBM Datastage 8.5, Oracle (Forms, Reports 10g), Mainframe DB2 Confidential host, Mainframe ESP scheduler, Teradata 12.0, BTeq, UNIX AIX, MS Visio, SAP R/3, ABAP, Serena Dimensions, Unix Shell scripting.

Confidential, Charlotte, NC

Sr. DataStage Developer

Responsibilities:

• Worked closely with Business analysts and Business users to understand the requirements and to build the technical specifications.
• Involved in business meeting to understand the retail and institutional customer information and stocks, bonds, mutual funds data.
• Responsible to create Source to Target (STT) mappings.
• Responsible to design, develop and built datastage parallel jobs using DataStage designer.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load the target tables using the DataStage Designer
• Designed developed job sequential to run multiple jobs
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed the Routines and Job Sequence for the ETL jobs
• Prepared Technical Specification Documents for DataStage Jobs.
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Deployed different partitioning methods like Hash by field, Entire and Range for bulk data loading and for performance boost.
• Developed parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage, Sample Stage) and processing stages (Aggregator, Change Capture, Change Apply, Filter, Sort & Merge, Funnel, Remove Duplicate Stage)
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Extensivley worked on Oracle Enterprise Stage, Oracle OCI Stage to extract, transform and load data.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Involved in Performance tuning of complex queries.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.

Environment: IBM Infosphere Server Suite 8.1.1 (Designer, Director and Administrator), Ascential DataStage (Designer, Director, Manager and Administrator), Test Director, Control M, Oracle 10g, AIX 5.3, SQL Server, IBM Cognos 10.1, Toad for Oracle, Windows XP, Visio, ERwin.

Confidential

Data Warehouse developer

Responsibilities:

• Maintenance of Data Warehouse, User Rights, Data Mining, Reporting, QC of Data.
• Worked closely with all levels of end-users to gather, document and develop reportsincluding recommending options and output formatting.
• Experience in using various tuning techniques to improve performance in Mappings, Sessions and Workflows.
• Debugged, maintained existing codes by SQL Query Tuning.
• Analyzed and designed source code documentation for investment Data Warehouse.
• Collaborated with database administrators, applicationdevelopers, and business users in order to ensure business requirements meet expected results.
• Generating of unique keys for composite attributes while loading the data into Data Warehouse.
• Developed documentation for the procedures.

Environment: Oracle 10, SQL developer, MS SQL Server, MS Access, MS Office and Windows 2003.