Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Organizations
Timeline
Generic

GNANACHELVAN G K

Namakkal

Summary

Oracle Applications Technical Consultant with over 6 years of experience, including more than 5 years in Oracle Financials and ERP. Skilled in Oracle EBS R12/11i, covering P2P, O2C, SCM, and Financial Modules (AP, AR, GL, PO, OM, INV).

Expert in PL/SQL programming, performance tuning, data migration, and Informatica workflows. Proficient in developing interfaces, conversions, reports, XML Publisher reports, and handling Oracle ERP customizations and implementations.

Strong in troubleshooting, system enhancements, and technical documentation (MD50, MD70, MD120). A problem solver with a keen eye for optimization, seeking opportunities to contribute expertise in Oracle ERP solutions.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Oracle Tech Consultant

Cisco Systems
03.2023 - Current
  • Company Overview: Cisco Systems is a multinational technology conglomerate that develops, manufactures, and sells networking hardware, software, telecommunications equipment, and other high-technology services and products.
  • Website: [Cisco](https://www.cisco.com)
  • Responsible for the study and analysis of all enhancement requirements from users.
  • Writing PLSQL subprograms, and working on advanced PLSQL.
  • Involved in performance tuning.
  • Involved in the development of interfaces and conversions to import the data from a legacy system into Oracle application base tables.
  • Understanding customer issues.
  • Coding and development of RICE, as per naming and coding conventions.
  • Developed and enhanced the PL/SQL codebase for key functionalities within Oracle Applications.
  • Conducted performance-tuning activities to improve system efficiency and response times.
  • Led data migration efforts, ensuring a seamless transition from legacy systems to Oracle Applications.
  • Developed Informatica workflows for ETL processes, ensuring data integrity and reliability.
  • Worked on Supply Chain Management, Order Management.
  • Worked on end-to-end data migration activities.
  • Expertise in Developing Data Validation Procedures.
  • Responsible for managing orders, including scheduling and rescheduling them.
  • Participated in unit testing for user interface applications.
  • Involved in systematic testing across instances.
  • Expertise in validating system functionality and ensuring a smooth transition of data for impactful results.
  • Website: [Cisco](https://www.cisco.com)

Oracle Tech Consultant

Harsco Corporation
12.2020 - 03.2023
  • Company Overview: Harsco Corporation, headquartered in the USA, has its production plants located there. Harsco is the world's leading provider of co-product recycling and logistics services for the steel industry.
  • Website: [Harsco](https://www.harsco.com)
  • Responsible for the study and analysis of all enhancement requirements from users.
  • Customize and develop the Oracle reports for PO, AP, GL, OM, and AR.
  • Writing PLSQL subprograms, and working on advanced PLSQL.
  • Involved in the development of XML Publisher reports based on business requirements, and registered them in Oracle applications.
  • Involved in performance tuning
  • Involved in the development of interfaces and conversions to import the data from a legacy system into Oracle application base tables.
  • Worked on UTL_PACKAGE and SQL*Loader.
  • LOADER for the interfaces and conversions.
  • Understanding customer issues
  • Coding and development of RICE, as per naming and coding conventions.

Oracle Tech Consultant

CLAIRE'S
01.2019 - 11.2020
  • Company Overview: Claire's, formerly known as Claire's Accessories, is an American retailer of accessories, jewelry, and toys primarily aimed toward girls, preteens, and teens.
  • Website: [Claire's](https://www.claires.com)
  • Customize and develop the Oracle reports for PO, AP, and GL.
  • Writing PL/SQL procedures, functions, and packages as per the application requirements.
  • Involved in the development of reports based on business requirements, and registered them in Oracle applications.
  • Development involves analyzing MD50 (Functional Spec), and then writing MD70 (Technical Spec).
  • Worked on inbound interfaces and conversions in financial modules.
  • Coding and development of RICE, as per naming and coding conventions.

Associate Consultant

NOBIA UK
09.2017 - 12.2018
  • Company Overview: Nobia UK forms part of Europe's leading kitchen specialists.
  • Website: [Nobia](https://www.nobia.com)
  • Working with the help desk team.
  • Monitoring L1 tickets.
  • Submitting daily reports to the user.
  • Extracting the SQL reports.
  • Coordinating with the team.

Education

BE -

M Kumaraswamy College of Engineering
01.2016

Skills

  • Interfaces
  • Conversion
  • Reports
  • XML Publisher
  • Technical support
  • Performance tuning
  • Data migration
  • Programming: PL/SQL, SQL*Loader
  • Informatica PowerCenter
  • Procure to Pay
  • Order to Cash

Accomplishments

  • Supernova Award for Outstanding Employee Performance

Certification

  • Oracle Cloud Infrastructure 2024 Generative AI Professional

Organizations

Rapidflow Apps Software Ltd (03/2023-Present)

Oracle Apps Technical Consultant

-

Motech Software (09/2017-03/2023)

Oracle Apps Technical Consultant 

Timeline

Oracle Tech Consultant

Cisco Systems
03.2023 - Current

Oracle Tech Consultant

Harsco Corporation
12.2020 - 03.2023

Oracle Tech Consultant

CLAIRE'S
01.2019 - 11.2020

Associate Consultant

NOBIA UK
09.2017 - 12.2018

BE -

M Kumaraswamy College of Engineering
GNANACHELVAN G K