Amy Clavin Email & Phone Number

Canada

Calgary, Canada

-Trained team members in reporting models and best practives, overseeing work and performing peer reviews and support when needed-Automated recurring reporting processes for clients taking the time to generate monthly reports from 6 hours and 2 people to 5 minutes and only one person required, improving efficiency and accuracy dramatically, and applied this automation to other clients and reports each time massivley reducing both the manual work and number of errors by moving reports from excel templates to SQL based jasper reports.-Acted as SME on all reporting needs from client data to internal metrics to financial information-Worked with data engineers and data architects to improve report performance and user experience through query enhancing and indexing-Integral in the Go-To-Market strategy for the business by developing critical reporting services for clients and providing key services quickly and accurately to meet SLAsCollaborated with clients to incorporate complex drill down logic with Java based Jaspersoft-Maintained report version control in git -Managed Giving Tuesday, the biggest day in the CSR calendar, by working with cross functional teams to prepare press releases and provide up to the minute insights -Responsible for keeping Company Key Metrics updated and providing key insights to all areas of the business, insuring the ability of senior leadership and executive to track company goals-Developed projection models for Fortune 500 companies to predict future donation volumes -Created and presented reporting workshops, both in person and virtually, for Goodness Matters (now Benevity Live) to teach and inspire leaders at Fortune 500 companies to create their own reports and gather their own insights.

Calgary, Alberta, Canada

-Developed business critical financial reports including granular level reports for tax filing purposes using SQL server and MySQL-Migrated existing reports to PostgreSQL from MySQL-Designed critical dashboards and reporting logic for Fortune 500 executive teams-Performed data integrity checks and identified issues and bugs in the data pipeline during the migration from a MySQL database to PostgreSQL-Assisted in identifying ESG key metrics for clients

Calgary, Canada

-Developed custom reports using Jaspersoft and MySQL for numerous Fortune 500 clients to quickly and easily view donation trends-Incorporated visualizations into reports -Built out complex projection models in MySQL to forecast upcoming donations for client budgets-Working in a Jira based kanban board managing client requests through tickets with all version control handled through Git

Calgary, Canada

MobSquad is a premium start-up based in Calgary that aims to build teams of highly experienced software engineers from around the world to work remotely for US-based start-ups and scale-ups.Responsibilities:- Led the talent acquisition efforts, recruiting and assessing top talent in the fields of software engineering, data science, machine learning, and mobile development- Managed the MySQL database containing over 30,000 engineers, and created complex queries to generate understandable and meaningful insights- Reported directly to the CEO on multiple projects, providing easy to understand dashboards and updates quickly, as required- Individually managed marketing campaigns, targeting US-based potential clients to generate leads and reignite existing leads- Wrote detailed documentation, outlining the experience and skill sets of engineers on the MobSquad Talent Roster, ensuring that this information was understandable to both the technical and non-technical target audience- Developed the messaging and voice used to communicate with engineers globally, transcending cultural and language barriers, through HTML built email templates- Directly worked with clients to understand their needs and customized bespoke teams of engineers to suit their requirements

County Dublin, Ireland

Analysing large data sets and presenting such in a readable manor.Excellent MS Excel experience in particular with pivot tables and the use and application of macros through VBA coding.Preparing reports from huge and diverse data sets for government approval.

County Dublin, Ireland

Helped to promote the Deloitte brand around Trinity College Dublin, with a particular focus on brand awareness within the STEM subjects. This included presentations and discussions in club and society meetings.

County Dublin, Ireland

Part of the data analytics team in Deloitte, involved in analysing and reporting on large data sets.As part of a team, designed an internal organisational system through, MS Excel VBA macros and created a self contained, self updating reporting process for management.Extensive knowledge on the GDPR (General Data Protection Regulation) and aided a team on presenting and explaining the GDPR and its consquences as well as conducting internal audits on companies with regards to GDPR compliance.

Dealing with customer service in a primarily retail role. Organisational and filing duties consistently utilized as a large amount of paper work and official documentation is constantly in circulation in the pharmacy.

Camp Chief Hector, Exshaw, Alberta, Canada

Encouraged the development of new skills in a fun and supportive environment for a number of groups of children. Teaching children outdoor and wilderness skills.Effective communication both between co-workers and children was required for this job, as was a huge amount of adaptability in this fast paced environment.