SUMMARY

• Over 6+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• 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).
• Proficient in developing Wireframes, Use Cases, Data Flow Diagrams, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams, Class Diagrams, Entity Relationship Diagrams and Business Process Diagrams.
• Very strong knowledge of Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Casuality.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Strong business domain knowledge of Property and Casualty Insurance including risk, Policy Sales, Policy Administration System, Receivables and Payments, across different lines of business.
• Experience developing web - based applications, wireframes, mockups etc.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
• Expertise with Microsoft servers like Microsoft Office SharePoint Server 2007 and Microsoft PerformancePoint server 2007.
• Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Proven experience in driving various life cycle stages of an ITIL project from Service Transition, Service Operation to Continual Service Improvement using ITSM and Lean Six Sigma best practices
• 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.
• 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.

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 RequisiteProBug 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, Washington, DC

Sr. Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Generated wireframes and prototype for the GUI.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Involved in full life cycle of Business Objects reporting Application.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Took lead role in migrating pages and data from old intranet to new SharePoint platform.
• Drafted workflow, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Upgrading and Patching of SharePoint and its' related systems
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Met with individual departments to communicate SharePoint purpose, application and vision for the future.
• Completed the documentation of Claims Scenario’s for the source system
• Was responsible for the hardware, software, upgrades, and patching of SharePoint equipment.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Created use case scenarios and documented work flow and business process.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Understood the requirements of the Sales and Marketing team
• Done the setups required for sales quoting.
• Updated the impacted MS Access tables.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows development involved in the project. Carried out defect tracking using Clear Quest.
• Created Custom Web pages for SharePoint sites in Visual Studio 2005 and Visual studio 2008 and SharePoint Designer 2007.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Run the SQL queries using TOAD and SQL Navigator.
• Assisted system analyst to create Sequence Diagrams and Class Diagrams to show the individual flow of activity and define functionalities of various processes in policy administration system.
• Provided key initiatives in working with users in defining project and system requirements.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Created wireframes and storyboards.
• Responsible for developing annual and mid-year operating budgets by underwriting departments.
• 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.
• Implemented and oversaw the ongoing execution of the ITIL/ COBIT best practice frameworks.
• Created workflow development, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Conducted Architectural Discussions to prepare the Proposed Architecture and provided insight in the Business Case to the Architecture Review Board (ARB).
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Execute test scripts, coordinated & conducted UAT testing.
• Conducted JAD sessions for communicating with Stakeholders and Project directors
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Worked with an information architect to create and develop wireframes and mock-up screens for the UI.
• Performed requirement analysis, went through all the use cases and issue logs.
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.

Environment: Windows, MS Office(MS Word, MS Excel, Documentum, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, AGILE, SWOT analysis, Java/J2ee, Win Runner

Confidential, IL

Business Analyst

Responsibilities:

• Involved in Troubleshooting, Debugging and Performance Tuning of code and supporting users by incorporating specific requests
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Expertise in MOSS 2007 Workflow, SharePoint Designer 2007 and InfoPath 2007.
• Conducting requirement sessions and successfully translating of those requirements into Use Cases and GUI wireframes.
• Performed custom data conversions and developed custom software for risk management applications including commercial insurance, life insurance, etc, tracking. Perform all data field mappings.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Worked closely with the loan officers (SMEs) to obtain a detailed knowledge of the loan life cycle process, risk analysis etc;
• 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.
• Implement SharePoint for team collaboration and Document Management.
• Involved in the defect fixing, testing and generating Incident Reports.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• Assisted in creating wireframes for web interface with the GUI design team.
• Interacting closely with functional teams and end users on critical issues
• Created use case scenarios and documented work flow and business process using Rational Rose.
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Performed in-depth testing of the service development system by documenting requirements and specifications for a world-wide deployment of SharePoint personal sites, workgroup portals and shared data repositories.
• Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products.
• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Responsible for installation and configuration of the SharePoint Server 2007 along with Office 2007 and worked on Site designing using SharePoint Designer 2007
• Involved in project management using MS Project
• Worked on the commercial property and casualty domain and made specific changes to the same for the smooth flow of the process.
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Wrote test cases and test scripts for the User Acceptance Testing
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Participated in meetings to establish and enforce SharePoint best practices and standards manage proper security group naming conventions & security assignment processes.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level
• Used Rational Clear case for version control
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Created different users, roles, Document libraries, Form Libraries, Team sites for projects, Issue Lists on SharePoint Server 2003.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Served as conduit for managing system requirements between the business and the software development team.
• Used Rational clear quest for defect management.

Environment: RUP, UML, Windows NT, Java Script, Documentum, Rational Suite (Rational Test Manager, Rational Robot, Rational Clear Quest) MS Project, MS Visio, Visual Basic, Win Runner, Test Director, Windows XP, J2EE

Confidential, Keene, NH

Business Analyst/System Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Assisted with development of strategy for managing SharePoint permissions in conjunction with Active Directory and future implementation of Identity Lifecycle Management functionality.
• 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 ACCORD xml standards.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Designed and developed project document templates based on SDLC methodology
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Designed workflows and allocated permissions within MS SharePoint.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.
• 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.
• Participated in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• 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).
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Worked extensively with MS Excel and MS access.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, UML, RUP, Mercury TestDirector, Mercury LoadRunner

Confidential, Portsmouth, NH

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) centric business analysis methodology.
• 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.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Coordinated activities with project manager and various other teams using MS Project.
• Worked with different Business Applications such as Billing for Loss Recovery, Cash Receipt Processing, and Loss Accounting Systems
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions.
• Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
• Written smoke test cases in Quality Center and modified them when they are automated.
• Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducted Black Box Testing on the application and validated the dataflow in the application.
• Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system
• Manually tested the whole application before going for the automated testing.
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
• Worked extensively with MS Excel
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.

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