Sonali Tripathi
Mascot,Australia
Summary
Organized data analyst and exceptional multitasker with top-notch verbal and written communication skills. Offering over 5+ years of hands-on experience in collecting, analyzing and recording data on business performances, network optimizations forecasting, scheduling and supply chain solutions. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Planning Specialist
Dnata Catering Services
05.2023 - Current
- Forecasting passenger demand and load factors based on historical flight data to support demand planning by procurement team and inflight meal preps by chefs
- Preparing Power BI dashboards (data visualization, report creation, DAX formulas, data analysis, power query, power pivot & power view) to provide business insights to the managers and COO (historical performances and future forecasts)
- Have prepared 8 POWER BI dashboards using complex DAX and M queries to assist with daily data reporting for purchasing, operations and sales team
- Identify and highlight potential impacts from forecasting perspective on business operations
- Supervise forecasting and scheduling assistants with regards to day-to-day operations
- Verifying customers flight schedule through multiple platforms to ensure their validity and then uploading them onto two platforms
- Understand, identify, and manage customer data and order integrity
- Testing and monitoring migration of legacy system into new ERP
- Liaise with offshore IT team to manage smooth system migration from legacy system to JDE
- Coordinate with multiple teams to understand change in demand and manage forecast and scheduling accordingly.
Senior Business Analyst
Team Global Express (Toll Global Express)
04.2022 - 04.2023
- To drive automation of information workflow for domestic and cross border consumer delivery
- To analyze and consolidate complex data from multiple disparate systems and provide solutions to improve growth opportunities, NPS, and assist in supporting ongoing last mile delivery innovation
- To innovate repetitive tasks to reduce re-work, improve NPS and improve results for stakeholders
- To analyze existing last mile delivery network, optimize it using various tools and suggest alternate or additional networks to fulfill customer demands
- Worked on 3 projects across different departments and collaborated on filling gaps to improve operating productivity and efficiency including developing and optimizing operating EDI exchange systems and information
- To drive customer obsessed focus behavior to support Ecommerce operation deliver industry leading omni channel solutions and support implementation as required.
Research Assistant (Ph.D. Degree – Discontinued)
University of Sydney
03.2018 - 01.2020
- Topic of research: Adding value through service innovation in logistics service provider firm
- Abstract: In response to changing customer expectations across different industry sectors, growing trend toward innovation, i.e., creating value through innovative services to traditional product offerings. Adopting innovation strategy could assist firm in increasing revenue and gaining competitive advantage. Research aimed to explore role of contract logistics company in innovative service provisions to its business-to-business partners across different sectors. Data were collected from in-depth semi-structured interviews with multiple stakeholders—secondary sources and observations during field visit to India in January 2020. Case study company and its customers are based in India.
- To present latest research work at research conferences
- Conducting literature review, case study research, and editing publishable research papers
- As teaching assistant, assist students with queries and provide lab support for subjects like procurement management and supply chain and operations management, R, MS SQL, advanced excel, and MS access
- Assist lecturer in preparing classroom notes & presentation
- Provide marking assistance for assessments conducted for subjects
- Provide one-to-one mentoring support to students in need.
Operations Analyst
Panalpina World Transport Pty. Ltd.
01.2019 - 11.2019
- Ensuring and monitoring that reported GP, CGP, and statistical information is accurate
- Ensuring that Operations follow and adhere to Forwarding Order Policy
- Audit loss-making files and follow procedure to eliminate them
- Analyze gaps in existing operations process and discuss methods and procedures to correct shortcomings with operations head
- Maintaining version control document for SOPs in Ocean Freight department
- Prepared 3 excel based reports/dashboard for monthly management meetings and highlighting profits/loss and trends in comparison with current and previous month
- Streamlining internal and external process variances
- Planning targeted gross profit for quarter and monitoring process to ensure targets are met
- Updating job descriptions for existing employees and ensuring employee’s profiles are up to date, with current versions
- Updating SOPs, organization chart, and workflow documents and updating company website with latest versions
- Work with HR/Payroll coordinator with scheduling for training and with training of employees on bi-annual performance review process
- To update overtime dashboard reports and highlight anomalies
- Analyzing and preparing employees turnover report.
Supply Chain Analyst
UPS Logistics Pvt. Ltd.
08.2016 - 01.2018
- Coordinating within team for solutions data request
- Managing team of twenty employees, both mix of IT and SCO domain
- Site Location Analysis & Network Optimization: Determining most optimal number and location of distribution centers to support current and future business and evaluating trade-offs between fixed and variable facility costs and transportation costs to determine optimal Supply Chain
- Inventory Optimization: Developing optimal levels of inventory to maintain at each facility, based on holding cost or service level
- Transportation Optimization: Modelling impact of mode shift, mode selection, and service level requirements on transportation network
- Carbon Emissions Analysis: Involves Baseline Analysis, Emissions by mode, CO2e, set carbon reduction goals, incorporate into annual Sustainability Reporting, and strike proper balance between cost, time-in-transit & emissions
- Use tools like Tableau, Microsoft access, service mapping, ArcGIS to perform analysis.
Sr. Marketing & Sales Executive – Contract Logistics/3PL
Allcargo Logistics
06.2015 - 08.2016
- Implementation and Operations: Preparation of Operations and Billing SOP for warehousing customer’s
- Successful implementation of 4 warehousing customers and assisting post-implementation-operations until process gets stabilized
- Implemented warehousing project for one of leading e-commerce companies in India – project worth 7 million dollars
- Work on project management module to ensure implementation project's timely completion
- Timely follow up with finance team to ensure all vendors get paid on time, to maintain business relationship
- Visiting warehousing sites to confirm that work progress is as per deadline and that implementation would be completed on time, as agreed with client
- Tracking CAPEX and OPEX pre-approved funding to ensure that budget does not exceed allocated amount for project
- Monitoring and analyzing operations performed for minimum of 3 months to ensure targets / KPIs are met
- Prepare monthly MIS and review it with CEO before rolling it out to CMD
- Analyzing daily performance data sent by warehouse managers and reverting with resolutions to issues faced by warehouse managers
- Sales: Review daily sales tracker reports from BDs and revert to their performance graph
- To set up by-weekly con-call to track CL – Sales team's updates and ensure that team was working towards achieving annual targeted business goal
- To help sales team fill up RFQs and assist them with scoping documents for prospective clients
- To coordinate with CRM team to align sales performance onto automated system and avoid manual interference
- Organizing annual performance review meeting with MD for Contract Logistics department
- Projects & Initiatives Rolled out: Involved in implementation of ISO and WMS at 3 of warehousing locations
- Analyze cost-saving initiatives suggested by respective warehouse managers to try and cut down costs to increase profitability
- Successful implementation of biometric attendance recording system at all warehousing locations and thus automating attendance registration process
- Mergers & Acquisitions: Allcargo contract logistics vertical went through merger with two organizations and worked closely with CEO and MD to complete same
- Involved in legal, IT, HR, and overall merger activities.
Casual Research Assistant
The University of Sydney
12.2013 - 09.2014
- Analyzing data from social media platforms like Twitter and Facebook quantitatively and qualitatively: Mapping them into graphs, tables, or trending
- Literature review for journals and papers with regards to research topic
- Published Articles: Bhattacharjya, J., Tripathi, S., Gezdur, A., Sutton-Brady, C., Bell, M (2022)Logistics and Supply Chain Around the World In C Mulley, M Attard (Eds.), Transport and Pandemic Experiences, (pp 149-162) Bingley, United Kingdom: Emerald Group Publishing Limited
- Bhattacharjya, J., Ellison, A., Tripathi, S (2016) An exploration of logistics-related customer service provision on Twitter: The case of e-retailers International Journal of Physical Distribution and Logistics Management, 46(6/7), 659-680
- Bhattacharjya, J., Tripathi, S., Taylor, A., Taylor, M., Walters, D (2014) Additive Manufacturing: Current Status and Future Prospects In Luis M Camarinha-Matos, Hamideh Afsarmanesh (Eds.), Collaborative Systems for Smart Networked Environments: 15th IFIP WG 5.5 Working Conference on Virtual Enterprises, PRO-VE 2014, Amsterdam, Netherlands, October 6 - October 8, 2014 Proceedings, (pp 365-372) Heidelberg, Germany: Springer
- Bhattacharjya, J., Tripathi, S., Ellison, A., Kitratporn, N (2014) Value creation Using social media in a Virtual Business Model: How Amazon Approaches Customer Service on Twitter In Khalid S Soliman (Eds.), Crafting Global Competitive Economies: 2020 Vision Strategic Planning & Smart Implementation, (pp 2208-2215)Milan, Italy: International Business Information Management Association (IBIMA).
Sr. Admin Assistant
United Parcel Service, UPS
10.2011 - 01.2013
- Control daily receipt of shipment notices, review contract for each shipment to ensure accuracy and presence of all charges, and then ensure timely release of shipments with all charges
- Audit final invoices to ensure all charges are accurate
- Investigate billing errors and request process corrections
- Attending conference calls with onshore managers to improve/resolve invoicing procedure for Apple Computer’s
- Training inexperienced staff during training period and to existing staff during monthly update team meeting schedule (around twenty-five people)
- Did transition for two major clients for Trade Direct department, UPS Pune
- Received appreciation from onshore Finance Manager for contribution given in improving invoicing procedure for one of UPS’s biggest/crucial clients
- Elected as the Chairperson of the Employee Engagement Committee by a team of fourteen members constituting members from 7 departments within UPS, including the operations & human resource manager.
Education
Master’s in Logistics Management -
University of Sydney
Sydney, NSW06.2014
Postgraduate Diploma in Business Administration, Operations -
Symbiosis Centre For Distance Learning
Pune, India05.2010
Bachelor’s in food science & Quality Control -
Maharaja Sayajirao University
Pune, India05.2006
Skills
- MS office tools – Advanced level (excel, word, presentation, access, project, VBA)
- Power BI – Data visualization, Report creation, DAX formulas, Data analysis, Power query, Power pivot, Power view & Power BI gateway refresh
- MS SQL & R– data fetching and data manipulation
- Demand forecasting
- Scheduling proficiency
- Effective Communication
- Problem-solving aptitude
- Analytical Skills
- Team Collaboration
- Team Leadership
- Strategic Planning
- Coaching and Mentoring
- Performance Management
- Cross-Functional Teamwork
Certification
- 2015, IATA Air Cargo - Introductory, IATA, Canada
- 2013, Fundamentals of the Maritime Industry, Shipping Australia, Australia
- 2013, GS1 Standards, GS 1 Group, Australia
Linkedinlink
https://www.linkedin.com/in/sonali3085/
Personal Information
- Age: 38
- Gender: Female
- Nationality: Indian
- Marital Status: Married
- Visa Status: 482 – dependent (valid until Mar 2026)
Timeline
Planning Specialist
Dnata Catering Services
05.2023 - Current
Senior Business Analyst
Team Global Express (Toll Global Express)
04.2022 - 04.2023
Operations Analyst
Panalpina World Transport Pty. Ltd.
01.2019 - 11.2019
Research Assistant (Ph.D. Degree – Discontinued)
University of Sydney
03.2018 - 01.2020
Supply Chain Analyst
UPS Logistics Pvt. Ltd.
08.2016 - 01.2018
Sr. Marketing & Sales Executive – Contract Logistics/3PL
Allcargo Logistics
06.2015 - 08.2016
Casual Research Assistant
The University of Sydney
12.2013 - 09.2014
Sr. Admin Assistant
United Parcel Service, UPS
10.2011 - 01.2013
Master’s in Logistics Management -
University of Sydney
Postgraduate Diploma in Business Administration, Operations -
Symbiosis Centre For Distance Learning
Bachelor’s in food science & Quality Control -
Maharaja Sayajirao University
Similar Profiles
Lance DomingoLance Domingo
Catering Assistant at DNATA Catering ServicesCatering Assistant at DNATA Catering Services
LISA CHATURVEDILISA CHATURVEDI
Catering Attendant at Dnata Catering ServicesCatering Attendant at Dnata Catering Services
Michael Dwight TanMichael Dwight Tan
Food Production Worker / Kitchen Hand at Qantas Airways / Dnata Catering ServicesFood Production Worker / Kitchen Hand at Qantas Airways / Dnata Catering Services