Database Analyst Resume Charlotte, NC - Hire IT People

SUMMARY

I'm a highly energetic and self - motivated professional with 17+ years' experience in database design and development with Database Technology. Experience working with Fortune 100 companies during my career as a Database Developer.

TECHNICAL SKILLS

Servers and Database: ETL, Microsoft SQL/Server, Oracle GoldenGate, MySQL, T - SQL, PL/SQL, SSIS, SSRS, disaster recovery architecture deployment for always-on environments
System Upgrades: Microsoft SQL upgrades from SQL 2000 to SQL 2008R2 and SQL 2012; Business Objects and Crystal Reports conversions to SSRS. Port data from legacy database to Amazon RedShift Cloud, MySQL cluster and other RDBMS environments
Networks: VPN, LAN/WAN, load balancing, configuration of routers, web-servers and database servers, encryption methods such as PGP and SQL/Server native
Programming Languages: Visual Basic.Net, PowerShell, Visual Basic for Applications programming in Microsoft Word, Excel and Access. FoxPro, DOS, BASIC, PASCAL, COBOL, RPG and VIPP
Operating Systems: Windows, UNIX, Linux, MAC-OS

PROFESSIONAL EXPERIENCE

Database Analyst

Confidential, Charlotte, NC

Responsibilities:

Analysis, design and implementation of ETL process load from source systems to Confidential Data Warehouse
Advanced TSQL logic built for the purpose of creating staging tables, cleansing data and inserting to data-warehouse dimensional model
Analysis/Design SSIS to replace transform-load process (Informatica) from staging tables to data warehouse
Championed initiative to move T-SQL DDL scripts from legacy Source Control System to Microsoft TFS

Systems Integrator

Confidential, Charlotte, NC

Responsibilities:

Modify existing systems integrations and create new integrations utilizing SSIS, Microsoft SQL Server and Oracle ODI
Troubleshoot errors with SQL/Server agent jobs and fix problems where necessary
Gather business requirements from end user and transform to technical requirements

SQL Programmer

Confidential, Charlotte, NC

Responsibilities:

SQL/Server automation and programming using SSIS packages, stored procedures and agent jobs
Agile/Scrum meetings and correspondence for software deployment
Documentation of existing architecture

Senior Content Database Developer

Confidential, Charlotte, NC

Responsibilities:

Design and develop solutions regarding ETL through extensive usage of SSIS
Highly automated SQL Server for ETL from hundreds of Government Agencies for Global Trade data consolidation
Document and showcase all database features, linkage charts, system specs and internal training for large audiences

Database Administrator

Confidential, Norfolk, VA

Responsibilities:

Create and modify stored procedures called from web user interfaces
Conducted data migrations from third party databases to create consolidated database system
Debug existing SSIS packages, agent jobs and stored procedures in response to error reporting and server activity