Shreesha Raya

Senior ETL/SQL Developer with 14+ years of experience specializing in large-scale SSIS workloads, advanced SQL development, and enterprise data integration. Demonstrated success improving performance, strengthening data quality, and delivering complex reporting solutions across high-volume environments. Expert in SQL performance tuning, indexing strategies, and optimization.

Strong

Informatica background supporting scalable, reliable, high-performance data workloads.

Senior ETL & SQL Developer / Analyst - Lincoln Financial Group - Dover, NH

(2015-06 - 2024-04)

• Designed and optimized ETL workflows incorporating CDC and SCD Type I/II logic for incremental and historical loads.
• Implemented data lineage and metadata management practices to improve traceability and audit readiness.
• Built robust error-handling and exception-handling frameworks to increase ETL reliability and reduce production incidents.
• Strengthened data quality and governance by aligning ETL processes with enterprise data governance standards.
• Partnered closely with QA teams through strong QA collaboration to validate ETL workflows, resolve defects, and ensure high-quality releases.
• Performed regression testing on SQL code, ETL pipelines, and reporting logic to prevent defects during enhancements and migrations.
• Collaborated with business, QA, and engineering teams through strong cross-functional collaboration to deliver high-quality ETL solutions.
• Led requirements gathering sessions with stakeholders to define data mapping, validation rules, and reporting needs.
• Produced detailed technical documentation for ETL workflows, data lineage, and SQL logic to support audits and onboarding.
• Communicated complex technical concepts to non-technical partners, strengthening stakeholder communication and alignment.
• Onboarded large national employers to Lincoln Disability and Leave products, supporting enterprise-scale data integration.
• Created 100+ custom reports and 400+ standard reports for 200+ customers.
• Developed and maintained ETL strategy using SSIS, SSRS, and SQL Server; built complex stored procedures, functions, views, triggers, and indexing strategies.
• Managed 20+ databases including SQL Server environments up to 80 TB.
• Improved application performance by 40% and reduced reporting time by 25%.
• Designed a data quality framework reducing data errors by 20% and improving reporting accuracy by 15%.
• Standardized stored procedures, eliminating 300+ manual hours.
• Built automated report template setup, saving 30–40 minutes per template.
• Implemented Git code-quality checks, reducing review time and enforcing SQL standards.
• Automated and tuned Autosys batch jobs, reducing daily batch time by 20%.
• Used Informatica PowerCenter/TDM for data obfuscation and test data migration.
• Built reusable Informatica components and optimized ETL sessions.
• Supported Informatica ETL processes, enterprise scheduling, and data migrations.
• Ensured on-time delivery of 2000+ reports and monitored SQL Server performance.
• Conducted unit testing (T-SQLT) and integration testing for BI applications.

ETL Tech Lead - Liberty Mutual - Dover, NH

(2014-09 - 2015-06)

• Led ETL development supporting producer and sales management processes.
• Designed and implemented large-scale data warehouse solutions.
• Developed ETL mappings for flat files and XML sources.
• Integrated data from multiple sources into unified enterprise models.
• Built reusable ETL modules for SCD Type I & II.
• Improved ETL performance by 20% through tuning strategies.
• Conducted unit, system, and performance testing.
• Provided production support and troubleshooting.
• Led Informatica upgrade from version 9 to 10.

Senior ETL Developer - UNUM - Portland, ME

(2013-01 - 2014-07)

• Managed the In-Source Customer Reporting (ICR) project delivering online claims and leave reports.
• Integrated data from transactional and legacy systems into BI marts.
• Migrated and transformed 40 TB of data using Informatica across SQL Server, Teradata, and DB2.
• Designed data integration and migration solutions improving performance by 15%.
• Built exception-handling mechanisms for ETL processes.

ETL Developer - IDEXX Laboratories - Portland, ME

(2012-11 - 2012-12)

• Captured device data and loaded it into data marts for reporting.
• Gathered ETL requirements and collaborated with business teams.
• Designed ETL architecture for heterogeneous data integration.
• Adapted ETL processes for evolving source systems.
• Performed data cleansing, audits, and validation.
• Used Informatica partitions and parallel processing to reduce workflow downtime.
• Implemented audit controls and performed code reviews and documentation.

Master of Science - Information Systems - Osmania University

Bachelor of Computer Applications - Osmania University