Analytical and technically minded data professional with extensive experience designing and implementing robust, scalable data infrastructure solutions. Proven ability to translate complex business requirements into effective data warehouse and data platform architectures that balance performance, scalability, and governance. Experienced in modernizing legacy data processing approaches into modular, reusable, and reliable data pipelines across cloud and hybrid environments. Strong background in data integration from diverse sources, data modeling, and performance optimization to support enterprise reporting and advanced data use cases. Adept at applying DataOps and engineering best practices to ensure reliability, security, and cost efficiency. Known for clear communication with non-technical stakeholders, effective cross-functional collaboration, and successful delivery of complex initiatives under time-sensitive deadlines.

pavana yanamandala

Analytical and technically minded data professional with extensive experience designing and implementing robust, scalable data infrastructure solutions. Proven ability to translate complex business requirements into effective data warehouse and data platform architectures that balance performance, scalability, and governance. Experienced in modernizing legacy data processing approaches into modular, reusable, and reliable data pipelines across cloud and hybrid environments. Strong background in data integration from diverse sources, data modeling, and performance optimization to support enterprise reporting and advanced data use cases. Adept at applying DataOps and engineering best practices to ensure reliability, security, and cost efficiency. Known for clear communication with non-technical stakeholders, effective cross-functional collaboration, and successful delivery of complex initiatives under time-sensitive deadlines.

Available to hire

Analytical and technically minded data professional with extensive experience designing and implementing robust, scalable data infrastructure solutions. Proven ability to translate complex business requirements into effective data warehouse and data platform architectures that balance performance, scalability, and governance. Experienced in modernizing legacy data processing approaches into modular, reusable, and reliable data pipelines across cloud and hybrid environments. Strong background in data integration from diverse sources, data modeling, and performance optimization to support enterprise reporting and advanced data use cases. Adept at applying DataOps and engineering best practices to ensure reliability, security, and cost efficiency. Known for clear communication with non-technical stakeholders, effective cross-functional collaboration, and successful delivery of complex initiatives under time-sensitive deadlines.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Data Engineer at Comerica Bank
September 1, 2021 - Present
Designed and delivered a scalable, cloud-native regulatory reporting and risk data platform using Snowflake and dbt. Modernized legacy, hard-coded ETL processes by implementing dbt-driven transformation frameworks built on modular, reusable, and fully testable SQL models. Established enterprise-grade data quality, documentation, lineage, and CI/CD standards through dbt tests, snapshots, macros, and version-controlled deployments. Engineered resilient Apache Airflow orchestration with dynamic DAGs and Python operators to manage end-to-end regulatory and credit-risk data pipelines. Drove Snowflake performance tuning and cost optimization via query profiling, clustering, and warehouse right-sizing. Applied DataOps and reliability practices to deliver governed, auditable, and AI-ready datasets while collaborating across domain teams and mentoring junior engineers. Contributed to AI RAG proof-of-concept.
Data Engineer at Humana
March 1, 2016 - August 1, 2021
Designed and delivered end-to-end data pipelines on Snowflake leveraging Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, and performance optimization techniques to process large-scale healthcare datasets. Integrated Azure Blob Storage as external cloud storage for secure ingestion, staging, and archival using Snowflake external stages. Developed curated data models using Snowpark (Python) with strong emphasis on scalability and reusability. Implemented RBAC and data-masking policies to meet HIPAA and healthcare governance requirements. Enabled analytic-ready datasets and business insights through Power BI reporting.
Data Engineer at GlaxoSmithKline
September 1, 2015 - February 1, 2016
Designed and delivered scalable data pipelines using Azure Databricks to ingest, cleanse, and process clinical trials, drug safety, manufacturing, and supply-chain data. Implemented Delta Lake–based architectures with optimized storage formats and advanced transformation logic to support high-volume, regulated datasets. Developed notebook-driven frameworks, job clusters, and automated workflows with embedded QC and validation rules aligned to pharmaceutical compliance standards. Produced curated analytical layers integrated with Azure services to enable regulatory submissions, R&D analytics, and commercial insights.
Senior SQL Developer at Genentech
March 1, 2015 - September 1, 2015
Maintained on-premises Oracle database solutions supporting pharmaceutical data domains, including clinical trials, drug safety, manufacturing, and commercial operations. Developed complex Oracle SQL and PL/SQL transformations, data models, and reporting views aligned with GxP-compliant processes and regulatory expectations. Implemented data validation, reconciliation, and audit-ready controls to ensure data integrity, traceability, and submission readiness. Enabled limited analytical consumption by exposing curated datasets to Qlik and Power BI for operational, regulatory, and trend reporting.
SQL Developer at Assurant
November 1, 2013 - February 1, 2015
Maintained on-prem SQL Server database solutions supporting core supply chain functions, including procurement, inventory, logistics, and order fulfillment. Developed complex T-SQL queries, stored procedures, functions, and views to integrate and transform data from ERP and operational systems. Implemented data validation, reconciliation logic, and transaction handling to ensure data accuracy and consistency. Performed query optimization and index tuning to improve performance and reliability of mission-critical supply chain processes.
BI Consultant at Plandata GmbH
March 1, 2009 - September 1, 2013
Provided BI consulting services and implemented analytics solutions for clients across financial services and manufacturing sectors, including dashboard development, data modeling, and reporting enhancements to enable data-driven decision making.
Oracle Developer at Sal Oppenheim jr & Cie
January 1, 2007 - February 1, 2009
Developed Oracle SQL/PL/SQL transformations, data models, and reporting views aligned with GxP-compliant processes and regulatory expectations. Implemented data validation, reconciliation, and audit-ready controls to ensure data integrity and submission readiness. Enabled limited analytical consumption by exposing curated datasets to Qlik and Power BI for operational, regulatory, and trend reporting.
Oracle Developer at Benchmark Capital Management GmbH
November 1, 2002 - December 1, 2007
Developed Oracle SQL/PL/SQL transformations and data integration workflows across multiple investment and back-office systems. Implemented data validation, reconciliation logic, and performance-tuned SQL to support accurate reporting and regulatory requirements.

Education

Master of Business Administration at University of Minnesota, Carlson School of Management
January 11, 2030 - January 8, 2026
Master of Science in Information Systems at University of Aberdeen
January 11, 2030 - January 8, 2026
Bachelor of Technology at National Institute of Technology, Warangal
January 11, 2030 - January 8, 2026

Qualifications

Add your qualifications or awards here.

Industry Experience

Financial Services, Healthcare, Life Sciences, Professional Services, Software & Internet