We provide IT Staff Augmentation Services!

Sr.business Analyst Resume

Phoenix, ArizonA


  • More than Seven years of IT experience with expertise in Business/QA Analyst in Finance/Telecom and Insurance Domain.
  • Extensive success in translating system requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
  • Experience designing and developing SQL statements and queries for Oracle Sybase and SQL Server 2000 database.
  • Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Excellent knowledge of the out - of-the-box capabilities of Siebel Call Center, Siebel Help Desk, Siebel Service Request Management, Siebel Order Management, Siebel Event Management, Siebel Contracts Management & Siebel Campaign.
  • Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
  • Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
  • Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
  • Ability to gather system and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
  • Extensive experience in conducting Joint Application Development (JAD) sessions.
  • Expertise in developing Master Validation test plan, Validation Protocols, Requirements Traceability Matrix (RTM), Gap analysis, remediation plan, FDA Audits, SOP’s.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
  • Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
  • Proven expertise in creating test plans, UML diagrams, flowcharts, screen mockups and systems requirements specifications.
  • Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
  • Solid Experience in developing Scope/Vision Documentation and Project Plan.
  • Efficient in converting the systems database from Sybase to oracle & vice versa.
  • Highly motivated, result oriented professional with a short learning curve and strong communication skills.


Software/Hardware: ERWIN, ETL: Ascential DataStage (7.x, 6.x, 5.x), Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, Business Objects, Micro strategy, Erwin 4.x, C/C++, Java SE 1.4, TURBO PASCAL 7.0, VB.Net, HTML, Agile/Scrum, COBOL, SQL Server, SOA, SAP SD, MySQL, Oracle 8i,Visio, Sybase ASA (6 - 9).ASP/ASP.net, PHP, Microprocessors 8085 & 8086, Unix, MVS, MS Windows/95/98/NT/2000/XP, MS DOS, MS Office 2000


Confidential, Phoenix, Arizona

Sr.Business Analyst


  • Worked on various Billing Center User Stories(Account - Account Evaluation, Account transfer, Delinquency, Disbursements, Distribution, Authority limits, Payment Plan, Payment Processing, Payment Request, Edit payment)
  • Investigated claims reports by reviewing suspicious transactions.
  • Worked on the Policy Center - Billing Center Integration User Stories(Get Payment Plans, Get Policy Contacts, Reinstatement, Renewals)
  • Worked on various policy center configuration User Stories (Account Summary, Policy, Quote Number, Cancellations, Create Submission, Bulk Producer change (buy and sell), Cancellations, Create submission, User Desktop)
  • Gathered user requirement specifications from senior-level managers
  • Configured Roles and Permissions in the GW system.
  • Built and executed test plans/ test cases to support the validation of software and business requirements of in-house development utilizing Excel and SharePoint.
  • Utilize the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire ClaimCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC).
  • Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines products.
  • Worked on various Guidewire integration concepts like Messaging, Batch Processes, Web Services.
  • Hands on experience with Guidewire PolicyCenter and ClaimCenter (Worker's Compensation Claims, General Claims) upgradation to v9.
  • Configured screen layouts, business logic, business rules, and operation parameters such as roles, permissions, user attributes, and regions as well as created new screens in Guidewire Studio as needed.
  • Involved in Guidewire Corporate on Guidewire PolicyCenter, Worked on Commercial Lines Property and Casualty Insurance.
  • Validated policy and claim data to assure every details are populated correctly from the legacy system WINS to Guidewire ClaimCenter.
  • Led requirement gathering elicitation through open-ended discussions, brainstorming, and prototyping for the development and implementation of a new Guidewire PolicyCenter 7.0.5 suite.
  • Mainly responsible for working in migration from legacy system to Guidewire system.
  • Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
  • Performed user acceptance testing (UAT) to ensure reports operated effectively.
  • Responsible for processing claims of policy holders in an efficient and timely manner
  • Conduct detailed analysis of claim forms to determine values in accordance with the law
  • Worked with Guidewire Prod support team to resolve the OOTB defects(Change Payment plan, Payment method, Renewal Payment, Delinquencies)
  • Worked on Underwriting User Stories( Underwriting cancellation, Renewals)
  • Involved in creating the Requirement Management Plan(RMP), Requirement templates.
  • Created Job Aides, Manuals, Process flows during the stabilization sprints
  • Worked with the Design team on bill layouts.
  • Used HP Quality Center for logging defects (Defect Management System).
  • Facilitated Sprint Planning and Retrospective meetings.
  • Assisted Quality Assurance (QA) in User Acceptance Testing.
  • Was involved in the various Customizations on the Policy Center Billing screens.
  • Worked on PPM, Rally to manage BA team resources
  • Facilitated meetings with the Guidewire Dev Team and Mercury Specific team to understand Edit Payment Schedule, Refactoring Invoices, PC-BC Status.
  • Worked closely with the Policy Center team on implementing the Multiple Premium types and Renewal offer.
  • Assisted PM’s in creating Task list for Sprints.
  • Worked on the various billing Integration points.
  • Worked with the Business on the eligibility rules for the payment acceptability.

Environment: HTML, XML, SQL, Rational Suite (Requisite Pro, Rose, Clear Quest, ClearCase), Excel, Access, MS-Word, MS-Outlook, MS-Power Point

Confidential, Woodland Hills, CA

Business Analyst


  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules
  • Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created system requirements document & functional requirements document (FRD).
  • Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
  • Involved in QA and testing procedures introduced into teams for both COTS and Legacy Systems.
  • Align design and technical requirements with COTS reporting database.
  • Developed and managed the formal SDLC implementation using the Lean/Agile Methodology.
  • 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 in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
  • Performs system administration duties related to the content management system. This would include developing process flows required for the development of workflows within Stellent that tracks all CMS-mandated content contributions.
  • Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
  • Created Detailed Use Cases for the Web interface applications, Screen Mockup’s for the project.
  • Conducting JAD Sessions to resolve open issues, change requests so that the application meets the system requirements and dead lines
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
  • Interacted with State Street Business owners to understand the current process and to provide suggestions to optimize using Autosys and Datastage.
  • Extensively involved in the automation of Regression Test Cases by scripting.
  • Create and maintain requirements, test cases and defects in Mercury Quality Center
  • Extensively used tools such as Rational Rose, Rational Requisite Pro, UML, MS Visio, MS Project, MS Office, MS Access
  • Responsible for managing the documented system requirements and Requirements Traceability Matrix.
  • Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
  • Automate and integrate data collection processes from databases using SQL and MS Access.
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
  • Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing.
  • Prepared system Test Plan and scenarios for Test Scripts.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
  • Responsible for providing analytical support in the Design, Development and Implementation of Project.

Environment: Rational Enterprise Suite (Rose, ClearCase, ClearQuest), RUP, MS Office, MS Access, Visual Basic, SQL, SQL Server, Oracle, MS Project, WebLogic, MQ Series, Quality Center, Quick test Pro, Adobe Photoshop, Agile,, Web Forms, LoadRunner, WinRunner, DOORS, Project Management.

Confidential, Cincinnati, OH

Business/Data Analyst


  • Gathered high-level requirement for all the external projects in a release.
  • Involved in Risk Assessment for each project.
  • 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.
  • Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
  • 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.
  • Created functional requirement documents for the impacting projects
  • Performed criteria table updates for each project.
  • Updated the impacted MS Access tables.
  • 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.
  • Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules
  • 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: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector.

Confidential, Atlanta, GA

Business Analyst


  • Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.
  • Gathered requirements and modeled the data warehouse and the underlying transactional database
  • Continued call Center reporting enhancements with integration from CCE to Microsoft Dynamics CRM for screen pop and to insert calling/called party information into customer record.
  • Worked on a Chordiant framework, a Java based web application used by the call center associates.
  • Involved in creation of high Level Class structure, Workflows and Rule sets in Pega.
  • Developed use cases, data mapping, screen mockups during the functional specifications.
  • Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
  • Performed Business Process Mapping and performed AS IS and TO BE analysis
  • Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
  • Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
  • Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
  • Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
  • Created Use Cases for the Web interface applications, UI Mockup’s for the Functional Requirements.
  • Automated and executed regression test cases using Quick Test Pro (QTP)
  • Managed and organized requirement coverage, Test Case Management and Defect Management using Mercury Quality Center.
  • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.

Environment: Rational Clear Case,Doors, IBM WebSphere, Quality Center, XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, MS Access, DB2, Sybase, SQL Server Reports, WinRunner,

Hire Now