SUMMARY

• He has over 20 years of professional information technology experience focusing in Database Development, Database Administration, Data Modeling, High Availability, Disaster Recovery, Business Intelligence data mining and integration, Data Architecture and .
• Twenty years of experience in SQL Server 2000, 2005, 2008, 2014 & 2016 Administration/Development, ETL, Data Warehouse and more.
• He is a great collaborator and easy communicator. Capable of leading teams, he is capable of accountability while leading with encouragement and technical assistance for junior members.
• He is an extraordinary communicator and can easily understand the instructions of supervision.
• He can comfortably express his statuses, obstacles and proposed remedies. Confidential is HYPER - ZEALOUS about task documentation and delivery.
• He is most comfortable with both scrum and Kanban. He - WILL- be sure to detail every Monday morning that weeks’ deliverables, and by Friday night, he will have requested clear hand-shaking regarding the acceptance of each item by the end of that day.

TECHNICAL SKILLS

Technologies/Tools: Azure (2), ADFv.1 (1), ADFv.2 (1), PowerBI (1); Hadoop, HDFS, KUDU, Parquet, Spark/Scala ETL (1); HPC - High-Performance-Computing & MPP - Massively Parallel Processing (25); SQL (24), T-SQL (20), Microsoft System Center / SBS (21), C# (15), Visual Basic 6.0 (13), VB.Net (12), VBA (13), VBScript (13); PL/SQL (9); SSRS (11), SSIS (11), SSAS (9), MDX (9), MVC (6), WCF (6), XML (6), Asp.Net (6); JavaScript (3), Java (3), NoSQL (6), HADOOP (6), GraphDB (6), XAML (3), HTML (5), XSLT (3), CSS (4), “hyperGRAPH” DB (3), R (1)

Computer Systems: Windows, UNIX, OS/2, Linux

Databases: SQL Server (2000/2005/2008/2012/2014/2016 ), MySQL, Oracle, DB/2, MPP, GraphDB, NoSQL

PROFESSIONAL EXPERIENCE

Data Architect, Developer

Confidential

Responsibilities:

• SQL 2014/SQL 2016 backend adaptation into .NET/ORM, OData integration.
• Defect and Feature SQL tracing, deadlock, discovery, and remediation.
• Performance re-architecting using add-on schemas to existing OLTP.

Data Architect, Developer

Confidential

Responsibilities:

• SQL2005->SQL2016 Migration Project Management, Database and VM architecture and dev; SQL2005 CLR rewrite (“PHOENIX”).
• SQL2016 Single-Tenant -> Multi-Tenant Migration Project Management, Database and VM architecture and dev (“Audit Manager / Compliance Manager”).
• SQL2014 Performance Debugging and re-Architecture research (“Practicode”).
• Creating SSRS, SSIS w/data-validation.
• VM provisioning, load-balancing, performance dashboard development and deployment.
• Disaster recovery for 900+ databases restore-verified daily.
• Instant-Resume HA High Availability.

Data Architect/Developer

Confidential

Responsibilities:

• Created SSRS, SSIS w/data-validation, MBaaS (JavaScript web-based) for Facilities Engineering Mobile Management and Inspections.
• R-based Lifetime Asset Management analysis
• VM provisioning, load-balancing, performance dashboard development and deployment.
• MSSQL Database administration and debugging.

Performance/ETL Developer

Confidential

Responsibilities:

• Created SSIS and data-validation for FHLBS, FNMA, GNMA banking data shredding and reporting.
• MBaaS, BaaS for the mobile inspections industry
• Reviewed, debugged and repaired hundreds of failing BI SSIS, DTS data processing and ETL rules.
• Analyzed, debugged and repaired several hundred frequently failing RedGate individual customer database backups.
• VM provisioning, load-balancing, performance dashboard development and deployment.

Confidential

High-Performance Data Architect/Developer

Responsibilities:

• Data Modeling, Data Architecture, Data Development, UI Development, Systems Engineering.
• 3D Massive Data Visualization Dashboards, C#/CLR Hyper-extension to MSSQL2012, Microsoft System Center 2012 Configuration Manager & Operations Manager for Data Center Clientele automating delivery and access.
• Performed (proprietary) “hyperGRAPH” “n-dimensional edge-processing” graphDB for advanced modeling of atomic particle behavior with applications to larger systems of multi-force / multi-mass / variable-distances / historically-aware “entities”.
• Hadoop data modeling of social-networks for the purpose of creating social-trend prediction tools.

Senior Data Architect, .NET BackEnd Developer

Confidential

Responsibilities:

• Analyzed, debugged, architected and developed reports, data warehouse and new servers for A/P reporting.
• Created tech specs for the outsourcing/off-shoring of multi-million-dollar financial/accounting reporting systems.
• Creation of ASP.NET, SSRS and C# User Interfaces & reports.
• Debugged WCF, created new C# add-ins for BI-rules/functions, and custom email interfaces.
• Created C# CLR stored procedures for database-managed Business Intelligence and Data validation/manipulation.
• Re-architected databases and programmability to repair data integrity, burdensome replication and report-timeout issues.
• Reports that were timing out with less than a week’s data and which were taking up to ten minutes to generate are now capable of presenting more than two years of data within less than ten seconds of report request.
• The sixteen re-architected reports are the ONLY reports within a group of sixty-six A/P reports which operate in less than five seconds; their pre-re-architecting versions took in excess of five minutes and many more than thirty minutes.

Senior Data Architect, Data Developer, Test Developer

Confidential

Responsibilities:

• Analysis of complex reporting logic using SSAS, MDX.
• Improved security data transfer by a factor of fifty through rewriting custom CLR sprocs and wise use of transactional replication as well as utilization of built-in, federally-security-certified encryption (within SQL Server 2008 Ultimate).
• Built and certified Confidential ’s Police Information Records Systems product as MSDN-Partner-compliant.
• Built and certified Records Systems product as Open-Source Compliant using Black Duck.
• Security scanned and Certified as Secure Records Systems product using Nessus.
• Participated in planning, execution of Agile program management leading to successful, quality-assured roll-outs of multiple releases of Records product.
• Creation of ASP.NET, SSRS and C# User Interfaces & reports.
• Prototyped WPF/XAMP XBAP for error-pre-correcting; training-eliminating NIBRS reporting system.
• Created C# projects and tools for data flow analysis and compiled into 2-million-line production source tree.
• Re-created 100% Error-Correcting / Training-Eliminating User Interface using WPF/MVC/ASP.NET for intra-net, web as extremely light-weight, stateful, centralized business-rules-aware, with NO UI-processing for Police Incident Reporting System.
• Created “parallel universe” source tree and builds for side-by-side testing of architectures using Visual Studio 2010 and HyperV virtual servers.
• Improved response time of supporting MS SQL Server 2008 by a factor of ten by creating stored procedures to handle all possible forms of “ad hoc” and LINQ/inline-SQL queries.
• Improved response of normalized database through data warehousing by a factor of 1000.