Brad Ahrens Email & Phone Number

Kitchener, On, Ca

Application Architect (Data Architect) July 2019 - Present· Provide the leadership and management of solution delivery· Architected a digital enterprise at OTIP. · Advocated the data management/data warehousing strategies for OTIP’s Provincial Health, Dental and Life plans encompassing 250,000 Ontario educational workers· Lead the business consulting and analytics defining requirements, shaping the solution design and data model (conceptual and logical) · Designed a self-service interface consisting of cubes, views and snapshots dramatically increasing self-service, reducing requests for new reports · Benefits realization/project ROI of >$1,000,000 in resources savings · Manage operations and governance· Automated bi-weekly processing of 250,000 member’s HR data using Python and SSIS· Advocated automation of member data processing· Lead the business consulting and analytics defining requirements, shaping the solution design and data model, as well as rules composition and SSIS structural design· Designed the governance interfaces for the file submission and processing results· 99.99% accuracy loading into the group benefits system Architected the Group Benefits Work Management Application· Advocated internal development for a new MVC .Net member work management application serving 400 resource · Lead the business consulting and analytics defining requirements, the solution design, including data model · Benefits realized: · Reduced ticket creation time from 3.5 minutes to <1 minute. · Eliminated duplication of through centralization of member work requests · Reduced call time by 20%. · Automated ticket creation for member data errors reducing 2200 hours manual effort per year. · The streamlined, intuitive design enabled the last round of training through online training due to Covid-19 work at home legislation.

· Responsible for application and data strategy· Data Warehouse and custom .Net application development· Implemented Azure DevOps· Revived custom development within OTIP· Team of 5 and 6 BSAs

- Managed the OTIP application base responsible for strategy and application architecture- Designed 4 of OTIP’s top 10 business critical applications (Member Single Sign-on Portal, LTD data warehouse and 2 call center knowledge management solutions) - Troubleshooted 3 most business-critical processes optimizing performance from 6+ hours runtime to 30 minutes or less- Managed a team of 19 direct reports including 3 .Net developers, DBA, 6 Business Analysts, 4 SysAdmins and 5 services desk resources

Mississauga, Ontario

-Designed and architected enhancements to PsPrint Web-to-Print application in production with revenue in excess of $40 million-Managed multiple concurrent product enhancements/projects -Lead an Agile delivery practice -Responsible for developing accurate, comprehensible requirements through user stories/use cases-Managed an off-shore team of 20 including .Net developers, business analysts and production support-Accomplishments include: o Managed production environment achieving 99.9% availability o Selected by the Hostopia CIO for an advanced management training course in 1st four months on the job due to the amount of rapid progress I generated in a stalled project.

Waterloo, Ontario

-Managed a portfolio of .Net, cloud-based products spanning several lines of business -Designed and architected enhancements to the corporate audit and compliance product (Compas), and the health and safety product (Awareness) for customers including Nike, Reebok/Adidas, Office Depot, OfficeMax, Payless Shoes, Kroger Foods, Schwan’s Foods and Genuine Parts Corporation-Managed 6 concurrent product enhancements/projects with budgets up to $250K -Manage 16 direct reports including .Net developers, business analysts and production support-Lead an Agile delivery practice leveraging time-boxed delivery for net new development and Kanban for production support-Responsible for developing accurate, comprehensible requirements through user stories/use cases -Accomplishments included:o Analyzed and redesigned the customer support process establishing a help desk reducing the number of customer facing resources by 1/3o Analyzed the customer support trouble ticket flow identifying high volume problems and reduced trouble ticket volume by 20% through product stabilization and process automationo Migrated 25 production customers into a cloud hosting environment achieving 99.8% availability

Mississauga, Ontario

-Managed delivery of multiple concurrent MS SharePoint e-Government and Community Portal projects encompassing website architecture, design and development incorporating Ontarians with Disabilities Act (ODA), Web Content Accessibility Guidelines (WCAG) compliance, and integrated online e-Services, and payment processing; and data warehouse and reporting solutions for healthcare -Lead the design and architecture of municipal Internet/Intranet sites incorporating content and document management with retention and approval policy and workflow, navigation, wireframes and page layouts, forms with workflow and integrated E-Services with clients including the Township of King, City of Brantford, City of Belleville, and data warehouse for the Mississauga Halton Local Health Integration Network-Responsible for developing accurate, comprehensible requirements through user stories/use cases Managed 13 direct reports in SharePoint and .Net development and delivery teams-Accomplishments included:o Spearheaded design and delivery expertise turning around the SharePoint (MOSS) practiceo Designed a content acquisition process for Internet site delivery and management using SharePoint out-of-the-box functionality

32 Upper Canada Place

-Designed and architected Microsoft SharePoint solutions and .Net applications encompassing content and document management with approval and retention policy with workflow; forms with workflow; site navigation, page design and security-Projects included:o The migration of Aecon’s 7000 page Intranet from Reddot to SharePoint 2007o Hamilton Health Sciences SharePoint 2007 Extranet enabling 5 hospital boards collaboration on inter-hospital initiativeso A .Net, web-based project management solution for The Linkage Group, a national contract retail services business reducing data entry costs by 75%, reducing project set-up time by 50% and providing immediate and continuous visibility of project progress and costs accrued

Mississauga, Ontario

-Designed and architected Microsoft SharePoint solutions, .Net applications and data warehouses encompassing content and document management with content acquisition, approval and retention policy with workflow; forms with workflow; site navigation and page design and security; and -Microsoft SQL Server-based data warehouse and reporting solution-Responsible for developing accurate, comprehensible requirements through user stories/use cases Customers include:o A SharePoint 2007 corporate intranet for Comark greatly enhancing corporate communications and collaboration o A SharePoint 2003 to SharePoint 2007 migration of the Algonquin District School Board Intraneto A Business Partner Extranet for Morrison Hershfield greatly simplifying project coordination and collaborating, consolidating project content and providing document versioning and ease of accesso A corporate Intranet for Rothmans, Benson & Hedges greatly enhancing corporate communications and collaboration o A data warehouse for Liberte Natural Foods automating data consolidation from two ERP systems providing an on-demand reporting and data analysis solution eliminating manual data consolidation and report creation-Designed and delivered a SharePoint Solutions seminar series partnered with Microsoft

Mississauga, Ontario

-Designed and architected Microsoft SharePoint Internet/Intranet solutions and Microsoft SQL based data warehouse and reporting solutions-Performed business analysis generating UML-based functional specifications -Customers include:o A SharePoint 2003 based service portal for Simplex Grinnell for managing customer alarm panel programs eliminating loss of panel programs estimated at $60K per incidento A document management solution for Black & McDonald consolidating sales and marketing, HR and project design documentation o A corporate Intranet for Maritz Canada migrating from SharePoint 2003 to SharePoint 2007o A sales portal for Bard Medical consolidating and providing content management for all sales related contento A SharePoint 2007/SQL Server 2005, KPI-based dashboard and data warehouse solution for ICS Courier consolidating data from an AS400, MS SQL and MySQL providing a single point for management of route and product effectiveness and overall sales force performanceo A SharePoint 2007/SQL Server 2005 data warehouse and reporting solution for Ticket King providing a browser-based reporting interface for stakeholders and production sponsors

Mississauga, Ontario

-Designed and grew a SAS network operations centre based on HP Openview, Cisco Works, Bay Networks Optivity, and Heat-Monitored business critical servers, and local and wide area networks for Orica Explosives spanning North and South America (formerly an ICI Paints company), Hostess Frito Lay, Toromont CAT, Beacon Eye Institute, Air Georgian and Viceroy Homes; and provided level 1 and 2 help desk services for 2500 users for Orica Explosives and Recall/Iron Mountain.-Designed operational processes, service level agreements and contracts-Developed and managed the customer satisfaction program-Managed 12 person network operations centre and help desk meeting stringent service level agreements

Mississauga, Ontario

-Responsible for defining scope for new opportunities and providing estimates to sales-Project managed the re-design of Magna’s global WAN spanning 1200 locations across 165 countries reducing operational costs by greater than $1 million per year-Project managed Bell Mobility’s new desktop software deployment to 1000 desktops with 0 defects-Project managed the network migration for Orica Explosives (formerly an ICI Explosive) encompassing 60 servers and 1000+ desktops spanning 84 locations across North America

Mississauga, Ontario

-Achieved $1 million in sales in the first year

Mississauga, Ontario

Achieved yearly sales of $2.5 million.

Computer Maintenance Diploma, Computer Technician

Diploma, Aircraft Maintenance