Puttur Raghavendra Kamath (Raghu)
Keysborough,VIC
Summary
Accomplished Senior Data Architect with over 20 years of experience leading the design, implementation, and optimisation of enterprise data ecosystems. Specialized in developing modern data architectures, enterprise data warehouses, business intelligence platforms, and strategic data roadmaps that enable digital transformation and operational excellence. Strong expertise in Power BI, Data Modelling, Data Migration, Data Governance, Data Quality Management, Database Administration, and Data Security. Adept at collaborating with executive stakeholders and cross-functional teams to deliver scalable, secure, and business-aligned data solutions that unlock actionable insights and drive organizational growth.
Overview
23
23
years of professional experience
Work History
Senior Data Architect
City of Port Phillip
St Kilda, VIC
11.2016 - Current
- Translated business objectives and requirements into scalable technical solutions for Enterprise Data Warehousing, Data Integration, and Real-Time Data Streaming platforms.
- Defined and governed enterprise data architecture standards, frameworks, and best practices, encompassing data modeling, security, governance, master data management (MDM), and reference data management.
- Collaborated with business stakeholders, executive leadership, technology teams, vendors, and strategic partners to align data initiatives with organizational objectives.
- Played a key role in shaping the organization's Data Strategy and Technology Roadmap, driving innovation through the adoption of modern data platforms, analytics capabilities, and emerging technologies aligned with strategic business goals.
- Advised senior management on technology investments, business cases, and budget planning for modern data platforms, analytics capabilities, and infrastructure enhancements.
- Architected and delivered an enterprise-scale Data Warehouse integrating data across 15+ core business domains, providing a single source of truth for reporting and analytics.
- Supported organizational capability development by mentoring team members, onboarding new employees, and promoting data architecture best practices.
- Designed and developed enterprise reporting and analytics solutions using Power BI, enabling data-driven decision-making through interactive dashboards and executive-level insights.
- Champion Agile delivery practices across data and analytics initiatives, successfully leading strategic projects including Finance Insights, Parking Insights, Active Directory Integration, and enterprise reporting solutions.
- Designed end-to-end data migration architectures for core business systems, ensuring data quality, integrity, governance, and minimal business disruption.
- Delivered enterprise data quality solutions, including data cleansing, matching, and deduplication frameworks to improve data accuracy and consistency across systems.
- Managed and governed the organization's SQL Server ecosystem, ensuring database performance, security, availability, backup, recovery, and operational excellence.
- Led technical teams through effective stakeholder engagement, resource planning, mentoring, and performance management, fostering a culture of continuous improvement and collaboration.
BI Consultant
Nigel Frank
Melbourne, VIC
08.2016 - 11.2016
- Designed, developed, and delivered enterprise-grade SSRS reports and reporting solutions, enabling stakeholders to access accurate and actionable business insights.
- Conducted detailed analysis of multiple source systems, including MySQL databases, to define data extraction, transformation, and integration requirements.
- Developed, optimised, and maintained ETL processes and data integration packages, ensuring reliable, scalable, and high-quality data movement across systems.
- Architected and developed a .NET-based web portal to streamline data capture and automate report generation processes for business users.
- Acted as a key liaison between business and technical stakeholders, effectively gathering requirements, communicating project progress, and ensuring successful delivery of reporting and analytics solutions.
- Designed and implemented Tabular Data Models and developed interactive Power BI dashboards and reports to support strategic and operational decision-making.
- Integrated Azure Active Directory (Azure AD) authentication and authorisation with SSRS reporting platforms, strengthening enterprise security and user access management.
- Designed and implemented Role-Based Security (RLS) across SQL Server, SSRS, and Power BI environments, ensuring secure and compliant access to sensitive business data.
BI Consultant
Ajilon
Melbourne, VIC
06.2016 - 08.2016
- Designed, developed, and maintained robust ETL processes and data integration packages, ensuring efficient, accurate, and scalable movement of data across multiple business systems.
- Conducted comprehensive analysis of source systems, including Oracle and Teradata, to define data extraction, transformation, and integration requirements for enterprise data solutions.
- Played a key role in the analysis, design, and implementation of a pricing system, collaborating with business stakeholders to translate complex business requirements into effective technical solutions.
- Served as the primary liaison between business and technical stakeholders, facilitating requirements gathering, project communications, and the delivery of timely and accurate project updates.
BI Consultant
Velrada
Adelaide, SA
03.2016 - 05.2016
- Designed, developed, and maintained robust ETL solutions and data integration frameworks, ensuring reliable, high-quality, and timely data movement from multiple source systems into the enterprise data warehouse.
- Designed and implemented Tabular Models and dimensional data warehouse structures to support high-performance reporting, self-service analytics, and enterprise business intelligence requirements.
- Developed and delivered SSRS reports, OLAP cube-based analytics, and interactive Power BI dashboards, enabling business users and leadership teams to make informed, data-driven decisions.
- Supported, enhanced, and optimized the organization's centralized Enterprise Data Warehouse, delivering a trusted and scalable platform that integrated and reported on core business processes across the organization.
- Collaborated closely with business stakeholders, project teams, and senior management to gather requirements, communicate project progress, and deliver solutions aligned with business objectives.
- Performed database administration and operational support for the organisation's data platform, including SQL Server databases, data warehouses, SQL Agent jobs, and SSIS packages, ensuring high availability, performance, security, and reliability.
BI Developer and Business Analyst
World Vision Australia
Burwood, VIC
04.2015 - 02.2016
- Supported, enhanced, and maintained the organisation's centralised Enterprise Data Warehouse, providing a scalable and trusted platform for reporting, analytics, and business decision-making.
- Designed, developed, and maintained ETL solutions to extract, transform, and load data from legacy CRM systems into the enterprise data warehouse, ensuring data quality and consistency.
- Optimised the performance of SSIS packages, SSAS cubes, Power BI dashboards, and reporting solutions, improving data processing efficiency and user experience.
- Designed, developed, and enhanced SSAS Multidimensional and Tabular Models to support complex analytical and business intelligence requirements.
- Developed and delivered SSRS reports leveraging cube-based and warehouse data, providing actionable insights to business users and management.
- Designed and implemented PerformancePoint and Power BI dashboards, enabling self-service analytics and executive-level reporting from enterprise data platforms.
- Worked within Agile delivery frameworks, collaborating with cross-functional teams to deliver high-quality data and analytics solutions through iterative development cycles.
- Performed business and data analysis activities, translating stakeholder requirements into scalable data architecture and reporting solutions.
- Collaborated closely with business stakeholders, project teams, and management to gather requirements, communicate project outcomes, and ensure successful solution delivery.
- Contributed to process improvement initiatives and the design of new data integration solutions, including CRM platforms such as Salesforce, enhancing data accessibility and business intelligence capabilities.
- Administered and supported the organisation's SQL Server ecosystem, including databases, data warehouses, SQL Agent jobs, SSIS packages, backup strategies, and performance tuning to ensure platform reliability and availability.
Team Leader
Accenture
Benguluru India
08.2008 - 01.2015
- Designed and implemented end-to-end ETL solutions to migrate and integrate data from Oracle and other source systems into enterprise SQL Server Data Warehouse environments.
- Analyzed existing systems and business processes, identified performance bottlenecks and functional gaps, and recommended scalable data and reporting solutions.
- Led the design and development of enterprise data warehousing, business intelligence, and analytics solutions aligned with business and operational requirements.
- Developed and enhanced robust SSIS frameworks, ETL processes, and data integration standards to improve maintainability, scalability, and operational efficiency.
- Designed dimensional data models and data warehouse architectures to support reporting, analytics, and strategic decision-making across the organization.
- Developed executive dashboards, KPI scorecards, and data visualisations that provided actionable business insights for management and stakeholders.
- Performed data profiling, reconciliation, cleansing, and quality assurance activities to ensure the accuracy, consistency, and integrity of enterprise data assets.
- Optimized the performance of ETL processes, databases, reports, and analytical solutions through proactive performance tuning and continuous improvement initiatives.
- Collaborated closely with business users, project managers, and technical stakeholders to gather requirements, communicate project progress, and deliver successful outcomes.
- Provided technical leadership throughout the SDLC, including solution design, code reviews, testing, defect resolution, UAT support, production deployment, and post-implementation support.
- Managed and mentored development teams, conducted knowledge transfer sessions, supported capability development, and participated in recruitment and technical interviews.
- Administered and supported enterprise platforms including SQL Server, SSIS, TFS, SQL Agent Jobs, and Data Warehouse environments, ensuring system reliability, security, and operational excellence.
Team Leader
Transgraph Consulting Pvt Limited
Hyderabad India
03.2004 - 08.2008
- Played a key role in the successful delivery of the Create Client implementation, contributing to solution architecture, development, testing, and deployment activities.
- Collaborated closely with business stakeholders and project teams to gather requirements, communicate project progress, and provide reporting metrics and analytical insights.
- Designed and developed logical and physical data models, ensuring alignment between business requirements, technical architecture, and SDLC best practices.
- Produced comprehensive functional and technical design documentation, translating complex business requirements into scalable technical solutions.
- Developed, reviewed, tested, and optimized application code while executing comprehensive test plans to ensure solution quality and reliability.
- Conducted code reviews and enforced development standards, ensuring compliance with design specifications, coding best practices, and organizational guidelines.
- Participated in the design and development of Data Warehouse and Data Mining solutions, enabling the identification of business trends, patterns, and key performance metrics for management and clients.
- Implemented and supported controlled deployment processes, ensuring smooth releases, system stability, and successful production implementations.
- Worked with third-party data visualisation platforms, including Dundas, to develop interactive dashboards and reporting solutions that enhanced business intelligence capabilities.
- Supported the administration and maintenance of application and database servers, ensuring high availability, performance, security, and operational reliability.
Education
Bachelor of Engineering - Mechanical Engineering
M S Ramaiah Insitute of Technology
Bengaluru India09-2001
Skills
- Data warehousing solutions
- ETL development
- Data migration strategies
- Data migration
- Data quality management
- Data governance
- Data security
- Business intelligence
- Team leadership
- Teamwork and collaboration
Timeline
Senior Data Architect
City of Port Phillip
11.2016 - Current
BI Consultant
Nigel Frank
08.2016 - 11.2016
BI Consultant
Ajilon
06.2016 - 08.2016
BI Consultant
Velrada
03.2016 - 05.2016
BI Developer and Business Analyst
World Vision Australia
04.2015 - 02.2016
Team Leader
Accenture
08.2008 - 01.2015
Team Leader
Transgraph Consulting Pvt Limited
03.2004 - 08.2008
Bachelor of Engineering - Mechanical Engineering
M S Ramaiah Insitute of Technology