Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Deepika Maddali

San Diego

Summary

Over two decades of experience in data architecture, engineering, and operations, specializing in leading teams to design and scale mission-critical data platforms across AWS and Azure ecosystems. Proven people leader, adept at mentoring and nurturing high-performing engineering teams while fostering a culture of trust, collaboration, and technical excellence. Expertise includes modern data engineering, ETL/ELT frameworks, cloud-native architecture, and governance—delivering secure, reliable, and scalable pipelines that enable analytics, AI/ML integration, and actionable business insights. Collaborates with cross-functional stakeholders to define roadmaps, set priorities, and ensure that data infrastructure meets performance and compliance requirements while driving measurable business value.

Overview

21
21
years of professional experience

Work History

LEAD DATA SPECIALIST – DATA ARCHITECT

Solar Turbines, a Caterpillar Company
07.2019 - Current
  • Lead and mentored teams of data engineers, providing coaching, technical guidance, and career development while instilling a culture of trust, empathy, and excellence.
  • Owned the enterprise data platforms, overseeing the architecture, scalability, and reliability of pipelines powering mission-critical manufacturing analytics and reporting.
  • Delivered measurable value through predictive analytics solutions that improved equipment diagnostics, supply chain optimization, and operational efficiency.
  • Partnered with product, analytics, and business teams to align data engineering initiatives with KPIs, ensuring trustworthy, actionable data to drive informed decisions across the enterprise.
  • Built and governed scalable data models and metadata frameworks, enhancing discoverability, accessibility, and consistency across the organization.
  • Pioneered real-time ingestion frameworks (AWS Kinesis, AWS Lambda, Spark, Python) that improved cross-system data timeliness and availability.
  • Established robust governance practices (DBT, Paradi.me) for data lineage, security, and compliance, increasing trust in analytics ecosystems.
  • Provided architectural leadership, actively participating in design/code reviews, guiding workflow orchestration (Airflow, Kubernetes), and modernizing ML pipelines with SageMaker and CloudFormation automation.
  • Ensured compliance with enterprise security, audit, and regulatory standards by implementing access controls, encryption, and governance reviews.
  • Documented data flows, lineage, and architecture decisions to support auditability, transparency, and cross-functional understanding.

DATA SOLUTION ARCHITECT

Qualcomm (Qualcomm Health)
12.2011 - 06.2019
  • Architected and managed large-scale enterprise data platforms, overseeing 6,000+ Oracle/MySQL databases and Teradata warehouses supporting global analytics and mission-critical applications.
  • Designed and developed complex ETL pipelines in Informatica PowerCenter, integrating Oracle, flat files, and API sources into Teradata and MySQL warehouses. Built parameterized mappings, reusable transformations, and dynamic workflows to standardize ETL and cut development time by 50%.
  • Optimized ETL and database performance through partitioning, indexing, query rewrites, and parallel execution strategies, improving throughput and reducing batch processing times.
  • Automated job scheduling and orchestration using AutoSys and Control-M, coordinating Informatica workflows, SQL scripts, and Python-based processes across distributed environments.
  • Built modular, metadata-driven ETL frameworks with PL/SQL and Python, enabling faster deployments, consistent error handling, and reusable pipeline components.
  • Designed standardized data models to support Customer360 and enterprise analytics, ensuring consistency across product, finance, and operational domains.
  • Partnered with BI teams to deliver enterprise dashboards and reports using Cognos, SSRS, and Tableau, enabling self-service insights for business stakeholders.
  • Piloted early cloud adoption initiatives, leveraging AWS S3, Redshift, and EMR for hybrid cloud warehousing and exploratory analytics.
  • Implemented security practices, including LDAP/Active Directory integration, row-level security, and audit logging to meet compliance requirements.
  • Mentored and trained junior engineers and DBAs, providing guidance on query tuning, ETL design patterns, and operational troubleshooting, fostering team-wide growth.
  • Collaborated with product teams and external healthcare partners to align data integration, interoperability, and FHIR/HL7 standards with Qualcomm Health initiatives.

ORACLE DATABASE ARCHITECT

Cedars-Sinai Medical Center
11.2008 - 05.2011
  • Architected and maintained high-availability Oracle database environments supporting sensitive clinical and operational workloads, ensuring compliance with HIPAA and healthcare regulatory standards.
  • Developed and tuned ETL workflows using Informatica PowerCenter and PL/SQL, integrating data from EMR systems, Oracle databases, and flat files into centralized reporting structures.
  • Optimized database performance through indexing strategies, partitioning, and SQL tuning, reducing query response times for clinical reporting. Implemented backup, recovery, and disaster recovery strategies to ensure business continuity in 24×7 hospital operations.
  • Collaborated with analysts and BI teams to deliver parameterized reports and dashboards using Cognos and SSRS, enabling physicians and administrators with timely decision-support data.
  • Strengthened data security and governance by implementing role-based access controls, auditing, and encryption features for clinical data.
  • Provided guidance to junior DBAs and developers, reviewing SQL code and sharing best practices for ETL and performance tuning.

SR. ORACLE DATABASE ADMINISTRATOR/ANALYST

Verizon
11.2006 - 10.2008
  • Administered and supported large-scale Oracle 10g/11g databases across OLTP and OLAP systems in 24×7 production.
  • Tuned complex SQL/PLSQL workloads using Explain Plan, TKPROF, and AWR/ASH, improving batch and reporting performance.
  • Managed multi-terabyte transactional systems (2TB–10TB) with capacity planning, partitioning, and space management.
  • Implemented Oracle Data Guard for disaster recovery, ensuring resilience and redundancy in backup and recovery drills.
  • Designed and executed RMAN backup/recovery strategies, ensuring resilience and compliance. Provided on-call production support for P1 incidents, performance issues, and failover events.

SR. DATABASE ADMINISTRATOR/DEVELOPER

Wipro Technologies
06.2004 - 03.2006
  • Developed and optimized T-SQL and PL/SQL stored procedures, triggers, and views for transactional and reporting systems.
  • Built ETL pipelines with DTS and SSIS, integrating Oracle, flat files, and Excel into SQL Server warehouses.
  • Tuned slow-running queries using execution plans, TKPROF, and SQL Profiler, improving performance by up to 80%.
  • Designed and maintained data models and partitioning strategies to improve scalability of billing and financial systems.
  • Managed backups, restores, and replication (Oracle Streams, SQL Server Transactional Replication) to ensure availability.

Education

MASTER OF SCIENCE - DATA SCIENCE AND MACHINE LEARNING

University of California, Berkeley
Berkeley, CA
01.2024

M.S. - COMPUTER SCIENCE

Boston University
Boston, MA
01.2010

MASTER OF COMPUTER APPLICATIONS -

Osmania University
Hyderabad, India
01.2004

Skills

  • Data architecture design
  • Data integrity management
  • Proficient in Python programming
  • Data integrity assurance
  • Data integration
  • Data pipeline control
  • API integration
  • Compiling data
  • Statistical modeling
  • AWS Cloud
  • System architecture expertise
  • ETL development
  • Data governance
  • Time series analysis
  • NoSQL databases
  • Machine learning
  • Deep learning

Timeline

LEAD DATA SPECIALIST – DATA ARCHITECT

Solar Turbines, a Caterpillar Company
07.2019 - Current

DATA SOLUTION ARCHITECT

Qualcomm (Qualcomm Health)
12.2011 - 06.2019

ORACLE DATABASE ARCHITECT

Cedars-Sinai Medical Center
11.2008 - 05.2011

SR. ORACLE DATABASE ADMINISTRATOR/ANALYST

Verizon
11.2006 - 10.2008

SR. DATABASE ADMINISTRATOR/DEVELOPER

Wipro Technologies
06.2004 - 03.2006

MASTER OF SCIENCE - DATA SCIENCE AND MACHINE LEARNING

University of California, Berkeley

M.S. - COMPUTER SCIENCE

Boston University

MASTER OF COMPUTER APPLICATIONS -

Osmania University
Deepika Maddali