EXPERIENCE SUMMARY:

• 9+ years ;of experience as an ;Oracle Apps Technical Consultant/Oracle EBS Techno-Functional Consultant/Oracle Techno-Functional Support Analystwith IT Companies likeARROW ELECTRONICSINC,ORACLE, ACCENTURE ;and ;CAPGEMINI.
• Strong experience in Oracle Application Financials and Supply Chain Modules such as General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Project Accounting (PA), Order Management (OM), Inventory (INV)
• Strong experience in Oracle Application R12/11i(11.5.10)/11.5.9
• Worked forfor GovernmentSector Clients such as ;Health Protection Agency(HPA), Rural Payment agency-RPA (Public Sector Organization) ;, Northern Ireland Civil Services(Public Sector Organization)
• Strong experience in ;Implementation,Support and Upgrade ;projects
• Excellent technical skill working on ;PL/SQL, SQL, Unix, ;Data Migration (Interface/ Conversions/APIs), Workflows, Reports, Extensions(RICE Components).
• Performed peer review for the work assigned to the team members
• Provide status update to the reporting manager
• Assisted team in resolving issues
• Excellent communication skills
• Coordinated with business user for requirement clarifications
• Experience working on the client site.
• Perform initial resource assessment/Interview while hiring resource for the project.
• Used oracle ;AIM’s ;methodology for technical documentation such as ;MD70,TE20,MD120
• Logged new ;SRs ;in oracle metalink for issue resolution.
• Technical Activities (Module lead, Senior Consultant):Identifying and clearly understanding the business requirement provided, estimating work, designing custom solutions, programming, leading developers, producing documentation and providing production support.

JOB INTERESTS:

• Oracle Applications Implementations and Upgrades/Production Support / Techno-Functional Consultant/Senior Developer ;(Oracle Applications ERP: (R12, 11i) Implementations, Upgrades, Customizations, Extensions, Workflows, Interfaces/Conversions, Reports).

EDUCATION

• Bachelor’s Of Engineering

KEY SKILLS

Oracle Apps Modules ;General Ledger(GL), Accounts Payable (AP),
Project Accounting (PA), Accounts Receivable(AR),
Inventory(INV),Order Management (OM),SLA
Languages: ;SQL, PL/SQL, Unix shell script
Reporting Tools: ;BI Publisher ;, Oracle Reports 10g/6i/6, ;
Limited ExposureDiscoverer,
Other Tools: ;Oracle Work Flow, Sql*Loader, Toad,flexform software ;
Visio, Power point, Excel, Word, HP Quality Centre, Textpad.

FUNCTIONAL SKILLS

General Ledger(GL )

Defining Segments, Defining Value sets, Defining segment values, segment qualifiers, cross validation rules, summary accounts, rollup groups, Defining Accounting flex fields, defining ledgers/set of books, defining legal entities, Defining rate types, Defining daily rates, enabling multi reporting currency for the ledger/set of books, defining journal sources, defining journal batches, defining recurring and mass allocation journals, defining secondary ledgers in R12,Defining Accounts, Defining Accounting mapping

Accounts Receivable(AR)

Entering transaction(Invoices, credit, memos, debit memos, on account credits),defining application rule sets, invoicing rules, accounting rules, grouping rules, defining transaction types, defining transaction sources, payment terms, defining customer, auto invoice(Importing invoices)Defining system options(Accounting, transaction and customer, miscellaneous)

Accounts Payable(AP)

Entering Invoices, Invoices lines, defining payment terms, defining invoice types, validate create accounting, format an invoice. Applying hold to an invoice, defining payment terms, create payment for the invoice, define banks, define suppliers, open/close Payable accounting periods, define payable options, define financial options

Inventory(INV)

Creating Item template, creating items, defining sub inventories, defining item categories, defining item ;
category sets, defining customer items, setting up organization access, performing material transaction ;
(Account issue, account Receipt, account Alias Receipt, account Alias issue), performing on hand quantity ;
validation. Open/close inventory periods, defining unit of measures

OM(Order Management)

Setting up customer, profile class, defining price list, modifier, qualifiers, defining holds, defining ;
payment terms, pick releasing, ship confirming, order booking..

Environment: Oracle Applications Release R12
Confidential,Aug’11 Till Date
(Oracle Apps Technofunctional Consultant)
Project: Unity ;
Responsibilities

• Worked on Supplier Bank Account Interface
• Cleared the autoinvoice interface table records for records having any issues such as duplicate llines,wrong ship to address,records with order date in closed period etc.
• Cleared the AP invoice interfaces for month end for intercompany invoices and invoices uploaded from different soruces such as B2B,B2B-NON,,WEB-ADI etc.
• Ran the record order management,collect revenue recognition information,generate cogs recognition events to move dcogs from cogs for transaction having high dcogs.
• Analysed the order if they were not invoiced to AR which caused high dcogs figures
• Fixed issues related to long running BI publisher report where these errored because of high volume of data
• Worked on CR for custom code related to IPV.
• Worked on creating an automated sql script to capture issues related to accounting and order such as ipv count and details,dcogs count and details,GRNI details etc The script creates the excel of the detail files and html summary.
• Presently logged an SR for issue where the user gets an error message tax does not exists
• Worked on order management workflow and assigned it to a order type
• Fixed payable issue where payments where not being transferred to GL.
• Provided prod support.
• Provided user with data extracts(reports) as per business requirement for eg. Erroneously Invoice created for only freight lines
• Worked on ar report to provide ar trial balance details to the users.
• Worked on custom sql report to pull all the inventory transactions for the gl source ipv and the corresponding ap invoices.
• Will be working on new script to apply credit memos to wrongly created freight line invoices.

Environment: Oracle Applications Release 11.5.10

Confidential,Jun’10 Aug’11
(Oracle Apps Technofunctional Consultant)
Project: NPC ;
Responsibilities

• Analysed the requirement and provided the project estimate.
• Attended meetings with business users to get clear understanding of he requirement.
• Helped user move the ap transactions to next period during period close.
• Fixed issue in the invoice workbench where invoice name had an additional space and could not be cancelled
• Working as techno-Functional provided Support and Change Request and development (11.5.10.2)
• Setup new printer in oracle application as an ;system administrator
• Used a third party tool to create and overlay formats checks and remittance advises
• Modified a custom report to display all the AR transactions for the corresponding gl lines(drill down)
• Fixed the Inventory close period end error.Applied a data fix
• Worked on order management workflow and assigned it to a order type
• Fixed payable issue where payments where not being transferred to GL.
• Created a custom package to create service requests,notes,tasks for a customer when customer logs a requests or request change to his account in service contracts module

Confidential, Oct’07 Jun\'10
(Senior Oracle Application Support Analyst)
Project: Verifone ;
Responsibilities

• Working in Support and ;upgrade project(11.5.10.2 to R12)
• Documented the MD-50 and MD70 for the reports upgraded.
• Converting oracle rdf reports to BI Publisher reports
• Used the oracle standard java API to create Data Template, RTF and related packages from the windows command prompt.
• Registered concurrent program having executable type XDODTEXE with output set to XML.
• Fixed requisition approval workflow issue for the business user.

Environment: Oracle Applications Release R12

(Senior Oracle Application Technical Consultant)
Project: Confidential,
Responsibilities

• Worked on Extensions RICE Component in Accounts Receivable (AR) in TCA.
• Understood the requirement and created technical design documents(MD70)
• Developed custom packages for generating XML file depending on letter types (Seven) requested by the customer.
• Registered two concurrent programs one as batch process (scheduled program) for extracting data for customer who are newly registered and populating the letter and customer details in the custom table.
• The data extracted for the customer depends on the company-customer relationships (TCA) and the empowerments assigned.
• The letter needs to be sent to the customer if he has the appropriate empowerment level.
• Second concurrent request (Individual request) extracts and populates the data in the custom table for the customer and the letter depending on letter type requested by the customer.
• Developed another package for validating and generating xml file in the specified directory.
• This package validates if the customer-company requesting has appropriate empowerment level.
• Created UTPs’ (TE20) and performed unit testing
• Fixed issues during system integration test.

Environment: Oracle Applications Release 11.5.10

(Senior Oracle Application Technical Consultant)
Project: Confidential, ;
Responsibilities

• Developed ;custom oracle reports(RICE) ;in General Ledger(GL),Accounts Payable(AP),Accounts Receivable(AR),Purchasing(PO),Inventory(INV)
• These are reconciliation reports which check the count of records selected in the primary database that would be purged by the standard oracle program with count of records in the Archive database.
• The report prints the count of records in both the databases and details of the missing records from the archive or secondary database.
• Involved in the ;Integration ;and ;UAT ;test phases.

Environment: Oracle Applications Release R12
Project: Confidential,

Responsibilities

• Worked on data migration(RICE Components)
• Led a team of 5 persons. Coordinated between the development team and the onsite functional team got clear understanding of the requirements.
• Resolved issues for team members
• Worked on inbound interface for importing the sales invoices from different billing application into oracle application using the Auto Invoice Master Program in R12.
• Attended functional walkthrough of the component to get clear requirement understanding.
• Logged the issues in share point. Interacted with onsite team for issue clarification.
• Created the technical design document and unit test plans for the object.
• Created staging table as per the data file and interface table.
• Created concurrent program of type host.
• Created concurrent programs which calls the pl/sql package (custom validation program) for validating the staging table records and inserting those into interface table.
• Created request set to run the programs sequentially.
• Defined individual programs incompatible to itself.
• Created the installation scripts.
• Worked on inbound interface. This interface creates the CSV file rather than loading the data into the interface table.
• The legacy data is uploaded in to oracle application/base tables using the Oracle WEBADI from the CSV file by the business user.
• Created three concurrent programs first is a UNIX script for loading the data into the staging table.
• Second concurrent program is the custom validation program for validating the records before writing into the CSV file.
• Third concurrent program calls the UNIX script for the spooling the records from the staging table into the CSV file.
• Registered the concurrent programs, executables
• Worked on out bound interface for extracting data from oracle application to legacy system.
• Created the position delimited file with required columns as per the DFD.
• Used the shell script to create the position delimited file.

Environment: Oracle Applications Release 11.5.10 ;
Project: Confidential,

Responsibilities

• Interacted with the business user for requirement gathering for system load testing.
• Created Test scripts for load testing
• Worked on performance tuning of queries.
• Worked on the gl_daily_rates interface(RICE Component).
• Created the staging table as per the data file and the interface table.
• Created the custom validation program for validating the records before inserting into the interface table.
• Created the request set..
• Create the technical design documents and UTPs as per the DFD.

Project: Confidential,

• As developer customized sourcing workflow (RICE Component) to send notification to all the members of the collaboration team.
• Created new attribute team members.
• Created the installation script for uploading the workflow.
• As developer worked on ;transaction Conversion in Inventory Module ;to import different transactions and Upload tax book interface
• Created staging table as per the data file and interface table.
• Developed the shell script to load the data using the sql*loader into the staging table.
• Developed custom validation package to validate the legacy data before inserting into interface table.
• Registration of Program:, Procedure and SQL *Loader in Oracle Apps. Defined executable, Concurrent Program and attached in Request Group.
• Prepared the technical documents such as MD-70, TE-20,MD120 as per the requirement in MD-50.

Environment: Oracle Applications Release 11.5.10 ;

Confidential,Aug’06 Aug’07

Role : Developer.

Responsibilities:
As a developer

• Developed a custom workflow(RICE Component) for sending notification with attachment to different groups.
• Attachment is a file created using utl file for each group with respective data for that group
• Sent same notification to multiple user in that group.
• Triggered the workflow from the concurrent program.
• Prepared the technical documents such as MD-70, TE-20 as per the requirement in MD-50.
• Co-ordinated with the onsite team for issue resolution.
• Created the ldt files to down load the concurrent program
• Used the WFLOAD command to load the workflow in the database.
• Identification of the customer requirements for custom workflow(RICE Component), conversions.
• Translating the requirements in to technical specifications.
• Implementing and developing custom workflow for importing the orders from custom order tables into order management using the workflow builder 2.6.
• Used the workflow API to trigger the workflow start process from backend.
• Designed and developed numerous packages procedure and functions for importing the orders into order management and then pick releasing the orders.
• Sent notifications to the defined user updating him whether the order imports was successful or failed.
• Used WFLOAD command in UNIX for loading the workflow into the database.