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.

They are currently iterating on a powerful API framework tool called Analytic.li Data Manager that performs high velocity staging from many potential source systems.  The 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.  They are also continuing to work 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 the product road map.  This includes supporting a browser-based UI, mobile (iOS and Android) apps so that the curated dashboards add decision support value for customers.

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 (now Asure Software, Inc. | NASDAQ: ASUR) 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.

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.

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.

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.

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.

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.