Sachin Louis Kachhap

Data Analyst | Business Intelligence Analyst

Ranchi, Jharkhand, India 4+ yrs exp 89 · Excellent

About

Data Analyst with 4+ years of experience in the insurance domain specializing in SQL, Power BI, SSRS, DevExpress BI Dashboard, and self-service reporting solutions. Experienced in analyzing business data, developing interactive dashboards, optimizing SQL queries, automating reports, and delivering actionable insights that support business decision-making. Skilled in KPI reporting, stakeholder collaboration, data visualization, and business intelligence solutions.

Skills & Expertise (23)

SQL Server Advanced

7.5/10

Years Exp

T-SQL Advanced

7.5/10

Years Exp

Stored Procedures Advanced

7.5/10

Years Exp

Power BI Advanced

7.5/10

Years Exp

Ad-Hoc Reporting Advanced

7.0/10

Years Exp

Data Visualization Advanced

7.0/10

Years Exp

Data Analysis Advanced

7.0/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Trend Analysis Intermediate

6.5/10

Years Exp

Business Analysis Intermediate

6.5/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Azure DevOps Intermediate

5.5/10

Years Exp

REST APIs Intermediate

5.5/10

Years Exp

KPI Reporting Report Automation Root Cause Analysis Data Cleaning Data Validation SSRS Query Optimization Functions Views Oracle 11g

Work Experience

Software Engineer

DAMCO Solutions Pvt. Ltd.

Jul 2022 - May 2026

Developed complex SQL queries, stored procedures, views, and functions to support insurance reporting and business intelligence requirements. Developed 40+ parameterized reports using DevExpress End-User Report Designer to enable self-service reporting for business users. Designed interactive BI dashboards to analyze policy issuance, premium collections, renewals, producer performance, and business KPIs. Gathered reporting requirements from underwriting, finance, and business teams and translated them into interactive dashboards and analytical reports. Optimized SQL queries and stored procedures, significantly improving report execution time and reporting efficiency. Developed Power BI and SSRS dashboards to support operational reporting, KPI monitoring, and business performance analysis.

Business Intelligence Developer

Edureka

Jan 2020 - Jul 2020

Input files were provided to us. Then staging of data was done in MYSQL Database and then the business rules were applied to it as directed by the organization. Error report was loaded to HIVE servers from HDFS servers by the help of Talend. The final report which fulfilled the business rules was sent to Kafka Servers. As a last step, a reconciliation report was generated and loaded to pig by the help of input file and aggregating the error report.