SHUBHAM KOLI
Brisbane,QLD
Summary
Dynamic analyst with a proven track record at Uniting Care, enhancing business intelligence and process improvement through advanced analytics and developing business models BPMN. Skilled in POWER BI, and Agile methodologies, I've driven revenue growth and operational efficiency, achieving a 95% error reduction in manual processes. Expert in transforming complex data into actionable insights, demonstrating exceptional problem-solving and project management capabilities.
Overview
7
7
years of professional experience
Work History
Revenue and Reporting Analyst
Uniting Care
Brisbane, QLD
03.2024 - Current
- Developed and implemented automated solutions to streamline report generation, ensuring timely delivery and high accuracy of insights to increase revenue across the business admissions.
- Collaborated with stakeholders and SLT across departments to ensure all requirements are met prior to the delivery of reports.
- Monitored daily operations activities through various reporting tools, such as Power BI and CRM.
- Developing process models using industry-standard tools, such as Visio or BPMN, for generating contracts and agreements through Nintex.
Business Performance Analyst
Uniting Care
Brisbane, QLD
08.2023 - 03.2024
- Implemented a rationalized reporting process and KPI metrics by collaborating with the stakeholders to align the business requirements, and analyze the data trends to improve the accuracy of the insights.
- Developed and maintained the dashboards in Power BI, Tableau, and Excel to visualize the KPI metrics on a day-to-day basis.
- Providing real-time insight on data visualization, business operations on a daily, weekly, monthly, and FY basis to the senior leadership team.
- Organized training sessions to understand data analysis techniques and tools like Tableau, Power BI, and data trends for the business stakeholders.
- Provided insights on data trends and the daily KPI metrics in order to identify the root cause of the issue, and suggested a strategy to derive actionable insights from the complex datasets.
- Empowering them to understand the data in a storytelling way to make decisions at the organizational level.
- Collaborating closely with stakeholders, and implementing advanced BPMN techniques.
- Efficiently solved complex problems, optimized processes, and delivered improvements in operational efficiency and business outcomes.
Business and Reporting Analyst
Uniting Care
Brisbane, AU
03.2022 - 08.2023
- Leveraged advanced analytics tools, including Tableau, Power BI, and Excel, to perform in-depth data analysis and effectively resolve complex business challenges and streamline daily operations.
- Prepared comprehensive daily, weekly, and monthly reports for the General Manager, provided strategic business insights, and developed data-driven business models to support decision-making and organizational objectives.
- Incorporate with the stakeholders and IT team to automate the manual process, such as manual data refreshing from the server, and manual data entry.
- Automating the process leads to time savings and a 50% error reduction, adding valuable time to focus on the data strategy at the organizational level.
- Analyzed data trends using BI tools like Power BI, Tableau, and Excel, and identified the productivity issues while implementing process improvements to optimize the efficiency of the KPIs.
- Proficient in Agile methodologies and tools, and efficiently managing multiple stakeholders and priorities to meet deadlines and expectations effectively and accurately.
- Created weekly and monthly reports to track the performance of business KPI metrics.
National Workforce Planner
Wilson Security
Melbourne, Australia
12.2021 - 03.2022
- Escalating the operational issues and incidents, and generating the reports.
- To analyze the data for the clients all over AU, and solve the operational queries for the Wilson National client.
- Capturing trends in workflow, and meeting rostering/recruitment requirements.
- Analyze the roster and manage the coordination of static guarding services for Wilson's National client base.
Customer Solution Specialist
Probe group
Melbourne, AU
08.2021 - 12.2021
- Acknowledge and resolve customer complaints, and the ability to determine customer needs and provide appropriate solutions.
- Communicate efficiently with customers on the phone and via email, and update the CRM and database.
- Administration and office duties.
- Booking appointments through biokinetics and Google Calendar.
Data Analyst
Yarra Valley Water
Melbourne, Australia
07.2021 - 11.2021
- To investigate the utility of the scenario tool, build a functioning baseline model in the WSC Urban Heat Island Module for the Northern growth area of Melbourne
- To build the scenario ratio-planning using the PSP structure to reduce the land surface temperature by 4 degrees Celsius by 2050 and analyse the data based on the scenario tool
Data Analyst
Verifier
Melbourne, AU
09.2020 - 03.2021
- Using confluence and JIRA as part of daily activities and ETL the data for the analysis of the project
- Implementing the matching algorithm for the project to reduce the credit card frauds in Australia
- Develop, integrate, and deploy the R/python code from the AWS cloud source
Reliability Analyst Intern
Cummins Global Analytics Centre
Pune, India
02.2018 - 06.2018
- Implementing FMEA (Failure mode effect analysis) and Reliability analysis
- Managing and providing the information regarding the best engine as per the requirements
- Dealing with the clients regarding the reliability of the product and providing relevant analysis to the clients in the US and Europe
Education
Master of Analytics - Business Analytics
RMIT University
Australia11.2021
Business Analytics and Data Mining- Certification -
Indian Statistical Institute
Mumbai, India05.2019
Bachelor of Technology - Instrumentation Engineering
Savitribai Phule Pune University
India05.2018
Honours in Reliability of Electronic product and Testing -
Savitribai Phule Pune University
India05.2018
Student Exchange Program - Industrial Engineering and Business Management
HoF University of Applied Sciences
Germany08.2017
Skills
- TABLEAU
- POWER BI
- R
- PYTHON
- SAS
- VBA
- MS Excel
- Dashboard creation and management
- Business intelligence
- Advanced analytics
- Reporting procedures
- Performance metrics evaluation
- MS Office
- STATA
- MYSQL
- Business Analysis
- Process Improvement
- BPMN
- Business Modeling
- Agile methodologies
- Data Visualization
- Change Management
- Regression analysis
- Statistical modeling
- Time Series Analysis
- Project Management
- Risk Management
- Predictive analysis
- Survival Analysis
- AWS Cloud Platform
- JIRA
- Confluence
- ETL
Accomplishments
- Erasmus Scholarship: Full funding of € 4820 as a full bright Erasmus+ student.
- Advanced Analytics SAS Certified.
- Future Leader's Scholarship: RMIT University.
- Punch riveting project was published in German Newsletter for the innovative technique.
- Winner of Northwest Metropolitan Cricket Association (Premier Championship).
Projects
- Joining of composites by punch riveting, Reinventing method of joining composites to reduce weight of materials for automobile industry.
- Shiny app for the analysis of student performance using R, Developed the shiny app to analysis the various factor that affects the student performance.
- Matching Algorithm, The frequency data for the names and surnames of Australian population is carried out to analyse the risk factor associate with the credit card fraud analysis.
Affiliations
Cricket Enthusiast - Passionate about playing cricket and engaging in strategic chess games
Timeline
Revenue and Reporting Analyst
Uniting Care
03.2024 - Current
Business Performance Analyst
Uniting Care
08.2023 - 03.2024
Business and Reporting Analyst
Uniting Care
03.2022 - 08.2023
National Workforce Planner
Wilson Security
12.2021 - 03.2022
Customer Solution Specialist
Probe group
08.2021 - 12.2021
Data Analyst
Yarra Valley Water
07.2021 - 11.2021
Data Analyst
Verifier
09.2020 - 03.2021
Reliability Analyst Intern
Cummins Global Analytics Centre
02.2018 - 06.2018
Master of Analytics - Business Analytics
RMIT University
Business Analytics and Data Mining- Certification -
Indian Statistical Institute
Bachelor of Technology - Instrumentation Engineering
Savitribai Phule Pune University
Honours in Reliability of Electronic product and Testing -
Savitribai Phule Pune University
Student Exchange Program - Industrial Engineering and Business Management
HoF University of Applied Sciences
Similar Profiles
Kim MacdonaldKim Macdonald
Cleaner at Uniting CareCleaner at Uniting Care
Tino OdonTino Odon
Family and Relationships Counsellor at Uniting CareFamily and Relationships Counsellor at Uniting Care
Judith MoyleJudith Moyle
In Home Care at Uniting CareIn Home Care at Uniting Care