Omkar Pawar
Chadstone,Australia
Summary
Results-driven Data Analyst with over 2 years of experience in data analytics and data pipeline development across government and corporate sectors. Proven expertise in ETL processes, data visualization, and reporting using Power BI, Tableau, SQL, and Python. Skilled at designing actionable insights, standardizing business metrics, and improving reporting accuracy. Adept at working with diverse stakeholders and managing data-driven solutions for strategic decision-making while ensuring compliance with data governance policies. Strong communicator with a keen ability to translate complex data into actionable insights, driving transformative results across various industries, including government and private sectors. Seeking opportunity to assist organization achieve business objectives and goals through waterfall and agile methodology.
Overview
3
3
years of professional experience
Work History
Data Analyst
Victorian School Building Authority
03.2023 - 02.2024
- Received, cleaned, and prepped data using SQL, SSIS Intergration and Excel to help support data warehousing solution for storing SAIL and AIMS data.
- Built data visualizations using Power BI and SSIS reporting for KPIs that reduced manual reporting by 6 hours weekly.
- Collaborated closely with the stakeholders and Business Unit team, gaining insight into SAIL and AIMS data aspects and writing documents
- Implemented SQL queries using SQL Server Management Studio (SSMS) and SSIS components for automation on data storage and update contributing to 15% decrease in processing errors.
- Contributed to weekly and monthly reports on school budget data enhancing reporting accuracy by 30%, driving more informed decision-making across the organization.
- Led the implementation of a data visualization tool that improved stakeholder decision-making.
Data Analyst - Associate
PWC
11.2022 - 02.2023
- Helped NSW Department of planning understand and improve their Housing supply trends by using Power BI to create multiple visually engaging dashboards
- Received positive feedback on analysis and reports, reducing clients time understanding the current increase in demand of housing supply and increased rental requirement and rent prices with increase in immigration.
- Used Alteryx to cleanse and normalize data, improving data quality for downstream analytics and slashing error rates by 22%.
- Created data specifications for the team members to better understand the data and develop precise analysis.
- Worked together with senior analyst to organize and prioritize tasks with GitHub Projects, enhancing team workflow and project completion rates by 34%.
- Improved data quality and reporting accuracy, enabling better decision-making at the executive level.
- Designed predictive models that enhanced business insights and improved efficiency by 15%.
Data Analyst
City of Stonnington
08.2021 - 10.2022
- Systemized the data extraction process from IoT sensors with Python Scripting, minimising the time required for producing reports by 3 hours.
- Integrated Microsoft Power BI dashboards with live data feeds from IoT sensors, boosting real-time data accessibility for 50+ users across multiple departments and people in the community.
- Collaborated with IT and development teams to deliver high-quality solutions, meeting both functional and non-functional requirements.
- Successfully reduced inefficiencies by implementing process improvements across various departments.
- Increased operational efficiency by 15% through predictive modeling and effective data management.
Data Analyst
CodeGym
11.2020 - 07.2021
- Developed data models based on research and large datasets to support business decisions.
- Employed Excel, SQL and Python for data extraction, cleaning, and processing, enabling more accurate analysis.
- Built dashboards in Tableau and Power BI to visualize trends and inform decision-making.
- Created predictive models that led to a 15% increase in student enrollment efficiency.
Python Developer
Appristine Technologies
07.2018 - 07.2019
- Collaborated with cross-functional teams to develop data-driven solutions for business problems
- Utilized Python and SQL for data manipulation, analysis, and reporting
- Developed and maintained data pipelines to automate data processing tasks
- Conducted statistical analysis and modeling to support decision-making processes, leading to more informed business strategies
- Designed and implemented visualization tools to communicate insights to stakeholders
- Participated in code reviews and provided constructive feedback to team members, improving code quality and team collaboration.
Education
Master of Data Science -
Deakin University
Burwood, Australia07.2021
Bachelor of Computer Engineering -
University of Pune
Pune, India06.2018
Skills
- Analytical and Problem-solving ability
- Data Management & Analysis: SQL, Python
- BI Tools: MS SQL, SSRS, SSIS
- Data Visualization: Power BI, Tableau
- Database Data fundamentals
- Communication Skills
- Time Management
- Critical Thinker
- Ability to work under pressure
- Taking responsibilities
- Snowflake Data Visualization
- Reporting solutions
- Strong problem solving skills
- Business Intelligence
- Azure
- Statistics and Quantitative
Timeline
Data Analyst
Victorian School Building Authority
03.2023 - 02.2024
Data Analyst - Associate
PWC
11.2022 - 02.2023
Data Analyst
City of Stonnington
08.2021 - 10.2022
Data Analyst
CodeGym
11.2020 - 07.2021
Python Developer
Appristine Technologies
07.2018 - 07.2019
Bachelor of Computer Engineering -
University of Pune
Master of Data Science -
Deakin University
Similar Profiles
Jodie WoodJodie Wood
Project Manager, Health Capital Program at Victorian Health Building AuthorityProject Manager, Health Capital Program at Victorian Health Building Authority
Manfred POHLENZManfred POHLENZ
VCAA State Reviewer (Music Repertoire) at Victorian Curriculum Assessment AuthorityVCAA State Reviewer (Music Repertoire) at Victorian Curriculum Assessment Authority
LAURA BARBANTELAURA BARBANTE
Head of Disruptions and Marketing at Victorian Infrastructure Authority (VIDA)Head of Disruptions and Marketing at Victorian Infrastructure Authority (VIDA)