Co-founder | Technology Lead
2020 - PRESENTKanary- Designed and implemented the back end and analytics engine with various technologies, including Node.js, Express, and PostgreSQL.
- Designed and implemented intuitive and effective UI/UX using Node.js, React, Redux, TypeScript, HTML5, and CSS.
- Developed integrations with third-party vendors such as Stripe, QuickBooks Online, SendGrid, and Google Analytics.
- Collaborated with the beta customers to refine UI/UX using Figma and rapid prototyping.
- Developed and executed marketing and sales strategies to facilitate growth.
Technologies: Node.js, React, React Redux, Express.js, TypeScript, PostgreSQL, Redis, HTML5, CSS, Nginx, Ubuntu Linux, Stripe API, QuickBooks API, SendGrid API, Google Analytics API, HTML, Data Architecture, Architecture, Relational Databases, SQL, Adobe Photoshop, ETL Development, Datasets, Databases, Business Intelligence (BI), Dashboards, Data Warehousing, ETL, Data Warehouse Design, Data Analysis, Data Engineering, Data Modeling, Data Analytics, API Connectors, JSONSenior Business Intelligence Consultant
2007 - PRESENTSalient Business Intelligence- Led and assisted 100+ enterprise clients on delivering technology solutions using SAP BusinessObjects, SAP Data Services, and custom development.
- Learned quickly and became effective in any product or technology that enabled delivering solution and client success.
- Re-engaged by clients to assist with multi-year projects based on the history of delivering high-quality, successful work.
Technologies: SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), Web Intelligence, Crystal Reports, C#.NET, Java, Oracle, IBM Db2, Microsoft SQL Server, Data Migration, JavaScript, HTML, CSS, SAP LSMW Data Migrations, HTML5, ETL, Data Architecture, Architecture, Consulting, Relational Databases, SQL, SQL Server Integration Services (SSIS), PHP, ETL Development, SAP HANA, Data Warehouse Design, Datasets, Databases, Python, Business Intelligence (BI), SQL Stored Procedures, Dashboards, Data Warehousing, Data Analysis, Data Engineering, Data Modeling, SAP, Data Analytics, API Connectors, Data Cleansing, Data Cleaning, XML, JSONSenior Business Intelligence Consultant
2016 - 2021Cleveland-Cliffs- Oversaw the BI aspects of company-wide ERP upgrade, focusing on ETL process, upgrade, testing, and roll out.
- Reduced turnaround time for management and departmental users by delivering accurate, timely information via Web Intelligence reports and underlying data processes.
- Managed the implementation of ETL process conversion to implement best practice methodologies around reliability and performance.
- Expanded data access and quality by maintaining existing data warehouse initiatives and architecting new ones.
- Improved the data quality and reliability through implementing best practice configuration management, testing, and validation for ETL processes across various environments.
- Worked with various internal companies and departments to successfully architect and implement custom analytic applications that improved data access and reduced IT dependency.
Technologies: SAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS), Web Intelligence, Oracle, Microsoft SQL Server, Data Warehousing, Database Migration, Data Migration, HTML, ETL, Data Architecture, Architecture, Consulting, Relational Databases, SQL, SQL Server Integration Services (SSIS), ETL Development, Data Warehouse Design, Datasets, Databases, Business Intelligence (BI), SQL Stored Procedures, Dashboards, Data Analysis, Data Engineering, Data Modeling, Data Analytics, Data Cleansing, Data Cleaning, JSONSenior Business Intelligence Consultant
2015 - 2021Marcus & Millichap- Expanded the company data access and quality by maintaining the existing and developing new ETL functionality using SQL Server, SAP Data Services, and SAP R/3.
- Streamlined the existing and developed new, highly-visible, and actionable financial reports for senior management.
- Empowered the senior financial staff to have timely access to the secure, personalized, regional performance data via a custom-developed report generation and distribution application.
- Reduced the user dependence on IT analysts by designing and developing a self-serve, custom portal in C# .NET for sales agents to access performance and commission metrics.
Technologies: C#.NET, SAP BusinessObjects (BO), Crystal Reports, SAP BusinessObjects Data Service (BODS), Microsoft SQL Server, ASP.NET, SAP R/3, Data Migration, HTML, JavaScript, CSS, HTML5, ETL, Data Architecture, Architecture, Consulting, Relational Databases, SQL, SQL Server Integration Services (SSIS), ETL Development, Data Warehouse Design, Datasets, Databases, Business Intelligence (BI), SQL Stored Procedures, Dashboards, Data Warehousing, Data Analysis, Data Engineering, Data Modeling, SAP, Data Analytics, API Connectors, Data Cleansing, Data Cleaning, XML, JSONSenior Business Intelligence Consultant
2014 - 2015Veolia- Migrated master data elements from disparate legacy systems to SAP in collaboration with various internal companies.
- Facilitated system interoperability by developing interfaces to allow data movement between different production systems via SAP Data Services.
- Established best practice testing and data validation processes in conjunction with various internal departments to ensure data quality and predictable project success.
Technologies: SAP BusinessObjects Data Service (BODS), SAP R/3, Microsoft SQL Server, Oracle, PeopleSoft, Data Migration, SAP LSMW Data Migrations, ETL, Consulting, Relational Databases, SQL, ETL Development, Datasets, Databases, Business Intelligence (BI), Dashboards, Data Analysis, Data Engineering, SAP, Data Analytics, Data Cleansing, Data Cleaning, XMLSenior Business Intelligence Consultant
2011 - 2012Dawn Foods- Developed, maintained, and rolled out the migration of legacy data areas to new SAP environments using SAP Data Services and IDocs.
- Implemented custom ETL processes using SAP LSMW processes.
- Collaborated with various functional teams to help determine requirements and provide solutions for ETL processes.
Technologies: SAP BusinessObjects Data Service (BODS), SAP BusinessObjects (BO), SAP, Microsoft SQL Server, SAP LSMW Data Migrations, ETL, SAP R/3, Data Cleansing, Data Cleaning, XMLSenior Business Intelligence Consultant
2009 - 2011Shaw- Oversaw, in conjunction with the IT management, a multi-phase 2-year project that successfully expanded data access by introducing new data sources, reports, and technologies to analysts and company leaders.
- Streamlined data-driven decision making via working with the departmental stakeholders to finalize requirements and ultimately implement, test, and roll out reports in Crystal Reports, Web Intelligence, and Xcelsius.
- Introduced best practice data quality and validation processes via implementing configuration management and development workflows within the various environments.
- Assisted the internal staff with addressing PL/SQL stored procedure issues and mentored the team on implementing efficient SQL and stored procedures for reports and universes.
- Enhanced the report developer and power user data analytic experiences through maintaining existing and developing new universes.
Technologies: SAP BusinessObjects (BO), Crystal Reports, PL/SQL, Microsoft SQL Server, Web Intelligence, Oracle, Java, ETL, Architecture, Consulting, Relational Databases, SQL, Datasets, Databases, Business Intelligence (BI), SQL Stored Procedures, Dashboards, Data Analysis, Data Modeling, Data Analytics, XMLSenior Business Intelligence Consultant
2010 - 2010Expedia- Solved complex requirements for company-wide dashboards, scorecards, and visualizations using Xcelsius, Query as a Web Service, and universes.
- Mentored staff on Crystal Report, Web Intelligence, and Xcelsius development issues and conducted training sessions on the full BO stack.
- Diagnosed and resolved performance issues in large BusinessObjects Enterprise clustered environment, leading to more efficient user experiences for client-facing applications.
Technologies: SAP BO Dashboards, SAP BusinessObjects (BO), Web Intelligence, Crystal Reports, Architecture, Consulting, Relational Databases, SQL, Datasets, Databases, Business Intelligence (BI), SQL Stored Procedures, Dashboards, Data Analysis, Data Analytics, XML, JSON
Allan Carruthers
Business Intelligence Developer in Vancouver, BC, Canada
Member since February 10, 2022
Allan is a seasoned data engineer and developer with 17 years of experience building elegant and creative products and services that make customers happy. He has delivered over 100 successful projects for his body of Fortune 1000 clientele. A specialist in business intelligence, systems integration, and application development, Allan continually solves complex problems as an entrepreneur, architect, designer, and implementer.
Allan is now available for hire
Portfolio
- KanaryNode.js, React, React Redux, Express.js, TypeScript, PostgreSQL, Redis, HTML5...
- Salient Business IntelligenceSAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS)...
- Cleveland-CliffsSAP BusinessObjects (BO), SAP BusinessObjects Data Service (BODS)...
Experience
- JavaScript 20 years
- SAP BusinessObjects (BO) 17 years
- Data Warehousing 12 years
- ETL Development 12 years
- SAP BusinessObjects Data Service (BODS) 12 years
- Data Migration 12 years
- Node.js 3 years
- React 3 years
Availability
Part-time
Preferred Environment
Windows, Linux
The most amazing...
...thing I've developed is Kanary, an employee fraud-mitigation product for small businesses, where I've designed and implemented the entire technology stack.
Employment
Experience
- Kanaryhttps://kanary.cloud
Kanary is an internal fraud monitoring and protection software service that helps businesses mitigate losses from internal fraud.
As a co-founder, I architected and implemented the entire technology stack, including the analytics engine, application back-end, and UI/UX elements. It is primarily implemented in React, Node.js, and Express. - Mine to Mill Project
A data warehouse and analytics application for a Fortune 500 resources company. The successfully delivered application consumed thousands of data points from various sensors and the entire mining operation workflows at disparate mine sites, empowering users to perform ad hoc end-to-end performance analyses that had not previously been possible.
I was the BI architect and developer for ETL, data warehouse, reporting, testing, user validation, and deployment tasks. - Financial Performace Agent Portal and Data Warehouse
A C#.Net-based web portal for the biggest commercial real estate broker in North America that allowed thousands of sales agents across hundreds of districts to access metrics on performance, commissions, sales, and other financial analytics. I was responsible for architecting the data warehouse, developing custom and off the shelf ETL processes using T-SQL and SAP Data Services, developing Crystal Reports in SAP BusinessObjects for consumption through the web portal, developing the report bursting and distribution engine, and developing the web portal itself. The resulting application empowered agents and managers to access timely performance metrics in a self-serve fashion without having to rely on IT turnaround.
- SAP HANA Medical Dashboard
Developed a next-generation interactive healthcare dashboard analytics set, based on SAP HANA models, for a leading Healthcare Analytics company. The resulting work was showcased with great success to potential clients at SAP's annual user conference, SAPPHIRE.
- SAP BusinessObjects Unix Course Review and Audit
Based on my expertise in the SAP BusinessObjects Unix technology stack, I was brought in by SAP as a consultant to formally audit and review their Business Objects Enterprise XI: Administering Servers: Unix course material before it was deployed to the public for consumption.
- Data Analytics for Mr. Carwash
Worked with a remote team on streamlining existing and developing a new set of Crystal Reports and Web Intelligence reports based on flat files and Microsoft SQL Server. The delivered reports enabled a consolidated view of how the company and the various car wash locations performed.
Skills
Languages
JavaScript, HTML, CSS, Java, HTML5, SQL, XML, PHP, C#.NET, Python, Solidity, TypeScript, C++Frameworks
Express.js, ASP.NET, Apache SparkLibraries/APIs
React, React Redux, Node.js, Stripe API, QuickBooks API, SendGrid API, Google Analytics APITools
Crystal Reports, Salesforce Einstein, Adobe Photoshop, Apache Airflow, Docker Compose, Nginx, SAP UI5Paradigms
Object-oriented Programming (OOP), ETL, Business Intelligence (BI), Human Interface DesignPlatforms
Oracle, Windows, Linux, SAP HANA, Docker, Ubuntu Linux, Red Hat LinuxStorage
PostgreSQL, Microsoft SQL Server, PL/SQL, Databases, Relational Databases, JSON, SQL Server Integration Services (SSIS), Database Migration, Redis, IBM Db2, SQL Stored Procedures, Google CloudOther
SAP BusinessObjects (BO), Web Intelligence, SAP BusinessObjects Data Service (BODS), ETL Development, Data Warehousing, Data Migration, Software Development, Consulting, Architecture, Data Architecture, Data Warehouse Design, Datasets, Dashboards, Data Analysis, Data Engineering, Data Modeling, Data Analytics, API Connectors, Data Cleansing, Data Cleaning, Tableau CRM, SAP R/3, SAP LSMW Data Migrations, SAP, PeopleSoft, SAP BO Dashboards, Algorithms, Ellipse, Google BigQuery
Education
- Bachelor's Degree in Computer Science1998 - 2003University of British Columbia - Vancouver, BC, Canada
Certifications
- Salesforce Certified Tableau CRM and Einstein Discovery ConsultantJUNE 2020 - PRESENTSalesforce
- SAP Certified Application Associate for BusinessObjects Enterprise XI 3.xAPRIL 2010 - PRESENTSAP
- BusinessObjects Enterprise XI Certified ProfessionalFEBRUARY 2005 - PRESENTBusinessObjects
- Crystal Enterprise 10 Certified ProfessionalMAY 2004 - PRESENTBusinessObjects
