CHANDRAKANTH K
Email: kk.chandra1503@gmail.com
Mobile: +91 9948699145
Objective
Seeking a career in Oracle Applications / Oracle Application Technical consultant would enable me to utilize my experience, educational and creative skills to provide elegant software solutions and also to explore avenues for higher learning.
Summary
?7.5 Years of strong experience in Oracle Applications R12 (12.1.3), Oracle Fusion SCM Cloud and 11i (11.5.10), SQL, PL/SQL, Oracle 10g/9i.
?Expertise in Developing, Customizing and Implementation of Oracle Manufacturing and Distribution: Order Management (OM), Inventory (INV), WIP, BOM, Accounts Payable (AP), Application Object Library (AOL) and Oracle System Administrator.
?create shipment, Deploy the reports under the custom folder in BI publisher, Setup Ship From Contact Name and Phone number for the Ship From Location, Create Freight Cost Types and Setup for Carriers in Oracle SCM Cloud instance
?Working on Functional setups (Customer Creation, Organization, Locations, Profile and Printer and Intercompany).
?Worked as an EDI support and development.
?Responsible in Sending and Receiving the correct information in customer specified format for inbound and outbound transactions.
?Responsible in Setting up Customer, trading partner, creating addresses, creating price lists, etc.
?We provide support and resolve issues pertaining to order-to-cash cycle. (OM/INV/AR).
?Working on both Implementation and Production Support and customizing Oracle Reports and Templates as per the Client's need.
?Many Open Order Reports developed for different sales persons and different customers with XML Publisher tool.
?Good understanding of both user and development needs.
?Expertise in Oracle databases (10g/9i), SQL and PL/SQL.
?Strong Programming Experience in writing Packages, Procedures, Functions and Triggers.
?Experience in XML Publisher Reports and Extensive Programming experience in Reports 10g/6i and Forms 10g/6i.
?Experience in forms development, forms customization and form personalization in Forms 10g/6i.
?Expertise in developing Data Conversions, Inbound/Outbound Interface from External System into Oracle Distribution and Manufacturing using SQL*Loader, UTL_FILE, PL/SQL.
?Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all Interfaces.
?Experience in registration of concurrent programs, creation of Users, responsibilities, forms, functions, menu, values sets, request sets, request-groups in Oracle Applications.
?Knowledge on ADF.
?Developed Technical documents for the customizations done on reports.
?Ability to learn and adapt to new technologies, good team player in dynamic work group environments.
?Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
?Excellent communication and interpersonal skills.
Skill Set
Core Expertise Oracle ERP (R12, Oracle Fusion SCM Cloud and 11i) (Order Management, Oracle Payables, Oracle Inventory, BOM, WIP, Application Object Library and System Administrator).
RDBMS Oracle 10g/9i/ 8i
Languages SQL, PL/SQL, C, C++, UNIX-Shell Scripts
Report Generating tools Developer2000 (Reports 10g/6i and Forms 10g/6i)
Tools & Utilities TOAD, SQL Developer, SQL* LOADER, UTL_FILE, Data Loader, Oracle Form Builder, Report Builder, XML Publisher and OAF.
Operating Systems UNIX (Sun & HP), Linux, Windows *
Profile
Total Experience 7.5 Years
Professional Experience Currently working as Oracle Applications consultant at Apps Associates Hyderabad since Jan 2016 to Till Date.
Worked as Oracle Applications consultant at CES Limited Hyderabad since July 2011 to Jan 2016.
Worked as Oracle Applications consultant at BirlaSoft Hyderabad since Nov 2010 to June 2011.
Worked as Oracle Applications consultant at IBM Hyderabad from Nov 2009 to Nov 2010.
Educational Background MSc (Information Systems) from Osmania University-Hyderabad.
BCA (Bachelor of Computer Applications) from Osmania University - Hyderabad.
Professional Experience
Project: Ship Console (Product) and Toops
Company: Apps Associates
Project: Ship Console (Product)
Role: Sr. Technical Consultant Duration: Jan’16 - Till Date
Ship Console (Product): The product is supposed to address the needs of a person who is at the warehouse in-charge of shipping deliveries. In a typical scenario the person at the warehouse would get the delivery from Oracle, print the label and then go back to the Oracle ERP and ship confirm the delivery. This is where Ship Console comes in. Now, the user at the warehouse could get to everything using this one product in the same screen, which simplifies the task.
Ship Console is tightly integrated with the Oracle ERP. The Order is initiated in Oracle, the order is pick-released in oracle, which means, and the order is ready to be shipped. User can pull delivery details in ShipConsole and ship to destination address with any carrier like FedEx, UPS, DHL.
Toops: Topps company The Topps Company, Inc., manufactures chewing gum, candy and collectibles. Based in New York City, Topps is best known as a leading producer of basketball cards, football cards, baseball cards, hockey cards and other sports and non-sports themed trading cards. It is currently the only baseball card manufacturer with a contract with the MLB.
Responsibilities
?Working with On site and functional team, gathering requirements and Preparing design documents before start working on requirements.
?Working on Functional setups (Customer Creation, Organization, Locations, Profile and Printer and Intercompany).
?Create shipment, Deploy the reports under the custom folder in BI publisher, Setup Ship From Contact Name and Phone number for the Ship From Location, Create Freight Cost Types and Setup for Carriers in Oracle SCM Cloud instance
?Working on Shipping tables and TCA architecture table and order tables.
?Working on Order process, Order release process, pick release and pick confirm and Ship Confirm process.
?Working on custom packages, we have around 40 custom package like Shipment, Ship Confirm, Serial, Carrier and Consolidate packages.
?Working on many APIs like wsh_deliveries_pub.generate_documents, wsh_deliveries_pub.create_update_delivery, wsh_delivery_details_pub.update_shipping_attributes.
?Working on Client Issues daily and at the same working on new enhancement for product development like Freight shopping and Internal Development.
?Worked on Sales Order Acknowledgement.
?Worked on Invoice Print Selected Invoices.
?Worked on Printed Purchase Order Report.
?Worked on OM Open Candy Orders with Gross Sales.
Environment: Oracle Applications R12, OM, INV, Oracle 10g, PL/SQL.
Client: Jacmel Jewellery (Long Island, NY, USA)
Company: CES LIMITED
Project: Oracle Applications Development and Support
R12
Role: Sr. Technical Consultant Duration: July’11 - Jan'16
Jacmel Jewellery was founded in 1977, and is one of the country’s largest Manufacturers and distributors of popular price pointed jewellery. Jacmel employs over 1000 people world-wide, including 250 in its 100,000 square foot state-of-the-art Long Island facility. This facility incorporates executive offices, design, model and sample making and distribution in one central location. The presence of all these functions in one location allows Jacmel to consistently achieve remarkably low lead times for product design and development. These low lead times result in the quickest reaction in the industry to customer trends and preferences.
Responsibilities
?Worked on development and customization of Reports and Interfaces
?Involved in developing the XML Reports.
?Many Open Order Reports developed for different sales persons and different customers with XML Publisher tool.
?Many Packing Slip Reports developed for different customers (Walmart, Sears, Kohls, Macys..,) with different barcodes.
?Number of Labels developed with barcodes through XML Publisher tool.
?Customized the code for EDI DROP SHIP Creation.
?Developed Master Detail forms using TEMPLATE.fmb and Registered the form and migrated.fmx Executable file to $AU_TOP on forms server of client
?Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all Interfaces.
?Worked on existing forms customization and form personalization.
?Responsible for creating the scripts for concurrent executables and concurrent programs for interfaces and custom reports.
?Involved in redesigning the EDI validation process for Order Import.
?Support for entire Order Management and Shipping processes.
?Involved in preparing Technical Design Document and Test Plans.
?Done several outbound interfaces.
?Modified the validation program to convert Canadian currency to USA Currency for Canadian orders.
?Involved in writing Control Files for SQL Loading
?Developed PL/SQL Stored Procedures, Functions, Triggers
?Preparation of Technical Documentation like MD70.
Environment: Oracle Applications R12, OM, INV, Oracle 10g, PL/SQL and TOAD.
Client : AVTEC, Indore, MP.
Company: BirlaSoft
Project: Oracle Applications Development and Support
R12
Role: Sr. Technical Consultant Duration: Nov’10 - Jun’11
AVTEC, the largest independent manufacturer of power trains and transmissions in India is a part of the C. K Birla group. The group spans four continents and has a global revenue of over USD $1.8 billion with interests in major industrial segments including automobile, bearings, power train for auto and off highway, paper, cement, building products, electrical products, information technology and other philanthropic activities like educational institution and hospitals.
Responsibilities
?I have worked in client location at Indore, MP.
?Involved in customizing and developing the Reports.
?Involved in developing the XML Reports.
?Preparation of Technical Documentation like MD70.
?Worked on existing forms customization and form personalization.
?Developed the Conversion for Budget Cost type creation for all cost elements (Material, Material Overhead, Resource, OSP and Overhead) using CST_ITEM_CST_DTLS_INTERFACE. After create the Budget Cost I have developed the report for Average and Budget Cost comparison Report.
Environment: Oracle Applications R12: WIP, BOM, Cost Management and AP, Oracle 10g, PL/SQL and TOAD.
Client: CISCO
Company: IBM
Project: NGCCRM
Role: Oracle Apps Technical Consultant Duration: Nov’09 - Nov’10
The primary goal for the Cisco International (CI) is to allow Cisco to capture business opportunities which are currently out of reach due to legal, tax and system limitations that prevent Cisco from conducting direct business in certain countries. There are several key benefits to doing this. This will allow Cisco to fulfill STC Strategy to protect its corporate tax status as Cisco tries to expand direct business going forward. It allows Cisco to position itself to enable Emerging Market growth while protecting the Cisco brand.
Responsibilities
?Worked with the offshore development team.
?Develop Execute Adjustment API.
?Responsible for design, development scripts including preparation of document deliverables for the assigned development tasks.
?Involved in design of AIM (Application Implementation Methodology) documents (MD-70) for all Interfaces.
?Preparation of technical specifications from the functional specifications received from the functional team.
?Developed PL/SQL package for Revenue Accounting Engine and Batch Jobs.
?Dealt with registering / defining of custom applications, tables, concurrent requests, defining of application users and responsibilities.
?Involved in unit testing of changed components to test the functionality.
?Assisted in database designing by creating database objects such as Views, and Indexes.
?Involved in development of codes and reports
Environment: Applications 11i: AR, OM, AOL, Oracle 9i, UNIX, PL/SQL and TOAD.