Kevin Lemay, B. Eng. – Technical Project Manager – Solution Architect - Data Management

**** ****** *** *****, ******, Ontario, K1C 2W7 613-***-**** adjgf8@r.postjobfree.com INTRODUCTION

Mr. Lemay is a bilingual (French & English) Technical Project Manager – Data Management with both a strong business and technical background proven over the past 8 years through his experience with custom Intelligent Information Management/Enterprise Content Management (IIM/ECM) projects, SAP projects, and through operating a successful IT company. He is highly focused and attentive to details, organized, hard-working, result-oriented, an excellent communicator, and capable of working across multiple fast- paced projects simultaneously. He enjoys new challenges, is quick at learning new skills and technologies, and is determined to get the job done.

Secret Clearance – Valid until 2024-11-20.

WORK EXPERIENCE

Employer: Enara Technologies – Ottawa, Ontario

Position: Technical Project Manager – Solution Architect – Data Management Clients: Taggart Construction Limited, Tamarack Homes, Taggart Realty Management, Ottawa Police Association

Time Period: February 2014 – Present (84 Months)

Enara’s primary focus is to understand the goals and needs of their Client organizations to develop a customized solution and strategy that meets their specific requirements – whether it is Intelligent Information Management (IIM), Enterprise Content Management (ECM), Human Capital Management

(HCM), Unified Information Views, Intelligent Information Automation, Compliance Enablement, Client Relationship Management, Business Process Re-Engineering and Automation (Workflow), Digital Transformation, etc.

Mr. Lemay was Technical Project Manager and Solution Architect for multiple projects and Clients throughout all stages of the project life-cycle. He attended and led discovery meetings (up to the director level) to identify, document, and analyze data/information requirements including current state IAM business, process, and application architectures. These details were used to design, develop, and implement IIM/ECM software solutions such as M-Files to meet Client data/information management needs and improve business processes.

Projects required creating migration strategies for Client legacy data into the newly developed IIM/ECM solutions such that only information that provided corporate value or was required for legal reasons was migrated.

Tasks and Responsibilities:

• Attend client discovery meetings (up to the director level) to determine and document business requirements, functional requirements, key performance indicators, business processes, system requirements, and user requirements. This information is documented, analyzed, and translated into technical specifications for the overall solution architecture design. Utilized Microsoft Visio and UML Standards for system/solution designs.

Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 2 of 7

• Proposed project schedule to the Client which included all major milestones to design, develop, and implement various IIM/ECM system solutions, Workflow processes, CRM Database activities, Security Policies, and Digital Transformation solutions. Utilized Microsoft Project for proposed schedules.

• Defined information management strategy, policies, and service/solution delivery methods to ensure all system users were properly prepared for new implementations.

• Supported the Senior Solution Architect in configuring and maintaining the servers (Application Server and Proxy Server), Firewall, and SQL Server/Database to implement the M-Files solution and allow for mobile/web access to all information in a central repository: o Installed IIS on the Proxy Server, configured RPC application on default website, o Installed wildcard SSL certificate on Proxy Server and added HTTPS binding to website o Updated mappings in the HOSTS File with DNS Aliases o Configured Proxy settings to establish connection with the Application Server. o Created HTTP Redirect to ensure HTTPS encrypted traffic is always utilized o Added SQL Database details to M-Files Admin Tool to establish connection. o Tested all aspects to ensure proper installation and configuration for the solution.

• Installed and configured M-Files software on the Client servers and all user workstations. o Import user and login accounts using Windows Active Directory and assign licenses. o Integrate M-Files with Microsoft Exchange for email notifications and assignments. o Determine and configure a regular backup and database optimization schedule. o Install M-Files software on all user workstations and create required vault connections via Group Policy Object (GPO) and by manual process if/when required.

• Designed, developed, implemented, configured, and tested the M-Files data architecture solutions that encompass current and potential future business process and data/information requirements determined in the analysis phase:

o Create an impact analysis report for different design decisions to present to the project manager and senior architect and select the best approach. o Create a solution design document and implementation schedule for approval by the project manager and Client.

o Define and implement all Object Types, Classes, Property Definitions, and Value Lists necessary to implement the solution architecture and allow for document organization, information management, process automation, and overall efficiency. o Create all client document types in M-Files, add existing templates, and configure automatic permissions with the use of access control lists. o Create and maintain workflows to increase business productivity and automate recurring business processes. Wrote custom code as required to enhance workflow capabilities, create metadata validations, and enforce naming conventions withing metadata. o Created and maintained security policies in M-Files at the Object, Class, and occasionally Property Definition levels with the use of user groups and access control lists. o Created various custom code to increase solution functionality – JavaScript, SQL, VBScript, and Application Programming Interfaces (APIs). o Tested (unit, integration, user) all installations, configurations, and custom code. o Installed and configured IDOL search engine to configure Faceted Searching capabilities for all users. This required creating configuration files in JSON format. o Installed and Configured the Intelligent Metadata Layer (IML) component of the solution for intelligent automation of metadata prediction.

• Designed, developed, and implemented custom user interfaces for both record and document entry.

• Imported pre-defined data into SQL tables for Choose-From Lists (drop-down selections in M- Files) using CSV files.

Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 3 of 7

• Demo the overall solution to the Client to ensure it meets their document and information management expectations. Implement final configuration changes based on Client feedback.

• Analyzing existing legacy systems and data models to determine the best approach to migrate data to the newly designed and implemented solution.

• Perform legacy data migration into the newly designed solution: o Meet with the Client to review the migration strategy which contains the current status of their legacy systems data, the best approach for migration, overall schedule, and progress. o Ensure all data access permissions remain unchanged in the new environment. o Create and maintain the migration progress report.

• Designed, developed, implemented, and supported (for Quality Assurance) custom automated workflow solutions in M-Files including identifying Key Performance Indicators for reporting and analytics. The following solutions were included:

o Organization recruiting and hiring process for new job postings that track and manage candidate information and resumes, maintain the overall status of a particular candidate in the hiring process, scheduling interviews, etc. A workflow was implemented to automate many stages of the business process and reporting capabilities were provided for HR Managers.

o HR department and Supervisor solution to manage and track employee vacation entitlements for the year including an approval and tracking process for each Time-Off request (Vacation, Sick, professional development, and special request days). A global calendar and reporting capabilities were created for HR and all supervisors to aid in managing their employees. Workflow was created to automate the approval process and update employee entitlement data.

o To provide Tamarack Homes with full view of their inspection report process – Inspector name / contact details, site details, inspection start/end dates, etc. Reports and Analytics were created here for CEO and Project Stakeholders to understand what bottlenecks exist in their operation (Site specific, specific inspections, site clerks, inspectors, etc.). o Conferred with Senior Management and project Stakeholders to understand/determine their reporting/analytic requirements which would later be implemented.

• Conduct detailed user and administrator training sessions for the newly implemented solution outlining all policies and procedures.

• Restructured and modernized a repository of Health and Safety document templates to ensure that they displayed properly on all devices (laptop, mobile, tablets, web, and iPad) as part of updating their site inspection process.

• Performed regular data integrity checks throughout the database for record data and document metadata. Created and executed VBScripts and various SQL statements to cleanse invalid data.

• Worked with the organization “super” users to define and document a business glossary of terms and create data governance policies that would be enforced on certain metadata fields to ensure accurate and required data is used.

• Provided on-going software and solution support to ensure that the Client and all their employees are comfortable with the end product and new business procedures assuring user acceptance. This included performing the following:

o Providing the Client and all system users weekly tips based on issues discovered during data integrity checks

o Conducting bi-weekly Lunch and Learn sessions

o Meeting with Client “Super” Users monthly to conduct reviews and receive feedback on new policies, procedures, software product changes, information system solutions, etc. to further refine roll-out strategies as part of the quality assurance process. Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 4 of 7

• Provided technical support including performing software upgrades/patches, resolving any discovered bugs/issues, and providing level 2/3 technical support on trouble tickets and feature enhancement requests:

o Performed Software Updates and patches through GPO and manual processes. o Analyzed trouble tickets to determine the cause of the issue, determined trouble ticket resolutions, acquired approval when required, and implemented the changes. o Created formal documentation for each trouble ticket that outlined all details – Ticket creator, issue description, cause, risk level, resolution option, changes implemented, problems encountered, level of effort, etc. Walkthrough guides were provided for steps taken to resolve issues so that internal IT staff had detailed information to resolve similar tickets themselves in the future.

o Utilized SARM for remote access to employee systems in order to diagnose/reproduce issues and provide prompt resolutions to escalated trouble tickets o Liaised with Vendors when bugs or issues are encountered that require further escalation to Vendor R&D team for resolution.

o Created various scripts, queries, and SQL statements to acquire data from SQL databases for analysis and to update tables/records to resolve issues or implement change requests. o Coordinated all Software and Database implementation changes and maintenance procedures that require system downtime with the IT team – this included providing detailed change request reports

• Document all configuration changes to the solution architecture for Client approval and reference.

• Utilized Microsoft Visio and UML Standards to create detailed System Diagrams for system design documentation.

• Documented business processes, IIM/ECM solution architectures/solutions, and all custom code.

• Produced guideline, procedure, and walkthrough documentation for the information system solutions, procedure and policy changes, trouble ticket details, and for overall data entry recommendations.

• Provided bi-weekly progress reports to the Client and daily updates to the Senior Solution Architect.

Documentation and Reports Created:

• Project Charters/Plans

• Business/System Analysis

• Impact and Risk Analysis

• Solution Design

• Data Migration Progress Reports

• Testing Scenarios

• Training Documentation and Presentations

• Guidelines, Procedures, Walkthroughs

• Status Reports

Employer: CVL Information Solutions Inc. Ottawa, Ontario Position: Business Development Manager / Contract Manager Time Period: February 2014 – Present (84 months) (Part-time) Focusing on expanding CVL Information Solutions Inc (CVLIS), the company’s Task-Based Informatics Professional (TBIPS), Solution-Based Informatics Professional Services (SBIPS) and ProServices contract vehicles were utilized to create proposals (bids) to acquire new public sector contracts. Upon being awarded Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 5 of 7

numerous contracts, Mr. Lemay was identified as the Contract Manager (the principal point of contact for both the Client and supplied sub-contractors) to ensure that projects ran smoothly and efficiently. Tasks and Responsibilities:

• Daily search of Canadian Buy and Sell along with MERX websites for newly released tender notices that fall in the company’s area of expertise.

• Contacting the Contracting Authority appointed to any request for proposals (RFPs) of interest to receive the RFP for review and to clarify any questions in regard to its requirements.

• Analyze the required skills, certifications, and security clearances to determine if CVLIS has qualified resources to supply to the procurement entity. This is accomplished by cross referencing the above details to the company resource database and searching for individuals on online recruiting networks such as Indeed, LinkedIn, and Monster.

• Contacting the potential resources to propose the job opportunity, determine if they are interested, and determine if they meet the requirements.

• Editing resource resumes to better answer all requirements.

• Creating all of the necessary documents (Technical Bid, Certifications, Financial, and any substantiating documents) to submit a high-quality compliant bid to the procurement entity.

• Leading internal QA sessions with upper management and team member to revise the final documents and make any necessary corrections before submission.

• Trained staff on the complete RFP bidding process from

• Drafting, signing, and managing contractor service agreements and task orders.

• Appointed as the technical and contracting authorities’ principal point of contact at CVLIS for all on-going projects. This includes the following responsibilities: o Managing Client invoices.

o Managing all contracts, and contract amendments. o Ensuring client satisfaction with performance of resources. o Managing any required resource changes and transitions. o Managing Visit Clearance Requests (VCRs).

• Principle point of contact for all sub-contractor resources. This includes the following responsibilities:

o Manage resource security clearances as the company Alternate Company Security Officer

(ACSO).

o Manage Controlled Goods and VCRs.

o Manage all contracts such as Master Services Agreement and Task Orders. o Manage resource invoices, timesheets, and progress reports. o Manage any resource concerns or issues with the project to ensure they have everything necessary to perform their duties.

• Hold regular meetings with all sub-contractors.

Employer: ERP Mastering Inc. Ottawa, Ontario

Position: Technical Analyst (SAP BW)

Time Period: April 2012 – March 2015 (36 Months)

During this time, Mr. Lemay worked on various SAP Business Warehouse (BW) upgrade projects from version 3.5 to 7.x for the ERP system. Legacy system data was analyzed and migrated into the upgraded environment of the ERP system (Dev QA Prod).

Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 6 of 7

Tasks and Responsibilities:

• Attended client discovery meetings to get a clear understanding of current business processes and systems to design the new SAP BW architecture, define client/user migration expectations, and determine the overall scope of the project.

• Analyzed current data flows and rules to design the new SAP BW system architecture and prepare for legacy data migration from various Relational Databases.

• Developed and documented data flowcharts and functional designs of the system architecture and migration process to describe how data will be migrated into the newly designed SAP BW system.

• Created, documented, and activated InfoCubes, DSOs, InfoSources, InfoObjects, Transformations, Start/Exit routines, DTPs, Transports, and process chains to develop the newly design system architecture.

• Activated and installed BI Content.

• Analyzed legacy systems and data models with varying interfaces to determine the best method to migrate the data into the SAP BW component of the ERP system.

• Verified that existing data has been cleansed and prepared for data migration into the SAP BW environment of the ERP system.

• Performed all necessary Extraction, Transformation, Load (ETL) data flow migration activities to transition the SAP system from version 3.5 to 7.0. o Migrated DataSources, Transformations, DTPs, and all InfoObjects. o Updated all Transfer Rules for DTPs and Transformations. o Tested newly transferred ETL data flows to ensure that data is properly loaded into the InfoProvider. If any discrepancies were found, input data and all stages of the ETL process were examined to determine and resolve the issue.

• Created custom Advanced Business Application Programming (ABAP) code for the start/exit routines of several Transformations in the new ERP system to ensure that only the required data is being extracted from the specified tables and migrated to the target system.

• Developed and maintained ETL processes to extract data from SAP and non-SAP data sources such as ORACLE and SQL database and load into the ERP system for reporting.

• Created and maintained documentation to track which data has been migrated to the ERP system.

• Extracting data through Flat Files for transactional data, master data (texts, attributes, hierarchies), and characteristics.

• Worked on performance tuning of InfoCubes and DSOs by using aggregates and indexing.

• Modified already loaded InfoCubes with the Remodeling Toolbox. This required modifying all queries based on the changed InfoCubes.

• Performed process chain maintenance by ensuring that all scheduled jobs ran to completion. Any process chains with errors were investigated, corrected, and manually executed to completion.

• Created and Modified queries using the BEx Query Designer with the use of Conditions, Exceptions, and Variables to create reports with BEx Analyzer and Web Application Designer.

• Reports were tested with scripts defined by team members and users.

• Tested the migrated data by generating and comparing reports from the legacy system and the newly designed SAP BW system to display all data anomalies. Documentation and Reports Created:

• Business/System Analysis.

• Solution/System Design.

• Status Reports.

• Data Import Tracking.

Kevin Lemay, B. Eng.

613-***-**** / adjgf8@r.postjobfree.com

Page 7 of 7

IM/IT EXPERIENCE SUMMARY

IIM/ECM Software:

• M-Files, SER Group Doxis4, Hyland OnBase.

SAP:

• Business Information Warehouse.

• Business Explorer Suite.

• Business Objects Crystal Reports.

• Application Server ABAP.

Programming/Scripting Languages:

• Java, JavaScript, SQL, C, C++, VB, VBScript, Python, MATLAB, Shell Scripting (BASH). Environments:

• Windows, SQL Server, Linux.

• SQL Database, ORACLE Database

• IIS

Microsoft Office:

• Visio, Word, Project, Excel, PowerPoint

EDUCATION AND CERTIFICATION

Education /

Training

B. Eng. Computer Systems Engineering – Carleton University OnBase by Hyland Training Course – 2018

Doxis4 by SERGroup Training Course – 2020

Certifications

M-Files Administrator, User, and System Administrator Certifications 2015/2017/2019 – Re-certified every 2 years.

SAP Certified Application Associate – Business Intelligence with SAP NetWeaver 7.0

August 2013

SECURITY CLEARANCE

Secret – Valid until 2024-11-20

REFERENCES

Available upon request

Contact this candidate