SUMMARY:

• 11.1 years of experience in Oracle Applications, out of which 1.0 year as Onsite technical lead.7.0 years in Implementation as a Techno functional Consultant( in Oracle Applications Release 11i/R12 E - Business Suite along with 6.0 Years months in OAF/ADF Jdeveloper experience
• Expert in OAF and worked as OAF Architect and solution/Design in most of the releases.
• Developed and customized /personalized the OAF pages forms from scratch.
• Prepare test cases, unit testing and involve SIT and CRP’s, UAT testing’s. And adhere the issues/tickets come out of testing.
• Familiar with testing tools like MQC and migration tools like kintana s, ticketing tools like Service now, JIRA.
• Well experience in SDLC process like design, solutions, development, execution and deploying till Go Live .
• Good experience on Conversions and interface experience in Finance/SCM.
• Knowledge on Web ADI development and customizations.
• Adding validations and mapping the columns as per requirement for interfacing through Web ADI.
• Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support
• Involved in setup of Set of Books (Chart of Accounts, Calendar and Currency).
• Involved in setting up the cross validation and security rules.
• Writing Unit Test cases and testing after completion of the Object.
• Configuring and enabling/disabling customer profiles in TCA architecture.
• Good experience/Knowledge on (Set of books, Ledgers(R12), TCA, Accounting setups, P2P, O2C cycle, SLA, Open/Close Periods, Flexi field Qualifiers and segment Qualifiers)
• Developed end to end Invoice, Journal Entry, Item, WIP, BOM, Routing, requisition, Supplier, Task etc Conversions using standard API and Interface tables.
• Rollout project experience in Confidential Projects. Developing, coordinating with onsite managers, client and offshore team.
• Scheduling the calls on required basis with business team, multi vendor team and offshore team.
• Set up and Configure experience in projects on required basis.
• Experienced in implementation, customization and Application support activities of Oracle Apps 11i & R12Financial modules (GL, Fixed Asset FA, AP, AR, CE) using AIM implementation method & integration with Inventory modules (PO, OM, INV).
• Customization in I Expense Module and Risk management.
• Currently working R12 Upgrade and new build Enhancements for Carrier Integrations.
• Good exposure of Carrier integrations and shipping process with FedEx, UPS, Expeditors.
• Modified the Expense Submit Page to enable the Attachment functionality.
• Modified the Expense Workflow to add a node to call custom PLSQL Method to update above two Fields and Trigger the (Standard Expense Receipts Workflow) receipts received Notification Workflow (FYI I Notification to the submitter).
• Extensive knowledge in Trading Community Architecture TCA and worked on importing banks, suppliers into Oracle AP using TCA API's
• Customized the Supplier Payment History Report, Invoice History Report in Payables using XML/BI Publisher
• Worked on Interfaces to import Receivables Transactions into the interface tables in Accounts Receivables Successfully designed and implemented the Auto Invoice Import Interface. Activities involved extraction, importing Transactions into interface tables, defining sources for import and then using Auto Invoice Import Interface to import the data into the base tables.
• Well versed experience in procurement both Technical& Functional and I supplier technical. Customized and developed custom OAF/ADF pages. And setup the Catalogs and Non Catalogs as per requirement.
• Well versed experience with BI Publisher technology with multi way of source of Data like Writing the PLSQL PKG, Data template and RDF reports.
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Worked on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash, procure to Pay Cycles touching various modules such as OM, AR, PO and AP
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables
• Good knowledge on OM, PO, I Procurement, AP, GL, AR, PA, SLA, and Oracle Service contracts, OTL, iExpense.
• Having good end to end implementation experience on RICE components and ERP Cycles O2C and P2P.
• Developed &customized Self-service pages (OAF Pages) and also self secured pages.
• Numerous VO/EO/AM and Controller extension experience in OAF (9i&10)
• Developed SWQ(Multiple Tab Pages ) .Familiar with PPR concept with coding and without coding
• Customized complete Check out and Non catalog Pages in I procurement. by adding new custom region.
• Very Strong experience in OAF Personalization’s and familiar with multiple way of migration of both OAF pages and OAF personalization’s into oracle Applications and registering the pages in oracle applications.
• Developed the task summary and multiple pages in diff modules like isupplier, Iproc, from Scratch using Java, HTML, JAVA Script J2EE and MVC architectures where it was required.
• Very familiar with Search, create and Modify, Master detail pages in OAF. and creation Business components like EO, VO,AM, CO, VL etc.
• Having knowledge in istore module and customization of JSP pages in istore using Java, HTML, JAVA Script J2EE and MVC architectures.
• Have good exposure in Modules like Account Payables, Account Receivables, Fixed Assets, General Ledger, Purchasing Order and Order Management.
• Developed the SQL and PLSQL (Objects) Scripts in PA, Customers (AR) module as per requirement basis.
• Developed numerous Reports (SQL, XML, Oracle reports 6i&10g ) and sql and PLSQL scripts and performance tuning in in various modules like PO,AR, AP, GL, PA, GL,OM
• Excellent skills in Oracle (SQL, PL/SQL, Forms & Reports 6i&10g, BI(XML) PUBLISHER.).
• Good exposure to Oracle Application Implementation Methodology (AIM)
• Worked on AventX configuration/ monitoring/ trouble shooting for communication like emailing or faxing of the Output of the Concurrent programs or Oracle reports
• Familiar with SQLLOADER, Data loader, tools and XML Bursting, Custom.pll process
• Familiar with version control and multiple code migration tools like Tortoise CVS, HPPM and STATS.
• Familiar with multiple SR(ticketing) tolls like Service now, JIRA, HPMQC
• Have a good knowledge in Workflow customizations and building new custom workflow.
• Customized the Standard PO Workflow to have Stop sign (custom logic) before it routs for actual Approval process.
• Familiar with AME engine in PO and retrigger the Workflow or monitoring/trouble shooting PO approval process for the Workflow failures
• Always used gets appreciations by Projects team/manager /Business user and clients for Quick turn round/Flexible and reliable solutions provided in multiple functionalities and across multiple Projects.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills, communication skills and interpersonal skills.
• Worked in multivendor team projects and big team size projects

TECHNICAL SKILLS:

Oracle PL/SQL: PLSQL Developer, TOAD, Sql developer ERP (Oracle Apps 11i &R12) SQL * Loader, Putty, FileZilla, Jdeveloper9i and 10g Developer 2000(D2k) 6i & 10g, Workflow, BI Publisher (XML Publisher), ERP(Oracle Apps 11i &R12) Modules OM, PO, I Procurement, AP,GL, Fixed Asset FA, AR,PA,INV, isupplier, iExpense, Web ADI

Operating systems: Windows XP/NT/2K, UNIX.

Others Tools: STATS, HPPM, HPMQC, Service now, AventX, JIRA

Utilities: FNDLOAD, D2K reports to BI Publisher, UTL FILE, SQLLOADER, Data loader, XML Bursting, Custom.pll

Method: Oracle AIM Methodology

PROFESSIONAL EXPERIENCE:

Confidential, Hanover, MD

Sr. Oracle Apps Technical Developer

Responsibilities:

• It was R12 upgrade project from 11. .2.4 Release.
• Was important key player in Confidential Carrier Integrations development
• Closely worked with business user to understand the process of Confidential relationship with Carriers like FedEx, UPS, and Expeditors etc.
• Played key role in design and solutions for carrier integrations from oracle point.
• Worked closely with b2b team OTM and GTM team for carrier integration in flow/outflow of data from carriers to EBS and EBS to carriers.
• Build numerous Database objects from Scratch like Triggers, Views, and Packages etc for END to End process for Carrier Integrations.
• Developed the important program of Carrier integration for inbound and outbound of data flow end to end Carrier integrations. This programs are called
• Build the Complex functionality end to end Integrations with real-time data flow using triggers (Written multiple triggers on each flow)
• Developed the Carriers Integration Errors Dashboard Page Using OAF technology To track the errors for each module of carrier integrations.
• Created master Scripts to deploy the OAF and Carrier integration code to the Applications (Including FND LOAD Scripts, PLSQL Scripts and OAF pages.)

Environment: Oracle Applications R12 Upgrade (AR, Shipping, OTM, GTM, OM, Carrier Integrations), Jdeveloper 10g (OAF), Oracle 12g, Toad, Workflow, UNIX.

Confidential, Stamford CT

Oracle Apps Technical Developer

Responsibilities:

• Modified the Credit Card Lines page, Cash n others Lines Page to add Custom Browse button at Line Level to upload the Expense Receipts in Standard table.
• Modified the Expense Submit Page to enable the Attachment functionality
• Extended the Standard CO’s to achieve the above functionality and to add custom validations, ie File Type, File Size, Billing and non-Billing Expenses Based on Custom lookup derived values.
• Switching the attachment functionality either at Line level or header level based on Custom Lookup derived Values for different OU’s
• Added the paper Receipt message and validation on Submit page to notify the User to Submit the Paper receipt in order to get pay reimbursed.
• Personalization To add Extended controllers In Credit card page, Cash and Submit Page
• Added the Logic to update Recipts Received Date and Status in Extended Standard Expense Workflow.
• Modified the Expense Workflow to add a node to call custom PLSQL Method to update above two Fields and Trigger the (Standard Expense Receipts Workflow) receipts received Notification Workflow (FYI I Notification to the submitter).
• Modified the existing Custom Risk Management Application Pages to In corporate the Addition Enhancements Like creating new custom Page (Search /create), Modifying the VO’s, CO’s and custom OAF pages.
• Enabling the credit card details to user, and loading the credit card details in Payable Module as on required basis.
• Modified the Custom Contract Approval Process Workflow to add new message and new Attribute and assign the Value in Triggering pkg.
• Created master Scripts to deploy the I expense and risk managements code to the Applications (Including FND LOAD Scripts, PLSQL Scripts, WFLOAD, and OAF pages and OAF personalization’s Scripts)

Environment : Oracle Applications R12 (HRMS, I Recruitment, GL, AP, I Expense), Jdeveloper 10g(OAF), Oracle 12g, Toad, Workflow, UNIX.

Confidential, Pittsburgh, PA

Oracle Apps Onsite Technical Lead

Responsibilities:

• Was leading the conversion activities from Onsite.
• The Project was implementation project to migrate/convert the data from legacy System (Baan) to Oracle R12.
• Designed and developed GL Daily rate interface and Fixed Assets mass additions Interface.
• Imported Bank and Bank Branch Details from Legacy system to Oracle System
• Involved in writing the Conversion Documents of GL and AP for data conversions from the Legacy.
• Developed Missing Assets Report in Fixed Assets FM module to identify missing assets based on physical inventory including a PL/SQL program that identifies and prints the report
• Developed Auto Write-off Inventoried Assets to identify Assets missing for more than two years and retire them automatically
• Have good exposure in Modules like Account Payables, Account Receivables, Fixed Assets, General Ledger, Purchasing Order and Order Management
• Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar
• Resolved the issues related to security rules which were affecting the FSG reports.
• Establish data conversion routines and executed scripts to convert GL, AP and FA data from legacy systems
• . Established new procedures for AP, PO, GL and FA modules
• Have good exposure in Modules like Account Payables, Account Receivables, Fixed Assets, General Ledger, Purchasing Order and Order Management.
• Developed a new SQL script to extract all the assets data.

Environment : Oracle Applications R12 (GL, AP, AR, CE, CST, INV,OM, PO, i Store ), Oracle 12g, ToadWorkflow, UNIX.SQL LOADER, D2k Developer, BI Publisher

Confidential, Cincinnati, Ohio

Oracle Apps Onsite Technical Lead

Responsibilities:

• Understand the pain areas in business process and act accordingly to simplify improve the Process and.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables
• Developed PO Requisition reports, PO Receipt BOM Explosion report, Open PO Reports, PO Contract Flow Down report etc using BI Publisher technology with multi way of source of Data Like Writing the PLSQL PKG, Data template and RDF reports.
• Modified the Standard PO Workflow to add Stop Sign Condition (one Level check before routing to Actual workflow Process) for hard pegging Items or Contract Projects.
• Developed /Build the Scripts/logic based on Set of books, Ledgers(R12),TCA, Accounting setups,P2P, O2C cycle, SLA, Open/Close Periods in various reports and PLSQL Programs.
• Modified the Standard AR Invoice and PO PDF reports from RDF to BI Publisher and added Additional required logic and columns
• Worked on Interfaces to import Receivables Transactions into the interface tables in Accounts Receivables Successfully designed and implemented the Auto Invoice Import Interface. Activities involved extraction, importing Transactions into interface tables, defining sources for import and then using Auto Invoice Import Interface to import the data into the base tables
• Personalized the Standard PO form to add Item revision DFF values in PO DFF based on Item validation org during When new form Instance and validation triggers.
• Modified Oracle provided Hooks to add Custom logic during PO Approval Process
• Mass PO PDF run during Conversion Process and burst into individual PO Copy using Standard Bursting Program and attaches using custom Program.
• Enabling the Contract Articles /Notes on the PO PDF for Project based PO’s
• AM, CO, VO Extensions, page extensions and Personalization of OAF pages.
• Customization of OAF pages and Deployment of Personalization and Customizations.
• During CRP/SIT testing would monitor MQC for defect log on daily basis and act accordingly.
• Involved in developing the end to end developing the RICE components.
• Developed SWQ multi tabbed page complex custom page to have multiple functionalities like drilled down to standard forms/pages based super/other user Access control.
• Moved OAF personalization from one responsibility to Other Responsibility By writing Script and finally moved all 10 Resp Personalization to Oracle By OAF Script.
• Personalized to add Custom page in Depot repair module.
• AventX configuration and monitoring for email or fax communication of the Output of the PO PDF and Invoice program for the end users.
• Worked Onsite/Offshore model and multi-vendor team’s model.
• Always appreciated me by Quick surround solution provided in multiple functionalities.
• Was well connected/communicated with DBA, functional and business team /user during Cutover and CRPS activities

Environment: Oracle Applications R12 (GL, (Fixed asset FA) AR, CST, BOM, WIP, INV, OM, PO, CRM, Depot Repair, Field Service), Oracle 12g, Toad, Workflow, UNIX.SQL LOADER, D2k DeveloperBI Publisher, Jdeveloper 10g (OAF)

Confidential

Oracle Apps Technical Support

Responsibilities:

• Along leading Involved in developing and Customizing OA pages.
• Full fledge customization of I procurement using OAF technology.
• Customized the Checkout Page to hide standard region and add custom Region
• Modified the PO PDF report logic to handle 54 templates by designing the Custom lookup.
• Modified the Customer Logic
• Experience/Knowledge on (Set of books, Ledgers(R12),TCA, Accounting setups,P2P, O2C cycle, SLA, Open/Close Periods, Flexi field Qualifiers and segment Qualifiers)
• Documented the Month end close Process as per the Confidential process.
• Used to participate the Month end process call was quickly fixed the issues during the Period close.
• Configure the Set of Books, Calendar, Currency and COA.
• Modified the Confirmation Page to add custom logic.
• Modified Oracle provided hook to default the Values in non-Catalog tab.
• Modified/personalized /customized a lot Controller’s, fields and VO, EO Extensions in I procurement.
• As it is support project used to check service now to see any logged tickets and assign the team accordingly and used work from my on a required basis.
• Involved in the GAMS calls, Integration Team to understand the process and pain areas and work accordingly to meet customer expectations
• Customized and developed custom OAF/ADF pages .and setup the Catalogs and Non Catalogs as per requirement for I procurement and I supplier.

Environment : Oracle Applications R12 (GL, AR, AP,PO, I Procurement, I Supplier, Field Service), Oracle 12g, ToadWorkflow, UNIX.SQL LOADER, D2k Developer, BI Publisher, Jdeveloper 9i/10g(OAF)

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Developed Task Summary Page in OTL Module add a link by personalizing the Standard OTL time Entry Page.
• Modified and Extended the Project and task Lov in OTL Time Entry page
• Based on custom logic
• Registration OA pages into oracle applications.
• Creating AM, VO, EO, VL and Associations as per the client configuration.
• Development of new self-secured pages.
• AM, CO, VO Extensions, page extensions and Personalization of OAF pages.
• Customization of OAF pages and Deployment of Personalization and Customizations.

Environment: Oracle Applications R12 (AP, OTL, Oracle Projects, Field Service), Oracle 12g, Toad, WorkflowUNIX.SQL LOADER, AK Developer, Jdeveloper 9i/10g (OAF)

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Registration OA pages into oracle applications.
• Journal import
• The requirement was to transfer the journals information from legacy to GL module. This process is scheduled as per client requirement.
• PO requisition open interface import
• The requirement was to transfer the requisitions from external system to oracle base tables.
• Standard interface table is po requisitions interafce all.
• Vendor open interface import
• The requirement was to import vendor information which are created in the external system to oracle applications.
• Standard Interface Tables are AP SUPPLIERS INT, AP SUPPLIER SITES INT And AP SUP SITE CONTACT INT
• Customization of OAF pages and Deployment of Personalization and Customizations.
• Developed Revenue recognition custom OAF page
• Developed Complex Multi tabbed TLIF (Task Line Summary Page) and Outage page(Multi tabbed) custom page based on the Service contracts, Filed service, Installed base modules
• Developed the custom documented Page in isupplier portal to retrieve the Engineer document for each PO Items from Confidential Standard Documentum Legacy System.
• Developed one of complex Quality Plans Page. Generating the Structure of table very dynamically based on selected Quality Plans and its related Data Structures.
• Developed Dynamic Pop List Lov by generation of static values.
• Familiar with code migration process during cutovers.
• Involved in end to end development of RICE components

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Developed Order Interface to upload data into Oracle Applications base tables.
• Customization of Purchase Order Report in AP Module
• Developed Cleared invoice report in AP Module.
• Developed pending purchase order report
• Developed Order Interface to upload data into Oracle Applications base tables.
• Developed the AP invoice Interface Program to transfer the Invoices from legacy system to oracle system
• Customization of Ap Bank branches report in AP Module
• Developed Item cost comparison new reports in custom Module.
• Involved in the development of procedures, functions and packages.
• Involved in end to end development of RICE components
• Extensive knowledge in Trading Community Architecture TCA and worked on importing banks, suppliers into Oracle AP using TCA API's
• Customized the Supplier Payment History Report, Invoice History Report in Payables using XML/BI Publisher
• Created the final accounting for Sub Ledger Journal Entries (JEs) and transferred the accounting to GL.
• Involved in Customer Conversion to load Customer details into Interface tables by creating staging tables and performing validations and finally loading then into base tables.

Environment : Oracle Applications 11i (INV, BOM, GL, AP, PO, (Fixed asset FA)), Oracle 9i, Toad, UNIX.SQL LOADER

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Stock locator import
• The requirement was to create the new locators in oracle base tables by using standard oracle API named as INV LOC WMS PUB.CREATE LOCATOR.
• Bills and routing interface import
• The requirement was to transfer the routing information from legacy to BOM module. This process is scheduled as per client requirement.
• Involved in developing and Customizing the Forms, Reports, and Interfaces
• Registration of reports with oracle applications
• Involved in the development of procedures, functions and packages.
• Involved in end to end development of RICE components
• Developed Available quantity Report as per client Requirement.
• Customized the Supplier report.
• Developed Supplier correction form in custom module as per Client Requirement
• Customized PO forms as per client requirement.
• Developed Mtl interface Errors report as per Client requirement.
• Developed PLSQL Procedure, Functions. Procedure Triggers, SQL tuning.
• Created FND Objected for executable, Values, Validations etc.
• Developed Scripts PLSQL for logic changes and in reports modifications.

Environment : Oracle Applications 11i (INV, BOM, WIP, GL, AP, PO), Oracle 9i, Toad, UNIX.SQL LOADER, D2k Developer 6i