Canam Datagroup

Austin Texas Area: Cloud Consulting Services:(Admin, Developer and Consultant), MDM strategies and processes for Cloud-based clients predominantly in the non-profit org space for On-Premise, Cloud and Hybrid systems. Other data services include: ETL & Data Warehousing, Data Integration, Data Prep, Data Validation, Data Migration, Custom Reporting, Salesforce Customizations, Business Intelligence and Data Analytics. Development and Deployment of RESTful/SOAP API based web services and microservices (AWS Lambda/API Gateway DevOps). Some former client engagements: • Designed, developed and implemented a re-useable duplicate management system for the HSSV Salesforce donor database. A custom Data Parser Application with a well-defined reusable process was developed using Oracle, MySQL, SOQL/SOSL, Perl/AWK/Python (regular expressions to support fuzzy logic), Convio ETL and Salesforce ApexDataLoader to allow the automated merging of duplicate match pairs and to preserve field data in the surviving records. The application and process is OS independent by design. Also developed a prototype Salesforce contact duplicate management app for Apple iOS. • Designed, developed and implemented an automated payroll system on Windows.NET platform using C#. This application exported data from PeopleTrak and an Advantage Database (Time Tracker) and imported to the SQL Server (payroll database). • Designed, developed and implemented a real time data processor to capture real time data from a mobile device and other external sources and write to a MySQL database. Implemented in C/C++ using the MySQL C API and deployed as a Linux daemon. Extensive post processing and reporting was performed against the captured data for review by individual clients. • Web development for GoldlunchBox.com. This PHP dynamic website is LAMP based technology and incorporates extensive JavaScript (using AJAX/JQuery and other JS Libraries). Client is a prominent Graphics Designer in Austin, Texas.