Raja Gopal

SENIOR BUSINESS ANALYST/SCRUM MASTER

Introduction Video: https://youtu.be/u1CUNPN6XzM

Email: ac2dox@r.postjobfree.com Phone: 201-***-****

PROFESSIONAL SUMMARY

Detail-oriented, organized, efficient, proactive, zealous and pragmatic Senior Business Analyst with 8+ years of experience in business analysis implementing a variety of projects in E-commerce, Insurance (Property and Casualty). Certified Scrum Master with a proven track record of working in self-organizing and cross-functional teams.

Excellent domain and technical knowledge in various insurance business processes and, have extensively worked on New Business, Underwriting, Policy Administration and Claims.

Strong knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, Test-Driven Development) and Scrum-Waterfall Hybrid software development life cycle environments.

Substantial experience in conducting structured walkthroughs using workflow diagrams to identify, understand and conduct process analysis for business process improvement and modeling.

Skilled as a liaison between technical team and management, change agent and a servant leader with an ability to communicate technical information to non-technical stakeholders. Experience of mentoring the team and providing business value oriented conflict resolution.

Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including Interviews, Requirement Workshops, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.

Ability to analyze requirements and identify dependencies in project, processes, data and systems.

Excellent writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Use-Case Specification, Logical and Physical architecture diagrams.

Detailed understanding of preparation of RACI Matrix (Responsible, Accountable, Consulted and Informed) and Requirement Traceability Matrix (RTM) throughout the process to verify adherence.

Proficient in Requirement Management, Sprint Planning, Issue Tracking, Impediment Management, and Work Allocation using tools like JIRA and HP ALM/QC.

Experience with IBM Maximo for operation tracking, maintenance and disposal of assets

Thorough understanding of preparation and use of Unified Modeling Language (UML) diagrams including Process Diagram, Activity Chart, Use Case Diagram, Sequence Diagram, Data Flow Diagram and ER Diagram using MS Visio and Rational Rose to support system design.

Experienced in creating Prototypes, Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) using tools like MockUp Screens.

Proven Track Record in conducting AS-IS and TO-BE analysis, GAP Analysis, Root cause analysis, Impact Analysis.

Seasoned in facilitating Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting.

Experienced in conducting Scrum Training Workshops and User Story Writing workshops to familiarize stakeholders with Scrum process skeleton and concept.

Well versed with backlog prioritization techniques (MoSCoW, Kano) and estimation techniques (Planning Poker, T- Shirt sizing) to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints)

Proven expertise in developing Test Cases, Test Plans, Tet Scripts, Test Scenarios, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored Black-Box Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing.

Created Training Script and conducted Training Sessions for the end users in the production environment once the product went live and was ready to use.

Experienced in working with Three-Tier Architecture, and Client Side Verification and Server side Verification.

Strong Knowledge on industry standards like ITIL (Information technology information library) and sig sigma

Detailed understanding of Data Modeling and Schemas and use of Business Intelligence (BI) to enable effective decision making.

Thorough understanding of Business Intelligence (BI) and experienced in creating interactive, analytical dashboards using Tableau and SSRS

Strong experience in creating workflows and data flows using ETL tools like Informatica and SSIS

Experience in Service Oriented Architecture (SOAP, XML, REST, JSON, WSDL, HTTP)

Well versed with writing SQL queries to integrate and extract data for analysis and reporting.

TECHNICAL SKILLS

SDLC Methodologies

Waterfall, Agile, Scrum, Extreme Programming

Management Tools

TFS,MS Share Point, MS Project, HP ALM/QC, JIRA

Database

My SQL, SQL Server 2008/2012, Oracle, MS Access

Design Tools

MS Visio, UML, MS Visual Studio, Eclipse IDE

ETL Tools

Informatica, Microsoft - SQL Server Integration Services(SSIS)

Reporting Tools

Tableau, Microsoft - SQL Server Reporting Services(SSRS), EXCEL

Graphical Tools

Mock-Up Screens, Wireframes

MS Office Tools

MS Office (Word, Excel, PowerPoint)

Languages

HTML, XML, SQL, Java, ASP.Net, ADO .Net

Operating System

Windows XP/10, Mac OS

Domain Knowledge

Insurance(Property & Casualty), E-commerce, Banking

PROFFESSIONAL EXPERIENCE

Germania Insurance, Brenham, TX APR 2016 – Present

SR. BUSINESS SYSTEMS ANALYST/SCRUM MASTER

SCOPE: Worked with team responsible for developing a system to perform trend analysis using 5 years of historical premiums and claims data on top of the organizations commercial data marts there by helping the underwriters and actuaries in decision making process and also generated monthly financial reports for verifying and analyzing the organizations financial status. It was very useful for underwriting decisions for which the most recent experience is relevant. The reports from this solution provided the ability to aggregate ultimate losses for policies using querying criteria selected by the user

Roles and responsibilities:

Analyzed the prior documentation and business processes for full understanding of the project. Interviewed area experts, asking detailed questions and carefully recording the requirements hereby building a bridge between the business people and technical people.

After being on boarded, conducted GAP Analysis by understanding the AS IS business process and the TO-BE business process

Involved in prior documentation and business process to understand the scope and development

Organized and Conducted the JAD sessions and conducted the weekly sessions from requirement gathering to sign-off of the application after testing.

Developed a vision plan that defined organization policies and procedures are primary goals of the project.

Conducted JAD sessions, document analysis and one-on-one interviews with the stakeholders for the requirements elicitation.

Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.

Assisted the project manager to construct a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.

Documented Business Requirement Document (BRD) and System Requirement Specification documents (SRS).

Utilized my SQL skills to perform queries to analyze issues during QA.

Assisted the developers to create unit tests, test cases to ensure 100% test coverage of the code.

As a Scrum Master, facilitated Scrum events including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.

Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.

Helped in estimation and prioritization of the user stories using MOSCOW and Planning Poker Techniques.

Decomposed the scope from the BRD into user stories by conducting a story writing session with the product owner. and then the acceptance criteria for the PSPI (Potentially Shippable Product Increment)

Create, maintain, and organize backlog of features, epics, stories, and tasks in JIRA.

Tracked team velocity and sprint progress using Burn down charts and conducted time boxed daily scrum meeting.

Supported the scrum development team by anticipating and resolving impediments and pushed them to deliver quality results based on schedule.

Was responsible for handling requirement churn.

Used JIRA for issue tracking, user story management and requirement traceability.

Submitted weekly reports about the progress of the project to our Program Manager.

Developed Use case documentation for system requirements, business process flows, and screen mockups using MS Visio.

Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams.

Assist with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.

Understood the data requirements and accordingly helped in designing the OLAP cube for analysis.

Integrated the various OLTP to the OLAP by using SSIS as an ETL tool, SSRS as the reporting tool and SSAS for performing analysis.

Assisted in identifying documents needed to develop trend analysis and generating reports and red flags to report trend analysis of every quarter for past five years.

Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.

ENVIRONMENT: MSBI (SSIS, SSRS, SSAS), SQL Server Management Studio, ASP .Net, ADO .Net, Azure SQL Database, Azure SQL Data warehouse, TFS, HP Quality center, N-unit, JIRA 6.4, MS Visio, MS Project, Rational Requisite Pro, HTML, MS (Power Point, Excel, Word, Project), IIS Server, SOA, SOAP, XML, JSON.

THE HARTFORD, HARTFORD, CT MAR 2015 – APR 2016

SR. BUSINESS SYSTEMS ANALYST

SCOPE: Business Technology Operations team wanted to an application that can offer personal insurance rating engine for auto and homeowners line of business for all US customers reducing all the manual efforts and hassles. The role involved to comprehend the business requirements and create functional specifications for the Dev team by helping them throughout the development life cycle, perform functional and regression testing.

ROLES AND RESPONSIBILITIES

Assisted PM in creating work breakdown structure and project charter using MS Project.

Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where, how and in turn help product owner to plan how to bridge the gap.

Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.

Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.

Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project.

Created Use Case Diagrams and Use Case Narratives and incorporated them in Macro Document.

Performed extensive prototyping using Mock-Up Screens and Tableau, Mock-Up Screens

Handled requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the triple constraint and discussing them in daily Scrum.

Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.

Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA.

Strong knowledge of client side and server side validation and assisted in writing verbiage for client side validation using Java Script and Ajax.

Used Informatica to map the data in central data repository and created Data Marts for enhanced Data Management. Used Tableau for generating reports.

Created SQL Queries for Portfolio Drill Downs to pull necessary data from data sources.

Created environment for self-organization and organized team engagement activities.

Worked on service oriented architecture (SOA), REST, SOAP, XML, API.

Created training curriculum and wrote training scripts.

ENVIRONMENT: MS Visio, MS Project, HTML, JavaScript: jQuery and AJAX (JSON and XML) technologies, Eclipse IDE, MS (Power Point, Excel, Word), SharePoint, Oracle 11g, Apache Tomcat Server, Informatica, Tableau, Toad, Web Services, SOA, SOAP, XML, JSON.

STATE OF NEW YORK, NEW YORK FEB 2014 – MAR 2015

BUSINESS SYSTEMS ANALYST

SCOPE: The New York City Human Resources Administration, the largest social services agency in the country, and CMA worked together to create an Enterprise Data Warehouse (EDW) with extensive reporting and analytical capabilities. The EDW has given staff across HRA unparalleled access to, and intimacy with, the agency’s client data. This enables managers to plan and manage initiatives and to respond to crises with up-to-date, integrated information. It has been the foundation for data sharing across HHS agencies, which allows for a more holistic view of the client and services being received.

ROLES AND RESPONSIBILITIES

Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Product Owner and Project Manager in planning the transition.

Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.

Conducted Gap analysis for As-IS and TO-BE of the process to identify and validate requirements.

Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.

Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.

Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.

Maintained project documents and shared important links and tutorials, etc., with the team using SharePoint.

Coordinated and controlled Change Request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes and prepared change request form to provide details of change request.

Conducted data profiling activities such as data clean up and data scrubbing to improve data quality.

Assisted in increasing data integrity by performing data normalization.

Used ETL to map data and integrate data from different sources to enterprise data marts using SSIS.

Assisted architects in creating data hub with Bus architecture.

Assisted the team to build the enterprise data warehouse using Star Schema with individual different data marts to address the area of interest.

Provided the analysis to enable the business integration of the MDM application into the enterprise. Understood customer and business needs and identified areas where business processes can be optimized to better serve those needs.

Helped in gathering requirements for enabling an enterprise to link all of its critical data to one file, called a master file, that provided a common point of reference.

Executed functional tests in the QA environment prior to the QAT process and logged tickets for bugs detected.

Facilitated the QA Test process by assigning test cases to the QA test plan in various builds, assigned test cases to the QA testers, and established contact with the testers.

Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Defect Review meetings during and after the QA Test process.

Provided Test Status by creating a Bug Summary Report and a Test Progress Summary spreadsheet on a daily basis during the QAT process

Participated in Data Validation process in QAT by developing spreadsheets with data from the reports in QA.

Documented Requirements Traceability Matrix (RTM) using IBM Requisite Pro.

ENVIRONMENT:

Wireframes, SQL Server, MS office (Word, Excel, PowerPoint, Visio), UAT Testing, SharePoint, ASP.net, SSIS, SSRS, SSAS.

BANK OF INDIA, NEW DELHI, INDIA APR 2012 – DEC 2013

Business Analyst

SCOPE: The project deals with the credit card transaction authorization based on mobile number and location from where the transaction took place. The system would be able to verify the registered number and location with the transaction details and would approve it accordingly.

ROLES AND RESPONSIBILITIES

Actively Involved in Pre-Analysis of project with SME (Subject Matter Experts) and Developers

Conducted Gap analysis for ‘As-in’ and To-be of the process to identify and validate requirements.

Participating JAD sessions with SME’s and multiple teams for requirement gathering and refinement.

Analyzed the gathered requirement and reviewed Business Requirement Document (BRD)/Functional Specification Document (FSD).

Created System Requirement Specification (SRS) document to describe all data, functional and behavioral requirement of the system.

Used Share point for content management and document management.

Wrote Use Case and built Use Case Diagram/ Activity Diagram using MS Visio.

Created Requirement Traceability matrix (RTM) using HP QC tool.

Used JIRA for allotting task and issue tracking, user story management and requirement traceability.

Worked with QA team for designing Test Plan and Test Cases for UAT and regression testing.

Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected throughout the project

Environment: MS Visio, MS Word, MS Excel, SQL, MS Access, Waterfall, Java /J2EE, Spring framework, Rest Web service, Git Hub (version controlling), HP QC, SOA, HTML 5/CSS, IBM Requisite Pro(Requirement management tool).

FLIPKART, BANGLORE, INDIA JUN 2011 – MAR 2012

Role: Data Analyst

SCOPE: The project was to estimate shipping cost based on distance/weight and implement detailed tracking information of the customer and providing updates to the customer regarding the dispatch of packages. Implementing new features as scheduled dispatch. Providing the information of the customer for a schedule dispatches.

ROLES AND RESPONSIBILITIES

Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.

Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

Designed the Data marts using Ralph Kimball's Dimension modeling methodologies using ERWIN.

Worked with Data Architectures and DBA team to implement data model changes in database in all environments. Generated DDL scripts for database modification, Macros, Views and set tables.

Attended Data Governance Team (DGT) meetings to address data modeling changes to reviewed databases and the enterprise database.

Designed data layer schema using Star and Snowflake Data Models for Enterprise Data Warehouse using CA Erwin.

Generated DDL statements by Forward Engineering and run the SQL scripts.

Worked with DBA to perform intensive data profiling and reverse engineered various already existing databases in order to discern the necessary data relationships underlying general and specific information needs.

Created data masking mappings to mask the sensitive data between production and test environment.

Designed and developed ETL processes using Data Stage designer to load data from Teradata, MS SQL, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse database.

Successfully worked closely with the QA team, other developers and the DBA to ensure optimal performance of SQL scripts.

SOA enabled ITIL framework of support, specialist for Multi-vendor services operating in different states, hands on experience with Lean six sigma methodologies to ensure quality oriented service delivery and reducing bottlenecks.

Ensured the system being developed is Six Sigma (6σ) compliant and the defects/bugs at the time of Go-Live are at the minimum

ENVIRONMENT: SSIS, SSRS, SQL Server Management Studio, MS Visio, Rational Rose, SQL server, HPQC, Microsoft Excel.

ACCENTURE, HYDERABAD, INDIA AUG 2009 – JUN 2011

End Client: Farmers Insurance

DB/ETL Developer

SCOPE: Worked for commercial Business Intelligence team, one of the key departments of Farmers Insurance which extract the Business Insurance data from several source applications and load it to the Commercial Data Marts(CDM). CDM will cover the data for users from Product, Finance and Actuarial groups. This will cover 2 major areas of the Insurance domain: Policy and Claim and all the required dimensionality. Data in the Data Marts was used to generate business object reports by the reporting team.

ROLES AND RESPONSIBILITIES

Identified and defined Entities, relationships and attributes in the data model as per new specifications after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.

Improved performance on SQL queries used indexes for tuning created DDL scripts for database.

Created PL/SQL Procedures to implement business logic.

Created database objects like Tables, Stored Procedures, Indexes, Sequences, Views, and Rules etc.

Implemented the standard naming conventions.

Created Informatica packages to perform get data from different sources, perform ETL and store it in IBM DB2 databases.

For database management system, Toad was used for designing, creating and managing DB2.

Created data mapping documents for the movement of data from transactional OLTP databases to OLAP databases and migration of data to different environments.

Did rigorous load testing by using Load Runner.

Used SQL scripting and automated the scheduling of the data loads to reduce manual efforts.

ENVIRONMENT: Toad, IBM DB2, Informatica power center, MS access, Load runner, Mercury Quality center, ER- diagrams, MS office

EDUCATION:

Vellore Institute of Technology

Majors: Electronics and communication Engineering

Contact this candidate