Stephen Stephan Email & Phone Number

Jacksonville, Fl, Us

Atlanta, Georgia, Us

Provided support to multiple lines of business for reporting needs via SSRS report builder for new and modifications of existing reports for both website and company proprietary APIs. Successfully created SSIS packages to move data between SQL SERVER and GCP for cross-platform to and from HD Supply and parent company The Home Depot.Assisted in the migration of numerous database tables from Microsoft Azure to Snowflake inclusive of data ingestion and the scheduling of daily job runs to insure accurate data across all platforms. Created tables, triggers, stored procedures, SSIS packages for data normalization purposes from our staging environment to production.Created tables, triggers, stored procedures, SSIS package, and reporting to insure successful rollouts of new Pipeline, Special Order, and NPS Survey Plugin applications.Provided support in the Hospitality and Multifamily migrations of data between ERP and Snowflake, mapping of customers and associated data into Snowflake for each wave of migration.Provided data layer support for the EAF applications move to Google Cloud, including Assortment Suite, CrossFire, and Special Orders applications.Was purchased by The Home Depot July 22, 2015, rebranded Home Depot Pro in 2017 and later merged with HD Supply.

Charlotte, Nc, Us

Provided support to multiple lines of business, as well as creating numerous SSIS packages utilizing the ETL methodology, stored procedures, tables, views, and functions; implement best practices to maintain optimal performance. Converted all Legacy Microsoft Access Reporting databases into stored procedures in a SQL Server environment.• Successfully completed 65 reporting and analytic projects using SQL Server T-SQL Stored procedures for Insuring and Guaranty and the Review and Resolution departments.• Converted all existing Microsoft Access databases to SQL Server T-SQL Stored procedures, reducing production time from hours to seconds. • Created back-up contingency stored procedures to run off of a separate server than production as a part of a business continuity process when the primary server is unavailable.• Re-engineered all Stored Procedures, Views and Function to be put in place for switching database owner from DBO to RA.

Boca Raton, Florida, Us

Provided support to multiple reporting platforms, as well as provided analysis on migration strategy and automation of background tasks utilizing DOS Batch files, SQL Server DTS Packages, writing dynamic T-SQL Stored Procedures and functions as well as migration and development of MS Access 2007 and MS Excel 2007. • Created staging table environment to replace existing process of data transfer within MS Access to be replaced with numerous DTS packages and T-SQL stored procedures to ramp up efficiency. • Set all T-SQL Stored procedures to set isolation level read uncommitted as a best practice to avoid data locking. • Created indexes on all tables within SQL Server 2000 to optimize querying speed. • Made recommendation to back up and archive data older than two years to reduce current storage by over 60 gigabytes. • Converted Supervisor Reporting database process from MS Access to SQL Server utilizing IBM I-Series Data Transfer Form, Avaya CenterVu auto-scripts, DTS Packages and Stored procedure reducing processing time from 2 ½ hours to 30 seconds. • Created weekly appointments reporting, utilizing IBM Iseries Data Transfer Form, DTS Package, stored procedure and MS Access VBA to format subtotals in a multiple tab Excel 2007 workbook for corporate finance department.• Migrated all legacy MS Access 2003 databases over to MS Access 2007 platform.

Provided support to multiple Business allocations and clients across the company by designing dynamic solutions to database migration using Microsoft Access, VBA for Applications and T-SQL for numerous projects as well as providing detailed reports via stored procedures with Crystal Reports or Excel spreadsheets on an adhoc basis. Supported existing Web Reporting databases by making requested modifications to reporting, including new reports or tabs on existing database structure through allocated approved requests as well as making new entry and modification to the Tech Scheduler time release report launching program.• Provided detailed analysis of legacy applications and reporting for the purpose of migration from MS Access to SQL Server 2005 based on usage.• Successfully deconstructed Microsoft Access module Private and Public Functions and incorporated that data into T-SQL stored procedure making end product Crystal reports available for all internal and external clients.

London, Gb

Provided support to multiple call centers across the world by designing dynamic database systems developed using Microsoft Access, VBA for Applications, PL/SQL, T-SQL, Visual Basic, and Oracle SQL Developer for numerous projects as well as providing detailed reports on an adhoc basis while providing mentoring to other Business Analysts worldwide.• Managed and completed 133 assigned projects involving database creation, administration, automation and report generation.• Developed inline views utilizing PL/SQL for the purpose of generating numerous MIS Operational reports that supported ongoing functions and provided key insights into improving efficiencies.• Re-factored legacy VB application to more resilient, efficient, and modular architecture; retained ongoing support and administrative functions for application.

Data Processing/Business Administration

Certification, Windows 2000 Pro, Mous Xp

Dbase Iv, Lotus 1-2-3, Word Perfect