Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Languages
Websites
Timeline
Generic
ROHIT GUPTA

ROHIT GUPTA

Delhi

Summary

Motivated BI Consultant with expertise in Analytics. Offering excellent communication and organizational abilities along with skill in SQL and fluency in QlikView/Qliksense/Power BI. Known for efficiency and best-in-class time management.

Overview

5
5
years of professional experience

Work History

Associate Consultant

AXA XL
Gurgaon
10.2022 - Current
  • Migration from QlikView to Power BI.
  • Developed new reports on Power BI as well as Qlik.
  • Reviewed existing reports generated by other team members and suggested improvements where needed.
  • Provided technical expertise in developing, deploying and optimizing Business Intelligence solutions.
  • Utilized BI tools to design and deploy user interfaces.
  • • Increased stakeholder satisfaction by presenting clear, concise, and insightful visualizations of complex data sets using Power BI.
  • Established strong working relationships with clients through exceptional communication skills, fostering trust and collaboration.
  • Adapted quickly to new technologies and programming languages, enhancing overall team productivity

Associate Projects

Cognizant
Gurgaon
09.2021 - 10.2022
  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Discussed issues with team members to provide resolution and apply best practices in Minerva.
  • Designed customized solutions for proposals to potential customers in Qlik.
  • Developed Drill through Qlik Dashboards which enabled users to drill down between dimensions, use of concepts like Set Analysis, joins, master Calendar in built functions and containers.
  • Development of Qlik Sense Dashboards for Minerva
  • Provided Support in Apps Development in Novartis
  • Used SQL for validation and and DB

BI Consultant

TEAM COMPUTERS PVT. LTD, Maruti Suzuki Pvt. LTD
06.2019 - 09.2021
  • Transformed project data requirements into project data models
  • Developed Dashboards in Qlik Sense at AVIVA life Insurance, and KIA Motors as well as got hand-on NPrinting
  • Developed POC for SANY group to show their Growth Analysis based on data shared
  • Development of Qlik Sense Dashboards for inhouse CRM
  • Provided Support App Development in Panasonic
  • Developed Inhouse Dashboards for Pharma and Healthcare Domain
  • Migration project from QlikView to Qlik sense in Maruti Suzuki Pvt. Ltd.
  • Developed Drill through Dashboards which enabled users to drill down between dimensions and Used concepts such as Set Analysis, joins, link tables, cyclic groups, master calendar, in built functions, container.

Education

B. TECH - Computer Science and Engineering

P.I.E.T
Panipat, Haryana
08-2019

12TH -

Mount Abu Public School
Rohini
05-2015

10TH -

Rukmini Devi Public School
Pitampura, Rohini, Delhi
05-2013

Skills

  • QLIK SENSE
  • Power Bi
  • QLIKVIEW
  • QMC
  • Hands-on on N Printing
  • Data Visualization
  • Data Analysis
  • Technical Analysis
  • SQL
  • Timeline Development
  • Work Planning and Prioritization

Affiliations

  • A technology driven professional with 4.5 relevant years of experience in Data Analytics with various technologies
    and tools like Qlik Sense and Power BI.
  • Currently working as Associate Consultant - BI at AXA XL.
  • Strong knowledge in designing and developing Qlik and Power BI dashboards by extracting data from multiple sources like
    SQL Server, Excel files, MS Access, etc.
  • Requirement Gathering, Data Cleaning, Problem Solving and Quality & Performance Testing.
  • Expertise in Advanced Set Analysis, and DAX and implementing the security model.
  • Experience in error handling and debugging of Qlik and Power BI reports. Expert in handling production issues like report
    failures, resolving synthetic keys, Relationships, Performance optimization and Data modelling.
  • Migration of Dashboards and Reports from Qlikview to Qliksense.
  • Migration of Dashboards and Reports from Qlikview to Power BI.

Accomplishments

  • Positive Commitment - Team Work - Dec`23
  • I Appreciate - Oct`23
  • I made a Difference - Mar`23

Languages

Hindi
First Language
English
Intermediate (B1)
B1

Timeline

Associate Consultant

AXA XL
10.2022 - Current

Associate Projects

Cognizant
09.2021 - 10.2022

BI Consultant

TEAM COMPUTERS PVT. LTD, Maruti Suzuki Pvt. LTD
06.2019 - 09.2021

B. TECH - Computer Science and Engineering

P.I.E.T

12TH -

Mount Abu Public School

10TH -

Rukmini Devi Public School
ROHIT GUPTA