PALLAVI P

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).

• 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.

• 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

• 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.

• 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.