Home

MEGHASRI SIDDAPPA - Business Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: Any

Visa: H1b

MEGHASRI SIDDAPPA 4693344999 E-mail: LinkedIn: Professional Summary: Enthusiastic Healthcare Analyst with over 7 years of experience in Data Management and Client Engagement. Proficient in SQL, Excel, and healthcare government programs. Experience in troubleshooting, issue resolution, and system enhancement for various applications such as Workday, Par Excellence, GHX Marketplace, NiceLabel, and print server systems. Proven track record of improving legal department efficiency by leveraging innovative legal tech solutions, streamlining contract lifecycle management, and ensuring cost-effective legal operations. Proven track record in enhancing process efficiency and client relations with notable achievements in data analysis that led to significant operational improvements within the company. Professional Experience: NTT Data Inc. Position: Sr. Business Analyst/System Analyst/Quality Analyst June 2020 - Present Client 3: Magellan Health Project: Provider Portal Application Development/Data Integration July 2024 November 2024 Collaborated with cross-functional Agile teams to test and validate the Provider Portal for a healthcare system, ensuring compliance with business requirements. Participated in Agile ceremonies, including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives. Documented and tracked user stories, bugs, and enhancements in Jira and maintained detailed test cases in Zephyr. Conducted functional, regression, and end-to-end testing to ensure the Provider Portal supported claims processing, provider search, and account management functionalities. Performed API testing using Postman to validate data exchange between backend services and the Provider Portal. Collaborated with healthcare clients to gather and document business requirements related to payroll, accounting, and HR systems, ensuring the successful implementation and optimization of CAPPS-like solutions. Support and maintain Workday SCM in a healthcare environment, optimizing supply chain processes for hospital and healthcare clients. Troubleshoot, identify, and resolve issues within Workday SCM and associated healthcare supply chain systems, ensuring minimal disruption to critical operations. Manage and resolve tickets related to Workday SCM, collaborating with cross-functional teams and escalating issues to the IS Workday HCM and IS Workday FIN teams as needed. Lead and support system enhancements and upgrades within Workday SCM, working directly with healthcare clients to understand their requirements and implement tailored solutions. Acted as the go-to expert for Loan IQ functionality and configuration, providing guidance to stakeholders across the healthcare finance sector. Led the implementation of Loan IQ within healthcare lending processes, ensuring its alignment with the complex regulatory requirements of healthcare financing. Validated database queries and ensured accurate data flow using SQL for claims management and provider information. Authored test plans, scenarios, and cases while performing comprehensive manual testing for new portal features. Led user acceptance testing (UAT) for system updates and enhancements to CAPPS, ensuring that business requirements were fully met and that the system was compliant with healthcare industry regulations. Delivered UAT support by guiding stakeholders through testing procedures and capturing feedback for continuous improvement. Worked closely with developers and product owners to resolve defects and prioritize backlog items. Tools: JIRA, SharePoint, Knowledge of Healthcare Data Formats (HL7, EDI, CSV, XML, JSON), Zephyr testing tool, Figma, MS Office suite (MS Excel, MS Word, MS Outlook, MS Visio). Consulting Focus: Project Management, Analysis Documentation, Enhancement, Automation, Application Development, Data Integration from Life Ray to Salesforce. Client 2: Blue Cross Blue Shield RI Project: Oracle Reconciliation, MA Benefit Solutions, Continuity Of Care, Sr. Markets 2022/2023, Print Migration etc. June 2021 July 2024 Determined and defined project scope and objectives Prepared budget based on scope of work and resource requirements Track project costs to meet budget and performed Cost-Benefit Analysis Develop and manage a detailed project schedule and work plan Manage contracts with vendors and suppliers by assigning tasks and communicating expected deliverables Led process improvement initiatives for the legal department, optimizing workflows for contract management, litigation support, and compliance monitoring, resulting in a 25% increase in operational efficiency. Managed the configuration and customization of Loan IQ for the bank's lending operations, ensuring seamless integration with other enterprise systems like CRM and ERP. Conducted in-depth analysis of loan origination, servicing, and syndication processes, identifying opportunities for automation and process optimization within Loan IQ. Led the data migration from legacy systems to Loan IQ, ensuring that data integrity and quality were maintained throughout the process. Lead the analysis and design of CCW and CCW-R implementations, including gathering requirements from business users, stakeholders, and SMEs, ensuring alignment with business needs. Worked closely with IT teams to translate business requirements into functional specifications for system enhancements and integrations within CCW and CCW-R platforms. Coordinated and led end-to-end testing cycles, including UAT, to ensure the quality and accuracy of CCW/CCW-R modules. Collaborated with healthcare providers to gather requirements for marketing-focused system enhancements within CAPPS, focusing on improving patient acquisition, marketing automation, and customer relationship management. Conducted gap analysis to identify discrepancies between business requirements and current system functionalities, recommending solutions to optimize customer service operations. Collaborated with cross-functional teams to create detailed process maps and streamline existing workflows, resulting in a 20% increase in operational efficiency. Assisted in data analysis, identifying trends, and creating reporting dashboards to support strategic decision-making. Support the integration of healthcare-focused applications with Workday SCM, ensuring smooth data flow between systems and optimizing hospital supply chain workflows. Provide post-implementation support, including training users on Workday SCM and related supply chain tools, to ensure operational efficiency and user satisfaction. Conducted comprehensive cost analysis on external legal services, helping the company shift to a fixed-fee model with external counsel, leading to a 15% reduction in legal expenses. Took ownership of Business Case, Business Requirement Document, Systems Requirement Specification, Solution Scope, Cost-Benefit Analysis, Impact Analysis and Gap Analysis Documentations. Facilitated Technical Requirement sessions with the Business (BlueCross BlueShield), Development and IT team on multiple projects and applications Facilitated business requirements and converted them into Functional requirement documents and Non-functional requirements. Prioritized requirements and addressed complex problems, processed critical data, established facts and drew quality conclusions. Providing technical development leadership and implemented design as it relates to the existing applications or processes that correspond with the architecture strategies at an enterprise level. Working on various Data masking and Data migration projects to Azure cloud. Creating Mapping and Session parameters as well as Mapping and Session variables. Actively involved in data analysis of large databases with up to 1000 tables and sensitive data analysis for larger and different databases, files; data validation and governance of the data that is migrated to the cloud Worked on different API calls and batch processes Working with/leading cross-functional teams within Information management of BCBSRI and NTT Data to ensure positive project impact. Installing, configuring, and verifying the operations of software components. Participating in research, design, development and implementation of application, database, and certificates or other emerging security technologies. Leading groups of individuals in the analysis, design, development and delivery of solutions, and working closely with project teams on customer-specific initiatives that involve data movement, translation or integration development, and to solve highly complex technical data communication and transformation issues. Tools: MS SQL Server, Informatica Power Center, Power BI, FACETS, qTest, MS Office Suite (MS Visio, MS Excel, MS Word, MS Outlook, MS Sharepoint) JIRA, Data Formats (HL7, EDI, CSV, XML, JSON) Consulting Focus: Project Management, Analysis Documentation, Enhancement, Automation, Application Development, Information System Security Data Security, Data migration from Oracle to SQL Management. Position: Sr. Business Analyst/Lead Client 1: Humana Health Insurance Project: Protect Production Data Project (Protegrity Protection) June 2020 June 2021 Facilitated Discovery sessions with the Business (Humana Health Insurance) on multiple applications CSD, FELIX, CRM, MHK Market Prominence. Gathered business requirements and converted them into Functional Requirement Documents, and further translated that into Technical Documents for development. Prioritizing requirements and addressing complex problems, processing critical data, established facts, and drawing quality conclusions. Worked on the configuration and optimization of CCW-R modules, enabling the company to enhance customer billing and service processes for retail clients. Gathered and documented business requirements, user stories, and functional specifications for system development, customization, and integrations. Conducted workshops and training sessions for business users on CCW/CCW-R system functionalities and best practices. Provided hands-on support for Workday SCM and other supply chain systems in a healthcare environment, ensuring efficient workflows across hospital supply chain operations. Managed troubleshooting and issue resolution within Workday SCM, GHX Marketplace, Par Excellence, and NiceLabel applications, ensuring uninterrupted service for healthcare clients. Ensured the company s legal operations were aligned with regulatory requirements (GDPR, SEC), conducting gap analyses and recommending solutions for compliance. Providing technical development leadership and implemented design as it relates to the existing applications that correspond with the architecture strategies at an enterprise level. Working on various Data masking and Data migration projects to Azure cloud. Creating Mapping and Session parameters as well as Mapping and Session variables. Actively involved in data analysis of large databases with up to 1000 tables and sensitive data analysis for larger and different databases, files; data validation and governance of the data that is migrated to the cloud through Protegrity. Worked on different API calls for the CRM Application. Creating relational database and generating SQL scripts to QA extracts. Performing Manual, Regression, End to End, System Integration Testing. Also, providing the business stakeholders with User Acceptance Testing guidance. Performing an active role in the execution of Humana s information system s strategy as it pertains to their vision of the organization in both strategic and tactical plans. Involving in team adoption, execution and integration of strategy to achieve optimal and efficient delivery. Working with cross-functional teams within Information management of Humana and NTT Data to ensure positive project impact. Installing, configuring and verifying the operations of software components. Worked closely with healthcare clients to understand their marketing goals and develop strategies for enhancing patient engagement using CAPPS and other healthcare management platforms. Participating in research, design, development and implementation of application, database, and certificates or other emerging security technologies. Leading groups of individuals in the analysis, design, development and delivery of Protegrity solutions, and working closely with project teams on customer-specific initiatives that involve data movement, translation or integration development, and to solve highly complex technical data communication and transformation issues. Active involvement in Production support testing to ensure the application has been tested for different kind of changes in production like application changes, infrastructure security changes etc. Trained in Protegrity Data Protection Tool Tools: Azure DevOps, qTest, MS Visio, MS Office Suite (MS, Excel, MS Word, MS Outlook, ms Visio) Protegrity Security tool, JIRA, SharePoint, MS SQL Server, Informatica Power Center. Consulting Focus: Data Protection through Protegrity, Process Improvement, Analysis Documentation, Enhancement, Automation, Application Development, Information System Security Data Security Post-Acute Analytics, Lewisville, Texas Position: Sr. Business Analyst/Quality Assurance Specialist Project: ANNA Application Development August 2019 June 2020 Responsible for Product Development. Behaved as a Liaison between the client and technical solutions group using strong communication skills. Delivered of IT infrastructure solutions by interacting with the IT, for our Centers of Medicare and Medicaid (CMS) customer. Elicited, Documented, Analyzed and Validated Business Processes, Systems, and Solution Requirements and documented them as stories on Pivotal Tracker. Facilitated JAD sessions and interview sessions with the Client Users and Stakeholders as a process of Requirement Gathering. Worked Closely with Center of Medicare and Medicaid Services. Performed data mapping of TMSIS codes based on the Medicaid requirements. Facilitated Scrum meetings, daily stand up and one on one sessions with the Development and QA Teams. Serve as the subject matter expert (SME) for Loan IQ platform, providing guidance on platform functionalities, configurations, and best practices to internal stakeholders and external clients. Lead the implementation, configuration, and customization of Loan IQ to streamline loan lifecycle processes, ensuring alignment with regulatory requirements and industry standards. Conduct thorough business analysis to capture requirements and perform gap analysis, identifying areas where Loan IQ can enhance operational efficiency. Collaborate with internal stakeholders and third-party vendors to integrate Loan IQ with CRM, ERP, and other core financial systems, improving data flow and system interoperability. Oversee data migration projects, ensuring the seamless transfer of data while maintaining high levels of data integrity and quality. Work closely with compliance teams to ensure that all Loan IQ configurations adhere to regulatory standards in loan origination, servicing, and syndication. Optimized contract lifecycle processes, from initiation to execution, using contract management software (Ironclad), reducing contract processing time by 20%. Implemented a vendor management system to track external legal spend and manage relationships with outside counsel, leading to a 10% savings in annual legal expenditures. Conducted regular data analysis and provided actionable insights into legal department performance, resulting in improved decision-making and resource allocation. Provided training to legal and cross-functional teams on using new legal technologies and process changes, driving smoother transitions during change management initiatives. Assisted with risk management by identifying trends in litigation and suggesting preventive measures to minimize legal risks. Managed compliance audits, ensuring adherence to corporate governance, regulatory standards, and internal policies. Facilitated Backlog Refinement meeting, Sprint Planning, Sprint review and Sprint retrospective meetings. Introduced and Governed the Scrum process within the Team. Tracked requirements, stories and defects on PIVOTAL TRACKER tool. Created User stories, Use Cases and UML diagrams for stories on Iterations. Created Data Flow Diagrams, Process Flows, Swim Lane Diagrams, Activity Diagrams using MS Visio Created User Interface design and Mock ups using Balsamic tool Expertise in processing EDI 837(Professional/Institutional) Encounter files for Medicaid and Medicare businesses, ensuring compliance with the state and federal regulations for accurate Claim submission and reimbursement. Proficient in usings Change Healthcare Claims Management tool to monitor, track, and manage the flow of encounter data from providers to payer systems. Worked with IT teams regarding EDI transaction such as X12 835/837 codes and many more for Claims Processing. Experience in data mapping from claims systems (EHR/EMR, billing etc.) to Data Warehouses for reporting and analysis. Performed HL7 data validation on the HL7 data sent by both Acute and Post-Acute facilities Created Data Mapping document for Data Integration between multiple databases of SNFs and Acute Care Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems. Functioned as a QA Lead and created Test Plans, Test Scenarios and Test Cases for Unit testing for developers. Performed Regression testing, Integration testing, System testing, End to End testing and Black box testing on the application. Very well versed with Gherkins Language and hands on cucumber automation testing tool. Performed Passive and Active UAT testing of the application. Created test plan, test cases and test scenarios for the Users and drove UAT testing accordingly Knowledge and hands on DRG/CPT/ICD/TMSIS code mapping Responsible for the Help Desk Support and escalated issues faced by the users to the technical team to resolve issues and defects. Created Defect reports, Change requests, Enhancement Requests on Pivotal Tracker. Environment: Agile-Scrum, MS Office Suite (MS Visio, MS Share Point, MS Excel, MS Word, MS Access) Pivotal Tracker, Balsamic, Cucumber, SQL Server Management Studio, Iguana, 3M tool, Jira, Power BI. Consulting Focus: Cloud Strategy, Process Improvement, Enhancement, Automation, Application Development Christus Health, Irving, Texas Position: Data Integration specialist/Business System Analyst Project: ERP SYSTEM INTEGRATION June 2018 Aug 2019 Facilitated JAD Sessions for Requirement Validation. Gathered, documented and tracked requirements for Patient Revenue. Created Functional Requirements Document and Technical Requirement Documents. Analyzed and translated Functional Specifications and Change Requests into Technical Specifications. Designed and developed Use Cases, Work Flow Diagrams, Activity Diagrams, Swim Lane Diagrams and Process flows using Unified Model Language. Led the creation of Data Governance vision, charter, framework, committees and processes. Designed Conceptual, Logical and Physical data flow diagrams for file transfers from ERP INFOR to the vendors and created Diplomat File transfers for the same. Validated Interfaces for each Vendor System and tested the Vendor Interfaces using XML Data Mapping Created source to target mapping Data Mapping for different Interfaces using XML and JSON files. Assisted with data migration and integration efforts to ensure that Workday SCM was successfully aligned with other healthcare-specific applications and workflows. Conducted Gap Analysis for different vendor systems by analyzing their Current state and future state to attain data transformation in ERP Analyzed Supply Chain Management and Human Capital Management reports using Lawson ERP system by INFOR Extensive involvement in Data Migration from INFOR Cloud suite to different Vendor Systems. Ran SQL queries for data validation and performed quality analysis on data extracts to ensure data quality and integrity across various database systems. Ran SQL queries for quality analysis of the extracts developed by developers Functioned as a QA Lead and delegated QA tasks for the team. Created Test Plans, Test cases and Test Scenarios for Data Extract testing. Performed Regression, End to End, System Integration Testing and UAT testing. Created and tracked defect reports and enhancement requests on Service Now. Created UAT test plan and test cases. Involved in both active and passive UAT testing along with the business. Environment: Agile, MS Office Suite (MS Visio, MS Share Point, MS Access) IBM Service Bus, IBM Router, Rational Requisite Pro, Lawson, Service Now, FTP, SSTP, MFT, MS Excel, INFOR Financial Services, ServiceNow, SQL Server Management Studio, Jira. Consulting Focus: Cloud Strategy, ERP Systems, Process Improvement State of Wisconsin - Department of Human and Health Services, Madison, Wisconsin Position: Business System Analyst/Quality Analyst Project: Claims Information Exchange System, Encounter Reporting System, Children s Incident Tracking System June 2017 June 2018 Liaison between client and technical solutions group using strong communication skills and elicited, documented, analyzed and validated business processes, systems, and solution requirements. Gather, Analyze and Report documentation for verbal, written and expedited member and provider complaints, grievances, appeals. Review inquiries to determine if they meet definitions of appeal and grievances. Participate in work group meetings to address trends in appeals and grievance and to work on process improvement initiatives with cross functional teams to reduce trends. Received, processed and routed medical record requests from various providers and vendors. Interacted and communicated easily with departments personnel, medical providers and members. Facilitated Joint Application and Design sessions (JAD) with participants (include Business, Deployment and Support personnel) from across the globe. Worked closely with SCRUM team in understanding epics, user story prioritization and sprint planning. Supported day-to-day operations of the legal department by coordinating administrative tasks, including maintaining legal document repositories and managing internal communication. Assisted in the rollout of a new e-billing system, overseeing vendor integration and providing ongoing support to ensure smooth operation. Developed and maintained a legal vendor database, helping track service level agreements (SLAs) and improve vendor performance. Contributed to the preparation of reports and presentations on legal costs, department performance, and compliance audits for executive leadership. Coordinated and facilitated the development of legal policies and procedures, ensuring alignment with company goals and industry standards. Assisted project teams in preparing Functional Specification Documents (FSD), Business Specification Documents (BSD), User Interface Design Document (UI) Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams/UML Diagrams (UML). Created Mock ups using MS Visio to create data mapping logic. Analyzed and verified changes in EDI raw data for 835/837 transactions according to the 5010 format Performed Gap Analysis for the AS-IS and TO-BE of the IES Application Performed Mappings on the HCPCS, CPT, ICD-10 coding system Worked with IT teams regarding EDI transaction such as X12 835/837 codes and many more for Claims Processing. Data Analysis, Source to Target Mapping, data dictionary and included meta data information for data elements Modelled and integrated new Data Mart Modules in the data warehouse to expand the existing data warehouse capabilities Validated data against the mainframe online screens to check path between UI and database Created Test Plans, Test Scenarios and Test Cases and was extensively involved in Black Box testing, Regression testing, Integration testing and End to End testing. XML file testing for the EDI claims in the IAT region of the IES Application Created Defect reports, Enhancement Requests and Change Management. Facilitated and involved in User Acceptance Testing (UAT) with the stakeholders and the business users. Created Defect Reports and Enhancement requests. Post Production Support o Conducted Workshops, Training sessions on IES application for business users. o Addressed, escalated and resolved Help Desk issues from Business Users Developed Project Status metrics for weekly evaluation of Project Status. Environment: Agile, Waterfall, Tableau, MS Visio, MS Excel, MS-Access, UML, SDLC, JAD, MS SQL Server, Six Sigma, XML, Tableau, Business objects, Oracle SQL Server, JIRA, Informatica Consulting Focus: Change Management, Enhancement, Process Improvement. Additional Experience August 2015 May 2017 Research Assistant University of Wisconsin Risk Management, Change Management and Human Resources IT Technician Division of Technology Services, University of Wisconsin Certifications February 2023 Present SAFe Product Owner/Project Manager Certification. Education Master of Science, Information Technology Management Campbellsville University IT Strategy, Risk Analysis, Operational Assessment, Project Management May 2018 May 2020 Master of Business Administration University of Wisconsin Operations, Leadership, Change Management, Human Resources August 2015 May 2017 Keywords: quality analyst user interface business intelligence rlang information technology golang microsoft Massachusetts Rhode Island