Pooja Mishra

• 1.7 years
• Worked on ETL Pipelines and also creating reports using Power BI, Looker Core.
• Build various KPIs related to customer feedback experience, sales , health, logistics,pharma and banking domain.

1. Project - WA-ESD (Washington Employment Security Department)

• Extracted raw data from Big Query database and optimized queries for efficiency.
• Developed the Virtual Agent Analytics Dashboard with 25+ metrics that helped gauge the Virtual agent performance, Customer Feedback Analysis, Callback mechanism efficiency,etc.
• Developed the data pipeline with scheduling Cloud Functions using Pubsub trigger and loading the data to Big query database.
• Created KPIs definition & Calculation logic document for client reference. Received appreciation from client for timely and efficient delivery.
• Technologies used- Cloud Functions, Pub Sub,Logs explorer, Big Query, Python, SQL, Looker Core

2. Project - Amgen (Pharmaceutical domain)

• Developed the Analytics Dashboard with the Key performance indicators (KPIs) for German chatbot in Phase-1 and US chatbot in Phase-2.
• Developed the whole data pipeline from logs to Big query database and further transformations to derive the metrics.
• Received appreciation from the team for Conversation analysis KPI (wherein we can see customer and bot conversation sequentially).
• Technologies used- Cloud Functions, Pubsub, Dialog Flow, Logs explorer, Big Query, Python, SQL, Looker Enterprise version.

3. Project - ICICI (Banking domain)

• Development of Virtual Agents with chat & voice functionalities for the bank customers as well as their departments to enhance their services and customer satisfaction.
• Developed the data pipeline and the Analytics Dashboard with 20+ KPIs to gauge the performance of the product.
• Technologies used- Big Query, Python, SQL, Looker Enterprise.

4. Project - Project 44 (Logistics domain)

• Project 44 is a company involved in helping customers with information about their shipments by maintaining a Tracking page with shipments and carrier information.
• Development of an Analytics Dashboard with 21 metrics to analyze the performance of the tracking page of the client.
• Appreciation received from clients for incorporating Geographical location based metrics and drill down features in Looker.
• Technologies used- Big Query, SQL, Looker Core.

5. Project -Cogeco (Telecommunication domain)

• Worked upon to build the KPI Dashboards on Tableau Desktop.
• Technologies used- Big Query,SQL, Tableau,Cloud Functions,GCS,Bigquery Policy Tags
• Developed the data pipeline and the Analytics Dashboard with 25+ KPIs to gauge the performance of the product.