shutterstock_128726255.jpg
shutterstock_159896321.jpg
shutterstock_139983946.jpg
shutterstock_147901157.jpg
shutterstock_128726255.jpg

Welcome to Blue Gecko Software, Inc.


Business Intelligence Consulting

Microsoft BI Stack

Contact Us

SCROLL DOWN

Welcome to Blue Gecko Software, Inc.


Business Intelligence Consulting

Microsoft BI Stack

Contact Us

scott_townsend.jpg
 

Scott E. Townsend has been working in business intelligence since 2008 when he began an ambitious journey to bring business intelligence and predictive analytics to the outsourced payroll services market.  Working on a Microsoft BI stack, he designed and created a multi-tenant data warehouse and multi-dimension cube using Visual Studio and SQL Server.  The solution provided analytical capability to the management team of the service bureau, to the service bureau's payroll customers, and to the vendor relationships that existed between the two.  His work was widely praised at the annual conferences of the Independent Payroll Providers Association between 2012-2014.

It was after the 2014 conference that Blue Gecko Software, Inc. and iSystems, LLC. began discussing an engagement that would bring our intellectual property to their EvolutionPayroll and EvolutionHCM platforms.  Mr. Townsend is currently engaged as a Chief Product Architect and is working with an amazing team to put Evolution Analytics into the hands of over one hundred service bureaus nationally that are using the full range of payroll, tax filing, time and attendance, advanced HR capabilities in their respective marketplaces.

 
shutterstock_159896321.jpg

Industry Background


Experienced in
Microsoft SQL Server 
Oracle 9g
Firebird 2.0+
 

SCROLL DOWN

Industry Background


Experienced in
Microsoft SQL Server 
Oracle 9g
Firebird 2.0+
 

At the present time, Blue Gecko Software, Inc. has a long-term engagement at iSystems, LLC. based in Vermont, USA.  Evolution is a dynamic Payroll, HR, and Tax Management system developed by payroll and HR service bureau veterans for the Human Capital Management (HCM) industry. Providing unparalleled accuracy, productivity, and financial control within one fully integrated platform, Evolution gives it's customers the power and flexibility to operate and grow their business while continuing to meet the growing trends of the industry.

EvolutionHCM.png

In his current assignment, Mr. Townsend is the Chief Product Architect for a new product called Evolution Analytics which will be offered to iSystems customers later in 2015.  In his role there, he is designing, architecting, and implementing a comprehensive data warehouse and cube to support embedded dashboards in the EvolutionPayroll and EvolutionHCM product family.  The backend transactional system is a collection of service bureau and payroll customer databases using Firebird (Interbase) and performing ETL into a full Microsoft BI stack beginning with SQL Server 2014.

Mr. Townsend reports to the VP of Engineering and regularly interacts with and mentors a growing team of about ten staff.  The team includes the Reporting and Analytics manager, the Product Owner, a BI Engineer responsible for Birst integration, a Senior ETL Engineer, and several offshore resources include an additional Senior ETL Engineer and two QA Engineers and a database administrator.

shutterstock_139983946.jpg

Recent Projects


 

 

 

Background in 

Payroll, HR, PEO, Staff Leasing

SCROLL DOWN

Recent Projects


 

 

 

Background in 

Payroll, HR, PEO, Staff Leasing

DesignMind.png

Through it's relationship with Design Mind, Inc. based in San Francisco, CA, we have a diverse consulting background as a sub-contractor.  To date, we have worked for the following organizations with a brief description of our work.

Intuit.png

Blue Gecko Software, Inc. was involved in two data warehouse projects at Intuit:

The first was a supplies data warehouse where Mr. Townsend retrieved Oracle, SQL Server, and flat file data combining order history with line item detail, marketing campaign data, and web traffic data to facilitate better understanding of its in-product campaigns and other sources.  Working with another teammate from Design Mind, Mr. Townsend handled all ETL responsibility for both an operational data store (ODS) as well as for the data warehouse itself (DW).  The project was approximately 9 months.

The second project was for Quick Book Finance and was centered around a partner funnel analysis with its various lending partners.  Working with the same teammate, Mr. Townsend again worked with multiple partner flat file feeds that reported lending activity status into the data warehouse for analysis by the product owner, analysts, and management.  He handled all ODS and DW ETL efforts over a six month period.

Intel.png

Mr. Townsend was also a part of a five man consulting engagement at Intel, where he focused on front-end and end-user proof of concepts using Excel, PowerPivot, and PowerView against a tabular sales and opportunity pipeline cube.  His responsibilities including using DAX to shape data from the cube into PowerPivot and used Excel pivot tables with slicers, visualizations, and a fair amount of styling to provide various stakeholders with dashboards.

Prosper.png

At Prosper.com, Mr. Townsend worked exclusively in SSIS and SSRS providing deep integration services between various external partners and Prosper.  The wide ranging assignments included banking, investors, compliance reporting for 1099 processing, marketing campaigns, debt collection services, marketing campaign prospect lists, and treasury movement reporting.

shutterstock_147901157.jpg

Technology Background


VS 2005-2013SSIS, SSAS, SSRS 
SVN, Perforce, TFS, GIT, Jira, Confluence

SCROLL DOWN

Technology Background


VS 2005-2013SSIS, SSAS, SSRS 
SVN, Perforce, TFS, GIT, Jira, Confluence