SUMMARY

• Experienced Oracle Applications Techno Functional consultant, working in ERP for 11 Years around Financials, Manufacturing, Supply Chain and Property Management modules.
• Proficient in Procure to Pay and Order to Cash business flows, mainly working in Payables, Purchasing, Inventory, Order Management, and General Ledger modules.
• Good Experience in Property Manager Module specifically on Expense Leases and on FASB and IFRS reporting standards.
• Extensively worked on various RICE objects design and development in both Oracle Applications R12 and 11i.
• Proficient wif various Reporting techniques and tools including Reports Builder 6i/9i/10g, XML Publisher, EIS Reporting, Discoverer, and others.
• Experienced in developing Forms from Scratch for Oracle applications. Extensively customized forms and used forms Personalization, for extending application functionality in Payables, Receivables and Order Management.
• Good Working knowledge on building various objects like business areas, folders, etc., using Discoverer Administrator component. Created various workbooks using Discoverer Desktop and Plus components.
• Well versed in authoring AIM documentation during all stages of teh SDLC including BR100s, MD50, MD70 and CV40, promotion, integration, and configuration documents.
• Hands on Experience in developing Workflows using workflow builder and customized various standard Oracle Workflows. Few of them are PO Approval, INV Approval, OE Headers, OE Lines, and others.
• Proficient in System Administration activities, managing concurrent managers, Developing custom applications, responsibilities, menus, and request groups. Registering Concurrent programs and Request Sets. Defining value sets, flex - fields, lookup values, profile options and printers.
• Proficient in SQL and PLSQL Scripting, developing various database objects such as Tables, Views, Indexes, Sequences and/or PLSQL objects like Stored Procedures, Packages, Triggers, etc.,
• Experienced in UNIX Shell Scripting and command line utility. Developed scripts for automation of various concurrent processes, mail generation, file handling, encrypting, archiving, etc., and registered them as host concurrent programs.
• Experience includes exposure to all teh phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
• Actively involved in handling of many production issues and fixing Bugs, working in proximity wif Oracle Support by logging Service requests, escalations, patch analysis and application.
• Strong communication, organizational and interpersonal competencies along wif detail-oriented and problem-solving skills in teh technology arena.
• Excellent problem-solving skills wif an ability to identify problems and implement connective solutions.

TECHNICAL SKILLS

Oracle Applications: Oracle Applications R12(12.0.6, 12.1.3)/11i(11.5.8, 11.0.3). General Ledger, Accounts Payables, Purchasing, Cash Management, Subledger Accounting, Inventory, Accounts Receivables, Fixed Assets, Order Management.

Oracle Tools: Reports 6i/9i/10g, Forms 6i/9i/10g/11g, Discoverer 4i/10g, Workflow Builder 2.5, XML Publisher, EIS Reports, JDeveloper.

Database: Oracle 10g/9i/8i, MS SQL Server 6.5/7.0, DB2, Sybase.

Development Tools: SQL*Plus, TOAD, PLSQL Developer, SQL*Developer.

Scripting: SQL/PLSQL, UNIX, JAVA, C/C++.

Application Utilities: SQL*Loader, TKPROF, UTL FILE, FND LOAD.

Operating System: HP-UNIX, SUN Solaris, AIX, LINUX, WINDOWS, NOVELL.

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

Sr. Oracle Techno-Functional Consultant

Responsibilities:

• Supervising teh process and functional design activities.
• User Support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
• Design and develop teh complex Lease solution software that modifies teh existing Oracle Property Manager application which handles teh lease abstracts and lease processes, to accommodate teh new lease accounting rule changes by Financial Accounting Standards Board (FASB -ASC 842) & International Financial Reporting Standards (IFRS-rule 16) globally.
• Work wif business users to gather and analyze teh business requirements for teh enhancement of teh new solution program to develop and install teh solution for teh lease portfolio of USA and for 16 International countries of teh client.
• Defined various Oracle Setups such as Custom and common lookups, DFFs, values Sets etc., as part of process design.
• Proficiency in defining/creating leases and their Index’s along wif Payment Terms.
• Worked on period and Quarter GL closing issues such as unbalanced JEs, currency conversion issues.
• Worked on Payment terms import issues from Property to AP.
• Worked closely wif teh business users to identify teh lease account discrepancies, identify teh root cause, and provide appropriate solution/work arounds.
• Performing unit testing and data analysis for new components/enhancements and make sure that teh functionality is as expected by teh user and teh user data is consistent throughout teh system.
• Authored several Reporting related MD50 both for Oracle Reporting and Insite Reporting (BIP).
• Developed several oracle queries for BIP reporting.
• Designed and developed Reconcile reports between Property Manager and AP.
• Performance Tuned existing BIP Queries to work on high volume table and fetch data correctly.
• Debug designed and Developed custom program/procedure for few major post-production issues in teh project.
• Designed Oracle Web ADI to provide an interface tool for users to load and execute ATLAS solution.
• Design and developed custom Oracle forms and concurrent programs wif pl/sql as project extensions.
• Designed teh custom accounting process from Oracle Property Manager to GL based on teh new accounting principals.
• Involve in data validation procedures, data validation sheets, acceptance testing (UAT), system integration testing (SIT), data processing, issues resolutions & go-live activities.
• Working wif teh QA or Validation team for data consistency, data clean-up and user acceptance.

Environment: Oracle Applications R12 (12.2.6), R12 (12.2.5) (General Ledger, Property Manager, Accounts Payable), Oracle Database (11g), Oracle BIP (InSite).

Confidential, Branchburg, NJ

Sr. Oracle Apps Developer

Responsibilities:

• Involved in Customization of various Financials Modules (GL, AP, AR, PO, INV and OM). Successfully Interacted wif Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.
• Customized menus, added new concurrent requests, registered teh custom applications, value sets etc. using System Administrator Module.
• Customized AP Check report in accordance to clients check printing stationary. Customized Report for Cash/Bank Book Report.
• Created interfacing objects such as Business Events, Custom workflows to communicate wif external systems using XML Gateway technology for 3PL Implementation.
• Involved in implementing various business process extensions of Order-to-Cash and Procure-to-Pay cycles as per teh business requirements.
• Designed and developed solution for Sunshine project for teh purpose of Sunshine Act government reporting.
• Workflow customizations in Purchasing Module me.e. PO Requisition Approval and PO Approval.
• Customization of Order Management Workflow for Sales Order Approval.
• Developed custom interface programs using standard Invoice Import interfacing to creates AP Invoices for expenses coming from external systems.
• Developed custom interface programs to create mass journal entries as a batch using standard Journal Import process.
• Developed and Customized Forms, Reports, PL/SQL Procedures, Triggers and Functions.
• Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.
• Developed XML/BI Publisher reports for standard purchase order wif 2-Way 3-Way- 4-Way matching, Customer aging report.
• Writing migration shell scripts to migrate code changes from instance to instance was also part of my responsibilities.
• Worked on various technical components such as Custom responsibility creation, defining concurrent programs, requests sets, values sets, creating interdependent parameters for a concurrent program etc.
• Developed FTP scripts to handle data activities such as inbound and outbound.

Environment: Oracle Applications R12 (12.1.3) (AOL, GL, AP, AR, PO, INV, OM, OPM), Oracle Database (11g), Forms 10g, Reports 10g, UNIX, Oracle SQL Developer, XML Publisher, Workflow Builder, XML Gateway Message Designer.

Confidential, Staunton, VA

Sr. Oracle Apps Developer

Responsibilities:

• Developed Interfacing objects to perform and mass load of Manufacturing Items and Items category assignments using data from an external file.
• Involved in various business meeting for gathering requirements for new developments and enhancements. Authored MD70 and MD120 based on teh requirements. Updated existing specification and migration documents for teh enhancements provided to existing functionality.
• Customized various existing Custom forms using Form Builder 10g to fulfill teh new brand requirements. Extensively worked on forms personalization to limit user access based on responsibility they logged in.
• Customized various reports using Reports 10g and converted few of them as per requirements into XML reports, by creating XML templates.
• Developed WebADI Integrator interface to create supplier Sites.
• Developed various new custom XML reports in P2P and O2C business process and registered them using XML Publisher Administrator.
• Extensively worked on interface maintenance and enhancements in Oracle Payables, Purchasing and Inventory. Extended functionality of various concurrent programs by adding parameters, value-sets, and embedding debug processes for ease of maintenance.
• Debugged various Data Corruption issues, accounting issues working closely wif business users in identifying and rectifying teh errors.
• Developed UNIX Shell scripts to make mass updates over existing setups and data.
• Extensively worked on FND LOAD utility for migrating objects between different instances. Download various LDT files for components such as concurrent programs, requests sets, forms, functions, request groups and uploaded to other instances.
• Developed migration scripts to migrate customized components such as forms, reports and concurrent programs as a batch.
• Production support was also one of teh main responsibilities, worked wif assigned production issues to provide resolution in a timely manner.
• Authored UNIX scripts to download LDT files for many components, such as concurrent programs, requests sets, forms, functions, request groups etc.
• Extensively utilized SQL Loader and DB links for converting a standalone database into oracle.
• Worked in collaboration wif Oracle support for resolving various production issues. Performed extensive patch analysis to validate client specific implications.
• Customized OE header workflow and Overdue Receipts Workflow process in IExpense to in corporate business logic.
• Provided extensive support during Month End, Quarter End and Year End processes.
• Extensively worked on Service Center ticketing system to identify assigned issues. Used version control and Code migration software as of when required.

Environment: Oracle Applications R12 (12.0.4) (AOL, GL, AP, AR, PO, INV, OM, BOM, WIP), Oracle Database (11g), Forms 10g, Reports 10g, UNIX, Oracle SQL Developer, XML Publisher, Workflow Builder.

Confidential, Bellevue, WA

Sr. Oracle Apps Developer

Responsibilities:

• Authored Technical Specification Documentation (MD70) from teh Functional Specs, attending meetings wif teh Business Analysts and Users.
• Designed and developed various components for loading AP Invoices into Oracle EBS, using standard Interface process.
• Created Staging tables to load legacy data, generated Control files and SQL*Loader scripts and registered them as concurrent program for data loading into teh staging tables.
• Created PLSQL procedures for validating teh data in teh staging table before loading into interface tables. Incorporated multiple business specific validations in teh PLSQL packages.
• Developed various UNIX shell scripts for FTP and archiving of data files, handling multiple file processing issues.
• Registered various request sets for automating teh submission of load, import and archiving teh data loaded into oracle AR.
• Customized GL Journal entry form using forms personalization embedding Trigger events wif Custom APIs as per client specification. For a manual Journal Entry added validations using API and enabled various fields of Line DFF as custom display enabled mandatory fields for user usage.
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.
• Performed UNIT testing on teh codes developed and provided extensive support during teh user acceptance and regression testing phases of teh project.
• Customized various forms, embedding complex business extensions for adding customer and item information in teh GL journal entry form, JE header block as part of Sales Detail Outbound interface process from Oracle EBS into legacy system.
• Designed and developed outbound interface, for extracting data from GL and AR as per teh client requirement, using oracle standard UTL FILE utility.
• Extensively used form personalization on Receivables, OM, and Procurement forms for back-to-back sales order processing.
• Developed various oracle reports using XML publisher for Account analysis, Customer Transaction Status validation, Integration Validation, etc.,
• Created various SRs wif Oracle for bug fixing and attended OWC sessions explain them teh issue and provided 24/7 support to obtain business critical issue resolution.
• Extensively worked on Version Control Software for code tracking and check-in.

Environment: Oracle Applications R12 (12.1.3) (GL, AP, PO, AR, OM), Oracle Database (11g), Forms 10g, Reports 10g, XML Publisher, UNIX, TOAD

Confidential, Renton, WA

Oracle EBS Consultant

Responsibilities:

• Understanding teh requirements by involving in teh Business meetings, authored Technical Specification, Change analysis and migration documentation.
• Designed and Developed codes for various periodic Inbound and Outbound interfaces including:
• Payables invoice Interface - Inbound
• Journal Import/GL interface -Inbound
• Remittance Advices - Outbound
• Supplier Extract - Outbound, etc.,
• Extensively utilized SQLLOADER, External tables, UTL FILE concepts for reading files and loading into oracle database. Created various packages, procedures and functions for validating teh data and loading into teh interface tables. Registered teh processes as Concurrent programs and combined and teh load, validation and Import script as request sets.
• Performed data conversion for newly implemented applications of R12.1.3, including pricing headers and lines, items and item costs.
• Redesigned and modified various custom codes developed in 11.5.10.2, to work wif R12.1.3 applications including, Manual Transaction Workflow, Ship confirm and Delivery detail identification, Drop ship process to block Sales Order Changes, etc.,
• Personalized various forms as per teh Business requirement, to block updates on all fields or few based on teh responsibility and Operating unit user is accessing. Developed various custom forms using Forms 10g to meet client specific needs.
• Developed various reports in Discoverer Plus, XML publisher, Reports Builder, EIS and PLSQL, including:
• Subledger Activity Report- Discoverer
• Vendor Audit - EIS
• Payment Register wif Coding - XML
• Delivery Detail - XML
• AP Invoice Aging - EIS
• AR transaction Aging - EIS, etc.,
• Designed and developed code to generate XML files for Out-bound extract and report generation using PLSQL and registered as Concurrent program.
• Developed custom mail UNIX script and registered as concurrent program which can be used to send notifications wif attachments as of when required.
• Supported existing interfaces into 11.5.10.2, by efficiently communicating and reprocessing as of when required. Enhanced interface codes for better debugging and error handling.
• Extensively worked in collaboration wif Oracle Support for resolving various bugs.

Environment: Oracle Applications R12 (12.1.3/11.5.10.2 ) (GL, AP, PO, INV, AR, OM, iExpense, iSupplier), Oracle Database (9i/11g), Forms 6i/10g, AIX/EXADATA, UNIX, TOAD, Discoverer 4i/10g, Reports 6i/10g, BI Publisher/XML Publisher, EIS Reporting, Workflow Builder, SYSAID, Rational Clear Case, Kintana.

Confidential, Appleton, WI

Oracle Techno-Functional Consultant

Responsibilities:

• Developed various in oracle BI publisher/XML publisher like Null Buyer Item, Future Cost Update and Backordered items Report and registered them as Concurrent Programs.
• Converted oracle Seeded reports in Reports10g to XML reports.
• Developed Custom packages to fetch ROYALTY item from staging table and load them into Item Master.
• Designed and developed various PLSQL programs and registered them as concurrent programs to fetch teh data and write to Comma Separated files in teh predefined Server location. Utilized UTL FILE Utility for writing data to teh file in middle tier.
• Authored various AIM documentation including Functional Specifications (MD50), Technical Design Specifications (MD70, MD120) and conversion documents CV40.
• Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice Base tables.
• Customized teh Accounts Payable Supplier Entry Form as per requirements.
• Developed simple to Complex worksheets, pivot reports using Discoverer Plus and shared teh workbooks wif users and responsibilities.
• Involved in designing and developing various reusable packages and procedures, which were utilized by various programs.
• Modified Customer Validation Program in Receivables, incorporating client specific Business requirements.
• Extensively worked RBAC, for defining new roles in R12, controlling user security.
• Worked on performance tuning like Explain Plan to improve teh performance of various custom PL/SQL Packages developed.
• Utilized FND LOAD for data migration of various system administration objects, between various instances such as Menus, Custom Responsibilities, Personalizations, Concurrent Programs, Value Sets, Flex-fields, lookups and others.
• Customized various workflows including Requisitions Approval (REQAPR), Invoice approval (APINVAPR), Order Headers and Order Lines in OM, Expense report approval (APEXP) and others using Workflow Builder.
• Prepared training documents and conducted sessions wif business users, to train them in teh newly developed custom extensions of teh existing oracle system.
• Extensively worked on Production issues, and resolved various bugs working in collaboration wif Oracle Support on Sev1 and Sev2 Service requests.

Environment: Oracle Applications R12 (12.0.6) (GL, AP, PO, INV, AR, OM, BOM, WIP), Oracle Database (10g), SQL*Plus, SQL*Loader, Forms 10g, SUN SOLARIS, PLSQL Developer, Discoverer 10g, Reports 10g, XML Publisher, CVS, SMILE ticketing system.

Confidential 

Oracle Applications Developer

Responsibilities:

• Team member in development of an in house MRP package to integrate Material Procurement, Inventory Control, Spares Management, Preventive Maintenance Planning Module and Production Control System Projects.
• Developed various reports using Reports Builder and PLSQL: Manpower Forecast and Planning, Daily and Monthly Production, Goods Receipt Note, Inspection Report, Acceptance & Rejection Reports, Issue of Material, Material Utilization.
• Worked on fine-tuning of SQL queries and PLSQL procedures for improved performance. Utilized Explain Plans to analyze and SQL Hints where ever required.
• Customized teh ‘OM: Generate Cost of Goods Sold Account’ Workflow to generate teh COGS account that meets teh business requirements.
• Developed Various Reports in GL, AP and AR and customized them using XML Publisher.
• Customized existingDunning Reportand Invoice PrintingReport in Accounts Receivables usingXML/BI Publisher.
• Customized various reports in Order Management, Inventory and Shipping. Some of them are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report.
• Involved in writing stored procedures in PL/SQL to validate, select, insert and update data in material procurement module. Material procurement module enables shop floor engineers to requisition and procure items involved in production and maintenance of machinery from central stores as well as from company vendors.
• Designed and developed reports in Oracle Discoverer for tracking Preventive Maintenance of machinery (pumps, motors, heat exchangers, dryers etc.) involved in day-to-day production activities

Environment: Oracle Apps Release 11i (11.0.3/11.5.8 ), Oracle Database (8i/9i), SQL*Plus, SQL*Loader, Forms 10g, UNIX, TOAD, Discoverer 10g, Reports 10g, BI Publisher/XML Publisher, SQL DEVELOPER.