Summary
Overview
Work History
Education
Skills
Timeline
Generic
RAVIRAJ BHAT

RAVIRAJ BHAT

Kalyan West

Summary

Am a self-motivated person and focused on success. Hard work, perseverance, dedication, passion and adept to the ever- evolving changes in the global markets is the key driver to being ever motivated. Shouldering the responsibilities by fully owning the job/process allotted. Excellent analytical thinking and a strong focus on query resolution within the pre-defined TATs.

Key Areas: SAP based Accounting, Retail Banking Operations, Market Research Analyst, Debtors Ageing Analysis, Sales Support Operations, Customer Value Analysis, Coordination with Stakeholders, Accounting & Book-keeping

Overview

23
23
years of professional experience

Work History

Associate

TeamLease Services Limited, affiliate of Disney Broadcasting
08.2022 - Current
  • Presently working in Finance vertical – “Credit-to-Cash” of “Disney+Hot Star” and CRM channel of “Star India Private Limited.
  • Handling pan India Billing and collections of Disney+Hot Star
  • Approving Invoice in SAP of existing and new customers of Hot Star [Monthly/Quarterly] as per billing frequency of each customer
  • All accounting and billing done on SAP ERP software application
  • Allocation of revenue share in SAP for each customer against Hot Star plans subscribed by customers
  • Allocation of pricing in SAP of each plan of Hot Star subscription bought by customers
  • Initiating requests for Hot Star coupons in JIRA application to be delivered to Subscriber companies for end-consumption
  • Compilation of MIS / Analysis of various Reports/MIS [Revenue / Active Subscriber Base/ Other Metrics on Preparing PAN India front
  • Preparing Incremental tracker for revenue and active base subscribers on month-on-month basis which is closely tracked on 7th, 14th, 21st and 28th day of every month
  • Close Coordination with inter-dept Functionaries for entire Invoice process – from Agreement/Contract signing till coupons are delivered to Subscriber company
  • Closely monitoring upcoming billing and collection dates and sending regular alerts to Billing Manager and to Sales Team
  • Maintaining Master File of all existing and newly added customers with details from inception till coupons are delivered [including any Debit Notes, Credit Notes, Advance Payments or On-A/c payments in OTC vertical - Order to Cash, Account Receivables]
  • Monitor and reconcile customer accounts to ensure all payments are received and allocated correctly
  • Review aging reports and follow up on outstanding payments, addressing any discrepancies or issues promptly
  • Prepare and analyze periodic financial reports related to accounts receivable
  • Obtaining payment details such as UTR and invoice wise breakup from customer/Sales Team and share it with cash apps team for AR knockoff
  • Create AR dashboards on outstanding receivables/Ageing buckets for tracking and monitoring Debtors Ageing and sending regular Ageing Report to Billing Manager based on days/month bucket [Data exported from SAP]
  • Tracking Coupon redemptions on regular basis against coupons bought by Subscriber
  • Accounts receivable reconciliation and confirmation to internal stakeholders
  • Coordinating with finance team, Sales and other controllership teams for verifying collections and payment advices against each invoice, and ensuring that entries are posted correctly in SAP erp systems
  • Assisted in implementation and enhancement of AR systems and processes to streamline operations and improve efficiency
  • Have successfully initiated many modification in Report Generations in SAP so AR work process becomes easier – including discussing with Manager about additions/modifications to be brought in existing reporting structures in SAP FICO module, integration between FI, CO and SD modules of SAP so entire Accounts Receivables can be monitored efficiently >>> coordinating with SAP IT systems Team as to how changes/modifications in reporting structures will impact tracking of Invoice and collections and will save Timelines to generate and track reports which will further increase productivity of entire Team >>> this ultimately has led to successful implementation of many reports. Few successful projects in “ZFR003” and FBL5N which are T-code in SAP ERP used for Debtors Aging reports wherein three different modules of SAP i.e., FI, CO and SD modules were integrated so that SO numbers and dates can also be replenished in same reports of AR aging reports
  • Hence end-to-end MIS, right from generation of Sales Order, Invoicing and further until collection is received from our valued customers can be monitored and controlled in one single report which simplified tracking and monitoring of Accounts Receivables
  • All Data downloaded from SAP Erp is further drilled down into many MIS and synopsis as per Manager’s requirement or other Inter-Departmental Controllership and Stakeholders and emails sent on regular basis and any ad-hoc MIS are also prepared in MS Excel and reported from data downloaded via SAP
  • Initiated monthly “Billing Calendar” in concurrence with Billing Manager so as to effectively track and monitor upcoming invoices to be raised to Customers including those carried forward from previous months and were pending to be billed – updates are sent on weekly basis – so invoicing can be done well within pre-defined TATs mentioned in Contracts or as per amendments agreed between both parties
  • KYC Validations for New/Existing Cable Operators and Multi Service Providers of STAR Tv Channels [New Sale, Novation Deed, etc.]
  • Agreement processing [including yearly Renewals] of new/existing Cable Operators and bigger MSO/DPO in which various steps are involved like Customer Registration, Renewals, Disconnection, Migration, New/Renewal Contract Activations, Billing Collections and Security Deposits against Set Top Boxes, Channel Activations
  • Closely monitoring upcoming billing and collection dates and sending regular alerts to Billing Manager and to Sales Team
  • Maintaining Master File of all existing and newly added customers with details from inception till coupons are delivered [including any Debit Notes, Credit Notes, Advance Payments or On A/c payments]
  • Tracking and Monitoring Debtors Ageing and sending regular Ageing Report to Billing Manager with different aging brackets based on days/month brackets [Data exported from SAP]
  • Tracking Coupon redemptions on regular basis against coupons bought by Subscriber
  • Excellent knowledge of MS Word, Advance Excel, (v-lookup, h-lookup, pivot tables, formatting, formulas, Dashboard Reports etc.) power point and SAP ERP tools
  • Process Training to new Joinees

Proprietor

Rrbgalaxy
04.2013 - 07.2022
  • Worked as Proprietor in start-up proprietorship firm, RRBGALAXY, doing online investments and trading from April 2013 to Jul-2022 in various market segments like equity, index derivatives and currency derivatives
  • Equity Trading [intraday, positional and long-term investments]
  • Index derivatives trading in nifty, banknifty and finnifty [intraday/nrml/btst/stbt]
  • Strategic trading like straddle, strangle, butterfly spread, collar, covered call, protective put
  • Initiating trades in various market segments like Equity, Futures, Options based on technical indicators like Bollinger-Bands, Moving Average Convergence Divergence [MACD], Stochastic RSI, Keltner’s Channel Oscillators, Arnaud Legoux Moving Average [ALMA], ATR, etc
  • NISM [National Institute of Securities Market] Certified Research Analyst with active certificate valid till March 2024 along with valid certifications in Currency Derivatives and Equity Derivatives
  • Effectively handling customer portfolio with excellent track record of healthy returns on their investments
  • Initiated project of developing website of proprietorship firm, www.rrbgalaxy.com through web development IT company based in Pune, so as to invite new customer inquiries into website, derive investment profile and risk appetite of customers based on online questionnaire system and then extracted from various algorithms and mnemonics for calculating Investor Profile [IP] score which is auto-generated in graphical manner that show customer’s financial goal, investment horizon and risk absorbing capacity
  • Learning & Knowledge portal – so as to educate customers through online content on various aspects of capital and securities markets so as to get added advantage for success of their investment journey
  • Self-initiated project to create intellectual property
  • Applied for “Trademark Registration” in Feb 2017 at Mumbai regional office of “Patents, Designs and Trademarks” through consultant, and after 9 months of close coordination, extensive follow up for resolution of offshore queries, finally in Nov 2017, said application was accepted and certified as “Registered Trademark”.
  • Developed and managed relationships with vendors and suppliers.
  • Consulted with customers to assess needs and propose optimal solutions.
  • Optimized team hiring, training, and performance.
  • Provided customer service on accounts and resolved problems.

Business Planner

HDFC Bank
08.2011 - 03.2013
  • Handling pan India yearly business planning and budgeting for Tractor Loan disbursements
  • Daily Performance tracking of sales team
  • Day-to-day close monitoring by preparing MIS reports [separately] for sourcing team and fulfillment team
  • Active and very strong Sales-support
  • Delinquency report of tractor loan customers
  • Follow-up with sales team for delinquent customers so as to ensure all documents for mortgage against tractor loans are collected and couriered/submitted at CPU within TAT of 30 days
  • TAT report of mortgage documents of delinquent customers
  • Cost of Acquisition – from Pan India level, Regional, State, ASM and of every Sales Manager
  • Fivefold Business analysis focused on i) Sales Team, ii) tractor loan customers, iii) demographics, iv) peer and v) sector centric
  • Deriving SOP scores for Regional Heads and State Heads
  • Major focus given for demographics with different weighted scores for different geographies based on rural farmer population, business opportunities, type and seasonal sowing of Kharif and Rabi crops
  • End-to-end point of contact in Mumbai Head Office for sales coordination between each and every sales manager, ASM, SH or RH to NSM and further to Business Heads/Group Heads
  • Have worked efficiently and proactively with internal and external stakeholders to ensure client satisfaction
  • Sales Contests held regularly for Bank Sales Team [sourcing] and DSA [fulfillment team] by organizing Tractor Loan Fares to attract farmer population
  • Close coordination with Tractor Manufacturers and their Authorized Dealers for marketing collaterals like standees, tents, banners, jumbo-size umbrellas etc
  • To be sent to them through Regional Sales Team at targeted locations.

Deputy Manager

Kotak Mahindra Bank
08.2007 - 07.2011
  • Primarily handling product development by adding various features and offers on Debit/ATM cards in line with latest requirements/trends in retail banking sector with help of requisite approvals from Product Head and Business Head
  • Preparing daily MIS reports and sending emails with daily run rate required in run-up to achieving monthly sales targets with strong focus on yearly business targets
  • Relationship Value [RV] analysis for increasing RV of corporate salary customers basis; cross-sell products like Life Insurance
  • Mutual Funds, Gold coins/bars, Home Loan and other asset products
  • Client-onboarding” post acquisition by sales team into core banking system like Oracle, Flex-cube and BCIF
  • Close coordination with various dept in CPU for said onboarding of new corporate clients into core banking system.
  • Roll-out of monthly/weekly campaigns of core product and recognition through email Certificates
  • Inter-dept Coordination for marketing collaterals for rewards and recognition programs which are product specific like core salary accounts or for cross sell products
  • Preparation of powerpoint presentations for sales reviews held in regular intervals and for ad-hoc meetings with National
  • Business Heads / Group Heads
  • In-depth analysis through data churning using MS Access and Excel and preparing graphs, pie-charts and pivots in MS Excel
  • These analysis were used in chasing future sales targets by providing insights on how to negate past under-performance and how future sales run rate can be increased towards fulfillment of yearly business targets
  • Threefold pyramidal Quantitative and Qualitative analysis – [Team centric, customer centric and industry centric] done for calculating monthly SOP scores to declare performance incentives to Sales team
  • Analytics are highlighted in powerpoint preparations on macro and micro level with additional pointers and commentary targeting revenue goals
  • Awarded with a Memento & Certificate for collective effort in achieving target of account funding [net salary credits] in FY 2009-at the “Salary2Wealth Business Conclave 2010” held in Goa.

Senior Associate

Atos Syntel [formerly Syntel Sourcing India Pvt. Ltd.]
04.2006 - 07.2007
  • Overseas operations of fund accounting and reconciliations of mutual fund companies in Aberdeen, Edinburg, London, rest of UK, Luxembourg and USA
  • Calculation of daily NAV
  • Settlement of daily buy/sell trades executed by client fund houses
  • Settlement of money against buy/sell trades in any international market where trades are executed
  • Settlement of Forex instruments on Bloomberg through wire transfer instructions received
  • Settlements of various corporate actions basis ex-Date, rec-Date and div-Date
  • Close coordination with fund managers in overseas countries over emails and phone
  • Major clients personally handled were
  • Aberdeen Asset Management [now Standard Life Aberdeen], among many others
  • After 3 months in this job process, I was elevated as acting Team Leader with team size of 8 Sr. Associates
  • Handled escalations as acting TL for unresolved queries above TAT of 3 days
  • Given additional job role of providing “Process Training” to new Joinees during induction phase.

National Sales Coordinator

HBL Global Pvt. Ltd, [affiliate of HDFC Bank Ltd]
04.2005 - 03.2006
  • Handling back-office operations work for HDFC Bank
  • Maintaining daily MIS reports on Lead Generations and Lead Conversions
  • TAT reports on Lead follow up
  • Detailed analysis on Lead Penetration and Lead Rejections
  • Actively took part in many Lead campaigns like customer-retention programs for reducing customer attrition
  • Sending emails to NSM and also to entire Pan India team on daily lead updates
  • Close coordination with HDFC Bank sales team incl RSM, ASM
  • Preparing powerpoint presentations for sales reviews held at regular intervals
  • Process training of new Joinees.

Accounts Assistant

Universal Chemicals and Industries Pvt. Ltd
04.2004 - 03.2005
  • Handling daily accounting & book-keeping, bank transactions and salary of Mumbai Head Office employees of its Chemical arm [ Pharmaceutical and Lab chemicals]
  • Stock reconciliation at manufacturing plant basis GRN and GDN of warehouse
  • Handling investment portfolio of its Treasury arm [Riviera Investors Pvt Ltd.]
  • Assisting for monthly accounts audit work
  • Assisted entire migration of accounting from Tally accounting to ERP based accounting
  • Further all accounting, book-keeping, stock reconciliations and bank reconciliations done on ERP independently

Accounts Associate

D. K. Exporters
10.2002 - 03.2004
  • Handling daily accounting and bank reconciliation.

External Auditor

M/s Engineer, CA Firm
04.2002 - 09.2002
  • Physical asset verification in Burroughs Welcome India Ltd a pharmaceutical company in Mumbai

Sales Representative

Monginis Foods Pvt. Ltd
10.2000 - 03.2002
  • Handling b2b selling of ready-to-eat [FMCG] food products like cakes, pastries, chips and wafers in South Mumbai.

Education

SAP FICO HANA End User - SAP GUI ERP Based Accounting Software Application

ICA Edu Skills
Kolkata
07.2023

NISM-Series-XV: Research Analyst - Securities Market Research And Analytics

National Institute of Securities Markets
Navi Mumbai
03.2021

NISM-Series-I Currency Derivatives - Forex Derivatives - Furtures And Options

National Institute of Securities Markets
Navi Mumbai
01.2021

NISM-Series-VIII Equity Derivatives - Equity Market Derivatives - Futures And Options

National Institute of Securities Markets
Navi Mumbai
12.2020

BACHELOR OF COMMERCE - Financial Accounting

University of Mumbai
Mumbai
04.2000

Skills

  • Banking Operations
  • Financial Accounting
  • AR Management
  • Ageing Buckets
  • MIS Dashboards
  • Sales Support and end-to-end Coordination
  • SAP FICO HANA End User
  • MS Excel, Word, Powerpoint
  • Tableau
  • Result Oriented
  • Key Initiator
  • Collaboration

Timeline

Associate

TeamLease Services Limited, affiliate of Disney Broadcasting
08.2022 - Current

Proprietor

Rrbgalaxy
04.2013 - 07.2022

Business Planner

HDFC Bank
08.2011 - 03.2013

Deputy Manager

Kotak Mahindra Bank
08.2007 - 07.2011

Senior Associate

Atos Syntel [formerly Syntel Sourcing India Pvt. Ltd.]
04.2006 - 07.2007

National Sales Coordinator

HBL Global Pvt. Ltd, [affiliate of HDFC Bank Ltd]
04.2005 - 03.2006

Accounts Assistant

Universal Chemicals and Industries Pvt. Ltd
04.2004 - 03.2005

Accounts Associate

D. K. Exporters
10.2002 - 03.2004

External Auditor

M/s Engineer, CA Firm
04.2002 - 09.2002

Sales Representative

Monginis Foods Pvt. Ltd
10.2000 - 03.2002

SAP FICO HANA End User - SAP GUI ERP Based Accounting Software Application

ICA Edu Skills

NISM-Series-XV: Research Analyst - Securities Market Research And Analytics

National Institute of Securities Markets

NISM-Series-I Currency Derivatives - Forex Derivatives - Furtures And Options

National Institute of Securities Markets

NISM-Series-VIII Equity Derivatives - Equity Market Derivatives - Futures And Options

National Institute of Securities Markets

BACHELOR OF COMMERCE - Financial Accounting

University of Mumbai

Similar Profiles

CREATE PROFILE
RAVIRAJ BHAT