Rakesh Gujari

Data analyst - patio Digital pvt ltd - noida, India

(2026-01)

Designed and deployed 4+ interactive Power BI dashboards for DICC (UMANG & DigiLocker, AIindia) covering SLA monitoring, agent productivity, audit reports, and attendance tracking.
Assisted in optimizing data transformation processes, improving efficiency by 40% and significantly reducing manual effort by over 16 hours per week.
Collecting, analyzing, interpreting, and presenting data required for business reporting and decision-making.
Developing, managing, and maintaining dashboards, trackers, data models, and analytical reports across business functions.
Automating manual reporting processes wherever possible using advanced Excel, Power BI, Google Suite, or similar platforms.
Coordinating with internal departments to gather data, validate inputs, and ensure completeness of information.
Optimized SQL queries and integrated databases within Power BI, reducing data refresh time and improving report accuracy.
The company reserves the right to assign or modify your responsibilities in the future, based on operational or business requirements, without altering your employment terms or compensts.

Data analyst trainee - Caliqik technology pvt ltd - Navi Mumbai India

(2025-07 - 2025-12)

large-scale datasets using SQL and Python (Pandas, NumPy) applying data mining techniques Handled to enhance accuracy.
Performed data mining and statistical analysis using SQL improving business decision-making efficiency by 20%.
Conducted statistical analysis on 2M+ data points using hypothesis testing and variance analysis, providing insights that influenced product development strategies.
Present data in a clear, interactive format to assist stakeholders in understanding complex data trends and results.
Designed interactive dashboards and reports in Power BI and Excel, providing real-time insights for data driven decisionmaling
Developed advanced Excel-based automation solutions, including dynamic dashboards, pivot tables, and VBA macros, improving data processing efficiency by 40%.
Monitored system performance using Intel Aternity, identifying anomalies enabling proactive issue resolution to enhance operational efficiency by 20%.
Collaborated with cross-functional teams to enhance reporting accuracy, improving efficiency by 25%.

Data Analyst (Ai variant Intern)

(2024-11 - 2025-02)

Conducted data cleaning and manipulation tasks to ensure accuracy and completeness of datasets.
Analysed and visual data using SQL, python, power Bi, Excel and tableau to identify trends and patterns for insights
Prepare reports on the above information and published

About