SUMMARY:

• Goal - oriented, resourceful, and dependable Information Technology Expert with comprehensive experience consulting in a wide range of industries.
• Excellent communication skills.
• Awarded Microsoft MVP (Most Valuable Professional, SQL/Data Platform) Award Authored/co-authored a dozen published books
• Authored several dozen published peer-reviewed articles
• Experience architecting, implementing, and managing IT technical project implementations, including enterprise transactional database systems (OLTP), data warehouses (EDW), data marts (DM), ETL, OLAP, management reporting, dashboards, and end-to-end business intelligence solutions (BI).

TECHNICAL SKILLS:

Amazon Web Services (AWS), AWS Serverless Lambdas, Amazon EC2, Amazon Aurora, Amazon RDS, AWS IAM, AWS Command Line Interface, AWS Directory Service, Amazon API Gateway, Amazon EBS, Amazon S3, Amazon Athena, Amazon Elastic Container Service, Amazon Virtual Private Cloud, Amazon Simple Email Service, Amazon CloudFront, Amazon CloudWatch, Amazon Route 53 DNS, SQL Azure, SQL Server 2017/ 2016/ 2014/2012/2008 R2, SSIS, SSRS, SSAS, Power BI, Oracle 12c/11g/10g, MySQL 5.7, DGraph, Dapper, Entity Framework, Visual Studio 2017, .NET 4.7/4.5/4.0/3.5/3.0/2.0 , .NET Core 2.0/1.0, IIS, Exchange Server, Hyper-V, C#, ASP.NET, ADO.NET, VB, Python, R, .NET MVC, JavaScript, TypeScript, XML, JSON, YAML, HTML, Web API, SSIS custom components, SSIS script components, ER/Studio, Jenkins, GitHub, TFS, Aspose.NET, Splunk, Slack, Jura, Confluence, Microsoft Office 2016, PostMan, KeyBase, Viscosity, Skype, Microsoft IE, Microsoft Edge, F12 Developer Tools, Google Chrome, Google Chrome Developer Tools, Firefox, Firefox Debugger, Wireshark, ISO Standards, FACTA, SOX, AML, OCC and DOJ Regulations, ACORD standards, EDI standards, U.S. Census Bureau and additional third-party datasets; integration with: Duck Creek PAS, Vertafore PAS, Accenture PAS, Dynamics CRM, Salesforce.com, Sage accounting; SQL Server stored procedures, user-defined functions, views, indexing strategy, query and index optimization, query plans, page and row compression, encryption, CLR, table and index partitions, memory-optimized tables, natively-compiled stored procedures, columnstore indexes, SQL Server AlwaysOn, SQL CLR, Service Broker; Oracle stored procedures, views, indexing strategy, query and index optimization, showplans, code pages; Sybase stored procedures, views, indexing strategy, query and index optimization, query plans, code pages; MySQL stored procedures, views, indexing strategy, query and index optimization

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lee, NJ

Senior Data Architect/Developer

Responsibilities:

• Implemented crucial HA/DR failover solution, using SQL Server AlwaysOn technology on Amazon EC2, to achieve 100% uptime during critical client testing and production runs
• Increased efficiency of critical database code by as much as 200% via query tuning, indexing strategy, and code rewrites
• Resolved multiple, critical client-escalated support issues within 24-hour SLA
• Designed and implemented AWS Lambdas to efficiently retrieve data via web API calls
• Simplified AWS Serverless Lambda API coding calls, using multiple design patterns, such as the Decorator pattern

Key technologies used: Amazon Web Services (AWS), AWS Serverless Lambdas, Amazon EC2 (EC2), SQL Server 2017/2016, .NET 4.7, .NET Core 2.0, Visual Studio 2017, Amazon Aurora, MySQL 5.7

Confidential, New York, NY

Data Architect/Senior Developer

Responsibilities:

• Increased efficiency of existing crucial database code by as much as 300% via query tuning, indexing strategy, and code rewrites
• Migrated a dozen critical reports from SSRS to Power BI
• Trained 10 staff members on relational database design, implementation, and coding strategies
• Assisted in quickly bringing four long-running client projects to successful conclusions
• Implemented EDW, data marts, ETL, management reporting, and dashboard best practices

Key Technologies used: AWS, EC2, SQL Server 2016/2014, Reporting Services (SSRS), Geneva, Power BI, GitHub, C#, ASP.NET, ADO.NET, .NET 4.6, Visual Studio 2017, XML, JSON

Confidential, Morristown, NJ

Director of Application Development

Responsibilities:

• Managed team of 20+ developers located on four different continents
• Responsible for managing hundreds of escalated support issues, from dozens of clients, representing over 2,000 users
• Rearchitected multiple e-discovery, asset archiving, and enterprise search solutions installed in a client base of over 200 customers, including a dozen Fortune 500 companies and several multibillion-dollar international banks and large law firms

Key technologies used: AWS, EC2, SQL Azure, SQL Server 2016/ 2014/2012/2008 R2, Oracle 12c/11g/10g, Sybase, Integration Services (SSIS), SSRS, Power BI, Analysis Services (SSAS), Python, TFS

Confidential, Charlotte, NC

Chief Data Architect

Responsibilities:

• Managed team of 10 developers (onshore and offshore)
• Integrated a dozen policy administration, claims administration, billing, CRM, and accounting systems into the company’s flagship product
• Architected and implemented flagship enterprise solution for policy and claims administration and BI solutions for P&C, specialty lines, and health insurance clients

Key technologies used: AWS, EC2, SQL Server 2014/2012/2008 R2, Oracle 11g, SSIS, SSRS, SSAS, .NET 4.0

Confidential, New York, NY

Chief Application Architect, Development Manager

Responsibilities:

• Managed team of 40+ developers, business analysts, and project managers, from multiple subcontracted consulting firms, on a $900M project
• Quickly architected and implemented enterprise-class workflow and auditing system to perform audits of one of the world’s largest banks, based on OCC regulatory guidance
• Designed system to support over 1,000 concurrent auditors, QA reviewers, and managers, simultaneously accessing the system from geographically disparate locations
• Supported a half dozen customers in implementation and utilization of flagship Anti-Money Laundering (AML) product

Key technologies used: SQL Server 2008R2, C#, ASP.NET, ADO.NET, .NET 4.0, SSIS, SSAS, SSRS, Python, TFS, R

Confidential, New York, NY

Senior Database Developer

Responsibilities:

• Increased overall computational efficiency of critical calculations by 30% through targeted database redesigns and code refactoring
• Designed and implemented enterprise data warehouse and data marts to support massively parallel risk calculations
• Eliminated over a dozen deadlocks from existing database code and refactored several dozen stored procedures to make code more efficient and manageable

Key technologies used: SQL Server 2008, C#, VB, .NET 3.5, Java, SSIS, SSRS

Confidential, New York, NY

Principal Solutions Architect

Responsibilities:

• Managed a team of 6 developers
• Implemented custom enterprise data warehouse, data mart, OLAP, management reporting, dashboard, and ETL business intelligence solutions for dozens of clients
• Architected and implemented flagship business intelligence product with integration from over a dozen policy administration, CRM, and corporate accounting systems
• Provided support for dozens of clients, including multibillion-dollar international insurers, reinsurers, and Fortune 500 companies
• Attained 99.999% uptime for critical client BI applications and internal development systems

Key technologies used: SQL Server 2008/2005, C#, VB, C++, .NET 3.5, .NET 3.0, .NET 2.0, Java, SSIS, SSRS, Dynamics CRM, Salesforce.com, Duck Creek PAS, Accenture PAS

Confidential, New York, NY

Senior Systems Programmer

Responsibilities:

• Designed and implemented efficient SQL Server-based ETL applications and process, increasing efficiency of ETL process by 2,000%
• Optimized dozens of existing queries and stored procedures, increasing efficiency by over 30%
• Designed and implemented SQL-based user interface applications, including in-store kiosks in 900+ stores

Key technologies used: SQL Server 2005/2000/6.5, C++, SSIS, Data Transformation Services (DTS), SSIS