SUMMARY:

• IT professional with 18+ years of extensive experience in application design, development, and implementation of Oracle EBS (11i/R12) projects for Oil and Gas, IT Services, manufacturing and engineering industries with OMCS (Oracle Managed Cloud Services) platform.
• Oracle Certified Professional Application Developer (SQL, PL/SQL, Oracle Forms, Oracle Reports), certification for ITIL foundation.
• Extensive experience with providing end - to-end solutions for RICEWF components for EBS R12.1.3 modules related to P2P, OTC, and MFG - INV, BOM, ENG, WIP, PO, AR, AP, CM, FA, GL, OM, WSH (Warehouse Shipping Handling), and Advanced Pricing.
• Experience of being on implementation team for oracle EBS R12 rollouts at different NOV plants and involved in design/development/testing/implementation/war-room support as well as post-production support tasks.
• Ability to understand functional design document and underlined business requirements for RICEWF+OAF components and converting into Technical design, writing technical specs, code development, writing test scripts for unit testing, writing UNIX shell script for deployment FUT coordination with BAs and end-users.
• Work experience as a developer/technical lead with PL/SQL, Oracle Developer Suite (Forms/Reports), XML/BI Publisher, OAF, SOA, BPEL, ADF, Workflow, Web ADI, Unix Shell scripting, Personalization, Application Developer and System Administrator responsibility tasks including AOL, DFF, KFF, Value Sets, Business Events, Alerts, Concurrent Programs setup and scheduling etc.
• Good knowledge of Oracle EBS customization/extension methodologies, developed many complex interfaces for Bank, Engineering, Manufacturing, OM, and PO using BPEL component of Oracle SOA as middleware, analyzing, debugging, and resolving issues, working on production support tickets, creating SRs and working with oracle support, writing data fix scripts.
• Expertise in data conversion/migration, open interfaces using APIs, customization of RICEWF components, ETL architecture - data extractions, cleansing, transformations, and loading to build enterprise Data Warehouse / Data Marts using Informatica PowerCenter. Designed and developed materialized views and packages for outbound interfaces to cater custom data warehouse.
• Adept at understanding business processes/requirements, database design, entity relationship (ER) modeling and dimensional modeling using Star and Snowflake schemas, creating mappings and transformations, tuning mappings and sessions for better performance.
• Extensive experience in oracle database programming in PL/SQL for creating Packages, Database Triggers, Functions, exception handling, debugging and tuning PL/SQL code, tuning complex queries utilizing Indexes, Hints, and Explain Plan, TKPROF for performance and optimization.
• Proficient working with Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Materialized Views, Bulk Collect, FORALL, Instead Of Triggers, Autonomous Transactions, Dynamic SQL etc.
• Experience with working in different capacities as developer, lead developer, team-lead, HP-QC admin, business analyst, and release manager, working with local team as well as offshore development team in India and delivering the projects on schedule within budget.
• Also have worked as release manager - coordinating with global development team for source control procedures, check-in and promoting the code, preparing implementation plan, coordinating deployment with SysAdmin/DBA team, monitoring deployment, and post deployment testing.
• Good understanding of AIM documentations, project life cycle, SDLC aligned to waterfall as well as Agile/ scrum methodology, requirement gathering, functional analysis, and effort estimation for customization.

TECHNICAL SKILLS:

• Oracle EBS 11i/R12 RICEWF+OAF Components
• Oracle 10g/11g/12c
• SQL
• PL/SQL
• Oracle Forms
• Oracle Reports
• BI/XML Publisher Reports
• Oracle Workflow
• OAF
• ADF
• JAVA
• UNIX Shell Script
• Informatica Power Center 9x
• Oracle SOA (BPEL)
• SQL*Loader
• Data Loader
• WINSCP
• Putty
• AOL (Application Object Library) Architecture
• Business flow and data flow knowledge for SCM
• FIN and MFG Modules
• Data Conversions/Migrations
• Open Interfaces/APIs
• EAI (Enterprise Application Integration)
• ETL Processing for Data Warehouse/Data Marts
• Oracle J-Developer
• Oracle seeded forms customization using CUSTOM.pll
• Performance Tuning.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Application Developer

Responsibilities:

• Worked on RICEW components for oracle EBS R12 financials, manufacturing, and oracle projects modules.
• Being part of implementation team for oracle EBS R12 rollouts at different plants of NOV. Involved in design/development/testing/implementation/and post implementation support.
• Worked on data migration while cut-over activity and going live with EBS rollouts for different plants as well as war-room support after go-live and then day-to-day production support.
• Wrote test plans and executed different types of testing - CRP/FUT/UAT/SIT. Worked with QTP developer for developing automated test scripts for unit testing different functional scenarios and load testing using QTP.
• Worked on conversions and interfaces related to Bank, SO, PO, Journals, Items, BOMs, Routings, and ECNs using PL/SQL and BPEL process as middleware.
• Developed SO interface between Glovia ERP and Oracle RBS R12, Bank Statement interface between global banks and EBS for bank statement reconciliation, Auto Lockbox interface between WF bank and EBS to collect and process all the receipt instruments, Two way Shipping interface between FedEx and EBS sending shipping details and collecting shipping labels from them, Cronos interface to send manufacturing data to Cronos system. BPEL Components are used in all these integrations/interfaces.
• Developed Item interface and dynamic ECO interface between Team Center engineering application and EBS. This engineering interface will sync the master BOMs with Team center engineering application, but also take care of differences maintained at different plants and their multiple operation sequence requirements. So creating ECO for the delta by comparing the two BOMs and will implement the ECO as per org preference.
• Upgraded Vertex-Q series to Vertex O-series and modified the hook to customize for NOV requirements for ultimate destinations, invoice exemption rule, modifying post-calc message for credit memo against Q-series invoice etc.
• Modified the invoice report to print short attachment notes from OM/Project/Manual invoices and credit memos as well as ultimate destination and deliver to instead of ship-to, showing dynamic log etc.
• Worked on many financial and manufacturing reports for creating hooks in PL/SQL for BI cognos reporting, developed new reports and modified existing reports for enhancement requirements using XML Publisher and oracle report. Translated financial and manufacturing reports into Russian language for Russia implementation.
• Worked on numerous form and report modules, developed custom oracle forms and personalized the seeded forms for extended functionality. Incorporated complex personalizations thru PCG and CUSTOM.pll for seeded oracle forms.
• Also worked on OAF personalizations as well as OAF components to customize/add search page, LOVs, adding regions to show additional info, uploading files through OAF page etc.
• Providing daily production support for the modules related to P2P (purchasing, iSupplier, iProcurement, payables), O2C (order management, receivables, cash management), and manufacturing (inventory, Bills of material, routing, work-in-process) modules involving analyzing the issue, providing work-around or fixing the root cause, writing data fix scripts in PL/SQL, if required then logging SR and working with oracle support.
• Worked on data extractions (ETL) projects for data warehouse and BI reporting. Good knowledge of Informatica and moderate knowledge of cognos reporting tool. Created few hooks in PL/SQL for cognos.
• Worked as QC Admin. Quality Center is used for help desk system at NOV to log day to day issues and RICEWF tickets. Also worked on AOL objects like values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, application user setup, defining responsibilities as well as providing support to apps users for any technical and functional issues.

Confidential, Houston

Application Developer/ Sr. Programmer/Analyst

• Worked on critical enhancements and SOX compliance projects. Modified forms and reports to implement SOX controls like Discount of Records, tracking of Price variance activities, tracking of all types of issues, holds and approvals during the order life cycle etc., writing downloads in PL/SQL and developing highly complex reports required by government auditors, SOX auditors, and business executives.
• Worked on complex differed revenue project.
• Worked on data extractions for data warehousing and dash boards to be used in BI for executive reporting. Developed back-end packages in PL/SQL for EAI (Enterprise wide Application Integration) functionality to update information in real time across the applications.
• Developed packages to generate email notifications (like order detail info to customer and sales rep, invoice notification, expiring service contract notification etc. from oracle during different processes.
• Troubleshooting tickets relating to AP, PO, iProcurement, iSupplier (P2P) issues. Providing production support for these modules to users, internal and SOX Auditors as well as for period-end closing process.
• Worked as a Lead Developer/Analyst with offshore development team and delivered the projects on schedule. It also includes preparing test plans and coordinating IST (Integrated System Testing), UAT (User Acceptance Testing) and getting signoff for the deployment.
• Also worked as a release manager for deployment of the projects, which includes - preparing SOX Compliance CR (Change Request) and its relevant documentation, coordination with global development team for version source control procedures, check-in the objects, preparing implementation plan, coordinating the deployment with Sys Admin/DBA team, and post deployment testing.
• Acquired Company Data Conversion as well as extraction for Data warehouse: Worked on acquired company data conversion for customer, product, Account Base, Agreements, License Products, support entitlements (service contracts), invoices etc. as well as extraction projects for data warehouse.
• Data mapping, data conversion (uploading ASCII data files to oracle staging tables) using SQL Loader, development and testing of conversion scripts, reports and queries to view conversion statistics, exceptions and warnings and proof reports. Developed a generalized import utility in PL/SQL to load data into oracle custom tables from ASCII files using UTL FILE package.
• Worked with ETL processes utilizing Informatica Power center tools to design data conversions from variety of data sources like relational, XML and flat file source systems to data warehouse/data marts, implementing business rules by creating transformations (Expression, Aggregate, Source qualifier, connected and Unconnected Lookup, Router, Rank) and developing Maplet, and Mappings.
• Merge/Sweep Utility for Customer Management: Developed tools to handle merge and cleansing of duplicate records for customers, sites and contacts. Any update on customer master (accounts, business address, contacts) will propagate to oracle through customer interface events.
• Developed stored procedures for Merge/Sweep functions. Developed RDP (Remote Data Processing), which updates the transactions in oracle custom applications for company/site/contact info in the tables listed in control table using Dynamic SQL.
• Upgrade of EBS 11i: Updated the custom objects (forms and reports) to 11i standard (i.e. from developer 2000 to Developer 6i), Updated the Database objects 11i standard and testing of all these objects.
• Enterprise wide Application Integration (EAI) project: Developed integration between different applications like Siebel, Oracle, and Customer First etc. to update information in real time through canonical design of publishers and subscribers. Changes made by application owner will be published and subscribers will get the events for change in real time.
• Written complex PL/SQL packages for handling these events, consuming the subscription as well as well as publishing the changes for its subscribers. Developed integrations for Customer, Product, Sales Order, and Agreement entities.
• Production Support and Enhancement of custom OM, license product, and PIM and interfaces with Siebel - handling helpdesk tickets, writing data-fix scripts, enhancement and development of forms, reports, packages, workflows, stored procedures, data base triggers, and AOL objects.

Confidential

Asst. Manager

• Consolidated different applications for finance and MRP being used at different manufacturing plants to bring them on platform and created a foundation for future ERP solution.
• Worked on requirement analysis for BOM, ENG, INV, MRP, Procurement, Production Floor Management and Maintenance (maintaining process sheets, machine utilization, operation center processing, operator efficiency, machine downtime, operation center overhead, wear-parts etc.).
• Prepared Requirement Specifications for the proposed system.

Confidential

Sr. Executive

• Developed finance and distribution applications using early version of oracle and PL/SQL. Transformed the payroll application from COBOL to oracle. Developed branch application for OM, invoice, inventory using PL/SQL, Forms/Reports. Also developed interfaces between HO and branch application.
• Wrote application for WD functions like processing retailor requests, retailor allocation, managing inventory, processing orders, monitoring stock flow etc. Also worked on EAI project between all three tiers (HO, branch office, and manufacturing plants) using Oracle and Web technologies.
• Worked in different capacities from programmer to BA. Also managed Systems department for its Ahmedabad regional office being a Senior Executive (Systems) for few years.
• Designed FS and ER diagrams for custom applications of handling assets, product complains, insurance claims, Business Intelligence reporting.