Robert Carlisle Copes

ad3l6k@r.postjobfree.com

(313) 214 - 9321

Senior Database Developer/Architect

Education

Western Michigan University, Kalamazoo, MI 1999

Bachelor's Degree Computer Information Systems

Lawrence Technological University, Southfield, MI 2025

Master’s Degree Computer Information Systems

Skills

●Servers and Database: Microsoft SQL/Server, PowerBI, NoSQL, Oracle ODI, Oracle CPQ, Oracle PL/SQL, MySQL, SSIS, SSRS, Informatica, Kafka, Redgate, Redgate SQL Monitor, SQL Century disaster recovery architecture deployment for always- on environments

●Architecture Upgrades: Custom Salesforce migration to Subscription Database designed in Microsoft SQL/Server, Diagram 3NF, Snowflake Cloud DBMS, Data Flow Diagram, Data Definition Language, Microsoft SQL upgrades from SQL 2000/20012 to SQL 2014/2017/2019; Migration of Source Control from legacy source control systems such as Harvest to Microsoft Team Foundation Server Migration of legacy AS/400 reports to custom systems designed with Microsoft technologies.

●Networks: Middleware development with Jitterbit and Visual Studio 202X, EDI, Azure, AWS, web-services, API development, monitoring for report and load balance considerations, configuration of database servers, encryption methods such as PGP and SQL/Server native

●Application Technologies: Alteryx, Jitterbit, Expert with Microsoft TSQL, Oracle PSQL, PowerBI, Python,MongoDB, NoSQL database, Visual Basic.Net, PowerShell, Jitterbit, Visual Basic for Applications, AXData, programming in Microsoft Word, Excel and Access. FoxPro, DOS, BASIC, PASCAL, COBOL and RPG Reporting: Tableau, PowerBI, Alterxy, web-based forms, data extracts and streams along with API analysis and deployment. Expert at performance tuning and monitoring reporting systems.

Work Experience

Best Buy Health, Novi, MI Oct 2021 – Nov 2022

Senior Database Architect

●Update, add stored procedures with advanced TSQL, modify existing tables, deploy Snowflake, Sybase, Alterxy, SQL Objects to database containing MicroKey for facilitation of emergency response by Customer Service Representatives at Best Buy

●Analyze existing system architecture and provide database solutions for NoSQL, MongoDB, Azure, AWS, Snowflake, Sybase for automation of existing disparate systems via ETL with Alteryx or Windows PowerShell

●Participate in daily SCRUM meetings and lead other developers to size projects for future initiatives for data streams.

●Prototype Jitterbit solution for Middleware migration

Reason for gap – Freelancing employment (June 2021- Sept 2021)

NFI Industries, New Jersey, NJ Feb 2021 – May 2021

Senior EDI Developer

●Document existing EDI mappings from SQL/Server Stored Procedures with TSQL for upgrade from Sterling Integrator to Jitterbit middleware

●Modify existing stored procedures that support EDI mapping, create test plan for code change and participate in production deployments/

●Maintained AWS database documentation and analysis of complete Middle-ware replacement.

●Maintained EDI database objects in SQL/Server database to facilitate ETL.

Reason for gap- Freelancing employment. (Nov 2019- Jan 2021)

Circor, Monroe, NC Aug 2019 – Oct 2020

Senior Database Architect

●Support of daily ETL process for Azure data warehouse by resolving load errors in SSIS packages and stored procedures and analysis of TSQL code for efficiency and update to company standards.

●Support EDI, Oracle CPQ quotation and Microsoft Dynamics customer relationship management systems through customizations requested by management.

●Maintained data streams and deployed PowerBI for senior management financial analysis as well as propose new MongoDB solution for data lake

●Migrate to Jitterbit from custom API middleware by recreating all functionality in Jitterbit, Python and Powershell

Catalysis, Seattle, WA Sept 2018 – Jun 2019

Senior Database Architect

●Design and implement Azure, MySQL, and Azure database objects and documentation such as stored procedures, tables and indexes, Entity Relationship Diagrams, System Architecture diagrams for support of web applications

●Interpret business requirements to document development (such as Snowflake implementation), and functional specifications and implement code to the production environment.

●Support ETL process, TSQL scripts and database objects for data warehouse, data streams, triage errors and implement solutions.

Reason for gap – Working on Freelance projects. (Sept 2018 – Aug 2018)

Bank of America, Charlotte, NC Mar 2018 - Aug 2018

Senior Applications Programmer

●Modification of existing SQL/Server stored procedures,TSQL scripts, and tables for ETL process enhancements

●SSIS package modifications that included resolving production problems and new feature implementation.

●Testing of new SQL/Server for application upgrade project.

Reason for gap- Freelancing employment. (Nov 2017- Feb 2018)

Wells Fargo, Charlotte, NC Jul 2017 – Oct 2017

Database Analyst 6

●Advanced T-SQL logic built for the purpose of creating staging tables, cleansing data, and inserting to data warehouse Snowflake dimensional model.

●Testing of new SQL/Server for application upgrade project

●Provided custom data sets to end users for extensive unit testing of new data source load to data warehouse.

●Analysis/Design of SSIS to replace Informatica load from staging tables to data warehouse

Reason for gap – Working on Freelance projects. (Apr 2016- June 2017)

LendingTree, Charlotte, NC Nov 2015 – Mar 2016

Senior SQL Architect

●SQL/Server automation using SSIS packages, stored procedures, and agent jobs

●Agile/Scrum meetings and correspondence for software deployment

●TSQL programming for credit report soft inquiry analysis

Integration Point, Charlotte, NC Apr 2010 – Nov 2015

Senior Content Database Developer

●Design and develop ETL solutions through extensive usage of SSIS and SQL/Server and advanced TSQL for automation of content data collection

●Highly automated SQL Server for ETL from hundreds of Government Agencies for global trade data consolidation for over a thousand clients

●Migrated entire companies Salesforce data to custom solution that integrated with Subscription database maintained in SQL/Server

Dominion Enterprises, Norfolk, VA Apr 2009 – Apr 2010

Senior Database Administrator

●Create and modify stored procedures, TSQL scripts that are called from web user interfaces

●Debug existing SSIS packages, agent jobs and stored procedures in response to error reporting and server activity.

●Conducted data migrations from third party databases to create a consolidated database system.

Reason for gap – Working as Freelancer (Mar 2007 – Mar 2009)

Master Data Center, Southfield, MI Aug 2002 – Feb 2007

Lead Applications Developer

●Develop, maintain, and enhance several Access, VB and Microsoft SQL/Server applications supporting and automating internal processes for over two-hundred internal users in various departments.

●Worked with a team to migrate the company's legacy COBOL AS/400 COBOL and RPG system to a client server application.

Gage Marketing, Romulus, MI Sept 2000 – Aug 2002

Lead Applications Developer

●Design and develop ETL solutions through extensive usage of SSIS and MongoDB

●Highly automated SQL Server for ETL from hundreds of Government Agencies for global trade data consolidation for over a thousand clients

●Document and showcase all database features, architectural diagrams, system specs and hosted internal training for large audiences.

Contact this candidate