Varun Malan

Techno-functional Business Analyst with 6 years of experience in dashboarding, process automation, and reporting. Expertise in translating business requirements into technical solutions that enhance efficiency and support data-driven decisions. Proven ability to analyze trends and deliver actionable insights that improve business operations. Collaborative team player with a strong focus on driving productivity through technology solutions.

HackerRank SQL (Basic and Intermediate)

• Certified in SQL query writing, data extraction, joins, aggregations, and optimization techniques

Advance Microsoft Excel

• Proficient in advanced Excel features, including PivotTables, Power Query, data validation, macros, VLOOKUP, INDEX-MATCH, and dashboard creation

Sales Data Analysis, Forecasting, and Dashboarding Duration:

• Gathered raw sales data from multiple sources, including ERP systems, CRM, and Excel
• Performed comprehensive data cleaning, exploratory data analysis (EDA), and feature engineering to identify key sales drivers and anomalies
• Built predictive models using regression techniques to forecast future sales trends with over 85% accuracy
• Designed and deployed interactive dashboards using Power BI to visualize real-time sales performance, forecasts, and customer segment behaviors
• Enabled leadership to make data-driven pricing and marketing decisions through actionable insights

Segmentation Rule Implementation in SAP (BRD Preparation)

• Led the Business Requirement Documentation (BRD) preparation for implementing new customer segmentation rules in SAP ERP
• Worked closely with cross-functional teams (Sales, IT, Finance) to define accurate mapping of customers into business segments based on sales behavior
• Created MIS dashboards in Excel and SAP Analytics Cloud to monitor sales against each segment post-implementation
• Improved accuracy of sales tracking by segment by 25%, enabling better performance analysis, and strategic planning
• Automated regular reporting using SAP queries and Power BI, ensuring transparency and faster decision-making

• Process Improvement - Achieved sales objective by implementing segmentation rule.
• Led team to meet 98% of SLAs by streamlining business processes and identifying areas for improvement.