PROFESSIONAL SUMMARY:

• Over 7 years of experience in IT industry.
• Over 6 years experience in using Datastage (8.1/8.0/7.5)Designing and developing jobs using Datastage Designer, Datastage Manager and Datastage Director.
• Have very good experience in ETL life cycle.
• Helping the business in the production failure scenarios.
• Extensively made use of all stages viz., Transformer, Aggregator, Sort, Join, Link Collector, and Link Partitioner in Data stage Designer. Remove duplicates, Lookup, Merge, Join, Change capture, Peek stages in Parallel Extender job and Expertise in working with Server jobs and Parallel jobs.
• Extensively made use of job sequencer in running Datastage jobs.
• Experienced in writing UNIX shell scripting and hands on experience with scheduling of shell scripts using AUTOSYS/CONTROL-M.
• Having very good experience in using the BEST PRACTICES in ETL jobs/stages.
• Experienced in Data analysis, Data modeling concepts, Database design and Data migration.
• Experienced in using the databases like DB2, Teradata, Oracle 10g/9i/8i and SQL Server.
• Strong understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables, Star Schema and Snowflake Schema modeling.
• Experience in Database Design, Entity-Relationship Modeling, Dimension Modeling, Star Schema & Snowflake with Kimball methodologies
• Experienced in using XML source files.
• Extensive experience with business intelligence applications with participation in entire life cycle of projects
• Extensive experience in developing custom routines to simplify the determination of data output paths for complex business logic
• Experienced in developing custom routines to simplify the determination of data output paths for complex business logic.
• Worked on writing numerous routines and transforms for various specifications such as Date conversions, files based operations such as splitting and moving the file and string conversions.
• Experienced in using Erwin for data modeling.
• Knowledge in using Datastage version control.
• Involved in the production support.
• Application Data warehousing experience including Telecom, Retail, Insurance and banking sectors.Proven ability to implement technology based solutions for business problems.
• Excellent skills in documenting the ETL process to facilitate an understanding of the entire ETL process and incorporate changes as and when needed.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills.

Technical skills:

ETL TOOLS:IBM Info sphere Ascential Datastage 8.1/8.0/7.5.x/7.5/6.x and Quality stage, DMEXPRESS (Syncsort).

Operating System:UNIX (AIX), Windows NT/2000/2003, XP.

Programming Languages:C, SQL, UNIX shell programming, HTML, PL/SQL.

Database:Oracle 10g/9i/8i, IBM DB2, Teradata V2R6 and SQL server 2000/2005.

Database Modeling Tools:ERWIN.

Others:Toad, AUTOSYS, Tivoli, SAP R/3, Tidal, Rapid SQL.

Educational Qualification:

Bachelors in Computers Science Engineering

PROJECT SUMMARY:

Confidential, NYC, NY September2011 – Present
Data Stage Developer 

Responsibilities:

• Participated in the Team meetings to gather the business requirements and developing the Specifications.
• Involved with business analysts to understand the business requirement specifications and implemented the ETL jobs using Datastage. Deployed the solutions that maximize the consistency and usability of data.
• Self Documenting ETL Jobs to comply with Metadata Standards.
• Extensively used Datastage Designer to develop various Parallel jobs to extract, cleanse, transform, integrate and load data into Enterprise Data Warehouse tables.
• Used Datastage Director for monitoring performance statistics.
• Involved in Performance Tuning of ETL programs and Stored procedures Code.
• Worked extensively on different types of stages like Sequential file, Data set, Lookup stage, ORACLE Stage, Aggregator, Transformer, Copy, Merge, Join, Filter, Funnel, Change Capture, Change Apply Stage, and several other stages for developing Parallel Jobs.
• Designed ETL jobs to identify and remove duplicate rows using remove duplicate stage.
• Extensively worked with surrogate key generator to generate warehouse keys before loading data into warehouse.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs.
• Involved in Design, Source to Target Mappings between sources to operational staging targets.
• Implemented logic for Slowly Changing Dimensions.
• Improved the performance of the jobs.
• Developed and Configured Jobs/ Job Control Sequence to run the ETL programs.
• Created Stored Procedures using Unix Scripts.
• Migrated Jobs from Development to QA and to Production Environments.
• Involved in production support 24 X 7.
• Unit Test Datastage Jobs in development including creating the appropriate test data.
• Developing and supporting the corporate data migration and reporting needs.
• Extensively used CONTROL-M Scheduler Tool to schedule Datastage jobs.
• Involved in the creation of mapping documents from data warehouse to data marts.
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Group Members and Technical Manager regarding any technical and Business Requirement issues.

Environment:IBM Info sphere Datastage 8.1, Quality Stage, DMEXPRESS, Oracle 10g, SQL, PL/SQL, SQL server, Shell Script, TOAD, Rapid SQL, ERWIN, Win NT, and UNIX (AIX), TIDAL.

Confidential, Memphis, TN Dec\'10 – Oct 2011 
Sr. DataStage Developer

Responsibilities:-

• Interacted with end users in finalizing the requirements and documented the Program Specifications for the ETL jobs.
• Involved in creating logical and physical Dimensional data models using Erwin.
• Involved in preparing Data Mapping Documents (DMD) and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Provide the staging solutions for Data Validation and Cleansing with Quality Stage and DataStage ETL jobs.
• Lead a team of developers, resolved issues, developed appropriate documentation. Interacted with offshore team every day to develop the jobs
• Designed Quality Stage Jobs in order to perform data Cleansing using Investigate Stage, Standardize Stage, Match Frequency, Survive Stage, Reference match Stage.
• Used information analyzer for column analysis, primary key analysis, foreign key analysis .
• Developed Data Stage Parallel Jobs where in using required stages, data from different sources formatted, Cleansing, summarized, aggregated and transform into data warehouse.
• Documented current SRS and future Process Flows, and Data Flows.
• Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Decode, Row Generator stages.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively used the CDC (Change Data Capture) stage to implement the slowly changing Dimensional.
• Created multiple configuration files and defined logical nodes, scratch disk, Resource scratch disk and pools.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Used the DataStage Director for testing and debugging its components and monitoring the results.
• Parameterized DataStage jobs and also created multi-instance jobs.
• Analyzed the performance of the jobs , project and enhance the performance using standard techniques.
• Created Master Job Sequences.
• Extensively worked with Job sequence stage such as Job Activity, Email Notification and Sequencer Wait for File activities to control and execute the Data stage Parallel jobs.
• Created PL/SQL Procedures, Functions on Database tables before loading to check some validations.
• Migrated jobs from development to QA to Production environments.
• Defined UNIX -shell scripts for file watcher and file archiving process.
• Developed complex queries using different data providers in the same report.
• Extensively developed Data stage server routines using Data stage Basic Language as part of the development process.
• Performed Unit testing and Integration testing in testing environment.

Environment: IBM Info Sphere DataStage 8.1, Quality stage, Oracle 10g, DB2 UDB, Teradata, SAP R3, Main frame, UNIX(AIX) , MSOffice Suite, Erwin, MS Visio, Toad, Control Center.

Confidential, Alpharetta, GA April2009-November2010 
DatastageDeveloper 

Responsibilities:

• Involved in customer financial management project, which deals mainly with the costumer’s information, invoices and payment.
• Experienced with all the new features in Datastage and migrated all the jobs from 7.5.2 to 8.0.
• Prepared the Naming standard documents, Best practice documents, Release documents and code migration steps to perform.
• Prepared Functional Specification documents, Process flow diagrams, Technical specification documents, mapping documents for Source to Target Mapping.
• Collaborated with Business analysts and the DBA for requirements gathering, business analysis designing of technical requirements document.
• Performed OLTP/OLAP system study, understanding database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Involved in Design and developed Data model using Erwin.
• Designed and implemented slowly changing dimensions (SCD’s) methodologies.
• Used technical transformation document to design and build the extraction, transformation, and loading (ETL) modules.
• Imported various Application Sources (tables from Database like flat files and Teradata) into Manager.
• Extracted the data from Web applications using Web Services pack in Datastage.
• 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 version Control for data stage to track the changes made to the data stage project components and for protecting jobs by making read only.
• Wrote SQL/PLSQL Procedures to improve the Performance while loading.
• Developed Server jobs using stages ODBC, Link Partitioner, Aggregator, Transformer, Link Collector, and Hash File etc.
• Migrated Jobs from Development to QA and to Production Environments.
• Written Executed Various UNIX kern Shell scripts before scheduling Jobs.
• Know various types of reports like Master Detail, Cross Tab, Drill Down and Linked reports to enable easy analysis.
• Involved in Creating Complex reports using User defined functions like @prompt, variable, condition.
• Extensively used Autosys Scheduler Tool to schedule Data Stage jobs.
• Documented self developed reports and universes as well as supported universe and Reports and Scheduled the Jobs.
• Analyzed the performance of the jobs and project and enhance the performance using standard techniques.
• Used Data Stage Parallel Extender parallel jobs for improving the performance of jobs.

Environment:IBM Info sphere Datastage 8.0/7.5.2(Designer, Manager, Administrator, Director, and Quality stage), SQL, Oracle 10g/9i, PL/SQL, Erwin, Windows NT, Toad, UNIX Shell scripting, Autosys, 

Confidential, Boston, MA Mar 2008-March 2009 
Datastage Developer

Responsibilities

• Involved in understanding business processes and coordinated with business analysts to get specific user requirements to build Data Marts.
• Modeled the Star Schema Data Marts by identifying the facts and dimensions using Erwin Data modeling tool. Involved in creating policy, premium and claim data marts.
• Developed Datastage Jobs to load the data into Teradata tables using Fast load utility.
• Worked with Datastage Director to schedule, monitor and analyze performance of individual stages and run Datastage jobs.
• Imported and exported repositories across projects using DataStage Manager.
• Set various environment variables and parameters in Datastage Administrator and also used them in managing the projects.
• Used several stages like Sequential file, Hash file, Aggregator, Funnel, Change Capture, Change Apply, Transformer, Merge, Join and Lookup during the development process of the Datastage jobs.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions.
• Used shared containers for reusability and reducing job complexity.
• Responsible for unit, system and integration testing. Developed test scripts, test plan and test data. Participated in UAT (User Acceptance Testing).
• Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing.
• Developed shell scripts to automate file manipulation and kicking off the Data Stage jobs.
• Migrated Jobs from Development to QA and to Production Environments.
• Extensively used Tivoli Scheduler Tool to schedule Datastage jobs.
• Participated in discussions with Group Members and Technical Manager regarding any technical and Business Requirement issues.

Environments:
Ascential Datastage 7.5 (Designer, Director, Manager), Quality Stage, Oracle 9i, MS SQL Server 2005, IBM DB2, Teradata, Oracle SQL Developer, Teradata SQL Assistant, IBM AIX, Erwin, Tivoli.

Confidential, Dorchester, MA June 2008 -Feb 2009
Data Stage Developer

Responsibilities:

• Worked extensively with Parallel Extender Jobs
• 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.
• Experienced in data migration from Legacy systems to PeopleSoft EPM data warehouse.
• Used the Folder stage to extract data from XML files and load into Oracle database
• Performed tuning on database queries, ETL mappings and end-user queries.
• 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 Oracle 9i.
• 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.
• Worked with DataStage Manager for importing metadata from repository, new job, Schema files
• Categories and creating new data elements.
• Created Test Plans and Test Scripts for unit testing and integration testing
• Involved in Designing Parallel Extender Jobs.
• Developing Korn Shell scripts to automate file manipulation and data loading procedures.
• Worked on writing routine to read parameters from hash file at runtime.

Environment: Ascential Data Stage 6.1, Ascential Data Stage Version Control, ,PL/SQL,DB2, Erwin, Business Objects.

Confidential July2006-May2008 
Datastage Consultant

Responsibilities:

• Interacted with End user community to understand the business requirements.
• Created ETL Design Functional Spec.
• Created Server Job using Data Stage 6.0 ETL Tool.
• Worked with Data Stage Designer to develop jobs for Extracting, Transforming and Loading the data into Target database.
• Created Job sequences for the jobs.
• Worked with Datastage Manager to import/export metadata, jobs and routines from.
• Designed Mappings between sources to operational staging targets, using Star Schema,
• Participated in the review of Technical, Business Transformation Requirements Document.
• Participated in discussions with Team Leaders, Group members and Technical Manager regarding any technical and/or Business Requirement issues.
• Defined Mapping rules doc from Source to Target database.

Environments:
Ascential Data Stage 6.0 (Designer, Director, Manager, Parallel Extender), Oracle 8i/9i, HTML, UNIX, Windows NT and Erwin, Windows NT, SQL loader, Toad, PL/SQL and DB2.

Confidential Apri2005- May2006Oracle Developer

Responsibilities:

• Creating PL/SQL Procedures, Packages, Functions.
• Involved in Interacting with the users taking their specifications into the Program Specifications.
• Developing Forms and Reports.
• Developed custom reports for various modules as per the client requirement.
• Query Optimization, Tuning SQL queries.
• Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers, Packages.
• Developed Oracle Stored procedures and database objects for the whole payroll database.
• Created Stored Procedures, Functions and Triggers using TOAD and SQL*Plus to be invoked by shell scripts and forms
• Tuned the payroll module to improve the performance, because of growing number of transactions.
• Developed the Oracle Reports to show the users various employee reports, Salary slabs, promotion, tax, loans and advances.
• Interaction with the accountants, Chief electricity engineers to gather all the requirements for the payroll module.
• Tuning SQL statements using Explain Plan Tool and Optimizer Hints for best response time
• Prepared Design Docs, Test plans, reviews and implemented the system across all the sites across the city.
• Writing of UNIX shell scripts
• Integration and performance testing of the entire system.
• Providing solutions to any day to day IT problems and providing help to all users.

Environments:
Oracle 8i RDBMS Enterprise Edition on Intel Xeon Servers, Oracle 9i Application Server Enterprise Edition on SUN Sparc Servers, SQL loader, Toad.