Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Profile Url
Timeline
Hi, I’m

Sathya B

Chennai
Sathya B

Summary

Professional Summary:

Results-driven SQL Developer with 5.7 years of experience in database development, data analysis, and reporting.
Expert in writing complex T-SQL queries, stored procedures, CTEs, views, and functions for efficient data manipulation and transformation.Proficient in SSIS for building and maintaining ETL workflows and in SSRS for developing interactive and paginated reports.Strong experience in performance tuning, query optimization, and ensuring data integrity and accuracy.Skilled in Power BI dashboard development using DAX and data modeling to visualize insights from SQL data sources.Familiar with Azure Data Factory (ADF) for cloud-based data integration and orchestration.Collaborates effectively with business stakeholders to design scalable, data-driven solutions that improve reporting efficiency and decision-making.

Overview

6
years of professional experience
1
Certification

Work History

Likewize India Shared Services LLP

Business Intelligence Analyst
09.2023 - Current

Job overview

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.


Lycatech Service Private Limited

Engineer
12.2019 - 04.2023

Job overview

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.

Education

Alpha College Of Engineering

Bachelor of Engineering from Computer Science
06-2019

University Overview

GPA: CGPA-6.65

Chennai Government Higher Secondary School

Higher School from Computer Sciences
05-2015

University Overview

GPA: 72.50%

Chennai Government High School

High School
05-2013

University Overview

GPA: 87.40%

Skills

  • Databases: SQL Server, PostgreSQL

  • SQL Development: T-SQL, PL/pgSQL, Stored Procedures, Views, Functions, CTEs, Query Optimization, Performance Tuning

  • ETL & Data Integration: SSIS, Azure Data Factory (ADF)

  • Reporting & Visualization: SSRS, Power BI (DAX, Data Modeling, Dashboard Development)

  • Tools & Platforms: SSMS, pgAdmin, Power BI Desktop, Visual Studio

  • Data Warehousing: Dimensional Modeling, Star/Snowflake Schema Design

Certification

  • Oracle Server- QSpiders Training Institute

  • Microsoft Power BI Data Analyst- Professional Coursera Certificate

Personal Information

Profile Url

https://www.linkedin.com/in/sathya-b-0a19b3139

Timeline

Business Intelligence Analyst

Likewize India Shared Services LLP
09.2023 - Current

Engineer

Lycatech Service Private Limited
12.2019 - 04.2023

Alpha College Of Engineering

Bachelor of Engineering from Computer Science

Chennai Government Higher Secondary School

Higher School from Computer Sciences

Chennai Government High School

High School
Sathya B