Nathan MacPherson
Data Services Manager
Prince Edward Island,Canada
Summary
Highly skilled and accomplished Lead Data Migration/Integration Engineer with 12 years of experience in designing, implementing, and managing data engineering solutions. Proven track record of leading cross-functional teams and collaborating with stakeholders to define data engineering strategies that align with business objectives. Adept at managing large-scale data projects, driving data governance initiatives, and ensuring data quality and integrity throughout the data lifecycle. Skilled in translating business requirements into technical specifications and implementing scalable data solutions.
Overview
19
19
years of professional experience
9
9
years of post-secondary education
Work History
Data Services Manager
Cogsdale
Charlottetown, PE
01.2017 - Current
- Led Data Conversion and assisted technical implementation for many projects (12+). Overseeing multiple projects at one time.
- Led team for software engineering services and supported key clients in development efforts, establishing standards, determining specifications and creating Service and Operational Level Agreements (SLA) .
- Extensive SQL Programming (ETL), Reporting & Analysis (Data Cleansing)
- Develop SQL Objects for Integrations and Reporting purposes. (Stored Procedures, Views, Functions).
- Maintain and track changes to customized SQL Code - Utilizing Jira and BitBucket.
- Developed and maintained integrations for MS SQL Server (i.e. SSIS, SmartConnect).
- Establish process for developing and implementing Reporting Requirements (SSRS, Smartlists, Power BI).
SQL Server DBA Analysts
Canadian Red Cross
Pownal, PE
01.2016 - 01.2017
- Developed and maintained courteous and effective working relationships.
- Manage dozens of cases, for many applications daily.
- Delivered exceptional level of service to each customer by listening to concerns and answering questions.
- Research software application products and services
- Provide support for testing of new and existing software applications
- Field and document incoming problem tickets from end users to resolve application and software issues within servers, databases, and other mission-critical systems
- Monitor Database performance and tune data issues related to expensive SQL Query (Solar Winds monitoring tool).
- Maintain SQL Data Integrations.
Business Application Specialist
Province of Prince Edward Island
Charlottetown, PE
06.2015 - 01.2016
- Provide information technology services to specific business applications by applying investigative, analytical and design skills.
- Develop complex data queries for system to system communication. Develop export, transform and load procedures (ETL).
IT Consultant Data Conversion Lead
Cogsdale
Charlottetown, PE
02.2012 - 06.2015
- Demonstrated respect, friendliness and willingness to help wherever needed.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
- Data Conversion Lead – Convert data to Customer Service Management (CSM). CSM is integrated with Microsoft GP 2010 ERP software and SQL Server 2008 R2.
- Facilitated End-to-End data conversion extraction queries for Oracle CC&B.
Naval Combat Information Operator
Canadian Armed Forces
Charlottetown, PE
05.2004 - 02.2011
- Conveyed communication between military personnel at home and war zone bases.
- Developed strategic plans to warn, control and evacuate personnel and general public from critical zones.
Education
Post Graduate Degree - Information Technology
Holland College
Charlottetown, PE06.2011
Bachelor of Arts - Police Studies
University of Prince Edward Island
Charlottetown, PE 09.2004 - 05.2009
Certificate of Public Administration - Local Government Administration
University of Prince Edward Island
Charlottetown, PE 09.2004 - 05.2009
Skills
- Administering Databases: MS-SQL Server 2012/2008 R2/70, MySQL, Oracle PL/SQL
- Report Development: SSRS, Crystal, Power BI, Smartlists
- Integration Software: SmartConnect, SSIS, SQL Server Agent Jobs
- Languages: MS SQL Server Transact, SQL Plus, Visual Basic (VB), UML, Advanced Java Programming, ASPNET, HTML, XML, PHP, SQL, CSS, JavaScript
- Tracking Software: Jira, Confluence, Sharepoint, BitBucket, Microsoft Project
Timeline
Data Services Manager
Cogsdale
01.2017 - Current
SQL Server DBA Analysts
Canadian Red Cross
01.2016 - 01.2017
Business Application Specialist
Province of Prince Edward Island
06.2015 - 01.2016
IT Consultant Data Conversion Lead
Cogsdale
02.2012 - 06.2015
Bachelor of Arts - Police Studies
University of Prince Edward Island
09.2004 - 05.2009
Certificate of Public Administration - Local Government Administration
University of Prince Edward Island
09.2004 - 05.2009
Naval Combat Information Operator
Canadian Armed Forces
05.2004 - 02.2011
Post Graduate Degree - Information Technology
Holland College
Similar Profiles
DAICA TALUSANDAICA TALUSAN
General Manager at Islandsand Holding Inc - SubwayGeneral Manager at Islandsand Holding Inc - Subway
Kyle SherrenKyle Sherren
Compensation Advisor at Public Service and Procurement CanadaCompensation Advisor at Public Service and Procurement Canada
Jason RaffoulJason Raffoul
Operations Manager at Maritime Pressure WorksOperations Manager at Maritime Pressure Works
Corey GreenCorey Green
Data Services Manager at ADJ Integration SolutionsData Services Manager at ADJ Integration Solutions
Jennifer CarverJennifer Carver
Data Services Manager at Aesto HealthData Services Manager at Aesto Health