Summary
Overview
Work History
Education
Skills
Accomplishments
INTERNSHIPS
Certification
Timeline
Generic

PRACHI DIWEDI

Noida

Summary

Experience individual determined to carve a successful, satisfying career in data analysis, with proficiency in performing and excelling under demanding work conditions to manage and format big data for use in financial forecasts. Proven ability to develop and implement efficient systems and processes, resulting in improved operational efficiency and cost savings. I am highly enthusiastic about applying my expertise in data analysis and project management to drive the success of a dynamic organization.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Senior Financial Analyst

Ameriprise Financial
Noida
10.2023 - Current
  • Designed and implemented detailed financial models for scenario analysis, forecasting, and valuation.
  • Preparation of annual budgets, and quarterly and monthly financial forecasts, ensuring alignment with organizational objectives.
  • Developed and implemented process automation solutions using tools like Power BI, Power Query, VBA macros, and advanced Excel functions, reducing manual efforts by three hours a week and enhancing accuracy.
  • Transformed complex financial data into actionable and valuable insights to help in decision-making.
  • Conducted detailed variance analyses to identify financial performance gaps and provide actionable suggestions to the stakeholders.
  • Led various quarterly and monthly budget discussions, providing insights into revenue, expenses, and cash flows.
  • Delivered high-level presentations on financial results and trends to onshore business partners and senior management.
  • Enhanced overall productivity leading to decreased labor costs and improved efficiency.
  • Collaborated with cross-functional teams to develop annual operating budgets and long-term strategic plans.

Sr. MIS Analyst

VVDN Technologies Pvt LTD
Gurgaon
04.2021 - 10.2023
  • Developed and implemented a comprehensive data management tool, with the help of the Technical Tool team, resulting in a 40% reduction in data errors and improved overall departmental efficiency.
  • Collaborated with the SAP team to identify the errors in the process and system, as well as to get them resolved, resulting in a 30% reduction in downtime and smooth working across the team.
  • Conduct detailed data analysis and generate reports with graphics, providing valuable insights to BU heads for informed decision-making, and contributing 10-15% efficiency in project execution and delivery.
  • Managed comprehensive market research, comparing past and present performances of competitors, and generating quarterly reports using ratios.
  • Prepared and analyzed detailed Profit and Loss statements at the time of receiving Purchase Orders, ensuring monthly budgeted versus actual comparisons for respective customers.
  • Prepare monthly revenue reports by actively engaging with program managers to gather project-specific revenue data and ensure accurate tracking of both billed and unbilled projects.
  • Handled the procurement of capital expenditures for the Project/Trading business, and monitored consumption booking in SAP for Trading.
  • Oversaw the creation of new sales orders for engineering services/trading, and ensured accurate traceability of project direct expenses to the respective projects/BUs.
  • Ensured proper project expense recovery from customers for expenses incurred during project execution.
  • Prepared Profit and Loss statements for Hardware, Software, and BU, tracking revenue vs. cost performance.
  • Worked on the Bill of Materials (BOM) costing, and prepared V0, V1, and V2 Profit & Loss statements for manufacturing projects.
  • Managed in-transit stock, production punching, blocked stocks, and quantity consumed as part of stock management responsibilities.
  • Participated in the statutory audit for FY'21, FY'22, and FY'23, as well as financial due diligence processes.
  • Prepared Consumption and Purchase Price Variance (PPV) reports, providing insights into cost control measures.
  • Collaborated closely with investment consultants, assisting in the development of financial models.
  • Contributed to the contract finance team, reviewing business contracts from a financial standpoint, and advocating for amendments in favor of the company.
  • Prepared presentations in PowerPoint, and developed dashboards as per requirements, coordinating with the sales team and respective BU heads for resource analysis.

Junior Analyst

SRAJ & Co
01.2020 - 03.2021
  • Finalizing Books of Accounts
  • Preparing monthly financial reports
  • GST Registration and GST Tax Filing
  • Preparing, Evaluating & Auditing Balance Sheet
  • TDS Deduction and Return Filing
  • GST Input Reconciliation, Generating E-Way bill, Invoice Generation
  • Capital Budgeting
  • Income Tax Registration & ITR Filing
  • Designed and developed user-centric products and systems
  • Expertise in implementing cost saving measures to achieve substantial cost reduction & enhancing organizations profits.

Education

MBA - Finance

Pranveer Singh Institute of Technology
Kanpur, Uttar Pradesh
01-2021

B.Com - Finance

Jagran College of Art, Science And Commerce
Kanpur, Uttar Pradesh
01-2018

Skills

  • Financial Modeling & Valuations
  • Revenue recognition & reconciliation
  • Cost-Benefit & Variance Analysis
  • Budgeting, forecasting & planning
  • Advanced Excel (Pivot Tables, Macros, Power Query, Fuzzy lookup, etc)
  • Business Intelligence Tools (Power BI & Tableau)
  • Financial Reporting & Consolidation
  • ERP Systems (Tally 90 & SAP)

Accomplishments

  • Received the Gold Award for developing the scoreboard at Ameriprise Financial, August 2024
  • Letter of Promotion and Appreciation from VVDN Technologies Pvt. Ltd., Sep '22
  • Letter of Recommendation from FinL, June 2020
  • Letter of Appreciation from GigIndia for the Amazon Project, June 2020
  • Letter of Appreciation and Recommendation from Tareeqa Global Solutions Pvt. Ltd., May 2020
  • Letter of Appreciation from the Leader of Tomorrow, October 2020
  • Letter of appreciation for organizing and hosting an event with Tech Rush Pvt. Ltd., June '20

INTERNSHIPS

Finance Trainee [Jun '20 - Aug '20], HBF Direct Private Ltd

  • Worked as a liaison between the company and other local firms
  • Acknowledging the problems of other ventures, and providing consultancy services
  • Part of a campaign, 'Angel Investment'
  • Market research and article writing for five startup ideas
  • Projection Report Formation

Market Research Intern [May '20 - Jun '20] FinL

  • A completed research study on financial literacy in India
  • Prepared analysis reports on financial platforms
  • The final project of the company was a team effort on various cities' financial inclusion initiatives, which overall increased my knowledge about those places and also enhanced my team spirit

Certification

  • Completed 'Managing Corporate Finance in a Financial Downturn' from Alpha Academy (2024)
  • Completed the compiled course for Power BI, Power Pivot, and Power Query from Simplilearn (2022)
  • Completed certification in financial modeling and reporting (2020)
  • Completed the Investment & Portfolio Management Certification Course in (2020)
  • Completed Excel Crash Course – Spreadsheet Tutorial for Finance (2020)
  • Completed the Digital Assessment and Certification program from TCSiON in (2020)
  • Certified Digital Marketing Course from Google (2020)
  • Certified in Accounting Fundamentals from the Corporate Finance Institute (2020)
  • Certified in Six Sigma Training from Master of Project Academy, (2020)
  • Certified in Non-Profit Essentials from NonProfitReady.org, (2020)
    Certified in Financial Inclusion, Financial Literacy, and Financial Education in Asia Program (2020)

Timeline

Senior Financial Analyst

Ameriprise Financial
10.2023 - Current

Sr. MIS Analyst

VVDN Technologies Pvt LTD
04.2021 - 10.2023

Junior Analyst

SRAJ & Co
01.2020 - 03.2021

MBA - Finance

Pranveer Singh Institute of Technology

B.Com - Finance

Jagran College of Art, Science And Commerce
PRACHI DIWEDI