sr.oracle applications Techno-functional Consultant

PREETHI R ANANDULA

Email: ********.*******@*****.***

Cell: 361-***-****

SUMMARY:

. Over 8 years of experience in Information Technology, involving in

Analysis, Design Development and documenting of Oracle Applications

Implementations.

. Experience in 2 Full Cycle ERP Implementation's and various CEMLI's in

11i.

. Worked Extensively on RICE components (or CEMLI's) (Reports,

Interfaces, Conversions and Extensions) and Oracle AOL objects.

. Extensive experience in customizing and implementing Oracle

applications (EBS) 11i .

. Knowledge of Oracle R12 (Customers Online module).

. Knowledge in Manufacturing, pharmaceuticals, Communication and fuel

industry domains.

. Worked on Production support for full cycle implementation.

. Experience in requirement gathering and using Oracle AIM methodology

(MD120, MD 70, RD60, and CV 40, CV 60 etc.) to document the

requirements.

. Worked on Oracle EDI 940,945,850,855 and 810.

. Experience in SIT and UAT testing cycles.

. Experience in working on projects individually and as part of teams as

big as 30 people.

. Experience in working with business users as well as through BA's and

team leads on projects.

. Experience in Technical, Techno-functional, BA and Production support

roles.

. knowladge of XML/BI PUBLISHER tools.

TECHNICAL SKILLS:

SOFTWARE SKILLS SUMMARY

Oracle Applications 11i Oracle Database RDBMS versions

9.0.2, 8.0

SQL* Plus 8.0, Oracle 9i PL/SQL SQL* Loader 9.0.2

Language

Developer Suite Oracle Reports 6i/9i

Discoverer 4i/9i /10g SQL * Trace 8.0.x

ORACLE APPLICATIONS 11i EXPERIENCE SUMMARY

Oracle Supply Chain Management Oracle Financials Modules

Order Management, Purchasing AP,AR,GL

Oracle Manufacturing Modules Others

Shipping, BOM, OPM, Inventory TCA, Oracle Internet Expenses,

Oracle Engg

VERSIONING TOOLS: Mercant PVCS, Serena, Dimension Express

O.S. ENVIRONMENT: UNIX, Sun Solaris VMS, Windows XP/NT/95/XE

EDUCATION: Bachelors in Electrical Engg, Madras University, Madras, India.

Sept' 96 - April' 00

Masters of Electrical Engg, Texas A&M

University, Texas, USA. Jan' 03 - Dec' 05

TECHNICAL EXPERIENCE:

Hussmann, Bridgeton, MO.

Domain: Manufacturing

August 2012 to December 2013

GEAC Project (project 1):

Task: Converting legacy data into Oracle

Role: Sr.Oracle Application Technical Consultant / Production Support

Accounts Receivable Technical Responsibilities:

. Developed outbound interface from Oracle to BAS Mainframe Interface.

. Developed outbound interface from Oracle TO AR Workflow Customer

Data.

. Developed legacy interface Oracle to VSAM Legacy system Interface

. Worked on system administration activites such as registering value

sets,flex fields,interfaces, concurrent programs.

. Worked on forms Personalization.

. worked on importing AR legacy invoices into Oracle.

. used sql loader for data loading.

. used third party tools such as Serena and Dimension express to Migrate

code of technical objects and AOL objects from Development,test

environment to Production environment.

. worked on performance tuning Of code.

. worked on production support issues of code.

After Market Parts Project (project 2):

Task: ERP Full Cycle Implementation

Role: Sr.Oracle Application Functional Consultant

Responsabilites:

. Analyzesd, documented, evaluated and tested current business systems

to create Business Requirements Documents for the IT Development

department.

. Consulted with business unit management and personnel to identify and

document business needs and objectives, current operational

procedures, problems, input and output requirements, data scope,

usage, formatting, and security requirements.

. Guided the business in implementing best practices in their business

processes and effective usage of tools and technologies employed.

. Provided business level technical assistance in identifying,

evaluating, and developing systems and procedures

. Has in-depth knowledge of commonly used concepts, practices, and

procedures for conducting business analysis and is proficient in

conducting business requirement sessions. Consulted with business

unit management and personnel to obtain additional information during

system development and evaluate alternatives.

. Developed detailed documentation of descriptions of user needs,

program functions, and steps required to develop or modify systems.

. Co-ordinated with programmers to design and develop automated business

systems.

. Developsed, coordinated, tested, and implemented plans to test

business and functional processes during system development and

quality assurance testing.

. Tracked and documented changes to functional and business

specifications.

. Assisted others in the writing of user documentation, instructions,

and procedures.

. Monitored and documented post-implementation problems and revision

requests.

. Resolved Production support Issues in supply chain management and

Finance modules.

. Responsible for changing Auto-Accounting Design setup.

. responsible for setting up new transactional types.

. worked on Auto-invoice setups.

. responsible for setting up new customer setups, clean up of old

Customer setups and migration of legacy customers into oracle in TCA.

. In Collaboration with the finance management team, gap analysis was

done once the existing business and the to-be processes were mapped

out.

. Project timelines were setup based of the results from the discovery

process.

. Oversaw the testing of AR functional setups and technical objects with

Finance business users in SIT and UAT .

. responsible for migration of custom objects and Functional Setups to

Production and setting up the scheduling of the standard and custom

concurrent program.

Environment: Oracle EBS 11i, Purchasing, OM,Shipping, AR, TCA, Oracle

PL/SQL, Serena, Dimension Express.

Peco Facet, Mineral Wells, TX, Domain: Manufacturing

February 2012 to May 2012

Role: Sr. Oracle Applications Techno-Functional Consultant

Task: Work on production issues and various functional projects.

Functional/Business Analyst Responsibilities::

. Conducted a Business Process Review for Purchasing and Engineering

Departments.

. Developed the functional and technical documentation based on the

requirements gathered.

. Testing of the deliverables was done with the business users and

timelines were met.

Technical/Production Support Responsibilities::

. Worked on Requisition's issues involving Price lists which were not

turning into sales orders.

. Set up Burn Pattern Number in oracle for the Drafting department to

streamline the process and reduce the redundancy and add the BP number

to the Cut Sheet report for the Engineering Department, EDM and Shop

floor's usage.

. Worked on the internet expense reports issues which were failing in

the Oracle internet Expense import program.

. Created a custom menu for Order Management Super with the Projects

View only responsibilities.

. Added new INCO terms to the existing Freight terms on the Purchase

Order and Sales Order.

. worked on Oracle AOL objects.

Environment: Oracle EBS 11i, Oracle Advanced Pricing, BOM, Purchasing,

OM,Shipping, Oracle Internet Expenses, Oracle Engineering,TCA, Oracle

PL/SQL, WINDOWS NT 4.0.

Dendreon, Seattle, WA, Domain: Pharmaceutical

June 2011 to Dec. 2011

Role: Sr. Oracle Applications Techno-functional Consultant

Task: Developed Operational and Management Reports in Oracle Discoverer for

CEO and IMF directors.

OPM:

Functional Responsibilities:

. Analyzed the existing data structure and evaluated the integrity of

data.

. Made recommendations to improve integrity of data.

. Communicated with the users while gathering the reporting requirements

and validating them against their existing business processes and made

suggestions to improve the efficiency of the existing business

processes and .

Technical Responsibilities:

. Gathered and elicited information from existing business processes and

supporting systems for documentation and creation of reports.

. Developed functions and package for the calculations being used in the

reports to improve performance of the reports as well as to avoid the

redundancy in the database.

. FDA approved environmentenvironment cGMP, cGDP and 21 CFR part 11.

. worked on Oracle AOL objects.

. Created appropriate documentation in work assignments such as

functional requirements (MD 50 and MD 70) documents and business

process flows.

> Purchase Price Variance Report

> Item Usage Variance Report

Environment: Oracle EBS 11i,TCA, Oracle OPM, Purchasing, ONT, WIP, GL, AP,

INV,Oracle PL/SQL, WINDOWS NT 4.0.

US Steel, Pittsburgh, PA, Domain: Steel

March 2011 to May 2011

Role:Sr. Oracle Applications Techno-functional Consultant

Responsibilities Included:

R12 Customers Online Governance:

. Worked on R12Customers online governance.

. Created customers and sites in R12 customer's online governance.

OPEX and CURE:

. Worked on Production support Issues for Customers from Customers

online to OPEX and to CURE.

. Worked on data mapping for R12 Customers online for Europe segment for

US Steel.

Environment: Oracle EBS R12, Oracle Customers Online, Oracle PL/SQL,

WINDOWS NT 4.0.

Otsuka Pharmaceuticals, Rockville, VA, Domain: Pharmaceutical

December 2010 to February 2011

Role: Sr. Oracle Applications Technical Consultant

Task: Worked on EDI 940,945,850,855 and 810 and developed Oracle reports.

Responsibilities Included:

Oracle EDI:

. Developed Oracle EDI interfaces 940,945,850,855 and 810.converted into

X12 format using a third party vendor.

. worked on Oracle AOL objects.

. Created reports in Oracle reports 10g

> MDD Kit Order Details Report

> Shipping exception report

Environment: Oracle 10g, Oracle EBS 11i, ONT, PO, Shipping, EDI, Oracle

PL/SQL, Oracle Reports 10g,WINDOWS NT 4.0.

American Red Cross, Ashburn, VA, Domain: NON - Profit

July 2010 to October 2010

Role: Sr. Oracle Applications Techno-functional Consultant

Task: Develop outbound interface from oracle which extracts and emails the

newly added customer information to legacy system.

Responsibilities Included:

TCA :

. Designed and developed Customer Outbound Interface (RICE).

. Designed and developed UNIX shell script to run the concurrent program

through the UNIX script.

. Developed custom mail package to send the output of the packages as an

attachment to the email to the users and also worked with UTL SMTP

Package.

. worked on Oracle AOL objects.

Environment: Oracle 10g, Oracle EBS 11i, AR, TCA, Oracle PL/SQL, Oracle

Reports 10g,WINDOWS NT 4.0.

World Fuel Corporation. Miami, FL, Domain: Fuel Vendor

September 2008 to May 2010

Role: Sr. Oracle Applications Technical Consultant

Task: ERP Implementation Project (Order to cash Process, Item master

Conversion, Oracle discover Reports)

Responsibilities Included

. Worked on Reports, Conversions and Interfaces (RICE) in a Full cycle

ERP Implementation.

Order to cash:

. Designed and developed open sales order conversion.

Item Master Conversion:

. Designed and developed conversion programs for converting approx.

250,000 items for six different organizations.

Oracle Discoverer 10g:

. Developed Various Custom Reports as per the client requirements using

Discoverer 10g.

Oracle Reports 6i:

. Gathered requirements and developed WFS Order Entry RMA Report

. Customized WFS Pick slip Report and WFS Packing slip Report

Environment: Oracle Applications (EBS) 11i (11.5.10), AR, AP,BOM,

WIP,INV,GL, ONT, HR, ORACLE 9i, PL/SQL, Discoverer 10g, Oracle Reports 6i,

Windows NT 4.0.

Atrium Companies Inc. Dallas, TX. Domain: Manufacturing

April 2008 to August 2008

Role: Sr. Oracle Applications Technical Consultant

Task: Develop AR reports in Discoverer, Purchase Order Lines Requisition

process

Responsibilities Included:

Order management:

. Focus on querying the data associated with purchase order lines

requisition receipts and revision information to find the data issues.

. Monitor and manage programs in the Application Object Library that run

all above processes transfer files to and from Oracle and have

incoming files properly loaded into the Oracle Applications database

(Concurrent Manager).

Discoverer 10g Reports:

> AR Aging detail and Summary Report.

Environment: Oracle Applications (EBS) 11i (11.5.10), AR, ORACLE 9i,

PL/SQL, Discoverer 10g, Oracle Reports 6i, Windows NT 4.0.

Cricket Communications, San Diego, CA, Domain: Tele Comm

June 2007 to March 2008

Role: Sr. Oracle Applications Tech Consultant Task: Conversions, Oracle

and Discoverer Reports

Responsibilities Included:

Oracle Conversions:

> Order Import conversion

> Order to Cash cycle.

Discoverer 9i Reports:

> Developed discoverer reports based on Noetix views.

Oracle Reports 6i Reports:

> Supplier Analysis Summary Report

Environment: Oracle Applications (EBS) 11i (11.5.9), OM, INV, PO, AR, AP,

BOM, WIP, ORACLE 9i, PL/SQL, Discoverer 9i, Oracle Reports 6i, Windows NT

4.0.

Dell,Austin,TX, Domain: Manufacturing

February 2007 - May 2007

Role: Oracle Applications Tech Consultant, Task: Reporting and conversions

Oracle Discoverer:

. Oracle Discoverer Administrator and Oracle Discoverer desktop

Oracle Reports 6i:

. Shipment-planning report.

Oracle Conversions:

. AP Closed Invoice Conversions (invoices, invoice distributions and

invoice payment schedules.

. Oracle Inventory (Items Conversions)

Environment: Oracle Apps 11.5.5 (AP, AR, BOM, PO, INV, Shipping), Oracle

8.1.7, Oracle Reports 6i, Discoverer 4i.

Aventine Renewable Energy Inc. Pekin, IL, Domain: Energy

December 2006 - January 2007

Role: Oracle Applications Tech Consultant, Task: Reporting

Responsibilities Included:

Discoverer 10g Reports:

. Was responsible for the Oracle Discoverer Administrator and Oracle

Desktop

. Contract Gallons Summary Report.

. BSA System Monitoring Report.

Oracle Reports 6i:

. New Business Order Report.

Environment: Oracle Applications 11i (11.5.10), AR, AP, GL, ONT, ORACLE 9i,

PL/SQL, Discoverer 10g, Oracle Reports 6i, Oracle Forms 6i, Windows NT 4.0.

PROQUEST Information & Learning, Ann Arbor, MI

March 2006 - November 2006

Domain: Information & Learning

Role: Oracle Applications Technical Consultant

Task: Conversion and Reporting

Responsibilities Included:

. As per Oracle Methodology, Created CV40, CV60, RD60 and MD120

documents for the conversion and interface programs.

. Developed Financial Statement Generator (FSG) reports for users for

analysis purposes.

Conversions:

. Order Import interfaces

. Worked extensively in Order to Cash cycle.

. custom conversion program for Vendors and Vendor details

Discoverer 9i Reports:

. Vendor Analysis Report.

. Orders On hold Report

. Customer info Report

Oracle Reports 6i Reports:

. Supplier Analysis Summary Report

. Supplier Analysis Detail Report

ADI Reports:

. Cost Center Summary report

. Cost Accounting Format report

Environment: Oracle Applications 11i, AR, AP, GL, INV,ORACLE 9i, PL/SQL,

Discoverer 9i, FSG, Oracle Reports 6i, Oracle Forms 6i, Windows NT 4.0,

ADI.

Contact this candidate