Project Details

Objective: Generated detailed Profit and Loss (P&L) reports for AtliQ Hardware across multiple fiscal years, including quarterly Gross Margin Percentage (GM%) analysis by sub-zone, utilizing advanced Excel features like PivotTables.

Key Responsibilities: Calculated key metrics: Gross Margin and Gross Margin Percentage. Compared performance across markets to identify strengths and areas for improvement.

Key Findings: Australia: Highest net sales ($20.99M) but lower GM% (32.9%), suggesting potential for improved cost management. Austria: Lowest net sales ($2.84M) and GM% (30.1%), highlighting a need for strategic adjustments. Bangladesh: Strongest GM% (34.5%), indicating effective cost management despite lower net sales ($6.95M). Outcome: Provided actionable insights to enhance profitability and cost efficiency across markets, supporting strategic decision-making.

Project Details

Finance View: Developed a comprehensive P&L analysis tool that allows users to generate statements for any customer, product, or country, with the ability to aggregate across multiple dimensions over any time period.

Sales View: Created a dashboard to track customer performance across key metrics such as Net Sales and Gross Margin, enabling users to analyze profitability and growth through detailed matrices.

Marketing View: Designed a product performance analysis tool that

Live Interactive Dashboard

Project Details

Conducted comprehensive analysis of hotel occupancy and revenue data to identify patterns and support strategic decisions.

Calculated average occupancy rates across various room categories and cities, and analyzed trends between weekdays and weekends, driving insights into guest behavior.

Determined city-specific occupancy rates during peak travel months, such as June, to optimize resource all

Project Details

● Developed comprehensive SQL queries and database views to analyze and optimize sales data, incorporating pre- and post-invoice deductions, and calculating net sales for various markets, enabling a more accurate financial reporting system.

● Created stored procedures to dynamically generate top market and customer reports by net sales, and implemented ranking algorithms to identify top products by division, enhancing data-driven decision-making and performance tracking across multiple segments.