Blogger
Nimmu Mary
Melbourne,VIC
Summary
Certified by Microsoft in Azure and PowerBI, I bring over 8 years of successful industry experience, specializing in advanced PowerBI. Currently engaged with Melbourne Metro, I excel in communication, effortlessly forging strong relationships and influencing stakeholders. My natural talent for collaboration drives strategic goal attainment. Proficient in Microsoft Excel, SQL, and Data Visualization through PowerBI, I also possess expertise in Microsoft Fabric, Snowflake Database, and Azure. My background includes extensive experience in Data Analytics teams, particularly within Audit, Risk, or Assurance functions, with deep subject matter expertise in Technology Operations and associated tools.
Overview
13
13
years of professional experience
2
2
Certification
Work History
Data Engineer
Self-employeed
Melbourne, VIC
03.2026 - Current
- Implemented automated data ingestion pipelines in Microsoft Fabric Data Factory to retrieve external data from REST APIs and land it in a Lakehouse storage layer in JSON format.
- Configured REST API connectivity using SearchAPI.io to ingest public search data following the deprecation of the Bing Search API.
- Designed and orchestrated data pipelines in Fabric Data Factory to automate extraction and ingestion of external data sources.
- Developed PySpark notebooks to process semi-structured JSON data, including schema inspection, flattening nested arrays using explode(), and expanding hierarchical fields into relational columns.
- Implemented data transformation and cleansing logic to standardise relative timestamp values and derive reporting-friendly date attributes.
- Persisted curated datasets as managed Lakehouse tables in Microsoft Fabric to enable scalable analytics and Power BI reporting.
Analytics Engineer / BI Data Engineer
Melbourne Metro
Melbourne, VIC
11.2024 - Current
- Design, develop and maintain Power BI semantic models, datasets and dashboards aligned to enterprise data standards.
- Develop and optimise ETL and data transformation processes using Power Query, SQL,python and Snowflake-sourced data, preparing curated datasets and analytical models for scalable Power BI reporting.
- Implement dimensional data models (star schemas) to support scalable enterprise reporting.
- Integrate Power BI with Snowflake, Azure data services and on-premise systems.
- Develop complex Power Query transformations and advanced DAX calculations to support business KPIs and analytics.
- Partner with stakeholders to translate business requirements into scalable BI solutions and reporting frameworks.
- Monitor and optimise semantic model performance including DAX optimisation, refresh strategies and dataset storage.
- Implement Row Level Security (RLS) and governance frameworks to ensure secure access to enterprise data.
- Automate reporting workflows using Power Automate and process automation tools.
Business Data Analyst
Melbourne Metro
Melbourne, VIC
10.2023 - 10.2024
- Develop a comprehensive flagship dashboard for Metro Academy, enhancing decision-making for management, employees, and students. This tool efficiently outlines training schedules, room allocations, leave details, and monitors progress across various categories.
- Design and implement various dashboards that deliver critical insights into profits, forecasts, budget plans, and targets, adjusted for enrollments and training completions.
- Learning to integrate real-time data solutions using Live Connection with Snowflake Datawarehouse and Azure Databricks, ensuring robust data accessibility and seamless integration across the Academy.
- Proved successful working within tight deadlines and a fast-paced environment.
Data Analytics Engineer
Capgemini
04.2022 - 08.2023
- Designed and delivered data-driven solutions by developing scalable dashboards and analytics models for diverse stakeholders, while building and optimising data pipelines to support reliable data ingestion and reporting.
- Designed, developed and deployed data pipelines using SQL Server and Power BI, performing data extraction, transformation and preparation to ensure high-quality, analytics ready datasets. Leveraged SQL for joins, aggregations and data validation to support accurate reporting.
- Collected, cleaned and transformed raw datasets using Python and SQL to ensure data quality, consistency and reliability for downstream analytics and reporting.
- Performed exploratory data analysis (EDA) using Python to identify trends, correlations and data anomalies, supporting data validation and business insights.
- Developed data visualisations and dashboards to communicate insights effectively to both technical and non-technical stakeholders.
Projects
• Implemented an HR analytics solution by integrating and transforming data from multiple SQL Server sources, enabling cross-departmental visibility and real-time reporting. This resulted in a 25% reduction in manual workload across departments.
Senior Consultant-UKI Data Operations Lead
Ernst and Young LLP,India
08.2020 - 02.2022
- Managed and led a team of analysts and specialists at EY in Revenue Analysis, Performance dashboards, and business trend analysis for UK and Ireland operations, demonstrating excellent communication and stakeholder engagement skills
- Ensured consistency, reliability, scalability, and quality of all standard reports
- Initiated an "Influencing Change" of our major reporting processes by creating an automated system with Power Query,DAX,M language and Alteryx for Extraction Transformation and Loading (ETL).These critical thinking skills helped in reducing report turnaround time to one day, cutting manual rework by 25%, and slashing reporting task time by 50%.
Data Analyst
Beinex Consulting Pvt Ltd
01.2020 - 07.2020
- Created actionable Tableau visualization solutions to provide insights and recommendations, demonstrating expertise in understanding business KPIs and delivering advanced analytics services using Tableau, Microsoft Power Bi, and Alteryx.
Data Reporting Analyst
Taprint Technologies Pvt Ltd
06.2016 - 01.2020
- Spearheaded data collection and annotation endeavour, leveraging SQL to extract cloud-based data for generating valuable business insights, utilizing tools such as MS Excel, Keybase, Trello, and Slack.
Assistant Professor
Private Engineering College
05.2013 - 05.2016
- Delivered exceptional lectures, drive innovative research, mentor students, cultivate a dynamic learning atmosphere, collaborate with peers, shape curriculum, and actively engage in scholarly pursuits to elevate knowledge and uphold academic excellence.
Education
Master of Science -
National Institute of Technology
06.2013
Bachelor of Science -
TKM College of Engineering
05.2011
Skills
- Microsoft PowerBi
- Azure
- Microsoft Fabric
- Microsoft Excel
- Snowflake DB
- SQL
- Python
- Tableau
- Alteryx
- R programming
Certification
- Microsoft Certified Azure Fundamentals
- Microsoft Certified Power BI Data Analyst
- Tableau Analyst Badge
- Alteryx Foundational Micro-Credential Badge
- Microsoft certified Viva Insights Specialist Badge
- Architect Badge from Capgemini
Interests
Timeline
Data Engineer
Self-employeed
03.2026 - Current
Analytics Engineer / BI Data Engineer
Melbourne Metro
11.2024 - Current
Business Data Analyst
Melbourne Metro
10.2023 - 10.2024
Data Analytics Engineer
Capgemini
04.2022 - 08.2023
Senior Consultant-UKI Data Operations Lead
Ernst and Young LLP,India
08.2020 - 02.2022
Data Analyst
Beinex Consulting Pvt Ltd
01.2020 - 07.2020
Data Reporting Analyst
Taprint Technologies Pvt Ltd
06.2016 - 01.2020
Assistant Professor
Private Engineering College
05.2013 - 05.2016
Master of Science -
National Institute of Technology
Bachelor of Science -
TKM College of Engineering