We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume Profile

Kansas City, MO

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience in the field of Business Analyst, Process Improvement, Data Profiling, Data Migration, Data Integration, and Metadata Management Services with strong understanding of Data Modeling concepts, Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Models.
  • Extensice experience in Guidewire suite PolicyCenter, ClaimCenter, BillingCenter and Contact Center integrations.
  • Extensively worked on custom Reporting using Tableau, Performing BI Analytics using Tableau, creating Tableau Dashboards, working with Business Groups to perform Custom Analytics and Custom Reporting.
  • Experience in developing accurate business process requirements for Insurance, Banks, and State Government projects with experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
  • Strong Analytical and Documentation skills, functional knowledge in Financial markets, Insurance, excellent communication and interpersonal skills, team player and self-starter with also well-versed in writing documenting Business Plan, Requirements document, Functional Specification document, and test cases.
  • Gathered business requirements from users and developed the Data Model to be used to develop Qlikview dashboards.
  • Gained advanced knowledge in commercial property insurance by learning underwriting processes.
  • Ability to collaborate with peers, in both business and technical areas, to deliver optimal business process solutions in line with corporate priorities and Software Development Life Cycle SDLC experience including Requirements, Specifications Analysis/Design, and Testing.
  • Extensive experience on Integration- Data Mapping work from Guidewire Policy Center to various external systems like Enterprise Service Bus, Insbridge, Rating Engine, Product Model, OnBase, xPression.
  • Responsible for analyzing and adjusting claims to ensure servicers received their claim payment in a timely manner, and responsible for insuring funds are paid off of the system with also pay valid claims in an accurate and timely manner, Complete weekly Pay out of claims, Train New Employee's on Weekly pay out of claims.
  • Good Data Warehousing concepts including Metadata and Data Marts with extensive experience in conducting Joint Application Development JAD sessions with end-users, Subject Matter Experts SME's , Development and QA teams.
  • Created various POC reports and dashboards in Tableau desktop using various features such as Hierarchies, Filters, Actions, Extract, Calculated fields etc.
  • Involved in Upgradation of Tableau Server from v7.0.12 to v 8.0.7 and also Created Users, Groups, Projects, Workbooks and assigned Access levels in Server.
  • Transform, format, and load FLAT FILES and XML files into SQL DB with write SQL queries to extract data/XML string from databases/ODS and parsed the data and store result in SQL tables based on the XML process and also create and maintain Data Model, database to capture parsed XML and parcel it for reporting through crystal and excel.
  • Developed a very complex dashboard in QlikView 10 with QVD creators, Aggregated Model QVD Creator and stored the data in to QVD's.
  • Provided detailed walkthroughs to all stakeholders Strategic Team, Business Users, development and testing teams and ensured functional adherence for Guidewire Policy center implementation.
  • Extensive experience in project management best practices, processes, methodologies, including Rational Unified Process RUP and SDLC with excellent communicator focused on customer service and also an ability to understand current business processes and implement efficient business processes.
  • Actively involved and supported EDW data marts for Finance and Payroll ETL activities. Participated in the UAT for Broker/Dealer conversion for integration using Mercury Test Director with also expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies.Strong command on SWIFT messaging.
  • Expertise in defining scope of projects based on business requirements, including documentation of constraints, assumptions, business impacts project risks with strong background in support documentation, analysis and review of software and business requirement documents.
  • Work with business partner to maintain store procedures for loan application Business Rules that extract data from two parallel sources and compare results using complex algorithms, loan data and lookup tables from SQL and analyze results through front end application using form filters for data isolation.
  • Worked closely with COE team to understand their deployment process through the release management tool in QlikView server.
  • Experience in identifying and documenting detailed business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives, Portfolio Management, Corporate Action, and Wealth Management,insurance policies etc., creating project and process specifications, working with development team to continually articulate requirements, and troubleshooting production issues including new investment products, applications, data analysis, data mapping and QA report testing.
  • Extensively used the XML, FLAT FILE, BULK INSERT AND FILE SYTEM control flow tasks and data flow tasks SSIS with also worked with Tivoli Data Protection TDP and TSM for backup of databases and scheduling the backups on the Microsoft SQL Server 2005/2008.
  • Diverse experience in Property and Casualty, Underwriting, Guidewire, Rating, Reinsurance and Life Insurance with also having experience with the Business Object report writing.
  • Worked on Client/Server tools like SQL Server Management studio, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server with also having experience in migrated SQL server 2000/2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
  • Experience in conducting requirement gathering sessions, feasibility studies, and organizing the software requirements in a structured manner with having experience in gathering business and technical requirements that would best suit the needs of the technical architectural development process.

Technical Skills:

SDLC,Catastrophe Modeling, Insurance, Reinsurance, People Management, Property Line of business, SQL, RUP, UML, Guidewire, Agile,Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008,ATDD ,Windows XP/95/98/NT/2000,XML, Mac OS X, DOS, UNIX, Linux,Oracle 8i/9i SQL Server 7.0 2000 Access 2000, MS SQL Server, DB2, C, C , HTML, Java, PL/SQL, ASP.NET. Rational Suite Requisite Pro, Rose, Clear Quest, Clear Case ,Qlikview,MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm,FLAT FILES,DoorsErwin Data Modeller 4x, Business Object Crystal Reports Business Definition Requirements,NWCS,GuidewireBillingCenter, GuidewirePolicyCenter, Business Process Analysis, Gap Analysis, Use Case Modelling Analysis, Business Environment and Market Research Analysis, OOAD, Business/Data Modeling,Win Runner, Load Runner, Test Director.

Work Summary

Confidential

SR. BUSINESS ANALYST

Responsibilities:

  • Interviewed Business users to gather requirements and analysed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Utilized corporation developed Agile SDLC methodology.Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
  • Working with the Guidewire development team to further develop our integration adapters and other integration mechanisms.
  • Developing custom integration programs to connect Guidewire applications with other internal and external systems.
  • Responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units underwriting, claims, reinsurance, actuary, accounting, and IT .
  • Conducted extensive requirement analysis using Rational requisite pro with also ran daily productivity reports for department through Business Objects.
  • Assisted the developers in performing data modeling, data validating and data mining using Cognos.
  • Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
  • Worked on Document for Version Controlling, to maintain up to date changes in the Documents.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
  • Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
  • Designed, developed, and implemented innovative sustainable Tableau reports. Supported effective rollout of reports, including training collateral.
  • Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
  • 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.
  • Record and maintain user profiles and data tables for the National Workers' Compensation System NWCS with also organize and prioritize system enhancement lists.
  • 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.
  • Currently involved in implementation of GuideWire product for Policy Center and involved in doing Requirements Gathering process by helping Business Users Business Analyst with technology insight and feasibility on various Technologies.
  • Established a RUP Rational Unified Process centric business analysis methodology.Development of a Data Warehouse for personal lines Property Casualty insurance .Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan.
  • Serve as Property and 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. Used SDLC System Development Life Cycle methodologies like the RUP and the Agile.
  • Deployment of QlikView documents using QlikView Management Console and QlikView Access Point. Use of QVS and QVD as and when required in the development process.
  • Responsible for Qlikview server management and maintenance CAL licensing, publishing dashboards, scheduling jobs and securing dashboard access .
  • Responsible for supporting the applications and working on production issues of Tableau.
  • SQL Server 2005 and 2008 data analyst providing analysis of legacy data stores, writing ETL using SSIS to load staging tables for enterprise data warehouse with also provide custom SQL reports and ETL for other analysts and external researchers. Consult with business process owners to develop rules for loading data.
  • Selected as a LOB representative for the development of The National Workers' Compensation System NWCS , a Siebel 8 based claims application with coordinated new system data set up and migration.
  • Worked with GuidewireClaimCenter's rich functional depth to end-to-end claims lifecycle management improvements.
  • Research and analyze technology available out on the market that would be possible tools for the project. Design, and implement a paperless employment profile environment for the business workforce from applicant status to hired, performance review, to termination.
  • Processed annuitant transaction to move their payout investment from one separate account to another .Performed requirement analysis, went through all the use cases and issue logs.
  • Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving.
  • Worked with GuidewireClaimCenter's rich functional depth to end-to-end claims lifecycle management improvements and gathered requirements around Underwriting, Billing, Insurance Claims Processing and Policy Administration System.
  • Implement and maintain Property Casualty e.g. bug-fix, data integration, version release systems of assigned customers.Worked on UAT testing and took signoff from the Commercial line of Property Casualty business users.
  • Helped design scope documents and the Request for Proposal RFP after extensive ROI analysis and coordinated with top management for the approval process.
  • Responsible for testing the Quote Purchase for both Auto and Home Property Insurance of the customers.Involved in Risk Assessment for each project.
  • Performed extensive Gap Analysis between the Company's Legacy System and Guidewire Billing System.
  • Performed analysis on enterprise data/report integration provided functional specification to development team to build Enterprise Reporting Systems. 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.
  • Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard with also implemented Data partitioning ,Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV's, DMF's, DTA, SQLCMD and dedicated admin connection, Common table Expression CTE .
  • P C claims investigation and loss determination by going over claimant's third party interview transcripts and other related documents provided by client with also review functional specifications and data from various data sources like mainframe, oracle, SQL databases and flat files.
  • XML processed in the Mainframe from the front end system called Claim Centre CC using GUIDEWIRE working with SQL SERVER Data.
  • Claims processing and reviewing related documents insured's claim files, loss pics, loss estimation documents, policy documents, coverage documents for at-fault determination.
  • Property Casualty insurance policies booking on client's online software with the help of Binders, Booking Request Forms, Rater, Compliance sheets, etc. received from underwriters.
  • Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for the user interface.
  • Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax/ Market claims to be paid or redeemed.Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate actions response, Currency, Free movement, Mutual Fund Order and execution, Non financial transactions and trading operational processing in Comerica's global wealth management platform.

Confidential

BUSINESS ANALYST

Responsibilities:

  • Reviewed the Project Vision document and specified the Scope, Stakeholders and the High Level Business Requirements.
  • Communicated extensively with users to define key requirements which included Operational and managerial reporting needs, Workflow management, Quoting and marketing needs, Policy life cycle, Claims management, Disaster recovery procedures.
  • Preparing exposure data, analyzing and interpreting Cat risk associated with General Property, Onshore Energy, Power Utility and Construction accounts.
  • Worked with catastrophic risk assessment models, property exposure and loss data along with other general insurance aspects.
  • Uses the Guidewire Claim Center for the claim management system for property and casualty insurance.
  • Worked with DBA's to develop and implement a workflow process from Data Mart to populate Qlikview dashboards. Utilized best practice methodologies.
  • Modeled use-case diagrams in Rational Rose to show end-user interaction with the personal information, loan information property information modules.
  • Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.,
  • Prepared sequence diagrams, class diagrams and activity diagrams to elaborate the behavior, structure and process flow for the use-case models.
  • Architected and deployed High Availability Clustered QlikView Shared Platform in all environments for the entire organization together with QlikTech.
  • Worked on reporting and estimates for Property Casualty P C on Guidewire ClaimCenter implementation and interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
  • Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
  • Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization with also created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
  • Worked on reporting and estimates for Property Casualty P C on Guidewire ClaimCenter implementation.
  • Performed sanity checks to ensure security and validation of online submissions. Included features to display contextual help in each section of the process.
  • Conducted interviews with users to elicit requirements test strategy pertaining to Navigability, User-Interface Design, transaction processing and work flow.
  • Developed test cases and for use-case models for the reports interface.Used Clear quest to report bugs and defects during UAT.
  • Assisted the technical writers to prepare user manual and online help giving an end-user perspective.
  • Ensuring Adherence to Standards and quality process set Creating schedules and monitoring progress to ensure quality timely deliveries .
  • Participated in GAP analysis around the identification of business rules and system process flows, user administration, requirements and assumptions.
  • Assisted Scrum Master to facilitate scrum meetings such as Sprint Planning meeting, Daily Scrum meeting, Sprint Review meeting, Sprint Retrospective meeting, and Backlog Refinement meeting.
  • Effectively used Object Oriented Analysis and Design OOAD to categorize and structure the requirement into logical grouping to avoid redundancy.
  • Analysis of data received through the broker for Commercial Property Insurance for General Property, Onshore, Power and Utility, Construction and Offshore line of business.
  • Application of limits and deductible when account is bound for all Lobs in Open Xposure OX and OPUS Open Property Underwriting Software software.
  • Analyze business requirements for a complex a Data integration Platform, working along with Stake-holders to identify and fill requirements gaps and manage documentation and hand-over to design team.
  • Exposure refine: Includes Refinement / Enhancement of key loss factors and attributes of Lloyds Market data i.e. including the occupancy profile of the insured and the core construction of the. Property hence forth Insure under Policy with the help of Exposure Source Database ESDB of RMS, GDT, Sanborn and other similar data sources.
  • Identified and documented issues, risks and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements.
  • Created data mapping templates and aided the development team to reduce the bandwidth of the project. Participated in User Acceptance Testing and Business-to-Business Transaction testing.
  • Synchronized and prioritized relevant defects and enhancement/system requests based on business requirements.

Confidential

BUSINESS ANALYST

Responsibilities:

  • Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
  • Created incremental refreshes for data sources on Tableau server.
  • Interacted closely with End users from Underwriting Claims teams and SMEs to understand and gather the business needs and requirements.
  • Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
  • Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for BML eBay PayPal.
  • Documented and implemented QlikView best practice approach for their Client Sales and Credit dashboards that were embedded in custom software using QlikOCX.
  • Performed extensive Gap Analysis between the Company's Legacy System and Guidewire Billing System and worked with project sponsor, project team and other stakeholders to determine project milestones and report on progress prepared communication and status reporting plan. Collaborated with various Property and Casualty Insurance P C insurance plans product.
  • Used Workflow statistics and front end query for performance tuning of predefined sessions and as per client requirement, prepared source data environment for various data bases, flat files with also built SQL queries Pl/Sql blocks for the project
  • Worked directly with business users to gather, document and implement requirements to improve Marketing campaign delivery capabilities including enhancement project management.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.
  • Meeting with multiple business units to gather and write functional system requirements that would allow the GuideWire product to be upgraded to a supported version while insuring that the all of the customized code would continue to function correctly.
  • 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.
  • Worked for a project to customize and integrate a Business Process Management BPM solution.
  • Developed automated Test Scripts in Win Runner using Test Script Language TSL for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
  • Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
  • Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring backup's of Tableau repository.
  • Debugged and fixed several production issues. Created Struts actions which encapsulate business logic of the application.
  • Conducted interviews with end-users to collect requirement and business process information and also worked with GuidewireClaimCenter's rich functional depth to end-to-end claims lifecycle management improvements.
  • Extensive knowledge on CSCs Banking and Insurance intellectual property IP products like Debt protection product - Convenience, Loan Default management product - Early Resolution and Core Banking Product Hogan.
  • 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.
  • Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.

Hire Now