Mohit Dahiya, Senior Specialist Reporting and Data Visualization

Mohit Dahiya

Senior Specialist Reporting and Data Visualization

OoredoO

Lieu
Koweït
Éducation
Baccalauréat, Bachelor of Technology in computer science and engineering
Expérience
9 years, 7 Mois

Partager Mon CV

Empêcher usager


Expériences professionnelles

Total des années d'expérience :9 years, 7 Mois

Senior Specialist Reporting and Data Visualization à OoredoO
  • Algérie
  • Je travaille ici depuis janvier 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 à Towell-TAKE Solutions (CMMI Level 5)
  • décembre 2016 à janvier 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 à Excelledia Quality Consulting
  • Qatar
  • août 2016 à décembre 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 à Team Computers (P) Ltd (CMMI Level 3)
  • novembre 2015 à août 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 à Espire Infolabs (P) Ltd (CMMI Level 5)
  • novembre 2014 à novembre 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.

Éducation

Baccalauréat, Bachelor of Technology in computer science and engineering
  • à KURUKSHETRA University
  • août 2014

Master, Diploma in Computer Science and Engineering
  • à Government Polytechnic
  • août 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

Profils Sociaux

Site Web Personnel
Site Web Personnel

Le lien a été supprimé pour non-respect des conditions d'utilisation. Veuillez contacter l’équipe d'assistance pour plus d'informations.

Langues

Anglais
Expert
Hindi
Expert