PROFESSIONAL SUMMARY:

• Senior Business Systems Analyst with 8+ years of experience in Business Development Process, Systems and Data Analysis.
• Experienced working in Insurance Domain, with expertise in Property and Casualty Insurance.
• Followed regulations like GDPR (General Data Protection Regulation), HIPAA guidelines, EDI transactions, IDD (Insurance Distributive Directive), Confidential
• Securities and Exchange Commission), FINRA (Financial Industry Regulatory Authority) and The Federal Reserve.
• Extensive knowledge and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Spiral, Scrum and Scrum
• Waterfall Hybrid software development life cycle environments and have a solid understanding of methodologies like SAFe (Scaled Agile Framework), Extreme Programming (XP), Kanban.
• Extensive years of experience in Business process re - engineering, Business process flow improvements.
• Experience in GAP Analysis, Feasibility Study, Risk Analysis, Impact Analysis, SWOT (Strength, Weakness, Opportunities and Threats) analysis, Cost and Benefit Analysis, Root Cause Analysis, and Pareto Analysis.
• Specialized in Business System Analysis, Requirement management and Change management, Data Management.
• Proficient in networking with individuals at various levels and facilitating elicitation sessions such as interviews, brainstorming, focus group, requirement workshops, prototyping, document analysis, and JAD sessions.
• Created Work Breakdown Structure (WBS) using MS Project for organizing team s work into manageable sections.
• Successfully gathered SMART (Specific, Measurable, Achievable, Relevant and Time-Boxed) requirements and transforming them
• Confidential Requirements documents, Use-Case Specifications, Functional Requirements Document (FRD), Functional Specifications Document (FSD) and System Requirements Specifications (SRS).
• Captained the breaking-down of epics into User Stories (INVEST criteria) and then helped in prioritizing user stories using various prioritization techniques like
• Confidential, MoSCoW model, Paired Comparison, and 100-point method.
• Assisted Scrum Master in facilitating the workshops for estimation of efforts using various estimation techniques Relative Mass Valuation, Planning Poker, T-Shirt sizing, Bucket System, Dot Voting and Affinity System.
• Designed, developed Business Process Modeling, and UML diagrams like Use Cases, Activity and Sequence.
• Good Knowledge of Data Warehousing concepts. Data Mapping, Data profiling, Data Mining. Extensively created Entity Relationship diagrams (ER Diagrams). Performed Data Modeling: Conceptual and Logical Models .
• Good knowledge on transformations, validation rules, Star and Snowflake schema, different OLAP (Online Analytical Processing) operations such as slice, dice, roll-up, drill down and pivot, facts and fact tables, etc.
• Developed data mappings using various transformations. Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc. and documented them.
• Programmed SQL Queries, Functions and business logic Stored Procedures, Packages, Triggers using SQL, PL/SQL and exposure to various database platforms such as Oracle and Microsoft SQL Server.
• Well versed in creating and designing Prototypes, Wire-Frames and Mock-Up Screens for better visualization and understanding of Graphical User Interface (GUI) using tools like Balsamiq, Lucid Charts.
• Worked on Guidewire Software which has three main products, Policy Center, Billing Center and Claim Center.
• Worked on Cloud Computing model, Amazon Web Service (AWS), used services like ELB, EC2, AWS SageMaker.
• Worked on Service oriented architecture (SOA), Web Services. Gathered requirements for Client-Side Validation, and Server-Side Validation. Involved in scripting business logic in the web methods of Web Services and documenting the Web Service Level Agreement (WSLA) document through XML (Extensible Markup Language) .
• Worked on API documentation using Swagger tool. Analyzed domain specific API s while conducting the Interface analysis, to interpret the data formats in their WSDL/WADL for a thorough understanding of business requirements. And supported integration of compliance through REST API s with Business Rules Engine.
• Performed API testing using Postman and SoapUI to check if the API s are returning the data in JSON, XML format as defined in the API documentation using Swagger tool and required by workflow.
• Experienced in creating Test Plan, Test Scripts, Test Scenarios, Test cases, Requirement Traceability Matrix (RTM), User acceptance Testing (UAT), and familiar with software testing and Regression testing.
• Generated multiple reports using different BI tools like Tableau, Qlikview and in-house reporting tools.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environment.
• Worked in Test-Driven Development (TDD) and Behavior-Driven Development (BDD) environments, where I have developed feature files in given-when-then format (Gherkins format) using Cucumber and Jenkins.

SKILLS:

SDLC Methodologies: Traditional Waterfall, Agile/Scrum, SAFE, Waterfall-Scrum Hybrid, XP, RUP, Spiral

Business Skills: Change Management, Risk Management, Impact Analysis, JAD Sessions, SWOT Analysis, Conflict Management, Effort and Impact analysis, Regression analysis, Why-Why analysis, Problem & Incident Management.

ETL Tools: Informatica Power Center, Oracle data integrator, Talend open studio

Business Modeling tools: MS Visio, Mockup Screens, Unified Modeling Language (UML)

Project management tools: MS Project, MS SharePoint, MS Office 365 online

Requirement management tools: JIRA, HP ALM, Confluence, SharePoint

Reporting tools: Tableau, IBM Cognos, QlikView, MS Power BI, MS Excel, Visio

Architecture/Framework: Service Oriented Architecture (SOA), N Tier ArchitectureCloud Platform (SaaS & IaaS), Apache Tomcat Web Server, RedHat JBOSS.

Testing tools: Rational Clear Quest, Load Runner, HP ALM, Swagger, Postman

Databases: MS SQL Server, Oracle, IBM DB2, MS Access, Teradata, SAP HANA

Languages: HTML, CSS, XML, SQL, Python, C, C++, Java/J2EE, JavaScript, JSON, SOAP.

PROFESSIONAL CAREER:

Confidential, CA

Sr. Business Analyst

Responsibilities:

• Participated in writing User Stories and Acceptance Criteria for confidential.
• To elicit the requirements, conducted JAD sessions, interviews, focus groups, brainstorming, prototyping .
• Co-ordinated with onshore and offshore development teams and testing teams for functional and non-functional requirements specifications in form of use cases, process flows, data flow, wireframes and prototypes.
• Organized and collaborated the teams for meeting notes, emails presentations and documentation by using Confluence.
• Created cloud formation template in json format and used AWS SDK to call AWS (Amazon Web Services) Cloud formation service to create AWS resources like ELB, EC2 instance, Route53, Auto scaling group.
• Developed supporting data analysis using Elastic Map Reduce on the Amazon Web Service cloud.
• Integrated the web services by generating the necessary stubs from the WSDL files for extracting the data.
• Used Stack Driver and AWS cloud monitoring extensively to monitor and debug the cloud-based AWS EC2 services.
• Guidewire InfoCenter reduced implementation time and risk through the use of pre-built data extract, transform, and load (ETL) processes from Guidewire Datahub so that you can focus on your business needs.
• Performed and executed DDL (Data Defining Language), DML (Data Manipulation Language) and DQL (Data Query Language) to perform CRUD operations - Create, Read, Update and Delete, Patch the data.
• Created Databases, Data Table Structures, Schemas, Data Marts and performed OLAP operations.
• Assisted Data Architects in ETL Process, Source to Target Mapping Process, Data-Migration and Data-Governance processes with good experience in documenting business and technical metadata.
• Created UML diagrams such as Use Case diagram, Activity diagram and sequence diagram with MS Visio.
• Conducted Agile Scrum Meetings to review the day to day progress when Scrum Master is out of office.
• Maintained defects by prioritizing them against the backlog items and tracked them till completion using JIRA.
• Participated in requirement walkthroughs with the Development teams and Quality Assurance teams with the aim to develop testing strategies, test scenarios and test plans such that test cases reflect user needs.
• Conducted Systems Integration Testing (SIT), Smoke Testing, Regression Testing, White Box Testing, Black Box Testing, Sanity Testing, and User Acceptance Testing (UAT) in both manual and automation test environment.
• Involved in writing Java API for Amazon Lambda to manage some of the Amazon service.
• Created various charts, graphs, reports for business analysis using Tableau Business Intelligence tool.

Environment: Agile-Scrum, Microsoft Office Suite, MS Visio, Tableau, BI Power Designer, HTML, Smart Draw, MySQL, JIR A UML.

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Researched and Analyzed property and casualty business needs specifically policy contracts and process administration.
• Collaborated with the business team in the creation and completion of project charters and project scope for confidential.
• Conducted JAD sessions, brain storming, focus groups & individual Interviews to captured business requirements.
• Also, to understand the policy administration system & ensured coverage on business values, story points & AC.
• The gap between existing Policy Administrating Systems and Guidewire PolicyCenter was identified and diligently designed as-is and to-be process, in scope and out of scope documents.
• Created Use Case models for policy creation to policy end using UML diagrams like Use Case Diagrams, Sequence diagrams, Activity Diagrams and Flow Diagrams using Rational Rose.
• Analyzed and checked for missing values, data structures, data sanity of the legacy system's data using R Studio.
• Performed data integration, data mapping and data extraction management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter with Guidewire Data Hub.
• Helped the product owner in creating Product Backlogs and helped team to maintain Sprint Backlogs.
• Collaborated with the Scrum Master and Scrum teams in Estimation and Velocity planning.
• Maintained defects by prioritizing them against the backlog items and tracked them till completion using JIRA.
• Managed, Shared and tracked version histories of backlog items using Confluence tool.
• Analyzed data patterns and trends using Power BI at the time of analysis and user acceptance testing.
• Validated Rating Algorithms for Schedule Rating, Experience Rating and Retrospective Rating using Guidewire Rating Management components.
• Facilitated the Post Production Validation and actively participated in production call support whenever necessary and ensure smooth running of the system in real time.
• Created training guides, assisted in deployment with step-by-step instructions and created appropriate GUI screenshots for underwriters, agents, claim staff, auditors.

Environment: Agile Methodology, SQL Server, MS Office, MS SharePoint, Power BI, Guidewire Policy Center, Confluence, JIRA.

Confidential

Business System Analyst

Responsibilities:

• Used SDLC (System Development Life Cycle) methodologies like Waterfall.
• Gathered high-level requirement using various elicitation techniques.
• Facilitated JAD sessions with SMEs and Business Analyst from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Assisted client in understanding the business impact of potential underwriting rule changes on sales, premium amount, and medical loss ratio at the state level.
• Analysis of business requirements and systems requirements of the client and also for Property and Casualty modules.
• Created Functional Required Documents, Business Required Documents and Software Requirement Specification.
• Used the DataStage Designer to develop processes for ETL, transforms, integrating data into data warehouse database.
• Developed expertise with ACORD standard Life, Annuity data model and data collection requirements, form models and archival stipulations.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for company's reinsurance broker.
• Responsible to import the existing report using Business objects live office to develop the required reports in Excel & Word.
• Worked with SQL queries using Microsoft Access for data manipulations.
• Created UAT plans with several test cases for each project to ensure that the System runs smoothly after the proposed enhancements or changes have been made.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Analyze Business requirements and segregated them into Use Case Diagrams, Activity Diagrams,
• Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Environment: UML, Waterfall, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Business Objects, TestDirector, LoadRunner.

Confidential

Business Analyst

Responsibilities:

• Gathered requirements for Medicaid and Confidential coverage and performed data analyses.
• Analyze federal and state regulations/ policies for Medicaid and CHIP reimbursements.
• Interacted with healthcare clients to gather requirements and input and output requirement on payer reimbursement.
• Developed Use case, Functional, Object diagrams using Rational Rose.
• Supported in collecting HIPAA related EDI transactional data from data warehouse.
• Worked on implementation, of HIPAA X12 transactions EDI 837 (encounter),835, 270/271,278,834 for upgraded system.
• Developed test cases and scripts for front end testing. Performed execution of test cases manually to verify results.
• Ensured the accuracy and consistency of the data during the data loading process.
• Assisted in documentation of the OnBase solutions using Microsoft Visio and Project.
• Used Linux OS for application prototype and performed screen mockups.
• Created UML diagrams such as use case, activity, sequence, class and component diagrams.
• Analyzed data architecture, documented and delivered data mapping, performed risk analysis.
• Developed a detailed test plan and test cases to cover all the requirements.

Environment: SQL, IBM Cognos, MS Office, DB2, SharePoint, MS Visio, UML, Rational Rose, Jira, Windows XP

Confidential

Jr. Business Analyst

Responsibilities:

• Worked along with the project manager to define the product scope and deliverables
• Acted as a liaison between the business units and the technology teams.
• Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Along with BA conducted elicitation techniques for Requirement gathering and Business Impact Analysis.
• Created BRD (Business Required Documents) artifacts to ensure high level design is accepted by client.
• Created the dimension models and the created the physical data models.
• Involved in end user training and support for new source providers.
• Created and updated artifacts like Software Requirements Specification and Functional Requirement Documents.
• Drafted and maintained business requirements and aligned them with functional and technical requirements.
• Involved with creation of UML diagrams such as activity and sequence diagrams by using MS Visio.
• Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
• Conducted BRD walk thru session with the entire team, business, testers and developers after the completion of the BRD.
• Organize meetings with the SMEs of the dependent systems. Conduct weekly issue meetings with customers.
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagram.
• Used Tableau for generating reports, dashboards, graphs for business analysis.

Environment: SDLC, MS Visio, UML, MS Office Suite, MS Project, HTML, XML, Tableau

Confidential

Java Developer

Responsibilities:

• Interaction with the users at all stages of development to ensure that development was as per user specifications.
• Used OOD concepts in overall design and development of the system.
• User requirements study, analysis and review of the specifications.
• Designed and Implemented the J2EE Based with JDBC in Eclipse IDE.
• Worked with management, vendors & third parties to ensure database management applications operate at peak efficiency.
• Worked on Java server-side programming using Servlets, and JSP. Used CSS for Web pages, HTML and XML markup.
• Implemented servlets to handle HTTP requests for on-line requests, credit card payments, registration and bug tracking.
• Using XML for dynamic display of options in select box and description on web page.
• Designed complex application database SQL statements for querying, updating and reporting using JDBC.
• Responsible for testing, debugging, bug fixing and documentation of the system.
• Developed JUnit test cases and performed integration and system testing. Implemented and Deployed Java components.

Environment: Java, J2EE, JDBC, XML, Servlets, HTML, JavaScript, JSP, CSS, SOAP, Eclipse, SQL, CVS, JUnit, WebLogic, Windows.