Business analyst

Hemanth Sai

Phone: +1-201-***-****

Email : ***********@*****.***

Business Analyst

Professional Summary:

Overall 6+ years of experience in Business Analyst with solid understanding of Business Requirements Gathering, Data Warehousing, Data Modelling, Translating Requirements into Specifications, and Application Design.

Extensive knowledge and working experience in converting business requirements into UML diagrams using Rational Rose and MS Visio and managing and tracking those requirements.

Experience in process modeling using Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, class Diagrams.

Elicited, Analyzed, validated and documented user, functional and non- functional requirements, business rules, and business process models (workflows and use cases).

Designing and analysis of Use Case Scenarios using tools like MS Office 2000 (Word, Excel, PowerPoint), MS Visio (for designing Data flow diagrams), Requirement\ traceability Matrix (RTM) and testing documents.

I am good at analytical skills with the ability to convert the needs of the stakeholders and business users to technical requirements.

Attended client meetings, which involved proposing solutions, training solutions and status updates about the project development.

Highly proficient in working with users and stakeholders to elicit, analyze, communicate, and validate requirements using JAD, JAR and Brainstorming sessions, identify Functional, Non-Functional and Business Rules and then subsequently model them.

Analyzed and prepared project deliverables such as Project Charter, Business Requirement Document (BRDs) and functional Requirement Document (FSDs).

Created Use Cases and Unified Modeling Languages (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.

Experience in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment.

Technical Skills:

Programming

Python, SQL, SAS, R

Platforms & Systems

SaaS Platforms, Enterprise Platforms, Underwriting Workbench, Smart Submission

Business Analysis Tools

JIRA, Confluence, Azure DevOps, SharePoint

Requirements & Documentation

BRD, FRD, RTM, Use Cases, User Stories, Functional Specifications

Process & Workflow Modeling

Process Flows, BPMN, Swimlane Diagrams, Gap Analysis

Testing & Validation

UAT, Test Case Preparation, Defect Tracking, Playback Sessions

Data Analysis & Reporting

MS Excel (Pivot Tables, VLOOKUP), Power BI (Basic), Data Mapping, Source-to-Target Mapping

Project & Delivery Methodologies

Agile, Scrum, Waterfall, Hybrid, SDLC

Collaboration & Communication

Stakeholder Management, Workshop Facilitation, Cross-Functional Coordination

Delivery Focused Skills

Solution Validation, Business Outcome Alignment, Delivery Governance

Professional Experience:

Fannie Mae - Washington, D.C. May 2025 to Present

Business Analyst

Responsibilities:

Developed annual operating plans, capital budgets, and financial forecasts to support executive decision-making across PANYNJ programs.

Partnered with 40+ product owners and stakeholders to align enterprise roadmaps with engineering and project execution priorities.

Documented business requirements (BRD, FRD, RTM) for Primavera P6 and SharePoint enhancements, improving transparency in project scheduling and reporting.

Conducted gap analysis, impact analysis, and feasibility studies to identify process improvements and recommend strategic business solutions.

Prepared comprehensive Business Requirement Documents (BRD), Functional Requirement Specifications (FRS), Use Cases, and Process Flow Diagrams.

Facilitated JAD sessions, workshops, and stakeholder meetings to gather requirements, validate assumptions, and resolve business issues.

Designed and maintained SSRS and Power BI dashboards, providing WTC leadership with real-time visibility into project performance, cost variances, and forecast accuracy.

Partnered with cross-functional teams to support HEDIS performance reporting and Medicaid claims analysis, ensuring compliance and operational efficiency.

Gained hands-on experience with Payment and ACH processing in the system, analyzing transaction workflows, documenting business rules, and coordinating enhancements to improve payment accuracy and efficiency.

Acted as a liaison between business, vendors, and IT, translating complex system requirements into actionable deliverables for development teams.

Partnered with Finance and IT to support payment systems, documenting workflows for ACH processing, settlements, and reconciliation, and driving enhancements to improve payment accuracy and compliance.

Gathered and analyzed requirements from finance, treasury, and accounts payable teams to streamline ACH/Payment reporting and automated exception handling.

Designed and developed Power BI dashboards and SSRS reports to provide real-time visibility into payment status, ACH transaction trends, settlement timelines, and project costs.

Environment: Business Analysis, BRD, FRD, FRS, RTM, JAD Sessions, Gap Analysis, Impact Analysis, UML, Use Cases, Process Flow Diagrams, SSRS, Power BI, SQL, ACH/Payment Processing.

Mayo Clinic - Rochester, Minnesota Oct 2023 to April 2025

Business Analyst

Responsibilities:

Gathered and documented business requirements and user stories from officers, command staff, and administrative teams, ensuring IT solutions met operational and compliance needs.

Designed and deployed interactive Power BI dashboards integrating SQL Server data, enabling leadership to track crime trends, case management performance, and resource allocation in real time.

Created visualizations with DAX calculations, KPIs, and drill-through reports to provide actionable insights for investigations, patrol coverage, and enforcement activities.

Created process maps, workflow diagrams, data flow diagrams, and UML use case documentation to improve process visibility and system understanding.

Analyzed existing business processes and identified opportunities for process optimization, automation, and operational efficiency improvements.

Prepared detailed Business Requirement Documents (BRD), Functional Requirement Specifications (FRS), use cases, process flows, and user stories.

Conducted stakeholder workshops, JAD sessions, interviews, and requirement elicitation meetings to define project scope and business objectives.

Configured and maintained NicheRMS (Records Management System), ensuring accurate reporting of arrests, incidents, and case documentation in compliance with state and federal standards.

Built data governance and audit-ready reporting frameworks to ensure consistency, transparency, and compliance with law enforcement data policies.

Developed geo-mapping dashboards in Power BI to visualize incident hotspots, improving deployment planning and response strategies.

Conducted UAT and regression testing for system upgrades and dashboards, documenting results and ensuring accurate data flow into reporting systems.

Provided executive-level reporting packs with Power BI visuals and detailed narrative summaries for leadership briefings and state compliance submissions.

Trained officers and analysts on self-service Power BI usage, empowering teams to generate custom reports and conduct independent analysis.

Supported digital transformation initiatives by modernizing reporting systems and creating scalable dashboard templates for long-term use.

Monitored data quality issues across payment and transaction systems, implementing corrective measures to maintain PCI and compliance standards.

Acted as a liaison between technical teams and law enforcement leadership, ensuring analytical insights directly supported policing priorities and policy-making.

Environment: Business Analysis, Power BI, DAX, SQL Server, Excel, Power Pivot, UML, Process Mapping, Workflow Diagrams, Data Flow Diagrams, UAT, Regression Testing, KPI & Geo-Mapping Dashboards.

Thomson Reuters - Bangalore, India Jan 2022 to May 2023

Business Analyst

Responsibilities:

Built interactive Power BI dashboards and Excel PivotTable reports with slicers, enabling stakeholders to analyze and visualize data in real time.

Designed and maintained data models, sources, and deployment configurations in Power BI to ensure reliable, secure, and high-performance analytics.

Developed ad-hoc and custom Power BI reports in response to client needs, allowing flexible, real-time data exploration and updates.

Created mock-ups and UI screen definitions in Excel and Power BI Report Designer to rapidly test and validate new report designs.

Gathered, analyzed, and documented business requirements, functional specifications, and process workflows by interacting with stakeholders and end users.

Worked closely with business teams, project managers, developers, and QA teams to translate business needs into technical requirements and actionable solutions.

Performed gap analysis, impact analysis, and feasibility studies to recommend process improvements and system enhancements.

Designed and developed lightweight, self-contained web applications using Node.js and Express for data visualization and integration prototypes.

Produced detailed UML diagrams (Use Case, Activity, Sequence, and State diagrams) using MS Visio to document business processes and guide development.

Conducted thorough requirements analysis sessions with stakeholders to capture both functional and non-functional business needs.

Participated in User Acceptance Testing (UAT) and QA activities, including GUI, functional, smoke, and integration testing to ensure solution reliability.

Documented project processes, reports, and version control details in SharePoint, ensuring transparency and traceability across teams.

Extensive experience as a Business Data Analyst with a focus on cloud data security and public cloud solutions, including AWS, Azure, and Google.

Environment: Power BI, DAX, Excel PivotTables, Power Query, SQL, BRD, FRD, User Stories, UAT, Gap Analysis, UML, MS Visio, Node.js, Express.js, SharePoint.

Aditya Birla Retail - Mumbai, India Feb 2020 to Dec 2021

Business Analyst

Responsibilities:

Facilitated meetings with developers, system analysts, and testers to align resource allocation and ensure timely project delivery using MS Project.

Analyzed complex business processes and systems to identify inefficiencies, implement process improvements, and achieve measurable cost savings.

Collaborated with cross-functional stakeholders to translate business needs into technical specifications, ensuring clarity in requirements and deliverables.

Designed and maintained documentation including BRDs, data mappings, and business rules to support system development and compliance.

Developed Power BI and Excel dashboards (PivotTables, Power Pivot, nested IFs) to visualize KPIs, merge datasets, and present actionable insights.

Analyzed existing business processes and workflows to identify bottlenecks, inefficiencies, and opportunities for process improvement.

Collaborated with stakeholders to define business goals, KPIs, and success metrics for new initiatives and system enhancements.

Translated business requirements into functional specifications, process diagrams, and solution design documents for development teams.

Leveraged CASB technologies real-time encryption, access control, and user behavior analytics to strengthen cloud data protection and mitigate risks.

Implemented data governance frameworks using tools like Microsoft Purview, Collibra, and Informatica MDM for improved data quality and compliance.

Conducted statistical and relational analysis comparing internal business processes with competitors, delivering insights to guide strategic initiatives.

Introduced Task-Based UI (TBUI) for Case Management modules, streamlining user workflows and improving efficiency in service request logging.

Facilitated communication between business users and technical teams to ensure alignment on project deliverables and timelines.

Defined and managed knowledge management system requirements for call center solutions, enhancing customer service operations and data accessibility.

Environment: Business Analysis, BRD, Functional Specifications, Data Mapping, Business Rules, KPI Dashboards, Power BI, Excel (PivotTables, Power Pivot, Advanced Formulas), MS Project, Process Mapping, Statistical Analysis.

Contact this candidate