SUMMARY:

• 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 warehouse/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• 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.
• 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.
• Object Oriented Analysis and Design (OOA/D).
• Provided technical and functional consulting to corporate and divisional users for Cognos.
• 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 RequisiteProDocumentum

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 Simi Valley, CA

Sr. Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Involved in all stages of testing the Auto & Home Insurance application.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Involved in creating dashboards for reporting
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Developed project plans and managed project scope.
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting needs of different corporate business units.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Designed the universes by creating the Business Objects data model.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Coordinating and Developing QA activities.
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Worked extensively with MS Excel and MS access
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Provided key input in working with users in defining project and system requirements.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: UML, RUP, Mainframes, Agile, Cognos, COBOL, JCL, Db2, Java/J2EE, Oracle, Rose, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner.

Confidential, East Rutherford, NJ

Business 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.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
• Preparing BRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.
• 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).
• Developed a thorough understanding of the “Compliance Readiness Using CobiT and ITIL”
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• 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.
• 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: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), UML, RUP, Casewise modeller, Agile, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential Keene, NH

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

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

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

• Interacting with the stakeholders to get a better understanding of client business processes and gather business requirements
• Identified Use cases from the requirements and wrote Use Case Specifications
• Created business process workflow diagrams (Activity diagrams) in Rational Rose
• Link business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
• Developed business process models in RUP to document existing and future business processes.
• Integrated RequisitePro with ClearQuest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests
• Managed all the requirements in RequisitePro, making requirements available to all team members.
• Facilitate weekly JAD sessions and interviews with SMEs, senior management and IT teams to track and document Credit Risk, market risk and operational risk related issues and tasks.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Performed Data Analysis of existing data through SQL.
• Created test plan and test cases for user acceptance testing. Used Rational testing tools.
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
• Performed Feasibility Analysis and Risk Analysis on vendor/third party tools.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
• Monitored client expectations and conducted user interviews

Environment: Rational Rose, Rational RequisitePro, Rational Clear Quest, Rational manager, Rational Administrator, SQLBasic, DOORS, SQL, VB.Net, Oracle, UML, MS Office, MS project, MS Word, MS Excel, MS Visio.