SUMMARY

• 7+ years of IT Industry experience as a Sr. Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Working knowledge of Visio, and Argo UML.
• Extensive background in Project Management - building relationships with key business members and change managers to ensure timely implementation of project deliverables using AGILE and BABOKmethodologies.
• Experience in implementation of Guidewire ClaimCenter, Rational LTS (RUP, RequisitePro, ClearQuest), MS Visio, Quality Center, and various open source tools for Issue Management and Documents Management
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in building applications to support businesses, e.g. automation in Request for Quote process (RFQ), middle office trade booking/capturing, auto-generation of term-sheets/contracts, position keeping, Straight Through Processing.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr.Business Analyst

Responsibilities:

• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Developed Guidewire Billing Center, Billing Center - Policy Center User Stories for various work products.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Worked with cross functional teams in order to establish comprehensive business and functional requirements.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Performed in depth gap analysis with different business groups to ensure that the system initiatives are met. Analyzed, documented, and managed all project requirements with RUP methodologies.
• Worked closely with users to understand the functionality of the current system and additional functionality required of the new system.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Involved in complete testing life cycle including creation of Test Plan, Test Cases, collecting test data for various projects and documenting test results.
• Created Use Case usingUMLtools and Process Analysis tool such as Fishbone Diagram, and business process flow chart using MS Visio.
• Established Business Analysis Community of Practice within the organization. Ensure the team understands and follows the best practices set forth perBABOK.
• Involved in the UAT Testing for Guidewire policy/billing centers during the production run.
• Performed End to End testing and security testing using manual/automated scripts on the IMS application and validated the UI & Database for both IMS/Core and Guidewire. product Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• Conducted functional walkthroughs and UAT (User Acceptance Testing) for each module and assisted the QA team to prepare user manuals.
• Facilitated User Acceptance Testing by creating Test plan and Test cases for the business users.
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Has gone through the complete phase of software development life cycle (SDLC), which Agile Methodology including analysis
• Followed the UML methodology to create Business Process Modeling notation including Use Cases Diagrams, Activity Diagram (Swim Lane Diagram) for AS-IS and TO-BE process.
• Successfully defined and implemented Project Management processes and procedures based on BABOK, and PMBOK for multiple groups.
• 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.Worked extensively with MS Excel and MS access
• Actively performed risk management and mitigation with follow-through on all projects and resources
• Worked on RADAR during UAT to assist the QA team and close the tickets associated with the functional issues.
• Used TestLink to create Test Plan, Test cases and test scripts as well as steps for manual implementation of test cases in TestLink .
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Developed business requirement specification documents as well as high-level project plan.

Environment: Mainframes, COBOL, JCL, SDLC, BillingCenter Db2, UML, Oracle, Agile, SQL, PL/SQL, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, UAT, Guidewire, LoadRunner, WinRunner

Confidential, OH

Sr. Business Analyst

Responsibilities:

• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Analysed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policycenter and Paymentmanager in Guidewire application based on the business requirements using LISA.
• Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
• 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.Worked extensively with MS Excel and MS access
• Assumed complete oversight and direction of the risk management function from a subsidiary and successfully transitioned the risk management program to a self-administered plan within corporate headquarters.
• CreatedSDLCdocumentation for a Documentum-based document management system migration and enhancement project.
• Responsible for describing the requirements using differentUMLmodels
• Working with Agile/Scrum methodology, I organize daily scrum sessions with the off - shore team in India.
• Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process
• Followed Lean Six Sigma methodology to ensure that there are less defects and errors during the project and receive high quality outputs.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Developed the QA test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge by using Test Director.
• Created testing scripts to test functionality of credit card processing software, exclusively dealing with currency conversion and ISO8583 credit card messaging.
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensively used Test Director to review and update the status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Work with Risk Management Staff to develops policies covering insurance and accident prevention programs.
• Worked with technical teams to collect requirements and publishSDLCdocuments.
• Involved in the UAT Testing for Guidewire policy/billing centers during the production run.
• Worked on several mainframe based applications running on an AS/400 platform.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Coordinated re-architecturing the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
• Design and develop the data load process using XML Style sheets and ACORD.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs.
• Worked extensively with MS Excel
• Provide customer service and support for Property & Casualty risk management needs

Environment: Windows, GuideWire, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, Mainframes, Agile/SCRUM, COBOL, JCL, Db2, SDLC, BillingCenter Db2, Oracle, Java, J2EE, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential, RI

Business Analyst/ QA Analyst

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Followed solely RUP methodologies during the course of the project.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Implemented the entire Agile (scrum) methodology of application development with its various workflows, artifacts and activities
• Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards.
• Prepared theUMLUse Cases using Rational Rose
• Worked with quality team to ensure end-products met the requirements for the new MerckSDLCtemplates.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Used theBABOKmethods and practices in my business analysis
• Worked extensively with MS Excel and MS access
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Documented business workflows textually as well as inUMLdiagrams according to RUP for the stakeholder review
• Gathered requirements and authoredSDLCdocumentation (functional specifications, user requirements, design specifications, Traceability Matrices, etc.) for a new global asset management database
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), UML, RUP, Case wise modeller, IBM WebSphere, XML, Java, Unix, C++, J2EE, JSP, SDLC, Oracle, Billing Center, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
• Developed front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
• Integrating functionality for multiple components for achieving the ability to send and receive currency/ cash via various EFT (electronic funds transfer) systems e.g. ACH, Wire, CHAPS.
• Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
• Prepared functional requirements and non-functional requirements based upon the approved business requirements byUMLprocesses.
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Created business requirements document and converted the business requirements to functional requirements by the help of use cases and activity diagrams.
• Defining and establishing improved processes and tools to supportSDLCneeds (both waterfall and agile methodologies)
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Implemented Snapshot replication.
• Conducted Requirements gathering and systems design of Airborne Billing and automated Remittance Processing systems.
• Driving and managing ourSDLCmanagement processes
• Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
• Building the cubes by using SSAS.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Involved inUML, designed Use Case Diagram, Class Diagram, Sequence Diagram, and State Diagram for project documentation.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Used Log shipping for synchronization of database.
• Involved in generating various reports using the SQL Server Reporting Services.
• Conducted UAT (User Acceptance Testing).

Environment: Windows, MS Office(MS Word, MS Excel, BillingCenter Db2, MS Powerpoint, MS Visio),.NET, Oracle, Crystal reports, RUP, UML, SQL, SDLC, SWOT analysis, GAP Analysis, Win Runner