We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Columbus, OH

SUMMARY:

  • Solution driven business analyst with 8 years of experience collaborating with cross - functional teams in the documentation, development and delivery of system innovations to meet challenging business goals. Expertise in agile, waterfall and iterative development projects in Property & Casualty Insurance Industry.
  • Extensive experience as a business analyst in Property & Casualty Insurance, Guidewire and Salesforce.
  • Working knowledge of policy underwriting, insurable interest, facultative reinsurance, retention limit, co-insurance, renewable term, written and unearned premium. Expertise in billing management with insurable interest, renewable term, retrospective rating, written premium and unearned premium.
  • Well versed with claims management i.e. FNOL, valuation, tort law, litigation, subrogation and salvage.
  • Experience with industry associations like insurance guarantee association and certificate of authority.
  • Experience with implementing software development projects using methodologies like Scrum, Waterfall and Waterfall-Scrum hybrid. Intense knowledge of RUP, XP, Kanban and SAFe methodologies.
  • Profound knowledge in risk identification & impact analysis, cost-benefit analysis, SWOT analysis, feasibility study, root cause analysis, business process (As-Is/ To-Be) analysis and GAP identification.
  • Proficient in requirement elicitation using market analysis, introspection, prototyping, brainstorming, document analysis, interface analysis, reverse engineering and joint application development session.
  • Tracked major project milestones and performed critical path analysis to manage project timeline and budgeting. Maintained work breakdown structure using MS Project for time, cost and resource allocation.
  • Rigorously used requirements documentations in the form of business requirement documents (BRD), functional specification documents (FSD), use case models, data flow models and user stories.
  • Expertise in scrum ceremonies like release planning, sprint planning, daily scrum, backlog grooming, sprint review and retrospective to manage issues using project collaboration tools like JIRA and HP-ALM.
  • Sufficiently aware about defining definition of done, acceptance criteria and definition of ready.
  • Extensive practical experience with writing user stories and prioritizing issues using user story mapping, MOSCOW and KANO methodologies. Performed horizontal and vertical slicing of user stories.
  • Well versed with SMART criteria to create user stories and adhered to INVEST (independent, negotiable, valuable, estimable, small and testable) principle to decompose epics into user stories.
  • Well versed in developing service level agreement (SLA) and defining key performance indicators (KPI).
  • Designed wireframes and mockup prototypes using Balsamiq and developed UML diagrams such as use case diagrams, sequence diagrams and activity diagrams using MS Visio and Lucid Charts.
  • Developed test cases in given-when-then format using Cucumber while following industry standardized development processes like test driven development (TDD), behavior driven development (BDD), acceptance test driven development (ATDD), continuous integration continuous development (CICD) and pair programming to streamline development of potentially shippable product increment (PSPI).
  • Elicited requirements to create data mapping specification document, dimensional data models and entity relationship (ER) data models. Executed data cleansing, data profiling and validation of data.
  • Identified business rules and business process specifications to design extraction, transformation and loading (ETL) process of bigdata for data warehouse project using AWS Glue, Alteryx and Informatica.
  • Identified the nature and types of reports required for various stakeholders and designed it using business intelligence tools such as Tableau, QlikView and Power BI to provide decision support.
  • Performed SQL CRUD operations on database including joins, aggregators, sub-queries, stored functions and stored procedures using data definition language (DDL) and data manipulation language (DML).
  • Performed data analysis using slicing, dicing, roll-up, drill-down and pivot on various OLAP cubes.
  • Created request and response API documentation using Swagger and executed API testing using POSTMAN and SOAPUI to audit the data type format (JSON, XML) for the flow of information.
  • Well versed with test scripts, test cases, test plans and created requirement traceability matrix (RTM).
  • Assisted business owner in executing user acceptance testing (UAT) for product increment approval by validating positive and negative test cases for various test scenarios.
  • Involved in execution and automation of tests, tracked bug tickets in JIRA and generated issue reports.
  • Assisted QA team to execute functional testing, integration testing, regression testing, system testing, performance testing (load, stress, endurance, spike), boundary value analysis and black box testing.

TECHNICAL SKILLS:

Business Skills: Change management, risk analysis, ROI analysis, cost-benefit analysis, JAD sessions, SWOT analysis, GAP analysis, feasibility study, impact analysis, project planning, conflict management, defect management.

Project Management Tools: JIRA (v.6.3,7.0), HP ALM (v.11.5), HP QC (v.11,12), MS Project (2013, 2016), MS SharePoint (2010, 2013), Confluence (v.6.4, 6.3, 6.2)

SDLC Methodologies: Waterfall, Agile-Scrum, Water-Scrum Fall, SAFe, Kanban, XP

Modeling Tools: MS Visio (v.14, 15, 16), Lucid Chart, Balsamiq, ERWIN Data Modeler

ETL Tools: Informatica Power Center (v. 9.5, 9.6.1), AWS Glue, Alteryx

Data Warehousing: Data Marts, Data Modelling, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up

Databases: MYSQL, Microsoft SQL, T-SQL, PL/SQL, Oracle, AWS S3, Redshift, RDS, PostgreSQL

Testing Tools: HP QC, HP ALM V11.5, Load Runner (v. 11.5, 12.02), Selenium, POSTMAN (v.3, 4, 5, 6)

Reporting tools: Tableau (v. 9.3, 10.0, 10.1), Power BI, SSRS, Google Analytics, MS Excel (2010, 2013, 2016), SWAGGER (v.2, 3), Cucumber (v3.0)

Languages: C/C++, JSON, XML, SQL, Python, JavaScript, JSON, HTML-5

PROFESSIONAL EXPERIENCE:

Confidential - Columbus, OH

Sr. Business systems analyst

Responsibilities:

  • Performed market analysis and developed survey questionnaires using SurveyMonkey to analyze market value and facilitated joint application development sessions between stakeholders to elicit requirements.
  • Elicited business rules and designed process flow diagrams to determine mileage threshold, replenish premium funds, determine cost of trip, create and manage insured’s electronic ledger.
  • Performed reverse engineering to analyze data flow of different departments and identify various sources of existing customer data to be integrated with AWS cloud services using Kafka connect APIs.
  • Performed GAP analysis and carefully elaborated application enhancement specifications detailing in-scope/ out-of-scope items and as-is/ to-be process maps to identify data lacking in current application.
  • Assisted product owner to create, slice and prioritize user stories to populate product backlog in JIRA.
  • Designed UML models like Use- Case diagram, Activity diagram and Sequence diagram using Lucid Charts.
  • Assisted in developing high fidelity and low fidelity mock- up and wireframe prototypes using Balsamiq.
  • Clarified business requirements associated with PBIs to the development team in sprint planning meeting.
  • Assisted QA lead in developing high level test scenarios, test cases, test plans and documented requirement traceability matrix to track the test coverage associated to business requirements using Confluence.
  • Developed test cases in given-when-then format using Cucumber for test driven development (TDD) to streamline development of potentially shippable product increment (PSPI).
  • Assisted PO with sprint feedback meeting to review committed potentially shippable product increments (PSPIs) and provided feedback according to definition of done (DOD) and Acceptance Criteria.
  • Facilitated feature demo meeting and scribed business owner reviews to convert feedback into user stories.
  • Assisted business owner in performing user acceptance testing (UAT) for approving product increments by validating happy, unhappy and exception test cases for various test scenarios.
  • Elicited requirements to create data mapping specification document, conceptual and logical data models utilizing entity relationship (ER) diagram. Executed data cleansing, data profiling and validation of data.
  • Migrated various sources to target data by applying transformation logics like aggregator, update strategy, lookups, source qualifier, joiner, union, expression source/target definition using AWS Glue.
  • Performed data analysis using slicing, dicing, roll-up, drill-down and pivot on various OLAP cubes.
  • Participated in writing SQL queries to extract selective data out of AWS Redshift for the analytics purposes.
  • Identified the nature and types of reports required for various stakeholders and wrote SQL queries to extract selective data to design visualization using BI tools such as Tableau to provide decision support.
  • Utilized Swagger editor and UI to document requests and responses for Angular JS frontend RESTful APIs.

Environment: agile scrum, MS Visio (v.16.0), Lucid charts, MS project, MS office suite, JIRA (v7.4), Confluence (v6.2), AWS Glue, AWS S3, AWS Redshift, Tableau, Cucumber (v.3.0), PostgreSQL.

Confidential - Columbia, SC

Sr. Business systems analyst

Responsibilities:

  • Tracked major project milestones and performed critical path analysis to manage project timeline and budgeting. Maintained work breakdown structure using MS Project for time, cost and resource allocation.
  • Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with project manager and technical lead. Authored functional and non-functional requirement documents, business requirement documents, solution requirement packages, and service requirement documents.
  • Developed user stories consisting of business rules, UI mockups and use cases using MS Visio to capture the functional requirements and GUI requirements for the Guidewire billing center.
  • Managed contents, documents, data, applications and information through MS SharePoint.
  • Prepared business requirement document after the collection of functional requirements from system users that provided appropriate scope of work for technical team to develop prototypes.
  • Worked on different areas of billing center, such as automated commission calculations, reducing billing leakage, combining invoices, managing and incorporating different payment plans.
  • Scheduled automatic bill payment option along with how customer receives and pays their bills.
  • Analyzed source and target data structures to check for missing data in the legacy system using Informatica.
  • Performed SQL CRUD operations on database including joins, aggregators, sub-queries, stored functions and stored procedures using data definition language (DDL) and data manipulation language (DML).
  • Performed data modelling, data mapping and ETL of data along with data cleansing and profiling while migrating data from legacy system to Guidewire Billing center with Guidewire data hub.
  • Analyzed business and functional requirements of the application and developed detailed test plan and test scenarios with various happy, unhappy and exception test cases in quality center.
  • Created relationships in requirement traceability matrix linking business requirements to functional requirements and functional requirements to systems requirements using HP ALM.
  • Created appropriate GUI mockups using Balsamiq for underwriters, agents, claim adjusters and billing clerks.
  • Developed guidelines for training users and assisted in deployment with step by step instructions.
  • Created request and response API documentation using Swagger and executed API testing using POSTMAN and SOAPUI to audit the data type format (JSON, XML) for the flow of information.
  • Performed business user acceptance testing (UAT) of all Guidewire billing center for data integrity.

Environment: agile scrum, JIRA, Guidewire insurance suite, Balsamiq, HP ALM, Tableau, MS office, MS SharePoint, Alteryx, MS Visio, Jenkins, Oracle.

Confidential - Brenham, TX

Business systems analyst

Responsibilities:

  • Tracked major project milestones and performed critical path analysis to manage project timeline and budgeting. Maintained work breakdown structure using MS Project for time, cost and resource allocation.
  • Assisted PO with scrum ceremonies like release planning, daily scrum, backlog grooming, process review and retrospective to manage issues using project collaboration tools like JIRA.
  • Assisted product owner to create, slice and prioritize user stories to populate product backlog in JIRA.
  • Customized JIRA tool as per functional team preferences and utilized it to track user stories to completion.
  • Clarified business requirements associated with PBIs pulled to sprint backlog by the development team.
  • Facilitated system demo meetings to present potentially shippable feature demo and documented business owner reviews to convert feedback into user stories and add it to product backlog.
  • Developed user stories consisting of business rules, UI mockups and use cases using Lucid Chart to capture the functional requirements and GUI requirements for enhancement of current system.
  • Performed GAP analysis and carefully elaborated application enhancement specifications detailing in-scope/ out-of-scope items and as-is/ to-be process maps to identify data lacking in current application.
  • Elicited business requirements to create data mapping specification document, conceptual and logical data models for entity relationship (ER) models. Executed data cleansing, data profiling and validation of data.
  • Migrated various sources to target data by applying transformation logics like aggregator, update strategy, lookups, source qualifier, joiner, union, expression source/target definition using Alteryx.
  • Performed data analysis using slicing, dicing, roll-up, drill-down and pivot on various OLAP cubes.
  • Created request and response API documentation using Swagger and executed API testing using POSTMAN and SOAPUI to audit the data type format (JSON, XML) for the flow of information.
  • Assisted QA team to execute functional testing, integration testing, regression testing, system testing, performance testing (load, stress, endurance, spike), boundary value analysis and black box testing.

Environment: Agile ScrumBan, JIRA, Balsamiq, Tableau, MS office suite, Cucumber, Swagger, Maven, Kafka, ZooKeeper, Spark, HDFS, Yarn, Mahout, MySQL, JDBC, MS SQL.

Confidential

Salesforce business analyst

Responsibilities:

  • Assisted in configuring security and organizational hierarchy for sales for Salesforce implementation.
  • Designed wireframes and mockup prototypes using Balsamiq to customize page layout for Salesforce standard and custom objects. Developed UML diagrams such as use case diagram using MS Visio.
  • Involved in feasibility study, market analysis, design, development and testing of workflow rules, triggers, data validation rules and other customizations with sales cloud.
  • Created field mapping document for various objects like accounts, contacts, products, quotes, campaigns, pricebooks, analytics and leads. Performed bulk data import using Data Loader.
  • Identified the nature and types of reports for custom objects and associated it to dashboard.
  • Automated Business processes like Sale Order, Shipping & Invoicing using app-exchange application.

Environment: Agile scrum, Salesforce, Data loader, App-exchange, MS Office suite, JIRA, Confluence, Oracle.

Confidential

Jr. business analyst

Responsibilities:

  • Documented elicited requirements in the form of business requirement documents (BRD), functional specification documents (FSD), use case models, sequence diagrams and activity diagrams.
  • Designed wireframes and mockup prototypes using Balsamiq for shopping catalogue and user profiles.
  • Assisted with test scripts, test cases, test plans and created requirement traceability matrix (RTM).
  • Elicited requirements to create data mapping specification document and entity relationship (ER) data models. Executed data cleansing, data profiling and validation of data.
  • Assisted business owner in executing user acceptance testing (UAT) for product increment approval by validating happy, unhappy and exception test cases for various test scenarios.
  • Designed various types of reports required for stakeholders using Tableau to provide decision support.

Environment: Waterfall, SharePoint, MS Office suite, Tableau, HP LoadRunner, Lucid chart, MySQL

Confidential

Data analyst

Responsibilities:

  • Identified various data sources to prepare data mapping document by interviewing subject matter experts.
  • Created SQL statements to query the database for data consistency, data quality, profiling and data analysis.
  • Identified business rules and business process specifications to design extraction, transformation and loading (ETL) process of data for data warehouse using Informatica.
  • Performed SQL CRUD operations on database including joins, aggregators, sub-queries, stored functions and stored procedures using data manipulation language (DML) to extract specific data for predictive analytics.
  • Performed predictive analytics on extracted data to forecast sales and develop labor schedule using Minitab.
  • Data management with Power Pivot, working with diverse data sources and building custom interactive dashboards with Tableau to study the trends, data patterns, data forecasting and answer the business needs.

Environment: Waterfall, HP ALM, MySQL, Informatica, Minitab, MS Office suite, Tableau.

Hire Now