Oracle apps technical
Resume:
Oracle Apps Developer
NARESH KOTAPATI
Email:**********@*****.***
SUMMARY
* About 4.2 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle Applications R12 spread across Implementations, Version upgrades, Data conversions and Customizations.
* Experience in three full lifecycle implementations. Strong knowledge of Order to Cash and Procure to Pay Cycles.
* Extensive experience in Oracle Application Modules which include General Ledger(GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing(PO), Inventory (INV) & Order Management (OM) modules.
* Extensive Programming experience in Oracle 10g/9i, SQL, PL/SQL and XML.
* Expertise in Forms 9i/6i and Reports 9i/6i.
* Experience in Application Object Library (AOL)
* Expertise in Data Conversion and Interface development
* Experience in Oracle Discoverer and XML Publisher
* Experience in Workflow Customization according to business needs.
* Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
* Experience in environments requiring direct customer interaction during specifications, documentation, design and development and implementation phases.
TECHNICAL SKILLS
Oracle Applications:
Oracle Applications 11.5.10.2/ 12.1.3 (Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Order Management (OM), Inventory (INV), Purchasing (PO) and Application Object Library (AOL)).
Languages:
SQL, PL/SQL, UNIX Shell Scripting
RDBMS:
Oracle 10g/9i
Oracle Tools:
Forms 6i/9i, Reports 6i/9i, Oracle 10g/9i, Discoverer 4i/9i, Work Flow Builder and XML Publisher.
Database Tools and Utilities:
SQL*Plus, SQL* Loader, Toad
Operating Systems:
UNIX, LINUX, Windows 98/NT/2000, MS DOS, Solaris 8.0
EDUCATION
* B.Sc from NAGARJUNA University in 2007
PROFESSIONAL EXPERIENCE:
* Working as Technical Consultant for IT Convergence, Hyderabad, From Nov’10 – Till date.
* Worked as Software Engineer for WIPRO INFOTECH, Hyderabad, From Jun’09-Nov’10.
PROFESSIONAL EXPERIENCE
Project: 3
Client : Mercury Marine
Team Size : 13
Role : Oracle Applications Techno-Functional Consultant
Duration : Feb 2012 – Till date
Mercury Marine, founded in 1939, is a division of Brunswick of Lake Forest, Illinois, in the United States. Mercury provides engines for private, commercial and government sales. Mercury also has its own line of racing engines tailored for power and speed. The company's primary business is outboard motors.
Environment: Oracle Applications R12 (AR, AP, GL, PO, OM, INV), Solaris, Oracle 11g, Forms10g, Reports 10g, Workflow 3.6.2.5, PL/SQL, SQL*Loader, Toad 9.7
Responsibilities:
* Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents
* Development of executables, concurrent programs, creating value sets and registering them into oracle applications
* Creating database Triggers
* Writing SQL queries according to customer requirement
* Understanding customer issues
* Analyzing logs and providing remedy to customers
* Preparing Unit test
* Developing Forms and Reports
* Coding of Forms and functional testing.
* PL/SQL method of submitting Concurrent programs
* Development and Customization of Reports, PL/SQL Procedures, and Packages.
* Registering reports in Oracle Applications
* Registering forms in Oracle Applications
Project: 2
Client : Glen Raven, Inc.
Team Size : 10
Role : Oracle Applications Techno-Functional Consultant
Duration : Nov 2010 – Feb 2012
Glen Raven, Inc. is a family-owned textile company that was founded in 1880. The company is headquartered in Glen Raven, North Carolina and, since its founding, Glen Raven has grown from a small cotton mill into a global textile company. Glen Raven’s two flagship brands are Sunbrella and Dickson, and it also produce a wide range of industrial and specialized fabrics.
Environment: Oracle Applications R12 (AR, AP, GL, PO, OM, INV), Solaris, Oracle 11g, Forms10g, Reports 10g, PL/SQL, SQL*Loader, Toad 8.5
Responsibilities:
* Interacted with business owners, functional consultants and subject matter experts effectively to
Understand business requirements, functional designs, process flow and data flow
* Worked on Bank conversion. Responsibilities involved configurations, data mapping using SQL*Loader
To import legacy Suppliers into Oracle
* Development of executables, concurrent programs, creating value sets and registering them into oracle
Applications
* Creating database Triggers
* Writing SQL queries according to customer requirement
* Understanding customer issues
* Analyzing logs and providing remedy to customers
* Preparing Unit test
* Developing Forms and Reports
* Coding of Forms and functional testing
* Developed inbound interface to transfer data from legacy system to oracle applications
* Developed outbound interface to extract the data from the Oracle Apps Tables to the Flat file using UTL_FILE utility
* Registering reports in Oracle R12 Applications
* Registrations of Tables
Project: 1
Client : CompuCom Systems, Inc
Team Size : 17
Role : Oracle Applications Technical Consultant
Duration : Jun 2009 – Nov 2010
CompuCom Systems, Inc. Corporation is a US-based Information Technology Outsourcing company, specializing in Infrastructure Management, Applications and Software Development Services Systems integration, and IT Workspace Management. CompuCom offers IT infrastructure management services, application development, systems integration, consulting and professional services as well as the procurement and management of software and hardware.
Environment: Oracle Applications 11i (AR, AP, GL, PO, OM, INV), Solaris, Oracle 9i, Forms6i, Reports 6i, PL/SQL, SQL*Loader, Toad 7.3
Responsibilities:
* Worked on custom forms
* Developing concurrent Programs, value sets, request group as per client requirement.
* Developed the interfaces
* Customization, requirement gathering and analysis.
* Created LDT’s for migrating the objects from one instance to another.
* 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
Contact this candidate