Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Divya Siddareddy

Data Enthusiast/BI Specialist
Edmondson Park,NSW

Summary

Looking forward to an opportunity in a challenging environment, where I can utilize my experience and skills in contributing effectively to the success of the organization and for the improvement of my personal skills. Business Intelligence Expertise with extensive experience in data analysis and dashboard development using Tableau and Cognos to support the business decisions. Working knowledge of Python to create extracts for the large data set and hands on SQL using different databases from traditional to modern cloud technologies. Self-motivated, team Oriented, ability to handle multiple projects and meet deadlines with Strong Problem- Solving Skills. Exposure to Agile and waterfall Methodologies and always ready to take up the new challenges.

Overview

15
15
years of professional experience
3
3
Certifications

Work History

Business Intelligence Specialist

Transport For NSW
Sydney
07.2023 - 06.2025
  • Worked as a technical SME, leading a team of three high-performing developers.
  • Liaising with a large number of stakeholders and working closely with the business analysts to understand the requirements and produce the data solutions.
  • Creating the data models based on the requirements using Tableau Prep.
  • Analyzed patronage, transport-related data, and produced sophisticated dashboards using predictive modeling for operational and analytical purposes within tight timelines.
  • Developed end-to-end scalable solutions to meet the requirements of the wider stakeholders.
  • Conducting root cause analysis for all the data-related issues and implementing the reliable solution.
  • Trained new analysts on best practices for research, analysis, and report-writing techniques, increasing overall team efficiency.
  • Developed significant knowledge about the public transportation system.
  • Standardized best practices to ensure consistency across the department.

Business Intelligence Manager

Westpac Group Pty Ltd
10.2022 - 07.2023
  • Involved in dashboard development according to the business requirements.
  • Analyze project-related data and produce dashboards for respective divisional managers.
  • Identify and interpret the trends and patterns from the complex data sets.
  • Refreshing and publishing month-end reporting.
  • Respond to ad-hoc requests regarding data discrepancies to manage data integrity.
  • Performing the root cause analysis and implementing the data solutions.
  • Managing the admin tasks within the division.
  • Developed significant knowledge of project management.

Analyst, Engineer

Insurance Australia Group Pty Ltd
07.2014 - 09.2022
  • Tableau SME – helping the users with dashboard development by following the best practices.
  • Involved in dashboard development according to the business requirement.
  • Primary contact for all the Tableau ops requests including creating the project, migration of dashboards and datasources.
  • Tableau Administration – Access provisioning and Managing projects.
  • Migrating Tableau workbook and datasources.
  • Scheduling the datasources as per business requirements.
  • Monitoring the Scheduled jobs every morning.
  • Highly involved in identifying the data discrepancies by doing root cause analysis by using analysis techniques.
  • Developed significant knowledge of Insurance Business.
  • Experience on Tableau V9, 10, 2020.4.
  • Exposed to Python scripting Language.
  • Developed stakeholder Management skills.

BI Systems Analyst

Wesfarmers Insurance Pty Ltd
12.2013 - 06.2014
  • Support lead - First point of contact for all the operational issues and then assign the jobs to the right team members for the resolution.
  • Tableau Administration – Granting Access.
  • Managing projects and users access for both PROD and UAT environments.
  • Deploying Tableau workbook and datasources.
  • Scheduling the datasources as per business requirements.
  • Monitoring the Scheduled jobs every morning.
  • Cognos Administrator – Granting the Cognos access and managing the Cognos licenses.
  • Creating data sources, managing and deploying the content into the IBM Cognos Connection.
  • Running Monthly ETL jobs and Month end Schedules in Datastage.
  • Monitoring Daily, weekly and Monthly ETL and Cognos jobs.
  • Involving in the projects whenever required.
  • Developing Reports by using Report Studio.
  • Writing SQL queries against Oracle database to check the data integrity.
  • Developing reports using Cognos Workspace Advanced to check the data integrity within the data warehouse.
  • Unit testing, system testing and performance testing.
  • Defect Management and Bug Fixing.
  • Deploying the reports and packages.
  • Scheduling the reports as per business needs.
  • Developed significant knowledge of Insurance Business.
  • Experience on Tableau V9, 10.
  • Exposed to Cognos v10.2.1 BI Suite.
  • Developed stakeholder Management skills.
  • Attained working knowledge of Datastage v8.5.

Business Intelligence Analyst

RACQ Insurance
03.2013 - 08.2013
  • Analyzing business requirements and documenting functional and technical specifications.
  • Liaising directly with the stakeholders to get the clear understanding of the report requirements.
  • Modeling Metadata using Framework Manager and publishing the packages.
  • Implementing Cognos security in Framework Manager.
  • Assisting in designing databases, data warehouse and data marts to ensure interoperability.
  • Creating data sources, managing and deploying the content into the IBM Cognos Connection.
  • Developing Reports by using Report Studio.
  • Developing Complex reports by using Conditional blocks, Page set, Section, Render Variable and Cascading prompts.
  • Writing SQL queries against Oracle database to check the data integrity.
  • Developing reports using Cognos Workspace Advanced to check the data integrity within the data warehouse.
  • Unit testing, system testing and performance testing.
  • Defect Management and Bug Fixing.
  • Deploying the reports and packages.
  • Scheduling the reports as per business needs.
  • Developed significant knowledge of Insurance Business.
  • Exposed to Cognos v10.2 BI Suite.
  • Developed strong problem-solving skills.
  • Implemented best practices to improve the performance of the reports.

Business Intelligence Analyst

Cubic Transportation Systems
04.2012 - 03.2013
  • Gathering and documenting business requirements.
  • Modelling Metadata using Framework Manager and publishing the packages.
  • Creating data sources, managing and deploying the content into the IBM Cognos Connection.
  • Developing Ad-hoc requests using Query Studio.
  • Providing Data requests to the business.
  • Developing the simple to complex Reports using Report Studio.
  • Developing reports using report functionalities like Conditional formatting, Master Detail relationships, Drill up, drill down, drill through and Conditional Blocks.
  • Writing SQL queries against Oracle database to check the data integrity.
  • Unit testing, system testing and performance testing.
  • Defect Management and Bug Fixing.
  • Deploying reports and Packages.
  • Scheduling the reports based on the user requirements.
  • Responsible for the successful implementation for Migration project which is very prominent project in Cubic's history.
  • Worked on numerous back to back high-profile projects.

BI Developer

Simplot Australia Pty Ltd
12.2010 - 03.2012
  • Involving in requirements gathering and documenting business requirements.
  • Modelling Metadata using Framework Manager and Transformer.
  • Implementing security and publishing the packages.
  • Creating data sources, managing and deploying the content into the IBM Cognos Connection.
  • Developing the reports using Report Studio based on the business requirements.
  • Analysing data using SQL Server, Query and Analysis Studio.
  • Scheduling the reports in event studio.
  • Developing complex reports using Report studio and analysis Studio.
  • Developing dashboards and reports using report functionalities like Master Detail relationships, Conditional formatting, Render variable, Conditional Blocks, Drill through and MDX Functions.
  • Unit testing and data validation of Reports.
  • Defect Management and Bug Fixing.
  • Obtained knowledge using MDX functions.
  • Obtained knowledge of Cognos v10 Suite.
  • Was appreciated by managers for my quick response on the critical production issues.

Education

Masters - Professional Computing

University Of South Australia
01.2008 -

Bachelors - Information Technology

Jawaharlal Nehru Technological University
01.2006 - undefined

Skills

  • Tableau and Tableau Prep

  • Power BI

  • AWS Lakehouse

  • Snowflake

  • Python

  • Oracle

  • SQL Server

  • Postgres SQL

  • Cognos v8

  • Cognos v10 BI Suite

  • Datastage

  • GITHUB

  • Active Batch

Certification

Tableau Certified Developer

Timeline

Business Intelligence Specialist

Transport For NSW
07.2023 - 06.2025

Business Intelligence Manager

Westpac Group Pty Ltd
10.2022 - 07.2023

Analyst, Engineer

Insurance Australia Group Pty Ltd
07.2014 - 09.2022

BI Systems Analyst

Wesfarmers Insurance Pty Ltd
12.2013 - 06.2014

Business Intelligence Analyst

RACQ Insurance
03.2013 - 08.2013

Business Intelligence Analyst

Cubic Transportation Systems
04.2012 - 03.2013

BI Developer

Simplot Australia Pty Ltd
12.2010 - 03.2012

Masters - Professional Computing

University Of South Australia
01.2008 -

Bachelors - Information Technology

Jawaharlal Nehru Technological University
01.2006 - undefined
Divya SiddareddyData Enthusiast/BI Specialist