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 E. Townsend is a serial entrepreneur who has co-founded Analytic.li, Inc. (2016), Blue Gecko Software, Inc. (2006), and TruPay Corporation (2003).  He has a long history of involvement in the Payroll/HCM Industry as a software product developer dating back to 1988 with Interlogic Systems, Inc. based in Indiana.  Beginning in 2008, he anticipated the need for embedded decision support solutions in the payroll industry and so began to pivot from transactional payroll/HCM product development to analytical systems.  Since then, he has established a strong track record of developing business intelligence and integration solutions for Analytic.li, iSystems, Intuit, Intel, and Prosper.

In late 2016, Mr. Townsend co-founded Analytic.li with a team of incredible industry veterans all with significant HCM, payroll, and service bureau backgrounds.  As a company, Analytic.li is working to break through typical industry boundaries by creating the first cross-platform analytics solution for the Payroll/HCM industry.  This means that customers that use multiple software platform providers can receive consolidated and unified analytics across all their business holdings--no matter what platform or service bureau is doing the processing.  Among other benefits, this solves a major reporting and decision support pain-point suffered by larger companies.

We are currently iterating on a powerful API framework tool called Analytic.li Data Manager that performs high velocity staging from many potential source systems.  Our staging framework includes the ability to support some client specific customization's all while smoothly performing ETL into a SQL Server 2016 Enterprise data warehouse running in Azure.  We are also working on customer facing API's that will expose post-ETL dimension and fact table data to be used in whatever corporate analytics standard required by our customers...including Excel, of course.

In addition to his architecture role, Mr. Townsend is managing onshore and offshore resources that are working on our product road map.  This includes supporting a browser-based UI, mobile (iOS and Android) apps so that the curated dashboards add decision support value to our customers.

 
shutterstock_159896321.jpg

Industry Background


Extensive Payroll and HR

Industry Background
 

Industry Background


Extensive Payroll and HR

Industry Background
 

Blue Gecko Software, Inc. was engaged to adapt our analytics intellectual property originally created for the Millennium (MPay Software, Inc.) platform and refactored it for the Evolution HCM platform offered by iSystems, LLC. based in Vermont, USA.  Evolution HCM 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.

Mr. Townsend served as the Chief Product Architect Evolution Analytics which was successfully developed and launched in March 2016.  In his role there, he designed, architected, and implemented a comprehensive data warehouse 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 Microsoft SQL Server 2014 Enterprise using Birst as an embedded visualization layer.

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 reported to the Chief Information Officer and regularly interacted with and mentored a  team of about ten onshore and offshore staff. The team included 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


 

 

 

Recent Data Warehouse
Consulting Projects

Recent Projects


 

 

 

Recent Data Warehouse
Consulting Projects

logo_iSystems.png

Blue Gecko Software, Inc. was engaged to adapt our analytics intellectual property originally created for the Millennium (MPay Software, Inc.) platform and refactored it for the Evolution HCM platform offered by iSystems, LLC. based in Vermont, USA.  Evolution HCM 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.

Mr. Townsend served as the Chief Product Architect Evolution Analytics which was successfully developed and launched in March 2016.  In his role there, he designed, architected, and implemented a comprehensive data warehouse 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 Microsoft SQL Server 2014 Enterprise using Birst as an embedded visualization layer.

Mr. Townsend reported to the Chief Information Officer and regularly interacted with and mentored a  team of about ten onshore and offshore staff.  The team included 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.

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+
Visual Stuido
SSIS, SSAS, SSRS
SVN, Perforce, TFS, GIT, Jira, Confluence

PowerBI, PowerPivot

Technology Background


Microsoft SQL Server
Oracle 9g
Firebird 2.0+
Visual Stuido
SSIS, SSAS, SSRS
SVN, Perforce, TFS, GIT, Jira, Confluence

PowerBI, PowerPivot