Oracle Project
Resume:
Bonthu Reddy
******.*****@*****.***
Summary:
Oracle Financials Technical capable of providing effective ERP Solutions.
** + Years experience in software design, analysis, development and number of Oracle Apps implementation and Upgradations.
10 + Years of experience in Oracle Financials10.6, 10.7,11x (GL, AP, AR, FA, AOL,SA,PO)
Experienced in using SQL * Plus, PL/SQL, Oracle 8.X, 10g, Oracle Forms 6i, Reports 6i, workflow, ADI, Web ADI, SQL * Loader and Open Interface.
Enthusiastic team player with excellent analytical and communication skills.
Expertise in designing functional & technical specication document.
Expertise in developing MD-50, MD-70, BR-100 documents.
Proficient in performing FIT/ GAP analysis, designing reports, Interfaces, conversions and Extensions (RICE) objects.
Commendable experience in data conversions, interfaces, migrations, import and export using tools like SQL*Loader.
Demonstrated expertise with Application Upgrade and Security Administration
Excellent verbal and written communication skills. Work well under pressure. Meet ambitious deadlines. Works well in a team as well as by self.
Technical Skills Summary:
Languages / Tools: Forms 4.5, 6i, Reports 6i, Pro*C, SQL*Plus, PL/SQL, AOL (Application Object Library), C.
Databases: Oracle RDBMS7x, 8x, Sybase System 10, 4GL.
Hardware: IBM AIX on POWER Systems (64-bit),PCs, HCL- Magnum, HP9000, and E45/E55.
Networking/OS: Novell 3.x, 4.x NetWare, Microsoft NT 3.51/4.0, HP-UX 9.x/10.x, Windows for Workgroups, MS-DOS.
Applications: Expert in customization of Oracle Financials 10.5, 10.6, 10SC, 11i / R12 environments (GL,AP, AR, PO and HR).
Excellent technical analysis, design, development and testing skills.
Fruit Of The Loom Oct 2006 To Tilldate.
Techno Functional Oracle Apps Specialist.
Bowling Green, KY.
Oracle R12 Upgradation ( Oracle Apps 11.5.10.2 To Oracle Apps R12 ) :-
Played Key role in the Upgradation from Oracle Apps 11.5.10.2 to Oracle Apps 12.1.3 by gathering the requirements of R12 Pre-Upgrade, Post-Upgrade Phases .
Co-ordinated all the Upgrade Project Techo-Functionally.
Developed several MD0.50, MD0.70 Documents.
Re-created all the GL, AP, FA Responsibilities as per the R12 Changes from 11i.
Configured all the Printers and modified Landscape, Landwide and Portrait Styles as per the R12 changes.
Fixed number of Oracle Bugs by interacting with the Oracle Corporation directly.
Found Lot of patches from the Oracle and applied to make sure for correct Apps Oracle r12 functionality.
Modified and Tested all the Fruit Interfaces including JDEFTP, PDM, Postive Pay, Web Coop and GL Interace.
Trained all the FA, AP and GL Users for Oracle R12 functionality Changes.
Oracle EBS 11,0.3 to Oracle EBS 11.5.10.2 Upgradation :-
As Business System Specialist played very Important role by gathering the requirement from the Business Users in the Oracle upgradation from 11.0.3 to 11.5.10.2 .
Customized number of GL, AP, FA reports and custom programs as per the 11i changes like date format mask etc..
Modified custom programs as per the User Requirements.
Modified all the Five Major Interfaces as per the 11.5.10.2 Changes.
Solely Trained all the Users about the functionality changes of Apps 11i.
(GL, AP, FA, INV Oracle Applications 11.0.3)
Responsible for documenting GL, AP, FA and System Administration module setups in FTL and teaching to the team members.
Responsible for working on 11.0.3 Support Projects.
Customized and Implemented the Fixed Assets module Reports Asset Retirements Report, Cost Adjustments Report and Asset Addition Report.
Customized and Implemented Monthly Pre-close Report set which contains total of eleven standard and custom reports.
Customized and Implemented Monthly close Report Set which contains total of ten standard and customized reports.
Worked on Descriptive Flex field of Assets Work Bench to add the functionality to track the Original Tag Number with the CMMS number and Implemented successfully.
Gathered all 11i requirements to upgrade the systems from 11.0.3 to 11.5.10.2.
Gathered all 11i requirements to upgrade the systems from 11.5.10.2 to 12.1.3.
Trained the Business Users in Oracle Financials R12.1.3 Changes and New Functionality of GL, AP, FA modules .
Russell Corportaion Project :-
Actively involved in Russell Corporationn Acquisition by Fruit of the Loom.
Participated number of meetings at Alexander City, AL to understand their Main Frames Systems and mapping to Oracle Applications.
Responsible for loading 65000 plus Russell Corporation assets into Oracle Financials Fixed Assets module manually after Russell Corporation bought by Fruit of the Loom.
Vanity Fair Brands Project :-
Actively involved in Vanity Fair Intimates Acquisition by Fruit of the Loom.
Responsible as Team Leader for supporting General Ledger, Special Ledger Modules as part of SAP Finance Team.
Involved in number of meetings at Atlanta, GA with Vanity Fair Corporation Business Users, Team to learn about the System.
Participated in Cut over as well as in Vanity Fair Brands take over from Vanity Fair Corporation.
Involved in the project of Legacy applications Accounts Receivables, Cash Application, Credit Management, Invoicing migration from Raleigh, NC to Bowling Green, KY.
Sekhar Soft, Hyderabad, India May 2004 To July 2006
(GL, AP, AR, FA, PO Oracle Applications 11.5.9)
Senior Oracle Technical Leader.
Responsible for Providing ongoing support, enhancements, and customization of Oracle 11i Financials applications.
Responsible For working for different Oracle Apps 11i Implementation projects across the country including Aurobindo Pharma Ltd and Veljion Hydraulics Limited.
Worked with Financial Modules (GL, AP, AR, FA, and PO) Of Oracle Applications Implementation 11i For Makson International Limted.
Worked on Setups Of Multi Language, Multi Reporting Currency, and Multi Organization.
Maintained proactive interaction with the client to understand business practices to aid in system configuration.
Co ordinated and lead the entire phase of the project which included operations analysis, business process re-evaluation, conversions, customizations and documentation testing, training, implementation of modules.
Developed interfaces and data conversion programs for applications.
Addressed operational problems, concerns, and questions posed by users.
Team Leader for Group of 11.
Eagle Global Logistics (EGL), Houston, TX. Feb 2003 To May 2004.
Senior Oracle Applications Techno functional.
Involved in writing Functional Design Document ( MD 0.50) , Technical Design Document ( MD 0.70 ) of Auto Lockbox Interface to get transfer the data from B A I file which Eagle Global Logistics Gets Daily from Bank of America to Oracle Applications.
Development of Auto Lockbox Interface ( APIAR0003 ) , which includes submission, importing, validation, post quick cash, which loads the data from Bank of America in to Oracle using Event Handler.
Involved in the conversion of Accounts Payables Invoices for three sub processes which includes Invoices Cass, Geac, and Stealth.
Customized Human Resources Reports for Monthly Head Count Report.
Development and enhancement according to the Business Requirement of Purchase Order interface (APIPO0001).
Loading the data from legacy Systems to Oracle which Involves in Daily Feed from EAI of Loading for Advance Type Trade, Inter company, Airlines and Conversions.
Converted Number of Reports from Text to PDF According to the User requirements.
Conversion of Accounts Payable (CNVAP0001) & APIAP0003 for Loading Bi-Monthly Feed for Cass, Geac, Noncass, Debit, Stealth, Unbilled.
Worked with Different Change Code Requests (CCR).
Loading Conversion Data in Different Instances by using Open Receipts Interface ( CNVAR002 )
Loading Conversion Data in Different Instances by using Open Invoices Interface ( CNVAR001 )
Worked on Disbursement Revenue Adjustment to Adjust by using Adjustments API, The Amount after lockbox run.
Involved in getting files from Bank of America to sending Files to Cash Management Module and Maintaining Cash Management Interface.
Developed new form for PO Delumping according to the user requirement to enter Accrual Account code combinations.
Worked on Change Code Request for Automation of AB/OB Tolerances Write-off as part of Auto match Process.
Worked on Moving Data from one of Business Partner Select Carrier Group (SCG) to Oracle AR Module.
Worked On Bank Reconciliation Automation for Lockbox, Positive Pay Accounts (3 Accounts).
One of the Team Member of 25 Members Team to Implement of Oracle Applications 11i
Environment:
Sun Solaris, Oracle Applications (GL, AP, AR, PO, AOL, CE Oracle Applications 11i).
New York State Education Department, Albany, NY. Jul 2001 To Nov’2002.
Senior Oracle Applications Techno functional
Responsibilities:
Developed the Loader Scripts to load Pay SR Bi-weekly Transactions data into Oracle from People Soft.
Installed and Implemented Oracle Advanced Benefits Module.
Involved in data conversion from Legacy to Oracle HRMS by using Oracle Application Program Interfaces.
Involved in Creating Key Flex Fields for Jobs, Grades, Positions, Special Information Types.
Involved in Creating Descriptive Flex Fields for Assignments, Jobs, Grades and Positions.
Developed Interface Programs to Reconcile NYSED Employee Bi -Weekly Salary and Earning Amounts (Location Pay, over time Pay, Longevity, Pre-shift, Inconvenience Pay etc.)
Coming from PAYSR (Payroll System Replacement) Bi-weekly Master File data with Oracle HRMS Salary and Earning Amounts.
Developed custom Reports to produce the discrepancies for Employee mismatched Bi-weekly Salary, Earnings and Deduction Amounts, Running totals Of matched and mismatched records etc.
Involved in Legacy Systems to Oracle HRMS Data Mapping, Preparing Solution, Functional and Technical documents and Test Scripts.
Extensively used to Workflow to build and launch the business processes.
Developed Custom Forms to view the NYSED (New York State Education Department) Employees Salary History, Personnel, and Position History.
One of the team members of five, responsible for implementation of HRMS Module.
Environment:
Sun Solaris, Oracle Applications (HR, AOL Workflow Oracle Applications 11i).
Delloitte & Touche Consulting (CGI Information Systems) Nov1999 To Jul2001.
E-HRMS Consultant.
Developed and helped GL, AP, AR, FA Financials Module Migrations and Forms customizations for Travelocity, Dallas.
Strategically designed IT solutions to accommodate internal and external business and reporting needs for CGI ERP Projects.
Involved in systems analysis phase of Oracle Conversion project of Travelocity.
Developed business requirements analysis for Oracle Financial modules (GL, AP, AR, and FA) setup, conversion and installation successfully.
Designed account research methodology and variance analysis using Oracle Payables and FSG.
Designed and developed financial reports in General Ledger Module Using Financial Statement Generator (FSG).
Designed financial models for estimating costs for large-scale systems integration projects.
Involved in Estimations and costs for different Projects for the Company to quote the clients.
Environment: Oracle Applications (GL, AR, HR, PO, OM, AOL Oracle Applications 10 Sc)
Oracle Corporation Nov1998 To Nov 1999.
Senior Consultant
Alabama State Docks / Application Customization Consultant
Customized the stevedore split billing process interface code between a legacy Unisys system and the Oracle Accounts Receivable application.
Designed functional requirements, technical design requirements, and process documents following Application Implementation Methodology (AIM).
Development Of customized Human Resources Alabama State Docks Form (ASDCALEN) form using Oracle Application Object Library (AOL).
Environment: Sun Solaris, Oracle Applications (GL, AR, HR, AOL, and Oracle Applications 10 sc.).
Catalink Direct Inc. (Elcom Services Group), USA Jun 1998 To Nov 1998.
Customization Consultant
Analyzed and created customized integration programs between legacy system and Oracle Financials for implementation of Globallink2000 project.
Integration of legacy sales order system and Oracle Purchasing Module.
Analyzed Ingram Process Change program As a part of static update evaluation process involving Order Entry, Purchasing, Inventory applications, Catalink customized tables, forms and reports, catalog parts distribution system ( CPDS ), catalog parts management system ( CPMS ), personnel electronic catalog ordering system ( PECOS ).
Environment: Sun Solaris, Oracle Applications (GL, INV, AR, OM, PO, AOL, Oracle Applications 10 sc.).
Dupont Photo Masks Inc, USA Oct 1997 To Jun 1998.
Information Systems Analyst
Analyzed, designed, and developed performance measurement reports for Inventory, Receivables, and sales and shipments.
Configured Fixed Assets application for new system requirements.
Developed user interface between legacy systems of foreign (Germany) and domestic divisions and Fixed Assets module.
Environment:
Sun Solaris, Oracle Applications (GL, INV, AR, FA, AOL, and Oracle Applications 10 sc.).
Optima Software Services Limited Dec 1995 To Sept 1997.
Software Engineer
Developed specific Application Program Interfaces (PL/SQL packages) for Oracle * Applications to third party product integrations, one of which was MetrixIndus Group.
Developed and tested outbound interfaces, wrote validation functions for data consistency and errors and involved in writing process functions for data from interface tables to applications.
Wrote SQL * Loader scripts to convert data to and from Oracle applications.
Documented all APIs, packages, procedures, functions, triggers, views, and prepared consolidated API Doc, irrespective of integration.
Facilitated alliance partners choices of options from existing library of APIs for integrating their product with Oracle Applications.
Completed documentation and integration software for Trilogy, Hyperion Pillar, TSW (old & new versions), TRW, Manugistics, Sherp_pdm, Alpha & Omega Doms, Project Software & Development Inc. (PSDI).
Wrote Regression Tests for Oracle Applications to third party integration software to automate process of certification of integration software against different application releases and on different platforms using RT feature of Application Object Library (AOL)
Wrote driver routines for each API object, prepared test cases, designed regressions tests, and wrote installation script for RT Installation.
Converted existing APIs of an integration into generic views whenever possible.
Wrote Generic Views for Oracle Financial Modules irrespective of integration partner.
Created views according to specifications, which are mapped to HR tables of Oracle applications.
Oracle Applications 10.5, 10.6, 10.7.
S.S. Intl Ltd. (New Delhi), India. Mar 1995 To Nov 1995.
System Designer
Designed and implemented a patient administration system as a project team member for a national health service.
Designed open architecture for the system with an Oracle Forms 4.5 front end and Oracle backend.
Involved in analysis, design, development, and testing of the Oracle server.
Wrote several batch and server programs.
Contact this candidate