Sr. Solution Architect Resume
                                    
                                    3.00/5 (Submit Your Rating)
                                
                            Northbrook, IL
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
 - 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 SQL Server 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 SQL Server based 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.
 - 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 for the data platform.
 - Worked with executive leadership to develop the Data vision for the 3-5 years.
 - Acted as a liason with Microsoft, 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 and SQL CLR in SQL 2012.
 - 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
 
