Alan Austin

** ********* ******

Toronto, Ontario M4X 1C4

Home: 416-***-****

ufdaqi@r.postjobfree.com

(U.S. CITIZEN)

Senior Oracle Financials R.I.C.E. Consultant

RESUME

Functional Summary

• Extensive ETL (Interface and Conversion) expertise including Team Lead

• In-depth analysis, design, modification and enhancement experience

• Performance-tuning expertise

• Business Process Execution Language (BPEL) development (See “Fidelity National Financial” Corp)

• Security clearance granted on Oracle Federal Financials projects by:

● U.S. Department of Defense ● U.S. Department of Health and Human Services

• Gap/Fit Analysis and Solutions

• Excellent verbal and written communications skills

• Custom Life-Cycle Oracle Applications designed, developed and implemented for:

Grants Administration, Freight Forwarding, Telephone Management, Fixed Assets

• Accounting background including corporate controllership

• User and Technical Liaison proficiency, issue resolution

• Trained users. Created comprehensive, understandable User Manuals

• Seasoned Security Analyst (5 years) - former member Investment Dealers’ Association

Applications Summary

Oracle Financials and Oracle Federal Financials experience:

• 12.1, 11i (9 years) incl. 11.5.10.2, 10.7 applications; 11g, 10g, 9i and previous databases

• Oracle Grants, General Ledger, Accounts Receivable, Accounts Payable, Purchasing,

Order Management, Fixed Assets, Project Accounting

• SOA Suite – Business Process Execution Language development

Oracle Manufacturing experience:

• 11i Items, WIP and BOM custom interfaces

Tools Summary

• Advanced capabilities in SQL, PL/SQL, SQL*Forms, Oracle Reports, Import, Export and SQL*Loader database utilities

• SOA Suite (BPEL) 10.1.3.4.0

• Performance Tuning (11g, 10g, 9i, 8i and lower)

• Oracle 11g, 10g, 9i (and older) PL/SQL packages, procedures, functions, database triggers

• Unix and Unix shell scripting

• TOAD, PL/SQL Developer, SQL Developer, SQL Navigator (PL/SQL development tools)

• MS Office Suite 2010, 2007, Visio Professional (extensive experience)

• DataLoad Professional

Consulting Experience & Accomplishments

Saskatchewan Workers’ Compensation Board October, 2011 – March, 2012

(Development/delivery of workers’ compensation programs/services) Regina, Saskatchewan

• Techno-Functional Consultant (Oracle Financials 12i upgrade, contracted through Sierra Systems)

• Cash Management –

• Bank Reconciliation – Designed, developed, implemented, tested entire reconciliation process for payments

from external system

• Configuration – banking-related setups

• Payables and Payments Configuration

• General Ledger Configuration – New ledger and Ledger Set

• Visio Process Flows – Developed high-level and drill-down to extremely detailed flows to portray workings of custom-developed code for Fineos-to-Oracle Payments and General Ledger processing as well as Annuity Import.

• DataLoaders - Developed and implemented Dataloaders for low-volume conversions

Munich American Reassurance Company June – October, 2010

(Reinsurance including accident, life and health treaties) Atlanta, Georgia

• Technical Lead (Oracle Financials 12.1 upgrade, 11g project, contracted through PricewaterhouseCoopers)

• Payable Transactions (Claims) Interface – Interfaced extensively with client personnel, created functional and technical designs and docs including complex Visio process flows; developed an extremely complex performance-tuned PL/SQL interface package utilizing multiple APIs and interface tables; crafted complex, multi-level Sub-Ledger accounting logic, accounting “Keys” and data remediation. Successfully created this interface in an environment of multiple daily requirement changes and code modifications. Successful Go-Live in October, 2010.

• Receivables, Customer and Vendor Interfaces – Created functional and technical designs, managed developers and development, enforced adherence to standards, involved in issue resolution.

• Performance-tuning – Optimized SQL queries and PL/SQL packages through design and technique

• Error handling – Personally designed/developed the multi-layered Error Handling package used on this and three previous projects: provides detailed logging of results, built-in debug processes and location of errors within script.

• Time Management – Adhered to extremely aggressive deadline requirements

• Agile/Scrum Project Methodology

Fidelity National Financial Corporation February – September, 2009

(Insurance, specialty insurance and claims management services) Jacksonville, Florida

• ETL Interface Consultant (Oracle Financials 11.5.10, 10g project)

• Vendor Interface – developed performance-tuned PL/SQL package, testing and Concurrent Mgr implementation.

• Receivables Interface – enhanced existing customized designs, modified/debugged existing PL/SQL packages including tuning, testing and Concurrent Manager implementation.

• BPEL - Designed and developed BPEL application for transport and processing of files using web services. Process polls external system, retrieves files, archives copies then auto-loads files into staging tables, calls PL/SQL package for data processing and error logging. After completion, activity/error logs are returned to users.

• Installed SOA Suite (BPEL), upgraded to 10.1.3.4.0 including all patches, pre-and post-install tasks

• Performance-tuning – Optimized SQL queries and PL/SQL through design and technique

• Error handling - multi-layered with detailed logging of results; built-in debug processes

U.S. Marines, Marine Corps Systems Command (GCSS-MC) January – June, 2008

(Support of military initiatives through innovation, procurement, technology and logistics) Dumfries, Virginia

• ETL Interface Consultant (Oracle Financials 11.5.10 project, contracted through Oracle Corporation)

• Custom Inventory and Sales Order interfaces and APIs – enhanced existing designs, developed PL/SQL packages including tuning, testing and Concurrent Manager implementation

• Performance-tuning – Optimized SQL queries and PL/SQL through design and technique

• Error handling - multi-layered with detailed logging of results; built-in debug processes

• Enhanced existing Functional/Technical documentation – Using Oracle AIM methodology

• Standards: Adhered to DOD/Oracle standards: coding, formatting, error-handling, performance, quality

Terex Corporation February – December, 2007

(Global heavy equip. mfgrs: mining, road surfacing, construction equipment, cranes) Cedar Rapids, Iowa

• ETL Conversion Lead, Cedar Rapids, IA pilot site (Oracle Financials 11.5.10 project, contracted through Ciber Corp)

• MD050s: crafted conversion design/mapping [Oracle AIM] documents for Items, Item Costs, Customers, Vendors, Sales Orders, Purchase Orders, AR Transactions, AP Transactions

• PL/SQL packages: Designed, mapped, developed, unit tested and implemented PL/SQL packages to validate and interface Items, Item Costs, Sales Orders, Price Lists to a Global Conversion Engine

• Pre-Validation: Designed and built pre-conversion error-trapping/validation processes

• Users: interfaced cordially with legacy personnel to clarify/resolve functional and technical issues

ACT, Inc. March – November, 2006

(Creators and administrators of educational competency examinations) Iowa City, Iowa

• Senior Custom Application Developer (Oracle Financials 11.5.10 project, contracted through TUSC Corporation)

• Developed detailed Technical and/or Functional designs and process flows, built, implemented and unit tested:

• Refunds Process, a complex custom process for handling student refunds including credit card purchases. (Client declared this the best Technical Design that they had ever reviewed).

• Utilized multiple AR and OE APIs in custom processes

• Error Logging Process used project-wide by all custom applications for error trapping/handling/recording.

• Customer AR Balance function.

• Drop Line Process for the cancellation of order lines under specific conditions.

• Tools and Platform: Built complex PL/SQL packages, utilizing Oracle AR and Order Mgt APIs, on a 10g database in conjunction with 11.5.10 Application. Unix shell scripting in Korn Shell.

• Service Requests: Logged, serviced and escalated Oracle SRs (TARs) as required – implemented solutions.

NextWave Group - PacketVideo October, 2005 –March, 2006

(Cellular Telephone Technology) San Diego, California

• ETL Conversion Lead (Oracle Financials 11.5.10 project, contracted through GRT Corporation)

• Developed design and conversion strategy for migration from legacy systems to Oracle 11.5.10. Conversions included GL, FA, AR, AP, PO, HR, OTE and Projects.

• Managed all conversion extract design, programming resources and coordination with Client SMEs.

• Developed Conversion Tracking and Management Tool to monitor progress of program.

• Managed/Resolved conversion and data issues

• Developed and implemented numerous complex Dataloaders for low-volume conversions

BT Americas (British Telecommunications) August – September, 2005

(Telecommunicatons) Reston, Virginia

• Accounts Receivable Conversion Lead (Oracle Financials 11.03 project, contracted through Computer Science Corp.)

• Developed functional design and conversion strategy for reverse-migration from Oracle11i back to 11.03 (to bring US subsidiary onto 11.03 global platform). Design includes conversion feeds and functional/technical design for on-going custom interface into Project Accounting using “Billing Extensions” functionality. Contract was terminated when project was suspended due to conflicting corporate priorities.

• Generated all AR Setups

Ontario Ministry of Natural Resources May – July, 2005

(Land and Timber Management) Toronto, Ontario, Canada

• Accounts Receivable Interface Consultant (Oracle Financials 11i project, contracted through Locus Systems, Inc.)

• Rigorously tested and tuned AR Interfaces and custom scripts

• Re-wrote/customized Oracle 11i AR Users Guide to the specific requirements of MNR Users

Tanana Chiefs Conference February – April, 2005

(Tribal Economic, Social, Educational and Health Services) Fairbanks, Alaska

• Oracle Grants ETL Interface Designer/Developer (Oracle Financials 11i project, contracted through Oracle Corp.)

• Developed functional and technical designs built and tested Payroll-to-Grants interface based on user requirements

• Crafted functional and technical designs, Visio Process Flow, Test Plan and Script, Relationship Diagrams

U.S. Dept. of HHS, Centers for Disease Control and Prevention April – November, 2004

(Health Services, Emergency Medical Response and Research) Atlanta, Georgia

• Oracle Reports Functional Designer (Oracle Federal Financials 11i project, contracted through BearingPoint, Inc)

• Developed functional designs for Budget Execution, AP/PO, GL and Month-End Exception reports

• Elicited/negotiated user requirements, proposed/implemented solutions, advised on technical issues.

• Designed and developed Financial Notes logic and PL/SQL package for the CDC Annual Report

U.S. Dept. of Veterans Affairs March – April, 2004

(Health Care and Federal Benefits for U.S. War Veterans) Washington, D.C.

• Oracle Reports Functional Designer (Oracle Federal Financials 11i UFMS project, contracted through BearingPoint, Inc)

• Functional analysis and design of report enhancements; issue resolution

• PL/SQL and SQL report enhancements, fixes and performance-tuning

• Contract terminated as part of massive project-wide reduction-in-force

U.S. Army, Military Surface Deployment and Distribution Command August, 2003 – Feb 2004

(Deployment and Distribution of goods & personnel in support of military initiatives) Alexandria, Virginia

• ETL Interface Consultant (Oracle Federal Financials 11i project, contracted through Computer Science Corp)

• Custom AP & PO interfaces - designed, developed and implemented

• Performance-tuning – Optimized pre-processing and validation of records with bulk-processing, PL/SQL memory utilities through carefully crafted and optimized SQL queries

• Error handling - multi-layered with detailed logging of results; built-in debug processes

U.S. Dept. of HHS, Centers for Medicare and Medicaid Services March – June, 2003

(U.S. National Health Programs) Linthicum, Maryland

• ETL Interface Consultant (Oracle Federal Financials 11i UFMS project, contracted through IBM Consulting)

Healthcare Integrated General Ledger Accounting System (HIGLAS) Oracle Federal Financials 11i project:

• Oracle 11i Strategy Document and the Technical Design - (co-authored) re complex, huge 835 Payments Remittance Interface from Oracle Federal Financials 11i AP, AR and custom Staging Tables to two legacy systems.

• Visio process flows - Created main process flows including depictions of the complicated Claim Reimbursement and Interest calculations. Based upon over 1000 pages of functional design and more than 30 highly detailed Visios, the interface was crafted to cope with almost 800 pages of real-life “Scenarios”.

• Performance-tuned code to handle an estimated 3 million transactions per day, using nested PL/SQL memory constructs, bulk-processing, optimized indexing, minimized I/O and economy of processing.

Cognos Inc. October – December, 2002

(Business Intelligence Software) Ottawa, Ontario, Canada

• ETL Interface Consultant (Oracle Financials 11i project)

• General Ledger conversion - Oracle 10.7 to 11i (11.7) multi-currency, multi-org: gathered and interpreted user requirements; developed functional and technical Oracle AIM design documents; coded the conversion and data mapping using PL/SQL, SQL*Loader and Unix;

Hudson’s Bay Company June, 2001 – September, 2002

(Retail merchandising) Toronto, Ontario, Canada

• ETL Interface Consultant (Oracle Financials 11i project contracted through Oracle Corp.)

• Functional designs created for Oracle 11i GL and AP interfaces, using Oracle AIM methodology; developed standardized approach, formats and PL/SQL packages

• Highly customized interfaces developed; performed GAP analysis, solution definition and guided issue resolution efforts; mentored users and functional consultants

• Oracle Reports 6i Techno-Functional – Created logic-intensive reports and customized existing PO reports

• Future-State PO process flows developed

Middle River Aircraft Systems November, 1999 – March, 2001

(Subsidiary of General Electric – builds jet engine thrust reversers) Baltimore, MD

• ETL Interfaces and Conversions Lead (Oracle Financials 11i project, contracted through KPMG Consulting)

• Implemented Financials and Manufacturing suite; managed/tracked design, development and scheduling 55 interfaces

• Mapped and developed functional and technical designs using Oracle AIM methodology

• Design and development - custom WIP and BOM interfaces, tables and triggers using SQL & PL/SQL. Used SQL*Loader extensively with custom functions, developed Unix shell scripts, applied patches, ran trace files and Explain Plans, performance-tuned scripts.

• Involved in strategy and “To-Be” development

GTE Internetworking October, 1998 – October, 1999

(Communications) Cambridge, MA

• Developed extension to Oracle Financials OE. Involved in design of “Proactive Credit Issuance System” for Virtual Private Networks (VPNs); created optimized PL/SQL scripts and customized Forms.

Alcan Aluminum Limited August, 1996 – August, 1998

(Aluminum products) Montréal, Québec / Cleveland, Ohio area

• ETL Interface Consultant (Oracle Financials 10.7 project, contracted through Andersen Consulting)

• Developed high-level and detailed designs for more than 100 Canadian, US and UK Oracle 10.7/legacy interfaces. Modules included GL, AR, AP, Project Accounting (PA) and Fixed Assets (FA).

• Crafted PL/SQL, SQL*Plus and Unix scripts to supply defaults, lookups, enforcement of business rules, reformatting and validation prior to import.

• AP Functional Consultant to resolve issues and ensure User “buy-in” to the project.

• Consulted on various special issues, e.g., design of Accounting Flexfields (Chart of Accounts).

• Analyzed and designed a custom Purchase Order Interface and Import program

• Analyzed and designed Gap solutions for AR AutoLockbox processing enhancements

Previous Experience

• Various Oracle development roles, between 1991 and 1996 with:

o Motorola Corp. (Communications and Electronics) - Developed custom Payables Use-Tax system

o Xerox Corp. (Document Company) - Analyzed and Designed Oracle Financials interfaces

o Entergy Services (Public Utility) - Developed complex reports

o Ontario Ministry of Health (Public Health Services) - Designed / developed custom Grants Administration System

• Served in various computer and accounting roles including Corporate Controllership;

• Security Analyst for five years in New York City and Toronto

Education

2000-05 Oracle Grants ● Oracle Fixed Assets ● Oracle Designer 2000 ● Oracle Custom Development Methodology

1997 Prism Warehouse Manager (mapping & control tool) ● Oracle Forms 4.5 ● Oracle Reports 2.5

1988 Computer Programming Diploma, Control Data Institute, Toronto

Previous: Courses completed for M.B.A. in Finance and Investment, Baruch School of Business Administration,

City College of New York.

Previous: B.S. in Economics, Columbia University, New York City.

Contact this candidate