• Lead solution to synchronize data between external applications by ingesting raw data through iPaas flows and organizing SQL scripts within Azure Data Factory pipelines. This effort led to enhanced data analysis capabilities and a 96.6% reduction in manual data entry.• Design and implement normalized database tables, schemas and models in Databricks while optimizing parallel processing, partitioning and efficient delta storage during a cloud migration and data unification project.• Ingest third party application data via Python serverless application and API, this data is transformed and integrated into the data warehouse daily to improve decision making and eliminate platform reporting constraints.

• Automate retrieval, cleaning, computation and integration of csv data between storage blobs and Databricks delta lakes.• Create a user-facing load status table, implement access controls and establish backup procedures in Databricks to improve data transparency and availability for end users.• Plan and execute Power BI data models and reports to meet multi-departmental needs while maintaining data confidentiality at row-level and optimal model performance through star schema. • Ensure seamless project offboarding by maintaining inline and external documentation and leading maintenance training sessions for clients.

• Initiated and completed Agile work process initiatives such as a lifecycle-management reporting dashboard, quality assurance dashboard and the consolidation of team resources in Azure DevOps.• Using Power Query in M syntax OData and SQL server data was transformed to create a revitalized Power BI data model through reverse engineering which reduced data refresh time by 62.5%.• Facilitated project and development meetings on behalf of the solution delivery manager.• Led internal and external assignment and weekly maintenance of 35 virtual machine software environments across North American districts.

• Provided analytic support to overall corporate profitability analysis.• Accountable for the planning, execution, and analysis of the inaugural customer satisfaction survey.• Execution of new branding initiatives including website content and design.• Indexing of nationwide industry media contacts for public relations purposes.

• Created promotional videos and infographics for social media with Adobe Premiere and InDesign• Promoted Prince Albert National Park events by scheduling Tweets through Hootsuite • Demonstrated advanced communication skills by conducting interviews for website content and by hosting information booths and educational programs during events and festivals • Created new projects and forged partnerships with community volunteers and local businesses to advocate for Prince Albert National Park