Senior Oracle Ebs Specialist Resume
SUMMARY:
IT Professional with over 20 years experience, primarily with Oracle technologies. Possess strong RDBMS concepts including abstract concepts of set theory. Excellent interpersonal, communication and leadership skills.
TECHNICAL SKILLS:
- Oracle RDBMS: V6, V7, V8, V9, V10
- Oracle Financials Technical: V10.5 through V11.5.10 and R12
- Oracle data warehousing functionality (star schemas, bit map indexes, query optimization, etc.)
- Oracle Forms, Reports V3 through V10
- Oracle CASE 5.0, 5.1 and Designer/2000
- Oracle BPEL, SOA and OAF.
- Oracle ADF with forms migrations
- Webforms 6i/9i deployment with Oracle Application Server
- Web Reports 6i/9i
- PL/SQL
- Application Services with Citrix
- Sql*Loader
- C and ProC
- Java2, Servlets
- Progress versions 6 and 7
- Shell programming using Bourn, Korn and C shells
- Sybase
PROFESSIONAL EXPERIENCE:
Confidential
Senior Oracle EBS Specialist
Responsibilities:
- GL and Subledger Account with Multi Currency Reporting.
- TCA for Customers & Suppliers. Established global Customer Master and Suppliers to be used by all business units.
- Credit Management with D&B integration, Advanced Collections, Approvals Management, Confidential Queue.
- Order Management configured with Credit Management.
- OSM - Established centralized Order and Service Management, Billing, Receivables and Collections. Integrated several CRMs globally. Developed OSM orchestrations.
- Cash Management: Lockbox, Auto Application, Dispute Management, Automatic Receipt Deduction Settlement(ARDS).
- Receivables (manage, collect and calculate global credit exposure).
- Procure to Pay - Standard Purchasing, iSupplier, AP Invoices, Intercompany Vendor / Customers.
- Led Business Process Improvement Initiatives:
- SOA Enable Interfaces using weblogic 10.3. System integrations originally developed as flat file, pipe delimited batch processes enabled as real time, SOAP endpoints. Especially successful for Global Credit. Reduced credit decisions from 1 hour to 30 seconds.
- Operating Unit Consolidation. Original system design unnecessarily defined many operating units that hampered credit exposure calculations and cash application. Developed systematic, repeatable process to consolidate operating unit transactions, customers, sub-leder, credit exposure, collector queues.
- General Ledger consolidation/reassignment. Developed repeatable systematic procedures to move GL and Subledger Accounting from ledger to ledger, legal entity to legal entity including GL rebalancing where source and target ledgers had different local currency.
- Global Customer Master (TCA) - Restructured TCA and Receivables to use 1 global customer master. This greatly reduced reduntant TCA information and brought customers to the a level to more effectively work with Dunn & Bradstreet integration.
- Vertex Integration with AR, AP and Payroll.
Confidential
Technical Manager
Responsibilities:
- Implemented Oracle Billing Revenue Management.
- Stream lined billing processes.
- Implemented regional and bundled pricing mechanisms.
- Integrated BRM with existing legacy systems.
- Designed and developed interface points with Confidential .
- Involved in the implementation of Ebusiness Applications (R12) .
- Implemented Oracle Payables, Oracle Approval Management and a Custom Java web based application for supplier invoice entry.
- Worked as a technical and functional lead consultant to implement Oracle fixed assets, Oracle Projects and a custom web-based application to process projects and project related invoices.
- Involved in integrating Oracle Applications with mainframe applications. Oracle Applications R12 and Sun Solaris.
- Business intelligence reporting technical lead.
- Led design and development of intelligence reporting and data warehousing.
- With Oracle Ebiz R12, used Oracle Data Integrator (ODI), Confidential and BI Publisher.
Confidential
Senior Oracle Lead DeveloperResponsibilities:
- Lead Technical Architect for eBusiness intergration with SOA using AIA (BPEL) components.
- Existing point to point flat file interfaces where replaced with multi point pub/sub model using Oracle Application Integration Architecture.
- Worked closely with the Oracle Product Development team to identify product deficiencies. Designed and developed working proof of concept for order updates to flow back to Siebel.
Confidential
Technical Lead
Responsibilities:
- Analyzed system deficiencies, gathered requirements, gap analysis.
- Designed and developed custom interfaces with Confidential .
- Implemented Confidential customizations including reports.
- Technical Lead for post production support and stabilization.
- Analyzed system deficiencies, gathered requirements, gap analysis.
- Conducted a min full life cycle effort using AIM methodologies.
- Architected Business Intelligence Reporting (BI Reporting) with BI Publisher and Confidential .
- Deployed Forms application on Citrix.
- Deployed Web Forms 6i/9i with Oracle Application Server.
- Functioned as overall technical manager and led development of custom forms, reports and programs. Confidential led a staff of designers/developers from requirement, through development into user acceptance and production roll out.
- The bulk of the development team was based off shore.
- Confidential workload for 23 offshore resources. Confidential was also tasked with establishing coding standards and performed code reviews. As typical with offshore efforts, Confidential was the liaison between the development staff and onshore functions SMEs.
- Diagnosed and resolved issues with poorly performing forms running through the web enabled application server. Specifically worked to identify performance problems as configuration or development issues related to Confidential Queue. Identified problem SQL in forms, reports, programs and JTF programs. ntroduced and led efforts to use new technologies with the mature Ebiz suite of software such as XML Publisher for customer facing documents (Oracle BI Publisher).
- Confidential has architected large application integrations between Oracle Ebiz and Siebel CRM, third party product configuration and legacy install base. Integration methods have included simple point to point flat files using Oracle Open Interface method as well as newer publisher - subscriber methods.
- Message based pub-sub projects have been developed with the industry leading Oracle BPEL along with Oracle’s AIA ebiz adapters. Project experience also include other middle tier software such as Tibco and SeeBeyond.
- Used Oracle ODI and ETL*Extract.
Confidential
Senior Oracle Lead DeveloperResponsibilities:
- Led technical team on new implementation of 11.5.9 (GL, AR, AP, OM, FA, OE). Established project standards, managed developer workload, performed code reviews and mentored junior team members. Designed highly reusable modules for updating CSV files from the user desktop into a database blob that could then be processed by a concurrent program. Designed and developed a custom PDF/data merge similar to XML publisher but more robust in that it could create dynamic fill-in fields and checkboxes to be used with FDF data. Designed and developed Iexpenses feature for users to upload scanned receipts. Financial reporting with Confidential . Extensive setup of Oracle Configurator for made to order kitted products.
- Identified performance issues with the Application Server, Forms, Reports, Programs and SQL. Ensured proper application server configuration and identified bottlenecks. Identified and corrected poorly performing extended functionality in Confidential queue. Identified and redesigned unrestricted queries that produce large record sets in LOVs and form blocks. Identified SQL problems using DB tracing and query statistics analysis tools such as tkprof.
Confidential
Senior Oracle Lead DeveloperResponsibilities:
- Interfaces for Oracle Project Accounting using AIM methodology. Create active projects and tasks based on Order Entries captured on Oracle order management for professional services, create project budgets and project agreements using Activity Management Gateway APIs, also send e-mail notifications to project managers using Oracle Alert.
- Design build and test a Fixed Assets Interface for Rental assets solution using Oracle assets standard APIs including additions, transfers and retirements.
- Reports for Accounts Receivable.
- Send escalation notifications for Order management using PL/SQL standard APIs. Modify Contract Approval Workflow.
- On site post-production support.
- Oracle Applications 11.5.8, PL/SQL, RDBMS V9.
- Led upgrade effort from 11.0.3 to 11.5. Development utility to automate recoding of certain AR tables obsolete due to new Confidential objects (HZ PARTIES, etc). Conducted code and performance reviews. Analyzed original gap analysis documents to identify custom procedures no longer needed.
- Participate in a CRP to get the technical specifications and estimate extensions for the Gaps of the Business Requirements in Oracle Project Management and Oracle Project Resource Management 11.5.7 using AIM methodology.
- Deployed forms 6i, 9i with Citrix.
- Led the deployment of an Oracle 9i DB / 9iAS platform implementing a sales analysis data warehouse for a major car rental company.
- Designed star schema and indexing scheme to ensure acceptable performance of reporting applications.
- Created a code generator to produce most of the warehouse loading procedures from detailed specs in MS Excel.
Confidential, Fairfield, NJ
Senior Oracle Lead DeveloperResponsibilities:
- Oracle Financials 11i Implementation and Customizations (AR, AP, GL, OE, HR)
- Extension and Customizations Cell Lead
- Planned and managed 11i extensions and customizations
- Review and approve technical designs
- Perform code reviews and Q/A
- Managed offshore development.
Confidential, Raritan, NJ
Senior Oracle Lead Developer
Responsibilities:
- Planned and managed 11i upgrade to version 11.5.9
- Participated in the implementation of 11i in a medical supply manufacturing environemt.
- Established project standards for coding and documentation.
- Developed custom HR payroll interface programs and reports
- Invented a custom PDF document data merge program to produce sophisticated documents such as invoice, credit/debit memo, return material authorizations, etc.
- Identified and corrected system performance issues.
Confidential, Hunt Valley, MD
Senior Oracle Developer
Responsibilities:
- Most assignments where related to Confidential ’s core business of fleet vehicle management.
- Developed new SeeBeyond systems for data warehouse systems
- Implemented new business functions related to management of vehicle fleets such as title and preventative maintenance.
Confidential, Parsippany, NJ
Senior Oracle Lead Developer
Responsibilities:
- Implemented Oracle Financials in a wise manner for a corporation in acquisition mode of travel related companies.
- Developed project standards including set up of “custom Oracle applications”
- Developed strategy for newly acquired companies to be brought onto the core ERP system and how to spin off sold entities.
- Installed 11i technology stack, web servers and Financials Application.
- Developed critical interfaces: ACH, Positive Pay, EFT, 1099
- Developed conversion programs for open invoices, vendors
- Modified core Oracle invoice and payment processing.
Confidential, South Portland, ME
Senior Oracle Lead Developer
Responsibilities:
- Designed, developed and performance tuned a data warehouse application for a fuel charge card processing company.
- Re-designed aspects of the application to utilize data warehousing features of Oracle. Defined facts and dimensions and optimized the data model into a star schema.
- Single handed developed all inbound programs to process data from feed systems
Confidential, Hunt Valley, MD
Senior Oracle Developer
Responsibilities:
- Created a data warehouse application for sales analysis for a major car rental company.
- Function as the corporate Oracle expert.
- Lead development team of four.
- Redesigned existing data model and implementation strategy to exploit Oracle’s data warehousing features (star schema, parallel queries, bit map indexes, etc)
- Created code generator to produce the warehouse load routines. To the best of my knowledge, not a single bug has been discovered in this generated code.
Confidential, Sugarland, TX
Senior Oracle Lead Developer
Responsibilities:
- Managed technical team of 4.
- Devised project plan and managed work assignments.
- Developed code manipulation program that saved Confidential $350,000 of effort.