Sumit Sharma
Faridabad
Summary
Dynamic BI Developer with extensive experience at JLL India Pvt Ltd and SHL India Pvt Ltd, proficient in Tableau, PowerBI, SQL, and Alteryx. Expertly designed automated workflows and interactive dashboards, significantly improving decision-making and operational efficiency. Skilled in stakeholder collaboration, generating impactful insights, and promoting team development. Dedicated to providing data-driven solutions that enhance performance.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior BI Developer
JLL India Pvt Ltd
Gurugram
04.2024 - Current
- Optimized cross-functional team performance, raising efficiency metrics (Productivity, Production Availability and OOE) from 50% to 98%, 45% to 90%, and 50% to 99% respectively using Azure Databricks and Power BI.
- Developed a text-to-SQL agentic AI system that interacts with SQL Server databases to answer user queries, leveraging ChatGPT’s NLP and LLM capabilities through API-based integration.
- Led the development of an end-to-end reporting solution for the Sustainability department, streamlining data collection and management via PowerApps and delivering insight-driven dashboards using Power BI, improving decision-making.
- Created Tableau dashboards for Accounts Payable to visualize transaction trends and bottlenecks, automating 15 FTE tasks and enhancing workflow efficiency.
- Developed automated tool to clean and process unstructured data for Power BI in Purchase Card project using Python libraries Pandas and Numpy.
- Defined key performance indicators with stakeholders to ensure alignment with strategic reporting goals.
- Automated data processes using Alteryx for ETL. Sourced vital data from platforms like Workday for enhanced analytical insights.
Senior Lead Business Intelligence
SHL India Pvt Ltd
Gurugram
05.2019 - 04.2024
- Developed and maintained Tableau and PowerBI dashboards for senior leadership, including COO and CEO.
- Lead a team of 3 members highly motivated and keen to learn and explore.
- Developed Tableau dashboards for Managed Services Director to visualize Salesforce data metrics.
- Developed and optimized complex Alteryx workflows, implementing scheduling on Alteryx server.
- Automated manual processes for clients using VBA and Python tools to enhance efficiency.
- Developed python selenium tool to download SFDC data from frontend for reporting.
MIS Executive - Reporting and Automation
InfoEdge India Pvt Ltd
08.2017 - 05.2019
- Responsible for creating daily, weekly, monthly, quarterly, half yearly and yearly reports for different team Managers and Vice President.
- Responsible for implementing automation for all the manual tasks in reporting.
- Migration of Excel Reports in PowerBI Desktop.
- Developed and maintained more than 50+ automation tools.
Data Analyst Intern
Gwynnie Bee India Pvt Ltd
New Delhi
12.2015 - 01.2017
- I helped Data Scientist in day to day activities to clean, process an upload data in tableau.
- I was responsible for maintaining a project called Welcome Call to track the number of new subscribers in the system using Impala and Tableau.
- Learned VBA and Excel and created automated and manual reports and shared on daily, weekly and monthly basis.
Education
Master of Computer Application -
Amity University
Noida, India01-2021
B.Sc - IT
Kuvempu University
Shimoga, Karnataka01-2015
Skills
- Power BI Desktop
- Power BI Workspace
- Power Automate
- Tableau Desktop
- Tableau Server
- Tableau Prep
- PowerApps
- SQL
- Exasol
- Alteryx Designer
- Azure Databricks
- Python - Selenium, Pandas, openpyxl
- Impala
- Sharepoint List
- VBA
- Advance Excel
- Salesforce
- Business Intelligence
- Data Analyst
Accomplishments
• Won the Collaboration Champion Award at JLL India Pvt Ltd.
• Received Above and Beyond Award and from Client in JLL India Pvt Ltd.
• Won quarterly award optimizing Analytics and Automation team in SHL India Pvt Ltd.
• Won 2 times Pioneer award in organization level in InfoEdge India Pvt. Ltd.
• Received Above and Beyond Award and from Client in JLL India Pvt Ltd.
• Won quarterly award optimizing Analytics and Automation team in SHL India Pvt Ltd.
• Won 2 times Pioneer award in organization level in InfoEdge India Pvt. Ltd.
Certification
- GNIIT (Software Engineering)
- Data Science Bootcamp IIT Delhi 2025
Languages
- Hindi
- English
LinkedIn Profile
https://www.linkedin.com/in/sumit-sharma-1427ab120
Timeline
Senior BI Developer
JLL India Pvt Ltd
04.2024 - Current
Senior Lead Business Intelligence
SHL India Pvt Ltd
05.2019 - 04.2024
MIS Executive - Reporting and Automation
InfoEdge India Pvt Ltd
08.2017 - 05.2019
Data Analyst Intern
Gwynnie Bee India Pvt Ltd
12.2015 - 01.2017
Master of Computer Application -
Amity University
B.Sc - IT
Kuvempu University