Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

Devangna Jain

Delhi

Summary

Results-driven Data Analyst with experience in technical consulting and data management. Over 2 years of expertise in designing automated systems, utilising SQL and Advanced Excel, python, UIPath to enhance efficiency, achieving a 96% increase in performance metrics. Adept at delivering data-driven solutions that support organizational objectives, ready to contribute valuable insights in a fast-paced environment.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Technical Consultant

Genpact
Noida
10.2023 - Current
  • Engineered and implemented an automated follow-up email notification and tracking system for Wesco, extracting data through SQL databases, which streamlined the follow-up process across diverse ERPs (MFNA, SXEUS, ACCUTECH, RUBICON) and diminished manual effort by 75%, facilitating quicker client response times.
  • Constructed and delivered over 5 end-to-end production-grade automations within the insurance and healthcare domains, harnessing data analysis to pinpoint process inefficiencies.
  • Utilised SQL and Advanced Excel to scrutinise historical process data, monitor pre- and post-automation KPIs, and generate reports illustrating a 96% increase in efficiency.
  • Developed comprehensive process and test documentation that enhanced User Acceptance Testing (UAT) efforts by 30%, ensuring a seamless transition from development to operations.

Full Stack Developer Intern

BCS Infallible Technology
06.2022 - 07.2022
  • Devised a web application 'Digital Evaluation System' using React JS for front-end development and SQL for backend data management, facilitating automated evaluation and scoring of answer sheets.

Education

Bachelor of Technology - Computer Science

Amity University
Noida, Uttar Pradesh
01.2023

Skills

  • Python
  • Data Structures
  • Numpy
  • Pandas
  • Matplotlib
  • Seaborn
  • OOPS
  • Advance SQL
  • Pivot Tables
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • Graphs
  • Filters
  • Advance Excel Functions
  • Hypothesis Testing
  • A/B testing
  • Descriptive stats
  • Probability
  • Confidence Intervals
  • Power BI
  • UIPath
  • Regression
  • Classification
  • Clustering
  • NLP
  • Decision tree

Certification

  • Coding ninjas (Analytics and Data science)
  • Generative AI- Genpact certification

Projects

Absenteeism Project, This project is aimed at analyzing employee absence trends and predicting potential excessive absenteeism., Developed a data science project with a real-world application to forecast and analyze employee absenteeism., Applied data preprocessing, feature engineering and Statistical analysis to determine main cause behind absenteeism., Predicted the probability of excessive absenteeism using Logistic Regression Model., Tech Stack - Python, Machine learning models, SQL, Power BI(for visualization).

Timeline

Technical Consultant

Genpact
10.2023 - Current

Full Stack Developer Intern

BCS Infallible Technology
06.2022 - 07.2022

Bachelor of Technology - Computer Science

Amity University
Devangna Jain