Roger NSwam

Oracle EBS / ERP / Financials / E-Business / EBiz / E-Biz / Application specialist

ac11c7@r.postjobfree.com (Also Skype ID) 604-***-****

(Vancouver, Canada but willing to relocate) https://www.linkedin.com/in/roger-nswam-38798875/

(As a Canadian citizen, I can get 3 year TN (NAFTA) visa at the US border with just an employment offer letter and this visa can be renewed indefinitely with no limit)

SUMMARY

Seasoned technology consultant with several years of experience in supporting, maintaining, customizing and enhancing Oracle EBS Applications Suite at dynamic NASDAQ listed Fortune 500 retailer ‘Best Buy’. Comfortable in delivering high quality results using on-site, offshore model. Proficient in supporting compliance audits for PCI, SOX etc. Significant experience in multiple version upgrades.

EDUCATION

Bachelor of Engineering in Mechanical Engineering with Honors (GPA 8.30/10.00) AWARDS

`Arkansas Traveler Award' from Governor of Arkansas Mike Huckabee

`National Merit Scholarship’

AIM (Automated Intelligent Matching) developer award from Best Buy Canada EXPERIENCE

Best Buy Canada Ltd From 2000-Mar-30 till 2017-Apr-01 Title: Support Analyst

Location: Vancouver, British Columbia, Canada

Role: Subject matter expert (SME) for Oracle Financial EBS suite, regular production support, SME consultation on projects

Accenture Ltd From 2005-Nov-06 till 2017-Apr-01

Title: Support Analyst

Location: Vancouver, British Columbia, Canada

Role: Placed at the client site ‘Best Buy Canada Ltd’ Sequent Corp From 1999-May-23 till 2000-Mar-15

Title: Systems Engineer

Location: Portland, Oregon, USA

Role: Part of the team which implemented Oracle Financials 11 EDS Inc From 1999-Jan-01 till 2000-Mar-15

Title: Systems Engineer

Location: Portland, Oregon, USA

Role: Placed at the client site Sequent Corp’

SKILLS

Technical

Experience with full implementation of Oracle EBS 10.7, reimplementation of 11i, upgrade to R12 as well as full production support of these versions

Worked with Oracle Support by raising SR (Service Requests) until the underlying issues are fully resolved

Excellent knowledge of complete SLC (Software Life Cycle) i.e. feasibility study, estimation, requirements gathering, analysis, design, development, testing, configuration, implementation and post deployment support of PL/SQL Views, Packages, Procedures, Functions, Triggers, Indexes etc.

Good Knowledge in RICE (Reports, Interfaces, Conversions and Extensions) components.

Excellent knowledge of Oracle database catalogue DBA_ views and EBS application’s foundation FND_ tables and their respective entity relationships

Excellent working knowledge of Oracle Databases 9i, 10g, 11c

Excellent knowledge of database utilities such as TOAD, PL/SQL Developer, SQL*PLUS etc.

Good knowledge of P2P process

Implemented and supported many modules of More for Apps (More4Apps) software

Built, customized and maintained interfaces from other systems into Oracle EBS and from EBS to other systems which includes (but not limited to) these o Journal import from all feeder systems (such as from Clarify CRM, Retek Retail, POS, PeopleSoft HR etc) into EBS GL via GL_INTERFACE

o Budget data import from other feeder systems (such as IBM Cognos TM1 and OFA) into EBS GL via GL_BUDGET_INTERFACE

o Publishing daily exchange rates from EBS GL to all other corporate, retail and POS systems o Publishing fiscal period calendars from EBS GL to all other corporate, retail and POS systems o Import of invoices and debit notes in to EBS AP via invoice gateway o Export of positive pay report from EBS AP to bank via a custom ETL o Import of daily bank statements from bank into EBS CM via bank statements open interface and subsequent reconciliation of payments in AP

o Importing assets into EBS FA via mass additions interfaces o Import of standard purchase orders into EBS PO via standard PO open interface o Import of receipts into EBS PO via shipment headers open interface and receiving transactions open interface

o Import of invoices into EBS AR from other feeder systems via Receivables Auto Invoice Interface o Import of Employees into EBS HR from People Soft via HRMS APIs General

Singlehandedly supported the needs of over 300 Oracle application users located across two continents in US, Canada and India in a dynamic multi-org and multi-currency environment

Led all technical activities onsite with 4 offshore team members and was on-call pager support 24/7

Took part in the periodic audit process for PCI and SOX as well as worked on various SOX/PCI related initiatives to make EBS application fully in compliance with SOX/PCI regulations

Was the point person during all month end, quarter end and year end processing activities

Was the point person during all EBS outages for application or database or OS related patches

Delivered demos to executives, trained EBS end users, mentored junior resources and created detailed documentation for multiple stakeholders

Prepared test cases, test scripts and developed configuration management solutions for Oracle APPS related custom objects

Upgraded Oracle Financials from versions 9.4 to 10.7 NCA to 10.7 SC to 11.5.9 to 11.5.10

Administered Oracle EBS application as System Administrator

Worked with DBAs on multiple performance related issues

Developed automated intelligent matching engine (AIM) for matching invoice to receipts that increased productivity exponentially

Customized and cloned many Oracle Reports, SQL Reports, Oracle Alerts etc.

Migrated from legacy systems, prepared data conversion scripts, data loads, designed staging schemas for migration to Oracle Apps

Functional

Performed as the primary Oracle EBS SME for all of business’s technical needs (as well as for many of their functional needs) hence well versed in these

GL - General Ledger Module: Setup of Chart of Accounts, Calendars, Currencies, Accounting Flex Fields, Cross Validation Rules, Code Combinations, Suspense Accounts, Journal Sources, Journal Categories, Exchange Rates, Rate Types, Period opening/closing, Financial Statement Generator

(FSGs), FSG Row Sets, FSG Column Sets, FSG Parameter Sets, Budget Versions etc.

AP - Accounts Payable Module: Invoice processing, Payment processing, GL Posting, Setup of Payment Terms, Freight Terms, Pay Groups, Supplier Types, Distribution Sets, Payables and Financial Options, Invoice Hold Codes, Invoice Release Codes, Terms Date Basis

SA - System Administration Module: Setup of System and User Profile Options, Profile Values, Concurrent executables, Concurrent programs, Concurrent Report Sets, Flex Value Sets, Flex Value Segments, Parent/Child Relationships, Application Users, Application Responsibilities, Application Menus, Printers, Concurrent Managers, Work Shifts, Oracle Alerts etc.

CM - Cash Management Module: Setup of Banks, Bank Accounts, Transaction codes

FA - Fixed Assets Module: Asset Category Setup, Mass additions import, depreciation calculation

PO - Purchase Orders Module: Setup of Suppliers, Sites, Matching Tolerances, Jobs, Approval Groups, Locations, Buyers Purchasing Options etc. PO creation and import, receipt creation and import

AR - Accounts Receivables Module: Setup of Customers, Sales Persons, Customer Profiles, Collectors, Transaction Types, Transaction Sources, Invoice Import, Auto Lock Box

PA - Project Accounting Module: Setup of Projects, Tasks, Expenditure Types, Expenditure Organizations etc.

HR – Human Resources (Shared Installation): Employee Setup Good Exposure to

Oracle Discoverer, Oracle Designer, Oracle Developer, Forms personalization, XML Publisher, Custom.pll, TCA (Trading Community Architecture), Work Flow etc.

Unix (Sun Solaris + Linux) Shell Scripting

Oracle Financial Analyzer

MHC Check Printing Software

Accurate Fiserv Reconciliation System

Informatica ETL, Harvest CM

CICS, VSAM, Cobol, DB2, JCL

SIGNIFICANT PROJECTS

Upgrade from 11i to R12.1.3: (May of 2015) Technical lead for upgrade project. Identified custom objects, modified concurrent programs and executables to R12 requirements, worked with functional consultants to identify gaps and customized/extended custom processes to fill the gap. Created the master RICEF list and ran with each business group to address their specific needs

Upgrade from 11.5.9 to 11i: (Nov 2005) Technical lead for upgrade project which also included a chart of account and organization change. Worked with third party Oracle consulting in transferring all open transactions including but not limited invoices, POs, receipts to new organization and chart of account. Addressed all gaps post upgrade and worked with business during deployment and subsequent production support

Upgrade from 10.7 to 11.5.9: (2003) Technical lead for the upgrade project which included identifying and moving custom database objects to XX schema and custom server objects to $XX_TOP folder. This follows oracle supported customization standard and made future upgrades a lot easier

Automated Intelligent Matching: (Feb 2003) Developed a PL-SQL matching engine to match incoming EDI810 invoices to POs and receipts. It has resulted in elimination of over 40 FTEs in invoice processing department. This engine loads about 5 billion dollars’ worth of invoices including 300 million dollars’ worth of debit notes. Engine is sophisticated enough to get back any overbilling due to price or quantity variance resulting in significant savings to business. Additionally, I had developed 5 concurrent reports to be available inside Oracle EBS and 3 forms which are hosted outside of Oracle EBS

New implementation of 11i: (Mar 2000 at Sequent Corp in Beaverton, Oregon) Part of an upgrade team of consultants in vanilla implementation of Oracle EBS financials, inventory and BOM modules. This project involved a change in chart of account (hence retiring the old Oracle 10.7 EBS) and I was responsible for conversion of GL balances and GL journals. Project also implemented multiple sets of books numbering 15 i.e. one for each country where company was operating OTHER PROJECTS

Database re-platform: (Dec 2011) Participated in DBA run initiative to migrate Oracle EBS database from Sun Solaris to Linux. Made some reconfiguration to workflow to work in the new environment

Excel front end software: (Oct 2010) Technical lead responsible for implementing MORE4APPS software and making the configuration changes in Oracle EBS to accommodate it. This provides easy to use front end 'Microsoft Excel' interface to GL and AP modules.

Payment Export: Implemented a new custom concurrent program to extract payment data from Oracle AP to be sent to third party ‘Western Union’ via secure FTP

PO and receipt import: Built custom concurrent program to import purchase orders with Oracle project details and receipts from external application into Oracle purchasing using standard API. Built Oracle packages to publish Oracle EBS vendor, GL chart of account and project chart of account details to this external application

New check printing software: (Aug 2008) Technical lead responsible for implementing and configuring a new check printing software called 'Document Express' from MHC Corp and building a data interface from Oracle EBS to MHC.

Custom PLL Development: Developed a CUSTOM PLL routine to extract data from another software called eCapture into Oracle AP invoice entry form to reduce key strokes and to ensure data correctness

SOX and PCI compliance: Worked with internal and external auditors to identify noncompliance in application, database, UNIX tiers. Subsequently made changes to address and / or mitigate deficiencies to pass SOX and PCI audits

Bank Statement Import: Built a data interface to load bank statement files into Oracle table and then wrote a PL-SQL engine to convert it to standard Oracle cash management API. This reconciles bank statement in CM module against checks cut in AP module

Daily Sales upload to GL: (Jun 2000) Built a PL-SQL package to validate and import data from our main Oracle based corporate system into GL interface. The routine converts store location, SKU type into corresponding GL chart of account segment values using mapping tables

Import Debit Notes: Built a PL-SQL package based concurrent program to import negative invoices aka debit notes into Oracle AP via standard API

Contact this candidate