Business Systems & Data Analytics Analyst

YASH BHIMANI

Business Systems Analyst Business Analyst

Irving, TX 682-***-**** ***************@*****.***

www.linkedin.com/in/yashbhimani-ba-da yashbhimani1601-ba.github.io/yash-bhimani-portfolio

PROFESSIONAL SUMMARY

Business Systems Analyst with 6+ years across healthcare, DME, construction, and supply chain, spanning requirements, process redesign, system implementation, and reporting across healthcare, construction, and supply chain.Owns delivery end to end — BRDs, FRDs, user stories, and acceptance criteria through SIT, UAT, and go-live — including a greenfield ERP launched across 5 departments in 3 months. Currently leads AI document intake, RFID, revenue cycle, and enterprise Power BI work. MS in Business Analytics; SQL, Power BI/DAX, Python, Tableau, Excel.

PROFESSIONAL EXPERIENCE

Business Systems Analyst

UniversalMed Supply, Irving, TX, Oct 2024 to Present

Durable medical equipment provider serving about 8,000 patients across 8 departments, 4 warehouses, and 250 staff.

•Own requirements across 8 departments and 10+ stakeholders, facilitating discovery workshops and producing BRDs, FRDs, use cases, acceptance criteria, and RTMs across 15 releases.

•Led AWS Textract and Bedrock document-intake solution processing approximately 375 documents per day and contributing to an estimated 70% reduction in manual document review time.

•Launched a patient portal supporting approximately 5,000 patients and 10-15 new registrations per day, defining user journeys, business rules, workflow requirements, and rollout readiness.

•Designed payer-specific prior authorization rules mapping HCPCS codes to payer transactions, cutting missing-authorization exceptions by 82% post-go-live.

•Built payer-level denial analytics in Power BI and DAX using MariaDB summary tables and Waystar remittance data, supporting revenue-cycle actions associated with a 38% reduction in claim denials.

•Delivered SIT, UAT, and rollout for an RFID solution tracking 5,600 items across 4 warehouses, increasing inventory count accuracy from 78% to 93% and reducing cycle counting from 16 hours to 2 hours per warehouse.

•Run sprint planning, backlog refinement, demos, defect triage, and release coordination; trained 250 users, reaching 87% adoption within 2 weeks.

•Established the company's Power BI environment from the ground up across 8 departments, defining Dev, Test, and Prod workspaces, Entra ID access groups, row-level security, publishing controls, and governance standards for enterprise reporting.

•Define API integration requirements across ERP, MariaDB, and the reporting layer while supporting HIPAA-compliant handling of patient and operational data.

Data Analyst Intern

CHRISTUS Health, Irving, TX, Jan 2024 to Apr 2024

•Validated 55,000 patient and operational records across 15 facilities in Snowflake using SQL and Python, investigating discrepancies and coordinating resolution with business owners.

•Automated weekly and monthly reporting in Power BI and Power Query as well as data cleaning using python, reducing report preparation time by 25% while standardizing KPI definitions and reporting outputs.

•Built an inventory forecasting model to identify slow-moving items and support replenishment decisions, contributing to an 18% reduction in stockouts.

Business Analyst

Everest Group, Vadodara, India, Jan 2019 to Jul 2022

•Led development for a greenfield custom ERP, facilitating stakeholder discovery, mapping current- and future-state processes, and performing gap analysis with department heads.

•Delivered the ERP in 3 phases over 3 months across 5 departments, 19 users, and covering 10 business domains.

•Migrated legacy spreadsheet data into a MySQL-based ERP, eliminating duplicate data entry across 5 departments and centralizing operational records.

•Built feasibility models for 10 real estate developments and presented go/no-go recommendations to the Managing Director and CEO.

•Automated 12 recurring reports using Excel, Power Query, and VBA, saving approximately 125 hours annually across management and department teams.

•Built 8 Power BI and Tableau dashboards for leadership covering sales, inventory, project, and financial performance and integrating those with new ERP.

•Developed a consumption forecast covering 3,000 construction materials, enabling advance buying and reducing excess purchasing by 27%.

Junior Business Analyst

Elkins Tradelink Pvt. Ltd., Rajkot, India, Nov 2017 to Dec 2018

•Gathered and documented requirements across export, logistics, warehouse, order-management, supplier, and finance teams supporting 4 warehouses.

•Automated Export-Import (EXIM), customs, letter-of-credit, and invoice preparation using Excel VBA, reducing preparation time from 60 minutes to 30 minutes.

•Built Tableau dashboards for letter-of-credit tracking, order status, and foreign-exchange monitoring, replacing static PowerPoint reporting.

SKILLS

Business Analysis: Requirements elicitation, workshop facilitation, stakeholder management, BRD, FRD, user stories, use cases, acceptance criteria, current and future state process mapping, gap analysis, root cause analysis, requirements traceability matrix, wireframing, SOPs, change management

Delivery and Testing: Agile, Scrum, sprint planning, backlog refinement, sprint demos, retrospectives, SDLC, Jira, SIT, UAT, test cases, defect triage, release readiness, data migration, end user training, post go live support

Data and Reporting: SQL, Power BI, DAX, Tableau, Excel with Power Query, PivotTables and VBA, Python, data modeling, KPI development, executive reporting, data validation, forecasting

AI and Automation: AWS Textract, AWS Bedrock, prompt engineering, LLM output validation, OCR and document intelligence, n8n, workflow automation

Platforms and Domain: MariaDB, MySQL, SQL Server, Snowflake, NikoHealth, SharePoint, API integration, ERP implementation, DME operations, patient intake, eligibility and payer workflows, prior authorization, HCPCS, claim denials, revenue cycle, HIPAA data handling, RFID inventory, procurement, EXIM logistics

Tools: Visio, Figma, Jira, SharePoint, Google Appscript, Google Docs

EDUCATION

Master of Science, Business Analytics University of Texas at Arlington, Arlington, TX Aug 2022 to May 2024

CERTIFICATIONS

Microsoft Business Analyst Certificate, Microsoft and Coursera, Nov 2025

PROJECTS

AI Assisted Requirements Copilot Python, n8n, Jira, Power BI

•Prototyped a workflow that converts stakeholder notes into user stories, acceptance criteria, and Jira-ready backlog items.

•Built a traceability view linking objectives, requirements, test cases, defects, approvals, and release status.

Power BI Governance Build, personal tenant Power BI Service, Entra ID, PowerShell, Power BI REST API

•Built a governance model in a personal tenant covering workspaces, a clustered gateway, 4 Entra ID groups, and 7 tenant settings.

•Used PowerShell and the Power BI REST API to test access, deployment, and refresh patterns through self-directed learning.

Contact this candidate