PROFESSIONAL SUMMARY:

• Innovative and competent business professional with experience and a strong background in Insurance, Healthcare IT, Biotechnology and Bioinformatics. Consistently demonstrated the ability to acquire a diverse range of new skills and techniques, with strengths in analysis, presentation and project implementation. Efficient in product delivery on schedule dates while reducing operating costs. Invasive analytical experience which includes data gathering, data testing, and simplifying data for user friendly approaches.
• About 8 years of experience as a Business Analyst with experience in eliciting, analyzing, and documenting the requirements for business processes and policies in the field of insurance and healthcare.
• Lean Six Sigma White belt, Project Management Essentials(PMEC) and Scrum Master certified.
• Strong knowledge of Software Development Life Cycle SDLC methodologies such as waterfall, Agile(Scrum), Scaled Agile Frame Work(SAFe), Hybrid(Water - Scrum-Fall), Kanban and Rational Unified Process (RUP).
• Experienced in Property and Causality Insurance (Auto, Home, Umbrella, Commercial lines, Personal and Business, Health), Health Care domains with 3 years of experience in Property and Causality and 5 years of experience in healthcare domains.
• Experience on Guidewire software suite (Policy center, Billing center and Claims Center).
• Knowledge of Guidewire integration framework and various integration methods (Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.)
• Solid Experience in Business Requirement Management (Elicitation, Validation, Specification, Verification), Gap Analysis, Feasibility study, Business Process Modeling, Process Management and Change Management.
• Experienced in Conducting JAD sessions and Interviews and gathering requirements, creating project status reports and presentations. Experienced in preparing Business Requirements Document (BRD) & Functional Requirements Documents (FRD) and System Requirements Specifications(SRS) from gathered requirements.
• Experienced in drafting Work Flow Diagrams, Data flow diagrams, Sequence Diagrams, Prototyping, Activity diagrams, business process flow diagrams using Lucid Chart, Balsamiq and Microsoft Visio.
• Expert in Business Process Engineering, adept at documenting procedures , project documentation.
• Extensive experience with Documentation Repository tools like Confluence, and SHARE POINT.
• Assisted project manager with detailed project plans, developing work break down structure (WBS), scheduling, performing Cost analysis, Risk Analysis, SWOT analysis and tracking project timelines .
• Converted business specifications into Service Oriented Architecture models across IT environments.
• Knowledgeable about 3-tier architecture, Web Services (SOAP, WSDL), Client-Side server and server side.
• Knowledge on API/Web Service frameworks such as Postman and Swagger for documenting and testing SOAP and REST Webservice requests and responses in XML and JSON formats respectively.
• Conversant with database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data Modeling, Data Mining, Data Mapping, Data integrity, Data profiling and Entity Relationships .
• Knowledgeable working with ETL process Extract, Transform and Load of data into a data warehouse.
• Worked in Data warehousing project and used ETL tools, such as SQL server Integration services (SSIS) and Informatica Power Center for data mapping and performing transformations.
• Good understanding of SQL, DDL (Data defining language) operations and executed queries in SQL server for data manipulation and retrieval, Table creation as well as Joins, stored procedures and functions.
• Experienced in developing Test Plan, Test Scripts and Test Cases for Functional, System, Integration and UAT.
• Involved in various kinds of testing like Functional Testing, Regression Testing, User Acceptance Testing.
• Experienced in creating different types reports like graphs, pie charts, dashboard etc. based on requirement using different tools like Tableau, Power BI, Crystal Reports, SSRS (SQL server reporting services).
• A self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Diverse expertise in analytical, conflict resolution and problem-solving skills. Effective in executing multiple tasks and assignments ahead of schedule. Quick learner with excellent communication and interpersonal skills with the ability to communicate effectively with business stakeholders as well as the technical team.

TECHNICAL SKILLS:

Methodologies: Waterfall, Agile(Scrum), Hybrid, SAFe, SCRUMBAN, RUP.

Business modeling tools: MS Visio, Balsamiq, Lucid Chart, Mock UP screens, Rational Rose.

Languages: XML, JSON, HTML, CSS, SQL.

Project Management tools: SharePoint, MS Project, HP ALM, Rally, JIRA, Confluence, MS Office.

Defect tracking: Rational Clear Quest, JIRA, HP ALM.

Testing tools: Load Runner, HP Win Runner, HP QTP, HP Quality Center.

Reporting tools: Tableau, Crystal Reports, Power BI, SSRS.

API documenting & Testing: Postman, Swagger.

Data warehouse tools: Informatica Power center, SSIS, SSAS.

Databases & tools: MS Access, SQL server, Oracle, IBM DB2, TOAD.

Operating systems: Windows 7,8,10 and Mac.

PROFESSIONAL EXPERIENCE:

Sr. Business System Analyst

Confidential, Brea, California

Responsibilities:

• Worked closely with SMEs to identify and analyze the core requirements and features of the project.
• Understood the existing systems and business processes to have a clear picture of the as is state.
• Executed personal interviews, brainstorming sessions, JAD sessions, and focus groups with stakeholders to elicit requirements. Reviewed and edited those requirements and specifications as per the feedback.
• Prioritized functional and non-functional requirements via data analysis, interviews and different modeling tools. Generated business requirement documents, functional requirement documents and data mapping documentation. Built Mock-ups of the Graphical user interface (GUI) of the system using Balsamiq.
• Worked with the team to implement SCRUM methods for project implementation and development.
• Drafted high-level Use Cases from Business Requirements and created UML diagrams like use case diagram, sequence diagram and activity diagram using Lucid Chart.
• Assisted Product owner in grooming the Product Backlog . Also assisted in drafting user stories .
• Gathered business and system requirements for Service Oriented Architecture (SOA) for reducing redundant system/application features. Assisted Web services team in designing REST services.
• Documented requests and responses to REST Web Services in JSON.
• Assisted in API documentation . Used SoapUI tool to perform API testing .
• Performed in depth data analysis to identifying data issues in legacy system and worked with business to develop resolutions to those issues. Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and billing marts.
• Created various tests for System Architects and Quality Assurance Analysts. Checked the compliances of corporate SDLC policies and guidelines.
• Involved in defect tracking to encounter specific requirements for a successful project implementation.
• Created test cases and test scenarios, performed User Acceptance Testing using HP Quality center.
• Involved in Testing and Validating Billing data in Guidewire Billing Center. Established Data Driven Automation Framework to be able to perform UI testing on Guidewire applications.
• Generated reports and created dashboards using Tableau to keep the stakeholders up to dated.

Environment: Scrum, Microsoft Office Suite, Microsoft Visio, Windows, SQL, Rally, SharePoint, Tableau, REST Web services, JSON, Lucid Chart, Balsamiq, HP Quality Center.

Business Analyst

Confidential, Graham, TX

Responsibilities:

• Worked as a liaison between the Business and Technology Department. Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Modelled the 'as-is' process flow and the 'to-be' process flow and analyzed the gap and developed the action steps to fill the gaps, devising processes & procedures to solve the problems, effectively satisfying the gap.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, designed templates, and wrote specifications.
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Worked with user story to respond faster and with less overhead to rapidly changing real-world requirements in an Agile environment. Worked with a cross functional team including Sales and Marketing.
• Conducted RAD sessions for the report users, requestors, and the developers.
• Created Business Rules Document and Requirement Traceability Matrix to track the requirements.
• Coordinated with the developer, on day-to-day basis, during the development process.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Wrote Test Cases in HP Quality Center that would test various Test scenarios.
• Performed GUI testing, Smoke and Sanity Testing, and User Acceptance testing in the new builds for Basic Functionality Checking.
• Maintained Change and Traceability Matrix , keeping track of the scope, timelines, and budget of the project.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
• Reviewed SQL Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Design the data load process using Informatica Power Center and XML Style sheets and ACORD XML.
• Performed SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Helped with Data Mapping between the data mart and the Source Systems. Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Coordinated with Testing Validation team in developing testing scenarios and solving deviations.
• Formulated test scenarios and test cases based on functional requirements documents (FRD) and helped to develop the test plan; performed sanity testing to validate reports.
• Generated reports and created dashboards using Tableau to keep the stakeholders up to dated.

Environment: Scrum, MS office suite, MS Visio, JIRA, MS PowerPoint, SQL, SQL Server, Oracle, HP Quality Center Tableau, SSIS (SQL server Integration services).

Business Analyst

Confidential, New York City

Responsibilities:

• Conducted GAP Analysis after analyzing AS-IS business process and the TO-BE business process.
• Conducted elicitation techniques like surveys/questionnaires, brainstorming, interviewing and document analysis, impact analysis and conducted JAD Sessions with various stakeholders.
• Drafted and maintained business requirements and align them with functional and technical requirements
• Involved in tasks prioritization and tasks Estimation sessions with Business, Project Managers, Business Architects, Application Development Architects, Development leads and Testing leads.
• Conducted project kickoff meetings and Solution meetings with team members to explain roles/ responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
• Drafted Narrative Use Cases and created UML diagrams such as Use Case Diagrams, Sequence diagrams and Flow Diagrams (Business/System) using MS Visio.
• Performed overall Requirements Management and built the Requirements Traceability Matrix.
• Conducted meetings and providing recommendations in enhancing and expediting business activities.
• All the web services in different functional units in the system are Rest API services.
• Used API Tool for adjudication of Professional as well as Institutional claims.
• Performed data manipulation using SQL queries for the retrieval of data from the relational database.
• Extensively used SQL for data Queries, data analysis, data verification and validation.
• Worked closely with development and Testing Team to iteratively implement and deliver functional modules throughout the duration of the project.
• Interacted with developers to report data related bugs and re-tested the fixed issues.
• Involved in creating Test Plan & Test Cases based on business users' requirements to conduct UAT testing with the end users & was responsible in documenting the outcome.
• Worked closely with the development team to analyze and troubleshoot bugs using defect tracking tool JIRA.
• Created and submitted weekly status report using crystal reports to the project manager.

Environment: Hybrid, MS word, MS Excel, MS Project, MS Visio, Balsamiq, MS SharePoint, JIRA, Windows, HP QC, Service Oriented Architecture(SOA), REST, XML, JSON, HTTP, ASP.Net, Java Script, SQL server 2014, Crystal reports .

Business Process Analyst:

Confidential, Minneapolis, Minnesota

Responsibilities:

• Assisted Project Manager in conducting the GAP Analysis of the transition from HIPAA (EDI 835 and 837) focusing on how current transactions and system was going to be affected by the new compliances.
• Elicited, documented and managed Business requirements for HIPAA 5010 version 837, 834, 835, 270, 271, 276, 277 transactions through requirements gathering sessions with stakeholders.
• Created business process workflow diagrams using Business Process Modeling Notation(BPMN). Created Data Flow Diagrams, use cases and activity diagram using MS Visio.
• Assisted project manager on drafting Project plan, Scope, Work breakdown structure(WBS)
• Developed crosswalk between ICD-10 and ICD-9 to assist with transitioning to ICD-10 and identify the differences between the two versions.
• Conducted meetings to gather the REST API Requirements for both the source and target system using Swagger. Managed the project documentation using the Confluence document management system .
• Facilitated sessions with agency staff to identify the business flows and determined whether any current or proposed systems are impacted by the EDI X12 Transaction Code Sets and Identifier aspects of HIPAA.
• Assisted project manager in developing detailing the tasks and efforts required to achieve HIPAA compliance.
• Co-ordinated work plans between project manager and stakeholders using MS Project.
• Support and consult product owner in developing, maintaining and grooming product backlog.
• Maintained Requirement Traceability matrix throughout the project using Microsoft Excel.
• Executed SQL queries to test the database for records that detect and submit functional acknowledgement and remittance advice in the claims application. Worked on ODBC compliant databases for HL7 data transfer.
• Worked on test data manipulation of X12 format using EDIFECS tool.
• Helped in conducting User Acceptance Testing (UAT), and System Integration testing (SIT).
• Reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.
• Tested the patient documentation being transmitted and received was in compliance with HIPAA X12 5010 standards with relevant ICD codes by validating it with Claredi.
• Created different types reports like graphs, pie charts etc. based on user requirement by using SSRS.

Environment: Agile, Windows 2000/XP, Toad, ODBC, Rally, MS Access, Lucid Chart, MS Visio, Confluence, SQL Server, SSRS, HP Quality Center, MS Office, HL7, SOA, JAVA, EDIFECS, Claredi.

Business Analyst

Confidential

Responsibilities:

• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application. Implemented different elicitation techniques like Interviews, JAD sessions and Brain Storming to gather requirements.
• Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
• Involved in gathering clinical data and supported application development.
• Analyzed and optimized the process, prepared Business Requirement Document (BRD) and then converted the business requirements into Functional Requirements Specification and Technical Specification using Rational Requisite pro.
• Used Rational ClearQuest to track the Stakeholders requested enhancements and changes.
• Used Rational Clear Case, a Configuration Management tool to maintain different builds of the application with description about all changes and Versions.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Assisted in UAT testing and interacted with developers to resolve the issues.

Environment: Rational Clear Case, Rational ClearQuest, MS Visio, MS Project, SQL Server 2000, Waterfall

Jr. Business Analyst

Confidential

Responsibilities:

• Understood the existing processes and created process flow diagrams for the new system.
• Conducted JAD sessions and acted as the lead facilitator for project meetings to gather the business and technical requirements from the business users and SME's
• Created Standard Operating Procedures (SOP) for the various activities with help of functional team
• Created wireframes for the claim forms that would be used in the new system
• Translated the business requirements to technical requirements and created the Technical requirements document TRD. Interacted with Development and processing team to discuss about Test issues.
• Created and executed Test cases / Test Scripts according to the Business and Functional requirements.
• Knowledge of Pharmacy Benefit Managers (PBM). Involved in the creation of Technical Specification documents and Customer reports.
• Assisted with maintenance and communication of project status reports and tracking.
• Responsible for Integration Testing, System Integration Testing and Performance testing during various phases of testing. Developed SQL Queries to test the Data Integrity.
• Assisted the Quality Assurance team with their Test Plan, Test Scripts and conducted Usability study.
• Responsible for User Acceptance Testing and created Client Data using Excel sheets.

Environment: Waterfall, Visual Studio 2005, SQL Server 2008, MS Access, Windows XP, MS-Office, Balsamiq, SAP Business Objects.

Jr. SQL Developer

Confidential

Responsibilities:

• Created tables, views, indexes based on the requirements.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Involved in all phases of SDLC and gathered business requirements from business people.
• Created complex T-SQL Stored Procedures, Functions, Triggers, Tables, Indexes and Views and other SQL joins and statements for applications.
• Worked extensively on Confidential Package designs for Import/Export from various Data Sources.
• Involved in performance tuning of T-SQL queries and PL-SQL blocks.
• Involved in Physical and Logical design of the databases.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links, formatted the results into reports, and kept logs.
• Used SQL Profiler and Query Analyzer to optimize Confidential package queries and stored procedures
• Maintained Client relationship by communicating daily statuses and weekly reports.

Environment: MS SQL Server 2000/2005, Windows Server 2003, T-SQL, PL-SQL, Confidential, MS-Office, Microsoft Visual Source Safe, SQL Profiler and Query Analyzer.