Roosy Pundir
Sydney,Australia
Summary
Strategic leader with 20 years of experience in business and data analysis, specializing in business intelligence and data architecture. Demonstrated success in managing projects and teams, resulting in increased productivity and timely task completion. Expertise in operational strategy and conflict resolution enhances team performance and drives organizational success. Strong communication and problem-solving skills facilitate achievement of key business objectives.
Overview
20
20
years of professional experience
Work History
Manager Insights and Statistics, Data and Analytics Safety, Policy, Environment and Regulation
Transport for NSW
02.2023 - Current
- Create complex qualitative and quantitative data analysis reports to support the delivery of the branch initiatives, including sourcing and managing data, presenting findings, and leading and developing design strategies.
- Provide subject matter expertise while designing and recommending appropriate analytical approaches and methodology in addressing key issues within the business.
- Lead a team of five specialists and analysts to deliver on key customer insights and statistics projects and initiatives within agreed timeframes and deliverables.
- Engage and manage stakeholders in relation to information and data gathering, report design, testing, deployment and oversee ongoing production and analysis to ensure data integrity and data quality.
- Manage data integrity and quality and to facilitate the assessment and analysis of customer information and enable key issues to be identified and cross-referenced in multiple data sources.
- Oversee the troubleshooting of identified data issues, develop solutions and implement changes to data analysis models as required.
- Maintain all databases and tables within database systems for use with various statistical packages to ensure data remains error free.
- Motorist behavioral analysis using Telematics data from COMPASS.
- Analyzing speeding, harsh braking and near-miss events of vehicles in NSW across specific roads, in Police Area Commands, near School Crossings and the Mobile Speed Cameras to understand motorists’ behaviors at these places.
- Predictive Analytics of Crashes in NSW: Built a predictive model (using Random Forest Regression) using variables (Day of Week | time of Day | type of day (e.g. Holiday day or double demerit) | section of M1) to help analysts understand likely crash risk by day and time of day.
- Study on Vehicle Safety Features and Crashes: This study examined the impact of specific advanced driver assistance systems (ADAS) on road safety.
- Unmatched Serious Injuries Modelling: The purpose of this predictive AI model was to understand the location details of the crashes for which the serious injuries data, from hospitals, did not have a matching Police record.
A/ Senior Manager Insights and Advanced Analytics
Transport for NSW
04.2024 - 06.2025
- Deliver key customer data analysis, performance measures and insights to the Director and Branch leadership team and other key business stakeholders to support modelling, strategic projects and drive business recommendations and decision making.
- Lead a team of 12 specialists, analysts and managers to deliver on key customer insights and analytics projects and initiatives within agreed timeframes and deliverables.
- Determine and manage the appropriate approach for sourcing and storing required data for immediate and future team needs.
- Demonstrate the Transport Connected Leadership dimensions by role modelling collegiate and collaborative behaviors to achieve the greater good for the community, celebrate our diverse workforce, create an environment where people can create and thrive, and support our people’s wellbeing.
- Showcase a deep understanding of needs of business & analytics users - advising on/guiding best in class data solutions.
- Creating a community practice, Statistics and Advanced Analytics and Insights, across Transport Safety to showcase and share new ideas, analysis and solutions for business problems using Advanced Analytics tools and Statistical methodologies.
- Creation, management of Rapid Response team to handle critical and urgent requests from Minister’s Office, Parliament and media through an efficient Agile based system, using Jira, and regular cadence in the team to go over the new requests.
- Helping the Director and other key stakeholders in the business to conduct workshops to collect data requirements for potential problems which can be solved through an advanced analytics methodology.
Manager Analytics and Data Management
KPMG Australia
09.2021 - 12.2022
- Provide unique services through delivering consulting projects, data management, custom analytics work, and data platforms.
- Lead project management activities such as project planning, fees and expense management, resource planning, status reporting and risk identification.
- Scoping and designing data projects and developing solutions using the latest data methods and technology to solve complex client challenges.
- Manage the execution of various project tasks including gathering data requirements, analysing data, documenting processes, designing solutions, and creating executive presentations.
- Collaborating with senior management on building business proposals.
- Managing teams to deliver data analytics projects for Banking remediation project.
- Working on Government projects for designing their reporting platform, conducting complex data analysis for fraud detection, and designing automated data testing algorithms.
- Performing Internal audit for clients’ data governance and management processes and creating reports with observations and recommendations.
Senior SQL Analyst
Sydney Trains
10.2018 - 09.2021
- Project: Financial Sustainability Project
- Role: Senior SQL Development Analyst
- Technologies & Skills: SQL, Python, Jenkins, Tableau, Anaplan
- The rationale behind developing the productivity costing modelling tool is due to below reasons:- Current pay conditions impose significant financial costs on roster changes and overtime.
- In FY21 (Jun-Dec) about $15m or 7% of total driver / guard labour costs (~ $29m annualised) were related to excess shifts and extended hours.
- Schedules are being optimised to achieve the lowest overall shift count but current rostering tools do not provide a financial optimisation that considers other cost drivers such as lift-up, lay-back, build up and mileage etc.
- A manual tool is available to cost master Baseline schedules and daily schedules but requires upgrades.
- The financial impact of roster changes during the lifecycle (master, period, daily, actual payment) cannot currently be quantified and compared.
- Pay rules are complex and payroll data does not provide the granularity to identify the financial impact of scheduling and rostering decisions.
- Scenario modelling to optimise schedules and rosters has to rely on limited financial indicators (shift counts).
- There is a lack of financial reporting and the efficiency of scheduling and rostering functions is difficult to assess and manage.
- The objective of this project is to create a productivity costing model to enable better financial management of train crew labour costs.
Technical Architect/Project Manager
Mindtree Ltd.
07.2016 - 09.2018
- Company Overview: Sydney, Australia
- Project: Data Migration Project
- Client: Link Group, Sydney
- Role: Technical Architect managing a team of 4 developers and analysts
- Technologies & Skills: Informatica 10.1, SQL Server 11.0, Oracle 12.1
- Involved in migrations of Managed /Superannuation Funds data for the clients of Link Group.
- Managed a team of 4 developers and analysts to perform the below tasks: Designing the solutions for any migration for a new client.
- Perform Data Profiling and generating metrics on data quality, assessing metadata accuracy and understanding data challenges.
- Conducting Migration High level Analysis which involves intense analysis / agreement between the Business and the Data Analyst.
- Producing a data mapping Specification to facilitate the Informatica data load.
- Implementing the solution using Informatica, SQL Server and Oracle.
- Performing Systems, Business and End to End Testing.
- Analyzing issues, data with respect to the requirements.
- Participate in post migration maintenance activities for the implemented clients.
- Sydney, Australia
Senior Systems Analyst
FMR India
04.2006 - 06.2016
- Company Overview: Bangalore, India
- Technology & Skills: Business Analysis, Data/Systems Analysis, Business Intelligence: SSIS & SSRS, Oracle, PL/SQL, SQL Programming, Unix/Linux Shell Scripting, Informatica, Big Data, Hadoop, Hive, Sqoop, R, Knime, Rapid Miner, Tableau, Qlikview, MS Visio, Brio, MS Excel, MS Access, BI Publisher
- Using data and analytics to personalize incredible customer experiences and develop solutions that help customers live the lives they want.
- To perform research on customer's requirements and analyze their suitability for physical implementation.
- To participate in the logical design of the system with the onsite partners.
- To study the Customer warehouse Environment thoroughly and know the data relationships and hierarchies involved in various tables in the underlying data marts.
- To prepare System Design Specification Document mapped to the data requirements.
- Review of Requirement Analysis Documents, Technical Specification Document and business test cases.
- Verifying the data in Production and providing support during the UAT phase.
- Creating plan and pseudo codes for fixing the production issues through analysis.
- Maintaining various documents for each activity like Project Metrics, Requirement Traceability, Project Closure Report, Project Learning Report, Project Status Report and Root Cause Analysis Report, Support Cycles Statistics Reports, Incident Management Report.
- Coordinating between the on-shore and off-shore teams for task assignment and delivery.
- Conducting audits for all the quality related documents to enforce high quality standards for Internal Audits.
- Programming in Hive on Hadoop Big data warehousing platform for performing day-to-day maintenance activities and enhancements.
- Performing Proof of Concept on Data Science tools and technologies like R, Knime and Rapid Miner.
- Doing Visual Analytics using Tableau and Qlikview on the customer’s data.
- Mentoring the team members for systems and data knowledge acquired through the years of working on the system.
- Bangalore, India
Software Engineer
Steria
04.2005 - 04.2006
- Company Overview: Noida
- Worked on the project British Telecom as a database developer.
- Create SQL stored procedures packages, cursors and other database structures in Oracle environment to maintain the client data.
- Performing unit testing and systems testing on the developed code.
- Conducting system integration testing on the developed codes.
- Deploying the code in production.
- Maintaining documentation at each step in the project lifecycle.
- Working on SQL queries to pull the data.
- Creating Problem Management reports.
- Noida
Education
Program - Data Science and Machine Learning program: Making Data-Driven Decisions
MIT Institute For Data, Systems, And Society (IDSS)
06-2025
Masters - computer applications
Guru Govind Singh Indraprastha University
Delhi, IndiaBachelors - operations research & Statistics
Delhi University
Delhi, IndiaSkills
- SQL
- Data analysis
- Machine learning
- Predictive modeling
- Statistical methodologies
- Project management
- Stakeholder engagement
- Team leadership
- Problem-solving
- R
- Python
- Knime
- Rapid Miner
- Anaplan
- PowerBI
- Tableau
- Oracle Database
- AWS Redshift
- MS Azure
- Unix/Linux Platform
- Data Warehousing
- ETL - Informatica
Strengths
- Data, Systems Analysis & Research
- Regression and Prediction
- Deep Learning, Networking and Graphical Models
- Statistical techniques like Classification and Hypothesis Testing
- Forecasting Methodologies
- Strategize Optimal System processes
- Data Integration & Reporting
- Data Governance and Data Quality Management
- Programming & Technical Design
- Business, data and Visual Analytics
- Testing, debugging, diagnosing applications
- Good Communication Skills
- Stakeholder management
- Fast Learner
- Good Interpersonal Skills
- Project and people Management
- Automating the manual processes to solve business problems
Permanent Resident
Australia
Awards Recognition
- Earned second runner-up position in the Organization wide Data Hackathon for creating a product to discover business opportunities.
- You have Earned it Award for becoming the go to person for all of the analysis and Data Quality tasks.
- You have Earned it Award for doing an exceedingly good job to bring down to production data issues.
- Team Award for contributing more than 100% to keep the warehouse environment up and running.
- You have earned it award for consistent efforts, hard work, team spirit and willingness to go beyond the call of duty.
- You have earned it Award for efforts and contribution in the Informatica Migration project.
Timeline
A/ Senior Manager Insights and Advanced Analytics
Transport for NSW
04.2024 - 06.2025
Manager Insights and Statistics, Data and Analytics Safety, Policy, Environment and Regulation
Transport for NSW
02.2023 - Current
Manager Analytics and Data Management
KPMG Australia
09.2021 - 12.2022
Senior SQL Analyst
Sydney Trains
10.2018 - 09.2021
Technical Architect/Project Manager
Mindtree Ltd.
07.2016 - 09.2018
Senior Systems Analyst
FMR India
04.2006 - 06.2016
Software Engineer
Steria
04.2005 - 04.2006
Program - Data Science and Machine Learning program: Making Data-Driven Decisions
MIT Institute For Data, Systems, And Society (IDSS)
Masters - computer applications
Guru Govind Singh Indraprastha University
Bachelors - operations research & Statistics
Delhi University
Similar Profiles
Suzanne SmithSuzanne Smith
Ministerial Correspondent Team Leader, Administrative Assistant at Transport for NSW, Transport NSW, MinisterialMinisterial Correspondent Team Leader, Administrative Assistant at Transport for NSW, Transport NSW, Ministerial
SAJIT JACOBSAJIT JACOB
Senior Analyst at Transport for NSWSenior Analyst at Transport for NSW
Jack NewsonJack Newson
Road Maintenance Worker at Transport For NSWRoad Maintenance Worker at Transport For NSW
Sascha WiszniewskaSascha Wiszniewska
Case Manager, Coronial Court at Ministry of JusticeCase Manager, Coronial Court at Ministry of Justice
JOHN TRADJOHN TRAD
Associate for Astronomy (AFA) at Macquarie UniversityAssociate for Astronomy (AFA) at Macquarie University