Rutvik Savani
Melbourne,VIC
Summary
Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data analyst
SATVAM SOFTWARE
01.2023 - 06.2023
- Developed ETL Mappings using SQL to extract the data from unstructured data and transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10,000 records
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Used statistical methods to analyze data and generate useful business reports.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Using Power BI created live dashboards and handle clients meetings and projects
- Utilized data visualization tools to effectively communicate business insights.
Data Analyst Intern
Internshala.com
05.2022 - 07.2022
Education
Master of Information Technology -
Swinburne University of Technology
01.2025
Bachelor of Science - Computer Science
VEER NARMAD SOUTH GUJARAT UNIVERSITY
SURAT07.2023
Skills
- Power BI
- Tableau
- Excel
- SQL
- Python
- MySQL
- Microsoft SQL
- Excellent verbal and written communication skill
Projects
Business Insights 360 - Data Analyst Student At Codebasics.io, Power BI, Learned how data transparency is brought to big organizations enabling users to make data informed decisions. Connected Power BI with MySQL, Excel to import ~4 million records. Performed data transformation in Power Query. Built a dashboard in Power BI from scratch for finance, sales, marketing, supply chain and executives which will support the organization in gross margin improvement. Learnt project management skills: Project charter (using Mural), stakeholder mapping analysis, Kanban board for task assignment to improve productivity., https://project.novypro.com/Mqr8L1 Covid 19 Data Exploration, SQL, Learned Basic joins, Converting Data Types, Select Statement and also some advance concepts of windows functions, CTE’s, Temp tables, Aggregate Functions and more. Dataset from corona virus website where they provided real numbers where they provided two files: covid deaths and covid vaccination. They have a total of 15 questions and with each question the level of it increases., https://github.com/savani1226/Covid-portfolio-project.git EDNA Youtube Channel Data Analysis, Power BI, As an analyst I prepared an exploratory analysis report about EDNA YouTube Channel growth! Connected PowerBI with Microsoft Excel to import data. Performed ETL in Power Query. I built a 3 page dashboard report in Power BI from scratch for general youtube information such as total views, total subscribers compared them with every year and more. Learnt Bookmarks, Parameters, Tooltips and more advance things., https://project.novypro.com/vu2zLR
Certification
SQL (Intermediate)- HackerRank
SQL (basic) - HackerRank
Timeline
Data analyst
SATVAM SOFTWARE
01.2023 - 06.2023
Data Analyst Intern
Internshala.com
05.2022 - 07.2022
Master of Information Technology -
Swinburne University of Technology
Bachelor of Science - Computer Science
VEER NARMAD SOUTH GUJARAT UNIVERSITY
Similar Profiles
Bhargav KirneBhargav Kirne
Software Developer at Qvantel software solutions ltd & Nexus Software Limited & Melvault software solutions Pvt LtdSoftware Developer at Qvantel software solutions ltd & Nexus Software Limited & Melvault software solutions Pvt Ltd
Shobha EswaraShobha Eswara
Payroll Specialist at Open Text Software (formerly Autonomy Software)Payroll Specialist at Open Text Software (formerly Autonomy Software)
Nanthini GanesanNanthini Ganesan
Software Engineer at Mindsbeam Technology Software Engineer Software Engineer Mindsbeam Technologies Pvt Ltd (Lystloc)Software Engineer at Mindsbeam Technology Software Engineer Software Engineer Mindsbeam Technologies Pvt Ltd (Lystloc)