Data Analyst - Python, SQL, Power BI Expert

Khushita Joshi

Boston, MA ***************@*****.*** 857-***-**** in/khushita-joshi

PROFESSIONAL SUMMARY

Data Analyst with 4+ years of experience delivering product and operational insights through SQL, Python, and Power BI dashboards. Proven at defining KPIs, running experiments, automating reporting, and translating analysis into clear recommendations for senior stakeholders. Skills

Programming & Querying: Python, SQL

Databases & Warehousing: MySQL, PostgreSQL, Snowflake, BigQuery (familiarity), Databricks (exposure) Cloud Platforms: AWS (S3, Lambda, Glue)

Data Engineering & Automation: dbt, Airflow, REST APIs, Postman Version Control: Git/GitHub

Machine Learning & AI: Applied Machine Learning (Regression, Classification), Feature Engineering, Model Evaluation, RAG Pipelines, Vector Databases, Large Language Models (OpenAI, LLaMA, Claude), Prompt Engineering, Semantic Search BI & Analytics: Power BI (DAX, Power Query), Tableau, Looker (familiarity) Statistics & Methods: A/B Testing, Hypothesis Testing, Regression Analysis, Time Series Analysis, Cohort & Funnel Analysis, Segmentation, KPI Development EXPERIENCE

Data Analyst

HyperNex Technologies July 2025—Present, Remote, Boston, MA

•Standardized interconnection and filing datasets using Python automation and SQL transformations with CTEs and window functions in cloud warehouses, improving cross-state comparability by 20%

•Built client-facing Power BI dashboards with DAX calculations surfacing approval timelines, backlog risk, and congestion metrics used in renewal conversations

•Automated cross-environment QA checks with dbt tests, Python scripts, and Airflow schedules, reducing production defects and client escalations by 50%

•Performed cohort and trend analyses on docket volumes and processing delays, delivering insights that guided feature prioritization

•Presented executive and customer briefings, translating regulatory complexity into recommendations, shaping product roadmap, and retention strategy

•Partnered with product, sales, and regulatory teams to intake data requests, define KPIs, and standardize metric definitions across dashboards and client reports.

Software Engineer Intern

Flow (ForTheGood PBC)May 2024—Aug 2024, Boston, MA

•Built a Retrieval-Augmented Generation (RAG) chatbot using Python, LangChain, OpenAI embeddings, and vector search to answer franchise questions from SOPs, contracts, and regulatory PDFs

•Designed document-ingestion pipelines, parsing PDFs and spreadsheets into structured tables, improving analyst research turnaround time by 15%

•Performed EDA in Python and SQL on pickup routes, contamination logs, and processing volumes, identifying inefficiencies that informed routing-optimization pilots

•Created Power BI dashboards with advanced DAX measures to track diversion rates, franchise utilization, and processing backlogs for operations

•Collaborated with product and sustainability teams to deploy prototypes in AWS, document workflows, and present findings to executives Data Analyst

Xyphramin Technologies - ICICI Bank Jan 2020—Jul 2023, India

•Investigated reconciliation failures by querying Snowflake with advanced SQL using CTEs and window functions, plus Python profiling scripts, reducing daily mismatches by 12%

•Built automated Python cleaning pipelines and Excel audit templates to flag duplicate merchants and missing KYC attributes, driving workflow changes that increased approval rates by 6%

•Developed Power BI dashboards and complex DAX measures tracking authorization funnels, chargebacks, revenue leakage, and GTM performance, reviewed weekly by ICICI risk leaders

•Implemented automated data quality tests via Great Expectations and dbt tests orchestrated through Airflow, preventing schema drift from impacting regulatory submissions

•Led experimentation and deep-dive analyses on fraud rules and onboarding policies, presenting statistical recommendations to banking stakeholders.

•Partnered with cross-functional teams to define data KPIs and reporting frameworks, ensuring alignment between analytics and strategic business goals PROJECT

Intelligent Data Pipeline Modernization & Real-Time Analytics

•Built automated data pipelines using Python, SQL, and Snowflake to streamline processing and reduce manual intervention across reporting workflows

•Developed interactive Tableau and Power BI dashboards to improve data visibility, operational monitoring, and data-driven decision-making Credit Card Portfolio Analytics Platform

•Designed an interactive Power BI dashboard analyzing credit card revenue, interest income, utilization, and customer segmentation across demographics and card categories to support portfolio decision-making

•Built DAX measures and Power Query transformations to compute financial and risk metrics, enabling consistent KPI tracking and executive-ready reporting EDUCATION

Master of Science in Computer Science

Worcester Polytechnic Institute - Worcester, MA • May 2025 Bachelor of Engineering in Information Technology

Thakur College of Science and Commerce - India • July 2020

Contact this candidate