Data Analyst Product

SIDDHANTH DHAWAN

*******@*******.*** • 540-***-**** • LinkedIn

EXPERIENCE

AFFINITY GLOBAL, Product Data Analyst Oct 2022 - Jul 2023, Mumbai, India

Processed large-scale ad impressions data with BigQuery and Spark, identifying optimizations for ad placement strategies

Enhanced RTB database efficiency by developing advanced SQL in MSSQL(SSMS), reducing query times by 40%

Deployed Tableau dashboards for performance visualization, driving data-driven decision-making and process improvement

Boosted ad revenue by 5% through detailed trend and consumer behavior analysis, elevating ad campaigning effectiveness

Improved data loading speeds by 60% through SQL optimization, refining performance of ad delivery systems

Streamlined ad campaign setup harnessing ETL tools, cutting time-to-market by 35% and supporting agile deployment

Developed a predictive model forecasting ad performance trends with 90% accuracy, enabling proactive optimization

SAFFRONSTAYS, Data Analyst Sep 2021 - Oct 2022, Mumbai, India

Led finance analytics development using Python and R, enhancing dynamic pricing strategies to meet 10% revenue growth

Partnered with business teams, using data insights and KPIs for product innovations, elevating user acquisition by 15%

Managed a deep learning and NLP project to analyze customer sentiments, enhancing guest testimonials on website

Automated consumer mail marketing workflows leveraging Python libraries, resulting a 20% uplift in leads generation

Crafted API docs and workflow processes using Jira and Confluence, facilitating integration for third-party booking services

Guided a 7-developer team to deliver a data-centric bookings app, achieving inception to go-live within 2 months through agile practices and effective scrum meetings

MOTION IDENTIX PVT. LTD., Associate Product Analyst Oct 2019 - Aug 2021, Mumbai, India

Spearheaded end-to-end web portal development for a travel company, from requirements to production release

Gathered business process information, aligning user requirements with stakeholder expectations through collaboration

Optimized project documentation efficiency and clarity by utilizing MS Excel & Word for BRDs, user manuals and test cases

Facilitated seamless collaboration between IT development and business teams, ensuring efficient project delivery

Executed rigorous A/B testing cycles and multivariate testing, securing business sign-off and validating product integrity

SKILLS

Programming Languages: Python (Pandas, Matplotlib, Seaborn), R, C, JavaScript, HTML, CSS, Hadoop, TensorFlow

Project Skills: Agile/Scrum, ETL/ELT Designing, Software Development Lifecycle, Product Management Lifecycle

Data Management & Visualization: Databricks, MySQL, Alteryx, Tableau, Power BI (DAX), Snowflake, Apache Hive, SAS

Productivity Tools: Confluence, Git, MS Office (Advanced Excel, Word, PowerPoint), Notion, JIRA, VS Code, Sublime Text, Google Colab Cloud computing: Oracle DB, AWS, Google Cloud Platform, Azure Prototyping: Figma, Marvel

PROJECTS

Healthcare Specialty Utilization Analysis

Leveraged Python, SQL, and Tableau to analyze a dataset of 5 million EHR Medicare records from The Primary Care IPA

Conducted in-depth analysis to identify anomaly and pattern detection in specialty utilization, leading to actionable insights enabling cost reduction, improved population health and enhanced quality of care

Financial Data Warehousing Solution

Implemented an ETL pipeline utilizing SQL for data extraction, manipulation and mapping into a Snowflake data warehouse

Optimized data storage and analysis by centralizing diverse financial datasets in Snowflake for an academic project

Electricity Consumption & Cost Forecasting System

Developed a Python model integrating machine learning algorithms - Linear Regression, Random Forest and time series analysis for precise electricity consumption and cost forecasting, enabling proactive energy management

EDUCATION

University at Buffalo, SUNY Master of Science, Management Information Systems (STEM) Jun 2024, Buffalo, NY

Coursework Includes: Cloud Data Warehouse Engineering, HealthCare Analytics, Relational Database Management Systems, System

Analysis & Design, Data Visualization & Business Intelligence, Predictive Analytics, Cloud Computing for Managers, Web Analytics

University of Mumbai Bachelor of Engineering, Information Technology May 2019, Mumbai, India

Coursework Includes: Advanced Database Management Systems, Statistics, Supply Chain Management, Data Mining & Business

Intelligence, Cloud Technologies, Intelligent Systems, Big Data Analytics, Open-Source Technologies, Business Communication

CERTIFICATIONS

Data warehousing digital badge, Snowflake Google Data Analytics, Google Connect to & Transform Data by Tableau Python Programming Specialization Courses, University of Michigan Data Science using Python & R, Rice University

INTERESTS

Traveling Sports Food Self-improvement

Contact this candidate