Summary
Overview
Work History
Education
Skills
Certification
Personal Project
Timeline
Generic

Swapnil Mark Pushong

Noida

Summary

Highly analytical finance professional with extensive experience in financial modeling, company valuation, and investment banking. Proficient in Discounted Cash Flow (DCF) modeling, Comparable Company Analysis (Trading Comps), and Precedent Analysis (Transaction DCF). Expertise in Excel-based financial models, financial statement analysis, and forecasting. Strong understanding of corporate finance, mergers and acquisitions (M&A), and capital markets. Adept at delivering actionable insights and investment recommendations, with a focus on optimizing financial performance. Effective communicator and presenter with excellent knowledge of financial markets, risk management, and deal structuring.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Process Associate

Genpact
Noida
02.2024 - Current
  • Conducted financial analysis and reviewed customer deductions related to accounts receivables, ensuring compliance with financial terms.
  • Analyzed and reconciled financial discrepancies using Excel-based models for accuracy in deductions and payments.
  • Implemented process improvement initiatives, reducing operational inefficiencies and improving cash flow management.
  • Collaborated with cross-functional teams to streamline financial reporting and enhance reconciliation processes.
  • Part of the transition phase, involving knowledge transfers (KTs) with clients, to ensure a smooth financial process handover.
  • Utilized Excel and Word to prepare detailed financial reports and maintain accurate documentation. Reviewed and analyzed customer deductions taken against invoices or payments.
  • Validate the accuracy of deductions against contract terms, pricing agreements, and promotional allowances.
  • Resolve disputes and discrepancies related to deductions.
  • Maintain accurate records and documentation of deduction activities.
  • Being part of the transition phase of the process and KT's with the clients.
  • Implement process improvements to prevent future deductions caused by operational inefficiencies.

Education

Master of Business Administration - Finance, HR

Galgotias Univeristy
Greater Noida
06-2024

Master of Commerce -

Swami Vivekanand Subharti University
Meerut
02.2022

Bachelor Of Commerce - Financial Accounting

Dr. BR Ambedkar University
Agra
08.2020

Skills

  • Financial Modeling: DCF, M&A, Precedent Transaction Analysis, Public Company Analysis
  • Valuation Techniques: DCF, NPV, IRR, Comparable Company Analysis, Intrinsic Valuation
  • Financial Statement Analysis: Income Statement, Balance Sheet, Cash Flow Statement
  • Investment Banking Tools: Excel (Advanced), PowerPoint, Word
  • Corporate Finance: Capital Structure, Working Capital Management, Financial Planning & Analysis
  • Forecasting: Revenue Forecasting, Cost Projections
  • Mergers & Acquisitions (M&A): Deal Structuring, Financial Modeling
  • Soft Skills: Communication, Leadership, Process Improvement, Team Collaboration

Certification

Investment Banking Certification
The WallStreet School, New Delhi | May 2024

  • Performed financial modeling for public and private companies using DCF, Comparable Company Analysis (Comps), and Precedent Transaction Analysis.
  • Built comprehensive financial models in Excel, including income statements, balance sheets, and cash flow projections for accurate forecasting.
  • Conducted valuations for mergers & acquisitions (M&A), and other corporate finance transactions.
  • Developed Excel-based financial models incorporating sensitivity and scenario analysis to provide a range of potential outcomes.
  • Proficient in analyzing key financial metrics such as EBITDA, P/E ratios, and Return on Investment (ROI) for decision-making.

Personal Project

DCF Valuation of PepsiCo | 2023

  • Developed a comprehensive Discounted Cash Flow (DCF) model to estimate PepsiCo's intrinsic value using Excel-based financial models.
  • Projected future revenues, operating expenses, and cash flows based on historical financial statements and market analysis.
  • Analyzed PepsiCo's capital structure and calculated the Weighted Average Cost of Capital (WACC) to determine the appropriate discount rate.
  • Presented valuation results and investment recommendations, identifying key risks and growth opportunities.

Timeline

Process Associate

Genpact
02.2024 - Current

Master of Business Administration - Finance, HR

Galgotias Univeristy

Master of Commerce -

Swami Vivekanand Subharti University

Bachelor Of Commerce - Financial Accounting

Dr. BR Ambedkar University
Swapnil Mark Pushong