Abhishek Gandra
Newark,CA
Summary
Finance Technology professional with over 15 years of experience in Corporate Finance, Customer Success, Sales Operations, Business Intelligence in a variety of industries including Networking, Telecommunications and Media & Entertainment. Core Competencies: Corporate Finance, Customer Success, Sales Finance, Sales Ops, Business Intelligence, Global Strategy
Overview
18
18
years of professional experience
Work History
Sr. Finance Manager
Arctera
San Ramon, CA
09.2019 - Current
- Develop ARR and Renewal rate workflows and report it in multiple dimensions such as customer, product, region
- Provide retention metrics (Upsell, Downsell, Churn, Gross Retention Rate, Net Retention Rate)
- Use AI modelling to cleanup customer names, system issues and manual errors in billing to get accurate ARR/RR
- Provide insights into ARR, such as pricing actions, pipeline analysis, sales accounts, contract roll offs
- Prepare ARR, Retention Rates and Renewal Rates monthly forecasting and yearly/long range planning
- Support FP&A activities with bookings, ARR details
- Improved Renewal rate by 4 ppt, by identifying gaps and industry standards, achieving high customer success
- Provide corporate, customer, partner, manager/sales rep renewal rate analysis & reporting on weekly, quarterly basis
- Analyse new logos, churn, upsells, downsells and identify potential areas for win backs
- Provide key performance indicators to identify area of improvements such as early renewals, multiyear deals etc.
- Create renewal rate model, to estimate the rates for all products by planning opportunity, and renewal bookings
- Run and maintain Alteryx workflows, and related analytics using tools like Power BI, Tableau, OBIEE for ARR and renewal rate reporting
- Led financial planning and analysis initiatives to support strategic business decisions.
- Streamlined reporting processes, improving accuracy and timeliness of financial information.
- Developed comprehensive budgets and forecasts to enhance financial visibility and accountability.
- Mentored finance team members, fostering professional growth and enhancing departmental expertise.
- Spearheaded system upgrades to optimize financial reporting tools, increasing user accessibility and functionality.
Business Intelligence Analyst (Pricing and Discounting)
VMware
Palo Alto, California
02.2018 - 08.2019
- Prepare regular analyses and dashboards to track key pricing trends, including key recommendations
- Develop pricing, discounting waterfall database and processes aims to transform discounting and value management practices assisting to optimize deal value and profitability for all VMW products
- Conduct business analysis, data mining from Quote to cash, to reveal business insights enabling data-driven decisions and to build pricing and discounting waterfall.
- Presented to executives with the pricing and discounting recommendations - improving margin by 20%
- Assist in identifying new business and growth opportunities to create incremental growth, including new pricing models, pricing promotions, and go to market approaches
- Create and develop dashboards, provide pricing analytics, KPIs to executives using Tableau, MS Access, Power BI, SAP BO and Excel
Business Intelligence Analyst (Sales Finance)
VMware
Palo Alto, California
06.2016 - 02.2018
- Collaborate with executive stakeholders across the globe in Sales, Marketing and Strategy Operations to improve business planning and analyze performance of all VMware products.
- Enable users to analyze and identify gaps in pipeline coverage, data quality, problems, imbalances and pace issues.
- Provide metrics and reports to Global & Geo leaders to monitor and manage quarterly & weekly sales forecast, bookings, pipeline and coverage KPIs.
Business Intelligence Analyst
Cisco Systems, Inc.
San Jose, California
12.2013 - 06.2016
- Provide analytics to sales groups to improve business planning and analyze performance of their products.
- Design and develop Tableau reports, dashboards and scorecards as per specified requirements and publish them to development, stage and production environments.
- Provide data architecture that scales with the business and consolidate collaboration data for easy correlation.
- Create data design according to Tableau standards using Big Data Hadoop environment and MySQL database.
- Build Executive Metrics Dashboard that provides a quick and easy way to review key performance indicators, critical success factors and thereby the overall health of the service and the offerings.
- Integrate JavaScript API and Tableau dashboards and support the web application where all reports reside on.
Technical Lead
IBM India Pvt Ltd.
Bangalore, India
06.2008 - 06.2012
- Provide analytics using IBM Cognos to analyze usage of rebates to customers provided by DirecTv.
- Develop, test and integrate end to end applications using multiple tools and languages.
- End-to-end ownership starting with requirements gathering till coordinating application releases using waterfall and agile methodologies.
- Achieved success in renewing contract with the client QwestCenturylink by providing strategic recommendations to the management.
Education
Master of Business Administration - MBA
HULT INTERNATIONAL BUSINESS SCHOOL
Boston, MA08.2013
MBA Intern Training -
THE SOUTH ASIAN TIMES
Hicksville, New York2013
Bachelor of Technology - Electronics and Communication Engineering
VELLORE INSTITUTE OF TECHNOLOGY UNIVERSITY
Vellore, TN, India05.2008
Skills
- Data/BI Tools: Alteryx, Tableau Desktop, Power BI, SAP BOBJ, SFDC, SAP HANA, OBIEE, QlikView, IBM Cognos
- Databases: MySQL, Greenplum, MapR Hadoop Hive, SQL Server, Postgre SQL, Oracle, Teradata, SAP BW, SAP HANA
- Query/Testing Tools: Aginity Workbench, pgAdmin (PostgreSQL), SQL Developer, Toad, Putty, QTP, SOA tool
- GUI/Tools: Microsoft Project Plan, JIRA, Word, Excel, PowerPoint, Siebel CRM Application
- Defect Tracking Tools: JIRA, Test Director, Quality Center
- Languages: SQL, UNIX, C, C, VB Scripting
- Cash flow management
- Revenue growth
Timeline
Sr. Finance Manager
Arctera
09.2019 - Current
Business Intelligence Analyst (Pricing and Discounting)
VMware
02.2018 - 08.2019
Business Intelligence Analyst (Sales Finance)
VMware
06.2016 - 02.2018
Business Intelligence Analyst
Cisco Systems, Inc.
12.2013 - 06.2016
Technical Lead
IBM India Pvt Ltd.
06.2008 - 06.2012
Bachelor of Technology - Electronics and Communication Engineering
VELLORE INSTITUTE OF TECHNOLOGY UNIVERSITY
Master of Business Administration - MBA
HULT INTERNATIONAL BUSINESS SCHOOL
MBA Intern Training -
THE SOUTH ASIAN TIMES