Summary
Overview
Work History
Education
Skills
Degrees And Certifications
Personal Information
References
Timeline
Generic

Hassan Mudassar

Quakers Hill,NSW

Summary

13 Years’ experience in Business and Data Analytics, Strategy, ERP systems implementation, forecasting, trend analysis and planning. Have been working across multiple retail chains and B2B systems in Australia and gained hands on professional experience in Business analytics, Data Analytics, Demand and Supply planning along with business KPI management. Worked as Merchandise and demand planner and successfully shifted my career into Business and Data Analyst to become producer instead of consumer of Business Intelligence tools. Obtained Masters in Data Science recently to support my further development in Data Analytics and Business Analytics on top of my deep experience in Business operations from Strategy perspective. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

Work History

Planning Specialist

ResMed – Medical Device Company
01.2024 - Current
  • I am working as Demand and Supply specialist looking after supply of multiple items from metals, bearings and packaging materials
  • Using cloud-based supply planning system of O9
  • Identification of the constraint materials and managing the forecast to highlight the issue to keep the product enough to manage the global demand
  • Coordinating with suppliers on the forecast and managing expectation on the supply back up and explain the demand spikes.
  • Determined production requirements based on facility's capacity and production specifications.
  • Created and maintained master schedule based on customer orders, availability of raw materials, machine capacity, and constraints.
  • Scheduled employee shifts according to production needs.
  • Championed change initiatives within the organization, driving continuous improvement efforts across all planning functions.
  • Facilitated coordination between sales, marketing, finance, operations teams for seamless execution of strategic plans.
  • Managed stakeholder communication, fostering strong relationships between internal departments and external partners.
  • Evaluated supplier performance to ensure consistent quality standards and adherence to contractual agreements.
  • Forecasted production schedules and adjusted plans to accommodate changes in demand.

Data Analyst

Goodman Fielder
  • I spearheaded the Power BI reporting and Data Connectivity including requirement gathering for the reporting required for monitoring
  • Business has both bakery and grocery stream with different information streams required
  • Role includes gathering of Data through SQLData Base hosted on Azure Platform along with Data Exports through internal and external sources
  • Data extraction, cleansing and maintenance through SQL
  • Gathered Data through SQL Database hosted on Azure Platform along with Data Exports through internal and external sources
  • Creating the reports and Dashboards including Power BI and Excel reports to be consumed across the wider business
  • I.e
  • Stock Projection Report
  • This report provides topline summary looking at sales forecast for each customer incorporating planned intake for next 8 weeks, a vital topline summary
  • Collaborating with teams across the board (all departments) for enhancement and maintenance of Dashboards Developed and maintained interactive dashboards in Power BI, providing real-time visibility into key performance indicators (KPIs) such as sales revenue, product profitability, and market share
  • Streamlined data entry processes for sales orders, reducing manual errors and improving overall data entry efficiency Management of Data Access and control within Power BI
  • Managed Data Access and control within Power BI, ensuring compliance with data security policies and maintaining access for 100+ users.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Participated in requirements meetings to understand business needs.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing the adaptability of solutions provided.
  • Streamlined data processing for faster results by implementing advanced analytics tools.
  • Optimized company resources allocation with detailed forecasting models based on historical data analysis.
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Established a culture of continuous improvement by fostering open communication channels and encouraging feedback on data analysis methodologies.
  • Designed custom tracking systems to monitor KPIs, ensuring alignment with organizational goals and objectives.
  • Created dashboards to monitor and track key performance indicators.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Assisted with creating data cubes and OLAP models to improve data analysis.
  • Implemented business intelligence solutions to increase operational efficiency.

Merchandise Planner / Data Analyst

FREEDOM FURNITURE AU&NZ
  • I worked with Freedom furnitureas merchandise planner forall Hardgoods (Dining, Living, Bedroom furniture) and Mattresses
  • Being part of the exciting journey of turnaround plan for 2 years for FREEDOM business and as part of the team was able to achieve some exciting growth in business
  • As I was part of the Planning team, was tasked to team up with IT to produce the Power BI Realtime reporting
  • I starting working on Power BI deployment in company including data connectivity and Dashboardcreation as I was aware of the requirements for the business to monitor KPIs
  • Developed skills for requirement gathering sitting both sides of the table
  • Freedom Furniture was going through transition from legacy order processing system to Oracle OMS
  • Then at later stage got teamed up with IT for Power BI reporting
  • Did run data extraction through SQL for setting up dash boards in Power BI
  • Conduct weekly sales performance reviews and meet with buyers to generate action plans to respond to performance that deviates from the business targets (budget or agreed replan)
  • Analysis of product range performance against budget and prior year to identify trends (includes price point analysis, GM contribution, stock turns, GMROI, GM% analysis)
  • Collated formal range review document, analyse with buying team and ensure adherence
  • Execution of demand forecasting and the generation of rolling sales plans at both SKU and aggregate levels
  • Planning and execution of promotionalactivities around marketing calendar activities and initiatives with forward sales plans
  • Prepare and manage sales budgets, stock levels, OTB and gross profit in line with target KPI's down to class level
  • Manage markdowns with the view to achieving objectives in terms of sales, stock levels, and gross profit
  • Scenario modelling to identify risks and opportunities within the plans of the business
  • Review availability of all products scheduled for inclusion in promotional events both outside and inside lead times
  • Ensure that all promotional activity is included in forward demand plans and that markdowns are considered in calculating projected sales and margins and variance to targets
  • Review performance throughout promotions and propose tactical actions to bring performance into alignment with expectations (add/remove product, increase/decrease discount, feature/remove product in media)
  • Run and review statistical forecasting and adjust where necessary to correct for out of stocks in historical data or for known changes in forward strategy
  • Create unit level (SKU) forecasts based on current trends and commercial insights for product groups where demand can be modelled (e.g., stocked items)
  • Ensure that promotional activity and subsequent unit uplifts are included in forward plans
  • Identify and implement improvements to demand forecasting systems, processes and tools.
  • Created sales projections and adjusted purchase plans to maximize inventory with volume responsibility of [Number] units.
  • Streamlined processes for increased efficiency in merchandise allocation and replenishment.
  • Utilized advanced analytics tools for more accurate demand forecasting and inventory optimization.
  • Analyzed historical data to identify opportunities for growth and margin improvement.
  • Followed up with retail stores with reminders to replenish stock, helping achieve peak inventory levels.
  • Prepared and analyzed reports to track inventory and purchasing trends.
  • Negotiated contracts with vendors for cost-effective purchasing terms.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Deployed predictive analytics models to forecast future trends.
  • Generated standard and custom reports to provide insights into business performance.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Evaluated the effectiveness of marketing campaigns using A/B testing methodologies, optimizing strategies for higher ROI.
  • Resolved complex business challenges by leveraging statistical modeling techniques and machine learning algorithms.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.

Supply Planning Analyst

David Jones
  • Worked within central planning department as demand planner to manageSystem Replenishment for ASR stock for Categories ofBeauty, Womenswear, Shoes & Accessories and Food
  • Part of the transition from legacy Oracle based ERP to Oracle RMS and RMS based system replenishment settings and responsible for replenishment settings review based on seasonal average weekly sales to ensure stock availability of the key lines
  • Manage brand and vendor analysis and strategies including streamlining reporting and performance criteria
  • Monitor and communicate vendor delivery performance like OTIF (On Time InFull) and take necessary corrective actions
  • Upload all approved budget and forecasts into the company’s system
  • Manage intake to an agreed budget and ensure Basic Stock in stock target is achieved
  • Providing a monthly basic OTB forecast.
  • Managed multiple priorities effectively, consistently achieving deadlines while maintaining a high level of attention to detail in all deliverables produced.
  • Supported the development of annual budgets by providing detailed financial analysis and projections.

Allocation Analyst

BENDON Group Sydney
  • Moved to Australia and after working on multiple blue-collar jobs for 8 months started worked as Allocation Analyst at Bendon group having 45+ retail and outlet network with wholesale and e-commerce business in Australia, New Zealand, USA and England.

Merchandise Planner

ServisSales Corporation - Largest Shoe retailer in Pakistan
  • Managed procurement and sales planning strategy for category business worth more A$300m which was out of a total of A$800m sales for 395 stores
  • As part of the retail men’s shoe team, we had a sales growth of 19%+and in the last 2 years had 3.2% improvement in gross margins
  • Inventory aging was improved to 78% on average across all season launches at SKU level from 56% and 60% on average from 43%
  • Developed forecast measurement mechanism and achieved up to 76% accuracy in sales forecasts across different seasonal launches
  • Managed and improved inventory turns to 3.23% on average across the whole shoe category from 3.05%
  • Involved in business strategy, policy, product, customer service with procedural development and compliance across merchandising, operations and supply chain
  • Development of forecasting and analysis of consumer buying behaviour and more importantly relating all these qualitative measures with futures quantitative numbers
  • Managed distribution with subordinates for stock demand and replenishment across stores i.e
  • Clusters, (store groups).

Education

Master of Science - Data Science

Simplilearn
Online
12.2023

Master of Science - Microsoft Azure Data Fundamentals

SimpliLearn
Online
12.2023

Skills

  • Expert Level SQL Skills – Restoring and updating Databases Writing complex SQL scripts to retrieve data
  • Power BI Services including Power BI Data sources connectivity and reporting – Including DAX
  • Trend Analysis with Power BI visuals
  • Developing relational data models – ETL Processes to ensure consistency
  • Use of Power BI Advance editor and M-Scripts
  • Realtime data Streaming
  • Expert Level Excel including management of complex data streams, Pivots and Slices
  • Python – Master course for Data Science and ML using Jupiter libraries
  • Process stream line including business and information flow
  • Business and Data Analysis – Agile Methodologies
  • Hands on using ERPs and forecasting tools like SAP, SAP-IBP, SAP Business Objects, Master Query, Oracle modules RMS, OMS, AP, MFP, Net Stock, Toolbox, VRP, DSX and TM1
  • Experience using Jira for documentation and workflow management
  • Ability to solve problems and stream line processes
  • Customer focus and strong team player
  • Stakeholder engagement and learning aptitude
  • Data Visualization and Presentations
  • Data Analysis
  • Excel Functions
  • SQL
  • Data Cleaning
  • Analytical Problem Solving
  • Tableau
  • Forecasting and planning

Degrees And Certifications

  • Masters in Data Science, Simplilearn, 2023
  • Power BI - Data connectivity and dashboard creations including DAX
  • Tableau - One sample dashboard, Tableau Public
  • Python and Machine Learning with hands on multiple projects using Jupiter libraries, 2023
  • Microsoft Azure Data Fundamentals, 2023
  • Business Analytics, Simplilearn, 2022
  • Certified Retail Buyer/Merchandise Planner, Australian Online Courses, 2018
  • Project Management Certification (PMC), University of Engineering & Technology Lahore, 2011
  • Certified Professional Marketer (CPM), Asia Pacific Marketing Federation, Singapore, 2009
  • MBA - Marketing and Finance, National University of Computer and Emerging Sciences, 2008
  • Bachelors of Computer Sciences (BS-Hons), University of the Punjab, 2005

Personal Information

Citizenship: Australian Citizen

References

Supplied upon request

Timeline

Planning Specialist

ResMed – Medical Device Company
01.2024 - Current

Data Analyst

Goodman Fielder

Merchandise Planner / Data Analyst

FREEDOM FURNITURE AU&NZ

Supply Planning Analyst

David Jones

Allocation Analyst

BENDON Group Sydney

Merchandise Planner

ServisSales Corporation - Largest Shoe retailer in Pakistan

Master of Science - Data Science

Simplilearn

Master of Science - Microsoft Azure Data Fundamentals

SimpliLearn

Similar Profiles

  • Alexa Jones

    Alexa JonesAlexa Jones

    Senior Supply Chain Analyst at Nashville Based Medical Device CompanySenior Supply Chain Analyst at Nashville Based Medical Device Company

    View Profile
  • Stefano Magarotto

    Stefano MagarottoStefano Magarotto

    IT Director at Health & Beauty and Medical Device CompanyIT Director at Health & Beauty and Medical Device Company

    View Profile
  • Ricky Sulistiadi

    Ricky SulistiadiRicky Sulistiadi

    HRD MANAGER at Medical Device CompanyHRD MANAGER at Medical Device Company

    View Profile
Hassan Mudassar