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.
Hi, I’m
Ranjith Pullagurla
Data Analyst
Sydney,NSW
Summary
Overview
5
years of professional experience
2
years of post-secondary education
2
Certifications
Work History
The APP GroupSydney, 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 UniversityMelbourne, 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
Similar Profiles
Ranjith PullagurlaRanjith Pullagurla
Analyst at The APP GroupAnalyst at The APP Group
Katherine McIntoshKatherine McIntosh
Senior Urban Planner at The APP GroupSenior Urban Planner at The APP Group
Karthi AnandhakrishnanKarthi Anandhakrishnan
Finance Manager at Butterfly Gandhimathi App Ltd (Crompton Group)Finance Manager at Butterfly Gandhimathi App Ltd (Crompton Group)