Business Analyst Supply Chain

Lisha P

Phone: 703-***-**** Email: *********@*****.***

BUSINESS ANALYSIS

PROFESSIONAL SUMMARY

Dedicated and results-driven Analyst with over 10 years of experience in gathering requirements for Health care, Government and HR domains. Expertise in business analysis, data analysis, and project management, with a proven track record of working on end-to-end initiatives including modernization, implementation, migration, automation, process improvements, enhancements, and product development. Seeking a challenging role to leverage my skills and experience in driving business growth and delivering valuable solutions.

EXPERTISE:

Expert in working on wide range of projects in both Agile/Scrum and Waterfall environments.

Strong knowledge of Learning and development, Medicaid Claims Processing, Enrollment, and Waiver programs.

Knowledge of Salesforce CRM application and Health care cloud applications.

Perform database validations to verify Data integrity & Data mappings using SQL., TOAD, Oracle, and Snowflake

Strong understanding of ICD-9 and ICD-10 structures and formats and 834, 837 transactions

Experience in conducting walkthroughs, JAD sessions and meetings with stakeholders, Project managers, Product Owners, SME’s, QA analysts and end users to deal with business and technical issues and resolving the issues.

Proficient at understanding the AS-IS system, analyze the shortcomings and improve the design of the TO-BE system.

Data mapping, Gap analysis, Process analysis and UAT to achieve the desired end user experience and to optimize the Business process.

Experience in SQL server, TOAD (Oracle), data visualization using MS Excel/Tableau and project management/task management tools like JIRA, VersionOne, Confluence and TFS/Azure DevOps.

Proficient in creating UML Diagrams including use case, swim lanes, activity and class diagrams; Data Dictionary, Business process flows, data flows using MS-Visio.

Leveraged Confluence, JIRA, Draw.IO, Visio, BMPN tools

Proficient in research of current process and emerging technologies which need analytic models, data inputs and output, analytic metrics, and user interface needs.

CORE COMPETENCES

Software Technologies and Tools

MS Office Suite, MS Visio, MS Excel, MS Project

SQL

Oracle

R Programming, R Studio

Tableau

Power BI

Salesforce

Google Analytics

Data Mapping, Data Mining, Data Manipulation

Azure

Gemini

Prompt Engineering

Sharepoint

SOAP UI

BPMN

ETL, XML, AWS

Python

SDLC, STLC

JSON, Javascript, SOA, Web Services

Gen AI

Project Lifecycle:

BA Analysis and Monitoring

Requirements Elicitation

Databases

MS Access, MS SQL Server, Oracle

SQL Server 2008/2005, TOAD (Oracle), MS Access, Excel 2007/2003

Azure, AWS

Value-Added Skills:

Collaboration

Project Management

Product Management

Excellent analytical and decision-making abilities

Exceptional interpersonal and communication skills.

Leadership skills

Strategic Thinking

Problem solving

Continuous Learning

WORK EXPERIENCE

Business Analyst Feb 2024- Present

Inflight Logistics, Remote

Currently working on a multiyear $1M project as MVP to improve the supply chain and provide catering and other services to the local airlines in timely manner.

Working on an AI initiative with the business partners across multiple departments to review various Generative AI services/tools to determine the best fit.

Conducting Gap analyses and collaborating with configurators as well as Data engineers for solutioning the appropriate implementation approach for the conversion.

Working on Source - to -Target Data mapping and build data dictionary for Data mart for all the modules.

Working on documenting the rules to create standardized data model and attribute mapping for modules

Leading the Business Analysts effort for integration design and development of over 170 data interfaces, supporting and integrating with multiple ancillary applications such as Agent Management, New Business, Product, Actuarial, Policy Services, Billing, Payments, and Claims, as part of a multiyear $100M companywide project.

Conducting Joint Application Development (JAD) sessions, Requirement refinement sessions and workshops with Business SMEs, stakeholders, and IT teams to understand, validate, and prioritize business requirements and change processes.

Managing and prioritizing project backlogs, features, user stories, tasks, and deliverables within JIRA to ensure timely completion and alignment with project vision.

Collaborating with Business users, Product Owners, and Stakeholders to gather and document comprehensive business and data requirements in business user stories and FRDs.

Documenting Business requirements and Functional requirements in user stories with Acceptance criteria within engineering team

Working with QA team and technical teams on Defect triaging and Defect management within JIRA and CONFLUENCE

Serve as the primary point of contact between stakeholders, clients, and team members

Provide regular status updates, reports, and presentations to key stakeholders

Manage stakeholder expectations and escalate issues appropriately

Conducted process analyses to proactively identify areas for process improvements, recommended solutions, and provided guidance to enhance the overall efficiency and effectiveness of the project.

Conducting research and data analyses using SQL, MS Excel, and Tableau to determine the most suitable implementation approach with minimal customer impact, while also performing data verification and loading in coordination with ETL developers.

Working closely with Data Modeling/Data Warehousing and Data Services teams to analyze data within current reports, perform data profiling, and devise solutions for enterprise data management.

Analyzing data within SQL and Oracle databases, mapping source to target data, and defining data definitions, data dictionary for interfaces.

Creating dataflow diagrams and business process flows using MS Visio to illustrate the flow of data between Mainframe and ancillary applications.

Demonstrated hands-on proficiency with Linux/Unix commands for system navigation, scripting, and troubleshooting in support of Atlassian tools and application configurations.

Gathered and analyzed business process requirements to build, configure, and optimize JIRA, Confluence, and BitBucket environments, driving workflow efficiency and collaboration.

Provided end-to-end application support for JIRA and Confluence across IT and business units, ensuring platform stability, user adoption, and high availability.

Working closely with QA team to complete test case design for various interfaces and for End-to-end testing

Developed and deployed custom XML-based JIRA gadgets to deliver tailored dashboard functionality and enhance reporting capabilities.

Business Data Analyst Jan 2022- Jan 2024

Cisco, Remote

The objective of this project is to summarize data using Excel, Access, Power BI and Tableau and create dashboards and reports for business leaders across Cisco. Provide data support to QBR and Illuminate programs every quarter.

Gathered requirements and built processes that help improve internal functions within the organization.

Develop, implement, and analyze training metrics, create customized reports to support business leader needs using advanced data analysis technique such as Python and Tableau

Evaluate business processes, anticipating requirements, and developing and implementing solutions in Learning and Development /HR domain.

Performing requirements analysis and translating business requirements and needs into data requirements.

Integrate different data sources and create data sets within Power BI tool to understand data

Develop queries for existing and new requests for data analysis.

Create executive dashboards using build in functions in Power BI

Leveraged query editor and Model Relationship (DAX) views to analyze data.

Leveraged Degreed data for creating customized and subscription reports.

Effectively communicating insights and plans to cross-functional team members and Business management.

Working closely with clients and advising on Learning related functionalities and business rules

Cross- training and providing guidance to Off-shore team on as needed basis.

Data analysis using advanced tools provided by Cisco such as MTM to improve survey data and results.

Created workflow diagrams to understand customer support call process.

Creating interactive reports for executives using Tableau and data visualizations for Illuminate and QBR programs

Working knowledge of executing queries in TOAD, Oracle databases

Report progress on daily basis for new and ongoing requests using Siebel.

Leverage Doc Central portal to upload reports once created for privacy reasons.

Monitoring deliverables and ad-hoc requests ensuring timely completion of data requirements.

Business Data Analyst Jan 2019- Dec 2020

Dept of MD Health Systems, Bethesda, MD

The objective of the project was to upgrade their Salesforce Cloud Health platform so that users can receive timely information regarding their IDs, claims and outstanding bills. This is a multi-year project and will be implemented in phases. My role in this project was to gather requirements and develop executive reports based on metrices derived from enrollment and registration

Gathered business requirements and documented business/data requirements and user stories for EDI transactions such as 834, 835, 837, 276/ 277, 278, 270/271 for Migration to Salesforce Cloud platform

Worked extensively on Claims processing, Payments, Eligibility, Provider, Reporting and Analytics business workflows

Performed gap analysis to determine which COTS system worked better for the organization

Documented requirements for patients Benefit program and progress of the patients on quarterly basis

Implemented HL7 interfaces to format HL7 messages based on customer and EHR/EMR Vendor requirements

Worked on validating EHR application for clinical data repository, patient portal and reporting system

Developed and maintained healthcare interoperability solutions using HL7, FHIR, and other standards, improving data exchange between disparate systems

Created and maintained Java, JavaScript, jQuery, XML, and JSON-based applications, improving UI/UX and system functionality

Solid understanding of HL7 transactions for v2 and v4 field transformations

Perform independent analysis on inbound HL7 v2, V3 FHIR and flat file extracts

Assisted the project manager in managing requirements, status of the project and risks.

Conducted gap analysis to determine gaps and Migration rules from patient 360, Care plan and Care coordination plan within Salesforce cloud.

Groomed user stories, acceptance criteria and worked with the development team to refine the backlog every sprint with engineering team.

Documented user stories for Waiver programs for Aging and LIVE programs and create test cases for the same.

Leveraged Data Integration Engineering to determine best practices for Data Ingestion, Data Governance and other data marts

Participated in agile ceremonies- Scrum meetings, Backlog grooming, Iteration grooming, Retrospective, and demo.

Tracked change request for various claims and enrollment process within Service Now

Followed up with respective teams to complete the key information in the Service Now portal and update the portal on a timely basis.

Business Analyst June 2017- Dec 2018

Dept of VA Health Systems, Rockville, MD

The objective of this project is to build enhanced capability to support Data integrity of MDE Care -property and casualty Net portal which is based on C# based application. The project is based on testing the functional flow of Various DBQ’s and Events for Client Veterans Affairs.

Perform business data analysis using HIVE to retrieve data from Hadoop cluster, SQL to retrieve data from Redshift.

Conducted gap analysis to determine potential changes to MMIS process flows.

Gathered Business requirements for MMIS applications, conversion of new CPT/ ICD codes and migration steps.

Documented new business processes to trigger Letters, address update and benefit updates.

Created data dictionary to include data format, descriptions, and data attributes specific to property and casualty.

Created a mockup data in XML and verified and validated Veterans Name, CPT and ICD codes, Veteran’s address, letters send, Type of service rendered for Veteran and respective DBQ’s.

Communicating effectively business and functional requirements to the configuration and integration teams for accurate implementation of various interfaces across the projects.

Extensively worked on root cause analysis of the production bugs or data errors using SQL queries, reading the Code and resolved them by working closely with developer to optimize the SQL code as well as to create workflow triggers for different Business cases.

Extracted Data using SQL queries and performed Data manipulation.

Analyzed data to develop Metrics using MS Excel functions like VLOOKUP, Pivot tables, etc.

Demonstrated the various findings and analyses with Data Visualization in MS Excel.

Involved in Sprint planning to prioritize the tasks and attended the daily Scrum to discuss the work done, work to be done and the outstanding issues.

Business Analyst Aug 13- March 2017

Dept of TX Health Systems, Dallas, TX

Texas Health Care Web Application, which provides the quality level of Health services for customers. Performed day-to-day EDI activities related to HIPAA compliant data submissions. The scope of the HIPAA 5010 Project includes remediation of the applications to meet the minimal functionality necessary to electronically send, receive and process the HIPAA compliant standard transactions, and fully implement all components of NPI Compliance. Duties included technical and non-technical telephone or email communications with physicians, clearinghouses billing services, and hospitals that submitted or received electronic claim data (ANSI X12 5010 version) implementation.

Gathered business requirements by driving user-group meetings and working with various global, cross-functional, and virtual teams.

Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that include modeling of all the activities of the business from the conceptual to procedural level.

Performed Unit Testing and User Acceptance testing and documented detailed results.

Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model

Conducted client interviews, gap analysis to understand how 5010 would work for the company

Determine how HIPAA updated rules will impact overall organization goals

Tested applications related to creation, member enrollment, billing, letter generation, contract administration and claim adjudication for State of TX

Conducted User Acceptance testing for various applications and ensured application has zero to few defects

Education:

Masters in Analytics - Harrisburg University

Masters in Information Systems – VIU University

Bachelors in Computer engineering – Mumbai University

Contact this candidate