RAMITHA K M
Bangalore
Summary
Business Analyst with over 5 years of experience in business and data analysis, skilled in SAP, Power BI, and Advanced Excel. Demonstrated proficiency in driving business growth through effective communication and strategic sales development. Strong analytical capabilities and expertise in optimizing business processes contribute to enhanced decision-making and operational efficiency. Aiming to apply these competencies within a dynamic organization focused on growth.
Overview
6
6
years of professional experience
Work History
Business Process Analyst
VOLVO EICHER Commercial Vehicles Ltd.
Bangalore
02.2023 - 08.2024
- Developing and Managing Daily, Weekly, and Monthly Sales Performance Report
- Analysing sales trends and providing actionable insights to improve sales strategies
- Utilizing tools like Power BI, Excel, and SAP for data visualization and reporting
- Collaborating with sales team to design and implement effective sales strategies
- Conducting market research and competitor analysis to identify opportunities and threats
- Training team on CRM usage and addressing technical or process-related queries
- Preparing presentations and reports for senior management on sales performance and market insights
- Designing sales incentive programs to motivate teams and drive performance
- Developing Sales Forecasts Based on Historical Data, Market Trends, and Current Performance
- Implemented a system for tracking and analysing KPIs, driving continuous improvement
- Implementing automated solutions to reduce manual tasks in sales operations
- Collecting and analysing customer feedback to enhance products or services
- Conducting performance reviews for sales teams and identifying areas for improvement
- Tracking Individual and Team Contributions to Overall Sales Targets
- Analysed competitor data to improve market share and conducted market activities to enhance business growth
- Assisted VECV employees by providing reports and data to improve efficiency and save time
- Created reports using Power BI to analyse business metrics and competitor data and presented findings to the team
- Maintain knowledge of all models in the department and provide training to dealer employees as required
- Coordinated with dealer teams and VECV employees to address sales-related queries and ensure smooth operations
MIS Reporting Analyst
Vidal Health Insurance TPA Private Limited
Bangalore
12.2018 - 01.2023
- Analysed and summarized large datasets to provide actionable insights
- Collect and compile data from multiple sources
- Handled Adobe queries related to the process on a regular basis
- Prepare regular reports (daily, weekly, monthly) to monitor KPIs
- Managed and verified data received from brokers and internal teams to ensure consistency and quality
- Utilized advanced Excel functions, such as pivot tables, VLOOKUP, HLOOKUP, formulas, and macros to organize and analyse data
- Create dashboards and visualizations for data presentation using tool like Power BI & Excel
- Managed and updated records from internal tickets, ensuring accurate and timely information sharing
- Provided end-of-month support for finance team with business summary reports
- Coordinated with internal and external teams to manage projects for major corporate clients, such as Accenture, Wipro, and SBI Etc
- Experienced in working with large datasets and ensuring data accuracy
- Delivered presentations summarizing key findings and recommendations
- LED a team of 25 members, coordinating tasks and providing support
- Coordinated with internal departments to provide data updates and respond to queries regarding the status of data changes
- Resolved client and stakeholder queries related to MIS reports and data updates efficiently
- Coordinated with different departments to manage client data updates
Education
Bachelor of Commerce -
University of Mangalore
Karnataka, India01.2018
Skills
- SAP
- CRM and Udaan Analytical Tool Expertise
- VBA and Macros
- Typing speed: 40 WPM
- Data Analysis and Visualization
- Data cleaning and pre-processing
- Advanced Excel with ChatGPT Plus v40
- Power BI
- MS Office Suite
- Presentation skills
- Quality reporting
- Data monitoring
- Business Intelligence
- Insight and Analytics
- Team collaboration
Languages
- Kannada
- English
- Telugu
- Malayalam
Personal Information
- Date of Birth: 04/13/98
- Nationality: Indian
Certificationsandawards
- Preparing Data for Analysis with MS Excel (Microsoft)
- Harnessing the Power of Data with Power BI (Microsoft)
- Save time with Microsoft Excel (Coursera)
Timeline
Business Process Analyst
VOLVO EICHER Commercial Vehicles Ltd.
02.2023 - 08.2024
MIS Reporting Analyst
Vidal Health Insurance TPA Private Limited
12.2018 - 01.2023
Bachelor of Commerce -
University of Mangalore
Similar Profiles
Kishor Eknath KasarKishor Eknath Kasar
Assistant Manager – QA/QC at Volvo Eicher Commercial Vehicles LtdAssistant Manager – QA/QC at Volvo Eicher Commercial Vehicles Ltd
RISHABH DEORISHABH DEO
Area Sales Manager _ UP East at Volvo Eicher Commercial VehiclesArea Sales Manager _ UP East at Volvo Eicher Commercial Vehicles
Nikhilesh D DioreNikhilesh D Diore
Senior Manager, Projects at Volvo Eicher Commercial Vehicles LtdSenior Manager, Projects at Volvo Eicher Commercial Vehicles Ltd