Prakash Tallada

abnqi2@r.postjobfree.com

650-***-****

Oracle, Applications Professional with 8 years experience.

Expertise in requirements gathering, functional gap analysis, and application design.

Expertise in customization of Forms, Reports, Data Conversions, Interfaces as well as techno -

functional analysis of Interfaces, Conversions and Oracle Work Flow design and development.

Experience in Oracle Applications 11i along with INV, PO, OM, AP, AR, implementation,

development, support and testing.

Experience with workflow implementation in BI-Data Warehouse Applications.

Identified product gaps, coordinated with development teams by creating TAR/SR’s and obtained

one-off fixes. Managed and monitored TARs for several P1 Issues. Provided on site solutions and

resolved showstopper issues.

Expert in System Administration in defining users, menus, responsibilities, printer set -ups and

maintaining concurrent programs, defined Custom Applications, which includes new Menus,

Request Groups and Responsibilities using Application Developer and System Administrator

responsibilities.

More than 3 years experience as an Oracle Developer (Forms, Reports and PL/SQL) and Shell

Scripting.

Experience in using Application Implementation Methodology (AIM).

Familiarity with R12 Accelerator methodology, Obtained OBA L3 Level Access and Attended Oracle

R-12.0.5 Accelerator Workshop: July, 2008.

Strong interpersonal skills, ability to interact with people at all levels.

.

Applications Tools: AOL Loaders, Adadmin, Autopatch, Autoupgrade, Oracle 11i Rapid Installer,

Experience with Oracle 11i Applications E-Business Suite, consists of

modules like Order Management (OM), Inventory, AR, PO, AP, etc., OPM

System Administration Setup, OPM-Inventory Management, Oracle

Workflow, Oracle Warehouse Builder, Oracle Discoverer, OBA (R12 Accelerators).

Languages: C, Pascal, HTML, JAVA, Unix-Shell

RDBMS: Oracle 7.x/8.0/8i, AOL, Developer 2000 (Forms 4.5/5.0 & reports 2.5), Forms

Developer 6i, Reports Developer 6i, GKS, SQL*Plus, PL/SQL, SQL*Forms 3.0,

SQL*Reportwriter 1.1

Software: Quickbooks, Peachtree Accounting, Toad, Oracle Workflow, Oracle Warehouse

Builder, Oracle Discoverer, BI Publisher, Source/Version Control System (CVS)

O/S: SCO-UNIX, Sun-Solaris, SUSE Linux, Win XP/NT/2000/3.11/95

Lion Apparel - Dayton, OH

February 2008 – Current

Applications Consultant – Design and Development of Interfaces, Conversion, Reports and

Documentation for multiple projects.

Design and Development of Sales Tax Rate data Conversion.

Design and Development of Price List data Conversion from Legacy system to Oracle.

Requirement gathering, Design and Development of Discoverer Report for custom manufacturing

2D Bar Code listing.

Documenting custom application process and technical analysis to jump start enhancing

development and support projects.

Enhancement/Development of applications custom reports.

Development of Oracle Integration/Interfaces with High Jump (Warehouse Advantage System) for

Oracle Inventory Items, Purchase Orders and Requisitions.

Resolving inbound/outbound interface issues between Oracle and High Jump.

Development of MD-50 documents based on customer requirements using Oracle AIM

methodology.

Development of complex custom report(s) for Oracle EAM Asset History.

Gathering requirements, Design and development of Interfaces for Lawson Payroll/HR modu le

integration with Oracle.

Environment: Oracle Applications Release (11.5.10) INV, PO, AR,OM, Oracle 9i, PL/SQL, Oracle

Reports 6i, SQL* Loader, Linux., Oracle Discoverer 10g

GOJO Industries - Akron, OH

April 2007 – January 2008

Applications Developer - GOJO is a leading manufacturer of skin care products.

Performed Oracle Discoverer Report Modifications.

Created Custom Application Modifications - Enhancing the existing application with add on

functionality. Development of Oracle Reports with respect to added functionality.

Performed Oracle Reports Modifications. Adding Parameters, modification of existing data model

and layout formats. Complex query troubleshooting.

Installed and configured Oracle JDeveloper with Portal Extensions. Documenting the Process and

development of Sample Portlet.

Performed Oracle Data Migration and prepared Data Migration scripts and execution of import

process and evaluation.

Changed Data Base (Prod) Character Set to UTF8 (AL32UTF8).

Document Store/Library creation using APEX.

Environment: Oracle 10g, Oracle Reports9i, Discoverer, Oracle Express (APEX), Linux

Jupitermedia Corporation - Chicago, IL

November 2006 - February 2007

Techno Functional Analyst - Jupitermedia is the leading provider of photo images and digital

content for information technology, business and creative professionals.

Performed compatibility testing of Oracle Apps. 11.5.8 with IE-7 for Order to Cash modules.

Created and modified setups for OM/AR transaction types and documentation.

Developed and enhanced custom reports on On-Account, Unapplied, Unidentified receipts.

Analyzed custom RMA import interface program to resolve the issue of contact-error when

difference in BT/ST address for a customer.

Developed custom programs of Auto-Invoice wrapper to limit certain transaction types.

Developed custom reports to list customer based on profile-class.

Performed troubleshooting of workflow errors of PO module.

Performed troubleshooting on expense report issues of AP module.

Environment: Oracle Applications Release 11i (11.5.8) OM, AR, AP on Windows 2000

McClatchy/Knight-Ridder - Miami, FL

July 2006 – September 2006

Techno Functional Consultant - The McClatchy Company is the second-largest newspaper and

web publishing company in the United States.

Sole resource for providing support for Oracle Financials, and Associated custom PL/SQL

applications.

Provided day-to-day support for Accounts Payable processes including Oracle check run,

troubleshooting creation of EDI files, as well as the EDI transmissions to the bank.

Created documentation for Accounts Payable processes.

Researched and identified solutions for cancelled purchase orders, which were generating accruals.

Developed General Ledger data extract scripts.

Made modifications to PERL scripts.

Set up and defined printers and responsibilities in Oracle Financials.

Environment: Oracle Applications Release 11i (11.5.7), AP, GL, PO, TOAD, HP UNIX.

USDA IAS Project - Washington, DC

August 2005 – June 2006

Techno / Functional Consultant

Responsible for supporting the applications Of the United States Department of Agriculture,

Procurement Division.

Established, maintained and improved processes and procedures.

Performed Configuration changes and system administration duties.

Was involved in re-organizing and streamlining the IAS helpdesk team procedures.

Worked to prevent issues and problems on a proactive basis.

Environment: Oracle Applications Release 11i (11.5.8) iProcurement and PRISM

Diebold - Canton, OH

November 2004 – July 2005

Techno Functional Consultant - Diebold is leading manufacturer of ATMs and Electronic Voting

machines, and a leading provider of electronic security systems and other card based systems.

Performed Oracle Applications Implementation – Global Cross Country. This was a new

implementation of Oracle Financials 11.5.8

Techno Functional Lead for the customization of the EFT-Interface for the Australia AP module.

Involved in designing user-friendly menu options for various Invoice reports for multiple countries in

the AR module. Supervised and customized reports as per user requirements.

Provided solutions to functional & technical team members in designing custom workflows for

custom billing options in the SO module. (e.g. Progress Billing).

Provided business problem resolutions to Deloitte Consultants and Diebold Associates in

resolving/simplifying complex support issues. Coordinated with teams involved in Business

Transformation from legacy systems/Business Process Improvement System.

Troubleshot techno functional gaps in iExpense module workflow customizations for Australia with

respect to Oracle Projects implementation.

Involved in gathering Oracle Diagnostic Tool results for PO and PA account generators and

troubleshooting account generator workflow issues for multiple countries.

Environment: Oracle Applications 11i (11.5.8), AR, AP, OM, iExpense, Workflow, Reports 6i

BELL Labs - Bell South - Atlanta, GA

May 2004 – October 2004

Corporate Data Warehouse Implementation Consultant - (Oracle Warehouse Builder- Oracle

Workflow) Bell South is a leading provider of Tele-Com services and a Yellow Pages Publisher.

Resolved the workflow integration issues with complex flows to improve performance.

Re-designed the mappings and automated the process flows to eliminate data errors.

Involved in designing Workflows for automating the process flows of Oracle Warehouse Builder.

Implemented the restart capability of process flows using Warehouse Builder and Workflow engine.

Evaluated the mappings runtime parameters and load distribution among process flow batches.

Designed the Unit testing plan of sub process flows, and integration testing of Process Flow

batches as per changes incorporated to improve the performance of weekly incremental load.

Performed documentation of Mapping vs. Process Flows.

Analyzed the data mismatch issues from source to target schema.

Implemented Oracle Discoverer Administrator-creating EUL, Security, and Views etc.

Environment: Oracle 9i, Oracle Warehouse Builder, Oracle Workflow.

GE-Transportation (Aircraft) - Cincinnati, OH

November 2003 – April 2004

Oracle Applications 11i Consultant (Implementation APS-Oracle Workflow 2.6.2) - GE-Aircraft

Engines is the world’s leading producer of large and small jet engines.

Involved the design of a Collaboration Workflow that created a Defined system, which reduced

email and call volume, while providing an integrated plan between SCP and Military systems.

Designed custom tables and indexes for workflow request data.

Designed flow using Oracle Workflow Builder 2.6.2.

Involved in Requirement analysis and “as-is” existing system study.

Involved in Oracle Workflow 2.6.2 installation and setup.

Designed and developed screens using the PL/SQL web agent and Workflow APIs.

Generated MIS reports to summarize activity status.

Created worklists to monitor the Notifications activity status.

Designed & developed multiple workflow processes to notify Supply Chain plan of exception

messages.

Environment: Oracle Applications 11i (11.5.7), APS, Oracle Workflow and PL/SQL

Agilent Technologies, San Jose, CA

July 2002 – August 2003

Technical Consultant (Oracle Applications 11i - Implementation/INV, PO, Shipping, AR, AP, GL)

Agilent Technologies is a cutting-edge technology firm, involved in optical and wireless innovations,

as well as health and life-science research.

Developed a feeder program to import journal data into Oracle General Ledger.

Modified pll’s and back end procedures related to INV.

Tested changes related to the INV module.

Involved in Oracle Financials Account Receivables (AR) and General Ledger and OE module setup.

Defined the set of books and defined the Unit of Measure Classes as per the requirement

specifications study.

Defined the additional Journal Entry sources and categories pertaining to industry specific.

Defined the Suppliers and Locations, etc.

Involved in Oracle Supply Chain, Inventory, and Purchase modules setup.

Involved in Oracle INV module setup.

Created the Item Master organization. Defined the item attribute controls. Set up the approval

information. Defined look-ups and classes, buyers, purchasing options. Defined suppliers and

receiving options.

Develop/Enhance forms and reports using Developer 6i.

Performed System Administrator setup and user profile creation, etc.

Verified Purchase Order Defaulting rules as per the specifications.

Involved in the data clean up of Oracle Purchasing and Oracle Payables.

Involved in implementing complex business rules.

Unit tested the customized forms of OE and AR modules and PL/SQL, custom PLL prog rams.

Environment: Oracle Applications 11i (11.5.7), GL, INV, AR, AP, OE, Shipping, Oracle Workflow,

Reports 6i

Oracle Corporation - Redwood Shores, CA

January 2000 – May 2002

Sr. Application Engineer - Oracle Applications Globalization/Integration/Release Group

Developed customer tools to automate Applications upgrade processes. Developed internal

tracking and statistical analysis tools to improve future quality. Interacted with other product and

technology teams within Oracle, working toward resolving packaging and quality issues. Validated

releases through test upgrades in various combinations. Contributed and reviewed customer

documentation.

Worked with Oracle 11i (11.5.7) Applications interface tools like native loaders and Applications

Database tools like ADADMIN, ADPATCH and AUTO UPGRADE, and assimilated the

user/design/technical documents details as per the requirement.

Interacted with product development teams for testing and verification of APIs (AOL loader

configuration files) of Oracle 11i Applications – NLS, translations.

Identified and documented the issues with Installing the Oracle 11i Applications using the Rapid

Installer (formerly known as One Hour Installer) in Single Node and Multi -node fresh environments

and applied the appropriate latest US-English maintenance pack (EBS11i). Also, applied the

respective NLS language maintenance pack to create MLS version of the Oracle 11i Applications.

Extensively used the Oracle 11i Applications DB character set conversions for the different NL S

language character sets and setting up the NLS parameters for the database.

Maintained the Applications-NLS (language) release status and executive MIS web pages.

Reviewed the Loader performance and testing the seed data upload with AOL generic loader and

other Native loaders, update and obtain fixes from WPTG (Oracle Product Translation Group) and

testing the translation components of seed data and generation of translated forms and reports

issues for the release of Oracle 11i applications Suite - NLS (28 languages), coordination and

obtain fixes for the respective issues from WPTG.

Created the Applications-NLS database for 28 languages for unit testing and Upgrade the

Applications-NLS from earlier releases to the current release with the AD tools like Auto Patch, Auto

Upgrade and follow up of issues with other teams of Oracle applications.

Upgraded the Oracle Applications and installed the E-Business suite with respect to NLS releases

and coordinated in resolving the functional issues with various internal teams.

Environment: Oracle Applications 11.0.3 to 11i (11.5.7), most of the modules of EBS.

MS - Applied Physics and Information Systems

University of Baroda - India

Contact this candidate