NAME: Pavan Kumar Parepalli

Address: Bangalore

Telephone: +91-964*******

Email:

adjdv3@r.postjobfree.com

Having 2.5+ years of experience as Azure Data Engineer and SAP HANA in one of the world’s largest consumer goods company UNILEVER & COKE as a Client and Capgemini India Pvt Ltd as an Employer. JOB EXPERIENCE SUMMARY

Having 1.5+ years of Hands on Experience in Azure Data Factory and 1 year of experience in SAP HANA and S4 Hana. Azure Data Factory:

Have vast knowledge on Data factory Core Concept's.

Extensively Worked on Copy Data activity.

Worked on Get Metadata Activity, Look up, Stored procedure, For each, IF, Delete and execute Pipeline activities.

Experience in Data Extraction from On-Premise Sources and Delta Extraction methods from Source Systems to ADLS.

Knowledge on processing stream data through Stream Analytics (IoT Hub, Event Hub and Blob Storage).

Good exposer on Azure SQL Database, Data Warehouse, Azure Data Lake Storage.

Involved in designing Logic Apps for Email alerts for pipeline failures, BLOB and ADLS alerts.

Knowledge in Key Vaults.

Followed the Naming rules for all the Resources/Activities.

Pipeline execution methods (Debug vs Triggers).

Created the Auto Schedules for executing the pipelines using the Triggers.

Extensively used Flat-Files, XML, JSON and Excel files data for loading data into target systems.

Experience in Development, Production support, Defect fixing. SAP HANA and S4 Hana:

Hands-on expertise in working on critical projects end-to-end. Worked extensively on HANA Calculation views modeling

Worked on Hana XSA and Hana Classic DB’s.

Worked on Stored Procedures and having good knowledge on Table Functions

Strong Knowledge on container based development in XSA Competency (Center Of Excellence)

Involved in Multiple solutions, POC’s and POV’s from Cloud, Hana and AI Competency.

Worked in POC for integration of sensors with IOT Hub, Streaming Analytics and ADLS.

Supported Competency in deploying AI Solutions in Azure cloud by using ACR (Azure Container Registry) and ACI (Azure Container Instance).

Provided PoV on Grafana and Kibana.

Worked in enabling Cognitive service of Face Recognition for one of the solution

Extensively worked on Machine Learning, Python and AI for multiple solutions DQ Solution, Retail Analytics and Safety PAL

Integrated Hana System with Python libraries and developed one tool for Capgemini.

Worked on developing Face recognition model and Object detection models for the solutions.

Have done very high level comparison of Architectures for Azure, AWS and SAP for multiple customers.

Worked on content preparation of SAP Leonardo and done the ML/AI deployments in Leonardo. ACADEMIC QUALIFICATION

Completed Computer Science Engineering in K L University with CGPA 9.09

Completed Intermediate in Narayana Junior College, with 94%

Completed High school education (SSC) Oxford School, with 8.7 CGPA Key Competencies & Skills

Operating System Windows

ETL Tools Azure Data Factory

Database Tools Azure SQL, Azure Synapse Analytics, SAP Hana, S4 Hana, Oracle Others Python, Machine Learning, SDI/SDA, Leonardo CAREER PROFILE

DATES ORGANIZATION NAME DESIGNATION

June 2018 – Till Date Capgemini India PVt Ltd Associate Consultant ASSIGNMENT DETAILS

The details of the various assignments that I have handled are listed here (in reverse chronological order). Project 2:

EMPLOYER CAPGEMINI INDIA PVT LTD.

CLIENT NAME UNILEVER

PROJECT TITLE CONNECT

PERIOD August 2019 to Till Date

TEAM SIZE 30

ROLE ADF Developer

DESIGNATION Associate Consultant

RESPONSIBILITIES Creating ADF pipelines and completed logic build using activities – Copy, Lookup, For Each, Get Metadata, Execute Pipeline, Stored Procedure, If condition, Web, Wait, Delete etc.

Implemented complex logics framework using ADF activities.

Worked with GIT and VSTS for the CI/CD Implementation.

Created external tables in SQL DW.

Monitor and Error Handling for Pipelines failures.

Involving in Azure SQL Data warehouse stored procedures implementation for transformations and logging tables.

Tested and evaluated Azure Data Factory feasibility for SAP HANA, SAP BW, ECC, Files, Oracle, SQL Server, SFTP connectors

Reviewing individual projects ingesting data into azure data lake; Feedbacks based on reference architecture, naming conventions, guidelines and best practices

Followed Operational framework for ADF pipelines. DATABASE SQL Server, Azure SQL DW

TOOLS Azure ADF, SAP ECC

Project 1:

EMPLOYER CAPGEMINI INDIA PVT LTD.

CLIENT NAME COKE

PROJECT TITLE CONTOUR

PERIOD From June 2018 to August 2019

TEAM SIZE 15

ROLES Hana Modeler, S4 Hana and BW4 Hana developer DESIGNATION Analyst

Responsible for interacting with client teams, gathering requirements and documenting them. Evaluate and identify the best possible path based on requirements and technical feasibility.

Gave Client demos in moving them from R to Python on Advanced Analytics.

Worked as Hana, S4 Hana and BW4 Hana developer

Extensively worked on CDS based Modelling and developed AMDP’s in case of complex calculation.

Developed Hana Calculation views for Harmonizing the data from legacy to the newer systems

Worked on creation of Data sources, ODSO, Composite Provider

Worked on creation of BeX Queries that has a live connection to SAC.

Worked on integration of S4Hana, BW4 Hana and Hana XSA.

Responsible in taking ownership of some of the models and provided demos to the client.

DATABASE Hana

TOOLS SAP Hana, S4 Hana

ACHIEVEMENTS AND RECOGNITIONS:

Certified in AZ-900 Azure Fundamentals - https://www.youracclaim.com/badges/3347f7c2-3e82-4089-8f2b- bd022becfaa7

Certified in DP-200 - Implementing an Azure Data Solution - https://www.youracclaim.com/badges/7f24ff5f-5c75-41a3- bd9e-e09e1937f2a2

Certifies in DP-900 – Azure Data Fundamentals - https://www.youracclaim.com/badges/5d46d9bf-bd97-47ed-8969- d23990ec0804

Recognized as Key member in Center Of Excellence.

Received Rising Star award for outstanding performance in Unilever project.

Provided multiple POV’s to different clients and received wonderful feedback and went with the business proposals.

Developed multiple user stories and presented in client visits that helps in bringing RFP’s to the Capgemini.

Did Comparison of Multiple Architectures for the client feasibility and also on costing Factor. PERSONAL DETAILS:

Interests: Playing Badminton, On how to Innovate

Nationality: Indian

Current Address: Bangalore

Place: Bangalore Pavan Kumar Parepalli

Contact this candidate