Data Analyst Power Bi

SHAILENDRA NUTAKKI

**********@*****.*** LinkedIn: Shailendra Nutakki 346-***-****

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of experience using SQL, Python, and Power BI to drive product growth, fraud detection, and stakeholder decision-making. Delivered high-impact insights through A/B testing, customer segmentation, and KPI frameworks. Skilled in building automated reporting pipelines across AWS and Azure platforms. SKILLS

Languages & Libraries: Python (Pandas, NumPy, Seaborn), SQL, C++ Data Analytics & BI: Power BI, Tableau, Excel, Looker ETL & Data Engineering: ADF, DBT, Airflow, Spark, Databricks, SnowFlake Cloud & Databases: AWS (S3, Athena, Glue), Azure (ADLS), GCP (BigQuery), SQL Server, PostgreSQL AI & Tools: LangChain, LangGraph, LLMs, GPT APIs, Streamlit, Git, Jira, Confluence PROFESSIONAL EXPERIENCE

Data Analyst (Consultant @ Capital One) – Pioneer Tek, TX.Jul 2024 - Apr 2025

● Extracted insights from 6M+ transactional records using SQL on Redshift to analyze credit card usage, churn drivers, and feature adoption; enabled strategic initiatives that led to a 9% increase in user engagement.

● Designed executive dashboards in Power BI and Tableau using DAX, filters, and tooltip drilldowns to monitor product metrics & fraud KPIs, supported quarterly business reviews & cut down manual reporting time by 30%.

● Led A/B testing initiatives with product and fraud teams using cohort-based segmentation and statistical testing (t-test, z-test); uncovered UI frictions and drove a 12% uplift in feature adoption (p < 0.05).

● Segmented 500K+ customers via K-Means clustering using spend patterns, tenure, and activation data, insights that powered targeted marketing campaigns resulting in 9.6% increase in engagement within 3 months.

● Streamlined Airflow-based ETL pipelines on Redshift/PostgreSQL, improving data ingestion reliability for experimentation logs and BI layers, improved data processing speed by 35% and automated KPI refreshes. Business Data Analyst – RBL Bank, Mumbai. May 2021 - Jun 2022

● Designed scalable ETL pipelines with Azure Data Factory and PySpark to ingest 10K+ daily financial transactions, improving data traceability and enabling governance in risk and compliance reporting.

● Consolidated fragmented customer data into a Delta Lake on ADLS Gen2, cutting ETL duration by 60% and enabling accurate CLV modeling for cross-functional analytics.

● Developed lineage-tracked Databricks workflows to meet AML audit standards, boosting Spark performance by 30% and automating BI dashboards that shortened manual reporting by 40%. Business Intelligence analyst –Trucon, India. Jun 2020 - Apr 2021

● Built a Kafka–Spark streaming pipeline to automate property listing ingestion, eliminating manual workflows and reducing analyst intervention by 90%.

● Delivered real-time Tableau dashboards with KPIs and regional filters, enabling pricing insights, cutting ad hoc analysis costs by $15K/year, and improving sales team efficiency through real-time pricing visibility. PROJECTS

FlexiBot – Adaptive AI Chat Agent:

● Developed a multi-agent AI chatbot using LangChain, LangGraph, and GPT-4 APIs with real-time tool routing and metadata-aware responses for analytics and onboarding scenarios.

● Engineered multi-turn logic pipelines with feedback loops to simulate user support flows, minimize hallucinations, and improve model accuracy in live LLM deployments. Retail Sales & Profit Analytics

● Analyzed 10K+ retail transactions using Pandas and SQL Server to uncover KPIs, discount sensitivity, and profitability trends, applied YoY growth and seasonality models to support quarterly sales planning.

● Built executive-level Power BI dashboards with custom DAX measures and regional drilldowns, enabling data-driven promotional strategies and improving subcategory performance tracking in monthly reviews. EDUCATION

University of Houston – Master’s in Engineering Data Science GPA: 3.85/4 BITS Pilani – Bachelor's in Electronics & Communication GPA: 3.75/4 CERTIFICATIONS & AWARDS

● AWS Certified Solutions Architect(SAA-C03)

● Google Data Analytics

Contact this candidate