Sathya B

Project: Device Protection Analytics

Description: Developed an end-to-end data analytics solution to monitor device protection plans, claims, and revenue performance, enabling data-driven decision-making and operational transparency.

Key Responsibilities & Achievements:

• Designed and optimized complex SQL queries, stored procedures, and views to extract and transform device protection data from multiple sources.
• Built ADF pipelines to automate data ingestion, cleansing, and incremental refresh from on-prem SQL Server to Azure environment.
• Created a star schema data model in Power BI with well-defined relationships, measures, and hierarchies for accurate reporting.
• Developed interactive Power BI dashboards displaying key KPIs such as claim trends, revenue by plan, customer churn, and protection coverage rate.
• Implemented DAX calculations for time intelligence, profitability analysis, and claim ratio metrics.
• Applied Row-Level Security (RLS) and deployed reports to Power BI Service with scheduled refresh for real-time insights.

Project: Lyca Online Sales System

Description:
Lyca Mobile is a leading MVNO telecom provider across Europe offering low-cost international mobile services. The project involved automating the online sales reconciliation system to ensure that online top-up transactions matched customer account balances, improving financial accuracy and preventing revenue leakage.

Key Responsibilities & Achievements:

• Designed and developed complex T-SQL queries, stored procedures, CTEs, views, and user-defined functions for reconciliation logic and validation.
• Implemented SSIS packages for automated ETL workflows, integrating data from multiple telecom systems and ensuring data quality through transformation and error handling.
• Performed query optimization, indexing strategies, and execution plan analysis to enhance database performance and reduce query execution time.
• Developed parameterized SSRS reports for transaction summaries, reconciliation mismatches, and financial KPIs, with automated scheduling via SQL Server Agent.
• Utilized temporary tables, table variables, and window functions (ROW_NUMBER, RANK, etc.) for efficient data comparison and analytics.
• Implemented transaction control (BEGIN TRAN / COMMIT / ROLLBACK) to ensure data consistency during reconciliation updates.
• Monitored and maintained database integrity, performing regular backups, job monitoring, and troubleshooting failed ETL executions.
• Collaborated with business teams to define reconciliation logic and validate financial data accuracy across environments.

GPA: CGPA-6.65

GPA: 72.50%

GPA: 87.40%