Alan Austin
50 Salisbury Avenue
Toronto, Ontario
M4X 1C4
Home: 416-603-0392
(U.S. CITIZEN)
RESUME
Functional Summary
· Oracle Consultant - 20 years of progressive functional and technical experience
· Extensive ETL (Interface and Conversion) expertise including Team Lead
· Business Process Execution Language (BPEL) development
· In-depth analysis, design, modification and enhancement experience
· Performance-tuning expertise
· Security clearance granted on Oracle Federal Financials projects by:
o U.S. Department of Defense
o 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
· Strong 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:
· SOA Suite – Business Process Execution Language development
· 11i (9 years) incl. 11.5.10, 11.5.9, 11.03, 10.7 applications; 8i / 9i / 10g databases
· Oracle Grants, General Ledger, Accounts Payable, Purchasing, Accounts Receivable,
Order Management, Fixed Assets, Project Accounting
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 (10g, 9i, 8i)
· Oracle 10g, 9i, 8i database triggers, PL/SQL packages, procedures and functions
· Unix and Unix shell scripting
· SQL Navigator & TOAD (PL/SQL development tools)
· MS Office Suite 2007, Visio Professional 2007
· DataLoad Professional V. 4.3.6.0
Consulting Experience & Accomplishments
Fidelity National Financial Corporation February, 2009 – 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 Manager 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 FTP application for transport and processing of files using web services. BPEL FTP process retrieves data files from external system, calls PL/SQL package for data processing and returns activity logs to source system and error logs 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 January, 2008 – 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, 2007 – 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
· Tools and Platform: 10g database in conjunction with 11.5.10 Application
·
ACT, Inc. March, 2006 – 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 to implement the above. Performed Concurrent Manager installations, developed custom value sets. 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 extract acquisition, program development and data validation. Used by GRT and Client for daily Evaluation Meetings.
· Managed/Resolved conversion and data issues
· Developed and implemented complex Dataloaders for low-volume conversions
· Developed Legacy-to-Oracle GL Mapping Tool
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 for Payroll-to-Grants interface based on user requirements
· Designed, built, aggressively performance-tuned, implemented and rigorously tested the interface
· 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 Generated Financial Notes logic for the CDC Annual Report
· Independently developed functional logic design and technical code design for implementation of 15 complex Financial Note Analyses
· Developed performance-tuned, 9,000-line PL/SQL package to produce federally required Financial Notes
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
· Extremely detailed documentation – modification descriptions linked to code in scripts
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) for the complex and mammoth 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 and tracked design, development and scheduling for more than 50 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
· Supported Users
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.
Alan Austin - Resume October 09, 2009 Page 2