Resume of Oracle Apps Techno-Functional Consultant




Title
Oracle Apps Techno-Functional Consultant

Primary Skills
Over 6 years of experience as Techno-Functional Consultant in Oracle E-Business Suite Applications.

Location
US-NY-NYC

Posted
Feb-13-07

RESUME DETAILS
Summary:

* Over 7 years of analysis, design, and development experience in the IT industry in of various oracle.
* Over 6 years of experience as Techno-Functional Consultant in Oracle E-Business Suite Applications.
* Experience in all phases of the system development /implementation life cycle.
* Extensively worked on GL, AP, AR, OM, INV, AOL, Alerts, Workflow and System Administration modules.
* Experience of Development, Interfaces & Data Conversion, Implementation, Customizations of Oracle General Ledger, Accounts Payables, Accounts Receivable modules.
* Prepared technical design documents for customizations and conversions using AIM documentation methodology.
* Expert level experience in Oracle 7.x, 8.x, 9.x, Oracle Forms 4.5,6i, Oracle Reports 2.5,6i.
* Proficient in writing Stored procedures, Packages and functions using SQL & PL/SQL.
* Highly experienced in developing & customizing Oracle forms and Reports in Oracle Applications.
* Experience in UNIX Shell (Korn, C, BASH) Scripting.
* Experience in performance and tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
* Good functional knowledge on financial accounting and business processes.
* Strong perseverance and diligence towards attaining challenging goals and effective time management.
* Self-motivated, excellent team player with proven leadership skills.
* Excellent communication and interpersonal skills.


Technical Skills:

ERP Oracle Financials 11i/10.7 (GL, AP, AR, OM, INV, AOL, System Administration, ALerts and workflow)
Data Modeling Tools Erwin, Designer 2000, Microsoft Visio 2003
RDBMS Oracle 10g/9i/8i /7x, SQL Server 7.0 / 2000
Tools Developer 2000/6i (Forms 4.5/6i, Reports 2.5/6i), Discoverer 4i, SQL*Loader, TOAD, Oracle Enterprise Manager, ADI, SQL*Loader, SQL*Plus, Discoverer 4i, Dataload and PVCS (Version Control System)
Languages SQL, PL/SQL, Shell Scripting, HTML, XML, Pro*C, Java
Environment UNIX - Sun Solaris, HP-UX, Windows 98/NT/2000/XP
Education:

* Bachelor's in Engineering Osmania University, India
* Oracle Certified Professional on Oracle 8i, Sep. 2001.
* Oracle Certified Associate on Oracle 9i (DBA), December 2002
* Training in Oracle 8i/9i/10g with Developer 6i for Application development
* Training in oracle 9i DBA

Professional Experience:

TMAResources, VA Aug.05 - till date
Oracle Applications Techno-Functional Consultant

Responsibilities:
* Designed and developed the conversion process for historical AR transactions into Receivables during the implementation process.
* Worked with functional experts to define requirements for interfaces.
* Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
* Developed a custom report to daily list all the rejected invoices based on the interface table.
* Developed data fix scripts for identifying the issues related to Invoices that are stuck in the interface table.
* Created Read Only version of Customer Standard form.
* Modified Invoices form in AP and Transactions form in AR to restrict data access.
* Resolved the accounting month and accounting date problem at the year-end processing.
* Tracked all the invoices and records that are modified for successful import loading into the base tables.
* Customized Journal Batch Summary Report, Aging 4 bucket report and past due invoice report.
* Created and Registered concurrent executables and concurrent programs.
* Interacted with users to resolve any issues during the production, development and enhancement phases.
* Used cross-validation and value set features while implementing descriptive flexfields extensively to capture additional information in standard as well as customized forms.
* Ran the General Ledger Interface program to transfer Receivables transaction accounting distributions to the general ledger interface table.
* Provided technical assistance in the AR to GL reconciliation efforts/issues.
Environment: Oracle Applications Release 11i(GL, AR, OM, AOL and Sys Admin), Oracle 9i(SQL, PL/SQL), Forms 6i, Reports 6i, TOAD, Sun Solaris.

Health New England, MA Jan.04 - Aug.05
Oracle Applications Techno-Functional Consultant

Responsibilities:
* Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
* Developed FSG reports to give department managers a high level view of their current operating revenue and expense categories compared to their budgets using FSG and ADI.
* Developed GL Summary, Income Statement Summary reports using FSG and ADI.
* Troubleshoot issues regarding row and column overrides and hierarchy of reporting structures, and custom themes in ADI for report formatting.
* Developed a package that validates invoice information and load the invoices into AR by running auto invoice daily.
* Resolved any issues for invoices generating from Order Management.
* Created receipts and applied them using AR_RECEIPTS_API_PUB API. This program is scheduled to run every night as a concurrent request.
* Optimized performance measures for Autoinvoice process using System Options setups.
* Worked on Customer Listing - Detail/Summary report and Dunning History report. Registered these reports as concurrent programs in AOL and modified request group to add these concurrent programs.
* Developed the required PL/SQL packages and registered as Concurrent Programs.
* Participated in the Unit and Integration Testing along with the end-users
Environment: Oracle Applications 11.5.9(GL, AR, OM, AOL and Sys Admin), ADI, Forms 6i, Reports 6i, Oracle 9i, (SQL, PL/SQL), TOAD, SQL*loader and HP-UNIX.



Tiaa-cref, NY Jun.02 - Dec.03
Oracle Applications Techno-Functional Consultant

Responsibilities:
* Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables
* Responsible for documenting the mapping and requirements for the interfaces and conversions between the source and oracle Applications
* Customized the Accounts Payable Vendor Entry Form as per requirements
* Created Alerts to notify users on various business events
* Developed a package to import expense information into Oracle Payables.
* Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL_FILE package at periodic intervals.
* Registered PL/SQL packages, Request Sets, Forms, Menus
* Involved in creating some Custom reports and Forms for the end users to check the details and errors.
* Customized Employee Listing report, Invoices on Hold report and Suppliers report as per the business requirements.
* Executed the Payables Transfer to General Ledger program and resolved the issues during the process.
* Responsible for the technical and user documentation of the customizations.
Environment: Oracle Applications 11.0.3/11.5.5(GL, AP, AOL, Alerts), Forms 6i, Reports 6i, Oracle 8i(SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer


Envision Labs, India Feb.01 - May.02
Oracle Applications Developer
Responsibilities:
* Involved in setup of Set Of Books (Chart of Accounts, Calendar and Currency).
* Defined value sets and value set values
* Involved in setting up the cross validation rules
* Converted User Requirements into formal Functional specifications and Interfacing with client
* Developed mapping documents for the columns of source application and oracle applications
* Involved in developing the template using which help the customers to understand the format of the data file, the required columns and optional columns and the mapping between the client's columns and the GL interface columns.
* Journal Import: Developed a package for GL Interface that validates and imports journals to General Ledger.
* Implemented Event Alerts like to notify the GL manager that import is done and notifying the manager when a large journal has been entered. Also developed periodic alert to notify manager of all unposted journals.
* Developed stored procedures, functions and packages in augmenting the business using PL/SQL.
* Registered PL/SQL packages, Forms, Menus and reports as concurrent programs.
* Developed custom reports such as Customer Information report, User Application Responsibilities report.

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts), Oracle 8i(SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and HP-UNIX, Discoverer

GTech, India, May.00 - Jan.01
Oracle Developer

Responsibilities:
* Extensively developed PL/SQL Procedures, Functions, Form Triggers and Packages
* Developed web based front-end screens using Forms 6i and Generated custom reports using Reports 6i
* Used TOAD, PL/SQL developer tools for faster application design and developments.
* Creating SQL, Object Views, PL/SQL database objects.
* Used PL/SQL TABLE, VARRAY, RECORDS and OBJECT TYPES.
* Analyzed and prepared Statement of Work and Requirement Definition Document.
* Designed the business logic to eliminate problems and to ensure efficient system functioning.
* Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.
* Implementing basic replication using snapshots.
* Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
* Tested the entire application in Testing environment and exported to Production.

Environment: SQL, PL/SQL, Forms 4.5/6i, Reports 6i, Oracle 8i, Solaris

WebTekLabs, India Jul.99 - Apr.00
Oracle Developer

Responsibilities:
* Responsible for creating the Database tables, indexes, constraints in Oracle8i.
* Played active role in tuning the Oracle Database queries using Indexes, Explain Plan and Optimizer Hints.
* Design & Development of User Interface using Forms 6i.
* Developed packages specifications & packages body, Stored Procedures, views and cursors using PL/SQL, Oracle 8i.
* Developed reports using Reports 6i
* Created Test Specification & Test Servers to simulate large transactions.
Environment:
SQL, PL/SQL, Forms 4.5i, Reports 4.5i, Oracle 8, Solaris

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-NY-NYC »
View all resumes in US-NY »

View other Oracle Apps Techno-Functional Consultant resumes, Programmer / Developer resumes