PUNITH MANJUNATH
Bangalore
Summary
To Advance MS Excel, Powe BI, MS Access & and Basic SQL in my profession and to be an asset to the Organization I am associated with.
Skilled data analyst with more than 8 years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical figures. Energetic presenter and confident communicator with the ability to circulate information in a way that is clear, efficient, and beneficial for end users. Creative in finding solutions to problems and determining modifications for optimal use of organizational data. Organized and timely in providing staff, departmental members, and executive management with reports on specific data findings and their impact on organizational growth and success. Overall, 8 years of experience in Data analytics In Sales, Distribution, Marketing and finance analysis, Back End Operations and administration. Detail-oriented professional with a strong background in data analysis and customer support. Seeking a role to address data-related requests, collaborate with first-line support, and contribute to the creation of a knowledge base, leveraging practical experience and learning-by-doing strategies. Maintaining cordial relationships with internal and external customers, ensuring quality and service norms to achieve customer satisfaction and business retention. A keen planner and execution with proven track records of consistently increasing the sales/ profitability of the company through MIS. Hardworking employee with customer service, multitasking, and time management abilities. Devoted to giving every customer a positive and memorable experience.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Sales & Data Analytics (Manager)
Shield Healthcare Pvt Ltd
Bengaluru
04.2018 - Current
- Proficient in data collection and cleaning, preprocessing, and analysis
- Experienced in using tools such as Advance Excel, SQL, and MS Acess for data manipulation and analysis
- Utilize data analysis tools and techniques to troubleshoot and resolve complex data-related challenges and Performance Monitoring Monitor key performance indicators (KPIs) to assess the effectiveness of sales strategies and identify areas for improvement
- Forecasting and Predictive Analysis Utilize historical sales data to create accurate sales forecasts
- Analyze customer data to identify segments based on demographics, behavior, and preferences
- Provide insights into the characteristics of high-value customers and target specific market segments for tailored sales approaches
- Competitor Analysis Monitor and analyze competitors' sales strategies, pricing models, and market share
- Analyze the sales funnel to identify areas of improvement and optimize the conversion process
- Provide recommendations to increase lead generation, lead qualification, and conversion rates Reporting and Visualization Develop and generate regular reports and dashboards to communicate sales performance to stakeholders
- Cross-Functional Collaboration Collaborate with marketing, finance, and other departments to integrate sales data with other business functions
- Work closely with sales teams to understand their needs and provide actionable insights
- Technology Utilization Stay updated on the latest technologies and tools for data analysis and reporting
- Implement and utilize CRM systems and other analytical tools to streamline data processes
- Training and Support Train sales teams on data-driven practices and tools
- Provide ongoing support to ensure the effective use of data in decision-making
- Incentive working- compile and prepare Employee incentives are rewards and privileges that motivate employees to meet business goals
- Upload the data and monitor For “DIGISHIELD” which is software for Field force to get the data online
- Organize, extrapolate, and disseminate data across departments to be used for concluding the success of current methods
- Presented detailed reports about the meaning of gathered data to members of management and helped them identify scenarios utilizing modifications in the data
- Organized quarterly projection data gathered in an orderly way for executive management
- Reported bi-monthly data analysis findings to upper management to use in making organizational decisions
- Assisted superiors with interpreting data and compiling it in an organized manner
- Prepare BEP Every Month
- Daily Sales and finance MIS, Data Analysis
- Digitalization & Visualization Project: Lead resources in implementing DIGISHIELD (An advanced tool used by field Forces across india)
Sr. Regional Sales and Finance Executive
Gionee India Pvt.Ltd
Bangalore
12.2016 - 01.2018
- Prepare and close Monthly Scheme Working
- Incentive working for GSC & Brand Promoter
- Daily Sales and finance MIS, Data Analysis
- Reconcile any discrepancies or errors identified by conversing with ND and/or RDS Partner Coverage analysis of GSC & Brand Promoter
- Analyze Regional Performance Tracker
- Cost & Revenue Analysis
- Monitor stock availability at online partner Regular KPI Updates along with Plan for the day
- Monitor daily productivity Target Vs Achievement Analysis.
Circle Sales Analyst
Sistema Shyam Teleservices Limited
Bangalore
08.2015 - 12.2016
- Responsible for Provide all support to sales team, Distributors, for their Targets, Achievement & Incentives
- Responsible for Retailer Meets, Distributor’s & Channel Partners monthly & quartly meets
- Responsible for all Corporate & Prepaid Sales MIS, Data Analysis
- Responsible for make the churn Projection for next month n calculates the Gross n Net Adds
- Responsible for Monthly Claims & incentive of all Channel Partners, Distributors & Sales Team
- Make all the presentation for the Prepaid Head as well as Sales Head Monthly
User and Retention Marketing Analyst
Sistema Shyam Teleservices Limited
Bangalore
08.2015 - 12.2016
- Run and schedule customized Campaign
- Prepare and analysis data revenue report
- Calculate the retailer commission monitor on credits
- Schedule offer SMS to the customer base
- Remainder their Usage on SMS for (postpaid customer)
- Promote speed booster on usage
- Analysis customer pulse to generate maximum revenue
- Data KPI reports
- Other adhoc activities.
MIS Manager
Mahaveer Distributors
Bangalore
02.2014 - 08.2015
- Sales Management – Generate Daily Sales Report for all the Brands, Prepare Daily Collection Summary Executive wise/Route wise
- Vigilance & Alert Management – Prepare route deviation report, Prepare Monthly (LMTD Vs MTD) Reports to keep an eye on Performance, Monthly Growth/Decline Report Executive wise/Route wise
- Logistics Management – Stock Summary for All Brands, Responsible for timely Purchase Orders, Manage Transport Costs through optimal mix of brands, Damage & Expiry Reports Payroll Management – Attendance, Leave Processing, Salary & Incentive Processing
- Office & Administration – Manage Petty Cash, Ensuring Office Hygiene, Purchase Stationery & other Miscellaneous Expenses at Office
MIS Executive
Idea Cellular
Bangalore
11.2011 - 02.2014
- Management Information Systems Prepare Daily Activation Report of Karnataka Circle By using MS Access And Excel Circulated All Report Summary Zone wise to the ZBM, ASM & Zonal MIS Dally Basis Generating reports of daily activations of all regions and sending to COO, HODS & Concerned Business Representatives Revenue Analysis s& Target Vs Achievement Analysis Maintaining daily sales & monthly Sales Reports& In-Depth Analysis of Sales & Marketing Providing total support to the Distribution Department
- Ensure that all reports are generated & provided on time consistently Sales scheme, new plan& target vs Achievement communication through SMS for Circle sales team on daily basis
Sales Promoter
TATA Docomo
01.2011 - 10.2011
- As a Brand Promoter for TATA Docomo, responsible for Promotions & Sales of TATA Docomo 3G Dongles at Retail Stores.
Education
BCOM -
JIWAJI University
PU -
Govt. College, Krishnarajapuram
SSLC -
Sri Vivekananda Vidya Kendra, Hoskote
Skills
- Data Entry
- Statistical Analysis
- Data Aggregation Processes
- Advanced Data Mining
- Analytical Thinking
- Customer Service
Certification
- TALLY
- ADVANCE EXCEL
- Power BI
- MS SQL
- PYTHON BASIC
Family Background
Agriculturist Background.
Personal Information
Date of Birth: 04/30/91
Hobbies and Interests
- Love Animals and I am a nature Lover.
- Movies, Cricket & Listening to Music
Languages
Kannada, English & Hindi
Accomplishments
- Digitalization & Visualization Project:
- We just finished a cool project to make things digital, and it worked really well! Now, employees can use a mobile app called DIGISHIELD to quickly check their sales info for their area. It's way faster than the old way of getting reports by email - they save 80% of their time! Everyone's pretty happy about it!
- This new project received positive feedback from employees who appreciate the convenience of accessing sales information on their mobile devices. It's a simple way for them to stay informed and engaged with their region's sales data.
Affiliations
- Teamwork & Ability to guide and motivate others.
- Flexibility in handling change.
- Problem-Solving
- Efficient use of time and resources.
- Analytical Skills
- Initiative
Additional Skills
- Market Knowledge and staying updated on industry
- Collaboration with cross-functional teams.
- Flexibility & adapt to changes
References
References available upon request.
Timeline
Sales & Data Analytics (Manager)
Shield Healthcare Pvt Ltd
04.2018 - Current
Sr. Regional Sales and Finance Executive
Gionee India Pvt.Ltd
12.2016 - 01.2018
Circle Sales Analyst
Sistema Shyam Teleservices Limited
08.2015 - 12.2016
User and Retention Marketing Analyst
Sistema Shyam Teleservices Limited
08.2015 - 12.2016
MIS Manager
Mahaveer Distributors
02.2014 - 08.2015
MIS Executive
Idea Cellular
11.2011 - 02.2014
Sales Promoter
TATA Docomo
01.2011 - 10.2011
BCOM -
JIWAJI University
PU -
Govt. College, Krishnarajapuram
SSLC -
Sri Vivekananda Vidya Kendra, Hoskote