Robert Denham Email & Phone Number

Florida, United States

Manage a team of 3 Reporting Analysts responsible for a variety of internal and external data requestsData Management contact responsible for monthly data downloads & updates from various data warehouses, text files, CSV & XML to team’s local SQL Server utilizing SSISResponsible for the Database Management of the team’s SQL Server including the security of all relational databasesAssisted in developing and designing business and reporting solutions to improve data quality

Florida, United States

Utilize SQL Server programming to query various data systems and data warehousesData Management contact responsible for monthly data downloads & updates from data warehouse to local SQL ServerResponsible for automating queries used for recurring monthly reportingUtilize SSIS to simplify loading of external data to use in satisfying DOI inquiriesPrimary Analyst for Florida Hurricane Catastrophe Fund (FHCF) Annual ReportingAssisted in developing and designing business and reporting solutions to improve data qualityAssists with system support analysis for new and existing insurance products ensuring adequate data was available for DOI responses

Utilize SQL Server programming to query various data systems and data warehousesData Management contact responsible for monthly data downloads & updates from data warehouse to local SQL ServerResponsible for automating queries used for recurring monthly reportingUtilize SSIS to simplify loading of external data to use in satisfying DOI inquiriesPrimary Analyst to provide data support to Compliance team for all Market Conduct & Premium Tax ExaminationsPrimary Analyst for Florida Hurricane Catastrophe Fund (FHCF) Annual Reporting, Wind Pool, Voluntary Credits & Beach/Coastal Reporting for Alabama, South Carolina, North Carolina, & Florida.Assisted in developing and designing business and reporting solutions to improve data qualityAssists with system support analysis for new and existing insurance products ensuring adequate data was available for DOI responsesPrepared adhoc data reports for internal and external clients to include auditors and accountingCreated technical documentation for responses to DOI data calls

Designed and implemented tables, functions, stored procedures and triggers in SQL Server 2012Experience in creating, modifying and executing SSIS packages.Transformed existing Access reporting databases to SQL Server utilizing SSISBuilt data connection from SQL Server to Teradata serverBuilt data connection from SQL Server to Tableau serverResponsible for designing data structures, reports and loading data utilizing SSISTransformed existing Excel pivot tables to Tableau Desktop v8.2Create macros through VBA coding to automate formatting of client reports

Florida, United States

Utilize SQL Server programming to query various data systems and data warehousesData Management contact responsible for monthly data downloads & updates from data warehouse to local SQL ServerResponsible for automating queries used for recurring monthly reportingUtilize SSIS to simplify loading of external data to use in satisfying DOI inquiriesPrimary Analyst to provide data support to Compliance team for all Market Conduct & Premium Tax ExaminationsPrimary Analyst for Florida Hurricane Catastrophe Fund (FHCF) Annual Reporting, Wind Pool, Voluntary Credits & Beach/Coastal Reporting for Alabama, South Carolina, North Carolina, & Florida.Assisted in developing and designing business and reporting solutions to improve data qualityAssists with system support analysis for new and existing insurance products ensuring adequate data was available for DOI responsesPrepared adhoc data reports for internal and external clients to include auditors and accountingCreated technical documentation for responses to DOI data calls

IBM AS400 Mainframe System / TSO on IBM 3090 / CCS Online SystemProcess daily, weekly & monthly reports by extracting data from AS400 mainframe system and importing into Excel or Access for delivery to the end-clientSchedule nightly production jobs for client deliveryPerform Transfer of Service for Lender loansProvide Production Job Run Status to clientsCreate macros through VBA coding to automate formatting of client reportsCreate technical documentation for creating client reports