Business Analyst Power Bi

RanaPrudhviTej Velampalli

BUSINESS ANALYST

740-***-**** **************@*****.*** linkedin.com/in/rana-prudhvi-tej-velampalli-59b701322

PROFILE SUMMARY

Business Analyst with over 3 years of experience in healthcare and finance domains, specializing in requirement gathering, gap analysis, stakeholder management, and end-to-end project delivery. Adept at creating BRDs, FSDs, SRS, user stories, and traceability matrices, while facilitating JAD sessions, workshops, and Agile ceremonies using tools like JIRA, Azure DevOps, Confluence, and MS Project. Skilled in writing and executing SQL queries, building dashboards with Power BI and Tableau, and leveraging RPA tools for automation of claims validation and financial workflows. Proficient in process modeling using Visio, Lucid chart, and BPMN 2.0 standards, with hands-on experience in UAT execution, training delivery, and ensuring regulatory compliance with HIPAA, CMS, and SOX through strong documentation and data governance practices.

TECHNICAL SKILLS

Methodologies:

Agile (Scrum), Waterfall, SDLC, JAD

Documentation & Requirements:

BRD, FRD, SRS, Use Cases, User Stories, BPMN, RTM, Test Plans, User Guides, Prototyping, System Configuration Documentation (Intelligrants)

Business & Data Analysis:

Gap Analysis, Impact Analysis, SWOT Analysis, Risk Analysis, Cost-Benefit Analysis, KPI Tracking, Data Modeling, Process Mapping, Requirement Gathering, User UX Understanding, Data Analysis, Grants Management Analysis (Intelligrants)

Project & Collaboration Tools:

JIRA, Rally, Trello, Asana, MS Project, MS Excel, MS SharePoint, MS Visio, Rational ClearQuest

Data & Database Tools:

SQL, MS Access, Data Modelling, Database Knowledge

Data Visualization Tools:

Power BI, Tableau,

Programming & Statistical Tools:

Python, R, Google Analytics

Quality Assurance & Testing:

UAT, QA Methodologies, Software Development & Testing Knowledge, Use Case Development for QA, End User Testing (Intelligrants)

Operating Systems:

Windows, Linux, Mac OS

WORK EXPERIENCE

Business Analyst Company: PNC Financial Services, USA Aug 2024- Present

Conducted gap analysis and stakeholder interviews across clinical operations and claims processing teams to define key pain points in reimbursement cycles and align business requirements with value-based care objectives.

Facilitated JAD sessions, workshops, and one-on-one discussions to gather business, functional, and non-functional requirements, ensuring clarity and completeness for development and QA teams.

Authored and maintained detailed documentation, including Business Requirements Documents (BRDs), Functional Specification Documents(FSDs), and User Stories with Acceptance Criteria for claims adjudication workflows and billing automation.

Led Agile ceremonies using Jira and Azure DevOps, including sprint planning, backlog grooming, and retrospectives, enabling efficient delivery cycles for cross-functional product teams.

Created AS-IS and TO-BE process models in Microsoft Visio using BPMN 2.0 standards to streamline provider credentialing and claims rework processes.

Developed SQL queries to extract and analyze claims, provider, and encounter data from SQL Server and Oracle databases, supporting root cause analysis of denials and identifying performance improvement opportunities.

Collaborated with the RPA team to automate manual claims validation and provider data reconciliation tasks, reducing cycle time by 40% and minimizing human error.

Partnered with compliance and audit teams to assess systems and workflows for HIPAA, CMS, and SOX compliance, and implemented appropriate data governance and audit logging.

Delivered SOPs, user guides, and training materials; conducted live sessions for end users and stakeholders to support the rollout of new claims workflows and reporting features.

Business Analyst Company: Cognizant, India May 2021- Jun 2023

Collaborated with FP&A, treasury, and accounting teams using Asana to define performance metrics, resulting in a 12% reduction in operating expenses and a 15% improvement in the monthly financial close process, while ensuring compliance with accounting and regulato ry standards.

Maintained a detailed traceability matrix to track over 100 business and system requirements across the development lifecycle, supporting audit readiness andinternal control processes.

Conducted cost-benefit and return-on-investment analysis to evaluate automation tools and process enhancements, leading to measurable annual savings and operational efficiency.

Designed interactive dashboards in Tableau by integrating enterprise financial systems with external market data to support more accurate forecasting, long-range financial planning, and variance analysis across multiple business units.

Managed end-to-end agile delivery cycles, including sprint planning, backlog grooming, and daily stand-ups, ensuring timely delivery of financial planningand regulatory compliance reporting initiatives.

Led user acceptance testing (UAT) for key finance stakeholders by authoring, executing, anddocumenting over 40test cases related tocost center reporting, accrual workflows, andsystem compliance alerts.

Delivered in-person andvirtual training programs on core financial planning concepts, including forecast management, rolling budgets, and variance reporting, resultingin highuser satisfaction and platform adoption.

Established enterprise-wide data governance practices within SAP by standardizing financial reporting definitions, defining validation rules, and conducting data quality sessions to ensure compliance and consistency across departments.

EDUCATION

Master's in Business Analytics- Kent State University, Kent, Ohio, USA - Aug 2023 - Dec 2024

Bachelor’s in Hospitality Management - International Institute of Hotel Management, Hyderabad, India July 2019 - May 2022

Contact this candidate