SUMMARY:

• Business transforming, bottom - line enhancing, passionate, driven, versatile data professional with over twenty (20) years of experience using Microsoft technologies and industry diversity to conceptualize, architect, design, develop, and implement efficient, practical software solutions
• Innovative thinker who brings proactive, dynamic solutions to difficult and high-pressure situations
• Proven ability to understand complex projects and bridge the communications gap between business and technology stakeholders and partners

KEY CAPABILITIES:

• Data Modeling
• Data & ETL Architecture
• Data Warehousing (Kimball, Star-Schema)
• Business Process Reengineering
• Systems Integration
• Hands-On Development
• Performance Engineering
• Agile / Scrum
• High Availability / Disaster Recovery
• Crisis Remediation
• Leadership / Team Building
• Training / Mentoring

TECHNICAL PROFICIENCY:

• Windows (All Versions)
• Windows Server (All Versions)
• SQL Server 6.5 - 2016 CTP 3+
• Parallel Data Warehouse 2012
• Analytics Platform System
• Azure SQL Database
• Azure DocumentDB
• Azure SQL Data Warehouse
• SQL Server Resource Governor
• SQL Server AlwaysOn Availability Groups
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Management Objects (SMO)
• SQL Server Service Broker
• SQL Server Replication
• SQL Common Language Runtime (SQL CLR)
• Distributed Transaction Coordinator (DTC)
• SQL Profiler
• Dynamic Management Views (DMVs)
• Transact-SQL (T-SQL)
• C# / VB (.NET & Classic)
• Visual Studio
• Windows PerfMon
• Failover Cluster Manager
• SQLSentry
• ScaleArc
• Actifio

EXPERIENCE:

ENTERPRISE DATA ARCHITECT / DBA

Confidential, Hatboro, PA

Responsibilities:

• Improved End-User Experience & Quality of Service (QoS)
• Configured VMware hosts to allocate resources (RAM, CPU, Storage) to guest virtual machines (VM) based upon workloads and use-cases to maximize capabilities of VM
• Configured Window Server and SQL Server instances based upon workloads and use-cases to achieve optimum performance, stability and availability of each instance
• Configured SQL Server Resource Governor by defining resource pools, provisioning resources and establishing priority for each pool and classifying / routing connections to a specific pool to govern QoS by workload
• Implemented SQL Server maintenance jobs for updating statistics
• Designed, developed and implemented an Intelligent Index Recommendation tool in T-SQL to analyze query index utilization and generate Data Definition Language T-SQL scripts to drop and / or create indexes to achieve optimal indexes by workload
• Identified and optimized poorly performing queries, stored procedures and workloads
• Implemented use of SQL Server AlwaysOn Availability Group compliant, ‘application intent read-only’ server connections to allow off-loading of read-only database activity to secondary replicas
• Facilitated use of secondary replicas for read-only database workloads by identifying qualifying workloads and using application intent read-only server connections where appropriate
• Implemented
• SQLSentry Power Suite Plus as a centralized, multi-server root-cause troubleshooting, proactive monitoring and alerting tool for Windows Server and SQL Server instances throughout the enterprise
• Application data flow related design standards and patterns
• T-SQL coding standards, stored procedure design standards and patterns, deployment requirements and code reviews
• Application developer training in SQL Server concepts including storage models, index rationalization and design, understanding query execution plans, query performance optimization, etc.
• ScaleArc for SQL Server in a trial as a database proxy appliance facilitating zero-downtime high availability / disaster recovery from planned or unplanned database failover, geo-aware dynamic load balancing, etc. with adherence to the topology and state of SQL Server AlwaysOn Availability Groups
• Proposed
• Actifio as a copy data virtualization appliance to replace SQL Server Backup / Restore, facilitating SLA defined recovery point and time objectives while also enabling crucial elements of efficient DevOps including self-serve database recovery, migrations, development, testing, analytics, etc. with dramatically reduced database storage requirements for such

DATA ARCHITECT / DBA

Confidential, King of Prussia, PA

Responsibilities:

• Improved End-User Experience & QoS
• Configured Window Server and SQL Server instances based upon workloads and use-cases to achieve optimum performance, stability and availability of each instance
• Analyzed index utilization and dropped and / or created indexes to achieve optimal indexes by workload
• Identified and optimized poorly performing queries, stored procedures and workloads
• Re-designed Java & Web application processes and data flows
• Implemented
• SQL Server Transactional Replication to replicate data to databases on remote SQL Server instances in high-performance, secure and fault tolerant manner
• Distributed Transaction Coordinator and added it as a resource in a Windows Server Failover Cluster with multiple SQL Server instances on multiple Windows Servers

DATA ARCHITECT

Confidential, Rockvile, MD

Responsibilities:

• Proposed Improved Capacity & Operational Efficiency through Designing, Developing & Prototyping
• Migration from row store to column store index based Fact table implementations to demonstrate and validate query performance improvements in effort to improve scalability and throughput within multiple data warehouses

DATA WAREHOUSE ARCHITECT

Confidential, Parsippany, NJ

Responsibilities:

• Improved End-User Experience & QoS
• Configured Window Server and SQL Server instances based upon workloads and use-cases to achieve optimum performance, stability and availability of each instance
• Identified and optimized poorly performing queries, stored procedures and workloads
• Rationalized and performed migration from SQL Server 2008 R2 to SQL Server 2012 for high data volume suppliers to leverage column store indexes to speed up analytic queries executed against relational data warehouses by upwards of 100x
• Improved Capacity, Operational Insights & Efficiency through Designing, Developing & Implementing
• Application metadata-driven Entity-Attribute-Value primary physical storage model for dimensional data in data warehouses as the cornerstone of a strategy to manage schema changes and attribute volatility in data feeds from suppliers and retailers
• SQL Server and application metadata-driven data warehouse object and code generation framework in T-SQL for dynamically creating table and views for Type I and II dimensions, reference dimensions, facts, etc., eliminating the need for manual creation of such when on-boarding new retailers or suppliers
• Application metadata-driven, state machine-based ETL Framework in T-SQL and SSIS to automate Fact and Dimension data loading into data warehouses, eliminating the need for data source-specific, manually created SSIS Packages
• Detailed analytics and operational intelligence on source data volatility and ETL process throughput for use in data warehouse disk capacity planning and ETL workload and scale-up or scale-out as necessary to support client service level agreements

DATA WAREHOUSE ARCHITECT

Confidential, Malvern, PA

Responsibilities:

• Assessed current data flows, processes, utilization, governance, reporting, etc. and developed multiple strategic action plans for the phased implementation of a modern data ecosystem, allowing the organization to choose the approach best suited to their evolving business objectives and priorities

BIG DATA ARCHITECT / DEVELOPER

Confidential, King of Prussia, PA

Responsibilities:

• Improved End-User Experience & QoS
• Configured Window Server and SQL Server instances based upon workloads and use-cases to achieve optimum performance, stability and availability of each instance
• Identified and optimized poorly performing queries, stored procedures and workloads
• Rationalized and performed migrations from SQL Server 2000 to SQL Server 2008, including use of row / page based upon functional assessment, code compatibility and performance benchmarks
• Improved Capacity, Operational Insights & Efficiency through Designing, Developing & Implementing
• SQL Server metadata-driven, ETL process in T-SQL to convert 100 Fact tables in a data warehouse to a new surrogate primary key structure facilitating dramatic reduction in fact data latency and improvement in client-facing analytic query performance and reporting
• SQL Server metadata-driven, custom replication monitor in T-SQL to provide line of business specific alerts and insights into replication data latency
• Enhanced Client Service Offerings through Designing, Developing & Implementing
• Process for collecting, correlating and analyzing data regarding consumer conversions for measuring ad interaction impact on advertiser web site visitation and engagement through integration with Adobe Analytics

CONTRACT TRAINER

Confidential, Parsippany, NJ

Responsibilities:

• Provided Evening & Weekend Instruction In
• Relational Database Fundamentals & Design
• Data Definition & Data Manipulation Language
• T-SQL, Stored Procedures, User-Defined Functions & Triggers
• SQL CLR
• Installing, Configuring, Administering & Troubleshooting SQL Server
• SQL Server Replication
• SQL Server High Availability / Disaster Recovery
• SQL Server Instance, Database & Object Level Security
• SQL Server Encryption
• SQL Server Service Broker

SOLUTIONS & DATA ARCHITECT / DBA

Confidential, Gloucester City, NJ

Responsibilities:

• Improved End-User Experience & QoS
• Configured Windows Server and SQL Server instances based upon workload and use-case to achieve optimum performance, stability and availability
• Analyzed index utilization and dropped and / or created indexes to achieve optimal indexes by workload
• Identified and optimized poorly performing queries, stored procedures and workloads
• Re-designed Access & VB application processes and data flows
• Improved Capacity & Operational Efficiency through Designing, Developing & Implementing
• Dynamic, expression-based calculation engine to compute costs of services provided while replacing over 5,000 lines of static, inflexible, inadequate and error prone calculations
• Automated service provider RFP generation for requests to service providers based on their proximity to service location, availability, capacity and historical weighted service performance scoring
• Optimized single communication of all work orders to a service provider
• Automated client invoice generation for scheduled preventative maintenance services
• Improved Financial Reconciliation & Forecasting and Operations Research through Designing, Developing & Implementing
• Data Warehouse to deliver business intelligence in the form of reports and dashboards providing metrics, key performance indicators (KPIs), alerts, trend analysis, etc. to help optimize / grow the business and uncover opportunities for new service offerings