Erik Sampsell Email & Phone Number

Atlanta, Georgia, Us

Project Owner and Subject Matter Expert for SQL Server to Snowflake Migration (2023 - Present)Spearheaded a high-impact migration project, leading a cross-functional team of 35 SQL Developers, QA Analysts, and Talend Developers.Successfully converted over 200 SQL Agent/SSIS jobs and 200+ SSRS reports to a new architecture utilizing Snowflake, Talend, Tableau, and SSRS with ODBC connections.Ensured seamless integration across critical business units, including Sales, Collections, Credit Administration, Finance, Compliance, Fraud, Customer Service, and Operations.Responsible for architecture, development, and support of internal, financial partner and merchant reporting and data analysis. Responsible for development and support of data integration with financial partners, clients, and vendors. Technologies used include SQL Server, SSRS, SSIS, SSAS, MicroStrategy. Manage and mentor developers. Responsible for SOX audits, credit bureau reporting, and finance partner reporting.

Provide database and reporting solutions to small and medium-sized companies utilizing SQL Server, SSIS, SSRS, Mark Systems IHMS reporting.

New York, New York, Us

• Designed and built SQL Server 2005 database to maintain daily Mutual Fund and Index Data.• Designed and developed SSIS Packages to retrieve files via FTP and load data into SQL Server Database.• Designed and developed a series of SQL Reporting Services reports as requested by client.• Designed and developed 2 VB.NET applications to import word document-based financial notices into SQL Server 2005.• Designed and developed Visual FoxPro 9 application to do financial analysis of mutual fund data.

• Served as the sole Database Architect for the Travel Syndication Technologies (TST) application. The TST application is a joint effort of 4 AAA/CAA clubs to provide a retail interface to various suppliers in the travel industry.• Designed database architecture to support the TST application.• Designed tables for client, supplier, and customer data.• Created a trigger-based audit system to track record-level data changes.• Created SSIS packages to load supplier product information into the database.• Designed and developed indexes and stored procedures to search the supplier data.• Designed the backup and recovery strategy for the 4 application environments (QA, UAT, Training, and Production).• Maintained extensive number of standard and supplier-specific lists and created the mappings between them.• Instrumental in creating solutions that would allow the application to map between lists from heterogeneous sources.• Provided on-call database support to the application development team.• Assisted the client's customers in designing data and reporting requirements for various systems.

Las Vegas, Nv, Us

• Designed, Developed and supported a SSIS package that downloaded debit card transactions from Chase and updated a banking transaction database.• Developed Crystal Reports for debit card activity.• On rotation for 24/7 support of 10 large (100+ gb) production SQL Servers Databases housing the DAS Application that handles real-time pari-mutuel wagering.• Supported an IVR (Interactive Voice Response) wagering system from a MySQL DBA perspective.• Performed New and Maintenance SQL development on the DAS application which contains approximately 700 stored procedures, functions and views.• Performed system administration duties for 20 development and test servers; installed Windows and Linux OS, SQL Server, MySQL.• Configured and supported Playertracking software on kiosks that are in-use at various horse tracks by players.• Performed on-going SQL DBA activities such as scheduling backups, re-indexing tables, monitoring server performance on production and non-production servers.• Performed and Analyzed SQL Server differences between productions sites to determine codes changes necessary for upgrading the DAS application.• Created and executed upgrade scripts and procedures to support software version upgrades for the DAS application.

Charlotte, Nc, Us

• Designed, Developed and supported an Internet site that utilized ASP.net, Web Services, and SQL Server 2005 to support the Vendor Program in the Global Trade Solutions Group.• Designed and Developed a Windows Service in VB.NET and SQL Server 2000 that generated emails to clients and financial partners notifying them of status changes in the Vendor Program.• Created a ASP.NET Web Service to interface with PocketPCs for RealTrac Application.• Guided a group of mainframe developers through a conversion of a 30 yr old COBOL Factoring application that processes $5 Billion per year in transactions to a vendor-written Visual Basic 6/SQL Server/ASP 3-Tiered application.• Designed and Developed SQL Server 2000 and Visual Basic 6 supporting applications for the Factoring Application.• Converted a highly complex Real Estate Construction Loan application written in Visual FoxPro 7 to VFP 9 with a SQL Server 2000 back-end. • Converted numerous legacy FoxPro 7 routines to stored procedures for RealTrac Application.• Converted data for 35 separate offices from VFP to SQL Server 2000.• Maintained the operating environment of the new Factoring Application in development, Q+A, and Production. This environment consists of 3 SQL Servers, 2 SQL Clusters, 6 Application Servers, 1 Web Server and 1 Web Application Server.• Provide primary support (24/7/365) for the Factoring Application with one other resource.

Us

• Designed and developed ASP.NET customer service tool utilizing VB.Net and SQL Server.• Designed and developed software applications utilizing SQL Server (DTS Packages, Stored Procedures, Triggers) that automate the processing of banking applications.• Designed and developed the reporting software that generates customer applications, management reports, and customer correspondence utilizing SQL Server, Visual Basic, and Crystal Reports.• Administered SQL Server Databases that stored all banking applications and customer information. Handled backups and restores, change control procedures, creating, monitoring, and scheduling jobs.

Worked on projects as a software developer for The Coca-Cola Company.

Johns Creek, Georgia, Us

Ms, Computer Information Systems

Ba, Economics

Education record