Samia Shakeel

Being a part of Supply Chain operational excellence team, continuously looking for opportunities to optimize processes and ensure transportation of products effectively and sustainably. The day to day work included but was not limited to

• Collaborate with business stakeholders to understand reporting requirements with focus on providing insights with storytelling
• Design, develop and maintain dashboards for effective business performance & KPI reporting
• Translate business requirements to wireframes, building data flow and report structures, guiding the stakeholders with optimal data sources.
• Clean, transform, and validate data to ensure reliability and usability. This includes identifying gaps and suggesting alternative data sources working collaboratively with technical teams.
• Analyze data trends to help identify future optimization opportunities
• Simplify work through smart workflows for data collection and analysis

Achievements:

• Provided end to end reporting for Last Mile deliveries from SAP - TMS which included, data cleansing, defining KPIs, preparing visuals and embed operational logic.
• Working collaboratively with transport operations team, designed and developed a report analyzing performance of logistics for finished goods inter branch transfer process, highlighting weekly performance on truck utilization, and looking at data in SAP – TMS/ Tableau and overlaying information from SAP ECC to highlight the exact area of opportunity.

• Create SSIS packages to ETL large data sets from diverse sources to a centralized Data Warehouse
• Design & Develop engaging Reports and dashboards to deliver meaningful information
• Analyse large data sets provided in MS Excel and perform data cleansing following the Quality Framework.
• Perform Data Modelling, define Transformations and analyse data reporting requirements
• Prepare SQL queries & stored procedures for developing reports in SSRS .

Achievement : Executed end to end BI Projects including data analysis, ETL, data modelling & visualization.

Projects

Design & Create Financial Dashboard

Client - Mackay Group

• Collaborate with the CFO to understand data reporting requirements & generate quarterly dashboards
• Perform Data Cleansing & Analyse data to Identify trends and report insights

Achievement – Produced a great Financial Dashboard for Board Reports ahead of a tight deadline

Transform Raw data to Reports & Dashboards

Client - Polar Sports

• Understand business requirements, Analyse Raw data, define metric & KPI's for Customer Behaviour.
• Prepare insightful Sales reports e.g. Top 10 Customers, Sales by Product, New & Lapsed Customers etc.

Interflow Pty Limited is the leading provider in Australia and New Zealand for repair, restoration and renewal services of deteriorated underground pipeline services. My role involved following tasks,

• Analyse data using Advanced Excel (Power Query, VLOOKUP, charts) and create effective reports
• Raise purchase orders using CRM & generate supplier reports
• Build Price Comparison report as required by the Procurement manager

Achievement : Saved money for the company by highlighting the supplier with lowest cost

Projects

• Eve Arabia– Fashion website
• Logta – Ecommerce Website

Danat handles IT developments and provides consultancy in various areas. My role involved:

• Conduct brainstorm meetings with business teams to gather requirements
• Prepared Presentations in Power Point for Business Users
• Translate Business requirements to technical specification.
• Involved in the project from initiation to closing, all phases of SDLC & prepared Documentation & User Manuals

Arwen Tech is an Enterprise Solutions Company & also Cisco Systems Gold Partner. My role involved:

• Establish project plan with engineering team, clients and project manager using Microsoft Project.
• Nurture strong and productive working relationships with key stakeholders ensuring effective collaboration
• Coordinate daily activities to ensure timely completion of project.

Projects:

1. Sales Dashboard using SAP - Business Objects

2. Imports Operations Tracking & Analysis System using C#

Working cross-functionally with departments within the organisation, I use to participate in design, implementation and testing for reporting & BI Systems.

• Prepare SQL Queries & Stored Procedures for business reporting.
• Business Objects administration, analyze business requirements and prepare reports & dashboard utilizing SAP - Business Objects.

Achievement : Provided an interactive dashboard to highlight insights for dropping sales of the Ice Cream brand.