Summary
Overview
Work History
Skills
Timeline
Generic

SANDEEP KARAMPURI

Troy,MI

Summary

Results-driven Data Analyst with over 4 years of experience in financial data and supply chain data analysis. Expertise in ETL development, predictive modeling, data visualization, and statistical data analysis. Proficient in Python, R, SQL, and Tableau. Strong track record of working in cross-functional teams, delivering actionable insights, and improving business processes through data-driven solutions.

Overview

5
5
years of professional experience

Work History

Data Analyst

Medtronic
Mounds View, MN
11.2023 - Current
  • Conducted data analysis and profiling using SQL (Oracle, Teradata) to improve data accuracy and drive decision-making
  • Developed normalized logical and physical database models for OLTP applications
  • Implemented Python (Pandas) to analyze and manipulate large datasets, driving insights into customer trends
  • Used HiveQL to query and extract structured data, integrated with RDBMS using Sqoop
  • Created interactive dashboards in Tableau, incorporating drill-down and parameterized views for business users
  • Developed customized ETL solutions using PySpark and Shell scripting for real-time data processing
  • Assisted in the deployment of rich graphical visualizations to track healthcare accreditation metrics

Sr. Power BI Developer / MSBI Developer

AllState Insurance
Bloomington, IN
10.2022 - 10.2023
  • Migrated data from heterogeneous data sources (DB2, Access) to SQL Server using SSIS for better data transformation and reporting
  • Developed SSIS packages for data extraction, transformation, and loading (ETL) into campaign databases
  • Optimized SQL queries and stored procedures to enhance ETL processes
  • Built reports using Power BI and Tableau for tracking key business performance indicators (KPIs)
  • Designed and deployed SSRS reports and dashboards, ensuring timely data refresh and reporting accuracy
  • Utilized DAX and MDX to create calculated columns and measures for analytical purposes

Data Analyst

Ness Technologies, Inc.
Hyderabad, India
08.2021 - 07.2022
  • Led the analysis and development of machine learning models to predict customer wealth and categorize data for marketing
  • Automated data processes using Python to reduce update time by 90%
  • Designed dashboards using Power BI to track market performance and opportunities
  • Performed DBA tasks including query optimization and storage management
  • Integrated external data sources with Azure Data Factory for a unified data pipeline

Jr. Data Analyst

VBV Solutions
Hyderabad, India
07.2020 - 07.2021
  • Developed and executed data mapping and test plans for data migration projects
  • Worked with business users to define reporting requirements and developed relevant data models
  • Executed SQL queries to validate and match test data against expected results
  • Utilized Informatica Data Quality to transform and load data from multiple sources into the data warehouse
  • Built automated reporting solutions to improve operational efficiency and reduce manual errors

Skills

  • Data Analysis & Validation
  • ETL & Data Warehousing
  • Programming Languages
  • Data Visualization & Reporting
  • Machine Learning & Statistical Analysis
  • Database Management
  • Business Intelligence
  • Agile Methodology
  • Technical Skills
  • Tools
  • Database Systems
  • ETL Processes
  • Cloud Platforms
  • Big Data & Storage
  • Reporting & Visualization

Timeline

Data Analyst

Medtronic
11.2023 - Current

Sr. Power BI Developer / MSBI Developer

AllState Insurance
10.2022 - 10.2023

Data Analyst

Ness Technologies, Inc.
08.2021 - 07.2022

Jr. Data Analyst

VBV Solutions
07.2020 - 07.2021

Similar Profiles

CREATE PROFILE
SANDEEP KARAMPURI