Pratham Prajapati
Advanced Excel Automation & Data Analysis Specialist
New to Contra
Pratham is building their profile!
I developed a comprehensive analytics solution to monitor business performance across Finance, Sales, Marketing, and Supply Chain.
Key Deliverables
Executive Summary: Created a top-level view tracking Net Sales, Gross Margin, and Net Profit performance against benchmarks.
Financial Analytics: Automated Profit & Loss statements and visualized Unit Economics, including Operational Expenses and COGS.
Sales & Marketing: Built performance matrices to analyze product and customer growth across global regions like APAC and NA.
Supply Chain: Developed forecast accuracy tracking to identify Out-of-Stock and Excess Inventory risks.
Technical Stack
Data Tools: Advanced Excel and Power BI.
Techniques: Power Query, DAX, and interactive dashboard design.
3
5
207