SUMMARY:

• Over 8 years of professional experience as a Sr. Business Systems Analyst / Business Analyst with expertise in Software Development Life Cycle methodologies (SDLC) and Business Process Re - engineering in Insurance and E-commerce domain.
• Highly skilled professional with industrial experience in standard Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Kanban and Waterfall-Scrum Hybrid and has a decent understanding of RUP and SAFe 4.0.
• Proficient in Stakeholder Analysis, Impact Analysis, Risk analysis, Change Management, Conflict Management, Cost-Benefit Analysis, process management and Gap Analysis includes AS-IS and TO-BE analytical techniques.
• Skilled as a Scrum master seasoned in facilitating Scrum Ceremonies including User Story Workshops, Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.
• Performed Business Process Modelling (BPM), Analysis & Re-engineering and providing solutions for issues relating to Risk management and Solution Management processes for better and efficient decision making in time.
• Proficient in conducting and facilitating Joint Application Design (JAD) sessions, interviews, brainstorming sessions, questionnaire, Document analysis, focus group, workshops, and Status Demo sessions.
• Proficiency in gathering requirements and transforming them into Functional and Non-Functional specifications.
• Extensive experience in drafting and analyzing Request for Proposal (RFP) and Request for Information (RFI), Business Requirements Document (BRD), Functional Specification Documents (FSD), Software Requirement Specifications (SRS), Use Case documentation and Requirement Traceability Matrix (RTM)
• Created multiple Unified Modeling Language (UML) diagrams including Use Case, Activity, Sequence, Data Flow and ER Diagrams using MS-Visio and wireframes, prototypes and mockups using Balsamiq.
• Expert in SQL, DDL (Data defining language) operations and executed queries in SQL server for data manipulation, retrieval, table creation as well as Joins, stored procedures, and functions.
• Extensive noledge on Data Warehousing architecture, Implementation approaches, schemas, dimensional modeling, Data Marts, Rapidly and Slowly Changing Dimensions, OLAP Cubes operations, and able to perform Reverse Engineering Analysis interpreting the business requirements and identify the source systems.
• Worked in Data warehousing project and used ETL tools, such as Informatica Power Center for data mapping and performing transformations. Hands on experience creating data mapping document using MS Excel.
• Comprehensive understanding of Three-Tier Architecture and Service Oriented Architecture (SOA), Web Services, APIs, REST & SOAP using XML, JSON, WSDL, and UDDI, with internet protocol suites like HTTP/HTTPS and FTPS.
• Knowledge of 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.
• 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, and User Acceptance Testing.
• Expertise in gathering and managing Requirements and tracked defects working with Jira, Rally (CA Agile), SharePoint Enterprise 2016, HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC).
• Experienced in creating different types reports like graphs, pie charts, dashboard etc. based on requirement using different tools like Tableau, Power BI, SSRS (SQL server reporting services).
• Extensive experience working in Hadoop ecosystems and familiar with concepts such as HDFS, Name nodes, Data Nodes, Map Reduce, YARN and libraries such as Hive, Pig, Spark, Sqoop, Flume, Storm, Oozie, Ambari, and Kafka.
• Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions
• Experience working with Guidewire Claim Center, Policy Center and Billing Center
• Knowledge of Guidewire integration framework and various integration methods like Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.
• Prepared manuals, Project Implementation Materials, and Standard Operating Procedures.
• Excellent analytical, team building, critical thinking and decision-making skills coupled with good verbal, communication, interpersonal skills with the ability to communicate effectively withbusinessstakeholders as well as the technical team.

TECHNICAL SKILLS:

Regulatory-Compliances: Dodd-Frank Act- Consumer ProtectionAct, Workforce Investment Act, Health Information Privacy Model Act, and Risk Management & Own Risk and Solvency Assessment Model ActPCI DSS, Fair Trading Act.

Insurance: Claim Management, Quotation Management, Billing Management, Policy Centre, Risk Exposures, Premium Calculations, Commercial and Personal Insurances, Unemployment Insurance, Life Insurance, Health Insurance, Property & Causality Insurance, Payment Verifications.

Requirements Management: JIRA, RALLY (CA Agile), HP ALM 11.5

Reporting Tools: IBM Congos, Power BI, SSRS, Tableau

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio, MS SharePoint 2013

Testing Tools: HP QC, Load runner, Cucumber, SOAP UI 4.5, Swagger, Postman 4.8.0.

ETL Tools: INFORMATICA Power Centre, SSIS -SQL Server Integration Service, SSAS

Languages and Web Elements: HTML, SQL, CSS, JS, XML, JSON, SOA, WSDL 2.0, UDDI, APIs and SLA.

Databases: MySQL, Postgre SQL, IBM DB2, Oracle 11g

Modeling & Designing tools: CA ERwin 9.5, MS Visio, Rational Rose, Smart Draw

Defect Tracking tools: Jira, HP Quality Centre, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Business Systems Analyst

Responsibilities:

• Ensured compliance with various compliance regulations such as Dodd-Frank, FIO Act, and NRRA act.
• Conducted multiple Interviews, Brainstorming, Requirements Workshop and JAD sessions with Product owners, development teams, BI analysts, DB admins, Insurance analysts, and SMEs to elicit requirements regarding scenarios, business rules, compliance & regulations, and reporting requirements of Property and Casualty Insurance.
• Created Functional Requirement document (FRD) to in corporate low-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional, Data, and GUI requirements
• Assisted the Product Owner in effectively drafting user stories and slicing the user stories based on the Business value
• Involved in business process reengineering (BPR) by conducting Process modeling, SWOT analysis, Document analysis, and GAP analysis to understand AS-IS business process and TO-BE business process for the system integration.
• Created multiple UML diagrams including Use Case, Activity, Sequence, Data Flow and ER Diagrams using MS-Visio.
• Experience in creating User Interface Design (GUI), wireframes, prototypes, and mockups using Balsamiq
• Involved in modeling business scenario predictions like segmenting audiences based on their behavior, building a customer profile, and providing simplified attribution insights
• Experience uploading user stories, maintain the status of the project and creating burndown and burnup charts in JIRA.
• Developed and implemented SQL queries by using various DDL and DML statements such as select, insert using MySQL.
• Analyzed the requirement, and discussed with the stakeholders, to identify the data sources to load data from HDFS to the HBase by performing ELT operation using Hive tool.
• Tested and documented SOAP and RESTful APIs in XML and JSON format using Swagger.
• Adept at supervising automation testing, black-box testing, integration, system and regression testing in a testing environment and involved in the creation of User Acceptance Test cases.
• Used Test Driven Development (TDD) development technique for building the components and Jenkins for automating the continuous integration of the components on a regular basis
• DevelopedReports/interactive dashboards with different analytics views (Drill-Down/ Dynamic, Pivot Table, charts, heat maps, Tabular with filters) based on user requirements in Tableau.

Environment: and Tools: Scrum, Tableau, SQL Server 13.0 database, Hadoop, Balsamiq, Jenkins, Swagger, Apache Sqoop, Apache Spark, HBase, Mahout, Oozie, Mongo DB, MySQL, Oracle 11g, Hive, Pig, and Jira.

Confidential, Brenham, TX

Sr. Business Systems Analyst

Responsibilities:

• Involved in eliciting the requirements of diverse sources in Property and Casualty Insurance such as Guidewire claims center, underwriting system, policy administration system and Billing System.
• Performing Gap analysis of Current state and desired state to identify As-Is business process and the To-Be system.
• Created and maintained User Stories by interviewing the SMEs, Claim Specialists, Claim Adjusters, to capture the process flow from First Notice of Loss (FNOL) to Claim-case closure, to communicate the requirements to development.
• Conducted meetings with stakeholders and users to review/manage expectations and identify opportunities to improve the efficiency and productivity of the project
• Helped in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD) and Software Requirement Specification (SRS) to enable the development team to understand business requirements.
• Coached teams to write effective user stories using INVEST criteria, and tasks using SMART criteria, defined Acceptance criteria, and Definition of Done during user story workshop.
• Used Mockup screens and screenshots to convey the look and feel of GUI screens to developers using Balsamiq
• Used Unified Modeling Language (UML) to prepare Use Cases Diagrams, Activity Diagrams, Sequence Diagrams to make a visual representation of the gatheird requirements using MS Visio.
• Extensively used SQL for data queries, data analysis, data verification, validation and to filter data.
• Worked with SME’s to perform in-depth data analysis to identifying data issues in the legacy system.
• Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and billing marts. Also designed logical data modeling, created class diagrams and ER diagrams.
• Documented and tested APIs like REST and SOAP which were in the format of XML and JSON using postman.
• Extensively interacted with QA Team in executing Test Plans, Test Scenarios and Test Cases for Claim Center Module
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Automation Testing, User Acceptance Testing (UAT) using the HP Quality Center.
• Analyzed and documented Reinsurance Claims, Billing Collections, and Accounting modules of the application.
• Generated reports and created dashboards using Tableau to keep the stakeholders up to date.

Environment: and tools: Waterfall-Agile Scrum Hybrid, Microsoft Office Suite, Microsoft Visio, Windows, SQL, SharePoint, Informatica PowerCenter, Tableau, REST Web services, JSON, Balsamiq, HP Quality Center.

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Interacted with business users, stakeholders, Subject Matter Experts (SME) and performed documents analysis and GAP analysis to assist Product Owner and Project Manager in planning the transition.
• Facilitated JAD sessions as Moderator, conducted interviews with various SMEs to elicit requirements.
• Documented requirements by creating BRD, FRD, SRS and Source Target Mapping Document (STMD).
• Worked on MS Visio to write Use Cases and create UML models along with Use Case diagrams, Sequence diagrams, Activity diagrams, Statechart Diagrams, User Interaction Diagrams and Class diagrams.
• Identified various source systems, types of data and created Data Flow diagrams. Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help the development of an accurate Data Warehouse Structure in a multilayer set-up inclusive of Metadata Layer.
• Integrated various data sources by Extracting, transforming and loading data by mapping them using Informatica Power center (PC). Created Data Mapping document on MS-Excel to track end-to-end systems.
• Integrated various Online Transactional Processes(OLTP) to the Online Analytical Processes(OLAP) by using Informatica power center and used Tableau as a reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Data Validation processes to maintain accuracy, the effectiveness of data and curb Data leakages.
• Generated periodic data reports for reconciliation, reporting using Excel & SQL Joins, views, and procedures & visualize and maintained documents using SharePoint Document management tool to record the progress.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional testing, load testing, Regression Testing as well as smoke and sanity testing.
• Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) analysis in facilitating expenditure tracking and resource optimization using various matrices critical to decision making.
• Involved in implementation by assisting in the preparation of module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.

Environment: and Tools: Waterfall, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau 7.0, Informatica Platform9.5, R, MS Visio, MS Project, Jira, Wireframes, Mock-Up Screens, MSSQL Server, SharePoint, GAP Analysis, UML, UAT testing.

Confidential, Hartford, CT

Business Systems Analyst

Responsibilities:

• Assisted in maintaining compliance requirements for varying and changing regulations such as serialization RoHS.
• Analyzed the prior documentation and understood the business processes interacted with the stakeholders, business users and SME’s and elicited requirements by conducting JAD sessions with on and offshore teams.
• Facilitated Requirements Workshops, Focus Groups, document analysis, brainstorming sessions and conducting interviews to elicit requirements and reported results. Conducted GAP Analysis to understand AS-IS and TO-BE business process.
• Responsible for drafting the artifacts such as Business Requirement Document (BRD), Software Requirement Specification (SRS), Functional Specification document (FSD), Request for proposal (RFP).
• Designed UML diagrams like Use Cases, Use Case Diagrams, Activity Diagrams and Sequence diagrams using MS Visio.
• Gatheird requirements for the GUI and created UI prototypes and mock-ups using Mock-up Screens.
• Worked on creating Data Analysis, ER Diagrams, and creating conceptual and logical data models.
• Worked on Databases along with Database Objects such as Tables, Stored Procedures, Views and indexes, Triggers, Rules, User-defined data types, and functions such as create, update, read, delete queries.
• Prepared project-related presentations to provide a clear view of the tasks to be performed and targets to be met within the time frame. Worked on updating the progress of the project on Requirement Traceability Matrix.
• Generated reports like drill-down reports, tabular reports using SQL Server Reporting Services on SQLServer and performed testing for the data in Test Environment for client validation and issues resolution.
• Prepared Test Cases, Test Plans, and Test Scenarios and assisted the QA in regression and integration testing.
• Used Project management tool like JIRA for maintaining project status and to maintain user stories.

Environment: and Tools: Waterfall-Scrum Hybrid, TDD, Share Point Enterprise, JIRA, MS Visio, MS Project, SOA, RESTful, JSON, XML, Informatica Power Centre, IDQ, Oracle 11g, MS Office tools (MS Word, MS Excel, MS PowerPoint), MySQL Workbench.

Confidential

Business Systems Analyst

Responsibilities:

• Hosted JAD sessions with stakeholders, Subject Matter Experts (SME’s) & management personnel to reduce the time spent on gathering requirements. Helped in creating BRD & FRD.
• Based on Business value vertically sliced Epics into user stories during Product Backlog Grooming sessions.
• Extensively used INVEST criteria to write User stories along with Product owner, development team and Scrum master. Also wrote Acceptance criteria for each user story. Participated in various scrum ceremonies like Product Backlog grooming sessions, Sprint planning meeting, Daily Scrum, Sprint review meeting, Sprint retrospective.
• Liaised between product development team, cross-functional units, Project management team, and finance department identifying business process gaps to manage risk ensuring project success.
• Created Mock-up and wireframes using UI components for enhancing customer experience using MS-Visio.
• Assisted User acceptance testing (UAT) with Sr. Business Analyst in environment setup, identified stakeholders, defined acceptable criteria for scripts to pass. Worked on HP- UFT.
• Tracked entire project using Rally, kept track of team involved in each phase, communicated defects to the team involved and made sure tickets raised are resolved.
• Creating different types of SSRSreports like Parameterized, Drill through, Drill down,subreports using tables, crosstabs, and charts. Applied various SSRS expressions like aggregate functions etc. to apply custom logic.
• Generated reports and created dashboards using Tableau to keep the stakeholders up to date.

Environment: and Tools: Waterfall, MS Office (MS Excel, MS Word, MS PowerPoint), Javascript, jQuery, MS project, Mockup-screens, MS Visio, MySQL 5.1, SQL Loader, Tableau.

Confidential

Business Analyst

Responsibilities:

• Worked in Waterfall-Scrum hybrid methodology as Software Development Life Cycle (SDLC).
• Interacting withthe Subject Matter Experts(SME's) andStakeholdersto get a betterunderstanding of client business processes and gather business requirements.
• Conducted various sessions like JAD Sessions, Brain Storming and Focus Groups for eliciting pragmatic requirements.
• Creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD).
• Drafted and Managed User Stories and Features and Create User story Dependency Matrix and Story mapping artifacts.
• Developed Mock Screen and Wire Frames and presented as DEMO session to the Primary Stakeholders.
• Understood 3-Tier Architecture, Service Oriented Architecture, Web Services, Application Servers, API, Web Servers.
• Developed Business Requirement Document (BRD) and Use Case Document (UCD).
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Created ad-hoc reports using MS-Excel and Pivot tables to do the calculations and creating reports according to the needs of the users.
• Worked with the QA team for designing Test Plan and Test Cases and assisted in conducting User Acceptance Testing (UAT)

Environment: and Tools: Waterfall-Scrum hybrid, MS Office, MS Visio, SQL, UAT Testing, HP QC, COTS

Confidential

Jr. SQL developer - Jr. Business Analyst

Responsibilities:

• Coordinated with Database team in creating Entity-Relationship (ER) Diagrams for database modeling
• Identified Primary Keys, Composite Keys, Candidate Keys and Foreign Keys for the tables and has assisted Sr. PL/SQL Developer in creating them with accurate relations for the RDBMS
• Comprehensively involved in development and creation of Centralized Database for the banking website and application which could be modified and further enhanced in the future
• Gatheird requirements from stakeholders to define the scope and requirements for the project and bridged the gap between the perspectives of the development team and business users
• Under the supervision, guidance and support of Sr. Business Analyst drafted Software Requirement Specification (SRS) and Functional Requirement Specification (FRD), Request for Proposal (RFP), Use cases, Test Cases and UML diagrams.
• Gatheird requirements for the Graphical User Interface (GUI) and created Mockup screens.
• Prepared project-related presentations to provide a clear view of the tasks to be performed within the time frame
• Facilitated Joint Application Development sessions (JAD), Brainstorming, with stakeholders, subject matter experts (SMEs) and developers to identify the needs and refine the work done
• Supported QA team to trace bugs and complete the bug life cycle for the best results
• Created several views and reports of the data which was needed by the Audit team using IBM Cognos.
• Assisted Sr. PL/SQL Developer in the creation of stored procedures, views, tables and wrote SQL queries for CURD operations to maintain a database on MySQL 5.1.

Environment: and Tools: Waterfall, MS Office (MS Excel, MS word, MS power point), Javascript, jQuery, IBM Cognos, MS project, Mockup Screen, UML, PL/SQL 5.1.