Summary
Overview
Work History
Education
Skills
Projects
Certification
References
Timeline
Work Availability
Hi, I’m

Ranjith Pullagurla

Data Analyst
Sydney,NSW
Ranjith Pullagurla

Summary

Results-driven Power BI Analyst with 3+ years of experience in data analysis, visualization, and reporting. Proficient in leveraging Power BI to transform complex data sets into actionable insights. Strong background in data modeling, DAX, and SQL. Adept at collaborating with stakeholders to identify business needs and deliver data-driven solutions. Proven track record of improving business processes and decision-making through effective data analysis.

Overview

5
years of professional experience
2
years of post-secondary education
2
Certifications

Work History

The APP Group
Sydney, NSW

Analyst
4 2024 - Current

Job overview

  • Developed dashboards to report on key metrics for NSW Manufacturing for Schools program by extracting data from various sources, including Procore, timesheets, Microsoft Project, SQL Server, and spreadsheets
  • Coordinated with project managers and general managers to collect desired datasets, identified 3+ inefficiencies and lack of validations in business processes when reporting costs
  • Demonstrated findings to senior management, resulting in implementation of strict cost validations and saving the company $367,000 in cost planning
  • Automated multiple BI dashboards using Power BI for month-on-month project schedule updates and cost reporting, reducing discrepancies between forecasted final costs (FFC) and budget estimates
  • Utilized complex SQL queries for ETL operations on large datasets from traditional project management systems and developed dashboards using AWS Quicksight for presenting insights on Data Centre construction cost estimates
  • Designed and implemented API integration solutions using Python to facilitate seamless data exchange between internal systems and third-party services

Ttec Pty. Ltd.

Data Analyst
02.2022 - 03.2024

Job overview

  • Designed Power BI dashboards based on historical sales trends, assisting in raising revenue by at least 7% in the next quarter
  • Optimized report performance using DAX Studio, resulting in a 5% performance boost and projected 10% revenue growth and 20% data-related expense reduction
  • Streamlined dashboards to pinpoint discrepancies in market share and revenue targets, resulting in 12% increase in net profit and market share recapture
  • Performed data cleaning and ETL operations on various datasets using Power Query and M-language to address inconsistencies
  • Created web scraping tools using BeautifulSoup and Scrapy to collect and process large volumes of data from online sources, providing valuable insights for market research.

Probe Group

Client Solution Specialist
10.2019 - 11.2021

Job overview

  • Handled customer inquiries in line with company requirements to meet Key Performance Indicators (KPIs) and targets
  • Identified customer pain points and trained sellers by recommending changes to enhance processes and sales performance
  • Once a problem is resolved, process and procedures are documented so that the issue can be quickly resolved in future
  • Created standardized procedures for proper escalation of unresolved issues to appropriate internal teams

Monash University

Performance Analyst (Contract role)
10.2020 - 12.2020

Job overview

  • Analyzed student data using python and machine learning methodologies to identify trends, drivers, and measures of key university performance
  • Performed statistical analysis to support student numbers planning, monitoring, and forecasting processes
  • Model was to achieve 96 percent accuracy which resulted in 7 percent reduction in planned resource for that financial year

Education

Deakin University
Melbourne, VIC

Master of Data Analytics from Information Technology
07.2016 - 08.2018

University Overview

Skills

Power BI: Advanced data modeling, DAX, Power Query, and report/dashboard development

Projects

Projects

Manufacturing for NSW Schools:

 Developed a comprehensive project dashboard providing real-time insights into key lifecycle metrics, including financials, risks, and schedules, for each of the 64 schools within the project, along with a portfolio view. The dashboard enabled senior management to make informed decisions, resulting in a 12% in profit margin. Collaborated with cross-functional teams to identify and document risks in a risk register, then streamlined risk management by visualizing data on a dashboard using a risk matrix. 


Business 360 - Brick & mortar and e-commerce:

 Designed a multi-view dashboard in Power BI for 6 departments (sales, finance, supply chain, executive, marketing, and products). Facilitated data-driven decisions, which aimed to scale the business processes by 10%. Imported 2 different data sources (MySQL, and Excel) with more than 1 million records and performed data modelling. Optimized the report using DAX studio, which saved 30% of storage and improved performance by 10%.

Certification

Certified Salesforce Administrator (CRM), 07/2019, No expiry date, 20291572

References

References
Available upon request.

Timeline

Data Analyst
Ttec Pty. Ltd.
02.2022 - 03.2024
Performance Analyst (Contract role)
Monash University
10.2020 - 12.2020
Client Solution Specialist
Probe Group
10.2019 - 11.2021
Deakin University
Master of Data Analytics from Information Technology
07.2016 - 08.2018
Analyst
The APP Group
4 2024 - Current
Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Ranjith PullagurlaData Analyst