Anthony D. Email & Phone Number

Stokesdale, Nc, Us

Remote

BI/Data engineer working in Corporate Analytics. Primarily responsible for building and managing data marts using Python, SSIS and SQL. Build and manage ETL/ELT processes in Python and SSIS. Connect to API’s using Python. Support data analysts with SQL query writing and refactoring. Document ETL/ELT processes.

Greensboro/Winston-Salem, North Carolina Area

Identify functional requirements and provide recommendations related to database development. Write documentation and work with quality control analysts to thoroughly test code. Assist .NET programmers with database related development including writing stored procedures, functions and database architecture. Refactor SQL queries as needed. Primary technologies used include SQL Server, SSIS/SSRS, TSQL, C# and PowerShell.

High Point, Nc

I worked collaboratively with business owners and CHESS customers supporting their data needs and priorities. With team input, I identified and architect solutions to meet the organizational or customer need. I worked closely with the data solutions team to build out the solution and stay prioritized on important tasks. Agile Scrum methodology used for keeping the team members engaged and getting timely feedback from business owners. I assisted team with development as needed. I also oversaw the database administration and assisted with DBA work such as performance tuning, security, and disaster recovery strategies. Technical skills include: MS SQL Database Administration, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), C#, and Python. Infrastructure solutions such as networking, server, (physical and virtual) and SAN technologies. Some open source experience.

High Point, Nc

As the functional manager for the development team, I managed and oversaw the data and application solutions for Cornerstone custom and off-the-shelf technologies. I collaborated with project managers on large organization initiatives and oversaw the team priorities and direction. For new development requests, I gathered the project requirements and discussed a solution with leadership, project managers and developers.Managing the team also included tracking time-off, employee reviews and hiring/interviewing for new positions. The team consisted of DBA's, SQL and .NET developers so I assisted with these technologies and assured proper coding practices were being met. In addition to management duties, I also assisted with SQL, ETL and reporting development requests as needed and backed up the DBA on any database related needs. Technologies used included: SQL Server 2008/2012/2014, T-SQL stored procedures, views, functions, SSIS, SSRS, and C#.

I developed complex ETL solutions using SQL Server Integration Services (SSIS). Created T-SQL stored procedures, views and other queries for use by custom applications, reports and analytics. Also, used SQL Server Reporting Services to create reports as needed. Technologies used included: SQL Server 2008/2012, SSIS, SSRS, T-SQL, C#

Greensboro/Winston-Salem, North Carolina Area

Managed several SQL Server database servers including disaster recovery management, database performance tuning and creating SQL views and queries as needed. Created data marts by connecting to Epic Clarity data warehouse using SSIS and T-SQL. I created multidimensional cubes using SSAS for clinical data analytics. I created reports using SSRS for reporting and analytics requirements. I worked with Excel and PowerPivot to build pivot tables and pivot charts/graphs. Technologies used include: SQL Server 2005/2008, SSIS/SSRS/SSAS and TSQL

Winston-Salem, Nc

I managed all SQL Server and Oracle database systems for the infrastructure. I managed disaster recovery including maintain daily backups and performance tuning on both SQL Server and Oracle database systems. I supported application developers as needed. I performed database development including creating reports with SSRS, ETL with SSIS and data mining with SSAS. Technologies used include: SQL Server 2005/2008/2012, Oracle 10g/11g, T-SQL/PL-SQL, SSIS, SSRS, SSAS

I managed all SQL Server database systems for the infrastructure. Supported 40+ database servers varying from SQL 2000 to SQL 2008. Developed, maintained and implemented disaster recovery strategies. Performed database development including database design and report creation using SSRS. Used integration services for ETL and creating new integration points for varying application systems. Monitored and enhanced database performance using Quest monitoring tools and SQL profiler. Quest tools used included SOSS and LiteSpeed.Technologies used include: SQL Server (2000/2005/2008), T-SQL, Quest SOSS/Litespeed, VB Scripts

Lead Citrix Administrator for a Citrix Farm of 35 servers, 40 applications and approximately 500 end users running in a Windows Server 2000/2003 environment. Also performed other Sys Admin duties such as installing and configuring new servers, running cable, and server/network security.

M.S., Computer And Information Science

B.S., Emergency Medical Care