Oracle Consultant / Developer
schlumberger (Contract by MPH/GNRS)
Total years of experience :18 years, 9 Months
Worked for Schlumberger, Responsible for migrating Finder database and application (oracle forms, Reports, database objects) to ProSource. Responsible to deliver a module named Back Allocation and integrate it with PS. ProSource is E&P custom application developed by Schlumberger for Oil & Gas industry.
• Preparing Technical Specification Document.
• Developed and tested the PLSQL migration scripts and mapping documents for data loading.
• Developed Oracle Forms & Reports and database objects like DOV, Triggers and procedures etc.
• Developed Loaders to load data into database in ProSource through different API.
• Responsible for quality check of deliverables and tuning queries.
• Providing status report to senior management & Responsible for preparing the implementations documents.
• Developed & maintained Autosys jobs to receive and send data files from upstream and downstream as per SLA document.
• Extensively worked in RICE components.
• Defined the security profiles and assign those profiles to different responsibilities.
• Involved in Registration of concurrent programs, executable(s), Creation of Responsibilities, parameters, request Groups, value sets, Flex Fields, Request Sets, Menus, Forms, Functions in System Administration & AOL.
• Developing new reports as per the client requirement using report builder and xml Publisher tools. Prepared SQL scripts to test the output.
• Develop the Interface Programs like Inbound Interface and Outbound Interface by using sql*loader program and utl file programs.
• Oracle Form Personalization and Page Personalization according to Client Requirement.
• Developing Interfaces and APIs using PLSQL objects (package, function and procedures) as per requirement
• Created tables & flex fields in required modules.
• Prepare Technical Design Documents like MD070 based on Functional Design Document Like MD050.
• Worked on Workflow and Oracle Alerts
• Involved in end to end testing of the entire oracle seeded functionalities as well as customizations.
• Extensively worked in RICE components.
• Developing new reports as per the client requirement using report builder and xml Publisher tools. Prepared SQL queries to test the output.
• Worked on Procure to Pay and Order to Cash Cycles.
• Develop the Interface Programs like Inbound Interface and Outbound Interface by using sql*loader program and utl file programs.
• Involved in end to end testing of the entire oracle seeded functionalities as well as customizations.
• Oracle Form Personalization and Page Personalization according to Client Requirement.
• Involved in Registration/Migration of concurrent programs, executable(s), Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Writing Procedures, Functions and Database Triggers following the Oracle standards.
• Active involvement in data gathering and identifying processes with functional team during onsite visits
• Developed and managed database instances for developers and testers. Created of CRUD & DB mapping.
• Worked on MVC architecture and JSP page design as per SOW.
• Provided complex SQL queries to developers and created PLSQL objects.
• B.E. (Computer Science and Engineering) Berhampur University, Berhampur, Orissa India, 2003 (71.7%). • Diploma in Computer Science & Engineering (72%). BOSE from SCTE&VT with Honors. • HSC (10th) 74%. Board of Secondary Education, Orissa