Migration of CRM data from any source into the SylogistMission donation management platform, sitting atop Dynamics 365.

"Rick tackled some very complex and challenging projects while he was here. He is an incredibly talented and determined problem solver" - Jeff Harris, President, Xello• Advanced Sql Server database development and data analysis• Migration of CRM and Accounting systems for two companies.• Integrated the SAAS applications of two companies with sales and billing operations as well as analytics reporting.• Ongoing implementation and development of Salesforce CRM, including Object development, Wave Analytics, Flows, Apex and Lightning component development. • Integration of Salesforce with Netsuite.• Sql Server integration with Salesforce.• Data warehouse architecture and development.• SSIS procedures to ETL data from HEAP (via Snowflake), Pardot, and the data warehouse into Salesforce Wave Analytics.• Administration of Sql server instance and multiple databases.• Developed Netsuite Suitescript routines and C#.NET REST calls to retrieve Netsuite data.

• Improved the production environment through a .NET development of Sql Server-sourced Excel reports• SSRS reporting• Integration of MsOffice products using .NET and VBA.• Designed and maintained a key revenue, cost and margin reporting Sql server data mart responsible for consolidation of tens of millions of dollars of financial information each month.• Test case development• Support for enterprise data warehouse development, including reconciliation and testing• Extensive ad hoc reporting• Cognos development

• Ms Access, VBA, and Clipper-based data systems for small business, and linkage of same to off the shelf accounting packages like Simply Accounting, Quickbooks, and Accpac. • Advanced Ms Excel application development• Advanced reporting design