Ashish Oza Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

Responsibilities:• Generated Ad-hoc reports on a timely basis of the mental health clients across all the hospitals in a Victoria region in support of Department of Health objectives and commitments.• Identified and resolved any processing and/or procedural issues as they occurred minimizing any impacts on the quarterly reports of Mental Health and Other Drugs services (MHAOD).• Compiled and validated data from different databases. Provided KPIs, analysed metrics and generated… Show more Responsibilities:• Generated Ad-hoc reports on a timely basis of the mental health clients across all the hospitals in a Victoria region in support of Department of Health objectives and commitments.• Identified and resolved any processing and/or procedural issues as they occurred minimizing any impacts on the quarterly reports of Mental Health and Other Drugs services (MHAOD).• Compiled and validated data from different databases. Provided KPIs, analysed metrics and generated reports that were used at the highest levels of executive management to make decisions for all units.• Developed custom PowerBI visuals for the PowerBI dashboard that would describe the data in a more precise way.• Fixing the ongoing PowerBI dashboards with an intention improve the performance as well as visual designs that would make the dashboard more productive and user friendly.Achievements: • Transformed large amounts of raw mental health client records data from variety of sources into searchable database for ad-hoc reporting on timely basis consistently attaining 80-90 % availability goal.• Consistently self-managed and independently motivated ahead of expectations in providing reports to the internal and external clients. Show less

Melbourne, Victoria, Australia

• Created visually impactful vaccination reports in R and excel for data reporting. Extracted, interpreted, and analysed data to identify key metrics and transform raw data from AIR (Australian Immunisation Register) & CVMS (Covid-19 Vaccination Management System) into meaningful, actionable insights.• Actively working on the Ad-hoc requests received from the manager, directors & PHI and sending out the reports on timely basis.• Responsible for generating the recurring reports mainly… Show more • Created visually impactful vaccination reports in R and excel for data reporting. Extracted, interpreted, and analysed data to identify key metrics and transform raw data from AIR (Australian Immunisation Register) & CVMS (Covid-19 Vaccination Management System) into meaningful, actionable insights.• Actively working on the Ad-hoc requests received from the manager, directors & PHI and sending out the reports on timely basis.• Responsible for generating the recurring reports mainly such as Vaccination Situation Report across Victoria, Vaccination Bookings reports, and Covid testing reports.• Successfully developed and maintained PowerBI dashboard for NDIS (Disability) vaccination data across Victoria.• Collaborated with directors and managers to perform cohort analysis that identified an opportunity to increase the Dose 3 campaign in low vaccination coverage across different LGA’s in VictoriaAchievements: • Developed and maintained vaccination PowerBI dashboard for Department of Family and Home affairs to track the vaccination status of the people living in high rise, low rise, and medium rise buildings.• Collaborating with entire team and consultants for improving the reporting process and making the required changes in the recurring reports as advised by seniors. Show less

Melbourne, Victoria, Australia

• Responsible for developing and delivering PowerBI dashboard for Mitchell Shire Council for tracking the activities of the contractors working on the project within the entire council region.• Developed in-house user activity dashboard to track the day-to-day activity and the information related to geospatial data that is collected on the web application. • Build and maintained a separate SQL database specially for live connection to the data for PowerBI reports.• Designed numerous… Show more • Responsible for developing and delivering PowerBI dashboard for Mitchell Shire Council for tracking the activities of the contractors working on the project within the entire council region.• Developed in-house user activity dashboard to track the day-to-day activity and the information related to geospatial data that is collected on the web application. • Build and maintained a separate SQL database specially for live connection to the data for PowerBI reports.• Designed numerous ad hoc reports for senior management significantly which positively contributed to accurate planning and budgeting in support of achievement of corporate goals.• Developed strong working relationships with the enterprise-wide team and clients to build and enhance reporting functionality.• Build and maintained a separate SQL database specially for live connection to the data for PowerBI reports.• Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.• Demonstrated strong technical proficiency, project leadership, and proactive communication skills with the ability to collaborate with clients to analyse business requirements.• Successfully delivered in house dashboard which increased the team’s efficiency while tracking the users with real time information.• Designing and Deployment of Reports for the End-User requests using Teradata. Show less

Melbourne

• Analyzed operational costs, expenditure to identify inefficiencies and recommend process improvements.• Implemented a companywide coding formula to allow rating and pricing reports to interface with operations and billingsystems more efficiently.• Performed reporting through Business Intelligence and Reporting tools to facilitate decision making.• Successfully run the compliance on the entire month of billing worth 400K in order to get the accuracy for the payment.•… Show more • Analyzed operational costs, expenditure to identify inefficiencies and recommend process improvements.• Implemented a companywide coding formula to allow rating and pricing reports to interface with operations and billingsystems more efficiently.• Performed reporting through Business Intelligence and Reporting tools to facilitate decision making.• Successfully run the compliance on the entire month of billing worth 400K in order to get the accuracy for the payment.• Developed financial model in excel and providing report on monthly expenditure on projects.• Leveraged cost improvement analysis, product offerings, and pricing strategies to maximize profitability in a proactivemanner. Show less

Melbourne, Australia

Mumbai, Maharashtra, India

• Performing data analysis on selected stocks from NSE index which resulted into 15% revenue generation on trading strategies.• Analysing market trends, technical analysis and researched statistical patterns to develop profitable trading strategies using advanced Excel functions.• Analysing annual reports and liaised with senior management teams to discuss strategic initiatives, attended industry meetings/conferences combined with company site visits• Issuing stock valuation reports… Show more • Performing data analysis on selected stocks from NSE index which resulted into 15% revenue generation on trading strategies.• Analysing market trends, technical analysis and researched statistical patterns to develop profitable trading strategies using advanced Excel functions.• Analysing annual reports and liaised with senior management teams to discuss strategic initiatives, attended industry meetings/conferences combined with company site visits• Issuing stock valuation reports through fundamental equity analysis and quantitative screening; conducted top-down and bottom-up analysis, identifying trends and sectors that would outperform Nifty 50. Show less

Master'S Degree, Business Analytics

Bachelor'S Degree, Business Administration And Management, General