Sumitha Mani

• • Architected and maintained end-to-end ETL pipelines using SAS, SQL, and SSIS, processing large volumes of healthcare claims and member data for enterprise reporting across multiple business units.

• • Designed and optimised complex MS SQL Server queries, stored procedures, and data models to support downstream analytics and compliance reporting, ensuring data integrity across 10+ integrated source systems.

• • Led a full-scale legacy SAS-to-Python (Pandas) migration programme, eliminating SAS licensing costs and improving pipeline automation; estimated 35% reduction in manual processing time across migrated workflows.

• • Built and operationalised data quality and anomaly detection frameworks, reducing data errors in production reporting by improving validation coverage across critical data feeds.

• • Authored functional specifications, data mapping documents, and transformation logic documentation for handover to offshore development and QA teams.

• • Managed a small engineering team, leading sprint planning, code reviews, and stakeholder communications with business analysts and reporting leads.

• • Used GitHub Copilot to accelerate Python development, improving delivery speed on ETL automation tasks.

• • Delivered database-driven application solutions for regulated-sector clients including the British Medical Association, After Adoption, and a medical legal protection society — all environments with strict data compliance and accuracy requirements.

• • Conducted requirements gathering with key business stakeholders, performed gap analysis, and translated findings into technical specifications for the development team.

• • Designed and improved data collection processes including surveys and structured data instruments, and supervised output quality from programmers and technical staff.

• • Contributed to software development projects across the full lifecycle, working directly with clients on functional requirements, performance specifications, and technical documentation.

• • Supported data pipeline and reporting deliverables, preparing technical documentation and collaborating on system integration tasks.