SUMMARY

• Sr. Business Systems Analyst with 7 years of experience in analyzing and gathering requirements for business processes in techno - functional roles across various domains. Proven Ability to understand the big picture while being detail oriented and highly motivated. Excellent analytical, communicational, organizational, problem-solving and interpersonal skills with experience in conflict and change management.
• Extensive working knowledge of various phases in the Software Development Life Cycle (SDLC) processes. Hands on experience in traditional and agile methodologies such as Scrum, Waterfall, Scaled agile framework (SAFE 4.0), water-scrum-fall and Kanban.
• Experienced in different areas of Telecommunication domain including Order and Billing Support Systems (OSS/BSS), Mobile Virtual Network Operator (MVNO), billing, line activation and provisioning.
• Experienced in different areas of Healthcare domain including Health Insurance, HIPAA compliance and regulations, Claims processing and adjudication, Electronic Health Records (EHR) and clinical data warehousing (CDW).
• Experienced in HIPAA 4010-5010 and ICD 9 CM- ICD 10 CM/PCS conversion project. Well acquainted with various CPT, HCPC codes and ANSI X12 Electronic Document Interchange (EDI) formats like 270/271, 276/277, 278, 835, 834, 820, 837 and 999. Thorough understanding of claims testing processes and compliance testing.
• Adept at understanding and analyzing current and proposed system architecture, possible Front End and Backend impacts and documenting API contracts to accommodate the changes.
• Highly proficient in eliciting, analyzing and documenting SMART (Specific, Measurable, Achievable, Relevant and Testable) business requirements using various requirements elicitation techniques like JAD session, brainstorming, user story workshop, requirements workshop, interviewing, focus groups, document analysis and prototyping.
• Skilled in conducting Feasibility analysis, Risk analysis and Impact analysis to understand business and technical risks, evaluate infrastructural requirements and determine business benefits.
• Extensive knowledge in Gap analysis and Documenting As-is and to-be situation. Skilled in Benchmarking, SWOT analysis, root-cause analysis (Fishbone diagram), cost-benefit analysis and 5why’s analysis.
• Skilled in facilitating meetings and elicitation sessions with different stakeholders and documenting Business Requirements Document (BRD), Functional Requirements Document (FRD) and Systems Requirement Document (SRD) to understand and communicate various GUI, functional, non-functional, configurational and data requirements.
• Actively assisted the Project Manager in creating Project charter, Project plans, Gantt charts, milestones and Work breakdown structures (WBS) and defining the product roadmap.
• Adept at Business process modeling using BPMN 2.0 and Workflow diagrams and various UML diagrams like activity, use case, sequence and class diagrams using MS Visio, Google Drawings and Lucid chart.
• Good knowledge of various visualization techniques like prototypes, wireframes, mockups, feature trees, mind mappings, decision matrix using tools like Zeplin, Balsamiq and Axure RP.
• Well versed in all Scrum ceremonies like Sprint planning, Daily Scrum, Sprint review and retrospect meeting. Experience in leading user story grooming and pre grooming sessions for multiple Front End and Backend teams. Well familiar with story estimation techniques (Planning Poker, T-shirt sizing and bucket sizing) and Story prioritization techniques (MoSCoW and Kano model).
• Experience in supporting the Product Owner to define the Minimum Viable Product (MVP), Definition of Done (DOD). Proficient in grooming and refining Product Backlog items and accommodating any stakeholder change requests.
• Proven expertise in conceptual and logical data modeling, data integration, migration and data conversion. Knowledge of Source data identification and data profiling.
• Through understanding of data warehouse architecture and implementation techniques and various database modeling techniques like Entity relationship diagrams (ERD) and dimensional modeling and Database schemas (Star schema and snowflake schema).
• Created Data mapping documents and Source to target mapping documents (STM)/ Source Data Mapping (SDM). Involved in identification of metadata and defining the Data Dictionary.
• Meticulously worked on defining OLAP cubes, dimensions and performed various drill down, roll up, slicing, dicing and pivot operations. Utilized Informatica PowerCenter to transform and integrated data from different sources.
• Strong knowledge of SQL queries like DCL, DML and DDL queries which includes inner and outer joins, select statements, order by, group by and various other aggregate functions and views.
• Working knowledge of visualization and reporting tools like Tableau and Power BI to drive operational intelligence.
• Extensive knowledge of REST API request and response testing, Functional testing, Unit and integration testing, Load and performance testing, Black box testing, User acceptance testing, smoke testing, sanity and regression testing. Assisted the QA in preparing test plans and test cases, actively involved in defining User acceptance criteria and conducting user acceptance tests (UAT) using HP ALM and integrating with LoadRunner, UFT and HP ALM Sprinter. Responsible for updating and maintaining the requirements traceability matrix (RTM).
• Strong understanding of XML, HTML, JSON, loosely coupled Web Services (REST, SOAP, WSDL) and various system architectures like Service Oriented Architecture (SOA), 3-tier architecture and Microservices.
• Documented RESTful and SOAP APIs (I was responsible for technical writing for both API response and requests in XML and JSON) using Swagger. Responsible for conducting API testing using Postman and SOAP UI.
• Exposure to various big data tools (Splunk enterprise) and cloud migration techniques (AWS Cloud migration).

TECHNICAL SKILLS

Project Management/ ALM: Atlassian JIRA, Microsoft Project, HP ALM, Team Foundation Server

Communication and Collaboration: Atlassian Confluence, Microsoft SharePoint

Modeling and mockup Tool: MS Visio, Lucid Chart, Google Drawing, Balsamiq, Axure RPWeb Sequence Diagram

Reporting tool: Tableau, MS Power BI, MS Excel

API testing and documentation: Swagger, SOAP UI (Ready API), Postman

Testing and Test management tools: HP Quality Center, HP LoadRunner, HP UFT, Sprinter, Selenium

Languages: C, C#, SQL, XML, JSON, HTML, Java, JavaScript

Databases: MySQL DB Server, DB2, Oracle DB, Oracle 11g, Cassandra DB

ETL and ETL testing: Informatica PowerCenter, Talend, Informatica Data Validation Option (DVO)

Technologies: Splunk enterprise, Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Technical Business Analyst

Responsibilities:

• Conducted brainstorming sessions, Architecture Repository review meetings and analyzed system Interface Design Documents (IDDs) to document As-is and To-be process flows and address the process gaps.
• Elicited stakeholder requirements from one on one interviews with POs and Business Owners. Assisted the PO with defining the MVP, Reasons to Believe, possible phases for launch, development iterations and maintaining Product requirement artifact in confluence.
• Collaborated with the system architects and external application vendors to define the current and proposed 3 tier system architecture, understand and plan for infrastructural impacts and validate functional and non-functional requirements .
• Contributed to the creation of System Design Document in Confluence by incorporating the Solution impact matrix along with the respective impacted Front End or Backend teams, system implementation details, proposed API changes, other system impact due to those changes and API field mappings.
• Worked with the Credit and Fraud management team to define the business rules, propose a refined credit decision logic, credit score to down payment matrix and maximum number of allowed lines for a customer.
• Utilized MS Visio and Web sequence diagrams tools to create Sequence diagrams that explains the current and proposed interaction between various Front End and Backend systems through REST APIs.
• Worked with the UI team to create Front End screens using Zeplin and made sure that they are aligned with product requirements. Organized UI review meetings with Developers to understand the API impacts and create API requirements for the changes in the screens and incorporated those details in JIRA tickets.
• As a Feature BA, created multiple Front End and Backend epics and stories in JIRA using the INVEST format with clear User Acceptance Criteria, API endpoint detail, proposed JSON payload and implementation details.
• Maintained User story maps and Requirements traceability matrix to promote organization wide visibility.
• Led User Story Grooming sessions and Pre-Grooming sessions to discuss the requirements and proposed solutions with the Development teams, estimate the effort and discuss possible technical questions.
• Held JAD sessions between Dev leads, Lead Architects and developers to discuss API contracts while following RESTful API standards and best practices. Assisted our Lead Architect in maintaining the API contracts in Swagger.
• Tested API request and responses using the G4 Cloud Foundry Application and POSTMAN to make sure a third-party solution is working as intended and QAs can test the user stories once development is complete.
• Actively contributed towards building a resiliency plan to reduce the dependency on XM’s OSS/BSS vendor AMDOCS. Identified existing data fields in various domain models and fields that are missing. Devised a mitigation approach for the missing data points.
• Identified and defined the reporting requirements for a feature and created data mapping document to address the requirement. Utilized JIRA to create Backend reporting user stories.
• Worked with the End to End testing team to identify the functional and technical requirements for customer facing trials for multiple features. Created user stories for trials in JIRA with technical details.
• Troubleshooted system integration issues with Developers and Testers. Created bugs and user stories to address the requirement gaps.

Environment: MS Visio, Zeplin, SharePoint, Swagger, Postman, JIRA, Confluence, MS Word, MS Excel, Cloud Foundry, Splunk, Web sequence Diagram, Agile Scrum, XML, JSON, Web services, RESTful API, microservices, SQL, Cassandra, BPMN 2.0, AMDOCS CRM, Slack, Microsoft Teams

Confidential, Bronx, NY

Sr. Business Systems Analyst

Responsibilities:

• Performed document analysis, conducted interviews with SME’s, business owners and referred to previous project artifacts to analyze the As-is system and To-be system. Created current process workflow using BPMN 2.0.
• Conducted feasibility analysis by defining the legacy system and creating feasibility matrix. Assisted in Initial risk assessment and developing a risk mitigation plan.
• Conducted brainstorming sessions to analyze the existing situation and discuss possible solutions.
• Gathered stakeholder requirements by conducting User story workshop. Worked with the PO to document the user stories in INVEST format and defined a clear user acceptance criterion for each of them.
• Worked with the facets team to analyze the HIPAA compliant X12 837 transaction sets and performed claims validation and adjudication as a part of As-is analysis. Wrote DML SQL queries to extract and analyze FACET data.
• Created use case diagram, activity diagram, sequence diagram and other UML diagrams in MS Visio to understand the target system and system workflow. Assisted the systems architect in breaking down the target system architecture.
• Assisted the PO and the team in prioritizing and estimating user stories and extensively used JIRA incident management tool to maintain and manage product backlog and sprint backlogs.
• Used Atlassian Confluence to write and maintain various artifacts like meeting minutes and UML diagrams.
• Actively helped the PO in creating POC s and accommodating any change request from the users and refining and re-prioritizing the backlog in backlog grooming meeting.
• Created wireframes and mockups using Balsamiq to provide better visualization and obtain stakeholder approval.
• Participated in various scrum ceremonies like initial backlog grooming, sprint zero, sprint planning, daily scrum, sprint retrospective, sprint review and backlog grooming meetings throughout the project.
• Assisted the team in analyzing and routing the existing claim submission portal, EDI Converter, web server, application server MQ, facet performance monitor data into Splunk.
• Extensively used Splunk enterprise and created MQ status reports, real-time system monitoring dashboards, claim submission portal reports and other mandatory HIPAA regulatory compliance reports to help the business gain an end to end system visibility. Documented all the key performance indicators (KPI) like Mean time to repair and First pass qualification rate to report and track the team progress.
• Worked on implementing distributed (scaled) version of Splunk to meet large scale requirements of the insurer.
• Assisted in Smoke testing to check for critical functionalities. Used HP ALM for test plans, test cases, execution and bug tracking. Assisted the team with User Acceptance Testing (UAT) to make sure that system meets stakeholder needs.
• Involved in JSON and XML Technical documentation for documenting REST API response and request formats. Involved in Splunk REST API testing in Postman. Assisted in creation of end user documentation with end user manual.
• Explored and integrated various Apps and add-ons like Splunk DB connect, Splunk enterprise security (SIEM solution) and Splunk for IIS to facilitate the machine data indexing process.
• Involved in Production support, user training and problem resolution after completion of Splunk integration.

Environment: Agile (Scrum), JIRA, BPMN 2.0, Confluence, Oracle 11g, MS Visio, Balsamiq, Postman 5.1, HP ALM 11.5, HP LoadRunner 12.5, XML, JSON, SQL, REST API, Splunk enterprise 7.2, Splunk DB connect, Splunk enterprise security, Splunk for IIS, Splunk for WebSphere, MS Excel, MS Word.

Confidential, Denver, CO

Business Systems Analyst

Responsibilities:

• Elicited requirements from stakeholders by conducting JAD sessions, User story workshops and Interviews.
• Actively involved in documenting user stories and assisting PO in estimating and prioritizing stories.
• Analyzed disparate source systems data like claims, billing, inpatient, outpatient data, Electronic Health Records (EHR) (from EPIC EHR system) and lab reports. Performed gap analysis to consolidate data from multiple sources to fill the target data models.
• Developed logical and conceptual data models. Created data dictionaries and defined metadata fields.
• Assisted the Systems architect to create dimensional models, fact tables, dimensions and defined technical requirements for project implementation. Adopted a just enough Data warehouse architecture approach.
• Involved in creation of data marts like Operational data mart, Diagnosis data mart to meet different business needs.
• Utilized Informatica PowerCenter for Extraction, Transformation and Loading process (ETL) to extract and manipulate the source data. Assisted in defining Worklets, Mapplets and Workflows to execute the ETL process.
• Documented the conformed dimension grid to define conformed dimensions and dimensional dependencies.
• Helped with data normalization up to 3NF for elimination of data redundancy and faster query processing.
• Participated in all Scrum events and gathered stakeholder feedbacks and change requests. Used JIRA to manage stories, tasks and change requests. Utilized SharePoint to store all project related artifacts and meeting minutes.
• Assisted in defining OLAP cube dimensions and performing various roll up and drill down OLAP operations.
• Actively involved in creating ETL Mapping Sheets to define source to target mapping (STM).
• Worked closely with QA and the development team to create test cases, test plans for ETL testing. Documented User acceptance tests (UAT) and collected test data from business users for User Acceptance Testing (UAT).
• Extensively used inner and outer joins, select statement and aggregate functions in SQL for source data extraction and target data validation. Created different views to assist front end users in monitoring the Data warehouse.
• Designed and developed various reports and dashboards like Pie chart of ER visits by gender, Bar chart of Readmission by diagnosis and gender to drive Business intelligence and analytics using Tableau.
• Assisted the development team in documenting and testing API request and response formats using POSTMAN.
• Engaged in creating user manuals, providing user training and post-production support.

Environment: Agile (SCRUM), JIRA, Informatica PowerCenter 9.6, Data Integration, SQL, Tableau 8.0, POSTMAN 4.3, MS Office tools (Word, Excel, PowerPoint), SharePoint, Informatica Data Validation Option (DVO), MySQL DB server.

Confidential, Dallas, TX

Business Systems Analyst

Responsibilities:

• Conducted JAD sessions, one on one interviews, brainstorming and Story grooming workshops to elicit requirements from stakeholders and documented them in form of user stories.
• Performed feasibility analysis and gap analysis to understand and validate the As-is and To-be situations.
• Assisted the Product owner (PO) in prioritizing and estimating user stories and worked closely with the development team to create user story map and define a clear roadmap for the system.
• Created Use case, activity and sequence diagrams using Google Drawing. Involved in creating prototypes, wireframes and mockups in Axure RP to obtain stakeholder approval in sprint review meetings.
• Worked with the system architect to define the 3-tier system architecture for the application.
• Created and maintained requirement traceability matrix (RTM) to track user requirements against actual system functionalities throughout the system development life cycle (SDLC).
• Utilized Team Foundation Server (TFS) to log user stories and handle change requests.
• Attended all Scrum ceremonies like Sprint planning, daily scrum, review and retrospect meetings to plan for sprint, discuss impediments and suggest any improvement. Handled change requests in backlog grooming/ story grooming meeting and made sure they were accommodated in the product backlog.
• Worked with the development teams to create Source Data Mapping (SDM) and defining the data flow.
• Assisted in defect tracking using HP QC. Assisted in creation and management of test cases.
• Used data Manipulation SQL queries like select and joins to query the source data.
• Defined User Acceptance Criteria and assisted in planning and conducting User Acceptance Tests (UAT).
• Tested various third-party APIs used in the application using SOAP UI. Utilized Swagger for API documentation.
• Extensively utilized Power BI to help the provider gain insights into their operations.

Environment: Agile (Scrum), oracle DB, Rally, SQL, HP QC, Google Drawing, Axure RP, Team Foundation Server, Informatica PowerCenter, Power BI, MS Word, MS Excel, SOAP UI, Swagger.