Ryan Downing Email & Phone Number

Columbus, Oh, Us

Columbus, Ohio, Us

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.

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.

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

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

St. Louis, Mo, Us

Associates Degree, Information Technology

Bachelor'S Degree, Sport Management