SUMMARY

• Over 20 years of Oracle Cloud Financials and E - Business Suite and experience specializing in numerous application modules and end to end processes
• Led technical teams to multiple successful implementations and upgrades of Oracle Cloud Financials and E-Business suite.
• Experience in business requirements analysis, project planning and deliverables management
• Technical and functional expertise in implementing and maintaining GL, FAH, AP, AR, FA, PA, OM, PO, CM, AME and CRM modules
• Performed installation, configuration, maintenance, and upgrades on databases, application servers, tools, and applications. Experienced in performance tuning at coding and database levels.
• Extensive experience in upgrades, data conversions, designing and implementing interfaces, extensions, customizations and administration in multiple modules
• Extensive programming experience with Oracle tools including BI Publisher, SmartView, OTBI, FRS, Forms, Reports, PL/SQL, SQL*PLUS, SQL Loader, Toad, JDeveloper, Java, Workflow Builder and Discoverer
• Experienced in Application Development, Database Administration, and Linux Administration
• Developed system architecture, project plans, training plans, technical standards, functional and technical designs, migration plans, and development standards
• Experienced in integrating data from multiple legacy and external systems
• Mentored junior Oracle programmers and trained end users
• Provided numerous technical solutions in integrating and migrating legacy systems.
• Conversant with industry best practices in software development cycle and quality assurance methodologies
• Strong analytical and problem-solving skills

TECHNICAL SKILLS

• Oracle Cloud Applications
• Oracle EBS 11i/12
• Forms 10/6i
• Reports 10/6i
• PL/SQL
• SQL*Plus
• SQL Loader
• Toad
• JDeveloper
• Java
• Discoverer
• Workflow Builder
• XML/BI Publisher
• SOAP
• Perl
• Shell scripts and RMAN
• Oracle 11g/12c

PROFESSIONAL EXPERIENCE

Oracle Technical Lead

Confidential, Dallas, TX

Responsibilities:

• Configured and Implemented Oracle Cloud Invoices to Pay and Cash Management
• Setup descriptive flexfields and customize Invoices and Payments pages
• Setup custom roles for Procurement, Invoices and Payments
• Loaded vendors from decommissioned system
• Designed and developed BI reports for Payables and Payments
• Developed interfaces to external systems to send extracts
• Setup import Payables Invoices and automate the payment process
• Support Month-end Closing and account reconciliation

Oracle EBS Consultant

Confidential, Dallas, TX

Responsibilities:

• Implemented Oracle Cloud Financials (GL, FAH and FA) at Santander Consumer USA
• Evaluation of new features with each upgrade and implementing them as required
• Customization of application pages using Page Composer
• Design and development of BI, OTBI, FRS and SmartView reports to meet business requirements
• Provide audit reports and extracts for internal audit as well as PwC
• Analysis and Configuration of accounting transformations for multiple external source systems
• Build and support custom roles following SOD and SA rules
• Customization of Springboard, Setup of Common Lookups, Descriptive Flexfields, Single Sign-on and Workflow for Journal Approvals
• Support refresh of dev and test instances
• Used Oracle BI Publisher, Shell Scripts

Technical Consultant

Confidential, Dallas, TX

Responsibilities:

• Implemented organizational changes across all Oracle Financials modules
• Upgraded database and applied all the application and security patches
• Built interface to load Oracle projects and assignments to Vista Time using web API
• Changes to Invoice approvals workflow process
• Working on Data extraction from AR, AP, PA and loading into data warehouse
• Used Oracle EBS 12, Oracle 11g, Toad, JDeveloper, OAF, Java, PL/SQL, SQL*PLUS, SQL Loader, Forms 6i/10, Reports 6i/10, Workflow Builder, SOAP, XML/BI Publisher, Shell Scripts

Solutions Architect

Confidential, Irving TX

Responsibilities:

• Revised and upgraded all the customized forms, reports, interfaces, personalizations and setups for GL, AP, AR, FA,OM and PO modules
• Developed templates for checks, invoices and reports using XML/BI Publisher
• Developed custom forms and reports for AR, AP and GL using Forms, Reports, and Discoverer
• Designed and developed web application to upload, validate, correct and import invoice data using OAF/JDeveloper 10
• Setup AME and developed/modified approval workflows for invoices, expense report and purchase orders
• Developed interfaces to load customers, vendors, sales invoices, and purchase invoices
• Automated receipt applications at invoice line level
• Conversion of fixed assets from legacy systems
• Printer configurations, email configuration, monitoring resources, ftp automation scripts, cleanup scripts and scheduling jobs
• Performance tuning, application of patches, cloning, backup and recovery planning
• Responsibilities include System Administration and Database Administration
• Used Oracle EBS 12, Oracle 11g/12c, Forms 10, Reports 10, JDeveloper, OAF, Java, PL/SQL, SQL*PLUS, Workflow Builder, XML/BI Publisher, Shell scripts, Perl, RMAN

Sr. Software Architect

Confidential . Dallas, TX

Responsibilities:

• Customization and development of interfaces in GL, AP, AR, PA, CM, and CRM modules
• Developed custom OAF process to process credit card transactions and extended Sales Dash Board using JDeveloper 9
• Setup of flexfields, banks, project organizations, and autoaccounting rules
• Customized tax codes and calculation of taxes based on state tax rules
• Custom processes to upload projects, events, project revenue and cost budgets
• Developed new forms, customized and added personalizations to forms in AR, AP, and PA
• Developed templates to print checks, invoices and Purchase Orders using XML/BI Publisher
• Database backup and recovery, printer configuration, email configuration, monitoring resources, ftp automation scripts, cleanup scripts and scheduling jobs
• Performed all duties related to Oracle Database Administrator and System Administrator
• Used Oracle EBS 11i/12, Oracle 9i/10g/11g, Toad, JDeveloper, OAF, Java, PL/SQL, SQL*PLUS, SQL Loader, Forms 6i/10, Reports 6i/10, SOAP, XML/BI Publisher, Shell Scripts

Technical Consultant

Confidential, Dallas, TX

Responsibilities:

• Led the Technical team in upgrading Applications from 10 to 10.7SC to 11i
• Set up multi-org, installed new org units, set up AP, AR and PO, and modified customized programs/reports for multi-org
• Developed interfaces for importing journals in GL, invoices in AR and AP, customers in AR and Purchase Orders in PO.
• Set up Cash management system and customized the loading program and trained the users
• Converted the Invoice interface system for a legacy system in Paradox to Oracle on Unix.
• Customized several reports and forms in AR, AP, FA, PA, PO and GL
• Converted Fixed Assets for calendar change to Fiscal year
• Set up menus, responsibilities, alerts, messages, flexfields, concurrent requests, request managers, printers and profiles
• Used Workflow builder to customize Account Generator for Fixed Assets and Project Accounting
• Responsibilities include System Administration and Discoverer Administration
• Resolved several issues related to processing in applications, performance, and printing.
• Developed Patch application method and applied patches in 10.7SC
• Tuned several custom reports and forms for Cost Based Optimizer
• Provided quick solutions to resolve new business problems and changes
• Specified and maintained naming, and programming standards
• Used Oracle Financials 11i/10.7SC, Forms 6i/4.5, Reports 6i/2.5, PL/SQL, SQL*LOADER and SQL*PLUS on Windows /UNIX

Principal Consultant

Confidential, New Orleans, LA

Responsibilities:

• Converted and imported GL journals from the legacy system
• Loaded vendors from legacy system
• Developed several GL Reports
• Used Oracle Financials 10.7NCA, Pl/SQL, SQL*LOADER and SQL*PLUS on Windows /UNIX.
• Involved in the implementation of GL, PO and AP involving conversion, customizations, interfaces and report development.
• Loaded the items and vendors from external source into the system. - Developed and customized several reports in GL, AP and PO including Budget Balance, Budget Status, Account Analysis, Salary Savings, Appropriation Activity Summary, Print PO, Invitation to Bid and Multi-payee Voucher Details.
• Customized forms in GL and PO.
• Created several valuesets and set up descriptive flexfields to be used in the forms and reports.
• Tuned several custom reports and forms and provided technical help to other programmers on the project.
• Used Oracle Financials 10SC, Forms 4.5, Reports 2.5, PL/SQL, AOL, SQL*LOADER and SQL*PLUS on Windows /UNIX.