Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Accomplishments
Timeline
Generic
PALLAVI P

PALLAVI P

Bangalore

Summary

As a driven professional with 8.8 years of experience in the IT industry, I have honed my skills as an Azure Data Engineer. My expertise encompasses a range of technologies including ADF, ADLS, Databricks, SQL DW, Synapse Analytics ,PySpark and Data Pipeline Optimization. With a goal-oriented approach, I consistently seek innovative solutions and strive to navigate the complexities of data with diligence and dexterity.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Data Engineer

Shell India MP Ltd
Bangalore
08.2023 - Current

Project CRMHUB :

Shell CRMHUB is a project implemented using the Microsoft Azure Data stack, and it is an analytics platform that collects customer data and their spending patterns across various sources (Shell Retail sites). It drives marketing strategies through levers such as data and campaigns.

Roles & Responsibilites:

I played key role in Ingestion from Source, Landing, Self Service and Reporting layers and have good exposure in Power BI Dasboard.

Ingestion : Worked on new file ingestion of Voucher Assignment for LOD , Gamfication for Adobe Analytics , Offer assignment for Hybris and Modifcation in Patner Management System , AT Customer profile , Mutliple Stamp Tracker ,Sonar Qube Bug Fix.

Reporting: Development for Gamification Weekly Dashboard, CLTV Automation, GDPR config cleanup (CI).

Senior Software Engineer

Prodapt Solutions
Bangalore
05.2021 - 07.2023
  • Designed both streaming and batch processing data pipeline from external sources to Snowflake using Azure Data Factory .
  • Worked as a part of Data Engineering Team, to Extract, Transform, Load the data into Different Data sinks.
  • Handled data migration from On-Prem to Azure environment.
  • Experience with AWS, Azure, Docker, Kubernetes, CI/CD, and DevOps processes.

Software Engineer

Future Focus InfoTech (TCS)
Pune
11.2011 - 09.2014
  • Preparing / reviewing the functional requirement document.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Responsible for product planning, configuration, UAT & release.
  • Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
  • Performed data manipulations using various Informatica Transformations .
  • Release / Configuration & Change Management Process

System Support Specialist

IBM India Private Limited
Bangalore
03.2010 - 11.2011
  • Extensively worked on taking MIS reports from Prepaid and Postpaid billing systems.
  • Reports generated using SQL on Daily, Weekly and Monthly basic for Business team Revenue Assurance , Marketing , Activation and Legal Dept.
  • Worked on automating reports to send directly to Business email ID on daily basis.
  • Worked on reports reconciliation and handled Tools such as POS, VOICE, BSCS.

IT Executive

Info Services Pvt ltd (IBM)
Bangalore
06.2009 - 03.2010
  • Responsible for MIS reports from Prepaid billing system to various Business teams (RA, Marketing , Activation and Legal).
  • Automating daily prepaid to BSCS updating process. Daily creation of cards is loaded in BSCS by scheduled jobs and logs are monitored.
  • Handling RC complaints effectively by providing a web base (Intranet) front end through VOICE application, it helps to provide the status of the card, achieved by updating Voucher details daily basis.

Education

Post Graduate Program - DevOps

Purdue University
Online
01-2023

Bachelor of Engineering - Computer Engineering

Vinayaka Mission University
Salem, TN
05-2009

Skills

  • Technology(Azurestack) - ADF, ADLS, Databricks, Stream Analytics, SQL DW, COSMOS DB, Click Event Analysis, Azure Functions, Serverless Architecture, ARM Templates, Synapse Analytics
  • Database - Microsoft SQL Server, MySQL, Time-series DB (Influx), Oracle,Postgres DB, Redis, AzurePostgresSQL Service etc
  • Languages - SQL, PL/SQL, PySpark, Python , Shell Scripting
  • Container Technology - Docker, Kubernetes
  • OS Platform- UNIX, Windows, LINUX
  • Tools-VS code, SQL developer, PGadmin, Informatica

Affiliations

  • Team Player
  • Good communication skill
  • Analytical and problem Solving skill

Certification

  • DP-203
  • Databricks DE Associate
  • Microsoft Fabric Analytics Engineer
  • Green Software
  • PG DevOps
  • ITIL

Accomplishments

  • “Spotlight Award” from Prodapt (2022)
  • “BRAVO awards from Vodafone (2013-14)”
  • “Innovation” Award from IBM(2010

Timeline

Data Engineer

Shell India MP Ltd
08.2023 - Current

Senior Software Engineer

Prodapt Solutions
05.2021 - 07.2023

Software Engineer

Future Focus InfoTech (TCS)
11.2011 - 09.2014

System Support Specialist

IBM India Private Limited
03.2010 - 11.2011

IT Executive

Info Services Pvt ltd (IBM)
06.2009 - 03.2010

Post Graduate Program - DevOps

Purdue University

Bachelor of Engineering - Computer Engineering

Vinayaka Mission University
PALLAVI P