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 Pradesh01-2021
B.Com - Finance
Jagran College of Art, Science And Commerce
Kanpur, Uttar Pradesh01-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