Oracle Apps Technical Consultant with 5+ Years Experience
Resume:
*.Name
Golla Nagendra
*.DOB
Nationality
Indian
3.Education
School, College and /or University Attended
Degree/certificate or other specialized education obtained
Date Obtained
Nizam Institute of Eng. and Tech, JNTUH
MCA
2009
4.Professional Summary
5+ years of extensive experience as Oracle Application Technical Developer
Good in Customizing Oracle reports and developing new reports by using Oracle Report 6i/10g.
Interacted with users, fixed the bugs, developed test plans and provides daily production support.
Developed new Concurrent Programs, Custom Forms, Reports and Flex Field Customizations.
Extensively used TCA (Trading Community Architecture) to create customers in AR.
Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle Forms, Oracle Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specification.
Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle packaged APIs etc.
Expert in developing technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
Involved in workflow.
Knowledge on SAP Plant Maintenance.
5.Languages
Read
Write
Speak
English
Excellent
Excellent
Excellent
Hindi
Excellent
Excellent
Excellent
Telugu
Excellent
Excellent
Excellent
Kannada
Limited
--
Limited
6.Employment Record
From: June 2013 To: Sep 2018
Employer: Tech-Lounge Private Limited, Bangalore
Position Held: Oracle Apps Technical Consultant
7.Project Profile
Project 1#
Tech-Lounge Private Limited
Year: May 2017 to Sep 2018
Location: Bangalore
Client : 24/7
Main Project Futures: Enhancements
Technical Details: Oracle apps R12, Reports 10g, Oracle 11g, BI Publisher
Modules : AR,PO,OM, INV,GL
Team size : 10
Position Held: Technical Consultant
Activities Performed:
Preparation of MD70 (Technical design document) and MD120 (Migration Document)
Writing SQL queries according to customer requirement.
Creating Database Objects like tables, views, sequences, Indexes.
Creation of PL/SQL procedures, Functions and Packages.
Working on XML Publisher reports.
Customized AR Invoice Report.
Developed Purchased Order Approved Report in PO.
Developed Sales Order Sales Order Report in OM
Developing inbound Interfaces and outbound interfaces.
Developed GL outbound interface to extract the data from the Oracle Apps Tables to the Flat file using UTL_FILE utility.
Developed Items categories Interface through API to assign item categories to the items
Developed Customer conversion to create Customers in AR module
Project 2#
Tech-Lounge Private Limited
Year: Sep 2015 to April 2017
Location: Bangalore
Client : Toshiba
Main Project Futures: Enhancements
Technical Details: Oracle apps R12, Reports 10g, Oracle 11g, BI Publisher
Modules : AP,PO, INV
Team size : 8
Position Held: Technical Consultant
Activities Performed:
Developed SQL Loader scripts to populate staging tables.
Developed Item wise details of Purchased Order Report.
Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
Involved in the conversion of AP Suppliers from legacy to Oracle ERP.
Worked on AP Interface to convert Open Invoice Transactions from Legacy System to Oracle AP module.
Part of the Implementation team for Procure to Pay (P2P) life cycle.
Developed Code for Custom AP Invoice Import Program. This interface reads invoices from ASCII data file and loads the standard Oracle Payables invoice Interface tables.
Involved in Performance tuning of various queries and stored procedures.
Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
.
Project 3#
Tech-Lounge Private Limited
Year: June 2015 to August 2015
Location: Gurgaon
Client : Polaris
Main Project Futures: Enhancements
Technical Details: Oracle apps R12, Reports 10g, Oracle 11g, BI Publisher
Modules : System Administrator, AP, INV.
Team size : 3
Position Held: DevOps
Activities Performed:
Creating User Accounts Details Activities.
Assigned Responsibility Modules for particular User Account.
Creating User Profiles.
Handling System Administrator Responsibility.
Developed SQL Loader scripts to populate staging tables. Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
Involved in the conversion of AP Suppliers from legacy to Oracle ERP.
Worked on AP Interface to convert Open Invoice Transactions from Legacy System to Oracle AP module.
Customized the pick slip, packing slip and invoice reports.
Design, Development and Customization of RICE components.
Involved in Performance tuning of various queries and stored procedures.
Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules.
Involved in Customization of Standard Outstanding Hold Report using Reports builder as per the business Requirements.
Project 4#
Tech-Lounge Private Limited
Year: July 2014 to May 2015
Location: Bangalore
Client: Fortis health Care
Main Project Futures: Enhancements
Technical Details: Oracle apps 11i, Reports 6i, Oracle 10g, XML Publisher.
Modules : AP,AR, PO, GL
Team size : 8
Position Held: Associate Technical Consultant
Modules : PO, AP, AR, GL
Activities Performed:
Developing inbound Interfaces and outbound interfaces
Working on XML/BI Publisher reports
Developed Material voucher report for PO module
Developed AR billing and receipt history report
Developed code for AR Receipts API Procedures.
Developed Customer Interface to create Customers in AR module.
Developed AR Transaction Interface.
Customized Invoice Report
Developed Customer conversion to create Customers in AR module
Preparation of MD70 (Technical design document) and MD120 (Migration Document)
Creation of PL/SQL procedures, Functions and Packages.
Creating Database Objects like tables, views, sequences, Indexes.
Writing SQL queries according to customer requirement.
Project 5#
Tech-Lounge Private Limited
Year: June 2013 to June 2014
Location: Bangalore
Client: Supra ITS
Main Project Futures: Support
Technical Details: Oracle apps 11i, Reports 6i, Oracle,XML Publisher.
Modules : PO, OM, INV
Team size : 10
Position Held: Associate Technical Consultant
Project Name : Supra ITS
Activities Performed:
Writing SQL queries according to customer requirement.
Understanding the Client Requirements in the new scenario, Requirements Gathering and Mapping Documents for above mentioned SCM modules.
customized standard Purchase Order Detail Report Using XML Publisher
Created value sets for concurrent programs.
Developed packages, procedures and functions.
Customized the pick slip, packing slip and invoice reports.
Design, Development and Customization of RICE components
Doing feasibility analysis and preparing technical design documents MD-070
Coding and Development of RICE as per Naming and Coding Conventions
Define Concurrent program, Request Sets and Executable
Performing Unit testing and Code review for developed RICE Components
Preparation of MD120 doc for Code migration
Preparation of TE020 doc for Unit Test cases
Monitoring the deliverables during each phase of project
Attending the weekly status calls and weekly reporting
Writing SQL queries according to customer requirement
Understanding customer issues.
Define value sets
Analyzing logs and providing remedy to customers.
Creating Database Triggers.
8.Technical Skills
Development Tools
Reports ( 6i,10g), XML/BI Publisher, TOAD 7.5 /9.6
Conversion Tools
SQL*Loader, Data loader
Network Utilities
Putty, WinScp, FTP
Database
Oracle 10g/11g
Operating Systems
Windows 2003 Server, Windows 2008 Server, Windows 2000,Unix, Linux,Windows XP,7,8.1,10
Contact this candidate