Ranjith Pullagurla
Sydney,NSW
Summary
Strategic Data Analyst with over three years of experience leveraging data to drive strategic business decisions. Expert in transforming complex datasets into actionable insights using advanced visualization tools, and proficient in ETL processes, data modeling, DAX, and SQL. Known for collaborating with stakeholders to identify critical business needs and deliver customized, data-driven solutions. Recognized for enhancing business processes and decision-making through precise, high-quality data analysis, consistently achieving measurable results.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Analyst
The APP Group
04.2024 - Current
- Developed dashboards to report on key metrics for the NSW Manufacturing for Schools program by extracting data from various sources, including Procore, timesheets, Microsoft Project, SQL Server, and spreadsheets
- Collaborated with cross-functional teams to gather business requirements and communicated complex data insights effectively, leading to a 10% increase in project delivery efficiency
- Identified 3+ inefficiencies and lack of validations in business processes when reporting costs
- Presented findings to senior management, leading to the implementation of stringent cost validations and achieving a 9% reduction in total cost planning estimates
- 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 extracted from traditional project management systems and developed dashboards using AWS Quicksight for presenting insights on Data Centre construction cost estimates
- Configured API integration using Python to facilitate seamless data exchange between internal systems and third-party services
- Developed and Implemented comprehensive P&L statement dashboards in Power BI, enabling detailed financial analysis and insights into revenue, expenses, and profitability trends.
Data Analyst
Ttec Pty. Ltd.
02.2022 - 03.2024
- 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
- Utilized DAX measures and Power Query for data transformation and analysis, facilitating more accurate forecasting and strategic decision-making for senior management.
Client Solution Specialist
Probe Group
10.2019 - 11.2021
- 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.
Performance Analyst (Contract role)
Monash University
10.2020 - 12.2020
- 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% accuracy which resulted in 7% reduction in planned resource for the next financial year.
Education
Master of Data Analytics -
Deakin University
Melbourne, VIC08.2018
Bachelor of Science - Computer Science And Programming
ICFAI University
06.2016
Skills
- Statistical Analysis
- Descriptive Analysis
- BI Tools – Power BI, Tableau
- Databases: MSSQL, PostgresSQL
- Data Warehousing, Data Modeling
- Azure Data Factory, Microsoft Office Stack
- Proficient in Python, DAX, Power Query, M Language
- ETL development
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%.
References
Available upon request.
Certification
- Certified Salesforce CRM Administrator (20291572)
- AMCAT Certified Data Processing Specialist (1790198-211)
Timeline
Analyst
The APP Group
04.2024 - Current
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
Master of Data Analytics -
Deakin University
Bachelor of Science - Computer Science And Programming
ICFAI University
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)