David McKelvey

*** ******* ****** ****

Garland, Texas 75044

ad4exs@r.postjobfree.com

214-***-****

PROFESSIONAL SUMMARY

Highly organized problem solver possessing solid technical, conceptual, and communication skills. Able to create simple solutions to complex problems by focusing on details without losing sight of the “big picture.” I have diverse experience in multiple industries and development environments with over 30 years of data-focused information technology experience specializing in both OLAP and OLTP database technologies, with a current focus on MS SQL Server.

EDUCATION

Texas A&M University - College Station, Texas

Bachelor of Science, Civil Engineering, December 1989

GPA: 3.8/4.0, Magna Cum Laude (Ranked 7th in the College of Engineering)

TECHNOLOGIES

SQL Server, T-SQL, SSMS, SSRS, SSIS, Git, Flyway, PowerShell, Visual Studio, Visual Basic, C#, HTML, XML, JSON, JavaScript, Selenium, Agile Methodology, Jira, TFS

CERTIFICATIONS

Microsoft Exam 461: Querying Microsoft SQL Server 2012/2014

Microsoft Exam 462: Administering Microsoft SQL Server 2012/2014 Databases

EXPERIENCE

O'Neil Digital Solutions (August 2018 – Present) – Plano, Texas

Lead Senior Database Engineer

ODS is a data-driven dynamic document generation company mailing millions of letters and books a day and

providing online access to those documents.

• Rearchitected processes, added automation, and removed technical debt. Reducing human support hours by over 75%.

• Addressed countless SQL Server performance problems, often reducing runtimes by over 99% by rearchitecting queries or even rearchitecting the database itself for optimal index utilization and high row selectivity.

• Reduced database size by over 75% by normalizing data, removing duplicate data, and using proper data types.

• Worked with highly parallel processes often spanning over 100 servers.

• Implemented job monitoring and notification system DataMart that tracked a client request from receipt through data processing, image generation, proofing, approval, printing, fulfillment, and shipment.

• Implemented database source control with Visual Studio, Git, and Flyway that did not exist before.

• Became the lead expert in the ODS internal system architecture.

• Worked directly with ODS Clients gathering project requirements and providing data expertise on their own data.

• Mentored dozens of Junior Developers for SQL and IT best practices providing code reviews and assisting when they could not find solutions.

• Worked with application development staff regarding project planning, resource allocation, task definitions, and schedules.

• Gathered requirements, worked with stakeholders, planned, and executed end-to-end solutions to meet a variety of business needs.

• HIPPA/HITRUST environment.

WebCE (March 2007 – August 2018) - Dallas, Texas

Database Architect & Administrator / Solution Architect

WebCE is an Internet company with a highly custom continuing education and compliance platform.

• Transformed our data environment from a single back-office SQL Server 2005 to a fully Virtualized High Availability/Disaster Recovery “Always On” solution across data centers with SQL Server 2016.

• Architected the database model and managed SQL Server configurations including security and maintenance for 1000+ tables.

• Responsible for all database backup, recovery, and maintenance processes.

• Established proactive database monitoring that alerted IT of database problems before they became customer-impacting.

• Established and maintained company database standards and best practices.

• Performed SQL code reviews for adherence to standards and best practices.

• Gathered requirements for and developed countless reports to address a myriad of business problems.

• Regularly worked with live production data for bulk data changes – there was no room for mistakes.

• Architected accounting systems for tracking and reporting on all financial data and seamless integration into Microsoft Dynamics GP.

• Utilized Selenium web driver functionality to automate previously manual processes saving millions in labor costs.

• Architected the marketing email system to avoid spam blocks and comply with the CAN-SPAM act.

• Created a complete order fulfillment solution including inventory management.

SkillsNET (April 2006 – March 2007) - Waxahachie, Texas

Database Architect

SkillsNET was one of the first neural network companies profiling job skills.

• Designed and implemented a new neural network database architecture that addressed severe performance, data integrity, and maintenance issues in the legacy systems.

• Led a team to develop standard procedures and functions to support the new database architecture.

• Implemented a data warehouse to address performance issues in reporting.

• Reduced website report response times from 2-4 minutes to 1-4 seconds. This was after five previous attempts by other IT personnel to do so.

Verizon (February 2003 - April 2006) - Irving, Texas

Professional Services Consultant

• Program Manager for Verizon’s Strategic Web Service Management Architecture.

• Project Manager for the elimination of non-standard IT products.

MCI/WorldCom (November 1997 - December 2002) - Richardson, Texas

Technical Lead/Architect - Systems Development, METIS Information Warehouse

METIS was a huge Informix Data Warehouse housing all of MCI’s network configuration and maintenance data.

• Hands-on Project Manager/Architect for several different teams of up to ten people with in-depth involvement in long-term management direction and decision-making.

• Developed and maintained hundreds of reports and data feeds using SQL, SSRS, UNIX scripting, MS Access, and Excel for Informix, Oracle, and SQL Server data sources.

• Extensive ETL experience using DTS (SSIS), UNIX Scripts, and T-SQL

• Developed custom data warehouse web applications and internal websites using HTML, ASP, XML, and JavaScript.

• Extensive remote management experience with up to 70% of my team remote.

Ferguson Information Systems (January 1996 - October 1997) - Irving, Texas

Lead Technical Architect, InfoManager Data Warehouse

FIS sold and supported an AS/400 based data warehousing tool called InfoManager.

• Designed, installed, and supported dozens of InfoManager data warehouses on customer’s AS/400, working directly with the company’s executives.

• Trained clients on the application, data warehousing concepts, and required maintenance and support of their data warehouse.

• Administered the FIS AS/400, NT, and Novell servers.

AON (August 1992 - January 1996) - Dallas, Texas

Risk Management Information Systems Consultant, Anistics

Anistics is a risk management application that allows management to track and forecast liabilities.

• Created Anistics’ Loss Development Triangle Reporting System which became a cornerstone of the Anistics Application.

• Designed, coded, tested, and documented ETL programs to convert insurance claim data from dozens of data sources into the Anistics database.

• Installed and supported Anistics' system at client sites.

• Trained clients on the Anistics System.

Accenture (Anderson Consulting) (January 1990 - July 1992) - Dallas, Texas

Experienced Staff Consultant, Information Systems and Technology

Accenture is one of the most highly rated and respected IT consulting companies in the world.

• Designed, coded, tested, documented, and implemented COBOL data ETL programs to convert legacy data.

• Responsible for equipment cost amortization schedules for a $200 million-dollar proposal.

• Maintained an Accenture in-house C/UNIX technical architecture by developing UNIX scripts and C modules

Contact this candidate