Srinivasa Koppolu
Brisbane,Australia
Summary
23 Years of IT experience (Data engineering, Team management, Technical hands-on), Possess exceptional Stakeholder management, communication and presentation skills. AWS Certified cloud practitioner. Professional scrum Master certification (From scrum.org). Teradata certified Master.
Overview
23
23
years of professional experience
1
1
Certification
Work History
Data Engineering Lead
Australian Bureau of Statistics
Brisbane, QLD
05.2022 - Current
- Team Leadership: Led a cross-functional team of Public Service staff and contractors to deliver the QBIS V1 and V2 releases, as well as the QBIS-ASP integration projects; currently leading the CPI-IMM (Consumer Price Index – Index Methods and Modules) initiative.
- Project Delivery: Delivered end-to-end solutions for QBIS and ASP-QBIS integration using YAML and AWS CDK for infrastructure as code, pytest for automated testing, AWS Step Functions for orchestration, and Python-based AWS Lambdas for data engineering. Currently contributing to the CPI-IMM project leveraging Python, R, and AWS services.
- Change, Agile & Project Management: Oversaw sprint planning, release cycles, code and design reviews, and stakeholder engagement. Facilitated Scrum ceremonies to drive team collaboration and transparency. My role involves conducting performance reviews and team guidance.
- Security & Governance: Collaborated with security teams on application assessments, guided change management processes, participated in enterprise architecture forums, and conducted technical interviews to support talent acquisition at ABS.
Technical Specialist & Data Engineer
Department of Transport and Main Roads
Brisbane, QLD
05.2017 - 04.2022
- Project Delivery: Designed and developed ETL pipelines using Infosphere DataStage and authored Cognos reports for legacy systems. Successfully ingested Registration & Licensing data into an AWS-Snowflake environment using AWS Glue, Python, Matillion, and Snowflake. Recognized with the CUBIE Award by the CTO of the Department of Transport and Main Roads for this accomplishment.
- Data Integration & Maintenance: Managed BAU activities, maintenance requests, and ETL development in the Enterprise Business Intelligence (EBI) team using Infosphere DataStage.
- Cloud Migration Strategy: Authored a white paper outlining the roadmap for transitioning on-premise legacy systems to an AWS cloud infrastructure.
- Security & Compliance: Partnered with the TMR Information Security team to ensure secure handling of Personally Identifiable Information (PII) within the AWS ecosystem.
- Solution Design & Delivery: Developed solution design documentation and executed cloud migrations for core systems including SBS Booking, Driver Examination, Disability Parking Permit, and Direct Debit Registration Renewal. Successfully deployed applications such as SBS Booking, E-Correspondence, Vehicle Inspection, and DocTrak to production.
- Agile Leadership: Served as Scrum Master for the EBI team, leading Agile ceremonies, sprint planning, backlog refinement, Jira card prioritization, and Kanban management.
- Reporting & Mentorship: Maintained and enhanced Cognos reports and Power BI dashboards. Mentored new team members on business workflows, application architecture, development standards, and project delivery, while also providing technical support to meet SLAs and delivery timelines.
Developer
Suncorp Banking & Insurance
Brisbane, QLD
03.2014 - 05.2017
- Project Delivery: Contributed to key Suncorp Insurance initiatives, including CCH, Pinnacle Home & Motor, and Chief Data Office (CDO) applications.
- ETL Solution Design: Designed ETL solutions aligned with Suncorp’s insurance data model for the CCH and Pinnacle projects, ensuring robust data flow and system integrity.
- Netezza Development & Standards: Authored Netezza SQL development guidelines and coding standards; developed ETL solutions driving Cognos and Tableau insights for CCH and Pinnacle Home & Motor.
- Dashboard Development: Built the iRec dashboard using Cognos Report Studio and Netezza SQL, enhancing business reporting capabilities.
- Agile Leadership: Led agile delivery teams and managed onsite-offshore coordination to streamline development and ensure timely delivery.
- Maintenance & Reporting Support: Handled maintenance of Tableau reports under the Chief Data Office; developed Cognos semantic layers including Insight layers, facts, dimensions, DMR models, and drill-through reports using Netezza.
- Custom Report Development: Delivered specialized reports such as Vector, Loss Cause, Large Loss, and Marine reports for the CCH project.
Technical Lead & Developer
ANZ Banking Group
Melbourne, VIC
06.2013 - 12.2013
- ETL Design & Development: Led ETL design and implementation for HR-RSDS and FSDIM (Financial Services Data Integration Model) modules using Infosphere DataStage. Contributed to projects aligned with the IBM Banking Data Warehouse and Financial Services Data Integration models.
- Requirement Analysis: Partnered with solution designers to analyze business and technical requirements and translate them into scalable ETL solutions for the HR-RSDS project.
- Job Development: Designed and built robust DataStage jobs for HR-RSDS and FSDIM across multiple releases, including HR-RSDS 1A, 1B, 2, and 3, ensuring data integrity and performance.
- Technical Leadership: Led a development team through planning, scheduling, coordination, and root cause analysis. Supported both System Testing (ST) and User Acceptance Testing (UAT), and conducted code reviews to maintain quality standards.
Technical Specialist & Developer
IBM
Hyderabad, India
02.2010 - 06.2013
- ETL Design & Development: Led ETL architecture and implementation for ComSeg Release 1 & 2 and Velocity CDW projects. Created comprehensive source-to-target mappings and detailed design documentation for seamless data integration.
- Informatica Development: Built and deployed ETL workflows using Informatica for ComSeg releases, Velocity CDW, and AMS work requests, ensuring data integrity and system performance.
- Teradata Technical Leadership: Served as Teradata lead, providing end-to-end technical solutions across multiple projects. Facilitated cross-project collaboration, work breakdown structuring, and design sharing.
- Teradata Scripting & Data Security: Developed advanced Teradata scripts for Customer, Mortgage, and Deposits domains within the Bank of America initiative. Delivered security and privacy views, automated snapshot generation, and managed stats collection to support compliance and performance.
- Teradata Administration & Optimization: Produced analytics reports for space, user, and CPU utilization using dictionary tables. Leveraged Teradata Viewpoint for performance diagnostics. Tuned queries and recommended index strategies. Engineered the Rock & Roll process for automated code migration and created a custom “Teradata Compression Analysis” tool to streamline compression, elevate performance, and reduce storage overhead.
Sr. Developer
Tech Mahindra
Pune, India
11.2006 - 01.2010
- Informatica ETL Development: Designed and implemented complex Informatica mappings for SC4LS, CCPM, and Bundles projects. Tuned performance at source, target, transformation, and session levels. Created reusable worklets and employed control tasks such as event raise/wait, decision, and email notifications.
- Team Leadership & Onsite Coordination: Served as onsite-offshore coordinator and ETL developer for the AT&T Bundles project while stationed at the client site in the USA. Led a team of 10 developers in the successful delivery of the CCPM project.
- Performance Optimization: Engineered and fine-tuned Teradata scripts to streamline data extraction from AT&T’s enterprise data warehouse. Enhanced overall ETL performance in SC4LS and Bundles by optimizing Informatica and Teradata processes.
- Design & Documentation: Created comprehensive high-level and detailed design documents, along with unit test plans, for SPDR, SC4LS, Bundles, and CCPM initiatives. Designed ETL architecture diagrams using MS Visio.
- Automation & Support: Automated reporting for production support processes using Unix shell scripting, incorporating advanced AWK logic for efficient data processing.
Software Engineer
Teradata Corporation
Hyderabad, India
03.2004 - 10.2006
- Teradata Utilities Development: Designed and developed Teradata utility scripts (FastExport, BTEQ, FastLoad, MultiLoad) to support large data volumes (over 2 GB), user-defined functions, checkpoint restart, and multi-character set environments. Automated Teradata Parallel Transporter (TPT) scripts using Unix shell scripting for streamlined data transport.
- Client-Focused Issue Resolution: Resolved complex Teradata utility issues for high-profile clients including Intel, Vodafone UK, and Walmart, ensuring minimal downtime and high customer satisfaction.
- Cross-Platform Migration: Migrated Teradata utility scripts across diverse operating systems such as IBM-AIX, HP-UX, Solaris, Windows, Unix MP-RAS, and Linux. Upgraded Teradata Warehouse Builder scripts from version 5.0 to Teradata Parallel Transporter 8.0.
- Server & Client Utility Expertise: Utilized Teradata server utilities including Vproc Manager, PDE, Schmon, Pmon, and TPA; proficient with client tools such as Teradata Administrator, Teradata Manager, ARC, and data recovery utilities.
Systems Programmer
Electronics Corporation of India Limited
Hyderabad, India
09.2002 - 02.2004
- Project Delivery: Developed software for X-Ray baggage inspection systems, programming in C to implement image processing algorithms including Laplacian and Gaussian filters.
- UI Development: Designed and built the front-end interface for a portable X-Ray inspection system using Visual C++ 6.0, enhancing user accessibility and system usability.
- Cross-Platform Code Porting: Ported core system code across multiple hardware configurations, ensuring stability and performance in diverse deployment environments.
Education
Masters - computer applications
Osmania University
Bachelors - computer science
Osmania University
Skills
- Cloud migration
- Data governance
- Agile project management
- ETL development
- Data pipeline design
- Matillion
- Informatica PowerCenter
- IBM Infosphere DataStage
- Teradata tools & utilities
- IBM-Cognos
- Tableau
- Power BI
- Teradata
- Oracle
- Netezza
- Snowflake
- PostGres
- Python Programming
- Unix Shell scripting
- AWS tools & technologies
- Stakeholder engagement
- Data integration
- Team leadership
Awards
1. TSD Excellence award for CPI-IMM project - Australian Bureau of Statistics
2. Cubie Award, Highly commended award from the CTO for RNLS AWS cloud ingestion work. Department of Transport & Main Roads, Queensland Government.
3. Suncorp - Star of the month award (twice)
References
Available on request
Security Clearance
Baseline security clearance (Australian Government Security Vetting Agency)
Personal Information
Citizenship: Australian Citizen
Certification
- AWS Certified Cloud practitioner
- Professional Scrum master from scrum.org
- Teradata certified master
Timeline
Data Engineering Lead
Australian Bureau of Statistics
05.2022 - Current
Technical Specialist & Data Engineer
Department of Transport and Main Roads
05.2017 - 04.2022
Developer
Suncorp Banking & Insurance
03.2014 - 05.2017
Technical Lead & Developer
ANZ Banking Group
06.2013 - 12.2013
Technical Specialist & Developer
IBM
02.2010 - 06.2013
Sr. Developer
Tech Mahindra
11.2006 - 01.2010
Software Engineer
Teradata Corporation
03.2004 - 10.2006
Systems Programmer
Electronics Corporation of India Limited
09.2002 - 02.2004
Masters - computer applications
Osmania University
Bachelors - computer science
Osmania University
Similar Profiles
Takako WakiyamaTakako Wakiyama
Data Analyst at Australian Bureau of StatisticsData Analyst at Australian Bureau of Statistics
Janet BarsbyJanet Barsby
Field Interviewer at Australian Bureau Of StatisticsField Interviewer at Australian Bureau Of Statistics
Arno HagenArno Hagen
APS3 Producer Prices and International Trade Index at Australian Bureau of StatisticsAPS3 Producer Prices and International Trade Index at Australian Bureau of Statistics
Joseph ElakloukJoseph Elaklouk
Application Support Analyst at HumanforceApplication Support Analyst at Humanforce
Connor GolbyConnor Golby
Factory Worker at B&R EnclosuresFactory Worker at B&R Enclosures