Majeti Krishna Vamsi

AI Augmented Data Analyst & Analytics Engineer
N/A, US.

About

Highly skilled AI Augmented Data Analyst & Analytics Engineer with expertise in SQL, Python, Power BI, and LLM-driven insight generation. Proven ability to build end-to-end analytics workflows, data models, and ETL pipelines, leveraging cloud fundamentals and AI governance principles to deliver scalable solutions. Adept at translating complex business needs into actionable, data-driven strategies, combining technical depth with advanced problem-solving capabilities.

Work

Self-driven Industry Projects
|

AI Augmented Data Analyst

N/A, USA, US

→

Summary

Led diverse data analytics and business intelligence projects, applying advanced SQL, Power BI, and LLM automation to deliver actionable insights and scalable solutions.

Highlights

Spearheaded the design and implementation of comprehensive BI systems and analytical dashboards across various domains including e-commerce, HR, retail, and hospitality.

Leveraged advanced SQL and statistical methods to perform profitability modeling, segmentation, anomaly detection, and time intelligence analysis on large datasets.

Integrated LLM-assisted insights and automation into analytics workflows, significantly reducing manual analysis and summary time by up to 60%.

Developed interactive dashboards using Power BI, Excel, Google Looker Studio, and IBM Cognos Analytics to visualize complex data, support executive decision-making, and demonstrate BI storytelling.

Education

New England College, USA
N/A, USA, United States of America

→

Master's

Computer Information Systems

Grade: 3.74/4.00

Courses

Database design

Python programming

Cloud computing concepts

Machine learning & Data science

Koneru Lakshmaiah University, India
N/A, India, India

→

Bachelor's

Electronics & Communication Engineering

Grade: 7.55/10.00

Courses

Python programming

SQL

Discrete mathematics

Strategic leadership & management

Awards

Graduate Record Examinations (GRE) Score

Awarded By

Educational Testing Service (ETS)

Achieved a score of 320/340 on the Graduate Record Examinations, demonstrating strong quantitative and verbal reasoning abilities.

Certificates

SQL (Basic, Intermediate & Advanced)

Issued By

HackerRank

Data Analyst Professional Certificate & Generative AI: Prompt Engineering Basics

Issued By

IBM

Corporate, Business Strategy, Strategic Leadership & Management Capstone

Issued By

University of Illinois

Jira

Issued By

Coursera Project Network

AI Augmented Insights & LLM Workflow Essentials

Issued By

Applied Practice

Introduction to Responsible AI

Issued By

Google

Skills

Core Strengths

Analytical thinking, Business Insights, Clear communication, Strategic mindset.

Technical Tools

Excel (Advanced Formulas, Power Query, Automation), SQL (PostgreSQL, pgAdmin, MySQL, T-SQL), Python (Pandas, NumPy, Matplotlib), Power BI (DAX, Power Query, Data Modeling), GitHub, VS Code, Jupyter Notebook, IBM Cognos Analytics, Google Looker Studio (GLS), AWS S3, Athena basics, LLM Tools (ChatGPT, Copilot, MS Office, Task Intelligence, AI Supervision).

AI Augmented & LLM Skills

AI assisted data analysis, LLM driven insight generation, Prompt Engineering (Analyst level), AI assisted data cleaning & validation, AI Governance basics, AI for summaries, KPI narratives, Storytelling, Automation using Python + LLM workflows.

Data Analytics Skills

Data cleaning & transformation, KPI & metric design, Exploratory Data Analysis (EDA), BI reporting & dashboarding, Statistical analysis, Time series analysis, Business requirement translation.

Analytics Engineering Skills

Data Modeling (Star, Snowflake, Entity relationship modeling), ETL/ELT Concepts, Pipeline logic, API Integration basics, Cloud Fundamentals (AWS / Azure / Snowflake basics), Query optimization, Window Functions, CTE's, Joins, Aggregations.

Cloud & Data Engineering Basics

AWS (S3, Athena, Glue basics), Azure Fundamentals (ETL & Data concepts), Snowflake (Fundamentals), Data Pipelines (ETL/ELT Concepts).

Version Control & Workflow

Git & GitHub, Jupyter Notebook, VS Code, Documentation.

Projects

Sentinel AI Business Intelligence System

→

Summary

Designed and implemented an end-to-end BI system leveraging SQL, Power BI, Data Modeling, and LLM Automation to deliver comprehensive analytics for e-commerce.

HR Employee Dashboard & Bonus Statistics Analysis

→

Summary

Developed an HR analytics solution using Excel, Power Query, and statistical methods to analyze employee data and bonus statistics.

Retail Sales & Global Orders Dataset Analysis (SQL)

→

Summary

Conducted in-depth analysis of multi-table retail datasets using advanced SQL techniques to derive customer and product insights.

Sales & Performance Dashboard (Power BI | DAX | Data Modeling)

→

Summary

Designed and implemented a comprehensive sales and performance dashboard using Power BI and DAX for executive decision-making.

Global CO2 Emissions Dashboard (IBM Cognos Analytics)

→

Summary

Created a multi-page dashboard using IBM Cognos Analytics to analyze global CO2 emissions by country, region, and income group.

Hotel Bookings & Revenue Analytics (Google Looker Studio)

→

Summary

Performed in-depth analysis of hotel booking data and developed an interactive dashboard using Google Looker Studio.