We provide IT Staff Augmentation Services!

Sr. Solution Architect Resume

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

Hire Now