PROFESSIONAL SUMMARY:

• Over 8+ years of extensive experience with Oracle Applications.
• Extensive experience in the technical aspect of Oracle Applications 11i (AOL, OA Framework, GL, PA, Purchasing, AP, AR, iProcurement, iExpense, Order Management, Oracle Inventory, BOM, WIP, OPM, MRP, WMS Shipping, ASCP, Oracle HRMS, Payroll, XML Gateway)
• Involved in Oracle based business application design and development, implementation, customization, maintenance, support, conversions, interfaces and user training.
• Experienced in Forms 6i/4.5, Reports 6i/2.5, Work Flow builder, JDeveloper, Discoverer 4i,SQL*Loader, Actuate Reports, UNIX Shell Scripts, SQL and PL/SQL.
• Comprehensive knowledge of System Life Cycle Development
• Strong knowledge of AOL, System Administration and AIM methodology
• Significant experience in Application Development, using Stored Procedures and Database triggers, as well as migration of data from legacy systems.
• Designed various application level securities in Oracle Applications so that segregation of duties within an org can be well maintained.
• Extended interfaces to Oracle Applications from shop - floor systems that are not in Oracle.
• Worked a lot on mapping data from legacy systems to Oracle Applications.
• Experience in creating and managing Service Requests with Oracle.
• Experience in Source Code Control and Software Change Management (Mercury ITG, PVCS and Source Safe)
• Excellent verbal, written and inter-personal communication skills.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i (AOL, OA Framework, GL, PA, PO, AP, AR, iProcurement, iExpense, Property Manager, OM, BOM, WIP, OPM, MRP, Oracle HRMS, Payroll, XML Gateway, WMS Shipping, ASCP.)

Database: Oracle 10g/9i/8i/8.0/7.x, MS Access

Tools: Oracle Forms 6i/4.5, Reports 9i/6i/2.5, JDeveloper, Discoverer 4i, SQL*Plus, SQL*Loader, TOAD, BI Publisher, Bar Tender.

Languages : PL /SQL , C, C++, Java, PHP, SQL.

OS : Windows 2003 Server/NT/2000/ XP, UNIX, Sun Solaris.

Web Technologies : ASP, JavaScript, VBScript, CGI, Perl

Other Skills: UML, XML, FrontPage, CSS.

PROFESSIONAL EXPERIENCE:

Confidential, Long Island, New York

Applications Developer

Environment: JD EDWARDS(8.12), Oracle 10g, PL/SQL, AP, AR, GL, SQL*Plus, TOAD, BI Publisher, Bar Tender.

• Developed AP Check Printing Template using XML Publisher(BI Publisher).
• Developing XML templates for Reports like “Purchase Orders Report” using XML Publisher.
• Developing barcode information and printing the labels using Bar Tender.
• Involved in SQL Tuning for efficient report execution as part of applications development.

Confidential, Omaha, Nebraska

Oracle Applications Developer

Environment: Oracle Applications 11.5.10.2 (AOL, PO, AP, AR, GL, FA, CE, HR, XML Gateway, PL/SQL, SQL*Loader, Reports 6i, SQL*Plus, Oracle 9i, TOAD.

• Worked on the conversion of legacy data to update the job categories for the new system requirements using API
• Wrote interface programs which extract the data from HRMS using SQL and PL/SQL
• Was involved in writing various PL/SQL procedures, packages, functions and reports
• Created various reports like new hires, terminations etc in a particular organization.
• Created technical design documents
• Updated the performance evaluation data using the Oracle SIT update API.
• Worked on the settings and shell scripts to automatically mail the report output run in oracle applications to the desired users.
• Created temporary tables, and conducted data conversion and mapping of data from legacy system to Oracle Applications using PL/SQL and SQL*Loader.
• Migrated the data from legacy systems into the temporary tables in Account Payables (AP). Successfully designed and implemented the Payables Open Interface. Activities involved creation of Loader File, porting Invoices into the AP Invoices Interface and AP Invoice Lines Interface interface tables using SQL*Loader and then using Payables Open Interface to port the data into the actual tables.
• Developed the conversion of Customer from legacy systems to Oracle Applications, Imported external invoices into Oracle Receivables (AR) through Auto Invoice Program using SQL*Loader.
• Developed AP Check Printing Template using XML Publisher(BI Publisher).
• Migrated XML, templates, style sheets and Web ADI’s using FNDLOAD.
• Ticket resolution of critical tickets

Confidential, Houston, TX

Oracle Applications Developer

Environment: Oracle Applications 11.5.10.2 (AOL, PO, AP, AR, GL,PA, FA, Property Manager, XML Gateway, XML Publisher PL/SQL, SQL*Loader, Reports 6i, Forms 6i, SQL*Plus, Oracle 9i, TOAD.

• Design, Development & Support of Oracle Financials, Oracle Inventory and Oracle Purchasing modules.
• Involved in design, development and customization of Oracle Reports like
• AR Reconciliation report. AR, AP, GL and PO Intercompany reports. Purchase Orders report. Printed Purchase Orders report.
• Created Custom Purchase Order XML Template for PO Output for Communication program using XML Publisher.
• Created trigger on PO DISTRIBUTIONS ALL table to change PO Approval Match to 2 - WAY depending on the PO Line amounts, Project number and Project type.
• Developed AP Check Printing Template using XML Publisher.
• Developed XML templates for Reports like “GL Journal Report”, “AP Trial Balance Report” and “Depreciation Projection Report” using XML Publisher.
• Implemented sending Purchase Orders to Suppliers in Purchasing through Oracle Supplier Network (OSN).
• Modified the CUSTOM.pll for forms personalization on PO forms.
• Created Custom alerts.
• Installed Logical Apps software (ERP part) on database server and also modified the CUSTOM.pll as part of installation.
• Created Custom Forms for implementing MARKVIEW application.
• Developed custom shell script program to import Cash Management Statement files from the Vendor’s FTP site and loaded into the interface tables CE STATEMENT HEADERS INT ALL and CE STATEMENT LINES INTERFACE. The loaded records were validated using SQL script.
• Developed data loading scripts using Oracle SQL*Loader for migration of legacy data into Oracle.
• Wrote SQL*Loader scripts and PL/SQL scripts for data conversion of legacy data into Oracle Financials, Oracle Purchasing and Oracle Assets modules and data validations before loading into the Applications tables.
• Created shell scripts to migrate forms, reports, workflow as part of the upgrade.
• Worked on vendor site conversion program for Vendor site conversion package.
• Developed various Packages and Triggers for Data Migration and Validation checks.
• Help business with the Month end closing and opening the next periods.
• Involved in SQL Tuning for efficient report execution as part of applications development.
• Troubleshooting Production issues, creating TAR’s in metalink, wrote MD60, MD50 specification documents.

Confidential, Indianapolis, IN

Oracle Applications Developer

Environment: Oracle Applications 11.5.10.2 (AOL, OM, PO, INV, WMS, ASCP, AP, AR, GL, FA, PL/SQL, SQL*Loader, Forms 6i, Reports 6i, SQL*Plus, JDeveloper, Discoverer, Designer 9i, Oracle 9i, TOAD.

• Design, Development & Support of (Oracle Manufacturing, WMS Shipping, Inventory, Order Management & Advanced Pricing for implementation in U.S., Mexico and Europe.
• Design and Migration of data and customization and Development of Forms and Reports.
• Designed and developed various Oracle reports and customized the existing .pll for enhancements to Oracle forms.
• Interacted with end users to gather requirements and draft specifications for the development phase.
• Involved in Requirement Analysis, Designing, Coding, System testing, creating technical and mapping documents like MD60, RD60 and MD70.
• Designed and developed major shipping reports like Pick Slip report and Machinery Ship log report for WMS Shipping.
• Worked with users and functional team members to draft the technical requirements and designed, developed, customized various major ASCP reports like Available Capacity report, Total Factory Capacity report, Capacity Load Planning report, Load detail report, Machinery Plan Priority report, MRP Shortage report, Report for Pull agreements matrix report, Injection forecast vs sales report and also worked on existing .pll for enhancements to ASCP forms.
• Involved in developing control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from legacy system.
• Involved validating and customizing new segments for existing applications, system administration, setting up users and configuring their roles to the desired applications.
• Designed and developed major form customizations according to the coding standards. Wrote SQL*Loader scripts and PL/SQL scripts for data conversion of legacy data into Oracle Inventory, Oracle Purchasing and Oracle Assets modules and data validations before loading into the Applications tables.
• Developed custom shell script program to import Periodic Average Costing data files from the Vendor’s FTP site and loaded into the interface tables CST PC ITEM COST INTERFACE and CST PC COST DET INTERFACE. The loaded records were validated using SQL script.
• Design, Developed & Customized Financial Reports such as 1099, FSG Reports.
• Designed and developed custom reports using Reports 6i in AR, AP as per business requirements:
• Invoice History Report and Checks History Report.
• Developed various Packages and Triggers for Data Migration and Validation checks.
• Upgraded Custom Reports from 11.5.8 to 11.5.10.2
• Customized the concurrent jobs, assigned the reports to respective groups & system administration.
• Worked on Mercury ITG for exporting and testing the data in QA and Production instances.
• Worked on creating TAR’s in metalink and troubleshooting production issues and resolve critical tickets.
• Supported and trained on-site and off-site end-users.

Confidential, Salt Lake City, UT

Oracle Applications Developer

Environment: Oracle Applications 11.5.10.2 (AOL, OM, PO, INV) PL/SQL, SQL*Loader, Forms 6i, Reports 6i, SQL*Plus, Windows NT, JDeveloper, Discoverer4i, Oracle 8i/ 9i, TOAD.

• Confidential develop a range of medical system equipment. The project involved automation of the entire order entry process. This eliminated the entire process of manual entry of orders into Oracle applications.
• Developed Custom reports and one web based application to keep track of orders in Oracle.
• Designed and developed a web based customer search tool that the salesperson could use to easily look for customer data before entering orders into Oracle.
• Installed and upgraded Oracle and Oracle products.
• Created databases, backup schedule, and table structures
• Designing & Development of Oracle Reports, Database Triggers, Stored Procedures & Packages.
• Migration of Legacy Data using SQL loader and upgrade of existing Forms and Reports
• Involved in SQL Tuning for efficient report execution as part of applications development

Confidential, Boston, MA

Oracle Applications Developer

Environment: Oracle Applications 11.5.8, PL/SQL, SQL*Loader, Reports 6i, Actuate Reports, SQL*Plus, 9ias, Oracle Portal (9.0.2.3.0.2 ), Oracle 8.1.7.3, Sun Solaris, JDK1.2, Microsoft Excel, Oracle JDeveloper, TOAD.

• Design and Develop database structure and entity Relationship.
• Design Excel templates for highly unstructured records and write SQL Loader scripts for those templates.
• Design and develop three access levels for the applications. Users would have restricted access to application and data as well according to the rights they have.
• Onsite assistance in Project implementation.
• Design and In corporate security management and user validations at component level as well as single database records levels in the applications
• Represented their financial and market summary data in Actuate Reports 6.

Confidential, VA

Oracle Applications Developer

Environment: Oracle Applications (10.7, 11.5.8, 11.5.9) (AOL, OM, PO, INV, AP, AR, GL) PL/SQL, SQL*Loader, Forms 6i, Reports4i/ 6i, SQL*Plus, Windows NT, Discoverer4i, Oracle 8i/ 9i, TOAD.

• Extensively worked on data migration from Oracle 10.7 to 11i.
• Involved in Requirement analysis, Designing, Coding and System testing.
• Creating Technical and mapping documents like MD60, MD70.
• Developed various Packages and Triggers for Data Migration and Validation checks.
• Customized the concurrent jobs, assigned the reports to respective groups & system administration.
• Designed and developed various reports and customized the existing .pll for enhancements to forms.
• Working on Data Conversion and upgrade of Oracle manufacturing 11i Applications. Created Packages and Procedures to extract 10.7 Manufacturing Applications, Data Mapping to 11i applications.
• Worked on Customizing and Developing Reports for Bill of Materials and Work in Process Modules.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from legacy system.
• Involved in the conversion of Financial Data Generator (FSG) data from 10.7 to 11i. PL/SQL package was developed to extract data from 10.7. This data is validated before inserting in to 11i base tables.