PROFESSIONAL SUMMARY:

• 10+ years of experience as aBusinessSystems Analyst and Data Analystin P&C (Property and Casualty) with solid understanding and capturing BusinessRequirements,BusinessProcess flow,BusinessProcess Modelling,DataAnalysis, SWOT analysis, and Business Analysis.
• Experience in Guidewire suite (PolicyCenter, BillingCenter, ClaimCenter and Contact Center) integrations.
• Expertise and hands on experience of migrating and upgrading insurance suite solutions toGuidewiresolutions as well as integrating third party solutions toGuidewiresolutions.
• Working knowledge about policy Underwriting, Binding, Rate making rules and factors affecting it, Rewriting and Worker's Compensation.
• Expertise in understanding Policy Administration System (PAS) using Guidewire PolicyCenter especially in Commercial Lines (Businessowners, Workers'compensation, Business Auto).
• Well versed in claim management i.e. FNOL, Claim Setup, Payment and Recovery, Fraud Detection Tools, Litigation, Subrogation and Salvage.
• Experience withDatacleansing,DataValidation and creating Source to TargetDataMapping documents, creating Metadata documents and Source to Targetdatacomparison.
• Strong experience in DataAnalysis,DataProfiling,DataMigration,DataIntegration and Metadata Management Services.
• Experience in working with different reporting tools like Cognos, OBIEE, Tableau, Business Objects, Microstrategy.
• Have developed standards fordatadefinitions,dataelement naming conventions, and logical/physical database design for applications anddatawarehousedevelopment.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Highly proficient in operating MS SQL Server suite of products like SSIS, SSRS and SSAS.
• In depth knowledge of variousSoftware Development Life Cycleswhich includeWaterfall, Agile (Scrum and Rational Unified Process /RUP) and Hybrid (waterfall - scrum) methodologies
• Hands-on experience with Rally project management software for managingSAFeprojects.
• Good experience in Cognos, Qlikview and Business Objects Reports testing
• Experience in working in close proximity withBusinessusers, project stakeholders, Subject Matter Experts (SMEs) and staff to understand high levelbusinessrequirements and minute level specifications for new applications, and to modify existing applications.
• Experience inDataVisualization,DataAnalysis and BusinessIntelligence.
• Adept in performing GAP Analysis to check the compatibility of the prevalent system infrastructure with new business requirements.
• Detailed understanding of preparation ofRequirement Traceability Matrix (RTM)throughout the process
• Proficient in Requirements Gathering, Surveys/Questionnaire Development,BusinessRequirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD)
• Extensively experienced at convening Joint Requirement Planning (JRP) sessions withBusinessUser Groups, conducting Joint Application Development (JAD) sessions with IT Groups, and Conflict Management.
• Cogent facilitation skills in Use Case walkthroughs, requirements elicitation sessions, and knowledge transfer sessions for personal and commercial lines ofbusiness.
• Experience in creatingUI/UX wireframes, mockup screens and prototypesinJustinmind, BalsamiqandMockup Screens.
• Experience in conductingGAP analysis, Business / Technical Impact analysis, SWOT analysis, As is - To be analysis, Cause & Effect analysis, Cost benefit analysis, Feasibility analysis, Risk analysisandReturn On Investment (ROI)estimation.
• PerformedETLprocess usingInformatica Power center; Data ProfilingusingInformatica Data Center, Mapping Disparate source datawith thedatain thewarehouse, designing and deploying various reports throughTableau and IBM Cognos.
• Experience in Headed Vendor Management and procurement tasks such as Request for Proposal (RFP), Request for Information (RFI), Statement of Work (SOW), Service Level Agreements (SLA).
• Exceptional in creating screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams,businessprocess flows, and in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
• Experience in Data Warehouse applications testing using Informatica Power Center and Ab Initio on multiple platforms.
• Quality Assurance experience in formulating and reviewing test plans, test scripts, test requirements, test cases, test reports, and adept in using defect-tracking tools to address issues as required by the project.
• Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
• Expert in tracking and managing requirements through Requirement Traceability Matrices (RTM)
• Handling Change Management by conducting Impact Analysis & facilitating Change Control Board (CCB) Meetings.
• Excellent technical skills in SQL to extract, transform and loadingdatato the database using tools such as Guidewire Data hub.
• Good understanding of Object Oriented Analysis and Design (OOAD)
• Proven track record indatacollection, analysis and evaluation in Information Systems issues, analytical problem solving, and decision making, communication and inter-personal skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

• Data HubCenter, SSIS, MS Excel (VLOOKUP, Reportand Dash Boards, Pivot Tables), Cognos, PL/SQL, SQL, C, XML, HTML, DataManagement, DataMigration, Data Structure, Oracle 9i & 10g, Sql Mysql, Ms Access, Ms Word, Power Point, Visio, Project, Req management, Testing, Wire framing, Rational Requisite Pro, QTP, HP Quality Centre 9.2, SilkCentral Test Manager, MS SharePoint Serve, Axure RP Pro 6.5,Bugzilla, Jira, Agile (scrum), Waterfall, BABOK, CMMI, BPR, Six Sigma (DMAIC), GuideWirePolicyCenter, ClaimCenter & BillingCenter, The Insurance Application (TIA)

PROFESSIONAL EXPERIENCE:

Confidential, Walnut Creek, CA

Sr. Business Systems Analyst

Responsibilities:

• Researched and AnalyzedBusinessneeds and ways to improve property and casualty specifically policy contracts and processes administration.
• Collaborated with thebusinessteam in the creation and completion of project charters and project scope forGuidewirePolicyCenter.
• Capturedbusinessrequirements in form of user stories using JAD sessions, brain storming sessions, focus groups and personal interviews to understand current policy administration system and ensured coverage onbusinessvalues, story points and acceptance criteria.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS),CognosImpromptu, and Microsoft Excel
• Identified gaps in existing Policy Administrating Systems andGuidewirePolicyCenter and diligently designed as-is and to-be process, in scope and out of scope documents.
• Created Use Case models for policy creation to policy end using UML diagrams like Use Case Diagrams, Sequence diagrams and Flow Diagrams using Rational Rose.
• Reviewed the data model and reporting requirements forCognosReports with the Data warehouse/ETL and Reporting team.
• Analyzed and checked for missing values,datastructures,datasanity of the legacy system'sdatausing R Studio.
• Trouble shoot overlap anddataquality issues by looking through the office of existing policy administration'sdatalineage, systems, and triggers for signs of bugs and malfunction.
• Worked along with the lead on cross functional teams for the development of Guidewire cloud claims management platform IT enhancements.
• Performeddataintegration anddatamapping anddataextraction management along withdatacleansing while migratingdatafrom legacy system toGuidewirePolicyCenter withGuidewireData Hub.
• Elicited, documented, modeled, validated and prioritized functional and non-functional requirements using interviews &dataanalysis for insurance policy lifecycle i.e. right from policy creation to policy renewal.
• Helped the product owner in creating product backlogs and Sprint Backlogs.
• Collaborated with the Scrum Master and Scrum teams in Estimation and Velocity planning. Also, participated in conducting Sprint Planning, Daily Stand Up, Sprint Review & Retrospective meeting.
• Assisted the Scrum Master to prepare and monitor burn-down charts for the successful completion of tasks within the time-boxes.
• Build reports and perform SQL queries usingCognosReport Studio
• Involved indataconversionsand extracteddatausing SSIS packages (ETL) to transferdatafrom different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text FormatData.
• Managed sprints i.e. burn down charts, project velocity, sprint backlogs and product backlogs using JIRA.
• Prepared mockup with sampledataand created a model with extract, transform and load (ETL) principles inQlikview.
• Involved inETLspecification designing for incoming feed coming from variousdatasource and Datamanipulation on it.
• Performeddataintegration anddatamapping management along withdatacleansing while migratingdatafrom legacy system toGuidewirePolicyCenter.
• Performed Walkthroughs ofbusinessrequirements and functional requirements with the development and testing teams.
• Set up definitions and process for scoping, document test cases, test phases included integration testing, end to end testing and user acceptance test (UAT) and documenting the results for policy underwriting rules, rewriting rules, policy rate making and pricing.
• Validated Rating Algorithms for Schedule Rating, Experience Rating and Retrospective Rating usingGuidewireRating Management components.
• Facilitated the Post Production Validation and actively participated in production call support whenever necessary and ensure smooth running of the system in real time
• Assisted in deployment with step-by-step instructions and created appropriate GUI screenshots for underwriters, agents, claim staff, auditors.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Confidential, Amelia, OH

Business Analyst / Data Analyst

Responsibilities:

• Worked in a fast paced atmosphere SCRUM and studied business processes, legacy application, and the corresponding Guidewire functionality and conducted requirements sessions.
• Utilize the guidelines and artifacts of the Agile Methodology to develop a detailed implementation processGuidewire PolicyCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC).
• Identified the functional as well as technical needs of the department and accordingly engaged as liaison between the Upper Management and IT Team to developCognosbased BI Reports, applications and softwares.
• Assisted in development of the reports usingCognosReport Studio and Framework Manager. Developed Forms, Reports and Queries using MS Access and Excel (including Pivot tables, Vlookup and Macros).
• Performeddataintegration anddatamapping anddataextraction management along withdata cleansing while migrating datafrom legacy system toGuidewirePolicyCenter withGuidewireData Hub.
• Elicit, document and publish reporting requirements for currentCognosbased reports for creation in Microsoft SSRS Reporting Solutions.
• Deriving the scope of testing by identifying the data flow from Rating systems andGuidewireData Hub.
• Working with PolicyCenter integration requirement with Docs and Forms, BillingCenter, Rating, CustomerData Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements for online Sales portal.
• Provided the data mapping with transformation logic for PC -ISOfeed for providing Premium, Claims (Losses, Reserves) data to support RegulatoryReporting
• Managed requirements for the implementation of more than 20 internal and external data feeds, includingISO, D&B, Epsilon, Lexis Nexis, Accuweather, Medi-span, Bureau of Labor Statistics, EASI/Census, and various claim systems and policy systems used in predictive models.
• Involved in developing variousDataManagement strategy components such as incremental delivery of an Enterprise DataWarehouse, utilization of adatalake for ETL offload, legacy systems archive, and adataintegrationhub.
• Involved in Fine tuning of database objects and server to ensure efficientdataretrieval.
• Responsible for getting approval of newly redesigned build Forms from Forms compliance team.
• Interacting withGuidewireteam and providing requirements for Formsdatabased on out of box feature ofGuidewire
• Based on analysis of legacy Formsdataand stakeholders need interacting withGuidewireteam about Cov Term patterns and coverage type (Electable, Required, Suggested) to print on Forms.
• Worked on Risk reports to ensure chargeability conditions, durations, and other attributes (Age, level, counts, SVC codes etc.) are correctly translated and ready for PC use on various functionalities (like Losses Violations, Discounts etc.)
• Actively participated in JAD sessions for overcoming project issues relating todataprocessing, user interface, and downstream system interactions.
• Generated Use case for business process and User Stories for Guidewire PolicyCenter to understand the various possible scenarios and dependency among various line of Business (LOB).
• Wrote detailed specifications and led the development for various reports generated usingCognos.
• Successfully conducted JAD sessions to facilitatebusinessprocess agility and to identify the content flows and processes.
• Gathered Product Backlog on the traditional claims system and newly integrated PolicyCenter and carefully elaborated application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction using SQL queries.
• Experience with complex SQL queries fordataprofiling forDataETLIntegration tool.
• Worked closely with technical services group coordinators to provide full support offormsimplementation
• Worked with claim specialists in specifying the requirements for Incident Permissions Incidents, Exposures, and Claims Incident Entity and their Subtypes
• Worked with quality control teams to develop Test Plans, Test Cases and test scripts based on functional performance criteria and usability.
• Garnered technical prowess on Change Management by performing Impact Analysis for Change Requests obtained during Claims processing lifecycle.
• Examine and research accounts in internal and external databases (i.e., Lexus Nexus) to identify which information is complete, missing, inaccurate, etc. Perform data entry and database maintenance for this information.
• Frequently used Requirements Traceability Matrix (RTM) for identifying and tracing the linkages among PolicyCenter, BillingCenter and ClaimCenter.
• Extensive experience in extracting UI based information by querying the Oracle database using SQL queries.
• Used SQL during the testing phase to verify and validate that the correct information is being provided.
• Orchestrated User Acceptance Testing (UAT) to guarantee that all the data model,businessrules, workflows and user interface requirements have been fulfilled by the web application.
• Worked closely with PO and Scrum Master during RACI review process and release management for seamless integration.
• Implemented Software Quality Assurance development policies and test procedures. Documented test scripts according to thebusinessspecifications and design documents.

Confidential, Pekin, IL

Business Data Analyst

Responsibilities:

• Gathering Requirements and design of technical specification documents. Documented thebusinessrequirements for theCognosBI reports. Derive Cognos report requirements from already existing report templates.
• Followed the Agile (SCRUM) methodology throughout the project. Analyzed all the functional and technical requirements and put it together in Rational Requisite Pro to convert them into Requirements Document
• Understanding thedatamodel of legacy application anddataflow to different legacy application streams.
• Perform Gap analysis for different attributes in legacy system vsGuidewire.
• Complete the design fordataextraction fromGuidewirePolicyCenter toGuidewireData Hub.
• Involved in developing the ETL jobs fordataextraction fromGuidewiretoData Hub.
• Participate indataconversion strategy and implantation on multiple phases.
• Also worked as an Enterprise Data Hub (EDH)BusinessAnalystand partnered with theEDH technical team and business partner teams in driving the requirements, design and development activities for several systems to be retired/archived within multi-node.
• Involved in the System Analysis, Design and Development of the project. Integral part of end-to-end implementation of IW Reporting from capturing reporting requirements, Relational data modeling inCognos, Metadata analysis, mock-up template designing and BI reporting system.
• Involved in developing Informatica Mappings to load data from Source Systems toEDH(Enterprise Data Hub) and then to Data Mart.
• Involved in multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere andCognos.
• Participated in integration ofMDM(MasterDataManagement) Hub anddatawarehouses.
• Performed complex SQL queries for retrievingdatafrom the database, generating ad-hoc reports, and conducting data validation testing.
• UsedBusinessIntelligence Reporting Tool (Cognos) to create KPIs and Scorecards.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Reviewed thedatamodel and reporting requirements forCognosReports with theDatawarehouse/ETL and Reporting team. Wrote several SQL scripts for massivedataextracts and manage thedataconversion and extraction process.
• Interacted with the SME's to analyze theDataExtracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Gathered requirements and modelled the data warehouse and the underlying transactional database
• UsedDatawarehousing forDataProfiling to examine thedataavailable in an existing database
• Worked with SCRUM Master, Business Owners, Project Sponsor, SME and Guidewire Consultants to define Product Backlog, Sprint Backlog, estimate efforts for user stories
• Conducted functional and technical requirement gathering sessions for BRD and FSD docs with Stakeholders, Underwriting Managers and Operations Analysts for the Policy, and Billing related modules.
• Responsible to maintain the defect log that traces back to the test cases and also to the requirements, involving Agile and Scrum methodology.
• Involves in planning and implementing both high-level and detailed system and integration test plans
• Perform overall Requirements Management and built the Requirements Traceability Matrix.
• Created use cases diagram for better understanding for developer and tester.
• Create Software Requirements Specifications, use cases, and wireframes forGuidewire
• Used Agile SDLC to ensure newbusinessprocesses and system changes are documented, developed, tested, and promoted successfully
• Worked closely with development and Testing Team to iteratively implement and deliver functional modules throughout the duration of the project.
• PreparedBusinessContext Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development ofBusinessProcess Management (BPM)
• Documented and reviewedbusinessprocess changes throughout the organization with Functional leads
• Responsible for assisting in testing of web releases on an as needed basis when requested.
• Liaison between functional leads, development teams and support teams
• Requirements Validation prior to delivery of documentation to Application Delivery team
• Support UAT (User Acceptance Testing) sessions
• Worked with the Application Delivery team to ensure Test Use Cases are current and correct for existing and new processes

Confidential, Los Angeles, CA

Business Data Analyst

Responsibilities:

• Analysis ofBusinessrequirements and preparingBusinessRequirement/Use Case scenario document.
• Work with the core development team to ensure thebusinessrequirements are understood and incorporated into the software development project.
• Analysis ofbusinessrequirements and system requirements of the client and also forPropertyand casualty modules
• Processing of NewBusiness, Renewal, Cancellation, Reinstatement, Billing for various lines ofbusiness(Fire, Auto, Commercial)
• Worked withDataWarehouse in the development and execution ofdataconversion,datacleaning and standardization strategies and plans as several small tables are combined into one singledata repository system MDM (Master Data Management).
• Extracted data sets from databases, developped and generated quality reports and graphs with tools such asCognos.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Worked on the commercial property and casualty domain and made specific changes to the same for the smooth flow of the process.
• Wrote SQL queries fordatavalidation, analysis and manipulation, and maintaining the integrity of the database.
• Analyzed the flow of data into downstream data warehouse which fed to data marts and end systems that support analytical and operational reporting.
• Responsible to extract specificdataset from Operation database(ODS) by using PL/SQL query in order todatacleansing process and new feed processing purpose.
• Created the DMD (Data Mapping Document) to specify the Data mapping from various data base sources to the target database and used Rational Rose for developing Unified Modeling Language (UML) diagrams like Use Cases diagram, Class diagram, Sequence and Activity based diagrams.
• Involved in creating reports framework with dimensional data models for the data warehouse and worked with the development team on SQL Server 2005 tools like Integrations Services and Analysis Services.
• Extracted theBusinessRequirements from the end users keeping in mind their need for the application and preparedBusinessRequirement Documents (BRD) using Rational RequisitePro.
• Facilitatedbusinessrequirements gathering sessions (JAD sessions) with the client/Technical team and overlooked the creation of Use Case scenario document.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT andBusiness.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational ClearQuest.
• Involved in generating Test cases forpropertyand casualty Insurances for Different Levels ofBusiness
• Create Functional and Non-Functional Requirement Document.
• Review of regression test results performed for projects.
• Coordinating with product manager, otherBusinessanalysts, developers, testers and Systemanalystof interfacing applications like Claims, Billing, Customer Communication, Data warehouse, Data Solution.

Confidential, Bloomington, IL

Business System Analyst

Responsibilities:

• Engaged inBusinessCase Development and research initiatives withBusinessand Systems Executives for Rating Changes to enhance Auto Process Guide and/or Code Manual for completeness and update to ensure that thebusinesspartners are equipped with the tools and resources to help them be as self-sufficient as possible and reduce systems support costs.
• Analyzing and understanding of project scope, capture Functional requirements documentation (FRDs) and requirements change notices (RCNs) and timely communication of meeting minutes in Lotus Notes.
• Worked on various auto and life insurance products (Bodily Injury, PIP etc) for various states in the US.
• Extensively used Requisite Pro to create and manage project templates, Use Case project templates, requirement types and traceability relationships.
• Communicate with the actuarial team for transmitting the rate changes and conduct functional checkouts using proprietary mainframe Rumba Host System.
• Coordinating and validating functional unit test cases (manually as well using DrCB) as the rate changes takes place, analyzing results of the test cases as required during the life cycle of the rate changes.
• Supporting the design team with the questions related tobusinessrules and screen behavior for the RSPE and Auto Quote Process.
• CreatedDataFlow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load,ETLprocess and various other processes that required transformation.
• Work closely with Razorfish to capture the detailed screen behavior for Eligibility and Drive safe & save (DSS) program screens in content component library that is used by User interface Designers (UIDs) for mock up screens.
• Utilize HP Service Manager to track errors received and importing itsdatato Excel to identifytrends, themes, and root causes and report on rating issue key measures andbusinessareas,operations, and Systems to reduce the occurrence and impact of issues.
• Prepared documents such as Project Scope, Project Vision, Project Success,Business Requirements, Functional Specification,DataWarehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards.
• Liaisoned with Business team to ascertain their requirements of standard reports and ad-hoc querying functionality using Cognos.
• Used SharePoint to store and organize and track documents. Used document libraries in SharePoint to store, create, collect, update and manage documentation.
• Provide support across different domain areas such as Auto Assignment, Payments, ClaimsDataand Appointment Logs, Auto Estimations, Fire Claims etc.
• Collaborated in building abusinessanalysis process model using Rational Rose, RequisitePro, and Visio.
• Used SQL and MS Excel for allDatavalidation based on theBusinessRules.
• Working with clients to better understand their needs and present solutions usingstructured SCRUM approach.
• Created UAT plans with several test cases for each project to ensure that the system runssmoothly after the proposed enhancements or changes have been made.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases& Test Scripts that are executed during testing process.