Summary
Overview
Work History
Education
Skills
Certification
References
Websites
Accomplishments
Timeline
Generic

Ketan Deshpande

Dublin

Summary

Results driven Analyst with over 7 years of work experience in analytics start-ups and MNCs with global clients. Hands-on experience in data extraction, analysis and reporting using advanced industry tools like dbt, Streamlit, Snowflake, Power BI, SQL, Python. Adept at working with structured, un-structured and semi-structured data to provide actionable insights. Proven track record of shipping highly scalable and reliable analytical solutions through multiple cycles. Avid follower & passionate reader of various blogs associated with analytics industry. Seeking opportunities to leverage my analytical expertise and steep learning curve to drive impactful programs, optimize processes and bridge technical and business goals as a Technical Program Manager.

Overview

10
10
years of professional experience
2
2
Certifications

Work History

Senior Product Analyst

Autodesk
06.2020 - Current
  • Driving data-driven decision-making by leading strategic analytics initiatives and managing cross-functional programs within Global Revenue Operations organization while developing scalable BI frameworks, optimizing data pipelines, and delivering actionable insights to stakeholders ensuring alignment between business goals, technical solutions and data strategy.
  • Drove readiness efforts to enhance operational efficiency and performance management by retiring or transitioning 34+ dashboards, optimizing resource allocation for strategic initiatives. Concurrently developed an Activity Tracker to measure access rates and adoption of enterprise datasets using Power BI, Snowflake and dbt.
  • Owned end to end delivery of the standardization of 14 key performance indicators (KPIs), improving scalability and simplifying complexity, for decision making as a part of customer analytics standardization.
  • Spearheaded quality and process optimization framework, increased query efficiency by 40% while reducing operational costs by 80% as a part of evangelizing analytics engineering mindset.
  • Established Snowflake SQL best practices and automated notifications to enhance data reliability.
  • Developed Streamlit-based Snowflake visualizations, improving data storytelling and increased onboarding by 30%, driving a 20% boost in engineering contributions.
  • Delivered scalable and automated data stories, providing solutions for complex Business Intelligence models while ensuring compliance with strategic architecture (data usage, storage, and access).
  • Conducted 12+ workshops engaging nearly 500 participants to improve analytics adoption across federated analytics teams and business stakeholders across globally distributed audience.
  • Provided 2500+ net new and 1900+ expansion prospects to the Global South Sales team, launched a Quick Insights Sales report as a prototype to view prospective customer data and high-level insights on India.
  • Expanded third party data coverage to include 1M additional records for enhanced sales insights.
  • Led a team of 4 analysts in the development and maintenance of the Customer Analytics Knowledge Network (CAKN) for certified documentation and the Customer Analytics Portal (CAP) for executive insights, both serving as single source of truth.
  • Designed and led the implementation of the GDI LCM & Maturity Framework within the data and analytics team, driving structured capability growth, enhanced product quality, optimized resource allocation, and improved cross-team collaboration.
  • Core Technologies: Power BI, Snowflake, SQL, dbt, Python, Git, Microsoft Azure, MS Excel, Jira

BI Developer

Studio Intelligence
03.2020 - 06.2020
  • Performed ETL and data migration using Microsoft Azure Data Factory. Built and scaled, sales and finance analytics solutions using Power BI, creating value for sales teams and cross-functional partners.
  • Successfully validated and migrated 89% of field data from a legacy system to a Microsoft Azure database and designed a reporting solution that analyzed data points across 14 internal companies.
  • Core Technologies: Power BI, Python, Microsoft Azure, MySQL, SQL Server, MS Excel, Salesforce

BI Consultant

Datalineo
06.2019 - 02.2020
  • Built and scaled analytics products and BI solutions to create value for customers, sales teams, and cross-functional partners for data-driven decision making.
  • Built operational and analytical dashboards using Power BI, DAX and Power Query for a leading pharmacy in Ireland, to help generate insights and analyze the impact of sales of various products and services. BI solution resulted in change of 53% to the quarterly sales.
  • Automated data extraction process from a legacy system to SQL Server database in Azure using Microsoft Flow resulting in 70% reduction in time.
  • Managed the architecture rollover of a team of 40 analysts to replace the existing solution with newly designed Power BI reports to fulfill self-service user experience.
  • Core Technologies: Power BI, Microsoft Azure, MySQL, SQL Server, MS Excel, Microsoft Flow, R, Power Query, DAX

Data Analyst

Rudder Analytics
12.2015 - 07.2018
  • Worked and interfaced with dynamic, cross - functional teams both in house and remotely across various business domains and geographies, to understand the business problem and provide actionable and implementable solutions.
  • Worked on data extraction, transformation and loading from various sources (including databases, flat files, JSON, XML)
  • Built and maintained customized operational and analytical dashboards & reports using Power BI, Tableau.
  • Performed exploratory & prescriptive data analysis of trending issues using various statistical techniques & industry tools.
  • Core Technologies: Power BI, Tableau, AWS EC2, RDS, S3, Microsoft Azure, MySQL, SQL Server, Excel, R, Power Query, DAX

Education

MSc Data Analytics -

National College of Ireland
09.2019

Bachelor of Engineering - Information Technology

University of Pune
05.2015

Skills

  • BI Tools: Power BI, Tableau, Looker, Klipfolio, Amazon Quick Sight, Google Data Studio
  • Databases: SQL Server, MySQL, PostgreSQL, Snowflake
  • Project Management & Collaboration: Jira, Confluence, Asana, Agile Methodologies (Scrum Framework)
  • Version Control: Git, GitHub
  • Programming Languages: Python
  • Cloud Services: Amazon Web Services (EC2, RDS, S3), Microsoft Azure, Google Cloud
  • Other Tools & Services: Salesforce, REST APIs, Microsoft Excel, Airflow

Certification

Microsoft Certified: Azure Fundamentals

References

Available on request.

Accomplishments

  • Featured Data Storyteller on Microsoft Power BI Blog (https://powerbi.microsoft.com/en-us/blog/featured-volunteers/)
  • Featured contributor from APAC region on VizForSocialGood (https://www.vizforsocialgood.com/featured-volunteers/)
  • Featured contributor to the Tableau MakeOverMonday Community

Timeline

Senior Product Analyst

Autodesk
06.2020 - Current

BI Developer

Studio Intelligence
03.2020 - 06.2020

BI Consultant

Datalineo
06.2019 - 02.2020

Data Analyst

Rudder Analytics
12.2015 - 07.2018

Bachelor of Engineering - Information Technology

University of Pune

MSc Data Analytics -

National College of Ireland

Similar Profiles

CREATE PROFILE
Ketan Deshpande