SUMMARY

• Passionate Sr. Enterprise Architect specializing in Data Platform, and Cloud - based solutions. Particularly interested in leveraging architectural patterns, performance optimization, relational, and non-relational database design to transform business value.

TECHNICAL SKILLS

• SQL Server 2000, 2005, 2008, 2008 R2, 2012 & 2014 Replication, In Memory Tables, Partitioning, High Availability, Spatial, SQL CLR, SSRS, SSIS, SQL Profiler, Optimization, XML, Service Broker, Power BI.
• Azure PAAS and IAAS Solutions.
• ERStudio, CA Erwin, star, snowflake, and 3nf schema design
• Coaching, Mentoring and Managing Software teams.
• Develop enterprise wide vision for data platform.
• .NET Framework (1.1, 2.0, 3.5, 4.0, 4.5) WF, WPF, WCF, Web Services, MVC, Windows Apps, Multithreading and Asynchronous development.
• 2007 & 2010 Application Development, Storage Internals
• C#, Transact SQL, ASP.NET, JavaScript, HTML

PROFESSIONAL EXPERIENCE

Sr. Solution Architect

Confidential, Northbrook, IL

Responsibilities:

• Rearchitected the database platform to:
• Support High Availability and Disaster Recovery requirements
• Support 10X the load on a similar hardware footprint.
• Enable advanced reporting scenarios.
• Designed fully-integrated Azure based Recipe Syndication and management platform.
• Analyzed existing marketing information architecture, and identified key gaps inhibiting current marketing strategical goals.

Enterprise Data Architect

Confidential, Evanston, IL

Responsibilities:

• Rearchitected a mission critical OLTP alignment application to:
• Support 3 times the previous load.
• Import data an order of magnitude faster.
• Enable advanced reporting scenarios.
• Increase responsivesness by 40% across the entire application.
• Rearchitected a Data Warehouse project resulting in:
• 90% reduction in space requirements.
• Eliminated the need for 1 of 2 costly 3rd party licenses.
• Made advanced anylitical scenarios possible.
• Owned the data platform for of 11 appliations encompassing ~250 developers.
• Created the next Generation data model to be used for the entire Sales & Marketing practices.
• Worked with operations counterparts to migrate to SQL 2014.
• Developed best practices and guidelines for the adoption of windows azure cloud platform.
• Acted as a liason with Confidential, getting 4 of our sr. technical leaders on the Azure advisory board.

Senior Data Architect

Confidential, Chicago, IL

Responsibilities:

• Architected Debt Tax Calculation tool for large hedge funds supporting 1 million transactions per year, per client that leveraged multi-level dynamic portioning, sql clr.
• Implemented Map & Reduce methodology in SQL 2012.
• Developed an enterprise Service Bus using SQL Server Service Broker to handle messaging across a suite of applications.
• Migrated Disparate SQL Server based applications to a common platform. This allowed them to leverage common components and reporting, and function as an application suite.
• Managed the Data application portfolio for the tax channel.
• Automated Database code reviews to increase quality and reduce costs.
• Engineered SharePoint 2010 Engagement Management tool that supported 10000 tax professionals.
• Managed Software Teams.
• Acted as technical liaison to senior leadership.
• Optimized performance of SharePoint 2010 farm.
• Managed architecture, development and Delivery of complex software systems.

Senior Technical Architect

Confidential

Responsibilities:

• Architected Scale out deployment of SQL Server 2008 which included replication, high availability, and SQL CLR.
• Executed performance tuning of mission critical application that prevented new hardware from being purchased.
• Led development effort to improve performance of enterprise web services.
• Advised technical and business leadership.
• Managed real time server upgrade of production databases.
• Moved an application that was listed as a critical threat to business goals under current load to an application that can successfully handle 8 times the current load.

Senior Data Architect

Confidential

Responsibilities:

• Developed Industry leading SQL Spatial Algorithms.
• Architected SQL Spatial integration.
• Data Mined 100 million records to answer business questions
• Optimized existing structure to scale of multi TB of data.
• Designed, and implemented software improvements to critical business processes.
• Engineered event based Workflow to transform raw data to production quality.
• Led development for partner integration and software delivery.
• Managed junior developers

Software Design Engineer in Test

Confidential, Redmond, Washington

Responsibilities:

• Contributed to the overall product quality of a client\server app with 240 million customers in over 40 countries.
• WTT Team expert in charge of developing BVT infrastructure, designing best practices, and managing relationship between automation lab, product team and IT support team
• Designed and implemented metrics to measure lab quality and BVT reliability in C# and SSRS
• Architected SQL Server 2005 Pool of Accounts test solution.
• Designed, and developed an API automation library using C# 2.0 and Visual Studio 2005 that included .NET Remoting and custom COM interop.
• Added OLAP cube reporting functionality to the team Sharepoint site.
• Investigated and troubleshot complex bug reports from internal and external sources.
• Maintained daily BVT runs to ensure high product quality.
• Performed the role of security champion, including writing Threat Model Analyses for new features, and participating in Security product and code reviews