Frederick Mcgovern

Frederick Mcgovern Email and Phone Number

Specialized in: Advanced & Detailed Data Analysis, Data-Driven Process Improvement, and Technical Advisement @ Travelers
Frederick Mcgovern's Location
Halifax, Massachusetts, United States, United States
Frederick Mcgovern's Contact Details

Frederick Mcgovern personal email

n/a
About Frederick Mcgovern

With over 20 years of experience in data analysis and application development, I am a seasoned Data Analyst and Database Engineer with a proven track record in designing, analyzing, and implementing sophisticated database systems. My expertise includes architecting and modeling databases, consolidating and migrating data, and driving continuous improvement to enhance efficiency. I have a strong background in applying advanced analytical techniques and methodologies, including statistical modeling and machine learning, to derive actionable insights from complex datasets. My experience extends to project coordination and management, where I have successfully led projects through requirements gathering, planning, and execution. I am focused on advancing my career in Data Science and leveraging my skills to deliver data-driven solutions that drive strategic decision-making.My skills include: Data Engineering Advanced-Data AnalysisDatabase Design & QuerySolution DevelopmentBusiness IntelligenceTechnical Training & SupportProject CoordinationCollaborative PartnershipsDocumentation & CommunicationAdaptive Problem-solvingCross-functional CommunicationSystem Issue SupportMS Office & Data Tools• Data cleaning/loading/extraction using various ETL tools• Hadoop/Hive• Database Design & Query• Solution Development• Project Coordination• System Issue Support• Business Intelligence• Collaborative Partnerships• Thorough Documentation• Cross-functional Communication• Adaptive Problem-solvingThank you for your interest and taking the time to look at my LinkedIn page. I am proud to say that my hard-fought skills, experiences, and commitment to work have led to my current achievements. I am always interested, however, in learning about new challenges especially in the area of data modeling. Ultimately, I need to be challenged and would like to have a position that fully utilizes the skills that I have developed,

Frederick Mcgovern's Current Company Details
Travelers

Travelers

View
Specialized in: Advanced & Detailed Data Analysis, Data-Driven Process Improvement, and Technical Advisement
Frederick Mcgovern Work Experience Details
  • Travelers
    Data Engineer
    Travelers Sep 2021 - Present
    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.
  • Travelers
    Software Developer
    Travelers Oct 2012 - Sep 2021
    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.
  • Travelers
    Associate Information Engineer
    Travelers Oct 2009 - Oct 2012
    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.
  • Travelers
    Senior Information System Specialist
    Travelers Dec 2005 - Oct 2009
    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.
  • Travelers
    Actuarial Assistant
    Travelers Jun 2004 - Dec 2005
    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.
  • The Guardian Life Insurance Company Of America
    Processing Underwriter
    The Guardian Life Insurance Company Of America May 2000 - Jun 2004
    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%
  • Us Navy
    Electronic Technician - Nuclear Field
    Us Navy Jul 1985 - May 1989
    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.

Frederick Mcgovern Skills

Sql Server Access Rating Oracle Sql Database Design Etl Ssis Excel Word Sql Microsoft Excel Microsoft Sql Server Microsoft Word Insurance Data Warehousing Agile Methodologies Business Intelligence Cognos

Frederick Mcgovern Education Details

  • Dakota State University
    Dakota State University
    Analytics
  • University Of Denver
    University Of Denver
    Software Design And Programming
  • University Of Denver
    University Of Denver
    Database Design And Administration
  • Bridgewater State University
    Bridgewater State University
    Computer Science
  • Bridgewater State University
    Bridgewater State University
    Mathematics
  • Massasoit Community College
    Massasoit Community College
    Liberal Arts
  • Sacred Heart High School
    Sacred Heart High School
    High School Diploma

Frequently Asked Questions about Frederick Mcgovern

What company does Frederick Mcgovern work for?

Frederick Mcgovern works for Travelers

What is Frederick Mcgovern's role at the current company?

Frederick Mcgovern's current role is Specialized in: Advanced & Detailed Data Analysis, Data-Driven Process Improvement, and Technical Advisement.

What is Frederick Mcgovern's email address?

Frederick Mcgovern's email address is fm****@****ers.com

What schools did Frederick Mcgovern attend?

Frederick Mcgovern attended Dakota State University, University Of Denver, University Of Denver, Bridgewater State University, Bridgewater State University, Massasoit Community College, Sacred Heart High School.

What are some of Frederick Mcgovern's interests?

Frederick Mcgovern has interest in Collecting Antiques, Exercise, Home Improvement, Reading, Gourmet Cooking, Sql Server 2008 Dba, The Arts, Home Decoration, Net, Asp.

What skills is Frederick Mcgovern known for?

Frederick Mcgovern has skills like Sql Server, Access, Rating, Oracle Sql, Database Design, Etl, Ssis, Excel, Word, Sql, Microsoft Excel, Microsoft Sql Server.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.