Vivian Mibei
Summary
- Key skills – Data Visualization (Power BI) | Data Analysis | Business Intelligence (SSIS, ETL/ELT) | Advanced Power BI (DAX Function) | SSAS Tabular | Microsoft SQL Server | SQL Programming (Stored Procedure, Functions) | Relational Database Management System (RDBMS) | Data Warehouse design | SSRS and Power BI (Report Builder for paginated Report) | Report Development | Data Modelling.
- A qualified Business Intelligence Developer with over 1 year of experience as a Business Intelligence Developer for MVP STUDIO which is a tech startup incubator and tech product development company.
- Successfully involved in multiple projects namely:
- Cancer Analytics Project
- Property Analysis
- Designing and developing a chat bot system for a real-estate company.
- Holder of master’s degree in technology (Software Engineering) from Federation University as well as a Bachelor degree of Information Technology.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Data Analyst
AusBiz Consulting
Sydney
09.2022 - Current
- Cancer Analytic project – From the NHS UK (UK synthetic cancer registry)
- Duties:
- Analysis and providing insight on cancer dataset including addressing the key questions the business has raised
- Requirement gathering
- Data acquisition and preparation (Extracting relevant information from the data set)
- Data cleaning and Transformation
- Populating data into Azure SQL
- Data Analysis
- Outlining change control procedures
- Generating Reports (Power BI Report).
Business Intelligence Developer/Data Analyst
MVP Studio
Sydney
- Software product development company
- Key project:
- Property Analysis of Australia - Using SQL queries to generate required results and using SSRS to develop reports
- Duties:
- Integrating property data from multiple government data sources to build a complete data set
- Using MS SQL server, SSIS, Power Query, SSRS and Power BI to develop the solution
- Creation and optimization of SQL queries, stored procedures, and functions to implement medium to complex business logic for analysis and reporting purposes
- Creating and maintaining SSRS reports using a data warehouse as the data source
- Designing of the data warehouse and SSIS package consistent with the existing design
- Optimization of Power BI dashboards focusing on performance, testability, and maintaining standards.
Education
undefined
2024
Business Intelligence Developer- Industry connect. Microsoft SQL Server, Power BI and Power Report Builder, Data warehouse, SSIS, SSAS, SSRS and ETL - undefined
2022
undefined
2021
Information Technology
Australian Technical and Management College
Nov 2020
Master of Technology - Software Engineering
Federation University
July 2019
Skills
- Database Developer
- Australian Computer Society (ACS) – Sydney, Australia
- Key project: Designing and developing a chatbot system for real estate
- Duties:
- Designing the chatbot to generate a dialogue and give options to the user when they visit the website
- Enabling flow for all possible scenarios which user can accomplish by talking to the bot ie (answering frequently asked questions)
- Designing the chatbot to have important information triggers that split the flow based on user replies and actions
- Ensuring there is fully functional forms to gather data for sales
- Designing the chatbot to be able to handle errors
- Skills:
- Database Management System Teamwork Agile Project Management Change Management Documentation Stakeholder Analysis Communication
- Key Study Areas: Understanding Australian work culture, Project Management, Leadership
- SKILLS SUMMARY
- Technical skills
- Data Analysis
- Business Analysis
- Data cleaning and standardisation
- Data visualisation
- Microsoft SQL server
- Data Mining
- Creating Dashboards and Reports
- Statistical Knowledge
- Business Intelligence
- Microsoft Excel
- Soft skills
- Great communication
- Attention to detail
- Teamwork
- Leadership
- Problem Solving
- Creativity
- Time Management
- Adaptability
- Conflict Management
- Critical thinking
Certification
Business Analysis | Data Analysis | Data cleaning | Data Warehouse | Teamwork | Power BI | SQL knowledge | Communication skills.
Oct 2020 – Dec 2020
Additional Information
- Work ethic.
Timeline
Data Analyst
AusBiz Consulting
09.2022 - Current
Business Intelligence Developer/Data Analyst
MVP Studio
undefined
Business Intelligence Developer- Industry connect. Microsoft SQL Server, Power BI and Power Report Builder, Data warehouse, SSIS, SSAS, SSRS and ETL - undefined
undefined
Information Technology
Australian Technical and Management College
Master of Technology - Software Engineering
Federation University
Similar Profiles
Prakriti NeupanePrakriti Neupane
Intern at AusBiz ConsultingIntern at AusBiz Consulting
Salman AbirSalman Abir
Data/Business Analyst (intern) at Ausbiz ConsultingData/Business Analyst (intern) at Ausbiz Consulting
Rajesh ADHIKARIRajesh ADHIKARI
Agile Business Analyst at Ausbiz ConsultingAgile Business Analyst at Ausbiz Consulting
Rajesh AdhikariRajesh Adhikari
Agile Scrum Master at Ausbiz ConsultingAgile Scrum Master at Ausbiz Consulting
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria