Download PDF

Summary

Experienced Data Analyst with more than six-year experience specialising in Power-BI, Azure SQL, and Azure Data Factory (ADF) along with extensive knowledge of SSIS, SSRS, software design, development, data visualisation, requirement gathering, and specification. Proven ability to convert raw data into valuable insights that drive strategic business decisions.Adept at engaging with stakeholders to gather requirements and ensure the delivery of solutions that meet organisational needs.

Passionate about utilising data to reveal trends, pinpoint opportunities, and optimise processes. Recognised for fostering a Data Culture within the organisations by empowering self-service BI capabilities and strong analytical skills. Effective communicator with result-oriented approach to analytics, consistently delivering solutions that enhance decision-making processes and contribute to overall business success.

Work experience

2020-122024-06

Technical Business/Data Analyst

Catalyst Education, Melbourne

Data Modelling

  • Designed the end to end Architecture.
  • Worked on the  the Data Mapping documents
  • Designed ADF pipelines to extract the data from API into Azure SQL, achieving a simple and cost-efficient solution.
  • Redesigned the Data Model.
  • Created unified views to be used as a single source of truth for the Power-BI reports as well as adhoc business reporting. 
  • Re-engineered MQuery into T-SQL.
  • Writing optimised SQL query to ensure the best query performance.
  • Creating the relationships in the data model for the better Slicing and Dicing of the data by different dimensions.

Progression Report

  • Developed Progression Reports for the business.
  • Worked closely with stakeholders to establish problem specifications.
  • Designed  and developed Azure Data Factory (ADF) pipelines for extracting data from a third-party application. 
  • Applied business logic within ADF to transform data and implemented robust error-handling mechanisms.
  • Utilised T-SQL for intricate calculations. 
  • Designed Power-BI reports to analyse progression data, providing valuable insights for the business and ensuring KPI's are met across the operations team.
  • Implemented Row Level Security (RLS) in Power-BI. 
  • Worked on DAX calculations to create measures in Power-BI.
  • Leveraged both out-of-the-box and certified visuals from Microsoft Marketplace to ensure an accurate representation of the data in a simplified manner.
  • Scheduling the Power-BI Refresh using the Power-BI Gateway.

Cancellation Analysis Report

  • Developed Cancellation Analysis report for the business.
  • Providing solution for business improvement to the Stakeholders to analyse cancellation reasons and enhance retention strategies.
  • Identified gaps in current processes and Recommended Solutions to mitigate issues.
  • Designed and developed a Power-BI report using DAX to gain insightful data and facilitate data-driven decision-making, aiming to reduce cancellation rates.
  • Establish and enhance the linkage between operational & financial data to assist better commercial decision making.

 Diverse Project Engagements : 

    In addition to the highlighted projects, I've contributed to various other initiatives. These            included tasks such as

  • Implementing SQL system versioning for capturing CDC changes.           
  • Conducting Ad-Hoc SQL Reporting
  • Collaborating closely with business stakeholders to comprehend their requirements, and translating them into technical specifications while delivering optimal solutions.
2014-102017-02

BI/Reporting Analyst

L&T Infotech, India

Client- Chubb Australia

  • Worked closely with stakeholders and solution Architect to establish business
    problem specifications and perform complex data analyses to provide solutions for the business.
  • Perform complex data analysis, data extraction, loading & transformation(ETL) using SSIS, data modelling in SQL and build front-end solutions using SSRS report and SSAS cubes.
  • Providing solution for data migration, including data mapping between legacy and the current system, strategy for staged roll-out.
  • Designing interactive dashboards to facilitates sales growth, orders estimates.

Client- UTC Climate, Controls & Security, U.S.A 

  • Developing integration packages for technician work orders to load from CRM into SQL using SSIS.
  • Implemented integration for reporting purpose and developed SSRS reports like Time series analysis tracking sales order and technicians field services.
  • Played a pivotal role in creating and Delivering Client Presentations.

Education

2018-072020-06

Masters Of Business Analytics

La Trobe University
2010-102014-06

Bachelors of Engineering (Computer Science)

IES-IPS Academy (India)

Skills

BI Tools

Power-BI, Azure Data Factory, SSIS, Tableau, IBM Cognos

Databases

SQL, Azure SQL

Programming Language

M Query, DAX, TSQL, R

Achievements

Participated and won second position in Women in Data- Responsible AI & Data Governance event by Precision Sourcing Australia.

References

Available on Request

Residency Status

Permanent Resident