Candidates About

Christopher Thomas Downey

EXPERIENCE

April 2015 – November 2016, Contract: Oracle EBS ERP Functional Analyst, Converge, Peabody, MA

·         R11.0.3 to R12.2.4 Reimplementation Oracle EBS: NA/EMEA/APAC: GL, AR, AP, Credit, Advanced Collections, Inventory, OM, Shipping Execution, PO. Project management, requirements gathering sessions, solution design, configurations, business process re-engineering, end user training, CRP/end user testing sessions, technical and end user documentation preparation.

October 2014 – March 2015, Contract: Oracle EBS ERP AR Functional Analyst, Agropur Inc., Longueuil QC

·         R11.5.10 to R12.1.3 Reimplementation: Report specifications, solutioning, functional setups, SIT/UAT/Production testing.

March 2012 – March 2014, Contract: Oracle EBS ERP Team Lead/Functional Analyst, Marsh & McLennan Companies Inc., Toronto, ON

·         Twenty-three OU/nineteen book instance consolidation R2R and O2C Team Lead R11.5.10; supervision of three staff; project plan development; fit/gap document preparation based on interviews with SME’s/GPO’s; gap analysis prioritization, solutioning and process recommendations; conduct weekly status meetings with Program Manager/GPO’s; document existing configurations/customizations using Panaya and ConfigSnapshot; functional/technical specifications for gap, data conversion and new interface development; liase with DBA’s/Developers regarding technical issues; SR/patch management; development of test scenarios and regression/user acceptance test execution; system configuration; user training; risk mitigation; cut-over plan development and execution.

·         Forty-five country upgrade R11.5.10 to R12.1.3, O2C, Vertex, EBTax, new implementation of Advanced Collections/Territory Management: Lead SME/GPO requirements gathering sessions; functional/technical specification development; lead CRP; test scenario development and UAT execution; final cut-over and configuration.

February 2008 – December 2010, August 2011 – June 2012, Contract: Oracle EBS ERP Program Manager/Team Lead/Functional Analyst, Verint Systems Inc., New York/ Atlanta

·         Oracle 11.5.10 PO/AP: Re-engineering of P2P processes/implementation including vendor master validation, ACH, interfaces for freight and telecom billing, blank stock payment documents, AME approval, 3-way matching, fax server, OM process improvements: project plan development and management; document current and new processes; prepare functional/technical specifications and liase with Development staff; conduct user training sessions; lead CRP/UAT sessions; Vendor Master conversions and cleansing activity; Production cut-over.

·         Revenue Recognition: Implementation of custom revenue recognition application: run and document functional requirement sessions with SME’s; unit/UAT testing sessions; conduct end user training sessions; production cut-over and post go-live support.

·         Billing and Presentment: Implementation of custom billing front end and Oracle Bill Presentment: run and document functional requirement sessions with SME’s; unit/UAT testing sessions; conduct end user training sessions; production cut-over and post go-live support.

·          AP implementation - Brazil: Full project management and functional responsibilities.

·         CM: bank reconciliation, cash forecasting.

September 2007 – January 2008, Contract: Oracle EBS ERP Functional Analyst, Trecata Inc., Toronto, ON

·         Oracle 11.5.10 Inv/AME: Configuration of AME for use with SSHR Appraisals, AP Invoice approvals.

·         Wrote Performance Management appraisal setup and user guide.

·         Oracle 11.5.10 BEN: Advanced Benefits Total Compensation configuration and testing.

May 2004 – May 2005, July 2005 – January 2007, Contract: Oracle EBS ERP Team Lead/Functional/Test Analyst, Mercer Human Resource Consulting, Toronto, ON

·         Oracle 11.5.10 GL/AR/FA/CM: Implementation of Canada, Australia and New Zealand. Business process review, functional specifications and documentation, functional setup, QA, change management, UAT support, AR/FA/GL data migration, Production cutover tasks and support.

·         Oracle 11.5.10 GL/AR/AP, Oracle Enterprise 9.2: Upgrade from 11.5.8 to 11.5.10. Interface and Oracle module regression testing, UAT support.

·         Oracle 11.5.8 GL/AR/AP: Migration of interfaces from legacy client billing system to new global client billing application. QA, UAT support, change management and regression testing.

·         Oracle 11.5.8 GL/AR/AP/CM: Maintain and support North American and UK operations. System Administration, Report development (Developer 6i), Customer/AR interface support (PLSQL Developer 5.1.6.7), Change management, SR management.

·         Development of data warehouse PLSQL load scripts, specification templates, PLSQL / MS Project (9.0) management reporting suite, user guides.

November 2003 – December 2003, Contract: Oracle EBS ERP Functional Analyst, Lucent Technologies, Ireland

·         Transition Oracle applications 11.0.3 support (Financials/Distribution/Manufacturing, custom interfaces) from US to Dublin, Ireland support team.

·         Review of current implementation for inefficiencies and general clean-up (interface tables, scheduled concurrent requests, process automation).

October 1997 – September 2003, Contract: Oracle EBS ERP Program Manager/Team Leader/Functional Analyst, Alias Systems Inc., Toronto, ON

·       Oracle iExpense11.0.3: Analysis and configuration for North American implementation.

·       Custom Royalty Calculation and Payment tracking system: Full life cycle implementation based on AR transactions, rule sets maintained in AR Memo Lines context sensitive flexfields. Written in PL/SQL and Oracle Reports.

·       OE 11.0.3/Oracle Enterprise 8.0.5 implementation in seven legal entities: UK, France, Italy, Germany, Canada, USA and Japan: Project Management: planning, resource organisation and allocation (team of three), integration, functional review, IT/Client liaison, testing co-ordination and execution review. Business/Functional/Technical: Gather business requirements, complete gap analysis, re-engineer business processes, OE/INV/BOM module configuration, custom responsibility/menu definitions, write functional/technical specs, Customer/Order/AR transaction interface analysis and design to custom product install base, integration of custom revenue recognition/reallocation processes and Management reporting, custom report development (Oracle Reports 2.5), unit/system/regression test management and script contributor, patch management and application, technical assistance request (SR) management, train Finance and Sales Support (order processing) personnel, production cut-over and post-implementation support.

·         11.0.3 to 11i Upgrade Assessment: Review and report on the functional and technical implications. Assess the upgrade effort on current processes and customisations.

·         Belgium, France, Germany and Italy legal entity transition to Euro functional (Oracle MRC/EFC): Project management: transition planning, resource scheduling (DBA, Junior Analyst), functional review, IT/client liaison, risk mitigation, status reporting, testing co-ordination. Functional/Technical: establish Euro reporting books, define posting and consolidation processes, conversion of National Currency Unit (NCU) books to reporting books, establish Euro Statutory and Management books, patch application, migration of custom reports, train Finance personnel, SR management, manage and participate in unit/system/regression testing, production cut-over and post implementation support.

·      Conversion of Canadian operating unit into two distinct organisations, Canada and Asia Pacific: Document business requirements, complete gap analysis, map/define business processes, configuration of new Asia Pacific operating unit AR and AP modules, custom responsibility and menu definitions, analysis and code modifications for Customer/AR transaction interfaces to custom product install base, SR management, unit/system/regression test management, data migration from existing Canadian operating unit to new Asia Pacific operating unit, production cut-over and post implementation support.

·       Upgrade Oracle Financials 10.7/7.3.4 to 11.0.3/8.0.5: eight legal entities (eight statutory books, seven management books), eight operating units, GL/AX/AR/AP/FA/CM/ADI/ European localizations, North America and Japan: Project management: transition planning, issue escalation, risk mitigation, resource allocation. Business/Functional/Technical: evaluation of schema changes and functional enhancements on current business processes and custom code, recommend and implement new functionality, migrate Customer/AR transaction interface code and reports to new release, train Finance staff on use of new GUI and application functionality, unit/system/regression test management, cut-over management and post implementation support.

·       Japanese implementation of Oracle Financials 10.7 GL, AR and AP: Project management: plan preparation, resource allocation and planning, IT/Client liaison, status reporting, issue escalation. Business/Functional/Technical: document business requirements, complete gap analysis, application configuration, define new business processes, write functional/technical specs, Customer/AR transaction interface integration to custom product install base, SR management, unit/system test management, train Japanese Finance personnel, production cut-over and post implementation support.

·       Technical/Functional responsibilities in implementation of Oracle Financials 10.7 GL, AP and AR in Belgium, France, Italy, Germany and the UK on a single multi-org/multi-set of book instance with Localizations and Global Accounting Engine installed, Oracle 7.3.4: AR/AP/GL/AX module configuration. Custom reports and modifications, incorporation of NLS (translated) statutory reports, SR and patch management, menu and responsibility customisations, user set up, end user support and Customer/AR transaction interface integration to custom order management and install base.

·       Technical Analyst: migration of North American Oracle Financials GL, AR, AP and FA 10.6 to 10.7: Code modifications for AR transaction/Customer interfaces to custom order entry/install base, custom report migrations (SQL/Oracle Reports), patch application, SR management, unit/system/regression test management, assist in production cut-over, and post-implementation support.

·       Maintenance contract revenue reallocation/recognition applications for eight operating units: Gather business requirements, design and code custom revenue recognition and revenue reallocation applications (PL/SQL), populate GL interface table, wrote maintenance contract revenue forecasting reports (Oracle Reports), convert contract data maintained in spreadsheets to the AR subledger, unit/system test management and production cut-over.

·       Implement Customer/AR transaction interface from custom order management/install base for eight operating units: Analyse, write functional/technical specs, re-design, code (PL/SQL), unit/system test, train Finance Personnel and cut over to production.

·       Recommendations on Oracle Financials/Distribution modules use of out-of-box functionality to satisfy new user requirements and custom solutions where necessary.

·       VAT/Sales Tax: configuration, maintenance, standard reporting and filing support for Belgium (+ Allocate/Reallocate; Monthly VAT Preparation, Sales Ledger, Purchase Ledger, ESL, Annual VAT Return declarations/reports), France (+ DAS2), Italy (+ Purchase/Sales VAT Registers and definitions, VAT Summary Report, Deferred VAT Register, Annual Customer List), Germany, UK, US (+ location tax rate interface), Canada and Japan.

·       Miscellaneous Oracle Financials activities: AR lockbox implementation, Y2K compliance.

·       Customisations: flexfield set-up/re-organisations, modify existing documents: invoices, bank remittances, cheques, statements, Dunning letters, EFT formats, Wire Transfer notifications (Oracle Reports 2.5), consolidated world-wide AR detail and maintenance contract revenue forecasting in US$, various other reports and ad-hoc reporting using SQL/PLSQL and (Oracle Reports 2.5).

·       Contract staff supervision.

·       Completed initial configuration of Oracle’s Project Costing/Billing: Responsible for all analysis and configuration activities. (This module was never implemented in production due to a company restructuring.)

January 1993 - May 1997 Permanent, June 1997 - September 1997: Contract: Business/Information Systems Analyst, Silicon Graphics Limited, Toronto, ON

·       Supervised Network Specialist and Information Systems Analyst.

·       Oracle EBS ERP Financials 10.5 implementation (GL, AR, FA): Compile Canadian business requirements, write functional/technical specs, gap analysis and provide post-implementation support.

·      Sales force automation using MS Office, ACT and Crystal Reports as a prospecting, sales funnel/contact management system: Hardware and software evaluation and recommendations, requirements gathering, analysis, design, define sales lead and funnel management reports.

·       LAN (Ethernet)/WAN (Frame-Relay)/ISDN implementation and management.

·       Application maintenance and development: Canadian GST reporting on warranty parts (Progress), Wingz (spreadsheet) macro driven graphical management reporting system.

·       Application/hardware support of 110 UNIX workstations and 40 notebooks.

·       UNIX administration (DNS, NIS, NFS, Sendmail)/tuning/shell scripting.

·       User training: Trilogy sales quoting and configuration software, ACT Prospecting, Showcase, UNIX, MS Windows 95, MS Office, productivity tools.

·       Other responsibilities: Management revenue and OPEX reporting, support all applications in use by the Canadian organisation, data extraction and reporting from various Progress, Sybase and MAXCIM databases using report writers and SQL.

November 1990 - December 1992: Supervisor, Micro Systems/ Functional Specialist, IKO Industries Limited, Brampton, ON

·       Supervised Programmer/Analyst, Support Co-ordinator and Hardware Support Technician.

·       Implement Trend financials/distribution GL/AR/AP/OE/PO/INV modules (head office and five wholesale outlets): Project management: plan development and organization, resource scheduling and co-ordination (team of three), functional review, issue escalation/resolution, risk mitigation, status reporting, IT/Client liaison. Business/Functional: business process review, gap analysis, functional/technical specs, configuration, training, data conversion from IBM System 36, patching and bug resolution, unit/system test management, cut-over and post implementation support.

·       Design, code and maintain Progress applications for production reporting and payroll on Windows and UNIX platforms.

·       SCO UNIX system tuning, administration and shell scripting.

·       Hardware/software evaluation and purchase negotiations.

·       Application support and trouble-shooting.

·       User training: MS Office, Trend.

·       Wrote technical and user documentation.

August 1987 - October 1990: Project Manager/Senior Business Analyst/Functional Specialist/Developer, Integrated Systems Group Inc., Toronto, ON

·       Supervised Programmer Analyst and two Programmers.

·       Project Manager on five implementations of the application suite.

·       Full life cycle implementation of ISG’s occupational health and safety system: All project management responsibilities in a functional/technical team of three.  Written in Dataflex consisted of Worker’s Compensation claim processing, cost tracking, incident statistic reporting, examination scheduling and medical record management.

·       Train client personnel.

·       Wrote technical and user documentation.

·       Provided on-site and telephone support.

·       Participated in product demonstrations and trade shows.

November 1986 - July 1987: Programmer/Analyst, Connaught Laboratories Limited, Toronto, ON

·       Design, code and implement a COBOL/Convergent Technologies based labour reporting system and payroll interface.

·       Support and train Human Resources’ staff in the use of productivity tools and Personnel Management System.

June 1982 - August 1985: Programmer/Analyst, The Toronto Stock Exchange, Toronto, ON

·       Design, code and implement Computer Assisted Instruction/Evaluation applications for the training of industry personnel.

·       ‘C’/Pascal/SQL/UNIX development environment.

·       Administer and support departmental systems including a bibliography and resource scheduling system.

·       Wrote technical and user documentation.

·       Prepared and updated course materials: debt and equity instruments, and front and back office administrative processes.

EDUCATION

11i/2.6 Implement Oracle Workflow – August 2003

11i eBusiness Suite Essentials for Implementers – June 2003

11i General Ledger Management Fundamentals – June 2003 – Master Level

10.7 Oracle Financials Foundation – October 1997

Microcomputer Management Diploma