Adam C. Email & Phone Number

Fredericton, Nb, Ca

Fredericton, New Brunswick, Canada

Achievements - Promoted to BI Functional Lead in a year. - Place on an Information and Governance Committee to help define the AI Directive for ANBL. - Designed a hybrid Agile / Waterfall strategy for future departmental structure. - Power Platform Administrator - Azure Administrator - Database Administrator - External Data Committee - ingestion from external data sources - methodology, processes and governance.Technologies - Microsoft Azure - Microsoft Power Platform - Power Apps, Power Automate, Power BI, Dataflows, Sharepoint - D365 - Finance and Operations, Supply Chain Management and Commerce - Postman - Microsoft Azure Data Studio - Microsoft AI Studio - SSRS / SSIS / SQL Management Studio - Synapse - Azure Databricks

Montreal, Quebec, Canada

Technologies - Microsoft Power Platform - Power BI, Power Automate, Power Apps) - Azure Data Factory - Azure Data Studio - SSMS / SSRS / SSIS - Dataflows - Postman

Montreal, Quebec, Canada

Responsibilities - Analyst, Developer and Data Engineer for Telecom companies Ericsson, AT&T, Verizon and T-Mobile. - Developing and Maintaining BI solutions for Supply Chain Management and Project Management Dashboards, Databases and Data Warehouses. - Lift and shift project from SQL Server to Cosmos DB. - Developing Power Apps, Dashboards for Inventory, Tower Latency, Fraud Anomalies and Finances. Technologies - Microsoft Power Platform - Power Automate, Power Apps, Power BI, Power Pages - Azure Data factory - Synoptic Mapping - SSIS / SSRS / SSMS

Montreal, Quebec, Canada

Projects Business Intelligence Specialist | OMERS – Remote Contract Toronto, Ontario Consultant / Contract | December 2020 – April 2021 - Developing Business Intelligence solutions and dashboards for stakeholders using Power BI, Azure, Tabular Editor and Power Query. Dashboard solutions for Finance, Fraud Anomalies (repetitive vendors, transactions etc.), Pandemic Planning, High Level Environment, Social and Governments, - Demographic Planning and Carbon Footprint Dashboards.Business Intelligence Analyst | Scotiabank – Remote Contract Toronto, OntarioConsultant / Contract | December 2020 - Developing a Server Dashboard for the Scotiabank IT department to detect anomalies and outages. - Applying live streaming data to Synoptic Mapping to create a live interactive vector map to see where and when the anomalies are occurring, and tickets associated with the anomaly. Applied cognitive analytics to potentially predict future anomalies through historic data. - Created dashboards for the Fraud Department to detect instances in personal and corporate accounts.QA Testing / Developer | TD Bank On-Site Montreal, QuebecConsultant / Contract | December 2019 – November 2020 - TD SAS Integration Project (Lift and Shift) - Testing – Creating and test cases for CBM and Reports in a SIT HEAT environment such as Functionality, User Interface, Performance, Integration, Usability, Database, Tableau, Negative and Security tests. Using Linux, Python, SQL, Excel, Jupyter Notebook and Tableau.Technologies - Power Platform - Power BI, Power Automate, Power Apps - Azure Databricks - Azure Data Factory - Cosmos DB - Python - PySpark / Spark - SSIS / SSRS / SSMS - Jupyter Notebook - Linux - Tableau - Synoptic Mapping - Hadoop - Tensorflow

Montreal, Canada Area

Engineering hybrid on premise and cloud solutions for EMR Records for professional athletes, organizations and associations such as NHL, LHJMQ, MLB, NBA, CFL and World Cup Organization. Created customs visuals and Medical Synoptic Mapping linked to live streaming data, ICD (WHO Medical Codex) databases. Presenting data engineering solutions, dashboards, security, architecture and process flow to NHL, CFL, MLB and NBA conferences in NYC, Sacramento, Houston and London England. Applying cognitive analytics to monitor and discover trends such as player injuries and causes, equipment usage, sleep patterns, win / losing games, training patterns and drafts. Managing Business Intelligence Department in Montreal branch, duties included budgets, hiring staff, training, travel and presenting to the board. Technologies | Azure, Power BI, SSMS, SQL, JavaScript, Azure Blob, Tableau, Qlik, Python, R and Vector Mapping.

Montreal, Canada Area

Projects Business Intelligence Developer | Flight Hub Montreal, Quebec Short Term Contract | February 2019 Creating a dataflow process from the Data Lake to the Warehouse to Tableau. Self-guided to improve skillset and learn best practices from Microsoft and ApacheTechnologies | AWS, Looker, Python, Redshift.

Montreal, Canada Area

SQL Developer for a lift and shift project to integrate the acquisition Alarm Force to Bell Smart Home. Developed and maintained ETL processes using SASS and Teradata. Technologies | Teradata, SSMS, MySQL, OLAP Cubes, SQL.

Montreal, Quebec, Canada

Developed and maintained webpages from ad hoc stakeholder requests.Worked in a 90% Agile environment when planning short and long-term environment.Promoted in a 2 month time from Junior Front End Developer to BI Developer and UX Analyst.Performed market research and A/B testing to analyze UX to retain clients and help with conversion. Created predictive models using statistical inference and analysis. Technologies | Optimizely, Sisense, R Studio, Looker, CSS, PHP, Java Script, HTML

Fredericton, New Brunswick, Canada