Oracle Application Consultant
Resume:
Ramesh Mandava
*****.*******@*****.***
Summary
Have 11.2 years of experience in Application Software Development in Oracle Applications and Oracle Client/Server systems.
• Experience in Implementation, Customizations/Upgrade of Oracle Applications versions R12/10.7/11i/ 11.0.3/11.5.7/11.5.9/11.5.10 and J2EE.
• Extensive experience in Distribution modules (OM, PO and Shipping) and Manufacturing Modules like BOM, WIP and Inventory.
• Experience in Oracle Applications Implementation/Upgrade and also experience in using Multi Currency & Multi Organizations in Oracle Applications.
• Extensive experience with Data Conversions in Oracle Applications.
• Expert in development of Forms, Reports, Alerts, Data Conversions, Interfaces and Discoverer reports development facilitating the implementation of Oracle Financials and Manufacturing modules.
• Familiar about cross-module applications.
• Experience in software version control system PVCS and Data Flow and ER Diagrams using Visio.
• Experience in documentation using AI Methodology (Ex: CV40, MD70, MD50, MD120)
• Proficient in the use of AOL and System Administration features.
• Experienced in the following programming languages/tools/utilities like PL/SQL, Forms 6i, Reports 6i, Discoverer, Forms Personalization, XML/BI Publisher, SQL* Plus, Sql loader, TOAD.
• Proficient in Application performance tuning and Query optimization.
• Experience of database architecting, process flow diagram, Data flow diagram, ER diagrams.
• Strengths include excellent Programming/Trouble shooting skills, communication skills and interpersonal skills.
Technical Skills
ERP Applications Oracle Applications 11i/11.0.3/11.5.7/11.5.9
Manufacturing and Distribution Modules INV, OM, PO, WIP, BOM
Databases Oracle 10g/9i/8i/8.0/7.x, MS Access
Operating Systems SunSolaris2.6/2.8, HP-Unix, Linux,
Windows 2000/NT
Languages / Web Technologies JDeveloper11g, Forms 6i/9i/10g, Reports 6i/9i/10g, C, PL/SQL, Java, HTML and Crystal Reports
Tools / Utilities Discoverer, Workflow Builder, Toad, SQL Plus, SQL Loader, Visio, ADI and XML Publisher
Professional Experience
National Oilwell Varco , Houston, TX Mar’ 2009 – till date
Role: Technical Analyst
Description:
National Oilwell Varco is a worldwide leader in the design, manufacture and sale of comprehensive systems and components used in oil and gas drilling and production, the provision of oilfield tubular inspection, internal tubular coatings and other services, as well as in providing supply chain integration services to the upstream oil and gas industry.
Development in Distribution and Manufacturing Modules (R12).
• Delivered documentation for all objects based on AIMS Methodology and NOV Documentation standards.
• Gathered requirements from functional team/core users to design and develop the required objects.
• Developed Customization Standards as required by NOV Technical Manager and Functional Team Manager.
• Design and development of conversions in PO, OM, BOM, WIP, Inventory.
• Developed Forms and Reports in PO, OM, INV, WIP modules.
• Developed several customer facing reports using XML Publisher.
• Developed Procedures, Functions and Packages to create validations for conversions.
• Worked on Design, Development and Testing as part of the development.
UTSTARCOM, Inc., SFO, CA Mar’ 2007 – Feb’ 2009
Role: Technical Analyst
Description:
UTStarcom is a global leader in the manufacture, integration and support of IP-based, end-to-end networking and telecommunications solutions. The company sells converged broadband wireless and wireline products, an integrated IPTV solution, and a comprehensive line of handset and customer premise equipment to operators in both emerging and established telecommunications markets worldwide.
Development in Manufacturing and Distribution Modules (R12)
• Responsible for design and development of RICE objects in Inv, OM, WIP and BOM.
• Designed, Developed and Documented PCD Interface which creates Material Transactions in oracle from JD Edwards Data.
• Responsible for Functional and Technical Specs in order to design and develop Interfaces and conversions in Inventory (Inv. Items export), OM (Orders, Shipments).
• Developed Items, Categories conversion in Inventory module and assigned Items to Child Organizations.
• Prepared and executed unit test strategies and scenarios.
• Responsible for Development and administration Discoverer interface for Inventory, WIP and OM.
• Prepared custom functions to extend Discoverer functionality as required and created Custom Business Areas, Items classes and scheduling work books, Exporting and Importing of EUL, Business Areas, Folders, work books.
• Managed Oracle TARS on issues related to interfaces.
• Developed Forms and Reports to develop custom application and integrated with Apps.
• Developed reports using Oracle Reports 10g and XML publisher.
Barnes & Noble, Inc., NY Apr’ 2005 – Feb’ 2007
Role: Technical Analyst
Description:
Barnes & Noble.com is a wholly owned subsidiary of Barnes & Noble, Inc., a publicly traded company listed on the NYSE under the symbol "BKS." Barnes & Noble.com leverage the power of the Barnes & Noble brand to offer online customers the Web’s premier destination for books, music, DVD, video games, and related products and services. Taking advantage of vast warehouses across the United States, we stock over 1 million titles for immediate delivery -- that's more titles than any other online bookseller does.
Development/Support in Finance Modules.
• Responsible for delivery of required documentation using AIM’s Methodology.
• Responsible for support and enhancements in Oracle Application Financial Modules.
• Responsible for the design of the custom module to maintain Merchant Vendors of Barnes & Noble, Inc.
• Responsible for all the Inbound and Outbound data conversions for Merchant Vendors Module and Financial Modules like GL, AP, AR and FA.
• Responsible for Design, Development and testing of AR Interfaces (Transactions and Receipts) thru Validation Scripts and standard oracle Concurrent programs.
• Developed FSG Reports and have familiarity with ADI.
• Deployment of FSG Reports and XML Reports thru XML Publisher.
• Responsible for development of Validations, Uploading Scripts and Extracts from Applications to other Barnes & Noble, Inc. Systems. The extracts were pipe delimited files, Comma Delimited files and tab delimited files, which were exported to a comn/temp directory every day by scheduling a Concurrent Program Set developed by using UTL_FILE Package.
• Developed Shell Script by using CONCSUB, uuencode and mailx to send concurrent output as mail.
• Responsible for the Form modifications using Forms Personalization.
• Responsible for development of Custom Forms for the Merchant Vendor Module like Merchant Vendor Master, Merchant Vendor Sites, Merchant Vendor Discounts Screen and Merchant Vendors EDI Data Screen.
• Tested the objects using tools and also manual Testing.
• Developed Discoverer Reports in AP, AR and FA.
• Responsible for deployment of Custom Reports and Forms in GL, AP, AR and FA.
Power-One Inc., Camarillo, CA Mar’ 2003 – Feb’ 2005
Role: Technical Analyst
Description:
Power-One Inc. is a leading Manufacturing Company in US and several locations in worldwide. Power-One Inc. is leader in system level power solutions in the global telecom, networking, and technology markets utilizing intellectual property to deliver comprehensive and cost effective solutions.
Developed Customizations in PO, OM, BOM and Inventory.
• Developed custom module for data comparison between Contract Manufacturers and POWER-ONE.
• Responsible for Preparation of Technical specifications.
• Responsible for Monitoring and coordinating Development activities.
• Code walkthrough.
• Creating test scenarios and test scripts, performing end-to-end testing and transport to production environment in coordination with Application Support team.
• Developed Custom BOM Explosion process and comparison between contract manufacturer’s data.
• Developed Query find Form Objects in PO and OM.
• Developed reports required for analyzing the Quantities in OM and PO.
• Responsible for delivery required documentation using AIM’s Methodology
MRF Limited Jan’ 2001 – Feb’ 2003
Role: Technical Analyst/Team Lead
Description
MRF TYRES is your ultimate destination to experience the ethos, image and brand identity of a company that manufactures the largest range of tyres in India and exports to over 65 countries world-wide.
Full Life cycle Implementation.
• Responsible for Designing and implementing the customized forms and reports
• Uploaded journal data using SQL*Loader to migrate the data from the XL files and populated to table GL_INTERFACE. Executed Journal Import program from GL menu.
• Developed Forms for business processes not supported by Oracle Product. Ex: Customer Norms, Tyre Adjustment Compliant Docket System, Handling new defective Tyres in Order Management.
• Developed and customized reports for Oracle Receivables and Stock ledger Details
• Developed Forms for Purchasing Module (Import Details form And Debonding Details form)
• Developed new Module for handling Worksheet Details
• Developed report objects in pre-printed format for TAC and MRF Check (Oracle Payables)
• Used Discoverer to generate reports in Financial Modules.
• Trained users in order to familiarize with the reports and Discoverer in order to print reports as required.
HRware Information Systems Sep’ 1997 – Dec’ 2000
Projects
Developed custom business applications using Developer 2000/6I, Oracle 7.3/8 and developed crystal reports in VB.
Education
B.S in Computer Science.
Post Graduate Diploma In Computer Applications.
Training
Oracle Data-warehousing
Oracle Financial Modules
Training Imparted
AOL & System Administration
Developing Standards in Oracle Applications
Oracle Forms 6i and Reports 6i
SQL Loader and Interface Concepts
Discoverer
Contact this candidate