Hi, I'm Abhishek Kumar Singh

A passionate

About

Data Analyst with 3+ years of experience designing dashboarding (Power BI, Tableau) solutions and writing optimized SQL queries. I specialize in analystics to drive business objectives, with a proven track record of taking full ownership of BI projects from requirements gathering to deployment while ensuring data accuracy.

With an MSc in Business Analytics (Machine Learning) from UMass Lowell (4.0 GPA), I've applied my analytical toolkit—Python, R, SQL, Tableau, and Power BI—across finance, supply chain, healthcare, and data engineering projects. My experience spans building scalable data pipelines with PySpark, creating ML infrastructure on AWS, and developing automated dashboards that accelerate decision-making by up to 40%.

What sets me apart is my ability to translate complex data into actionable insights for both technical and executive stakeholders. Whether it's improving data accuracy to 98%, reducing reporting time by 35%, or building AI chatbots with NLP, I thrive on transforming raw data into business impact.

  • Work Experience: 3+ years in Data Analytics & Engineering
  • Education: MSc Business Analytics (ML) | GPA 4.0
  • Core Strengths: BI Solutions, SQL Optimization, Data Pipeline Development, Statistical Modeling, Stakeholder Communication
  • Top Skills: SQL, Python, Power BI, Tableau, Snowflake, AWS, PySpark
Profile Picture

Education

University of Massachusetts, Lowell

MSc in Business Analytics

Aug 2023 - May 2025

Awards: GPA of 4.00, Beta Gamma Sigma

Coursework: Decision Analytics, Advanced Data Mining, Advanced Machine Learning, Database Management, Statistics for Predictive Modeling, Optimization, Storytelling with Data

Government Engineering College, Wayanad

B.Tech in Mechanical Engineering

Aug 2015 - Jun 2019

Coursework: Object Oriented Programming

Work Experience

Data professional with 3+ years specializing in BI solutions, dash boarding, data engineering, and analytics. Proven track record of building scalable data pipelines, improving data accuracy to 98%, and accelerating decision-making through automated dashboards and predictive analytics.

Professional Experience

Holiday Channel

Data Engineer

Sep 2025 - Present | Boston, MA
  • Engineer automated data collection pipelines using Python (PySpark) to process large-scale datasets from multiple sources, ensuring 100% data availability for statistical analysis and trend identification.
  • Collaborate with data science team to ensure data quality and prepare data for ML applications.
Triple Ring Technologies

Data Science Analyst

Jun 2025 - Sep 2025 | Boston, MA
  • Improved decision-making accuracy by 11% by designing scalable ML infrastructure using AWS SageMaker and Terraform.
  • Accelerated cross-functional alignment by 20% by presenting predictive analytics to executive stakeholders, translating complex data system requirements into clear business insights.
  • Reduced project cycle time by 5% through Agile methodologies and Git version control.
Dell Technologies, Global S&OP Team

Data Analyst – Supply Chain

Jul 2024 - Dec 2024 | Lowell, MA
  • Designed, developed, and maintained Power BI dashboards using complex DAX calculations, accelerating revenue-driven decisions by 40%.
  • Forecasted 2.4M+ Salesforce CRM records using SQL and Power BI to monitor key performance indicators (KPIs) for market efficiency and operational health.
  • Reduced ad-hoc reporting time by 35% through dashboard automation, collaborating with stakeholders to translate requirements into actionable visualizations.
  • Partnered with cross-functional teams to translate complex operational data into actionable strategies, aligning physical processes with financial outcomes.
University of Massachusetts Lowell, Residence Life

Assistant Area Manager

Sep 2024 - May 2025 | Lowell, MA
  • Managed operational capacity for a community of 1,000+ residents, utilizing data analysis to forecast demand trends and optimize resource allocation.
  • Drove measurable improvements in satisfaction (+11%) by analyzing feedback data and re-engineering service protocols to improve operational delivery.
Infosys Consulting

BI Systems Engineer

Dec 2021 - Aug 2023 | India
  • Ensured data accuracy and integrity across reporting solutions during SAP S4/HANA migration, achieving 98% data accuracy.
  • Improved data availability by 3% by identifying and resolving critical SAP BI pipeline bottlenecks.
  • Automated manual reporting processes using Advanced Excel, saving 40+ hours per month and taking full ownership of BI projects from requirements to deployment.

Projects

Here are some of my key projects showcasing my expertise in data analysis, machine learning, business intelligence, and visualization.

Music

Pricing Optimization & Linear Regression in SQL

This project focuses on using SQL for pricing optimization and linear regression to help businesses determine the optimal price point for maximizing revenue.

Dell Volatility Analysis

Operational Volatility Analysis (Dell Technologies)

Developed a framework to quantify operational volatility in 2.4M+ deal records, enabling predictive analytics for high-risk scenarios.

AI

MSBA program specific AI chatbot

Built a custom RAG-based AI chatbot to answer queries from UMass Lowell's MSBA program pages using sentence-transformers and feedback loops & is designed for accurate context retrieval, dynamic response generation, and scalable deployment.

Music

Biomedical Text Classification – Cancer Document Classification (Academic Project)

Built a cancer document classifier using classical ML, ensemble models, and CNN. Achieved 97% accuracy on biomedical abstracts for Lung, Colon, and Thyroid cancers.

Music

E-Commerce User Behavior & Retention Analysis ( Kaggle )

Analyzed user behavior from real e-commerce data using A/B testing, segmentation, and retention modeling & uncovered insights on user value and lifecycle trends through cohort and revenue analysis.

Music

Music Sentiment Impact on Stock Returns Analysis

Pioneered novel market prediction research combining sentiment analysis with Double Machine Learning to uncover hidden patterns in S&P 500 and Russell 3000 indices.

Stock-Portfolio

# 📊 Stock Portfolio Analysis Project

Engineered a risk-optimized investment strategy achieving 91.8% better returns than S&P 500, leveraging CAPM and advanced portfolio analytics.

Dell Volatility Analysis

Inventory Forecast Optimization –(Simulated Data)

Demonstrates how predictive analytics and supply chain simulations can optimize inventory management and improve forecasting accuracy.

COVID SQL Analysis

Exploratory Data Analysis in SQL

Utilized CTEs, temp tables, and views to perform in-depth analysis of COVID-19 data.

Tableau Dashboards

Tableau Dashboards

Collection of interactive dashboards covering various business intelligence and analytics topics.

EDA in Pandas

Exploratory Data Analysis in Pandas

Performed EDA on world population data, leveraging Seaborn for visualizations and outlier detection.

Data Visualizations in Pandas

Data Visualizations using Pandas & Matplotlib

Utilized Matplotlib to visualize Ice Cream Ratings data with heatmaps and bar plots.

Web Scraping

Wikipedia Page Scraping using Python

Used BeautifulSoup to scrape Wikipedia data, clean it, and save it as a structured CSV file.

More projects on GitHub

GitHub

Skills & Certifications

Here's an overview of my technical proficiencies and professional certifications.

Data & Analytics

  • SQL (Expert) - Query Optimization, Complex Joins, Window Functions
  • Python (Advanced) - Pandas, NumPy, PySpark, Data Pipelines
  • R - Statistical Modeling, Predictive Analytics
  • Advanced Excel - Macros, Pivot Tables, VBA
  • Snowflake - Data Warehousing, Query Optimization

Data Visualization & BI

  • Tableau (Certified Data Analyst)
  • Power BI - DAX, Data Modeling, Dashboard Design
  • Looker - Business Intelligence Reporting
  • Matplotlib - Data Visualization in Python
  • Excel Dashboards - Interactive Reporting

Cloud & Data Engineering

  • AWS (Cloud Practitioner Certified) - SageMaker, S3, EC2
  • Terraform - Infrastructure as Code
  • PySpark - Big Data Processing
  • Supabase - Database Management

AI & Methodologies

  • Claude AI & ChatGPT - Prompt Engineering
  • Statistical Modeling - Hypothesis Testing, Regression
  • Root Cause Analysis - Process Optimization
  • Agile & JIRA - Project Management
  • Git - Version Control

I love learning new technologies! For more details, check out:

Contact

Feel free to reach out to me for collaborations, job opportunities, or any inquiries!

Phone:

+1-978-375-****

Loading
Success!
Your message has been sent. Thank you!