Ambuj Bhardwaj

Co-Founder

Bengaluru, Karnataka, India9 yrs 5 mos experience
Highly StableAI Enabled

Key Highlights

  • Over 9 years of experience in Business Intelligence and Analytics.
  • Expert in optimizing BI solutions for cost savings and performance improvements.
  • Proven track record in mentoring junior analysts and enhancing data quality.
Stackforce AI infers this person is a SaaS Business Intelligence expert with strong data analytics and engineering capabilities.

Contact

Skills

Core Skills

Business IntelligenceData EngineeringData AnalyticsData Analysis

Other Skills

Big Data AnalyticsInsight GenerationData ModelingDAX MeasuresProblem SolvingSQLPythonSentiment AnalysisExecutive ReportingCustomer Satisfaction (CSAT)Machine LearningRegressionTableauMicrosoft ExcelVBA

About

Driving business excellence through advanced Business Intelligence, optimized data solutions, and leadership in analytics and scalable reporting architecture. With 9+ years of experience in Business Intelligence and Analytics, I specialize in optimizing BI solutions that deliver significant cost savings and performance improvements. My expertise spans the complete BI lifecycle - from Strategy and Data Modeling and Warehousing to Dashboard development and Performance tuning. My leadership extends to hiring and mentoring junior analysts. Known for spearheading initiatives that enhance data quality and drive automation, I bring a strategic and collaborative approach to data analytics. I help functional leaders drive their KPIs by providing analytics and key insights and keep an eye on metrics development. Let's connect to explore how my skills can contribute to your organization's data-driven success. Email: ambuj.mtr@gmail.com Topmate: https://topmate.io/ambuj_bhardwaj/

Experience

9 yrs 5 mos
Total Experience
3 yrs 9 mos
Average Tenure
1 yr 11 mos
Current Experience

Skan

Senior Business Intelligence Analyst

Jun 2024Present · 1 yr 11 mos · Hybrid

  • ➤ Design Data Models that support automated analysis, pattern detection and AI Agent interactions, optimized for LLM reasoning.
  • ➤ Leading and building the BI Strategy and Architecture in a fast paced environment to deliver lightening fast insights to the customers.
  • ➤ Engineering the Data Warehouse for BI team. Working as an Analytics Engineer honing Data Analytics and Data Engineering skills.
  • ➤ Aggregated the reporting dataset to 18% of the total volume for efficient reporting on Big Data. Daily volume of 1.5+ Billion records.
  • ➤ Reduced the Fabric Capacity usage from 78%+ to sub 28% by identifying redundant processes and optimising reports.
  • ➤ Reduced time to refresh reports by 85% by optimising Data Model, Data source restructuring and DAX Measures.
  • ➤ Implement monitoring systems to maintain high availability and performance of BI solutions. Taking proactive actions for proper resource allocation and ensuring business continuity of analytical products.
  • ➤ Develop and maintain ETL pipelines, technical documentation of design, process and configurations for critical business reports.
  • ➤ Provide mentorship and enforcement of best practices for reporting on Big Data.
Big Data AnalyticsInsight GenerationBusiness IntelligenceData Engineering

Citrix

2 roles

Senior Analytics & Insights Analyst

Promoted

May 2022May 2024 · 2 yrs · On-site

  • ➤ Working with the Business Process Management team for all their data driven decision making by providing them with data, insights, recommendations and self help dashboards and in-depth analysis using SQL and Python.
  • ➤ Responsible for complex analysis projects, providing insights and recommendations to stakeholders, and mentoring junior analysts, reviewing their work and helping when required.
  • ➤ Established reporting infrastructure from data modeling to building shareable reports, ensuring data accuracy and self-service data solutions enabling consistent and reliable reporting. Empowering the end user to track their KPI’s and take timely actions to achieve their targets. Overall work reduced by 73 man days per year.
  • ➤ Reduced overall time to create reports by 70% after establishing an ETL process and Data Models for the entire team to use. Worked with the Data Engineer team to enable the ETL processes in the production database by providing them with complex and business focused SQL queries.
  • ➤ Present weekly business performance reports to track critical metrics, share insights and recommendations. Work with cross functional teams to take necessary actions to work towards business goals.
  • ➤ Established Version Control using the Git for Analytics team to keep track of changes in SQL queries and Power BI releases. Also started the process to document the analytics projects for seamless handover.
  • ➤ Initiated efforts to investigate customer feedback and perform sentiment analysis and identify areas of dissatisfaction of customers related to post sales experience.
  • ➤ Work with the Digital Analytics team to help them with writing and reviewing queries and business logics. Delegated to work with Knowledge base (self help) content classification to help improve the
  • search and quality of this content. Supported in chatbot performance data analysis to track the user behavior to fine tune the bot menu.
Insight GenerationProblem SolvingBusiness IntelligenceData Analytics

Business Intelligence Analyst

Feb 2020Apr 2022 · 2 yrs 2 mos · On-site

  • ➤ Recommended and improved the Scorecard used for a reward program for technical support engineers by normalizing the data and updating the calculation.
  • ➤ Developed forecasting model with 94% accuracy for high Severity case volume QOQ. Recommended shift plans and need for increased human capital to address and adhere to SLA.
  • ➤ Analyzed datasets for correlation of productivity with other key metrics. Created a Machine Learning model using Regression to predict important KPI’s like NPS, ASA, FCR, FDR, First Response SLA and more. Built Trend Analysis capabilities in the dashboards with varying date granularity.
  • ➤ Improved Tableau dashboards performances as high as 97% by using best practices and SQL query optimization. This resulted in increased adoption and self serve.
  • ➤ Developed a standardized QBR presentation template in Tableau for Technical Account Managers which reduced the time to present from 1 day to 5 minutes per customer.
  • ➤ Developed and published 12 Tableau dashboards from end-to-end through a BI lifecycle. Actively communicated with stakeholders to understand and gather requirements, provide weekly updates on the progress followed by maintenance and support post completion.
  • ➤ Led efforts to identify most significant product tags for improving the performance of the chatbot recommended weblinks for 15k knowledge base articles.
  • ➤ Collaborated with the Customer Success team to keep track of the Product usage metrics and helped in identifying the customers in their Lifecycle phases from Onboarding to Expansion. Identified 30% customers in Onboarding phase ready to move into Adoption Phase.
  • ➤ Scheduled meetings with stakeholders from all Geo’s (APAC, EMEA and Americas) for capturing the requirements, understanding their pain points and providing desired solutions. Developed skills required for project management.
Executive ReportingCustomer Satisfaction (CSAT)Business IntelligenceData Analytics

Tata consultancy services

Data Analyst

Sep 2016Jan 2020 · 3 yrs 4 mos · Bengaluru, Karnataka, India

  • ➤Built a VBA based Search Engine for identifying relevant information from a data lake of excel and csv files. Implemented tf-idf and cosine similarity for search enablement.
  • ➤Automated the flow of data population by utilizing the search results on process related documents. Hence reducing the time to complete the activity and reduced rework and manual errors. Resulting in ~$1M cost saving.
  • ➤Built a text mining application for exporting text data from pdf to excel, followed by information retrieval. Identified missing information and highlighted risk.
  • ➤Collaborated with cross functional teams to identify and automate repeat processes. Delivered 30+ process automation and reporting and Natural Language Processing projects.
Microsoft ExcelInsight GenerationData Analysis

Yourfactry

Founder

Aug 2015Jul 2018 · 2 yrs 11 mos

  • College project turned into a business opportunity where I consulted for 3D Modeling and 3D Printing services. Offered in-person group trainings on 3D Modeling tools like Autodesk Fusion 360. Helped bringing visions to life, from personalized gifting to robotics and IOT.
Autodesk Fusion 3603D Printing

Education

International Institute of Information Technology Bangalore

Post Graduate Diploma in Data Science — Data Science

May 2019Jun 2020

Hindustan College of science and technology

Bachelor of Technology (B.Tech.) — Mechanical Engineering

Jan 2012Jan 2016

Sacred Heart Convent Higher Secondary School, Mathura (U.P.)

High School — High School/Secondary Diplomas and Certificates

Jan 1996Jan 2010

Stackforce found 100+ more professionals with Business Intelligence & Data Engineering

Explore similar profiles based on matching skills and experience