Konjetti Sai Advith

System Engineer @Tata Consultancy Services

Hyderabad, IN

Role: PLSQL DeveloperResponsibilities:• Developed and optimized PL/SQL scripts, stored procedures, functions, packages, and triggers to support high-performance, reliable processing of business-critical data across enterprise systems. • Designed and executed complex SQL queries for data extraction, transformation, and analysis, ensuring data integrity, consistency, and accuracy in large relational datasets. • Collaborated with business analysts, QA teams, and application developers to gather requirements and deliver scalable, production-grade database solutions aligned with evolving business needs. • Created and maintained technical documentation including data flow diagrams, schema definitions, and data mappings to facilitate efficient development and knowledge transfer. • Led production support and incident management in the Accounts Receivables domain, resolving critical data issues, monitoring batch jobs, and implementing preventive measures to ensure system stability.• Experienced in data warehousing concepts, adept in core principles including OLTP for managing transactional data, OLAP for complex querying and analysis, and understanding key data modeling components such as dimensions and facts. • Skilled in designing data warehouses and architectures, optimizing ETL processes for performance, and developing effective data models for seamless data integration. • Developed and managed jobs using various tools to automate routine PL/SQL tasks and ELT/ETL processes.• Continuously monitor CI/CD pipeline performance and logs to identify and address bottlenecks or failures. Implement alerts and automated notifications for pipeline issues to ensure prompt resolution and minimize disruptions. • Monitored workflows in Informatica PowerCenter and analyzed sources to address end-user issues promptly and effectively.• Interacted with product owners and users to understand their business requirements, and created both functional and technical documentation.

Osmania University

Bachelor of Commerce - BCom

Osmania University

Master of Business Administration - MBA