Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

HIMANSHU KOHLI

Analytics, Data Warehousing & Business Intelligence
Gurgaon,HR

Summary

Accomplished Data Warehousing & Business Intelligence leader with 10+ years of experience in driving impactful analytics and strategic insights. Proficient in SQL, ETL workflows, and complex data solutions. Proven success in managing high-stakes projects, optimizing data processes, and delivering actionable business intelligence. Adept at fostering team collaboration and communicating insights effectively. Seeking to leverage expertise to excel in a Analytics role and drive data-driven success.

Overview

10
10
years of professional experience

Work History

Manager - BI & DW

DecisionTree Analytics & Service
10.2022 - Current
  • Role involves setting the team priorities, partnering effectively with customers and stakeholders. You establish a roadmap and successfully deliver BI solutions that meet the business needs.
  • Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
  • Cross-trained existing employees to maximize team agility and performance.
  • Managed end-to-end Business Intelligence deliverables, including ETL Pipelines development, writing complex SQL queries and Tableau Reporting to provide data insights to the client

Senior Lead Data Analyst

DecisionTree Analytics & Services
04.2022 - 09.2022
  • Assisted the B2B businesses to improve the Cash Conversion Cycle by providing the insights on 'Days sales outstanding' and Days payable outstanding'
  • Enhanced data-driven decision-making by streamlining data collection and analysis processes.
  • Built data models to setup and manage data warehouses for the existing clients.
  • Along with stakeholders and team management, mastered the hands on complex SQL query skillset.

Lead Data Analyst

DecisionTree Analytics & Services
04.2020 - 03.2022
  • Provided actionable insights to senior management, resulting in a 25% increase in operational efficiency
  • Identified key market trends through data analysis, resulting in a 25% increase in market share
  • Created interactive dashboards that provided real-time insights, improving decision-making by 40%
  • Developed data-driven strategies that led to a 30% reduction in customer churn rate.

Senior Data Analyst

DecisionTree Analytics & Services
01.2018 - 03.2020
  • Designed and implemented practical Data Warehouse architecture
  • Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
  • Managed MS-SQL development to solve client's business problems
  • Proficient in Microsoft SQL Server (T-SQL), PostgreSQL, and Oracle coding
  • Supported stakeholders in analyzing sales performance by building Sales Leadersboard based on metrics like quota attainment and revenue generation

Programmer Analyst

Cognizant Technology Solutions
06.2014 - 01.2018
  • Trained in SQL and Data Warehousing concepts
  • Worked in Retail and Insurance Vertical
  • Collaborated to enhance supportability and identify performance issues.

Education

Post Graduate Program - Artificial Intelligence & Machine Learning

Great Lakes Institute of Management

Bachelor of Technology -

Galgotias College of Engineering & Technology

Coursera Certification: Data Management And Visualization - undefined

Wesleyan University

Skills

  • Analytics
  • Data Warehousing
  • SQL
  • ETL
  • Strong problem-solving abilities
  • Tableau
  • Team Leadership
  • Business Intelligence
  • Requirement Gathering
  • Stakeholder Management
  • Problem Solving Skills

Accomplishments

  • Awarded the "Circle of Joy" Award in 2022 at DecisionTree for creating an exceptional experience for clients and stakeholders, consistently receiving outstanding feedback.
  • Recognized as the "Star Performer of the Year" in 2019 at DecisionTree for exceptional performance and impactful contributions to the Business Intelligence Department.
  • Received the "Exemplary Performer" certificate from a Fortune 1 client at Cognizant in 2016, with frequent commendations for delivering high-quality results and exceeding expectations.
  • Supervised team of 10 staff members.

Timeline

Manager - BI & DW

DecisionTree Analytics & Service
10.2022 - Current

Senior Lead Data Analyst

DecisionTree Analytics & Services
04.2022 - 09.2022

Lead Data Analyst

DecisionTree Analytics & Services
04.2020 - 03.2022

Senior Data Analyst

DecisionTree Analytics & Services
01.2018 - 03.2020

Programmer Analyst

Cognizant Technology Solutions
06.2014 - 01.2018

Post Graduate Program - Artificial Intelligence & Machine Learning

Great Lakes Institute of Management

Bachelor of Technology -

Galgotias College of Engineering & Technology

Coursera Certification: Data Management And Visualization - undefined

Wesleyan University
HIMANSHU KOHLIAnalytics, Data Warehousing & Business Intelligence