PROFESSIONAL SUMMARY:

• Around 10.5 years of total experience in Oracle Technologies as Oracle Consultant and Oracle Apps Techno/Functional C onsultant with expertise on RICEW (Reports, Interfaces, Conversions, Extensions, Workflows) Forms, API’s, Data Migration, Data Conversion, Concurrent Program API’s.
• Worked for Confidential (Product Development full time employee) from Dec 2010 until Apr 2015 (4.5 years). Sr Applications Systems Engineer for developing OAF pages and PLSQL package procedures in the Standard Sub Ledger Accounting (XLA), Accounting Engine(AX) and FAH ( Financial Accounting Hub ).
• Extensive Working Knowledge in EBS Oracle Application modules like AR, AP, GL, FA, AGIS, Cost Management, OM(Order management), Inventory, Purchasing and SLA modules.
• Hands on Development experience with FAH(Financial Accounting Hub) and SLA Modules .
• Worked with the customers, who have implemented Financial Accounting Hub (FAH) for their third party / customer owned sub ledgers.
• Experience in Working R12 E - Business Suite Financial Modules and EBS Architecture and Application Object Library (AOL) Concepts.
• Expertise in Conversions ( GL Trial Balance conversion , Vendor Conversion program and Item On-hand conversion ) and Interfaces ( Journal Import, Auto Invoice Program and Payables Open Interface)
• Hands on expertise on performance tuning of SQL queries, Dynamic SQL,Stored Procedures Packages, Collections, Explain Plans, Partitioning Tables and various PL/SQL intensive applications.
• Having exposure of new features available in 10g / 11g / 12c Database.
• Working Knowledge in Order to Cash(O2C) and Procure to Pay(P2P)
• Worked on 11i to R12.1.X and 11i to R12.2.X Upgrade Projects and 12.2.x Online Patching.
• Working experience in OAF (Oracle Application Framework) and Java Development using Oracle J Dev.
• Experience in Unix Shell Scripting
• Good Knowledge on OATS (Oracle Application Testing Suite)
• Hands on experience on Oracle 12c New Features.
• Worked on 2 R12 End to End Implementations Projects, 2 R12 / 11i Support Projects and 3 Upgrade Projects 11i toR12.

TECHNICAL SKILLS:

RDBMS: SQL Server, Oracle 12c,11g/10g/9i

GUI s: Forms 10g.

Reporting Tools: Oracle Reports 10g & XML/BI Publisher, FSG and Crystal Reports

Internet Tech: XML, HTML and Java Script.

OS: Windows NT/2000/XP, UNIX & Linux.

ERP: Oracle Applications 11i, R12(12.0.x, 12.1.x and 12.2.x) & Fusion.

ETL: SQL*Loader, FNDLOAD, Informatica

Oracle Tools: TOAD, Oracle SQL Developer & SQL Navigator.

Languages: C, Java, SQL, PL/SQL, Shell Scripting.

WORK EXPERIENCE:

Confidential, Iowa

Oracle BI Consultant

Responsibilities:

• Developed New Concurrent Programs as part of Customer Enhancements
• Designed custom workflow process for the entire business flow in the project and developed key PL/SQL procedures to handshake between OAF pages and the workflow function/notification activities.
• Worked on GL Balances conversion is to bring all GL Balances from QuickBooks to Oracle R12 from December 2013 through Feb 2015.
• Worked on Supplier On Hand Conversions, designing the mapping documents, implementing PL/SQL code for all transformations and loading into main tables.
• Worked on the migration of Journal Entries from Third Party Systems to Oracle EBS using Quick Book Data Migration.
• Accounts Receivables(AR) Customers setup which includes accounts, sites, bank accounts and contact information for the lessees to create and process rebill invoices.
• Worked on PTP technical issues (Purchasing, Payables) and working with Oracle Support to get the issues resolved.
• Process and functional expert in the Rail Car Arrival to Disposition process that utilizes EAM/BOM/WIP/Inventory/Order Management/Purchasing/Payables & SLA. Functional expertise involved performing the setups in the required applications like Inventory items using templates, Maintenance Bill for Scope of work, Asset Groups/Asset Activities for Railcar Repair shops (Oracle Suppliers), Outside Processing setups for purchased labor to onboard a rail car repair shop into the Oracle solution. n a legacy system by using the journal import interface provided by Oracle General Ledger.
• Worked on MD50 and MD70 Documents for the new enhancements in the Product
• Worked on Agile methodologies, attending daily Scrum meetings and weekly deadline tasks.
• Responsibilities involved converting acquired rail car assets into Oracle Installed Base, creating new Account Derivation Rule using custom source for inventory valuation in SLA, enhancing Oracle Workflow process to add process/function activities and notifications that generated dynamic HTML content with pdf/text attachments of rail road industry specific information and other rail road industry specific data conversions. Conversions are done by complex PLSQL anonymous blocks to write into Oracle standard interfaces/custom tables.
• Production support issues on WIP Receiving, Inventory and AP accounting having accounting issues during GL accounting period close as and when they are reported which includes drill down from GL to SLA and then to respective sub ledger which created those accounting entries.

Environment: Oracle Applications R12, EAM, Inventory, Purchasing/supplier, Cost Management, Accounts Payables, Oracle projects, Accounts Receivables, BOM, SLA, GL, OA Framework, Workflow

Confidential

Sr EBS Application Developer

Responsibilities:

• Working on SR’s, timely providing the resolutions in efficient manner.
• Maintained the internal forums for techno-functional questions.
• Handled many performance optimization bugs. Dealt with SQL Trace, Tkprof, Hints, Histograms and Statistics
• Monitoring the SR’s and keep tracking of the statuses.
• Mentoring Team Members in their assigned tasks and helping them for any issues.
• Prioritizing the SLA based on the severity and providing the resolution in less time.
• Development of Forms, Reports, Procedures, Functions, Indexes, Triggers and Packages.
• Implemented the Integration with Order Management module with Accounting and how it integrates with General Ledger.
• Working on RICE Components i.e. fixing the production support and customization issues.
• Worked on OAF Customizations and Workflow Customizations.
• Worked on Interfaces like Journal Import and Payables Open Interface (Account Payables (AP)).
• Strong Knowledge in Account Payables (AP) and General Ledger.
• Handled many performance bugs. Dealt with SQL Trace, Tkprof, Hints, Histograms and Statistics.
• Worked on the Customers who upgraded from 11.5.0 to R12.1.X and R12.1.X to R12.2.x
• Developed all the reports to use Data Templates (BI Publisher)
• Worked on Accounting Rules loading concept, AAD Loader.
• Developed QuicBooks GL Trial Balance Conversion from Quick Books Legacy Systems to Oracle EBS and Vice Versa.
• Developed New Concurrent Programs as part of Customer Enhancements.
• Worked on Fusion Migration from EBS to Fusion.
• Worked with different customers (Amazon, CISCO, Alcova) and resolved issues during Implementation phases.
• Worked on MD50 and MD70 Documents for the new enhancements in the Product.
• Worked on Designing various Customized Reports OBI, FSG based on the customer requirements.
• Worked and resolved Upgrade Issues for Customers who Upgraded from 11i to R12 (Alcoa, Cap Gemini, SGS, Info SPA etc)

Confidential

Oracle Developer

Responsibilities:

• Understanding the Customer Business System
• Using SQL Loader, loading the data from Old System to New System and performing Data validation on Staging tables then Loading into Main Tables.
• Involved in writing PL/SQL blocks which implement business logic.
• Involved in code reviews for the code written by other team members.
• Worked on ETL Migration development for new enhancements.
• Involved in Exporting and Importing tables.
• Worked on the Conversions / Interfaces programs from NON-EBS Oracle Systems to EBS Oracle System
• Involved in code reviews for the code written by other team members.
• Writing Procedures, Packages, Triggers for the Application.

Confidential

Oracle Developer

Responsibilities:

• Understanding the Customer Business System
• Using SQL Loader, loading the data from Old System to New System and performing Data validation on staging tables then Loading into Main Tables.
• Involved in writing PL/SQL blocks which implement business logic.
• Involved in code reviews for the code written by other team members.
• Involved in Exporting and Importing tables.
• Worked on the Conversions / Interface programs from NON-EBS Oracle Systems to EBS Oracle System
• Involved in code reviews for the code written by other team members.
• Writing Procedures, Packages, Triggers for the Application.
• Developed the Crystal Reports, to maintain the Billing Details and Policy Details for customers who took the Insurances.