Rakesh Rao

Rakesh Rao

Data Analyst
UAE
English, Hindi
Full-time On-site

About Me

Data Analyst and BI Developer with 5+ years of experience across financial services, analytics support and MIS reporting. Skilled in Power BI, Tableau, AWS QuickSight, SQL, Python, Snowflake and Databricks, with hands-on…

Experience

Assistant Manager - Data Analyst

Motilal Oswal Financial Services Pvt. Ltd. · Mumbai, India
Jan 2024 - Aug 2026 · 2 years 7 months

<p>Developed 30+ interactive dashboards using Power BI, Tableau and AWS QuickSight for business reporting.</p><p> Automated 10+ recurring reports using Python and Excel, reducing manual effort by 40%.</p><p> Performed sales forecasting and product performance analysis to support business decisions.</p><p> Queried and transformed large-scale datasets using SQL, Snowflake and Databricks, ensuring 99% data accuracy for reporting and analytics.</p><p> Implemented data validation checks, including null, duplicate and reconciliation checks, to maintain data quality.</p>

Support Engineer (Data Analytics)

Intellect Infotrade Pvt. Ltd. · Mumbai, India
Oct 2022 - Aug 2023 · 10 months

<p>Designed 10+ Power BI dashboards to track KPIs and customer metrics.</p><p> Automated reporting workflows using SQL and Python, improving efficiency by 35%.</p><p> Monitored and maintained data pipelines, ensuring 99% timely and accurate data availability.</p><p> Performed root cause analysis to resolve data discrepancies and improve data reliability.</p><p> Collaborated with cross-functional teams to streamline reporting processes, delivering analytics outputs 20% faster.</p>

Analyst

Nielsen Company · Mumbai, India
Jun 2021 - Oct 2022 · 1 year 3 months

<p>Extracted and analyzed large datasets using SQL to generate reports and insights.</p><p> Automated reporting using Excel and VBA macros, reducing manual effort by 30%.</p><p> Performed data validation and transformation on global datasets, improving data consistency and quality by 25%.</p><p> Supported global teams with standardized reporting and analytics deliverables.</p>

MIS Executive

Mahindra Integrated Business Solutions Pvt. Ltd. · Mumbai, India
Aug 2019 - Mar 2021 · 1 year 6 months

<p>Developed 20+ automated MIS reports using Excel and SQL for operational reporting.</p><p> Created dashboards and conducted trend analysis to support business reviews.</p><p> Improved data accuracy by 70% through structured validation and data cleaning processes.</p><p> Supported supply chain reporting and provided insights for operational decisions.</p>

PROJECTS

Sales Performance Analytics

Motilal Oswal
Duration : 01-Jan-2026 - 16-Jan-2026

<p>Automated business performance dashboards using SQL, Python, and AWS QuickSight, integrating data from multiple sources to provide real-time visibility into key KPIs. Automated data preparation, transformation, and reporting processes, enabling stakeholders to monitor trends, identify performance gaps, and make faster, data-driven business decisions.</p>

Certifications

Databricks Academy

Databricks Academy · Mumbai , Maharashtra , India · 2025

Skills

Power BI SQL Python Tableau AWS QuickSight Advanced Excel Dashboard Development KPI Reporting MySQL Snowflake Databricks AWS ETL Processes Data Pipelines Pandas NumPy Matplotlib Seaborn Scikit-learn BeautifulSoup Machine Learning Deep Learning OpenCV NLP Sales Forecasting Trend Analysis Data Validation Data Cleaning Reconciliation Report Automation Root Cause Analysis Excel VBA
Report this Profile?