PRERIT MIGLANI
Melbourne,VIC
Summary
As a passionate data analyst with a keen interest in technology and its transformative impact on business processes, I excel in translating data into actionable insights through advanced modelling and machine learning capabilities. Proficient in Python, SQL, and data modelling, I have successfully applied these skills to drive impactful outcomes across various university projects. Additionally, my expertise extends to leveraging data visualization tools such as Power BI to effectively communicate insights. With strong analytical acumen, attention to detail, and a collaborative mindset, I am eager to apply my skills to tackle real-world business challenges and contribute to your organization's success.
Overview
3
3
years of professional experience
Work History
Data Analyst
New Aim Pvt Ltd.
10.2022 - Current
- Collaborate with cross-functional teams and senior stakeholders to define problem statements, collecting data from various internal systems, and build analytical models using Databricks SQL in Microsoft Azure Databricks and T-SQL in SQL Server Management Studio (SSMS) to optimize costs and enhance operational efficiencies.
- Utilize Power BI with DAX and M queries to create comprehensive daily KPI tracking reports for Quality Control, Customer Service, and Logistics teams, enabling actionable insights, data-driven decision-making, and impactful data visualizations across departments.
- Integrate reputable data providers using DBT for data transformation and integration into the data warehouse. Manage version control with Bitbucket for collaborative data engineering projects and automate data sourcing and analysis with RESTful APIs.
- Implements data modelling techniques, specifically utilizing star schema, to enhance financial analysis accuracy for invoice reconciliation reporting across multiple freight couriers, ensuring comprehensive reconciliation and transparency.
- Migrating all production reports from Microsoft SQL Server to Azure Databricks in the company to enhance data analysis and operational efficiency.
- Conduct A/B testing to analyze and optimize marketing strategies and initiatives, ensuring data-driven decision-making and continuous improvement.
- Develop and deploy a cash flow model using Python, leveraging NumPy and Pandas, to support budgeting and forecasting decisions for the Finance team.
- Conduct detailed analysis of channel sales data, utilizing logistic regression and Scikit-Learn to develop and train predictive pricing models, enhancing accuracy and effectiveness.
- Work on ad-hoc analysis and Business As Usual (BAU) tasks, developing reproducible analytical approaches to meet CIO department requirements.
- Currently utilize Agile project management with Jira and Confluence to efficiently execute projects, creating reports and maintaining regular communication with stakeholders.
Business Intelligence Analyst
Curio Business Consulting
04.2022 - 10.2022
- Utilized Snowflake for data querying using SQL and implemented data warehousing techniques to gather data from diverse sources via different APIs.
- Developed Power BI reports tailored to clients' needs and presented findings to external stakeholders.
- Defined data requirements for projects, identified key metrics essential for achieving objectives, and focused on resource and cost management.
- Connected data sources and developed SQL queries for statistical analysis, leveraging tools like SAS and Google Cloud Platform's BigQuery to infer trends and provide insights into the Australian labor market for future course mapping.
- Applied feature engineering and utilized Vertex AI for model building, creating proof-of-concepts to enhance data-driven decision-making capabilities.
Data Analyst
CSIRO's DATA 61 (Research & Science)
06.2021 - 12.2021
- Conducted extensive data wrangling and exploration on Australian AI investment data sourced from Crunchbase and other APIs.
- Utilized Python for detailed analysis, extracting demographic insights on AI investments.
- Integrated data from multiple API sources to enrich analysis and provide comprehensive insights.
- Developed interactive Tableau dashboards to visually present findings from private and public enterprises.
- Documented insights to contribute to Australian AI research policies, employing Python and Tableau for robust data analysis and visualization.
Education
Master of Data Analytics -
RMIT University
12.2021
Bachelor of Technology (Engineering) -
ITM University, Delhi, India
01.2015
Skills
- Python
- SQL
- DAX
- Power BI
- M Query
- Tableau
- DBT
- Snowflake
- Azure Databricks
- Excel
- Jira
- GitHub
- Google Cloud
- MLOps
- Mircrosoft Azure
- Bitbucket
- R studio
- Big Query GCP
- Machine Learning
- Time Series Analysis
- Agile Methodologies
- NLP
Websites
Hobbies and Interests
- Reading
- Travelling
- Swimming
- Cricket
Timeline
Data Analyst
New Aim Pvt Ltd.
10.2022 - Current
Business Intelligence Analyst
Curio Business Consulting
04.2022 - 10.2022
Data Analyst
CSIRO's DATA 61 (Research & Science)
06.2021 - 12.2021
Master of Data Analytics -
RMIT University
Bachelor of Technology (Engineering) -
ITM University, Delhi, India
Similar Profiles
Kiran Khushalani PandyaKiran Khushalani Pandya
Manager Business Development at Laqshya Media Pvt LtdManager Business Development at Laqshya Media Pvt Ltd
Eshwar PotnuruEshwar Potnuru
Machine Learning Engineer at AIM Co., Pvt Ltd.Machine Learning Engineer at AIM Co., Pvt Ltd.
Shyam SinghShyam Singh
Operations Manager at Axess Aim India Pvt LtdOperations Manager at Axess Aim India Pvt Ltd
Cavsar KuerbanCavsar Kuerban
ECommerce at DropK CardsECommerce at DropK Cards
Rabah Al RifaiRabah Al Rifai
Plumbing Apprentice at Own BusinessPlumbing Apprentice at Own Business