Damanjot Singh

• Used BigQuery to optimize SKU storage by implementing weighted average pricing, reducing table memory consumption by 2%
• Merged warehouse & inventory data from multiple sources in BigQuery, cutting BI dashboard query time by 5%
• Integrated Gulf region data (SKU, prices, time zone) to provide country-specific performance insights
• Set up automated email alerts to monitor data discrepancies, enable proactive identification and resolution of data quality issues
• Drive business analysis initiatives from concept to implementation, ensuring alignment with organizational goals
• Monitor data quality and integrity, designing and developing checks to ensure accuracy and consistency
• Built a unified pricing table and implemented minimum offer price logic by integrating multiple price sources and cross-border rules,
ensuring accurate alignment between internal pricing and app-displayed prices
• Optimised the SKU tables design and processing logic in DAGMAN, significantly reducing slot utilisation and computation overhead,
resulting in 50% reduction in the tables running cost

• Investigated data discrepancies using SQL, collaborating cross-functionally to resolve root causes and implement monitoring
solutions in Amplitude for real-time alerts
• Designed data governance frameworks, JSON contracts, and schemas using Confluence, Jira & GitLab, ensuring data integrity and
compliance
• Led UAT & QA testing for new products, validating data flow and ensuring seamless integration
• Conducted A/B testing analysis (Databricks SQL, Amplitude) to optimize user experience and guide product/marketing decisions,
improving user conversion by 2.5%
• Spearheaded data reprocessing, identifying & correcting discrepancies across event types, successfully recovering 530K users
data and reducing loss to 1%
• Managed expert data projects, aligning business units and driving data-driven insights for key initiatives

• Contributed to a Centre of Excellence project for client by implementing data-driven approaches using SQL & Python as core tools
on multiple datasets made available
• Independently analyzed patient data using SQL and Power BI Direct Query Refresh, delivering a targeted list of physicians resulting
in a saving of $2.3 million in payouts and incentives forthe client
• Supported client with analytics requirements, including pharmacy and patient data analysis and business reporting using SQL for
querying 867 & DDD data sets, resulting in effective marketing measures and saving 8.3%of MR effort
• Conducted referral network analysis using third-party data, leading to increased sales by $5.7 million

• Contributed to a data-driven decision-making project for a client, involving data extraction, cleaning, and analysisusing SQL to
inform crucial business decisions
• Worked on an EDI 274 data extraction project fora client, converting RDBMS format into X12 format using BizTalk
• Developed a tennis match scheduling system using Python and Oracle database, designing the database structure, building player
availability and results modules, and managing the flow between modules