Vidhya Sai Venkat Ramana
Woodbridge,US
Summary
A competent Finance Analyst with a diverse background in financial analysis, forecasting & Budgeting. Experienced in strategic planning, process improvement and creating operational metrics A highly motivated result – driven professional with a proven track record of process improvement, cost reduction, exceeding expectations and On-time performance; improving efficiencies in the process and contributing to achieve Organizational Objective Senior Finance analyst from India with post qualification experience of 14 years in Ford Motor Company, Chennai, India 6 Years in Accounting Payables & Check Audit from May 2008 – Nov 2015 8 + years in Finance from Dec 2015 to July 2022 – Parts Pricing across Asia Pacific region (including China), for Ford Customer Service Division; Sales mix Pricing for warranty parts; SEO (Service Engineering Operation) Finance; Variable marketing and Fixed marketing Finance; Extended Warranty Service Business for Europe Location Cross functional synergies, developing monthly financial reporting/consolidated monthly financial reporting to management, Preparation of yearly Business plan, YOY and Variance analysis. Sectors Exposed to: Manufacturing (Automobiles) Highly motivated and goal-driven Financial Analyst skilled in collecting, monitoring and studying data to analyze financial status and recommend business strategy. Experienced in qualitative and quantitative analysis, contract management and forecasting. Tech-savvy in use of spreadsheets, accounting and financial management software.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Finance Analyst
Extended Warranty
11.2021 - 07.2022
- Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts.
- Conducted detailed financial analysis to identify and evaluate changes in operations, trends and potential areas of improvement.
- Used relevant financial technology to generate reports and recommended courses of action to upper management.
- Performed complex financial and budget analyses to determine requirements and justify requested funding.
- Collected data from other divisions to support quarterly forecasts.
- Reviewed financial reports and streamlined operations to increase productivity and company profits.
- Developed and implemented financial models to analyze complex information and assess health of organization.
- Collaborated to develop and maintain targeted profit plans to sustain growth.
- Determined pricing, margins and risk factors for active and proposed projects.
- Evaluated financial performance of investments, acquisitions and other business opportunities to provide strategic recommendations.
- Provided strategic planning advice and financial oversight for corporate stakeholders.
- Assisted in preparation of presentations, data tables and other documents for investor meetings.
- Generated comprehensive reports on portfolio performance and risk assessment.
- Participated in client meetings to discuss financial analysis and investment strategies.
- Created financial strategies to optimize portfolio performance and reduce risk.
Customer Service
Ford Motor Company
08.2021 - 07.2022
- Extended Service Business /Optional Extended warranty – Monthly reporting, forecasting & Budgeting, ESB: Sale of Vehicle Service Contracts for mechanical repairs, routine maintenance
- Handled Month end & Quarter close, Journal entry bookings, monthly forecast and variance analysis for various process in ESB
- Prepared a various market pricing portfolios across EU region for Mechanical contracts, Maintenance and Service contract
- Worked on the Analysis of Sales and Claims data, Historical Claims Curve which is the base for claim cost calculation to finally arrive out the Extended Service plan cost & pricing of portfolio and to evaluate out the accounted profit
- Handled Budget preparation for Mechanical and Service contract plans with the support of Operations team
- Improved efficiency in monthly closing by creating a learning environment of Alteryx and evaluating processes
- Supporting various ad hoc requests/analysis
- Reviewing and approving the consolidated Monthly billing (prepared by operations) in People Soft Billing
SERVICE ENGINEERING OPERATIONS
07.2019 - 08.2021
- SEO) Finance – Analysis and Variance Reporting, SEO: Development of service solutions and diagnostic information services & sale of equipment.
Lead analyst
11.2015 - 07.2019
- Role allowed me to work cross functionally with PD (product development), Engineering, Operations team and PS&L team (Parts Supply and Logistics)
- Monthly Financial Forecast, Variance analysis and reporting to Central finance
- Worked on yearly Budget and 5-year Business Plan Development with Operations team and did a deep dive analysis on YOY and Plan to Plan performance & presented to management
- Being the interface with the operating team to address cost issues/problems they encounter
- Coordinate cost analysis projects to find optimal cost opportunities
- Business Case Support during pre & post vehicle launches
- Ability to Work Cross Functionally with different skill teams allowed Team Building & To generate new and exciting ideas
- Interface regularly through monthly connect with FCSD Operations Team, and Central Finance team helped to achieve the cost opportunities to the tune of $1.5mils USD from the Budget
- As a Finance analyst we always tried to Balance the demand for stretch objectives with the need for a physical based plan
- Worked on supplier past Cost recoveries from Dealers and achieved $3mils USD opportunity in SEO Budget
- Understanding the end-to-end SEO business and Worked on Non-production Purchase order approval process against each budgeted items submitted by operations team, which is the main key deliverables for upcoming year base budget to run the SEO operations Business
- Explaining Year over Year variance, Issue to Issue, Quarter over Quarter variance and presented the detailed analysis to Top Management Variable Marketing and Fixed Marketing – Monthly Actuals, Forecast, Analysis and Reporting
- Coordinate with operations to manage advertising, fixed and variable marketing budgets and forecast
- Develop marketing cost/revenue assumptions to support Business Plan
- Supported for Retail, Wholesale, Aftermarket, Fleet and Quick Lane channels with respective market leads
- Monthly close responsibilities, actual spend vs
- Budget forecast, year-end accruals
- Actual spend vs
- Budget/forecast Status report to management and monthly discussion with management and with respective market leads
- This role helped me to develop my understanding on the marketing side and worked as a rep
- To Central Finance team in reporting month over month status of budget spent and to co-ordinate with each market to achieve the task (Finding out the additional opportunities to reduce the cost) Financial Analysis and Variance Reporting: – Finance analyst Positions Provide Opportunities to Develop Skills and Learn Organization’s Business
- Pricing Finance - Analysis and variance reporting, Product Pricing/Parts pricing & analysis including the following
- Developing strategies and setting price of parts, Control discounts for different channels of distribution
- Understand competitor moves and react, if necessary
- Achieve pricing budget and support in monthly management submissions on pricing (budget vs
- Actual)
- Looking for pricing opportunities by undertaking special studies (Key Image Parts)
- Identifying parts spiking in warranty and recall and pricing accordingly to save millions of $
- Worked on product profitability, competitive and strategic analyses
- Various strategies were deployed including but not limited to - New Model Launches, Competitive positioning - Original equipment manufacturers (OEM) and independent aftermarket (IAM), Customer value perceived, Segmentation – cost, price, margin, Customer price index, Margin maintenance, Cross country
- New program/Vehicle launch analysis and Parts pricing Study: Worked on New program launch in Lincoln & FCO (Ford China Operations) vehicle models like Raptor, Explorer, MKC, MKZ and did a Cost of Ownership study for parts and achieved more than $5 mils USD
- Breakeven pricing analysis
- Transfer price calculation and
- Product Harmo pricing & analysis
- Develop winning product, pricing and distribution strategies for product category
- Responding to Ford Dealer Pricing inquiries
- Support FCSD senior management in development of strategic initiative reviews
- Warranty Product pricing
- Sales Mix Pricing Finance – pricing analysis and Reporting
- FSA & High Warranty Parts Pricing analysis and reporting
- Pricing & Re-pricing of all the recall parts and high warranty parts based on break-even methodology and Contribution margin methodology
- Monthly reporting to higher management and to operations team on each Asia pacific market warranty pricing proposal and their current trend and status
- Automation of each market proposal of pricing study from previously existing manual template to Automated Dashboard using ALTERYX tool
- Actioning the more recall parts on high priority which reduces the more VOR’s (Vehicle on Road)
- Continuous focus on warranty parts re-pricing by applying 80:20 rule helped in achieving the Customer satisfaction with consistently addressing the issue with warranty spend team and Product Development team
Associate & Senior Associate
Potential Duplicate Review
02.2013 - 10.2015
- For Ford of North America& Europe Locations)
- Reviewing the released payments and identifying duplicate payments made to supplier
- Vendor code analysis done for the Identifying duplicate codes
- Taken lead in closing the S-ox and non-S-ox testing for the MCRP Audit
- Handled PWC auditors in explaining the process
- Checking the cash recovery for the duplicate payments made
- Handled TL activities like report downloading, uploading and circulation of customer metrics
- Achievements
- Regular target achiever
- 100% Nil external error processor
- Identified duplicate payments made for the highest value of USD 299,975
Team member & Senior Team member & Associate Level
05.2008 - 10.2015
- Summary of Roles & Responsibilities Handled in Accounting Department in various teams:
- GSDB –Global supplier Database (supplier/vendor code creation, Vendor code Audit for different locations mainly North America, Asia Pacific)
- Ford of Germany Accountable documents
- Check Audit (Accounting payables Audit) for Ford North America, Europe& APA
- Brazil & CPARS (Purchasing system): New Process Launch Transition Invoice auditing
- Potential duplicate review payment process for North America, Europe& Asia Pacific, Analyzing the invoiced payments made to the customers and rectifying the wrong payments
- Ensure smooth month close in APA Check audit despite new launch at Sanand plant which adds on the volume of additional and bulk request with huge flow of request and completed within TAT
- Handled return invoices and took necessary action to clear it
- Handled the independent desk for most of the new launch process and stabilized the process with necessary detailing and documenting
- Developed material for content development & knowledge transfer
Senior Team member
Asia Pacific Check Audit
03.2010 - 05.2011
- Checking the payments booked by the payables in the payable system (GAPS)
- Auditing the invoices and releasing the right payments at right time to the right vendors
- Handled Payment-run activities in CCAPS (payable system for North America)
- Prepared the desk procedure for the process handled and documented
- Accountable documents (For Ford of Germany location)
Senior Team member
06.2011 - 01.2013
- Monitoring the usage of Accountable documents
- Indexing of documents like Chargeable, non-chargeable, void etc
- Tracking the documents which has been used and left in stock
- Process walkthrough given to ISO Co-Ordinator
- Achievements
- Presenting metrics to Customer – Ford of Germany
- Taken lead in launching ADHOC Process for Ford of Britain
- Consistently receiving CSR rating of 5 from External customer – Ford of Germany & Britain
- Training given to newcomers & prepared new launch tool kit
Education
Master of Business Administration (MBA) - Finance
Deemed University (SCSVMV)
2008
Bachelor of Business Administration (BBA) -
Tiruvallur University
2006
Higher Secondary - undefined
Tamil Nadu State Board Vellore
2004
10th Grade – Matriculation - undefined
2001
Skills
- Technical Highlights:
- On-Job Experience
- Advanced Microsoft excel, Outlook, PPT, Word (MS office Applications)
- Business Analytics (Microsoft POWERBI, SQL, TABLEAU, Power query, Agile methodologies, Python basics, Odyssey applications, GCRP, Share point, PeopleSoft, Alteryx, Accounting software application(CCAPS, GAPS, QAD), ESPS (Main frame system), ESPARS (Analysis tool for ESPS), GCAMP Vendavo (Backend support application)
- Financial Forecasting
- Monthly Close Reporting
- Advanced Financial Analysis
- Sales and Marketing
- Financial Reporting and Analysis
- Expense and Revenue Analysis
- Closing Procedures
- Monthly Financial Statements
- Variance Resolutions
- Self-Motivated Professional
- Documentation Skills
- Finance
Certification
Certified in 6-Sigma – 2 Yellow Belt Project & 3 kaizen projects
Additional Information
- Taken a Lead during absence of TL in the Team activities Achievements , Three - Employee Excellence Award One - Employee Recognition Award from Operations Head Two Top Achiever & One Higher Achiever - (Top Performer of the specific grade) in yearly performance appraisal
Timeline
Senior Finance Analyst
Extended Warranty
11.2021 - 07.2022
Customer Service
Ford Motor Company
08.2021 - 07.2022
SERVICE ENGINEERING OPERATIONS
07.2019 - 08.2021
Lead analyst
11.2015 - 07.2019
Associate & Senior Associate
Potential Duplicate Review
02.2013 - 10.2015
Senior Team member
06.2011 - 01.2013
Senior Team member
Asia Pacific Check Audit
03.2010 - 05.2011
Team member & Senior Team member & Associate Level
05.2008 - 10.2015
Master of Business Administration (MBA) - Finance
Deemed University (SCSVMV)
Bachelor of Business Administration (BBA) -
Tiruvallur University
Higher Secondary - undefined
Tamil Nadu State Board Vellore
10th Grade – Matriculation - undefined
Similar Profiles
Deanna WhiteheadDeanna Whitehead
Coordinator at Rosemark Warranty/Tru WarrantyCoordinator at Rosemark Warranty/Tru Warranty
Gerad GonzalesGerad Gonzales
Asset Protection Associate at Endurance Warranty Services LLCAsset Protection Associate at Endurance Warranty Services LLC
Ariana GraciaAriana Gracia
Warranty Administrator at 2-10 Home Buyers WarrantyWarranty Administrator at 2-10 Home Buyers Warranty
Denise McGlandDenise McGland
Section 508 Program Manager at Department of EducationSection 508 Program Manager at Department of Education
Wanda LockwoodWanda Lockwood
Client Care Manager at Computer Services Unlimited, IncClient Care Manager at Computer Services Unlimited, Inc