Sign in

Data Project

Columbus, Ohio, United States
April 25, 2019

Contact this candidate


Abdul Wahab



6+ years of extensive experience in the field of Business analysis and Business Data Analysis in different vertical markets such as Insurance with Guidewire Suite.

Experience working on GuideWire ClaimCenter, PolicyCenter & BillingCenter.

Involved in documenting customization requirements and business rules for the Implementation of Guidewire ClaimsCenter and PolicyCenter.

Focused on the project is to create new policy administration system using Guidewire Policy Center focusing on personal auto policies with pre-fill, predictive model, monthly policy level billing and new billing system.

Experience in full SDLC in various SDLC methodologies such as waterfall, agile, and scrum in fulfilling general and specific user requirements gathering, Use Case design and analysis, Use Case specifications, Scenarios, Business processes improvements, manufacturing Work flow diagrams, process flows, wireframes and technical documentation, using Unified Modelling Language (UML)/Visio, MS Office Suite, SharePoint.

Familiarity with Agile team concepts like burn down charts, story cards, and stand-up meetings.

Experienced working with Software Development Life Cycle (SDLC), like Waterfall/Agile/Scrum methodologies and knowledgeable in Test management/Software Testing Life Cycle (STLC).

Expertise in conducting Brainstorming sessions, JAD Sessions, one-on-one interviews, and workshops with business users, Subject Matter Experts (SME's), and other stakeholders for requirements gathering.

Conducted gap and impact analysis and created Source to Target Mapping (STM) documents for data migrations

In-depth knowledge of writing Business Requirement Documents (BRD), user stories, acceptance criteria and Functional Requirement Documents (FRD) as well as liaising with Developers and Analysts ensuring Test Strategy, Test Plans and Test Cases are conducted in line with Project goals.

Experienced with using SharePoint and updating documents with SharePoint on a regular basis

Expertise in GUI testing and functional testing.

Proficient in writing user stories, capping them in product backlogs, prioritizing product backlog items (PBI's) for sprints backlog and creating and updating Burn down Chart in MS Excel

Proficient using JIRA to manage test cases and defects.

Extensive experience in data Visualization and BI tools and technology such as Qlikview and Qliksence.

and creating report layouts.

Advance knowledge of Excel for using Pivot tables, Power Pivot.

Extensive experience in creating the interactive dashboards in Power Pivot Dashboard reports that were presented to Business Users, Program Managers and End Users.

Extensive experience in creating the interactive dashboard and Reports in Qlikview and Qliksense for monitoring the operation performance on day to day basis.

Independent yet team oriented with excellent analytical, problem solving, multi-tasking, oral and written communication skills.

Exceptional organizational, interpersonal and communication skills; highly motivated team player and self-starter with leadership and team management skills.


MBA- University of South Australia, Adelaide, Australia

BS in Computer Science- Edith Cowan University, Perth, Australia


Database systems: SQL Server, MS access, Aginity Work Bench (Neteeza), Aginity Work Bench (RedShift),

BI/ Reporting tools: Qlikview, QlikSense, MS Excel

Other tools: MS Office (Word, Excel, Power Point), MS Project, MS Visio, JIRA,

Work Authorization- US Citizen


State Auto Insurance, OH JAN 16 – Present

Sr. Business Analyst


Gather business requirements through interviews, JAD sessions and observations and created the Business Requirements documentation for building UI for viewing data through Guidewire Policy Centre.

Participated in the development of Guidewire - Policy Center User Stories.

Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire ClaimsCenter and PolicyCenter.

Involved in the implementation of the Guidewire Policy Center for Personal Lines (Auto, Home & Umbrella) system.

Used business analysis techniques, documented business requirements to be readily used by Guidewire configuration analysts and also worked on Property and Auto products using Guidewire Application.

Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire Policy Center.

Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.

Documented User Stories and facilitated Story Point discussions to analyse the level of effort on project specifications

Worked with stakeholders, subject matter experts, process owners and users to elicit and document needs, expectations, constraints and external interfaces using various methods.

Identified inconsistencies and gaps within a business process description and collaborated with stakeholders to clarify and simplify complex processes.

Developed the Business, Functional and Non -Functional requirements by translating the needs, expectations, constraints and interfaces into a User Story format understandable to both clients and technologists.

Involved in driving the creation of Unified Modelling Language (UML) diagrams such as Activity Diagrams, Use Case Diagrams, Flow charts and Process Flow Diagrams.

Supported Development and Testing phases of the SDLC, by conducting walkthroughs of requirements, providing clarification and facilitating issue resolution.

Provided signoff of deliverables of Development, Testing and Implementation.

Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.

Actively conducted SCRUM meetings and ensured all Agile project techniques are used in accomplishing the tasks based on the dead-lines.

Involved in designing, testing, publishing, maintaining, and supporting QlikView & QlikSense applications.

Built QVDs, QVWs, QVFs using source systems like SQL Server, Excel files, Sales Force, Aginty Work Bench (Redshift and Neteeza)

Created Excel reports, PowerPoint reports and Word Reports using NPrinting tool.

Involved in analysing the data and defining Key Performance Indicators (KPI).

Simplified complex expressions in the dashboards and improving front end.

Helped end users to perform competitive metrics both visually and detailed by multiple attributes by using the Sales Dashboard.

Validated the data in the Data warehouse and Data Marts by running the SQL queries.

Built ad-hoc reports for business data analysis based on the end user requirements & distribute the reports to the end users.

Developed reports in QlikView and in NPrinting and email the reports to the end users.

Provided the updated status reports to the managers on daily, weekly and monthly basis.

Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.

SansAmerica, Edison, NJ Dec 14 – Nov 16

Data Analyst/Business Analyst


Extracted data from SQL Server into data marts, views, and/or flat files for Qlikview and Qliksense consumption using T-SQL.

Designed, implemented and maintained the databases, reporting and dashboards based on business needs and requirements.

Involved in the requirement analysis and identifying sources and targets.

Create QlikView & QlikSense dashboards using different objects and expressions.

Identified data issues and provide recommendations for resolution to ensure optimal performance.

Executed functional and end-to-end testing as required on GUI and Mainframe applications.

Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.

Involved in Designing Star Schema, Creating Fact tables, Dimension tables and defining the relationship between them.

Worked on data analysis using SQL, T-SQL and many other queries-based applications.

Provided key initiatives in working with users in defining project and system requirements.

Review client business requirements to identify gaps in the Guidewire product. Worked with the product managers to find resolutions to the product gaps.

Created User Story Index explaining the development life cycle consisting of 'Release Planning' and 'Iteration Planning' phases.

Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams and Conceptual Data Models in MS Visio.

Analysed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.

Worked with the Business Objects developers to provide input for generating automated and ad- hoc Business reports.

Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.

Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.

Authored progress and completion reports, which were then submitted to project management on a weekly basis and interacted with business users to analyse the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables

Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team

Create User Acceptance Test scenarios and coordinate user acceptance testing.

Ensured goals and objectives of the business to deliver guidewire functionality changes.

Reviewed Test Plan and Test Cases of guidewire billing centre provided by Testing Team.

Involved in design and implementation of Progression and Regression Tests for the new guidewire functionalities.

Managed bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.

Geico, Laurel, MD Sep 13 – Oct 14

Business Analyst


Prepare Functional test flows for personal lines auto (major) and property policy administration quick quote and full applications.

Worked with Guidewire Suite to initiate projects and resolve defects in the Policy Center Module.

Worked explicitly on Policy Center implementation, Guidewire Rating engine, Data Mapping and Document Management System.

Worked in Guidewire Claim Center projects both in integration and configuration.

Participated with the business team in the creation/completion of project charters and project scope for Guidewire Billing & Policy Center projects.

Prepare Functional test flows for personal lines auto (major) and property policy administration quick quote and full applications.

Performed ODS (Operational Data Store) testing for different commercial and personal lines policies whose policy data is extracted in Guidewire and Policy Administration Systems.

Created and owned various User Story and Process Flow diagrams.

Worked closely with Guidewire Developers to understand the GW Billing center functionalities.

Created User Story Index explaining the development life cycle consisting of ‘Release Planning' and 'Iteration Planning' phases.

Addressed and resolved all billing issues by working closely with Accounts Payable, Receivables, Sales and Project Managers.

Worked on the data mapping which acts as a mediator between Rating engine and Policy Center screens.

Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.

Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.

Analysed information garnered within billing cycle and provided billing related information to project stakeholders through reports and other communications.

Facilitated requirements gathering sessions, including leading discussions, managing group dynamics, and maintaining group focus, to work towards accomplishing the stated goal(s) of the session within the context of the project objectives.

Participate in the development of Forms User Stories.

Write business requirements and business rules for the Forms.

Map Guidewire Policy Center UI details with the Forms attributes.

Design proprietary forms by using Nuance PDF and Adobe Pro.

Participate in daily defects triage meetings and give required inputs.

Participate in state rollout workshop meetings.

Work closely with the Policy Center team to find and resolve the gaps between Guidewire Policy Center and Forms.

Work Closely with Policy Center team to setup the coverages and help Policy Center team to create story cards according to the required forms.

Work closely with Integration team to make them understand Forms business requirements and data requirements.

Create and maintain forms tracking documents such as PIDs and Products Specs.

Analyse field level to form level business requirements.

Write Forms Inference, packaging and sequencing business requirements.

Work with QAs to make sure test scenarios are as per the business requirements, reviewing the test results to give the Product Signoffs.

Contact this candidate