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
Mathura12.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.