JJ AMES SS COTT WW I L L I AMSON

acvfh6@r.postjobfree.com : 421-349 McLeod St, Ottawa ON K2P 0S1 : 613-***-**** PROFESSIONAL EXPERIENCE

New Democratic Party of Canada : IT Coordinator : Ottawa, ON : 2006–Now Database Development Management (2013-Now):

• Project Manager of the multi-million dollar development of new NDP Election Database based on a Web front end & PostgreSQL backend and using CloverETL for data migration, match, merging, extract, transform and loading.

• Managing budget spend and tracking, staffing, team meetings, scope, development, testing and deployment

• Managing 5 direct NDP staff and multiple vendor teams to ensure the success of the project

• Databases: PostgreSQL, MS Access

IT Management (2006-2013):

• $350k+ Budgeting for the NDP’s IT needs for local and off-site staff as well as during elections & conventions

• Procuring IT related contracts, vendor, software and hardware selection, negotiations of services & pricing

• Strategic planning, architecture and design of IT needs of the enterprise

• Coordinate with IT staff at Federal office, Parliament Hill and other provincial party sections.

• Advanced Excel 2013 Support, including purchasing of Abelbits & ASAP uti l ities for Excel

• Databases: Dynamics CRM (MS SQL), Dynamics GP (MS SQL), Salesforce.com (Oracle), MS Access Wakefield Community Centre : Teacher : Wakefield, QC : 2013

• Taught "Introduction to Computers" workshop once a week to 12 seniors who where new to computers

• Self wrote the curriculum from scratch to convey complex topics in way for beginners to understand: The Bradford Group : IT Manager & Network Analyst : London, ON : 2003–2006

• Manage all IT related duties (Data, Telecom, Windows, Unix & Mainframe) for a 200-person call centre

• Level 1 & 2 tech support for local issues and Level 3 for the enterprise as a whole (several US cities).

• Advanced Excel & Word work creating complex statistics spreadsheets and other documents for the centre.

• Mange the IT Help Desk through “Team Track” for the entire 1000 person enterprise located in North America.

• Primary Call Center analyst working with Cisco, AT&T, Callisma & Datacom to implement a total replacement of our aging Nortel based phone system to a Cisco based IPCC (VoIP) based product. Origin Technology / Disus : Baan Software Developer/Consultant : Mississauga, ON : 1997–2002

• ***Software development project detai ls on the next page***

• Customized BaanERP (Enterprise Resource Planning) software. Baan is similar to SAP & Peoplesoft

• Projects were $30 million dollars in scope with average ROI of $25 million/year in effeciencies post implimentation

• Major clients: International Paper, Ricoh, Nortel Networks, Digital Security Controls, Baker Refractories, Tri-Ed, Baan Automotive, Sonoco Flexible Packaging, Manufacturers’ Services Ltd, Crown Equipment & Intermec Technologies

• Developed functional requirements, specs and designs for implementing, fixing and enhancing BaanERP systems.

• As Business/Technical liaison I determed what business needs are technically feasible and ensuring developers understood business goals while translating complex developer feedback into business terminology for stakeholders.

• Developed and implemented bolt-on solutions and interfaces between Baan, legacy and third party systems.

• Customization, bug fixes, unit testing, and integration testing as well as training key business people.

• Databases: Oracle, Informix & DB2

Math & Science Academy : Manager & Tutor : Mississauga, ON : 1995–1996

• Tutoring students in math & physics after school and weekends at two schools

• Specializing in math grade 10-12, OAC Algebra, Calculus & Physics but teaching as young as grade 2

• Managing both schools full-time for 3 weeks during owner’s vacation then part-time from then on. Bel l Canada : Senior Control Centre Supervisor : Toronto, ON : 1991–1994

• Supervised day staff specifically and all staff in general (7 people) for the 24 hour operation.

• Wrote training & instruction manuals for tracking the information in a custom built database.

• Monitoring, and programming of computers in Win3.1, DOS and XENIX EDUCATION, TRAINING & AWARDS

• Alliance française : French A1.1 : Ottawa, ON : 2012

• Salesforce : Salesforce Administration & Development : Toronto, ON : 2010

• Manfacturers’ Service Ltd. : Letter of Recommendation : Sandstone, VA : 2000

• International Paper : Letter of Recommendation : Franklin, VA : 1999

• Baan : Baan IV ERP Business Development : Mississauga, ON : 1997

• C.I.C.T. : UNIX System Admin & “C” : Mississauga, ON : 1996

• University of Toronto : Bachelor of Engineering (Electrical) : Toronto, ON : 1994

• University of Toronto : Bachelor of Science (Astrophysics) : Toronto, ON : 1987

• Lord Dorchester Secondary : 97% Average, Cartier Scholarship : Dorchester, ON : 1986 SOFTWARE DEVELOPMENT PROJECTS:

International Paper : Franklin, VA : (1.5 years)

***Received a letter of reference for my work (attached

• Design, specifications, development, consultation, personal/unit/integration testing & debugging, go live implementation, follow up support & debugging, training in-house developers & high end users

• Data migration of Customers, Consignees, and Stock Items.

• Interfaces for Planned Receipts, Items & Inventory Position to the MIMI production scheduling system.

• Baan Available to Promise on Sales Orders (SLS), Sales Quotes (QUO) & Production Orders (SFC) via an IBM MQ-Series Proxy Server to pass messages to and from the MIMI production scheduling system in real-time.

• Based on a common Oracle view for Sales (SLS), Production (SFC) and Replenishment (RPL) orders to extract (batched) data based on Adds/Changes/Deletes of Orders captured by (real-time) Oracle Triggers.

• I had to remap one Baan Order to multiple Legacy Orders based on complex restrictions in the legacy ordering system. A cross reference was maintained along with complex transformation rules.

• Customers, Consignees, Order Balance, Corporate Credit, Order Planning, Product and Customer Allocation. Changes were captured by Oracle triggers in real time and passed in batch mode to the legacy systems.

• 22 Data Warehousing sessions which were loaded nightly and passed by via Oracle staging tables.

• Delivery Addresses via Legacy EDI was linked via Oracle triggers to the Consignee Interface Digital Security Controls : Concord, ON : (8 months)

• Part of a team that designed and developed a bolt-on Repairs and Returns module for DSC’s multi-company environment and was showcased at Baan World Users conference in Toronto.

• The Repairs and Return module was designed with flexibility to use a newly created RMA order steps table, which allowed sessions to be run in any order and for different RMA processes for each of their companies.

• Along with this, ‘disposition’ tables were created for verification, approvals and repairs decision points. A matrix would be set up with all possible combinations of attributes (repairable, scrap, credit, exchange, 3rd party) and based on that determine what the next step in the process was where straight order steps were insufficient.

• Limited integration with Standard Baan (S/O and P/O generation, no inventory impact)

• Auto conversion of cryptic alphanumeric date codes for warranty calculations

• Bug fixes and enhancements to the Repairs and Returns module as well as to other preexisting customizations. Tri-Ed : Mississauga, ON : (4 months)

• Part of a team that reworked DSC’s Repairs & Returns module to function under Tried’s business model.

• Mainly changes for auto skid generation, where the S/O and P/O generation was done, and handling of over the counter orders, which was not considered in the DSC process. Baker Refractories : York, PA : (4 months)

• Designed and developed bolt-on Freight Management System and bolt-on Extended Pricing System. Baan Automotive : Detroit, MI : (3 months)

• Bug fixes and writing help text on BaanIVc Supply Chain enhancements for the automotive sector.

• This included both the Supply Chain Sales and Purchasing modules along with some Baan EDI testing. Crown Equipment : New Breman, OH : (7 weeks)

• Testing of MRP (Manufacturing Resource Planning) customizations fixes

• Fixed a problem with the Hours Accounting Function Server where it did not write error records.

• Fixed a problem with the International Trucking Association (ITA) Interface. Manufacturers’ Services Ltd : Richmond, VA : (6 weeks)

***Received a letter of reference for my work (attached

• MSL was in a major time crunch brought on by last minute requirements from their supplier (HP) to create direct shipment model in Baan-they were currently shipping to distribution centres. We worked with vague ideas jotted down and no functional designs. We were under intense pressure to complete a stable fully functional system from scratch in 6 weeks or less, which we accomplished!

• Learned ZPLII to write Baan reports to communicate with Zebra label/barcode printer due to lack of drivers.

• Designed, documented and wrote 14 manufacturing & shipping modules Intermec Technologies : Mississauga, ON : (3 weeks)

• Enhancements designed and implemented in distribution along with minor bug fixes. Nortel Networks : Toronto, ON : (2 weeks)

• EDI Unit Testing done at the Origin offices.

Ricoh Canada : Toronto, ON : (1 week)

• Retrofitting of new standard BaanERP patches with their customizations from the Origin offices. Sonoco Flexible Packaging : Toronto, ON : (1 week)

• Writing Functional Design from Functional Requirement for Enhancements to PCS & SFC Planning Systems.

Contact this candidate