Summary of Qualifications

• More than 13 years of total IT experience in Software Development Environment.
• Over 5 years of Professional experience as Technical Team Lead with solid understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Quality Assurance
• In depth knowledge in Banking, Finance and Mortgage Industry, Retail, Automobile and Healthcare Services
• More than 10 years of Oracle PL/SQL experience with Strong SQL and Performance Tuning and Strong understanding of database design, transactional and data warehouse systems
• More than 7 Years of experience in Data warehouse ETL tools like ODI, BODI,SAP DI
• Hands-on experience in preparing Source to Target Mappings, Requirements Gathering using Software Development Life Cycle SDLC methodology and Rational Unified Processes RUP
• Proficient with creating Test Cases and creating Test Data and Screen Mockups for Quality Assurance of client server and web-based systems
• Experience in working in all phases of Software Engineering, expert in gathering, developing and documenting Business Requirements Document BRD , User Requirement Specification URS , Functional Requirement Specification FRS , System Design Specification SDS , System Requirement Specification SRS
• Extensive experience in Object Oriented Analysis and Design OOAD techniques with UML using Flow Charts, Use Cases, Class Diagrams, Sequence Diagrams, Activity Diagrams and State Transition Diagrams
• Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases and collecting the Test Metrics
• Strong background in Unix environment, shell scripting
• Experience in performing User Acceptance Testing UAT and documenting test results
• Experience with Designing and verifying Databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams ERD
• Proficient with Unix including bash and/or ksh
• Involved in evaluating, architecting, developing, testing, implementation, and documentation of a migration
• Ability to work effectively as a team leader, team member or individual contributor
• Upgrade plan for the existing Oracle databases to the latest Oracle releases, software tools, and application products
• Independently performs technical or functional research.

Technical Skills:

• Operating System Windows 98/2000/XP/NT/2003/7, UNIX
• RDBMS Oracle 9i/10g/11g, SQL Server 7.0 / 2000 / 2005, Access, Sybase 12.5, Rapid SQL, Oracle SQL Developer, PL/SQL Developer
• ETL Tool BODI 11.5 / 12.2, Oracle Data Integrator 10/11,SAP DI
• Report Tool Crystal Report 4.5 / 7.0 / 8.5 / 9.0 / 10.0 / 11.0, Actuate
• Modeling Tool UML and Microsoft Visio
• Front End Visual Basic 6.0, Excel VBA, DOT NET, VB Script, Shell Scripting
• Code Repository VSS, PVCS, AccuRev
• Quality Tool HP Quality Center 9.2, JIRA

Project Experience

Confidential

Consultant

Software: ODI, UNIX, Oracle 11G, Oracle PL/SQL developer, Shell Script, JIRA, AccuRev

Working for Ford's EPC5 R8 Pub Project for publishing process using all these RAW-BL-CDR-CEPC-QLINK phases. This project consists of Analysis, design and Technical specification which contains Oracle and ODI development. Snap-On supports a global application named as EPC4 and need to re-write a CDR based EPC application which will help to meet these growing demands and move forward with the products worldwide.

Responsibilities:

1. Preparation of documents Business functionality, Process Understanding , Technical system Design

2. Design and implement data quality and data auditing processes

1. Performs moderately complex development tasks following SBS system development life cycle
2. Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.
3. Analysis, Technical specification writing in ODI, Oracle SQL coding, testing and tuning
4. Works with Lead Developers, Data Analysis, DBA's, and end users in the specification, design, and construction, testing and implementation of publishing services
5. Researches and understands the business and technical requirements for a publishing process/system, including target environment and performance criteria suggests technical approaches to management on projects
6. Worked with different KM's LKM,IKM, CKM
7. Automated testing scripts using Oracle Unit Test
8. Working on data integration solutions to utilize the Oracle Data Integration platform
9. Strong unit, integration and system testing skills.
10. Enforce business rules using ODI Constraints and data quality functions
11. Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team

Performed End-to-End testing on the release version using AccuRev for the software application and detected track bugs using JIRA.

Confidential

Consultant

Software: ODI, UNIX, Oracle 11G, Oracle PL/SQL developer, Shell Script, JIRA, AccuRev

Working for General Motor's NextGen and Cornerstone Projects for publishing process using CDR. This project consists of Analysis, design and Technical specification which contains Oracle and ODI development. Snap-On supports a global application named as EPC4 and need to re-write a CDR based EPC application which will help to meet these growing demands and move forward with the products worldwide.

Responsibilities:

1. Preparation of documents Business functionality, Process Understanding , Technical system Design

2. Design and implement data quality and data auditing processes

1. Performs moderately complex development tasks following SBS system development life cycle
2. Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.
3. Analysis, Technical specification writing in ODI, Oracle SQL coding, testing and tuning
4. Works with Lead Developers, Data Analysis, DBA's, and end users in the specification, design, and construction, testing and implementation of publishing services
5. Enforce business rules using ODI Constraints and data quality functions
6. Researches and understands the business and technical requirements for a publishing process/system, including target environment and performance criteria suggests technical approaches to management on projects
7. Automated testing scripts using Oracle Unit Test
8. Worked with different KM's LKM,IKM, CKM
9. Strong unit, integration and system testing skills.
10. Developed steps for Unit Testing and Test scenarios / Test Plans with QA Team
11. Performed End-to-End testing on the release version using AccuRev for the software application and detected track bugs using JIRA.

Confidential

Technical Team Lead

Software: ODI, UML, UNIX, MS-Visio, MS Project, MS Office, Oracle 10G, Rapid SQL, Crystal Report, Unix

Responsibilities:

1. Preparation of documents Business functionality, Process Understanding , Technical system Design

2. Design and implement data quality and data auditing processes

3. Estimation costing experience, Resource and team planning

4. Enforce business rules using ODI Constraints and data quality functions

5. Conducted interviews with the Source Team and Business Customers for gathering Business Requirements, System Requirements and Functional Requirements

6. Automated testing scripts using Oracle Unit Test

7. Created and reviewed Functional Specifications, Project Schedules, and Test plans

8. Created Business Process Models using RUP to document current business process

9. Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

10. Performed extensive requirement analysis including data analysis and GAP analysis

11. Designed and developed Use Cases and UML models using Visio

12. Reviewed various Project Artifacts like High Level Design, Detailed Design, Unit Test Cases, and Integrated Test Plans etc

13. Performed End-to-End testing on the release version of the software application and detected GUI bugs

Confidential

Technical Team Lead

Software: UML, ODI, UNIX, SQL Server, Crystal Reports, Clear Case

Responsibilities:

1. Involved in database design and writing store procedures and functions.

2. Acquainted with opportunities to optimize performance of ETL code existing data structure

3. Preparation of documents Business functionality, Process Understanding , Technical system Design

4. Worked on different Knowledge Module like LKM,IKM, CKM,JKM

1. Automated testing scripts using Oracle Unit Test

6. Design and implement data quality and data auditing processes

7. Enforce business rules using ODI Constraints and data quality functions

8. Worked with the business community of different departments to gather their report requirements and analyzed them to create Business and Functional Requirements

9. Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mappings.

10. Performed GAP analysis between the current state and future state Data Warehouse environment identifying data gaps and quality issues

11. Worked closely with the users to understand their current state of information availability and defined future needs based on analysis of Business Requirements, current state environments, Gap Analysis, and future state warehousing implementation

12. Defined timelines for project delivery, and provided the status update to the client team on a regular basis

Confidential

Technical Team Lead

Software: ODI, Requisite Pro, Rational Rose, Test Manager, Share Point, MS Visio, MS Project

Responsibilities:

1. Preparation of documents Business functionality, Process Understanding , Technical system Design

2. Execution of the Test Scripts/Test Scenarios

3. Creating the Defect descriptions and all relevant information

4. Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

5. Customized the RUP framework and implemented it in the project

6. Created Activity and Sequence Diagrams in UML using Rational Rose and also involved in creating the Business Process Models

7. Documented and reviewed high level and detailed level requirements in Detailed Design Specification DDS document

8. Created Need Analysis Documents of the requirements gathered through JAD sessions and individual elicitation sessions using Rational Requisite Pro

9. Created the specs for the stored procedures and triggers, based on the business logic

10. Participated in entering, tracking system defects in Rational Clear Quest

Confidential

Technical Team Lead

Software: ODI, Requisite Pro, Test Manager, Share Point, MS Visio, MS Project

Responsibilities:

1. Responsible for the study of the requirements and designing of the system

2. Preparation of Technical System Design Document

3. Involved in designing and development of project

4. Working on an In-depth Analysis of the data files for different global custodians Nos. 70 including JP Morgan Chase, Bank of New York, Northern Trust, Mellon Bank, Brown Brothers Harriman, U.S. National Bank, Dresdner Bank Luxembourg etc and thereby suggesting the enhancements eventually increasing the auto match percentile of the existing Recon application. Resultant in FTE saves.

5. Gathering the requirements from Client Source IT teams and thereby explaining the functional aspect and liaising with technical team for feeds development.

6. Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

7. Customized the RUP framework and implemented it in the project

8. Created Use Cases based on the Business Needs and Features BNF's provided by the business team

9. Created Activity and Sequence Diagrams in UML using Rational Rose and also involved in creating the Business Process Models

1. Participated in entering, tracking system defects in Quality Center

Confidential

Technical Team Lead

Software: Test Manager, ODI, Share Point, MS Visio, MS Project, Oracle 10G, SQL Server 2005, Sybase, VB Script, Unity Platform and Crystal Report

Confluence Unity software is a Platform aimed at Mutual Fund administration. It offers a variety of products to track Holdings, create financial statements and create Surveys.

Responsibilities:

1. Provide technical support for the implementation of the Unity platform and products.

2. Responsible for the creation of customized code and reports as per customer requirements.

3. Writing Queries, Stored Procedures and working on other Database Objects

4. Re-execution of the Test Scripts after fixing

5. Execution of Stored Procedures as part of Testing/Data Creation

6. Writing Scripts and creating Database Objects

7. Involved in Requirements Gathering from user groups and analyzed workflows and UI screen dynamics

8. Customized the RUP framework and implemented it in the project

9. Created the specs for the stored procedures and triggers, based on the business logic

10. Set up definitions and process for test phases including Product Test, Integration Test, System Test and User Acceptance Testing UAT

Confidential

Technical Team Lead

Team Size: 6

Software: UML, ODI, ETL Tool, Oracle, SQL Server, MS Office and Sybase

Responsibilities:

1 Migrating database from SQL Server ,Sybase to Oracle

2 Init: Admin User, Role, Tablespace, Create Batch files, User setup

3 Reference: Static BCP Method Event Manager, SWIFT and Price Feed

4 Upgrade Project from SQL Server to Oracle with various versions

5 Running each upgrade version in SQL Server and Oracle

6 Migrating Common, GUI, Excel and Alarm Stored Procedures and Temp Objects in Oracle

7 Working on Schema, application and data migration design and Unit Testing

8 Creating User Space, Roles for Database and Application Users

Confidential

Technical Team Lead

Software: UML, MS Office, ODI, ETL Tool, C , Oracle, SQL Server and Sybase

Responsibilities:

1. Installation of the Applications as per the standards and pre-requisites

2. Identification of Test Data for test execution

3. Execution of the Test Scripts/Test Scenarios

4. Creating the Defect descriptions and all relevant information

5. Re-execution of the Test Scripts after fixing

6. Understanding the application and knowledge transfer by means of Knowledge Sessions and creating of Understanding documentation for installations and product modules.

Confidential

Technical Team Lead

Server 2000.

Responsibilities:

1. Coordinates with the Client for acceptance of deliverables.
2. Involved in analyzing and reviewing the Custodian data to design one uniform format of custodian statements.
3. Writing and Maintaining Database Objects
4. Requirements gathering and preparing functional specification document.
5. Ensured standards are maintained at all the stages of the Process.
6. Designed and implemented the reports as per the formats compatible to reconciliation Tool CT2000 Tool .

Confidential

Technical Team Lead

Software: Test Director, UNIX, Share Point, MS Project, MS Office , Excel VBA, Visual Basic 6.0, Oracle, Sybase 12.5 and SQL Server.

Responsibilities:

1. Developed test cases in accordance to business requirements, technical limitations and product knowledge and ensured all the possible scenarios are included in the test plan

2. Controlled and tracked defects and change requests using Test Director

3. Used Test Director to create reports and graphs to help review the progress of planning tests, running tests, and tracking defects

4. Reviewed test objectives to make sure that all the possible scenarios are tested for the system enhancements

5. Documented Meeting Minutes of various meetings and Brainstorming Sessions

6. Developed project delivery schedule, managed projects and identified resources to successful completion

7. Designing and developing the various components for Accounting System.

8. Identifying the test cases for Accounting Infrastructure.

9. Creating Stored Procedures, Triggers and related database objects

Confidential

Technical Team Lead

Software: Share Point, MS Project, MS Office ,Visual Basic 6.0, Oracle, Sybase 12.5, MS Excel and SQL Server.

Responsibilities:

1. Conducted various interviews and meetings for requirement gathering with key business users and SMEs
2. Maintained and kept track of stakeholders requests for system enhancements and changes
3. Used Rational Requisite Pro to analyze and document requirements
4. Interfaced with development and testing teams to accomplish timely release objectives
5. Analyzed the system functionality in relation to impacts of the change requests and other system modifications
6. Technical Solution for adding Emailing Options to Store and Retrieve files after drag-drop.
7. Involved in Coding, Unit Testing

Confidential

Technical Team Lead

Responsibilities:

1. Acts as second-level escalation point for resolution of issues
2. Handling day-to-day project planning, controlling and execution.
3. Writing Database Objects and scripts for database roles
4. Manage Project Deliverables.

Confidential

Team Lead

1. Responsible for multiple modules or one or more projects.
2. Writing Stored Procedures, Packages , Functions and Triggers
3. Executes project related responsibilities as assigned by PM.
4. Provides induction training to new members of the project team.
5. Designing the various components for Accounting System.
6. Identifying the test cases for Accounting Infrastructure.
7. Coordinating account activities with account dept.

Confidential

Module Lead

Responsibilities:

1. Development and Unit testing of various sub-systems.

2. Coordinating project activities with team

3. Writing Database Objects and scripts for database roles

Confidential

Senior Software Engineer

Software: Visual Basic 6.0, Sql Server 2000, and Crystal Report 7.0

Responsibilities:

1. Development of various modules and Reports

2. Writing Database Objects and scripts for database roles

Confidential

Project: Financial Accounting, Order Processing, Sales And Distribution System

Software Engineer

Responsibilities:

1. Development of various modules and Reports

2. Writing Database Objects and scripts for database roles.