Stonemeadow Solutions LLC

Work Experience

Larry Barnes has 30 years of experience, 22 of those years working directly for clients. Larry has been focused on Integration and Business Intelligence solutions since 1990 and has been working with SQL Server since 1989 when 1.0 shipped During that period, Larry was a founding member of the ODBC standards committee.

Clients

Financial Services	Healthcare
Retail Brokerage	Healthcare Services Provider
Raymond James	NE Healthcare Services Provider
US Financial Company	ISV Analytics Division
America's Division, Global Financial Co.	Other
Top US 100 Financial Institution	Top US 500 Media company
Commercial / Institutional Banking	GroupM
Wachovia Securities	Large US based utility
Fleet Bank	BGE Home
State Street Bank	Large Software Company
Financial Services VC Division	Large Global Conglomerate
Top US 300 Financial Institution	Large NE based Conglomerate
Insurance	Global Telco
Top US 100 Property & Casualty Company	Large Software Company
Commercial Property & Casualty Company	Global Retailer
	NE based Retailer
	Stream International
	Commonwealth of Mass.

Client Engagements

Healthcare Services Provider

Role: Architect / Developer / SME

Developed an ETL Framework including SQL 2005 Integration Services (SSIS) and template packages and Reporting Services (SSRS) reports. Architect and Subject Matter Expert (SME) for 3 ETL projects including a team consisting of employees and three services providers. Architect / Developer for a rule-based implementation for data driven program alerts. Extensive knowledge transfer including 150+ of documentation.

Technology: SSIS, SSRS, SQL Server 2000 / 2005, Oracle

References: CIO, VP of Applications, Director of ETL

Top 100 Software Company

Role: Project lead / Analyst

Project lead for a Business Intelligence (BI) roadmap for the consumer division of a large software company. This project interviewed stakeholders across the business and delivered a three-year roadmap for this organization.

References: Client project lead

US based Utility

Role: Project Lead / Developer

Proof of concept that migrated an Excel based Pay for performance scorecard to Microsoft's Business Scorecard Manager (BSM) product.

Technology: SQL Server 2005, Business Scorecard Manager

References: Client project lead

BGE Home

Role: Architect / Developer

Delivered a data warehouse and ETL Framework for BGE's service organization. This warehouse consolidated data from a myriad of systems including Oracle, IBM DB2, Mainframe, Great Plains, MS-CRM and Access. The project team consisted employees, consultants and off-shore ETL resources.

Technology: SQL 2000 Rdb, SSAS, DTS, Business Objects

References: CIO, VP of Marketing, SI Partner

Microsoft Technology Centers (MTC)

Roles: Project Lead/Architect/Developer/SME

Project lead / architect for client Proof of Concept engagements at the Waltham and Chicago MTCs. These projects typically involved demonstrating SQL Server's ability to scale using client scenarios and data.

Technologies: SQL Server product stack (Rdb, Analysis Services (SSAS), SSRS, SSIS), Microsoft Office, Balanced Scorecard Manager, Pro-Clarity

References: Waltham MTC Director

Clients:

Top 100 Financial Institution

Objective:

Demonstrate how SSAS and SSRS can replace and out perform the existing Business Objects implementation atop a retail investing subject area

Subject area: Retail investing trades / transactions

Americas Division - Global Financial Institution

Objective:

Demonstrate how the Microsoft BI Product Suite (SSAS, SSRS, Rdb, SharePoint, Balanced Scorecard) can be used for all aspects of the organization's reporting and analytic needs.

Subject area: Retail investing transactions and balances.

Subject area: Retail investing transactions and balances

Top 100 Property and Casualty Company

Objective:

Migrate solution from SSAS 2000 to 2005 and demonstrate performance improvements using Microsoft Office and Pro-Clarity clients.

Subject area: Consolidated claims.

Large New England based Conglomerate

Objective:

Demonstrate how SSIS 2005 and best practices can reduce a 24 hour ETL processing cycle into 3 hours Subject area: Healthcare sales (manufacturing) subject area.

Subject area: Product Sales

Top 100 New England based Conglomerate

Objective:

Demonstrate how SSAS 2000 can replace Essbase for a consolidated spend analytics application.

Subject area: Consolidated spend analytics

Global Telco

Objective:

Demonstrate how SSAS 2005 can scale and replace an existing Essbase solution.

Subject area: Consolidated Sales

Top 200 New England Retailer

Objective:

Demonstrate how SSAS and Microsoft Office can scale for a Retailer's consolidated sales.

Subject area: Consolidated Sales

Global Retailer

Objective:

Demonstrate how SQL Server's 2005's product suite can be used to implement the organization's Global data warehouse

Subject area: Orders

Top 500 Media organization

Role: Architect / SME

Optimized the existing AS2000 Sales and Marketing cubes logical and physical design. Developed an asp.net portal providing a web-based interface to these cubes. Implemented a security provisioning system for applying security to the portal, SSAS and SQL Server relational database.

Technology: SQL Server 2000, SSAS 2000, DTS, Excel, Office Web Components, ASP.NET

References: VP of Applications

Wachovia Securities

Role: Architect / SME

Architect for the ETL and relational data warehouse components of a fixed income investor performance management reporting system. This solution used DTS to extract, transform and load information into SQL Server 2000 from Sybase, SQL Server, Access and Excel data sources. Siebel Analytics is the front office reporting tool.

Technology: SQL Server 2000 Rdb, DTS, Siebel Analytics

References: VP of Analytics, Product Manager

Raymond James

Role: Architect, SME

Avanade teamed with MCS to deliver an Enterprise Data Warehouse for a large regional brokerage firm. The first subject areas include client assets, financial analyst performance and account statistics for over 6,000 financial advisors (both employee and broker). This solution used DTS to load Analysis Services cubes from a 1+ terabyte data warehouse and utilizes 64-bit Windows 2003 and SQL Server. One of Larry’s roles in this project was to build out the Microsoft Solutions Framework for Data warehouse projects.

Technology: SQL Server 2000 Rdb, SSAS 2000, Office Web Components, Pro-Clarity 4.0

References: VP of Applications, Data warehouse director

GroupM

Role: SME

Larry provided subject matter expertise and best practices for a large international media companies' Enterprise Data Warehouse.

Technology: SQL Server 2000, DTS, Analysis Services 2000 and Excel Pivot Tables

References: Director of Applications

Healthcare ISV Analytics Division

Role: Tech lead, SME

Developed an ETL and Execution Framework for the analytics arm of a major Healthcare ISV

Technology: SQL Server 2000 Rdb, TSQL

References: VP of Analytics

New England Property and Casualty Company

Role: Tech lead, SME

Tech lead for an Analysis Services Proof of Concept combining Policy, Reinsurance and Claims cubes into a Virtual cube. Larry also provided ETL and OLAP knowledge transfer and best practices for the company’s in house team.

Technology: SQL Server 2000 Rdb, SSAS 2000, DTS

References: BI Director

Top 50 Financial Services VC division

Role: Architect

Larry was the technical architect role for a project within the VC arm of a large East coast financial institution. This project measured and optimized the system and database environment for a 3rd party Windows DNA / SQL Server 7.0.

Technology: SQL Server 2000 Rdb, Mercury Loadrunner

New England Healthcare Services Co

Role: Tech lead, SME

Implemented an OLAP Claims Adjudication Proof of Concept for a New England based Healthcare Services company.

Technology: SQL Server 2000 Rdb, DTS, SSAS 2000, Pro-Clarity 4.0

Fleet Bank

Role: ETL Developer / SME

Larry provided architectural, design and implementation consulting for Fleet's Relationship Manager Data Warehouse. This solution provided product, customer and organization profitability to a 5k+ user base.

Technology: SQL Server 2000 Rdb, DTS, Microstrategy 7.0

References: Data Warehouse Manager

State Street Bank

Role: Architect / SME

Larry led a team that optimized a 30+ hour Straight Thru Processing analytics daily load to under 4 hours.

Technology: SQL Server 7.0, SQL Server 2000 and Visual Basic.

References: VP of Applications

Top 300 Financial Organization

Role: Performance Analysis

Larry provided application bottleneck analysis and recommended database, application and physical implementation changes which removed bottlenecks from the organization's core trading application

Technology: SQL Server 7.0, C++

Top 200 New England Retailer

Role: Architect / SME

Larry provided SME and architectural guidance to a major New England retailer looking to move an Essbase OLAP reporting solution over to SSAS 7.0

Technology: SSAS 7.0, DTS

Commonwealth of Mass

Role: SME

Provided architecture, design and performance consulting for the Commonwealth of Mass data warehouse, used by over 1500 employees to access key revenue and expense project information. This was one of the largest known SQL Server 4.21 data warehouses at the time.

Technology: SQL Server 4.21 Rdb

References: Data Warehouse Director

Stream International

Role: SME

Larry provided database layer consulting, as part of MCS, for Stream International's Internet B2C site. This was one of the first B2C sites in New England and utilized IIS 3.0, ASP, MTS/COM and SQL Server 6.0. Larry provided database layer consulting, as part of MCS, for Stream International's Internet B2C site. This was one of the first B2C sites in New England

Technology: IIS 3.0, ASP, MTS/COM, SQL Server 6.0.

Digital Data Warehouse

Role: Developer

Larry was initially the lead developer, as a consultant, for the client side components of Digital Equipment's Digital Data Warehouse product. Moved to the server side and redesigned the server component as a multi-threaded finite state machine. Larry completed his tenure as the project lead for this effort

Technology: Win 32 APIs, Windows 3.1, ODBC, Visual C++, VAX/VMS, VAX Rdb

References: Rick Sherman (DDW Product Unit Manager)

DataRamp 1.0

Role: Project Lead / Architect

Project Lead and architect for Data Ramp, a multi-threaded ODBC Server concentrator that provided a universal client for all ODBC data sources. This product was the basis for PC DOC's acquisition of WSI in 1995.

Technology: Windows NT, Visual C++, ODBC

VAX Rdb / SQL Services

Role: Dev Lead

Development Lead for DEC's first client/server database product.

Technology: VAX/Rdb, C++

Work Experience

Stonemeadow Solutions LLC (2006-present)

Provide consulting services to organizations looking to maximum their investment in Microsoft's Data integration and Business Intelligence product suite. Larry presented at multiple Microsoft events including Tech-Ed 2007 where Larry presented on ETL Frameworks.

Avanade (2000-2006)

As BI Fellow my responsibilities included QA on large Global BI initiatives, BI Solution development and External communications. In this role I developed / contributed to the following BI assets: Delivery methodology, ETL Framework, CIO Dashboard, BI in FSI Dashboard, Customer Intimacy solution

Prior roles included BI Practice Director where I was responsible for creating and extending Avanade's BI Practice from one region into a global presence.

During my tenure I represented Avanade on Microsoft's BI Partner Advisory Council.

References: CTO, VP of Applications, Chief Delivery Officer

Microsoft (1995-2000)

As a Solutions Specialist, Larry divided his time between evangelism, architecture and pre-sales activities. Larry worked with many NE based companies to scale SQL Server for their web sites. During this time, Larry was part of the popular "Bob and Larry" developer series.

Larry started as a senior consultant for Microsoft Consulting Services focused on SQL Server engagements.

Larry was also the co-author of two SQL Server publications during this period; Data warehousing with SQL Server 7.0 and SQL Server lessons from the field.

References: MCS General Manager, Director, Enterprise Technology and Solutions

Working Set Inc. (1986-1995)

Larry was a principal at Working Set, a boutique consulting firm with a client list that included Microsoft, Lotus, Powersoft, Computer Associates, Manufacturers Hanover Trust and Goldman Sachs. During his tenure, Larry was a founding member of the ODBC 1.0 standard, presented at Microsoft's Professional Developer Conference and was the architect/developer of DataRamp 1.0, an ODBC server/concentrator that was the basis of Working Set's acquisition by PC Docs in 1986.

Digital Equipment Corp (1980-1986)

Larry was a principal engineer at DEC and during his tenure contributed to the following products: VTX 1.1, Teamdata 1.0, TDMS 1.0 and 1.1.