Experience

St. George's School

• Canada
• Primary and Secondary Education
• 100 - 200 Employee

• Senior Applications Specialist

  • Feb 2013 - Present



Sophos

• United Kingdom
• Software Development
• 700 & Above Employee

• CRM Administrator/Data Analyst

  • 2003 - 2012

  Duties included: Data Migration • Extract/Transform/Load between many systems including; MS SQL Server, Lotus Notes, MS Excel, Pivotal CRM, Salesforce CRM, Big Machines • Staged migrations for global operations with 6 different regions on multiple different systems • Migration/Transformation of multiple acquired Companies from different systems • Developed and maintained MS SQL, Salesforce CRM, Pivotal CRM, Informatica, Demand Tools to support data structures and resources… Show more Duties included: Data Migration • Extract/Transform/Load between many systems including; MS SQL Server, Lotus Notes, MS Excel, Pivotal CRM, Salesforce CRM, Big Machines • Staged migrations for global operations with 6 different regions on multiple different systems • Migration/Transformation of multiple acquired Companies from different systems • Developed and maintained MS SQL, Salesforce CRM, Pivotal CRM, Informatica, Demand Tools to support data structures and resources needed for migration • Migrated 6 legacy systems and 2 acquired Companies into Pivotal, and Pivotal to Salesforce Requirements • Requirements gathering for migration/system enhancement/reporting needs: stakeholder meetings, source system passive data dictionary & business rules/workflow, destination system passive data dictionary & business rules/workflow, transformation rules/data quality rules, functional specification, UI mock-ups Data Maintenance/Quality • Developed and maintained MS SQL/Pivotal agents/Informatica agents/Demand Tools scenarios to support de-duplication and data quality initiatives for Salesforce CRM/Pivotal CRM/data migration • Designed and developed functionality to selectively apply Dunn & Bradstreet data to Pivotal CRM data • Analysed data patterns to determine what corrective actions should be developed both in existing systems and during data migration • Developed and applied de-duplication/merging processes CRM System Administration • Deployed and maintained 10 instance Pivotal CRM application server/MS SQL Server system serving 13 offices around the globe • Developed and maintained MS SQL/Pivotal agents to support system customization • Provided user support for Pivotal CRM BI/Reporting • Developed and maintained Crystal Reports for Pivotal CRM and Crystal Enterprise • Developed and maintained MS SQL for report consumption and data warehouses • Analysed data patterns to determine what reporting was available and how it could be improved Show less Duties included: Data Migration • Extract/Transform/Load between many systems including; MS SQL Server, Lotus Notes, MS Excel, Pivotal CRM, Salesforce CRM, Big Machines • Staged migrations for global operations with 6 different regions on multiple different systems • Migration/Transformation of multiple acquired Companies from different systems • Developed and maintained MS SQL, Salesforce CRM, Pivotal CRM, Informatica, Demand Tools to support data structures and resources… Show more Duties included: Data Migration • Extract/Transform/Load between many systems including; MS SQL Server, Lotus Notes, MS Excel, Pivotal CRM, Salesforce CRM, Big Machines • Staged migrations for global operations with 6 different regions on multiple different systems • Migration/Transformation of multiple acquired Companies from different systems • Developed and maintained MS SQL, Salesforce CRM, Pivotal CRM, Informatica, Demand Tools to support data structures and resources needed for migration • Migrated 6 legacy systems and 2 acquired Companies into Pivotal, and Pivotal to Salesforce Requirements • Requirements gathering for migration/system enhancement/reporting needs: stakeholder meetings, source system passive data dictionary & business rules/workflow, destination system passive data dictionary & business rules/workflow, transformation rules/data quality rules, functional specification, UI mock-ups Data Maintenance/Quality • Developed and maintained MS SQL/Pivotal agents/Informatica agents/Demand Tools scenarios to support de-duplication and data quality initiatives for Salesforce CRM/Pivotal CRM/data migration • Designed and developed functionality to selectively apply Dunn & Bradstreet data to Pivotal CRM data • Analysed data patterns to determine what corrective actions should be developed both in existing systems and during data migration • Developed and applied de-duplication/merging processes CRM System Administration • Deployed and maintained 10 instance Pivotal CRM application server/MS SQL Server system serving 13 offices around the globe • Developed and maintained MS SQL/Pivotal agents to support system customization • Provided user support for Pivotal CRM BI/Reporting • Developed and maintained Crystal Reports for Pivotal CRM and Crystal Enterprise • Developed and maintained MS SQL for report consumption and data warehouses • Analysed data patterns to determine what reporting was available and how it could be improved Show less



Microsoft

• United States
• Software Development
• 700 & Above Employee

• Contract Consultant

  • 2003 - 2003

  Upgrade Advisor for Visual Basic 6 to .NET. • Tested application and installation package. Upgrade Advisor for Visual Basic 6 to .NET. • Tested application and installation package.



eduVoice

• remote

• Contract Consultant

  • 2002 - 2002

  Data integration system for K-12 education administration. • Tested application and installation package. Data integration system for K-12 education administration. • Tested application and installation package.



Discovery Software/Eclipse Software

• Consultant

  • 1998 - 2002

  Crystal Reports Development • Developed and maintained Crystal Reports for Web delivery in ‘Process Web’ • Developed and maintained Crystal Reports for the Vancouver Port Authority and Stats Canada MS SQL Server Development • Developed and maintained stored procedures, views and tables to support ‘Process Web’ • Performed data cleansing maintenance tasks for the Vancouver Port Authority Senior Requirements Analyst Projects: Lucent Technologies ‘e-licensing’… Show more Crystal Reports Development • Developed and maintained Crystal Reports for Web delivery in ‘Process Web’ • Developed and maintained Crystal Reports for the Vancouver Port Authority and Stats Canada MS SQL Server Development • Developed and maintained stored procedures, views and tables to support ‘Process Web’ • Performed data cleansing maintenance tasks for the Vancouver Port Authority Senior Requirements Analyst Projects: Lucent Technologies ‘e-licensing’, eduVoice K-12 School Portal, CTB-McGraw Hill “Fox in a Box’, Triant Technologies ‘Data Archiving’, NCS-Pearson ‘TSS Texas PIEMS’. • Delivered Project Charters and Requirements as specified by the High Level Schedule • Worked closely with Client Representatives and Project and Account Managers • Defined the business and technical requirements for projects • Acted as a requirements advocate and expert throughout the project life cycle • Managed the requirements gathering process Software Testing • Test Lead/Tester for; NCS-Pearson ‘TSS (The School System)’, Lucent Technologies ‘e-licensing’, Vancouver Port Authority Y2K (used Rational Visual Test), Vancouver Port Authority ‘PortView’ Software Project Management Managed projects; Lucent Technologies ‘e-licensing’ and Vancouver Port Authority ‘PortView’ Show less Crystal Reports Development • Developed and maintained Crystal Reports for Web delivery in ‘Process Web’ • Developed and maintained Crystal Reports for the Vancouver Port Authority and Stats Canada MS SQL Server Development • Developed and maintained stored procedures, views and tables to support ‘Process Web’ • Performed data cleansing maintenance tasks for the Vancouver Port Authority Senior Requirements Analyst Projects: Lucent Technologies ‘e-licensing’… Show more Crystal Reports Development • Developed and maintained Crystal Reports for Web delivery in ‘Process Web’ • Developed and maintained Crystal Reports for the Vancouver Port Authority and Stats Canada MS SQL Server Development • Developed and maintained stored procedures, views and tables to support ‘Process Web’ • Performed data cleansing maintenance tasks for the Vancouver Port Authority Senior Requirements Analyst Projects: Lucent Technologies ‘e-licensing’, eduVoice K-12 School Portal, CTB-McGraw Hill “Fox in a Box’, Triant Technologies ‘Data Archiving’, NCS-Pearson ‘TSS Texas PIEMS’. • Delivered Project Charters and Requirements as specified by the High Level Schedule • Worked closely with Client Representatives and Project and Account Managers • Defined the business and technical requirements for projects • Acted as a requirements advocate and expert throughout the project life cycle • Managed the requirements gathering process Software Testing • Test Lead/Tester for; NCS-Pearson ‘TSS (The School System)’, Lucent Technologies ‘e-licensing’, Vancouver Port Authority Y2K (used Rational Visual Test), Vancouver Port Authority ‘PortView’ Software Project Management Managed projects; Lucent Technologies ‘e-licensing’ and Vancouver Port Authority ‘PortView’ Show less



Annex Pro

• Canada
• IT Services and IT Consulting
• 1 - 100 Employee

• Tech Support/Sales

  • 1993 - 1998

  Tech Support Representative • Performed MAC and PC configuration • Provided audio/video system support Purchaser / Sales Representative • Performed store purchasing for a multi-million dollar business from 1996 – 1997 • Pro Audio and Video specialist. Tech Support Representative • Performed MAC and PC configuration • Provided audio/video system support Purchaser / Sales Representative • Performed store purchasing for a multi-million dollar business from 1996 – 1997 • Pro Audio and Video specialist.