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

Welcome to Blue Gecko Software, Inc.


Business Intelligenceand Analytics Consulting

Microsoft BI Stack | Payroll Processing Industry

Contact Us

SCROLL DOWN

Welcome to Blue Gecko Software, Inc.


Business Intelligenceand Analytics Consulting

Microsoft BI Stack | Payroll Processing Industry

Contact Us

scott_townsend.jpg
 

Scott E. Townsend has been working in the payroll industry since 1987 and most recently 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.

logo_iSystems.png

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


Extensive Payroll and HR

Industry Background
 

SCROLL DOWN

Industry Background


Extensive Payroll and HR

Industry Background
 

At the present time, Blue Gecko Software, Inc. has a consulting engagement at iSystems, LLC based in Vermont, which will run through February 2017.  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.

In his current engagement, Mr. Townsend is working on a new product called Evolution Analytics, which is being offered to customers beginning in February, 2016.  In his role there, he is designing, architecting, and implementing a comprehensive data warehouse solution to support embedded dashboards in the Evolution Payroll and EvolutionHCM product family.  The backend transactional system is a collection of service bureau and payroll customer databases using Firebird (Interbase) and performing ELT into two star schemas.  The first is a conventional Kimball method star schema.  The second, derived from the first, has been highly optimized for performance by using pre-aggregated measures and sparse dimensional attributes to ensure the SaaS front-end loads in a responsive way.

Press Release on Blue Gecko Software, Inc. Intellectual Property sale, here.

Press Release on Evolution Analytics here.

More information on Evolution Analytics can be found here.

Mr. Townsend reports to the Chief Information Officer and regularly interacts with and mentors a team of about eight staff.  The team includes the Reporting and Analytics Manager, the Product Owner, a BI Engineer responsible for Birst integration, four offshore ETL and QA engineers, and finally a Scrum Master.

 

shutterstock_139983946.jpg

Recent Projects


 

 

 

Recent Data Warehouse
Consulting Projects

SCROLL DOWN

Recent Projects


 

 

 

Recent Data Warehouse
Consulting Projects

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


Microsoft SQL Server
Oracle 9g
Firebird 2.0+
VS 2005-2013
SSIS, SSAS, SSRS
SVN, Perforce, TFS, GIT, Jira, Confluence

SCROLL DOWN

Technology Background


Microsoft SQL Server
Oracle 9g
Firebird 2.0+
VS 2005-2013
SSIS, SSAS, SSRS
SVN, Perforce, TFS, GIT, Jira, Confluence