SUMMARY

• 7+ years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) /Enterprise Data warehouse (EDW) analysis, design, development, Testing and implementation.
• 5 years of experience in populating and maintaining Data warehouses and Datamarts using IBM Information Server 9.1,8.7,8.5, Ascential DataStage v7.5.x (Administrator, Director, Manager, Designer) - Server Edition, Enterprise Edition (Parallel Extender).
• Involved in all the phases of the SDLC requirement gathering, design, development, Unit testing, UAT, Production roll-out, enhancements and Production support.
• Worked with offshore team as co-coordinator with responsibilities such as providing solutions for the issues/troubles/technical difficulties that offshore team TEMPhas on top of design documents, source to target mappings.
• Expertise in Relational Database Modeling and Dimensional Modeling-Star schema, Snow-Flake schema, and hands on experience in data modeling tools Erwin / Microsoft Visio.
• Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like performance tuning and enhancement.
• Optimized DataStage jobs utilizing parallelism, partitioning and pipelining features of Parallel Extender.
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Experience in migrating ETL code to upgraded version.
• Experience in programming using SQL, PL/SQL, and UNIX Shell Scripting.
• Extensive experience in Microsoft SQL Server 2005/2000, IBM DB2 UDB 8.0/7.0, Informix, Teradata, Oracle 10g/9i., XML files and Message Queues.
• Strong Experience in Unit testing and System testing of the DataStage jobs.
• Experience in Scheduling the DataStage jobs using Control-M, Autosys.
• Knowledge on designing and developing reports using BI/OLAP tools like Business Objects and Cognos.
• Involved in Documentation of ETL process following the standard naming conventions used in DataStage.
• Excellent communication and interpersonal skills, teamwork, problem solving skills, flexible, self-direct and energetic person.
• Extensively worked co-coordinating with offshore team distributing the work, keep tracking development status and monitor day-to-day activities.
• Installation, configuration, setup and Administration of DataStage Server.
• Experience in DataStage Administrator to create/modify/delete projects, add DSN entries and cleanup projects and Implemented security among DataStage users and projects.

TECHNICAL SKILLS

ETL: IBM Datastage 9.1, 8.5/7.5.2/7.1/ client components (Designer, Director, Manager, Administrator), Profilestage, WEBSPHERE INFORMATION SERVER 8.0 (Datastage,Qualitystage) & Information Analyzer 8.1

Data Modeling: Star Join Schema, Snow-Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, Erwin (Forward & Reverse) engineering.

BI Tools: Business Objects XI, OBIEE 3.1

Databases: Oracle 10g/9i, DB2 9, MS SQL Server 2005, Teradata V2R6/V2R5,DB2 UDB

Languages: Java, XML, SQL, T-SQL, PL/SQL, C, C++

Environment: Windows 2003/2000NT 4.0, Sun Solaris 2.x/5.x, AIX 5.2/4.3, HP-UX, Unix, Linux.

ERP / CRM: SAP R/3 ABAP 4.7, SAP CRM5.0,SAP BW3.5, Oracle 11i, Siebel 8.0

PROFESSIONAL EXPERIENCE

Confidential, Murray Hill, NJ

Sr. DataStage Developer

Responsibilities:

• Used the IBM Info Sphere DataStage 9.1to develop processes for extracting, cleansing, Transforming and loading data into data warehouse database.
• 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 template jobs to maintain standard common format (SCF) file that we receive from different divisions of Bard across the world.
• Prepared Technical Specification Documents for DataStage Jobs.
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Developed Parallel jobs using stages like Dataset, Sequential file, Funnel, Filter,
• Join, Lookup, Merge, Aggregator, Peek, Pivot, Transformer, External Source Stage and Remove Duplicate Stage.
• Used stages like Oracle Connector, Odbc Connector and DRS stage to extract data from Oracle and IBM DB2 databases.
• Extracted data from XML files using XML Input Stage.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used DataStage Director to validate schedule run and monitor the data stage jobs.
• Created Sequence jobs to control the flow of jobs and their dependencies.
• Designed Job sequencers to automate the process and Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
• Designed Job Documentation and Installation and Back out Documentation.
• Involved in unit, performance testing of data stage jobs and prepared technical design documentation.
• Responsible for analyzing and preparing dependencies and sequence in which processes should be scheduled in Control-M scheduler.
• Responsible to track, log all support issues to significantly reduce the amount of time needed for support issues.

Environment: IBM Information Server DataStage & Quality Stage 9.1 (Designer, Directory and Administrator), Oracle 11g, IBM DB2 9.1, AIX 5.1, K-Shell Scripting, SQL, PL/SQL, Toad for Oracle, Control - M, Clear Case, Erwin, Microsoft Visio.

Confidential, Cincinnati, OH

Sr. Datastage Developer

Responsibilities:

• Responsible to work with Business users to understand the requirements.
• 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 disparate systems 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 sequencer to run multiple jobs with dependency and email notifications
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• 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.
• Extensively worked on Oracle Enterprise Stage, Oracle OCI Stage to extract, transform and load data.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Responsible to create Source to Target (STT) mappings.
• Responsible to create technical specification document.
• 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.7/8.5 (Designer, Director and Administrator), Ascential DataStage (Designer, Director, Manager and Administrator), Test Director, Control M, Oracle 11g, AIX 5.3, SQL Server, Toad for Oracle, Windows XP, Visio, ERwin.

Confidential, Roanoke, VA

Datastage Developer

Responsibilities:

• Involved in functional meetings with business users to gather requirements and worked with business to sign-off the requirement.
• Extensively worked on designing the ETL process and creating source to target (STT) mapping.
• Extensively worked on developing ETL jobs using Parallel Extender and DataStage/QualityStage Designer using stages like DB2 Enterprise Stage, DB2 API Stage, Oracle Enterprise Stage, Transformer Stage, Join and Lookup stages, SFDC Stage, Funnel and Peek etc.
• Designed and developed DataStage jobs to extract HR data from PeopleSoft systems.
• Worked on building interfaces to pull CRM data from Salesforce.com (SFDC) cloud systems into Centralized customer database (CCDB) and to Enterprise Data Warehouse.
• Installed and configured salesforce.com (SFDC) Server and Client PACK.
• Extensively worked on applying server and client patches for Salesforce.com PACK.
• Extensively worked on building commercial hierarchy from DIFM Commercial Customer database.
• Involved in data modeling using Embarcadero ERStudio.
• Built commercial fact tables at a grain level of customer, store, data, products etc.
• Extensively worked on building dimension tables like Customer, Store, Product and Time etc.
• Worked with DB2 DBA team building replicated dimensions.
• Extensively used DataStage Director to create and compile, run, schedule, monitor and reset DataStage and QualityStage jobs, importing/export objects.
• Worked on Change Capture stage and Slowly Changing Dimension (SCD) stage.
• Extensively worked on customizing Salesforce Object Query Language (SOQL) to extract data from SFDC.
• Extensively worked on customizing DB2 SQL and created truncate and run stats scripts and used them in before and after job routines.

Environment: IBM Information Server WebSphere DataStage 8.1.2 / 8.1.1 / 8.0.1 (DataStage and QualityStage Designer, Director, Administrator), IBM DB2 9.1/9.7, Oracle 11g/10g, UC4, PeopleSoft HR Module, IBM Information Server PACK for Salesforce.com (SFDC), Salesforce Object Query Language (SOQL), Oracle OBIEE, Business Objects XI, AIX 5.3,Toad, APEX Explorer, APEX DataLoader, PLSQL Developer, Windows XP

Confidential, Boston, MA

DataStage Developer

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse to design the business process, data representation, dimensions and fact tables using Erwin.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the CDW data from various source systems (Flat files, XML, ORACLE, DB2 UDB).
• Extracting, cleansing, transforming, integrating and loading data into data warehouse using Datastage Designer.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used DataStage Director and the runtime engine to schedule running the Parallel jobs, monitoring and debugging its components for performance and events such as error conditions.
• Designed and developed Server and Parallel jobs using Datastage designer to migrate data from flat files, ORACLE, DB2 UDB into the Data Warehouse.
• Used Parallel Extender for Parallel Processing for improving performance when extracting the data from the sources.
• Used stages like Transformer, Oracle, Aggregator, Remove Duplicates, Sort, Join, Merge, Lookup, Funnel, FileSet, Copy, Modify, Filter, Change Capture, Change Apply, DataSet.
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Used SQL Loader to load the data into Oracle tables.
• Created UNIX shell scripts using K-shell for calling the stored procedures for truncating the tables and calling the SQL Loader for loading the data into the target staging area and loading the stats into the stats tables.
• Worked on Autosys for scheduling and automating the month end job flow.
• Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.

Environment: IBM Information Server (Datastage & Qualitystage) 8.1/, Quality Stage, Oracle9i, SQL*Loader, Erwin 4.1, Clear Case, Websphere MQ 6.0, DB2 UDB, AIX UNIX, TOAD, Autosys, Windows XP.

Confidential

SQL Developer

Responsibilities:

• System study, interaction with users and management, performance of analysis, designing, coding, and testing and implementation of the system.
• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
• Designed and implemented number of Data Entry Forms using Developer 2000. Various management reports like Cash Flow statement, Cash/Bank statement, Account statement, Balance sheet, Sales/Purchase register.
• Designed and prepared specifications and did module level testing using over 45 forms (Forms 4.5), 40 reports (Reports 2.5), 35 stored procedures and database triggers for company’s reconciliation.

Environment: Oracle 7.3/8i, Sybase, SQL, PL/SQL, Developer/2000(Forms 4.5, Reports 2.5) and Sun Solaris/Windows-NT.