Greg Ryan Email & Phone Number

Indianapolis, In, Us

Indianapolis, In, Us

Saint Louis, Mo, Us

• Installation, Development and Administration of MSSQL Servers and Databases • Backup/Recovery, Disaster recovery and performance tuning.• Logic Monitor installation and Configuration• Management of Customer SQL servers and Databases.• Data Engineer on multiple Data Warehouse Projects

Indianapolis, In, Us

• Installation, Development, and Administration of MSSQL Servers and Databases • Backup/Recovery, Disaster recovery, and performance tuning.• ETL development and administration Utilizing SSIS and Change Data Capture.• Design, and develop a Datawarehouse incorporating data from multiple internal and external Databases.• Fulfilled the following roles within the organization; SQL Administrator, SQL Developer, ETL Administrator / Developer, Data Engineer, Data Architect, Data Analyst, Azure SQL Administrator, Power BI Developer / Administrator + (Power Query, Excel), Report Admin / Developer (SSRS)Working with Stake Holders and Subject matter experts, designed, developed, and implemented a Data Warehouse. Designed the ETL from the various outside databases in SSIS and SQL to populate the Fact and Dimension tables. Implemented a Power BI environment for Dashboards and Reporting. This gave Management and stakeholders better insights into the data to help them make better business decisions.Designed and developed ETL process in SSIS and SQL to import data from two Proprietary / external databases into local Data Marts to be consumed by internal applications at intervals of 15 to 60 minutes. One of them uses Change Data Capture. Created validation to make

Noblesville, Indiana , Us

• Development and Administration of MSSQL Databases including installation, Backup/Recovery performance tuning.• Development of new applications, integration, and ETL between databases.• SSRS – Design publication and administration of numerous reports and Dashboards.• SSIS – Import and ETL from numerous heterogeneous data sources and integration with existing databases.• Design and administration of a data warehouse.• Development and administration of a custom VB application and the underlying database to handle contract management which includes account and distributor management, Sales representative and territory management, sales tracings, rebates and fees management, and sales commissions• M2M ERP administration, customization, and analytics.• Salesforce administration, development, and analytics.• Responsible for EDI and other inbound and outbound data between internal systems and outside entities• Working with Stake Holders and Subject matter experts, designed, developed, and implemented an application written in VB and SQL for contract and rebate management to replace an existing proprietary obsolete application. Gave the organization a replacement for an obsolete application that was adapted to the organization’s specific needs.Implemented Salesforce to replace and obsolete CRM, including migration of data from the previous system, development of custom objects to meet specific needs. Implementation of an IT Support Ticket system using Salesforce. This gave the organization a companywide CRM rather than individual installations, and customizations to better meet their needs.