SUMMARY

• Oracle Specialist with more than 15 years of experience with various oracle products. Worked with Oracle from version 6i through 12.
• Have more than 10 years of experience working in jdeveloper 10,11(11.1.4),12(12.2.1.3).
• Have more than 10 years of experience in Java 6/7/8
• Have more than 10 years working in Oracle Web Center Portal (11 and 12)
• Have more than 5 years of experience in Oracle WebLogic server (10,11,12)
• Have more than 15 years of experience working in Oracle forms(9,10,11,12c), PLSQL, SQL
• Have more than 15 years of experience in pro*c
• Have more than 6 years of experience in Oracle SOA (11,12)

TECHNICAL SKILLS

• Oracle SOA 11g/12c
• OSB (Oracle Service Bus)
• SOAP/REST
• BPEL, File and Database Adapter FTP adapter, Mediators and composites
• Web Center Portal
• Oracle, 11g,12, 10g,9i and 8i
• Clustering
• High Availability
• Performance Tuning
• RMS foundation
• Supplier
• PO
• Transfers
• Stock Ledger
• Receipts\
• Benefits Administration
• Allocation
• RPM
• Resa (Sales Audit)
• SIM
• General Ledger
• Cash Entry
• Windows NT
• Windows 2000
• HP - UX 11.11
• Red Hat Linux
• Java
• Pro*c
• Oracle SOA(12)
• C++
• HTML jdeveloper and ADF 11g/12
• Java
• PLSQL/SQL
• Shell Scripting

PROFESSIONAL EXPERIENCE

Oracle Developer

Confidential

Responsibilities:

• Worked on developing custom allocation in ADF, Custom extensions to Oracle RMS in jdeveloper 11g in ADF with WebLogic server 11. These applications are in production and I currently support them for any issues in production.
• Created test cases and deployed applications in QA WebLogic server
• Created spreadsheet upload functionality using ADF desktop integration tool to help in upload of various excel spreadsheets for creating PO, Allocation, Pricing information, Ecommerce item information.
• Developed UI for various SOA error messages to help users view the error and update the error information.
• Exchange smart app functionality developed in ADF 12.2.1.3 to integrate with SOA to trigger PO, item, pricing information. This application uses web services like SOAPUI, REST to get information from SOA in XML, JSON format. These were parsed in ADF to display information to the users.
• Developed custom Web Center portal application for buisness users for dashboard and other management information.
• Used Oracle APEX to create various reports for the end user and these reports were integrated into Web Center Portal for easy access for users.
• Integrated Apache POI with ADF to help upload of excel spreadsheet into Oracle database to help users directly upload the information instead of entering it manually.
• PLSQL procedures, packages, functions created for various functionality using advanced features like Bulk binding, array inserts.
• Maintain and performance tuned various SQL and pro*c programs for best performance.
• Maintain and created multiple functionality in Oracle forms (11/12) for the client.
• Converted various Oracle forms application to Oracle ADF.
• Worked on ASAP project to convert Oracle forms to Oracle APEX 5.
• Converting APEX 5 to Apex 18.
• Developed a Supplier induction/Item induction process for vendors to enable them to upload their products directly into the database. The process was developed in Oracle ADF/Java with security built in using Oracle Web Center portal.
• Created timesheet application for all employees of the company using Oracle Web Center.
• Project based application to show different people on the team to show their vacation, work from home hours, availability for the project
• Developed an application for production support using web portal. This will show when a employee is on call, different jobs in production, history of the jobs, failure history and also the resolution for failure. On-call person use this information to fix the failed job and will also add new resolution if the failure resolution is not in the system.
• Developed a Dashboard application for management in Web Portal to show the Oracle SOA failures, messages, flow information.
• Converted pricing tool from Oracle ADF 11 to Oracle ADF 12.2.1.3.
• Production Support on Oracle Applications. Worked with production control to work on production failures and analyze why the job failed and understand the data and job causing the failure.

Senior System Analyst

Confidential

Responsibilities:

• Worked as part of the development team to develop applications in Oracle ADF for Oracle Merchandising System (Oracle Retail)
• Was part of development of Oracle Pricing and Oracle Allocation in Oracle ADF/jDeveloper.
• Was also involved in supporting issues reported by customer and fixing any bug fixes in Oracle Merchandising product.
• Travelled to customer sites for any priority bug fixes.
• Worked late hours to handle any P1 issues reported on Oracle Merchandising System (Oracle Retail)
• Deployed completed to web logic server for testing product.

Senior System Analyst

Confidential

Responsibilities:

• Worked with users to implement Oracle Merchandising solution, which was built in Oracle forms, Pro*C, Java, PLSQL.
• Customized Oracle Merchandising based on user requirements.
• On-call production support
• Worked with Vendors to enable them to upload an EDI flat file for vendor information.
• Developed an ASN process for vendor ASN.
• Sales file upload for real time sales information for management.
• Inventory information reports.
• Part of the implementation team for Oracle Retail.

Senior System Analyst

Confidential

Responsibilities:

• Part of the implementation team for Inventory system for Sainsbury, London.
• Part of the development / implementation for Simpsons, Chennai. We developed an in-house system for their Engine manufacturing facility. This was done in Oracle Forms/Pro*C/PLSQL.
• Also, part of the team to develop an in-house financial system and payroll system for TI Cycles in Chennai using Oracle Forms/Pro*C/PLSQL.