Quote
Summary
Overview
Work History
Education
Skills
Software
Project Work
Certification
Websites
Languages
Work Availability
Hi, I’m

PRATIK RIJHWANI

PRATIK RIJHWANI

Quote

Rule No. 1: Never lose money. Rule No. 2: Never forget rule No.1
Warren Buffett

Summary

Finance professional with expertise in quantitative analysis and automation projects, backed by a solid educational foundation and hands-on experience in financial modeling, strategic budgeting, and performance analysis.

Overview

2
years of professional experience

Work History

Northeastern University
Boston, USA

Financial Analyst
09.2023 - 08.2024

Job overview

  • Variance Analysis & Resource Optimization: Led in-depth variance analysis focusing on underperforming cost centers within the operating expenses. My analysis led to the reallocation of $200,000 to high-impact initiatives, which not only strengthened the departmental EBITDA by 10% but also optimized resource utilization, ensuring that the university's financial resources were directed towards the most beneficial areas.
  • Budgeting Framework Development: Developed a comprehensive financial framework for the management of a $20 million departmental budget. By utilizing scenario planning and historical trend analysis, I enhanced budget accuracy by 15%, ensuring that funds were distributed optimally across various initiatives, supporting the university's strategic goals.
  • Financial Data Aggregation Overhaul: Spearheaded the overhaul of financial data aggregation processes, integrating Banner Finance with MS Power BI. This transformation reduced manual labor by 50 hours per month and decreased errors by 80%, significantly improving the efficiency and accuracy of financial reporting.
  • KPI Tracking Implementation: Engineered a robust KPI tracker using Power BI, which streamlined the monitoring of financial and operational metrics. This tool provided real-time insights to stakeholders, reducing the reporting cycle by 5 days per month and enabling quicker decision-making.
  • Investment Decision Guidance: Offered critical financial guidance on investment decisions worth $10 million, employing Discounted Cash Flow (DCF) and scenario analysis models. This approach refined sensitivity analysis and stress testing, enhancing the decision-making process and ensuring more reliable financial outcomes.
  • Invoicing Process Standardization: Standardized and integrated the invoicing process with AR/AP systems, enabling real-time tracking and reporting. This standardization reduced errors and discrepancies by 80% and accelerated payment cycles by 20%, improving cash flow and operational efficiency.

Asian Paints Ltd.
Mumbai, India

Corporate Financial Analyst
09.2021 - 10.2022

Job overview

  • Variance Analysis & Budget Accuracy: Led comprehensive variance analysis on monthly financial reports, uncovering and rectifying discrepancies in operational budgets. This initiative resulted in a 15% decrease in overall budget variances and significantly improved forecasting accuracy, contributing to more precise financial planning.
  • Operational Efficiency Enhancement: Executed detailed reviews of operational metrics, which revealed inefficiencies in workflow processes. My targeted process improvements led to a $150,000 reduction in annual spending and optimized resource allocation, ensuring that the company's resources were utilized effectively.
  • Inventory Reporting Automation: Automated the monthly inventory reporting process, reducing data collection time by 50% and enhancing data integrity through rigorous quality assurance protocols. This automation drove more accurate and timely financial insights, aiding in better decision-making.
  • Financial Dashboard Development: Designed and implemented an exhaustive financial dashboard using Power BI, integrating key financial metrics for production and sales. This tool enhanced stakeholder transparency and engagement, reducing report queries by 70%.
  • KPI Monitoring & Analysis: Monitored key performance indicators through variance and trend analysis, providing actionable insights to senior authorities. This work elevated cost efficiency by $30,000 annually and ensured that the company's operations were aligned with strategic goals.
  • Financial Modeling & Revenue Growth: Developed intricate financial models using DCF and profitability index methodologies, which led to the identification of a new revenue stream. This discovery generated an additional $250,000 in annual revenue, contributing to the company's financial growth.

Education

Northeastern University
Boston

09.2023 - Current

University Overview

Relevant Coursework: Corporate Finance, Data Analytics, FinTech, Financial Markets, Derivatives & Risk Analysis

Teaching Assistantship: FinTech Assistant, Data Analytics with Python Assistant

Leadership: NEU Finance Club Co-Ordinator, 360 Huntington Fund Analyst

Association of Chartered Certified Accountants
Mumbai, India

Chartered Certified Accountant - Level 2
03.2023 - Current

University Overview

Relevant Coursework : Business Technology, Financial & Management Accounting, Taxation, Financial Management, Performance Costing.

V.G Vaze College of Arts, Science & Commerce
Mumbai, India

Bachelor of Commerce
05.2018 - 05.2021

University Overview

Relevant Coursework: Financial Accounting, Auditing, Cost Analysis, Financial Management, Financial Statements Analysis, Economics.

Leadership: Head Secretary- Campus Placement Committee, Vice President - Finance Society

Skills

  • Variance Analysis
  • Trend Analysis
  • DCF
  • Budget Development
  • Financial Modeling
  • ABC Budgeting
  • Process Automation
  • Root Cause Analysis
  • KPI Tracking
  • Data Integration
  • Cost Reduction
  • Resource Utilization
  • Compliance
  • Validation Checks
  • Project Management
  • Collaboration
  • Stakeholder Management
  • Financial Reporting
  • Revenue Streams
  • Growth Opportunites

Software

MS Excel

MS Power BI

Python in Finance

MATLAB

MS PowerPoint

MS Power Automate

MySQL

SAP FICO

Oracle NetSuite

Banner Finance

Bloomberg Terminal

Project Work

Project Work

VIRTUAL INVOICE PROCESSING AUTOMATION (VIPA) 2021

  • Achieving 98% automation, reducing labor costs by $110,000 annually, and cutting processing time from 7 minutes to 30 seconds. As the project lead for the Virtual Invoice Processing Automation (VIPA) initiative, I worked closely with IT to design and implement an automated accounts payable system at APL. The system achieved 98% automation, significantly reducing the reliance on manual processes and cutting labor costs by $110,000 annually. Additionally, the automation reduced the processing time for invoices from 7 minutes to just 30 seconds, dramatically improving efficiency and freeing up resources for other critical tasks.
  • Improved financial reporting accuracy, decreased stakeholder inquiries by 50%, and yielded annual cost savings of $13,000. In this project, I also focused on improving the accuracy and transparency of financial reporting. By leveraging SAP, Excel, and BI tools, I developed an automated management information system (MIS) that reduced the frequency of errors and inconsistencies in financial reports. This improvement led to a 50% decrease in stakeholder inquiries, as the reports were clearer and more reliable. The project also generated annual cost savings of $13,000, and I was able to complete it ahead of schedule, further demonstrating my efficiency and project management skills.
  • Strengthened compliance and audit readiness by integrating real-time validation checks into the automation process, reducing invoice errors by 90% and minimizing audit discrepancies by 80%. A key aspect of the VIPA project was enhancing compliance and audit readiness. I integrated real-time validation checks into the automated process, which significantly reduced the occurrence of invoice errors by 90%. This proactive approach also minimized audit discrepancies by 80%, ensuring that the company was well-prepared for internal and external audits. These improvements not only streamlined financial operations but also reduced the risk of regulatory non-compliance and associated penalties.

Certification

Certifications:

  • Data Manipulation with Pandas
  • Microsoft Excel 365
  • Intermediate Python
  • Analyzing and Visualizing Data with Microsoft Power BI
  • Financial Modelling and Valuation (FMVA -GrantThornton)

Languages

Hindi
Native language
English
Advanced (C1)
C1
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
PRATIK RIJHWANI