SUMMARY:

• Over 7+ years of extensive experience as Oracle Application Technical Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications. This includes system study, design, development, post implementation maintenance and support of Oracle EBS
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications
• Expert in developing Technical design documents, Technical Test documents, Conversion and Migration documents.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader
• Expertise on designing and implementing Oracle Alerts and Lookups
• Performed User and Administration responsibilities in Discoverer
• Dexterous in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher)
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specification
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc
• Strong in Performance Tuning, UNIX shell scripting
• Good team player and strong technical and program solving skills
• Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (Srs)
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL
• Interacted with users, fixed the bugs, developed test plans and provides daily production support

TECHNICAL SKILLS:

• Oracle Application Technical Support
• Oracle E Business Suite (EBS) / Applications: R12, 11i, R11, R10.7
• Oracle 10.7 PO, AP, OE, INV, AR, MRP,BOM,WIP
• Oracle 11i (11.5.7): CRM, ASCP, PO, INV, OM, AR, AP,BOM,WIP
• Oracle R11i (11.5.10): PO, INV, WMS, OMAdvance Pricing, FA, AP, AR, GL
• Oracle R12 (12.2.3): WMS, INV, PO, OMAdvance Pricing, FA, AP, AR, GL
• SQL*Developer, PL/SQL, BI Publisher, Oracle Forms & Reports, Workflow, Web-ADI etc.
• XML, Java, JDeveloper, ODI, ADF, SOA

PROFESSIONAL EXPERIENCE:

Confidential, Somersworth, NH

Production Support Analyst

Responsibilities:

• Use Oracle Application R12 (INV, AR, AP, PO, GL) system to generate report and monitor data to make sure no problem in any processes.
• Working experience with PL/SQL including Procedures, Functions, and Cursors & Triggers.
• Maintain data integrity in the ERP system using reports to find and correct errors
• Work with purchasing to expedite materials with long lead time.
• Analyze and report on work center load and capacity for constraint work centers.
• Monitor actual output versus the Production Plan; Identify gaps and drive solutions
• Review change orders and execute them appropriately.
• Analyze customer orders and establish production schedules for timely delivery.

Confidential, NH

Disposables Equipment Assembler

Responsibilities:

• Follow written and verbal instructions for the manufacture of equipment.
• Demonstrate excellent attention to detail in execution of work instructions, accurately repeating and documenting steps.
• Provide to others as necessary.
• Work in a team environment, with co-workers, engineers, etc. to meet company objectives.
• Provide technical support to R&D, CAPA, and Complaint system activities.
• Adapt to change in procedures, revisions, updates, and system improvements.

Confidential

Oracle Application Consultant

Responsibilities:

• A global provider of end-to-end IT services and solutions designed to help clients improve competitiveness and efficiency.
• Project: Essilor Worldwide (Europe and Asia-Pacific), the world leader in corrective lenses present in more than 100 countries.
• Oracle Application Technical Support
• Oracle E-Business Suite (EBS) / Applications: R12, 11i, R11, R10.7
• Oracle 10.7: PO, AP, OE, INV, AR, MRP
• Oracle 11i (11.5.7): CRM, ASCP, PO, INV, OM, AR, AP
• Oracle R11i (11.5.10): PO, INV, WMS, OM, Advance Pricing, FA, AP, AR, GL
• Oracle R12 (12.2.3): WMS, INV, PO, OM, Advance Pricing, FA, AP, AR, GL
• Other Components: Workflow/Workflow Builder, Alerts (ALR), Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields;
• Specific customized programs for Essilor group.
• Worked with functional team, MIS, DBA, HelpDesk to resolve / provide the solution to the user.
• Ensure production SLAs are met; provide performance tuning as necessary.
• Troubleshoot issue, including creation/follow-up of Oracle service requests (SRs).
• Identified and troubleshoot any potential problems and issues proactively.
• Fixed bugs in Forms and Reports previously designed.
• Reviewed, analyzed, and modified programming system including testing, performance tuning, debugging to support organization’s application system.
• Technical writing, developing and rolling out customer specific modifications.
• Worked on XML Publisher reports using RDF and Data Template.
• Experienced in working with Oracle Utilities like SQL*Loader, UTL FILE Package and Interfaces.
• Experienced in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL
• Created of various Oracle Alerts (ALR) to inform users of certain events.

Software/Programming: Microsoft office (Excel, word, Outlook, PowerPoint) Visio, Unix, Oracle Developer/2000, Oracle Workflow Builder, Oracle JDeveloper, Oracle iDeveloper (including Forms6i and Reports6i), XML Publisher, Oracle API’s, SQL*Plus, SQL*Loader, PL/SQL, SQL Navigator, Unix Shell Scripting, TOAD

Confidential

Programmer/Senior System Analyst

Responsibilities:

• Reviews, analyzes, and modifies programming system including testing, debugging to support organization’s application system.
• AS/400: Refund Control System, Fixed Asset System
• Oracle Application 11i: OM, MRP, INV, BOM, WIP, PO, FA,Financial
• Customized Modules in Oracle: SO EDI, PO EDI, Local Sales System, Costing System
• Coordinate with other IS staffs in Confidential Matsushita Group such as Singapore, Germany, Japan, Canada, America for Purchase Orders and Sales Order data exchanged system.
• Developed and maintained plan outlining steps and time tables for developing programs.
• Experienced in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Performed User and Administration responsibilities in Discoverer.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Expertise on designing and implementing Oracle Alerts and Lookups
• Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
• Write manuals for users to describe installation and operating procedure.
• Write documentation to describe program’s objectives, program development, logic coding, and correction.

Software/Programming: RPG/400, CL, Window NT, Unix Shell Scripting, Developer 2000 Form & Report 6i, Oracle Discoverer 4.0 Administration Edition & User Edition, Discoverer 2000 Browser 2.0, Oracle Application Desktop Integrator, SQL Navigator 4, SQL *Plus, SQL*Loader, PL/SQL, Oracle API’s, Oracle Application 11i, Oracle Application 10.7

Confidential

Responsibilities:

• Reviewed, analyzed, and modified programming system including encoding, testing, debugging and installing to support an organization’s system.
• Consulted with users to identify operation procedure for Billing, AR, Wage & Salary, to clearify program objectives and provided appropriate solution.

Software/Programming: Novell Netware, Foxpro Lan