Headline

Data Analyst Intern at Bluestock™🔺

About

I spent nearly two years on the shop floor watching products fail — and figuring out exactly why. As a Quality Engineer at Indo-MIM, I didn't just flag defects. I dug into the data behind them — built Excel dashboards, ran root cause analyses, and helped cut supplier rejection rates from 13% to 5%. That work taught me something most analysts learn much later: data only matters when you understand the business problem behind it. That insight is what drives me now as I move fully into data analytics. Since transitioning, I've worked on projects that go well beyond classroom exercises. I analyzed 101,766 hospital encounters in Python and SQL to identify an 11.16% readmission rate and segment high-risk diabetic patients. I mapped 3,200+ cybersecurity threat events across 35 countries and built risk-scoring models from scratch. Every project ends the same way — a clean, stakeholder-ready Power BI dashboard that makes the findings impossible to ignore. My edge isn't just technical. It's that I've sat in production meetings, presented findings to cross-functional teams, and watched decisions get made based on numbers I put together. That context changes how I approach analysis. What I work with: Python · SQL · Power BI · Excel · Pandas · NumPy · Data Cleaning · EDA · Feature Engineering · KPI Reporting What I'm looking for: A Data Analyst role where I can solve real business problems, work with messy real-world data, and grow alongside a team that takes decisions seriously. If you're hiring or just want to connect — reach me at sunilreddybijjam1@gmail.com or message me directly here on LinkedIn.

Location

Andhra Pradesh

AI stack

claude

deepseek

gemini

grok

lovable

metaai

Work experience

Data Analyst Intern at Bluestock™🔺, Jul 2026 - Present · 3 mos, Work From Home, Built an end-to-end ETL pipeline in Python (Pandas) and SQL, consolidating 10 datasets (87K+ transaction rows, 46K+ NAV records) from AMFI India and mfapi.in into a 5-table SQL star schema covering 40 real mutual fund schemes. Performed EDA and computed performance/risk metrics — CAGR, Sharpe Ratio, Sortino Ratio, Alpha, Beta, and Maximum Drawdown — across 4.5 years of NAV history using Python, NumPy, and SciPy. Developed an interactive 4-page Power BI dashboard tracking AUM growth, SIP inflows, fund performance, and investor demographics across 12+ Indian states, with slicers for fund house, category, and date range.

Quality Engineer at INDO-MIM Limited, Jun 2024 - Jan 2026 · 1 yr 8 mos, Tirupati, Built Excel dashboards tracking supplier defect trends across production lines, reducing rejection rates from 13% to 5% over 8 months. Applied 5-Why and 8D root cause frameworks to analyze recurring defect patterns, cutting repeat failures by an estimated 30% across 3 production lines. Created weekly quality metric reports for cross-functional teams of 10+ stakeholders, reducing report turnaround time by ~40%. Analyzed investment casting defect data across 5+ supplier categories, identifying top failure patterns that directly informed procurement decisions. Presented data-driven findings to production and quality leadership, contributing to process changes adopted across 2 manufacturing lines.

Education

Bachelor of Technology, Mechanical Engineering, Sri venkateswara college of engineering