SUMMARY:

• Nine and half years of experience in the IT industry with skills in analysis, design, development and implementation of various projects using Object Oriented Analysis, Design and Methodologies. Managed multiple teams as a Team Lead and delivered several critical projects. Managed code changes from development stage to production implementation stage. Worked extensively with various verticals viz., Banking, Energy, Retail and Utilities as a Release Manager with major focus on Process flow, Change Management, and overseeing the Integration and flow of Development, Testing, Deployment and Support of these systems mainly Data Warehousing and Database Applications.
• Six Plus (6+) years of experience in facilitating smooth and timely delivery of project changes belonging to multiple Data Warehousing projects by taking the responsibility of their implementations & also has Coordinated the job responsibilities of Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Abi initio, Data Stage and Oracle Warehouse Builder, AutoSys, Clear case and Crontab.
• Six Plus (6+) years of experience in Change Management tasks for major Banking, Energy, Retail and Utility clients by taking care of the planning, coordinating, implementing and monitoring changes affecting production.
• Successfully lead several production implementations as a Change Analyst coordinating with multiple development teams spread across multiple geographical locations, QA teams, Infrastructure and Production Readiness teams by verifying the change request security risk level, type of change, reviewing the approvals and sign - offs provided by respective teams and ensuring the documentation like Test, implementation and back up plans.
• Worked with the development teams to track all the open tickets and update them as needed and if they have to be cancelled or closed or abandoned did so with valid reasons. Have ensured to capture all the change, work order and work request details to enable the auditing team with complete details for tracking purposes.
• Owned the responsibility of checking that the all the tasks in the change order or request for change are in-line with the overall change implementation window and this change window is not part of the freeze calendar.
• Worked on the communication plan for these projects involving all the stakeholders and their responsibilities so that everyone knows whom to approach in case of issues during the actual production implementation and incase of need arising of the back-out process including the time taken for that task.
• Facilitated weekly/bi-weekly status meetings to discuss on the production changes and their pre and post implementation activities in order to get the desired output of the code changes.
• Worked extensively on submitting the SPARC requests for the all the new changes to the environments (DEV/QA/UAT/PROD) like server names, DB changes/additions, new process additions and also attended the Enterprise Change Board Meetings to discuss on the production changes.
• Four Plus (4+) years of experience in leading the projects of Ab initio and Data Stage development. Involved in Estimations, Planning and Resource management.
• Four years (4) of experience in Java Programming including various java concepts like Internationalization (I18n), JSPs, Servlets, Struts-MVC concept.
• Sound understanding and experience in Software Development Life Cycle (SDLC) with extensive exposure in Data warehouse, Database Applications and ETL process technology, Star Schema/Snowflake Schema.
• Extensive experience in utilizing ETL Process for designing and building very large-scale data OLAP and OLTP instance using ETL tools Ab Initio and custom scripts.
• Utilized Ab Initio suite for designing and building scalable architectures addressing parallelism, data repositories and analytics, data integration developed heavily parallel CPU bound ETL process jobs in a dynamic, high-volume environment
• Worked with EME for Ab Initio jobs migration, version control, and Dependency analysis
• Three plus (3+) years of Onsite experience worked in Onshore-Offshore model.
• Extensively worked on Performance tuning of Ab Initio graphs, Datastage jobs and Oracle Warehouse Builder maps, Unix shell scripts and Database Instances.
• Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify the functional, data quality, performance of graphs.
• Experienced in end-to-end Data warehousing ETL routines. This includes writing custom scripts and data quality processes.
• Extensive experience in writing efficient and well-tuned SQL Queries and UNIX Scripts to provide data reporting, processing and validation on Teradata, DB2 and Oracle.
• Expert in Teradata utilities Fastload, MultiLoad and T-Pump to load the data from flat files to the table.
• Excellent Communication Skills and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff, to clients, and management.

TECHNICAL SKILLS:

Operating Systems: DOS, UNIX, Linux and Windows: 95/98/2000, NT 4.0, XP

GUI: Visual Basic 5.0/6.0/7.0, MS Excel-VBA Macros, MS Word(VBA) Macros

Data Warehousing: Ab Initio, Data Stage 7.5x/7.1/8.1; Oracle Warehouse Builder,Data Cleansing, Data Profiling, Star Schema, Snowflake Schema,SQL *Plus, SQL *Loader.

Programming: SQL, PL/SQL, Java Script, UNIX Shell Scripting

Testing Tools: Test Director

Others: PAC2000, Harvest, Anthill Build, HPSC Tool,mMS-Excel, MS-Word, MS Visio, ETL Testing Experience.

Database Management Systems: Oracle8i/9i/10i, DB2, Teradata, SQLServer 2000/2005/2008 , Sybase, MS Project, MS Visio, MS Office Suite (Word, Excel,PowerPoint, Outlook)

RDBMS: DB2, Oracle 8i/9i/10i/11i, MS Access, MS-SQL Server

PROFESSIONAL EXPERIENCE:

Release Manager

Confidential, Atlanta, GA

Responsibilities:

• Lead the meetings involved onsite production team that constitutes 7 tracks by getting the consolidated status of the project implementations going in for every month from the individual tracks and coordinated with the production support management to apprise them with the Freeze dates and the risk factors involved if the testing is not done in lower environments.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Involved in enhancement and new change discussions with business and ensure that gets implemented in the production as needed.
• Coordinated with the stakeholders like ETL Infrastructure and Database teams to ensure that all the Month End processing related activities have been performed.
• Analyzed, designed and tested the new system for performance, efficiency and maintainability using AB INITIO.
• Involved in the review of the artifacts along with required implementation related documentation.
• Attended the Enterprise Advisory Board meetings to discuss on the changes that will be going in and to decide on the GO - NO-GO decisions.
• Involved in review of RFC for production Implementation and decision team for its approval/denial and pre and post implementation checks till the closure of the Request For Change.
• Ensured that these production implementation are entered in the Change calendar and are in line with the process.

Environment: Harvest Tool, Anthill Build, PAC2000 and HPSC tool, Ab Initio GDE 2.15, Co>Operating System 2.15, UNIX, Teradata, Teradata SQL Assistant, Windows2003, Mainframe and Autosys for scheduling.

Release & Change Manager

Confidential, Charlotte, NC

Responsibilities:

• Involved and provided the management mediation services for employees on internal grievances.
• Facilitated positive work environment to ensure high employee morale.
• Managed daily workflow and the Call Centers resources.
• Design of process oriented UNIX script and ETL processes for loading data into Data Warehouse
• Analyzed, designed and tested the new system for performance, efficiency and maintainability using AB INITIO.
• Maintained internal and external relationships include tracking and reporting performance statistics.
• Involved in the review of the artifacts along with required implementation related documentation.
• Maintained and did troubleshooting for batch processes for overnight operations.
• Owned the process of change related activities right from the Production Change request creation till its pre and post implementation activities, validation of the change, closure of the request and then updating the required documentation.
• Mainly involved in the reviews and attended the Enterprise advisory meetings to evaluate if a decision on GO or NOGO for the planned production implementation change.

Environment: Ab Initio GDE 2.15, Co>Operating System 2.15, UNIX, Teradata, Teradata SQL Assistant, Windows2003, MainFrame and Autosys for scheduling.

Technology Lead & Change Analyst

Confidential, Atlanta, GA

Responsibilities:

• Interacted with the Business Analyst to gather the requirements; worked closely with the Data Architects, DBA’s, and Business Analyst to understand the requirements; thus translating them into ETL requirements for design and implementation.
• Involved in an analysis to understand the new data model for the application.
• Involved in implementing the business requirements into Abinitio Graphs after impact analysis
• Created Solution Specification Documents (SSD) Based on BRD for approval from Client prior initiating Development tasks.
• Prepared Unit test plans (positive and negative test cases) for all the business requirements.
• Involved in the estimation and resource planning.
• Worked with DBA to setup a new DB2 database for Integration testing and configured dbc file to connect to the Database.
• Ran SQL queries on the tables in the Oracle database to verify the data and mapping documents.
• Completely owned the Review and Rework of the implementation related documentation.

Environment: Ab Initio GDE 2.15, Co>Operating System 2.15, UNIX, IBM DB2, SQL Assistant, Windows2003, MainFrame and CA7 Scheduler.

Technology Lead & Configuration Support Analyst

Confidential, Houston, Tx

Responsibilities:

• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning
• Project development estimations to business and upon agreement with business delivered project accordingly
• Developing Data Extraction, Transformation and Loading jobs from flat files, Oracle and DB2 Sources into SQL Server Database and Windows server locations.
• Design of process oriented UNIX script and ETL processes for loading data into Data Warehouse
• Extensively used OWB (Oracle Warehouse Builder) Components like Join, Sort, Merge and Reformat etc as well as Partition and De partition extensively and functions like is valid, is error, is defined, string substring, string concat and other string functions etc.
• Performing data quality and integrity end to end testing and reverse engineering and documented existing ETL program codes
• Develop scenarios for testing BI functional area and review of these scenarios with Business.
• Implemented Lookups, lookup local, In Memory Joins and rollups to speed up various OWB maps.
• Lead a team of 5 resources and mentored them as the whole team was relied on job as this was a new tool for all of us. Were able to successfully explore and deliver the project output.

Environment: OWB 10.2.0.4, Unix Shell scripting, Windows XP, Oracle 10g, SQL Server.

ETL Lead

Confidential, Los Angeles, CA

Responsibilities:

• Involved in all the stages of SDLC during the projects
• Developed and designed unique tools for the Data Warehouse group using MainFrame and Data Stage. These tools are responsible for gathering data from files and convert them to existing database and also use it for reporting
• Worked in the Data Management Team on Data Extraction, Fictionalization, Subset, Data Cleansing, and Data Validation
• Handled and loaded multi-terabyte size data and responsible to load millions of credit reports that were generated each quarter of the month into oracle database.
• Developed a script which automated the loading process to the DB2 Database and MainFrame.
• Was Team Lead for a team of 16 people at offshore and responsible for reviews of the work done.
• Analyzed, designed and tested the new system for performance, efficiency and maintainability using Data Stage.
• Used Data Stage Director to run/schedule/monitor jobs and analyze logs.
• Good understanding and knowledge on the usage of “AutoSys” Automation tool.
• Co-ordinate with different testing groups to accommodate their testing data requirements and translate them to data selection criteria in Data Stage format.
• Batch processing for data downsizing (subset) and document ways to automate manual processes.
• Tuned Data Stage Jobs for better performance.
• Developed UNIX shell scripts for the purpose of parsing and processing data files.
• Maintained and did troubleshooting for batch processes for overnight operations.
• Involved in documentation of the entire project. Mentored other team members.
• Generated reports for the users and data analysis on Test Beds.
• Cooperated and communicated among architects and business groups to achieve common

Environment: IBM Datastage 8.1, Oracle, UNIX, AutoSys, Oracle 10i and Mainframe.

Technology Lead & Onsite Coordinator

Confidential, LA, CA

Responsibilities:

• Interacted with the Business Analyst to gather the requirements; worked closely with the Data Architects, DBA’s, and Business Analyst to understand the requirements; thus translating them into ETL requirements for design and implementation. This project was a prep work for the Datastage project in which warehouse was created.
• Involved in an analysis to understand the impact of new enhancements and data model changes on the application.
• Involved in implementing the business requirements on the existing jobs based on the impact analysis; in the process made necessary changes to the jobs to achieve the business objective.
• Used Datastage components from Partition, Departition, Transformer, etc., to apply data parallelism and maintained data in multi file system.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Worked with DBA to setup a new DB2 database for Integration testing and configured dbc file to connect to the Database.
• Ran SQL queries on the tables in the DB2 database to verify the data.
• Involved in running the test cycles of the application in Development.
• Used CA-7 Scheduler to run the jobs.

Environment: VB, MS-Access, Javascript, Oracle 9, MS-Visio, and MS-Excel.

ETL Module Lead & Onsite Coordinator

Confidential, LA, CA

Responsibilities:

• Interacted with the Business Analyst to gather the requirements; worked closely with the Data Architects, DBA’s, and Business Analyst to understand the requirements; thus translating them into ETL requirements for design and implementation. For this project I have taken the handover Knowledge Transfer (KT) from IBM.
• Involved in an analysis to understand the impact of new enhancements and data model changes on the application.
• Involved in implementing the business requirements on the existing jobs based on the impact analysis; in the process made necessary changes to the jobs to achieve the business objective.
• Used Datastage components from Partition, Departition, Transformer, etc., to apply data parallelism and maintained data in multi file system.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Ran SQL queries on the tables in the DB2 database to verify the data.
• Involved in running the test cycles of the application in Development along with the IBM team.
• Used CA-7 Scheduler to run the jobs.

Environment: Data Stage 8.0, Oracle 10g, Web sphere Application Server 6.0, MS-Visio, and MS-Excel.

ETL Module Lead

Confidential, LA, CA

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Worked on the coding of the Several PPBU subject area related dimensions and facts and capturing the Unit Test Results.
• Involved in an analysis to understand the impact of new enhancements and data model changes on the application.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Involved in verification and validation of data for the correctness.
• Involved in running the test cycles of the application in Development..
• Used CA-7 Scheduler to run the jobs.

Environment: Data Stage 8.0, Oracle 10g, Web sphere Application Server 6.0, MS-Visio, and MS-Excel.

ETL Datastage Lead

Confidential, LA, CA

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Worked on the coding of the Several Finance subject area related dimensions and facts and capturing the Unit Test Results.
• Performed Object conversion using the Datastage tool involving several Legacy Systems.
• Involved in an analysis to understand the impact of new enhancements and data model changes on the application.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Involved in verification and validation of data for the correctness.
• Involved in running the test cycles of the application in Development..

Environment: Ascential Data Stage Client Version 7.5.1.A and Server Version 7.5.2, SSH Techtia Client 4.3.4 and AIX 5.3.0.0.

Sr. Software Engineer

Confidential, Houston, TX

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Configuring and Setting up of application in offshore which includes installations, maintaining the server side components.
• Involved in the Regression testing and the Integration testing for this application.
• Involved in the Maintenance and Bug fixing tasks along with other team members.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Involved in verification and validation of data for the correctness.
• Involved in running the test cycles of the application in Development.
• Also took the responsibility of Configuration Coordinator of the project where maintained several trackers and task lists.

Environment: Windows 2003 Server, Tomcat 5.5, JDK 1.5.0.x, Internet Explorer 6 SP2,Oracle 9i, Toad, FLEXlm 9.5 or 9.2.

Sr. Software Engineer

Confidential, Houston, TX

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Worked on Internationalization of Java, JSP and JavaScript files in the modules like Data Search, Organizer-Queries, Lists, Reports, Data By Depth, Data Availability, Text Search, Forms Manager, Shopping Cart and Personalization.
• Mentored 3 member fresher team and review the code and see that delivery is in Time.
• Involved in the Regression testing and the Integration testing for this application.
• Involved in the Maintenance and Bug fixing tasks along with other team members.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in code reviews, Integration testing and User Acceptance Testing (UAT).
• Involved in verification and validation of data for the correctness.
• Involved in running the test cycles of the application in Development.
• Also took the responsibility of Configuration Coordinator of the project where maintained several trackers and task lists.

Environment: Windows XP professional, Windows 2000, J2EE, JSP, Java, Tomcat 4.1, Tomcat 5.5, Oracle 9i, Toad, JavaScript, XML, HTML,CSS.

Sr. Software Engineer

Confidential

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Designed and developed JSP pages for UI presentation.
• Involved in the coding of various Java Bean Classes.
• Developed Java components for the core business logic.
• Involved in the Maintenance and Bug fixing tasks along with other team members.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.
• Involved in running the test cycles of the application in Development.
• Also took the responsibility of Configuration Coordinator of the project where maintained several trackers and task lists.

Environment: Java, JSP, Struts, Tomcat and Oracle8.

Software Engineer

Confidential

Responsibilities:

• Involved in the preparation of the Technical design documents.
• Designed and developed JSP pages for UI presentation.
• Involved in the coding of various Java Bean Classes.
• Developed Java components for the core business logic.
• Involved in the Maintenance and Bug fixing tasks along with other team members.
• Worked in Onshore-Offshore model and involved in the code and design reviews with the Onsite Coordinator.
• Prepared Unit test plans and performed unit testing for all the business requirements.

Environment: Java, JSP, Servlets, EJB, Java Beans, Web Logic and Oracle8.

Software Engineer

Confidential

Responsibilities:

• Developed Servlets that acts as Controller in MVC architecture.
• Developed user interfaces using HTML and JSP.
• Involved in the coding of several Java Bean Classes
• Involved in the preparation of the Technical design documents.
• Responsible for the unit testing of the system.
• Involved in the coding of various Java Bean Classes.

Environment: Java, JSP, Servlets, EJB, Java Beans, Tomcat4.1 and SQL Server7.0