Summary
Overview
Work History
Education
Skills
Technical & Analytical Skills
Soft Skills
LANGUAGES
Timeline
Generic

Nikhil Sharma

Rourkela

Summary

Lead Data Analyst with 4 years of experience in data analysis, visualization, and ETL processes, with proficiency in tools such as SQL, Looker, Tableau, Power BI, and Qlik Sense. Skilled in designing scalable dashboards, optimizing data pipelines, and transforming complex datasets into clear, actionable insights. Proven track record of enabling data-driven business decisions that improve operational efficiency, uncover growth opportunities, and drive strategic initiatives. Committed to continuous improvement and delivering high-impact analytical solutions across cross-functional teams.

Overview

4
4
years of professional experience

Work History

Lead Data Analyst

Sun King
04.2024 - Current
  • Orchestrated end-to-end execution of data projects, ensuring on-time delivery and adherence to budget.
  • Led a team of 3 analysts, providing strategic direction, mentorship, and fostering their professional development.
  • Implemented the EPI (Early Payment Incentive) program by integrating updated commission structures, resulting in a 30% increase in loan collections.
  • Conducted A/B testing on SMS and call interventions, achieving a 30% cost reduction and saving approximately $15,000 per month.
  • Analyzed Customer Lifetime Value (CLTV) and designed a follow-on sales approach, leading to a 40% increase in repeat sales.
  • Ran simulations on existing data to design agent incentive structures and task logic, driving improvements in both sales and collections.
  • Improved Looker performance by optimizing LookML code and using Persistent Derived Tables (PDTs), resulting in faster data refreshes and more efficient query processing.

Data Analyst

Sun King
11.2022 - 03.2024
  • Created Looker dashboards and reports that enabled actionable insights, leading to a 35% increase in data-driven decision-making across internal and external stakeholders.
  • Collaborated with data engineering teams to optimize database structures and query performance, achieving a 20% reduction in response times.
  • Developed interactive dashboards offering real-time insights into sales, collections, and product performance, contributing to a 20% increase in sales revenue and a 15% reduction in collection times.
  • Built custom Looker reports integrated with a B2B mobile app, improving sales agent efficiency by 24% and enhancing field accessibility to key data.
  • Led weekly and monthly incentive processing for field sales agents across 11 countries, using Looker Looks and dashboards to validate sales, collections, and eligibility metrics; ensured accurate, timely payouts and resolved issues proactively to maintain a smooth payout cycle.
  • Automated the entire incentive process using Apache Airflow, integrating Looker backend queries, storing output files on Amazon S3, and triggering automated email alerts to finance teams—enhancing accuracy, efficiency, and transparency in incentive distribution.

Data Analyst

Ganit Inc.
06.2021 - 10.2022
  • Client Collaboration & Requirement Gathering: Engaged with clients in retail, FMCG, and QSR domains to understand business needs, define KPIs, and translate requirements into actionable BI solutions.
  • Dashboard Development: Designed and developed interactive dashboards in Tableau, Qlik Sense, and Power BI to visualize key metrics across inventory, sales, marketing, customer retention, and operational performance.
  • Data Modeling & ETL: Built and optimized ETL pipelines using SQL; created and maintained QVD files in Qlik Sense, implemented incremental loads, and integrated data from diverse sources (SQL Server, Excel, CSV).
  • Advanced Analytics: Used SET Analysis (Qlik Sense) and DAX functions (Power BI) to develop over 26+ complex KPIs and calculated measures including YTD, MTD, YOY growth rates.
  • Customer Insights & Marketing Analytics: Delivered actionable insights on personalized marketing performance and lapsing customer trends at the store and regional level, helping drive targeted strategies.
  • Documentation & Optimization: Created technical and functional documentation, and collaborated with client analytics teams to optimize data sources for faster dashboard performance.

Education

Bachelor of Technology - Biomedical Engineering

National Institute of Technology
Rourkela,India
04-2021

Intermediate - Science (PCM)

Deepika English Medium School
Rourkela,India
03-2016

Skills

  • Looker
  • Tableau
  • Qlik Sense
  • Power BI
  • JIRA
  • PyCharm
  • Google Colab
  • MS Office

Technical & Analytical Skills

  • SQL
  • Python
  • LookML
  • Airflow
  • NumPy, Pandas
  • Market Research and Strategy
  • Data Analysis
  • Data Visualization
  • Business Analysis
  • Financial Analysis
  • A/B Testing
  • Strategic Analysis

Soft Skills

Communicaon, Problem Solving,

Team Player, Creave,

Time Management.

LANGUAGES

English: Full Professional Proficiency
Hindi: Native Proficiency

Timeline

Lead Data Analyst

Sun King
04.2024 - Current

Data Analyst

Sun King
11.2022 - 03.2024

Data Analyst

Ganit Inc.
06.2021 - 10.2022

Bachelor of Technology - Biomedical Engineering

National Institute of Technology

Intermediate - Science (PCM)

Deepika English Medium School

Similar Profiles

CREATE PROFILE
Nikhil Sharma