SUMMARY

• Over 7 years of diversified experience as a Business Analyst in domains like Banking, Healthcare and Insurance.
• Extensive experience in implementing all phases of Software Development Life Cycle (SDLC) and methodologies like Agile SCRUM, Rational Unified Process (RUP) and Waterfall Method.
• Expertise in translating user requirements into technical specifications and mapping the process design, work flows for SDLC and Agile with documenting and managing business requirements..
• Conducted JAD (Joint Application Development) and RAD (Rapid Application Development) regularly.
• Expertise in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specifications (SRS), System Design Specification (SDS).
• Efficiently conducted GAP analysis and Feasibility Analysis to check the performance and compatibility of the existing system with the desired system.
• Created UML diagrams (Use case, Activity and Sequence diagrams) using MS Visio & Rational Rose; experience in OOAD (Object Oriented Analysis & Design) &APM (Agile Project Management).
• Highly experienced in using Data profiling techniques and SQL queries and Database Systems.
• Created and provided Reports using SQL Server Reporting Services (SSRS).
• Used knowledge on ETL tools to load data to Teradata by making various connections to load and extract data from sources systems like Mainframe legacy systems, Oracle systems, Flat files and XML files.
• Used rational tools for creating version control, defect reporting & tracking in all areas of SDLC.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Implemented QA methodologies and developed Test Plans, Test Cases, Test Script and Test Scenario to meet product’s business requirements and participated in conducted User Acceptance Testing (UAT).
• Requirements gathering, Analysis experience in SOA architecture - Data and messaging services, Enterprise services - Datapower/Mule application of Leading PBM Company. Short-term experience as Quality assurance analyst in the same application.
• Excellent knowledge of HIPAA X12 EDItransaction codes such as 270/271 (Inquiry/Response Healthcare Benefits), 276/277 (Claim status), 834 (Benefit enrollment) 837.
• Knowledge of ICD-9-CM and ICD -10-CM coding and claims processing; Managing Test Director for the test team, SQL, Oracle EBS R12, Supply chain analysis.

TECHNICAL SKILLS

OOAD and Design: Rational Rose, UML diagrams, MS Visio, RSA7 (Rational Software Architect)

Reporting Tools: Rational ClearQuest, Crystal Reports, Cognos, SSRS

Testing Tools: QTP 8.0, Rational Functional Tester, Rational RequisitePro, Quality Center, LoadRunner, WinRunner, ClearQuest.

Packages: Rational Rose, Requisite Pro, ClearQuest, I log J-Rules

Version Control: PVCS, SVN, CVS, Clear Case

Office Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, Lotus Notes, Microsoft SharePoint, and MS Project.

PROFESSIONAL EXPERIENCE

Confidential - Louisville, KY

Business Analyst

Responsibilities:

• Gathered end user requirements and suggested the improvised business process model by applying RUP Methodology and also conducted JAD Sessions with the SME’s.
• Conducted Gap Analysis of current and desired client requirements, generated workflow process, flow charts and relevant artifacts.
• Created and provided Reports using SQL Server Reporting Services (SSRS).
• Managed integration process using CMMI and divided the phases of project while applying CMMI.
• Participated in weekly status meetings to in corporate any deflections from the original scope to estimate best/worst case scenarios and track progress.
• Assisted inClinical Data ManagementandClinical Trials Management.
• Maintained test metrics, reports, and schedules as necessary using MS Project and participated in the design walkthroughs and meetings.
• Studied the “As is” and “To be” analysis to show the current and proposed functionalities of the system and also created baseline test scenarios.
• Experience inAnalytical CRMfor health care customers and their custom data management.
• Worked heavily onClinical Trials using IVRto conduct global clinical trials and manage the large volumes of data generated.
• Conducted UAT and reported Bugs to Developers.
• Functioned with Business Owners ofIDX, the claims adjudication system,and documented updates and enhancements to the application.
• Captured allHIPAA-relatedEDI datain the repository usingFACETS.
• Accepted inbound transactions from multiple sources usingFACETS.
• Created Timeline diagram (Project level timeline vs. Team Timeline).
• Worked in theARISgImplementation of the EHR-Pharmacy Module.
• Used Clinical Connect to provide connectivity and transfer of information from the legacy Clinical Data management system toARISg.
• Created Master plan document, Prepared Test Plans and guideline for QA Team.
• Created Data validation status report involving for multiple projects.
• Exposure toHIPAA Compliancerequirements andHL 7 standards.PerformedContent ManagementusingDocumentum.
• Wrote Use cases by using requisite pro and sometimes by using MS Word, for simple Use Cases.
• Placed Bug reports through Rational Clear Quest to the developers.
• Defect Tracking and Bug Reporting was performed using Test Director.

Environment: MS Project, RUP, Rational ROSE, Rational Suite (RequisitePro, ClearQuest, Clearcase), UML, MS Visio, Requisite Pro, SQL, Windows 2000, IIS Web Server, Oracle, UNIX.

Confidential, Cleveland, Ohio

Sr. Business Analyst

Responsibilities:

• Experience in Agile/Scrum environment as Product Lead on multiple projects.
• Created Functional Specification Document (FRD) and Supplementary Specification (non-functional) Document.
• Gathered Business Requirements and created Business Requirement Documents (BRD) to analyze data/workflows.
• Conducted interviews with business users to gather requirements and designed Work flow diagrams (Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams) using MS Visio.
• Working with different IT &Businessgroups to understand and determine the Impacts to theDataWarehouseand/orDataMarts for different projects.
• Conducted JAD sessions to involve Users and Stakeholders in resolving problems at early stage.
• Used complex SQL, Indexes, Joins and Stored Procedures.
• Conducted GAP analysis to improve and meet the desired requirements; also applied AS IS and TO BE analysis.
• Conducted Sprint planning Meeting on a timely basis.
• Have a good knowledge of Oracle platforms and development environments.
• Worked with developers to make sure that they understood the Use Cases.
• Worked with Subject Matter Experts (SME’s)to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system.
• Engaged with product owners to groom user stories, acceptance criteria, sprint backlog, use case, use case models and acceptance testing.
• Implemented SQL queries for QA testing and Report / Data Validation.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Created test conditions and test scripts for Operational Data Stores and related ETL processes.
• Performed data validation on data mappings in Basel II and Financial Data Warehouses.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT).
• Identified risks and compliance policies of the firm.
• Translated customer/client needs into new features and new services.
• Functioned with Quality Control Teams to develop Test Plan and Test Cases.

Environment: Microsoft Office Suite, MS Visio, Windows XP, Dreamweaver, SQL, PL/SQL, XML, VB, ASP, Crystal Reports, Cognos, Adobe Photoshop, Mercury Test Director, Oracle.

Confidential, Charlotte, North Carolina

Business Analyst

Responsibilities:

• Used Agile Scrum methodology during the Guidewire implementation as the SDLC.
• Created Business Requirement Document (BRD), Functional Requirement Document (FRD) by collecting the User Requirements and Business Requirements.
• Planned and defined system requirements to Wire Frame with Use Case and Use Case Scenario and using the UML (Unified Modeling Language) methodologies with MS Visio.
• Managed the SharePoint site for documentation and tracking project updates.
• Conducted AS-IS and TO-BE analysis to compare and develop the current requirements with the desired product of the end user; and conducted business process analysis using GAP analysis.
• Interacted with business heads to finalize the Business Requirements for the application. Wrote complex SQL statements (JOINS, Stored Procedures) to extract data from the Tables.
• Facilitated Joint Application Development (JAD) sessions to regulate communication among the stakeholders and the project team.
• Worked with Subject Matter Expert (SME) to check the mappings; Assisted in creating requirement document for ETL - Data Extraction, Data Analysis and Data uploading process.
• Implemented a very effective tracking system using Requirement Traceability Matrix (RTM) to maintain stakeholder requests for enhancements during the project life cycle.
• Created the financial models for a new IT Cost Reduction Project including pricing model, cost model, personnel/ resource management, infrastructure volume.
• Created test cases and worked with the QA and UAT team for QA Validation and UAT (User Acceptance Testing).
• Worked as a Project Coordinator during the application/server migration to send communication bulletins to all stakeholders including the clients and third party vendors.
• Aided with the creation of Service Level Agreement (SLA) and Statement of Work (SOW).
• Implemented HIPAA standards, Electronic Data Interchange (EDI) using new HIPAA 5, 837, 270, 271), transaction syntaxes such as ANSI X12, ICD-9, ICD-10 coding and HL-7.
• Worked on Member Management, Eligibility, Claims, and Provider modules within FACETS.
• Prepared test cases and test plans according to the test strategies defined in the project guidelines and modified business processes to manage and reduce risk using Risk Management Process.
• Maintained the knowledge transfer of EDI format used in electronic documentation to vendors as per the requirements.

Environment: MS Office, Quality Center, SQL Server 2014, Facets 4.21, MS Project, Server, MS Visio, Unix, XML, Mainframes and Rational ClearQuest, ClearCase.

Confidential, Rochester, NY

Sr. Business Analyst

Responsibilities:

• Experience with Agile /Scrum and Waterfall Methodologies.
• Created business and functional use cases, project plans and managed the project scope.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and MS Visio and managed using RUP.
• Delivered presentations on Project Status to Stakeholders, Users along with the Technical team.
• Executed data analysis, data mapping, data modeling, Entity Relationship Diagram and strong understanding of Relational Database Management System (RDBMS).
• Responsible for syncing requirements from ReqProto Quality Center using sync tool.
• Created reports using Crystal Reports to perform data analysis.
• Conducted weekly meetings with the development and testing team to update on the changes in requirements and testing.
• Wrote Use cases and Activity Diagrams and analyzed results using Test Director.
• Responsible for risk assessment, identifying, logging and tracking bugs within Defect Management Database.
• Studied trading partner specifications and created EDI mapping guidelines.
• Associated with the SME’s and Marketing Team for Requirements gathering in definition stage.
• Worked with the system architects to convey the business needs to technical team in association with RUP mentors to meet the standard RUP practices of the institution.
• Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.
• Worked with the Testing team for User Acceptance Testing and participated in data analysis for verification purposes.

Environment: DB2, SQL Server, OLTP, OLAP, XML, Web Services, Ms Visio, SharePoint, Siebel, TOAD, QTP, Quality Center, NASCO, NMS, E1 (Evaluation 1), CDH, HRA, HSA, FSA, ESI (Express scripts).

Confidential

Business Analyst

Responsibilities:

• Developed project document templates on SDLC methodology.
• Conducted comprehensive business analysis by working with the client IT staff, supervisors, and end-users, in order to identify operational requirements.
• Worked with the clients in defining the high-level functional requirements.
• Developed Process Model and Business Policies and modified the business requirement document.
• Created SQL queries to create reports using SSRS automation.
• Designed workflows and allocated permissions within SharePoint.
• Evaluated data from sources and generated logical database designs using ERWIN data modeling tool.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Worked with the stakeholders management with the cross functional management.
• Analyzed, Revised and Created Test Plans according to business requirements and guidelines.
• Designed and executed User Acceptance Test script files for new authentication and Security Updates Request enhancements.
• Documented the Requirement Traceability Matrix for tracing the Test Cases and requirements.

Environment: IBM Rational RequisitePro, Rose, Clear Quest, Clear Case, MS Visio, Microsoft Project, Oracle, Quality Center, Windows NT, Lotus Notes, Crystal Reports.