Sr. Business System Analyst Resume
Durham, NC
SUMMARY:
- Results orientated Sr. Business System Analyst with 8 years of diverse experience in developing business processes and system solutions within the Healthcare, Insurance, Banking and Finance Industries.
- Demonstrated ability to work actively in different phases of Software Development Life Cycle (SDLC) using Agile/ SCRUM, Rational Unified Process (RUP) and Waterfall methodologies.
- Experienced in creating business analysis artifacts such as Impact analysis, Requirement management plan, Business requirement document (BRD), UML diagrams, Functional specification documents (FRD).
- Expanded expertise in writing Use Case Narratives, System/Process/Business Flow Diagrams, and Business Modeling by using tools such as MS Visio.
- Experience in facilitating Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
- Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
- Skilled at performing GAP analysis, SWOT analysis, Cost benefit analysis and Feasibility Analysis
- Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity - Relationship Diagrams (ERD).
- Experience in implementation of Risk Management Information System(RMIS) with Risk connect and Learning Management System(LMS)
- Experience with building reports-SSRS, Crystal Reports, dashboards for analytics - Performance Point Services and collaborative team sites (using Microsoft SharePoint Server 2010).
- Designed and implemented SQL Queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and validation.
- Strong understanding of SQL Server Reporting Service (SSRS) and System Oriented Architecture (SOA), CMM and SOX.
- Highly skilled at creating and executing test scripts and end user training while successfully planning and executing implementations of enterprise directives.
- Well versed in Change Management, Gap Analysis, User Acceptance Testing (UAT), Quality Assurance Testing (QAT), SWOT analysis, Cost Benefit Analysis, ROI analysis to check the compatibility of the existing system infrastructure with new business requirements.
- Extensively worked with the On-site and Offshore Quality Assurance Groups by assisting the QA team for developing Test Plans, Test Cases, and Test Scripts.
- Development of large scale synchronized test plans and defect tracking.
TECHNICAL SKILLS:
Operating Systems: Microsoft Windows 8/7/XP, Unix, Linux (Ubuntu), Windows Server 2003
SDLC Methodologies: Agile/SCRUM, Waterfall, Spiral, RUP Process and Prototyping
Internet Languages/ Web Applications: UML, HTML, CSS, XML, Shell Scripting
Databases and Tools: SQL Server 2005/2008, My SQL, Distributed DB, Oracle 9i/10/11g, MS Access, My SQL, PL/SQL, TOAD, DOORS
Quality Management: IBM Rational Manual Tester, HP Quality Center, QTP, JIRA
Project Management: Microsoft Project Professional
Change Management: Rational Clear Quest 7.1, Requisite Pro v7.1
Languages: C/C++, Java/ J2EE, Python, VB.Net, JavaScript, VB6, PHP, Perl, ASP.NET, C#.NET
Version Control: Rational Clear Case, Rational Rose, Rational Requisite Pro
CRM: Dynamic CRM
Business Intelligence/ Reporting: SQL Server Reporting Services (SSRS), Performance Point Services
Content Management System: Microsoft SharePoint Server
Others: MS Office Suite (Word, Excel, PowerPoint, Visio)
PROFESSIONAL EXPERIENCE:
Confidential, Durham, NC
Sr. Business System Analyst
Responsibilities:
- Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.
- Designed a claim processing system for the healthcare management client system. It allowed the user to inexpensively capture information regarding patient, summary of medical history, symptoms (ICD-9 codes), and treatment (CPT).
- Responsible for gathering the functional requirements for the health benefit claims receiving and processing system.
- Conducted requirement gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD).
- Captured process flows by preparing activity and sequence diagrams, pre- and post-conditions, performance requirements, impacted areas, high-level business rules, issues, areas in scope and out of scope, assumptions, etc.
- Involved in Requirement Scoping and analyzing high priority requirement. Conducted sign-off meetings with IT teams to lock down the requirements.
- Created high-level Use Cases from Business Requirements and created UML diagrams like Use Case and Activity diagrams using MS-Visio.
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
- Tracked stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
- Reviewed Technical Specification Documents (TSD), with development team, resolves issues and provide Sign Off.
- Involved with the following list of HIPPA-EDI Transaction Code sets: 837, 835, 270/271,277/275 and 276/277
- Executed SQL queries to test the database for records that detect and submit functional acknowledgement and remittance advice in the claims application.
- Involved with the Quality Assurance Team to develop and design test plan and test cases.
- Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
- Conducted User Acceptance Testing (UAT) of the application with the QA team.
- Performed testing of the health benefit claims receiving and processing system to ensure that the system adheres to project standards, performance criteria, and functional specifications.
- Extensively used tools like Microsoft Excel, Access, Share point 2013, MS Visio and in-house Optimal Trace tool.
Environment: SQL Server 2014/2012, Agile/SCRUM, MY SQL, PL/SQL, Java, J2EE, UAT, Quality Centre, HP ALM, MS Visio, MS Office, SharePoint, UML, Oracle 11g, SSIS, SSRS, Crystal Reports, MS Project.
Confidential, Charlotte, NC
Sr. Business System Analyst
Responsibilities:
- Involved in the analysis of the functional, technical specifications, data mapping document and conceptual diagrams.
- Wrote system requirements specification (SRS) and functional requirements specification (FRS) and Data Requirement Matrix (DRM) documents as per the business requirements and process flow.
- Documented user stories and modelled use case diagrams by utilizing MS Visio.
- Conducted Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on a Business Requirement.
- Created Use Case Models, Wireframes & Mock-ups,, Analysis Models, Design Models, Use Case Diagrams, Behaviour Diagrams (sequence diagrams, activity diagrams) based on UML methodology
- Wrote process flow and business case documents of existing processes.
- Actively involved in design of wireframes for the different UI’s with UX architects by mitigating the requirement and business validation rules.
- Defined frameworks for the application development and analysed the areas of improvement
- Highly interacted with the development team and claim settlement experts making sure that the development of the project is meeting the business requirements.
- Jointly responsible for monitoring the progress of the system development by preparing status reports.
- Conducted daily interaction with the development team, stake users, business executives and Quality assurance to coordinate all the engineered process.
- Analysed the security implementation of the application with respect to user’s perspective.
- Worked with the data architecture and data analyst team in designing the model and in creation of the data mapping documents.
- Worked on MS CRM Dynamics for handling the customer claim inquiries, Validation and case creation.
- Prepared test data for the functional test cases, manual test planning and creation of the test cases based on the user expectations.
- Evaluated test results and prepared test summary reports. Performance testing analysis was also done by analysis the results from balance and load tests .
Environment: Agile/SCRUM, SQL Server 2012, MY SQL, PL/SQL, Java,J2EE, MS Office, MS Visio, MS CRM Dynamics, UAT, HP Quality Centre, Data Mapping, UI, SSIS, SSRS, Oracle 10g, Performance Testing, MS Project, TFS.
Confidential, Atlanta, GA
Sr. Business System Analyst/ Business Analyst
Responsibilities:
- Created Stakeholder Analysis Matrix to identify key stakeholders, evaluate their interests, power, support level and flexibility.
- Organized and conducted JAD sessions, user interviews and surveys to identify, understand and document the requirements.
- Analysed the requirements using MS Visio and also created BRD and FRD by interacting with the IT personnel and business users.
- Translated Business requirements to functional and technical language with the help of use cases and UML diagrams for developers.
- Developed RTM to find out if the current project requirements are met and ensured its timely update.
- Interviewed SMEs and carefully recorded the requirements in a format that can be reviewed and understood by both business people and technical people.
- Worked with FDA guidelines (21CFR), HIPAA and EDI transactions.
- Involved in coordination of implementation of Risk Management Information System with Riskonnect RMIS for compliance.
- Identify and recommend improvements that are technically sound, feasible and meet IT standards.
- Grouped the Use Cases and other diagrams into sequence and collaboration Diagrams using Rational Rose based on Agile Scrum, UML methods; thereby defining the business process model.
- Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
- Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Created and managed the reports using SSRS.
- Verified and analysed X12 Medical encounter files processed by external client for building business logic of corrected claims by using tools like E-track, Rev Runner and HIPAA Processing to ensure HIPAA compliance.
- Participate in Triage meetings and help testing team to prioritize the requirements and participated in User Acceptance Testing (UAT).
- Involved in preparing a simple and detailed user and technical manual.
- Conducted training sessions and workshops for the application users
Environment: Agile/SCRUM, SQL Server 2010, MY SQL, PL/SQL, Java, J2EE, Java Script, UML, UAT, HP Quality Centre, SSRS, SSIS, Crystal Reports, MS Office, MS Visio, MS Project, TFS.
Confidential, Jupiter, FL
Business System Analyst/ System Analyst
Responsibilities:
- Liaison between stakeholder’s system users, clients and managers, software development team and the QA team to gather requirements.
- Incorporated agile methodology and SCRUM techniques to manage requirements.
- Facilitated (JAD) Joint Application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
- Studied and analyzed competitor’s applications and brainstormed to gather effective requirements for a quality product.
- Strong understanding of Investment banking, Fixed Income, Bonds, Equities, Derivatives (Options and Futures), Fund Accounting, Portfolio Management, Wealth Management.
- Engage in project initiation activities such as developing the Project Charter, Project Scope and assisting the management in resource and budget estimation.
- Created Business Requirements Document and converted them into System Requirement specifications Document.
- Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.
- Analyzed Requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect
- Conducted Database analysis via Microsoft SQL Server to run ad-hoc reports weekly/monthly for upper management using SQL queries to generate excel reports/charts analyzing usage of Online Banking vs. Bill Pay Services users
- Gathered requirements to implement Master Data Management ( MDM )
- Worked with Project Management team (EPMO) in preparing RACI chart, Project Plan, Timelines, Scope Management, Stakeholder update.
- Involved in preparing a simple and detailed User manual for the application, for an intended novice user.
- Proficient in defect management using JIRA.
- Worked with SIT team in development of System Test Cases.
- Created Test Strategy developed UAT Test cases and execution of Test cases
- Created meeting minutes and maintained action items for various WAM project meetings.
- Worked with Project management team for vendor selection process.
- Prepared test plans and executed Unit, Integration, User Acceptance testing using test cases to endure that the systems conformed to specifications of business requirements performance criteria.
Environment: Agile / SCRUM, Windows 8, IE, Oracle 11g, Microsoft SharePoint Server 2010, JIRA, Enterprise Architect, Master Data Management, Microsoft SQL Server 2008, SQL Queries, MS Access, My SQL, SSRS, MS Office Suite (Word, Excel, PowerPoint, Visio)
Confidential, River woods, Illinois
Business System Analyst
Responsibilities:
- Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback
- Communicated Project Requirements, Business issues, Solution and made recommendation
- Responsible for defining scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
- Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines
- Identified KPI aligning with business rules
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other
- Used Rational Requisite - Pro to prepare BRD, use cases, process flow diagrams
- Created Use case models and Process flow diagrams using MS Visio
- Created use case scenarios and documented work flow and business process
- Conducted functional walkthroughs, User Acceptance Testing
- Developed and managed project plans and schedules.
- Managed resolution of project issues and conflicts.
- Managed (UAT) sessions and processes to review user feedback.
- Interviewed, investigated and analyzed the current system.
Environment: RUP, Rational Requisite Pro, Rational Rose, UML, Test Director, UAT, SQL Server 2008, Window 7, MY SQL, MS Office Suite (Word, Excel, PowerPoint, Visio), Microsoft Project Professiona