Data and Operations Analyst
Everest Agencies
Total years of experience :15 years, 9 Months
Everest Agencies: Established electrical showroom specializing in leading brands like HAVELLS, L&T, and BAJAJ. Offers a comprehensive range ofelectrical products including switches, water heaters, LED fittings, and solar panels.
• Extract, transform, and load data from various sources, including Sales operations, inventory management systems, financial databases, and Procurement.
• Generate and present reports on sales, inventory levels, profitability, payments and receivables, and customer behaviour.
• Design and develop reports and create reports from complicated databases and dashboards using Excel and Google Sheets, effectively presenting data insights to management.
• Implement statistical techniques and forecasting models to predict future trends and inform business decisions.
• Manage and maintain the companys MIS systems.
Balco Pipes: Leading manufacturer of PVC electrical conduits, fittings, and water pipes (uPVC) under the Balco brand. Operates 4 manufacturing facilities across India, boasting a cumulative annual production capacity of5, 000 metric tonnes
• Executed business plans and managed sales operations.
• Collaborated with managers for strategic planning and target achievement.
• Supported sales team in promotions, pricing, and demand forecasting.
• Streamlined workflows for order management, collections, and credit policies.
• Developed and automated MIS for efficient data management.
• Established and maintained the first organized customer database.
• Used data analysis to control profitability and increase contributions.
• Implemented a robust mechanism for accounts receivables management.
• Optimized inventory processes for improved customer service and sales.
Sheenlac Paints Ltd: Industry leader in the paint segment, holding a dominant market share of over 50% in the thinner category.
Joined as Sales Controller and later got promoted to Branch Admin Manager
• Managed sales operations for Rs 1bn annual turnover with more than 2000 customers including Order management, Primary / Secondary / Tertiary sales data, Accounts receivables, MIS, Trade promotions, Customer communications, team productivity, sales target management etc supporting an annual sales growth of more than 20% while industry growth was 11%
• Prepared the annual admin budget along with all the administrative functions ofthe branch including sourcing
• Led the management ofsales billings, secondary sales data, and payment settlements ofdealers and distributors
• Rendered support to the corporate HR with the branch related works, and clearance ofemployee bills
• Liaised with finance team to contribute in statutory and auditing requirements while maintained records, preparing reports from SAP.
Sony is a fortune 100 consumer electronics company
• Led office activities and operations efficiently, with increased effectiveness, managed office annual budget and ensured accurate and timely reporting while ensuring compliance to company policies
• Administrated the contract and price negotiations with office vendors, service providers and office lease
• Managed facility management vendors, including cleaning, catering and security services for day to day operations
• Organized the office layout, planned office maintenance, ordered stationery and equipment, monitored the inventory, recycling and scrap, renovations, event planning etc.