Venkata Sai Patha

Phone: +91-903*******

Email: ac99k3@r.postjobfree.com

Experience Summary

Having 3 years and 10 months of Information Technology experience in ETL tools such as Informatica BDM,PWC and databases like Netezza, Hive and datawarehouse technologies.

Also had experience in Analysis, Design and Implementation of DW & BI Projects.

I have worked on mapping design documents and prepared unit test documents for the developed mappings using backend HiveQL queries.

Worked with customer to understand functional and business requirements.

Education

Course

College/University

Year of Passing

Percentage

Bachelor of Engineering in Mechanical Engineering

SRM University, Chennai

2015

91.9

Board of Intermediate Education

Narayana Junior College, Hyderabad

2011

95.9

SSC

Sri Viswasanthi EM High School, Andhra Pradesh

2009

94

Technical Skills

Databases

Hive,Netezza

ETL Tools

Informatica Powercenter v10, Informatica Big Data Edition

Database Languages

SQL,HiveQL

Operating Systems

Unix, windows

Programming Languages

Python

Certifications

Oracle Database SQL expert(1z0-047) certified.

Informatica Big Data Management Specialist certified.

Project Experience

Organization: Accenture

Project #1

Title Shire CMSO(Now Takeda)

Client Shire

Operating System Windows 7

Tools Informatica v10.2, Informatica BDM, Hive, Netezza

Team Size 20

Domain Pharmaceutical

Role Team Member - Offshore

Period Dec 2017– Till date

Project Objective & Description

Shire CMSO has broadly classified into three major operational towers under its portfolio namely BI tower, CRM tower and patient services tower and BISP tower.

Shire BI tower handles four major markets like ADHD, OBU, GI and renal. Each market has its specific purpose to withhold its position in the market as they are one among the rarest diseases in PHARMA sector. Whereas Market Analysis provides details analysis on market based dimensions like product, brand, territories and Postal HCP alignments.

Under Shire nomenclature a sales officer is considered as an employee and a Health Care Professional is considered as a customer.

Role and Responsibilities

Worked in AGILE SCRUM process according to SPRINT timelines(3 weeks).

Understanding about the Work request and its user stories and having a grooming session with product owner about the work requests in product backlog.

Analyze BDM requirements and identify solution elements.

Chosen the compatible engines(Blaze,Spark,Hive) in Hadoop environment to overcome the restrictions for particular requirements.

Implemented source to mart layer mappings for extracting outbounds in BDM.

Implemented performance improvement techniques in the existing systems for better performance of the workflow runs in BDM.

Active participation in SPRINT retrospective calls for raising the points that are to be improvised.

Attending Change control Board meetings to address the applications that are affected as part of the deployment.

Organization: Cognizant

Project #2

Title Coty BI Development

Client Coty

Operating System Windows 7

Tools Informatica 9.6.1, Teradata

Team Size 15

Domain Retail

Role Team Member - Offshore

Period Sep 2015 – Dec 2017

Project Objective & Description

Coty BI has mainly two large BI applications related to different business subjects namely Global BI and Market Analysis.

Global BI reporting application is used by large user base across the different geo-locations. This is very special reporting the provides essentials metrics on Coty Beauty product sales activity, Finance Activity, Manu logistics and combinations of Sales and Finance Activities including Forecasting analysis. Whereas Market Analysis provides details analysis on market based dimensions like product, brand, regions and houses levels.

Role and Responsibilities

Understanding about the different sources available for data loading.

Analyze ETL requirements and identify solution elements.

Create/review design documents.

Reviewing Remedy tickets.

Monitoring Redwood Jobs.

Review Informatica mappings/workflows.

Raise request to Operations team whenever a failure happens in the regular scheduled jobs.

Prepare Weekend Status Report and distribute on weekly basis.

Contact this candidate