Khan_K
docx
keyboard_arrow_up
School
Arizona State University *
*We aren’t endorsed by this school
Course
400
Subject
Information Systems
Date
Nov 24, 2024
Type
docx
Pages
8
Uploaded by CommodoreHorse875
Khan
Sr. Data/Business Analyst
khan.mali2m@gmail.com
PROFESSIONAL SUMMARY:
●
8+ years of experience as a Business/Data Analyst in P&C Property/Casualty with solid understanding and capturing Business Requirements, Business Process flow, Business Process Modelling, Data Analysis, SWOT analysis, and Business Analysis.
●
Expertise and hands on experience of migrating and upgrading insurance suite solutions to Guidewire solutions as well as integrating third party solutions to
Guidewire solutions.
●
Working knowledge about policy Underwriting, Binding, Rate making rules and factors affecting it, Rewriting and Worker's Compensation.
●
Well versed in claim management i.e. FNOL, Claim Setup, Payment and Recovery, Fraud Detection Tools, Litigation, Subrogation and Salvage.
●
Comprehensive knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile, RUP, Waterfall.
●
Experience with Data cleansing, Data Validation and creating Source to Target Data Mapping documents, creating Metadata documents and Source to Target data comparison.
●
Strong experience in Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
●
Project Management experience, especially in Project Planning, Project Design and coordinating / managing multiple BI and DW projects.
●
Extensive experience in testing and implanting Extraction, Transformation and Loading of
data from multiple sources into Data warehouse using Informatica.
●
Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse
●
Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
●
Experience in working in close proximity with
Business users, project stakeholders, Subject Matter Experts (SMEs) and staff to understand high level
business requirements and minute level specifications for new applications, and to modify existing applications.
●
Adept in performing GAP Analysis to check the compatibility of the prevalent system infrastructure with new business requirements.
●
Proficient in Requirements Gathering, Surveys/Questionnaire Development, Business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD)
●
Extensively experienced at convening Joint Requirement Planning (JRP) sessions with Business User 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 of
business.
●
Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
●
Working experience in writing T-SQL, working with DTS, SSIS/SSRS, Data Cleansing, Data Scrubbing and Data Migration.
●
Exceptional in creating screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams, business process flows, and in developing Use Case Diagrams, Behaviour Diagrams (Sequence Diagrams and Activity Diagrams) based on the
UML Methodology.
●
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.
●
Actively participating in Post Production Validation (PPV), production support, and handling of issues.
●
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 loading
data to the database using tools such as Guidewire Data hub.
●
Proven track record in data collection, 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 Hub Center, SSIS, MS Excel (VLOOKUP, Report
and Dash Boards, Pivot Tables), PL/SQL, SQL, C, XML, HTML, Data Management, Data Migration, 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 Server 2007 & 2010, Axure RP Pro 6.5,
Bugzilla, Jira, Agile (scrum), Waterfall, BABOK, CMMI, BPR, Six Sigma (DMAIC), GuideWire PolicyCenter, ClaimCenter & BillingCenter,
The Insurance Application (TIA)
PROFESSIONAL EXPERIENCE:
Universal Insurance Company, Sarasota, FL Dec 18 - Present
Sr. Business Analyst / Data Analyst
Universal Insurance Company, a Commercial and Personal lines carrier with operations in the
United States has selected Guidewire Insurance Suite to support transforming its core operations including underwriting, policy administration, rating, billing, and claims management. Guidewire insurance suite adopted comprised of PolicyCenter, BillingCenter, ClaimCenter within add on modules like data hub and
Guidewire Live. Personal lines were the
first be part of the migration followed by commercial lines and worker's compensation insurance. 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 process Guidewire PolicyCenter Integration during different iterations and
phases in Software Development Life Cycle (SDLC).
●
Performed data integration and data mapping and data extraction management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter with Guidewire DataHub.
●
Deriving the scope of testing by identifying the data flow from Rating systems and GuideWire Data hub.
●
Working with PolicyCenter integration requirement with Docs and Forms, BillingCenter, Rating, Customer Data 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 -
ISO feed for providing Premium, Claims (Losses, Reserves) data to support Regulatory
Reporting
●
Managed requirements for the implementation of more than 20 internal and external data
feeds, including ISO, 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 various Data Management strategy components such as incremental delivery of an Enterprise Data Warehouse, utilization of a data lake for ETL offload, legacy systems archive, and a data integration hub.
●
Involved in Fine tuning of database objects and server to ensure efficient
data retrieval.
●
Responsible for getting approval of newly redesigned build Forms from Forms compliance
team.
●
Interacting with Guidewire team and providing requirements for Forms
data based on out of box feature of Guidewire
●
Based on analysis of legacy Forms data and stakeholders need interacting with Guidewire team 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 to data processing, user interface, and downstream system interactions.
●
Developed detail Data Mapping document for generating Workers Compensation compliance reporting through Policy Center.
●
Use analysis and experience to ensure data is properly mapped from the OLTP system to the staging area to the Claims Data Warehouse.
●
Reviewed the data model and reporting requirements for Cognos Reports with the Datawarehouse/ETL and Reporting team. Wrote several SQL scripts for massive data extracts and manage the data conversion and extraction process.
●
Worked on Informatica ETL Data Integration tool to migrate the data, to create mapping from source to ODS (Operational Data Source) and then to Target of Netezza Appliance.
●
Processed in the Mainframe from the front end CC, BC, PC & RC systems, using GUIDEWIRE working with SQL SERVER Data.
●
Successfully conducted JAD sessions to facilitate
business process 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.
●
Experience with complex SQL queries for
data profiling for Data ETL Integration tool.
●
Worked closely with technical services group coordinators to provide full support of formsimplementation
●
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.
●
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, business rules, 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 the business specifications and design documents.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Nationwide Insurance Group, Phoenix, AZ May 16 - Nov 18
Business Analyst / Data Analyst
This Program is to implement the Gudiewire for Nationwide Insurance Policy & Billing Center. Includes data conversion from legacy IPM application.
Data read from Guidewire data hub and facilitate data to Guidewire Info center and downstream systems through data extraction layer (views).
Responsibilities
:
●
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 the data model of legacy application and data flow to different legacy application streams.
●
Perform Gap analysis for different attributes in legacy system vs
Guidewire.
●
Complete the design for data extraction from Guidewire Policy center to Guidewire data hub.
●
Involved in developing the ETL jobs for data extraction from Guidewire to Data hub.
●
Participate in data conversion strategy and implantation on multiple phases.
●
Also worked as an Enterprise Data Hub (EDH) Business Analyst and partnered with the EDH 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 developing Informatica Mappings to load data from Source Systems to EDH(Enterprise Data Hub) and then to Data Mart.
●
Participated in integration of MDM (Master Data Management) Hub and data warehouses.
●
Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
●
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 the data model and reporting requirements for Cognos Reports with the Datawarehouse/ETL and Reporting team. Wrote several SQL scripts for massive data extracts and manage the data conversion and extraction process.
●
Interacted with the SME's to analyze the Data Extracts 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 ●
Used Data warehousing for Data Profiling to examine the data available 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 for
Guidewire
●
Used Agile SDLC to ensure new business processes 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.
●
Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of BusinessProcess Management (BPM)
●
Documented and reviewed business process 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
Transamerica, Cedar Rapids, IA Y Aprl 14 – Aprl 16
Business Analyst
Transamerica Reinsurance is a front runner in life, annuity, commercial, auto, medical-
professional liability, capital assets insurance, financial services companies and other P&C insurance in North America, Latin America and Asia-Pacific. The project was to provide improvements to TARSAS, a product of Transamerica
Reinsurance, a PC based reinsurance administration system to help desk support and consulting services. The system can interface with policy administration systems, provide data extracts to other systems, accept premium rate and reserve factor files. Responsibilities
:
●
Actively involved in brainstorming and JAD sessions with the stakeholders in order to identify all the business requirements for project development.
●
Successfully performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), both personal and commercial, and ensured that contributors and all key stakeholders were motivated to
Complete assigned tasks.
●
Dexterously managed the requirements (Business
as well as Functional requirements), performed requirements analysis along with the creation of Use Case Scenarios. Modeling
of the business and application using Rational Unified Processing (RUP) and Unified Modeling Language (UML)
●
Primarily responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation & Verification process for capital asset and
business owner insurance - commercial lines.
●
Developed Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD)
●
Expertly performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system for Treaty and Facultative Reinsurance.
●
Worked with the Project Manager on various Project Management activities like keeping track of Commercial line modules, Project Status, Deadlines, Environment Request, and Compliance Issues.
●
Performed Defect Tracking and Change Control Procedures using Rational Clear Quest and Configuration Management and Version Control using Rational Clear Case.
●
Developed exceptions report which were then submitted to project lead and stakeholders on a regular basis (for both P&C commercial lines)
●
Constantly worked with the development team to make sure that they understood the user requirements for P&C insurance and that the system developed met those requirements.
●
Actively participated in developing test plans and test procedure templates and guidelines to be used by the project team with detailed screen layouts with regards to various types of corporate actions.
●
Managed bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.
●
Incessantly involved in the development of Test Plans, Test Cases and Expected Results, and coordinated the tests with the QA team to verify implementation of new features and enhancements.
●
Gathered user and business requirements through interviews, surveys and prototyping. Stored and modified requirements in MS Word.
●
Primary responsibility includes writing business rules and creating system requirements by setting up meetings with project managers, architects, developers, testers,
business, designers, legal, and other stakeholders. It also includes creating and updating user stories.
●
Discuss out of the box (OOTB) features with business and development team. Proposed and implemented minimal changes to save development time and satisfy business needs.
●
Proactively identify inefficiencies in system and proposed changes to increase system accuracy and cost effectiveness.
●
Working on understanding "as is" processes and helped to define "to be" processes to streamline the processes and make them more effective.
●
Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
●
Conducted Change Analysis for the improvement of the existing system and recommended the required changes using Rational Clear Case.
●
Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using Rational Rose.
●
Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
●
Involved in the entire project life cycle (SDLC) from evaluation, installation, configuration and development of end user reports.
●
Gathered and analyzed the business reporting requirements with the existing Data source
and suggested the changes in the data source.
●
Created the universes based on the user classes and their hierarchy in the organization at
different aggregations.
●
Specified the standards for universes, Classes, Aliases, Help text, Simple and complex objects.
●
Created user groups and managed access privileges using
Business Objects Supervisor. Maintained Business Objects universes.
●
Created the Test cases and SQL scripts to verify the results and performed bug tracking using Clear Quest.
Farmers Insurance, Los Angeles, CA Sep 12 - Mar 14
Business Data Analyst
Farmers insurance provides a wide variety of insurances ranging from Auto/Home to commercial; it is one of the leading Property & Casualty insurance companies, which provides various insurance products for personal and commercial lines of
business to the customers through independent network of insurance agents. Farmer sells its insurance through a web application known as Point of Sale. The application is used by Farmers Insurance independent agents and Hub users (Farmers Employees). This application supports backup for different lines of businesses like Personal Auto, Homeowners, Commercial Auto, Business owners, Workers Compensation and Claims.
Farmers Insurance Group agents have their marketing and accounting
data in 2 different systems. This made record keeping a huge problem over time and the
data is not in sync
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
between 2 systems. ACE application full fills this gap and allows to have both marketing and accounting information in a single source.
Responsibilities
:
●
Analysis of Business requirements and preparing Business Requirement/Use Case scenario document.
●
Work with the core development team to ensure the
business requirements are understood and incorporated into the software development project.
●
Analysis of business requirements and system requirements of the client and also for Property and casualty modules
●
Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines ofbusiness (Fire, Auto, Commercial)
●
Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
●
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 for data validation, 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 specific data set from Operation database(ODS) by using PL/SQL query in order to data cleansing 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 the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
●
Facilitated business requirements 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 and Business.
●
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 for property and 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, other Business analysts, developers, testers and Systemanalyst of interfacing applications like Claims, Billing, Customer Communication, Data warehouse, Data Solution.
State Farm Insurance, Bloomington, IL Aug 11 - Aug 12 Business Analyst
RSPE (Rating Simplification Process Enhancement): This project involved the simplification of rating rules for easier quoting in agent's office, online or CCC thereby providing a foundation for future pricing, reducing the need for agents and increase automation. This falls under the
company's main effort called as Integrated Customer Platform (ICP) aims at simplifying, integrating and transforming the customer experience.
Responsibilities
:
●
Engaged in Business Case Development and research initiatives with
Business and Systems Executives for Rating Changes to enhance Auto Process Guide and/or Code Manual for completeness and update to ensure that the
business partners 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 to
business rules and screen behavior for the RSPE and Auto Quote Process.
●
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 its
data to Excel to identify trends, themes, and root causes and report on rating issue key measures and business areas, 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,
Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards.
●
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, Claims Dataand Appointment Logs, Auto Estimations, Fire Claims etc.
●
Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
●
Used SQL and MS Excel for all Data validation based on the Business Rules.
●
Working with clients to better understand their needs and present solutions using structured SCRUM approach.
●
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.
●
Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.