Summary of Professional Skills

• 7+ years of extensive IT experience with in ETL tools using IBM Infosphere (ver 8.1/7.5/7.1), and experience in Data Analysis and Dimensional Modeling.
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension Phenomenon(SCD), Surrogate key assignment and CDC (Change Data Capture).
• Expertise in using Transformer, Aggregator, Look-up, Filter, Join Stage, Sequential file stage, Funnel Stage and Oracle stages in Datastage 7.5.x & 8.1.
• Extensive experience in working with Server jobs, Parallel jobs, Troubleshooting and Performance tuning.
• Built integration process for migrating data from Oracle platforms, SQL Server platforms and even excel spreadsheets via DataStage.
• Hands-on experience on SQL Server, developing ETL scripts and related functions.
• Extracted data from heterogeneous sources like SQL server, SYBASE, ORACLE, DB2, and TERADATA.
• Familiar using highly scalable parallel processing Infrastructure using IBM Infosphere Data Stage (Parallel Extender).
• Involved in all the stages of Software Development Life Cycle.
• Detailed and problem-solving oriented in Data Stage jobs and addressing production issues such as performance tuning and enhancement.
• Familiar with Data Stage production job scheduling using Control M, Autosys.
• Diverse knowledge of data dependencies using IBM Information Analyser and preparing job sequences for existing jobs to facilitate scheduling of multiple jobs.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Good knowledge of Plug-in stages like TeraData Load and TeraData Multiload.
• Experienced in writing system specifications, translating user requirements to technical specifications.
• Effective skills in planning, coordination, and execution of system applications and engineering projects.
• Excellent understanding of business processes & interface with IT.
• Substantial ability in cross-functional and global environments to manage multiple tasks & assignments concurrently.
• Multilingual, highly organized, detail-oriented professional with strong technical skills.

Summary of Technical Skills:-

Data Warehousing

IBM Information Server DataStage/Quality Stage 8.1/7.5/7.0 (Designer, Administrator, Director), IBM Infosphere 8.1, Information Analyser, Integrity, Orchestrate Parallel Extender, Cognos,Teradata 13.0, v2 R6.0, Teradata SQL Assistant 7.1, Teradata Multiload 7.1,Teradata BTEQ 7.1, Datamart, OLAP, OLTP, SQL*Plus, SQL*Loader

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERwin, Oracle Designer

Reporting Tools

Data Reports, Crystal Reports, Cognos, Business Objects XI, MS Access Reports

Databases

Oracle 11g/10g/9i, TeraData, IBM DB2, MS SQL Server 2005/2008.

UNIX Tools

C Shell, K Shell, Bourne Shell, Perl, AWK, VI, SED

Languages

VB.NET,ASP.NET, C#, VB Script, JAVA Script, UML, SQL, T-SQL, PL/SQL, XML

Environment

Windows 2008/2005/XP, MVS OS, IBM 390/370, Sun Solaris, Sun OS, IBM AIX, Unix, IBM-PC Compatibles

Professional Experience

Confidential 
Role: DataStage Developer Jan 2011- Current

Developing a state-of-the-art Statewide Automated Child Welfare Information System (SACWIS) solution for the State of Michigan Client. The newSACWISsolution will replace a legacy system developed in the year 2000 called the Services Worker Support System (SWSS). TheMiSACWISproject includes the design, development, testing, training, conversion and implementation services. TheMISACWISSystem will be developed using JAVA and will be supported with Oracle database.

• Involved in business requirements gathering and preparing architecture design documents.
• Involved in preparing Technical Design Documents for the ETL development.
• Extensively used DataStage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into EDW and then to Data Mart.
• Worked with DataStage Designer to import/export jobs, metadata, DataStage components between the projects.
• Developed Job Sequences to run Staging load, EDW load, Data Mart Load and to run store procedures.
• Extensively worked on Parallel Jobs using Various Stages like Sequential File, CFF Stage, Data set, Lookup, Join, Aggregator, Remove Duplicate, Modify, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Store Procedure Stage, Transformer, Change Capture, Oracle Connector/Oracle Enterprise, and ODBC Stage.
• Used Parameter Sets, Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.
• Created and implemented datastage routines.
• Improved performance of the jobs.
• Involved in Design, Source to Target Mappings between sources to operational staging targets.
• Implemented logic for Slowly Changing Dimensions.
• Created Test Plans and Test Scripts for unit testing and integration testing.
• Created implementation plans and implemented ETL project.
• Developing and supporting the corporate data migration and reporting needs.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Experienced in all phases of development lifecycle (SDLC).
• Participated in discussions with Group Members and Technical Manager regarding any technical and Business Requirement issues.
• Worked on CRs and implemented on requested time.

Environment: IBM Information Server 8.1, IBM Information Analyzer 8.1, DataStage (Designer, Director and Administrator), Oracle 11g, Oracle Sql Developer, HTML, XML, UNIX, Windows NT.

Confidential, Chicago IL Sept 2009- Dec 2010 Role: Data stage Developer
Confidential is one of the leading financial institution and home for all personal financial like credit cards, loans, home buying and more. The team implemented an Enterprise Data Warehouse (EDW) that collects, organizes and stores data from different systems to provide a single source of integrated and historical data for the purpose of end user reporting, analysis and decision support. Primary objective is to improve the client’s services by preventing errors, providing real time data and upgrading records as transactions are completed.
Responsibilities: -

• Developed DataStage ETL jobs for extracting data from COBOL GDG files.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Created Data stage 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.
• Used the Data Stage Director and its run-time engine to run the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Worked on performance tuning and enhancement of DataStage job transformations, Summed key performance indicators using Aggregator stages as an aid to Decision Support Systems
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Analyzed data for discrepancies through Error files and Log files for further data processing and cleansing.
• Unit tested the mappings to check for the expected results.
• Enhanced the job properties for performance tuning.
• Tuned Data Stage transformations and jobs to enhance their performance.
• Loaded dummy data using row generator to provide data to reporting people.

Environment: IBM Information Server 8.1, IBM Information Analyzer 8.1, DataStage (Designer, Director and Administrator), Oracle 11g, MSSQL Server 2008, HTML, XML, UNIX, Windows NT.

Confidential- AZ June 2007- Aug 2009
Role: DataStage Developer 
Confidential has established itself as a leading provider of higher education programs for working adults by focusing on servicing the needs of the working adult. I worked in Data Services team, involved in building Centralized data warehouse from disparate source systems (Oracle, SQL Server) and Datamarts.

Responsibilities: -

• Participated in gathering the user requirements and involved in writing technical design documents.
• Involved in the analysis, data modeling, detailed system design, development and technical documentation.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures using Data Stage.
• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into data warehouse database.
• Designed DataStage Parallel jobs involving complex business logic, update strategies, transformations, filters, lookups and necessary source-to-target data mappings to load the target.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Extensively used the Sequential File stage, Hashed File Stage, Modify, DataSet, Filter, Funnel, JOIN, Lookup, Copy, Aggregator, and Change Capture during ETL development.
• Extensively used Built-in, Plug-in and Custom Stages for Extraction, transformation and loading of the data.
• Used DataStage Director to Run and Monitor the Jobs for Performance Statistics.
• Implemented logic for Slowly Changing Dimensions Type II by using Date methodology.
• Involved in Performance Tuning of Parallel Jobs using Performance Statistics.
• Extensively worked with database objects including tables, views, indexes, schemas, PL/SQL packages, stored procedures, functions, and triggers.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts.
• Involved in solving Production support issues.
• Used Control M to schedule jobs.

Environment: IBM Information Server 8.0.1, IBM Information Analyzer 8.0, DataStage (Designer, Director and Administrator), Oracle 10g, DB2, SQL, PL/SQL, SQL* Loader, UNIX Shell Script, ERWIN 4.2, Win XP and AIX UNIX 4.2, Control M.

Confidential, Newark, NJ Apr 2006 - May 2007 
Role:ETL Developer 
Confidential companies serve individual and institutional customers worldwide and include Confidential, one of the largest life insurance companies in the US. These companies offer a variety of products and services including mutual funds, real estate brokerage franchise, relocation services and more. The primary objective of the project is to develop Data Warehouse system making extensive use of Data marts. The objective is to extract data stored in different databases and load into Oracle system.

Responsibilities: -

• Analyzed and Designed ETL processes for loading the data in to DW.
• Identified / documented data sources and transformation rules required to populate and maintain data warehouse content.
• Mapped the ETL process.
• Created Data Stage Server jobs to load data from sequential files, Flat Files and MS Access.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used the Data Stage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Prepared Data Volume estimates.
• Defined the data definitions, and created the target tables in the database.
• Wrote routines to schedule batch jobs to obtain data overnight from various locations.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Troubleshoot jobs using the debugging tool.
• Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
• Standardized the Nomenclature used to define the same data by users from different business units.
• Created job sequences and schedules for automation.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Used Data Stage to transform the data to multiple stages, and prepared documentation.
• Analyzed business functionalities and building the fundamental blocks.
• Created ETL execution scripts for automating jobs.
• Worked on writing routines to read parameters from hash file at runtime.
• Unit tested the mappings to check for the expected results.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

Environment: Ascential Data Stage 7.5 (Designer, Director, Manager), Windows 2005/XP, UNIX, Oracle 10g, PL/SQL, and UNIX Flat Files.

Confidential May 2005 – Jan 2006 
Role: PL/SQL & ETL Developer 
This application involves maintenance and enhancements to a sales application for one of the world’s largest consumer goods company and enjoys over 50% market share of tobacco products in the United States. The client monitors their sales force operations using legacy system, which is supported based on onsite-offshore delivery model. 
Responsibilities: -
Developing Architecture for building a Data mart by using data modeling tool Erwin. Involved in creating entity relational and dimensional relational data models using Data modeling tool Erwin. Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.

• Developing Architecture for building a Data mart by using data modeling tool Erwin.
• Developed Analytical applications that can analyze large amounts of online and offline data using orchestrate environment.
• Using Orchestrate, integrated third party applications within house applications.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data mart database.
• Worked on programs for scheduling Data loading and transformations using Data Stage from legacy system and Data Warehouse to Oracle9i.
• Worked with Data stage Manager for importing metadata from repository, new job, Schema files categories and creating new data elements.
• Involved in Designing Parallel Extender Jobs.

Environment: Ascential Data Stage 7.1(Manager, Designer, Director, Administrator), Oracle 9i, DB2, DB2 UDB, SQL, UNIX, Windows XP