Summary
Overview
Work History
Education
Skills
Websites
Certification
Projects
Timeline
Generic

Abhijeet Neog

Bangalore

Summary

Dedicated and results-driven professional with expertise in data analytics and database architecture. Known for meticulous attention to detail, rapid adaptability, and a collaborative team-oriented approach. Committed to delivering top-tier solutions with a strong sense of ownership and excellence in all endeavors.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Decision Analytics Associate

ZS Associates
01.2024 - 07.2024
  • Led data analysis for GitHub and ISV workstreams, employing PySpark for streamlined data extraction and exploratory data analysis
  • Utilized complex SQL queries to process and transform large datasets, ensuring data accuracy and integrity
  • Implemented A/B testing methodologies to assess the impact of marketing campaigns, applying Z-score and p-value calculations for statistical significance checks
  • Developed and implemented analytical models using Pandas and NumPy for data manipulation and statistical analysis, uncovering actionable insights
  • Utilized Seaborn for data visualization, creating clear and insightful plots to communicate findings to stakeholders
  • Leveraged Power BI with advanced DAX formulas to develop interactive dashboards and reports, facilitating data-driven decision-making for high-profile marketing campaigns
  • Contributed to strategic optimization of marketing initiatives, driving impactful insights to enhance user acquisition and campaign effectiveness.

Business Analyst - ETL

EXL Service
07.2022 - 12.2023
  • Spearheaded development of an Al auditing platform, collaborating with stakeholders to translate business needs into actionable insights
  • Architected a robust data framework for the insurance industry, optimizing system performance by 50%
  • Automated ETL processes using AWS Glue, seamlessly loading data from AWS S3 to database tables
  • Created Power BI dashboards from scratch to display live auditing results for claims
  • Utilized Pandas and Numpy to clean and transform data before loading it into database tables, ensuring data integrity and efficiency.

Education

Bachelor of Technology - Mechanical Engineering

National Institute of Technology Silchar
Silchar, Assam
05.2022

12th -

Crescent Academy Jorhat
Jorhat, Assam
01.2018

10th -

Jorhat Govt. Boys' H.S & M.P School
Jorhat, Assam
01.2016

Skills

  • Python
  • SQL
  • Power BI
  • PySpark
  • Tableau
  • Alteryx
  • Excel
  • Data Architecture
  • ETL
  • Marketing Analytics
  • Insurance Audit

Certification

PL-300 Microsoft Power BI Data Analytics Associate, ZS Associates, 2024

Projects

Email Spam Detection, 07/2024 - 07/2024, Implemented email spam detection using vectorization techniques, analyzing historical data to classify emails with high accuracy., Enhanced model efficiency by optimizing feature extraction and selection processes, resulting in improved spam detection performance.


House Price Prediction, 06/2024 - 07/2024, Utilized linear regression to predict house prices, analyzing features such as locality, age, and area, resulting in accurate forecasting models., Conducted data preprocessing and feature selection to enhance model performance, improving prediction accuracy for real estate valuation.

Timeline

Decision Analytics Associate

ZS Associates
01.2024 - 07.2024

Business Analyst - ETL

EXL Service
07.2022 - 12.2023

Bachelor of Technology - Mechanical Engineering

National Institute of Technology Silchar

12th -

Crescent Academy Jorhat

10th -

Jorhat Govt. Boys' H.S & M.P School
Abhijeet Neog