Dideepriya Salla

Sr. Business System Analyst

Professional Summary:

I currently hold 8+ years of Comprehension experience as a business analyst in the healthcare domain, Insurance, and Supply Chain Management. Committed to ongoing professional development and research by constantly creating value for various businesses and clients in delivering quality software systems and enhancing business processes to suit organizational

Also worked on projects like (EHR/EMR/PMS, LIMS system, Insurance regulatory and authority) processing through all phases of SDLC. Knowledgeable with HIPAA, PHI, FDA, FISMA, ACA, GDPA, and claims from the purpose of entry of settling, claim review, recognizing claims preparing issues, their source, and giving prompt relating answers for their related emerging issues. HITECH (motivation of the implication of EHR system), HL7 international standards (protected data sharing between healthcare providers, ICD-9 & ICD-10 (records and codes specific symptoms, diagnoses, procedures.)

Comprehension of insurance policies as, Health maintenance organization (HMO), preferred provider organization (PPO), demonstrated involvement in HIPAA EDI exchange codes as, 270/271 (ask/reaction medical health care benefits), 276/277 (claim status), 834 (benefit enrolment), 835 (Payment/settlement advise), and 837 (Health care claims).

Have excellent analytical, problem-solving, communication, and interpersonal skills, with the ability to interact with individuals at all levels and work as a part of a team as well as independently.

Excellent technical command to work with Agile project management tool like JIRA.

Experience working multiple projects, with both experienced and new agile teams and ensuring delivery of high-quality projects within budget and schedule.

Perfected in defining As-Is &To-Be GAP analysis with proficiency in performing Risk Analysis, Feasibility Studies, change management processes, handling change requests, and conducting impact analysis along with its effect on the Triple Constraints and on the scope of the project. Extensive knowledge, and expertise in various phases of the Software Development Lifecycle like Waterfall methodology, Agile Framework-Scrum, & Waterfall-Scrum hybrid environments.

Proficient in networking with individuals at various levels while organizing, conducting, & facilitating requirement elicitation sessions such as surveys/questionnaires, interviews, brainstorming, focus groups, requirement workshops, document analysis, JAD sessions, Interface Analysis, Observation, SWOT analysis Introspection & Reverse engineering.

Proficiency in documenting artifacts by gathering requirements such as Business Requirements Documents (BRD), Functional Requirement Documents, Software Requirement Specification (SRS), Use Case Documents, Requirement Traceability Matrix, Change Request Documents, Work Breakdown Structure, Risk Register &Project Charter.

Experience in creating Wireframes & Mock-ups using MS Visio & Balsamiq to visualize Graphical User Interfaces. Well, acquainted with Unified Modelling Language (UML) diagrams including Use Case Diagram, Activity Diagrams, Sequence Diagrams, and Business Process Modelling & Notion (BPMN) diagrams using MS Visio.

Detailed working knowledge of SCRUM & its Ceremonies like Backlog Grooming, Release Planning, Sprint Planning, Daily Stand-ups, Sprint Review & Sprint Retrospective Meetings, and Ceremonies.

Assisted the various teams in resolving dependencies and empowering the teams with the Pillars of Scrum such as Transparency, Inspection, and Adaptation, and achieving the goal to deliver the PSPI at the end of each Iteration.

Experienced in writing User Stories, defining Acceptance Criteria, and assisting in the Definition of Ready and Definition of Done. Well-versed in breaking down Epics into User Stories by satisfying INVEST criteria in grooming meetings.

Assisted Product owner in prioritizing the User stories in the Product Backlog artifact using various Prioritization Techniques such as Moscow, Kano, Forced Ranking method, walking skeleton, and 100-point method.

Efficient in performing vertical and horizontal slicing of User stories and determined Story points by Estimation Techniques like Planning Poker, T-Shirt sizing, Relative Mass Evaluation, Bucket sizing, and Affinity Mapping.

Experience in handling Change Request Management effectively implemented change by performing both Business Impact Analysis and Technical Impact Analysis to understand the upstream and downstream dependencies.

Performed Analysis to Identify Sources, Targets and wrote the Transformation Rules for the process of Data Migration. Involved in Conceptual, Logical models and created ER diagrams (Entity Relationship) for the data modeling phase.

Experience in implementation of Dimensional data modeling with Star & Snowflake schema, Facts & Dimensions. Proficient in creating Data dictionaries, Data glossaries, Data Mapping specifications & Data Mapping documents. Worked on Relational Database Management System, Data Warehouses, Data marts &Operational Data stores (ODS).

Extensive knowledge of the Extraction of data from source systems, Transformation of data sources into an integrated system (Transformation includes Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Source Qualifier, Expression, and Router), and a load of the data into the data warehouse using Informatica Power Center. Broad execution and information on OLAP (MOLAP, ROLAP, and HOLAP) operations like Roll Up, Drill Down, Slice, Dice, and Pivot as well.

Data Warehouse configuration utilizing techniques like Kimball's design and Inmon's Corporate Information

Performed API endpoint validation using Postman and documentation using Swagger to capture the Headers, Query Parameters, Resources, and POST/PUT response body and received different bug/error codes. Mapped the designed URLs for the RESTful APIs to the business requirements and operations by using Service Oriented Architecture (SOA).

Well-versed in web services like REST/SOAP based on XML, and JSON using HTTP/HTTPS under the Three-Tier, Service Oriented Architecture (SOA) and Micro services Architecture (MSA) as well.

Closely operated with the API & Web Services team while developing new APIs &enhancing existing APIs along with preparing API technical & testing documentation using & Postman Soap UI software for the whole system processes.

Collaborated and worked with the testing team during the testing life cycle and supervised Black-Box testing, functionality testing, system testing, integration testing, regression testing, and have experience in facilitating User Acceptance UAT, using HP QC/HP ALM, Smoke and Sanity testing of applications with knowledge on STLC (Software Testing Life Cycle) by creating Test plan, Test Scripts, Test cases, Test Scenarios as well as Test reports.

Worked on JIRA for Reporting and used it for bug tracking, issue tracking, and project management.

Thorough understanding of Business Intelligence (BI) and experience in creating interactive reports, and analytical dashboards using Tableau and IBM Cognos/ Power BI (business intelligence) for visualization and decision making. Used Tableau as a BI tool for generating Analytical Reports required for the project for further analysis.

SKILLS, TOOLS, AND TECHNOLOGIES

Health care Domain Knowledge

Medicaid, Medicare, Patient Segmentation, HIPAA, ICD 10 CM, Claim Processing, Electronic Health Records, Apex EDI, Facets

SDLC Methodologies

Waterfall, Agile-Scrum, Waterfall-Scrum hybrid.

Business Skills

Change Management, Problem & Incident Management, Impact Analysis, JAD Sessions, SWOT Analysis, Project Planning, Project Scheduling, Project Budgeting, Risk Management, Excellent Communication, Competent leadership & managerial skills, Goal & Time oriented.

Data Modeling & tools

Dimensional Data Modeling, Fact and Dimension tables, Data Marts, Data Mining, ETL, Slicing/ Dicing, Drill Down/ Star and Snowflake Schema.

Business Modelling and Designing Tool

MS VISIO, Balsamiq, Lucid Chart, Unified Modeling Language (UML), MS Share Point, JIRA, Confluence.

Reporting/BI and ATL tools

Tableau, Microsoft Power BI, Informatica Power Center, Informatica Data Cloud Integrator, Informatica Scheduler, SQL Server Integration Services

Roles and Responsibilities:

Performed Document Analysis and Business Process Re-engineering (BPR) and constructed a Process Flow Diagram (PFD) to examine the workflow of each department, associated different entities, instruments, and tests, and Extensively Gathered Business Requirements from stakeholders by adopting various requirement elicitation techniques such as Interviews, brainstorming, focus groups, email chains, requirement workshops to attain clarity on system specifications and expected final product from end-users.

Actively participated in JAD sessions with the SMEs, Development team, Data Architect, Data Analyst, Testers, Key Stakeholders, by interacting with the group gather information, analyze, and develop solutions. Created Business Process Model (BPM) to visualize the workflow of the business process, Data Diagrams such as Context diagrams to depict how data flow through the system and how components of the system interact, UML diagrams such as use case diagram, activity diagram, and sequence diagram using Lucid Charts to communicate the flow of project to all the stakeholders.Gather and analyze client’s business requirements for design, application configuration and implementation of UI/UX web initiatives.

Intelligently collaborated with the Product Owner in determining features for MVP and participated in Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective.

Actively cooperated with the Product Owner to build INVEST compliant User Stories in JIRA, &specified Acceptance Criteria for each user story. Assisted the Scrum Master in conducting sessions for Slicing, Prioritizing, and Estimating methodologies to user stories, and worked with the PO &the team to create the Definition of Ready&definition of done.

Written SQL queries to extract and validate the data from the database.

Documented user and functional requirements for Healthcare professionals' HCP look-up between Veeva CRM and third-party Medallia database. Applied Use case diagram to validate and test web application design against UI architecture.

Actively involved in the health of account relationships by correlating feedback with engagement metrics to identify potential risk or opportunity areas and provided insights on Recommendation Development based on collected data and insights, propose strategies to improve the overall customer experience and enhance engagement effectiveness.

Coordinated with Veeva and Salesforce for any issues in the current platform and new releases.

Provided solutions for the salesforce best practices for customer service implementation.

Solved the workflow problems in high intensity environments, through visual and interaction design. Planned and implemented UI/UX strategies.

Maintained Tractability matrix throughout the project and developed flow charts &flow diagrams using lucid chats.

Retrieved data for data validation using SQL queries like Joins, views, Subqueries, and Aggregate functions like max, min, sum, and average with a good understanding of Procedures, Functions, and Triggers for data manipulations, data extraction and data mapping.

Developed test cases and test plans on the basis of requirements and also did manual testing on the templates of the surveys to ensure that the surveys were as expected. Assisted actively along with the Testing Team in various types of testing such as Data Validation Tests, Data Integration Tests, Performance Tests, and Usability Tests.

Experienced in planning and executing system integration, functional testing, regression testing, testing performance.

Collaborated with team and regularly to review and iterate on the VOC program based on feedback, changing business objectives, and emerging best practices in the industry.

Coordinated with the client team in the User Acceptance Test (UAT) phase and gathered feedback from the clients.

Facilitated the training for the staff through the Learning Management System (LMS).

Environment: Agile-Scrum, Amazon Web Services such as AW, AWS S3 bucket, Lucid chat, My SQL v5.7, JIRA 8.16, Confluence v7.11, MS Office 365, Salesforce lightening, Veeva CRM

Roles and Responsibilities.

Elicited requirements using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups and analyzed the feasibility of the requirements and formulated and derived requirements for EMR and EHR data processing, and gathered Knowledge of HIPAA & PHI operating rules and guidelines, as the data should be processed in real-time by working with the engineers, programmers, and the end users to ensure the accuracy of the transfer of data and its enhancements business owners, development teams, and subject matter experts to elicit requirements and structure them.

Interacted with the teams to gather requirements for retail and PBM IPad integration project.

Analyzed the business requirements for the doctors/ Physicians and Secure Member of the Customer web portal.

Introduced agile methodology and related tools in pilot phases of the project, met executive management to review the various agile practices and get them on board along with the initial plan to be implemented.

Established and supported communities of practices to promote organizational understanding of Agile roles and to help individuals develop into them. Requirements elicitation with the PBM teams for the iPad &webservices projects.

Conducted research and evaluated hardware and software technology options & performed the Cost Benefit Analysis.

Conducted GAP Analysis to thoroughly understand and document the AS-IS process flow and to determine the TO-BE process flow by considering all the Functional and non-functional requirements, Data, and GUI requirements.

Communicated across all the Stakeholders about various aspects like Electronic Data Interchange (EDI), protected health information (PHI), and Health Insurance Portability and Accountability Act (HIPAA) compliance to keep the health data protected from any users who are unauthorized to have access to the records of health data.

Populated and refined the Product Backlog, &defined Acceptance Criteria for the user stories to be included in the implementation. Prioritized the Product Backlog and slicing user stories. Entailed with the Scrum Master in creating Burn Up/Burn Down charts to communicate team progress with the Product Owner and the corporate executives.

Assisted in implementing Datawarehouse by identifying all the facts and dimensions in the tables, participated in the designing of Schema, data mapping, and data glossary document for easier and faster Data Retrieval. Integrated Salesforce Health to establish a doctor-patient relationship and record management.

Created clear and atomized User Stories with Backend Subtasks to grasp and plan the feature for development using JIRA.

Maintained the full Agility Board on JIRA, and assisted the testing team in tracking bugs, issues, and defects.

Involved in creating wireframes, mock-up screens, Data flow diagrams, use case diagrams, sequence diagrams, and Activity diagrams for the To-Be system, and Reporting User Interface (RUI) using Microsoft Visio for Business Stakeholders and end-users along with the customers to get a better perspective on the flow of the system.

Identified the source and target data systems to configure Data Mapping and Integration between sources MS SQL Server Oracle database, MySQL Server, and target AWS Redshift to store information about various health forums.

Identified the different data sources and participated in the ETL process using the Informatica Power Centre.

Executed various SQL queries such as Joins, subqueries, order by, group by, select, and union.

Performed API documentation and specification for request and response messages using POSTMAN/SWAGGER.

Assisted the QA team in creating Test cases, Test plans, and Test Scenarios through Micro Focus. Knowledge in building interactive Tableau dashboards by utilizing Tableau features such as parameters, sets, calculated fields and table calculations, user filters, and action filters by applying advanced technical charts.

Gained extensive knowledge and understanding of MITA, MMIS, Electronic Medical Health Record EMHR

and Pharmacy Benefit Management PBM .

Environment: Agile-Scrum environment, JIRA (8.5.13), Confluence (7.0) MS Visio, HTML, AWS DB, SQL Server (8.0), MS Office, Postman, Swagger (2.0), Tableau (2021.1), Informatica PowerCenter (PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository Manager), AWS Redshift.

Roles and Responsibilities:

Facilitated Focus Group sessions with the subject matter experts such as medical billers, doctors, nurses, & administrative staff to elicit the functional, non-functional, and other system-specific requirements, along with Brainstorming events.

Performed Document Analysis to closely study the ins and outs of the current system and conducted GAP Analysis.

Facilitated Joint Application Development (JAD) for discussing critical requirements, identifying business workflow, analyzing to check the effect on the existing system, and conducting semi-structured interviews.

Identified the major system features, and system constraints and developed Business Requirement Documents (BRD)

Analyzed working of EDI X12 transactions such as 835,837 P/I, analysis of appointment scheduling data, billing data, encounter data, claims processing, medical scheduling, payment processing, and patient portal of the existing system.

Identifying key metrics to allow the organization to quantify levels of maturity from an agile baseline.

Analyzed the workflow of messages in various HL7 formats like ORU, and ADT monitored their parsing and conversion in the analyzed format and viewed database updates, which were made while message processing through debugging support. Monitored multifarious alerts and along with the support team resolved various issues. Worked with various versions of HL7 v2.x as well as with ICD-9, ICD-10, SNOMED, LOINC, CPT, and HCPCS codes.

Worked with clinical interfaces using various standards like CCD and CCDA. Also, monitored the messages that Failed Processing, and decided to either repair, review, or resubmit them based on the business decisions made.

Utilized the testing feature of the interface to test conformance between messages received from an external healthcare partner and the expected message format. Also tested the applied Data Routing, Data Filtering, and data mapping rules before putting the system into the production environment. Supervised the interactions of the Integration Engine with the database & made modifications accordingly. Developed various Data Flow diagrams, Process Flow Diagrams including Use cases, Activity Diagrams, and Sequence diagrams.

The company's PBM services include retail network pharmacy management and retail drug card programs home delivery pharmacy services specialty pharmacy services patient care

Assisted Product Owner in breaking down epics into user stories that have well-defined Acceptance Criteria and Definition of Ready. Acted as a Proxy Product Owner in his absence to prioritize the features.

Assisted the Product Manager in prioritizing features and developed the Wireframes and Mock-up Screens to understand the User Interface part and get clear feedback from customers, as well as the stakeholders. Assisted the development team in understanding stories and estimating story points using the T-shirt sizing technique.

Managed epics, user stories, bugs, tasks, and defects as well as conducted sprints, monitored burn-up, burn-down, and velocity charts using JIRA along with Scrum Master, and acted as a proxy whenever needed. Used Confluence for sharing vital information across and allowing collaboration among the team members and various teams.

Responsible for maintaining and extending the automation suite and keeping track of UI changes that impact test scripts. Worked on developing and testing functionality for the subgroups module like PBM Pharmacy Benefit

Utilized SQL queries for querying data from the backend for a data scope assessment, analysis & validation. Used various types of Joins, and Aggregating Functions within SQL for generating reports.

Analyzed Test Performance reports, identified issues and reported them to the developers, and performed overall test management through Zephyr. Performed testing & validation of HL7 messages through FHIR API using POSTMAN, documented REST APIs and various Streaming APIs using SWAGGER.

Developed Feature Files, and Acceptance Criteria using Gherkin for conducting Behavior-driven Development (BDD) tests, as well as assisted testers in conducting TDD & ATDD using JUnit and Fitness.

Based on requirements created different types of interactive customized Ad-hoc and management reports on Microsoft Power BI. Ensured that patient data stays protected, and the overall project follows HIPAA compliance.

Environment: Agile-Scrum environment, JIRA (8.17.0), Confluence (6.13), MS-Office Suite, CSS 3, Integration Engine, Microsoft Power BI, Lucid Chart, JSON, Swagger (2.0), Postman, Web Services.

Roles and Responsibilities:

Worked in Agile software development methodology & assisted Product owner in performing user & market research.

Interfaced with the Subject matter experts (SME's), Stakeholders to understand business needs and requirements, set up the technical vision of the product, and analyze triple constraint trade-offs.

Managed Impact Analysis to get an estimation of the system conversions of ICD 9 codes to ICD 10.

Accumulated information on HIPAA (Securing data), GALP (Good automated laboratory practices), GSP (Good storage practices), GDPR (collecting, securing personal data, financial, medical, and biometric data) rules and guidelines. Integrated Electronic Health Record (EHR) system to LIMS system under HIPAA guidelines, applied HL7 and EDI X12 transaction to the elements for data transaction.

Generated UML diagrams- Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in Lucid charts.

Immovably cooperated with the Product Owner to Prioritize and Estimate the User Stories and write detailed Acceptance Criteria using JIRA to support Potentially Shippable Product Increment (PSPI).

Registered the Traceability Matrix for drafting the Test Cases and requirements identified with them.

Firmly worked together with the Product Owner to Prioritize Product Backlog, Slice/Breakdown User Stories, Estimate the Spring Backlog, characterize Acceptance Criteria, and Definition on Done utilizing Jira.

Helped the Scrum Master in making Burn Up/Burn down Charts to convey team progress with the Product Owner.

Documented and assisted the testing team to write Test plans, Test scripts, and Test scenarios for functional, load, stress, performance, and regression testing of REST API, and SOAP UI, and identifying the API analytics.

Effectively checked out the Scrum Ceremonies such as product vision meeting, Backlog Grooming/Refinement, Sprint Planning meeting, Daily Scrum meeting, Sprint review, and the Sprint Retrospective meetings.

I was responsible for creation and execution of manual test cases for functional and regression testing.

Participated in UAT cycle test scripts, reviewed User Acceptance Test Plan (UATP), and take part in the walkthrough.

Involved in managing bug tracking and defect prevention activity using defect management life cycle in JIRA to improve issue/bug fixes and maintained the issue log. Solely responsible for the design of several key data tables and ETL routines, that will streamline reporting needs as well as improve report performance.

Designed and created complicated SQL queries for production support data analysis, which involved fetching and displaying data using SQL queries that effectively executed exporting table data in MS- Excel and flat files.

Created various graphs such as Heat Map, Tree Map, Scatter plots, and dashboards using Tableau for identifying opportunities and spotting inefficient processes.

Environment: Agile-Scrum environment, JIRA ((7.4.5), Lucid charts, Balsamiq, Tableau, Informatica, MS PowerPoint, MS Excel, MS Access, Oracle.

Roles and Responsibilities:

Elicited requirements using techniques like Requirement workshops, semi-structured Interviews, document analysis, and Joint Application Development (JAD) sessions and analyzed the gathered requirements.

Conducted Gap analysis (As-Is to To-Be) to document requirements for existing system enhancements.

Created various requirement artifacts such as Business Requirements Document (BRD) and Functional Requirement Document (FRD), and the Requirements Traceability Matrix (RTM) to track issues.

Worked on GUI development by creating mock-ups to review requirements and provided feedback on the screen design using MS Visio. Coordinated with the Change Control Board and when a Change Request needed to be registered. Performed Impact Analysis on the Change Request, as well as got the necessary approval signoffs.

Conducted testing before data migration and Extraction transformation load ETL jobs along with the creation of fact and dimension tables for dimensional modeling. Performed roll-up and drill-down operations as a part of Online Analytical Processing (OLAP) data warehouses to present data in the required format to the stakeholders.

Normalized the data to fit into various fact and dimension tables of snowflake schema for higher data storage.

Made use of Informatica Power Center to extract data, apply transformations and load it into the target repositories.

Coordinated with the testing team during the formulation of Test plans and Test Cases for Functional, System Integration, User Acceptance Testing (UAT), and Regression Testing based on Design documents, User Requirement Documents for Functional and Performance Testing.

Created visualization reports, and dashboards using the Power BI tool to report to the key stakeholders on time.

Acted as a scribe by being involved in JAD sessions with stakeholders, subject matter experts (SME), end-users, software architects, and developers to work out requirements definition and software system design methodology.

Designed &developed UML Diagrams including Use cases, Activity Diagrams and Sequence Diagrams, and MS Visio.

Environment: Waterfall-Scrum Hybrid, JIRA (7.15.1), Confluence (7.14), MS word, MS Access, SQL Server 2012, Informatica Power Center (v.9.6.1), MS Office Suite 2013, MS Visio (v.15), Power BI.

Role and Responsibilities:

Performed Requirements Workshop and Document Analysis to elicit the multifarious requirements.

Performed Card Sorting to understand the view of customers regarding the User Interface part.

Based on the outputs of these sessions, developed Business Requirement Document (BRD), Functional Specifications Document (FSD), and System Requirements Specification (SRS) documents.

Designed various UML diagrams like Use case, Activity, and Sequential diagrams using MS-Visio.

In the development phase, analyzed the working of software in the developing environment.

I used MS-Project for keeping track of various tasks and used SharePoint for document management.

Handled the Change Management process and convinced the Change Control Board (CCB). Conducted business and technical impact analysis and rebase lined the artifacts.

In the testing phase, developed various Test cases and performed defect mgt. using ClearQuest

Conducted User Acceptance Testing (UAT) and addressed the concerns of users through their feedback.

Maintained continuous communication with developers and testers to ensure that the modifications are in alignment with the requirements.

Assisted the Operation and Maintenance team in documenting the Standard Operation Procedures (SOP).

Environment: Waterfall, JIRA (7.15.0), HTML 5, CSS 3, Microsoft Visual Studio 2013 Microsoft SQL Server 2012, MS Office, MS-Project 2010, SharePoint.

Roles and Responsibilities:

Participated in the JAD session along with developers, business analysts, and other stakeholders to get a detailed understanding of the requirements. Participated in software testing lifecycle phases.

Analyzed the requirements to understand testable requirements by interacting with various stakeholders.

Updated Requirements Traceability Matrix (RTM) and participated in defining the Entry and the Exit criteria for all the phases in Software Testing Lifecycle.

Assisted Sr. Quality Assurance Analyst to prioritize testing objects, documenting test environment details, and carrying out Automation Feasibility Analysis. Participated in determining efforts and cost estimates and baselined the Test Plan document after reviewing Test Strategy.

Developed, documented, and maintained functional test cases and other test deliverables like Test Data, Data Validation, and Test Scripts using HP Quality Center and assisted in Defect Lifecycle management.

Actively worked on Smoke & Sanity testing to analyze critical functionalities before and after updating the code.

Executed and evaluated GUI Testing, User Acceptance Testing, and manual testing.

Monitored the STLC process and logged an issue in the Issue Log document and assisted in prioritizing these issues.

Environment: Waterfall, HTML, JIRA, CSS, SharePoint, SQL, SWOT, MS Excel, MS PowerPoint, HP QC, Confluence.

Education: Bachelors in Biotechnology Engineering – Koneru Lakshmaiah University, India

Genentech Biotechnology Corporation, CA December 2022-Present

Business System Analyst

The project was focused on a VOC

Contact this candidate