Divya Siddareddy
Edmondson Park
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.
Around 15 years of commercial experience in Business Intelligence Expertise in Using Data Visualization tool – Tableau and Cognos.
Self-motivated, team Oriented, ability to handle multiple projects and meet deadlines with Strong Problem-Solving Skills. Exposure to Agile Methodologies and Complete Software Development Life Cycle (SDLC) Extensive experience in unit testing, system testing and performance testing
Overview
14
14
years of professional experience
1
1
Certification
Work History
Business Intelligence Specialist
Transport for NSW
07.2023 - Current
- Liaising with the large number of stakeholders in understanding the requirements for decommissioning legacy dashboards
- Creating the data models based on the requirements using Tableau PREP
- Analyzed patronage/transport related data and produced strategic dashboards for operational and Analytical purposes
- Updating the quarterly and Half yearly dashboards to be submitted to the Executives
- Performed unit testing on the dashboards
- Developed significant knowledge about the publish transport system
- Experience on Tableau 2023.2, 2024.3 and Tableau Prep
- Experience in AWS Lakehouse
- Developed stakeholder Management skills
Business Intelligence Manager
Westpac Group Pty Ltd
10.2022 - 07.2023
- Involved in dashboard development according to the business requirement
- Analyze project related data and produce dashboards for respective divisional managers
- Refreshing and Publishing month end reporting
- Respond to ad-hoc requests on data discrepancies to manage Data integrity
- Managing the admin tasks within the division
- Developed significant knowledge of Project Management
- Experience on Tableau 2021.4
- Developed stakeholder Management skills
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 datsources
- 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 reports 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
Skills
- Data Visualization Tools: Tableau
- OLAP Tools: Cognos v8, v10 BI Suite
- Database Languages: SQL
- Databases: AWS Lakehouse, Snowflake, Oracle, SQL Server, Postgres SQL
- Web Technologies: HTML, XHTML, CSS, JavaScript, XML
- ETL Tools: Datastage, Tableau Prep
- Repository Tool: GITHUB
- Scheduling Tool: Active Batch
- Service Management Tools: HP Service Manager, ITSM, Service Now, Assyst
- Defect Management Tools: HP Quality Center, Jira
- Content Management Tool: Windows SharePoint, Confluence
- MS Office: MS Access, Excel, Word, Power Point
Certification
- Tableau Certified Developer
- Azure Data Fundamentals Certification
- Oracle Database SQL Certified Expert
Timeline
Business Intelligence Specialist
Transport for NSW
07.2023 - Current
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
Bachelors - Information Technology
Jawaharlal Nehru Technological University
Masters - Professional Computing
University of South Australia
Similar Profiles
Pahlia KennyPahlia Kenny
Senior Manager, Programs – Motorways Integration Program at Transport for NSWSenior Manager, Programs – Motorways Integration Program at Transport for NSW
Hayden SutherlandHayden Sutherland
Civil Construction Worker at Transport For NSWCivil Construction Worker at Transport For NSW
Jay CrittendenJay Crittenden
Team Leader at Transport for NSWTeam Leader at Transport for NSW
DILEK SENGELDILEK SENGEL
Shared Services Consultant, Receivables and Payables, Corporate Services at TRANSPORT FOR NSWShared Services Consultant, Receivables and Payables, Corporate Services at TRANSPORT FOR NSW
SYED ALISYED ALI
STORE MANAGER at BOB JANE T-MARTSSTORE MANAGER at BOB JANE T-MARTS