Summary
Overview
Work History
Skills
Achievements and Certification
Educational credential
Hobbies and Interest
Timeline
Generic

Vivek Vishwakarma

New Delhi

Summary

Seasoned Finance professional & Transformation with a proven ability to successfully lead cross- functional and deliver complex projects on time with accuracy. Experienced in Stakeholder management, risk mitigation and strategic planning. Looking for an opportunity to leverage my financial and transformation expertise to drive operational excellence and achieve key business objective in a dynamic corporate environment.

Overview

8
8
years of professional experience

Work History

Sr. Lead Analyst

American Express
Gurgaon
02.2022 - Current
  • Performing sales incentive calculation on MTD, QTD, and YTD basis.
  • Responsible for creating a SIP calculator for different sales incentive plans and policies on an Excel model, which calculates all plan components itself.
  • Headcount report, along with hierarchy details, MTD, QTD, and YTD analysis, top and bottom performance analysis.
  • Analyzing and performing quarterly incentive dashboard using AI functionality in Excel, which shows the performance attainment, trend analysis on a QTD basis, SIP Payable, outliers (if performance drops in subsequent quarters).
  • SIP Calculation process Transitioned to Varicent (ICM) that calculate and publish report to business leader it self
  • Created Incentive Simulator, it helps employee to understand anticipated SIP and breakdown OTI multiplier that adds value to the business by motivating employee to bring more business
  • Created password protection add-in which helps to meet Control and compliance
  • It secures all workbook by providing one time password, Secure file with data classification as Restricted along with feature to not show hidden sheets if password protected
  • Providing technical support where business excellence and automation required.

Analyst (FP&A)

Accenture Solutions private ltd
Gurgaon
10.2020 - 01.2022
  • Month End Close report after closing of all books
  • Preparation of Flash Report which shows the variances between prior forecast number and Actual number for Order Entry, Revenue, Cost of sales and Gross Margin along with commentary as per the analysis
  • MBR Deck (Monthly Business Review) – under this deck, I prepare some certain set of analysis with proper commentaries i.e
  • Backlog & scheduling – this report is prepared to show backlog Order Entry on year to date basis which is not converted into revenue and also scheduling month on which revenue get recognized
  • Risk & Opportunity – this report provide the detail of upcoming order in the coming months
  • Top 10 Deals – shows the details of top 10 customer for revenue and cost of sales on quarter wise
  • Accounts Manager Report display the financial status of business on Year to date basis which includes Order entry and revenue
  • Preparing of Monthly P&L report, which has detail distinction of revenue as well as cost of sales
  • Accountable for Business Excellence, I have created some GB (Green belt) projects over the VBA macro that helps to reduce FTE hours and increases efficiency in the project
  • I.e
  • Data extraction form SAP environment for individual country as well as multiple country
  • Reconciliation report under this automation robot fetch data from SAP and create summary after doing some analysis and mappings.

Analyst (FP&A)

Whisk Software private ltd
Gurgaon
01.2020 - 10.2020
  • Margin Analysis as per client, practice and for each FTE
  • Ratio Analysis and working for Gross and Net profit factor i.e Operation and other cost
  • Monthly Employee census report, which shows actual margin between bill rate and cost rate after addition of direct cost ie.
  • Bench Cost, Competency Cost, Delivery and IT Cost
  • Preparation of sales cost report for Account Manager and Practice Manager
  • Variance analysis for Sales cost and identify the causes ie.
  • Direct Cost(Loader), Increment
  • FTE comparison on Account level as well as process level.

Analyst (FP&A)

EXL Services India PVT LTD
Noida
07.2018 - 01.2020
  • Preparation & analysis of Actual Budget vs Plan Forecast or Actual Forecast for selling general and administration expenses
  • Working on severance calculation and analysis, monitoring severance around 3000 people on monthly basis
  • Preparation of Enterprise management information system(EMIS),that show top level hierarchy movement
  • Creating of expanse allocation report through downloading data smart view(ESS BASE)
  • FTE comparison and analysis on the base of cost center & organization
  • Comparison between daily & monthly AOR, preparation of final AOR
  • Analysis & preparation of cost center hierarchy from top organization to cost center
  • Creation and publishing of regular reports as well as responsible for ad-hoc reports also
  • Responsible for automation of regular activities on Macro VBA and MS Access.

FnA Executive

IBM India PVT LTD
Gurgaon
09.2016 - 06.2018
  • Preparation of Dashboard for monthly productivity
  • Preparation of daily and weekly efficiency report and share it with seniors and also with associates
  • Assist with month end closures and reconcile vendor account and share with client
  • Tracking out variances between vendor invoice and payment with reason for the variance
  • Create Presentation through Bars & Pivot for productivity on team and each person on monthly and quarterly basis
  • Tool development using VBA & Macro
  • Frequently use of If, Sumif, Countif, V-lookup, H-lookup, Index & Match, Is Error, Pivot Table, Macros and automation etc
  • Report template designing (Attendance, leave).

Skills

  • Reporting
  • Financial Modeling
  • Incentive Calculation
  • SIP Calculator
  • Dashboard Preparation
  • ICM Transition
  • Budgeting Forecasting
  • Variance Analysis
  • Margin Analysis
  • MBR Deck
  • Ad-hoc/Flash Reports
  • EMIS
  • FTE Comparison
  • Reconciliation
  • Presentation Skills
  • Analytical Skills

Achievements and Certification

  • Awarded by VP individual for transition of SIP to Vericent (iPlus)
  • Recognized by Director award for implementation of SIP Models and automation, which calculate complex sales incentive itself with 100% accuracy
  • Got a shout out from business for incentive simulator, incentive simulator enables business to calculate estimate SIP by providing inputs
  • Certification:- SIX Sigma Green belt certification and Tableau Basic certification done through linkedin learning

Educational credential

  • MBA, 2021, Symbiosis, 69.06%
  • B.com, 2015, Delhi University, 48.96%
  • 10+2, 2011, C.B.S.E, 50.33%
  • 10, 2009, C.B.S.E, 59.50%

Hobbies and Interest

  • Cooking
  • Home decore, creating by my own

Timeline

Sr. Lead Analyst

American Express
02.2022 - Current

Analyst (FP&A)

Accenture Solutions private ltd
10.2020 - 01.2022

Analyst (FP&A)

Whisk Software private ltd
01.2020 - 10.2020

Analyst (FP&A)

EXL Services India PVT LTD
07.2018 - 01.2020

FnA Executive

IBM India PVT LTD
09.2016 - 06.2018

Similar Profiles

CREATE PROFILE
Vivek Vishwakarma