Manu Raj Gehlot

Data Analyst @ University of the People

About

Data Analyst with 3.5+ years of experience in Power BI, Advanced SQL, Python, Google BigQuery, Excel, Microsoft CRM, and Azure Databricks, specializing in dashboard development, ETL/ELT pipelines, KPI reporting, and large-scale data analysis (100M+ rows).I help business and leadership teams make faster, data-driven decisions by transforming complex datasets into clear, actionable insights through automated reporting and analytics solutions. Key impact delivered: • 50% faster decision-making through automated Power BI dashboards • 40% improvement in data accuracy via robust data validation and ETL processe • 15–18% increase in conversion and target achievement through funnel and performance analytics • 2–3% improvement in forecast accuracy using time-series analysis and statistical modeling My experience spans admissions analytics, marketing analytics, supply chain forecasting, inventory optimization, and KPI performance tracking, with hands-on expertise in EDA, statistical analysis, forecasting, and machine learning model building deployment. I enjoy working at the intersection of business, analytics, and automation, collaborating with cross-functional teams to solve real-world problems using data. Open to Data Analyst / Power BI / Business Intelligence opportunities (Remote / Hybrid).

Country

India

City

Bhopal

Industry

Information Technology & Services

Skill

Customer Relationship Management (CRM), SQL Server Integration Services (SSIS), SQL Server Management Studio, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Mathematics, Business Metrics, Product Analytics, Business Insights, Statistics, Analytics, Dashboards, Organization Skills, Teamwork, Data Pipelines, English, Computer Science, Learning, Skill Development, Seaborn

Experience

Data Analyst

University of the People

2024-11 - Present · 1 yr 11 mos

Mysore, Karnataka, India

Data Analyst

Vizlogic Digital Solutions Pvt. Ltd.

2022-12 - 2024-11 · 2 yrs

A.working for our client Procter on gamble as a data analyst on there various projects like DCPFR, OLA ,MRCPFR . which involved collaborating with business users, collecting requests, and updating a set of existing power bi reports B. Did ETL from various sources like share point, excel, Azure data bricks in power bi and wrote complex power queries and measures in power bi C. Created, Developed, and maintained DCPFR-related reports like distributor-sbf ordering accuracy , source accuracy , top losses in power bi by processing huge amounts of data and finally publishing it on power BI service which improved decision-making with the following outcomes 1. Improved ordering of sub-brand form by particular distributors by reporting accuracies with the help of forecast and Actual sales of sub-brand form using MAPE as a measure which improved monthly accuracies by 2 to 3 % month on month 2. Build top losses reports across categories and overall wise which helped the business team to identify top losses and improve decision-making and optimize the inventory and save business cost 3. Helped various teams to identify better suited model for particular sub-brand form so that prediction meets the Actual sales for particular month and improves decision making due to improved accuracy 4. Maintained table ensuring correct mapping of distributor with its branches and ensured that none of the branches are being missed out D. Wrote complex Python code and SQL queries to ensure proper maintenance and reporting of data E. performed data validation in Azure Data Studio ,SSMS and Excel