SHIVANGI AGRAWAL
Data Analyst at Macutex- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SQL for Data Science With Google Big Query
Udemy
Experience
-
Macutex
-
Australia
-
Facilities Services
-
1 - 100 Employee
-
Data Analyst
-
Apr 2022 - Present
-Produce data visualizations, dashboards, report development using Power BI and Tableau -Handle Big data, ETL operations, Data wrangling, Data processing -Write SQL queries -Build data collection tools using company preferred applications. Ensure tool is fit for purpose and designed efficiently -Make recommendations to improve use of data systems and how data is handled -Improve process for standardization of data capture, database management and data integrity -Data validation using set Quality Assurance procedures. -Maintain, amend and enhance existing database
-
-
-
-
Data Analyst
-
Aug 2021 - Apr 2022
-Worked with large and complex data. Data collection, interpretation, and analysis. Collected data from different sources to combine and prepare a large dataset and cleaned it for further use. -Coordinated statistical data analysis, design and information flow. -Have completed multiple projects involving Big Data Analysis and future prediction. -Worked on a Dashboard with several powerful visualisations and insights. -Used various Machine Learning and AI techniques such as Data Modelling and Feature Engineering for forecasting. -Developed tables, views and materialized views using SQL. -Recommended data standardization and usage for protection of data integrity. -Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes. -High quality insights reporting and documentation.
-
-
-
Prodegee.com
-
Australia
-
Financial Services
-
1 - 100 Employee
-
Data Science Intern
-
Feb 2021 - Jul 2021
-Data collection from live web resources using APIs in Python, data cleaning, wrangling and organization. -Data Mining, Pattern recognition and modelling using Machine Learning techniques such as Decision trees, ANN and Clustering. -Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources. -Evaluated trends to understand competitive environments and assess current strategies. -Compiled, evaluated and reviewed engineered data for internal system. -Documented business workflows for stakeholder review. -Data preparation using Power Query and SQL. -Storytelling with Data using advanced Data Visualization techniques in Power BI and MS Excel. -Agile methodology, sprint planning and reviews, collaboration with stakeholders. -Elaborate reporting and presentation for stakeholders at the end of project.
-
-
-
-
Data Intern
-
Nov 2020 - Feb 2021
-Extensive data collection, data cleansing, improving profitability by suggesting new strategies based on data modelling and machine learning techniques. -Power BI reporting, dashboard creation, complex formula development. -Advanced Excel, Excel macro development, dashboard creation in Excel. -Participated in requirements meetings and data mapping sessions to understand business needs. -Extensive data collection, data cleansing, improving profitability by suggesting new strategies based on data modelling and machine learning techniques. -Power BI reporting, dashboard creation, complex formula development. -Advanced Excel, Excel macro development, dashboard creation in Excel. -Participated in requirements meetings and data mapping sessions to understand business needs.
-
-
-
-
Data Analyst
-
Apr 2018 - Apr 2019
-Designed and developed schema data models. -Created and improved intelligence resources to facilitate consistent data management strategies. -Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions. -Data analysis and prediction using Machine Learning and Data Modelling Techniques, attribute selection and expansion, decision tree, clustering, Data Mining, Data Visualization. -Big Data analysis, statistical analysis for strategic policy formation, hypothesis testing, searching data for interesting hidden patterns and drawing insights. -Worked on cloud-based platforms such as AWS, Azure. Learnt JAVA Frameworks and worked on projects involving JavaScript, CSS, SQL. -Worked with desktop application development project for creating a web-based platform for company employees with PHP, MySQL and API integration.
-
-
Education
-
2019 - 2021
RMIT University
Master's degree, Data Science -
2014 - 2018
Vellore Institute of Technology
Bachelor of Technology - BTech, Computer Science
Community
