Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic
Himanshu Madaan

Himanshu Madaan

Faridabad

Summary

Detail-focused data analyst with expertise in data warehousing, process validation, and business needs analysis. Skilled in optimizing systems to meet dynamic requirements, enhance collaboration, and strengthen security. Demonstrated ability to comprehend customer needs and translate them into actionable project plans. Committed and diligent professional with a strong passion for big data.

Overview

5
5
years of professional experience
1
1
Certification

Work History

IT Analyst (C2 Grade)

Tata Consultancy Services
04.2024 - Current
  • Provided expert support, troubleshooting complex technical problems for end-users in a timely manner.
  • Responsible for performing functional testing and database testing.
  • Improved user experience, monitoring feedback and making necessary adjustments to software applications.
  • Troubleshot incidents reported by end-users to schedule system changes and identify permanent solutions.

Functional Analyst E2E Integrations

Ramboll India Ltd.
07.2023 - 04.2024
  • Monitoring end to end integration of multiple cloud/SaaS based ERP applications and Biztalk integration.
  • Reviewed and tested plans and criteria to meet functional and technical requirements.
  • Performing smoke testing and regression testing in UAT.
  • Monitoring CRM D365 and analyzing BI reports.

Senior Data Analyst

CipherSquare Technologies
05.2022 - 03.2023
  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data and created a dashboard "Micro BI" for ad-hoc data analysis and visualization by creating multiple API's as per business requirements.
  • Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
  • Performed customer segmentation using bucket analysis & RFM ( Recency, Frequency and Monetary) analysis for customer retention.
  • Implemented a Rule Engine using Python with a set of rules that will either match or ignore messages depending on the conditions and flag an alert if necessary.

Technical Consultant

BirchStreet Systems (GDI)
08.2021 - 04.2022
  • Client data management, integration and designed their implementation of BirchStreet solutions along with configuring client procurement system as per the project requirements and their datasets in the ERP system.
  • Enhanced system performance by identifying and resolving technical issues through troubleshooting and root cause analysis.
  • Managed multiple projects simultaneously while prioritizing deadlines effectively under pressure through meticulous organization skills and time management.
  • Facilitated knowledge transfer among team members by leading training sessions on new tools, validating various datasets and reviewing databases using SQL and other database tools for creating business reports for clients.

Data Analyst

ATS Services Pvt. Ltd.
07.2019 - 06.2021


  • Creating features for different campaigns based on their treatments, on live data of different campaigns.
  • Utilized data visualization tools to effectively communicate business insights.

Education

Bachelor of Technology in Computer Science - Engineering Technology

Indraprastha University (GGSIPU)
08.2019

Skills

  • Python
  • SQL
  • Excel
  • Django
  • PL/SQL
  • Numpy
  • Pandas
  • Matplotlib
  • Seaborn
  • SciPy
  • Scikit-learn
  • Service Now
  • JIRA
  • Deltek Maconomy (ERP software)
  • D365 CRM
  • VIM (RYDOO)

Certification

  • IELTS certified 7 Bands
  • Google Data Analytics from Coursera
  • Data Science with python

Projects

  • AI Voice Assistant (Python, ML, AI, NLTK, GTTS, Google speech recognizer, VS code) - Developed an automatic voice assistant using Python, AIML, ML and GTTS that performs action according to voice command. Implemented GTTS to convert text into speech and Google speech recognition to recognize the command and perform accordingly. The AI assistant can track the user's real-time location using IP address and can send email as well using SMTPlib.
  • Customer Segmentation (K-Means Clustering, Python, ML, Clustering, Jupyter Notebook) - Designed an ML model for customer segmentation using Python, ML, and Clustering that group customers based on their spending pattern and purchase behavior. Customer Segmentation is an example of Market-Basket analysis that will allow companies an effective way to define and meet their customer needs.
  • Customer Retention (Buckets and RFM analysis, Python, SQL, Flask,Google-Colab, Postman) - RFM (Recency, Frequency, Monetary) analysis is a customer segmentation technique that uses past purchase behavior to divide customers into groups. RFM helps divide customers into various categories or clusters to identify customers who are more likely to respond to promotions and also for future personalization services. With the help of RFM analysis, we'll be able to predict if the customer is going to continue using the services or not and how to retain them.

Timeline

IT Analyst (C2 Grade)

Tata Consultancy Services
04.2024 - Current

Functional Analyst E2E Integrations

Ramboll India Ltd.
07.2023 - 04.2024

Senior Data Analyst

CipherSquare Technologies
05.2022 - 03.2023

Technical Consultant

BirchStreet Systems (GDI)
08.2021 - 04.2022

Data Analyst

ATS Services Pvt. Ltd.
07.2019 - 06.2021
  • IELTS certified 7 Bands
  • Google Data Analytics from Coursera
  • Data Science with python

Bachelor of Technology in Computer Science - Engineering Technology

Indraprastha University (GGSIPU)
Himanshu Madaan