Marc Richard Email & Phone Number

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

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.

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