Business Analyst Intern

SANIKA UDAY SHINKAR

Phoenix, AZ *****************@*****.*** +1-602-***-**** Linkedin

WORK EXPERIENCE

Technical Business Analyst, Arizona State University, Tempe, AZ Aug 2024 – May 2025

• Orchestrated collaborative sessions with 15+ university departments to define key performance indicators (KPIs) for optimized reporting; increased data-driven decision-making across IT and public health sectors.

• Built automated dashboards with Excel and BI tools, reducing support tickets by 10%; such KPI-based automation transfers well to healthcare performance tracking or financial help desks.

• Introduced enhanced collaborative framework between business and IT divisions, creating clear workflows that enhanced oper- ational precision and allowed the team to meet project deadlines 95% of the time. Business Intelligence Extern, Beats by Dre, Los Angeles, CA Dec 2024 – May 2025

• Developed 10+ Tableau dashboards using SQL to analyze GenZ preferences and brand sentiment; skills applicable to hospital reporting (e.g., patient satisfaction metrics) and consumer analytics in finance and IT sectors.

• Forged cross-functional partnerships, establishing clear analytics reporting frameworks that enhanced care quality evaluations and streamlined client onboarding, resulting in a 20% improvement in project delivery timelines. Business Analyst Intern, Parsetu, Pune, India Jan 2023 – Jul 2023

• Engineered logical BI architecture for healthcare applications using SQL and data warehouse principles, enabling predictive modeling on patient outcomes and optimized resource allocation across 5 hospital departments.

• Collaborated with 10+ cross-functional stakeholders (product, IT, support) to streamline reporting workflows; approach aligns with consulting project delivery in hospital and fintech environments.

• Verified data reporting accuracy within ETL pipelines utilizing comprehensive SQL scripts and test cases, enhancing data governance and supporting the quality of healthcare dashboards by 15%. Business Analyst Intern, Canspirit AI, Pune, India Mar 2022 – Jul 2022

• Leveraged complex SQL queries, including joins and CTEs, to uncover the root causes of delays in financial transaction processing, recommending five actionable steps that could accelerate throughput by 20%.

• Led to 12+ Power BI dashboards integrating KPIs and drill-through filters; enhanced real-time monitoring for incident alerts—translatable to triage systems or fraud detection workflows. PROJECTS

Healthcare Operations Dashboard, Mayo Clinic Simulation Tableau, SQL, Excel

• Designed a real-time Tableau dashboard to track emergency room wait times, patient admission rates, and readmission trends across 5 departments, enabling leadership to reduce patient wait time by 18% and improve bed utilization.

• Processed and joined 70K+ patient visit records using SQL and Excel, uncovering patterns in length of stay and readmission by diagnosis category; insights supported targeted care protocol improvements and operational cost reduction. University Health Services Analytics Dashboard, ASU Tableau, SQL, Excel

• Constructed data visualizations of clinic operations, identifying underutilized resources and bottlenecks; resulting recommenda- tions increased provider efficiency by 10% and patient throughput by 12% across the network.

• Cleaned and analyzed 50K+ records using SQL and Excel to identify inefficiencies; methods apply to workflow redesigns in finance, healthcare operations, or resource allocation studies. Eviction and Crime Analysis of San Francisco Power BI, R, SQL

• Created 5+ interactive dashboards using Tableau providing policy makers and city planners with actionable insights into eviction trends, crime rates and socio-economic patterns across San Francisco.

• Cleaned and integrated 200+ datasets using R and SQL, performing advanced analysis to predict high-risk eviction zones with 90% accuracy, enabling data-driven policy reforms to improve resource allocation. TECHNICAL SKILLS

Languages/BI Tools: SQL, Python, R, MySQL, Power BI, Tableau, DAX, Power Query Data & Analytics: Data Modelling, ETL, Real-Time Reporting, KPI Design (LOS, Readmission), Forecasting Healthcare Ops: Claims Analysis, Patient Flow Metrics, UAT, Healthcare KPIs, EHR Systems (Familiar) IT Consulting/Finance: Agile, JIRA, Confluence, Excel (PivotTables, VLOOKUP), Risk Models Software/Collaboration: Microsoft Office Suite, Figma, Smartsheet, Trello, System Testing Documentation: Requirement Gathering, User Stories, SOP Creation, Data Governance Mapping EDUCATION

Arizona State University, Tempe, AZ May 2025

Master of Science in Engineering Management (Analytics Track) MIT World Peace University, Pune, India Jun 2023

B.Tech in Electronics and Communication Engineering (AI Track)

Contact this candidate