Vijay Somani
Hampton Park,Australia
Summary
Experienced Business and Data Analyst with a proven track record in streamlining business processes and system performance across diverse industries. Strong capabilities in Power BI, SQL, and ERP systems, with expertise in designing automated reports, dynamic dashboards, and conducting in-depth data analysis to drive key business decisions. Demonstrated success in process optimization, achieving a targeted reduction in operational inefficiencies and increasing revenue through cross-functional collaboration. Good communicator, able to effectively interpret business problems and transform these into technical tasks, model user requirements and provide assistance during system change processes aimed to meet business objectives.
Overview
7
7
years of professional experience
Work History
Data and Business Analyst
Ironman 4X4 Pty Ltd
Melbourne, Australia
06.2023 - Current
- Led ERP transformation for subsidiaries in Australia, Thailand, and the US, ensuring seamless integration and minimal disruption
- Designed automated Power BI reports and dynamic dashboards to visualize performance, reducing report generation time by 30% and enabling real-time KPI tracking
- Provided expert support for ERP and data-related issues, troubleshooting and maintaining system stability
- Collaborated with cross-functional teams to implement system enhancements, driving a 20% reduction in operational inefficiencies
- Conducted UAT, BFUT, and E2E testing, managing defect tracking to ensure timely issue resolution
- Analysed business data to deliver actionable insights on sales, promotions, and financial performance, driving revenue growth
- Streamlined ETL/ELT processes, improving data quality and reducing processing time
- Created Power BI reports for the Supply Chain team to assist in supply and demand planning processes, enabling better inventory management and forecasting
- Managed defect tracking and resolution processes, ensuring timely fixes and reducing interruptions to business operations
Business Process and System Improvement Analyst
Schott Minifab
Melbourne, Australia
02.2022 - 06.2023
- Analyzed workflows and systems to identify inefficiencies and improvement opportunities through data collection and stakeholder collaboration
- Created process flowcharts and diagrams to visualize current and future workflows, highlighting gaps and opportunities for optimization
- Collaborated with teams to design and implement process and system enhancements, including defining specifications and creating action plans
- Developed communication and training materials, providing end-user support to ensure smooth transitions during system updates
- Tracked performance metrics to evaluate improvements and reported results to stakeholders
- Stayed updated on industry trends, applying best practices to drive continuous improvement
- Configured system settings, including user roles, workflows, and custom fields, to align with business processes
- Worked with stakeholders to implement custom ERP enhancements, including custom workflows and reports
- Automated processes to streamline operations and boost efficiency across the organization
Clinical Trial Logistic Associate
PCI Pharma Services
Melbourne, Australia
03.2021 - 02.2022
- Act as a central reference and information source, providing guidance and assistance in the system project decision making process
- Managed dispatches to clinical trial sites, ensuring compliance with packaging and labelling requirements
- Assisted in the preparation and maintenance of the Poisons Plan in line with regulations
- Conducted stock checks and assisted in quality assurance processes for incoming drugs
- Identified business process inefficiencies, recommending solutions for improvement
- Participated in warehouse audits and liaised with sites to maintain strong relationships and ensure compliance
Business Analyst and Dispatch Manager
Melbourne Office Supplies
Melbourne, Australia
05.2018 - 12.2020
- Analyzed sales, KPIs, invoices, and delivery schedules to optimize business performance
- Designed dashboards and workflows to analyze sales forecasts and monitored performance
- Conducted process mapping and identified inefficiencies, proposing solutions for improvement
- Collaborated with technical teams to deploy solutions and manage change processes
- Provided training, documented business requirements, and assisted in system implementations
Education
Master of Business Analytics -
Deakin University
Melbourne, Australia11.2019
Skills
- Data Analysis
- Reporting
- Power BI
- SQL
- ERP systems
- Process Optimization
- Stakeholder Engagement
- Business process improvement
- Systems analysis
- System Integration
- Business Requirements
- Documentation
- ETL/ELT Processes
- Defect Management
- Project management
Timeline
Data and Business Analyst
Ironman 4X4 Pty Ltd
06.2023 - Current
Business Process and System Improvement Analyst
Schott Minifab
02.2022 - 06.2023
Clinical Trial Logistic Associate
PCI Pharma Services
03.2021 - 02.2022
Business Analyst and Dispatch Manager
Melbourne Office Supplies
05.2018 - 12.2020
Master of Business Analytics -
Deakin University
Similar Profiles
Erin Nicole SeliniotakisErin Nicole Seliniotakis
Logistics Coordinator at Ironman 4x4Logistics Coordinator at Ironman 4x4
Jane CockingJane Cocking
Office Administrator at North Harbor 4x4 Ltd TA Motortech 4x4 AucklandOffice Administrator at North Harbor 4x4 Ltd TA Motortech 4x4 Auckland
Michael Price JrMichael Price Jr
Setup Technician at Ironman Sound IndustriesSetup Technician at Ironman Sound Industries