Power Bi Oracle Pl

Teja Challagundla

+1-469-***-**** ******.************@*****.***

linkedin.com/in/teja-challagundla

Professional Summary

BI and Data Developer with 4+ years of experience in Oracle PL/SQL, Informatica, SQL performance tuning, and ETL pipelines (SSIS, Azure). Proficient in developing robust stored procedures, optimizing data workflows, and supporting enterprise-scale databases and applications. Strong background in troubleshooting production issues, scripting, and collaborating in global delivery environments. I am skilled in data modeling, system integration, and producing reliable BI solutions.

Professional Experience

Link Well INC Dallas, Texas, USA Sep 2024 – March 2025

Oracle PL/SQL & ETL Support Developer

Provided technical support for BI dashboards and SQL-based reports, ensuring high availability and customer satisfaction.

Resolved Power BI data refresh issues by optimizing data sources and reducing memory bottlenecks.

Monitored SQL Server, Power BI environments, and ETL pipelines (SSIS), increasing system reliability.

Conducted after-hours support and health checks on reports and ETL jobs to ensure smooth business operations.

Collaborated cross-functionally to troubleshoot production issues and implement fixes quickly within SLA windows.

Documented SOPs, troubleshooting steps, and resolution paths to reduce MTTR.

Managed support tickets using ITSM tools, ensured timely escalation and closure.

Cognizant Technology Solutions

Oracle PL/SQL & Informatica Developer Client: Molina Healthcare July 2020 – Nov 2022

Developed and optimized PL/SQL stored procedures, functions, and packages for high volume healthcare data.

Built and managed ETL processes using Informatica PowerCenter and SSIS.

Designed and optimized complex SQL queries implemented performance tuning using EXPLAIN PLAN and TKPROF.

Designed Azure Data Lake and Azure SQL DB solutions for structured and semi structured data storage.

Spearheaded SQL Server to Azure migration project with zero data loss and <1% downtime.

Collaborated with stakeholders to translate business requirements into actionable BI and ETL solutions.

Applied data modeling and mapping techniques to build scalable data warehouse systems.

Reduced Power BI dashboard load time by 40% through performance tuning and backend optimizations.

Mentored new members in team on SSIS design, query tuning, and best practices.

Oracle PL/SQL Developer Client: Anthem Healthcare Nov 2019 – July 2020

Developed and maintained Oracle PL/SQL scripts for custom reporting and application logic.

Implemented database schema design using DDL scripts for complex healthcare systems.

Performed performance tuning using SQL*TRACE, AUTOTRACE, and optimized query structures.

Built SSIS packages for ETL tasks including data cleansing, standardization, and backup automation.

Executed data validation and transformation using PL/SQL and SQL scripts to maintain data integrity.

Developed Unix shell scripts for automating logs, backups, and monitoring batch ETL jobs.

Collaborated with onshore and offshore teams in a global delivery model, ensuring consistent project success.

Education

PG Diploma in IT Infrastructure, Systems & Security, C-DAC GPA: 7.0

B. Tech in Electronics & Communication Engineering, JNTU Kakinada 75%

Certifications

DP-203: Data Engineering on Microsoft Azure

CCNA: Routing and Switching

Developing Microsoft Azure and Web Services

Skills

Languages/Databases: Oracle PL/SQL, SQL Server, TSQL, Azure SQL DB

ETL Tools: Informatica PowerCenter, SSIS, Azure Data Factory

BI & Reporting: Power BI, SSRS, SSAS

Performance Tools: EXPLAIN PLAN, TKPROF, SQL*TRACE, AUTOTRACE

Cloud/Platforms: Microsoft Azure, Azure Databricks

Scripting: Unix Shell Scripting, Python

Monitoring & Tools: ITSM tools, Jira, Git, Visual Studio

Methodologies: Agile, Global Delivery, Incident/Problem Management

Professional Highlights

Reduced Power BI report refresh time by 40% and improved support SLAs via proactive system monitoring.

Led Azure cloud migration project with zero data loss and minimal downtime.

Developed and optimized Oracle PL/SQL codebase, improving ETL reliability and execution time.

Authored detailed SOPs and automation scripts to streamline BI support operations.

Contact this candidate