Vikram Shankar Mathur
B-404, Shashwat Apartments, Atithi Dining Hall Lane,
B/h GNFC Infotower, Bodakdev, AHMEDABAD-380054, Gujarat, INDIA
Being a Chartered Accountant with an additional qualification of Diploma in Information Systems Audit (DISA-ICAI) and Forensic Accounting and Fraud Prevention (FAFP-ICAI) is what is my strength. My analytical skills using Microsoft Excel in conjunction with Microsoft Access / Microsoft Word are quite legendary in creating numerous types of MIS Reports, including various types of mail merging between the three.
(A) WORK EXPERIENCE:
1989 – 1990
Office (Internal Audit), INGERSOLL-RAND (INDIA) LTD
Complete responsibility of completing all aspects of Internal Audit of their Naroda (Ahmedabad) Factory in addition to sharing the responsibility of completing the Mumbai HO Internal Audit with the Bangalore Plant Officer/Executive.
1990 – 1992
Branch accountant, crompton greaves limited
Was primarily responsible for the accounts, finance and administration of the Ahmedabad and Baroda Branches, including Sales Administration, Accounting Data to the Central EDP at Kanjur, Mumbai and for various other accounts and administration related work at both branches. Actively participated in the Finalization of Accounts of the Company at year end.
1993 – 1994
Manager (credit control), cadila laboratories
Was primarily responsible for managing the credit control function for 46 C&S (Consignment and Sales) Agents spread all over India (Pimpri, Bhubaneshwar, Ranchi, Kolkatta, Chennai, Mumbai, New Delhi, etc.). Manager (Internal Audit) at Cadila Laboratories Limited, Ahmedabad located at the Ghodasar Plant from February 1994 till May 1994 – Assisted Shri Shantanu Roy of Kolkatta for Operations Audit of Marketing & Personnel during this period. Also coordinated certain aspects of programming at EDP Center for the C&S Cell for better monitoring of accounting records. Actively participated in the Annual Accounts Finalization of the concern at year end.
Manager (ACCOUNTS), GUJARAT TELEPHONE CABLES LIMITED
At Ahmedabad Corporate Office from May 1994 till May 1995. Was primarily responsible for managing the external borrowings (rupee and foreign currency loans) portfolio of the company , apart from managing some key functions of the accounts and computerisation departments of the company. Actively participated in the finalization of annual accounts of the company at year end.
DEPUTY GENERAL Manager (ACCOUNTS), GOKUL REFINERIES & OILS LIMITED
FINANCIAL CONTROLLER & AUDITOR, CIP MACHINERIES PRIVATE LIMITED
STATUTORY AUDITOR & FINANCE CONSULTANT, OPAL INFOTECH
All India Senior Secondary School Examination (CBSE)(12th), Modern School, Poorvi Marg, Vasant Vihar, New Delhi-110067
Science Stream (Physics, Chemistry, Mathematics, Engineering Drawing, English and Hindi)
BA (Economics) honours, shri ram college of commerce, maurice nagar, delhi-110002
Completed my graduation with various papers in all aspects of Economics, including Microeconomics, Macroeconomics, Indian Economy, Public Finance, etc.
CHARTERED ACCOUNTANCY FINAL EXAM, THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA, INDRAPRASTHA MARG, delhi-110002
(C) POST QUALIFICATION DIPLOMAS:
(D) PRE-QUALIFICATION TRAINING:
M/s Lovelock & Lewes, Chartered Accountants (Now merged with Price Waterhouse Coopers Global), Bombay & Delhi Office (1984-86).
American Express Bank Limited, New Delhi (1986-87).
M/s S. B. Billimoria & Sons, Chartered Accountants, New Delhi (1987). During the course of my SQT, have been trained by the Loans Department to audit the Loan Documentation of Housing Development Finance Limited (HDFC) and have successfully conducted the Branch Audit of their Lucknow Branch as Audit-In-Charge, for which my work was lauded by their Partner on appraisal of my Audit & Working notes.
(E) EXTRA CURRICULAR ACTIVITIES :
Ø Ex-Member & Ex-Chairman of Suyash Members Association "B" Block Maintenance Committee (on a/c of ownership flat).
Ø Ex-Secretary of "ARTI" (Administrative Reforms Techniques Institute), Ahmedabad,
Ø Ex-Member of Gujarat Internet Users Group(GIUG), Ahmedabad.
Ø Ex-UnderSecretary (Debating) in 2nd year of College at Shri Ram College of Commerce.
(F) PAST OCCUPATION:
Ø Branch Statutory Auditor, State Bank of Mysore, (H.O.: Bangalore)
a. Basava Raja Market Branch, Raja Rajeshwari Branch and Nandini Layout Branch, located in Bangalore, Karnataka for the the Financial year ended March 31st, 2006, Sunkadakatte Branch and Nagarbhavi Stage-II Branch located in Bangalore, Karnataka for the the Financial year ended March 31st, 2007, CBAB Complex Branch
b. Mahalaxmi Layout Branch located in Bangalore, Karnataka for the the Financial year ended March 31st, 2008 & Cantonment Area, Bellary Branch
c. Kanchipura Branch located in Karnataka for the Financial year ended March 31st, 2009.
Ø Have been appointed as Concurrent Auditor of Bank of Baroda, (H.O.: Mumbai) Vatva Industrial Estate Branch, Ahmedabad commencing from April, 2008 till March 31st, 2009.
Ø Have been appointed as the Concurrent Auditor of Bank of Baroda, Maskati Market Branch, Ahmedabad commencing from January 2003 till December 2005, extended upto March 2006 and further upto March 2007.
Ø Have been appointed as Concurrent Auditor of Narol Branch, Ahmedabad with Bank of Maharashtra from March'2004 to March’2005.
Ø Have been empanelled for the Revenue & Expenditure Audit of the Indian Overseas Bank for Ahmedabad since the financial year ended (FYE) 31/03/2002 till FYE 31/03/2005. Covered the following branches in this duration.
(A) Gita Mandir Road Branch, Ahmedabad;
(B) B. D. Patel House, Naranpura, Ahmedabad;
(C) Ashram Road Branch at Ahmedabad;
(D) Sardar Patel Road, Morvi;
(E) MJM College Road Branch, Rajkot;
(F) Vaniavad Branch, Rajkot;
(G) Bhavsingh Park Road Branch, Porbandar; and
(H) Relief Road Branch, Ahmedabad.
Ø Have been empanelled by Dena Bank for the purpose of conducting Revenue & Inspection Audits, Stock & Recievables Audit and Concurrent Audit from March'2005 till March’2006.
Ø Had been working in an informal partnership with Mr. Rajiv I. Ravani, Proprietor, M/s. Rajiv I. Ravani & Co., Chartered Accountants, Ahmedabad from May'1999 till December’2012.
Ø Have been in Independent Practise as a Chartered Accountant since May'1995.
Ø Was associated with M/s Arun Arora & Co., Insurance Surveyors, Ahmedabad in a professional capacity for carrying out Stock Assessments upto 2003.
Ø Have carried out the Half-Yearly Stock Audit of Shakti Cotton Industries, Vijapur, Navkar Industries, Unjha and Urvesh Psyllium Industries Limited, Siddhpur and have been involved in the Stock Audit of Royal Castor Industries Limited, Siddhpur on appointment by Dena Bank.
Ø Have been associated with Cip Machineries Private Limited, Ahmedabad in the professional capacity as Statutory Auditor, Financial Consultant and Advisor since 1995, after having started practise as a Chartered Accountant. Have been actively involved in looking after Accounts, Company Law Affairs, Taxation (Corporate & Personal) and MIS of the Company since 1995 till present. Have been actively involved in an advisory capacity in the development of a customised ERP software for their internal use using SQL Server 2000 since 1998 till date.
(G) COMPUTER LITERACY:
Ø Am currently self-learning Visual Basic Programming using VB6, Visual Studio 2010/2019 and SQL Server 2010 Database Programming for supplementing my skills in the Financial Sector and have self-learned and am fairly well-versed with Visual Basic for Applications as a part of the Microsoft Office'2000-2016 / MSOffice365 Suite for developing forms and modules in Microsoft Excel, Word and Access.
Ø Fairly high versatility in all popular Windows based packages like MS Excel 2016, MS Word 2016, MS PowerPoint 2016, MS Access 2016, MS Publisher 2016, MSWorks 6, OpenOffice.ORG 1.46, LibreOffice 6.3, Corel WordPerfect v 5/12, Lotus 1-2-3, FoxPro+, DBase+, Quattro-Pro etc.
Ø Well-experienced in using Windows-based Accounting packages like Busy Accounting, Value'95, all versions of Tally 5.40 till present Tally.ERP9, E-X Next Generation, Miracle Accounting Software, QuickBooks, Microsoft Money, Microsoft Accounting 2007 and Quicken'2000-2007.
Ø Have experience in running ERP Software on UNIX and Windows Platform u Have independently developed critical modular Clipper 5.20 executable code to manipulate databases for maintaining accounting/financial data
Ø Have developed an expertise in preparing financial projections for Term Loans for New Projects/Expansion of existing projects for submission to Banks/Financial Institutions (E.g. Vimal Oil & Foods Limited, Mehsana & Vimal Diary Limited, Mehsana - For another Chartered Accountant)
Ø Experience in preparing worksheets with detailed quantitative working forming the basis for CMA/QIS data for Working Capital Requirements and for Project Finance Workings
Ø Have developed Spreadsheets for detailed MIS data from existing Financial Accounting System's databases
Ø Have developed spreadsheets for filing income-tax returns for corporate and for individuals including Form 16 and computations (SaralNew & Saral2003 Excel Application in Microsoft Excel)
Ø Have developed a complete Payroll package in Clipper 5.2 and for managing supplier payments in a medum-sized private sector company
Ø Have reasonable good experience in setting up complete Computerised Accounting Packages in both UNIX , Dos and Windows.
Ø Have represented Cip Machineries Pvt. Ltd. at the SDRC User's Conference'2000 in November'2000 at Pune, where a presentation was made on the use of CAD/CAM Software Ideas Artisan Series 4 in achieving competitive edge
Ø Have made a presentation on "Efficiently Browsing the World Wide Web" on behalf of the Gujarat Internet Users Group at Bhaikaka Hall in July'1999
Ø Have made a presentation on "What's new in Excel'2000" and the InfoHighway'99 exhibition held at Ahmedabad in September'1999
Ø Have prepared a Corporate Profile CD for Cip Machineries Private Limited in HTML format containing Corporate Profiles, Management Profiles, Product Images, Technical Specifications and Movies detailing use of Pharmaceutical Machineries and for Cip Infosys Private Limited for marketing CipSoft, an ERP Software offering Complete Chain Management software .
(H) PROFESSIONAL ASSIGNMENTS UNDERTAKEN:
Ø Preparation of Financial projections, Detailed Project Report and draft prospectus for Vimal Dairy Limited, (Mehsana) Public Issue u Preparation of Financial Projections (including CMA & QIS Data), Detailed Project Report and draft prospectus for Vimal Oil and Foods Limited, (Mehsana) (ranked amongst the Fortune 500 companies of 1995) Public Issue (Castor Oil Project)
Ø Preparation of CMA data for sanction of working capital facilities for Patina Trading Company Pvt. Ltd. (an enterprise of M/s Mohanlal S. Mithaiwala, Bombay) for their plant at Kheda
Ø Statutory Auditor of M/s Ramkumar D. Agrawal (Stock & Share brokers at Ahmedabad)
Ø Statutory auditor and accounts consultant of M/s CIP Machineries Pvt. Ltd., Ahmedabad
Ø Statutory auditor and accounts consultant of M/s Cosmic Byte Pvt. Ltd., Ahmedabad.
Ø Statutory auditor and accounts consultant of M/s Total Solutions, Insurance Claim Investigators, Ahmedabad.
(I) SCOPE OF PROFESSIONAL WORK SOUGHT:
Ø Stock & Receivables Audits u Concurrent Audits
Ø Income & Expenditure Audits
Ø Revenue Audits u Statutory audits
Ø Tax Audits
Ø Project Finance Consultancy
Ø Public Issues related work
Ø Management and Operations Audit
Ø Certification work u Preparation and submission of CMA/QIS data upto sanction of Working Capital Limits
Ø Procurement of Term Loans from Financial Institutions / Banks
Ø Tax Audits u Filing of Income Tax returns
Ø Company Law matters relating to Registrar of Companies, Gujarat
Ø Presentations on any aspect of the Finance / Accounts Department using software like Microsoft Word, Excel, PowerPoint, Access, FrontPage etc.
(J) REFERENCES :
(1) Dr. O. P. Gupta, B-304, Shashwat Apartments, Atithi Dining Hall Lane, B/h GNFC Infotower, Bodakdev, AHMEDABAD-380054.
Phone: (R) +91-79-26852222. (Clinic) +91-79-26462131 (M) +91-9825474680.
(2) Mr. Rajiv I Ravani, M/s Rajiv Ravani & Co., Chartered Accountants, 703, Abhishree Avenue, Opposite Hanuman Mandir, Near Nehru Circle, Satellite Road, Ahmedabad-380015.
Phone: (O) +91-79-26447150 (R) +91-79-27452928 (M) +91-9825024929.
Email: firstname.lastname@example.org / email@example.com
(3) Mr. Jignesh J. Mehta, MBA (International Trade), Innomac Healthcare Equipments Pvt Ltd., 301, Krishna Palace, Near Maninagar Railway Station, Maninagar, AHMEDABAD-380 008.
Phone: (O) +91-79-25468888 (TeleFax) +91-79-25452888 (M) +91-9825305514.
(4) Mr. Jigney Bhachech, M/s Opal Infotech, 711, Samaan Complex, Opp. Satyam Mall, Near Jodhpur Char Rasta, Satellite, AHMEDABAD-380015.
Phone: (O) +91-79-26750333 / +91-79-26752333 (M) +91-9426001664
(5) Mr. Gaurav Ramavtar Agarwal, CEO, Total Solutions, 201, Brooklyn Towers,
Adjacent to YMCA, S. G. Highway, AHMEDABAD-380015.
Adjacent to YMCA, S. G. Highway, AHMEDABAD-380015.