Data Analyst Sql Server

Krishna Kapse

937-***-**** # **************@*****.*** ï krishna kapse § krishnakapse

Education

Shri Shivaji Maratha Society’s Institute of Management and Research Aug 2024 MBA in Business Analytics and International Business Management Pune, Maharashtra SCES’s Indira College of Engineering and Management June 2020 BE in Mechanical Sandwich Engineering Pune, Maharashtra Experience

WebMinds IT Solutions Sep 2021 – Present

Data Analyst Pune, Maharashtra

• Spearheaded a Python-powered Data Reconciliation System, preventing data loss and engineered ETL pipelines to integrate data from SQL Server, Excel, and third-party applications, improving efficiency by 40%.

• Optimized SQL queries for high-performance data retrieval, reducing query execution time by 60%.

• Designed and automated data cleaning workflows, improving data accuracy.

• Extracted, transformed, and analyzed large datasets using SQL, Python (Pandas, NumPy) for strategic reporting.

• Understood the existing architecture of EPICOR ERP and SQL SERVER data warehousing system, identified required tables and columns, and documented the same.

• Communicated data-driven findings to stakeholders and senior management, facilitating data-driven decision-making.

• Designed data models using Power BI Desktop, including calculated columns, measures, and relationships. Optimized Power BI reports by implementing best practices in DAX and data modeling.

• Developed visualizations including Column Charts, Stacked Charts, Pie Charts, Slicers, Donut Charts, Row Cards, Multi-Row Cards, Line Charts, and Table Reports using DAX Queries. Projects

Project Name: Pharmacy CMS

• Data Collection & Cleaning: Extract, clean, and preprocess data related to customers, medicines, orders, and inventory from the Pharmacy CMS database.

• Reporting & Insights: Generate reports on customer purchasing patterns, medicine demand, and supplier efficiency for stakeholders.

• Dashboard Development: Create visual dashboards to track key metrics such as medicine stock levels, expired medicines, and sales trends.

Project Name: MaxLife Insurance

• Data Collection & Management: Gather, clean, and preprocess insurance-related data, including insured persons’ details, policies, claims, and premium rates from SQL databases.

• Develop analytical reports on policy trends, customer demographics, and insurance claim patterns for business decision-making. Perform exploratory data analysis (EDA) to estimate market trends and identify opportunities for optimizing insurance plans.

• Write and optimize SQL queries to extract meaningful insights from large datasets stored in Microsoft SQL Server. Work closely with insurance analysts and business teams to interpret data insights and drive strategic improvements.

• Automation & Optimization: Use Python and Excel automation techniques to streamline data processing and reporting workflows.

Technical Skills

Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL Databases: SQL (MySQL, SQL Server), Excel

Data Visualization: Power BI, Matplotlib, Seaborn, Excel Charts, Tableau

Contact this candidate