Dip Panchal
Auckland,Mt Roskill
Summary
Strategic and analytical professional with more than 10 years of success in Financial, HR & Business analysis and reporting. Talented in retrieving data from BI and SAP interface.
Intermediate to advance experience in automating reports through effective design and scripting in MS Access, Excel, and VBA. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel, MS Office, BI and SAP functionality to measure performance and implement improvements.
Seeking a full-time position that offers professional challenges utilizing interpersonal skills, excellent time management, problem-solving skills.
Overview
13
13
years of professional experience
Work History
SAP & Price Integrity Manager
New World Mt Roskill
, Auckland
09.2017 - 07.2022
- Gathering and analyzing store performance data with help of Power BI Reporting
- Utilized MS Excel, BI & SAP and other dashboard/visualization tool sets for data analysis and intelligence for team meeting i.e., Park Invoice, block stock report, negative stock, daily top and bottom selling product
- Ensure current and new processes are bedded and become part of daily operations in store.
- Prepared reports that interpret article sales trend for opportunities for more revenue generation
- Focus on process improvement and analysis to drive accurate financial reporting. E.g., Fresh Department inconsistent invoicing process where, advise to create PO at same week as they receive delivery which not only help department to have consistent GP but also able to monitor stock level
- Converted data into actionable insights by predicting and modelling future outcomes
- Weekly report to Owner / Operator on KPI i.e., store performance report, scraping, consumption, slow moving and DC return rejected
- Consult with department managers around pricing and invoicing issue ensuring price integrity across all departments
Team Manager
Vodafone India Services Private Ltd
Gujarat, India
11.2013 - 07.2015
- Evaluated employee performance on monthly basis and coached and trained 16 team members, increasing quality of work and employee motivation.
- Installed reliable performance tracking system and monitor quality of agents
- Mentored team members to upskill and foster their best
- Organized training workshops to improve performance of members who were lagging performance
- Drove performance of staff by creating incentives and positive work atmosphere and administering recognition and rewards programs
- Worked with Human Resources to investigate and provide documentation for employee concerns, claims, disciplinary action, performance reviews, and discharge disputes
Reporting Analyst
ANZ
Melboure, Australia
05.2009 - 10.2012
- Develop, support, and customize database to store and report Global HR Metrics for business Heads
- Implement techniques for efficient data management
- Assisting HR Business partner with automate & analytical reporting and data modelling for different division
- Review and update Global organization structure monthly
- Customize and compile ad hoc reports and dashboards for business stakeholders
- Provide HR community with monthly People Report
- Engage with businesses to report and highlight issues, for effective people management
- Automate monthly report with help of VBA to minimize manual involvement. E.g., Create Excel VBA code that will upload raw data in MS Access database and create visualise table in Excel to saves time from 5 days to 2 days.
- Managed guidelines for calculations for metrics and analysis
- Enhanced data integrity by applying meticulous diligence when reviewing and analyzing data maintenance processes
Junior MIS Executive
Vodafone
, India
05.2006 - 12.2008
- Generating reports using database systems and performing analysis
- Preparation and delivery presentations for management board in retention department
- Discuss information & business intelligence needs with staff and clients to implement IT functionality changes to existing reporting software
- Consulting with cross-functional departments in various locations for data analysis and quality assurance
- Developed and led large-scale technology initiatives for long-term strategic plans and solutions
- Perform routine analysis and calculations on data for recurring internal reports
- Prepare documentation for various reporting and data processes
- Participate in system testing for reporting modules
Education
Post Graduate Certificate - Data Science With AI & ML
DataCamp
Perusing RemotelyAdvance Diploma - Multimedia
Northern Melbourne Institute of Tafe
Australia11.2009
Bachelor - Commerce (Specialized in Statistics & Accounting)
Gujarat University
India04.2005
Skills
- Dependable and Responsible
- Flexible and Adaptable
- Self-Motivated
- Database Management
- Data Analysis
- Data Mapping
- Performance metrics evaluation
- Business Development
- Operation Analyst
- Continuous Improvement
- Reporting efficiency & accuracy
- Price management & auditing
- SAP Experience
- BI Reports
- MS Excel
- MS VBA Macros
Websites
Accomplishments
- Successful implementation of VBA tool to automate data collection, calculation, and reporting on sourcing data, reducing the effort from 20 to 8 hours per week.
- Automate monthly Global HR dashboard to minimize manual involvement. Effective saving of over 5 days in a month.
- Achieved Process & Data improvement by introducing One Pager Report for weekly manager meeting about Key Sales Performance, Top Products analysis with high margin, Weekly Invoice processing rate, Stock Adjustment & Gross Profit by department.
Additional Information
Aaron Scanes (Owner Operator – Glen Innes)
+64 212932365
aaron.scanes@foodstuffs.co.nz
Timeline
SAP & Price Integrity Manager
New World Mt Roskill
09.2017 - 07.2022
Team Manager
Vodafone India Services Private Ltd
11.2013 - 07.2015
Reporting Analyst
ANZ
05.2009 - 10.2012
Junior MIS Executive
Vodafone
05.2006 - 12.2008
Post Graduate Certificate - Data Science With AI & ML
DataCamp
Advance Diploma - Multimedia
Northern Melbourne Institute of Tafe
Bachelor - Commerce (Specialized in Statistics & Accounting)
Gujarat University
Similar Profiles
S H A R N I D R E A D O N - B E L LS H A R N I D R E A D O N - B E L L
OPERATIONS TEAM MEMBER at BUNNINGS WAREHOUSE - MT ROSKILLOPERATIONS TEAM MEMBER at BUNNINGS WAREHOUSE - MT ROSKILL
Jun Hui (tony) OngJun Hui (tony) Ong
Cashier and Filling Stocks at Mt Roskill Fresh SupermarketCashier and Filling Stocks at Mt Roskill Fresh Supermarket
Jovahn StanleyJovahn Stanley
Checkout Assistant at Gilmours Mt RoskillCheckout Assistant at Gilmours Mt Roskill
Gagan Deep KaurGagan Deep Kaur
Restaurant Team Member at Black PantherRestaurant Team Member at Black Panther
Anupriya SinghAnupriya Singh
Commercial Analyst at Foodstuffs North Island LimitedCommercial Analyst at Foodstuffs North Island Limited