SUMMARY

• Sr. Business Systems Analyst with over 8+ years of diverse expertise in Pharmaceutical and Healthcare domains with focus on Business Analysis, Software Development Life Cycle (SDLC) methodologies and Business Process Reengineering (BPR), Application Development, Testing and UX/UI Design.
• Experienced in waterfall, Scrum and hybrid methodologies like Water - scrum-fall along with expertise in using Extreme programming (XP), Spiral, Scaled Agile Framework (SAFe), Kanban, Scrumban and RUP.
• Extensive working knowledge and working exposure to Healthcare domain concepts such as HIPAA and FDA guidelines, Medicare and Medicaid, Electronic Health Records (EHR), Electronic Data Capture (EDC), Health Effectiveness data and Information Set (HEDIS) measures, Remote Patient Monitoring, Internet of Healthcare Things (IoHT), Monitoring devices, KPI tracking and Salesforce Health Cloud.
• Practical experience in Health Insurance Domain such as Explanation of Benefits (EOB), Health Maintenance Organization (HMO), Preferred Provider Organization (PPO), Point of Service (POS), Electronic Data Interchange (EDI), ICD - 10 CM, Claim Payment Processing pertaining to HIPAA, EDI 5010, ANSI X12 837, 835, 834, 999 and 270/271.
• Acted as a liaison between Business and Technical Stakeholders to elicit various Functional and Non-functional requirements through a variety of elicitation techniques such as Stakeholder Analysis, Interview, Brainstorming, JAD & RAD sessions, Requirements Workshop, Survey/Questionnaire, Document Analysis, Focus Groups etc.
• Experienced in managing RIMS activities like submission planning and tracking, Product registration, change control and Commitment management maintaining data standards and governance following IDMP, HL7 standards.
• Efficiently converted the requirements into Technical specifications and articulated across all the Stakeholders.
• Conducted multiple Feasibility studies, Risk Analysis, Cost Benefit Analysis, SWOT analysis and Impact Analysis to analyze the needs of a project and its execution. Performed GAP Analysis to understand AS-IS and TO-BE business processes.
• Created multiple deliverables such as Business Requirements Document (BRD), System Requirements Specification (SRS), Functional Specification Document (FSD), Data Requirements Specification (DRS), Project Charter, Project plan, RTM and RACI matrix thereby possessing a broad knowledge of Documenting and Presenting the deliverables at every milestone.
• Improved the teams’ competencies by creating Work Breakdown Structures (WBS) and Critical Path Analysis (CPA).
• Managed Requirement Churn carefully and efficiently documented Change Management plan.
• Highly proficient in creating Use Case Document and Unified Modeling Language (UML) diagrams like Use Case diagrams, Activity diagrams and Sequence Diagrams using different versions of MS Visio and Lucid Chart.
• Profound knowledge of Agile ( Scrum) framework including Scrum Ceremonies like Backlog Grooming, Sprint Planning meeting, Daily Scrum, Sprint Review Meeting and Sprint Retrospective. Efficiently documented various Scrum Artifacts such as Product Backlog, Sprint Backlog, Information Radiators ( Burn-up - Burn-down charts).
• Carefully examined the Triple Constraints pertaining to the project to maintain a balance in the Scope, Time and Resources.
• Closely assisted the Product Owner in requirement elaboration and acted as a Proxy Product Owner as and when required.
• Apt in breaking down Epics into User stories keeping the INVEST criteria in acceptable limits. Experience in slicing the user stories using Horizontal and Vertical Slicing Techniques, Prioritizing the user stories using techniques such as MoSCoW, Kano and Estimating the user stories using techniques like Planning Poker, T-shirt Sizing and Relative Mass Valuation.
• Skillfully supported the Product Owner to define Minimum Viable Product (MVP), Rigorous Definition of Done (DoD) and narrowed down the Acceptance Criteria for the user stories to be included in the development process.
• Proficient in creating Prototypes, drafting Mockups and Wireframes to visually present the requirements to the Stakeholders for better understanding of the outcomes and to accommodate any changes, using MS Visio and Balsamiq.
• Harbored various Conflicts which arose during the development process by effectively negotiating with the Developers, Testers, Architects, SME’s, Business users, Enterprise level Management and all the Stakeholders of the projects.
• By identifying various Entities and their Relationships, created Entity-Relationship Diagrams (ER) and the associated Conceptual and Logical Data Model to define the required objects accurately (without any Redundancy) in the Database. Helped understand Anomalies in the database design and Normalization to address them.
• Explicit insight and knowledge of Data warehouse implementation, ETL process, Data Profiling, Data Integration, Data Mapping, Data Migration, Data Governance, Data Conversion, Data Quality and Data Modeling concepts along with experience implementing Databases, ODS, Data marts, Data Analysis, Data integration, Schemas, OLTP and OLAP operations like Drill down, Roll Up, Slicing and Dicing.
• Thorough knowledge of DML, DDL and TCL SQL queries such as Joins, SELECT, Views, Order by, Group by, Relations, Triggers, Stored Procedures, Rollback, Commit and Aggregate functions such as Count, Min, Max.
• Experienced in Application Program Interface ( API) testing using Postman and SoapUI to check if the API response data is in JSON or XML format as required by workflow to resolve discrepancies and used Swagger for API documentation.
• Well versed with System architectures like n-tier architecture and Service Oriented Architecture (SOA).
• Working knowledge of MySQL database, Data Warehouse and Hadoop HDFS.
• Actively involved in creating and documenting various Test Artifacts like Test Plan, Test Data, Test Scripts, familiar with Black Box testing and have experience in conducting Smoke and Sanity Testing.
• Effectively utilized Project Management tools like JIRA, Collaboration tools like MS SharePoint and Confluence, Business Presentation tool like Prezi, Reporting tools like SQL Server Reporting Service (SSRS) and Tableau.
• By analyzing the requirement of the project, assisted in creating various Static, Ad-Hoc, Tabular, Dashboards and Technical Reports.

TECHNICAL SKILLS

Healthcare and Healthcare Insurance Domain: Medicaid, Medicare, Patient Segmentation, HIPAA, ICD 10 CM, Claim Processing, Electronic Health Records, Apex EDI

Software Development Life Cycle: Agile-Scrum, Scrum-Waterfall, Waterfall, XP, SAFe, Spiral, Kanban, Scrumban

Business Skills: Change Management, Impact Analysis, JAD Sessions, Project Planning, Project Scheduling, Issue Management, Conflict Management

Business Modelling Tools: MS Visio, Lucid Charts, Balsamiq mockups

Project Management Tools: JIRA, HP ALM, MS SharePoint, Confluence

BI and Reporting tools: Tableau, MS Office Suite (Excel, Word, PowerPoint), Prezi, SQL Server Reporting Service (SSRS)

Architecture/Framework: Service Oriented Architecture (SOA), 3-Tier Architecture, n-Tier Architecture

Databases and ETL Tools: RDS DB, Informatica PowerCenter, HADOOP HDFS, HIVE, Dynamo DB

Data Warehousing: Enterprise Datawarehouse, Data Marts, ETL, Red shift

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Sr. Business Systems Analyst

Responsibilities:

• Interviewed Subject Matter Experts (SMEs) and performed extensive Document Reviews to develop an in-depth understanding of the Business Processes to aid Business Process Improvement (BPI).
• Conducted Brainstorming sessions to perform GAP Analysis by understanding AS-IS business flow and by using Prezi Business Presentations, facilitated TO-BE requirements using Joint Application Design (JAD) sessions.
• Drafted Process Workflow, Use-case diagram and Activity Diagram (UML diagrams) using Lucid Chart.
• Assisted the PO to conduct and document SWOT analysis in order to be prepared for any business risks.
• Reviewed and Analyzed the HIPAA compliances and guidelines pertaining to Protected Health Information (PHI) to develop and enable Device Authentication feature for secured data transmission.
• Communicated the importance of ICD 10 codes and collaboratively baselined Apex EDI as a translator software and was involved in its integration process. Collaborated to discuss the Effectiveness of Health Data (HEDIS measures).
• Worked closely with Data requesting protocol X12 270 to gain access of the patients’ coverage plan and benefits and further to transmit the data representing the care provided (EDI 837) through a Clearing house (VAN).
• Actively participated in the Scrum Ceremonies such as Backlog Grooming/Refinement, Sprint Planning meeting, Daily Scrum, Sprint review Meeting and Sprint Retrospective. Closely collaborated with the Product Owner to create User Stories and Acceptance Criteria using JIRA to validate Potentially Shippable Product Increment (PSPI).
• Assisted the Product Owner and the team closely to prioritize, slice and estimate the Product Backlog items and defining the Definition of Done (DoD) to include these items into Sprint Backlog.
• Assisted the Scrum Master to create and document deliverables like Information Radiators (Burn-up - Burn-down charts) to transparently communicate with all the Stakeholders and also track the teams progress.
• Actively involved in maintaining the agility board to track the different issues and bugs using JIRA.
• Applied the Top-Down approach of System Design based on various Functional Requirements, Non-Functional Requirements and Data Requirements and assisted the Technical team to design an In-House Service Oriented Architecture (SOA) system by mainly considering the services and utilities revolving around our system.
• Assisted the Architects in creating Data Flow Diagrams and communicated across all the Stakeholders.
• Helped the Developers to analyze various Communication protocols and assisted in selecting a secured mode of communication
• To simplify key-value paired JSON language, implemented a JavaScript Parser. Communicated the requirement of capturing real time data and eventually implementing Web Sockets to serve the purpose.
• Implemented the Web Application Firewall (WAF) to authorize as well as deny certain systems/users to have access to Electronic Health Records (EHR) to Electronic Data Capture (EDC) from fraudulent users.
• Assisted the Architects in selecting the various API’s which can be efficient based on the Service Requirements.
• Reviewed, Baselined and Documented the API’s required for efficient functioning of the system. Implemented RESTful API, APACHE TOMCAT API for effective communication between the system.
• Further stored data in Redshift and performed Analytics through AWS platform and loading the replicated structured data in Secondary Storage Areas.
• Assisted in creation of Test Cases, Test Plans and Test Scenarios and created Requirements Traceability Matrix (RTM).
• Conducted User Acceptance Test (UAT) and actively participated and facilitated Smoke Testing and Black Box Testing.
• Involved in integrating Visualization and Reporting tool such as SQL Server Reporting Service (SSRS) to create Customized Dashboards, Static reports as well as Ad-Hoc reports.

Environment: Agile-Scrum environment, JIRA, Confluence, Prezi, Lucid Chart, APACHE TOMCAT, Redshift, RDS, Dynamo DB, AWS, Service Oriented Architecture.

Confidential, Rensselaer, NY

Sr. Business Systems Analyst

Responsibilities:

• Responsible internal controls with process flow, segregation of duties, financial foresight, risk assessment, and information and communication according to the SOX compliance.
• Learned relevant technologies to participate in the design, development, testing, and implementation of Salesforce Sales Cloud, Marketing Cloud, and integration with Oracle ERP for Business Process Re-engineering (BPR).
• Networked with Subject Matter Experts (SMEs), Project Managers, and Process Analyst to understand the business processes by gathering requirements and identified enhancement.
• Interface with various departments within the organization to understand process flows, their needs, and documented GAP analysis by identifying AS-IS and TO-BE process models.
• Created enterprise business process modeling (BPM), mapping of importing salesforce contacts, centralized technical documentation at one place to drive transparency and defining process timeline with lucid charts.
• Facilitated two-way integration with MuleSoft API manager to synchronize Oracle ERP data with Salesforce to connect EHR, facilities and procedures, environmental information, credit and claim information of patients.
• Successfully implemented APIs to connect with webservices in HTML, JSON and XML formats as per requirements.
• Verified the data integrity due to the system integration with the help of SOQL and SOSL query languages.
• Supported partners understanding Object data, Groups, Dashboards, Announcement and reports.
• Created a patient field within Salesforce Account object that will reflect the level of reliability and implemented encryption to patients’ Protected Health Information (PHI) and Personal Identifiable Information (PII).
• Assisted in designing and deploying workflows, validation rules, approval process and auto-response rule for automating business logic with health cloud on Salesforce.com.
• Involved in the development process, gave fast feedback, and assembled apps that are a better fit for the purpose using the lightning platform and enabled messaging and queuing, alerts and notifications using Heroku platform.
• Helped admin using Einstein activity capture to create application dashboards and pre-build data sets in the salesforce, lensed to explore the data sets within Salesforce.
• Documented and tested Chatter REST, Radian6, Desk.com, and Bulk APIs considering different functionalities.
• Trained users on system usage, investigated issues with troubleshooting and reported to developers for resolution.
• Enabled 360-degree view of the patient at a single point of view for better forecast and analysis.
• Streamlined the arduous and stringent process of scheduling meetings between healthcare providers and Lilly reps to contract physicians.

Environment: Salesforce Health Cloud, Oracle ERP, MuleSoft, JIRA, Lucid Charts, Ruby, Confluence.

Confidential, Norfolk, NE

Business Systems Analyst

Responsibilities:

• Actively involved in upfront planning and designing phase.
• Interacted with the client and the Technical Team for requirement gathering and translation of Business Requirements to Technical specifications .
• Created the business requirement document (BRD), system requirement specification (SRS) document and develop timelines for project delivery, and managed projects and resources to successful completion.
• Held regular Joint Application Design (JAD sessions) with the Business Leads, SMEs, system architects.
• Reviewed technical recommendations related to software and hardware proposals.
• Created a Release Planning Document consisting of a high-level overview of all the requirements to be released in the upcoming sprint and assisted in creating a pre-defined release schedule.
• Assisted the Project Manager in creating a Product backlog which is a detailed requirements document formatted according to the IEEE 830 standards for requirements specifications.
• Acknowledged the Iterative and Incremental development process in order to understand Hybrid Agile framework.
• Actively took part in determining the cadence for the sprint based on the Capacity of the team and participated in Scrum Ceremonies.
• Assisted the Technical team to identify the source and the target of the data for an efficient data migration through ETL process using Informatica PowerCenter.
• Helped in creating Conceptual and Logical Data model and created a Data Mapping document.
• Assisted in integrating data from regional storage to a single data mart by conformed dimensions.
• Based on the Release Planning Document, assisted the Project Manager to set a limit on the release frequency and helped the testers to conduct System testing and User Acceptance Testing before creating a solution for Deployment.
• Created a Deployment plan by closely analyzing the characteristics of the Production environment and saw the project to “Go-Live”.

Environment: Waterfall-Scrum Hybrid model, Data Warehouse, SharePoint 2010, SWOT, MS Office, Confluence, Prezi, MS Visio, Informatica PowerCenter.

Confidential

Business Systems Analyst

Responsibilities:

• Led product implementations and business requirements sessions with clients to understand available instruments, tests, test procedures, and associated standard codes and regulations.
• Analyzed the GAP between standard operating procedure (SOP) and actual procedure followed for routine and batch lab testing from work order through sample tracking to loading reports.
• Represented the system to stakeholders using a use case diagram and activity diagram using Lucid Charts.
• Defined, assessed and prioritized the key requirements to develop the LIMS online worksheet platform.
• Developed low-fidelity mockups and wireframes with the UI designer and lab analysts using Balsamiq.
• Maintained quality procedures to ensure documentation is in place with Good Documentation Practices (GDP).
• Configured and developed SharePoint UI sites and sub-sites for PPD Quality Assurance and CGMP Laboratory.
• Validation of Lab Ware Laboratory Information Management System (LIMS) to be used by Quality Management group to store project-related regulatory and non-regulatory documents in a controlled manner.
• Designed, implemented and validated 21 CFR Part 11 compliance strategies for Lab Ware LIMS.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams, used SQL queries to filter data and produced data mapping and data definition documentation.
• Created and maintained business rules in Performance point server for data cubes to enhance data cube security.
• Assisted to develop the test plan, test cases and test scenarios for testing based on business requirements, technical specifications, and product knowledge and performed user acceptance testing (UAT).

Environment: Scrum-Agile Environment, JIRA, Confluence, Cleo, Informatica PowerCenter, Tableau, MS Office.