We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Columbus, Oh

SUMMARY:

  • Sr. Business Analyst with 8 year’s industry experience in business data modelling, software requirement analysis, process modelling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML.
  • Extensive experience in business Analysis modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
  • Hands on experience and expertise in Guidewire PolicyCenter implementation and integration by leveraging Agile Methodology.
  • Extensive experience in health care/Insurance domain.
  • Insurance experience includes Personal Property and Casualty P&C and Commercial Automobile Product knowledge, Reinsurance for Commercial Property and Casualty, Group and Life Insurance Systems
  • Interviewing Subject Matter experts and carefully recording the Business requirements in Agile methodology
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • 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 with extensive experience in all facets of property and casualty underwriting in a broad range of businesses and industries.
  • Worked with 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 with end-user/clients/stake holders and the IT group.
  • Experience in Agile Methodology, XP (Extreme Programming), Six Sigma.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • 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
  • Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
  • Exposure to Client/Server, Web Application developmental tools and Software development and design.

TECHNICAL SKILLS:

Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP,CVS,TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA,DB2. Windows, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Rational XDE, DOORS, Products Guidewire PolicyCenter, Cobol, RequisitePro, CaliberRM, Crystal Reports, various NIKU products, C, C++, SharePoint, Docushare, BASIC, Intermediate level-Visual Basic.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Business Analyst

Responsibilities:

  • Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
  • Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
  • Created User Interface Documents (UID) of prototypes and wireframes of the software solution, Guidewire Policycenter, to help designing user interface.
  • Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
  • Worked on Commercial lines Property and Casualty P&C Insurance including both policy and claim processing and reinsurance.
  • Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing agile methodology.
  • Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
  • Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
  • Involved in every Sprint that covered Elaboration, Configuration and Testing of the Guidewire PolicyCenter following AGILE approach
  • Developed test plans with QA team and helped test every scenario using Mercury TestDirector Tool for system testing
  • Supervised staff of 7 Casualty Specialists conducting the investigation, evaluation and disposition of coverage, liability and damages on 1st and 3rd party property and casualty P&C claims.
  • Created cross system data flow diagrams and flowcharts to depict the integration dependency of other applications with Guidewire PolicyCenter
  • Used Test Director, PL/SQL for testing the application and develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
  • Efficient in MS Project for planning and status reporting.
  • Selling Professional Liability, Benefit Lines and other Property and Casualty P&C products to physicians, hospitals and other related health care entities.
  • Collaborated with External Auditors and documented SOX compliance requirements
  • Worked extensively in Data Analysis, Data Reconciliation and Data Mapping for ETL process
  • Exposed to Agile methodology and Solid experience in calculation of the Greeks (Delta, Gamma, Vega, Theta and Rho) in the simulation test of the system.
  • Used MS Visio for Process modeling and Business Process flow diagrams
  • Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
  • Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
  • Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems test plans with QA team and helped to develop test cases for system testing,
  • Integration testing and performance testing.
  • Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle

Environment:: Windows XP, Business Objects, MS Excel, XML Word, Visio, power point, SQL, DB2, SAS database, MS Project, MS PowerPoint, Visio, Rational Rose.

Confidential, Woodland Hills, CA

Business Systems Analyst

Responsibilities:

  • Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
  • Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
  • Managed cutover of master data from existing information system into SAP system. Created and performed program specifications for scripting to extract and prepare data for import into SAP database.
  • Managed cutover of existing business processing done in outgoing information system to SAP system at go-live.
  • Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
  • Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
  • Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Involved in multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
  • Experience on Guidewire PolicyCenter for Commercial Insurance products.
  • Created source table definitions in the Data Stage Repository by studying the data sources.
  • Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Expertise experience in Guidewire PolicyCenter and Billing Center configuration and Integration and also in Workers Compensation and Personal Insurance modules in Guidewire Policy Center and also in commercial Property and Casualty and Personal Lines Insurance experience with national carriers (as contractor).
  • Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
  • Run the SQL queries using TOAD and SQL Navigator.
  • Used XML for building and parsing of Application Configuration file.
  • Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
  • Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
  • Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
  • Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

Environment:: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), OBIEE, Microsoft Office Products (Word, Excel, PowerPoint), Visual Basic, SQL, SQL Server, Oracle, C#.Net, XML

Confidential, Kansas City, MO

Business Analyst

Responsibilities:

  • Capture of Business Features and delivery of Business Requirements Document.
  • Capture of Functional Requirements and delivery of Functional Requirements Specification.
  • Capture of User Interface Requirements and delivery of User Interface Requirements Document.
  • Capture of Reporting Requirements and delivery of Reporting Requirements Document.
  • Capture of Non-functional Requirements and delivery of Non-Functional Requirement Document.
  • Solid experience in property and casualty claims handling and production.
  • Completed training on GuideWire ClaimCenter 8.0, PolicyCenter 8.0 & BillingCenter 8.0 from GuideWire Certified Member.
  • Worked on GuideWire ClaimCenter implementation and Upgrade projects.
  • Worked on GuideWire PolicyCenter & OneShield Policy Admin System implementation projects.
  • Worked on Renaissance P&C Insurance Billing System implementation projects.
  • Expertise in using the testing tools such as Mercury Quality Center (QC)/Test Director and Quick Test Pro (QTP).
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules
  • Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
  • Performed extensive Requirement analysis and developed use cases and workflows.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
  • Played a key role in the planning, User Accepted testing, and Implementation of system enhancements and conversions.
  • Participated in integrating Prudential’s purchase of all states Variable Annuity business. This effort entailed interviewing technical and senior management staff
  • Implement and maintain Property and Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Capture and Formulation of Business Rules and delivery of Business Rules Templates
  • Met with client groups to determine project scope, requirements and plan. Utilized Rational Unified Process (RUP) to configure and develop process, and create BRDs.
  • Analyze business requirements and segregated them into high level and low level Use Cases, Activity and Sequence using Rational Rose according to UML methodology.
  • Derived Functional Requirement Specifications based on User Requirement Specification. Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.

Environment: UML, RUP, Mainframes, COBOL, JCL, GuideWire PolicyCenter, Db2, Oracle, Rose, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

  • Gathered high-level requirement for all the external projects in a release.
  • Involved in all stages of testing the Auto & Home Insurance application.
  • Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
  • Experience on Guidewire PolicyCenter for Commercial Insurance products.
  • Gathered requirements for business process flow and on screen flow for wizards driven products from products SME's and Sales people and created Requirements documents to implement in Pega PRPC.
  • Created Business Rules Document and Requirement Traceability Matrix to track the requirements for Pega PRPC.
  • Communicate with Customer Service on ACORD Forms design and other technical problems
  • Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
  • Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
  • Worked extensively with MS Excel and MS access
  • Developed test plans with QA team and helped to develop test cases for system testing,
  • Integration testing and performance testing.
  • Assigned tasks among development team, monitored and tracked progress of project following agile methodology.
  • Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
  • Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
  • Reviewed test results and coordinated with testing and development team to correct the issues.
  • Developed timelines for project delivery, and managed projects/resources
  • Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
  • Responsible for preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans. Closely coordinated with 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.
  • Interacting with the developers on resolving the reported bugs and various technical issues.
  • Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

Environment:: Rational Rose, Rational RequisitePro, DB2, Rational Clear Quest, Rational manager, Rational Administrator, DOORS, SQL, VB.Net, Oracle, MS Office, IBM Business Modeler, SEI, UML.

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

  • Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
  • Wrote Business Requirements, analyzed them and tested them.
  • Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
  • Worked with user story to respond faster and with less overhead to rapidly changing real-world requirements in an Agile environment
  • Analyzed trading partner specifications and created EDI mapping guidelines.
  • Worked with a cross functional team including Sales and Marketing
  • Conducted RAD sessions for the report users, requestors, and the developers.
  • Created Business Rules Document and Requirement Traceability Matrix to track the requirements for Pega PRPC.
  • Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
  • Examined, analyzed and model Test plans, Use Case Model cases and Test procedures based Agile methodology.
  • Coordinated with the developer, on day-to-day basis, during the development process.
  • Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
  • Wrote Test plan and Test cases for the Integration testing and system testing.
  • Did Integration Testing, GUI testing, Smoke and Sanity Testing, and Acceptance testing in the new builds for Basic Functionality Checking.
  • 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 with the actual report against the Data mart (Oracle).
  • Helped with Data Mapping between the data mart and the Source Systems.
  • Worked as a liaison between the Business and Technology Department.

Environment:: SQL Server, Windows, HL7 v2.X,Crystal Reports, Oracle, Mantis Defect Tracking, UML, MS Office, MS Visio.

Hire Now