R. HARIRAJAN
Coimbatore
Summary
To pursue a challenging and rewarding career in an organization which can provide me with a competitive and professional environment, whereby my skills along with academic background and experience will be utilized for mutual benefits. Resourceful Executive - Accounts known for high productivity and efficient task completion. Skilled in financial reporting, budget management, and regulatory compliance. Excel in problem-solving, communication, and strategic planning to deliver results.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Executive Accounts
TUV India Private Limited
Coimbatore
08.2017 - Current
- Company Overview: TUV India Private Limited was established in 1989 as part of the German RWT
- V group's Indian operations
- Being one of the first Certification Bodies to start operations in India, TUV India has been closely associated with the quality revolution in India
- It started with some of the earliest ISO 9001 audits by any certification body in India
- With a current workforce of over 14,000 employees across 70 countries globally, the T
- V NORD GROUP is one of the world’s largest Inspection, Certification & Testing organizations
- Accounts Receivable
- DSO Preparation
- Debtors Reconciliation
- International Customer Collection Follow-up and Accounting
- Preparation of Domestic and International E - Invoices
- Prepare customer's Outstanding statements
- Generate weekly aging reports
- Bank Guarantee
- GST Verification
- Contact delinquent customers to secure payment
- Investigate and resolve billing and account discrepancies
- Manage and resolve customer inquiries
- Compile data and prepare monthly reports and statements
- Performed daily reconciliations
- Resolved accounts receivable issues with customers
- Monitored credit limits
- Assisted with month-end closing
- Accounts Payable
- Collect, compile, and review invoices from vendors for payment processing
- GST Reconciliation
- GST Recovery from GST defaulters
- TDS Deduction
- Maintain records of journal entries and ledger postings
- Conform with vendors for the receipt of payments
- Vendor Invoice processing
- Reconciling accounts and monitor non-payment
- Verifying purchase orders and confirm the rates
- Monitored company accounts and ensured no late payment is paid
- Resolved bill discrepancies by communicating with vendors and purchase department
- Rectified and solved escalated accounts payable issues
- General Accounting & MIS
- Preparation of Monthly MIS Reports
- Annual Budget Preparation
- Monitoring and reporting month wise Budget vs Actuals variances
- Preparation of National and International Invoices
- Preparation of Creditors and Debtors ageing reports
- Preparation of Monthly Bank Reconciliation Statements (BRS)
- Review of debtors and creditors ledger and reconcile the same with party statements
- Provide all the details required for Internal Audit
- Finance & Banking
- Managing the funds for meeting the day-today working capital requirements
- Arranging Payments for Vendor bills as per Purchase Order terms
- Ensure all accounts data entry and filling in up-to date
- Reconcile inter concern ledger and balance in monthly basis
- Weekly Payable & Receivable Statement Preparation & follow up for Outstanding
- Handling Group of Companies internal transactions
- Preparation of Monthly Cash flow statements and planning for the future working capital requirements with divisional heads
- Reimburse the branch office expenses, staff conveyance & traveling Expenses as per company policy
- On the basis of ageing Analysis follow up with the customers for fund collection
- Dealing with bankers for Bank Guarantee, fixed deposits, DD, Cheques, and Internet Banking & E-Payment of taxes
- Data Analysis:
- Preparing Dashboards in Power BI
- Using Power Query to Clean and transform the data
- Using DAX for creating measures
- Prepare attractive dashboards
- Database management
- Create, Alter, Remove the data from Relational Database through SQL
- Query writing for getting the required reports from database through SQL
- Generating Data from SAP Module for Data Visualisation and Dashboard preparation
- Data cleaning
- Cleaning the data by using Excel, Power Query and Python (Pandas and Numpy)
- Data Analysis
- Creating Statistical Analysis through Python (Pandas, Numpy and Matplotlib)
- Report Designing
- Sales information Report
- Pending Order Reports
- Collection information Report
- MIS Reports
- TUV India Private Limited was established in 1989 as part of the German RWT
- V group's Indian operations
- Being one of the first Certification Bodies to start operations in India, TUV India has been closely associated with the quality revolution in India
- It started with some of the earliest ISO 9001 audits by any certification body in India
- With a current workforce of over 14,000 employees across 70 countries globally, the T
- V NORD GROUP is one of the world’s largest Inspection, Certification & Testing organizations
Accounts Officer
Sri Kanchi Kamakoti Medical Trust
Coimbatore
11.2014 - 08.2017
- Company Overview: Sri Kanchi Kamakoti Medical Trust – Known as Sankara Eye Hospital is a leading Eye care hospital in India
- It has 10 branches all over the India namely Anand, Bangalore, Coimbatore, Coimbatore City, Guntur, Vijayawada, Krishnankovil, Ludhiana, Shimoga and Kanpur
- Accounts Receivable
- Prepare customer's (TPA – Third Party Administrator ) statements, bills and invoices
- Research and analyze accounts
- Generate weekly aging reports
- Determine payment schedules with customers
- Contact delinquent customers to secure payment
- Investigate and resolve billing and account discrepancies
- Manage and resolve customer inquiries
- Performed daily reconciliations
- Resolved accounts receivable issues with customers
- Accounts Payable
- Collect, compile, and review invoices from vendors for payment processing
- Reconciling accounts and monitor non-payment
- Send notifications to vendors for deducting amount on invoices for good returned
- Verifying purchase orders and confirm the rates
- Monitored company accounts and ensured no late payment is paid
- Resolved bill discrepancies by communicating with vendors and purchase department
- Opened new vendor accounts and renewed old ones
- Rectified and solved escalated accounts payable issues
- General Accounting
- Maintain Fixed Assets Register
- Preparation of Monthly Bank Reconciliation Statements (BRS)
- Provide all the details required for Internal Audit
- Ensure that all statutory payments (Service Tax, Sales Tax, TDS & Professional Tax) are made timely
- Managing the funds for meeting the day-today working capital requirements
- Preparation of Monthly Cash flow statements and planning for the future working capital requirements with divisional heads
- Reimburse the branch office expenses, staff conveyance & traveling Expenses as per company policy
- Implemented canteen management system
- Sri Kanchi Kamakoti Medical Trust – Known as Sankara Eye Hospital is a leading Eye care hospital in India
- It has 10 branches all over the India namely Anand, Bangalore, Coimbatore, Coimbatore City, Guntur, Vijayawada, Krishnankovil, Ludhiana, Shimoga and Kanpur
Accounts Officer
Uttara Foods And Feeds Private Limited
Namakkal
11.2012 - 10.2014
- Company Overview: Uttara Foods & Feeds Private Ltd – is a leading manufacturer & supplier of animal foods, feeds for and grower of commercial broiler chicken with turnover of Rs.120crore
- General Accounting
- Preparation of Creditors and Debtors ageing reports
- Preparation of Monthly MIS Reports to Top Management
- Maintain Fixed Assets Register
- Preparation of Monthly Bank Reconciliation Statements (BRS)
- Review of debtors and creditors ledger and reconcile the same with party statements
- Provide all the details required for Internal Audit
- Ensure that all statutory payments (Service Tax, Sales Tax, TDS & Professional Tax) are made timely
- Preparation of E-Return for Service tax half year basis and sales tax monthly basis
- Collection & Issue of C forms in quarter wise
- Finance & Banking
- Managing the funds for meeting the day-today working capital requirements
- Arranging Payments for Vendor bills as per Purchase Order terms
- Ensure all accounts data entry and filling in up-to date
- Reconcile inter concern ledger and balance in monthly basis
- Weekly Payable & Receivable Statement Preparation & follow up for Outstanding
- Handling Group of Companies internal transactions
- Preparation of Monthly Cash flow statements and planning for the future working capital requirements with divisional heads
- Reimburse the branch office expenses, staff conveyance & traveling Expenses as per company policy
- On the basis of ageing Analysis follow up with the customers for fund collection
- Dealing with bankers for Bank Guarantee, Fixed Deposits, Letter of Credit, DD, Cheques, and Internet Banking & E-Payment of taxes
- Uttara Foods & Feeds Private Ltd – is a leading manufacturer & supplier of animal foods, feeds for and grower of commercial broiler chicken with turnover of Rs.120crore
Education
Master of Business Administration -
RKKR School of Management Studies-Anna University
India01.2012
Bachelor of Business Administration -
Muthayammal College of Arts and Science
India01.2010
Skills
- Data Science
- Python for Data Science
- File Handling
- Lambda
- Filters
- Map
- List Comprehension
- Data Engineering
- Handling Missing Data
- Data Visualization
- Pandas
- Numpy
- EDA
- SQL
- Data Definition Language
- Data Manipulation Language
- Date and time functions
- Integrating Python with SQL
- Machine Learning
- Sklearn
- SAP GUI
- SAP FICO
- Ms Office
- MS Excel
- MS Power Point
- MS Word
- Power Query
- Power BI
- Tally 91
- Python
- Accounts receivable
Disclaimer
I hereby do solemnly affirm that the details furnished above are true to the best of my knowledge.
Languages
- Tamil
- English
- Telugu (Speak Only)
Personal Information
Date of Birth: 03/20/90
Certification
- IIT-M Certified Advanced Programming Professional
& Master Data Science
Timeline
Executive Accounts
TUV India Private Limited
08.2017 - Current
Accounts Officer
Sri Kanchi Kamakoti Medical Trust
11.2014 - 08.2017
Accounts Officer
Uttara Foods And Feeds Private Limited
11.2012 - 10.2014
Master of Business Administration -
RKKR School of Management Studies-Anna University
Bachelor of Business Administration -
Muthayammal College of Arts and Science