Rakesh Gujari

Data Analyst with 1+ years of experience in data visualization, SQL databases, and statistical analysis. Proficient in Python, SQL, Power BI and Matplotlib for extracting insights, automating workflows, and developing interactive dashboards. Delivered data-driven solutions for Fortune 500 clients, optimizing decision-making and operational efficiency. Experienced in analyzing complex datasets, improving data accuracy, and applying predictive analytics to drive actionable business insights.

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

Bachelor of technology - computer science - NIILM University of KAITHAL (2021-09 - 2024-06)