SUMMARY

• A proficient, result & detail oriented Business Analyst/SCRUM Master/Agile Coach with 8+ years of experience of high productivity. Driven by strong leadership, strong work ethics and high competence, with exceptional interpersonal, written & verbal communication skills shared with ability to work under pressure to keep up with the deadlines.
• Worked in various domains like P&C Insurance and Finance. Ability to quickly grasp new concepts and processes while working vertically across the organization and end users to ensure accurate and timely completion of large & small - scale projects.
• Senior Business System Analyst, Senior Business Analyst, Scrum Master with 8+ years of experience with proven ability to work with self-organizing and cross- functional teams in a wide spectrum of various sectors.
• Highly skilled in Business Analysis, Business process Flow, Business Re-engineering, Business process improvements and implementation of complex IT projects and Extensive experience in all phases of the Software Development Life Cycle (SDLC).
• Excellent understanding and experience of software methodologies such as Waterfall model, Spiral model, Agile, Scrum, Waterfall-scrum hybrid, Extreme programming and Rational Unified Process (RUP).
• Proficient in authoring/reviewing Business Requirements Document (BRD), Functional Specification Document (FSD), System Requirement Specifications (SRS), Use Cases, Test cases, Data mapping document, RTM (requirement traceability matrix) and also documented the project process and procedures.
• Experience in Eliciting Business Requirements by organizing and facilitating requirement gathering session with various techniques like, Interviews, Brainstorming, Joint Application Development (JAD), Survey, Job Shadowing, Document/Report Analysis, Focus groups and Prototyping.
• Proficient in creating Unified Modeling Language (UML) diagrams such as Use case diagrams, Activity diagrams and Sequence diagrams using MS Visio, Rational Rose helping the technical team and non-technical team in understanding the requirements in effective manner.
• Knowledge and Experience in performing GAP Analysis, SWOT analysis, Impact Analysis, Root-cause identification, Cost-Benefit analysis, Feasibility study, and Risk Analysis for supporting execution of several business decisions.
• Experience in handling change request management, effectively implemented change by performing both business Impact analysis and technical Impact analysis of the change on the scope of the project.
• Experienced in converting requirements into wireframes, mock-ups to give a better view of requirements to technical team for developing UI/UX components and also to get approval from Business users.
• Skilled Scrum Master with experience and understanding of Scrum Process, Scrum Artifacts and Scrum Ceremonies.
• Well acquainted in facilitating Sprint Ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective) for each sprint in Agile Scrum Methodology as a Scrum Master.
• Experienced in writing User stories conducted user-stories workshops and handling the Requirement Churn. Efficient in performing prioritizing techniques, Moscow, KANO, Walking Skeleton and Business Value Based.
• Worked on decomposing EPICs into smaller user stories for effective utilization by Considering the INVEST (Independent, Negotiable, valuable, Estimable, Small, Testable) Criteria and identifying SMART tasks with the help of the team.
• Certified Scrum Master and coached multiple teams on agile principles to ensure they follow the Principles. Conducted story writing workshops to effectively write user-stories.
• Conducted Funspective’s to improve team’s productivity; also maintained the velocity of all the teams and reported the teams progress to stakeholders. As a Scrum-master managed the dependencies in the Product backlog.
• Experience in Using Estimation techniques like Planning Poker, T-shirt sizing, Relative mass evaluation. And also kept track of the team’s velocity.
• Worked in Safe environment at program level as a scrum master and maintained multiple teams tracked the teams progress and used time management techniques.
• Assisted the Product owner in maintaining the Product Backlog. Strong internal and external communication, improving productivity, adaptation and transparency. Kept track of all the bugs using the Grasshopper boards.
• Conducted Retrospective meetings at the end of each sprint using various Techniques like Silent Writing, 4L’s, 360 degrees’ appreciation, The CAPT activity and Happiness Histogram by maintaining the team’s comfortability.
• Created and maintainedSprint Burn-down Chart andProduct Burn-Down Chartto keep the track of the team’s progress and Sprint Burn-up chart and Product Burn-up chat to show the progress of team to the higher management.
• Good knowledge about the KANBAN process and helped them team to and ensured there is no cherry picking.
• Coached the Scrum team as scrum master on agile principles/scrum principles and made sure the team is following the agile principles. Collaborated with both off-shore and on-shore team members to ensure they are collaborated, self-organized and also providing high productivity and to support agile deliver.
• Highly skilled in requirements tracing throughout the development process and verifying with the Requirement Traceability Matrix (RTM) and Good understanding in preparing Responsible, Accountable, Consulted, and Informed (RACI) chart.
• Experience working in (SOA- Service Oriented Architecture) Three-Tier architecture, Ajax, Web Services (SOAP, WSDL and REST), Client-Side Validation, and Server-Side Validation. Possess good knowledge of validation scripting like JavaScript, JQuery and Angular JS, HTML and CSS.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different data sources. Knowledge of Relational Database Management systems (RDBMS).
• Good knowledge of Data mapping and Data Warehousing. Worthy knowledge of User Administration.
• Knowledge of OLAP cube and performing operations such as Roll-up, Drill-down, Slice, Dice and Pivot and designing and deploying reports via Tableau and Micro-Strategy.
• Good understanding on Data modelling which includes Dimensional Modelling and E-R modelling. Expert in creating Specifications and developing Conceptual, Logical and Physical ER Diagrams.
• Experience in supervising various types of testing like Black-box Testing, System Testing, Functionality Testing, Regression Testing, Integration Testing, Load/Stress Testing, Security Testing and Performance Testing.
• Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications. Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.
• Worked with third party vendors and contactors to accommodate the needs and specify the requirements.
• Worked with QA team to design Test plans, Test Scenarios and Test Cases for Testing process and User Acceptance Testing (UAT) and also performed User Acceptance Testing(UAT) with the end-users to demo the system. Also a part of Smoke testing, Sanity testing and A/B testing.
• Possess strong knowledge on concepts like data profiling, data mining, data migrating, data mapping, ETL process, data masking, top down and bottom up approach, OLTP, OLAP, MOLAP, ROLAP, HOLAP & DOLAP.
• Strong knowledge of personal line property and casualty insurance including policy, claim processing, Underwriting, insurance rate regulations, Premium’s and reinsurance. Designed business rules based on the exposure of the risks.
• Extensive experience in MS Project, MS Visio, MS Office Suite (MS Word, MS Excel, MS PowerPoint) and Microsoft Outlook.
• Excellent communication, analytical, problem solving, and management skills with an eagerness to learn new technologies and team building capability.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Spiral, Waterfall-SCRUM Hybrid, Rational Unified Process (RUP), Extreme Programming(XP).

Reporting Tools: Tableau, IBM Cognos, Micro-strategy.

Business Modeling Tools: Rational Rose, Rational Rose, Mockup Screens.

Languages: HTML, XML, JAVA, SQL.

Requirement Management Tools: JIRA, Version one, MS Office, Rational Requisite pro, Rally.

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, ETL, Slicing/Dicing, Drilldown/ Roll Up, Informatica Power Center.

Web Services: XML, Soap, Rest, JSON.

Testing Tools: HPQC, HP ALM, Rational Clear Quest, Load Runner.

Databases: MYSQL, Oracle, DB2.

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

BUSINESS SYSTEM ANALYST/ SCRUM MASTER

Responsibilities:

• Actively involved in prior documentation and business process for understanding the Scope and Developed knowledge of Catastrophe modelling and CAT Bond pricing.
• Facilitated Joint Application Development (JAD), Brainstorming Session involving business unit stakeholders, technical analyst, SME, portfolio managers, and financial analyst to gather requirements and have better understanding of business process.
• Conducted as-is analysis and Gap Analysis for current state and to-be state of the system which involved in in the identification of business rules, business and system process flows, requirements and assumptions.
• Rewrote new business rules which were outlined by business owner for increasing the accuracy of the system.
• Involved in finalizing the Business Requirement (BRD/HLD/LLD), FSD, SRS, project planning and scheduling.
• Created the UML for structuring the whole project. Identified Use Cases and develop the Use Case diagram, Activity diagrams and Sequence diagram.
• Being a Scrum master, effectively conducted Sprint Ceremonies, created sprint burndown chart and collaborated with team to come up with action plan. Ensured to remove impediments to make team more efficient and productive.
• Gathered requirements in the form of use cases and user stories based on the need and necessity. And Assisted product owner to work on User stories to create Product Backlog.
• Prepared data dictionaries, requirement specifications and User Interface (UI) specifications.
• Prepared requirement traceability matrices (RTM) and managed every change requests effectively throughout the software development life cycle.
• Conducted User Acceptance Testing (UAT) and developed the test plan, test conditions and test cases and manually executed these to verify actual result against the expected results and also exported test case created in MS Excel Sheet to Quality Center/HP ALM.
• Used Quality Center/HP ALM for reporting and defect tracking, also followed up with the development team to verify defect fixes and updated defect status also documented all the bugs.
• Analyzed existing data sources in OLTPs by working with SQL Queries and came up with to-be states of new OLAP System coordinating with the SME’s as how to achieves those states.
• Implemented change data Capture (CDC) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Worked on JIRA for continuous update with project schedules, quality, issues and managing resources.
• Used Informatica Power center in data warehouse to map data coming through different input sources to the target data marts.
• Worked with Information Architect to create wire-frames / prototypes of the web based application.
• Worked with servers with different configurations such as Application server, mobile server.
• Regularly submitted defect reports and conducted meetings to communicate with the development team about the defects. Also, Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.

Environment: Waterfall-scrum hybrid, HP Quality center, JIRA 6.4, INFORMATICA POWER CENTER 9.6, Tableau, MS Visio, MS Project, Rational Requisite Pro, HTML, Java Script, MS (Power Point, Excel, Word, Project), Jenkins, IBM Cognos, IBM WebSphere ESB, IBM BluMix, IBM DB2, Web Services, REST, SOA, SOAP, XML, JSON.

Confidential - Brenham, TX

BUSINESS SYSTEM ANALYST/SCRUM MASTER

Responsibilities:

• Conducted JAD sessions to gather the requirements from the stake holder and also performed Job shadowing to understand the previous system. Created the Business Requirements documentation(BRD) for building User Interface Guidewire Claim Centre.
• Conducted Gap-Analysis to understand the AS-IS process and also give insights of the TO-BE process.
• Interacted with the stakeholders, claim specialists, claim adjusters, Field investigators to capture the process flow from first notice of loss (FNOL) to claim case closure and understand the current state of system and defined future needs based on analysis of business requirements after implementing Gap analysis.
• Developed Data Mapping and Data Transformation documents between Legacy database, Data Hub, and front end application of Guidewire.
• Recommended the enhancements needed in the Guidewire Data-hub analyzing the existing reports in data warehouse of NexGen legacy systems and also examined the existing the ETL programs.
• Associated with business heads to finalize the product backlog for Guidewire claim center application and assisted in verifying the Micro-Strategy reports.
• Prepared Use Cases and Data Flow Diagrams to communicate the page flow and user interaction with the system.
• Designed Conceptual and Logical Models to capture the entities existing in the system and the relationship between them using E-R Diagrams, keeping in mind the business requirements for each LOB in P&C insurance.
• Facilitated Design sessions with Data Architects and development team to enhance the Data-hub Design to meet Enterprise, Business and Data processing requirements.
• Performed SQL queries operations like Joins, Union, aggregate to fetch the data from MYSQL server and also performed operations like master data retrieval from Informatica power center.
• Performed OLAP operations for retrieving data from the database and data warehouse, generating ad-hoc reports, and conducting data validation testing.
• Identified and documented issues, risk, gaps, descriptions, impact and provided recommendation and alternatives to develop the application to meet the user requirements.
• Wrote User Stories fulfilling INVEST criteria, assisted the Product Owner in prioritizing the Product Backlog Items (PBIs) and also estimated Story Points using planning poker.
• As a Scrum master facilitated and time-boxed Scrum ceremonies such as Sprint planning, daily scrum, Sprint review, Sprint retrospective and also backlog refinement meeting.
• Conducted Sprint review meeting by inviting all the stakeholders and Assisted with product owner to give Demo of the Potentially shippable product increment (PSPI) to the stakeholders.
• Conducted Sprint Retrospective meeting at the end of each sprint to track the teams progress in previous sprints and improve performance in next sprint.
• Shielded the team from various impediments. Used JIRA to create and manage sprint and product backlogs, to track issues, trace requirements.
• Created Sprint Burndown and Release burn-down Chart to keep track of the team’s velocity and sprint progress.
• Created Mockup screens and wireframe to assist the UI team in development of the Guide wire claim center UI interface and also got the designs reviewed and approved from the stake holders.
• Worked with both off-shore and on-shore teams to mainly ensure that they are self-organized.
• Assisted in design review meetings to make sure all the requirements are covered in the development project scope. Involved in writing Test Plans, Test Cases and Test Scripts using HP Quality Center.
• Worked closely with development and Testing Team throughout the project to make them understand the requirements to deliver the functionality on time.
• Responsible for identifying risks and also Escalating risks to higher management if required.

Environment: Scrum, HTML, CSS, JavaScript, Informatica power center, .NET, Micro-strategy, MS Visio, MS Excel, MS (Power Point, Excel, Word, Project), JIRA, HPQC.

Confidential - Madison, WI

BUSINESS SYSTEM ANALYST

Responsibilities:

• Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
• Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Conducted one to one meetings with Data architect, Enterprise architect and Solution advisors.
• The methodology used for the project was Waterfall and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status both internally within IT team and to stakeholders.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO- BE system concepts and also prepared the System Process Maps.
• Prepared Business Requirement Document (BRD) and drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Identified Source systems for Financial data profiling of Billing and Budget processes.
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as 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 Validity to maintain accuracy and effectiveness of data,
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Used ETL to map data and assemble data repository and created data marts.
• Used Data Center for Integrating Legacy systems and supporting in decision making.
• Assisted in creating Data Hub with Bus Architecture.
• Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
• Understand the Software Development Life Cycle and experience in system architecture mapping.
• Designed and developed all Use Cases and UML models using MS Visio.
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
• Establish Incident Reporting and Change Control procedures.
• Developed timelines for project delivery, and managed projects and resources to successful completion.

Environment: - SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSIS, SSRS, SSAS.

Confidential

BUSINESS ANALYST

Responsibilities:

• Conducted JAD Sessions with the SMEs and managers to understand the business processes, functional details and understand the requirements.
• Identified gaps in the existing systems by performing GAP Analysis on the AS-IS business process maps.
• Created the TO-BE business process maps to communicate the solutions to the entire team as well as to gain the approval of the SMEs and the management team.
• Documented the business requirements into a Business Requirements Document (BRD) and created System Requirement Specification (SRS).
• Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow Diagram (DFDs).
• Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and the test case requirements to their functional requirements.
• Worked as a liaison between business and technical teams to communicate requirement prioritization and level of effort (LOE) to make sure highest value features are given higher priority.
• PreparedUML Diagrams which included modeling of all the activities ofbusinessfrom conceptual to procedural level in MS Visio. Also,assisted in designing Conceptual and Logical Data Models.
• Coordinated with the Business Analysts for assisting Data Analysis, Data Mapping process, Data Extraction and Integration to the data mart by using the Informatica Power Center.
• Worked on development and customization of Informatica mappings" Mapp lets" workflows with work lets A tasks using various transformations for loading the data from multiple sources to data warehouse
• Involved in Data cleansing and Data de- duplication through Data stage and Quality stage layer
• Conducted Requirement Walkthroughs with the development and test teams before the development and testing phases started respectively, to ensure that the requirements are accurately understood.
• Managed scope and performed Change Control and Change Management after base-lining the requirements.
• Assisted the software testing (QA) team in creating the test plan, test Scenarios, and test cases by conducting knowledge transfer sessions.
• Created User Acceptance Testing (UAT) plans with several test scenarios to ensure that the proposed features and functionalities are functioning correctly.

Environment: MS Visio, MS Word, MS Excel, SQL, MS Access, Clear Case, Clear Quest, RUP, Java /J2EE, Spring framework, Rest Web service, HP QC, SOA, HTML / CSS / JavaScript: jQuery and AJAX (JSON and XML) technologies. IBM Requisite Pro.

Confidential

JUNIOR BUSINESS ANALYST

Responsibilities:

• Used Waterfall Methodology throughout the project lifecycle and Worked closely with Business teams/project stake holders to map the expectations to deliver the capabilities.
• Gathered business requirements by interview technique from business users and stakeholders, conducted one to one sessions and consulting existing systems documents. Also, conducted and participated in JAD sessions to gather the requirements.
• Prepared Functional Requirements document (FRD) and also assisted in Use-case modelling.
• Designed UML diagram’s such as Use-case diagram, Activity Diagrams and Sequence Diagrams to depict process flows.
• Performed GAP analysis to identify/discover new functional requirements and understood AS-IS and TO-BE process.
• Prepared Change Request form and conducted the Impact analysis for each phase, Cost analysis and also obtained approvals for the change request form.
• Involved in preparing test cases and also a part of UAT testing to evaluate results against the user requirements.

Environment: Java, J2EE, JSP, HTML, Eclipse 3.1, WebLogic Application Server, UNIX, Oracle 10g, Rationale Rose, Spring MVC, MS Project, MS Office Suite.

Confidential

JUNIOR JAVA DEVELOPER

Responsibilities:

• Involved in system design, coding, testing, installation, documentation and post-deployment audits, all performed in accordance with the established standards.
• Developed the project using Agile Methodology and Involved in the implementation of Spring IOC.
• Developed Session Beans for Flex clients.
• J2EE Architecture was a combination of Apache Struts implementing MVC model. Involved in design and development of three-tier architecture.
• Created Java Servlets and other classes deployed as EAR file, connecting to Oracle database using JDBC.
• Developed the business logic using Java Beans and Session Beans.
• Developed a tool to retrieve and send data to third party service provider. This feature was implemented using XML, SOAP.
• Developed Event Logging & Error Reporting application using Servlets.
• Built customer tag handlers and description library. And developed view pages and Java Beans (Flex, Java Beans, HTML, SQL).
• Developed system to access to legacy system database (JDBC). Modelled EJBs and other classes using Rational Rose.
• Designed data flow system, divided data flow to modules, defined function and interface.
• Developed procedures and functions, user interfaces and error handles for bookkeeping and RMB transaction modules (SQL), writing user manual and training users. Used Shell Scripting in UNIX for calling multiple java commands through the script file.
• Web Services Integration with other web Services using REST client.

Environment: Core Java, JDK, J2EE, Servlets, JSP, Struts, MVC, EJB, Java Beans, SQL, PL/SQL, Design Patterns, JDBC, JBOSS, Log4J, Apache ANT, JavaScript, CSS, HTML, XML, DB2, Stored Procedures, Windows 2000/NT/98 OS.