A njaneya Prasad.Dasari

acb5wi@r.postjobfree.com

650-***-****

Professional Summary:

• 10 years of diversified technical and Functional expertise in Oracle E-Business Suite (EBS)

A pplications11i, with extensive exposure in development of C ustom interfaces, AP Is, building

control files, dealing with Application Object Library, customizing forms, reports, OAF and workflows.

• Expertise in Technical and Functional aspects of Oracle E-Business Suite (EBS)applications Federal

F inance, Accounts Payables (AP ), Accounts Receivables (AR ), Purchasing (PO ), C RM, Supply Chain

and O rder to cash M odules which include Trading Community Architecture ( TCA ), Pricing (QP ),

AOL, General Ledger (GL ), Service Contracts, Install Base ( IB ), Inventory( I N V ) Cash Management

(CM ), Fixed Assets (FA),Project Accounting(PA), M anufacturing & HR MS.

• Well experienced in R eports, I nterfaces, Conversions and E xtensions (R ICE), I mplementation

and Support of various Oracle Apps modules. Involved in implementing versions/upgrades of Oracle

A pplications 11i, and recently involved in implementing O racle E-Business SuiteApplicationsR12

for Oracle Business.

• Extensive experience in Oracle backend objects like: Database Tr iggers, Stored Procedures, Functions,

and Packages using PL/SQL.

• Good experience in developing reports using R eports6i/9i/10g, Discoverer 9i/10g and XML

P ublisher .

• Expertise in developing forms using Forms 6i/9i/10g.

• Strong Knowledge in OAF personalization experience.

• Expertise in developing w orkflows.

• Experience in developing Install scripts, copy scripts and fnd load scripts using Shell programming.

• Experience in Import and Export utility, SQL* Loader .

• Expertise in data fixes and troubleshooting the issues.

• Strong familiarity with A I M standards and worked on MD50, MD70, CV60 and CV80.

• Experience in registering of Custom Applications/Table/Schemas in Oracle Applications.

• Capable of Performance Tuning, O ptimizing SQL and P L/SQL scripts.

• Experience in Log, view, access, monitor, follow up and close Service Requests (SRs) online -Oracle

M etalink .

• Good experience in creation of concurrent programs to execute requests viz.; reports, stored procedure,

shell script.

• Strong knowledge of order to cash (O2C ) and procure to pay (P2P ) business f lows.

• H ighly motivated self-starter with excellent communication, presentation and interpersonal skills, can

perform well both independently and with a team, always willing to work in challenging and cross-

platform environments.

T echnical Skills:

Oracle EBS applications 11i/R12 (AP, AR, GL, OM, PO, IB, SC, FA and CE).

ERP

Java, SQL, PL/SQL, C, C++.

Languages

Oracle 8i/9i/10g, MS Access, SQL Server 2000, MYSQL.

D atabases

HTM L, Java Script, JSP, MS Front page.

Web Tools

MS-Office.

O ffice

A pplications

Oracle Reports 6i/9i/10g, Oracle Forms 6i/9i/10g, Oracle Developer, OAF, Oracle

Tools

D iscoverer 4i/9i/10g, Oracle Workflow, TOAD, SQL Navigator, and Workflow

B uilder.

UN IX, & Linux, Windows98/XP, Windows NT.

Operating

Systems

Professional Experience:

Client: UF MS(Unified Financial Management System), SilverSpring, M D.

Sep 13 – tilldate

Working as a techno functional consultant in UFMS project analyzing GTAS, IPAC, SAM and PAM

t reasury mandates. Changing the custom solution designs to fi t t reasury mandates in Oracle Federal

F inance.

• Prepared BR 100 documents regarding setup changes and performing the configuration changes in

several development, test and production instances in Oracle Federal Vertical.

• U pdated As-Is Process Flows and F unctional Specification Design documents.

• Involved in t rouble shooting

• Analyzed custom value sets, personalizations, lookups for t reasury mandates impact and

recommended solutions for them.

• Analyzed impact on OpDiv Specific IDDA interface and proposed a Global IDDA solutions that fits

t reasury requirements.

• Completed design documents for Global IDDA interface.

• Supported FY 2013 Year end activities in monitoring the performance of UFMS Production system

• Performed QA on Global and OpDiv Specific Change requests and provided recommendation to deploy

t hem on t ime.

• Conducted/Participated in Solution Reviews for PMR's (Problem Management Records) and Working

G roup Sessions for GTAS

• Functional & Technical Analysis and Troubleshooting of post production issues on

various Business processes

Environment : O racle EBS Federal Finance Apps 11i, ORACLE 11g, PL/SQL, Toad 9, SQL*PLUS, UN IX.

Client: Allscripts, Atlanta, GA.

Sep 12 – Aug 13

Allscripts provides innovative solutions that empower all stakeholders across the healthcare continuum to

deliver world-class outcomes. The company's clinical, financial, connectivity and information solutions for

hospitals, physicians and post-acute organizations are the essential technologies that enable a connected

healthcare community. Allscripts is one of the largest companies focused exclusively on healthcare

i nformation technology, with over 5,500 employees and combined 2009 pro forma revenues of

approximately $1.2 billion. Allscripts team members will have streamlined access to accurate and reliable

client, product, financial, professional and HR data to sharpen decision making, business planning and

p roject execution.

Responsibilities:

• Designed Technical documents (CV60) and developed AR Conversions like Invoices, Receipts, and

Resources to bring data from different Legacy systems.

• Designed Technical documents (MD 70) and developed Cash Management Bank statement In terface

to load BAI2 files from different banks for reconciliations.

• Developed Custom form to maintain Voucher details, Cost Allocations and mapping to GL Accounts.

• Designed Technical documents and developed Conversions and In terfaces for GL to import Journals

f rom different systems.

• Developed OAF page to view and updated Customer credit rules for Customer holds and generate the

reports.

• Created JSP pages to upload files manually to run interface on demand.

• Created Dunning plans for sending custom letters via manual dunning process to 3rd party systems

• Customized OAF Controller class to change the labels by creating messages from Application

Developer and assigning default values.

• Publish dashboard reports on current projects and issues. Review escalated Issues and work with the

team to ensure a resolution plan.

• Provided Change Management on-call support for Emergency Changes. Processing CAB exceptions

efficiently.

• Involved in post Implementation support and providing t raining to end users.

Environment : O racle EBS Apps R12, ORACLE 10g/11g, PL/SQL, Toad 9, SQL*PLUS, UN IX.

Client: VMware I nc, Palo Alto, CA.

F eb 11 – Aug 12

VMware, the global leader in vir tualization and cloud infrastructure, delivers customer-proven solutions

t hat accelerate IT by reducing complexity and enabling more f lexible, agile service delivery. VMware

enables enterprises to adopt a cloud model that addresses their unique business challenges. VMware’s

approach accelerates the t ransition to cloud computing while preserving existing investments and

i mproving security and control. With more than 250,000 customers and 25,000 partners, VMware

solutions help organizations of all sizes lower costs, increase business agility and ensure freedom of

choice.

R ole: Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed Custom In terface programs using API’s to update Service entitlements and products in

Service Contracts.

• Developed Keystone – TCA-Detailed Customer Master Architecture.

• Developed forms to maintain Customer Volume Purchase Program (VPP), pricing benefits they can get

for future orders based on the points earned on existing orders.

• Developed Order import program to create different orders like ELA Order, Redemption, NFR,

Downgrade.

• Developed Zoom form in Order manger to get license details for the Customer.

• Issue resolution, incident management, coordinating with Business Analysts and end-users, attending

weekly review calls with business, developing hot fixes through e-CAB and taking part in the CAB

Review/Approval meeting.

• Customizing Order management workflows as per Business requirement.

• Created outbound Interface to inform consignment suppliers about the i tem demands.

• Handling quality metric management for t ickets by ensuring SLA is met and the key words are in

p lace for t ickets.

• Developed In terfaces and reports to accommodate generated f lat files to be t ransferred to external

systems using custom UT I L package.

• Customized several reports in OM, I NV and Telesales as per Business requirement.

• Developed Custom In terface programs using API’s to update Install Base Parties and Licenses.

• Customized Oracle standard report “Payables Account Analysis Report” to meet the business needs.

• Created PDF/EXCEL output’s for reports based on requirements.

• Created Data fixes in OM, SC, BOM and IB for issues.

• Developed deployment documents for data fixes.

• Developed Workbooks based on the Custom Folders and calculations using Discoverer Desktop.

Environment : O racle EBS Apps 11i, ORACLE 10g/11g, PL/SQL, Reports 6i/10g, Toad 9, SQL*PLUS,

U N IX.

Client: I TRON I nc, Spokane, WA.

J ul 10 – Jan 11

ITRON Inc. is the world’s leading provider of intelligent metering, data collection and utility software

solutions, with nearly 8,000 utili ties worldwide relying on technology to optimize the delivery and use of

energy and water. I t ron Inc. products include electricity, gas, water and heat meters, data collection and

communication systems, including automated meter reading (AMR) and advanced metering

i nfrastructure (AM I), meter data management and related software applications as well as project

management, installation, and consulting services.

Role: Oracle Applications Techno Functional Consultant

Responsibilities:

• Coordination of a 7-member development team, evaluate and implement changes to all customizations

and extensions.

• Prepared Functional and Technical design Document for Reconciliation Summary and detail report.

• As a technical lead in support analyst I handle escalated issues.

• Handled quality metric management for t ickets by ensuring they meet SLA and the key words are in

p lace for t ickets

• Managed all development aspects of an Oracle Applications 11.5.10.2 to R12.1.2 upgrade.

• Analysis COA changes (Client Requirement) impact after upgrading.

• Place all new alternate accounts in both setups and open t ransactions.

• Preparing unit test plan with COA changes and R12 futures.

• Worked on Period closure reconciliation Issues.

• Validating open t ransactions in all finance modules & matching the same with the GL balances, as

part of upgrade activity.

• Customized OAF pages by using personalization in iExpenses.

• Customized standard workflows in Project Accounting for approval hierarchy.

• Implementation of Search pages in OAF.

Discoverer (Admin, Desktop, Plus)/ XML Publisher / Report Builder / Forms:

• Responsible for modifying & creating Business Areas using Oracle Discoverer Admin for changed &

new reports.

• Created Workbooks based on the Custom Folders with multiple parameters and calculations using

D iscoverer Plus and Discoverer Desktop.

• Responsible for developing new reports in Oracle XML/BI publisher.

• Created output format in XML/BI, new templates for XML/BI Publisher to display the reports in client

requirement format.

• Created PDF/EXCEL output’s for reports based on requirements.

• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations

happen at the template level.

• Customizing the application forms to meet the specific business needs using built in features available

w ith (Template.fmb) form, built-in stored procedures and attached libraries.

• Involved in the design & development of user interface in Forms and table design using Oracle.

• Developed various Business and ad-hoc Reports.

• Extensively worked in tuning the SQL queries using Explain Plan, Tkprof, SQL*Trace.

• Involved in In terface designing and Documentation and implementation of these as per AIM.

Environment : O racle EBS Apps R12, ORACLE 9i/10g, PL/SQL, Oracle Workflow, D iscoverer, XML/BI

Publisher, UN IX.

C lient: Phonographic Performance Limited UK.

D ec 09 – Jun 10

PPL is a music industry organization collecting and distributing airplay and public performance royalties

i n the U K on behalf of over 3,000 record companies and 30,000 performers. The company also licenses

clubs, shops, pubs, restaurants, bars and grills. Over recent years PPL’s revenue has grown significantly

to exceed £80 million a year, which makes PPL the largest collector of this type of income in the world

today.

Role: Oracle Applications Techno Functional Consultant

R esponsibilities:

• Developed In terface by using API for creating Notes corresponding.

• Developing components for the M iddle Tier using COM implementing various business rules.

• Developed In terface by using API for creating Notes corresponding Customers and Leads.

• Developed In terface by using API for Converting Quotes to Booked Orders.

• Coordinate with Oracle Support determining the bugs incurred in 11i with EVENTS and counters and

f ix them applying appropriate patches. Resolved issue in Service pricing with oracle support.

• Documentation and maintenance of Technical work done.

• Resolving the issues on Telesales Module.

• Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving.

• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.

Customer Launch Pad

• The Customer Launch Pad will be the view that will combine all relevant Customer information like

L icense Details pane, All Notes pane, Transactions pane, Interactions pane and Outstanding Tasks

pane bring i t together in one screen, making i t easier and quicker for the PPL User to assess a

Customer’s details.

Amend Invoice Process

• PPL receives lot of changes to the quote from the customers, as the customer realizes they have

received invoice for a higher amount. So developed Amend Invoice Process to wri te off the old invoice

and create the new invoice.

Environment: O racle EBS Applications R12, Oracle Database 10g, Discoverer9i/ 10g, UN IX, BI Reports

and Forms.

Client: Phoenix Park Gas Processors Limited WI.

M ay 08 – Nov 09

PPGPL is an excellence driven, customer focused, T rinidad and Tobago Company whose core business is

natural gas processing, NGL aggregation, fractionating and marketing. The company maximizes the value

of the count ry’s NGL’s by delivering competitively priced, high quality products and services, operating i ts

physical assets in a safe, reliable, f lexible and efficient manner that preserves the environment and

p roactively pursues value-adding growth opportunities in its core business.

Role: Oracle Applications Techno Functional Consultant

Responsibilities:

• Developed In terface by using API for creating Notes corresponding.

• Developing components for the M iddle Tier using COM implementing various business rules.

• Developed In terface by using API for creating Notes corresponding Customers and Leads.

• Developed In terface by using API for Converting Quotes to Booked Orders.

• Coordinate with Oracle Support determining the bugs incurred in 11i with EVENTS and counters and

f ix them applying appropriate patches. Resolved issue in Service pricing with oracle support.

• Documentation and maintenance of Technical work done.

• Resolving the issues on Telesales Module, iprocurement and iexpense.

• Resolving the issues on PO components like Requisitions, Purchase Orders and Receiving.

• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.

• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and creating

i ndexes.

• Worked on creating application mode End User Layer, building business areas, and building

d iscoverer workbooks.

• Developed reports in AP, GL and AR modules using Reports9i.

• Buil t custom forms using TEMPLATE.FMB to fulfill the business requirements like implementing the

calendar feature, WHO columns, defining DFFs etc.

• Developed the Request sets that are scheduled to submit concurrent programs in a desired sequence

as per the functional document.

• Customizing the application forms to meet the specific business needs using built in features available

w ith (Template.fmb) form, built-in stored procedures and attached libraries.

• Involved in the design & development of user interface in Forms and table design using Oracle.

• Experience in customization of XML Publisher reports.

• Created output format in XML, new templates for XML Publisher to display the reports in client

requirement format.

Environment : O racle EBS Apps 11i, ORACLE 9i/10g, PL/SQL, Forms Reports 6i/10g, Toad 8, Discoverer,

X ML/BI Publisher.

Client: Agrotech Foods Ltd I ndia. Nov

07 – Apr 08

AGRO TECH FOODS L I M ITED is Rs1260 crores company with a dominant market position in the edible

oils and branded foods sector, in India. ConAgra Foods Inc of USA, world's third largest foods company,

a long with Tiger Brands of South Africa holds a majority stake of 51.3 per cent in Agro Tech Foods

L imited through CAG Tech Holdings, Mauritius With well-known brands like Sundrop, Healthy World,

ACT I I and Rath as part of its portfolio, the company has a dominant market share and value leadership

i n the refined oil segment, primarily led by its f lagship brand Sundrop.

Role: Oracle Applications Techno Functional Consultant

R esponsibilities:

• Defining the Approval Group by utilizing the Position H ierarchy.

• Customizing Accounting Flex Fields, Cross Validation Rules and Security Rules.

• Designing and development of customized object/programs in Oracle Database/Applications as per the

business requirements and Apps Schema standards.

• Setup t ransaction types, document numbers, and processing constraints.

• Implementing control points in business processes by developing Form Personalization.

• Created alerts, for sending mails to users and receiving response mails from users.

• Resolving the issues on OM components like Sales Orders and Sale Returns.

• Resolving the issues on AP components like Invoices, Payments, and Banks & Suppliers.

P rima ry freight

• Freight cost incurred on shipping the goods from Factories to Godowns is known as Primary Freight.

Custom Form was developed to capture the t ransaction and Concurrent program creates a provision in

G L for the freight amount

Secondary freight

• Forms and Concurrent Programs were developed to capture the Freight cost incur red on shipping the

goods from Godowns to Customers. Reports were developed for reporting Secondary Freight

t ransaction details and Exception details.

Environment: O racle EBS Applications Release 11.5.10.2 (CRM), Oracle Database 9i, SQL * Loader,

Reports 6i, Forms 6i.

C lient: SolFocus .

A pr 07 – Oct 07

SolFocus technology was developed specifically to overcome the cost and manufacturabili ty bar riers of

earlier solar approaches. The company’s technology combines the record-setting efficiency of multi-

junction solar cells with patented high concentration, compound-reflective optical design

Role: Oracle Applications Technical Consultant

Responsibilities:

• Creating Flex fields for Location, Defining Systems Option parameters

• Creating Customers, Profile Classes & Bank information

• Creating Distribution Sets, Receipt Sources, Receipt Classes & Payment Terms

• Defining Application Rule Sets, Auto Accounting Rules & Auto cash Rule Sets

• Creation of Transactions & Source and Customization of check printing report

• Importing Legacy Journals in General Ledger using SQL Loader and Journal Import

• Created BOM Interface using API.

• Created I tem and Invoice Interfaces

• Developed interface programs to integrate Legacy System with the AR module to import customer

i nformation using the Customer Interface. Defined descriptive f lex fields

• Testing and Code review.

• Implementing control points in business processes by developing Form Personalization.

Environment: O racle EBS Apps R12, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Oracle 9i, TOAD

and UN IX.

C lient: Power wave Technologies.

F eb 06 – Ma r 07

Power wave Technologies, Inc., is a global supplier of end-to-end wireless solutions for wireless

communications networks. Power wave designs, manufactures and markets antennas, boosters,

combiners, fil ters, repeaters, mult i-carrier RF power amplifiers and tower-mounted amplifiers and

advanced coverage solutions, all for use in cellular, PCS and 3G networks throughout the world.

Role: Oracle Applications Technical Consultant

Responsibilities:

• Developed Invoice Report in XML Publisher.

• Created Discrete Job Pick List Report using in XML Publisher.

• Created the RMA Received Report using Discoverer4i.

• Created PWAV Commercial Invoice Report in XML Publisher.

• Customized And Developed Many Forms as per Different Client Requirements.

• Created Procedures in Custom.pll.

• Created Personalization in WIP and I NV.

• Supporting Production Issues for Inventory, Order management, Install Base and Payables.

• Created Alerts as per Client Requirement.

• Developed Reports in Project Accounting Module by using Discoverer tool.

• Developed I tem Cost In terface to update the I tem Costs.

Environment : Oracle EBS Applications Release 11.5.10.2 Toad, Shell Scripts, SQL, PL/SQL, Oracle,

O racle Reports 4i, Windows NT/XP.

Company: Tulips Corporation, I ndia.

J un 04 – Jan 06

C lient: H D FC Bank

R ole: Oracle Applications Technical Consultant

HDFC Bank was entrusted with the task of implementing Financials, Purchasing & HRMS modules. The

business driver for implementing E-business 11i was to improve process efficiencies, reduce wastage &

i ncrease operational productivity. These Services helps to improve business performance by designing and

i mplementing strategically aligned organizational, service delivery and business process improvements

across the enterprise. The modules implemented include implementation, testing and production support

of Financials, Purchasing and HRMS.

Responsibilities:

• Developed interface programs for upload of GL In terface from legacy system after validate the data.

• Created HDFC AP Withholding Tax Report.

• Created HDFC GL Tr ial Balance Report.

• Customized Standard Reports in AP, PO in D2K.

• Developed New Reports in GL and AP in D2k.

• Conversion of data from legacy system to Oracle application system by using SQL* Loader.

• Developed New Audit Detail Reports.

• Developed Reports in Property Manager Module by using Discoverer tool.

Environment : Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 4i, Windows NT/XP.

C lient: I nnovent Solutions.

A pr 03 –May 04

F inancial Accounting System takes care of entire financial related matters. In this package we include

Bank Accounting, Purchase Accounting, Sales Accounting, Marketing & General Accounting module with

E xcise & Tax account. This system is an online system, which will take care of all data posting same t ime

of data entry. All are internally correlated to each other for data integrity and to avoid duplication of data

entry.

Role: Oracle Developer

R esponsibilities:

• Generation of required reports using Reports 6i.

• Worked with Menus, PL/SQL Libraries.

• Design and development of user interfaces using Forms.

• Developed database Packages, stored procedures & functions for handling batch posting operations.

• Performance Tuning of SQL statements and stored procedures.

• Involved in code review, Code walk through, Unit testing etc.

• Involved in meetings with the client to deliver an efficient system.

• Integrating various modules of the project.

Environment : Toad, Shell Scripts, SQL, PL/SQL, Oracle, Oracle Reports 4i, Windows NT/XP.

E ducation: M aster of Computer Management.

Contact this candidate