SUMMARY

• 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.

TECHNICAL SKILLS

• 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

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. Business Analyst

Responsibilities:

• Conducted working sessions with Business and technology teams to capture requirements for Deposit products like Savings, Checking, CD, CAA, and Package Accounts, Internal money movement (Single Immediate Transfers, Single Future Transfers, Recurring Transfers etc.)
• Conducted Gap Analysis of As Is & To Be State for new Online Banking and Money Movement Platform.
• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Interacted with the testing team while developing the functional test cases and regression test cases.
• Designed Document Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Tested access control of Siebel call center application by logging using different user ID s and verified views based on responsibilities.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• Interacted with customers in call center environment to validate fraud claims
• Developed a thorough knowledge and maturity in all the phases of SDLC and familiar with industry standard best practices & frameworks such as RUP (Rational Unified Process), AGILE & Lean
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases (automated/manual), used QTP for automated testing.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Used Agile methodology of development to improve customer satisfaction by rapid & continuous delivery of S/W
• Participated in test planning, writing test cases/scripts within PEGA PRPC and correct the responses according to the erroneous outcomes.
• Involved in designing application interface using Pega BPM
• Conducted workshops for Use Case writing with User experience groups .
• Worked as Track Lead for the Money Movement Platform. Responsibilities included creation and maintenance of Requirement Artifacts and maintenance of Issue tracker on the program management site through SharePoint and other collaboration tools.
• Created Use cases for the various functionalities of Deposit Products.
• Worked extensively on Rational Requisite Pro to create Requirements specification.
• Conducted training for new team member for the Project

Environment: MS Office Suite 2007, MS Visio 2007, SQL, Agile/Scrum, HTML, XML, WinRunner, Load Runner, Mercury Quality Center 9.0, RUP, UML.

Confidential, Woodland Hills, CA

Business Analyst

Responsibilities:

• 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, Atlanta, GA

Business Analyst

Responsibilities:

• 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, LoadRunner, Quick Test Pro

Confidential, Columbus, OH

Business/QA Analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Interact and negotiate with Vendors to complete the tasks related to data conversion
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Lead team in iterative approach of AGILE development with all the teams members (Requirement, Development and QA teams) reporting to me for issue resolution and each iteration was 3 weeks long.
• Prepared System Requirement Documents after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Organize requirements into high level Use Cases and low level Use Case Specifications and modelled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Creating, Document Flow Diagram, Context Diagram and Activity diagrams using UML.
• 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.
• Developed and maintained the project plan using MS Project
• All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Plans in MS Word for Manual Testing, System Testing, Integration Testing
• 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).
• Prepared graphical depictions of Use Cases, Business process diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Performed Requirements Traceability and managed changes to requirements for this application using Rational Requisite Pro.
• Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Manually tested and GTS modules using Quality Center.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, MS Project, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, Agile, RUP, MS Access, Quality Center, C#. NET, ASP.NET, Business Objects, Autosys, TestDirector, LoadRunner.