Mohit Dahiya, Senior Specialist Reporting and Data Visualization

Mohit Dahiya

Senior Specialist Reporting and Data Visualization

OoredoO

Location
Kuwait
Education
Bachelor's degree, Bachelor of Technology in computer science and engineering
Experience
9 years, 6 Months

Share My Profile

Block User


Work Experience

Total years of experience :9 years, 6 Months

Senior Specialist Reporting and Data Visualization at OoredoO
  • Algeria
  • My current job since January 2020

Projects: - Inhouse Dashboards
●Facilitated business decision-making, producing clear, dynamic data visualizations in Qlik / Power BI to communicate trends.
●Responsible for daily, weekly, and monthly CEO/CCO Business and Sales Performance Pack, and Revenue Forecasts.
●Predicted Customer Churn using Qlik AutoML.
●Executed large-scale data analytic projects for Ooredoo to identify gaps in business processes and create data reports outlining findings, allowing users to drill in any direction, follow their curiosity, and uncover actionable insights, resulting in the consolidation of multiple departments.
●Lead agile projects as a business interface for digital teams for innovative Business Intelligence and Advanced Analytics tools.
●Drove initiatives to enhance automation for data reporting across the organization, which eliminated manual tasks related to lead management and validation and saved over 100 work hours per year.
●Develop custom SQL queries & DWH to establish effective data models leading to insightful business intelligence visualizations.
●Completed weekly root cause analysis and reports by extracting information from data sets.
●Defining Data Models, Architectures, and Standards.
●Work alone and in collaboration with teams (Marketing, Sales, customer care, and customer loyalty) to build exact bi dashboards leading to statistically significant increases in work order response and completion percentages, cost savings, budget planning, and additional business functions.
●Effectively communicate results and insight into dashboards, business processes, and other related documents.
●Manage the entire process of designing, developing, testing, and publishing a dashboard.
●Collaborated with the production support team and performed root cause analysis to fix critical issues.
●Developed ETL mappings to integrate disparate source data into the staging layer and, transform and load into the data warehouse.
●Significant experience in Telecom.

Business Intelligence Analyst at Towell-TAKE Solutions (CMMI Level 5)
  • December 2016 to January 2020

Projects: - RPx Dashboard, Sales Dashboard, Finance Dashboard, HR Dashboard. Clients:- Pepsi, Enhance, Mazoon Dairy Company (S.A.O.C), Fairtrade, CPD, National Mineral water, Bustan Al Khaleeji (Kuwait)
●Presented and communicated actionable insights in a way tailored to the specific audience and client's needs.
●To cultivate a design i.e. professional in nature in the form of a Proof of Concept to showcase generated leads to prospective clients based on clientele's business requirements.
●Created automation framework for 100+ reports for different clients and reduced processing time by 70%.
●To conduct a steady process that is based on Extraction, Anticipation, Constraining, Translating, Verifying, and Managing Requirements that are essential for System and Operations Maintenance.
●Applied knowledge of data modeling and statistical analysis to note trends and draw conclusions.
●Analyzed large datasets, drawing meaningful conclusions and providing actionable recommendations.
●To develop Data Modelling, ETL (Extract, Transform and Load) interface, and BI Reports using QlikSense, QlikView, and Microsoft Power BI Software.
●To have gained and utilized Processes and Information using Transact-SQL for Relational Databases.
●Actively pursued new methods to track, calculate, and report data for the client.
●Improved business intelligence report performance by creating aggregated fact tables and partitioning fact tables.
●Develop custom SQL queries and alternative methods to establish effective data models leading to insightful business intelligence visualizations.
●Defining Data Models, Architectures, and Standards.
●Experience delivering E2E projects
●Significant experience in FMCG.

Business Intelligence Analyst at Excelledia Quality Consulting
  • Qatar
  • August 2016 to December 2016

Projects: - Finance Dashboard, Sales Dashboard. Clients: - Al-Ahli Hospital, Barq construction group, Gulf Helicopters, DEWA Dubai
●Implemented BI solution framework for end-to-end business intelligence projects.
●To cultivate a design i.e. professional in nature in the form of a Proof of Concept to showcase generated leads to prospective clients based on clientele's business requirements.
●Created automation framework for 50+ reports for different clients and reduced processing time by 80%.
●Showing clients' financial details through the dashboard.
●HealthCare Dashboard, Finance Dashboard, Company's wealth.
●Extract requirements, anticipate requirements, constrain requirements, translate requirements, Verify requirements, manage requirements, System and operations maintenance.
●Reports are created using QlikSense to the requirement of the end-user.
●Defining Data Models, Architectures, and Standards.
●Client's user training

Software Developer at Team Computers (P) Ltd (CMMI Level 3)
  • November 2015 to August 2016

Projects: - Business Kockpit, Finance Kockpit. Clients: - Casio, Hitachi, Parijat, Team Computers, Safex, AIMIL, JBM Group
●Deliver projects and products using the appropriate project management methodology, learning & iterating frequently.
●Making Dashboards as per the client's requirements as a Proof of Concept to convert generated leads into Prospective clients.
●Handled clients: CASIO, Neel Auto (JBM Group), HITACHI, Magnum, and Channel Play.
●Extensively used QlikView reporting functionality such as Incremental load, Partial load, Resident load, Sorting, Creating QVD, Section Access, Variables, Tables, Charts, etc. using QlikView BI tool.
●Responsible for Publishing and Server setup.

Software Developer at Espire Infolabs (P) Ltd (CMMI Level 5)
  • November 2014 to November 2015

Projects: - Sales Analysis Dashboard, Stock Inventory Analysis Dashboard Clients: - Rebound UK
●Performed data visualization and interpretation using Qliksense, Qlikview, batch scripting, and SQL server.
●Responsible for understanding User Requirements and suggesting charts and trends and various KPIs to them.
●To cultivate a design i.e. professional in nature in the form of a Proof of Concept to be Responsible for POC (Proof of Concept).
●Produced detailed, data-driven insights and reports using online BI software to inform strategic business decisions.
●Publishing and Server setup.
●Created reports using Mashups in Sales Analysis Dashboard, and Stock Inventory Analysis Dashboard.
●A Mashup is a web page that uses content from more than one source to create a single new service displayed in a single graphical interface.
●Using Mashup HTML/CSS and JavaScript to embed the objects which cannot be done in Qlik Sense.
●Using Mashup to edit fonts, add new charts, embed images, and customize look and feel.
●Reports are created using QlikSense to the requirement of the end user.

Education

Bachelor's degree, Bachelor of Technology in computer science and engineering
  • at KURUKSHETRA University
  • August 2014

Master's degree, Diploma in Computer Science and Engineering
  • at Government Polytechnic
  • August 2011

Specialties & Skills

Business Analysis
Qlik Sense
Qliksense
QlikView
POWER BI
AUTOMATION
DASHBOARD
EXTRACT TRANSFORM LOAD (ETL)
BUSINESS INTELLIGENCE
SQL (PROGRAMMING LANGUAGE)
VISUALIZATION
COLLABORATION
AGILE PROJECTS

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

English
Expert
Hindi
Expert