System Analyst/techno/functional Resume
FloridA
SUMMARY:
- I have excellent experience in system analysis, design, development, Testing and implementing Oracle Applications (11.5.9/11.5.10 ) In addition, my proficiency in Oracle (Oracle 7.x/8i/9i) and Strong knowledge of Oracle 9iAS, PL / SQL* Plus, Forms 4.5/5.0/6.i/9i,Reports 6i/9i, BPEL, Oracle Jdeveloper 10g,
- JAVA, J2EE Good knowledge of OAFrame work, Oracle development and Data Modeling, Unix Shell Scripts, Stored procedures, OLAP, web Application, Web Service, ORACLE XML, Oracle Advance Queuing and JMS (Java Messaging system), Oracle raptor, Oracle Finance Application (GL, AOL, iProc, iSupplier, PO, AR, AP, PO, Cash Management, XTR,SCM), OM with Developer 6i/9i (Forms 9i, Reports 9i) should also serve in meeting the requirements of this position. I can offer to your company:
- 9 + years of Information Technology experience with excellent Oracle Application Skills.
- Ability to handle multiple projects independently and within a team environment; work effectively under pressure
- Excellent analysis, designing, documenting and problem solving skills
- Outstanding multitasking, project management and leadership skills
- Excellent communication and interpersonal skills
- Extensive 8 yrs experience in Oracle Applications 11i in various modules (GL, AOL, iProc, PO, iSupplier, iReceivable, AP, AR, PA, Order Management, and FA) with major strength in GL, AOL.
- Excellent Oracle Finance implementation Knowledge.
- Application Development, including Oracle Application, PL/SQL, SQL Plus with over 9 + years of experience.
- Expertise in Development/ Customizations/ Conversions/ Up - gradation/ Debugging/Integration of Oracle Applications.
- Extensive experience in Application Object Library (AOL), Work Flow and OAF.
- Detailed design and Development of Interfaces, Conversions, Customization & Enhancements of Forms and Reports.
- Excellent knowledge of General Ledger, Account Receivable, Account Payable with AOL.
- Involved in Project Analysis, Design, and Development, Performance Tuning & Testing. Active participation in providing technical support to entire team and involved in development.
- Experience in importing information into oracle Apps from legacy Systems.
- Co-ordination with clients, involvement in implementation of project at client sites.
- Strong Knowledge of ORACLE11i Financial, OAF.
TECHNICAL SKILLS:
RDBMS: ORACLE 8i/9i/10g, Oracle Application 10g, SQL, PL/SQL, Import - Export, SQL Loader
ERP Applications: Oracle Applications 11i (11.5.9) (GL, iPorc, iSupplier, iReceivable, AP, AR, AOL, PO, Cash Management, SCM, Order Management).
Web Server: Oracle Application Server 10g, Personal Web Server, APACHE, XML
Operating Environment: Windows NT 4.0, UNIX HP, Windows NT 4.0 Workstation, Windows 95,Window 2000 Pr.
Programming Languages: JAVA, Pascal, TURBO C, C++, J2EE Application In ORACLE 9i
Internet Tools: VBScript, HTML, Java Script, JSP
Front End Tools: Developer 2000 Rel 5/ 6i,Jdeveloper 10g/9i
Packages: Office 2000 Suit, MS Access 97
Case Tool: Designer 2000 Rel 6i (Forms 9i/6i . Reports 6i)
Area of Interest: Web Application Development (E-Commerce), E-commerce
PROFESSIONAL EXPERIENCE:
Confidential
System Analyst/Techno/Functional
Responsibilities:
- Involved in Oracle extension including workflow, Interface, OAF and customization of forms.
- Involved in Full Life cycle Implementations of Oracle 11i.
- Developed and customized OAF component for iProc/OTL (Extending VO).
- Co-ordinate with Functional user to get the requirement to convert into MD70.
- Implemented RMA process (Order Management) from Custom Approval to Restocking Fee.
- Customized Order, Line Workflow to meet the business requirement.
- Implemented AR Collector API and Developed New OAF page.
- Customized PO, AP Workflow.
- Project Spend overspend trigger process in iProcurment.
Confidential
System Analyst/Techo/Functional
Responsibilities:
- Involved in Functional Design Review (MD50) with client for GL Conversion implement.
- Developed Technical Design as per Business requirements which have defined in MD50.
- Developing custom PL/SQL conversion program for GL Rate Conversion for Austria, London, Italy and Swiss with different reporting currency.
- Successfully implemented GL Conversion Program for one of Eroup branch.
- Working in Multi currency. Involved in unit testing and reviewing of interfaces and Modified reports.
- Involved in Full Life cycle Implementations of Oracle 11i in GL.
- Successfully implementation conversion for Austria, London, Germany and Swiss.
Confidential, Florida
Techno/functional
Responsibilities:
- Involved in Functional Design Review (MD50) with client, Created MD70 for Oracle Finance including iProc and Build he system and implement.
- Successfully implementation of Finance module that include PO, iProc, iSupplier, AP, AR and Oracle Projects.
- Created PL/SQL Interface to transfer project data from SQL Server to Oracle apps for global.
- Defined Conversion Strategy for millions of records.
- Developed custom PL/SQL conversion program for Item, Purchase Order and Oracle receipt.
- Modified PO Approval, ASN (Advance Shipment Notice), ASBN Workflow in iProc module to meet client requirement.
- Created and Customize Page and deploy base on business requirement in OA Framework for iRec and iProc module. Used XMLimport & XMLExport utility to modified existing OAF Page.
- Worked with MTL SYSTEM ITEMS INTERFACE (Open Item Interface) and PO Interface as well as Oracle Project’s API (PA PROJECT PUB, PA BUDGET PUB).
- Ensured development team deliverables meet function, performance and quality specifications.
- Modified AME Workflow and defined attribute, condition, Approvers and Rules (Oracle Approval Management) in AR for Dispute transaction to meet client requirement.
- Good knowledge in BEPL.
Confidential, New Jersey
Technical Consultant
Responsibilities:
- Successfully Upgrade from 11.5.9 to 11.5.10 (Involved in All Modules).
- Fixed the invalid objects during upgrading.
- Convert Function design (MD-50’s) into Technical Design Documentation (MD-70’s).
- Developed custom PL/SQL program for loading AP Invoices using Oracle Standard AP Invoice Interface.
- Worked with Main GL table i.e. GL JE HEADERS, GL JE LINES, GL SET OF BOOKS, AR Interface, Customer Interface and GL interface (GL INTERFACE, GL BUDGET INTERFACE.)
- Defined the descriptive flex fields and key flex fields.
- Created Value sets for report parameters and registered in application using AOL.
- Developed custom PL/SQL conversion program for Import Journal (GL INTERFACE) and also loading customers using Oracle Standard Customer Interface Program.
- Developed custom PL/SQL conversion program for loading GL Balances using Oracle Standard GL Interface program. (Modified AR Lockbox Programs) and Involved Unit testing.
Confidential
Oracle Apps Technical Consultant (Support/Analyst/Developer)
Responsibilities:
- Financials (GL, AR, AP, PO and Cash Management) and Supply change Mang SCM (Inventory, Order Management, Purchasing, Bill of Materials, and Shipping).
- Prepared design and technical documents for Customers, AR Open Invoices, AP Invoices, PO vendors, GL balances conversions, and Reports.
- Modified PL/SQL Package based on business requirements.
- Implemented Bank file Auto Load, Import (Concurrent Program) in Interface through UNIX CONSUB job. Closely worked with BANK ( Confidential, BOM )
- Worked for BANK Interface (BOA), Exchange Rate Interface. Created PL/SQL Package for BANK Wire Payment.
- Involved in unit testing and reviewing of interfaces and Modified reports for BANK.
- Developed custom UNIX shell script which is submitting concurrent program.
- Developed custom PL/SQL conversion program for loading PO Vendors using Oracle Standard Vendor API
- Developed PL/SQL programs for Item Revision Extract, Item Cost Extract, and BOM Components Extract using UTL FILE.
- Developed custom Reports such as GL Multi-Currency, AP Internet Expense Activity, AP Employee EFT Payments and AR Sales/Use Tax Extract Reports using Oracle Reports 6i.
Confidential
Senior Oracle Apps Consultant
Responsibilities:
- Successfully Implement Financials (GL, AR, AP, Cash Management).