ROHAN KUMAR SHETTY Mobile No: 971-***-****

Email_id:

acdm0g@r.postjobfree.com

Experience Summary

An accomplished Software Professional with 6+ Years of experience in Data

Warehousing/Big Data/Reporting tools.

Having 4+ years of experience in DW (ETL) Testing, Big data and Reports

Testing.

Experience in Analysis, Planning, Effort Estimation, Development, Testing,

S/W Configuration Management, Delivery activities, Team Coordination and

Team Leading activities.

Good experience in Data warehousing testing - System Integration, UAT

Support Boundary Value testing, Unit Testing.

Excellent Exposure to End to End DW Testing - Test Plan, Test Strategy,

Estimation, Communication Plan, Test Approach, Test Data Setup and

preparing Test Reports effectively.

Hands-on experience in scheduling, running, monitoring ETL jobs,

troubleshooting session logs and communicating issues to the Development

team.

Proficient in Quality Center for Test Designing, Requirement Mapping,

Reports, Test Execution and Defect Tracking.

Providing Solutions to Automation (Test cases, Test data preparation and

data validation using Platinum) and Informatica Data Validation Option (DVO

tool) for all Informatica jobs.

Good Technical knowledge of Data warehouse development using Informatica.

During this period, I have worked on DW projects using technologies like

Informatica, Hadoop, Hive, SAS, Cognos, SQL Server and Oracle.

OCA (Oracle Certified Associate) Professional.

Having experience in Financial Services, Insurance Domain, Life Science and

Retail.

Effective communication, professional attitude, strong work ethic

and interpersonal skills.

Educational Background

Title of the Degree with Branch College/University Year of

Passing

Bachelor of Engineering (B. E. St. Joseph's College Of 2007

Computer Science Engineering) Engineering

Technical Skills

Hardware / Platforms Windows 98/2000/XP/NT, DOS, Unix

Tools & Technology Informatics, Hadoop, Hive, Hue, DVO, Platinum, SAS

9, Cognos

Test Management Tool HP Quality Center V10

Databases ORACLE 9/9i,ORACLE 10g, SQL Server 2008

Programming Languages SQL, PL/SQL, C

Awards & Recognition

. Outstanding Achievement Award for 2 consecutive years from Cognizant

life science for exceptional contribution to Pfizer US & Abbott, Q1 2011-

12 & Q4 2011-12.

. Client Performance Award from Pfizer for successfully executing a

challenging project within client defined deadlines, Q2 2011-12.

Project Experience

1) Nike - Digital Integration (TPSS) Project

Nike, Inc. is an American multinational corporation that is engaged in the

design, development, manufacturing and worldwide marketing and selling of

footwear, apparel, equipment, accessories and services.

Project PCAT will be redirected to Prodigy. All functionality

Description will be the same but the User Interface will be

different. User edit access will be limited to those who

need to edit product data. Prodigy will replace the

existing PCAT for all commerce geos (NA, WE, JP) and will

be the digital product catalog system for China. Future

enhancements require a more robust tool: PDP updates,

Seamless commerce, Operational excellence, Improved speed

and accuracy of information

Some of the benefits of moving to Prodigy

Organized placement of information

Reduced clutter on product tabs

Moving launch capabilities together in one screen

Improve NIKEiD workflow

Improved Product Search

Search by season

Search by category or sport

Search deeper and more specific: Men's, Running,

Clothing, T-shirts, attribution incomplete

Client, Nike, Beaverton

Location

Start and End Jan 2014 to Till Date

Date

Role Test Lead - Onshore

Responsibiliti Client interfacing and Team management.

es Attend design Meeting, understand customer requirements

and prepare high level / low level test cases.

Test execution for ETL job, which includes extraction,

validation & mapping of data in batch mode.

Responsible for validation Sqoop and Hadoop MR Jobs.

Responsible for Test Planning.

Taken care of the onsite- offshore interactions and

coordination.

Responsible for Managing and coordinating Defect Status.

Responsible for Test Execution and Reporting to the

client.

Contribution to Test Signoff.

Technology Informatica 9.x, Hadoop, Hive, Hue, Oracle 9i. SQL

Developer, UNIX

Team Size 3

2) Nike - Digital Integration GCD Acxiom feeds Project

Nike, Inc. is an American multinational corporation that is engaged in the

design, development, manufacturing and worldwide marketing and selling of

footwear, apparel, equipment, accessories and services.

Project The business would like to integrate Moving Average Cost

Description (MAC) data into the GCD. There is currently an existing

SAP report that can be automated for Acxiom to consume.

We would like to bring in the price at which a product

was purchased for before being sold into the AN_MART for

both the US and Euro commerce

Business objective is to capture and identify all the

marketing channels that the visitor was exposed for each

US and Europe order from Omniture over the trailing 7

days of traffic to analyze and report in RBI and Acxiom.

US and Europe only to be covered. Need to capture and

identify all the marketing channels visited by the

customer for each order.

Client, Nike, Beaverton

Location

Start and End Aug 2012 to Dec 2013

Date

Role Test Lead - Onshore

Responsibiliti Client interfacing and Team management.

es Attend design Meeting, understand customer requirements

and prepare high level / low level test cases.

Preparation of Test Strategy, Efforts Estimation, Test

plan, Query log and Test Approach.

On daily basis communicating status to the clients

through daily standup meeting and emails.

Preparing trackers for estimates, issues, Status,

Preparation, Execution and Defects

Prepared high level / low level test cases based on

requirement documents, executing and testing

functionality.

Test Effort estimation for the project

Responsible for Test Planning.

Taken care of the onsite- offshore interactions and

coordination.

Responsible for Managing and coordinating Defect Status.

Responsible for validation Hadoop MR Jobs.

Responsible for Validating Informatica mapping with DVO

Tools.

Responsible for Test Execution and Reporting to the

client.

Communication and coordination with the third party

vendors, testing team at client site and support during

the SIT phase.

Contribution to Test Signoff.

Technology Informatica 9.x, Hadoop, Hive, Hue, Oracle 9i. DVO, SQL

Developer, UNIX

Team Size 13

3) Abbott - Transfer Pricing Shared Solution (TPSS) Project

Abbott Laboratories is an American global pharmaceuticals and health care

products company. It has 90,000 employees and operates in over 130

countries. The company headquarters are in Abbott Park, North Chicago,

Illinois.

Project Transfer Pricing Shared Solution (TPSS) is intended to be

Description an enterprise level 'transfer pricing' (TP) platform that

will be used by Abbott divisions to calculate transfer

pricing for all Abbott products that need to be shipped

across entity boundaries.

Transfer Pricing (TP) is used when products are shipped

across entity boundaries of Abbott owned legal entities.

Currently Abbott divisions use different systems to

calculate TP's. The project is an enterprise initiative

to provide a new shared services platform that can be

used by all Abbott Divisions to calculate and meet

ongoing Corporate Tax requirements for Transfer Prices.

TPSS deals with various divisions- such as PPG, ADD, AMO,

AAH, GPO and AVD.

TPSS project is expected to achieve the following

business objectives:

Shorten the TP cycle time with increased automation.

Reduce tax inefficiencies and period end adjustments.

Reduce risk of penalties due to inconsistencies in TP

calculations.

Client, Abbott Laboratories US, Chennai

Location

Start and End May 2012 to Aug 2012

Date

Role Senior Test Analyst

Responsibiliti As ETL Tester, responsibilities involved in understanding

es functionality and architecture involved in Ordering.

Clarified client requirements, business needs and project

objectives, via feedback sessions and client meetings, in

collaboration with all stakeholders, updating the

Business Documents.

Test Effort estimation for the project

Preparation of Test data and Test Cases.

Done all the environment setups, code amendments and

executed the Datastage and mainframe batches.

Tested various ETL transformation rules based on log

files, data movement

Extensively used SQL statements to query the database for

Data Validation and Data Integrity.

Review of Test Cases and Uploading and sequencing of Test

artifacts in QC.

Execution of Test Cases and defect raising and tracking

defects to closure in QC.

Regression testing of the Defects.

Involved in the preparation of test data set and status

reports

Coordination between onsite and offshore team and

interaction with client for better understanding of

problem and then proposing an optimum solution.

Coordination with the development team for the defect

fixes.

Knowledge transfer to offshore automation & performance

team for smooth functional and technical testing process.

Contribution to Test Signoff.

Technology Informatica 9.x, Oracle 9i. Toad, Oracle SQL Developer

Team Size 4

4) Pfizer - JCIP Data Integration Phase 1 Project

Pfizer, Inc. is an American multinational pharmaceutical corporation

headquartered in New York City and with its research headquarters in

Groton, Connecticut, United States. It is one of the world's largest

pharmaceutical companies by revenues. Pfizer develops and produces

medicines and vaccines for a wide range of medical disciplines, including

immunology, oncology, cardiology, diabetology/endocrinology, and neurology.

Project The Pfizer Japan Commercial IT Program (termed as JCIP

Description henceforth), is re-building Pfizer sales organization

systems across Pfizer business units. As a result, the

Sales Data warehouse is going to have few data interfaces

which are received from the Source systems Pfizer PRO

direct, Rejita, CS&L, SOP and CTS.As part of JCIP Data

Integration CR module, the data from several sources

Pfizer PRO Direct, Rejita, CS&L, SOP, and CTS are

integrated and loaded into existing WARP Data warehouse.

Client, Pfizer Ltd Japan, Chennai

Location

Start and End Apr 2011 to May 2012

Date

Role Senior Test Analyst

Responsibiliti As ETL Tester, responsibilities involved in understanding

es functionality and architecture involved in Ordering.

Clarified client requirements, business needs and project

objectives, via feedback sessions and client meetings, in

collaboration with all stakeholders, updating the

Business Documents.

Test Effort estimation for the project

Preparation of Test data and Test Cases.

Done all the environment setups, code amendments and

executed the Data stage and mainframe batches.

Tested various ETL transformation rules based on log

files, data movement

Extensively used SQL statements to query the database for

Data Validation and Data Integrity.

Review of Test Cases and Uploading and sequencing of Test

artifacts in QC.

Execution of Test Cases and defect raising and tracking

defects to closure in QC.

Regression testing of the Defects.

Involved in the preparation of test data set and status

reports

Coordination between onsite and offshore team and

interaction with client for better understanding of

problem and then proposing an optimum solution.

Coordination with the development team for the defect

fixes.

Knowledge transfer to offshore automation & performance

team for smooth functional and technical testing process.

Contribution to Test Signoff.

Technology Informatica 8.x, Quality Center 9.2. Toad, Oracle9i

Team Size 5

5) Morgan Stanley - EMP Data warehouse and Gateway Project

Morgan Stanley is an American multinational financial services corporation

headquartered in the Morgan Stanley Building, Midtown Manhattan, New York

City.

Project The EMPDW and the EMPGW interact with a number of

Description firm-wide data stores and applications, as well as EMP

applications. The EMP Support Portal is the user facing

EMP Application which allows application owners to

register their applications and associated assets on EMP,

thus defining the scope of applications for which the

EMPDW provides the retrieve/grant/revoke service.

Client, Morgan Stanley, Pune

Location

Start and End Nov 2009 to Apr 2011

Date

Role Associate Consultant

Responsibilit Responsible for creating test documents like test plan,

ies daily status reports etc.

Reviewing Test Scenarios and Execution results.

Creating complex SQL queries using joins & sub-queries to

validate transformations and reconciliation.

Organize Team Meetings and Conference Calls.

Monitoring the defects in MQC (Mercury Quality Centre)

and updating the status of the same.

Check for timely delivery of different milestones.

Ensuring the quality of delivered work.

Status reporting to the onsite and offshore Managers.

Technology Informatica 8.6, UNIX, Quality Center 9.2, DB2, Sybase.

Team Size 12

6) BB&T - Corporate Credit Risk Business Intelligence Management Project

BB&T Corporation (Branch Banking & Trust) is an American bank with assets

of $157 billion, offering full-service commercial and retail banking

services along with other financial services like insurance, investments,

retail brokerage, mortgage, corporate finance, consumer finance, payment

services, international banking, leasing and trust.

Project Since this enterprise wide data warehouse was in the

Description process of being built, CCRM constructed an interim

solution over the last two years. The centralized data

repository for CCRM is called LGRED. This has been

developed in SAS and consists of two parallel processes

called 1st Train and 2nd Train.

Client, BB&T, Pune

Location

Start and End Oct 2008 to Nov 2009

Date

Role Associate Consultant

Responsibilit Worked with business requirements analyst to identify and

ies understand source Systems.

Maps source system data to data warehouse models.

Develops and tests for extraction, transformation, and

load (ETL) processes. Schedules for extraction and load

processes.

Involved in Testing activities including executing test

cases, logging defects and reporting test status to the

clients.

Coordination with the development team for the defect

fixes.

Technology Informatica 8.x, Quality Center 9.2. Toad, Oracle9i

Team Size 5

7) MetLife- Claim Management Project

MetLife, Inc. is the holding corporation for the Metropolitan Life

Insurance Company, or MetLife, for short, and its affiliates. MetLife is

among the largest global providers of insurance, annuities, and employee

benefit programs, with 90 million customers in over 60 countries.

Project This project was for developing an Insurance product for

Description having a complete view of the current and prospective

policy holder for the claims department. The need has

never been greater for insurers to establish and maintain

a complete view of their current and prospective

policyholders. This product empowers Claim Managers with

new insights into their business that enables them to

Lower Claim Costs. A key part of this complete view is

the specific claims risk that each customer portfolio

poses to the company. We also generated reports on

developed data warehouse for analysis.

Client, MetLife, Chennai

Location

Start and End Sep 2007 to Oct 2008

Date

Role Associate

Responsibilit Responsible for creating test documents like test Cases,

ies daily status reports etc.

Reviewing Test Scenarios and Execution results.

Creating complex SQL queries using joins & sub-queries to

validate transformations and reconciliation.

Organize Team Meetings and Conference Calls.

Monitoring the defects in MQC (Mercury Quality Centre)

and updating the status of the same.

Check for timely delivery of different milestones.

Ensuring the quality of delivered work.

Status reporting to the onsite and offshore Managers.

Technology SAS 9.1, Informatica 8.5.1, UNIX, Cognos 8, Toad.

Team Size 5

Contact this candidate