Lubna Framewala
Melbourne,VIC
Summary
Motivated junior data analyst with hands-on experience in data cleaning, preprocessing and exploratory data analysis. Skilled in transforming raw data into actionable insights using programming languages such as Python and SQL. Demonstrated ability to create compelling visualizations and reports to communicate findings effectively. A proactive problem solver committed to delivering high-quality analytical solutions. Seeking opportunities as a data analyst to contribute to projects that involve data analysis, reporting and process improvement.
Overview
7
7
years of professional experience
Work History
Junior Data Analyst
Industry Connect Australia
05.2023 - Current
- Design database schema (Star schema / Snowflake schema) to meet the requirement of the project.
- Identify data validation requirement which included constraints like data type, range of values, length limits. Use database constraints like primary key, foreign key, not null and unique key.
- Designed and Implemented ETL Processes by understanding the project's requirements,
- Extract and Transform data in SSIS using the correct Source, Transform and Destination components. Also included error handling by redirecting rows, conditional splits to manage data that fails validation or transformation.
- Use the SSRS Report Designer to create the visual layout of the report. This involves adding elements like tables, charts, text boxes, and images to organize and present the data.
- Add components like headers, footers, page numbers, and logos to provide context and branding to the report.
- Organize data into groups, like categories or subcategories. Use math tools to figure out totals, averages, or other important numbers. Set up options so that people using the report can change things and see different results.
- Use Power BI's to visualize chart such as Bar chart, Line chart, Clustered column chart etc.
- Integrate slicers, filters, and other interactive elements that allow users to explore the data.
- Calculate measures and Key Performance Indicators (KPIs) using DAX (Data Analysis Expressions) to provide additional context and insights
Educator
Milestone Early Learning Centre
05.2019 - 09.2023
- Excellent communication and interpersonal skills.
- Plan and implement developmentally appropriate activities and curriculum for children aged 0-5 years.
- Establish positive relationships with parents and guardians through regular communication.
- Supported children's social, emotional, and cognitive development through engaging play and learning experiences.
- Collaborated with colleagues and maintain a stimulating learning environment that met the needs of all children.
- Participated in staff meetings, training sessions, and professional development opportunities to enhance skills and knowledge in early childhood education.
Assistant Chef
Hawthorn Early Learning Centre
08.2017 - 03.2018
- Prepared and cooked a variety of dishes according to menu ensuring timely service and customer satisfaction.
- Ability to work effectively under pressure in a fast-paced environment.
- Assisted with inventory management and stock rotation, to optimize food cost and minimize expenses.
- Maintain cleanliness and organize the kitchen area, adhering to sanitation standards and health code regulations.
Education
Certificate in Data Analyst - Data Analyst
Industry Connect Melbourne
Melbourne, VIC11.2023
Diploma in Early Childhood And Education - Childcare
Melbourne City Institute of Education
Melbourne11.2019
Certificate III in Commercial Cookery - Cooking
Melbourne City Institute of Education
Melbourne, VIC12.2016
Skills
Statistical modelling
Visual Studio 2022
SQL Server Integration Services (SSIS )
Server Reporting Services(SSRS)
Data visualization: Power BI
SQL and database management
Data cleaning and preparation
Adaptability
Detail oriented
Microsoft Excel
Professional Skills
MVP Studio:
Role: BI Developer/Data Analyst Intern May 2023 - Present
Project: Australia Property Analysis
Working on Creating Dashboards for Australia Property Analysis and enable intelligent and relevant decision making with regards to candidate’s commitments and skills.
Responsibilities:
•Import raw data from multiple sources, ensuring quality and integrity.
•Utilization of advanced Excel and Power Query editors to perform data cleansing and standardisation.
•Data modelling using relational, dimensional to represent information system.
•Implementing the star schema and snowflake schema using dimensional model to design, build, and test complex data warehouses.
•Created complex ETL packages, transformed data using staging area for data warehousing and implementing slowly changing dimension using SSIS.
•Analysing and interpreting the data using analysis services to create a Power BI dashboard for Australia Property Analysis using Power Query, DAX, and filters.
•Developed SSRS reports using SQL Queries.
Project: Tutor Performance
- Extract data from Google sheet into SQL management studio, removing Null value from the data.
- Creating database Diagram according to the requirement.
Timeline
Junior Data Analyst
Industry Connect Australia
05.2023 - Current
Educator
Milestone Early Learning Centre
05.2019 - 09.2023
Assistant Chef
Hawthorn Early Learning Centre
08.2017 - 03.2018
Certificate in Data Analyst - Data Analyst
Industry Connect Melbourne
Diploma in Early Childhood And Education - Childcare
Melbourne City Institute of Education
Certificate III in Commercial Cookery - Cooking
Melbourne City Institute of Education
Similar Profiles
Hasan MusanaHasan Musana
GIS Analyst at Primary Industry and Region of South Australia (PIRSA), Adelaide, South AustraliaGIS Analyst at Primary Industry and Region of South Australia (PIRSA), Adelaide, South Australia
Dipendra GhimireDipendra Ghimire
Personal Care worker at Connect Care AustraliaPersonal Care worker at Connect Care Australia
Swapnil GaikwadSwapnil Gaikwad
Research Intern at Study Australia Industry Experience ProgramResearch Intern at Study Australia Industry Experience Program