SUMMARY:

• IT Professional with over 20 years of experience specialized in Oracle.
• Oracle ERP Functional Specialist and Technical Lead
• Oracle Fusion Cloud Implementation Specialist
• Strong Analytical skills.
• Implemented/Upgraded Various modules in Oracle ebusiness suite (R12)
• Balanced knowledge of Functional and Technical aspect of Oracle Applications.
• Managed Data Warehouse modules which involves large amount of data.
• Strong in PL/SQL, Oracle Database development, Oracle Forms, Reports, development.
• Have excellent Design and Development, Functional and Technical experience in big projects and modules
• Experience in building OBIEE repository and other tools.
• Hard working, dedicated, self motivated team player and a fast learner

TECHNICAL SKILLS:

Oracle E - business suite(11i and R12) Financials Order Management Process Manufacturing Purchasing Inventory XML Publisher Oracle Business Accelerator (OBA-Implementation Tool) Oracle Fusion Cloud Payables General Ledger iProcurement Tax Other Oracle Tools Portal Application Express Oracle 11g/10g/9i/8i/8x/7x Database PL/SQL Oracle Forms / Reports Developer SQL Loader SQL SQL DBA Erwin Crystal Reports

PROFESSIONAL EXPERIENCE:

Sr. Functional Consultant

Confidential

• Lead Implementation of Oracle Fusion Application for all international Business units across the globe. Modules implemented are Payables, iProc, Financials and Tax for 14 different countries. Integrate with Oracle ERP R12 and other external systems. Roles include analyze, provide POC, business requirement gathering, Fit gap analysis, Configuration, Deployment planning, UAT, Training and support.
• Functional Financial Team lead for R12 (11.5.10 to R12.2.4) Upgrade project. Analyze gaps between business process, customization and upgrade changes. Lead Business Transitions, Change Management and validate upgrade. Work closely with Business Process Analysts and Users through test cycles and UAT. Upgrade and post Go-Live support.

Confidential, El Segundo, CA

Sr. Oracle Programmer / Business Analyst

• Senior systems Analyst and a core Member of SARA (Service And Repair Automation) system.
• The system involves major modules like Financials, Receiving, Over the Counter Sales, Inventory, Work order, Shipping, Advance Replacements, Data Warehousing & Claims. As a team member my responsibility include analyze the functionality, design and development of screens, menus, Reports, functions, procedures and creation of stored procedures to enforce business rules. Developed standards, templates and library for the system. Designed standards for GUI based front-end applications. The standards covered general object layout, screens, menus and all window objects.

Confidential, Irving TX

Oracle Developer

• Responsibilities included design, data modeling, script specification, development, testing and user training of company’s Payroll System, which is developed in Oracle 7.2 and Developer/2000. The system runs on NT server and Windows 95 workstation and maintains employees’ indicative information as well as historical payroll data. The functionality covers employees’ leave time, loans and advances, and detailed payroll information, including standard deductions and deposits.

Confidential

Oracle Programmer

• Responsible for client interaction, enhancement, coding, implementation and user training of Warranty and Insurance System developed in Oracle 7.3 and Developer/2000. Duties included building and implementing back-end bridges with other systems of the company, including Inventory Management, Financial Accounting, and Service and Parts Management modules. Back-end Triggers were written to reflect updates in the Service and Parts Modules and whenever the Accounting system was updated
• As a member of the team, responsible for the enhancements and maintenance of company's Financial Accounting System which was developed in Oracle 7.3/Developer 2000. Involved in analysis, re-design and implementation of numerous screens and tables in support of trial balance, profit and loss statement, and balance sheet modules. Duties included interface design and development of bridges between other sub-systems of the company.
• Involved in analysis, database planning, development, and implementation of company's Service and Parts Management System. The system processes customer and vehicles' indicative information, as well as scheduling and assigning jobs to mechanics. Duties included development of Parts Inventory and Invoicing sub-systems which process parts requisition and details labor and parts costs. Also developed extract modules to transfer and update corresponding data to company's Financial Accounting System.
• Responsible for client interaction, design, development of user interface, testing, implementation and user training of Warranty and Insurance System on Oracle 7.3, Developer/2000, Erwin Windows 'NT Server and Windows '95 Workstation. The system maintains information on part number, warranty documents, warranty policy, and effective guidelines for dealers in fulfilling service obligations towards warranty repairs. Triggers for this system were written at the front-end level.
• Responsible for client interaction, analysis, prototyping, development of user interface of Financial Accounting System on Oracle 7.3, Developer/2000. This project included payments, receipts, journals, ledgers, vouchers, trial balance, profit & loss statement and balance sheet modules.
• Involved in analysis, design, creation of data model diagrams, script specification, development of user interface, and database tuning of Accessories Purchase System using Oracle 7.2, Developer/2000, and Erwin. The purchase module is exclusively developed for accessories and starts with placing an order with the supplier. A back-end process was developed to automatically generate and assign a unique identifier for each order when the order is introduced/placed. On receipt of goods, quantity received is verified with the number of orders placed and verification process is triggered. This system also included development of purchase order, merchandise received, purchase returns, sales invoice, and sales returns reports.