We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

Nyc, NY


  • Over 9 Years Professional Experience as Sr. Business System Analyst wif strong noledge of Property and Casualty, life insurance and Annuities.
  • A highly skilled Senior Business System Analyst of multi - disciplined business analysis expertise encompassing Life Insurance/Annuity business application development and maintenance.
  • Extensive experience in business Analysis modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
  • Extensive experience in Life Insurance Annuities domain.
  • Insurance experience includes Personal Property and Casualty P&C and Commercial Automobile Product noledge, Reinsurance for Commercial Property and Casualty, Group and Life Insurance Systems
  • Strong experience in RUP Business Modelling process. Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Understanding and strong awareness of pragmatic data quality and data governance policies, procedures and guidelines.
  • Experienced in reporting defects using defect tracking tools such as HP ALM and JIRA.
  • Managed the Story Board for the team and prepared it before the iteration/sprint planning meeting.
  • Stored and modified requirements in MS - Word and using Test Director.
  • Reduce the overall lead time of deliverable by adopting the Agile methodology largely by quick analysis, lean documentation and enabling synergy between business and development teams.
  • Insurance experience includes Personal Property Casualty and Commercial Automobile Product noledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
  • Interviewing Subject Matter experts and carefully recording the Business requirements in Agile methodology.
  • Involved in Production Support / Design and Development / Future initiatives.
  • Extensive experience in analysing and requirements gathering and writing system functional specifications including use cases.
  • Experience wif the ACORD standard Life, Annuity data model and data collection requirements, form models and archival stipulations.
  • Marketing and placing international property and casualty coverage for middle market clients; includes day-to-day needs for local placements, policy corrections and policy interim inquiries.
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Extensively used SOAPUI for testing web services.
  • Proficient in using UML in behavioural, structural and architectural modelling - in creating Use Case, State, Activity, and Class and Sequence diagrams using Rational Rose.
  • Strong experience in RUP Business Modeling process and expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM's Rational Rose.
  • A resourceful and multi-talented Commercial Insurance Professional wif extensive experience in all facets of property and casualty underwriting in a broad range of businesses and industries.
  • Worked wif Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
  • Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions wif end-user/clients/stake holders and the IT group.
  • Experience in Agile Methodology, XP (Extreme Programming), Six Sigma.
  • Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
  • Provide postproduction support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.
  • Excellent in Business proposal Risk Assessment. Highly TEMPeffective management and organizational skills wif ability to prioritize.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.


Sr. Business Systems Analyst

Confidential - NYC, NY


  • Worked as business systems analyst in application development for new products (term life insurance, whole life insurance, universal life insurance and variable universal life) and application enhancements for existing product offering scenario.
  • Worked wif the account managers, managements, and report requestors to gather requirements, get report requests.
  • Worked on writing Business Requirements, analysed them and tested them.
  • Owned the entire reporting process. Interacted wif the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
  • Worked wif user story to respond faster and wif less overhead to rapidly changing real-world requirements in an Agile environment.
  • Involved in developing processes and controls for new Business Automation Team.
  • Applied Six Sigma principals to Life and Annuity to reduce errors and time to issue.
  • Developed program specifications for various insurance applications handling life, disability income, and annuity policies.
  • Worked wif a cross functional team including Sales and Marketing.
  • Involved in conducting RAD sessions for the report users, requestors and the developers.
  • Planned and Managed User documentation, training and Production Support.
  • Examined annuity applications and supporting documents for correctness and completeness.
  • Involved in complete Insurance life & annuities Processes: Application administration, Policy administration, Agent Commissions and Statements, Claims Management.
  • Worked wif staff to migrate business processes from paper-based processing to an electronic process and provided training as needed on software applications and working in a networked environment.
  • Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
  • Involved in creating a User Guide and Operations Guide for the Annuities Group and IT.
  • Held regular meetings wif the system architects, developers, database quality testers, Life insurance annuities SME during the entire project to assure that the critical as well as minute details of the project were discussed, and issues were resolved beforehand.
  • Performed Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
  • Worked on creating and maintaining Narrative Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Facilitate meetings wif development, stakeholders, and internal customers to explore potential solutions for the implementation of Policy Administrative System (PAS) in various states.
  • Serves as a liaison between Information Technology department, Project Management team and development team in developing Actuarial Modelling System and its joint venture business on Life Annuity and Pension Lines of Business.
  • Worked on preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans. Closely coordinated wif both business users and developers for arriving at a mutually acceptable solution.
  • Documented and delivered Functional Specification Document to the project team.
  • Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
  • Create and revise point of sale forms for annuity and insurance products.
  • Worked wif annuity and insurance business partners to support the drafting and management of annuity point of sale forms.
  • Performed data mapping of the entire new business module and performed exhaustive analysis towards integrating the new life insurance products wif the existing products setup.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Worked on creating and managing project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
  • Worked on preparing need Analysis Documents of the requirements gatheird through JAD sessions.
  • Examined, analysed and model Test plans, Use Case Model cases and Test procedures based Agile methodology.
  • Coordinated wif the developer, on day-to-day basis, during the development process.
  • Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results wif the actual report against the Data mart (Oracle).
  • Helped wif Data Mapping between the data mart and the Source Systems.
  • Worked as a liaison between the Business and Technology Department.
  • Worked on Test Cases in Mercury Quality centre that would test various Test scenarios.
  • Involved in conducting Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Involved in writing Test plan and Test cases for the Integration testing and system testing.
  • Worked on Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.

Business Systems Analyst

Confidential - Wooster, OH


  • Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
  • Involved in gathering user and business requirements through open-ended discussions, brainstorming sessions and role-playing. Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
  • Worked on business requirements defining the business need and proposed solution, complete wif visuals and a sound business case.
  • Worked for a project to customize and integrate a Business Process Management (BPM) solution.
  • Involved in performing GAP Analysis of the AS-IS system and the TO-BE system using models for better understanding of the business process.
  • Involved in rebuilt reporting and metrics for the business group when they moved to a new version of an automated work distribution system (AWS) that functioned differently TEMPthan the previous system.
  • Performed custom data conversions and developed custom software for risk management applications including commercial insurance, life insurance, etc, Perform all data field mappings.
  • Coordinate User Acceptance Testing (UAT) and assist in Post-Production Support.
  • Assigned tasks among development team monitored and tracked progress of project following Agile methodology. Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
  • Prior to my current position I was working wif annuity payment specialist responsible for processing life insurance and annuity contract wifdrawal requests wif a high level of accuracy.
  • Review business manuals and requirement document (BRD) to summarize system-specific business rules and other operating conditions.
  • Created and managed User Stories on JIRA.
  • Created concise documentation which included FRD documentation, generating reports wif tableau, making graphical charts, helped in Business cases documentation.
  • Responsible for the management of two Application portfolios, both central to client business, involving the maintenance and production support wifin a mainframe environment.
  • Worked on designing and writing the Annuity Basics training manual, Administrative Services procedures manual, and the department orientation manual.
  • Crafted BRD and FRD artefacts as part of BA deliverable to ensure system changes are clearly defined and the existing process remains uneffected.
  • Provided implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
  • Worked on performing data mapping of the entire new business module and performed exhaustive analysis towards integrating the new life insurance products wif the existing products setup.
  • Responsible for cost estimation and timelines for various Business Intelligence reports
  • Execution of PL/SQL on oracle table in order to view successful transaction of data.
  • Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau.
  • Facilitated JAD sessions wif management, development team, users and other stakeholders to refine functional requirements.
  • Authored progress and completion report which were then submitted to project management on a weekly basis in MS project.
  • Identified various frequently used modules wifin the application as well as the peak user volume for load testing purposes.
  • Collaborated wif Quality Assurance Analyst in Automated and Manual Black box testing.
  • Worked on Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Involved in developing strategies wif Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing. Helped in creating end user manuals and procedure manuals.

Business Analyst

Confidential - Charlotte, NC


  • Involved in physical/logical data modelling; metadata documentation; user documentation; and production specs.
  • Involved in identifying business rules for data migration and Perform data administration through data models and metadata.
  • Involved in gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
  • Worked on Data mapping testing by writing complex SQL Queries using WINSQL.
  • Attended user interviews, gatheird requirements, analysed the requirements by using Rational Rose, Visio and Requisite pro - RUP Analysed the requirements and segregated them into high level and low-level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
  • Involved in creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
  • Involved in implementing and maintaining Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Review and apply funds received for annuity policies in a timely matter.
  • Involved in the extraction, transformation and loading of the source data to the target.
  • Worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
  • Serves as a liaison between Information Technology department, Project Management team and development team in developing Actuarial Modelling System.
  • Involved in preparing Business Analysis Plan and Functional Requirements document for Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
  • Involved in implementing and maintaining Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Worked on data validation and data cleansing to improve data quality and accuracy.
  • Worked on Excel using pivot tables, pivot charts, Vlookups & conditional formatting resulting in customized reporting.
  • Worked on User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
  • Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting and data manipulation.
  • Worked on the data warehouse project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analysed.
  • Involved in preparing test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
  • Involved in data flow diagram to illustrate where data originates and how data flows wifin the Enterprise Data warehouse (EDW).
  • Worked on systems requirements into technical specifications utilizing UML and RUP methodology.
  • Involved in Data Migration from MS SQL server, Oracle, PeopleSoft, My SQL and Progress SQL to Teradata.
  • Involved in writing Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
  • Worked on functional requirements documents FRD by interacting wif development team for improving client's legacy system.
  • Worked on documentation for Agile methodology for implementation wif a very water-fall-centric development team.
  • Involved in creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
  • Worked on requirements document for Commercial Auto, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
  • Involved in implementing data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
  • Involved in developing and maintaining sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
  • Involved in developing small applications wif Teradata at the backend.
  • Involved in JAD sessions and translated them into system Requirements. Suggested measures and recommendations to improve the current application performance of the system.
  • Worked on SQL queries for querying data against different data bases for data verification process.
  • Worked on test cases and test scripts for the User Acceptance Testing.
  • Involved in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

Business Analyst

Confidential - Cincinnati, OH


  • Worked wif all stakeholders and contributors to identify, prioritize and coordinate continuous process improvement activities.
  • Involved in developing and maintaining the Project Schedules, including Deliverables, Milestones and Resource Assignments.
  • Defect management for the different iterations of testing for the Collections and Disbursements module for a Property and Casualty Insurance Company.
  • Involved in audits of year-end Common Area Maintenance (CAM), insurance and property tax reconciliations.
  • Involved in implementing applying standard processes for scope change management, risk management, issue management, quality assurance and project communications.
  • Worked on action plan, meetings and analysis regarding topics, often including key business stakeholders and senior management.
  • Ensured project close TEMPeffectively through production turnover, documentation of learning and provision of feedback on project resource performance.
  • Coordinate Risk Management (establish monthly risk management reviews, record risks and mitigation strategies, ensure risk management strategies are implemented).
  • Involved in commercial (P&C) Property and Casualty and Personal Lines Insurance experience wif national carriers.
  • Involved in project budgeting, project resource planning, project scheduling, risk analysis and management.
  • Involved in web-based questionnaires for specific lines of business in Quest (i.e. Property & Casualty and Financial Lines in addition to Workers' Compensation).
  • Assessed the status of the organization to determine the scope of the application and developed Process flows, Business rules, Page flow and User Guides.
  • Involved in creating a vision document to explain user demographics, profiles, environments and requirements and created a Business Glossary that defined the terms used during modelling.
  • Worked on designing business models that served to identify requirements and communicate information between teams.
  • Worked on business use cases and activity diagrams to represent different workflows and associations.
  • Involved in creating Business Flow Diagrams, Data Flow diagrams, UML Activity diagrams, Sequence diagrams, and USE cases diagrams using MS VISIO.
  • Analysis of business requirements and system requirements of the client and also for Property and casualty (P&C) modules.
  • Performed GAP and Risk analysis of existing system and evaluated benefits of new system.
  • Utilized RUP to configure and develop process, standards, and procedures.
  • Worked on documentation for training and Help Desk teams.
  • Implemented and monitored Individual Development Plans focusing on total performance, including both quality and productivity.
  • Involved in creating reports for business analysis purposes using Crystal Reports and Microsoft Excel.
  • Involved in generating Test cases for (P&C) property and casualty Insurances for Different Levels of Business.

Business Analyst

Confidential - Harleysville, PA


  • Involved in analyzing the business process, creating requirements documents, maintaining vision documents, supplementary specification documents, and developed use cases.
  • Worked on Property and Casualty insurance company along wif the Underwriter. Strong understanding of rating in Property and Casualty.
  • Involved in managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
  • Established a RUP (Rational Unified Process) centric business analysis methodology.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Involved in maintaining and filing the company reinsurance claims and providing a financial report to the management team.
  • Responsibility included modifications to a customer's mainframe system to support new product features or regulatory requirements and, in some cases, involved a system upgrade.
  • Involved in designing business requirement & systematic approach based on project scope and SDLC.
  • Worked on business requirements and system requirements of the client and also for Property and casualty modules.
  • Proficient working noledge wif CMM Level and ISO (Insurance Service Office) standard guidelines.
  • Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
  • Involved in translating business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
  • Involved in interviewing Business Users to gather Requirements and analysed the feasibility of their needs by coordinating wif the project manager and technical lead.
  • Worked on the data-mapping by verifying various accounts details in various banking mainframe regions using test scripts in Quality Centre & filling defect logs if any.
  • Attended User Interviews and Work Shops to gather accurate Business Requirements.
  • Involved in JAD sessions allowing different stakeholders to communicate their perspective wif each other and resolving issues to come to a quicker agreement.
  • Involved in preparing High-Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyse and document business data requirements.
  • Involved in JAD sessions wif end users, development and QA teams. Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
  • Involved in developing UML Use Case models using Rational Rose, workflow and Screen Shots for the application.
  • Worked on RUP analysis model using object-oriented design concepts that include entity classes, use Case diagrams and Sequence diagrams using rational Rose to enable developers and stakeholders for a clear comprehension of the business process.
  • Involved in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

Hire Now