Business Analyst Power Bi

SWAPNA KOSURI Business Analyst

AL 980-***-**** ****************@*****.*** LinkedIn

SUMMARY:

Business Analyst with around 3 years of experience in gathering and analyzing business requirements, translating insights into user stories, BRDs, and FRS to drive system enhancements. Proficient in designing UML diagrams, mapping end-to-end business workflows, and identifying inefficiencies to optimize processes. Hands-on experience in SQL and Python for data extraction, validation, and analysis, ensuring accuracy in claims processing, reimbursement models, and business intelligence reports. Skilled in developing interactive Power BI and Tableau dashboards to track KPIs, optimize cost structures, and enhance data-driven decision-making. Experienced in leading UAT efforts by defining test cases, validating system outputs, and collaborating with developers to resolve defects before deployment. Strong background in Agile project management, assisting in backlog refinement, sprint planning, and cross-functional collaboration to streamline project execution. Expertise in ETL workflow refinement, healthcare data integration, and compliance enforcement, ensuring HIPAA and data governance adherence.

TECHNICAL SKILLS:

Languages & Tools: SQL, Python (Pandas, NumPy, Matplotlib, Scikit-learn), Salesforce, JIRA, Confluence, MS Visio,

Database & ETL: MySQL, DBMS, Databricks, Hadoop, HDFS, Spark, ETL

Data Visualization: Tableau, Power BI, Figma, Advanced Excel

Project Management: Agile, SCRUM, Waterfall, JIRA, Confluence, SharePoint

Analysis Techniques: SWOT Analysis, GAP Analysis, Impact Analysis, Risk Analysis

Other Tools: MS Office Suite, ServiceNow, Change Request Management

Business Analysis & BRD, FRD, RTM, Use Case Development, UML, Functional Requirements Specifications (FRS),

Documentation: User Requirements Specifications (URS)

EXPERIENCE:

Humana Inc. USA November 2024 - Present

Business Analyst

•Conduct and lead requirements gathering sessions with stakeholders to capture business needs, translate them into actionable insights, and define user stories with clear acceptance criteria to align system functionality with healthcare policies and compliance mandates.

•Develop and maintain BRD and FRD documentation by outlining business rules, functional workflows, and system specifications while establishing and managing an RTM framework to track requirement fulfillment throughout the project lifecycle.

•Design and implement UML diagrams, including use case, sequence, and activity models, to visualize system interactions, dependencies, and process improvements in healthcare applications.

•Extract, analyze, and transform healthcare data using SQL to validate claims processing, optimize reimbursement models, and enhance reporting accuracy for strategic decision-making.

•Lead and coordinate UAT efforts by defining test cases, executing validation scenarios, documenting discrepancies, and collaborating with QA teams to ensure system functionalities meet business expectations.

•Develop and execute strategic roadmaps for system enhancements, outlining key milestones, resource allocation, and priority features to optimize operational workflows and improve healthcare service delivery.

•Collaborate with cross-functional teams, including developers and data engineers, to refine ETL workflows, ensuring seamless integration of patient records and claims data across enterprise platforms.

•Design and generate dynamic Power BI reports to track key performance indicators, optimize cost structures, and improve patient and provider engagement strategies through data-driven decision-making.

•Analyze and recommend modernization strategies for legacy systems, enhancing claims adjudication, provider credentialing, and policy administration through automation and digital transformation initiatives.

•Validate and enforce data governance policies, security controls, and HIPAA compliance in member data processing, storage, and access control, mitigating risks and ensuring regulatory adherence.

Mphasis India January2022 - November2022

Business Analyst

•Assisted in gathering and analyzing business requirements through stakeholder interactions, translating insights into user stories, BRD, and FRS, while ensuring clear documentation of system needs, functional specifications, and process enhancements to guide development teams.

•Designed dynamic reports and interactive dashboards using Power BI and Excel, helping stakeholders visualize key performance indicators, track trends, and make data-driven decisions.

•Performed data analysis using SQL queries and Python scripts, extracting meaningful insights to optimize business processes and identify areas for operational improvement.

•Document findings from risk and gap assessments in Confluence, ensuring transparency and traceability of all identified issues and recommended resolutions.

•Mapped end-to-end business workflows by documenting existing processes, identifying inefficiencies, and proposing optimizations to improve system functionality and reduce manual effort.

•Executed comprehensive UAT (User Acceptance Testing) by preparing test cases, validating system outputs, and collaborating with developers to resolve defects before deployment.

•Validated data accuracy in reports and dashboards by writing SQL queries and using Excel functions, ensuring consistency in reporting and business intelligence outcomes.

•Facilitated cross-team collaboration by organizing meetings between stakeholders, developers, and quality assurance teams to clarify project scope, resolve queries, and track progress.

•Managed Agile project tasks, assisting in backlog refinement, sprint planning, and ensuring well-documented user stories for smooth execution of development cycles.

•Researched emerging trends in automation, AI, and cloud-based analytics, exploring potential applications to enhance business processes and improve reporting efficiency.

PROJECTS

Shark Tank Investment Analysis

•Performed exploratory data analysis on Shark Tank investment data to identify patterns in industry success rates, deal characteristics, and funding trends, using Python and Tableau to provide actionable insights for stakeholders.

•Developed data visualizations in Tableau to showcase investment trends and success metrics, leveraging regression modeling to identify key predictors of deal outcomes and support strategic decision-making.

EDUCATION:

•Masters in Technology Management August 2024

Lindsey Wilson College KY

•Bachelor of Engineering August 2022

Priyadarshini Institute of Science & Technology for Women India

Contact this candidate