Accounts Payable Oracle
Resume:
SITARAM NARAPARAJU
COLUMBIA, Maryland 21044
******@*****.***
Status : Citizen
Objective: To utilize my Oracle implementation experience, finance background, and interpersonal skills in a client service environment that includes software implementation and process optimization.
ERP: ORACLE FINANCIALS 11.5.10, 11.0.7, 10.7 MODULES: AR, AP, GL, Sys Admin, PSA, Federal Administration, iExpenses.
ANALYTICAL TOOLS: FINANCIAL ANALYZER WITH FINANCIAL EXPRESS STATEMENT GENERATION USING FSG
ROLE: TECHNO FUNCTIONAL
TOOLS USED: Forms 6i, Reports 6i, SQL, PLSQL, Rational ClearCase, Rational ClearQuest, Data Loader, QTP, AutoSys.
Work Experience
Configuration and Management at HIGHLAS(HOC) (From 10/2015 Till Today) Upgrade from 11.5.10 to R12.
HIGLAS is a Medicare Federal project where am working in configuration and Management team. The modules am working are AR/AP/GL/CM and SYS ADMIN. My role is to make setups in various instances and creating operating units as per client requirement. It includes setting up of books of account, responsibilities, creating operating Units using Inventory module, setting up request groups, Menus, Functions, values sets and setting up profile options. Used SQL for back-end verification. Worked on various instances including production and testing. Involved in problem solving and production support and worked on BR100 CR Documents, PMRs, Problem tickets like Management Now and Change Now tickets. Main resources in setting up Advance Scoring Engine from Collections module.
Oracle Functional Consultant – Implementation for 43 countries
Oracle Functional Consultant – New Implementation of R12:
09/2013 till 09/2015 Toshiba Global Finance, Research Triangle Park, NC for IBM.
Oracle Financials R12 Global Implementation for 44 countries:
Modules worked: Accounts Payable and iExpenses.
Created FDDs (Functional Design Documents for AP) and completed FUT (Functional Unit Testing). Worked on SIT A (Simulation Testing) and SIT B configuration documents as well as configurations for both AP and iExpenses. Closely involved with client testing of SIT A AND SIT B instances. It involves sitting beside the client and helping them in their Simulation test without ourselves touching the computers. Participated in client meetings and actively involved in gap analysis for RICE components. Actively involved in CRP2 and SIT (System Integration testing). Resolved all the parking lot issues.
Receivables: Worked closely with Receivables team whenever they needed any help. Created Transaction types, Receivable activities, Payment Methods and other setups. Helped the team in completing Invoice Printing and Open Receivables FUT testing.
General Ledger: Worked with GL team in completing SLA setups. Most of the setups are related to AP but need to complete in GL Sub-ledger accounting.
Cash Management: Helped CM team in configuring Bank and Bank accounts.
Oracle Functional Consultant - Conversion from SAP to Oracle Financials R12:
07/2013 till 09/2013 GM (General Motors) Fort Worth, Texas for IBM.
Oracle Financials R12 conversion from SAP:
Creating Functional mapping SAP system to Oracle Customization.
Documenting MD50 for Function Specification.
Interacting with Client and conducting meeting with business users to understand legacy process.
Documenting MD70 for Technical Specification.
Design test scripts of all sub-process identified in assessment phase.
Business process Mapping with all standard and customized modules.
Unit testing execution for each business process.
Analyze and test integration with 3rd Parties and legacy systems.
Participated in making recommendations for GL, AP, CM, and FA.
Defined setups and configured GL,AP,CM and FA modules with R12 new features.
Participated in Requirement gathering, design, documentation, setup and configuration.
Involved in Payment functions including Supplier and Supplier Site import Supplier banks defining, Payables, Cash, Bank operations.
Involved in configuration for Account Receivables, Payables, Banks and Cash Management.
Defined Customer profile classes, bank accounts, payment terms, distribution sets and Credit.
Prepared RD20 Requirement document, MD50 and BR 100 Functional setup document.
03/2013 till 07/2013 – IBM Client: UCMS (Unemployment Compensation Mechanization System:
2:47:40 PM
As a member of the QA team on the UCMS project, I gained extensive experience in test script execution and defect logging with the IBM Rational Testing tools. This included Rational Manual Tester, ClearCase, and ClearQuest. also managed to gain experience in automation testing with IBM Rational Functional Tester. In order to execute the test scripts. Learned how to effectively interpret use cases, business rules, and other business process specification documents. This requirement analysis was key, especially when interacting with business analysts to decide the outcome of a test execution. In addition to test script execution. Produced and ran queries using Oracle SQL Developer when it was necessary to analyze data from the back end of the application. With large development and test teams, strong communication, problem-solving, and organizational skills were a necessity. As he learned more about the application being delivered to the client, Mr. Kotob helped put together several training documents to help colleagues, as well as newcomers to the project, better understand how the product worked.
2:47:41 PM
10/2004 – 02/2013 IBM Client: HIGLAS(Medicare Project), Baltimore, MD
Joined IBM as permanent employee in 2007 April, 7th.
QA Analyst (Functional Tester):
06/2011 till 02/2013 covering functional testing of all Production fixes. Used tools like Autosys for running batches. Involved in running round trips for clients and fixing the problems as needed. Tested functionality of all modules. Helped other team members with understanding AR related functional issues. Used QTP to load data for test purposes. Involved in discussions relating to production fixes and offered suggestions. Helped other team members in achieving their goals in resolving issues. Involved in Regression testing and shake down testing.
Break Fix (Production support functional consultant)
07/2007 – 06/2011 Covering AR, Oracle Loans, Letters, Sys Admin, Fed Admin, PSA, Cash Management and AP modules. As a team member I fixed very complex and challenging problems. Most interesting being Bank re-name, Fixing consolidated TROR reports, different types of letters and loans related problems. Resolved various production issues. Main focus being Accounts Receivable module which includes Transactions, Receipts and Collections. Fixed problems with transactions, Receipts, Loans, Letters, AutoAdjustment program, CNC Program to track debts due for over 6 months period, Auto Lock box. Worked on Advance Collections by fixing the problems with Scoring Engine. Scoring engine helps in displaying status of Loans correctly. Also worked on DCIA Reports. Acted as SME for Letters and Loans modules. Created and implemented many PMRs and BR 100 CRs. Did initial test in test instances which are cloned from production. Being member of functional team am very familiar with all functionalities of oracle applications. Interacted with client on day to day basis on obtain requirements and discuss about fixes.
Configuration and Management (10/2004 Till 2007)
HIGLAS is a Medicare Federal project where am working in configuration and Management team. The modules am working are AR/AP/GL/CM and SYS ADMIN. My role is to make setups in various instances and creating operating units as per client requirement. It includes setting up of books of account, responsibilities, creating operating Units using Inventory module, setting up request groups, Menus, Functions, values sets and setting up profile options. Used SQL for back-end verification. Worked on various instances including production and testing. Involved in problem solving and production support and worked on BR100 CR Documents, PMRs, Problem tickets like Management Now and Change Now tickets. Main resources in setting up Advance Scoring Engine from Collections module.
Interface Developer
5/2004 - 10/2004 IBM Client: A & P, Montrail, NJ
A & P is a very big chain of stores with branches in different locations. The object of this project is A & P will get gift cards from various partners through a provider. Every week the sales figures will be imported into our temporary tables and commissions of A & P, Provider and Partners will be calculated basing on sales. An invoice will be generated for the sale value after deducting our commission. Invoice amount will be paid to the provider and commission will be accounted to our profit and loss account. Accounts Payable? Responsible for developing Gift Cards Data File Handler shell scripts to copy data file into $INTFWORK directory and archive in $CUSTOM_TOP/log directory and Gift Cards SQL*Loader Program to load data into the custom tables? Developed Custom Interface for calculation of Commission and arrive at the amount payable to the provider after deducting A & P commission from Sale value. This program will fill in additional information in the custom tables and will calculate commissions based on the setup. Developed Gift Cards Invoice custom Program which loads data into interface tables. All the validations will be done and data will be inserted into interface tables from staging tables. This program will create Payable invoices by distributing the liability charges to all the Divisions. ? Gift Cards Data Purge/Archive Program. Developed a custom program to purge the data from the custom table and archive in the history Table? Developed Gift Cards Weekly Accounting Report. This report will be used by A&P to reconcile with GL. Environment: ORACLE FINANCIALS 11i, Accounts Payable,, Report builder 6i, Oracle 8i,PL/ SQL, Stored Procedures, Shell Scripts, Windows 2000, SUN Solaris, UNIX.
Senior Techno/functional consultant
5/2001 - 12/2003 NCR Corporation, Dayton, OH
Accounts Receivable Defined Transaction Types, Customers, Payment Terms, Receipt Classes, Distribution Sets and Bank Related Information Defining Auto Accounting, Analyze, Design and Develop Accounts Receivables Interface for Autoinvoice. It also involved an Automated Interface in Shell Script registered and scheduled in Oracle Receivables. Analyze, Design and Develop Accounts Receivables Customization for Aging Report in SQL*PLUS script. This involved enhancement to standard Oracle Financial Packages to do Aging Report at a finer level. Worked on Customer Interface between Oracle Receivables and Data Warehousing by creating various Triggers, scripts, procedures and views on customer Transaction tables and also created triggers for transaction adjustment and Auto Adjustment. Analyze, Design and Develop Accounts Receivables Billing Interface with CLARIFY. This involved data mapping, developing Interface programs in PL/SQL, setting up integration with VERTEX tax engine for reporting taxes It also involved an Automation of this Interface from the creation of invoices in CLARIFY to the printing of Invoices in COGNOS. Analyze, Design and Develop Accounts Receivables Customer Interface with CLARIFY. This involved data mapping, developing two Interface programs in PL/SQL for outbound data and inbound data. Conducted both front end and back end test. Oracle General Ledger Installation of General Ledger module using Auto Install program. Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules setting of profile options at various levels. Creating foreign currencies and revaluation journals for Receivables and Payables Evaluation of organization structure, reporting needs, business needs to plan the chart of accounts as well as defining them. Defining set of books and assign it a calendar, functional currency and account structure and assigning the set of books to a responsibility. Defined dimensions and exclusively worked on Oracle Financial Analyzer with Oracle express server for online analysis and reporting. Used FSG for preparing tabular reports, TB and Balance Sheet. Responsible for Analysis, set-up and mapping of GL Developed Reports like Trial Balance & Conversion reports, Customized reports like JV listing, Account Analysis etc. using report builder6i and Discoverer. Accounts Payable: Analyze and Upgrade Accounts Payables Customizations for Automatic Electronic Fund Transfer (EFT) payment to Employees and Vendors (Customized 11 SQL*PLUS reports) from 10.7 character version to 11i.Analyze, Design and Develop Data-warehousing outbound interfaces from Oracle Payables and Oracle Receivables to the external system using PLSQL. Design and Develop Forms using Oracle Forms 6i and Reports using Oracle Reports 6i to inquire on the data files that are send periodically and to inquire on the data records that could not be sent because of data-mapping issues.
Senior consultant
9/2000 - 3/2001 eCredit.com, Dedham, MA
General Ledger Module Data migration (Accounts, Journals) from legacy system to oracle financials GL setup Modifying standard forms and reports Creation of new reports and forms Responsible for Analysis, set-up and mapping of GL Developed Forms for Accounting Period Calendar, Telephone directory, Exchange rate inquiry and Customized Personal detail screen in ORACLE PURCHASE as per AOL standards. Developed Reports like Trial Balance & Conversion reports, Customized reports like JV listing, Account Analysis etc. using FSG. Developing interface between Oracle financials and eCredit product GFN Accounts Payable Developed and maintained AP Sys Feed programs for check printing, which accepts data from feeder systems. Developed Vendor conversion program, which include formatting, validation, reporting and loading of vendors into AP module of Oracle Financials. Converted the prepayments into AP Invoice using custom PL/SQL package loaded into the AP Interface tables. Developed Shell scrip to run automatically. Scheduled in the concurrent Job. Developed an Auto Match form, which is a 3-Way match (Invoice-Receipt-PO). Responsible to develop AP Invoice form to accept the manual entry invoices. Imported all the Invoices and matched with PO. Requirement analysis and development for Conversion of data for 12000 customers, Addresses, Contacts, Bank and Payment modes from Oracle Applications 10.7 to Oracle Applications 11i using Customer Open Interface. Created a control file to load Customer information from flat file into temporary tables using SQL*Loader and I wrote customized programs to validates data column by column and inserted the proper data into the Oracle Applications interface table using PL/SQL. After porting the data into the Interface table in the Receivables module I executed the Customer Import to port the data from the Temporary table to the actual table
FIXED ASSETS: Created a form to enable user to enter Account mapping information. Design of a Temporary Table to load the data. Loaded Data from Flat file Provided by Feeder system into Temporary table Using PL/SQL and SQL * Loader. Developed Validation Programs Import the data through Standard General Import Program Created Unit Test plans, Unit test cases Prepared the User registration Documents
Environment: This system was developed using Oracle Applications11.X, ORACLE 7.3/8.X, SQL*Forms 5.0, & SQL*Report 3.0 (Developer 2000), XML, PL/SQL 2.0, & SQL menu 5.0 on HP 9000 & Windows NT
Senior Techno/functional consultant
1/2000 - 8/2000 Bell and Howell, CHICAGO, IL
Oracle General Ledger Installation of General Ledger module using Auto Install program and standard predefined data like basic responsibilities, menus, journal entry sources and categories Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules Setting of profile options at various levels, Creating foreign currencies and revaluation journals for Receivables and Payables Evaluation of organization structure, reporting needs, business needs to plan the chart of accounts as well as defining them Used FSG for Financial Statement Generation. Oracle Receivables Setting up Profile Options for Multiple Operating units for Multi Organizations Defining Transaction Types, Invoice Batch Sources, Customer Profiles, Customers, Payment Terms, Payment Methods, Tax Structures, Sales Tax Location Flex Field, Exemptions and Exceptions Defining Receipts Sources, Receipt Classes, Distribution Sets and Bank Related Information Accounts Payables Defining payment terms and quick codes Defining purchase order matching processes like 2/3/4 way and tolerance Defining tax names and withholding tax groups Defining invoice approval codes to apply and release holds from invoices Defining distribution sets Creation of templates to enter employee expense reports Defining employees, locations, banks and accounts
Implementation of GL, AR, AP Modules
1/1999 - 10/1999 Dr. Reddy's Labs, Hyderabad, India
Implementation of AP, AR AND GL 11.0 versions. Creation of set of books Defining of Flexfields Customization, segment validation used SQL * Loader, PL & SQL, SQL, forms 4.5, Reports 2,5 used FSG for statement Generation and Financial analyzer and Financial express for Financial Analyses. Defined customer, bank, payment terms, matching process, tax names and tax groups, distribution sets, employees, locations in AP. In AR setting up Profile options for Multi org, defining transaction types, Invoice Batch sources, defining Customer Profiles, Customers, Payment Terms, Payment Methods, Tax Structures, Sales Tax Location flex field, defining Receipt sources, distribution sets and Bank related information and also oracle cash management.
Education:
12/1994 International Education Foundation of India, Hyderabad, ANDHRA PRADESH
Certification
Affiliated to Newport University, Asian Chapter, California, USA
6/1992 Institute of Chartered Accountants, DELHI,INDIA, DELHI
Professional
Finished CA Inter which is equivalent to Semi-CPA here.
3/1986 VRS & YRN COLLEGE, CHIRALA, ANDHRA PRADESH
Bachelor's Degree
First class in B.com With Costing main and Accounts, statistics, management, management accounts as optional subjects
Skills
Data Ware Housing, Oracle Reports, Oracle Financial Analyzer, Oracle Financials, Oracle Forms, Work Flow, XML.
Completed R12 SLA Training from Oracle University, SFO.
Contact this candidate