Summary:

• 5.5 Years of professional experience in IT industry on Business Intelligence projects involving Systems Development & Production Support in Data Warehousing, Data Migration and Data Integration.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Staging, Transformation, Pre Loading and Loading of data from multiple sources into Data Warehouse.
• More than 4 years of experience with Extraction Transformationand Loading (ETL) tool AscentialDatastage 7.5
• Extensively used DataStage tools (Data Stage Designer, Data Stage Manager and Data Stage Director).
• 1 Year of experience in Reporting Tool Cognos 8.3 Report studio.
• Excellent experience in working with Parallel jobs (pipelining & partitioning) to distribute the load to different processors.
• Basic knowledge of Shell Scripts in UNIX Environment.
• Experience in Integration of various data sources like Oracle, Netezza, Sequential File and Flat Files into a staging area.
• Expertise in Data warehousing and Data migration.
• Strong experience with Star and Snowflake schema, Data conversions, Dimensional Data Modeling, Fact and Dimensional tables, Slowly Changing Dimensions. Worked CDC (CDC Change Data Capture).
• Involved in initial and incremental runs, Validation, monitor documents, monitor scripts.
• Involved in Performance Fine Tuning of ETL programs.
• Extensive experience in design and development of Decision Support Systems(DSS).
• Involved in Requirement Gathering and prepared Requirement Document.
• Developed Test Cases for Unit Testing and System Integration testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Ability to learn quickly and apply new skills to existing problems.
• Good knowledge of Onsite/Offshore Software Development Model.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TechnicalSkills:

ETL Tools Ascential DataStage 7.x/8.x
Reporting Tools Cognos 8.3
Operating Systems Windows,UNIX (AIX)
Databases Oracle 9i/10g, Netezza.
Languages SQL, UNIX shell programming.
Database Tools SQL Developer, SQL Navigator
Job Control and Verification Tools Control M, Enterprise Manager.
Version Controls Serina Version Controller
Domain Experience 5 years of Retail Experience

Education: Bachelor of Engineering in Electronics and Communication

Certifications:
Oracle Certification for SQL (Oracle 9i)
IBM Certified Solution Developer - WebSphere Datastage 8.5

Work Experience:

Confidential, Texas
June 2009 - Till Date

Project#1: Technical Lead
Pricing Visibility:
The (PV) Pricing Visibility System is the application which is going to be developed for Merchants and pricing manager to create the price changes and to approve the same. It also includes the Dashboard to give visibility to the user regarding the current, past and future pricing events.

Responsibilities:

• Involved in Requirement Gathering. Developed the project scope and requirement document.
• Prepared the Mockups for the UI layout.
• Involved in Data Modeling.
• Prepared the Functional Design Document
• To Use Parallel extender (DataStage 7.5.2) while running jobs for bulk data splitting and to pass the data into subsets to all available nodes for best job performance.
• Involve in Designing Parallel Extender Jobs.
• Involve in the preparation of Data Model
• Involve in Use Case and Test case preparation.
• Offshore Co-ordination.
• UAT setup and UAT test case preparation.

Environment: DataStage 7.5.2 (Parallel jobs), Oracle 10g, Netezza, SQl, Shell Scripting, UNIX and Windows 2000.

Project#2: Senior Datastage Developer
Regular Price Optimization:
RPO is an integrated system of SAS RPO (Third Party Organization) solution with RPM. The project creates and transfers the weekly sales, inventory, price, and cost and promotion information to SAS. Followed by, pre-processing the optimized price files (from SAS) and induct the regular price changes into the existing price execution batch. This involves initial data cleansing followed by conflict checks to ensure the regular price changes are processed in RPM with fewer exceptions.

Responsibilities:

• Analysis of Business Requirements.
• Preparation of the Data Model
• Preparation of the low level Design.
• Onsite Offshore co-ordination.
• Documented design and solution that meets business requirement with technical vision. Co-ordinate with team member once Design is approved by client.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Provide support and training to team members for successful Production deployment.
• Quality Process Management using IQMS tool.
• 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.
• Implemented logic for slowly changing Dimensions (Type1 and Type 2).
• Involved in Designing Parallel Jobs.
• Came-up with an efficient recovery, rollback and restart mechanism at the datastage job level as well as database level.
• Extensively used Processing Stages- Join, Funnel, Filter, Aggregator, Sort, FTP, Transformer and Lookup. File Stages- Dataset, File Set, Sequential File, Database Stages-Oracle, Netezza Enterprise stage.
• Extensively used DataStage- Designer to design and develop Parallel jobs to migrate data from Oracle into the Data Warehouse.
• Used Dynamic data re-partitioning between processors, sequential logic and deployment configuration that automatically adds the desired degree of parallelism for data transfer.
• Involved in the testing of the various jobs developed and maintaining the test log.
• Involved in the implementation of UNIX shell scripts to invoke the Datastage jobs and automate file manipulation.
• Creation of Unit testing strategy according to the test plans.
• Creation of Integration testing strategy according to the test plans.
• Provide Post Warranty Support.

Environment: DataStage 7.5 (Parallel jobs), Oracle 10g, SQl, UNIX, Netezza,Windows 2000, Putty, Visio- 2003, Control-M

Project#3: Datastage Developer
Coupon Management Systems (CMS)
The Coupon Management System (CMS) gets the coupon SKUs from Retek system. Initially there was a full load and subsequently only the delta will be sent to the Coupon Management System. The Coupon events and the related offers are sent to the Point of Sale system (POS) via the ISP.A file is created in CMS for all valid events and this file is sent by Xcellenet across to the ISP system. From the ISP system, this file will be sent to the POS via the EALMOVE process.

Responsibilities:

• Analysis of Business Requirements.
• Preparation of the low level Design.
• Documented design and solution that meets business requirement with technical vision. Co-ordinate with team member once Design is approved by client.
• Provide support and training to team members for successful Production deployment.
• Quality Process Management using IQMS.
• Designed the mappings between sources (external files & databases) to operational staging targets.
• Followed STAR SCHEMA Schema for the methodology to organize the data with in the database.
• Involved in Designing Parallel Jobs.
• Used Dynamic data re-partitioning between processors, sequential logic and deployment configuration that automatically adds the desired degree of parallelism for data transfer.
• Came-up with an efficient recovery, rollback and restart mechanism at the datastage job level as well as database level.
• Extensively used Processing Stages- Join, Funnel, Filter, Aggregator, Sort, FTP, Transformer and Lookup. File Stages- Dataset, File Set, Sequential File, Database Stages-Oracle oci, ODBC stage.
• Extensively used DataStage- Designer to design and develop Parallel jobs to migrate data from Oracle into the Data Warehouse.
• 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.
• Involved in the testing of the various jobs developed and maintaining the test log.
• Provide Post warranty support.

Environment: DataStage 7.5 (Parallel jobs), Oracle 10g, SQl, UNIX, Netezza, Windows 2000, Putty, Visio 2003, Contol-M

Project#4: Datastage Developer
Vendor Scorecard:
The project automates the some of the manual processes that generate the report and make the report more useful to the Business and vendor community. The enhancements include reporting by department level drill down and automating the data collection for POSummary and routing information from the data warehouse. Impacted business departments are Vendor Relations, Category Management, Finance, Inventory Management, Sourcing, Supply Chain, and Accounts Payable. The Michaels systems involved are BAAM, TIPS..

Responsibilities:

• Preparation of the low level Design.
• Co-ordinate with Onsite Project Coordinator.
• Documented design and solution that meets business requirement with technical vision. Co-ordinate with team member once Design is approved by client.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Provide support and training to team members for successful Production deployment.
• Quality Process Management using IQMS.
• Used Datastage Designer for Developing various Parallel jobs using various stages like Join, Lookup, Aggregator, Transformer, Merge, Oracle Enterprise, Filter, Funnel, Copy, Remove Duplicates, Column Generator, Peek, Data Set, Sequential File etc.
• Used Datastage Director for monitoring and viewing the job log
• Used Datastage Manager to import and export the jobs
• Involved in the implementation of UNIX shell scripts to invoke the Datastage jobs and automate file manipulation.
• Creation of Unit testing strategy according to the test plans
• Imapct Analysis with integration.
• Provide Post Warranty Support.

Environment: DataStage 7.5 (Parallel jobs), Oracle 10g, SQl, UNIX, Netezza, Windows 2000, Putty, Visio 2003, Contol-M

Project#5: Datastage Developer
Retek Reporting:
Michaels Ad Planners/Buyers, plan and forecast their promotional offers and events in PROMOTE application. Promote application include both US and Canada Stores in the calculation for determining the forecast units. Also Promote looks at store on hands, on-orders, in transit values to accurately determine the forecast units, sales and margin. These values are not interfaced to Retek. Forecast Sales, Margin is calculated for all stores without taking into account the store on hand or what's in transit…resulting in the mismatch between the numbers reported in promote versus what is being reported in retek. This project aims at syncing up retek with promote by taking the forecast values from promote and loading into retek.

Responsibilities:

• Preparation of the low level Design.
• Co-ordinate with Onsite Project Coordinator.
• Documented design and solution that meets business requirement with technical vision. Co-ordinate with team member once Design is approved by client.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues.
• Provide support and training to team members for successful Production deployment.
• Quality Process Management using IQMS.
• Developed various Parallel jobs using various stages like Join, Lookup, Aggregator, Transformer, Merge, Oracle Enterprise, Filter, Funnel, Copy, Remove Duplicates, Column Generator, Peek, Data Set, Sequential File etc.
• Involved in the implementation of UNIX shell scripts to invoke the Datastage jobs and automate file manipulation.
• Creation of Unit testing strategy according to the test plans.
• Provide Post Warranty Support.

Environment: DataStage 7.5 (Parallel jobs), Oracle 10g, SQl, UNIX, Netezza, Windows 2000, Putty, Visio 2003, Contol-M

Confidential, Illinois
Cognos Developer
Jun 2008 - Jun 2009

IDO Answers:
AC Nielsen is a global marketing research firm, with worldwide headquarters in New York City. Regional headquarters for North America are located in Schaumburg; The Innovation Delivery Organization (IDO) has been set up to focus on the delivery of products and solutions to Nielsen high value client such as Kraft (On-Demand) and P & G.Nielsen Answers reports deliver information in the form of different formats and clear graphic illustrations designed to meet the specific needs of individual clients in general management, marketing and sales .The Project is aimed at the analysis of the Over-all Performance of the Company To demonstrate the business IDO Reports

Responsibilities:

• Analysis of business requirements.
• Preparation of low level design.
• Co-ordinate with Onsite Project Coordinator.
• Developed standard reports like List, Cross tab and Charts.
• Developed standard Templates for different Costume Reports.
• Created Dash boards and conditional formatting reports by using different variables
• Created filters and prompts to reports to add interactivity for users
• Involved in Functional testing and Smoke testing.
• Creation of Standard Reports, Complex reports based on user requirements and efficient analysis
• Implemented Widget code for different reports as per project requirement by using ADF technology
• Created various conditional block reports.
• Testing report studio reports for accuracy and performance.

Environment: Cognos 8.3, SQL, Windows 2000/XP

Confidential, Minneapolis
Datastage Support
Jun 2008 - Jun 2009

Target EAM BI
The main objective of this project is to provide maintenance to Target Corporation's applications. Target is the second largest general retailer in the United States. The project involves production support, enhancement and maintenance of existing Business Intelligence / Data Warehousing applications in TARGET like ADW, EDW, DTK and DDW.

Responsibilities:

• Involved in Design, Development and Testing of ETL Jobs
• Involved in preparation of design document
• Involved in requirement gathering.
• Analyzing and fixing the bugs with the program after extracting the business needs.
• Involved in writing Unix Scripts for invoking the datastage jobs
• Old files were moved to archive location using scripts
• Open issues were tracked and resolved after confirming with business clients
• Automated mail processes were implemented using unix script.
• Make sure that the team is 100% compliant to the quality processes.
• Involved in performance tuning.
• Creating and updating documents.

Environment: Datastage 7.5.2, Secure CRT, SQL, UNIX Shell Script