Oracle Project
Resume:
VIJAYENDRA CHINTHAKINDI
**.**********@*****.***
Oracle Apps Techno functional Consultant
Experience Summary
* ***** ** ********** ** various roles/levels of software development, design, Support, Technology Consulting,
•
Training, Customer Support and leading a team with excellent customer reviews and growth in Oracle Apps
Technical.
Extensively worked on Oracle Apps Inventory, Routing, BOM, WIP, Shop Floor, Demantra Forecasting
•
and ASCP Planning.
Excellent working experience on Oracle Apps Order Management, Install Base, Service Contract
•
iProcurement, iSupplier and Purchasing (11i/R12).
Very good experience in trouble shooting the day to day problems while upgrading to R12.
•
Worked month end activities like clearing the error records from the interfaces and transferring all the modules
•
data to GL, import, post and open/close of the business periods.
Involved in all stages of development with strong implementation skills spanning Full life cycle in
•
implementation of Demantra.
Extensively worked on NPI concept, Chaining and modifying and creating Demantra Worksheet.
•
Extensively worked on Demantra Demand Management..
•
My technological forte is Oracle PL/SQL, Oracle Forms and Reports, Discoverer Reports, XML Publisher,
•
Sql loader, util files, Oracle Alerts, Interfaces, and Logical Apps, Demantra and knowledge on workflows.
Developed util file with Excel output which has coloring and bordering using xml with pl/sql. Received best
•
custom report award from custom.
Developed Barcode Report using XML Publisher.
•
Developed Custom form to integrate Inventory with Shop Floor.
•
Thorough knowledge in e Business Suite, Oracle Apps Architecture, Directory Structure, Schema structure in
•
Oracle Apps, Multi Org, Menus and Functions, Key Flexfield, Descriptive Flexfield, Profiles, Value Sets,
Concurrent Processing, Inbound Interface, Outbound Interface and FND_CONCURRENT package.
Excellent working experience on Data Conversion for Oracle Apps 11i/R12 using standard API’s or open
•
interface programs to Interface Data into Oracle Applications.
Experienced in analyzing index, quality assurance, Performance Tuning of Oracle SQL and PL/SQL
•
applications using TKPROF Explain Plan, SQL HINTS
Developed Custom Forms and worked on form Personalization and custom.pll.
•
Understanding on OAF architecture and customizations of iProc and iSupplier.
•
Good Exposure to OAF Personalization and extending View Objects and Entity Objects.
•
Excellent analytical and debugging skills – Specialized in writing complex and Efficient Algorithms.
•
Excellent Team Management Skills Played key role in training a team of 4 Members on Oracle Apps
•
manufacturing and planning and leading them for more than a year.
EDUCATION:
Bachelors of Technology in Computer Science and Information Technology from JNT University.
•
Technical Skills:
Operating systems : LINUX, HP UX and Win NT/2000/2003/XP.
Languages : C, Pl/Sql
Databases : Oracle 10g/11g.
ERP : Oracle applications 11i (INV, BOM, WIP, Planning, PO, OM, Shipping, Packing,
Quality, Interface (Inbound/Outbound), Conversions, Oracle Reports, XML Publisher, Discoverer, UTIL
Files).
Front End Development Tools: Forms 6i, Reports 6i, Discoverer, and XML Publisher
Tools : SQL* Loader, Toad, Pl/Sql Developer
Automated Testing Tools : Win Runner, Test director
PROFESSIONAL EXPERIENCE
CLIENT: Centurylink, Denver, CO
Oct 2012 Till Date
Oracle Apps Technical Consultant
PROJECT: Oracle R12 Upgrade (General Ledger, AR, AP, and Supply chain (PO, OM, INV))
Description:
This Project is about Upgrading from 11.5.10 to R12 and developing the projects, enhancements to fill the gap
between application and business. Worked on identifying the obsolete objects in R12 and fixing them. Involved in
requirement gathering and set ups in financial modules. Developed an custom process of auto create PR's for
Expiring PO's. Customized and personalized OAF pages in iSupplier and iPorc. Developed the AP Invoice interface
to integrate with the legacy systems. Working experience in month end closing process, transferring data to GL.
Responsibilities:
Developed customized reports to compare the legacy and oracle application database.
•
Developed a custom flow to auto create the PR’s for the Expiring Maintenance items.
•
Worked on PR and PO API’s.
•
Defined value sets, menus, concurrent programs, report sets, registering custom build forms, reports and
•
PL/SQL Procedures, Triggers and Packages and creating executables using Application Object Library
(AOL) in the development environment
Worked on Form Personalization and custom pll.
•
Worked on shell script to upgrade from FTP to SFTP and FTPS.
•
Designed and Developed RDF and XML Publisher reports
•
Designed and Developed Discoverer Reports
•
Designed and Developed the Inbound and Outbound Interfaces.
•
Good understanding on OAF architecture.
•
Worked on Migrating the OAF personalization from one instance to other instances.
•
Designed and developed Extending of Controller, View Object.
•
Worked on Profile options of OAF.
•
Modify the standard OAF page as per the business requirement.
•
Developed the Oracle Alerts to satisfy the business requirements.
•
Worked on Logical Apps Rules.
•
Worked on UTLFILES
•
Created AOL objects as per the project requirements
•
Prepared Technical specification documents, Unit test script documents
•
Performed code migration in various testing and development environments.
•
Experienced in Custom migration tool CPEBUILD.
•
Worked on R12 Implementation Project.
•
Environment: Oracle applications 11i/R12 (PO, INV, BOM, WIP), Interface (Inbound/Outbound), Oracle 11g,
Reports 6i, JDeveloper.
CLIENT: Qualcomm, San Diego, CA
Sep 2009 to Oct 2012
Oracle Apps Technical Consultant
PROJECT: Oracle 11i and R12 (INV, BOM, WIP, Planning, Forecasting, Demantra, General Ledger, AR, and AP)
Description:
This project in about upgrading from 11i to R12 and developed many projects and implemented Carousel System,
and Demantra.
WIP MASS MOVE Project: Developed custom process called WIP MASS MOVE to fill the gap between oracle
system and Business and received best customization award from Oracle for the same.
Carosel Project: Involved in Integrating Carousel system with Oracle ERP. Creating Inbound/Outbound interfaces.
Demantra Integration: Involved in Demantra Integration with Oracle system. Developed Custom Collections from
oracle side, NPI Form, Feeding the Demantra output to ASCP for planning, Monitoring Weekly and monthly plans.
Supporting the performance issues in Demantra.
Handheld Scanner Project: Handheld scanner for material transactions: It is an integration with Web services to
perform multiple transactions at a time by scanning the Item and Transaction details through Handheld scanner.
Label Printing Project: Printing the Labels from an Oracle Form: Printing the labels straight out from Oracle form
using UNIX command to hit the printer.
Developed inbound and outbound interfaces to/from oracle system.
R12 Upgrade: Used panaya tool to identify the affected objects from 11i to R12. Performed code retrofit of affected
objects. Analyzing and suggesting the solutions to business to fill the gap between R12 features and business
process.
Responsibilities:
Developed customized reports to compare the legacy and oracle application database.
•
Designed and Developed RDF and XML Publisher reports
•
Designed and Developed Discoverer Reports
•
Designed and Developed the Inbound and Outbound Interfaces
•
Designed and developed Oracle Forms
•
Worked on SQL*Loader
•
Developed complex reports during Demantra Implementation.
•
Worked on outbound interfaces on the pricing for Demantra.
•
Developed Extensions and customization's in Oracle apps to integrate with Demantra.
•
Worked on Collections and key customer forms for Demantra.
•
Worked on Collaborator workbench and worksheets, formatting worksheets and concepts of Chaining and
•
shaping.
Worked on Inventory APIs
•
Developed the Oracle Alerts to satisfy the business requirements.
•
Worked on creating/modifying Logical Apps rules as per project requirements
•
SQL queries performance tuning to improve the run time results.
•
Created AOL objects as per the project requirements
•
Prepared Technical specification documents, Unit test script documents.
•
Preparing user acceptance test cases covering the requirements.
•
Written PL/SQL stored procedures for back end business logic and reports processing.
•
Developed Interface Scripts.
•
Development of UTLFILES.
•
Creation of Menus, functions and Concurrent programs.
•
Development and enhancement of Reports.
•
Documentation of Technical Specs, Technical design.
•
Experienced in PVCS and object migration using Kintana.
•
Used FNDLOAD for migrating the components from Development instance to various instances (DEV,
•
TEST, and Production).
Worked on R12 Implementation Project.
•
Environment: Oracle applications 11i/R12 (PO, INV, OM, MFG, Shipping, Packing, Shop floor management,
Quality, BOM, WIP), Interface (Inbound/Outbound), Forms 6i, Reports 6i.
CLIENT: Motorola, Hyderabad, India
July 2008 to Aug 2009
Oracle Apps Technical Consultant
Project: Oracle ERP Enhancement Project (SCM Modules)
Description: The project is maintenance and enhancement to existing Oracle ERP system. Analyzing the
business and proposing the solutions.
Responsibilities:
Developed customized reports to compare the legacy and oracle application database.
•
Developed MD60 and MD70 documents for custom Interfaces and developed interface to synchronize
•
Legacy (MES) system and Oracle.
Created concurrent programs for pl/sql procedures.
•
Defined the concurrent programs for the SQL Loader programs.
•
Develop & Support XML Reports.
•
Translated Report, Form, Conc. Programs to German Language Using Translation Builder.
•
Worked on AOL objects.
•
Worked on Interfaces and conversion.
•
Involved in internal review of Code and documentation.
•
Also involved in the development & Performance tuning.
•
Perform unit testing, user training & got the final acceptance for all the technical objects from the users.
•
Preparing the migration Documents.
•
Interacting with QA team to develop Test Strategy, Test Plan and Test scripts and documentation.
•
Developing new PL/SQL packages, stored procedures, functions, cursors and views etc.
•
Customized the existing programs as per the requirements.
•
Analyzing the Requirements and Preparing the High level and Low level design documents.
•
Resolving bugs reported by users and Post implementation support.
•
Environment: Oracle applications 11i/R12 (PO, INV, OM, MFG, Shipping, Packing, Shop floor management,
Quality, BOM, WIP), Interface (Inbound/Outbound), Forms 6i, Reports 6i.
Contact this candidate