SUMMARY:

• Experienced and versatile Business/Quality Analyst with 8+ years of extensive experience as a Business/Quality and Data Analyst, in different domains.
• Comfortable working with multiple Software Development Methodologies (SDLC): Waterfall, AGILE, SCRUM and RUP
• Comfortable working in all phases of project supporting requirement gathering, preparing and reviewing deliverables such as Business Requirement Document (BRD), Functional Specification Document (FSD), Test strategies, Test plans, System Requirements document and Data Requirement document.
• Well versed in creating Test Scenarios, Test Cases, detailed Test Scripts and testing Road Map.
• Experience in Data Driven Testing, Backend Testing, White Box Testing, Functionality Testing, Regression Testing, Black - Box Testing, System Integration and User Acceptance Testing (UAT).
• Power user of multiple Requirement and Test management tools: HP ALM, Quality Center (QC)
• Excellent documenting and versioning skills using MS Office Suite, MS Visio, Snagit, Outlook, MS SharePoint and EDRMS
• Strong Database experience to support backend testing; Capable of creating complex SQL queries for data validation.
• Very good working knowledge with Relational Database Management Systems (RDBMS), SQL server, Oracle and DB2
• Modeling the Current Business Process (As-Is) and the Future Business Processes (To-Be), identifying gaps via Gap analysis.
• Utilizing Unified Modeling Language (UML) methodology to prepare Use-Case Models, Flow Charts, Activity Diagrams, Data Flow Diagrams and ER diagrams using Rational Rose / MS-Visio.
• Has performed business requirements gathering, conceptual data model, logical data modeling, Entity-Relation diagrams, system requirement analysis, solution architecture, process modeling, workflow analysis, fit-gap analysis, data-flow analysis, data mapping, and structured data modeling, etc.
• Well experienced in Mainframe application design, development, testing implementing using COBOL, DB2 and testing IMS based applications.
• Experience in test environment setup and test infrastructure development in both manual and automation
• Expertise in analyzing the results and reporting defects providing suggestions and recommendations.
• Good exposure on Bug life cycle, organized defect triage meetings, provided suggestions and work arounds, followed up on resolution ETA.
• Experienced with Scrum ceremonies such as Backlog Grooming, Daily Standup, Sprint burndown and Retrospective.
• Expert in providing boundary conditions to User story and creating test scripts.
• Excellent team player who can communicate with all levels of management.

TECHNICAL SKILLS:

Modeling/Version Tools:: Rational Rose, Visual Paradigm, Microsoft Visio, MS Share Point 2014, Rational DOORS, Team Foundation Server

Database/Data Analysis: MS SQL Server 2010,12,14,17, Oracle 10G, DB2, SQL Developer, Informatica Power Center, Tableau, Crystal Reports (7.0, 8.0 & 8.5)

Microsoft Tools: MS Office Suite, MS Visio

Operating system: UNIX, Linux and Windows 7,10

Web Technologies:: SOAP UI, XML, HTML

Methodology: Waterfall, Scrum Framework and RUP

Testing Tools:: Bugzilla, HP ALM 11.5, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. Business Analyst

Responsibilities:

• Responsible for collaborating with the EOE/EEC Organization, Business SMEs and stakeholders, Project Managers, Quality Assurance, and Developers in the process of creating and documenting business and data requirements and materials.
• Performed Data and Statistical Analysis for gathering requirements
• Developed several reports in Crystal Reports for the users and management for effective decision making.
• Tested, raised and managed defects through Team foundation server
• Gathered requirements for Contract/Vendor Management and their reports along with data analysis
• Collaborated with the business to understand strategic goals and objectives, define requirements, assess product fit to business needs, and re-engineer business processes as needed.
• Collaborated with the technical team to understand the data design of the application and apply that knowledge to define data requirements related to the new functional requirements.
• Conducted all interviews and meetings needed to document current business process.
• Assisted in the development of and approval of the business process documentation.
• Helped team members elaborate their requirements; analyze gaps, permutations, inconsistencies, constraints, assumptions, and risks so that requirements are clear, concise, etc.
• Advised QA of test coverage needs for each release's functional requirements.
• Reviewed test cases, expected results, and actual results to ensure that the spirit and intent of all functional requirements are being met.
• Developed materials geared toward end users.
• Data analyzed through Microsoft SQL server for defining reports requirements
• Facilitated and attended daily scrum meeting.
• Documented business process, use cases, Class diagrams using MS Visio

Confidential, Salt Lake City, Utah

Sr. Business Analyst

Responsibilities:

• Responsible for supporting the systems definition process in developing applications by ensuring that the requirements were accurately reflecting the business processes and understood during the design and development of the application.
• Extensively used Rational tool to document requirement and change requests
• Provided expert knowledge of the system requirements definition (RD) processes and modeling methods and tools
• Assign defects to developers via HP ALM.
• Altered normal procedures to eliminate lateral roadblocks to get a job done and/or meet a customer request.
• Interfaced with senior management to provide and obtain information and to build consensus regarding project direction.
• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders
• Worked with business representatives and applied business expertise to ensure quality and accuracy in articulating the business needs into technical application requirements
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using MS Visio
• Performed Data mapping and created case diagrams
• Identified and documented improving areas to meet federal regulatory requirements
• Setup and customized COTS integrated business information systems for clients in various industries
• Organizing JAD sessions, personal interviews and surveys in the process of collecting requirements including that of Ally’s and other higher management

Confidential, Raleigh, NC

Sr. Business Analyst/QA

Responsibilities:

• Involved in various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
• Worked with lead Systems Architect in developing customized application extensions with via C and JavaScript.
• Security testing of both application and infrastructure for multiple web-based applications
• Identified/defined business security requirements for application
• Defect process flow defined and maintained in Bugzilla.
• Created Use-Cases, Wireframes and State Diagrams to demonstrate software architecture and interaction of system components before prototyping. Used Rational Rose, Requisite-Pro for requirement traceability.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Developed project plans and managed scope using MS Project.
• Impact analysis: Assess the of impact of change on current process; Develop and execute the and documentation of process improvement initiatives
• Creating user stories and maintaining and tracking them using JIRA.
• Validated multiple web services used by the client, both REST and SOAP.
• Collaborate with leaders and their organization to inspire a continuous improvement culture by deploying process improvement/operational excellence toolkits and methods across the enterprise
• Created Use Cases, Process maps, Workflow diagrams in Blueprint.
• Worked as a Business Analyst as well as an Assistant Project Manager to guide the team through the conversion process employing SDLC models, Agile Model and UML
• Participated in SCRUM meetings and worked closely with the Subject Matter Expert and the Project Manager.
• Authored Requirements document, Use Case Specifications, Systems Requirement Specification (SRS), Requirement Change Request, Data Dictionary along with the technical staff and developers.
• Initiated GAP analysis by analyzing as-is and to-be conditions for the project at the beginning of the conversion process.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Facilitating JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing requirements
• Created and maintained the process documents for the project to be used for collaboration with developers, project manager, etc. on SharePoint.
• Created and maintained data mapping documents.
• Created Business process flow charts using Visio. Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic. Involved with optimization of MS-SQL queries.
• Organized project tasks, managed team workflow and project scheduling using Team Foundation Server.

Confidential, San Francisco, CA

Sr. Business System Analyst

Responsibilities:

• Participated in gathering User Requirements, developed functional specs and configuration summary documents
• Used JIRA tool to story point each story and prioritize story backlog based on Business Goals and objectives during the Sprint Workshop
• Migration of applications designed using Sun Identity Management to Oracle Identity Management.
• Documented the AS-IS and TO-BE processes and conducted GAP Analysis to identify key areas of concern and addressed them with the Business team.
• Completed thirty-day onsite Oracle Identity Management while simultaneously analyzed the requirements to be migrated.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Experience in application analysis, application design and system integration.
• Prepared weekly project metrics, including tracking spreadsheets, online databases and preparation of high-level PowerPoint presentations for use by project manager and various project leads
• Revitalized requirement elicitation techniques - conducting user interviews and JAD sessions and managed the requirements using Rational Requisite Pro and Use Case Modeling with all phases of SDLC.
• Responsible for interacting with client for requirements gathering, analyzing requirements, and creating detailed specifications.
• Participated in functional design sessions, creates and executes SQL test scripts, and aids in the solution of data issues.
• Validated the test data in DB2 database on Mainframes using SQL queries.
• Involved in testing the Member Enrollment, Eligibility Enquiry, Eligibility Response, Claim Status Enquiry, Claim Status Response and conversion of Financial Claims.
• Helped the QA team in writing the Test Plan, UAT testing and conducting the quality assurance phase.
• Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) sessions, and lead the effort to get Business and System requirements baseline (stakeholder approval)

Confidential

Business Analyst

Responsibilities:

• Functioned as the primary liaison between the business, operations, and the technical teams throughout the project cycle.
• Involved in impact analysis of HIPAA 7 999 transaction sets on different systems.
• Worked with FACETS edits and EDI HIPAA Claims (837/835/834/997/999 ) processing.
• Assisted the EDI team in the development and documentation of the test strategies for the EDI transactions which included all standard transactions, auditing and error correction processes, and the creation of the transactions.
• Worked on several reporting tools like Crystal Reports, Cognos to help the company build a strong reporting process for effective management decisions.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277, 837/835,997,999 transactions.
• Coordinated with the EDI team in developing and documenting the detailed testing work plans and created the various testing documents for the assigned EDI transactions.
• Performed project management skills, which include planning, development, management of project plans, budget management, and maintenance activities.
• Worked with agile methodology for the modification of the enrolment system
• Organized several JAD meetings, one on one meetings, storyboarding meetings, and process workshops to gather business and system requirements from SMEs in different departments involved in the enrolment system like the Medical underwriting department, the claim approval department and the accounting department.
• Created and tracked burn up and burn down charts for sprint release estimations.
• Used Microsoft Visio to create some UML diagrams like Activity diagram, Data flow diagram, use case diagram, and process flowchart to depict the 'As-is' process and 'To-be' process for gap analysis and impact analysis.
• Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI.
• In depth knowledge of Medicare/Medicaid Claims processes from Admin/Provider/Payer side which were later part of the program to vendors.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Narratives, Use Case Scenarios, and Use Case Diagrams using the UML modeling methodologies.
• Support requirements triage in MQC to select release specific requirements identify relationships and dependencies between requirements, estimate technical effort and perform Impact Analysis
• Trained other business analyst with respect with claims process workflow.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.
• Analyzed database tables for common key information (SQL joins) to generate full reports
• Used complex Excel formulas and pivot tables to manipulate large datasets.
• Lead Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Performed User Acceptance Testing (UAT), Integration testing, Product testing.