Back to Developers
Rohan Dodia

Rohan Dodia

Director of Finance & Administration

Ahmedabad, Gujarat 1+ yrs exp 84 ยท Excellent

About

MBA Finance graduate with hands-on experience in data analytics, financial modelling, and report automation using Advanced Excel, SQL, and data visualization tools. Built Excel-based analytical models across 50+ commodity data points to forecast seasonal demand and support data-driven business decisions. Proficient in collecting, cleaning, and interpreting large datasets, creating dashboards and summary reports, and developing ETL workflows to ensure data accuracy and consistency. Exposure to Power BI, Python, and statistical techniques through MBA coursework in financial technologies and data analytics. Strong stakeholder communication skills with experience presenting insights and recommendations to management for operational improvement.

Skills & Expertise (15)

Advanced Excel Advanced
8.0/10
3
Years Exp
Pivot Tables Advanced
8.0/10
3
Years Exp
stakeholder communication Intermediate
7.5/10
3
Years Exp
Data Analytics Intermediate
7.2/10
3
Years Exp
Financial Modelling Intermediate
7.0/10
3
Years Exp
SQL Intermediate
7.0/10
3
Years Exp
Google Sheets Intermediate
7.0/10
3
Years Exp
VLOOKUP Intermediate
7.0/10
3
Years Exp
ETL Processes Intermediate
6.5/10
3
Years Exp
Data Modelling Intermediate
6.5/10
3
Years Exp
Macros Intermediate
6.5/10
3
Years Exp
Power BI Intermediate
6.0/10
3
Years Exp
tally Intermediate
6.0/10
3
Years Exp
Tally Prime Intermediate
6.0/10
3
Years Exp
Python Intermediate
5.0/10
3
Years Exp

Work Experience

Director of Finance & Administration

AGRICOM FPO Ltd.

Apr 2026 - Sep 2026

Collected, cleaned, and analysed financial data across 3 facility accounts and 50+ vendor accounts, generating weekly summary reports and dashboards for management decision-making. Developed ETL workflows in Excel to extract transactional data from Tally and Busy, transform it into standardised formats, and load it into consolidated reporting templates. Created data-driven financial reports including P&L statements, Debtors & Creditors summaries, and variance analyses, presenting actionable insights to stakeholders. Automated month-end close reporting processes, reducing manual data compilation time by 30% and improving data accuracy to 100% in ledger postings.

Summer Finance Intern

AGRICOM FPO Ltd.

Apr 2025 - Jun 2025

Built 4 Excel-based analytical models evaluating pricing variations across 50+ commodity data points, applying statistical techniques to forecast seasonal demand and identify business opportunities. Performed data collection and market analysis at Unjha APMC over 3 months, producing a detailed analytical report with data visualizations that supported executive-level capital allocation decisions.

Accounting Associate

AGRICOM FPO Ltd.

Aug 2022 - Oct 2023

Processed and validated 200+ monthly transactional data entries across sales, purchase, and payment records using Tally and Busy, ensuring zero data discrepancies. Reconciled monthly bank statement data across 50+ accounts, building a streamlined verification process that reduced turnaround time by 30% and improved data integrity. Generated periodic financial reports and organised expense documentation for management review, coordinating cross-functional data requests with the finance team. Trained new team members on data entry workflows, documentation standards, and accounting software operations, ensuring consistent data quality across the team.

Education

MBA โ€” Finance - Institute of Management, Nirma University

2024 - 2026 ยท Afghanistan

B.E. (Engineering and Technology) - Thapar Institute of Engineering and Technology

2018 - 2023 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 9/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 84/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer