Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Work Availability
Timeline
Technical Knowledge
Technical Knowledge
Personal data processing
Generic

Mahavir Sharma

Gurgaon

Summary

Results-driven BI specialist with 12 years of experience designing, developing, and optimizing enterprise data solutions. Proven expertise in Power BI and Tableau for interactive dashboards and advanced visualizations, combined with strong skills in SQL for data modeling, querying, and performance tuning. Extensive background in SSIS for ETL processes and SSAS for multidimensional/Tabular models, enabling scalable analytics solutions. Adept at collaborating with cross-functional teams to translate business requirements into actionable insights, driving data-informed decision-making and operational efficiency

Overview

16
16
years of professional experience
1
1
Certificate

Work History

Technical Specialist (Power-BI, Tableau, SQL)

CitiusTech Healthcare Technology Private Limited
10.2023 - Current
  • Developed and maintained ETL processes to integrate data from multiple sources.
  • Collaborated with stakeholders to gather requirements and deliver data-driven solutions
  • Optimized data models and performance for large datasets.
  • Created interactive dashboards in tableau with full pledge functionality.
  • Migrated reports from Tableau to Power BI & QlikView.
  • Created the power BI reports using complex DAX like SUMMARIZE, RELATED, USERELATIONSHIP, SELECTEDVALUE, RANKX, DATEADD, SAMEPERIODLASTYEAR, KEEPFILTERS etc.
  • Created new dashboards based on the client requirement within the time limit and analyze the dashboard performance.
  • Provided training and support to users on Power BI best practices.
  • Worked with multiple project with advance tableau functions and created interactive business solutions.

Technical Lead (Power-BI, Tableau)

HCL Technology
06.2022 - 10.2023
  • Understand business requirements in BI context and design data models to transform raw data into meaningful insights
  • Created dashboards and interactive visual reports using Power BI & Tableau 2022.2.
  • Identify key performance indicators (KPIs) with clear objectives and consistently monitor those.
  • Created relationships between data and develop tabular and other multidimensional data models.
  • Created customize charts and custom calculations as per requirements.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed Tableau workbooks from multiple data sources using Data Blending in a single story.
  • Built dashboards for measures with forecast, trend line and reference lines.
  • Chart creation and data documentation explaining algorithms, parameters, models, and relations
  • Performed DAX queries and functions in Power BI.
  • Created complex DAX measures and calculated columns for data analysis.
  • In order to process and magnify the raw data, a complete automation in excel reports using VBA.

Associate Project Control Admin (Power-BI, Tableau)

Lutec Resource Pvt. Ltd. (Client-McDermott)
09.2019 - 05.2021
  • Created dashboard on Tableau desktop and Power BI and migrated from Tableau to PBI.
  • Worked with multiple data source (Cloud, SQL) and connected to Tableau Live or by making extract.
  • Related the data from different sources or table by using blending or joining.
  • Worked with high level dashboards with various functionality Like actions, buttons, parameter, custom visuals and containers etc.
  • Published the dashboard on tableau server and maintaining the row level security with the users.
  • Worked with power BI DAX like CALCULATE, ALL, ALLEXCEPT, ALLSELECT, FILTER, SUMMARIZE, USERELATIONSHIP, SELECTEDVALUE, RANKX, DATEADD, SAMEPERIODLASTYEAR
  • Data Model, relationship, query editor and user access management on power BI workspace.

Data Analyst Finance (E2)

Fareportal India Pvt. Ltd.
03.2015 - 02.2019
  • Integrated Advance Excel formulas (V-lookup, H-lookup, index, offset, match, array formulas, loops, arrays etc..) and VBA techniques to manipulate & Automate spreadsheets
  • Build dynamic Pivot tables and Charts using VBA
  • Integrated Error handling to log errors and notify users
  • Use VBA to import data from WEB application (IE, Chrome, M Firefox)
  • Dashboard Designing, Report Automation, VBA Development.
  • Using DAX functions perform various calculations to design KPI driven dashboard. In Tableau perform the calculation by using the different types of functions, LOD and parameters.

MIS Executive

SIPL (Securitrans India Pvt. Ltd.)
12.2012 - 10.2014
  • Created Billing Data as per indent report on daily basis in Excel sheet.
  • Coordinated with regional branches for collecting cash load data and generate the CBR reports.
  • Weekly Takeover & Handover Report
  • Weekly EOD Reports, Branch & Region wise performance chart.
  • Prepared MIS Reports using advance excel formula like Lookup, match, conditional formatting, arrays and VBA (Macros) code for automation.
  • I've provided 2 Years of coaching in BALA KRISHNA Coaching Institute in Mathura for Basic & Advance MS Excel, MS Access, Ms Word, Macro Programs. Date 07th Aug 2010 to 05th Dec 2012

Coaching Instructor

BALA KRISHNA Coaching Institute
08.2010 - 12.2012
  • I've provided 2 Years of coaching in BALA KRISHNA Coaching Institute in Mathura for Basic & Advance MS Excel, MS Access, Ms Word, Macro Programs.

Education

BCA -

BIMT collage Vrindavan
Mathura
12.2009

Skills

  • Tableau expertise
  • Power BI expertise
  • Experience with Google Analytics
  • Advanced Excel proficiency
  • Database querying
  • ETL process management
  • Data analysis with SSAS
  • Snowflake data management
  • Presentation design
  • VBA programming
  • Automation using macros
  • Skilled in Python development
  • Artificial intelligence

Accomplishments

  • Achieved automated BI(Power BI) reports by introducing JIRA/ADO for Sprints/Kanban board tasks.

Certification

Power BI Certified

Tableau Certified

Languages

English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Technical Specialist (Power-BI, Tableau, SQL)

CitiusTech Healthcare Technology Private Limited
10.2023 - Current

Technical Lead (Power-BI, Tableau)

HCL Technology
06.2022 - 10.2023

Associate Project Control Admin (Power-BI, Tableau)

Lutec Resource Pvt. Ltd. (Client-McDermott)
09.2019 - 05.2021

Data Analyst Finance (E2)

Fareportal India Pvt. Ltd.
03.2015 - 02.2019

MIS Executive

SIPL (Securitrans India Pvt. Ltd.)
12.2012 - 10.2014

Coaching Instructor

BALA KRISHNA Coaching Institute
08.2010 - 12.2012

BCA -

BIMT collage Vrindavan

Technical Knowledge

Tableau, Power BI, Google Analytics, Advance Excel, MSSQL, MS Access, Oracle, Snowflake, Advance Excel, MS Word, Power point, VBA (Visual Basic for Applications), Macros, SQL

Technical Knowledge

Tableau, Power BI, Google Analytics, Advance Excel, MSSQL, MS Access, Oracle, Snowflake, Advance Excel, MS Word, Power point, VBA (Visual Basic for Applications), Macros, SQL

Personal data processing

I declare that the information and facts stated above are true and correct to the best of my knowledge and belief.
Mahavir Sharma