SUMMARY

• 7 years of experience as a Sr Data Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Knowledge of Data Warehouse concepts, applications, and ETL tools
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
• Extensive experience in implementing insurance claims applications using Guidewire Claim Center Product.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Ab Initio and Data stage using Oracle, DB2, Teradata and UNIX.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Analysis requirements and developing as well as executing test cases for ETL
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are following the Business Requirements.
• Well versed in ETL Testing and validating reports.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

• UML
• Rational Rose
• RequisitePro
• Rational SoDA
• Rational Clear Case
• Rational Clear Quest
• Mercury Test Director
• MS Project
• MS Visio
• MS Office Suite
• Bloomberg
• VBA for Excel
• SQL
• PL/SQL
• Java
• J2EE
• C#
• VB.NET
• C++/CLI
• Adobe Acrobat
• Photoshop
• AutoCAD
• 3D MAX Databases
• Oracle 8i/9i
• MS SQL Server
• MS Access

PROFESSIONAL EXPERIENCE

Confidential, Keene, NH

Sr. Data Analyst

Responsibilities:

• Analyzed the business rules for Auto claim assignments throughout the US, to have balanced workload for all the claims reps.
• The Guidewire Claim center application uses Java to write data from Claim Center to Staging Tables as part of Distributed Team.
• Written complex SQL queries to validate the ETL transformation rules.
• Developed Data Flow Diagrams and Data mapping agreement, illustrating the flow of data from the front - end Guidewire Claim Centre into the Application database Tables.
• Responsible for testing all new and existing ETL data warehouse components.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group.
• Worked on commercial Property and Casualty and Personal Lines Insurance experience with national carriers. Established a Business Analysis methodology around the Rational Unified Process.
• Developed SQL scripts and wrote stored procedures to validate the flow of data from Legacy source to target application database and ability to perform data validation (of ETL processes, schema and DDL check, data flow from data warehouse to application databases, data marts, return marts, referential data, repositories).
• Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk and increase the quality of application before deployment.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Guided development team in the Oracle 9i based database. Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Was responsible for indexing of the tables in that data warehouse.
• Worked extensively with MS Excel and MS access.
• Have sizeable adequate hands on exposure in Workmen Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intri Confidential es.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Worked with Data warehousing developers who extensively used Informatica, ETL tool to design mappings to move data from source to target database-using Stages to understand the functionality.
• 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.
• Meticulously assessed data from various sources and generated conceptual and logical database designs using ERwin data modeling tool.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• 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, Db2, Oracle, SQL, PL/SQL, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• 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.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Postproduction testing and End to end Testing of ETL code and reports.
• Negotiated with teams from projects to decide if modules should be implemented independently or parallel.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/reporting database.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin. Configured the Data mapping between Oracle and SQL Server 2005.
• Review requirements and understand technical recommendations and constraints and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Provided data modeling support for numerous strategic application development projects.
• Updated the impacted MS Access tables. Worked extensively with MS Excel and MS access. Analysis of business requirements and system requirements of the client and for Property and casualty modules
• Managed efforts associated with the on-going development of reporting environment to include requirement, data modeling (star, Snowflake), ETL and end user reporting. Successfully managed all related Service Level Agreements (SLAs).
• Tested requirements and modeled the data warehouse and the underlying transactional database
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snowflake Schema methodology.
• Maintained on-going technical assistance and provided help desk support to customer’s mainframe systems software that included problem determination and resolution.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Carried out ETL Testing using Informatica and PL/SQL.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Create and analyze Web metrics for business performance, dash boarding and scorecards
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• 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.
• 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 10/8, Oracle, SQL, SQL Server, Sybase, VBScript, C#, MS Project, SQL, PL/SQL, C++, NET, ASP.NET, Business Objects

Confidential, CA

Data Analyst

Responsibilities:

• Worked as a Business Analyst to translate customer product requirements into comprehensive, complete and accurate business requirements and functional specification.
• Manages disbursements of home and mortgage insurance payments three weeks prior to due date.
• Implemented the full project lifecycle phases including requirements gatherings, development and quality assurance develop functional test plans, execute and review results of test plans to ensure the system meets user community requirements.
• Worked with the developers to create Data Mapping Documents for Direct BAI, SWIFT, Non-BAI Controlled Disbursement and Shared Draft Products.
• Mapping required fields off the customer reports to the source tables in Electronic Window (EW).
• Involved in all SDLC stages under agile process in applications including Requirements analysis, implementation, testing, deployment and maintenance. Created Process Flow diagrams, use case diagrams (UML) using MS-Visio.
• Gathered requirements by conducting meetings and brainstorming sessions with end users and Subject Matter Experts (SME) and documented them using Borland Caliber RM.
• Preparing UML artifacts viz. Use Cases, Activity Diagrams, recommended by RUP (Rational Unified Process) for Requirements.
• Interacted with business partners to perform the Initial Project Analysisdefine new and document retail sales reporting requirements and Change Requests (CRs) in Borland Caliber RM
• Prepared an analysis report based on the COTS evaluation. Worked on up gradation of SSIS packages.
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyse customer needs and many other business areas.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Assisted with user testing of systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Worked with the developers to create Data Mapping Documents for Direct BAI, SWIFT, Non-BAI Controlled Disbursement and Shared Draft Products.
• Mapping required fields off the customer reports to the source tables in Electronic Window (EW).
• Presented discovery documents to the IT activities for acceptance into the integrated and point releases via Statement of Business Requirements documents using MS Word, MS Excel, Teleologic DOORS, Visio tools.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, and Sequence Diagrams using UML. Full knowledge of phases of the Systems Development Life Cycle.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Preparation of Test Plans and execution of business testing, preparation for and delivery of application.
• Participated in various vendor selection processes and conducted Cost-Benefit Analysis of COTS products and comparison between COTS and In-house developed components.
• Performed Defect Tracking and Change Control Procedures using Quality Centre.
• Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met (extensive project life cycle experience).
• Created product documentation, including online help, user manual and training materials
• Data validation using database tools such as SQL and Access queries and following up with the development and QA team for the same.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing. Designed and implemented basic SQL queries for reports and data validation.

Environment: Windows 10/8, RUP, UML, Visio, Caliber RM, Doors, Rational Suite (Rational Requisite Pro, Test Director, Clear Quest, Rational Clear Case, Rational Soda) MS-Office, SQL Server, SSIS, UAT.

Confidential, Seattle, Washington

Data Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companies’ reinsurance broker.
• Data Modeling and optimization:optimizing the system layout to take the most advantage of our IO subsystem. Followed solely RUP methodologies during the project.
• Analyzed sales volume and web metrics to track success, identified variances and built forecasts
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Used Rational Clear Quest to track required changes and Rational Clear Case to maintain different versions of the project documentation.
• Developing functional specifications for business process refinement and automation, data modeling, system Architecture, conducting feasibility studies, scope.
• Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• Excellent command over Logical and Physical entity relationship data modeling using CASE tools
• Data modeling and design of databases, tables and all objects.
• Provided implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Responsible for the management of two Application portfolios, both central to client business, involving the maintenance and production support within a mainframe environment.
• 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.
• 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.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, MS Visio, MS Project, PL/SQL, J2EE, JSP, Oracle.