Kerrell D. Williams
***** ******* **** ****.., #**** Jacksonville FL 32258 770-***-****
and/or *****************@*****.***
Expertise: Senior Business Analyst / Project Manager
Objective: To obtain an opportunity that will utilize my strong
analytical, developing, problem solving skills within a
live and testing environment
Education: Cleveland Institute of Dental and Medical Assistant=received a
Medical Assistant Diploma
Lakeland Community College = Majored in Business Management - No
degree
Employer: Syntel, Inc. - Lead Information Systems Analyst - (Kemper
Insurance ) - Property & Casualty Industry - Commercial Insurance
Date: 08//10 to Current
Responsibilities:
. Apart of the Development Team
. Validate the conversion process of the data values between COBOL and
XML for the PERS Ecosystem for ACORD
. Verify that data is passed through to the correct interface for (STAT
Reporting, General Ledger, Data Warehouse, DMV Report, Claims and
Billing)
. Verify the XML (structures, elements, xpaths and namespaces)
. Gather functional and non-functional requirements from the Business
Unit
. Creating functional and non-functional specifications
. Publishing the standardized data values into EBS
. Coordinating UAT
. Data Mapping
. Regression Analysis
. Analyze new requirements and system enhancements for the following
systems: PERS Ecosystem and Billing
. Document and management requirements within CaliberRM
. Content Management in Sharepoint
. Create the test plans, test cases, scripts, log defects and
requirement builds within Quality Center
. Performance testing; Methodologies: SDLC and Agile
. Create framework via VISIO and Paintbrush
. Managing off-shore and on-shore resources=includes task management
. Run queries via sql-TOAD
. Facilitate JAD sessions with SME's
. Defect Management
. Mentor Jr. Information Systems Analysts
. Validate / verify that messages are trigged, sequenced and generated
at its expected interval within the Message Assurance Service System
Environments: .NET in WEB arena, sql-TOAD, Message Assurance Service, EBS,
PERS Ecosystem, PLIS, RPW, EXCEED, Blue Cod, DFDC, CaliberRM, Quality
Center, Syntranet, webmail, People Soft, Paintbrush, VISIO, Sharepoint,
excel, Microsoft Word, XML, AS400, Web-Service, Rightfax, Oracle, Outlook,
Test Director, ACORD, Enterprise Manager, DTS Packages, Legacy, (Batch and
FTP files), Windows NT, Test Driven Development and multiple web browser
environments
Employer: JBA International, LLC - Ratabase Developer and Analyst -
(Farmers Insurance) - Property & Casualty Industry-Commercial Lines
Date: 01/10 to 05/10
Responsibilities:
. Apart of the Development Team
. Created and updated tables, codes, formulas and algorithms
. Developed the rating business logic using Ratabase 1.5
. Implemented rate revisions
. Unit Testing
. Validated the testing results
. Analyzed rating manuals in order to determine the rating similarities
and differences across multi-states (50)
. Prepared High and Low Levels Designs for Ratabase 1.5 as per the
Business Units requirements
. Coordinated UAT
. Methodologies: SDLC and Agile
Environments: Legacy CIS systems, AMS, TOS Mainframe, eZSD Web-based
applications, Ratabase 1.5, VPN, Word, Excel, Lotus Notes, SharePoint, Test
Director, extranet, sql-TOAD, Microsoft Net Meeting and AS400
Aon Servicing Group - Project Manager and Senior Business Analyst- Property
& Casualty Industry-Commercial Lines
Date: 09/08 to 01/10
Responsibilities:
. Apart of the Development, Production Support and Configuration Teams
. Managed time constraints and deliverables based upon Project Schedules
for small to large projects=15,000 + man-hours (Underwriting, Rating,
PMS, Claims and Accounting)
. Developed release strategies and schedules for Data Configuration,
Content and Production items (includes validating releases)
. Obtain code approvals for builds and releases
. Provided Level 3 Production Support
. Developed the requirements document and requirements specification for
web-based applications for (D&O/A&E)
. Managed on-site and offshore engineers (provided day to day work
direction) and generated reports
. Interacted with Clients within the US and Overseas
. Drove the project in order to deliver business results
. Troubleshooting (resolved critical production problems)
. Provided training and demonstrated demos of the AuMine product via
WebEx
. Coordinated performance testing, load testing, stress testing,
regression testing, integrating testing and UAT
. Developed business process mapping workflows and managed the
requirements within the scope
. Gathered Requirements and GAP Analysis
. Apart of the PeopleSoft HR time entry project (gathered requirements
and coordinated UAT)
. Compared the requirements against the system's capability in order to
make sure that the system meets the functionality and design needs
based upon the client requirements
. Developed test cases and BPM's
. Methodologies: SDLC, PMBOK, Agile and Waterfall
. Data Mapping, developed the Interface Design Specifications and
Business Acumen
. Ran queries using sql-TOAD, created paths in the system(s) and loaded
files into ClearCase
. Checked-in and checked-out files, defect management, recorded baseline
results and made recommendations
. Apart of the internal audit process for adhering to standard system
compliance for SOX
. wrote release notes, developed processes for generating the OFAC
files
. Liaison between IT Department, Upper Management, and Client
. Project Management (provide timeline and cost estimates) for
the(Energy and P&C Industry)
. Marketing and cross-selling
Environments: AuMine, AMS, Share Point, SOA, Team Foundation Server, POS,
Microsoft Word, Excel, Lotus notes, sql-TOAD, Oracle 9i and 10g, Snag It 8,
InRule, WinBroker, WebEx, Beyond Compare 2, EDI, Citrix, Test Tracker,
UNIX, AS400, Ecommerce, Microsoft Net Meeting, PeopleSoft, extranet,
Legacy, ClearCase, ClearQuest,VPN, Test Manager, Cache, Web Service, .NET,
Microsoft Project, ASP, Agile/Scrum, GUI, cognos server and multiple web
browser environments
Independent Contractor - KW Consulting Services - Project Manager and
Senior Business Analyst- (Data Scan Field Services)-Automotive Industry
Date: 05/08 to 09/08
Responsibilities:
. A part of the Development, Systems Rewrite, Production and Systems
Configuration Team
. Responsible for managing Jr. Business Analysts on a daily basis from
the Systems Rewrite & Configuration Team
. Regression analysis and testing
. Provided Level 3 Production Support
. Developed the technical and functional specifications for the
Automotive Financial Institutions (Warranty, Inspection, Audit,
Auction, Repossession, Repair/Service, Call-Center, and Consumer) web-
based applications for Ford, Toyota, Chrysler, JD-By-Rider
. Gathered requirements and developed system enhancements specifications
for the Production Department
. Wrote procedures and validated releases
. Trouble Shooting, provided feedback and made recommendations
. Created business process mapping workflows and developed traceability
matrix
. Liaison between IT Department, Upper Management and Client
. Managed small to large implementation projects for (Production
Support, System Rewrite & Configuration Team)=15,000 + man-hours;
Managed the requirements within the scope
. Data Mapping, GAP Analysis, facilitated JAD Sessions of 12 +
individuals and coordinated UAT
. Methodologies: SDLC, PMBOK, RUP, UML and Agile
. Identified the parent and child relationship for table databases
. Developed use cases and test cases
Environments: Visual Source Safe, SOA, POS, SAP/CRM, SharePoint, Visio,
Citrix, Web Service, Legacy, SQL Server, .Net, ASP, Oracle 9i, Great
Plains, ACD Application, cognos server, Service Power, MS Project, Word,
Excel, PowerPoint, Biz Talk, Outlook, Cache, extranet, Windows NT, UNIX,
Requisite pro, EDI, Team Foundation Server, ClearCase, ClearQuest,
Ecommerce, Hand-Held Device, Storyboard, GUI, RTI/Customer First, and
multiple web browser environments
TM Floyd and Company - Senior Business Analyst and Systems Consult
- (TOKIO MARINE) - Property & Casualty Industry-Commercial Lines
Date: 08/07 to 01/08
Responsibilities:
. A part of the Development and Systems Configuration Team
. Gathered requirements, reviewed manuals- circulars- rates-
classifications and rules for the collaborative method for documenting
countrywide and state specific requirements for Workers' Comp
. Developed state specific and country wide rating formulas from NCCI,
manuals and circulars for pricing Workers' Comp policies=formulas were
entered into Ratabase 1.5
. Regression analysis and testing
. Developed the technical and functional specifications for CL and PL
(Underwriting/Rating) web-based applications
. Developed BPM's
. Wrote procedures and validated releases
. Trouble Shooting, provided feedback and made recommendations
. Created business process mapping workflows
. Developed requirements traceability matrix
. Data Mapping, GAP Analysis, facilitated JAD Sessions of 12 +
individuals and coordinated UAT
. Identified parent and child relationship for table database
. Managed (off-shore resources) and assigned their daily work
activities
. Developed use cases and test cases
. Methodologies: SDLC, RUP, UML and Agile
Environments: Requisite pro, ClearCase, ClearQuest, Share Point, GUI,
Microsoft Word, Microsoft Office Outlook, Excel, Windows NT, UNIX, Oracle,
TFS, Ratabase, NCCI, Legacy, Ecommerce and multiple web browser
environments
Revolution Technologies - Lead Senior Business Analyst and Project
Management - (AXIS CAPITAL) - Property & Casualty - Reinsurance Industry
/Finance Industry/TPA /MGA)-Commercial Lines
Date: 02/07 to 7/07
Responsibilities:
. A part of Development & Interface Team
. Developed Technical & Functional Specifications for (Cash, AP, AR,
GL, Claims and Coverage) automation purpose for web-based
applications; developed BPM'S
. Gathered requirements and wrote procedures
. Developed the requirements document and managed the requirements
within the scope
. Developed the Interface Design Specification
. Developed MGA and TPA Premium Receivable Matrixes, developed the
(Premium/Claims/Underwriting Bordereau Matrixes) for Workers' Comp,
General Liability, Commercial Auto, Property, Specialty Lines, Excess
and Umbrella
. Downloaded files and generated/ran reports
. Defect management and provided feedback and made recommendations
. Change & Records Management
. Viewed and manipulated Table Database
. Verified compatibility, developed workflow processes
. Regression and integration analysis
. Coordinated UAT, facilitated JAD Sessions of 12 + individuals, GAP
Analysis and Data Mapping
. Reconciliation and created pivot tables
. Created business process mapping workflows
. Troubleshooting and developed requirements traceability matrix
. Developed use cases and test cases
. Managed (off-shore resource) and assigned their daily work activities
. Liaison between IT Department, Upper Management and Client
. Methodologies: SDLC, PMBOK, RUP, UMP and Agile
Environments: Visio, SOA, Microsoft Word,, POS, SAP/CRM, Microsoft
Office Outlook, Excel, Access, Microsoft Project, Visual SourceSafe, Share
Point, Citrix Applications, EDI, Microsoft Project, Windows NT, Claims
Managing System, Ecommerce, PeopleSoft, .Net, UNIX, Oracle,,TFS, IRISH,
ClearQuest, ClearCase, Requisite pro, SQL and multiple web browser
environments
Bearing Point - Senior Business Analyst - (FFIC / Liberty Mutual) -
Property & Casualty/Finance Industry-Commercial & Personal Lines
Dates: 09/05 to 02/07
Responsibilities:
. Gathered Client's requirements for Workers' Comp, General Liability,
Property, Commercial Auto, Private Passenger Auto, Home Owners and
Umbrella
. Provided written analysis based upon the clients requirements
. A part of Development and Interface team
. Developed and designed functional and technical specifications for
the (Rating Engine, AR, AP, GL and Cash modules) based upon the
clients requirements
. Created use cases and test cases based upon design specifications for
client-server and web applications
. Developed BPM's
. Managed the requirements within the scope and developed the Interface
Design Specification
. Verified the compatibility, developed workflow processes and gaps
between the system and functional specification for CL and PL
(Underwriting / Rating Engine) web - based applications
. Mentored Jr. BA'S and QA'S
. Liaison between IT Dept and End User
. Documented countrywide and state's specific requirements for (KLU, WC,
PVO, CAR, PPA-PTC, CLUE, WC and Homeowners)
. Defect management, provided feedback and made recommendations
. View and manipulated table database
. Developed test cases and test scripts
. Developed and designed web-based applications
. Regression analysis and testing
. Validating releases
. Data Mapping and SQA
. Identified problems and made acceptable recommendations
. Risk Management, Change / Records Management and Business Acumen
. Familiar with Metadata and Taxonomy
. Methodologies: SDLC, UML, RUP and Agile
Environments: Legacy, SQL Server, POS, Ecommerce, CIS, EPAS, MS Access,
Designer Access, iRise, ISO, PMS,PI IWIN, AMS, Word, Excel, Access, XML,
.Net, HTML, EDI, TFS, Java, Oracle, GUI, Windows NT, PeopleSoft, AS400,
SQL, ClearQuest, ClearCase, ISO, NCCI, Share Point, Test Manager, VPN,
Portfolio Management, Requisite pro, Cache, Unix, Lotus Notes and multiple
web browser environments
LCJ - Contractor PM / Lead Analyst - (Webroomz) - Education Industry
Dates: 05/05 to 09/05
Responsibilities:
. Created/updated use cases/ test cases/test scripts based upon design
specifications for mainframe and web-based applications
. Executed test scripts, logged defects via Request Tracker and Defect
Management
. Made recommendations
. Regression and integration analysis/testing and manipulate table
databases
. Troubleshooting and ran queries
. Provided timeline, cost estimates and managed small to large
projects=15,000 + man-hours
. Interrupt flow-charts
. Tested web-based applications
. Liaison between Client and IT Dept.
. Directed other QA resources
. Coordinated UAT
. Verified traceability matrix and verified encrypted results shared
between two applications
. Auditing
. Cross-reference between different databases
. Methodologies: SDLC, UML and Rup
Environments: .NET in WEB arena, POS, SQL Server, ClearQuest and Test
Manager, AMS, Citrix, Oracle, Unix, AS400, Excel, Basic Visio, Ecommerce,
Microsoft Word, Outlook, Test Director, Enterprise Manager, DTS Packages,
Windows NT and multiple web browser environments
Insurance Overload Systems - Contractor Lead Business Analyst -
(Crawford and Company) -Property & Casualty / Claims -- (TPA ) Industry-
Commercial Lines
Dates: 02/04-03/05
Responsibilities:
. Provided analysis expertise on the implementation of a new web based
claims intake applications for Workers' Comp, General Liability,
Commercial Auto, Private Passenger Auto, Property and Home Owners
policies
. Gathered requirements and developed technical/functional
specifications
. Developed use cases, test cases and recorded baseline results based
upon the client's specified requirements and functionality for (web-
based applications, mainframe and client-server)
. Reviewed account set up specifications for completeness and accuracy,
ran test scripts, recorded actual results and compared actual results
against expected results
. Provided written analysis on failed test script results
. Regression analysis and testing
. Made recommendations on how to resolve discrepancies between actual
and the expected results
. Trained new QA resources and monitored their progress
. SQA, Troubleshooting, Data Mapping and Auditing
. Developed project plans and Risk Management
. Familiar with web-based and client-server applications
. Defect Management, provided an ad hoc management report on testing
results and application data and prioritized daily workload based on
backlog
. Created the test case, test plans and test scripts
. Liaison between Clients and IT Department
. Managed off-shore resources
. Provided timeline and Cost Estimates
. Bonded at Crawford and Company
. Methodologies: SDLC, RUP and UML
Environments: Test Director, Cache, AS400, Citrix, Unix, SQL, .Net,
Rational Clear Quest, ACD Application, Test Manager and Requisite pro,
Excel, extranet, Windows 2000 NT, Lotus, Oracle, e Comply, ISO, NCCI,
Ecommerce, Right Fax, Policy Management Systems, Claims Managing System and
multiple web browser environments
Progressive Insurance Company - Senior Business Analyst-Property &
Casualty - Commercial Lines
Dates: 01/94-10/99
Responsibilities:
. Created use cases and test cases
. Record the baseline results based on specific Underwriting and Rating
engines for CL and PL web - based applications
. Reviewed account set up specifications for completeness and accuracy
for Mainframe and Client-Server
. Gathered Requirements
. Documented requirements for countrywide and state's specific for PL
and CL
. Apart of the pilot team that developed state specific and country wide
rating formulas from (Proprietary information, ISO, NCCI, manuals and
circulars in order to price General Liability, Commercial Auto,
Private Passenger Auto, Commercial Property, Private Passenger Auto
and Workers' Comp policies)=formulas were entered into Ratabase 1.5
. Regression analysis and testing
. Provided written analysis on the clients requirements
. Developed the functional and technical specifications, ran test
scripts, recorded the actual results and compared the actual results
against expected results
. Provided written analysis on failed test scripts results and offered
recommendations on how to resolve defects
. Developed the rating formulas
. Risk Management
. Coordinated UAT, Defect Management and developed the business process
mapping workflows
. Mentored Jr. BA's and QA's resources
. Liaison between the Underwriting Department and IT Department
. Provided ad hoc management reports based upon testing results
. Methodologies: SDLC and RUP
Environments: Right Fax, POS, pro-rater, Call Center, Polaris, Mobius/App-
Suite, Excel, Ecommerce, Ratabase 1.5, NCCI, ISO, Microsoft Word, Lotus
Notes, extranet, Windows NT, Policy Management Systems, Citrix, Unix,
Oracle, AS400 and multiple web browser environments
Cleveland Eye Clinic - Jr. Business Systems Analyst and EKG Technician-
Healthcare Insurance Industry
Dates: 11/88 to 06/91
Responsibilities:
. Analysis
. Gathered requirements for the following implementation processes:
Front Office, Out-patient Admissions, Records Management, medical
coding=ICD -9, billing, diary, notes, charge and posting payments
. Developed workflow processes for filing Medicare and Medicaid claims
. Manuel testing, wrote test scripts and logged defects
. Multi-tasking and prioritized daily work-load
. Documented Requirements
. Wrote procedures
. Troubleshooting
. Facilitated EKG's
Environments: Dos, Mainframe, Private & Public Unified Systems, Single
Unified System, HCPM, MACC and Med Star