Sanjana Kumara

Project: Data Dissemination Framework (DDF)

• Led the DDF project to partition, format, and deliver ~5 TB/day of datasets tailored to vendor and stakeholder requirements.
• Acted as the primary liaison between clients and technical teams, translating business needs into actionable development tasks.
• Designed and maintained ETL pipelines using Azure Data Factory to extract, transform and load billing, operational and transactional data into Azure SQL Database.
• Built and maintained PySpark workflows in Databricks for complex data transformations, billing computations, and business rule implementation.
• Developed SQL objects (tables, views, stored procedures) for efficient data modelling, querying, and storage.
• Automated workflow orchestration with ActiveBatch, managing interdependent ADF and Databricks jobs, and implemented failure email alerts via Azure Data Factory.
• Collaborated closely with DevOps for CI/CD deployment of pipeline changes, ensuring smooth and reliable production releases.
• Created detailed release and design documentation to support development, deployment, and knowledge sharing.
• Managed daily batch executions, ensuring timely delivery, SLA adherence, and quick resolution of data pipeline issues.
• Supported test and UAT environments by delivering curated datasets for client validation and quality assurance.
• Handled ad-hoc and bulk historical data requests, providing 3–4 years of archived data and managing the successful execution of backfill runs.

Project: Billing System Replacement (BSR)

• Maintained scalable ETL pipelines using Azure Data Factory, Synapse, Databricks, PySpark, SQL, Pandas.
• Automated fee calculations and improved billing accuracy through data validation and transformation.
• Optimized query performance and database design for faster reporting.
• Supported report development and integrated new data sources into existing workflows.
• Collaborated with global teams to align data requirements and ensure consistent delivery.