Experience Summary:

• Eminently Focused, Result driven Oracle Financial consultant with over 8 years of core Oracle financial experience.
• Comprehensive experience in different areas of Development, Production System Support, Data Conversion techniques, Implementation, System Configuration and Customization of Oracle Application modules like Oracle General Ledger, Oracle Accounts Payable, Accounts Receivable, Oracle Purchasing and Oracle Asset.
• Strong familiarity with AIM methodology in creating BRD, BR-100, MD-50, MD-60, MD-70 etc documents throughout multiple Projects.
• Highly skilful in Designing completely new system and troubleshooting the legacy systems with unique ability to deliver under critical time bound requirements.
• Skilled in eliciting user demands and translating them to data, functional and usability requirements.
• Facilitated and participated in Joint Application Design (JAD) sessions, user workshops, conference calls and white board sessions to plan strategic Business decisions and detailed systems design.
• Excellent writing skills in authoring Business Requirements Document (BRD), Functional Requirement Design (FRD), Use Case Specifications, Systems Requirements Specification (SRS), Data Dictionary, Workflows.
• Strong functional and technical expertise in Procure to pay process and exposure to Order to Cash in flow Oracle finance.
• Experience on implementation and support of Payable integration with e invoicing with 170 Mark view Imaging systems.
• Experience of set up, configuration, documentation and coordination of CRP and UAT testing with user of I Expense, I Supplier Module.
• Worked extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables.
• Experience in working upgrade projects in R12.1.2, R12.0.5 and R11i application.
• Strong quality bias, self driven and highly motivated for timely target achievement.
• Excellent written and oral communication skills with a results-oriented attitude.
• Skilled in various MS Office tools including MS Visio and MS project.
• Served as the key point of contact/Liaison between on and offshore
• Co-ordinate and follow with offshore team to accomplish the milestones as per project time line.
• Effective time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved.
• Experience in reviewing Test Procedures, defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Good Knowledge ofSOX (Sarbanes-Oxley act) compliance.
• Enjoys a professional attitude and have excellent communication skills, self-motivated and multi-task oriented, with strong work ethics and ability to work effectively and cohesively in a team or individually.
• Experience in working as team lead on onsite and offshore model for more than 5 year in Wipro Technology.

Skill Set :

Environment : R12.1.2, R12.0.5 and R11.5.10

Oracle Application :

• Accounts Payables,
• Account Receivables,
• General Ledger,
• I Expense
• Oracle Purchasing,
• Oracle I supplier
• Oracle Time and Labor

Other modules : AOL, System Administration
GUI : Developer 2000 (Forms6i, Reports6i), Discoverer,
RDBMS : Oracle 7.3/8.0/8i/9i /10g
Technical : SQL, PL/SQL, Data Loader, SQL Loader, UNIX and Shell Script
Tools : Toad, 170 Systems Markview, PVCS, and TRS.

PROJECT DETAILS:

Project Name : Oracle Financial Process Stabilization Project (Jul ’10 till Date)
Client : Confidential,Dallas
Role : Onsite Lead: Finance Track
Environment : Oracle Financial 11.5.10, Oracle General Ledger, Oracle AP, Oracle I supplier Oracle I expense, Oracle Time and Labor, Oracle General Ledger and Procure to Pay, PL/SQL and UNIX.

Confidential,is a registered telecom service company helping network operators and manufactures engineer, deploy, integrate and maintain complex and converging networks.
The project is about implementation and enhancement project consisting of implementation and customization of existing process in different business areas.

• Worked on Implementation of PO Approval process and implementation of Invoice Approval Process.
• Setting up of Contractor into Oracle and integration of Contingent worker to HR, PO, I Expense and OTL module.
• Conducted meeting and workshop to explain the feasibility and scope in setting up of Contingent workers in Oracle.
• Worked on enhancement to existing Payable and General Ledger module.
• Identified the key business process areas along with the dependencies if any as suggested by the Business team.
• Created set up document for setting up of Contingent worker functionality in Oracle HR, Purchasing, Oracle Time labor and I Expense module.
• Created MD.20, MD.050 and Test Scripts document for a project life cycle.
• Reviewed the regression test results and updated the flow of business processes in all modules.
• Conducted workshop with business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
• Conducted workshop to explain end to end process to Business Analyst and super user groups.
• Working on for enhancement of I expense Approval Process.

Project Name : SUPER FUSION Project (R12 Upgrade from R12.0.5 to R12.1.2) – (May-2010 to Jul-2010)
Client : Confidential,Boise
Role : Onsite Lead/ Functional Consultant Payable (AP) and Receivable (AR)
Environment : R12.1.2, R12.0.5, Oracle Payable (AP), Oracle Receivable (AR)

Confidential,operations including Payable, Receivable and GL related to Customer and Vendor are being performed in Oracle R12.0.5 environment. And also it uses different legacy system like Mainframe, PeopleSoft and Lawson as a part of the retail management system. The purpose of SUPERFUSION project is to standardize the business process and improve the efficiency of Retail management system. Hence existing Oracle e-business suite will be upgraded from R12.0.5 to R12.1.2 and Retail Management system will be integrated to Oracle.

Responsibility:

• As a functional consultant, responsible for studying the business process.Prepared AS-IS understanding document for AP and AR modules.
• Assisted in business process reengineering, created TO-BE process document.
• Prepared functional design document and Test case document for custom enhancements.
• Assessed the current use of Oracle applications and the mapping of new features and functionality of R12.1.2 to the functionality required in the present company environment.
• Working on co ordination of integration of Oracle retail system to Oracle Financial.
• Design and testing of integration of Legacy Payable system with Oracle Payable with help of netting process.
• Working on sub ledger accounting process.
• Performing functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Understood existing interfaces and provided AS-IS a document.
• Prepare issue and risk tracker and submit to client weekly basis.
• Coordination with Oracle to apply patches as a part of Upgrade process.
• Coordinating and lead the entire phase of the project for Oracle Payable and Oracle Receivable which included initial of analysis, business process re-evaluation and solution design.
• Worked with technical team to resolve / provide technical issues.
• Writing / executing scripts using Toad to perform various extracts from database

Project Name : Process Customization I expense Project (Jan-10 to Apr-10)
Client : Confidential,San Diego
Role : Team Lead
Environment : I expense, AP, I expense integration with AMEX, Oracle Applications 11i, SQL*Loader, SQL, PL/SQLOracle 10g, TOAD, PL/SQL, UNIX, Shell Programming and Cron Job.

Confidential,is implementing additional security measure as a part of improving data security to i expense processes.
Custom Financial Processes relating to i expense integration with service provider AMEX is redesigned and restructured.

Responsibility:

• Worked on preparing documents as a part of business requirements, GAP and Fit-GAP analysis.
• Designing functional and technical design document for I expense project.
• Conducted workshops with Key members of Audit team provided transaction flow live demonstration
• Designing and developing custom interfaces, pre production testing, and related documentation and deliverables in I expense module.
• Developed custom scripts in UNIX and Shell programming using .ksh.
• Use of CRON tab functionality in testing of scheduling and executing Interfaces.
• Working on development and modification of custom interface program that integrates I expense data base to AMEX server.
• Worked in use of file encryption process using gpg keys and data encryption process with DBMS_CRYPTO package in Credit card and Credit Card transaction Interface.
• Working on integration of i expense with STU utility for AMEX.
• Development of Credit Card, Credit Card Transaction and Payment Interface to process transaction to Oracle Payable.
• Co-ordination with business and team for complete cycle testing for validation of expense transactions from AMEX to Payment of Transaction.

Project Name : Sony Foxconn Project (Sep-09 to Jan-10)
Client : Confidential,USA
Role : Team Lead Finance Team

Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Discoverer4i, Oracle Reports 6i and PVCS.

Confidential,is in the process of selling it’s LCD TV manufacturing unit in Tijuana to Foxconn, one of the biggest ODM manufacturers, based in Taiwan. In this business agreement, Foxconn will take over LCD TV manufacturing operations while also providing manufacturing service for other product categories like Car Audio, Home Audio & Branding audio. Foxconn will continue to use SEL systems for a limited period.So necessary modification has been done so to meet the requirement. As a part of this project, I am responsible for requirement analysis, design and development of custom interfaces and reports that is required for maintaining continuity in business operating in AP and AR track.

Responsibilities:

• Coordinating and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
• Identified the key business process areas along with the dependencies if any as suggested by the Business team.
• Reviewed the regression test results and updated the flow of business processes in all modules.
• Conducted workshop with business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
• Created MD.20, MD.050, and MD.060 document for a project life cycle.
• Designing functional and technical design document for custom interfaces, reports, pre production testing, and related documentation and deliverables in Payable and receivable module.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Involved in extensive coding using Oracle PL/SQL.
• Analyzing and creation of technical and functional analysis document of custom process.
• Worked on design, development and coding custom AR reclass program to facilitate in booking new sub ledger details to new accounting set up.
• Development of custom program for data extraction, transmission and loading from Oracle to external system.
• SQL Loader and UTL Packages are used for data loading in interfaces.
• Data Loader is used for uploading data from external system.
• Used Collections like variable arrays, nested tables extensively.
• PL/SQL was extensively utilized for coding and writing complex stored procedures and packages.

Project Name : 11i Upgrade Project (ITD operation) (Jan-09 to Sep-09)
Client : Confidential,USA
Role : Track Lead Finance Team

Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Form, Discoverer4i, Oracle Reports 6i, PVCS,HP-PPM Tool(Version control and Migration) and TRS.

Confidential,including Payable, Receivable, Sales, Inventory, Procurement, Accounting related to Customer and Vendor etc are being performed in Oracle 11.0.3 environment. VAIO has 2 departments to process above task RETAIL and DIRECT. RETAIL is dealing with all Retailers and Distributor and DIRECT is dealing with all end customers who is login to SonyStyle.com or visiting to Sony Stores. To Standardize and streamline VAIO supply chain and improve operational efficiencies, Oracle 11.0.3 require upgrade due to not being flexible; therefore as a part of consolidation all the functionally related to sales and marketing is moving to SAP and related to manufacturing moving to Oracle 11i.. This involves up gradation of all 1103 finance standard and custom objects that exists to migrate to 11.5.10 version. I am responsible for GAP analysis, creation of BPML document, functional requirement gathering, creation of set up and configuration document for financial module which ever applicable.

Responsibilities:

• Studied the Required business processes and suggested alternate ways to accomplish the same through Non-Customizations of Oracle Application in 11i. Business Processes which does not fall under the Standard features within Oracle were analyzed and required customizations were made in the Oracle system to accommodate the Business Process.
• Assessed the current use of Oracle applications and the mapping of new features and functionality of 11.5.10 to the functionality required in the present company environment.
• Gather the required process flow diagrams with knowledge transfer on extension of its functionality.
• Identified the key business process areas with the help of BSA team along with the dependencies if any as suggested by the Business team.
• Reviewed the regression test results and updated the flow of business processes in all modules.
• Conducted workshop with business team as a part of explaining the flexibility of oracle functionality and how it meets the business requirements.
• Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
• Created MD.20, MD.050, and MD.060 document for a project life cycle.
• Working on design and coding custom AR lock box interface program.
• Creation of Custom AP interface program for inter company affiliate reconciliation and settlement of AP invoices.
• AP Invoice Interface program for loading AP Invoices from different legacy systems
• Development and enhancement of Custom Cashless AR settlement process for new operating unit. This program is used for Sony affiliate vendors to balance their account in a cashless manner.
• Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
• Designed, developed and implemented validation (PL/SQL Code) strategy to check for record accuracy of the data residing in the interface tables before importing into oracle apps
• Involved in the Setting ups Transaction Types (Invoice Types), Auto Accounting Setups, Invoice Types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.
• Creation of unit test and unit test case documents for both standard and specific RICE components.
• Coordinate with business user for user testing.
• Design and program the solution as per Sarbanes Oxley (SOX) requirements

Project Name : Oracle Financial Solution Support – Project Team (Jul-08 to Jan-09)
Client : Confidential,USA

Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Form, Discoverer4i, Oracle Reports 6i, PVCS, HP-PPM Tool (Version control and Migration) and TRS.

This is a project for performing all enhancements and short duration development projects for Oracle Finance module. I am responsible for functional requirement gathering, technical design doc preparation, and development of technical components and testing of deliverables. I have worked on customization and enhancement of Oracle Payable, Oracle receivable, Oracle General Ledger, Oracle Purchasing and other financial module.

Responsibilities:

• Working on Oracle financial module (AP, AR, GL, FA, PO and CM).
• Responsible for gathering Business Requirements, creation of Technical Design Documents (MD.60), Unit Test Cases, Defect logs and user Documentation using AIM methodology for Payable, Receivable and Purchasing module.
• Worked on functional support of I Supplier and I Expense Module.
• Working on understanding and gathering of functional designs for customizations / extensions / inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Involved in Customization of Flex fields, Creation of Profiles and Alerts
• Involved extensively in customizations and Extensions of procure to pay cycle.
• Devising the standards check lists for the teams to use during development
• Worked on customization and enhancement for employee interface so to include employees from new operating unit.
• Created Unix Shell scripts, SQL scripts and SQL*loader scripts for the following:
• Automated extract to load the AP supplier banks and branches, to migrate data for banks and branches from legacy to Oracle Applications
• AP Invoice Interface program for loading AP Invoices from different legacy systems
• Development and enhancement of Custom Cashless AR settlement process for new operating unit. This program is used for Sony affiliate vendors for ITD to balance their account in a cashless manner.

Project Name : Oracle Finance Patch Upgrade (Jun-08 to Jul-08)
Client : Confidential,USA
Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, Oracle 9i/10g, TOAD, PL/SQL, Form , Discoverer4i, Oracle Reports 6i, PVCS,HP-PPM Tool(Version control and Migration) and TRS.

Oracle Finance Patch Upgrade is to bring R 11i instance at latest patch set level, recommended by Oracle, for financial modules like GL, AP, AR,PO,FA and PA.

Responsibilities:

• Gathering information about existing patch set level in Oracle finance and then working with Oracle to get latest patch available.
• Working on testing across functional and technical aspect of PO, AP, FA, PA, AR and GL module.
• Creation of impacted custom object list and then working on fixing or redesigning so as to get required result.

Project Name : Travel & Expense Payment process (Apr-08 to May-08)
Client : Confidential,USA
Role : Team Lead
Environment : Oracle iexpesne, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Form , Discoverer4i, Oracle Reports 6i, PVCS,HP-PPM Tool(Version control and Migration) and TRS.

This project has been designed to replace existing payment process for expenses incurred by employee. In the existing scenario payment has been created and check has been created by 3rd party tool.. But later on business has decided to pay all travel and expenses out of Hewitt Payroll system instead of internal check processing. SO this project has been developed to create required custom interfaces and reports so that this objective can be achieved.

Responsibilities:

• Working on AP and I expense module.
• Responsible for gathering Business Requirements, creation of Technical Design Documents (MD.60), Unit Test Cases, Defect logs and user Documentation using AIM methodology.
• Working on understanding and gathering of functional designs for customizations / extensions / inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Design and program the solution as per Sarbanes Oxley (SOX) requirements
• Worked on development of outbound interface that validates employees Travel related expenses and creates outbound feed that will be sent to Hewitt for payment to employee using PL/SQL ,Toad, SQL Loader, Unix, Shell script, UTL_File.
• Created technical design (MD.60) and development for reports that will reflect status of each invoice whether it has been extracted, sent to Hewitt and paid in Oracle system.
• Performed code modification and testing at user approval testing.

Project Name : Oracle Financial Solution Support (OFSS) (Nov-05 to Mar-08)
Client : Confidential,USA
Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Form , Discoverer4i, Oracle Reports 6i, PVCS,HP-PPM Tool(Version control and Migration) and TRS.

Confidential, is a financial support project which involves modification, enhancement and support of all standard and custom financial applications.

Responsibilities:

• Interaction with business user for requirement gathering for issue and enhancements regarding standard and custom solutions. Analysis of functional and technical issues involved in standard and custom financial applications.
• Responsible for gathering Business Requirements, creation of Technical Design Documents (MD.60), Unit Test Cases, Defect logs and user Documentation using AIM methodology for any enhancement for Standard and Custom application.
• Working on understanding and gathering of functional designs for customizations / extensions / inbound-outbound interfaces and preparing Functional Design Documents (MD50).
• Worked extensively on providing functional support for issues related to Month End Processes, GL reconciliation, Accrual Process, Period End Closing, MRC, Revaluation, Translation and Financial Statement Generator (FSG) process.
• Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per clients’ requirement.
• Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.
• Conducted business process review and gap analysis to determine business requirements.
• Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Defined payment terms, invoice approval codes and payables look-ups.
• Defined 1099 suppliers and testing the tax payment extractions for reporting purpose.
• Set up transaction types, invoices, guarantees, deposit and credit memos, debit memos.
• Worked with technical team to migrate suppliers, employees, bank information and open invoices data for AP.
• Participated in testing, user accepting testing in production and test instance.
• Experience and knowledge in set up of FSG,MRC, Revaluation, Translation and Consolidation process.
• Coordination with Oracle Support team in case of technical issues in standard financial solutions by logging TAR.
• Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
• Involved setting ups Expense Report Templates and creating expense reports.
• Exposure to setting up of Transaction Types (Invoice Types), Auto Accounting Setups, Auto lock box Auto invoice process, Grouping rule, Invoice Types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.
• Extracted AP Invoices from Legacy system, populated them into AP Interface tables through SQL*Loader script
• Developed UNIX shell scripts to move data flat file from 3rd party server.
• Designed, developed and implemented validation (PL/SQL Code) strategy to check for record accuracy of the data residing in the interface tables before importing into oracle apps.
• Exposure to setting up of Transaction Types (Invoice Types), Auto Accounting Setups, Auto lock box Auto invoice process, Grouping rule, Invoice Types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.

Project Name : Freight Billing System (Jun 2005 - Oct 2005)
Client : Confidential,USA
Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, Oracle 9i/10g, TOAD, PL/SQL, Form, Discoverer4i, Oracle Reports 6i, PVCS,HP-PPM Tool(Version control and Migration) and TRS.

The objective of this project is replace the existing billing process for SLA (Sony Logistics America)
that is labor intensive to maintain and results in significant gaps between estimated costs and actual billings to marketing companies. The technical solution will be deployed on an Oracle database and maintained by the Corporate Accounting group.

Responsibility:

• Defined Business requirements for creation of custom process.
• Worked on preparing documents required under the AIM methodology.
• Involved in finding effective solutions that involved both work around and customizations to the forms and reports.
• Worked on many interfaces that brings in freight logistic data into Oracle staging and then validates item detail, invoice information and other item related validation with Oracle.
• Development of custom form that will display item details with both estimate data (Invoices that is yet to be paid in future) and actual data (Invoice to be paid in a specific date).
• Custom form has been developed from Template form to maintain estimate and actual information For Logistic application.

Project : GDM MAP Enhancement Project (May -2005)
Client : Confidential,USA
Environment : Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TOAD, PL/SQL, PVCS,HP-PPM Tool(Version control and Migration) and TRS.
Responsibility: Working as team member. I was involved in program modification and testing with of AIMS interface program.

• Developed PL/SQL Interfaces to send information out of Oracle system, also created data loader scripts, both as SQL Loader and PL/SQL to receive the inbound interfaces.
• Worked on Shell scripting for mailing/FTP process.
• Worked on tuning process for making sure the interfaces takes less time to run, hence studied TKPROF generation process / Oracle Hints /Query writing techniques for better performance of the program.
• Defined the programs in the AOL group and created custom responsibilities for running these interfaces.
• Interface Reports were created later which provides insight to the data sent in the Interface for reconciliation process.

Project : AR Daily Sales Reporting :– (Oct-2004 to APR-2005)
Client : Confidential,USA
Environment: Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TOAD, PL/SQL, PVCS,HP-PPM Tool(Version control and Migration) and TRS

This project is to provide management with information representing the average number of days it takes to turn the receivables into cash. It is calculated by dividing receivables by daily sales. The results are presented to members of SEL’s and Sony Corporation’s management teams.

Responsibility:

• Worked on creation of GL set up form. It is required to have a one time set up for GL Cost center and Division with DSO set up.
• Created AR Invoice and Sales data inbound loader and validation program.
• Worked on development and of AR interface that calculates the DSO amount for AR transaction.
• Developed AR DSO set up form with which business can view DSO details.
• Worked on custom outbound interface that validates data with Oracle AR and then send it in a specified format to accounting group.

Project : Electronic Mailing Non Trade (Jan-2004 to Sep-2004)
Client : Confidential,USA
Environment: SQL,PL/SQL,Developer 2000 (Forms4.5, Reports2.5), Database Oracle8.0

The e-MINT project is a global initiative to implement a centralized system for Non-Trade Inter-Company transactions across all SEL affiliate companies. This process facilitates to eliminate the need for paper invoices for Non-Trade Transactions with affiliate companies and to automate the interfacing of Invoices, which are coded and approved by the business to Oracle Accounts Payable.

Responsibility:

• Developed custom interface and form relating to AP, AR and GL module.
• Development of AR outbound interface that will extract all AR invoice information from Oracle, create outbound feed file and then it will FTP to Common Staging Area.E-Mint inbound AP interface that will load invoice information to Oracle staging and then in turn to Oracle Payable.
• Worked on development of Non Trade Invoice Workbench custom form. This is used by each Business AP Users to find non- trade invoices, perform GL coding and approve them to be posted to Oracle AP
• I have worked on creation of program that will create automatic Accrual Journal entries (JE) for those invoices, which are not approved/coded or posted to Oracle AP system.

Project : ECubic Phase-I &II (Feb 2003 - Dec 2003)
Client : Confidential,USA
Environment: Oracle Applications 11i, SQL*Loader, SQL, PL/SQL, TCA, Oracle 9i/10g, TOAD, PL/SQL, Oracle Reports 6i, PVCS, HP-PPM Tool (Version control and Migration) and TRS
Role : Technical Consultant

This ECubic project is an initiative and centralized systems to perform the cashless settlement of inter company transactions between all Sony Affiliated companies including Sony Tokyo. This is also one of the major projects under the scope of One-Day Financial Close (ODFC) This is also one of the major projects under the scope of One-Day Financial Close (ODFC) and will benefit all the EMCS-A business units to settle their inter-company transactions efficiently

Responsibility:

• Development of custom interface to load inbound data for AP and AR in custom interface table.
• Development of interface to reconcile AP invoice details and then creation of outbound feed that has been sent to Tokyo.
• Created AP settlement interface and settlement report.
• Worked on custom interface to load AR invoice detail to Oracle and report that displays details about it.
• Developed AR settlement process and settlement report.
• Registered reports and stored procedures in Concurrent Manager that is part of Oracle Applications 11i.
• Created value sets in Oracle Applications 11i to support variable choices used in reporting
• Consolidated documentation on the project.
• Tested the integration of various components to make sure the system as a whole is working intact.

Education and Training Summary:

• Bachelor of Engineering (B.E) in Electronics and Telecommunications Engineering
• Completed Functional and Technical Training of Oracle Application Release R12.05,11i and 11.0.3.