Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kishor Jagdale

Chikhali Pune

Summary

Accomplished Lead Data Engineer with 13+ years of experience in insurance data analytics. Expertise in SQL, Oracle, SSIS, and ETL processes. Proficient in Tableau, Power BI, Power Automate, and Blue Prism for automation. Skilled in stakeholder management and project delivery using Version One. Adept at driving business insights and operational efficiency with Python and Core Java. Familiarity with cloud platforms like AWS and Snowflake.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Data Analytics Lead

Allstate India Pvt. Ltd.
Pune
03.2016 - Current
  • Designed and implemented data pipelines for processing large datasets using SQL and SSIS.
  • Collaborated with business stakeholders to gather requirements and deliver data solutions supporting strategic decision-making.
  • Developed and maintained ETL processes to ensure data accuracy and integrity across multiple systems.
  • Utilized Tableau and Power BI to create interactive dashboards and reports for data visualization.
  • Automated, repetitive tasks using SSIS, Power Automate, Blue Prism, and Python, improving operational efficiency by 30%.
  • Developed Python scripts for data cleaning, transformation, and analysis.
  • Created and maintained business intelligence reports using Business Objects and Tableau.
  • Aligned business objectives with technical requirements through close collaboration with product owners, providing insights based on available data sources.
  • Mentored junior engineers on best practices in data engineering, fostering a culture of continuous learning and improvement within the team.

Senior Practitioner

Concentrix(IBM) Daksh India Pvt. Ltd
Pune
05.2014 - 03.2016
  • VBA (Visual Basic for Applications) - Develop Excel macros, Excel/Access-based VB Script apps, and PCOMM (Mainframe) macros based on the business requirements.
  • Creation of automation tool/macros in MS Excel to simplify and avoid repetitive work.
  • Responsible for automating manual processes by writing VBA code and using macros and formulas to speed up processes and maximize accuracy.
  • Wrote major VBA program to locate discrepancies between Claims Database and Electronic Claim image.
  • Knowledge of Insurance HIPAA Act, Insurance Claims Adjudication.

Claim Associate

Trizetto India Pvt. Ltd.
Pune
02.2011 - 01.2014
  • Enrolled and maintained the client's Commercial, Medicaid, and Medicare Members into Facets and Enrolment Administration Manager (EAM).
  • Followed enrollment policies and procedures to ensure proper enrollment of subscriber.
  • Followed adjudication policies and procedures to ensure proper payment of claims (QNXT and Facets).
  • Basic knowledge of claims configuration of system.
  • Preparing MIS Reports, preparing daily, weekly, and monthly production and quality reports. Maintaining and analyzing reports by designing macros.

Education

Bachelor of Computer Applications - Computer And Information Sciences

Shivaji University
Kolhapur
04-2009

HSC - Science Education

DCD Dahiwadi
Dahiwadi
02-2006

SSC -

KBPV Bijwadi
Dahiwadi
03-2004

Skills

  • Programming Languages: SQL, Python, Core Java, VBA
  • Databases: Oracle, SQL Server, Snowflake
  • ETL Tools: SSIS
  • Data Visualization: Tableau, Power BI, Business Objects
  • Automation Tools: Power Automate, Blue Prism
  • Cloud Platforms: AWS
  • Version Control: Git, GitHub
  • Project Management: Version One
  • Other Tools: Excel

Certification

  • Full Stack Developer from IIT Roorkee and Great Learning (Feb 2023 to Feb 2024)
  • Blue Prism Developer course completed (Feb 2020)
  • ISMAC Dot Net Developer course completed from IIHT (Feb 2017)

Timeline

Data Analytics Lead

Allstate India Pvt. Ltd.
03.2016 - Current

Senior Practitioner

Concentrix(IBM) Daksh India Pvt. Ltd
05.2014 - 03.2016

Claim Associate

Trizetto India Pvt. Ltd.
02.2011 - 01.2014

Bachelor of Computer Applications - Computer And Information Sciences

Shivaji University

HSC - Science Education

DCD Dahiwadi

SSC -

KBPV Bijwadi

Similar Profiles

CREATE PROFILE
Kishor Jagdale