AJ

Akshay Jain

Consultative Data & Analytics Professional

Consultative analytics partner for business-facing teams
Turns ambiguous requests into structured, adopted solutions
Translates technical complexity into clear business decisions
Moves quickly while protecting accuracy and trust
Helps teammates unblock analysis, reporting, and delivery problems
Strong ownership across discovery, build, rollout, and iteration
Looks beyond requirements to suggest better analytical approaches
Consultative analytics partner for business-facing teams
Turns ambiguous requests into structured, adopted solutions
Translates technical complexity into clear business decisions
Moves quickly while protecting accuracy and trust
Helps teammates unblock analysis, reporting, and delivery problems
Strong ownership across discovery, build, rollout, and iteration
Looks beyond requirements to suggest better analytical approaches

I turn ambiguous business questions into data products people use to make better decisions.

My work spans stakeholder discovery, enterprise BI, data modeling, automation, and user-facing analytics apps. This portfolio brings together measurable business impact, newer GitHub builds, and an AI guide that answers from the same structured source of truth.

Why teams hire me

Enterprise BI builder with strong product instincts

I connect stakeholder discovery, data modeling, automation, and UX into reporting people actually use.

Consultative problem-solver in ambiguous spaces

My best work starts with unclear business questions and turns them into practical, measurable decisions.

Explore featured workLaunch AkshayGPT
Impact

1000+

Users on flagship dashboard

Built a flagship Power BI reporting experience that became one of the most active dashboards in the company.

Impact

2000+

Hours saved through automation

Reduced manual reporting at scale by replacing recurring Excel-heavy workflows with automated BI reporting.

Impact

30%

Client engagement lift

Architected executive-level KPIs, driving accountability and reducing missed communications by 80%

Why this format works

Recruiter clarity, hiring-manager depth, and AI-assisted exploration in one place

The portfolio is organized around one story: business problems clarified, data systems built, and decisions made easier.

Recruiter path

Analyze role fit against a real job description

Paste a JD and get a recruiter-friendly fit summary, top priorities, honest strengths, and realistic gaps.

Open Recruiter Tool

Hiring manager path

Business-facing depth across BI, ETL, and data products

See how stakeholder problems became usable reporting systems, data apps, and decision tools.

See featured work

Interactive path

Explore the portfolio with AkshayGPT

Ask focused questions about projects, business impact, technical strengths, and working style.

Launch AkshayGPT

Career history

Enterprise analytics delivery with independent product building alongside it

The strongest signal is Holman: clarifying stakeholder needs, shaping modern BI systems, and driving adoption at enterprise scale.

Holman

Analytics Engineer

Mount Laurel, New Jersey•July 2023 - Present

Owns business-facing analytics delivery from problem discovery through rollout, turning ambiguous operational needs into Power BI reporting, SQL/Python logic, dbt and Databricks transformations, and reusable semantic models.
  • Delivered Holman's flagship Power BI dashboard by consolidating multiple consulting reports into a single semantic-model-driven experience, now actively used by 1,000+ users enterprise-wide.
  • Architected a Microsoft Fabric Metrics KPI for senior leadership that drove a 30% lift in active client engagement and an 80% reduction in missed client communications, directly improving account-management accountability.
  • Consolidated 8 call-center data sources into a unified reporting model, eliminating Excel-heavy workflows and saving 2,000+ hours through automation; further reduced average speed of answer by 15 seconds through PO complexity scoring that distinguished simple versus complex calls and surfaced agent handling patterns.
  • Built a KPI benchmarking solution that normalized 20 client KPIs, enabling client-to-client, peer-group, and industry-level comparisons that strengthened client conversations and supported retention efforts.
  • Engineered advanced DAX measures, calculation groups, and RLS frameworks with deep expertise in filter context, row context, and expanded table behavior; used DAX Studio log timings and Tabular Editor to systematically eliminate bottlenecks and optimize query performance across enterprise datasets.
  • Designed dbt models, macros, and Azure Databricks SQL transformations to move curated data through silver-to-gold layers, powering star-schema semantic models for enterprise Power BI reporting.
  • Implemented Git-based BI deployment workflows using Power BI PBIR artifacts, CI/CD pipelines, and source-controlled releases across environments, standardizing and de-risking the delivery lifecycle.
  • Partnered with Account Managers, Fleet Managers, and IT leaders to translate loosely defined business needs into trusted analytical solutions, including executive-level analysis on auto-approval rejection patterns and service behavior that gave VP-level stakeholders clearer visibility into training and operational opportunities.
  • Presented dashboard work at IBIS 2024 in Phoenix and internal seminars, consistently translating complex technical design decisions into measurable business value for mixed technical and executive audiences.
Power BISQLPythondbtAzure DatabricksGitCI/CDMicrosoft FabricDAXSAP BusinessObjects

Collabera

Data Analyst Intern

Basking Ridge, New Jersey•May 2023 - July 2023

Improved KPI reporting performance and model structure for business users who needed faster, clearer operational visibility.
  • Optimized SQL queries and Power BI models, reducing report rendering time by 30%.
  • Built a dimensional calendar and DAX-led reporting structure that improved reporting efficiency by 15%.
  • Built KPI dashboards that gave stakeholders clearer performance signals.
Power BIDAXSQL Server

LabWare

Data Science Intern

Wilmington, Delaware•June 2022 - September 2022

Connected ETL, machine learning, and visualization so non-technical teams could interpret model outputs more easily.
  • Developed an end-to-end ETL pipeline using Python, AWS S3, and Snowflake for crime data analysis.
  • Engineered an XGBoost model that predicted crime types with 80% accuracy.
  • Translated machine learning outputs into Tableau dashboards for intuitive stakeholder use.
PythonTableauAWS S3SnowflakeXGBoost

Snapshot

  • Authorized to work in the U.S. on an H-1B visa.
  • Open to relocation and conversations around analytics engineering, data engineering, BI, and data product roles.
  • Strongest in roles that need business-facing problem solving and strong technical follow-through.

What stands out

Owns both backend data shaping and frontend reporting experiences.

Works comfortably with stakeholders, executives, and operational teams.

Looks beyond the initial ask to suggest simpler, clearer, or more useful approaches.

Education

M.S. in Business Analytics

Drexel University

Philadelphia, Pennsylvania • August 2021 - March 2023

B.E. in Electronics and Telecommunication

Savitribai Phule Pune University

Pune, India • July 2016 - April 2020

Featured work

Recent GitHub projects that show applied problem solving

These public builds demonstrate geospatial decision support, production backend thinking, product UX, and developer workflow design.

Independent product build

H-1B Wage Map

2026
Immigration intelligenceLive

Built an interactive geospatial decision tool that helps H-1B applicants compare county-level wage competitiveness under the FY 2027 weighted selection rule.

Product builder, data engineer, frontend engineer

Why this matters

Shows how an ambiguous policy change became a practical tool for high-stakes personal decision-making.

Design brief

Applicants need a clearer way to evaluate how job titles, counties, and wage levels affect H-1B odds under the new selection process.

  • Combined DOL wage data with historical filing data into a geospatial decision tool.
  • Used static JSON sharding to support fast search across 200,000+ filing records without a traditional backend database.
  • Added county-level safety visualization, employer filing lookup, and AI-assisted SOC matching to reduce user guesswork.
Next.jsTypeScriptTailwind CSSMapboxPythonPandas
GitHubLive demo

Real-world application backend

GitDecode

2026
Developer intelligenceProduction support

Built a FastAPI backend that turns public GitHub activity into structured engineering signals and recruiter-friendly candidate summaries for a Chrome extension workflow.

Backend engineer, data engineer, and AI systems builder

Why this matters

Shows ownership of a messy evaluation problem, from API design and data ingestion to scoring logic and AI-assisted explanation.

Design brief

Recruiters and hiring teams need a faster way to turn public GitHub activity into structured engineering signals instead of relying on manual repo scanning.

  • Converts GitHub GraphQL activity into normalized behavioral features.
  • Computes deterministic dimensions such as execution, collaboration, ownership, maintenance, and credibility before generating narrative summaries.
  • Supports a real Chrome extension experience with recruiter-facing outputs, evidence grouping, placement guidance, and health-check endpoints.
PythonFastAPIGitHub GraphQLFeature EngineeringOpenAIData Pipelines
GitHubChrome extension

Independent product build

Net Worth Tracker

2026
Personal financeLive

Built a private financial dashboard for net-worth tracking, historical snapshots, portfolio analysis, and long-term goal monitoring.

Frontend-heavy product builder

Why this matters

Shows thoughtful data UX beyond traditional reporting, with financial information organized around personal decisions.

Design brief

Most budgeting tools are not designed for high-level wealth tracking, custom asset mixes, or clean historical snapshot analysis.

  • Designed a ledger-driven dashboard for assets, liabilities, goals, and historical net worth changes.
  • Used immutable snapshots to preserve point-in-time financial history.
  • Focused on privacy-first product design with Google OAuth and Firestore-backed persistence.
ReactTailwind CSSFirebaseFirestoreFramer MotionRecharts
GitHubLive demo

Independent VS Code product build

Contextly

2026
Developer toolingLive on Marketplace

Built a local-first VS Code extension that saves reusable AI context inside each workspace so developers can reopen structured prompts without retyping setup.

Product engineer and extension builder

Why this matters

Shows product-minded engineering across extension UX, local storage design, prompt structure, and real developer workflow integration.

Design brief

Developers repeatedly rewrite repo-specific schema notes, business rules, and prompt constraints across AI chats, which creates friction and inconsistent outputs.

  • Stores prompt context locally in a hidden `.contextly.json` file so context stays workspace-specific and shareable through Git when teams want it.
  • Structures prompt context into intent, task, context, constraints, and output format instead of one long note.
  • Includes a status-bar picker, management dashboard, search, clipboard copy, and VS Code chat prefill for fast day-to-day use.
TypeScriptVS Code Extension APIESBuildLocal JSON StorageProduct UX
GitHubVS Code Marketplace

Selected analysis work

Earlier projects that still show strong analytical depth

These remain useful evidence of NLP, customer analytics, and translating raw datasets into business signals.

Starbucks Drink Recommendation

Starbucks Drink Recommendation

2023

Analyzed social media data to identify Starbucks brand perception and engagement patterns through topic modeling.

PythonNLPTopic ModelingREST APIData Scraping
View repository
E-Commerce Customer Purchase Analysis

E-Commerce Customer Purchase Analysis

2023

Analyzed customer reviews and recommendation behavior to identify what drives product advocacy.

PythonPandasPower BINLTKScikit-learn
View repository

Skills & toolbox

Tools organized around decision support

The toolset matters most because it helps turn unclear business questions into trusted, usable systems.

Decision Analytics

Power BIDAXKPI designExecutive reporting

Data Products

Next.jsReactTypeScriptTailwind CSSStreamlitMapbox

Data Modeling & Platforms

SQLdbtSemantic modelingAzure DatabricksMicrosoft FabricPostgreSQL

Automation & ML

PythonPandasETL automationScikit-learnXGBoostNLP workflows

Get in touch

Open to teams that need data work close to real business decisions.

If you're hiring for analytics, BI, or product-minded data work, I'd love to connect.

Email

akshayjain128@gmail.com

Calendly

Book a 30-minute intro

LinkedIn

linkedin.com/in/akshayjain128

Resume

Download PDF