Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact
Hello, I am

Harshavardhan Pailla

Data Aspirant
Resume
Harshavardhan Pailla

1

Excel
Project

2

PowerBI
Projects

About

Me

Welcome to my portfolio website! I’m a Data Analyst with 3 years of experience turning complex datasets into clear, actionable insights that drive performance across finance, healthcare, and e-commerce. Skilled in SQL, Python, Excel, Power BI, and Tableau, I specialize in building interactive dashboards, streamlining ETL pipelines, and applying statistical techniques like A/B testing, forecasting, and anomaly detection to solve business problems.

From developing predictive models and automating compliance reporting at Edward Jones to optimizing marketing campaigns and customer segmentation at LTIMindtree, I’ve consistently delivered results that improved efficiency, accuracy, and revenue outcomes. I thrive in fast-paced, data-driven environments where impact matters.

With a Master’s in Computer Science and hands-on experience across cloud platforms like AWS, GCP, and Snowflake, I bring both technical depth and business understanding to every project. Explore my portfolio below to se

Key

Skills

SQL, Python, Excel, Power BI, Tableau, Looker, dbt, Alteryx, Apache Airflow, Snowflake, BigQuery, Redshift, AWS (S3, Lambda, Redshift), GCP (BigQuery, Dataflow)

Data Cleaning, ETL, A/B Testing, Forecasting, Anomaly Detection, Dashboarding, Data Warehousing, Predictive Modeling, Time Series Analysis

My

Projects

AtliQ Global Sales & Profitability Analysis
AtliQ Global Sales & Profitability Analysis

Domain/Function: Financial Analytics / Sales Performance

Developed an interactive sales and profitability dashboard using Power BI to analyze performance across 20+ countries. Tracked YoY growth, target deviations, and profit margins, helping business leaders identify top-performing markets and areas of concern.

See My Work Excel
Business Insights 360 – Enterprise Performance Dashboard
Business Insights 360 – Enterprise Performance Dashboard

Domain/Function: Business Intelligence / Enterprise Performance

Developed a full-suite BI dashboard in Power BI providing 360° visibility into Sales, Finance, Marketing, and Supply Chain. Enabled executives and analysts to monitor profitability, growth, and forecast accuracy across global operations.

See My Work PowerBI
U.S. Healthcare Trends & Insights Dashboard (2019–2020)
U.S. Healthcare Trends & Insights Dashboard (2019–2020)

Domain/Function: Healthcare Analytics / Financial & Operational Intelligence

Developed an interactive Power BI dashboard analyzing U.S. healthcare trends across hospitals, patients, and providers. It tracks KPIs like AR, CPT units, lifestyle risks, revenue, and spending, aiding strategic planning for health leaders.

See My Work PowerBI

My

Experience

🔹 Edward Jones — Data Analyst

St. Louis, MO | Oct 2024 – Present

  • Designed Tableau dashboards used by 20,000+ advisors, boosting client satisfaction and advisor productivity by 17%

  • Automated compliance reporting with Python & SQL, cutting audit prep time by 42% and ensuring SOX/HIPAA compliance

  • Built ARIMA/Prophet-based forecasting models, improving quarterly asset growth planning by 30%

  • Created predictive churn models and anomaly detection pipelines, reducing transaction errors by 70% and improving retention by 15%

  • Streamlined recurring reporting using Alteryx, saving 35+ hours/month and enhancing data consistency

🔹 LTIMindtree — Data Analyst

India | Apr 2021 – Jul 2023

  • Built ETL pipelines with Python, SQL, and dbt, reducing manual processing by 40%

  • Developed Power BI dashboards with storytelling KPIs, decreasing weekly analysis time by 55%

  • Performed customer segmentation (K-means, RFM), increasing customer lifetime value by 17%

  • Executed 20+ A/B tests with statistical rigor, improving campaign conversions by 18%

  • Tuned Snowflake/BigQuery performance and reduced cloud spend by $70K annually

  • Automated Excel-based reporting via VBA and Power Query, cutting report time from 3 days to 6 hours


Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals