Suzanne Douglas

ad2de2@r.postjobfree.com

Senior Technical Specialist

Career success leading Information Technology innovation for high-growth organizations

Seasoned professional with distinguished career aligning technology strategies with business objectives to deliver short- and long-term goals, improve product capabilities, and mitigate operational risks. Engaging contributor with expert qualifications; Oracle products and services, project management, development, and system analysis. Effective communicator, dedicated to maintaining a reputation built on service, excellence, and uncompromising work ethics.

Highlights of Expertise

Team Leadership

Requirement Gathering & Analysis

Reports, Interfaces, Conversions, Extension Strategies

Data Conversion Expertise

Fast Formulas

Oracle Databases

Full Life Cycle Project Management

Oracle Development

Agile SCRUM

ITIL, Incident Management, Problem Management

ERP, Oracle E-Business Suite (EBS R12, 11i), HCM, Financials and Manufacturing.

HCM Cloud (Compensation, Benefits, Core HR, Payroll, HCM Extracts, OCI, HDL, BIP, and OTBI) & Cloud Financials (GL, AP)

Verbal & Written Communications

Education & Credentials

Master of Science, Computer Information Systems University of Phoenix, Phoenix, AZ

Bachelor of Science, Computer Science & Mathematics University of West Indies, JA

Big Data Analytics 2020 York University

Oracle SOA Suite 11g: Build Composite Applications Ed2

Microsoft Azure – Skillsoft

Agile Scrum Master Training - Fujitsu

Project Management Skills for Success - Learning Tree

SCO UNIX

C Programming Language

Java - George Brown College

Oracle Forms, Oracle Reports, Building Extensions to Oracle Applications, Oracle Purchasing, Oracle Order Entry, Oracle Receivables, Oracle Inventory, Develop Extensions to Oracle Application, System Administration and FlexFields.

Technical Proficiencies

Oracle Managed Cloud Services environments, Oracle Reports, Workflow, Oracle 9i, Oracle E-Business Suite 11i and R12, Oracle Database 12c, Oracle 10g, Oracle 11g, Oracle 12c, HCM Extracts, HDL - HCM Data Loader, Oracle HCM Cloud (Compensation, Benefits, Payroll and Core HR), Oracle Integration Cloud (OIC), Oracle iProcurement, Oracle iExpenses, Oracle HCM, Oracle Time and Labor, SVN Version Control, Oracle Forms, Oracle Reports, SQL, PL/SQL, Toad, AIX, Linux, BI (XML) Publisher HCM Cloud, XML, JIRA, Linux, Developer, HP Service Manager, HP Quality Center, PVCS, HP UNIX, Oracle e-Business Suite (Order Management, Inventory, Receivables, Payables and Purchasing)

Career Experience

LCBO (Partially Remote)

Merchandising and Marketing Technical Lead (03/2022 to 11/2023)

Managed development resources

Managed projects

Team leadership &

Resource management

Deloitte Consulting Services (Remote)

Oracle Cloud Technical Lead - independent consultant

CONSULTANT - Oracle Cloud Technical Lead (10/2021 to 02/2022)

Oracle Cloud HCM Technical Lead at a Telecommunications company

IBM Business Consulting Services Canada (Remote)

Oracle Cloud Technical Consultant finance applications, BI Publisher Reporting for an IBM public sector client

CONSULTANT - Oracle Cloud Technical (06/2021 to 09/2021)

Oracle Cloud Technical Consultant -- Oracle Cloud Application 21C (11.13.21.07.0)

Implemented General Ledger Oracle Account Analysis Reports – Closing balance, Account Analysis by Descriptive Flexfield, Account Analysis Budget Report, other Payables reports and an application security report.

BI publisher Security report and Payables Distribution Set Report

Oracle Cloud Application 21C (11.13.21.07.0), Human Capital Management (HCM)and Finance

Scotia Bank (Remote) - Infosys

Technical design and build, Hammer Project, Accounting Hub, Subledger accounting interfaces

CONSULTANT EBS (12/2020 to 05/2021)

Designed Foreign exchange interface.

Implemented archiving on pre-existing interfaces.

Design and build of FAH accounting integration for US Entities on Oracle RDBMS in PL/SQL

Oracle 12.1.0.2.0

Confluence, and JIRA

Broadcom (Apptad Inc.) - Wipro, Allentown, PA

Worked on the business intelligence team to designed data warehousing schemas for several sales and marketing visualizations as well as created visualizations from Oracle R12 EBS Order-To-Cash ERP tables.

CONSULTANT – Business Intelligence (10/2019 to 02/2020)

Designed schemas in Incorta (an analytics tool) for Sales, Shipping and Order Management visualizations.

Oracle 11g

Indiana University Health (Apptad Inc.), Indianapolis, IN

Provided Payroll and Core HR integrations Technical Designs for an Oracle Cloud Implementation, utilizing several integration patterns on Oracle integration cloud.

CONSULTANT – HCM Cloud integrations (05/2019 to 09/2019)

Technical Design of Oracle HCM Cloud- Benefits, Payroll and Compensation Integrations, utilizing, HCM Extracts, BI Publisher

Oracle Integration Cloud (OIC) (an iPaas tool), with Restful and SOAP API’s

BI Publisher, OTBI, OBIEE

Oracle 12c

XPO Logistics (Systel Inc.) Tech Mahindra, Portland, OR

Worked on the re-implementation of Oracle Receivables and General Ledger as well as Netezza, queries for the data warehouse. Work consisted of common file handling interface design.

CONSULTANT – Integrations, Data Conversion and Enhancements (10/2018 to 05/2019)

Technical design and development of interfaces in PL/SQL and API’s,

Data Conversion

Linux Shell scripting, and the design of the file handling

BIP Reports and Oracle Forms development

Cloudworks, Toronto, ON

Provided technical leadership for Oracle Fusion Human Capital Management (HCM) Cloud Software and facilitated as the Integration Lead on implementation of Oracle HCM Cloud.

TECHNICAL SPECIALIST DEVELOPMENT CONSULTANT (08/2017 to 02/2018)

Provided all levels of consultancy and led project development. Identified requirements and solutions to meet overall business needs with responsibility to lead teams to enhance and improve business platforms.

Led technical team on the implementation of Oracle HCM Cloud, in Atlantic Canada

Designed and built data conversion validation programs that were independent of fixed data positions. Data was compared against received versus extracted data discrepancies reported if data was dropped or changed.

Reconciliation reporting on data conversion metrics.

Established processes and procedures in the design of multiple data extract programs in support of interface to external vendors such as the OSI interface.

Worked extensively on Fast Formulas (Benefits and Compensation)

Fast Formulas, BIP Reports, OTBI, HCM Extracts, HCM Data Loader

Fujitsu Consulting – Canada Incorporated, Toronto, ON

Delivered Application Management Support, focus was on Oracle development support on 11g, 10g and Oracle 9i, for custom Oracle Forms software.

SENIOR TECHNICAL CONSULTANT (12/2015 to 08/2017)

Key contributor to the Transition Management team for custom Oracle distributed applications, which successfully allowed Fujitsu to take over production support from a prior vendor, held responsibilities for documenting existing application and processes during the transition.

Providing leadership role in onboarding new team members utilizing expertise in Oracle database concepts and products.

Ensured adequate allocation of disk space, created monthly reports for the AMS dashboard from JIRA, and leveraged best practices in weekly report extracts from JIRA for open and resolved tickets.

Played integral role, collaborating with Project Manager on proposal for the integration of a web-based Oil & Gas industry application with a custom Oracle form application in the public sector.

Millennium Software Inc., United States

Consulted on an Agile Development Scrum project for Ford Motor Company located in Dearborn, Michigan; BOM thin change client project on Oracle 11g.

CONSULTANT (11/2015 to 12/2015)

Instrumental in building the BOM thin change client to generate XML output and implemented a web-based application utilizing Scrum.

Intact Insurance Company, Toronto, ON

Participated in a R12 E-Business Suite functional and technical role to support project and production of CEMLI’s, iProcurement, Purchasing, Cash Management, Payables, General Ledger and Web ADI.

PROGRAMMER ANALYST (04/2015 to 08/2015)

Provided daily support of Oracle E-Business suite software; documented process and system changes such as adding newly acquired companies to the existing chart of accounts, and the respective interface through Web ADI.

Built solid relationships to collaborate with Oracle support to resolve any applications issues.

Supported the approval process for procurement approvals.

PepsiCo Canada, Toronto, ON

Facilitated as the Systems Analyst and held accountable for upgrading Oracle E-Business Suite from 11i to R12 and provided production support to Oracle Financials and Manufacturing modules, inclusive of transition management functions.

SYSTEMS ANALYST (07/2012 to 03/2015)

Instrumental in the development of new projects, facilitated system analysis, and provided production support of web-based applications with focus on Oracle E-business suite.

Effectively supported Oracle Financials and manufacturing through GL, AP, FA, CE, iProcurement Cost Accounting.

Completed an American Express interface fix which included the resign, process documentation and coordination of user acceptance testing, to implementation.

Worked collaboratively to document Accounts Receivable (AR) reconciliation process and verified available reporting that supported process.

Provided daily production support inclusive of month-end and year-end closing.

Softchoice Corporation, Toronto, ON

Demonstrated expertise in development of extensions to Oracle E-Business suite for ongoing projects and provided oversight of production issues.

ORACLE DEVELOPER (10/2011 to 07/2012)

Developed Oracle Discover reporting for receivables aging and conducted Interface development in coordination with Oracle E-business suite release for GL interfaces.

Developed and implemented a journal entry batch custom audit trigger that worked with Oracle workflow.

Developed Receivables Aging Report in Oracle Discoverer.

Production support of E-business suite issues (footprint included Oracle HCM and Financials).

PWC for Bank of Montreal, Toronto, ON

Provided outstanding results for a revolutionary web based online investment application for the Bank of Montreal.

CONSULTANT PL/SQL DEVELOPER (09/2010 to 05/2011)

Instrumental in the development of UNIX-Bourne shell scripts for data purging application and various operational utilities, and developed Pl/SQL packages, procedures, and functions.

Created and tested migration scripts for database objects, packages, tables, constraints, and indices for the final applications release while supporting various application modules during Quality Assurance (QA) testing; facilitated analysis and resolution of software bugs.

Rogers Communications, Toronto, ON

Responsible for assessing the impact of Oracle Applications Release 11.5.10 upgrade on existing reports which included BI Publisher, Noetix Views, and Oracle Reports; resolved technical issues as they arose, with additional responsibilities for post implementations and cutover support.

BUSINESS SYSTEMS ANALYST (08/2009 to 10/2009)

Developed PL/SQL procedures that facilitated Noetix Views report testing, supported end-user testing of existing Noetix reports against the new 11.5.10 release of e-business suite.

MDS, Inc., Toronto, ON

Held responsibility for expanding technology operations, led offshore teams to deliver Oracle projects while providing consultancy and recommendations on system configuration choices that met business objectives.

SENIOR DEVELOPER, TECHNICAL TEAM LEAD (07/2008 to 05/2009)

Delivered outstanding Project Management for key projects including Bank of America, American Express, HSBC; projects focused on archiving existing production data because of regulatory requirements to keep historical data, collaborated with off short teams from vendors which included IBM and Applimation.

Provided technical leadership to offshore resources; mitigated performance risks for Human Resource interfaces, Project Accounting, Install Base, Order Management, and Inventory.

Led the Oracle Install base data conversion exercise which led to a unified system that included an acquired company’s install base items.

Install included Oracle HCM, Financials, and Supply Chain

Utilized effective communication skills with key stakeholders to plan, schedule and managed projects, conducting full life cycle project management to ensure deliveries were on time and within budget.

Trecata Corporation, Toronto, ON

Provided functional and technical support regarding the outsourcing business for a full-service technology solutions company that offered Oracle packages software implementation solutions.

SUPPORT MANAGER (06/2006 to 06/2008)

Led all aspects of an archive project for a large financial institution, included the acquisition of infrastructure and relocation, whilst adhering to budget and timeline constraints.

Completed impact assessment for reorganization on Accounts Payable, Fixed Assets, Human Resources, and General Ledger. Reported impact to interfaces to other systems.

Oracle HCM R12 and finance – Benefits, Compensation, Fast formulas

BI Publisher, PL/SQL

Atomic Energy of Canada Ltd, Toronto, ON

Production support for Canada’s largest nuclear science and technology company.

SENIOR BUSINESS SYSTEMS ANALYST 05/2005 to 06/2006)

Worked on strategic projects such as Project Accounting (PA), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), Human Resources, and Oracle Time and Labor (OTL) as well as production support of interfaces through to code fixes.

Developed data conversion on the chart of accounts, an account reorganization project that was completed successfully.

Created feasibility study; analyzed, designed, and developed successful code fix an employee assignment interface programs that were previously deemed irreparable.

Managed and coordinated the Oracle release 11 archive project.

Led daily direction of the Timecard Workflow data cleanup project (1 FTE and 1 PTE).

Delivered production support on the Oracle Release 11i; resolved production support issues, inclusive of code fixes when required.

IBM Business Consulting Services/PricewaterhouseCoopers (PWC), Toronto, ON

Played a key role as a Senior Consultant driving high performance teams on large-scale Oracle E-Business Suite implementations and delivered products including MD050 Functional Design, and MD070 Technical Design.

SENIOR CONSULTANT (07/1997 to 05/2005)

Delivered diverse leadership roles in the implementation of Order Entry, Warehouse Management, and Manufacturing modules, created proposals for RFP responses for multiple large implementations and oversaw development of global implementations of Oracle E-Business Suite (Oracle HCM, Financials, and Manufacturing); created estimates of work, gathered information, reporting strategy on data conversion and interface, and delivered technical designs with code reviews.

Led the development of Oracle Applications development extension team; delivered development standards, coordinated, and delivered training materials as part of global implementation for 3 sites in 2 countries.

Reviewed and coordinated training teams for the telecommunications company as part of a global implementation of Oracle applications, oversaw the activities of three technical writers, and delivered training materials and job aides which included Supply Chain training materials for 3 sites and 2 countries.

Implemented Reports, Interfaces, Conversions and Extensions strategy (RICE) inclusive of oracle workflow, fast formulas and delivered strategy for release 11i; provided a development framework and performed coaching and development leadership role on multiple projects.

Requirements gathering, and business system analysis for several customers.

Contact this candidate