Combining
technology with business process improvement...
Contact Us:
Office Phone: (514) 907-3268
Email: info@snoot.net
Naviguer vers le site français
Previous Projects
Below is a chronological list of past projects/mandates undertaken by
Snoot Technologies Inc.
Project No: 106
Client: Diabsolut/Service America
Industry: Services
Project: Cloud and mobile enablement of ClickSoftware
(WFM)
Roles: Project Manager
Start
Date: 02-Mar-15 End Date: 24-Apr-15 Months: 2
Project Details:
Project Management services for upgrade of ClickScheduler,
migration to the Cloud environment and deployment of Click-mobile using JD Edwards
as backend ERP.
·
Elaboration
of project plan, resource management and tracking (financial, human and contractor)
·
Maintenance
of registers (risk, decision, issues, action items, etc.),
·
Member of
project leadership / executive steering committee influencing project direction
and execution.
·
Weekly
status reporting and communications to both groups (Overall Project Status
Achievements, Organizational Change Management,
·
Timeline,
Financials, Risks)
·
Coordination
of workshops and documentation of key decisions
Project Details:
·
Migrate
GIS solution from MapInfo to PTV for performance, quality, and enable the
Mapping component in ClickSchedule.
·
Upgrade
of existing 7.5.7 solution as baseline configuration to 8.3 for ClickSchedule Cloud (using AWS).
·
Addition
of Click Mobile to the solution enabling WFM functionality using tablets
·
Upgrade
of existing ClickSchedule interfaces that send
messages to and from JD Edwards.
·
Migration
of the existing system configuration, Technician & Task data.
·
Configuration
of object schema.
·
Addition
of nes status and configuration of standard work
status flow.
·
Integration
with SoundByte web services for client notifications
·
Deploy
Pilot (20-30) followed by general roll out to entire workforce (around 250)
Technologies:
Identity Management
and User Security, Mobile Enablement, WebServices, ClickSoftware, Cloud-Enamblement,
Click Upgrade, JD Edwards, JDE-CRM
Project
No: 105
Client: STI
Industry: Professional Services
Project: Major upgrade of Microsoft corporate mission critical
software
Roles: Project Manager, Solution Architect, Team Lead
Start
Date: 01-Nov-14 End Date: 28-Feb-15 Months: 4
Project
Details:
·
Elaborating
the project plan and rollout / deployment strategy for upgrade of Microsoft
Enterprise solutions:
·
Upgrading
4 installations of SQL Server from 2000, 2005, 2008, 2012 to 2014
·
Upgrade
of Small Business Server from 2003 to 2011
·
Upgrade
of SharePoint Server from 2007 to 2013
·
Upgrade
Microsoft Exchange Server from 2003 to 2013
·
Upgrade
of Lync Server from 2003 to 2013
·
Installation
and configuration of Microsoft Dynamics Great Plains 2013
·
Installation
and configuration of MS Dynamics CRM Workgroup Server 2011
·
Installation
and deployment of MS Dynamics CRM Workgroup 2013
Technologies:
MS-SharePoint,
MS-Office, MS-SQL Server, MS-Dynamics GP, MS-Dynamics CRM, MS-Exchange Server, MS-Lync
Server
Project No: 104
Client: STI
Industry: Professional Services
Project: Server Migration - Virtualization
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Apr-14 End Date: 31-Oct-14 Months: 7
Project
Details:
Migration of 4 physical servers to a virtual environment. Elaboration of
requirements specifications and configuration required for ensuring high
availability and business continuity of mission critical servers from a
physical to a virtual environment (Microsoft Hyper-V).
Technologies:
Hyper-V, Virtualization, Windows Servers, Infrastructure Review, Networks
Project
No: 103
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Knowledge Transfer for Support of Warehouse Solutions
by HP
Roles: Pedagogical Consultant, Technical Analyst, Functional
Analyst, Solution Architect, Strategic Analyst, Team
Lead
Start
Date: 04-Nov-13 End Date: 17-Jan-14 Months: 3
Project
Details:
Knowledge transfer and documentation of global SAP
warehouse management solution for transition of ongoing support to outsourcing
firm.
Among the various solutions we find documentation and
knowledge transfer of:
SAP WMS (SAP GUI including SSO),
SAP WMS Wireless (RF) on multiple devices (both
vehicle mounted computers and hand-held barcode scanning devices) and
technologies
(SAP Console, use of SAP-GUI in wireless shop floor
infrastructure, and SAP GUIXT scripting),
Mobile device baseline image maintenance
(documentation and multimedia step-by-step illustration of modifications,
deployment and testing),
WMS Contingency Solution (stand-alone solution for
business continuity in disconnected state)
Shockwatch (fork lift impact monitoring solution) used
in both wireless (RF) and disconnected states.
Ensure sufficient knowledge transfer and documentation
exists to not only allow for end-to-end support by HP, but also prepare for
business and technological evolution such as server virtualization and
re-purposing, domain name migrations, upgrade and replacement of
front-end data capture equipment (vehicle mounted and hand-held units) that have
reached end-of-life support.
The knowledge transfer deliverables consisted of:
PowerPoint presentations,
Technical documents,
Step-by-step user guides,
Diagnostic
scripts,
Multi-media demonstrations,
On-site
training
Mentoring of SMEs and technical experts.
Technologies:
Shockwatch, MS-Office, X Modular, VMU (Vehicle Mounted
Computers), SAP-WMS, SAP-Console, Mobile
Enablement, Middleware solution
Budget: $75,000.00
Mandate No: 102
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Knowledge Transfer for Support of Warehouse Solutions by
HP
Roles: Pedagogical Consultant, Technical Analyst, Functional
Analyst, Solution Architect, Team Lead
Start
Date: 04-Nov-13 End Date: 17-Jan-14 Months: 3
Project
Details:
Knowledge transfer and documentation of global SAP
warehouse management solution for transition of
ongoing support to outsourcing firm.
Among the various solutions we find documentation and
knowledge transfer of:
SAP WMS (SAP GUI including SSO),
SAP WMS Wireless (RF) on multiple devices (both vehicle
mounted computers and hand-held barcode
scanning devices) and technologies (SAP Console, use of
SAP-GUI in wireless shop floor infrastructure,
and SAP GUIXT scripting),
Mobile device baseline image maintenance
(documentation and multimedia step-by-step illustration of
modifications, deployment and testing),
WMS Contingency Solution (stand-alone solution for
business continuity in disconnected state)
Shockwatch (fork lift impact monitoring solution) used
in both wireless (RF) and disconnected states.
Ensure sufficient knowledge transfer and documentation
exists to not only allow for end-to-end support by
HP, but also prepare for business and technological
evolution such as server virtualization and re-
purposing, domain name migrations, upgrade and replacement of
front-end data capture equipment
(vehicle mounted and
hand-held units) that have reached end-of-life support.
The knowledge transfer deliverables consisted of:
PowerPoint presentations,
Technical documents,
Step-by-step user guides,
Diagnostic scripts,
Multi-media demonstrations,
On-site training
Mentoring of SMEs and technical experts.
Technologies:
Shockwatch, MS-Office, X Modular, VMU (Vehicle Mounted
Computers), SAP-WMS, SAP-Console, Mobile
Enablement, Middleware solution
Mandate
No: 101
Client: Canadian National Railways (CN)
Industry: Transportation
Project: SAP-MDM (Master Data Management) & SRM (Supplier
Relationship Management)
Roles: Functional Analyst
Start
Date: 01-Sep-13 End Date: 30-Nov-13 Months: 3
Project
Details:
Functional designer for implementation of SAP-Supplier
Relationship Management (SRM) MDM Product
Catalogue solution (as detailed in previous Project
Management mandate).
Coordination of efforts related to needs assessment
and blueprinting for the replacement of legacy vendor-
catalogue solutions (Requisite's eMerge
and BugsEye) with SAP Master Data Management –
Product
Catalogue. (presentations,
meeting coordination, needs assessment, documentation and confirmations,
and business sign off)
Gathering functional requirements from business unit
Conversion of business requirements into functional
design specifications
Identification of data sources, targets, required
conversions and data massaging for consolidation of
vendor product
and service catalogues
Technologies:
SAP-SRM, SAP-MM, ETL / Change Data Capture / Data
Replication, SAP-BW, SAP-SCM, SAP-Basis,
SAP-SD, SAP-MDM, Data Conversion and Integration
Mandate
No: 100
Client: Canadian National Railways (CN)
Industry: Transportation
Project: SAP-MDM (Master Data Management) & SRM (Supplier
Relationship Management)
Roles: Project Manager, Functional Analyst
Start
Date: 01-May-13 End Date: 30-Aug-13 Months: 4
Project
Details:
Project Manager (with secondary roles as Solution
Architect, Functional Analyst and Solution Designer) for
an SAP-Supplier Relationship Management (SRM) solution.
Responsible for coordinating efforts for the
replacement of legacy vendor-catalogue solutions (Requisite's eMerge and BugsEye) with SAP
Master
Data Management – Product Catalogue. The core project
team consists of a dozen resources including
skill sets such as:
• Architecture,
• Development,
• Functional Analysts,
• SAP Basis,
• Quality Control
• Testing,
• Change Management
• Business Representatives.
Assumed the full range of project management service
delivery (beginning with assessment and planning),
the mandate consisted of delivering:
• Replacement for a legacy vendor catalogue solution
with SAP's SRM-MDM Product Catalogue solution
Upgrade of current SRM implementation (as Phase II)
• Timely upgrade of MDM Product Catalogue
implementation to align the upcoming implementation with the
SAP roadmap (and maintenance plan) with the current
SAP component versions found throughout the SAP
landscape
• Import of numerous vendor product catalogues
(including vendor-specific data conversion) into one
consolidated MDM product catalogue for ESS through SRM
Technologies:
SAP-SRM, SAP-MM, ETL / Change Data Capture / Data
Replication, SAP-BW, SAP-SCM, SAP-Basis,
SAP-SD, SAP-MDM, Data Conversion and Integration
Mandate
No: 99
Client: Bell Canada
Industry: Telecommunications
Project: SAP Project System (PS) Archiving and Data Volume
Management Review
Roles: Technical Analyst, Functional Analyst, Strategic
Analyst
Start Date: 01-Feb-13 End Date: 30-Apr-13 Months: 3
Project
Details:
• Review the SAP Project System (SAP-PS) archive
objects and the relevant tables/data being archived
• Review/validate SAP-PS Module configuration with PS
Analysts
• Review SAP-PS Archiving objects (including customer
ABAP programs for archiving Z* tables) and make
performance improvement recommendations
Technologies:
SAP-Archiving, SAP-PS
Mandate
No: 98
Client: Florida Crystals
Industry: Food & Beverage
Project: SAP WMS Project Plan Review / Evaluation
Roles: Technical Analyst, Project Manager, Functional
Analyst, Strategic Analyst
Start
Date: 01-Oct-12 End Date: 30-Nov-12 Months: 2
Project
Details:
• Review and update of SAP-WMS project plan for
multi-site roll out (9 sites throughout US and Canada)
including:
• Review and validation / adjustment of project plans
and tasks (individual and rollups), precursors and
milestones.
• Coordination and alignment of project tasks (WBS) to
meet project milestones and timelines for multi-year
roll-out.
• Provide functional & technical advice for WMS
end-to-end project delivery (including development,
deployment, roll out, and cutover plan).
• Unbiased, independent assessment and validation of
project plan resources (human, time and financial)
for SAP-WMS rollout throughout North America.
Technologies:
SAP-MM, MS-Office, Network (wired/wireless/security/firewall),
X Modular, VMU (Vehicle Mounted
Computers), SAP-WMS, SAP-SD, SAP-QM, SAP-HR, Mobile
Enablement
Mandate
No: 97
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: BASC CASRA Audit Billing Upon Departure
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
• Solution architecture and infrastructure review required
to ensure material and equipment assigned to
employees for performance of their duties is return upon
completion of their duties.
• The loaned resources must be returned or employees
to be billed for them.
• Through a total of 8 solution enhancements
(initially believed to require changes in material equipment
configuration) the project provided the following benefits by
altering ABAP code only:
• Improved internal customer experience
• Decrease cost to re-enter previous modifications
(minimizing redundant tasks)
• Increased cash flow, faster billing & revenue
recognition.
• Progressive Billing Capability.
• Reduced FINAL billing delays (less data to manage)
• Increased Customer Satisfaction
Technologies:
SAP-Solution Manager, SAP-SRM, SAP-MM, SAP-SD
Mandate
No: 96
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: RFC Impact Assessment for SAP-Optegra
Order Status Interface
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
Impact assessment and evaluation of various
technologies for interfacing Optegra order status
information
with SAP
Technologies:
SAP-Solution Manager, SAP-Interface Development, X Modular,
SAP-SD, SAP-PI / XI, WebServices
Mandate
No: 95
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: MCC 3PL Petsche Solution for
Kit Purchase
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
• 14 requirements were identified in the Business
Requirements Document.
• They all pertained to reporting, invoicing, and/or
receiving requirements and were implemented through
various ABAP or business process changes (including multiple
bidirectional interfaces / file extractions and
function module modifications).
• Solution Manager used as monitoring tool:
• to maintain solution and
landscape documentation
• to review system
performance, and establish a proactive approach to issue resolution through
trend
identification
• to monitor through Early
Watch reports
Technologies:
SAP-Solution Manager, SAP-MM, X Modular, SAP-SD
Mandate
No: 94
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: Deutsche Bank Reverse Factoring
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project Details:
Technologies:
SAP-Solution Manager, X Modular, SAP-SD, SAP-PI / XI
Mandate
No: 93
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: Implementation of SAP finance modules for China
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
Design of architecture and infrastructure (and system
builds) required for implementation of SAP financial
components (FI-CO) in China. A particular challenge was printing
SAP Script reports in classical Chinese
(Centalized vs local
printing, fonts, etc).
Technologies:
SAP-Solution Manager, SAP-Basis, SAP-Patches, SAP-HCM,
SAP-HR, SAP-FI
Mandate
No: 92
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: SAP Netweaver Portal Stress
Testing: P6 Modsum Change Request
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
Evaluation of system robustness and performance metrics
through end user access of SAP Netweaver
Portal.
Specific transactions were executed followed by review
and analysis of pertinent log files and Solution
Manager as monitoring tool:
Use of Solution Manager to maintain solution and landscape
documentation
System performance review, and proactive approach to
issue resolution through trend identification
Monitoring through Early Watch report
Technologies:
SAP-Netweaver, SAP-Solution
Manager
Mandate
No: 91
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: ITIM (Tivoli Identity Manager) SAP Adapter Upgrade
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
This project consisted of generating the technical
documentation for approval and upgrading the Tivoli
Identity Manager Connector for SAP and configuring a
new enhancements delivered as a result of the
upgrade. The upgrade was purely technical in nature since it
built on an existing infrastructure.
Coordinating efforts within and between projects to
ensure minimal disruption to ongoing operations was
Technologies:
SAP-Solution Manager, Identity Management and User
Security, X Modular
Mandate
No: 90
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: SAP BW Upgrade Assessment
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
Assessment of cost, effort impacts and benefits of
upgrading SAP BW to version 7.3
Technologies:
SAP-Solution Manager, SAP-BW, X Modular
Mandate
No: 89
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: [M]Plan Drop 3 – Multiple
Drop Shipments
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
• Review and update of Stage Gate 0 solution
architecture design documentation and estimates
• Elaboration of technical and architecture
recommendations for reducing costs, improving performance
and re-alignment with enterprise architecture vision
• Use of Solution Manager to explore and maintain
current solution and landscape documentation
Technologies:
SAP-Solution
Manager, SAP-MM, SAP-SD
Mandate
No: 88
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: BAS Billing Audit (CASRA) - On Line SQK Approval
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
• Establish the billing scope and strategy for
implementing user volume additions and associated
chargebacks
• Solution architecture documentation of the proposed
approach,
• Presentation of recommendations to the relevant
stakeholders with a view to obtaining sign-off,
• Generation the functional and technical details of
the solution.
Technologies:
SAP-Solution Manager, SAP-MM, SAP-SD, SAP-HR
Mandate
No: 87
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: US Payroll Server Migration
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
Reality-Check/Review of Stage Gate 3 architecture
documentation to ensure the solution design aligns well
with the final version of the project deliverables and all
the business as well as technical requirements
have been met.
• Overall solution review
• Validation of
data mapping and flow (for example, employees are assigned material and
equipment for
performance of their duties)
• Validation of data and process integration points
(including banking interfaces
• Review, validate and ensure adherence to data
governance, management and policies
• Sign-off on technical components of testing criteria
• Review, validation and enhancement of bank
interfaces aligning them with current technology roadmap
and enterprise architecture vision
• Review and validation of high availability strategy
(clustering, failover, disaster recovery procedures).
Technologies:
SAP-Solution Manager, SAP-HCM, SAP-HR, SAP-FI
Mandate
No: 86
Client: Bombardier Aerospace
Industry: Space and Aerospace
Project: SAP Payroll Solution Replacement for US (Wichita)
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Aug-12 End Date: 31-Oct-12 Months: 3
Project
Details:
•Reality check/review to ensure the solution design aligns
well with the final version of the project
deliverables and all the business as well as technical
requirements have been met.
• Overall solution review
• Validation of data mapping and flow (for example, employees
are assigned material and equipment for
performance of their duties)
• Validation of data and process integration points
• Review, validate and ensure adherence to data
governance, management and policies
• Sign-off on technical components of testing criteria
• Review and validation of high availability strategy
(clustering, failover, disaster recovery procedure)
Technologies:
SAP-Solution Manager, SAP-HCM, SAP-HR, SAP-FI
Mandate
No: 85
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: digiTRACC Upgrade (Continuous Improvement)
Roles: Technical Analyst, Project Manager, Solution Architect
Start
Date: 01-May-12 End Date: 20-Aug-12 Months: 4
Project
Details:
• Liaise and oversee delivery of a third party
solution upgrade: digiTRACC (a continuous improvement
management system that enables organizations to implement best
practices in operations across multiple
operating units and sites).
• Elaboration of complete project plan
• Resource (internal, external, partner) management
and oversight,
• Elaboration and validation of solution technical and
architecture design
• Management / coordination of project delivery phase
Technologies:
MS-Office, MS-SQL Server, SQL / PL-SQL / Transact-SQL
Mandate
No: 84
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: WCS-SAP Interface for Handling Units
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-May-12 End Date: 31-Aug-12 Months: 4
Project
Details:
• Implementation of SAP-PI as interface technology for
unidirectional transfer of HU data from WCS (SQL
Server 2008 shop floor system) to SAP.
• Needs assessment (business and non-functional
requirements)
•
Identification of data integration points
• Identify gaps
and recommend alternatives for addressing them (business process, functional or
technical)
• Identification and documentation of source and
target data (between SAP and WCS), including required
conversions and modifications (data massaging)
• Design and validate data flow and data quality
• Document functional requirements (data sources, data
transfer frequencies, error handling)
• Document technical requirements (SAP-PI adapters,
conversions, and integration technologies,
architecture frameworks)
Technologies:
SAP-Solution Manager, ETL / Change Data Capture / Data
Replication, MS-SQL Server, Network
(wired/wireless/security/firewall), SQL / PL-SQL /
Transact-SQL, SAP-WMS, SAP-PI / XI, WebServices,
DBA and Data Modelling, Middleware solution, Data
Conversion and Integration
Mandate No: 83
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: PAM (Pallet Makeup) Interface
Roles: Pedagogical Consultant, Solution Architect, Team Lead
Start
Date: 01-May-12 End Date: 20-Aug-12 Months: 4
Project
Details:
Development of infrastructure to support interface for
exchanging information between SAP and PAM
(Shop Floor Pallet Make-up Solution).
Identify functional and technical requirements for
implementing SAP-PI as interface between SAP and PAM
Implementation and configuration of SAP-PI,
connectors/adapters, and error-handling.
Knowledge transfer to outsourcing support team and
SMEs.
Perform and document needs assessment
Analyze and compare requirements with SAP standard
functionality
Design and validate business process flow • Identify source
and target data, conversions / modifications
(data massaging) required
Design and validate data flow
Document functional requirements (data sources,
conversions, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
Elaborate connectivity protocols and specifications
for creation of web service
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Presentation to stakeholders, and project team
Technologies:
SAP-Interface Development, SAP-MM, MS-SQL Server,
Identity Management and User Security, X
Modular, SAP-WMS, SAP-PI / XI, WebServices,
Infrastructure review / enhancement, DBA and Data
Modelling, Middleware solution, Data Conversion and
Integration
Mandate
No: 82
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Warehouse Management System (WMS) Vehicle Mounted Unit
(VMU) Baseline Image Upgrade
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-May-12 End Date: 20-Aug-12 Months: 4
Project
Details:
Subsequent to Montreal's WMS Go-Live, changes had been
identified that required adjustments to the
baseline image for CV60 Vehicle Mounted Units (VMUs). While
some of the changes had been made
(though not deployed at
Go-Live), others were still pending and to be incorporated to a refreshed
baseline
image scheduled for deployment in spring of 2010.
A similar situation existed in Toronto. In the hope of
standardizing (where possible) and eliminating task
and cost duplication, the VMU Baseline Image Refresh was
extended to include one standard image for
both Montreal and Toronto, and all devices (Intermec
CV30s, CV60s, and Symbol MC9090s) as well as
their permutations of operating systems (Windows XP
Embedded, Mobile 5, and CE). This entailed the
following:
Perform needs assessment
Generation of business requirements documents
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
Design and validate business process flow
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Technologies:
Shockwatch, SAP-MM, MS-SQL Server, DotNet,
VMU (Vehicle Mounted Computers), SAP-WMS, Mobile
Enablement, Infrastructure review / enhancement, DBA
and Data Modelling
Mandate
No: 81
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Controller-Based Access Points (Implementation for
WMS)
Roles: Technical Analyst, Solution Architect
Start
Date: 01-May-12 End Date: 20-Aug-12 Months: 4
Project
Details:
Migration of stand-alone APs to Controller-based to
improve wireless network performance when fork-lift
mounted computers transition (roam) from one AP range to
another.
Technologies:
Network (wired/wireless/security/firewall), Identity
Management and User Security, Mobile Enablement
Mandate
No: 80
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Single Sign On (SSO)
Roles: Technical Analyst, Solution Architect
Start
Date: 01-Apr-12 End Date: 20-Aug-12 Months: 5
Project
Details:
Implementation of SSO for SAP at a national level
Identify modification requirements for the various
system configurations to enable single sign on
Implementation of file replication to deploy/propagate
updates when devices and workstations are
connected to the network
Adopting a uniform approach to managing the new
SAPLogon.ini files as well as local modifications (such
as shortcuts) that are maintained locally (even
subsequent to file replication).
Plan and execute national roll out (Canada) for all
workstations, and as pilot project for vehicle mounted
devices as part of the WMS@CDM project
Technologies:
Identity Management and User Security, X Modular,
Mobile Enablement, Infrastructure review /
enhancement, Middleware solution, SAP-SSO
Mandate
No: 79
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Delivery Planning/Optimization System
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-Mar-12 End Date: 20-Aug-12 Months: 6
Project
Details:
The solution is a SAP embedded/Rapid Deployment one
consisting of vendor-specific, Badis, RFCs and
BAPIs that interact with various middleware
optimization servers to yield results via ActiveX components that
are embedded directly in the SAP GUI screens. Responsible for architecture / solution
design and
implementation of a Delivery Planning/Optimization System to improve
the logistics components of the
supply chain. Implementation of third party (Ortec) bolt-on solution for optimization of pallet, truck
loading
and delivery route selection. • Review of business and functional
requirements documents • Elaboration of
infrastructure and architecture requirements • Generation of
solution architecture specifications for 4
technology verticals: o Presentation Layer (deployment of SAP
front-end OCX components) o VMWare
Virtual machines running optimization services (9
Windows 2008 virtual servers) o SQL
Server clustered
servers (2 physical SQL Server 2008 R2 servers) o SAP Basis (Transports for new namespace)
Technologies:
SAP-ABAP, SAP-Solution Manager, SAP-Interface
Development, SAP-MM, SAP-APO, MS-SQL Server,
Mandate
No: 78
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: MiniSAP Project
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect
Start
Date: 01-Mar-12 End Date: 20-Aug-12 Months: 6
Project
Details:
•Setting foundation and performing basic groundwork to
migrate the MS-Access based equipment
management solution to SAP-PM.
Project scoping • Identification and documentation of
current business processes (use case and story
boarding)
Mapping current processes to SAP standard
functionality
Identification and documentation of gaps (gap-fit
analysis)
Identification of alternatives / proposals for
addressing them
Data mapping and identification (high level) of the
extent of conversion/data-massaging, and possible
alternate data sources required to ensure conformity to single
source of truth, data governance and data
quality
Solution design and architecture documentation
Evaluate, document and demonstrate data and process
flows
Identification of integration points (both process and
data)
Identification of and documentation of solution
interfaces required
Establishing test scenarios end end-user acceptance
criteria
Technologies:
SAP-TMS-Delivery Planning Optimization, ETL / Change
Data Capture / Data Replication, MS-SQL Server,
Network
(wired/wireless/security/firewall), Identity Management and User Security, X
Modular, SAP-SD,
SAP-HR, Infrastructure review / enhancement, DBA and
Data Modelling, Middleware solution, Data
Conversion and Integration
Mandate
No: 77
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Vehicle Mounted Unit Replacement for Opus (UK WMS
Solution)
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Strategic Analyst
Start
Date: 01-Feb-12 End Date: 20-May-12 Months: 4
Project
Details:
Evaluation of various vehicle mounted computers (VMUs)
for WMS shop floor viability as well as gap-fit
analysis
Support to business partner for building the business
case leading to the selection of LXE-Thor as the
device best suited to replace the current front end
(Motorola VC 5090).
Alignment of hardware/software with enterprise
architecture roadmap
Accommodating the current technological requirements
Assuring re-use of development and technology with
SAP-WMS (gradual roll out in accordance with device
life-cycle)
Alignment with global architecture strategies while
considering localization-specific business requirements
Technologies:
SAP-MM, VMU (Vehicle Mounted Computers), SAP-WMS,
Mobile Enablement, Infrastructure review /
enhancement
Mandate
No: 76
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Implementation of new warehouse (McLaughlin)
Roles: Technical Analyst, Project Manager, Solution Architect
Start
Date: 01-Jan-12 End Date: 20-Jun-12 Months: 6
Project
Details:
Implementation of warehouse infrastructure necessary
for extending existing SAP-WMS solution for
performance of WMS tasks wirelessly in a newly rented empty
warehouse.
Coordinate with facilities management and the business
for ideal storage layout,
Supervise execution of wireless site survey,
Determine requirements (cabling, routers, switches,
APs, etc.)
Elaborate RFPs and coordinate with suppliers for
high-level estimates.
Elaborate technical project plan (with dependencies
and milestones) for inclusion with the main project
plan.
Generation of Solution Architecture Design Documents
as well as technical (non-functional) requirements
such as security (access and roles), high availability
requirements, business continuity and disaster
recovery strategies
Technologies:
SAP-Solution Manager, SAP-Interface Development,
SAP-MM, Network (wired/wireless/security/firewall),
Identity Management and User Security, X Modular, VMU
(Vehicle Mounted Computers), SAP-WMS, SAP-
SD, SAP-PP, Mobile Enablement, Infrastructure review /
enhancement, Middleware solution
Mandate
No: 75
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: WMS Implementation - New Distribution Centre
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Strategic Analyst, Business Analyst
Start
Date: 01-Jan-12 End Date: 20-May-12 Months: 5
Project
Details:
Responsible for designing the infrastructure and
architecture that will support wireless shop floor
processes. Assuming a
role of functional/technical team lead overseeing the implementation of SAP-WMS
for the Molson Canada Distribution Centre in Montreal. Complete functional and
technical/architecture
solution review/development for implementing SAP-WMS via a
wireless network using lift vehicle mounted
units. Evaluating
new technologies and hardware (since the previous implementation at the Toronto
Warehouse)
Evaluating and leveraging the benefits vs. drawbacks of selecting new
hardware/OS
combinations that have evolved beyond the baseline software
currently used for equipment soon be
declared End-Of-Life by the manufacturer.
Technologies:
SAP-Solution Manager, SAP-MM, Network
(wired/wireless/security/firewall), Identity Management and User
Security, VMU (Vehicle Mounted Computers), SAP-WMS,
Mobile Enablement, Infrastructure review /
enhancement
Mandate
No: 74
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Archiving – Molson
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-Dec-11 End Date: 20-Aug-12 Months: 9
Project
Details:
My role was that of Technical Team Lead, Solution
Design Architect and Functional Analyst overseeing the
implementation and roll out of technical components for SAP
Archiving in SAP R/3 4.6C. Archiving
objects
and retention periods were identified as a result of
several consultation meetings with the business, and
archiving (as well as house-keeping cleanup) programs were
scheduled with appropriate variants.
OpenText iXOS was used to manage
archive files generated from SAP and move them from SAP NFS to a
Centera content server storage solution which replicates to a
second Centera box (located in different
datacenter). HTTP/RFC
connections between SAP R/3 and iXOS servers were implemented SAP
Archiving Development Kit (ADK) Bradmark's
solution was implemented for table and index re-organization
with zero downtime
Technologies:
SAP-Solution Manager, Identity Management and User
Security, X Modular, Infrastructure review /
enhancement
Mandate
No: 73
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Real-Time Advance Shipping Notifications (ASN) from The Beer Store (TBS)
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Strategic Analyst, Business Analyst
Start
Date: 01-Nov-11 End Date: 27-Jul-12 Months: 9
Project
Details:
TBS currently sends Advance Shipping Notifications
(ASN) as one file to MCBC and Labatt on a daily basis.
The business felt
a considerable portion of the data is received well after the fact and
expressed an
interest in obtaining the ASN information for return of
empties more frequently – real time (defined as every
15 min). With the new ASN solution, a maximum of 1760
file sets could be transmitted to MCBC (and
Labatt) on an hourly basis representing a potential of
14080 file sets (header-detail) over any given 8 hour
period. Implementing this solution consisted of: • Clearly identifying the scope and extent of business
requirements (processes, data mapping, conversions, etc.) •
Translating that into functional specifications
(SAP transactions, data mining and mapping,
transmission frequency, etc.) • Elaborating the data/process
Technologies:
SAP-Solution Manager, SAP-Interface Development, EDI,
SAP-MM, ETL / Change Data Capture / Data
Replication, Identity Management and User Security, X
Modular, SAP-WMS, SAP-IS-Bev, WebServices,
Infrastructure review / enhancement, Middleware solution,
Data Conversion and Integration
Mandate
No: 72
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Bank of Montreal (BMO) EDI Interface
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Business Analyst
Start
Date: 01-Nov-11 End Date: 31-Mar-12 Months: 5
Project
Details:
Project to implement EDI interface solution for
payment settlements and electronic funds transfer (including
EDI message types
820 and 320) between MolsonCoors and Bank of Montreal
(BMO). Among the various
tasks performed we find:
Generation of business requirements
Functional and technical specifications
Review and validation of required message types and
fields
Documentation of data mapping and conversions required
Stakeholder signoff
Solution architecture design documentation
Coordination with VAN (Alligacom)
and business partner (BMO) to implement the solution successfully
using technologies such as EDI, SAP-Idocs,
Alligacom NetTransfer /
AS2, and UC4
Technologies:
EDI, ETL / Change Data Capture / Data Replication, X
Modular, UC4, DBA and Data Modelling, Middleware
solution, Data Conversion and Integration
Mandate
No: 71
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Console Server Refresh – MolsonCoors
(Canada and US)
Roles: Technical Analyst, Project Manager, Solution
Architect, Team Lead
Start
Date: 01-Aug-11 End Date: 20-Nov-11 Months: 4
Project
Details:
As a result of the server refresh project, the
middleware servers allowing SAP shop floor transactions to
run
via SAP Console were
replaced. The impact was enterprise-wide, and affected connectivity issues for
WMS installations in Millers, Coors, and Molson
throughout North America.
The variations in Vehicle-Mounted Units or VMUs
(hardware, OS, Telnet client versions, etc.) and Servers
(Telnet servers, SAP Console version compatibility,
virtual and actual names, etc.) significantly
increased
the testing complexity.
My role in this project was to design the role out
strategy that would assure minimal impact to the business
of all three organizations throughout North America.
This consisted of:
Technologies:
SAP-Solution Manager, SAP-MM, SAP-WMS, SAP-Console,
Mobile Enablement, Infrastructure review /
enhancement, Middleware solution
Mandate
No: 70
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Vehicle Mounted Unit (CV60) Baseline Image Refresh
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Strategic Analyst, Team Lead
Start
Date: 01-Aug-11 End Date: 20-May-12 Months: 10
Project
Details:
To improve security and better align shop floor
systems with corporate standards and
consolidate/standardize process flow and business functionality, the baseline
image for CV60 devices was
re-visited in the context of the WMS@CDM project.
The baseline image was revamped taking into account
new and evolved business functionality including
added benefits such as
• Upgrading the SAP GUI to 7.2 patch level 4
(rendering it at par with corporate desktop solutions),
• Simplifying the Contingency solution code
maintenance, and expanding the scope to include both
Montreal and Toronto in once solution code base,
• Implementing SAP Single Sign On
(SSO) for VMUs on a global scale),
• Simplifying the maintenance of the ever evolving SAP
Logon.ini,
• Moving away from the generic user ID and forcing
each user to authenticate him/herself to the network
(allowing security concerns
to be addressed at the AD level – rather than the device level while).
Almost $100K of previously committed funds for this
exercise was returned to the project fund by adopting
and implementing the recommended approach.
This entailed the following:
• Perform needs assessment
• Generation of business requirements documents
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
• Design and validate business process flow
• Identify source and target data, modifications (data
massaging) required
• Design and validate data flow
• Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
• Validate and adjust scope
• Document technical (non-functional) requirements
such as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
• Presentation to stakeholders, and project team
Technologies:
Shockwatch, Network
(wired/wireless/security/firewall), VMU (Vehicle Mounted Computers), SAP-WMS,
SAP-Console,
Mobile Enablement, SAP-SSO
Mandate
No: 69
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Test Data Migration Server (TDMS)
Roles: Pedagogical Consultant, Technical Analyst, Functional
Analyst, Solution Architect, Strategic Analyst
Start
Date: 01-Jul-11 End Date: 20-Sep-11 Months: 3
Project
Details:
This activity consisted of evaluating, investigating
and documenting the benefits of SAP's Test Data
Migration Server as a sustainable alternative for
streamlining the testing of new development and solutions.
Among the
obvious benefits and advantages one finds:
• Potential recuperation of disk space,
• Speedy setup and reuse of test environments,
• Accelerating the testing phase of all SAP projects.
Subsequent to a fact-finding and discovery phase, a
formal feasibility analysis and cost analysis / benefits
report was generated and presentations (tailored to each
audience) were delivered:
• Stakeholders,
• CXO,
• Global Architecture Review Board,
• SAP CoE,
• Business Community
Technologies:
ETL / Change Data Capture / Data Replication, Network
(wired/wireless/security/firewall), X Modular,
Mandate
No: 68
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Root Certificate Upgrade (to 2048)
Roles: Technical Analyst, Project Manager, Solution
Architect, Team Lead
Start
Date: 01-Jul-11 End Date: 20-Dec-11 Months: 6
Project
Details:
Move of fork-lift vehicle mounted computers used for
WMS to a more secure connection strategy by using
security certificates. This required implementation and roll
out of (and upgrading of) security certificates for
all mobile devices used in WMS: Intermec CV30, CV60, Symbol
MC9090 at 2 Montreal sites (brewery and
distribution center) and the Toronto Brewery.
Elaboration of project plan identifying
tasks/resources required as well as dependencies, milestones and
partner / supplier resources required.
Modification of baseline image for each device type
and OS combination to use certificates, remote re-
deployment, end-user testing, and documenting the solution for
ongoing support/maintenance
Technologies:
Identity Management and User Security, Infrastructure
review / enhancement, Middleware solution
Mandate
No: 67
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: APO-Ryder Transportation Optimization
Roles: Pedagogical Consultant, Solution Developer, Technical
Analyst, Functional Analyst, Solution Architect,
Strategic Analyst
Start Date: 01-May-11 End Date: 31-Oct-11 Months: 6
Project
Details:
Delivery of FTP-based interface for improving the optimization
and planning strategy for deliveries. This
consisted of:
Validating the business documents against functional
design specifications
Elaboration of architecture and infrastructure
modifications upon which the solution rests
Identification design and documentation of the various
solution components and how they inter-relate
(sFTP,
UC4, Security, etc.)
Designing UAT and supporting users for
testing/sign-off,
Documentation (technical, troubleshooting,
architecture)
Technologies:
EDI, SAP-MM, ETL / Change Data Capture / Data
Replication, X Modular, SAP-SD, Material Requirements
Optimization MRO, SAP-IS-Bev
Mandate
No: 66
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Grandville Island Brewing Co. (Acquisition by MCBC -
Data Integration with MCBC)
Roles: Technical Analyst, Project Manager, Solution
Architect, Strategic Analyst
Start
Date: 01-May-11 End Date: 20-Aug-11 Months: 4
Project
Details:
Architecture and infrastructure integration of newly
acquired brewing company (Grandville Island Brewing
Co) to the MCBC family.
Validate existing GIBCo
infrastructure and architecture,
Align technologies with MCBC Enterprise Architecture
vision,
Identify options for re-use of existing MCBC
technologies and resources to house new company
requirements,
Consolidate resources / re-align future short-term
projects to accommodate both MCBC and GIBCo
requirements.
Technologies:
Identity Management and User Security, X Modular, VMU
(Vehicle Mounted Computers), SAP-WMS, SAP-
IS-Bev, UC4, Infrastructure review / enhancement, DBA
and Data Modelling
Mandate
No: 65
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP-QM / SharePoint Integration: Vendor Conformity
Roles: Pedagogical Consultant, Technical Analyst, Project
Manager, Solution Architect, Business Analyst, Team
Lead
Start
Date: 01-May-11 End Date: 20-Aug-12 Months: 16
Project
Details:
Extending vendor quality management and SAP-QM
processes to the internet using SharePoint and K2 for
notification updates (including attachments) by vendors.
What was to be a simple SAP IDoc-based
Notifications interface project leveraging existing service provider
partnerships already in place experienced scope creep and
evolved into an externally-facing SharePoint
interface with attachments using K2 (3rd party technology) for
middle-layer interfacing to SAP.
Tasks performed:
• Identifiy of data
integration points
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
• Identify source and target data (between SAP and
SharePoint), required conversions and modifications
Technologies:
SAP-Solution Manager, SAP-Interface Development,
MS-SharePoint, K2, WinShuttle, SAP-MM, MS-SQL
Server, Identity Management and User Security, X
Modular, SAP-WMS, SAP-SD, SAP-QM, Infrastructure
review / enhancement, Middleware solution, Data Conversion
and Integration
Mandate
No: 64
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP-CRM Implementation
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-May-11 End Date: 20-Aug-11 Months: 4
Project
Details:
•Designing the architecture and infrastructure
landscape, writing the necessary statements of work and (as
Technical Team Lead)
overseeing the implementation of SAP CRM for Molson Canada.
This consisted of adding a separate, Canada-specific
client to the CRM landscape found in the UK CRM
instance, and hooking it up to a separate backend.
Responsibilities also consisted of sitting on the CIC
(Customer Interaction Centre) Integration / Governance
committee to ensure client-independent code changes are
conducive to the evolution of both Canadian
and UK installations
Technologies:
SAP-Solution Manager, SAP-CRM, Infrastructure review /
enhancement
Mandate
No: 63
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Alligacom EDI Solution Server Implementation
Roles: Technical Analyst, Solution Architect
Start
Date: 01-May-11 End Date: 31-Dec-11 Months: 8
Project
Details:
Analysis and implementation of infrastructure required
for supporting Alligacom as an EDI solution.
Technical specifications solution design
specifications and server build documentation assuring high
availability, fault tolerance and disaster recovery for secured
and encrypted EDI data exchange with
partners (vendor, clients and banks)
Technologies:
EDI, ETL / Change Data Capture / Data Replication, X
Modular, SAP-IDOCS
Mandate
No: 62
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Ivara
Wireless Connectivity Support
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-May-11 End Date: 20-Aug-12 Months: 16
Project
Details:
Ivara is the current shop-floor solution for managing and
maintaining shop floor equipment with SAP-ERP
as backend. The mandate consisted of:
Reviewing and validating technical components (server,
network, mobile devices, etc.), how they interact
and how the functional processes depend on them
(including data and integration points),
Debugging and resolving wireless connectivity issues
related to front end Symbol MC9090 hand held
devices accessing Ivara as back
end,
Establish and documenting maintenance procedures for
support of the devices moving forward.
Technologies:
Network (wired/wireless/security/firewall), Identity
Management and User Security, Mobile Enablement,
Infrastructure review / enhancement
Mandate
No: 61
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Nova Scotia Liquor Corporation (NSLC) Interface to SAP
(SD and MM)
Roles: Technical Analyst, Project Manager, Functional
Analyst, Solution Architect, Team Lead
Start
Date: 01-Feb-11 End Date: 20-Jun-11 Months: 5
Project
Details:
EDI Interface design for exchange of SD and MM
information between MCBC and Nova Scotia Liquor
Corporation.
Coordination with VAN,
Identification and modification of EDI message types, fields
and conversion requirements
Integration of new EDI process to current MCBC EDI
Infrastructure.
Generation of solution and architecture design
documents
Elaboration of technical project plan,
Coordinate technical resources,
Oversight of technical resources (as team lead) and
solution roll out
Technologies:
SAP-Interface Development, EDI, ETL / Change Data
Capture / Data Replication, X Modular, UC4,
Infrastructure review / enhancement, DBA and Data
Modelling, Middleware solution, Data Conversion and
Integration
Mandate
No: 60
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Archiving - Coors Brewery
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-Feb-11 End Date: 20-Aug-11 Months: 7
Project
Details:
As Technical Team Lead and Functional Analyst support
to Business Analysts, my role was to oversee the
implementation of SAP Archiving for three separate SAP instances
(Production, APO, and SCM) – all ECC
6.0.
This consisted of:
• Identifying archiving objects and retention periods
• Identifying archiving and as well as house-keeping
cleanup programs
• Determining the program run schedules (with
appropriate variants).
• Establishing HTTP connectivity to OpenText/iXOS to manage archive
objects from the SAP NFS to a
Centera storage solution.
• Establishing connectivity between two Centera boxes (both located in different datacenters –
Markham
Ontario and Auburn Hills Michigan) and configuring
unidirectional replication
• Implementing and configuring Bradmark's
solution for table and index re-organization with zero downtime.
This entailed the following:
• Perform needs assessment
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
• Design and validate business process flow
• Identify source and target data, storage strategies,
etc.
• Design and validate data flow
• Document functional requirements (data sources,
archiving objects, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
• Document technical (non-functional) requirements
such as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
• Presentation to stakeholders, and project team
Technologies:
SAP-Solution Manager, SAP-Interface Development,
MS-SharePoint, SAP-Archiving, Oracle, X Modular,
Mandate
No: 59
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Shock Watch (Lift Truck Impact Monitoring Solution)
Roles: Technical Analyst, Project Manager, Functional
Analyst, Solution Architect, Strategic Analyst, Business
Analyst, Team Lead
Start
Date: 01-Oct-10 End Date: 20-May-11 Months: 8
Project
Details:
Implementation of a lift truck impact monitoring
solution (sensors cabled to vehicle mounted computers)
using a wireless network to transmit data to Microsoft SQL
Server backend in the corporate datacenter.
In addition to impact monitoring, capturing measuring
point values, and reporting on driver behavior
(ensuring compliance Ontario
Health and Safety Board driver assessment), the solution migrates a former
paper-based daily inspection procedure to one that manages data
in SQL Server improving ongoing
vehicle maintenance.
The information gathered is visible from a web-based
dashboard (that can be integrated with SharePoint
as web parts), and alerts can be received on cell phones
for critical levels of configured events.
Shockwatch allows user definable events (measuring
points) to trigger alerts when specific thresholds have
been exceeded.
The data (for example speed, temperature, battery
voltage, impact – measured in G's, etc.) is monitored by
sensors, can be cumulated (when out of network range), and
ultimately synchronized with a SQL Server
backend (where it can be reviewed and reported on). The
values gathered for the various triggered events
can subsequently be passed to SAP as equipment measuring
points.
This entailed the following:
• Perform needs assessment
• Generation of business requirements documents
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
• Design and validate business process flow
• Identify source and target data, modifications (data
massaging) required
Technologies:
Shockwatch, ETL / Change Data Capture / Data
Replication, MS-SQL Server, Identity Management and
User Security, SAP-PM, Mobile Enablement, Web
Development (HTML, XML, ASP, etc.), Infrastructure
review / enhancement, DBA and Data Modelling
Mandate
No: 58
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP Manufacturing Integration and Intelligence (MII)
Roles: Technical Analyst, Project Manager, Functional
Analyst, Solution Architect, Team Lead
Start
Date: 01-May-10 End Date: 20-Nov-10 Months: 7
Project
Details:
• Implementation and roll out of a centralized (vs.
decentralized) instance of SAP-MII as replacement for the
legacy ELink solution.
• Elaborate technical specifications for connectivity
and interfaces with local instances of Proficy at
breweries in located Montreal, Toronto, Vancouver, St-Johns and
Moncton.
• Identification of solution components (hardware as
well as software), elaborating the solution architecture
design documents including optimal connectors for the
relevant data servers and configuration required for
the message listeners to ensure an integrated end-to-end
solution
• Identification of new vs reusable infrastructure
components and how they will interact
• Generation of relevant statements of work and
overseeing their execution
• In addition to validating and challenging the
business as well as functional documents, my primary
responsibility was to generate the Technical Specifications Build
documents and statements of work for HP
to execute, oversee the performance of their tasks, and
act as technical PM for the project
Technologies:
SAP-Netweaver, SAP-Solution
Manager, SAP-MII, SAP-Interface Development, SAP-MM, ETL / Change
Data Capture / Data Replication, MS-SQL Server,
Network (wired/wireless/security/firewall), Identity
Management and User Security, X Modular, SAP-WMS,
SAP-SD, SAP-Portal, SAP-IS-Bev, Infrastructure
review / enhancement, DBA and Data Modelling, Middleware
solution, Data Conversion and Integration
Mandate
No: 57
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: EDI Infrastructure Overhaul
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-May-10 End Date: 20-Dec-10 Months: 8
Project
Details:
• Two part infrastructure upgrade for EDI
transactions executed by Molson Canada.
• The initial phase consisted of migrating an Alligacom FTP PC-based system to the corporate datacenter,
and implementing failover to the DRP datacenter to
address immediate security concerns.
• The second phase involved a complete technology
review having as objective the replacement of the
current Alligacom solution with
Crossgate's SAP-PI solution. This consists of
• Detailing the process flow,
• Elaborating architecture diagrams, and solution
architecture design documents
• Establishing the high-level rough order of
magnitudes for costs,
• Elaborating, reviewing and approving statements of
work necessary for delivering the project,
• Overseeing the solution roll out (as both Project
Manager and Technical Team Lead) and the execution
of relevant project tasks
Technologies:
EDI, MS-Office, Network
(wired/wireless/security/firewall), Identity Management and User Security, X
Modular, UC4, WebServices,
Infrastructure review / enhancement
Mandate
No: 56
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP R/3 4.6 – ECC 6.0 Upgrade
Roles: Technical Analyst, Solution Architect, Team Lead
Start
Date: 01-May-10 End Date: 20-Oct-10 Months: 6
Project
Details:
Assuming a role of Project Technical Team Lead, I was
responsible for
Identifying the technical project tasks (2172 of the
5040 tasks total),
Writing the statements of work, and
Overseeing their successful and timely execution to
ensure successful upgrade from 4.6 to ECC6.
The
upgrade was very successful with an uneventful Go-Live that
took place Easter weekend 2011. The new
upgraded production system was delivered well ahead of
schedule with no business disruption whatsoever.
Although the upgrade
was purely technical in nature (no new functionality), its
downtime-minimized
orientation had to consider several hurdles for example:
16 levels of patching that had been neglected,
Complexities associated with IS-BEV,
Massive amounts
of data (especially COEP conversion) since no archiving had ever been
performed. A
pre-cursor archiving project was successfully executed (see
Molson Archiving) to reduce system downtime
Technologies:
SAP-Solution Manager, X Modular, SAP-Upgrade, SAP-Basis,
SAP-IS-Bev, Infrastructure review /
enhancement
Mandate
No: 55
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Implementation of WMS – Molson Canada (Toronto)
Roles: Pedagogical Consultant, Solution Developer, Technical
Analyst, Functional Analyst, Solution Architect,
Strategic Analyst, Business Analyst, Team Lead
Start
Date: 01-Jan-10 End Date: 20-Oct-10 Months: 10
Project Details:
• Implementation and roll out of SAP WMS on ECC6.0
using SAP R/3 4.6 as backend corporate ERP
system.
• The solution consisted of a wireless RF network
environment using SAP Console running on Intermec CV-
30 Vehicle Mounted Units (VMUs) bolted to 50 forklifts
that ensure 24/7/365 order fulfillment and beer
shipping operations (picking, packing, put-away,
cross-docking, etc.).
• To ensure operations during outages, a Contingency
Solution (which I architected and designed) was
devised consisting of a disconnected, stand-alone data
capture application that saves to a local SQL CE
instance on each device. Once the outage over, SQL Server
replication ensures data migration to a central
SQL Server
instance that in turn allows review, modification, and reporting of data
captured and
subsequent to approval, posts production data to SAP.
Technologies:
SAP-Solution Manager, SAP-MM, ETL / Change Data
Capture / Data Replication, MS-SQL Server, Identity
Management and User Security, X Modular, VMU (Vehicle
Mounted Computers), SAP-WMS, SAP-SD, SAP-
IDOCS, SAP-Console, SAP-IS-Bev, Infrastructure review
/ enhancement, DBA and Data Modelling,
Middleware solution
Mandate
No: 54
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Warehouse Management System (WMS) Contingency Solution
Phase II
Roles: Pedagogical Consultant, Solution Developer, Technical
Analyst, Project Manager, Functional Analyst,
Solution Architect, Strategic Analyst, Business
Analyst, Team Lead
Start
Date: 01-Jan-10 End Date: 20-Aug-10 Months: 8
Project
Details:
• The WMS contingency solutions (Phases I and II) were
successfully delivered prior to the Toronto Go-
Live. To
minimize risk, a text-based version (Phase I) of the solution was deployed in
the baseline image
for Go-Live (even though the SQL Server version – Phase
II was ready). With the positive user
experience, business acceptance testing was completed shortly
after Go-Live, and the text based solution
never saw its way to production (in favor of the SQL
version).
• Phase II (VMU data capture on local SQL Server CE
that replicates with a middleware central instance
that posts to SAP) is the current production standard for
all business continuity scenarios in WMS
deployments. Considering the ability to maintain warehouse
business operations in completely
disconnected mode, the contingency solution has become an attractive
prospect for other divisions (MCBC
Canada,
MCBC-UK, and MillerCoors).
• Deployment and rollout of the Contingency Phase II
solution was closely tied to the VMU Baseline Image
Refresh project that covers shop floor warehouse
operations for both Toronto and Montreal.
• A few minor changes had to be implemented as a
result of Montreal's business acceptance testing: the
impact of using SAP TRM – Task Resource Management in
Montreal but not in Toronto.
The knowledge transfer aspect focused on content
identification and design for end-user training for shop
floor WMS scenarios (picking, put away, cross docking), COE
support teams, and infrastructure support.
This entailed the following:
• Perform needs assessment
• Generation of business requirements documents
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
• Design and validate business process flow
• Identify source and target data, modifications (data
massaging) required
• Design and validate data flow
• Document functional requirements (data sources,
conversions, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
• Interface design specifications (BAPI-based
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, Network
(wired/wireless/security/firewall), Identity
Management and User Security, DotNet, VMU (Vehicle
Mounted
Computers), SAP-WMS, Mobile Enablement, Infrastructure
review / enhancement, DBA and Data
Modelling, Data Conversion and Integration
Mandate
No: 53
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP R/3 4.6 – ECC 6.0 Upgrade Assessment
Roles: Technical Analyst, Functional Analyst, Solution Architect,
Strategic Analyst, Team Lead
Start
Date: 01-Sep-09 End Date: 20-Apr-10 Months: 8
Project
Details:
This project consisted of assessing the high-level
effort for upgrading R/3 (4.6) to ECC (6.0).
An upgrade assessment team was put together and I was
responsible for conducting an extensive review of
all relevant interfaces including:
• Interface inventory (there were 108 known interfaces
to address)
• Required code changes
• Impact of replacing interface technologies (i.e.
from RFC to SOA)
• Connectivity changes
• Testing and retrograde testing scenarios (resulting
in an estimated 222 days of testing)
• Impact on upgrade project plan
Technologies:
SAP-Solution Manager, SAP-Upgrade, SAP-IS-Bev,
Infrastructure review / enhancement
Mandate
No: 52
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Maintenance, Repair and Overhaul (MRO): Ivara-SAP Interface
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-May-09 End Date: 20-Aug-09 Months: 4
Project
Details:
This project was aimed at outsourcing equipment/plant
maintenance by having a third party manage
maintenance orders and equipment using its own applications and
subsequently, update SAP.
Implemented
interfaces:
• PO generation (for replenishment of consumed
materials),
• Material issue,
• Equipment measuring points,
• Creation/update of maintenance orders.
This entailed the following:
• Review and critique of needs assessment
• Review and critique of business requirements
documents
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing
them.
• Participate in design and validate business process
flow
• Identify source and target data, modifications (data
massaging) required
• Validate data flow
• Document functional and business requirements (data
sources, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
• Validation, scope adjustment and customer sign-off
• Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
• Presentation to stakeholders, and Global
Architecture Review Board for technology adoption
Technologies:
EDI, SAP-MM, ETL / Change Data Capture / Data
Replication, Network (wired/wireless/security/firewall), X
Modular, SAP-WMS, Material Requirements Optimization
MRO, UC4, WebServices, Infrastructure review /
enhancement, DBA and Data Modelling
Mandate
No: 51
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Grupo Modelo Interface
Roles: Technical Analyst, Solution Architect, Strategic
Analyst, Team Lead
Start
Date: 01-May-09 End Date: 20-Aug-09 Months: 4
Project
Details:
Grupo Modelo (owned by
Anheuser-Busch/ InBev group), is the largest brewer
in Mexico with 63% of the
national market). MCBC
is one of its many export partners, and as a result, required an interface to
assist
in planning the receipt and distribution of imports, as
well as improve reporting with respect to assessing
import taxes. The
mandate consisted of
Reviewing and validate the business data identified in
the business requirements document,
Identification of EDI message types and coordinate
modifications with the various partners
Integration of new EDI message types to the existing
infrastructure,
Plan file movements/frequencies/fall back plans and
processing between MCBC and Modelo using UC4 as
file transfer protocol/solution.
Coordinate UAT and document the solution
(end-to-end)
Technologies:
EDI, SAP-MM, ETL / Change Data Capture / Data
Replication, X Modular, SAP-WMS, SAP-SD, SAP-IS-
Bev, UC4, Infrastructure review / enhancement, DBA and
Data Modelling, Middleware solution
Mandate
No: 50
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Implementation of New Distribution Centre in Toronto
Roles: Solution Developer, Project Manager, Functional
Analyst, Solution Architect
Start
Date: 02-Jan-09 End Date: 30-Sep-09 Months: 9
Project
Details:
Elaborating and creating the infrastructure required
(from scratch) to implement a new distribution centre
from a rented empty warehouse building. This consisted of
extending the current SAP-WMS solution to a
new site and involved the following:
Generation and management of project plan
Wireless site survey,
Access point additions and adjustments,
IP reservation management (through Bell Canada
partner),
Adjustment/modifications of vehicle mounted computer
baseline images,
Configuration and deployment of SAP Console-based WMS
Configuration changes to business continuity /
contingency solution
Validation of configuration for newly created storage
locations and bins for pre-existing materials,
Extending the targeted materials,
Documenting the changes
Technologies:
SAP-Solution Manager, SAP-MM, Network
(wired/wireless/security/firewall), Identity Management and User
Security, X Modular, VMU (Vehicle Mounted Computers),
SAP-WMS, SAP-SD, SAP-IDOCS, Mobile
Enablement, SAP-IS-Bev, Infrastructure review /
enhancement, Middleware solution
Mandate
No: 49
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Warehouse Management System Molson (WMS) – Molson
Canada (Montreal)
Roles: Technical Analyst, Functional Analyst, Solution
Architect
Start
Date: 01-Sep-08 End Date: 20-Dec-08 Months: 4
Project
Details:
I was brought
in to resolve difficulties experienced after project delivery
• Delivery of Post Go-Live support/trouble shooting
expertise for implementation of SAP ECC6.0 WMS in a
wireless, environment using Windows XP Embedded Intermec CV-60
Vehicle Mounted Units (VMUs).
• Provided subject matter expertise and
reviewed/adjusted architecture framework and project
documentation where required.
• Analysis and modification of solution design
specifications, and update of project documentation.
• Solution adjustments to accommodate changes in
business practices that did not surface prior to project
delivery (such as warehouse storage practices that impact the
quality of wireless coverage).
• Coordination of partner (Bell Canada, HP, Intermec)
and MCBC internal resources to resolve Severity 1
issues
Technologies:
SAP-Solution Manager, Identity Management and User
Security, VMU (Vehicle Mounted Computers), SAP-
WMS,
Mobile Enablement, Infrastructure review
/ enhancement
Mandate
No: 48
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Oracle Upgrade
Roles: Technical Analyst
Start
Date: 02-Jun-08 End Date: 31-Jul-08 Months: 2
Project
Details:
Project technical team lead for upgrading Oracle from
9i to 10.2 as precursor project for upgrading SAP
from R/3 to ECC 6.0.
• Elaboration and evaluation of statements of work
• Reviewing, modifying and approving the project plan
• Coordinating outage schedules
• Overseeing post upgrade tests for development,
Quality assurance (consolidation) and production
instances
Technologies:
Oracle,
Infrastructure review / enhancement
Mandate No: 47
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: SAP-HCM (eRecruite)
Roles: Technical Analyst, Solution Architect
Start
Date: 01-May-08 End Date: 30-Aug-08 Months: 4
Project
Details:
Coordinate tasks with the business to elaborate the
business requirements documentation, and generate
the technical specifications documentation for adding new
servers to the current infrastructure that will
support the eRecruite solution
(SAP-HCM).
This is an externally-facing solution that allows
individuals to apply for open positions and upload their
résumés/file attachments (similar to current job boards and
recruiters).
This entailed the following:
• Perform needs assessment
• Analyze and compare requirements with SAP sizing and
standard functionality
• Identify source and target data, modifications (data
massaging) required
• Design and validate data flow
• Document functional and business requirements (data
sources, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
• Validation, scope adjustment and customer sign-off
• Document technical (non-functional) requirements
such as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
• Technology and solution demo / proof of concept
• Presentation to stakeholders, and project team
Technologies:
SAP-Solution Manager, SAP-Interface Development,
SAP-Upgrade, SAP-HCM, SAP-HR, Infrastructure
review / enhancement, SAP-TREX, Adobe Developer Forms, SAP-eRecruite
Mandate
No: 46
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Review of Production Support / Service Level Agreement
Roles: Technical Analyst, Solution Architect, Strategic
Analyst
Start
Date: 01-May-08 End Date: 20-Aug-12 Months: 52
Project
Details:
Ongoing review and update of service level agreement
(SLA) MCBC has with HP.
Objective:
Formalize (establishment of monitoring and reporting
tools, penalties) and improve response time to take
into account infrastructure evolution by reviewing and
adjusting the acceptable system downtime:
• Considering the multitude of SAP modules installed
• Considering numerous changes in infrastructure
components (such as networks, databases, and other
legacy or partner solutions such as Ivara,
Proficy, etc.)
• For patching and maintenance
• For operation critical processes - severity 1 issues
Technologies:
SAP-Solution Manager, Shockwatch, X Modular, VMU
(Vehicle Mounted Computers), Infrastructure review /
enhancement
Mandate
No: 45
Client: MillerCoors Brewing Corporation
Industry: Food & Beverage
Project: Extended Warehouse Management (SAP-EWM) - MillerCoors (Golden Colorado)
Roles: Technical Analyst, Project Manager, Functional
Analyst, Solution Architect, Team Lead
Start
Date: 01-May-08 End Date: 30-Aug-08 Months: 4
Project
Details:
Decommissioning current Warehouse Information
Tracking System (WITS) and replacement with SAP's
extended warehouse management solution.
This involved implementing a wireless radio frequency
(RF) solution for a 30,000 square foot warehouse
that uses 60 forklifts to line load (24/7/364) both trucks
(47 docks for 53 foot trailers) and railway cars on 2
separate floors.
Objective: Combine best of breed solutions (and
solution components) from warehouses located in Toronto
(Canada),
Montreal (Canada), Shenandoah Valley, Virginia (USA) and implement the selected
solutions in
Golden, Colorado (USA).
Role:
• Identify the project tasks required for a successful
implementation,
• Generate the numerous statements of work
(identifying the success criteria) for the various
partners/contractors, and
• Assume a role of Solution Design Architect /
Technical Project Management / Technical Team Lead for
the project.
Mandate:
• Complete assessment of solution architecture and
upgrading / replacing components that were obsolete
or approaching end-of-life to ensure a 99.5% solution
availability - 4 hours downtime per month.
• Analysis and revamp of network - wired and wireless
(implementation of a redundant wireless network)
• Wireless site survey
• Component upgrade (APs, switches, network cabling)
• Hardware - vehicle mounted computers selection
(POCs, end-user evaluations, generation of surveys
and ratings, etc.)
• Generation and evaluation of RFPs
• Partner and vendor selection
• Communications and preparing supporting
documentation for Global Architecture Review Board approval
• Elaboration of both high-level milestones and
detailed project plans
• Oversee execution of project technical tasks
• Participation in generation of service level
agreement (specifications, performance measurement criteria,
escalation structure and reporting)
Technologies:
SAP-Solution Manager, SAP-Interface Development,
SAP-MM, MS-Office, ETL / Change Data Capture /
Data Replication, Oracle, X Modular, SAP-WMS,
SAP-Basis, SAP-EWM, Mobile Enablement
Mandate
No: 44
Client: MolsonCoors Brewing Corporation
Industry: Food & Beverage
Project: Human Capital Management (HCM-eRecruite)
MolsonCoors (Golden Colorado)
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-May-08 End Date: 30-Aug-08 Months: 4
Project
Details:
Infrastructure and architecture review for
implementation of SAP's HCM eRecruite solution as an
electronic
recruitment solution (similar to JobBoom)
for use by Molson (Canada), Coors (USA), Miller (USA), and Bass
(UK) using
various SAP technologies such as:
• SAP ECC 6.0
• Netweaver
• SAP Portal
• TREX 7.0
• XI
• Adobe Developer
Responsible for
• Sizing the solution,
• Determining the various components required,
• Identifying the add-ins, and SP Patch levels for
preparation of the server build document.
• Review, edit, challenge and technically scope
business blueprint documents generated by HP-SAP and
Molson Coors Subject Matter Experts (SMEs).
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing
them.
Technologies:
SAP-Solution Manager, Network
(wired/wireless/security/firewall), X Modular, SAP-HCM, SAP-HR,
Infrastructure review / enhancement, SAP-TREX, Adobe
Developer Forms, SAP-eRecruite
Mandate No: 43
Client: Metropolitain Gas
(Société Commanditée Gaz Métropolitain)
Industry: Gas & Oil
Project: Field Service Technician Mobility Project - Mobile
enablement of SAP PM,SD,MM,HR processes
Roles: Solution Developer, Technical Analyst, Project
Manager, Functional Analyst, Business Analyst, Team Lead
Start
Date: 01-Oct-05 End Date: 31-Aug-07 Months: 23
Project
Details:
Mobile-enabling field service technicians: perhaps one
of the most demanding and technologically
challenging projects undertaken to date.
Porting SAP order processing (Sales and Maintenance
Orders, Notifications, Measuring Points, Functional
Locations, Equipment, Material, Employee, etc.) to the mobile environment to allow order processing
through use of hand held Symbol M70 PDA. This project made
use of the following technology
components:
• Barcodes (Code 128 and PDF417-2 dimensional
barcodes),
• Telemetry transponders,
• Radio Frequency Identification (RFID), 1X and GPRS
wireless for synchronizing data between mobile
• devices and middleware
server (SQL Server),
• Global Positioning System (GPS) and Geo-coding
integrating GPS and measuring points for equipment
and functional locations,
• Implementing Enterprise application integration
(EAI) among such corporate systems as:
o SAP (running on DB2),
o Click Scheduler,
o TS (Oracle-based Time Sheet and Reporting System)
o SQL Server 2005-based Bell Fleet-LAV (Automated
vehicle location and tracking system)
o Online Data Store (ODS).
The project resulted in deliverables that required
integration with SAP and as a result required core
functional and technical analysis resulting in business
requirements documents that detail process and
data flows for signoff by stakeholders.
This solution required full revision and
recommendations for equipment hierarchy structure, equipment
characteristics and measuring points as well as an in depth review,
analysis, and adjustment of
data/process flow development and elaboration of master data
integration points.
Responsibilities:
• Needs assessment,
• Project scoping,
• Analyzing and writing business requirements and
functional requirements specifications,
• Technical design specifications for development,
• Interface specifications documentation (including
data mining and conversion requirements for exchanges
between 5 corporate systems - listed above)
Technologies:
SAP-ABAP, SAP-Netweaver,
SAP-Interface Development, EDI, SAP-MM, MS-Office, ETL / Change Data
Capture / Data Replication, MS-SQL Server, Oracle, SQL
/ PL-SQL / Transact-SQL, X Modular, SAP-
WMS, SAP-Basis, SAP-SD, SAP-QM, SAP-PM, Material
Requirements Optimization MRO, SAP-IDOCS,
SAP-HR, SAP-IS-Gas & Oil, Mobile Enablement
Mandate
No: 42
Client: Government of Canada – R.C.M.P. United Nations Peacekeeping
Directorate
Industry: Police and Public Safety
Project: Stock Tracking and Material Issue Solution
Roles: Developer-OOP, Solution Developer, Technical Analyst,
Project Manager, Functional Analyst, Business
Analyst, Team Lead
Start
Date: 01-Apr-05 End Date: 30-Jun-05 Months: 3
Project
Details:
Upgrade of stock tracking and issue materiel
management application developed in 2001 for the R.C.M.P.
in two distinct infrastructures: Batch hand-held devices
and wireless RF hand-held devices.
Application
enhancement and performance improvements:
Elimination of middle-layer processing for issues and
physical inventory audits performed by PDA.
Implementation of automated backup system to ensure
high availability
Data conversion, cleansing and RDBMS maintenance
RDBMS upgrade from SQLBase
6.1 to SQLBase 8
Solution support documentation and end-user training
Multi-media reference material and self-paced
learning
Technologies:
SAP-Interface Development, ETL / Change Data Capture /
Data Replication, Centura Team Developer &
SQL Base, Point of Sale (POS), X Modular, Mobile
Enablement, DBA and Data Modelling, Data Conversion
and Integration
Mandate
No: 41
Client: Government of Canada – R.C.M.P. Protective Policing Logistics
Industry: Police and Public Safety
Project: Warehouse / Stocked Material Management Solution
Upgrade
Roles: Developer-OOP, Pedagogical Consultant, Solution
Developer, Technical Analyst, Project Manager,
Functional Analyst, Business Analyst, Team Lead
Start
Date: 01-Feb-05 End Date: 30-Apr-05 Months: 3
Project
Details:
Analysis for implementation of materiel management
application developed in 2001 for the R.C.M.P. using
two distinct infrastructures: Batch hand-held devices and
wireless RF hand-held devices. The
existing
software required reconfiguration and partial re-coding for
use in 2 separate warehouses that have
differing and limitations (physical and infrastructure). The project mainly involved enhancement,
configuration and code migration to a wireless platform.
This project allowed the R.C.M.P. to use one common
material management solution to stock, issue and
track materiel in either desktop, hand-held batch or
hand-held RF flavors. Tasks performed:
• Performs needs analysis and scoping exercise
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
Technologies:
SAP-Interface Development, SAP-MM, ETL / Change Data
Capture / Data Replication, Centura Team
Developer & SQL Base, X Modular, SAP-WMS, Mobile
Enablement, DBA and Data Modelling, Middleware
solution, Data Conversion and Integration
Mandate
No: 40
Client: Government of Canada – R.C.M.P. Protective Policing Logistics
Industry: Police and Public Safety
Project: Warehouse and Material Master Data (Configuration and
Master Data Load)
Roles: Developer-OOP, Solution Developer, Technical Analyst, Project
Manager, Functional Analyst, Solution
Architect, Team Lead
Start
Date: 01-Jan-05 End Date: 30-Apr-05 Months: 4
Project
Details:
Master Data:
Conversion and migration of data from legacy material management
system (Basset Pro) to new material
issue and tracking system (SQLBase)
while setting the foundation and ground work for updating SAP
Material, Equipment and Functional Location master
data.
Analysis and configuration of warehouse layout
Creation of application to generate bar-coded location
labels
Analysis and data mapping of serialized and bulk
material (stocked)
Development of ETL tool to convert source (Basset Pro)
data to stock tracking and issue system (Oracle
8i)
Technologies:
ETL / Change Data Capture / Data Replication, Centura Team Developer & SQL Base, SQL / PL-SQL /
Transact-SQL, X Modular, DBA and Data Modelling,
Middleware solution, Data Conversion and Integration
Mandate
No: 39
Client: Government of Canada – R.C.M.P. Automated Information Management Systems
Industry: Police and Public Safety
Project: Development of Equipment/Asset Tracking Solution
Roles: Developer-OOP, Solution Developer, Technical Analyst,
Functional Analyst, Solution Architect, Business
Analyst, Team Lead
Start
Date: 01-Oct-04 End Date: 30-Apr-05 Months: 7
Project
Details:
Development of material management application to
manage issues and tracking of classified
telecommunications equipment using bar-coding technology.
Perform needs analysis, scoping exercise and
generation of business requirements documents
Recommend optimal hardware and infrastructure that
best meets business requirements
Design and validate business process flow
Design and validate data flow
Document functional and business requirements (data
sources, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
Validation, scope adjustment and customer
sign-off
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Technology and solution demo / proof of concept
Presentation to stakeholders, and project team
Master Data Load (analysis, data modelling, source and
target data mining, data massaging and
conversion, etc.)
Interface development: Develop application for ongoing
transfer data from Oracle 8i RDBMS to Palm based
barcode reading hardware.
Mobile Development: Develop Palm Tungsten application
(screen design, UI navigation and data
persistence capture/persistence) to enable barcode capable
warehouse operations: goods issue, returns,
exchanges, and stock audit
Implement barcode-printing capability from scratch
Interface Development: Application development for
updating the Oracle 8i backend RDBMS with data
Technologies:
SAP-Interface Development, ETL / Change Data Capture /
Data Replication, Centura Team Developer &
SQL Base, SQL / PL-SQL / Transact-SQL, X Modular,
Material Requirements Optimization MRO, Mobile
Enablement, DBA and Data Modelling, Middleware
solution, Data Conversion and Integration
Mandate
No: 38
Client: Jacob
Industry: Retail, Apparel
Project: Jacob Inc. - IBC Project (Purchase Order Automation)
Roles: Pedagogical Consultant, Functional Analyst
Start
Date: 01-Aug-04 End Date: 31-Oct-04 Months: 3
Project
Details:
Pedagogical consulting and knowledge transfer for Jacob
clothes line (fashion industry). Since their Go-
Live in 2001 (see previous project below) Jacob
decided to extend the procurement process to its
employees and allow them to use SAP to procure goods and
services for internal consumption (ESS
scenario). Key
employees are tasked with all phases of the process:
Master Data (vendor, article, service master records)
Generation of Purchase Requisitions
Generation of Purchase Orders
Goods Receipts Invoice Settlements (including
pre-payments)
SAP Workflow integrated with Lotus Notes resulted in a
drastic change for the employee who formerly
relied on other divisions to perform the tasks.
I was responsible for the development of documentation
and training material to facilitate knowledge
transfer to employees using SAP R/3 Version 4.6C – Retail.
This consisted of over 60 SAP R/3
transactions. The material developed (both high level concepts as
well as step-by-step procedures)
consisted of:
PowerPoint Presentations
Documented Step-By-Step Procedures
Reference / Quick Help Tools
Tutorials
Multi-media based knowledge transfer
Training exercices
Technologies:
SAP-MM, MS-Office, X Modular, SAP-WMS, SAP-SD, SAP-QM,
SAP-IS-Retail
Mandate
No: 37
Client: Government of Canada – R.C.M.P. Automated Information Management Systems
Industry: Professional Services
Project: Mobile Enablement of Goods Receipt
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect
Start
Date: 01-Jun-04 End Date: 31-Dec-04 Months: 7
Project
Details:
Development of a PDA-based goods receipt and
distribution module to bolt on to a previously developed
(in 2001) material management
system for the United Nations Peacekeeping Directorate. The module
allows procurement data extracted from the TEAM (SAP) system
to be used to perform goods receipt and
delivery to end users using hand-held devices. The resulting
data (delivery and tracking information) is
used to populate a middle layer Oracle 8i database, and
ultimately update TEAM (SAP) as the back-end
ERP. This builds on previously developed functionality
implemented for the R.C.M.P. UN Peacekeeping.
Tasks performed:
• Perform needs assessment
• Generation of business requirements documents
• Solution storyboarding and data flow diagrams
• Stakeholder presentation and buy-in / signoff
• Recommend optimal hardware and infrastructure that
best meets business requirements
• Master data conversion and load
• Interface development for bi-directional data
exchanges
• Develop application to transfer data from Oracle 8i
RDBMS to Palm-based barcode reading hardware.
• Develop Palm application to enable barcode capable
warehouse operations: goods issue, returns,
exchanges, and stock audit
• Implement barcode-printing capability
• Design screens for data capture on Symbol SPT-1700
• Develop the application to read the captured data
and update the Oracle 8i backend RDBMS.
Technologies:
SAP-Interface Development, ETL / Change Data Capture /
Data Replication, Centura Team Developer &
SQL Base, Oracle, SQL / PL-SQL / Transact-SQL, Point
of Sale (POS), X Modular, Material Requirements
Optimization MRO, Mobile Enablement, Infrastructure
review / enhancement, DBA and Data Modelling,
Middleware solution, Data Conversion and Integration
Mandate
No: 36
Client: DataMirror
Industry: Transportation
Project: Novus (Puerto Rico) SAP-POS Interface
Roles: Solution Developer, Functional Analyst
Start
Date: 01-Apr-04 End Date: 30-Jun-04 Months: 3
Project
Details:
Preparation of
business requirements documents,
fit gap analysis,
functional design specifications and
proof of concept (POC)
for data exchange between Point of Sale (POS) and SAP using EDI (XML and
IDocs)
Technologies:
SAP-Interface Development, EDI, SAP-MM, Transformation
Server (now IBM Infosphere), ETL / Change
Data Capture / Data Replication, Point of Sale (POS),
X Modular, SAP-WMS, SAP-SD
Mandate
No: 35
Client: DataMirror
Industry: Media and Entertainment
Project: Cirque du Soleil - Material and Equipment Tracking
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Business Analyst
Start
Date: 01-Oct-03 End Date: 31-Jan-04 Months: 4
Project
Details:
To simplify and improve trans-border shipments, Cirque
du Soleil wanted to perform a feasibility study to
implement RFID technology to
tag items such as tools and costumes (that typically average $5K +) The
Deliverables:
Perform an assessment of the current situation
Validate the accuracy of information gathered with the
business community
Provide advice and guidance on how to address gap-fit
scenarios (business, functional and technical)
Explore the existing technologies that can meet the
business requirements, and prioritize the options in
order of complexity/effort/cost.
Identify data sources (origin and destination) and
conversions between SAP and data capture systems - at
a high level - required for data validation (updates
and new entries – i.e. creation of new materials,
equipment including measuring points, characteristics, etc.) in the mobile (disconnected version) of the
proposed solution.
Develop work and process flows for data insertion and
updates
Identify data and process integration points, as well
as governance/ownership issues
Technologies:
SAP-MM, SAP-AA, ETL / Change Data Capture / Data
Replication, MS-SQL Server, X Modular, SAP-PM,
Mobile Enablement, Web Development (HTML, XML, ASP, etc.),
RFID, Middleware solution
Mandate
No: 34
Client: DataMirror
Industry: Pharmaceutical
Project: Merck Pharmaceuticals - M&RE Equipment Maintenance
Downtime Reporting
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Business Analyst
Start
Date: 01-Mar-03 End Date: 31-Oct-03 Months: 8
Project
Details:
Merck Pharmaceuticals wanted to mobile-enable the data
capture related to maintaining equipment and
report downtime to better assess the reliability and productivity
of shop floor equipment. The data
captured subsequently updated SAP equipment maintenance
orders, measuring points as well as
employee time tracking. This consisted of performing the
following:
Perform needs assessment
Generation of business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
Design and validate business process flow
Use case and story boarding
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validate and adjust scope
Document technical (non-functional) requirements such
as security (access and roles), high availability
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, X Modular, SAP-WMS, SAP-SD,
SAP-QM, SAP-PM,
Mobile Enablement
Mandate
No: 33
Client: DataMirror
Industry: Pharmaceutical
Project: McNeil Consumer Heathcare -
Mobile Enablement of SAP Processes
Roles: Solution Developer, Technical Analyst, Functional Analyst,
Business Analyst
Start
Date: 01-Mar-03 End Date: 31-Aug-03 Months: 6
Project
Details:
McNeil Consumer Heath
Care already benefited from RF-based shop floor data capture updating SAP as
back end, and wanted to extend their current inventory of
transactions to include 3 new ones:
Goods Issue to a process order (Transaction MB1A
movement type 261)
Reversal of Goods Issue to a process order
(Transaction MB1A movement type 262)
Goods Receipt (Transaction MB31 movement type 101)
This entailed the following:
Perform needs assessment
Support TA in the generation of business requirements
documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
Design and validate business process flow
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL and
integration technologies, architecture
frameworks and landscapes, etc.)Validate and adjust scope
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Presentation to stakeholders, and project team
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, Network
(wired/wireless/security/firewall), SQL / PL-SQL / Transact-SQL,
X Modular, SAP-WMS, SAP-SD, Mobile
Enablement
Mandate
No: 32
Client: DataMirror
Industry: Food & Beverage
Project: Dare Foods - Mobile Enablement of Sales Force
Roles: Solution Developer, Technical Analyst, Functional
Analyst
Start Date: 01-Feb-03 End Date: 30-Nov-03 Months: 10
Project
Details:
Porting SAP transations
VA01-03 to disconnected hand-held devices for implementing offline sales
order
processing using Windows CE-based Pocket PC devices transmitting
data over a 1X-based cellular
network.
Information captured using hand held devices is used
to update SAP sales orders via SQL Server as
middleware.This entailed the following:
• Perform needs assessment
• Support technical analyst in the generation of
business requirements documents
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
• Design and validate business process flow
• Design and validate data flow
• Identify source and target data, conversions,
modifications (data massaging) required
• Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
• Validate and adjust scope
• Document technical (non-functional) requirements
such as security (access and roles), high availability
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, X Modular, SAP-SD, Mobile
Enablement, Web Development (HTML, XML, ASP, etc.),
Middleware solution, Data Conversion and
Integration
Mandate
No: 31
Client: DataMirror
Industry: Manufacturing
Project: Electrovaya-Development of Wireless WMS Transactions
Roles: Developer-ABAP, Solution Developer, Technical Analyst,
Functional Analyst
Start
Date: 01-Oct-02 End Date: 31-Dec-02 Months: 3
Project
Details:
Mobile enablement of the following SAP processes:
Goods Issue for Delivery
Goods Receipt for PO
Physical Inventory Count This entailed the following:
Perform needs assessment
Support technical analyst in the generation of
business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
Design and validate business process flow
Identify source and target data, conversions and
modifications (data massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validate and adjust scope
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Presentation to and buy-in from stakeholders, and
project team
Technologies:
SQL / PL-SQL / Transact-SQL, SAP-WMS, Data Conversion
and Integration
Mandate No: 30
Client: Bell Canada
Industry: Telecommunications
Project: Bell Canada – Physical Inventory and Asset Management
(PIAM)
Roles: Solution Developer, Technical Analyst, Project
Manager, Functional Analyst, Team Lead
Start
Date: 01-Sep-02 End Date: 30-Nov-03 Months: 15
Project
Details:
Mobile-enablement of SAP MM and PM processes (physical
inventory functionality and equipment location
validation to an offline handheld Pocket PC.
Integration with Plant Maintenance (install and
disassemble equipment) and Material Management Module
(both serialized and
non-serialized materials).
Considerable custom development allowed migration of
legacy functionality to a middle-ware, off-line
environment that communicates with SAP using stand-alone
hand-held barcode readers (Intermec
m700)and desktop PCs to
manage and approve results through an ASP-based web page prior to posting
in SAP.
Responsibilities Included:
• Generation of business requirements documents
• Functional and technical specifications design
• Management of developers responsible for user
interface development (ABAP, C, and Visual Basic for
• Windows CE)
• Documentation generation
• Scoping documents for customer approval and
development of recommendations with respect to
architectural and IT infrastructure.
This entailed
the following:
• Perform needs assessment
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
• Design and validate business process flow
• Identify source and target data, conversions and
modifications (data massaging) required
• Design and validate data flow
• Document functional requirements (data sources,
required conversions, ETL and integration
technologies, architecture frameworks and landscapes, etc.)
• Validate and adjust scope
• Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Technologies:
SAP-ABAP, SAP-Interface Development, SAP-MM,
Transformation Server (now IBM Infosphere), ETL /
Change Data Capture / Data Replication, MS-SQL Server,
Network (wired/wireless/security/firewall), SQL /
PL-SQL / Transact-SQL, X Modular, SAP-WMS, Mobile
Enablement, Web Development (HTML, XML, ASP,
etc.),
Middleware solution, Data Conversion and Integration
Mandate
No: 29
Client: Government of Canada – R.C.M.P. United Nations
Peacekeeping Directorate
Industry: Police and Public Safety
Project: Computer Based Training (CBT)
Roles: Pedagogical Consultant, Functional Analyst
Start
Date: 01-Sep-02 End Date: 31-Dec-02 Months: 4
Project
Details:
Development and deployment of multimedia
computer-based training (CBT) for material management and
warehousing solution including:
system reference and support manuals
knowledge transfer for application support
end-user documentation and multimedia
requisitioning of materials and supplies
stock issues
replenishment and re-order point planning
Technologies:
MS-Office, ETL / Change Data Capture / Data
Replication, Centura Team Developer & SQL Base,
Point of
Sale (POS), X
Modular, Mobile Enablement
Mandate
No: 28
Client: DataMirror
Industry: Professional Services
Project: Tennant Corporation Mobile Enablement of Sales Order /
Field Services
Roles: Solution Developer, Technical Analyst, Functional
Analyst
Start
Date: 01-Sep-02 End Date: 31-Dec-02 Months: 4
Project
Details:
Project scope expansion to include new / additional
SAP functionality. Information captured using hand held
devices is used to update SAP sales orders and employee time
tracking using CATS. Among the new
functionality we find:
Equipment master update,
Measuring point data capture,
Notifications and order status updates (user and
system)
Solution scoping,
High level design, and prototyping
Project preparation for client approval for
implementing offline sales order processing by field service
representatives.
Perform needs assessment
Generation of business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps.
Design and validate business process flow
Identify source and target data, modifications (data massaging)
required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validation, scope adjustment and customer
sign-off
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Functional design specifications and proof of concept
(POC)
Technologies:
SAP-ABAP, SAP-Interface Development, SAP-MM,
Transformation Server (now IBM Infosphere), ETL /
Change Data Capture / Data Replication, MS-SQL Server,
Network (wired/wireless/security/firewall), SQL /
PL-SQL / Transact-SQL, X Modular, SAP-WMS, SAP-SD,
SAP-QM, SAP-PM, SAP-HR, Mobile Enablement,
Web Development
(HTML, XML, ASP, etc.), Middleware solution
Mandate
No: 27
Client: DataMirror
Industry: Mining
Project: MSA (Mine Safety Associates)
Roles: Pedagogical Consultant, Solution Developer, Functional
Analyst
Start
Date: 01-Jul-02 End Date: 31-Jan-03 Months: 7
Project
Details:
Preparation of business requirements documents, and
functional design specifications/knowledge transfer
documentation for implementation and configuration of Report
Distributor (SAP Bolt On product from
DataMirror)
Technologies:
SAP-ABAP, SAP-Interface Development, SAP-MM, X
Modular, SAP-WMS, SAP-Basis, SAP-Patches, SAP
OSS Notes
Mandate
No: 26
Client: DataMirror
Industry: Media and Entertainment
Project: CBC Radio Canada - Asset Auditing
Roles: Solution Developer, Functional Analyst
Start
Date: 01-Jun-02 End Date: 31-Oct-02 Months: 5
Project
Details:
Preparation of business requirements documents, fit
gap analysis, functional design specifications and
project plan for mobile-enabling the physical auditing of
assets (SAP Transaction AS02).
Technologies:
SAP-ABAP, SAP-MM, SAP-AA, MS-SQL Server, X Modular,
Mobile Enablement
Mandate
No: 25
Client: DataMirror
Industry: Manufacturing
Project: Mann and Hummel: SAP-MES Integration
Roles: Technical Analyst, Functional Analyst, Solution
Architect, Business Analyst
Start
Date: 01-Jun-02 End Date: 28-Feb-03 Months: 9
Project
Details:
Project aimed at integrating Manufacturing Execution
System (MES) shop floor data (gathered via PLCs:
Production Line Computers/Robotic components) and
employee time-sheet data.
This essentially consisted of designing a number of bi-directional
robotics interfaces between MES and
SAP that download SAP orders, and equipment master
data (characteristics and measuring points),
capture new equipment measuring point values throughout the
manufacturing process, update SAP orders,
and equipment using middle-ware server.
Functional analyst / solution designer responsible
for:
• Needs assessment
• Support technical analyst in the generation of
business requirements documents
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
• Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)Validate and adjust scope
• Document technical (non-functional) requirements
such as security (access and roles), high availability
• requirements, business
continuity and disaster recovery strategies
• Presentation to stakeholders, and project team
• The scope consisted of the following SAP shop floor
processes:
• Cross Application Processes
• Component and Lot Tracking
• Component Recall Tracking
• Cross Application Time Sheets (CATS) – Labor
Tracking
• Management reporting (approximately 12 reports)
SAP Processes:
• PM Order Processing
• Sales Order Processing
• Goods Receipt
• Goods Issue
• Picking
• Packing
• Delivery Processing
• Shipping
• Equipment Master Update
• Equipment and Functional Location Measuring Points
Shop Floor / Manufacturing Processes:
Technologies:
SAP-Interface Development, SAP-MM, ETL / Change Data
Capture / Data Replication, MS-SQL Server,
Network (wired/wireless/security/firewall), SQL /
PL-SQL / Transact-SQL, X Modular, SAP-WMS, SAP-
Basis, SAP-SD, SAP-QM, SAP-PP, SAP-PM, SAP-IS-Auto
Mandate
No: 24
Client: DataMirror
Industry: Professional Services
Project: Electrovaya - Mobile Enablement of SAP Warehouse Processes
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Business Analyst
Start
Date: 01-Apr-02 End Date: 31-Jul-02 Months: 4
Project
Details:
Mobile enablement of the following SAP processes:
Goods Issue for Delivery
Goods Receipt for PO
Physical Inventory Count This entailed the following:
Perform needs assessment
Support technical analyst in the generation of
business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
Design and validate business process flow
Identify source and target data, conversions and
modifications (data massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validate and adjust scope
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Presentation to and buy-in from stakeholders, and
project team
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
X Modular, SAP-WMS, Mobile Enablement
Mandate
No: 23
Client: DataMirror
Industry: Telecommunications
Project: Expertech - Field Workforce Visibility
Roles: Solution Developer, Functional Analyst
Start
Date: 01-Apr-02 End Date: 31-Oct-02 Months: 7
Project
Details:
Preparation of business requirements documents, fit
gap analysis and functional design specifications for
mobile enabling sales and PM Order Processing by field
technicians. SAP processes:
Component and Lot Tracking
Component Recall Tracking
Cross Application Time Sheets (CATS) – Labor Tracking
PM Order Processing
Sales Order Processing
Goods Receipt
Goods Issue
Picking
Packing
Delivery Processing
Shipping
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, X Modular, SAP-WMS, SAP-SD,
Web Development
(HTML, XML, ASP, etc.), Data Conversion and Integration
Mandate
No: 22
Client: DataMirror
Industry: Professional Services
Project: Logica -
Mobile Enablement of SAP Process (Physical Inventory)
Roles: Technical Analyst, Functional Analyst
Start
Date: 01-Apr-02 End Date: 30-Sep-02 Months: 6
Project
Details:
Mobile enablement of physical inventory of material
(both serialized and non-serialized) as well as
equipment using mobile hand-held devices. This entailed:
Perform needs assessment
Support TA in the generation of business requirements
documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
Design and validate business process flow
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks
Technologies:
SAP-MM, SAP-AA, ETL / Change Data Capture / Data
Replication, MS-SQL Server, X Modular, SAP-WMS,
SAP-PM, Mobile
Enablement, Web Development (HTML, XML, ASP, etc.)
Mandate
No: 21
Client: DataMirror
Industry: Food & Beverage
Project: Unifine Reichardson – Analysis and
Specifications Development for Implementation of RF-based
Warehouse Functionality
Roles: Solution Developer, Technical Analyst, Functional
Analyst
Start
Date: 01-Apr-02 End Date: 30-Sep-02 Months: 6
Project
Details:
Multi-national supplier of condiments to major food
chains (McDonalds, Wendy's, Burger King, etc.) making
use of SAP WM Migration of SAP physical inventory
functionality (and custom development) to both RF
(real-time) as well as
off-line (batch) environments using hand-held barcode readers.
Proposal for implementation of new custom
functionality at middle-ware level. Responsibilities included:
• functional and technical
specifications,
• user interface development.
This entailed the following:
• Perform needs assessment
• Generation of business requirements documents
• Analyze and compare requirements with SAP standard
functionality
• Identify gaps and recommend (business process,
functional or technical) alternatives for addressing
them.
• Design and validate business process flow
• Identify source and target data, modifications (data
massaging) required
• Design and validate data flow
• Document functional and business requirements (data
sources, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
• Validation, scope adjustment and customer sign-off
• Document technical (non-functional) requirements
such as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
• Technology and solution demo / proof of concept
Technologies:
SAP-MM, Transformation Server (now IBM Infosphere), ETL / Change Data Capture / Data Replication,
MS-SQL Server, SQL / PL-SQL / Transact-SQL, X Modular,
SAP-WMS, SAP-SD, SAP-QM, SAP-Patches,
SAP-HR, Mobile Enablement, Middleware solution
Mandate
No: 20
Client: DataMirror
Industry: Transportation
Project: St-Lawrence Seaway - Mobile Enablement of SAP
Processes
Roles: Technical Analyst, Functional Analyst
Start
Date: 01-Apr-02 End Date: 31-Oct-02 Months: 7
Project
Details:
Mobile enablement of the following SAP processes:
Enter employee work time against the PM Work Order
Confirm completion of PM Orders
Update Notifications for Notification types M1, M2 and
M4 and TECO PM Order
Update PM orders
Goods Issues to Reservations
Addition of new material (unplanned material) to PM
Goods Issue to a Planned Order This entailed
performing the following:
Perform needs assessment
Generation of business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps.
Design and validate business process flow
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validation, scope adjustment and customer
sign-off
Technologies:
SAP-ABAP, SAP-Interface Development, Transformation
Server (now IBM Infosphere), ETL / Change Data
Capture / Data
Replication, X Modular, SAP-WMS, SAP-SD, SAP-PM, SAP-HR, Mobile Enablement
Mandate
No: 19
Client: DataMirror
Industry: Automotive
Project: Motovan-Mobile Enablement of SAP Processes
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Business Analyst
Start
Date: 01-Jan-02 End Date: 31-May-02 Months: 5
Project
Details:
Motovan wanted to migrate
their current SAP functionality for goods receipt and physical inventory cycle
counting to an RF-based infrastructure, and as a result of
business process review, streamline (where
possible) their goods receipt for PO process. This entailed:
Perform needs assessment
Generation of business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing the
gaps
Design and validate business process flow use case and
story boarding
Identify source and target data, modifications (data
massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)Validate and adjust scope
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Technology and solution demo / proof of concept
Presentation to stakeholders, and project team
Technologies:
SAP-MM, ETL / Change Data Capture / Data Replication,
MS-SQL Server, X Modular, SAP-WMS, SAP-SD,
SAP-IS-Auto,
Mobile Enablement
Mandate
No: 18
Client: Government of Canada – Canadian Space Agency
Industry: Space and Aerospace
Project: SAP-AMMIS Interface Development
Roles: Developer-ABAP, Developer-OOP, Pedagogical Consultant,
Solution Developer, Technical Analyst,
Project Manager, Functional Analyst, Strategic
Analyst, Business Analyst, Team Lead
Start
Date: 01-Jan-02 End Date: 30-Apr-02 Months: 4
Project
Details:
Elaboration and design of interfaces required for
maintaining AMMIS as the shop-floor system for ensuring
ongoing material and asset management operations, and SAP
(the Agency’s back-end ERP system).
In addition to initial legacy data loads, data
exchanges were required between the two systems on an
ongoing basis.
SAP-AMMIS Interface development:
• Master data conversion and load to SAP using LSMW,
and BDCs
• Asset Management: Legacy master data conversion and
load: Generation of Excel spreadsheets for
AMMIS initial data load
• SAP Extract of Asset Procurement Data for AMMIS
• SAP Asset Custodial Updates: SAP updates (data
conversion and upload) from AMMIS extract of asset
custodial records (including initial and subsequent
assignments)
• SAP Asset Value Adjustments: SAP updates (data
conversion and upload) from AMMIS extract of asset
data subsequent to value adjustments
• Material and goods receipts (data ETL – conversion
and updated to SAP using BDC)
• Nightly SAP Extract of Procurement Data for
Receiving
• SAP Daily Goods Receipt based on AMMIS Data
(extracted from AMMIS, converted and uploaded to SAP)
Technologies:
SAP-ABAP, SAP-Interface Development, EDI, SAP-MM, ETL
/ Change Data Capture / Data Replication,
Identity Management and User Security, Centura Team Developer & SQL Base, SQL / PL-SQL /
Transact-
SQL, X Modular, SAP-WMS, SAP-SD, Mobile Enablement,
DBA and Data Modelling, Middleware solution,
Data Conversion and Integration
Mandate
No: 17
Client: DataMirror
Industry: Manufacturing
Project: Tennant Corporation - Mobile Enablement of SAP
Processes
Roles: Solution Developer, Functional Analyst
Start
Date: 01-Jan-02 End Date: 31-Aug-02 Months: 8
Project
Details:
Feasibility study and evaluation for Tennant
Corporation to mobile enable their work force with respect to
the following SAP processes:
Service Order Processing,
Employee Time Tracking. This entailed the following:
Perform needs assessment
Generation of business requirements documents
Analyze and compare requirements with SAP standard
functionality
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
Design and validate business process flow
Identify source and target data, modifications (data
massaging) required
Design and validate data flow, and data conversion
requirements
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Validation, scope adjustment and customer
sign-off
Document technical (non-functional) requirements such
as security (access and roles), high availability
requirements, business continuity and disaster recovery strategies
Technology and solution demo / proof of concept
Presentation to stakeholders, and project team
Technologies:
SAP-MM, Transformation Server (now IBM Infosphere), ETL / Change Data Capture / Data Replication,
Point of Sale (POS), X Modular, SAP-WMS, SAP-PM,
SAP-HR, Mobile Enablement, Web Development
(HTML, XML, ASP, etc.)
Mandate
No: 16
Client: Government of Canada – R.C.M.P. United Nations
Peacekeeping Directorate
Industry: Police and Public Safety
Project: Migration of material management functionality (stock
issues and audits) to bar-code reading platform
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Strategic Analyst, Business
Analyst, Team Lead
Start
Date: 01-Dec-01 End Date: 31-Mar-02 Months: 4
Project
Details:
Migration of material management functionality (stock
issues and audits) to bar-code reading platform by
performing the following:
Perform business requirements analysis and generate BR
Documentation
Analyze, compare and recommend optimal hardware that
meets business requirements
Identify requirements and develop application to
transfer data from SQL-based relational database
management system to Palm-based barcode reading hardware.
Develop front end application (Palm) to enable barcode
capable warehouse operations: picking, goods
issue, returns, exchanges, stock replenishment, goods
receipt, put away, and stock audit
Implement barcode-printing capability.
Design screens for data capture on Symbol
SPT-1700.
Develop the application to read the captured data and
update the SQL-based relational database
management system.
Solution documentation and end-user training
(documentation, end-user / instruction manuals, and multi-
media for self-paced study
Technologies:
SAP-Interface Development, ETL / Change Data Capture /
Data Replication, Identity Management and
User Security, SQL / PL-SQL / Transact-SQL, X Modular,
Mobile Enablement
Mandate
No: 15
Client: Connexim
Industry: Professional Services
Project: Pedagogical Consultant: Connexim
Inc. (SAP MM / SD Overview)
Roles: Pedagogical Consultant, Functional Analyst
Start
Date: 01-Dec-01 End Date: 28-Feb-02 Months: 3
Project
Details:
Knowledge Transfer Presentations – MM and SD Concepts
in SAP Overview presentation of Material
Management (including APO, MRP and demand planning)
and Sales and Distribution modules in SAP.
Mandate Objective:
• give a high level training
of the relevant SAP processes, how they inter-relate and offer the client a
view
of the possibilities and potential pit-falls in new SAP
installations
• elaborate on best business practices and how they
align with client's business process flows (covering
master data, material management, warehouse processes - RF
and offline, sales order processing,
procurement for stock replenishment, goods receipt, put away
processes covering various storage
strategies such as FIFO and LIFO, physical inventory including
periodic and cycle counts, and MRP.
The deliverable consisted of on-site presentations to
both stakeholders and SME, process flows and
documentation.
Technologies:
SAP-MM, SAP-APO, MS-Office, X Modular, SAP-WMS,
SAP-SD, SAP-QM, Material Requirements
Optimization MRO, Mobile Enablement
Mandate
No: 14
Client: Government of Canada – Environment Canada
Industry: Public Sector
Project: Elaboration of Material Management Strategy and Policy
Roles: Strategic Analyst, Business Analyst
Start
Date: 01-Nov-01 End Date: 30-Apr-02 Months: 6
Project
Details:
Elaboration of a material management strategy to
ensure material management systems are in harmony
with the Treasury Board of Canada's new Financial
Information Strategy for Federal Departments. The
project was broken down into the following major phases:
• Assessment of current needs
• Analysis of Oracle Financials and the gaps/fit
analysis to be addressed
• Identification of driving forces and principal
factors to consider for successful execution of material
management functions by Environment Canada front-line managers
while ensuring compliance with
Treasury Board of Canada Policies.
• Development of the Material Management Strategy
Technologies:
SAP-Interface Development, MS-Office, X Modular
Mandate
No: 13
Client: Government of Canada – Canadian Space Agency
Industry: Space and Aerospace
Project: Analysis and Evaluation of Material Management Systems
Roles: Technical Analyst, Functional Analyst, Strategic
Analyst, Business Analyst
Start
Date: 01-Sep-01 End Date: 31-Dec-01 Months: 4
Project
Details:
Perform an in-depth analysis of business process
review and identify shortcomings between adopted best
business practices and material management systems currently
used to perform Inventory Control,
Shipping and Receiving, Customs and Excise,
Warehousing, Material Tracking and Hazardous Materials
Management functions.
Generate a functional as well as technical checklist
to evaluate the above material management systems
as well as future systems being considered.
Use the generated lists to evaluate the effectiveness
and efficiency of SAP's R/3 system (as it is currently
configured) vs. AMMIS as a possible alternative for some of the
systems in place
Supply recommendations and estimates of development
efforts required for implementing the systems such
that the client's business practices are met.
Technologies:
SAP-Interface Development, SAP-MM, SAP-AA, ETL /
Change Data Capture / Data Replication, Centura
Team Developer & SQL Base, SQL / PL-SQL /
Transact-SQL, X Modular, SAP-WMS
Mandate No: 12
Client: Government of Canada – R.C.M.P. Material Management
Directorate
Industry: Police and Public Safety
Project: Feasibility Study for Implementing WMS RF Devices
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Strategic Analyst, Business
Analyst
Start
Date: 01-Sep-01 End Date: 31-Dec-01 Months: 4
Project
Details:
Business requirements, solution design documentation,
and feasibility study (including analysis of options
for implementing wireless: RF access to SAP-R3 using
Intermec and Janus (DOS-Based) hand-held
barcode reading devices in a warehouse environment (SAP WM /
SD / MM). Identification of alternative
technologies to maximize return on investment (hardware and software).
Technologies:
SAP-MM, Transformation Server (now IBM Infosphere), ETL / Change Data Capture / Data Replication,
X
Modular, SAP-WMS, SAP-SD, SAP-Console, Mobile
Enablement, Infrastructure review / enhancement
Mandate
No: 11
Client: DataMirror
Industry: Pharmaceutical
Project: McNeil Consumer Products (Johnson and Johnson) -
Development of Wireless WMS Transactions
Roles: Developer-ABAP, Solution Developer, Technical Analyst,
Functional Analyst
Start
Date: 07-Aug-01 End Date: 04-Feb-02 Months: 7
Project
Details:
Development of SAP Console RF transactions:
Implementation of accepted proposal for implementation
of RF-based SAP material management /
warehouse functionality (Goods Issue – Goods Receipt) for
multi-national supplier of health care products.
Business requirements gathering, functional and
gap-fit analysis, development of scoping and
implementation proposal document (including elaboration of
infrastructure, and RF interfaces),
development.
Technologies:
SAP-MM, SAP-WMS, SAP-SD
Mandate
No: 10
Client: Jacob
Industry: Apparel
Project: SAP 4.6C Retail Pedagogical Consulting for Jacob Inc.
Roles: Pedagogical Consultant
Start
Date: 01-Aug-01 End Date: 31-Oct-01 Months: 3
Project
Details:
Pedagogical consulting and end-user (pre and post
Go-Live) support for Jacob clothes line (fashion
industry). Develop
documentation and training material to facilitate knowledge transfer to
employees using
SAP R/3 Version
4.6C – Retail system and Business Information Warehouse. The material developed
(both high level concepts as
well as step-by-step procedures) pertains mainly to allocation planning in SAP
Retail and consists of:
PowerPoint Presentations,
Documented Procedures,
Technologies:
SAP-MM, MS-Office, Point of Sale (POS), X Modular,
SAP-WMS, SAP-QM, SAP-IS-Retail
Mandate
No: 9
Client: Government of Canada – R.C.M.P. United Nations
Peacekeeping Directorate
Industry: Police and Public Safety
Project: Analysis for and development of automated inventory
control system
Roles: Solution Developer, Technical Analyst, Functional
Analyst, Solution Architect, Business Analyst
Start
Date: 01-May-01 End Date: 31-Jul-01 Months: 3
Project
Details:
Performance of all project phases for the development
and delivery of the solution.
Perform needs assessment
Generation of business requirements and solution
design documents (including flowcharts, proof of
concepts and prototyping).
Analysis of business process review and
architecture/infrastructure requirements
Data mining and identification of legacy data to be
transferred (ETL, conversion, one-time master data
load, recurring data transfers via interfaces, etc.)
Analysis of current market trends and aligning
development proposal with Treasury Board Directives and
Guidelines.
Elaboration of project plan for client review and
approval
Installation and configuration of SQL Relational
Database Management System (RDBMS).
Data modelling and development of database objects
(tables, views, stored procedures, and table triggers)
Object-Oriented Programming of approved functionality
(based on project specification proposal).
Quality assurance testing
Documentation (both user and technical), and end-user
training
Technologies:
SAP-Interface Development, SAP-MM, ETL / Change Data
Capture / Data Replication, Centura Team
Developer & SQL Base, SQL / PL-SQL / Transact-SQL,
X Modular, SAP-WMS, Mobile Enablement, Data
Conversion and Integration
Mandate
No: 8
Client: Government of Canada – R.C.M.P. United Nations
Peacekeeping Directorate
Industry: Police and Public Safety
Project: Master Data Load for Automated Inventory Control
System
Roles: Developer-OOP, Solution Developer, Technical Analyst,
Functional Analyst, Solution Architect, Team Lead
Start
Date: 02-Apr-01 End Date: 30-Sep-01 Months: 6
Project
Details:
Plan and execute the master data load processes
identified below for material, HR, and warehouse data.
Perform business requirements analysis, generate
business requirements and project technical
documentation.
Generate functional and technical specifications
documents (including architecture and infrastructure)
Identify source and target data,
conversions/modifications (data massaging) required
Design and validate data modelling and flow
Document functional and business requirements (data
sources, ETL and integration technologies,
architecture frameworks and landscapes, etc.)
Analysis and mapping/data modelling of source and
target data.
Validation, scope adjustment and customer
sign-off
Application development for legacy system data
extraction
Technologies:
MS-Office, ETL / Change Data Capture / Data
Replication, Centura Team Developer & SQL Base,
Point of
Sale (POS), X
Modular, Mobile Enablement, DBA and Data Modelling, Data Conversion and
Integration
Mandate No: 7
Client: Pièces
Métropolitaines / Au Foyer du Campeur
Industry: Retail
Project: Development of Material Management and POS Solution
Roles: Developer-OOP, Pedagogical Consultant, Solution
Developer, Technical Analyst, Project Manager,
Functional Analyst, Solution Architect, Strategic
Analyst, Business Analyst, Team Lead
Start
Date: 01-Jan-01 End Date: 31-Jul-02 Months: 19
Project
Details:
Development of full-scale material management / POS
system. The project consisted of automating the
entire material life cycle process (acquisition, processing,
warehousing, sales, inventory control, stock
replenishment and management reporting from scratch).
Business process review and needs analysis
Hardware and software recommendations and acquisition
Installation of RDBMS and creation of tables, stored
commands and procedures.
Development of object-oriented coding to execute the
desired functionality (including user-interfaces, auto
backup and restores, and file-based EDI for updating
inventory master records from suppliers).
Quality assurance testing,
Documentation,
End-user training
Post-implementation support. This entailed the
following:
Perform needs assessment
Generation of business requirements documents
Identify gaps and recommend (business process,
functional or technical) alternatives for addressing them
Design and validate business process flow
Identify source and target data, modifications
(conversions, data massaging) required
Design and validate data flow
Document functional requirements (data sources, ETL
and integration technologies, architecture
frameworks and landscapes, etc.)
Technologies:
EDI, ETL / Change Data Capture / Data Replication,
Network (wired/wireless/security/firewall), Identity
Management and User Security, Centura
Team Developer & SQL Base, Point of Sale (POS), Material
Requirements Optimization MRO, Mobile Enablement,
Infrastructure review / enhancement, DBA and Data
Modelling, Data Conversion and Integration
Mandate
No: 6
Client: Datahorse International (DHI) / SAIPX
Industry: Professional Services
Project: RCMP Upgrade to R/3 (4.6)
Roles: Developer-ABAP, Technical Analyst
Start
Date: 01-Sep-00 End Date: 30-Nov-00 Months: 3
Project
Details:
Custom code validation adjustment and testing to
ensure post upgrade success of ABAP programs. Among
the various technologies, we find:
Dialog programming
BDCs
IDocs
List reporting
Application of OSS Notes
Technologies:
SAP-ABAP, X Modular, SAP-Basis
Mandate
No: 5
Client: Prevost
Industry: Transportation
Project: Prevost Car - Internet Transaction Server Online
Ordering
Roles: Developer-ABAP, Pedagogical Consultant, Solution
Developer, Technical Analyst, Functional Analyst
Start
Date: 01-Apr-00 End Date: 31-Oct-00 Months: 7
Project
Details:
Implementation of a client-facing website for ordering
parts using the SAP Online Store and ITS
infrastructure. This mandate
not only consisted of ascertaining the business requirements and functional
specifications, but also developing the entire solution, documenting
it and delivering end-user training
(user manual, mentoring SMEs,
PowerPoint presentation, train the trainer, etc. Tasks consisted of multiple
technologies:
ABAP development
Web and gateway server installations
Front-end development (web pages, MIME objects, Java
connections, etc.)
Liaising with web hosting and ISP partners.
Technologies:
SAP-ABAP, SAP-MM, SAP-SD, Web Development (HTML, XML,
ASP, etc.)
Mandate
No: 4
Client: Datahorse International (DHI) / SAIPX
Industry: Professional Services
Project: ReportScape Development
Roles: Developer-ABAP, Pedagogical Consultant, Solution
Developer, Technical Analyst, Functional Analyst,
Team Lead
Start
Date: 01-Oct-99 End Date: 31-Oct-00 Months: 13
Project
Details:
Development of a bolt-on solution for SAP that uses
DDE to dynamically extract data from SAP and display
it in Word place holders allowing users to report SAP
data within Word. Development of:
• SAP-sided ABAP CODE
• OLE interface
• Technical and installation documentation
• End-user training manuals
• Multi-media knowledge transfer.
Technologies:
SAP-MM, MS-Office, X Modular
Mandate
No: 3
Client: Bell Canada
Industry: Telecommunications
Project: Bell Canada – Disaster Recovery Strategy
Roles: Technical Analyst, Strategic Analyst
Start
Date: 01-Jun-99 End Date: 29-Sep-99 Months: 4
Project
Details:
Develop the policies and procedures required to
implement disaster recovery for the Genesis project (SAP
Production)
Technologies:
X Modular, SAP-Basis
Mandate
No: 2
Client: Bell Canada
Industry: Telecommunications
Project: Bell Canada – SAP Implementation (Genesis Project)
Roles: Developer-ABAP, Solution Developer, Technical Analyst,
Functional Analyst
Start
Date: 01-Oct-98 End Date: 30-Jun-99 Months: 9
Project
Details:
ABAP developer responsible for:
Identification and documentation of technical
requirements (for client and team lead approval) based on
business requirements and functional documents.
Development was mainly related to FI-CO, MM, SD, and
WM SAP modules.
Development of ABAP-based Vendor Managed Inventory
(VMI) solution aimed at rating vendor
performance based on goods movements, receipts and delays.
This consisted of list reporting as well as an Excel
interface for graphical reporting, as well as optimization
of code and job scheduling
Technologies:
SAP-ABAP, SAP-MM, MS-Office, SAP-QM, Data Conversion
and Integration
Mandate
No: 1
Client: Government of Canada – Canadian Space Agency
Industry: Space and Aerospace
Project: Canadian Space Agency: Head of Logistics and Material
Management
Roles: Developer-OOP, Pedagogical Consultant, Solution
Developer, Technical Analyst, Project Manager,
Functional Analyst, Strategic Analyst, Business
Analyst, Team Lead
Start
Date: 01-Sep-90 End Date: 31-Oct-98 Months: 98
Project
Details:
Head of Material Management and Logistics at the
Canadian Space Agency responsible for ensuring
ongoing logistics/services in the following areas:
Asset Management,
Consumables supplies,
Shipping and Receiving,
Warehouse Management,
Hazardous Materials,
Customs and Excise
Elaboration and evaluation of statements of work for
sub-contractors and outsourcing partners Supervision
of contractors (contractor assessments), and employees
(performance management evaluations)
Generation and management of project plans covering
material management contributions to various
projects and missions
Seconded to Treasury Board of Canada as SAP-MM and
SAP-AA subject matter expert for IFMS (federal
initiative for SAP roll out to 17 federal departments)
SAP - MM and AA Subject matter expert for SAP rollout
at CSA Throughout my tenure, I had the honor of
participating in the successful delivery of:
One Satellite Mission: $300M (approx.)
7 Human Space missions that can easily reach $200M
each
Technologies:
SAP-ABAP, SAP-Interface Development, EDI, SAP-MM,
SAP-AA, ETL / Change Data Capture / Data
Replication, Centura Team
Developer & SQL Base, X Modular, SAP-WMS, Material Requirements
Optimization MRO, Mobile Enablement, Web Development
(HTML, XML, ASP, etc.)
Over 93 % of our customers
are repeat customers
Projects / Clients / SAP Modules
Download Excel
Spreadsheet