PUVVADI LOKESH
ORACLE CONSULTANT
+91 63660 53419
puvvadilokesh9@gmail.com
SKILL
P R OSUMMURY:
FESSIONAL SUMMARY
ERP - OracleE-BusinessSuiteR12(PO, AP, OM, AR, INV, GL)
RDBMS - Oracle 19c/11G
Operating - Windows7.
Tools - SQL* Loader, Toad, Win SCP, MS
Office,XML, BI - Application Implementation Met(AIM)/OUM
Methodologies
Reporting Tools - D2KReports/XML/BI Reports
PROFESSIONAL SUMMURY:
Having around 3+ Years of Professional IT experience in oracle application as a SCM &
Finance Consultant with implementation and support experience in AP, AR, GL
,inventory, purchasing, order management of Oracle application. PL/SQL Developer.
Worked on procure to pay [P2P] and Order to cash [O2C] Cycles.
Worked on Inventory Management, Purchasing and order management and data
migration form legacy system to oracle system with the respective functional modules
integration in the implementation and supporting projects.
Adept in reviewing and analysing the business scenarios, processes and activities,
evaluating end user requirements and troubleshooting any problems in the process.
Proficient in Creating User Requirement Specification, Functional Requirement
Specification and Business Process Flows.
Good supporting knowledge with the direct interaction and having good communication
skill with client.
Worked on J Developer in OAF, involved in OAF personalization and OAF vo extensions
controller extensions.
Good experience on working on Business requirements analysis, review, definition and
documentation.
Experience in writing Stored Procedures, Functions and Packages using SQL*Plus and
PL/SQL
Prepared Technical Documents like MD’S, CV’s.
Have an ability to work well in a team or individual environment.
Strong technical background with excellent interpersonal skills and an ability to interact
with individuals at all levels.
Experience on Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
Experience in working with all the RICE components (Reports, Interfaces, and
Conversions).
Good Experience on XML Publisher Reports like XML Bursting reports.
Should be flexible to work in coordination with onshore and offshore models and in a
Matrix environment.
EDUCATION:
B.TECH ELECTRONICS AND COMMUNICATION ENGINEERING
Priyadarshini College Of Engineering and Technology-2016 - 2020 - 67%
INTERMEDIATE
Nri Junior College -2016 - 72%
SSC
Sri Venkatadri English Medium School - 2014 - 80%
PROFESSIONAL EXPERINCE:
Working as an Oracle apps technical Consultant in 9I WEB SOLUTIONS PVT LTD.
from SEP - 2021 to PRESENT
PROFESSIONAL SKILLS:
Oracle - Oracle 12
Module - Inventory, Purchasing, Order Management, Payables,
Receivables, General ledger, XML Publisher
Operating System - (Windows 10/8/7/XP)
PROJECT #3
Client : National Paints, U.A.E
Role : Oracle apps technical Consultant
Team Size : 25
Database : Oracle 11g.
Environment : Oracle EBS R12 (AP, AR, GL, PO)
Project Duration : (JAN 2023 –SEP 2024)
Description:
A well-known paint manufacturing company, National Paints produces a variety of
coatings and decorative paints for residential, commercial, and industrial use. They are a
key player in the UAE’s construction and real estate sector.
Roles & Responsibilities:
Development of Interfaces and Conversions.
Worked on the design, development of custom Oracle Forms for reviewing and approving
customer transactions, merchant billing and payments
Development of Developer Reports and Customization of Existing Reports.
Prepared UNIX shell scripts
Provided instant solutions to issues which were reported in the production instance.
Created various PL/SQL procedures/packages according to the Client requirements in
Oracle ERP.
Developed XML Publisher Reports.
Created forms to enable Confidential to enter/edit/delete header/line/detail level
transactions
Involved in Discoverer Reports.
Worked on performance tuning.
Developed custom Alerts as per business requirements.
Involved in Designing new OAF Self Service Web Pages using JDEVLOPER.
Deployment of OAF Pages and registering/importing pages/regions to MDS
Oracle Forms (Applets) and OAF pages Personalization.
Development of personalization on OAF page for isupplier module.
This Extension is for the purpose of making changes on the Quote User Interface (UI)
screen to
facilitate the sales person with the additional information in the quote screen while
performing
negotiations with the customers.
displayed the full name of the Operating unit under OU field in Buyer Work Center.
Involved in design reviews, test plans and code reviews.
PROJECT #2
Client : Danube Group (Danube Building Materials), U.A.E
Role : Oracle apps technical Consultant
Team Size : 21
Database : Oracle R12.
Environment : Oracle EBS R12 (AP, AR, GL, PO)
Project Duration : (MARCH 2022 – Dec 2022)
Description:
Danube is a prominent manufacturer of building materials and home interiors. Known
for its high-quality products, it serves the construction, interior design, and home
improvement sectors in the UAE and beyond.
Roles & Responsibilities:
Development and Customization of Developer Reports.
Involved in development of Conversions in AP, PO, OM Modules in Oracle ERP.
Development of XML Publisher Reports in AP, PA module.
Involved in preparing documents as per standards.
Code review and testing and fixing the problems.
Involved in oaf Pages development, customizations and Personalization’s.
Customization of OAF pages as per requirements in Payables and projects.
Provided instant solutions to issues which were reported in the production instance.
Preparing Technical Documents like MD’S, CV’S and TE’S.
Involved in design reviews, test plans and code reviews.
PROJECT #1
Client : Generac Power Systems , U.S.A
Role : Oracle Apps Technical Consultant
Team Size : 11
Database : Oracle R12 Oracle EBS R12(AP,
Environment : AR, GL, PO)
Project Duration : (OCT 2021 – FEB 2022)
Description:
Generac is a well-known name in the power generation industry, producing backup
generators for residential, commercial, and industrial use. They have a strong focus on
innovation in energy storage and smart grid solutions, making them a leader in backup
power solutions in the U.S.
Roles & Responsibilities:
Responsible for Study and Analysis of all enhancement Requirements from users.
Customization and Develop the Oracle Reports for PO, AP, GL.
Writing PLSQL sub programs and worked on advanced PLSQL.
Involved in development of XML publisher reports based on business requirements
and registered them in Oracle applications
Involved in performance tuning.
Worked on oracle discoverer.
Involved in the development of interfaces/Conversions to import the data from
legacy system into oracle application base tables.
Worked on UTL_PACKAGE and SQL*LOADER for the interfaces and conversions.
Understanding customer issues.
Deployment of OAF Pages and registering/importing pages/regions to MDS
Oracle Forms and OAF pages Personalization.
Coding and Development of RICE as per Naming and Coding Conventions.
Preparation of AIM Documentations.
Provided instant solutions to issue which were reported in the production instance.
Involved in preparing the documents as per standards and testing and fixing the
problems.
Personality Traits:
Self-motivated and continuous learning professional.
Has strong analytical, problem solving skill and interpersonal skill.
Adaptable and flexible to work in any environment.
