Frederick Mcgovern Email & Phone Number

New York, Ny, Us

Build and operationalize complex cloud based data solutions including extract, load and transform data, recommend data cleansing/quality solutions.Design and create data products, data pipelines and integrate and deploy into solutions.Perform exploratory analysis of data sources to determine value and recommend data to include in analytical processes.

New York, Ny, Us

I developed new and upgraded existing applications and performed data analysis and quality control for the Fortune 500 insurance company’s main office.Notable highlights include: Created applications, data warehouses, and data extracts utilizing a variety of languages, tools, and database engines, including XML, Python, Visual Basic/C#.Net, Hadoop, Hive, SSIS, Linux, Oracle, SQL Server and Teradata. Implemented scripts to create schemas to clean and parse data extracts from internal and third party vendors and store data into Hadoop and Hive databases and tables. Independently developed an extensive application to translate policies from a legacy system to Travelers’ current rating production environment saving the company ~$1.8M in vendor support expenses.  Developed and tested a new ETL tool (over a weekend) used to translate data from existing policies into XML documents for conversion to 3rd-party systems and, ultimately, saved the company $120K in vendor costs. Performed application and report upgrades for the Travelers MI custom applications team to support the transition to current versions of SQL Server and application servers and, ultimately, improve execution speeds by ~54%. Conducted analysis, including time estimates, determined system issues, and implemented changes in development. Executed QA testing and production signoff of applications for business units requesting modifications and enhancements. Documented and provided transfer information sessions to transition new and upgraded applications to production support.

New York, Ny, Us

I developed components as an associate engineer supporting business objectives of the insurance company.Notable highlights include: Solely developed PSSR SQL Server database components, including DB structure modeling, database objects definition and creation, ETL process development (SSIS packages), back-end stored procedure generation, and QA testing. The database was a major data store component of the Business Intelligence (BI) architecture and supported multiple applications and reporting. Developed Billing SQL Server DB components, including modeling, ETL, object creation, stored procedures, and QA, utilizing VBA and MS Access to extract billing data from reports of another system ultimately saving $3M in SW development costs. Modeled and created TMARater SQL Server database components allowing departments to view 20+ rate versions, identify and correct errors in the SAS rating database, and to project renewal premiums. Increase efficiency, accuracy, and control of data by creating an Underwriter Renewal Decision tool using SQL Server data objects, ETL processing to control information flow from multiple applications, and a distributed MS Access front-end for data entry.

New York, Ny, Us

I developed SQL Server and Oracle database solutions working closely with business units of the insurance company.Notable highlights include: Performed database logical and physical modeling and normalization, PL/SQL package development, and QA control and developed stored procedures, functions, views, and SSIS packages. Conducted Oracle PL/SQL tuning by removing cursors and replacing them with collections resulting in up to 95% faster runtimes. Collaborated with developers and mid- to senior management in other business units to define application requirements and provide technical guidance.  Authored user and technical documentation for processes and applications used by TIS and other business units.

New York, Ny, Us

I contributed as a High Loss Ratio Producer committee member and assisted the lead actuary in determining appropriate auto and homeowner IBNR reserve levels by maintaining earned premium, reserve, and loss ratio triangles Excel reports.Notable highlights include: Developed enhanced MS Access DB to make multi-million-dollar cession decisions utilizing cost model parameter estimates developed in a SAS environment. Developed applications to enable sales managers to identify fraud and to assist agents in identifying profitable business.

New York , Ny, Us

As a Processing Underwriter, I gathered documentation and evaluated submitted applications for Health, Dental and Disability Insurance.  Automated process to issue Health Net health care plans resulting in an increase in the issuance of plans by 300% Created Word macros for account specialists and risk underwriters to automate all correspondence sent to plan holders and brokers increasing team productivity by 30%. Developed a Visual Basic.Net program to interact with Powerstack script files for use by underwriting department improving accuracy as measured by quality control to 98.1%

Washington, Dc, Us

• Served as Reactor Controls Audit program supervisor and Squadron Two Engineering Assistant both with extensive administrative responsibilities.• Operated, maintained and repaired reactor control and instrumentation equipment on board nuclear powered submarines.

Masters Of Science, Analytics

Master'S Of Applied Science, Software Design And Programming

Master'S Certificate, Database Design And Administration

Bachelor Of Science, Computer Science

Bachelor Of Science, Mathematics

Associates Degree, Liberal Arts

High School Diploma