Ryan Downing

Ryan Downing Email and Phone Number

Data Warehouse Team Lead @ Encova Insurance
Columbus, OH, US
Ryan Downing's Location
Columbus, Ohio Metropolitan Area, United States, United States
Ryan Downing's Contact Details

Ryan Downing personal email

n/a
About Ryan Downing

Ryan Downing is a Data Warehouse Team Lead at Encova Insurance. He possess expertise in business requirements, business analysis, requirements gathering, sharepoint, sdlc and 33 more skills.

Ryan Downing's Current Company Details
Encova Insurance

Encova Insurance

View
Data Warehouse Team Lead
Columbus, OH, US
Website:
motoristsmutual.com
Employees:
350
Ryan Downing Work Experience Details
  • Encova Insurance
    Data Warehouse Team Lead
    Encova Insurance
    Columbus, Oh, Us
    View
  • Encova Insurance
    Data Warehouse Team Lead
    Encova Insurance Mar 2023 - Present
    Columbus, Ohio, Us
    View
  • Encova Insurance
    Senior Etl Developer
    Encova Insurance Feb 2017 - Mar 2023
    Columbus, Ohio, Us
    o Designed and developed ETL objects from Guidewire’s Insurance Suite (Policy, Billing, and Claim Center) into our Data Warehouseo Lead Developer on conversion from SQL Server 2008 to SQL Server 2014 which included over 500 SSIS packages and 4 SSAS cubes.o Converted all existing 2008 SSIS packages from a package deployment model to a Project deployment model.o Set up environment variables for all packages to make deployment to new environments easier.o Created dacpac’s for all database objects to help improve deployment and source control. o Developed multiple SSIS packages to retrieve FTP files for an incremental claims solution.o Created claims ETL solution for our Hadoop data lake using HIVE-sql.o Responsible for on-call production support for Data Warehouse.
    View
  • Safeauto
    Sr. Etl/Sql Server Developer
    Safeauto Aug 2013 - Feb 2017
    Winston-Salem, Nc, Us
    o Develop executive and management level reports using SSRS o Create SSIS packages for our new Data Warehouse. o Create various complex Stored Procedures using T-SQLo Create dimensions and facts within an OLAP cubes using SSASo Work with business partners to help them better understand and access data in our warehouse. o Perform Validation Testing for our new Data Warehouse Projecto Set up SharePoint site to store Executive Monthly Reports and OLAP Cubes.o Create and design a Fact table and multiple dimensional tables as part of a data mart.o. Lead Business Analyst and Developer for Guidewire Claim Center reportingo Familiar with Star and Snowflake Schemas.
    View
  • Safeauto
    Business Analyst
    Safeauto Aug 2012 - Aug 2013
    Winston-Salem, Nc, Us
    - Lead Business Analyst for Guidewire Claim Center Reporting- Developed multiple Claim Center Reports for Finance using SSRS - Worked as the BA on the integration team for Guidewire Policy Center and Claim Center- Managed 11 concurrent integrations for Guidewire Implementation project- Experience in Agile environment writing User Stories and Acceptance Criteria- Experience analyzing user needs and existing functions to determine business requirements- Act liaison between business units and IT- Experience gathering, analyzing information needs and functional requirements from stakeholders and business owners
    View
  • State Auto Insurance
    Business Systems Analyst Ii
    State Auto Insurance Oct 2007 - Aug 2012
    o Create and review requirements.o Worked on Intergration team for Guidewire Claim Centero Translate requirement docs to Analysis & Design/Tech Spec Documents.o Execute multiple projects from inception to delivery.o Experience analyzing user needs and existing functions to determine business requirementso Maintain and update DB2 database tables using SQL.o Prepare and execute detailed system test plans and matrices.o Daily production support for billing and claims systems.o Independently interpret and analyze detailed information to identify potential issues.o Implemented an automated workflow for production support using Microsoft InfoPath. Executed roll-out and training to multiple users. o Developed weekly management reporting package
  • State Auto Insurance
    Claim Specialist Ii
    State Auto Insurance Oct 2003 - Oct 2007
  • Enterprise Rent A Car
    Management Trainee
    Enterprise Rent A Car Dec 2002 - Sep 2003
    St. Louis, Mo, Us
    View

Ryan Downing Skills

Business Requirements Business Analysis Requirements Gathering Sharepoint Sdlc Sql Requirements Analysis Claim Analysis Db2 Data Warehousing General Insurance Insurance Microsoft Sql Server Tfs Ssrs Property And Casualty Insurance Integration Agile Methodologies User Stories Business Process Mapping T Sql Ssis Etl Visio Systems Analysis Testing Integration Testing Business Intelligence Databases System Testing Waterfall Guidewire Sql Server Integration Services Mainframe Tso Xml Quality Center

Ryan Downing Education Details

  • Franklin University
    Franklin University
    Information Technology
  • Bowling Green State University
    Bowling Green State University
    Sport Management

Frequently Asked Questions about Ryan Downing

What company does Ryan Downing work for?

Ryan Downing works for Encova Insurance

What is Ryan Downing's role at the current company?

Ryan Downing's current role is Data Warehouse Team Lead.

What is Ryan Downing's email address?

Ryan Downing's email address is ry****@****uto.com

What schools did Ryan Downing attend?

Ryan Downing attended Franklin University, Bowling Green State University.

What skills is Ryan Downing known for?

Ryan Downing has skills like Business Requirements, Business Analysis, Requirements Gathering, Sharepoint, Sdlc, Sql, Requirements Analysis, Claim, Analysis, Db2, Data Warehousing, General Insurance.

Who are Ryan Downing's colleagues?

Ryan Downing's colleagues are Deb Johnson, Scott Roese, Lisa Whited, Katherine Dodson, Ted Nixon, Susan Hummel, Gwendolyn Scruggs.

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.