Available for new opportunities

Data & Business Analyst

I build end-to-end analytics solutions that transform raw data into actionable insightsβ€”from SQL queries and ETL pipelines to interactive dashboards and automated reporting. Focus: Financial Analysis, Business Intelligence, Data Visualization, and KPI Development using Python, SQL, Power BI, and Snowflake.

Microsoft Azure AI IBM Applied AI IBM Generative AI for Software Developers Databricks GenAI
✨ Try FinSight β†’ πŸ“„ Resume πŸ’Ό LinkedIn πŸ‘¨β€πŸ’» GitHub

SQL β€’ Python β€’ Power BI β€’ Tableau β€’ Snowflake β€’ Excel β€’ DAX β€’ ETL β€’ Financial Analysis β€’ KPI Development β€’ Data Visualization

Additional Projects

KPIFlow AI – Self-Service Analytics

Self-service analytics platform enabling non-technical users to upload CSV/Excel files and instantly generate KPI dashboards with automated insights, trend analysis, and exportable visualizations.

Python Pandas Streamlit Plotly Data Viz BI

AI Financial Scenarios – CFO Forecasting

~40% faster iterations

Financial scenario modeling tool for CFO-level forecasting. Upload historical data, adjust assumptions, and generate comprehensive forecasts with executive summaries and scenario comparisons.

Financial Modeling Python Pandas Forecasting Scenario Analysis

FinSight LLM – Finance Q&A Platform

+25–30% accuracy

Finance-specific Q&A system providing instant answers to financial questions. Optimized for analyzing financial statements, understanding metrics, and explaining complex financial concepts.

Finance Q&A System Data Analysis Next.js

SplitChamp AI – Receipt Data Extraction

95%+ accuracy

Automated receipt data extraction app parsing restaurant receipts into structured data with line items, taxes, and tips. Mobile-first design with instant processing capabilities.

Data Extraction OCR React Native Automation

GhostTab AI – Productivity Analytics

Chrome extension for tracking and analyzing productivity patterns. Automated content summarization, focus time tracking, and tab management with visual analytics dashboards.

Analytics Chrome Extension Data Tracking Automation

Professional Highlights

What I Do

Build end-to-end analytics solutions that transform raw data into actionable business insights. From SQL queries and ETL pipelines to interactive dashboards and automated reporting, I focus on accuracy, clarity, and business impact. Every analysis drives data-informed decisions.

Toolbox

  • Analytics Tools: SQL, Python (Pandas, NumPy), Excel (Pivot Tables, VLOOKUP, Macros, VBA)
  • Visualization: Power BI, Tableau, Plotly, Matplotlib, Seaborn, Streamlit
  • Data Warehousing: Snowflake, BigQuery, Azure SQL, PostgreSQL, ETL/ELT pipelines
  • Business Skills: Financial Analysis, KPI Development, Variance Analysis, Forecasting, Market Research, A/B Testing
  • Languages: Python, SQL, JavaScript/TypeScript, DAX, Power Query (M), HTML/CSS

Key Achievements

  • βœ“80% reduction in manual reporting time through automated FP&A dashboards
  • βœ“End-to-end ownership of data pipelines from extraction to visualization
  • βœ“95%+ accuracy in automated data extraction and processing systems
  • βœ“Self-service analytics platforms enabling stakeholders to generate insights independently

Education & Certification

University of Pittsburgh β€” B.S. in Computer Science (April 2024)

  • Microsoft Azure AI Engineer Associate β€” Exam Oct 2025
  • IBM Applied AI Developer β€” Issued Oct 2025
  • IBM Generative AI for Software Developers β€” Issued Oct 2025
  • Databricks Generative AI Fundamentals β€” Issued Oct 2024

About Me

I'm passionate about the intersection of data analysis and business impact. My approach is pragmatic: understand the business question, find the right data, analyze it thoroughly, and present insights in a way that drives action. Whether it's building financial models, creating dashboards, or automating reporting workflows, the goal stays the same: measurable business outcomes.

Get In Touch

williamcjk11@gmail.com (773) 415-4606 LinkedIn GitHub
πŸ“₯ Download Full Resume