Oracle Business Analyst Resume
SUMMARY:
- Oracle Developer/ Business Analyst / Tech Lead position
- Hiring ManagerI have been contracting as an Oracle Developer, Business Analyst since March 1999 for a variety of industries like
- Process Manufacturing, Discrete Manufacturing, Energy, Research, and Retail. I have worked Confidential many different Oracle and Custom Applications shops.
- One of the advantages that makes me successful as a consultant is that I bring technical and functional knowledge to the table.
- Because of this, I have participated in every step of the SDLC and have worked closely with end users, external customers, analysts and developers.
- Another benefit is that I owned and operated my own business with 15 employees.
- This gave me the unique advantage of being able to see the big picture, yet still focus on the details.
- My strongest Application Modules are Order Management, Advanced Pricing, and Inventory.
- I also have experience in Financials (Payables, Receivables, and General Ledger) and Purchasing.
- My strongest languages are PLSQL, SQL+ and Unix. I have very extensive experience using Oracle Forms and Reports.
- I look forward to discussing opportunities in greater detail with you. Attached is my resume. If you have any questions please feel free to contact me.
TECHNICAL SKILLS
- Oracle Apps. R12 (OTL, TCA, OM, AP, PO, INV, Projects, Service Contracts, WIP, Install Base, BOM, Routing, Advanced Pricing, Order to Cash (O2C), Procure to Pay (P2P), light Incentive Comp, Oracle Apps. 11i (OM, Supply Chain, OPM, ATP, FA, AP, GL, CE, INV, PO, WSH, AR, CRM, TCA, Workflow, RICE objects, Oracle Reports (2.5, 3.0, 6.0, 6i, 9i), Oracle Forms (4.5, 5.0, 6.0, 6i, 9i), XML Publisher, BI Publisher, Logical Apps, Personalizations, Oracle (7.3, 8i, 9i), SQL+, PLSQL, Unix (AIX, HP, Korn), OBIEE, Maximo, MSDOS, Windows (3.1, 95, 98, 2000, NT, XP), Microsoft (Access, Excel, Word, Powerpoint, Outlook, Project), Visio, PC (building, repairing), Business Objects, light EDI.
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Business Analyst
Responsibilities:
- Production Support of (AP,GL,FA,AR) for North America, Europe and China
- Implemented Bank Statement Reconciliation process
- Designed and Implemented a custom AP Invoice Approval process.
- Designed and Implemented Bank Account Security process.
- Designed and Implemented Custom Reports
- Implemented FA Impairment process for Europe
- Designed a Custom Credit Memo Approval process
- Developed Logical Apps Rules for Order Management / AR
- Designed and Implemented AP / AR Month End Automation process.
- Regression testing for server upgrades
- Identified bugs and installed data fixes / patches.
- Performance Tuning
- Participated in all steps of the SDLC.
Confidential
Oracle Developer
Responsibilities:
- Converted Oracle 11i to Sales Force. Modules converted: TCA, OM, AR, and Service Requests)
- Designed and developed Custom Interfaces between Salesforce and Oracle. (TCA, OM, AR, and RMA’s)
- Designed and developed a front - end form for a custom Business Rules Engine using Oracle Forms.
- Designed and Developed interface between Oracle and Manhattan for Item Quantity Conversion.
- Designed and Developed custom interfaces between Oracle and Manhattan.
- Worked closely with Accounting to reconcile new inventory systems and processes with existing ones.
- Wrote several reports using SCI / Cognos.
- Production Support of Oracle 11i.
- Code reviews for onshore and offshore developers.
- Participated in all steps of the SDLC.
Confidential
Technical Lead
Responsibilities:
- Designed and coordinated technical approach for project implementation.
- Designed and developed Custom Interfaces.
- Designed and developed BI Publisher reports.
- Designed and developed Custom Reports.
- Designed and developed OBIEE Reports / Dashboards.
- Designed and developed Oracle Forms for custom Estimating system.
- Code reviews for onshore and offshore developers.
- Trained legacy developers in SQL+, PLSQL, BI Publisher, Oracle Reports and Oracle Applications.
- Participated in all steps of the SDLC.
Confidential
Oracle Business Analyst / Developer
Responsibilities:
- Business Analyst for AR, GL, FA, AP, OM, Advanced Pricing, Cash Management, and Projects
- Developer for AR, GL, TCA, Advanced Pricing, Incentive Comp, Cash Management and Projects
- Designed and developed Custom Interfaces for Oracle R12 and its satellite systems.
- Conversion of R11 customers to R12 TCA structure.
- Code Reviews for the R12 project
- Designed and developed BI Publisher reports. (R12)
- Designed and developed Custom Reports
- Designed and developed many custom processes.
- Performance tuning of many processes.
- PCI Compliance
- Production Support, enhancements and bug resolution.
- Participated in all steps of the SDLC.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for OM, CRM, AR, PO, and INV.
- Designed and Developed a custom shipping rules engine.
- Designed and Developed of several process for IVR upgrade.
- Performance tuning of several processes.
- Item Conversion, Archiving and Purging.
- Production Support and bug resolution.
- Participated in all steps of the SDLC.
Confidential
Oracle Developer
Responsibilities:
- Developer for CRM and AR applications.
- Designed and Developed customer conversion process from a custom Oracle VLDB into Oracle Applications.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for OM, CRM, AR and a custom inventory tracking/processing application.
- Designed and Developed an “online” credit card application process.
- Developed Custom forms using Oracle Forms 6i.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Designed and Developed a custom application for a Home/Commercial Security business.
- Designed and Developed a custom Quote / Project module
- Designed and Developed a custom Order Capture module.
- Designed and Developed a custom Pricing module.
- Developed Custom many forms using Oracle Reports 9i.
- Developed Custom many reports using Oracle Reports 9i.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Designed and Developed a custom CRM module
- Developed Custom many forms using Oracle Forms 9i.
- Developed Custom many reports using Oracle Reports 9i.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer
Responsibilities:
- Developer for AP, HRMS.
- Designed and Developed Positive Pay and NACHA Extracts.
- Developed Custom reports using Oracle Reports 9i.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for Order Management in an OPM (process) environment.
- Designed and Developed several custom processes.
- Developed Custom reports using Oracle Reports 9i.
- Performance tuning of existing processes.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for Oracle Accounts Payable and Order Management.
- Designed and Developed custom Cash Management interface process.
- Designed and Developed several EFT and Positive Pay bank interfaces.
- Created and Designed a COGS engine.
- Developed a custom Accrual Redemption Process.
- Created custom ship manifest and interface process
- Performance tuning of many plsql processes and reports
- Developed Custom forms using Oracle Forms 6i.
- Developed Custom reports using Oracle Reports 6i.
- Participated in all steps of the SDLC
- Software debugging of custom and standard processes in PO, INV, OM and AP
- Working closely with developers, analysts, and users to troubleshoot and solve database issues
- Documentation of custom processes.
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for Oracle Accounts Payable and General Ledger.
- Designed and Developed custom General Ledger interface process.
- Designed and Developed custom Cash Management interface process.
- Created custom email notification program
Confidential
Oracle Developer/Systems Analyst
Responsibilities:
- Developer for Order Management in a OPM (process) environment.
- Designed and Developed several custom processes.
- Order Import performance tuning
- Created a Custom Form using Oracle Forms 6i and Custom.pll
- Written a PLSQL EDI extract.
- Developed four Custom reports using Oracle Reports 6i.
- Production Support and bug resolution
- Participated in all steps of the SDLC.
Confidential
Oracle Developer
- Converted 11 PLSQL extracts to Oracle Applications 11i.
- Designed and developed a Custom Form using Oracle Forms 6i.
- Designed and built a custom table, index, and synonym.
Confidential
Business Systems Analyst
Responsibilities:
- Lead Functional OM Analyst for a Vendor Managed Inventory Project
- Designed and written documentation for a Order Entry conversion.
- Written several reports using Oracle Reports 6i
- Participated in all steps of the SDLC
- Software testing for custom processes for PO, INV, OM modules.
- Software debugging of custom and standard processes for PO, INV, OM modules.
- Solution Design
- Working closely with developers and users to troubleshoot and solve database issues
Confidential
Primary Order Management Developer
Responsibilities:
- Designed and implemented processes in the OM and CRM modules of an Oracle 11i Application environment including Advanced Pricing.
- Developed a business critical custom Order Entry form
- Developed several custom forms using Oracle Forms (6i).
- Wrote several reports using Oracle Reports (6i).
- Designed and developed several Workflow processes.
- Created custom defaulting rules in Order Management
- Created custom processing constraints in Order Management
- Wrote many scripts using PLSQL utilizing Oracle API’s
- Developed several processes in the Custom.pll
- Provided production support for OM, AR, and CRM modules.
- Tutored Confidential /Motion employees on Oracle Reports (6i) and Oracle Forms (6i).
