Yasaswini Bandi

KEY ACHIEVEMENTS:

• Strategic Digital Alignment: Directed the development of technical roadmaps and architectures for large-scale digital transformation projects, ensuring alignment with business goals, and driving measurable outcomes such as improved operational efficiency.
• Data Architecture Excellence: Designed and implemented scalable, secure data infrastructures, including leading the integration of Azure, Snowflake, and legacy data warehouse solutions to deliver a comprehensive, future-ready data architecture.
• Product Management: I took full ownership of Oracle Data Appliance (ODA) and Oracle Database products, overseeing all aspects from license management to the complete lifecycle of ODAs. Including working closely with technical and leadership teams to assess and communicate risks related to the ODA lifecycle, and performing an in-depth cost analysis, I created a strategic roadmap for ODA infrastructure hosting, resulting in a nearly 40% reduction in costs.
• Innovative Team Leadership: Initiated continuous learning programs, and facilitated cross-team knowledge-sharing sessions, enhancing team performance by 20%, while fostering a culture of innovation and professional growth.
• Stakeholder Collaboration & Communication: Successfully navigated complex capability landscapes, collaborating with senior stakeholders, program directors, and vendors to deliver projects aligned with both technical and business objectives. Regularly represented architectural solutions in governance forums, securing organizational buy-in, and alignment.
• Recognition & Impact: Delivered innovative, centralized solutions that can be adopted for a national pattern across New Zealand's District Health Boards (DHBs), receiving commendations for excellence in architectural design.

DAY TO DAY RESPONSIBILITIES:

• Designed and delivered sustainable technical solutions for ICT projects, focused on meeting digital and environmental objectives.
• Ensured compliance with Architecture Governance standards for all solutions at both the DHB and regional levels.
• Completed security assessments for multiple projects, ensuring adherence to security policies and timelines.
• Collaborated with regional and national health architecture forums to drive alignment in architecture and solutions across New Zealand.
• Provided trusted technical advice to subject matter experts, fostering confidence in ICT solutions.
• Collaborated with stakeholders, program directors, team leads, and vendors to align ICT solutions with project strategies and key performance indicators.
• Facilitated design and architecture discussions during sprint planning and daily stand-ups, providing technical guidance to development teams.
• Collaborated with cross-functional Agile teams to design and implement technical solutions that meet product goals and business requirements.
• Developed business cases for ICT solutions, conducting options analysis and feasibility studies.
• Engaged vendors to clarify designs and ensure compliance with agreed specifications and standards.
• Supported ICT governance by participating in design and project reviews and served on the Architecture Governance Board.
• Represented solutions at Change Advisory Board reviews at DHB and regional levels. Created and maintained design standards and guidelines, supporting consistency across projects.
• Participated in policy, standards, and procedure development to enhance operational efficiency.

PROJECTS HIGHLIGHTS: Projects where I delivered beyond day-to-day responsibilities, driving innovation, efficiency, and business value.
AZURE Cloud Migration Project:

• Collaboratively led the design and delivery of a scalable data infrastructure and end-to-end migration of applications to Azure, resulting in a reduction in infrastructure costs and improved performance.
• Initiated continuous learning programs and knowledge-sharing sessions within the team, resulting in a 20% improvement in delivery times.
• Identified and met with stakeholders to gather requirements and understand business needs.
• Assessed existing data, infrastructure, applications, and cloud usage, and established clear goals and success criteria for the cloud solution.
• Created a comprehensive document detailing the proposed architecture, Landscape of applications including diagrams and descriptions of components.
• Developed clear and accessible patterns that optimize decision-making processes, driving better outcomes and increased collaboration.
• Designed and implemented Azure architecture for scalable applications and databases utilizing Azure services such as Functions, Managed Instance SQL DB and Storage.
• Designed a disaster recovery plan using Azure Site Recovery for critical applications, ensuring business continuity and compliance.
• Developed and executed cloud governance policies, ensuring compliance with industry standards and enhancing security posture.

ODA Upgrade Project

• Took end-to-end ownership of the Oracle Database Appliance (ODA) upgrade project, serving as SME, technical lead, and commercial liaison.
• Delivered key insights and performed comprehensive option analysis to support effective stakeholder decision-making during organizational transitions.
• Contributed to technical requirements, financial planning, and vendor discussions, ensuring alignment with strategic objectives.

Scope (OP Notes & Clinical Audit) Project

• Collaborated closely with stakeholders to define and confirm project scope, enabling the project to progress to the implementation phase.
• Influenced key decision-makers to adopt standardized operational note processes across Capital Coast and Hutt Valley Districts, improving consistency and efficiency.

Radiation Treatment Projects

• Successfully delivered high-impact healthcare projects, including SunCHECK and RadMachine, within scope and on time.
• Ensured seamless coordination across clinical and technical teams, maintaining quality and regulatory standards throughout execution.

• Managed and monitored databases for Wairarapa, Hutt Valley, and Capital Coast DHBs, overseeing BAU tasks and cloud migration for 2,000+ SQL and Oracle databases.
• Led database security and lifecycle management for CCDHB, ensuring data safety through proactive patching and high-availability solutions.
• Designed SQL Server high availability with Always On Availability Groups, log shipping, and replication; implemented Azure Data Sync to support reporting.
• Handled data migrations, upgrades, and performance optimization for SQL and Oracle databases.
• Developed and deployed efficient ETL pipelines using SSIS for data transformation and loading.
• Established T-SQL best practices while maintaining database naming and coding standards.
• Authored technical documentation and deployment guides to streamline database operations.
• Collaborated with cross-functional teams in agile environments to enhance data pipelines and improve app designs.
• Coordinated with development teams to optimize database queries and indexes.
• Established security controls to help protect systems.
• Ensured that all the stored procedures are optimized for better performance of the system.

• Implemented ITIL framework for Incident, Change, and Problem management across design and database tasks.
• Provided operational support for data platforms and database management systems, ensuring seamless execution in diverse time zones.
• Executed database upgrade projects for UK clients, enhancing system performance.
• Monitored production transactional databases and implemented Performance Tuning strategies to optimize efficiency.
• Managed Change Data Capture (CDC) solutions to improve data tracking and integrity.
• Ensured data integrity and security through robust backup and recovery processes.
• Maintained high availability of production databases using mirroring, clustering, log shipping, and replication techniques.
• Developed best practices for T-SQL, database naming conventions, and coding standards with infrastructure teams.

• Executed effective implementation of incident response, change, and problem management for seven clients within UK DCS.
• Provided 24/7 on-call support for MS SQL database servers across multiple clients.
• Conducted routine database management tasks, including job scheduling, log monitoring, and space management.
• Managed SQL Server installations and service pack updates in standalone and cluster environments.
• Secured SQL Server by overseeing logins, user permissions, and audit logs.
• Acquired expertise in managing Oracle database technologies to support diverse client needs.
• Responded to client requests as part of project support team through inbound calls and ticketing systems.
• Demonstrated ability to thrive in fast-paced environments while managing migrations and upgrades to production systems.