Stephen Stephan Email and Phone Number
Stephen Stephan work email
- Valid
- Valid
- Valid
- Valid
Stephen Stephan personal email
Stephen Stephan phone numbers
At HD Supply, data integration isn't just a task—it's a mission to streamline operations and ensure immaculate data accuracy across platforms. With a wealth of experience as an Application Engineer, I've taken the helm in crafting and executing ETL processes that bolster business reporting capabilities, fortifying our organization's data management infrastructure.My commitment to excellence shines through in the seamless migration of databases to Snowflake and the meticulous creation of SSIS packages that bridge SQL Server and GCP. These efforts, alongside my expertise in Snowflake, have not only enhanced cross-platform operations but have fundamentally transformed our approach to handling and normalizing data within our complex IT ecosystem.
Healogics, Llc.
View- Website:
- healogics.com
- Employees:
- 1799
-
Healogics, Llc.Jacksonville, Fl, Us
-
Application EngineerHd Supply Feb 2014 - Nov 2024Atlanta, Georgia, UsProvided 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. -
Reporting & Analytics Cons Prod Strategic Analyst IiBank Of America Nov 2010 - Dec 2013Charlotte, Nc, UsProvided 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. -
Data Analyst Ii - Ops SupportAdt Security Services Apr 2009 - Oct 2010Boca Raton, Florida, UsProvided 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. -
Database AnalystInteractive Resources Sep 2008 - Mar 2009Provided 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.
-
Senior Mis Business Information AnalystHsbc Aug 2004 - Aug 2008London, GbProvided 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.
Stephen Stephan Skills
Stephen Stephan Education Details
-
Jones CollegeData Processing/Business Administration -
National Computer Science AcademyMous Xp
-
Florida State College At JacksonvilleWord Perfect
Frequently Asked Questions about Stephen Stephan
What company does Stephen Stephan work for?
Stephen Stephan works for Healogics, Llc.
What is Stephen Stephan's role at the current company?
Stephen Stephan's current role is Application Engineer at HD Supply | SSRS, SSIS, Data Migration.
What is Stephen Stephan's email address?
Stephen Stephan's email address is ss****@****ast.net
What is Stephen Stephan's direct phone number?
Stephen Stephan's direct phone number is +190438*****
What schools did Stephen Stephan attend?
Stephen Stephan attended Jones College, National Computer Science Academy, Florida State College At Jacksonville.
What are some of Stephen Stephan's interests?
Stephen Stephan has interest in Politics, With An Emphasis On Ssrs, I'm Currently Studying Sql Server 2005, Jet Sql(Ms Access) And Pl/sql, Science And Technology, In Its Application, Animal Welfare, I'm Still New To T Sql.
What skills is Stephen Stephan known for?
Stephen Stephan has skills like Microsoft Sql Server, T Sql, Database Design, Ssis, Crystal Reports, Etl, Microsoft Office, Pl/sql, Ssrs, Access, Business Objects, Stored Procedures.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial