TECHNICAL SKILLS:

Developer IDE/Language: Visual Studio 2010, 2012,2015, 2017, 2019, VB 6.0VB.Net (read/Write), C# (Read), VBScript, HTML, XML, JSON, PowerShell

Other: Windows Server NT 4, 2000, 2003, 2008, 2012 SharePoint 2007, 2010 IIS 5.0/6.0Oracle 8/9i

MS Office: Excel, Access, Visio, PowerPoint, VBA, .NET

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta Georgia

Senior Database Developer

Responsibilities:

• Database development and ETL support for compensation surveys report website.
• Maintained and upgraded legacy compensation survey data flows from multiple sources into a MS SQL Server 2017 database and reporting warehouse.
• Upgraded client data ETL systems over multiple versions including transforms that were custom made
• Designed and built a new client portal to upload, transform, and display for editing client data which feeds directly into our main data pathway to production
• Generated new reporting system allowing companies to compare their employees directly to market.
• Primary production and development DBA responsible for database creation, security, backup and restores, maintenance, replication and availability of the SQL Servers version 2012,2016,2017.
• Developed and maintained production processing reports to analyze or production build process

Confidential, Atlanta Georgia

Database Developer

Responsibilities:

• Primary DBA for all development servers involved with their Risk Management programs/projects.
• Design, developed, deployed several processing enhancements of multiple clients’ daily data feeds of various formats from small clients to large financial organization
• Worked to ensure all internal operations and development were following PCI requirements so that the organization was certified on first attempt.
• For the PCI, developed a secure data flow of files from the client through a secure perimeter network and into our data processing pipeline. Each step was catalogued so that at any time a file’s status could be determined. The data flow used Microsoft’s MDM and Data Quality services in addition to standard ETL tools.
• Built and provided daily management reports indicating the status and quality of the legacy data being transformed into a new data warehouse as well as exception reporting Served as technical lead for junior ETL developers

Confidential, Atlanta Georgia

SQL Developer/General Developer

Responsibilities:

• Database design and support for a centralized reporting development team utilizing several data warehouses and data marts. The ETL dataflows created were from many different locations and clients and between data marts that web reporting applications depended on
• Design, developed, deployed Insurance Premium collected on Car Title Loans with functionality of gathering from multiple sources, aggregating the information and submitting data to partners and vendors. Data types included financial data as well as general marketing data. Redesigned and deployed an ETL Process for extracting data out of MS Great Plains and posting into two separate Point of Sale systems for use in reporting.

Confidential, Atlanta Georgia (Contract)

Database Administrator and Developer

Responsibilities:

• Extraction, Transformation, and Loading (ETL) of customer data from multiple data sources into one primary pathway into the company’s marketing data warehouse.
• Several data extractions came from external vendors were the full cycle of data discovery to data warehouse design was utilized

Confidential, Atlanta Georgia

Database Administrator/ SQL ETL Developer

Responsibilities:

• Database design and support for a centralized reporting development team utilizing several data warehouses and data marts. The ETL dataflows created were from many different locations and clients and between data marts that web reporting applications depended on
• Primary Architect for data integration between a homegrown application and Great Plains. Developed system of Service Broker objects and related database objects to shorten transaction lifetime allowing for asynchronous processing of data that allowed the sending client application to not be locked for large periods of time. Developed process to extract information stored in Active Directory relating to the Line of Business (extraction included attributes and structural hierarchy information).
• Provided Production and Development DBA duties as requested

Confidential, Atlanta Georgia

Database Engineer

Responsibilities:

• Production level support for four (4) clients who utilize a custom software package for managing their Video Gaming Systems. Developer support for several versions of the custom software mentioned above.
• Activities include System, Application Server, and Application performance monitoring and troubleshooting. Custom data importations into MSSQL2K5 utilizing standard and customized SSIS packages. The customized packages usually include internally developed components. Planning, implementing and supporting disaster recovery/business continuity planning (DR/BCP) operations.
• Successfully implemented several data migrations utilizing SSIS migrating data from old platforms into new application databases.
• Implemented several log shipping solutions to increase disaster response time and minimize downtime

Confidential, Atlanta Georgia

Senior DBA/Developer

Responsibilities:

• Data ETL (Extraction, Transform and Loading) Engineer/Developer for project involving security access involving many different applications throughout the organization
• Activities include Discovery, Analysis, Coding, Testing and Implementation of various data feeds from various sources into a central data mart/warehouse which will be used in analyzing and administrating security principles across the organization.
• Data feed types include but are not limited to Linked Servers (Oracle, SQL Server 2000/2005), text files (fixed width and delimited), Active Directory integration and well as Main Frame feeds.
• Developed and implemented standardized process, procedure and documentation for above data feeds through several custom components and SSIS as well as implementing a Reporting Server for in depth analysis and data retrieval.

Confidential, Atlanta Georgia

Senior DBA/Developer

Responsibilities:

• Database developer/administrator supporting Research and Development Department of an international bank in both Bermuda and the Cayman Islands.
• Installed and maintained 2 & 3 node SQL Server 2000/2005 cluster installations with related services and monitoring and alerting systems. Installation includes planning for cluster software settings and proposing/reviewing server node acquisitions including hardware design and hard disk RAID configurations for optimized performance.
• Full involvement with building, installing, configuration and burn in of installed clusters from Operating System to SQL Server Installation
• Developed, maintained and utilized a dashboard system of reports for monitoring SQL Server Clusters throughout the organization resulting in the last regional deployment being chosen as the model for the main SharePoint farm for all the international locations.

Confidential, Charlotte, NC

SQL Developer/DBA

Responsibilities:

• Provided customer support involving troubleshooting, identifying, correcting and/or advising, creating code for
• Primary area of support consisted of anything dealing with a data connection involving any of Microsoft's data components MDAC (ODBC, OLE DB, ADO, ADO.NET, etc.). Reporting Services and SQL Server configurations
• Supported technologies include but are not to IIS 5/6 and Web Applications and Services, SQL Server 7/2000 and its subcomponents of DTS, Reporting Services, and Analysis Services etc. Other scenarios in developer support is VB.NET, C#, C++, VB6, and VBA data related issues.

Confidential, Alpharetta, Georgia

Database Developer

Responsibilities:

• Database development project in support of Cingular’s Fixed Asset Conversion of AT&T merger. Coordination and accountability project.
• Performed ETL from various sources into centrally managed database.

Confidential, Norcross, Georgia

Lead Analyst

Responsibilities:

• Primary data and data related construction with SQL Server 2000 and Analysis Services in support of an integrated intranet of Reporting and Dashboard Web App.
• ETL processing from an Oracle Warehouse via DTS with integrated Quality Assurance was a major part of my duties. Oversaw final QA program of intranet deployment.

Confidential, Alpharetta, Georgia (Contract

SQL Developer

Responsibilities:

• Senior DBA and Programmer and Team Lead for an Enterprise Level Web Application involving logistical data.
• Performed requirements gathering, technical specs writing, and Quality Assurance measures for Web Site functionality and data integrity and accuracy

Confidential, Columbus, Georgia

Senior Programmer/Analyst

Responsibilities:

• Senior Programmer in support of a data warehouse department servicing 50 separate entities including 40 banks.
• Primary projects included ETL of securities, deposits, loans, and credit card account information into local data stores for a front - end Web Application.
• Performed Quality Assurance measures against data for integrity and accuracy as well as measures against user requirements. Assisted in operational networking issues and tasks.

Confidential, Alpharetta, Georgia (Contract)

Data Analyst II

Responsibilities:

• Primary Data Analyst /Data Developer in support of the Sales Team in the Health Enhancement Division (HED).
• Provides ETL services on multiple data formats to standardize data into a useful and analyzable data format. Formats ranged from Microsoft standard (i.e. Access/Excel) to Cobol flat file formats with volume from a few hundred MB’s to several GB’s of data. Serves as the final developer to process 12 clients’ standardized data into XML formats required for insertion into the web based/SQL 2000 backend Production System.
• ETL processing included standard Quality Assurance checks and balances. Initiated a “Best Practices” database for the team in support of the external QA team.

Confidential, Alpharetta, Georgia

SQL Developer/DBA/Administrator

Responsibilities:

• Primary software developer for client systems and in house operational and production applications; Primary Data Analyst for all reporting functions; Network and System Administrator for small LAN/WAN; Overall responsibility for all things pertaining to Information Management/Systems.
• Successfully designed, maintain and revise a SQL Server 7.0 databases containing well over 15 million records relating to Package Level Detail information. The database availability has consistently stayed above 99% even though a steady stream of over 2 million records per month of varying detail are added. A system of well-designed Stored Procedures, Constraints, and Triggers are constantly performing data integrity checks and/or conversions.

Confidential, Austin, Texas

SQL Developer

Responsibilities:

• Senior Data Analyst for Financial operations involving budgets, utilization review, and special projects for a regional Health Maintenance Organization (HMO) in Texas. Assistant System/Network Administrator.
• Primary DBA and Data Developer and Data Analyst responsible for providing In House Medical Management personnel with thorough claims analysis involving various medical studies.
• Collected, Consolidated, and Analyzed Long Term Claims data for use in Medical Trend studies involving such areas as Ultrasound Requirements during first term of pregnancy, ER vs. Outpatient Utilization costs.