Roger C. Carson Email & Phone Number

Tallahassee, FL, US

• Developed integrated Power BI reports for the various internal/external customers.
• Created an agent/agency report detailing book of business and property claims history.
• Provided metrics for an enterprise-wide dashboard on FEMA Flood policies and potential legislativeimpacts to Citizens.
• Provided various dashboards detailing private market insolvent carriers and policy growth impactsto Citizens.
• Devised and implemented solutions for measuring underwriting and agent turnaround time.
• Automated operational reports for Consumer and Agent Services utilizing SSIS packages.

Tallahassee, FL, US

• Performed month-end reporting of policies in-force, total exposure, and other key insurance metrics.
• Tracked monthly Citizens Data Warehouse (“CDW”) defects related to company-wide integrationimplementation for Senior Management review.
• Created and executed ad-hoc reports for business units via internal Data Store.
• Maintained historical and present Cognos License spreadsheet for accountability and audit compliance.
• Utilized “Agile” methodology to create and deliver reporting User Stories to Business Units to ensurereporting needs were met upon delivery of Core implementation solution.
• Assisted in determining Data Warehouse data quality issues and provided solutions to ETL developers.

Tallahassee, FL, US

• Led BA team in performing complete process flow mapping and redesign among various work functions.
• Built small maintainable databases to assist work units in performing their duties expeditiously.
• Performed QA testing on behalf of the division for numerous production enhancements and fixes.
• Trained all new Business Analysts and Business Operations Specialists in Jacksonville Auditing unit toprepare reports for management.
• Drafted requirements to enhance/modify various enterprise-wide internal custom IT applications (e.g.,ePAS, eWIND, FMAP, AAS, ARS, ACP, etc.).
• Queried Citizens Data Warehouse for reporting to management (e.g., Board of Governor’s meetings,program evaluation, etc.).

Brisbane, AU

• Gathered requirements to integrate several distributed policy systems into one enterprise-wideapplication.
• Analyzed and documented client processes through process flow redesign and recommendedsignificant improvements to existing procedures.
• Acted as the central point of contact for the coordination of multiple projects for a company-widehurricane preparedness project.
• Created test strategies and executed test cases for major releases.
• Tested several significant vendor enhancements and fixes (i.e., Alpha, Beta and regression testing).
• Utilized MS Office tools and PL/SQL Developer to query databases to determine actual versus expectedtest results.

* Project Management

Tallahassee, Florida, US

• Examined Florida domestic insurance companies for statutory compliance.
• Analyzed financial statements and conducted solvency and liquidity tests.
• Determined the reliability and accuracy of financial data to ensure compliance.
• Conducted financial trending of insurance companies.
• Trained new examiners in the Property and Casualty Solvency area.
• Provided the Florida legislature with relevant data for policy decisions.

Prepared periodicals to be sent for binding.

Mba, Business Administration And Management, General

B.A., Political Science