Nathan Macpherson Email & Phone Number

Vancouver, British Columbia, Canada

Atlanta, Georgia, United States

Prince Edward Island, Canada

As the Data Service Manager I work with the implementation team to create business rules and migrate data from legacy system to the Cogsdale Solution by defining a process that ensures both data conversion quality and efficiency for implementation.I provide coaching and mentoring to our customers. Also, I ensure customers have the right tools to get quality reporting and data from the system in order to have the services align with the sales processes.As the Manager, I am responsible for all people management task such as assisting with scheduling, vacation request management, and performance management.

Prince Edward Island, Canada

• Provide information technology services to specific business applications by applying investigative, analytical and design skills. Namely: Claims Processing System (CPS) Drug/Medicare/Dental – System Administrator – Platform: Oracle PL/SQL – Vendor: Deltaware  Provincial Safety Management System (PSMS), System Administrator – Platform: MS-SQL Server 2008 R2 – Vendor: RL Solutions WinRecs – Health Records – Platform: MS-SQL Server 2008 R2 – Vendor: Med2020  EMR (Icore) – Medical Practice Management – MS-SQL Server 7.0 – Vendor: Deltaware  Colorectal Cancer Screening(CCSP) – Platform: MySQL – ITSS  Adstra Management and Imaging – Dental – Platform: MS-SQL Server2008 Vendor: Adstra• Crystal Report Development and Editing (i.e. Department of Finance Reporting)• Develop complex data queries for system to system communication. Develop export, transform and load procedures (ETL).• Adhoc SQL Querying for Oracle and SQL Server Databases, troubleshoot code• Providing support to system users by identifying and troubleshooting system issues.• Understanding business rules and environment when defining and coding within Oracle databases• Working and liaising with business staff and vendors to ensure problems and issues are clearly communicated.• Participating in designing the development of application enhancements.• Producing technical and functional documentation for staff and users.• Reviewing, understanding, and supporting Government’s IT Business Plan recommendations.• Administer SQL Server and Oracle based Databases• Communicate and liaise between vendors and clients/end users• Software upgrade assistance and planning• Track defects of applications and ensure vendors are aware of software issues

Home Office

• Research software application products and services• Provide support for the 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• Schedule, and administer enhancements and defect resolution• Track and document the problem-solving process• Test fixes and perform post-resolution follow-ups to ensure problems have been adequately resolved• Maintain all new and existing software and applications• Post software updates, drivers, knowledge bases, and frequently asked questions resources on company intranet to assist in problem resolution• Create and deploy feedback mechanisms for end users. Analyze results, make recommendations for support process improvement, and implement changes• Evaluate documented resolutions and analyze trends for ways to prevent repeated future problems

Charlottetown, Pei

• Provide information technology services to specific business applications by applying investigative, analytical and design skills. Namely: Claims Processing System (CPS) Drug/Medicare/Dental – System Administrator – Platform: Oracle PL/SQL – Vendor: Deltaware  Provincial Safety Management System (PSMS), System Administrator – Platform: MS-SQL Server 2008 R2 – Vendor: RL Solutions WinRecs – Health Records – Platform: MS-SQL Server 2008 R2 – Vendor: Med2020  EMR (Icore) – Medical Practice Management – MS-SQL Server 7.0 – Vendor: Deltaware  Colorectal Cancer Screening(CCSP) – Platform: MySQL – ITSS  Adstra Management and Imaging – Dental – Platform: MS-SQL Server2008 Vendor: Adstra• Crystal Report Development and Editing (i.e. Department of Finance Reporting)• Develop complex data queries for system to system communication. Develop export, transform and load procedures (ETL).• Adhoc SQL Querying for Oracle and SQL Server Databases, troubleshoot code• Providing support to system users by identifying and troubleshooting system issues.• Understanding business rules and environment when defining and coding within Oracle databases• Working and liaising with business staff and vendors to ensure problems and issues are clearly communicated.• Participating in designing the development of application enhancements.• Producing technical and functional documentation for staff and users.• Reviewing, understanding, and supporting Government’s IT Business Plan recommendations.• Administer SQL Server and Oracle based Databases• Communicate and liaise between vendors and clients/end users• Software upgrade assistance and planning• Track defects of applications and ensure vendors are aware of software issues

Prince Edward Island, Canada

• Data Conversion Lead – Convert data to Customer Service Management (CSM). CSM is integrated with Microsoft GP 2010 ERP software and SQL Server 2008 R2. Utilize Microsoft Business Intelligence Platform; MS-SQL Server, Microsoft Sharepoint, and Office Suite Extensive SQL Programming, Reporting & Analysis Experience leading data conversion team Reconcile Financial Reports to Legacy System (i.e. Aged Trial Balance Report) SSRS Reporting Development and Support Administering SQL Server Databases via Citrix Virtual Environment Develop Crystal Reports• Evaluate Software, Hardware and Training Requirements• High attendance record• Required to have good organizational, analytical, problem solving, decision making and communication skills• Responsible for providing direction, advice and support to vendor staff on customized applications and also provide programming support where necessary• Monitoring and Supporting imported data to CSM• Scheduling and testing upgrades, patches and test plans• Develop data mapping documentation• Managing multiple tasks and projects simultaneously• Providing analysis, verification, modeling and methodology development for CSM• Overseeing design, development and implementation of applications for CSM• Provide systematic and consistent requirements specification in both technical and user friendly language• Provide status reports and milestone updates to Project Manager• Involved with 4 Go-Lives in 3 years• Legacy Systems Converted include Oracle Customer Care & Billing (CC&B)• Provide Documentation and Analysis reporting to Project Stakeholders• Training/Instructing Vendor Staff and QA Leads• Develop SSIS Import Packages for Data Import of Legacy Data• Microsoft Dynamics GP 2010 Smart list Reporting Development• Crystal Report Development and support• Experience with SQL Plus programming language• Functional Analysis of CSM Customization• Quality Assurance testing and support

Charlottetown, Pei

Victoria, Bc

Business Information Systems Development, It, Business Analyst

Political Studies And Public Administration, International Politics, Political Theory, University Bachelor'S Degree

Activities and Societies: Business Society

Administering Microsoft Sql Server 2012 Databases Course, Administering Microsoft Sql Server 2012 Databases Course

Train The Trainer, E-Health Specialist