Project Manager Software Engineer

CURRICULUM VITAE

Shekhar Battu Mobile : +91-961*******

E-mail : *******.*****@*****.***

Professional Objective:

To seek a responsible and challenging job where there can be an excellent opportunity for professional advancement in Data warehousing domain. I look forward to an exciting and challenging career with an organization that has a congenial working environment and provides excellent opportunities for mutual growth.

Executive Summary:

? Acquired 4.5 years of IT experience on Data Warehousing Development and implementations.

? Extensive experience in development of mappings, transformation standards and processes using Informatica Power Center 8.1,8.5,8.6

? Designed and developed Mappings, transformation objects using Informatica Power Center 8.1,8.5,8.6

? Handled 24X7 database offshore/onsite models. Good exposure to production environment.

? Has got exposure to Insurance, Telecom and Banking Domain.

? Adherent to Process.

? Willingness to travel to various locations of work.

? Good ability to quickly understand and master the new concepts and technologies.

Experience Profile:

? Working in JPMorgan Chase, Hyderabad as Application Developer from Oct 2011 to till date.

? Worked as Systems Engineer for TATA Consultancy services, Hyderabad from July 2010 to Sep 2011

? Worked as Software Engineer for Accenture Services Pvt Ltd, Hyderabad from Aug 2007 to July 2010

Technical Skill Profile:

Operating Systems Windows98/2000, XP and UNIX

Languages SQL, PL/SQL,Shell Scripting,

ETL Tool Informatica Power Center8.1,8.5,8.6

Database TERADATA,ORACLE

Reporting Tool Cognos 8.4 (Trained)

Scheduling Tool Control-M,TWS

Educational Profile:

? Master of Computer Applications (MCA) from Osmania University.

? Bachelor of Computer Science (BSC) from Osmania University.

Corporate Trainings Pursued

? Have taken Green Field Training in Informatica 8.5 from Accenture.

? Have taken Green Field Training in Cognos 8.4 from Accenture.

PROJECT Profile 1: CE – JPMorgan Chase India Pvt Ltd

PROJECT NAME ICDW –CE (CUSTOMER EXPERIENCE)

CLIENT JPMORGAN CHASE

ROLE Application Developer

ORGANIZATION JPMorgan Chase, Hyderabad, India

DURATION Oct 2011 – Till now

TEAM SIZE 39

ENVIRONMENT

(WITH SKILL VERSIONS) Languages: UNIX shell scripting.

Tools : Informatica Power Center 8.5, 8.6, Teradata 12.0 &13.0, CONTROL-M

DATABASE Teradata

OS Unix/Linux, Windows XP

DOMAIN KNOWLEDGE Banking

Project Synopsis:

J.P. Morgan is a leader in financial services, offering solutions to clients in more than 100 countries with one of the most comprehensive global product platforms available. We have been helping our clients to do business and manage their wealth for more than 200 years. Our business has been built upon our core principle of putting our clients’ interests first.

ICDW (Integrated Consolidated Data Warehouse) is used for Reporting purpose and critical analytics; it is reconciled with external system.

Role & Responsibilities:

As a Senior Application Developer I was responsible for:

? Worked with onshore team for gathering requirements.

? Understanding and analyzing the Requirements.

? Developed various mappings & mapplets to load data from various sources using different transformations like Router, Aggregator, and Joiner, Lookup, Update Strategy, Source qualifier, Filter, Expression and Sequence generator etc., to store the data into the target table.

? Done code reviews of Informatica Mapplets, Mappings, and Workflows and other documents required by onshore.

? Involved in development of Change requests.

? Appraising the project status to project manager regularly and maintained it in Project shared folder for tracking purpose.

? Understanding the Existing System, verifying and validating the application log files on production UNIX boxes to check the backend functionality of the application.

? Creation of Unit Test Plans (UTP), Unit Test Cases (UTC's), Unit Test scripts with captured unit test results.

PROJECT Profile 2: ECDW –Jim Mackey Tower

PROJECT NAME ECDW

CLIENT AT&T Wireless

ROLE Senior Software Engineer

ORGANIZATION TATA Consultancy Services, Hyderabad, India

DURATION July 2010 – Sept2011

TEAM SIZE 26

ENVIRONMENT

(WITH SKILL VERSIONS) Languages: UNIX shell scripting.

Tools : Informatica Power Center 8.5, 8.6, TOAD12.0, Teradata 12.0, Citrix

DATABASE Teradata and Oracle 10g

OS Unix/Linux, Windows XP

DOMAIN KNOWLEDGE Telecom

Project Synopsis:

AT&T Wireless (Formerly Cingular Wireless) is the largest wireless company in the United States, with more than 50 million subscribers who use the nation's largest digital voice and data network.

eCDW(Enterprise Consolidated Data Warehouse) data is used for critical analytics and operation purpose and is reconciled with the external system. eCDW ensures that the data supporting critical business metrics are reconciled with the external data.

Role & Responsibilities:

As a Senior Software Engineer I was responsible for:

? Understanding and analyzing the Requirements.

? Attending the Requirements and Design Review meetings and preparing business process flow.

? Developing code/software as per the approved design document and checking the standards using ASSENT.

? Done code reviews of Informatica Mapplets, Mappings, and Workflows and other documents required by onshore.

? Appraising the project status to project manager regularly and maintained it in WebIPMS for tracking.

? Understanding the Existing System, verifying and validating the application log files on production UNIX boxes to check the backend functionality of the application.

? Reporting status (Weekly status & Monthly Metrics) to the client.

? Creation of Unit Test Plans (UTP), Unit Test Cases (UTC's), Unit Test scripts with captured unit test results.

? Had interactions with onshore Dallas and Atlanta Team to resolve some of the offshore technical & functional issues.

Project Profile 3: NI CONVERSION

Project Name NI CONVERSIONS

Client Level (3) Communications

Role Software Engineer

Organization Accenture Services Limited, India

Duration March 2009 – July 2010

Team size 4

Environment

(With skill versions) Languages: SQL, PL/SQL

Tools: Informatica Power Center 8.1, TOAD 7.1, Citrix

Database Oracle 9i

O/S Windows 2003, Windows XP

Domain Knowledge Telecom

Project Synopsis:

Level (3) communications intends to implement an End-to-End (E2E) solution as a means to integrate and consolidate recently acquired business entities to a unified solution improving processes in Order Fulfillment, Order Management, and Network Inventory Management. The goal of the implementation is to support future acquisitions, lower operating costs, and support growth and new product introductions. Delivery of the E2E solution has been approached by validating its capabilities and business effectiveness with an initial prototype

Roles and Responsibilities:

As Associate Software Engineer I was responsible for:

? Understanding and analyzing the Requirements.

? Work on on-time deliverables and prepare project plan accordingly to meet deadlines.

? Created sessions, work flows and ran for scheduling jobs and implemented error-handling mechanism for ETL mappings.

? Created the Mapplets & Reusable Transformations.

? Done code reviews of Informatica Mapplets, Mappings, and Workflows and other documents required by onshore.

? Involved in development of Change requests.

? Worked on SCD type-1 and SCD Type-2 dimensions.

? Involved in Unit testing and Enhancements.

? Creation of Unit Test Plans (UTP), Unit Test Cases (UTC's) & Scripts with captured unit test results.

? Had interactions with onshore Team to resolve code issues on daily basis.

? Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

PROJECT Profile 4: EFBI (FARMERS)

Project Name EFBI (FARMERS)

Client ZURICH FINANCIAL SERVICES

Role Associate Software Engineer

Organization Accenture Services Limited, India

Duration FEB 2008 –JAN 2009

Team size 15

Environment

(With skill versions) Languages: Oracle

Tools: Informatica Power Center 8.5, 8.6

Database Oracle

OS Unix/Linux, Windows XP

Domain Knowledge Insurance

Project Synopsis:

Zurich Financial Services is an insurance-based financial services provider with a global network that focuses its activities on its key markets in North America and Europe. In North America, Zurich (www.zurichna.com) is a leading commercial property insurance provider serving the global corporate, large corporate, middle market, small business (not offered in Canada), specialties and programs-sectors.

Role & Responsibilities:

As a Software Engineer I was responsible for:

? Involved in code and application development & enhancements.

? Developed various mappings & Mapplets to load data from various sources using different transformations like Router, Aggregator, and Joiner, Lookup, Update Strategy, Source qualifier, Filter, Expression and Sequence generator etc., to store the data into the target table.

? Created the Mapplets & Reusable Transformations.

? Involved in development of Change requests.

? Worked on SCD type-1 and SCD Type-2 dimensions.

? Involved in the performance Tuning.

? Created sessions, work flows and ran for scheduling jobs and implemented error-handling mechanism for ETL mappings.

? Done code reviews of Informatica Mapplets, Mappings, and Workflows and other documents required by onshore.

? Had interactions with onshore Chicago Team to resolve some of the offshore technical & functional issues.

Thanks & Regards

Shekhar Battu

Contact this candidate