Business Analysis Product Owner

Neeharika Bandi

Cell : 314-***-****

*****.*****@*****.***

Professional Summary

A professional with 9+ years of IT experience in Business Analysis/Design, Implementation, Testing, Support of Data warehousing and Data Integration Solutions using Informatica PowerCenter.

Experience eliciting requirements, writing user stories and design documents, defining acceptance criteria, testing outcomes, and facilitating communication between business stakeholders, developers, and project teams.

Proficient in developing and supporting Analysis Solutions including Data Transformations and Reporting

Proficient in creating Business requirements, Technical requirements and Solution Requirement specification Document.

Experience managing stakeholder expectations and priorities. Assisting the Product owner for PI plannig in presenting the business context, objective, and detailed feature level descriptions to the team.

Managed customer-facing interactions, demonstrating excellent interpersonal and communication skills to build trust and ensure satisfaction.

Developed and optimized SQL queries to extract, manipulate, and analyze large datasets, supporting business analysis and reporting needs.

Managed customer projects from initiation to completion, adhering to strict timelines and delivering high-quality results.

Collaborated with cross-functional teams to communicate business analysis findings and project recommendations effectively.

Worked closely with Data Design and Architecture team for designing the data warehouse and develop data ingestion techniques to improve business processes.

Provided mentorship and guidance to junior staff, supporting their professional development and ensuring smooth team operations.

Handled moderately complex business issues, provided solutions, and escalated more complex challenges to senior management.

Extensive Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing

Team player, Motivated, able to grasp things quickly with analytical and problem-solving skills.

Excellent communication and interpersonal skills. Ability to work effectively while working as a team member as well as individually.

Experienced in all project phases using Waterfall and Agile Methodologies.

Skills Summary

Reporting tools: Tableau, Power BI, Excel

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Databases and Tools: Oracle 12c/11g, SQL Server, Informatica 10.2/9.1/8.6/8.1, Postgresql,Teradata, MySQL, JIRA, Putty,Hive,Microsoft Office 365,Visual Studio 2019

Scheduling tools Methodologies: Control M, Informatica Scheduler

Project Management tools: Rally,Jira,Confluence

Cloud: Platforms and Big data Hadoop, HBASE, Hive, AWS

Methodologies : Agile/Scrum, Waterfall

Professional Experience

Optum( United Health group)- Atlanta, GA August 2023 – Present

Senior Business Analyst

As part of the merger & acquisition of Landmark with Optum, I worked on migration project from Legacy/Hadoop platform to Azure.

The business unit I worked for was Optum at Home (OAH). They focus on delivering home-based care to meet the medical,behavioral social need of the people they serve. The project name was OAH 2.0 which focused on enhancing the current architecture to make it more resilient, scalable and enhance the data availability.

OAH 2.0 Data Pipeline Modernization

Data Ingestion framework

Establish H&C patient ID using Enterprise Solution(HCM/Golden id)

OAH transactional store aligned to OCM persistence

Revutionalizing the Ubiquity 2.0 application that uses data to predict the risk of disease,digital adoption and medication adherence.

Roles and responsibilities

Worked as BA/DA to create mapping documents (STM) for various domains for multiple health plans.

Reviewed existing Sql Server Stored procedures to comprehend the logic and document for the STM.

Worked with various business stakeholders to gather requirements.

Developed System Requirement specification(SRS) to build an application to manage Non Risk Referrals. Current system used a Google form to manage new or existing non risk member which would be replaced by an application to add/update member indviually and also allow bulkoperation.This application will directly create/update members and integerate with OAH 2.0 pipeline data.

Performed advanced data analysis using Microsoft Excel, including pivot tables and complex SQL queries.

Applied SQL, ETL, and BI data warehouse knowledge to deliver reporting solutions.

Developed test plans, set up test scenarios and conduct thorough testing of the reports and system enhancements to ensure accuracy and completeness before implementation.

Worked with multiple people at different levels to demonstrate effective communication and coordination skills.

Utilized agile methodology for daily work management and progress tracking

Worked in Offshore-Onshore model to coordinate day to day tasks with team members and knowledge exchange for any business requirements clarification.

Anthem (Elavance Health INC) – Atlanta, GA Feb 2021 – Aug 2023

Project: Analytical Resource Center and Cost Of Care

Business Analyst

Participate in Scoring and Claiming sessions to claim requirement for DSS (Data Support System) group.

Work with business to translate business requirements to technical requirement. Document SRS and business process flow diagrams.

Provide technical know-how in the creation of a flexible and sustainable Data Ingestion process to load data

Design database, data models, ETL processes, data warehouse applications and business intelligence (BI) reports using tools.

Interact with multiple team SME’s and Stakeholders and assist Product owner with PI planning

Work with RDM team to refresh data in RDM Tables

Extensive use of Informatica Metadata queries downstream impact analysis. This also helped in identifying the ETLs which uses the PI elements.

Worked on offshore-onshore model.

Created source to target mapping as part of Technical requirement document.

Used JIRA to record epics, user stories and task to effectively manage the work allocation.

Identified and documented detailed business rules and use cases based on requirements analysis.

Anthem(Elavance Health INC) – Atlanta, GA May 2015 – Jan 2021

Project: Clinical Data Acquisition and SPS (Strategic Provider Data And Solutions)

Business Analyst II

Worked on CDA(Clinical Data Acquisition) project to support Medicare and Medicaid data

Worked as BA/DA for CDA team and send Immunization reports for various domains

Worked with Indirect Lending group, Collections core team and others business groups to understand the impact of the merger on the existing applications and business reports which they manage and document requirements for the changes needed.

Was responsible for testing of applications and reports once development was complete.

Worked as a link between business and development team to achieve the best possible solutions for the updates requested.

Applied MS SQL, ETL, and data analysis skills to deliver system and reporting needs

Worked with multiple people at different levels to demonstrate effective communication and coordination skills.

Involved in defect tracking and remediation plans.

Created source to target mappings for application and reports impacted as part of the merger.

SPS (Strategic Provider Data And Solutions)

Business Analyst/Software Developer

Worked as a key member of Data operations team to support Business and Data Analysis

We do in depth analysis on Provider subject area on Medicare, Medicaid and Commercial data

Developed ETL processes using Informatica Power Center for SPS

Used Informatica Power Center for (ETL) extraction, transformation and loading data from EDWard source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Worked on Unit Testing and preparing Unit Test Logs for the end users’ reference

Handled slowly changing dimensions of Type 1/ Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse. Updated the table without using Update Strategy improving session performance. Extensively used workflow variables, mapping parameters and mapping variables

Work closely with other Business Units to identify and deliver Enterprise value.

Work with Development team to do code reviews to ensure all ETL standards are met as per the mapping document

Worked on data issues reported through Incident Management system and did core analysis to find out the issue

Experience in Performance Tuning and Debugging of existing ETL processes.

Identified and documented detailed business rules and use cases based on requirements analysis.

Education

Tamilnadu College Of Engineering – India, May 2012

BE in Computer Science And Engineering

Contact this candidate