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, Haryana08-2019
12TH -
Mount Abu Public School
Rohini05-2015
10TH -
Rukmini Devi Public School
Pitampura, Rohini, Delhi05-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