We provide IT Staff Augmentation Services!

Development Manager, Business Systems Resume

Chantilly, VA

SUMMARY:

Technical and Functional Subject Matter Exert, with over 20 years of experience providing implementation and sustainment services in Oracle E - Business Suite, of which the past 15 years have been with Federal customers. Confidential specializes in Oracle ERP functional and technical areas, and has led functional, development and database administration teams. He establishes, executes, and coordinates technical activities with a hands-on approach that includes best practice project management, functional implementation, code development, code reviews, technical documentation reviews, and advising and monitoring DBA team activities. Confidential brings deep expertise to Oracle ERP management, leading functional and technical teams, architecting critical solutions, providing thought management to leadership, leading Software Change Control processes, Risk Management, development of Custom Reports, Interface, Conversion, Extension and Workflow items and associated configuration management and testing disciplines. He works effectively with customers to identify and validate requirements, designs functional and technical solutions, and collaborates across teams to ensure a high-quality end product.

TECHNICAL SKILLS:

  • Business Suite Applications (P2P, O2C, B2R, A2R, CRM)
  • Oracle Financials Cloud
  • Oracle Accounting Hub
  • Project Management
  • Team Leadership
  • Service Management
  • Design and Development of Reports
  • Interfaces
  • Conversions
  • Extensions, Customizations
  • Workflow
  • XML, PL/SQL, SQL, Core Java
  • UNIX Shell Scripting. PERL
  • Oracle Forms, Reports
  • Performance Tuning
  • Functional and Technical Design Documentation (AIM)
  • Excellent Root Cause Analysis and Troubleshooting Skills
  • TOAD, Oracle SQL Developer
  • C, C++, Pascal
  • MS Office Suite, Visio, MS Project

Technical Specialist

  • Setup and support Oracle Receivables, Sales Compensation, and Sales and Marketing.
  • Train new employees on the functionality of the Oracle Applications.
  • Provide technical support services in Oracle Application Object Library and Accounts Payable.
  • Install Vertex/Quantum for Sales and Use Tax software
  • Integrate Quantum for Sales and Use Tax software with Oracle Receivables and Oracle Order Entry
  • Integrate Taxware/AVP software with Oracle Receivables and Oracle Order Entry
  • Customize and support tax views for the Tax Vendor extension
  • Implement and support U.S. Sales Tax and Value Added Tax
  • Setup and implement the AutoInvoice interface – using SQL*Loader and PL/SQL.
  • Write feeder programs to populate interface tables – using SQL*Loader and PL/SQL.
  • Setup Transaction Flexfields and assign System Options
  • Setup Accounting and Invoicing Rules, and Grouping and Line Ordering Rules
  • Setup Batch Sources, and import Revenue, Tax and Freight lines
  • Improve the performance of AutoInvoice using tuning techniques
  • Setup and implement Sales tax Rate Interface
  • Create/modify SQL*Loader control file for importing data into interface table
  • Import data from multiple sources
  • Verify the sales tax location flexfield structure
  • Clean up the tax tables and verify that all addresses comply with the Vertex values for proper taxation
  • Perform monthly upload of tax data
  • Setup and Implement Customer Interface – using SQL*Loader and PL/SQL.
  • Import data into interface tables
  • Reconcile Receivables
  • Setup and implement Consolidated Billing
  • Assist Development in testing new and existing releases of Oracle Receivables
  • Implemented and tested the Archive and Purge processes
  • Performance tuned Oracle Applications
  • Tune Executables using trace
  • Tune Reports – Modify reports to set the trace on the report only instead of whole database trace – used Reports 2.5
  • Tune Forms – Use the form trace option within the Oracle Applications
  • Tune the Transaction Workbench – using Forms 4.5
  • Tune the Collections Workbench – using Forms 4.5
  • Tune the Receipts Workbench – using Forms 4.5
  • Setup Multi-Org
  • Setup Auto Accounting
  • Implement Customer Merge
  • Implement Dunning Letters
  • Implement and fine tune Customer Statements – using Forms 2.5
  • Provide data fixes for corrupted data
  • Cleanup Unposted Items Report to help close periods
 

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

Development Manager, Business Systems

Responsibilities:

  • Design, development and maintenance of various Reports with XML Publisher and Oracle Reports, Interfaces, Conversions, Customizations, Extensions and Workflows. Various tools and programming languages used include: Oracle Database, Oracle E-Business Suite of applications, SQL and PL/SQL, UNIX Shell scripting, XML, Java, Oracle Reports, Oracle Forms, Oracle Workflow, Oracle JDeveloper, TOAD, and HP PPM
  • Highly skilled in application design and development - including Entity Relationship Diagrams (ERD), Database Schema creation, Workflows, XML, User Authentication Schemes, Unit Testing, Code Migration, and Validation
  • Led technical and functional teams working with internal and external stakeholders to coordinate and implement initiatives, e.g. Payment Management System (PMS), Fellowship Payment System (FPS), Grants, and a nVision Data Warehouse with an Informatica based ETL solution
  • Established Development Standards for Reports, Interfaces, Conversions, Extensions, and Workflow (RICEW)
  • Reviewed and approved Change Requests (CRs) to assess business and functional requirements. Updated CRs with solutions, provided Level of Effort (LOE) estimates, and managed scope.
  • Instituted a code review process to assure adherence to standards, ease of maintenance, confirm requirements compliance, review, validate and update Requirements Traceability Matrix (RTM), Unit Test Cases and Results
  • Implemented the Code Versioning System (Subversion and Tortoise), and HP Project Portfolio Management (HP PPM) suite for configuration, change, and migration of code and configurations into Production
  • Designed the solution for PMS Accruals using Oracle Subledger and Financial Accounting Hub (SLA/FAH).
  • Implemented a custom DATA Act solution that included data extraction from EBS and Non-EBS sources, analysis of DATA Act patches, and coordination with other Health and Human Services (HHS) programs
  • Developed and presented Solution Papers for multiple initiatives to internal and external stakeholders - Options Analysis, Level of Effort (LOE) or Rough Order of Magnitude (ROM) estimates, Pros and Cons and Recommended Options. E.g. Data Act, PMS, Third Party Treasury Accounting Symbol (TP-TAS) options, Accounting Segment Changes, iSupplier/eVIP (electronic Vendor Invoicing Program)
  • Led Requirements and Solution discussions with external system owners - e.g. Two-way interface between Oracle EBS and the Scientific Review and Evaluation (SREA) system for creation and modification of transactional data such as s/POs, Invoices, as well as master data such as Suppliers, and Encryption and Decryption of Bank Accounts using Oracle Trading Community Architecture (TCA)
  • Mentored the team decommissioning an Oracle Projects Enhancement (OPE) solution to use R12 features.
  • Performed R12 upgrades to key custom solutions - e.g. Budget, Requisition and PO, and GL Approval workflows; UPIID solution to meet the Federal numbering scheme guidelines; GTAS solution for populating TP-TAS for Cost Management and Custom sources such as eRA, Property, and Payroll
  • Designed and developed key custom interfaces from the legacy Central Accounting System to GL, custom manual journal entry forms, custom ETL from Oracle GL to the NIH Data Warehouse, custom extension to automate an AP Interface, custom emailing routines, custom Payables Advance Accounting solution, and a custom Receivables Multi-Fund accounting solution.
  • Architected and developed the technical solution for expedited NBS Year-end Close.
  • Led initiatives to prepare for Year-End close of procurement and financial systems through Data Quality and Integrity verification and correction in a hands-on leadership role.
  • Implemented the AppWorx scheduling solution.
  • Developed an accounting error correction solution that identifies errors in commitments, obligations, and accruals, and creates an Oracle Applications Desktop Integrator (ADI) spreadsheet with correction entries.
  • Worked with 11.5.10 Upgrade team on technical issues, perform patch analysis and resolve performance issues. nVision is the Enterprise Data Warehouse program using Informatica ETL and is the reporting tool that works with other systems including Oracle E-Business suite
  • Designed, developed and supported extraction programs for the nVision Data Warehouse
  • Supported the nVision Informatica ETL group in design of extractions from sub-ledgers and General Ledger
  • Led Vendor support team meetings, e.g. Oracle Support, Sunflower and PRISM support
  • Implemented Oracle E-Business Suite at NIH. Started as a developer in 2003, promoted to Technical Manager in 2009. Went live with an initial General Ledger implementation in 2005, and implemented the remaining applications including Confidential, Confidential, and Confidential in 2007.
  • Extensive experience in Waterfall and Agile methodologies. Initial implementations were based on the waterfall framework; later implementations such as the Animal Procurement system, SREA, Release 12 upgrade, OPE, and subsequent OPE retirement followed an Agile framework
  • Extensive experience in Software Development Life Cycle (SDLC) implementations, Information Technology Infrastructure Library (ITIL) practices, and Project Management Office (PMO) practices
  • Mentored new functional and technical recruits
  • Led Operations & Maintenance technical teams and in parallel worked on implementation projects such as Payment Management System interfaces, Animal Procurement Systems, OPE Decommission project, Upgrade projects for E-Business Suite and Confidential systems, Integration of PRISM and Procurement Card (P-Card) with Departmental Contracts Information System (DCIS) and Federal Procurement Data System - Next Generation (FPDS-NG).

Functional and Technical Consultant

Responsibilities:

  • Migrated Oracle EBS from version 10.7 to 11i, working as both functional and technical consultant in AR module to convert and customize financials modules, perform AR customers’ conversions using customer interface and Trading Community Architecture (TCA) APIs (PL/SQL code).
  • Worked as both functional and Technical consultant in AR
  • Conversions and customizations of Financials modules
  • AR customers conversion using customer interface and TCA APIs
  • Value set conversion
  • AR Invoices Conversion
  • AR Adjustments Conversion using APIs
  • AR Cash Receipts Conversion using APIs
  • AR Customer calls conversion
  • AP Invoices Conversion
  • HR Conversions (Employee conversions using Employee APIs, Address APIs and Assignment APIs)
  • FA Conversions
  • Vendor Conversion
  • CUSTOM.pll customizations in AR/AP
  • Customizations using TCA/HZ APIs
  • Custom Reports in Financial modules
Confidential, Toronto, ONDeveloper

Responsibilities:

  • Developed print modifications using Optio solution. Solution improved the printing of documents such as invoices, purchase orders, checks, and statements. Customized the Invoice Print program and Statement Print programs to provide the data stream in a format needed by Optio.
  • Technical design and development of the following programs, interfaces, and systems:
  • AP Invoice Import interface - Designed and developed programs to download expense reports daily from Necho (3rd party expense system) into Oracle AP using open invoice import tables.
  • Necho - Payables Reconciliation Report, Exception Report
  • AR Conversions - Conversion of customers from legacy system (SART); conversion of customer diary (call history) as attachments to converted AR invoices; AR Sundry Receivable Invoices Conversion from legacy SAR system;
  • AR Invoice Print Modifications, and AR Statement Modifications for Optio. The client had decided to use Optio as the tool for printing the documents (Invoices, Purchase Orders, Checks, Statements etc.) Customized the invoice print program to provide the data stream in a format needed by Optio

Confdential, Toronto, ON

Responsibilities:

  • Led team in implementing Release 11i Oracle Financials, Human Resource Management System (HRMS), OM, AR, AP, Vertex, PO, INV and Manufacturing Modules in a Technical Lead/Mentor Role.
  • Developed RICEW object and Alerts in HRMS, AP, PO, AR (plus Vertex) and Oracle Manufacturing (MFG).
  • Developed HRMS conversions using Oracle APIs for employees, assignments, grades.
  • Developed CUSTOM.pll for extending HRMS functionality, to validate grades, national identifiers, salary ranges.
  • Customized Engineering Change Orders (ECO) workflow in Oracle Engineering Module (ENG) module.
  • Customized requisitions workflow in HRMS.
  • Implemented iExpenses and Purchase Card extension in Oracle Payables.
  • Completed functional and technical implementation of Vertex/Quantum software, including data migration.
  • Design of custom interfaces (Cash Mgt, AR Customer, Invoices, Lockbox), workflows, reports
  • Designed and developed over 20 alerts in AP/PO and HRMS.
  • Designed and developed conversions for AR customer, AR invoice conversion and Auto invoice.

Hire Now