Marc Richard Email & Phone Number

Montreal, Qc, Ca

Montreal, Qc, Ca

Remote - Ottawa, Ontario, Canada

• Consult clients on query optimization, index optimization, server health and MySQL instance health• Troubleshoot and fix broken MySQL / MariaDB replication and outage issues, GTID errors• Use xtrabackup and mysqldump to restore MySQL replicas• Add, drop and alter indexes using pt-online-schema-change (percona toolkit)• Setting up and configuring MySQL alerting systems, such as PMM, datadog and Orchestrator• Creating custom bash scripts for recurring processes and automation• Manage upgrade of AWS RDS and Aurora MySQL instances• Create service files to run executables on LinuxProject Work--------------• Developed Ansible upgrade script for MongoDB replicaset and sharded cluster for client• Developed MongoDB replicaset and sharded cluster test environment using Terraform, GCP, and Ansible• Scripted automated report building using Bash and Python for MySQL performance analysis, and duplicate index analysis

Remote - Ottawa, Ontario, Canada

• MySQL query reviews, analysis and execution• 5 months of researching SQL and NoSQL database administration and use• Modified project management tools to improve team efficiency• Created Slack chat app: server automation using Terraform, Ansible and Google Cloud

Toronto, Ontario, Canada

• Evaluated client financial models and legal contracts, use business case to customize debt sizing model• Managed external consultants for review of debt financing deals• Filtered and contact in-bound web leads for clean energy projects and present them to team

Toronto, Ontario, Canada

• Service and monitor 12-client $20M clean energy loan portfolio of solar and geo-exchange projects• Facilitate accounting and treasury processes for clean energy financial entities• Guide clients through onboarding and banking services

Montreal, Canada Area

• Smoothly facilitated accounting transition to acquiring company• Responsible for payroll, bank account reconciliation, and accounts payable for financial group• Developed project management tool for company-wide data collection event• Automated Xero accounting software, speeding up reconciliation and data entry processes

Montreal, Canada Area

• Created accessible documentation and workshops on sustainable finance for small to medium sized non-profits• Recommended investment strategies for individual non-profits based on needs and values• Researched ESG integration in the investment process• Worked in high-trust team environment

Victoria, Bc

• Handled payroll of 40, reconciled bank accounts, and managed cash flow and accounts payable♦ Programmed macros in excel to automate reconciliation processes and report writing (VBA)♦ Increased data integrity of our accounting process by building MS Access application for parts inventory♦ Proposed and implemented project management tool, significantly improving coordination at administrative level

Montreal, Canada Area

Description: Company devoted to events with speakers surrounding impact investing topics• Compiled ecosystem of impact investing organizations in Canada• Created literature review on impact investing’s latest research

Montreal, Canada Area

Responsible for overseeing financial operations in a campaign focused non-profit organization • Facilitated 3 financial audit engagements• Developed budgeting, payroll, and audit processes• Worked within a close non-hierarchical team

Montreal, Canada Area

Responsible for overseeing the financial operations of a working group based non-profit organization• Developed cash controls, and other basic processes in nascent organization• Researched and implemented government compliance procedures• Navigated organization through bankruptcy of related party

• Created and maintained an information system for 350+ clients,• Maintained the organization of the office,• Handled complaints and solved problems for parents of the children who attended camp.

Research on topics pertaining to small non-profits in Quebec and in Canada, advised small projects, and produced report on better sustainability policies within Concordia University.Researched tax policies affecting non-profit organizations in Quebec and CanadaDeveloped research report on implementation of Green Revolving Funds