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.• Supported Consumer and Agent Services through an enterprise-wide project specific to dataintegration.• Provided metrics to the Consumer and Agent Services Vice President for enhanced decision-making:1. Agency New Business policies written compared to previous years.2. Agency specific depopulation data for Agency Field Managers.3. Hurricane specific data with respect to agents and direct policy impacts.4. Aggregate and display Voice of the Customer survey data by agency/agency field manager forappropriate interventions.• Supported accounting in compiling data and administering email mail merge for commissions owedby Agencies from 2011 to present.• Setup a SQL server database to import and securely store sensitive claims Acuity data.• Developed an early warning weekly email for Vendor Management Office Vice President for upcomingcontract expirations.• Created a Human Resource employee delta report to manage activation/deactivation of IT accounts.• Mentored data analysts on the Systems & Operations team.• Trained data analysts on the basics of SQL Server Management Studio

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.• Provided reconciliation reporting for management analysis to ensure integrity of Data Warehouse priorto enterprise month-end delivery.• Led prioritization sessions for ranking of Business Unit initiatives.• Reviewed and updated SDLC documentation detailing changes to processes.• Triaged Data Warehouse defects and provided root cause analysis.

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.).• Represented division in various internal/external IT meetings (e.g., CORE)

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.• Active participant in several Joint Application Development sessions with external clients.

* 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.• Analyzed Probable Maximum Loss (PML) and catastrophic analysis.• Determined the adequacy of reinsurance contracts.• Designed and maintained an internal tracking database.• Updated and maintained an internal compliance spreadsheet for compliance testing.• Participated in determining which IT projects the Department should pursue.• Participated in the implementation of CORE Navigator (an enterprise-wide company tracking system)

Prepared periodicals to be sent for binding.

Mba, Business Administration And Management, General

B.A., Political Science