Project Data
Resume:
ROHAN KUMAR SHETTY Mobile No: 971-***-****
Email_id:
**********@*****.***
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