We provide IT Staff Augmentation Services!

Sr. Business System Analyst Resume

SUMMARY:

  • Sr. Business System Analyst with IT experience of 8+ years. I havea background of working in Business analysis, System Analysis and Quality Assurancefor diverse roles asBusiness System Analyst, Business Analyst, Programmer Analystand Test Lead in Property and Casualty Insuranceand Life and Annuities Insurancebusiness domain for CAPEX and OPEX projects using various SDLC methodologies like Waterfall, Agile, Waterfall - scrum Hybrid, and working in SAFe environment.
  • Over 8 years of Industry experience as a Sr. Business Systems Analyst with solid understanding of Insurance Business (life and annuities, property and casualty insurance) and technical delivery of Insurance Industry related solutions.
  • Strong understanding and experience in working for regulatory driven projects under ACORD Standards, Know Your Customer (KYC), USA PATRIOT Act, The National Association of Insurance Commissioners (NAIC), The Securities and Exchange Commission (SEC). Familiar with COBIT(Control Objectives for Information and Related Technologies)framework.
  • Highly experienced in working and leading teams throughout the Software development life cycle (SDLC) and familiar with different development cycle methodologies like Waterfall, Rational Unified Process (RUP), Spiral, Agile methodologies (Scrum, Kanban, Scrum-ban, Extreme Programming- XP), Scaled Agile Framework SAFe-4.0, Waterfall-Scrum Hybrid.
  • Experienced in conducting Market Research, Feasibility Studies, Gap Analysis, SWOT Analysis, Cost benefitanalysis, Root Cause Analysis, Risk Identification, Risk Assessment, Risks Analysis, and Risk management.
  • Well versed in RequirementElicitationTechniqueslikePrototyping, Interviews, Focus Groups, Requirement workshops, Survey/Questionnaire, Document analysis, Brainstorming and JAD sessions also Business Requirement Analysis.
  • Expertise increating high-level and low-levelartefacts and creating and presenting clear and concise reports to senior management.Created Business requirement documents (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS) and maintained RACI(Responsible, Accountable, Consulted, Informed) matrix.
  • Worked together with project manager to create Work Breakdown Structure (WBS),tracking Schedules& Milestones.
  • Experience in handling Change Request Management, effectively implemented change by performing Business Impact Analysis and Technical Impact Analysis, monitoring and tracking implementation plans till closure.
  • Adept in splittingepics into User Stories satisfying INVEST(Independent, Negotiable, Valuable, Estimable, Small, Testable) criteria.Proficient with Prioritization Techniques in Scrum like MOSCOW, KANO Model, Paired Comparisonand Estimation techniques like Planning Poker, T-shirt sizing, Relative mass valuation and DOT voting.
  • Facilitated discussion for Decision making and Conflict resolution to ensure positive work environment.
  • Competent in Creating Unified Modelling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams,Sequence Diagramand Data flow diagramsusing MS Visio and Smart Draw.
  • Competent creating and designing prototypes, wire-frames, and mock up screens (high fidelity and low fidelity) to visualize Graphical User Interface(GUI) using tools like Balsamiq and Axure RP.
  • PerformedSQL queries and Stored Procedures and used functions like joins (left, right, inner, outer, full), unions, groupby, order by and aggregate functions to extract data for timely reporting and validation and familiar with Data Definition Language (DDL), Data Manipulation Language (DML) operations to Create, Read, Update and Delete (CRUDoperations).
  • Worked with IT Architects and assisted in creating current and target state enterprise data architectures.
  • Assisted teams in Data modelling, Dimensional modelling, data mapping, Data integration, Data migration, Data Extraction, Transformation and loading (ETL process and procedures) using tools like Informatica Power Centre and SSIS.
  • Experienced in Data Warehousing and ETL process including OLTP(online transaction Processing), OLAP(Online Analytical Processing) like slicing, dicing, roll up, drill down and pivot, data profiling, transformation and validation rules, efficient knowledge of Star and snowflake schema, Data marts, ODS(Operational Data Store), Staging, Data Sources/Targets, Normalization, Denormalization, Dimension tables, Fact tables, Fact-less fact tables.
  • Supported teams in working with different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON, XML for different architectures like 3-tier architecture and SOA for efficient information transfer and mapping.
  • Experienced in API-testing using Postman and SoapUI to verify format defined in API documentation using Swagger.
  • Skilled in Software testing life cycle, helped teams for Test planning, test preparation, test execution, Issue resolution, and report generation. Created Requirement Traceability matrix (RTM) to ensure full requirement coverage.
  • Lead and supported Software Testing and Quality Assurance activities like manual and automated testing to perform Functional testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Regression Testing and performance testingin diverse technical environments with demonstrated leadership abilities.
  • Have experience in Java-Selenium WebDriver forautomation framework enhancement and executing Automated Regression test suites. Also have prepared Business Calc sheets using Java-Selenium and Excel VBA Macros.
  • Having experience inClient interaction, Defect triage meetings, defect impact analysis calls, Scrum Calls, possess extensivehands-on experience in Test Estimation andTest Strategizing.
  • Thorough understanding of Business Intelligence (BI) and adept in creating interactive, analytical dashboards using Tableau/SAS visual analytics/Google analytics for visualization and decision making.
  • Used Tableau and Google analytics as BI tool for generating analytical report required in project for further analysis.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, RUP, Spiral, Agile- Scrum, Waterfall-Scrum Hybrid, Kanban, Frameworks- SAFe, COBIT.

IT Management Skills: Change Management, Problem and Incident Management, Impact Analysis, Requirement Elicitation, SWOT analysis, Gap analysis, Risk management, Conflict management.

Business Modelling Tools: MS Visio, Smart Draw, Lucid charts, Axure RP, Balsamiq, Mock-up screens, UML.

Project Management Tools: MS Project, MS SharePoint, MS Office 365 online

Requirement Management Tools: JIRA, Confluence, CA Agile central (Rally), HP-QC/ALM

Reporting Tools: Tableau desktop, SAS Visual Analytics, Google Analytics, IBM Cognos, QlikView, Microsoft Business Intelligence (MSBI), MS Office Suite- Excel, PowerPoint, Word, Outlook, SQL Server Reporting Services (SSRS)

Testing Tools: Selenium WebDriver, Excel VBA, Quick Test Professional (QTP), LoadRunner, Test Director, ClearQuest, Postman, Cucumber

Languages: C, C++, JavaScript, VBA, HTML, CSS, XML, JSON, SQL, Audit Command Language (ACL)

ETL Tools: Informatica Power Centre, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Databases: MySQL server, Oracle,HDFS, MS Access

PROFESSIONAL EXPERIENCE:

Sr. Business System Analyst

Confidential, Austin, TX

Responsibilities:

  • Actively involved indocumentation of business processforunderstanding the Scope and to develop knowledge of pricing equation for an insurance premium.Facilitated Joint Application Development (JAD), Brainstorming Session involving business stakeholders, technical analyst, SMEand financial analyst to gather requirements & have better understanding of business process.
  • Analysedas-isand to-be states of the systemfor performingGap Analysisinvolvingidentification of business rules, business and system process flows, requirements and assumptions.
  • Recordedbusiness rules outlined by business owner for increasing accuracy of the system.Involved in creatingBusiness Requirement Document(BRD), Functional specification document(FSD),project plan and schedule.
  • Gathered requirements in the form of use cases and user stories based on the need and necessity, assisted the product owner to break down epics into User storiesand Prioritizationof Product Backlog Items.
  • Created the UML for structuring the whole project. Identified Use Cases and developed the Use Case diagram, Activity diagrams and Sequence diagram.Worked with solution architect to create wire-frames / prototypes of the web-based application and forservers with different configurations such as Application server, mobile server.
  • Prepared data dictionaries, requirement specifications and User Interface (UI) specifications.
  • Analysed existing data sourcesin 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 in Amazon SageMaker.
  • Implemented change data Capture (CDC) for inserting and updating slowly changing dimension tables in target for maintaining the history data.Used Informatica Power centre in data warehouse to map data coming through input sources to the target data marts.
  • Created dimensional data models& helped teams in ETL process fortransferring the data to Amazon S3 bucket and create the DataMart in Amazon Redshift and to load the predictive data models into Salesforce Marketing Cloud.
  • Documented REST API via JSON using Postman and used plugins for integrating with JAVA. Reviewed Business Rules written for middle tier and validated JSON schema for system data documentation including the requirement data document.
  • Worked on JIRA for continuous update with project schedules, quality, issues and managing resources.
  • Managed every change request effectively throughout the software development.Conducted User Acceptance Testing (UAT) and developed the test plan, test conditions&test cases&manually executedtests to verify actual result against the expected results.
  • Regularly submitted defect reports and conducted meetings to communicate with development team about the defects.
  • Used JIRA 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 and prepared requirement traceability matrices (RTM).
  • Worked with the Product owner to review the working demo of Potentially shippable product increment (PSPI) in review meeting and helped which features satisfy acceptance criteria and are Done.

Environment and Tools:SAFe, JIRA 6.4, Informatica PowerCentre 9.6, Tableau, MS Visio, MS Project, HTML, Java Script, MS (Power Point, Excel, Word, Project), Jenkins, Amazon Redshift, AWS SageMaker, Salesforce Marketing cloud services, REST, JSON, Postman.

Business System Analyst

Confidential, Brenham,TX,

Responsibilities:

  • Interacted with stakeholders, claim specialists, claim adjusters, field investigators to capture the process flow from first notice of loss (FNOL) to claim case closure and conducted Gap-Analysis to understandAS-IS process and give insights of TO-BE process .
  • Successfully performed Job shadowing to understand legacy system and conducted JAD sessions to elicit requirements .
  • Created the Business Requirements document (BRD) for building User Interface Guidewire Claim Centre.
  • Created Mockup screens and wireframe using Balsamiq to assist the UI team in development of the Guide wire claim center UI interface and got the designs reviewed and approved from the stakeholders.
  • Recommended enhancements needed in the Guidewire Data-hub by analyzing existingreports in data warehouse of legacy systems and examined existing ETL (Extract, Transform and Load) programs .
  • Designed Conceptual & Logical Models to capture entities existing in the system & relationship between them using E-R Diagrams . Facilitated Design sessions with Data Architects & development team to enhance the Data-hub Design to meet requirements.
  • Associated with business leads to finalize the product backlog for Guidewire claim center application and assisted in verifying Micro-Strategy reports. Prepared Use Cases and Data Flow Diagrams to communicate page flow and user interaction with system.
  • Assisted in design review meetings to make sure all the requirements are covered in the development project scope.
  • Wrote User Stories fulfilling INVEST criteria, assisted Product Owner in prioritizing the Product BacklogItems (PBIs) and helped the development team in estimating story points using planning poker .
  • Developed Data Mapping & Data Transformation documents between Legacy database, Data Hub, &front-endapp of Guidewire.
  • Performed SQL queries operations like Joins, Union, aggregate to fetch the data from MYSQL server and 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 user requirements.
  • Worked closely with development and Testing Team throughout the project to help them understand the requirements . Involved in writing Test Plans, Test Cases & Test Scripts using HP ALM &worked with off-shore teams to ensure coordination .
  • Involved in running the automated test scripts in Selenium and performed User Acceptance testing.
  • Used 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 and prepared requirement traceability matrices (RTM).
  • Worked with the Product owner to review the working demo of Potentially shippable product increment (PSPI) in review meeting and helped which features satisfy acceptance criteria and are Done.

Environment and Tools: Scrum, HTML, CSS, JavaScript, Informatica power center, .NET, Micro-strategy, MS office suite (Power Point, Excel, Word, Project, Visio), HP-ALM, Balsamiq, Selenium Web driver.

Business System Analyst

Confidential, Madison, WI

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 session and analysing existing systems documents.
  • Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams. Understood AS-IS system, developed TO- BE systemconcepts and prepared the System Process Maps.Prepared Business Requirement Document (BRD) and drafted Systems Requirement Specification (SRS). Analysed, modified and validated these documents.
  • Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
  • Assisted Product Owner in writing User Stories fulfilling INVEST criteria, prioritizing the Product BacklogItems (PBIs) and helped the development team in estimating story points using T-shirt sizes .
  • 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 reportingtool.
  • Assisted in increasing Data Integrity by performing Data Normalization&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.
  • Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest. Designed and developed all Use Cases and UML models using MS Visio.
  • Played a key role in the planning, testing, and implementation of system enhancements and conversions.
  • Used ETL to map data and assisted to assemble data repository and create data marts.Used Data Centre for Integrating Legacy systems and supporting in decision making.Assisted in creating Data Hub with Bus Architecture.
  • Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
  • Established Incident Reporting and Change Control procedures.Developed timelines for project delivery, and managed projects and resources to successful completion.
  • Assisted the Product owner to review demo of Potentially shippable product increment (PSPI) helped identify features that satisfy acceptance criteria and meet definition ofDone.

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

Business Analyst

Confidential

Responsibilities:

  • Acted as a liaison between the business partner &other Systems Department areas, development centres & various other vendors.
  • Led as a primary contact for team members &coordinated activities that involve various teams & cross disciplines, such as requirements, design and testing.
  • Assisted the Project Manager in setting realistic project expectations and in evaluating the impact of changes.
  • Created status update reports, analysed information, and proposed action plans to assist leadership in decision-making and achieve resolutions. Worked on data related requirements and conducting data/requirement validation and verification by querying through SQL statements from databases e.g. SQL server/Oracle etc.
  • Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Created documentation including detailed requirements, user stories based on BDD, acceptance criteria, feature description PowerPoint decks, user guides, requirements mapping, data elements, business rules and process flows as well as all agile artefacts for project tracking and budgeting.
  • Served as Point of Contact for deployment activities and coordinated with deployment team to create plan, determined impacts and formed resolutions. Performed change management activities using HP Service Management and signing off the document after the changes were approved.
  • Served as escalation point and coordinate risks, issues and dependencies and change requests as well as own and track the resolution, furthermore, assist in removal of roadblocks impeding team progress.
  • Supported User Acceptance Testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge. Also, documented the evidence of tests.
  • Adhered to the standards set forth in the Enterprise Architecture (EA) Playbook, Integrated Customer Platform (ICP) playbook, and process owner guidance to produce business architecture, requirements and transition artefacts.

Environment and Tools:Waterfall-Scrum hybrid, DXCs wealth management accelerator (wmA), DXCs customer service accelerator (csA), Vantage, MS Office, MS Project, JIRA, Confluence, MS Visio, UML, Business Process Model and Notation (BPMN), OneNote, MY SQL, SQL, Selenium.

Test Lead

Confidential

Responsibilities:

  • Worked as the RC12 test lead from Offshore with a team size of 9 members .
  • Estimated the number of scenarios, cases and effort required to complete the project.
  • Gathering Requirements, analysing BRD’s and BA documents and functional requirements and providing effort estimation .
  • Preparing Test Scripts to enhance the existing Regression Test Suite. Running Regression scripts and analysing impact of defects in production.
  • Understanding the requirement from requirement specs provided by customer and then preparing the High-Level Test Scenario Document.Attained walkthrough of Test Scenario and Test Cases and received sign off from business.
  • Responsible for MTP preparation and sign-off, Table set up preparation, Environment set up plan preparation and sharing the same with client and Development team.
  • Providing KT to new resources and upgrading their skill sets in the fields of Annuity, Testing and application.
  • Functionality validations and sign-off for Fund Sweep (or investment calculation), Fund Maturity calculation, Fund investment with respect to Gain criteria and Annual Lock investment and maturity calculation for SCS16 B-share contract. Tax calculation for Qualified and non-Qualified contracts.
  • Selecting Scan Criteria for the entire release (consisting of data which comprised of in-scope products policy dump).
  • Attaining Defect Calls, defect triage meetings and production defect analysis .

Environment and Tools:Waterfall, wmA,csA, Vantage, MS Office, MS Project, HP-QC, SharePoint, MS Visio, UML, OneNote, MY SQL, SQL, Selenium, Quick Test Professional (QTP).

Programmer analyst (Quality Assurance)

Confidential

Responsibilities:

  • Worked as a team member for the Fund Substitution project.
  • Took sole responsibility of Prelims Testing project.
  • Quarterly and Anniversary statement of account validation for the contracts satisfying the condition.
  • Understood Requirement eliciting and then breaking the same into smaller modules such that that helps the Business, Development and the Testing teams.
  • Analysis, verification and logging of Defects, linking and tracking of defects in HP-QC .
  • Attained Defect calls from QA offshore, was involved in defect logging, retesting, test execution, test case development and review and test scenario preparation .
  • Preparing Test Scripts and following Fixed Bid model. E execution of test cases.
  • Requirement Traceability matrix preparation and reporting to client on any ambiguity/changes on requirements.
  • Developed automation scripts in selenium .
  • Automated test scripts in Selenium, LoadRunner, Test Director to verify the issues and perform regression testing.
  • Running Regression scripts and analysing impact of defects in production.
  • Dashboard Preparation and Daily status reporting .

Environment and Tools: Waterfall, wmA, csA, Vantage, MS Office, HP-QC, SharePoint, OneNote, MY SQL, SQL, Selenium, Quick Test Professional (QTP).

Hire Now