- Maintenance of all Cognos reporting on Sales, Purchasing, Finance and WMS- Configure Elite (ERP) on custom functionalities- Create Shopify Dashboard for E-Commerce Team- Create and ensure inventory data integration between Elite and 3rd party sites- Salsify PIM in-house Subject Matter Expert- Train user community on Elite system

- Integrated Sales Divisional data with existing Cognos Cubes and provide improved operational insight for Finance.- Enhanced Cognos Cube in-memory performance by segregating current and historical data.- Built Warehouse Management (WMS) "Operator Labor Summary" excel report for Supply Chain for increased visibility of warehouse personnel against standards.- Created new Priya WMS reports leveraging Crystal Reports.- Developed integration of 3PL shipping details with legacy ERP.- Managed the EDI system for AS2/VAN customer base of 100+

I was responsible for the understanding of the business needs, assessing their impacts, acquiring, analyzing and documenting the requirements, and executing the communications, testing, training and delivery to the appropriate stakeholders.Analytics and Decision Support SME for Customer Service, Finance, Customer Facing Supply Chain (CFSC) and Sales teams• Sales and Supply Chain Wal-Mart “National Sales Business Overview”weekly dashboard with insight to key POS consumer indicators for the immediate execution of purchasing corrections• Sales Field Wal-Mart “No POS for 4 Weeks” and “Store Level Inventory”reports for improved visibility of the true physical inventories and greater assurance of On-Shelf Availability• Supply Chain and Account Manager Wal-Mart “Five Week Forecast Variance” report for increased Buyer accuracy of actual vs. purchase demandsData Standards/Data Management (DSDM) for Customer, Material and Vendor data• Collaborated with Customer Service on a new SAP Manual Order Creation process by integrating existing solutions for a yearly time savings of 33%• Provided the Master Data Team monthly KPI reports on data accuracy,integrity and 1st Time-Right for Customer, Vendor and Material• Presented training sessions to the Master Data Team on SAP R/3 Customer standards and enhancements• Migrated legacy data to SAP for Customer and FICO COPA data objects• Ensured daily delivery of SAP Pricing Conditions report for corrections EDI technical, on-site support and related SAP business processes• Primary contact for all EDI daily issues, concerns and consultations with Customer, Customer Service, Finance and EDI Development Team. Evaluation, prioritization and communication were key elements in maintaining customer relationships• Successfully implemented and coordinated all resources on the SAP Vendor enhancement for emailing of EDI remittances resulting in cost reductions of$13,800/year

- Produced legacy BPCS Customer and Financial data mappings for conversion to SAP. This provided a migration framework between the business and ETL group.- Conducted on-going meetings with Customer Service and Finance for data preparation prior to SAP loads to ensure data consistency and cleansed in accordance to SAP standards.Performed data validation of SAP loads for data quality, adherence to standards and 100% accuracy of loads.- Supported legacy EDI business and technical issues for Customer,Customer Service and Warehouse to ensure business continuity with the timely transmission of documents. Each issue was assessed, prioritized and communicated with scope of impact and time to resolution.- Initiated Knowledge Transfer sessions with Customer Service for process improvements, the use of existing tools, and changes in business processes. These sessions created efficiencies and alignment for the CS Team.

- Enhanced the Woods-Gordon Order Entry system for complete integration of the Warehouse Management System (WMS) using MQSeries.- Communicated with US IT, Canadian IT and other business- Subject Matter Experts for project knowledge acquisition.- Developed new applications to interface Order Entry applications with WMS Transaction Sets.- Documented and instructed on all new features and process changes to the existing Order Management System to Customer Service Representatives.- Built communication architecture to support both production and test environments for error reporting.- Accountable for on-going Mississauga WMS Production support.- Transferred Order Entry and WMS knowledge to IT support staff.- Analyzed and configured the environment settings for the successful implementation of WMS in Innisfail, Alberta.

I was responsible for 3 Siebel environments to ensure all Siebel, Citrix,Resonate, Actuate, Gateway and Database servers are available and problem-free. Other functions included database administration, server installation andconfiguration, scheduling of maintenance upgrades and communicating withthe Siebel Technical Account Manager.- Responsible for creation, integration and support of new customer facing order entry web application for ARAMARK Canada. This allowed for the retention of a $3.2 million customer.- Reconfigured the Microsoft Cluster Server for correct fail-over of resources to ensure application availability and user preferences were retained.- Resolved DB2 Training Environment Control Centre issue with Database Administrator and Consultant allowing Production refreshes.- Implemented LDAP solution for Password Warnings and self-administration of passwords.- Created a monitor and broadcast messaging solution for Siebel Object Managers when not running or shutdown.- Resolved Siebel Server memory leak issue ensuring a stable, consistent user environment.

I was responsible for the system integration between BPCS, Data Warehouse and Siebel systems. This included the creation of process documentation and error touch-points for Help Desk assistance.- Analyzed and established the necessary business entities and business rules for the Siebel integration project.- Evaluated and designed the data flow processes between Canadian BPCS units and Siebel.- Accountable for all support tasks during the post-production support phase of Siebel project.- Gathered hardware infrastructure requirements and integrated Citrix solution with Siebel Call Centre roll-out in Cincinnati, Ohio.- Created customized trigger programs on the AS/400 for file and field auditing for Siebel/BPCS data synchronization.

I coordinated the staffing of programmers on various Canadian projects and managed a staff of three.- Established a Change Control Management policy in coordination with Senior IT Managers.- Gathered and documented requirements from business leads and ensured projects met budget and time constraints.- Accountable for all current Sagent ETL tasks for Data Warehouse and Hand-Held project, and future development plans.- Educated programmers on MQSeries and how to implement within the existing environment.

I was accountable for all Canadian BPCS/Prism ERP applications and supervised a team of three AS/400 programmers and one consultant.- Managed and prioritized all Canadian Business Unit requirements, and reported on weekly progress reports.- Responsible for the selection, retention and development of programmer sand provided yearly performance reviews.- Designed Business Systems requirements for programmers.- Coordinated projects with 34 IT programmers and managers in Oakville and Plymouth, Michigan.- Created a Y2K Disaster Recovery Plan with AS/400 Security Officer.

I provided AS/400 BPCS support for ABS, LED, Corporate, Pricing, Billing and Product Promotions.- Upgraded Order Entry System to integrate with Freight Delivery System for delivery consolidation and freight cost reduction.- Enhanced legacy systems and reports as part of post-integration maintenance.- Maintained scheduled jobs using Robot.

I worked within a team environment for maintenance of the Customer Core applications.•- Developed and implemented “Guiding Point” specifications document.- Assisted in object promotions from Test to User Acceptance Testing (UAT)environments.- Created Address Parsing program to recognize various address format breakdowns.

I created and maintained existing programs, routines and reports for the ISIS system.- Member of the systems conversion team on the integration of two corporate systems.- Maintained and monitored POS EDI data using Premenos.- Coordinated the creation of new Bay, Sears and Eaton’s labels in accordance with freight regulations.

- Provided AS/400 support for in-house programs, routines and reports.- Applied journaling concepts to schedule file maintenance within a distributed environment.- Educated IT members on triggers and referential integrity concepts.

- Monitored system operations and communications- Maintained AS/400 system security and provided infrastructure user support.