Punya Saryar

Skilled Data Engineer with over 4 years of experience and expertise in data warehousing, data profiling, SQL, PySpark, Azure and ETL technologies. Proficient at developing complex database architectural strategies at the modeling, design and implementation stages. Accustomed to working closely with system architects, product managers and design analysts to understand business or industry requirements and develop comprehensive data models.

Customer Analytics - Tableau Report (Personal Project)

https://public.tableau.com/app/profile/punya.3009/viz/CustomerAnalysis_16931077472300/Dashboard1

Created dashboard that shows customer purchasing behavior with respect to gender, seasons, discount etc

Operational Pricing Metrics - Vistaprint
Designed the logic to transform list price datasets for Vista and their competitors using SQL logic, which enabled stakeholders to compare Vista's prices against competitors and optimise its own pricing strategy to maintain market position and offset cost surges.

EPICX Data Lake implementation for Roche Pharma - ZS

Led the project aimed at helping the client visualise their sales data in different geographies along with call activities that would help them plan call activities with HCPs better. Gained business understanding of calls/sales data, customer data, geography data and mastering logic (MDM).

GFaRM implementation for Gilead Sciences - ZS

Studied business requirements for project scoping and designing different data warehousing layers (logic, load type, data flow) using Microsoft Visio. The project was aimed at providing the client with a detailed view of non-compliant employee expenses and validated reimbursement forms against uploaded receipts.

Business Conduct Analysis for Gilead Sciences - ZS

Dashboard design to help client to keep track of business expenses. Worked as the sole developer tasked to ingest the expense dataset from PwC and designing fact and dimensions of the database. Used Informatica to extract, transform and load huge PwC datasets, and added visualisations to a Tableau dashboard.