RAVIKIRAN INDRAKANTI
HYDERABAD
Summary
To secure a challenging and rewarding position in this era where I can best utilize my extensive technical and practical experience to promote my career path while I contribute for the growth of the organization.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Asst.Manager
MYK ARMENT PVT LTD
Hyderabad
06.2018 - Current
- Company Overview: MYK ARMENT PVT LTD is a joint venture between MYK group of companies Hyderabad and Schomburg GmbH of Germany who are one of the leading solution providers to the construction industry in the European market with a complete line of products, systems and services in 39 countries for over 70 years with 12 manufacturing plants worldwide
- Preparation of dynamic Charts &dashboards by using critical formulas in Advanced Excel for National Sales Management and Special Price Approval process
- Using with SAP data (dump), generate MTD & YTD reports using with Advanced Excel & Power Point presentation for month end meets with Management
- Calculation templets for GP % depends on various products and for various price
- Preparing daily, weekly, monthly sales reports with Pivot’s Charts and Dashboards
- Produce descriptive statistic reports using graphs with the filtered data (Pivots) in MS-Excel and present the reports in MS-Power point
- Day wise and month wise reports submission to various H.O.D’s like Marketing & Finance
- To do the comparative analysis & document the reports for the higher management using functions like V-LOOKUP, H-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF(S), COUNT IF(S), INDEX MATCH, COMPLEX FORMULAS….etc
- MYK ARMENT PVT LTD is a joint venture between MYK group of companies Hyderabad and Schomburg GmbH of Germany who are one of the leading solution providers to the construction industry in the European market with a complete line of products, systems and services in 39 countries for over 70 years with 12 manufacturing plants worldwide
MIS EXECUTIVE
SPORTSCULT SERVICES PVT LTD
Bangalore
05.2015 - 05.2018
- Company Overview: This company operates multi-format professionally managed sports facilities, including training and coaching services in various sports
- MIS Reports (VLookup, Hlookup, Pivot Table, Data Validation, Conditional Formatting, In-built Functions, Network days) for Sports Equipment database Reports
- PPT and Analysis report showing in PPT Status Reporting - Daily, Weekly and Monthly
- Preparing daily, weekly, monthly sales reports with Pivot’s Charts and Dashboards
- Preparation of dynamic Charts & dashboards by using critical formulas in Advanced Excel
- Reports analysis and creating Dash Boards with power point presentations
- Produce descriptive statistic reports using graphs with the filtered data (Pivots) in MS-Excel and present the reports in MS-Power point
- Maintained internal storage (Database) data using with MS Access
- This company operates multi-format professionally managed sports facilities, including training and coaching services in various sports
MIS EXECUTIVE & ACCOUNTS
ULTRATECH CEMENTS LIMITED
Hyderabad
09.2011 - 05.2015
- Company Overview: UltraTech Cement Ltd, a flagship company of the Aditya Birla Group, Birla White is India's largest white cement producer with a production capacity of over 550 thousand tonnes annually
- To do the comparative analysis and document the reports for the higher management using functions like VLookup, Hlookup, Pivot Table, Data Validation, Conditional Formatting, In-built Functions, Network days
- Maintenance of Account Receivable modules including invoice processing, receipts & reconciliation
- Interaction with suppliers for material delivery related issues and payments
- Preparation of MIS report as per requirement of different department heads
- Verify the accuracy of all the accounting entries and ensure the General Ledger is updated on regular Basis and the books reflect correct balances
- Maintaining Purchase, Sales & Stock Register
- Monthly books closing of following schedule
- Preparation of State wise sales & purchase reconciliation
- Deposits and Stock Transfer Reconciliation
- UltraTech Cement Ltd, a flagship company of the Aditya Birla Group, Birla White is India's largest white cement producer with a production capacity of over 550 thousand tonnes annually
Education
MBA - FINANCE
Q.I.S COLLEGE OF ENGG&TECH
ONGOLE01.2011
Bachelor’s Degree -
T.J.P.S COLLEGE
GUNTUR01.2008
Skills
- Proficiency in MS-Office
- Functional knowledge of Accounts Related Applications
- Knowledge in Tally ERP9
- Advanced Knowledge in Excel
- Knowledge in SAP(FI-CO) as end user
Certification
Certified as Microsoft Office Expert – Excel-2007
Place
HYDERABAD
Projects
Cash and Receivables Management, Bharath Heavy Electricals Limited (BHEL), HYD, 45 Days
Disclaimer
I hereby declare that all the Information provided by me in this Application is Factual and Correct to the best of my Knowledge and belief.
Project Description
Done the project in BHEL (Bharat Heavy Electrical Limited) under ‘Cash and Receivables Management’. In this project period I understood the strength and weakness of the organisation in relation to cash/Credit management. I observed that how much cash inflows and cash outflows for each period of the planning period. At the completion of my project period I gave some useful suggestions to the organization. To manage the net working capital and net assets in increasing way that is useful for the growth of the company.
Personal Information
- Father's Name: I.C. KAMALA KUMAR
- Date of Birth: 05/15/88
Timeline
Asst.Manager
MYK ARMENT PVT LTD
06.2018 - Current
MIS EXECUTIVE
SPORTSCULT SERVICES PVT LTD
05.2015 - 05.2018
MIS EXECUTIVE & ACCOUNTS
ULTRATECH CEMENTS LIMITED
09.2011 - 05.2015
MBA - FINANCE
Q.I.S COLLEGE OF ENGG&TECH
Bachelor’s Degree -
T.J.P.S COLLEGE
Similar Profiles
Chandan Kumar JhaChandan Kumar Jha
Technical Engineer at MYK ARMENT PVT LTDTechnical Engineer at MYK ARMENT PVT LTD
Shiva Kumar SingarapuShiva Kumar Singarapu
Senior Executive (Accounts Receivables) at MYK Arment Pvt. Ltd.Senior Executive (Accounts Receivables) at MYK Arment Pvt. Ltd.
Arup Kumar GhoshArup Kumar Ghosh
Cluster Sales Manager - CG &MP at MYK Arment Pvt LtdCluster Sales Manager - CG &MP at MYK Arment Pvt Ltd