Nauman Khalid - ACMA

Experience

• 

  Rupali Polyester Limited

  Nov 2011 - Mar 2013

  Assistant Manager Accounts
• 

  Sapphire Textile Mills Limited

  Mar 2013 - Aug 2015

  Assistant Manager Costing & Budgeting
• 

  Nishat Mills Ltd.

  Aug 2015 - Feb 2019

  Deputy Manager Account
• 

  Outfitters Stores

  Feb 2019 - Apr 2021

  Manager Financial Planning and Budgeting

  Leading the Business Planning process, my responsibilities include,• Preparation and submission of corporate strategic business plan, Annual business plan, Monthly rolling forecast, Ad Hoc reporting/ Analysis.• Consolidating/Integrating financial/non-financial data for budget preparation, review of underlying assumptions, applying business logics to build projected financial statements.• Business partnering with support functions [Retail, Marketing, HR, Supply Chain etc.] for preparation of budget/forecast.• Supporting executive management decisions making by scnario planning by considering changes in business environment.• Variance Analysis by analyzing actual results to budgets, forecasts and LY.• Developing financial models/ templates including Chart of Account groupings to extract P&L, balance sheet, Direct/ Indirect cash flows.• Standardising corporate KPI's [GM, EBIT, EBITDA, CM, WORKING CAPITAL] and tracking performance in achieving them.• Establishing budgetary controls on day-to-day operations while raising flags for short/excess.• Business performance analysis at all levels by tracking achievements with Targets and LY growths.• Coordination with Sales/Retail teams for regional/nationwide Analysis of business performance.• Preparation of forecasted fixed assets schedule in accordance with planned CAPEX aligned with Network Expansion strategies.• Preparation & submission of executive MIS reports.• Developing dashboards in Power BI to support management decisions making.• Effectively handling vast amount of retail transactional level data for effecient forcastings using Advanced Applications i. e. Power Tools, VBA and Advanced Excel. Show less

• 

  Sapphire Retail Limited (SRL)

  Apr 2021 - now

  ▪︎ Conduct exploratory data analysis to gain a deep understanding of the retail data, for trends with Fiscal & Lunar Granularities, performance patterns, anomalies & abnormalities to feed data for visualization and KPIs in Power BI.▪︎ Analyze sales data to track performance by Product Category and Channel (Brick & Mortar, Consignment stock, 3rd Party and eCom).▪︎ Evaluate pricing, discounting, product life cycle, sales promotions to identify opportunities to increase sales, margins, sell thru's etc▪︎ Optimize inventory levels and identifying Stock Outs, Zero Sellers, Top Sellers, Sell Thru's, Stock Covers, Turns, GMROIs for timely actionable decisions.▪︎ Identifying Product performance for Launch's Initial push, Replenishment, demand forecasting, Channel Assortments, on-time delivery & display on racks.▪︎ Competitor's market intelligence based on public data points related to Product assortments, design depth, price points etc using Python tools.▪︎ Assess the effectiveness of marketing campaigns with KPIs i.e. Impressions, CTR, Reach frequency, Conversations & ROAS, Last Click attribution Sales & Traffic, Customer insights like Interest Groups targeting for acquisition of new lookalikes and remarketing for retention etc.▪︎ Fulfillment efficiency to analyze logistics data, reduce lead times, and improve overall efficiency for enhanced customer satisfaction with insights on 3PL performance into zones.▪︎ Working capital efficiency and align financial goals with operational data insights into Payables & Receivables ageing, Channel & Category PnL, Marketing Spent controlling.▪︎ Create comprehensive reports & dashboards that communicate key insights to stakeholders.▪︎ Ensure data-driven decisions are accessible and understandable to non-technical teams.▪︎ Stay up-to-date with industry trends, emerging tools, and best practices in data analysis and retail. Show less ■ Developed totally integrated eCommerce Dashboard with Integration of Shopify, Dynamics D365, Courier Tracking APIs in Power BI to report on,▪︎Order Fulfillment Efficiency ▪︎Customer Satisfaction with On-Time delivery ▪︎ Courier Receivable Tracking ▪︎Expected Billing with Courier■ Dashboard to answer Shopify Website performance on,▪︎Traffic landed on landing page/Organic/Referrers with Conversations▪︎Re purchase and Customer Lifeatime Value▪︎Bounce Rate, ▪︎Abandonment Rates on product launches■ Connected D365 cloud with Power BI through Azure SQL VM to generate dashboards for,▪︎Retail & Commerce ▪︎ PIMS ▪︎ GL (for P&L, BS, CFS, Opex dive down CAPEX dive down) ▪︎ Procurement & Sourcing ▪︎B&M stores Plannogram vs actual design availability etc■ Power User for Implementation of Dynamics D365 to provide business knowledge to design solution with Consultant. Suggested design changes based on detailed insights of Dynamics FinOps in General Ledger, AR, AP, Inventory Management, Procurement & Sourcing, Product Information Management, Budgeting, Fixed Assets, Retail & Commerce. ■ Open Source Industry wide Information Intelligence via E-Commerce platforms for product range, price competitiveness, product variety and Depth. In this regard prepared a Power BI dashboard for auto generation of key reports.■ Power BI Descriptive reporting based on Historical datasets to provide performance visibility. ■ Prepared Predictive Reportings to forcast future based on Historical treads with simulations based on events to answer critical questions for business sustainability.■ Sensitivity analysis for evaluating risk of changes in EBITDA, PAT, Product GP%. Show less

  • Deputy General Manager Accounts & Financial Reporting

    Jul 2023 - now

  • Senior Manager Financial Reporting & Analysis

    Aug 2022 - Jun 2023

  • Manager Financial Reporting & Analysis

    Apr 2021 - Aug 2022