We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Columbus, OH


  • Versatile professional with8 years of ITexperience working as a Sr. Business Systems Analyst / Business Analyst with expertise in Software Development Life Cycle methodologies (SDLC) and Business Process Re - engineering in Property and Casualty Insurance and E-commerce domain.Highly motivated, Proactive, Exceptional Negotiation Skills, Impeccable Written and Communication skills with excellent Interpersonal skills.
  • Highly skilled professional with industrial experience instandardSoftware Development Life Cycle (SDLC) methodologies like Waterfall, Scrum, Kanban and Waterfall-Scrum Hybrid.
  • Experience in Property and Casualty Insurance (Auto, Home, Life, Umbrella and Commercial lines).
  • Proficient in Stakeholder Analysis, Impact Analysis, Risk analysis, Change Management, Conflict Management, Cost-Benefit Analysis, and Gap Analysis includes AS-IS and TO-BE analytical techniques.
  • 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.
  • Proficient in conducting and facilitating Joint Application Design (JAD) sessions, Interviews, Brainstorming sessions, Questionnaire, Document analysis, andFocus group.
  • Proficiency in gathering requirements and transforming them into Functional and Non-Functional specifications.
  • Extensive experience in drafting and analyzingBusiness Requirements Document (BRD), Functional Specification Documents (FSD), Software Requirement Specifications (SRS), Use Case documentation, RACI matrix (Responsible, Accountable, Consulted and Informed) and Requirement Traceability Matrix (RTM).
  • Created multiple Unified Modeling Language(UML) diagrams including Use Case, Activity, and Sequence diagrams
  • Expertise in creating Mockups andWireframesto convey the User Interface to Business users and developers.
  • Excellent understanding and experience with Scrum Framework including Ceremonies (Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective), Artifacts, Prioritization techniques (Moscow, Kano) and Estimation techniques (Planning Poker, T-shirt Size, Relative mass Estimation).
  • Expert inSQL, 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.
  • Worked with ETL developers in creating Data Dictionaries, Data Modelling Documents, Data Mapping Documents (Source to Target Mapping), and Data Profiling using ETL tool Informatica PowerCenter.
  • Good knowledge on Data Warehouse concepts such as Dimensional model, Star and Snowflake schema, Fact Tables, Data Marts, OLAP operations such as Roll-up, Drill-down, slicing, dicing, and ETL process consisting of extracting data from various sources, Data Cleansing, Transformation and loading it into the Data Warehouse.
  • Significant experience gained of Three-Tier Architecture,Service Oriented Architecture (SOA), Web Services, APIs, REST & SOAP using XML, JSON, WSDL,andUDDI, with internet protocol suites like HTTP/HTTPS.
  • Concrete understanding of SOAP and RESTful web services requests and responses in XML and JSON format respectively. Proficiency in using tools like Postman andSwaggerfor documenting and testing API’s.
  • Experienced in developingTest 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, SharePoint Enterprise, HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC).
  • Hands on experience in creating Interactive, Analytical Dashboards using Reporting tools like Tableau, Power BI, SSRS (SQL server reporting services)for decision making.
  • Experience in Hadoop Ecosystem and tools like Apache Sqoop, Flume, Kafka, HDFS, Spark, Hive, and HBase.
  • Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions
  • Knowledge of Guidewire integrationframework and various integration methods like Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.
  • Excellent Training skills, facilitation, powerpoint presentations, maintaining performance metrics, devising training documentation and communicating to users.


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

Requirements Management: JIRA, RALLY (CA Agile), Team Foundation Server (TFS)

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

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

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

ETL Tools: InformaticaPowerCenter, SSIS (SQL Server Integration Service), SSAS

Languages: HTML, SQL, CSS, XML, JSON

Databases: MySQL, 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


Confidential, Columbus, OH

Sr. Business Systems Analyst

Roles and Responsibilities:

  • Involved in project management, developing Project Plans, setting Project Schedules and milestones, scheduling tasks and activities.
  • Facilitated one-on-one interviews,JADSessions to elicitrequirements from business and technical stakeholders.
  • PerformedGap Analysis, Impact Analysis, SWOT Analysis and Cost-Benefit Analysis.
  • Proactively involved in all the Sprint Ceremonies such as daily stand-up calls, sprint planning sessions, story grooming sessions, mid-sprint reviews and sprint retrospective meetings.
  • Instrumental in implementing good Acceptance Criteria for user stories in Product Backlog with Product Owner and ensured the User Stories were created based on INVEST criteria.
  • Involved in developingScreen Mock-ups using Balsamiqto describe the interface Requirements.
  • Created a RACIMatrix to identify all relevant stakeholders in the project.
  • ExercisedJIRA forUser Story Management, Issue Tracking,andRequirement Traceability.
  • Analyzed the requirement, and discussed with the stakeholders, to identify the data sources
  • Created Data Mapping Documents for the migration of data from transactional OLTP databasesof Property & Casualty related policy and claim data to the Hadoop environment.
  • Used open sourceHDP to migrate to the Hadoop ecosystemfor both real-time and batch processing.
  • Performed data migration to Hadoop Ecosystems usingApache SqoopandApache Flumeto offload the structured and unstructured data from the relational database intoHDFS.
  • Involved increating Hive tables, loading data and writing Hive Queries as per business requirements.
  • EmployedHive QLto perform ad-hoc querying, summarization and data analysis.
  • ImplementedContinuous Integration & ContinuousDeployment (CICD)through Jenkins for Hadoop jobs.
  • Involved in software integration testing and web servicesAPI TestingusingSwagger.
  • Assisted the QA team to create a Test Suit, Test Cases, Test Scenarios and Readiness Document.
  • Involved in theUser Acceptance Testingphase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
  • Responsible forwriting feature file inCucumber for various scenarios in Gherkin format.Selenium driverwas integrated with cucumber, created Step definition file.
  • DevelopedReports/Interactive Dashboardswith different analytics views using Tableau.

ENVIRONMENT:Waterfall-Scrum hybrid, Jira 7.2, Confluence 6.2, MS Office 2016, MS Visio 2016, MS Project 2016Balsamiq, Gherkins, Jenkins,Hadoop, Apache Sqoop, Apache Flume, Apache Spark, Apache Kafka, HBase, Oozie,Hive, Pig,MySQL,HTML 5, CSS 3,Cucumber, Selenium, SwaggerandTableau 10.1.4

Confidential, Brenham, TX

Sr. Business Analyst

Roles and Responsibilities:

  • Worked closely with SMEs to identify and analyze the core requirements and features of the project.
  • Performing Gap analysis of Current state and desired state to identify As-Is business process and the To-Be system.
  • Executed one on one interviews, JAD sessions, and focus groups with stakeholders to elicit requirements. Reviewed and edited those requirements and specifications as per the feedback.
  • Conducted Brainstorming sessions with stakeholders and users to review/manage expectations and identify opportunities to improve the efficiency and productivity of the project.
  • Created and maintained User Stories by interviewing the SMEs, to capture the process flow to communicate the requirements to the development team using Rally.
  • 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 Axure RP
  • Used Unified Modeling Language (UML) to prepare Use Cases Diagrams, Activity Diagramsto make a visual representation of the gathered requirements using MS Visio.
  • Performed in-depthdata analysis toidentifying data issues in the legacy system and worked with business to develop resolutions to those issues.
  • Performed Data mapping, logical data modeling, ER diagrams and used SQL queries to filter data.
  • 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 Policy Center Module
  • Coordinated the execution of Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) using the HP Quality Center.
  • Generated reports and created dashboards using Tableau to keep the stakeholders up to date.

ENVIRONMENT:Scrum, Rally, Guidewire Insurance Suite,Microsoft Office Suite, Microsoft Visio, SharePoint,Axure RP, Web Services, SOAP, SOA, HTML, XML, Java, JScript/jQuery, Postman, JSON, HP QC, Oracle 11g,and Tableau.

Confidential, Boston, MA

Business Systems Analyst

Roles and Responsibilities:

  • DefinedProject Scope, Risks based on Vision Documents and developed Project Timelines for on-time delivery.
  • Assisted project manager in keeping track of project progress and status, delivered high-level estimates for delivery schedule and resource allocation.
  • Conducted Interviews with stakeholders from both the business side and IT side to elicit high-level requirements and estimate project feasibility.
  • Executed elicitation techniques to gather detailed requirements, and documented business requirements in artifacts like Business Requirements Document (BRD), and Functional Requirement Document (FRD).
  • Ensures data warehouse business requirements as the foundation for database design, data extraction,and analysis.
  • Created detailed UML models including use case diagram, activity diagram, and sequence diagram while working with software developers to make sure that the applications fit into the requirements.
  • UsedRequirementTraceability Matrix intensively for the business processes and expected changes.
  • Maintained project documents and shared important links and tutorials, with the team using SharePoint.
  • Identified various source systems, types of data and created Data Flow diagrams. Assisted Data modeling process by creating conceptual and Snowflake Schema logical database model.
  • Integrated various Online Transactional Processes (OLTP) to the Online Analytical Processes (OLAP) by using Informatica PowerCenter.
  • Assisted in Creating Data MappingDocument and worked with the team on normalizing, data schema, data cleansing.
  • Used Informatica PowerCentertools like repository manager and designer to generate source to target mapping.
  • Extensive working knowledge of Informatica power center for Extracting, Transforming and loading the Data
  • Worked with QA team to design and developTest Plansand Test Cases to perform User Acceptance Testing (UAT).
  • Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Defect Review meetings during and after the QA Test process.
  • Was involved in using Power BI for effective reporting to provide Business Intelligence (BI) analysis critical to decision making.

ENVIRONMENT:Waterfall, SharePoint, MS Visio, MS Office suite, Informatica PowerCenter, Informatica Data Quality, ETL, OLAP, OLTP, Erwin, Rally, XML, SOAP, WSDL, WADL, HP QC, MSSQL Server, andPower BI

Confidential, Hartford, CT

Business Systems Analyst

Roles and Responsibilities:

  • Assisted the project managers in developing a project plan that included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.
  • Created Business Process Workflow diagrams of Current and Expected System, using MS Visio and makes sure that both business and technical teams understand the process.
  • 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.
  • Responsible for drafting the artifacts such as Business Requirement Document(BRD), Functional Requirement document(FRD) and Software Requirement Specification (SRS).
  • Created and maintained RTM (Requirements Traceability Matrix) to trace requirements to test cases.
  • Analyzedanddrafted Service Detailed documents from Web Service Description Language (WSDL).
  • Assisted Quality Assurance team in APItesting and assisted in technical writing workshops.
  • Assisted Quality Assurance Team with Test Cases, Test Plans, andTest Scenariosalso facilitated UAT.
  • Prepared project-related presentations to provide a clear view of the tasks to be performed and targets to be met.
  • Created User Manuals with a detailed list of parameters and system responsive screenshots.

ENVIRONMENT:Waterfall-Scrum Hybrid,Share Point Enterprise, JIRA, MS Visio, MS Project, SOA, RESTful, JSON, XML, SoapUI, MS Office(MS Word, MS Excel, MS PowerPoint), and Oracle 11g


Business Systems Analyst

Roles and 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.
  • Extensively used INVEST criteria to write User stories along with Product owneralso 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, and Sprint retrospective.
  • Liaised between the product development team, cross-functional units, and Project management team,identifying business process gaps to manage risk ensuring project success.
  • Created Mock-up and wireframes 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.
  • 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.
  • Generated reports and created dashboards using Tableau to keep the stakeholders up to date.

ENVIRONMENT:Waterfall-Scrum hybrid, MS Office, MS project, Mockup-screens, MS Visio, MySQL, Rally,andTableau.


Business Analyst

Roles and Responsibilities:

  • 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 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.
  • Developed Mock Screen and Wire Frames and presented as DEMO session to the Primary Stakeholders.
  • Understood 3-Tier Architecture, SOA, Web Services, Application Servers, API, Web Servers.
  • Created and maintained Requirements Traceability Matrix (RTM) using HP QC tool.
  • Created ad-hoc reports using MS-Excel 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

ENVIRONMENT:Waterfall-Scrum hybrid, HTML, CSS, JS, MS Office, MS Visio, SQL, HP QC, and IBM Cognos


Jr. SQL Developer/ Jr. Business Analyst

Roles and 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 have assisted Sr. SQL Developer in creating them with accurate relations for the RDBMS
  • Comprehensively involved in development and creation of Centralized Database for the e-commerce website and application which could be modified and further enhanced in the future
  • Facilitated Joint Application Development sessions (JAD), Brainstorming, with stakeholders, subject matter experts (SMEs) and developers to identify the needs and refine the work done
  • Gathered requirements from stakeholders to define the scope andbridged 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).

ENVIRONMENT:Waterfall, MS Office,Javascript, jQuery, MS project, Mockup Screen, and PL/SQL 5.1

Hire Now