Jean-Philippe Leclerc

As part of improving quarterly reporting for the Alternative to Detention (ATD) program:

• Automated manual quarterly KPI reporting by building a Power BI dashboard using DAX, saving approximately one week of effort per reporting cycle.
• Designed and optimized a multi-table data model from large Excel datasets.
• Built a new Power BI dashboard, implementing additional, more granular KPIs beyond an existing baseline dashboard.
• Optimized Power BI performance for scalable, recurring reporting.

As part of identifying illegal exports of stolen vehicles across Canada, and supporting efforts to prevent cross-border criminal activity:

• Developed and generated simulated data to model real-world network environments, serving as a proof of concept and prototype for further applications.
• Collaborated with border officers to identify project needs and scope by gaining insights into their data and operational requirements.
• Designed a graph model and automated the transformation of large tabular datasets into graph data, streamlining the conversion process.
• Detected and identified various types of anomalies within graph data using statistical techniques such as degree, centrality, and path length analysis.
• Prepared comprehensive reports, summarized key findings, and presented results to senior management for strategic decision-making.

Contributed to a project focused on documenting and monitoring the costs of all Amazon Web Services (AWS), while optimizing cloud resource management:

• Analyzed AWS usage and associated costs, identifying their origins based on cost centers and project tags.
• Prepared comprehensive reports summarizing AWS costs and presented findings to key stakeholders within the organization.
• Designed and implemented a schema-less database model using AWS DynamoDB, enhancing data flexibility and scalability.
• Leveraged AWS services, including Cloud9, Cost Explorer, and CloudWatch dashboards, to monitor and optimize infrastructure performance.
• Delivered software as part of a Scrum Agile team, contributing to iterative development, and continuous improvement.

As a franchise manager:

• Recruited and managed a team of three employees, overseeing their performance and development.
• Utilized strong verbal communication skills to engage customers, assess their needs, and provide tailored solutions.
• Oversaw all financial aspects of the business, including profitability, collections, tracking, and payroll management.