SUMMARY:

• 12 years of experience as a Techno - Functional solution designer & developer for Oracle E-Business Suite (EBS) releases 11i & R-12.
• Hands-on experience in managing the implementation, maintenance & production support of Oracle Financials and SCM Suites through onsite-offshore model.
• Possess ample business knowledge in domains like Oil & Energy, Utilities, Retail and Financials.
• Expert in understanding the business requirement by communicating with the users and/or business analysts and involve in design, develop, test and deploy various Oracle technical solutions like RICE components (Reports, Interfaces, Conversions and Enhancements) development, Form Customizations & Personalization, Oracle Workflows, BI Publisher, OAF Form Personalization, Custom Web ADI integrator creation, Designing multi layered PL/SQL packages, Performance tuning, etc.
• Involved in Oracle global rollouts for various clients with MRC for countries with like Canada, Brazil, Mexico, Italy, Russia, Australia etc. This involved in various challenges pertaining country specific localizations and customizations.
• Revolutionized the Legacy2Oracle conversion process using Web ADI, by enabling the business analysts to simply upload the data into Excel documents.
• Complete understanding of the critical business cycles in Oracle- Procure to Pay cycle and Order to Cash cycle.
• Expert in multi system integration like Oracle-Siebel, Oracle-OTM etc.
• Strong in communication skills, self-motivated and great analytical skills.

TECHNICAL SKILLS:

Oracle Technical Products: FRICEW\CEMLI Components Development, XML\BI Publisher, Oracle Application Framework (OAF), Oracle 10g Forms and Reports, Oracle Workflows, Oracle Web ADI, Oracle PL\SQL, Oracle SQL Performance Tuning, Oracle SOA 11g and ADF.

Oracle Modules (For R12 & 11i): O2C Modules Inventory (INV), Order Management (OE), Projects (PA), Accounts Receivables (AR) & General Ledger (GL) and P2P Modules Purchasing (PO), iProcurement (ICX), iSupplier (POS), Accounts Payables (AP).

Other Products: Noetix Views, Concepts of Data Warehousing, Informatica 9, OBIEE.

Tools: JDeveloper, Dell STAT, Kintana, PVCS, Microsoft Team Foundational Server (TFS), and TOAD for SQL, PL\SQL development.

Other Languages: C, C++, Java, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr Oracle EBS Technical Consultant

Responsibilities:

• At Nabors my duties mostly involve providing the technical expertise and building a robust solution to implement Oracle iSupplier & Oracle iProcurement modules and integrate them with the existing Oracle EBS 12.1.3 implementation.
• I was mostly handling the development of business defined customizations to the iSupplier & iProcurement modules through OAF Extensions, personalizations, Oracle Workflow changes pertaining to these modules and RICE component development.
• Oracle EBS Release 12.1.3 iSupplier & iProcurement implementation and customization
• Enabled 2-Step receiving (Standard receipt routing) of POs through iProcurement OAF screens by extending the Controller (CO) and View Objects (VO) as per the business requirement. The design involved in customization of a 3 step train page with tons of validations and data verification.
• Customized the AP Invoice Approval workflow for Non-PO invoices by adding a rejection notification step. Once the invoice is rejected, the workflow sends out a notification to the creater/requestor with the reject reason.
• Customized the iSupplier invoice request creation page (both PO & Non-PO) by extending the controller (CO) and the view objects (VO) components. This also involved addition of MessageChoice and external LOVs.

  Confidential,Houston,TX

Senior Oracle Developer

• At Newpark my role is to provide comprehensive Oracle techno-functional solutions according to project requirements and also coordinating with the functional consultants and the users on business critical issues.
• My main focus was understanding the business requirement by communicating with the users and/or business analysts and involve in design, develop, test and deploy various Oracle technical solutions like RICE components (Reports, Interfaces, Conversions and Enhancements), Form Customizations & Personalization, Oracle Workflows, BI Publisher, OAF Form Personalization, designing multi layered PL/SQL packages, Performance tuning, etc.,
• Oracle EBS Release 12.1.3 rollouts for NDF EMEA (Italy, Algeria, Tunisia), NDF APAC (New Zealand-Australia), NDF Canada and NMIS (Newpark Mats and Integrated Services) operating units.
• Played a technical architect role during Oracle EBS R12.1.3 rollouts for Canada, APAC, EMEA and NMIS.
• Revolutionized the conversion process, now the business analysts can simply upload the data from legacy system to Oracle using MS Excel.
• These conversions include Open AR, Open AP invoices, Open POs, Inventory items, Customers, Vendors and Projects creation.
• Created multiple invoice report templates like Draft Invoice report, AR Invoice detailed report, AR Invoice summary report, Direct Sale Invoice report etc.
• Created country specific AP checks templates using BI publisher reports.
• Created interfaces for data flow between Oracle and GETPAID system, which also process the data and does currency conversions.
• Performed form personalization for the country specific localization to Oracle Purchase Order and Purchase requisition forms.
• Oracle iProcurement punch out store implementation for vendors Office Depot & CDW.
• Implemented Oracle iProcurement module in Newpark and its subsidiaries by identifying the required setup changes and workflow changes in PO requisition process, to accommodate the business model of Newpark.
• Defining the Code conversion values of external UNSPSC codes into e-Commerce gateway and their equivalent mapping to the internal purchasing categories and also defining the UOM mappings.
• Creating Punchout content zones and Punchout stores for Office Depot and CDW.
• Performed form personalization to align the workflow changes with iProcurement screens and auto populating the vendor email addresses while PO approval.
• Oracle Chart of Accounts (COA) consolidation mapping to support hybrid model of account & segment rules
• Oracle provides 2 standard methods of the COA mapping for GL Consolidation, Segment Rules & Account Rules
• The “Newpark Custom COA Mapping” form is a custom component (extension) to add another mapping method 'Newpark Custom Rules' that allow users to map by source segment combination and default the target value of the other segments based on the segment rules. It is a hybrid of the 2 standard methods.
• The code comprises of extensive form customization to accommodate the need, complex multi layered PL/SQL packages are integrated with form, form personalization, custom tables, triggers and sequences.
• Standardizing Newpark Payments process to ISO XML 20022 and migration from JP Morgan Chase to Bank of America.
• Customized the standard Oracle XSL template that integrates with the payment profile used for making the payments.
• An XML ISO 20022 standard has been achieved using the custom XSL template that gives the output which is later fed into Bank of America servers through Secure FTP protocols.
• Oracle Inventory KANBAN Planning System implementation (Achieved 6σ Standards)
• Instrumental in design, development and implementation of Custom Inventory KANBAN Planning system for Newpark. Achieved a Six Sigma (6σ) certification.
• Created multi layered and complex PL/SQL packages that would measure, estimate and suggest optimum KANBAN bin/inventory levels to be replenished.
• These PL/SQL packages are integrated with Web ADI templates that provide both upload and download (content) features to get the analyzed information into excel sheets. Also a color coded report has been designed that shows colors of different KANBAN Cards based on current inventory quantities.
• Created a simple OAF page that contain EO, VO, AM and Controller components. This OAF page supports the KANBAN Planning system by suggesting optimum inventory Min Max levels based on 12 month average and overriding the suggested levels as per the user input.
• The KANBAN Planning System was a six sigma level project that saved almost US$ 488,000 to the organization spanning across 25 warehouses.
• Newpark Oracle EBS Release 12.1.3 Implementation and production support
• Involved in development various RICE components like Unbilled Receivables Aging Report, All Inventories Value Report, Price List auto upload program etc.
• Developed the B2B solution that sends out secure data of AR invoices to the local server from which the third party B2B data exchanger does the rest.
• Performed tons of OAF form personalization, created and customized workflows.

Confidential

 Schlumberger, Houston, TX.

 Systems Analyst

• In Confidential I lead a small team of around 6 people by providing them the technical assistance according to project requirements and also coordinating with the functional consultants both onsite and offshore on business critical issues.
• Technically involved in developing the RICE components (Reports, Interfaces, Conversions and Enhancements), Form Personalization, developing SQL scripts and designing multi layered PL/SQL packages, Performance tuning, etc.,
• Implemented Release 12.1.1of Oracle EBS and 11.5.10.2 roll outs for Schlumberger whose users majorly use Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Purchasing (PO), Order Management (ONT), Inventory (INV), modules.
• Oracle EBS to Siebel Customer Integration :
• Schlumberger has implementations of multiple ERP systems like SAP, Siebel and multiple instances Oracle EBS etc. Challenge lies in integrating them closely to function like an Enterprise Mega system.
• I was involved in integrating the Customers information from Siebel v9 to Oracle EBS 11.5.10 system. With Siebel playing as a Master Customer Data manager for the whole enterprise.
• Developed multi hierarchical Pl\SQL packages that pick the Siebel customer information and pump the customer data into Oracle AR system through synchronous set of operations creating customer, location, party, party site and party site use using Oracle FND APIs.
• From the top level of the hierarchy, the PL\SQL packages perform a set of validations, translations and transformation of data that comes from the Siebel to map with Oracle data format.
• At the middle level of the hierarchy, the PL\SQL packages make use of the HZ%V2PUB APIs which are Oracle native APIs that are provided to create the customers related information from backend.
• In the lower level of the hierarchy the data changes that happen at Oracle Apps base tables are triggered out as set transactional events to the top layer where in turn the data translation as per Siebel standards are made and fed into Siebel system.
• Oracle EBS Financials Modules Implementation for Latin America (LAM)
• Played a technical lead role in rollouts of Oracle EBS R12 for 5 Latin American countries (Mexico, Peru, Columbia, Ecuador & Venezuela), with MRC setups and LAM localizations applicable.
• Involved in various conversions of data like for Customers, Vendors, Open AP/Open AR invoices, Bank Accounts etc. from legacy systems to Oracle EBS system applying the LAM country specific localizations.
• Created language specific multiple AR invoice templates for LAM countries using XML publisher reports, these templates are chosen dynamically based on the language.
• Performed form personalization for the country specific localization to Oracle Customers and Order Entry forms.
• Implemented automation of period closure procedure through a set of requests that are triggered at the end of monthly financial life cycle.
• Schlumberger., Oracle Apps Implementation and Support Project :
• Involved in various conversions of data like Open AP/Open AR invoices, Customers and Vendors conversions, Bank Accounts conversions etc from legacy systems to Oracle EBS system
• Developed hundreds of complex .RDF/XML reports and also converted the Oracle Standard .RDF reports to XML/BI Publisher reports.
• Personalized various Customers, Order Management and Payables forms to achieve custom functionality.
• Developed several interfaces in Inventory and Purchasing modules like miscellaneous inventory issue, creation of custom requisition import program etc.
• Worked on Performance issues and also designed complex PL/SQL packages and SQL queries for extended functionality.

 Confidential

CISCO, San Jose, CA.

• Cisco Service Contract Center (CSCC):
• The technical part of CSCC is to develop the backend code through advanced PL/SQL from which the whole functionality is derived.
• The front end application of CSCC uses its own framework is based on OAF which dynamically fetches the data with less response time.
• The job involves in designing the database on how the data is to be organized within the tables and how the packages are designed for optimum performance.
• Developed a few OAF pages with embedded business logics.

Confidential 

JApplications Engineer

• My role in Noetix as a developer is to create comprehensive reports upon the module specific business areas. To create these reports exhaustive functional knowledge is required for configuring the application, doing all the basic setups and then performs transactions.
• The technical aspect of report creation is accomplished through designing the business metadata by writing SQL queries.
• These virtual reports are converted in .RDFs, also conversion of these .RDFs into XML Publisher reports upon customer requirements. Job also involved in customization of forms with specific customer requirements.
• Creating PL/SQL packages that integrate with the product installer to provide extended functionality to the virtual reports.
• Accounts Receivables (AR)(Versions 11.5.10):
• Setting up and maintaining party and customer account information, processing the invoices, implementing auto invoices, correcting existing invoices like debit memo, credit memo, make adjustments and on-account credits, create refunds, void transactions. Creating receipts and receipt batches etc.
• Developing the reports on all these setups and transaction through SQL queries with support of PL/SQL packages and other database objects.
• These SQL Queries are created by identifying the core database tables for each business area and subsequently creating .RDF and XML publisher reports.
• Accounts Payables (AP)(Versions 11.5.10):
• Setting up the payables options, defining suppliers, sites their bank accounts. Working on the transactions like invoice creation matching to the POs, issuing of payments, closing of periods etc.
• After doing all these setups and transactions, the SQL Queries which hit the Apps DB are created by identifying the core database tables for each business area and thus creating the RDFs, also conversion of these .RDFs into XML Publisher reports for the customer, if required by the customer even forms will be enhanced.
• Purchasing (PO) (Versions 11.5.10 & R-12):
• Defining all the Purchasing Options, creating requisitions, creating standard/Blanket/Contract POs, automating document creation, receipt processing of goods etc.
• Implementing the “Procure to Pay cycle”.
• After doing all these setups and transactions, the SQL Queries which hit the Apps DB are created by identifying the core database tables for each business area and thus creating the RDFs, also conversion of these .RDFs into XML Publisher reports for the customer, if required by the customer even forms will be enhanced.
• Order Management (OM)(Versions 11.5.10,R12):
• Setting up and main order entry setups and their integration with other supply chain modules like ASCP and PO. Creation of sales orders and order lines. Releasing the sales orders accordingly, providing the shipping details and shipping transactions.
• Implementing the “Order to Cash cycle”.
• Developing the reports on all these setups and transaction through SQL queries with support of PL/SQL packages and other database objects.
• These SQL Queries are created by identifying the core database tables for each business area and thus creating the RDFs, also conversion of these .RDFs into XML Publisher reports for the customer, if required by the customer even forms will be enhanced.
• Inventory (INV)(Versions 11.5.10 & R-12):
• Running all the basic setups like creating the Items through master items form and defining various options for the created inventory item, also creating the Item categories.
• Worked on the integration of these INV items with other EBS module like PO, WIP and their usage in Projects. Also the INV related set ups with Financial modules
• After doing all these setups and transactions, the SQL Queries which hit the Apps DB are created by identifying the core database tables for each business area and thus creating the RDFs, also conversion of these .RDFs into XML Publisher reports for the customer, if required by the customer even forms will be enhanced.

Confidential 

Executive Technical Support 

• My major role was to provide technical support to the customers who wish to fetch different sets of data through Oracle SQL. These SQL queries run against Oracle Apps database to fetch the desired information.
• Provided support to the customer on database querying by normalizing the database tables, indexing the tables, etc...
• Also worked on Quality assurance factors such as identifying bugs in the existing code, and tracking the bug.