Kalpesh Shinde

Kalpesh Shinde

About Me

Hi there! I am Kalpesh Shinde, an Information Technology Engineer & an Engineering enthusiast having extensive experience working in the BFSI domain understanding the domain and executing end-to-end data-driven solutions for solving complex business problems.

Skilled in problem-solving and navigating complex challenges, with a strong ability to understand business domains, analyze issues at their core, and approach problems from multiple perspectives.

I am proficient in following Tech Stacks:

  1. Languages: Python, SQL, HTML
  2. Libraries: Pandas, NumPy, Matplotlib, Seaborn, Scikit learn
  3. Web Frameworks: Django, Pyramid, Streamlit
  4. Unit Testing: Test-Driven Development, PyUnit, PyTest
  5. Tools: MySQL, SQLite, Heroku, Google Sheets, Microsoft Excel, Power BI, Git, GitHub, GitLab, VS Code, Spyder, Jupyter, Confluence, JSON
  6. Project Management Tools: JIRA, Redmine
  7. General: SDLC, OOP, Debugging, Data Extraction, Data Mining, Data Wrangling, Data Cleaning, Data Modeling, Data Visualization, Business Acumen, ETL, EDA, Data Pipeline, Agile Methodology

Interests

  • Data Engineering
  • Machine Learning

Education

  • Certification in Applied Data Science & Analytics

    MCED-Meritorium Knowledge Academy

  • Bachelor of Engineering in Information Technology

    Konkan Gyanpeeth's College of Engineering,
    Mumbai University

Experience

 
 
 
 
 

Python Developer

National Stock Exchange IT (NSEIT) - Client: SBI Life Insurance

Jul 2023 – Current Navi Mumbai
Key responsibilities include:

  • Spearheaded the Real Time Validation project, developing an exact flow of client insurance policies in Python. Worked on end-to-end process flow from receiving and optimizing SQL input data queries to producing results according to business requirements and presenting them to the stakeholders.
  • Wrote sophisticated Python code to replicate insurance policies based on input data. Ensured precise process flow replication, generating audited results to validate the correctness and authenticity of the processed policies. Enhanced accuracy and efficiency by creating automated solutions that align with the policy structure.
  • Led initiatives to refactor the code base, significantly improving execution efficiency and code agility. Focused on writing clean, maintainable code and maintaining comprehensive documentation to support future development.
  • Introduced and spearheaded Git implementation for version control, establishing best practices for code management and collaboration. Promoted high-quality code standards and structured software development processes across the team.
 
 
 
 
 

Business Intelligence Developer

Imenso Software

Feb 2022 – April 2023 Remote
Key responsibilities include:

  • Acquire data from various sources, use Python scripting language to perform data wrangling operations extensively on the data as part of the ETL process, Power BI to develop visualizations based on the business requirements.
  • Understand the business domain and various KPIs for better working on client requirements, worked on data modeling, and created reports and dashboards using Power BI as required.
  • Proficiently acquire and extract data from various sources, ensuring data integrity and quality. Employ Python scripting language to execute comprehensive data wrangling operations, including data cleaning, transformation, and integration.
  • Develop and optimize Extract, Transform, Load (ETL) processes to efficiently prepare data for analysis. Leverage expertise in data modeling to design & implement efficient data structures conducive to analysis & reporting.
  • Acquire an in-depth understanding of the business domain and relevant Key Performance Indicators (KPIs). Collaborate closely with clients to elicit and comprehend their specific data analysis and reporting requirements.
 
 
 
 
 

Data Science Intern

iSecurance Technologies Pvt Ltd

Feb 2020 – Aug 2020 Thane, Maharashtra, India
Key responsibilities include:

  • Utilized the Market Basket Analysis technique to examine consumer purchasing patterns and make suggestions for Product Placement, Cross Selling, and Affinity Promotion strategies that ultimately increased revenue.
  • Used Apriori Algorithm for generation of frequent item set & association rules using metrics lift confidence, conviction & support threshold.
  • The implementation of the research showed an impact of rise in sales by nearly 18%.
  • Conducted Market Basket Analysis to identify associations and patterns among products frequently purchased together by customers & leveraged the insights from Market Basket Analysis to optimize product placement and improve cross-selling strategies, leading to increased sales and revenue.
  • Collaborated with team members using version control systems such as Git to organize modifications and assign tasks.
  • Developed and implemented Affinity Promotion techniques based on customer behavior analysis to enhance customer engagement and drive sales & utilized Matplotlib & Seaborn libraries and other data visualization tools to present analysis findings and actionable recommendations to stakeholders.
 
 
 

Jr Python Developer

Verus Enterprises

Oct 2019 – Oct 2021 Mumbai, Maharashtra, India
Key responsibilities include:

  • Organized the data which was collected from various file locations and merged in to a tidy and preprocessed dataset.
  • Created Analytics reports for 2 business sub-domains (Sales & Service) which eventually led in to more calculative and nearly perfect Business Decisions along with less risks.
  • Collected the Data, performed the Extract Transform Load operation was used, various EDA techniques were used, & Feature Engineering was performed. Inconsistencies in data were handled for Sales & Service subdomains.
  • Performed ETL Operations to extract data from various sources, transform it into a consistent format, & load it into the target system for analysis. Utilized EDA Techniques to gain a comprehensive understanding of the collected data.
  • Conducted data profiling, summary statistics, data viz, & pattern identification to uncover insights & patterns.
  • Identified & addressed inconsistencies, missing values, outliers, & data quality issues. Implemented appropriate data cleaning & data validation techniques to ensure data integrity. Leveraged data visualization tools and techniques to present findings from EDA & feature engineering processes. Created visualizations, charts, and graphs to effectively communicate insights and facilitate decision-making.
  • The impact of the outcoming results showed an increase in the company’s performance by approximately 20% in the Sales domain while the Service domain saw an increase by approximately 22%.

Projects

*
All Data Analytics Machine Learning

Car Price Prediction

Tool used: Python

Predicting prices of cars using Regression based Machine Learning Technique.

Mobile Price Prediction

Tool used: Python

Predicting prices of mobiles using Classification based Machine Learning Technique.

Housing Price Prediction

Tool used: Python

Predicting prices of housing using Regression based Machine Learning Technique.

IMDB Movies Dashboard

Tool used: Power BI

Dashboard of insights of IMDB movies using Power BI Data Analytics Tool.

Sales Dashboard

Tool used: Power BI

Dashboard of insights of Sales records using Power BI Data Analytics Tool.

Accomplish­ments

Python for Data Science

NPTEL: Indian Institute of Technology Madras Apr 2020 – May 2020
See certificate

Introduction to Data Science in Python

Coursera: University of Michigan Sept 2020 – Oct 2020
See certificate

Microsoft AI Classroom Series

Microsoft, NASSCOM & futureskills Oct 2020
See certificate

Python for Data Science

iNeuron Apr 2020 – May 2020
See certificate

Embedded Analytics

Contact