Oracle Sales

Mahesh Vaddi

ablitr@r.postjobfree.com

Ph :504-***-****(Mobile)

WORK EXPERIENCE

Oracle ERP Techno-Functional Consultant with emphasis in RICE (Reports,

Interfaces, Conversions and Extensions), Over 14 years of Oracle experience

primarily in Oracle ERP (GL, AP, AR, FA, Loans, PO, HR, INV, OGA, PA,

Federal Financials modules), Very strong in the design and development of

commercial and business applications. Involved in the full lifecycle of

Requirement Analysis, Gap analysis, Gap Solution, Setups Technical Design,

Development, Implementation and testing, post-implementation support,

customizing existing applications, Application Migration, Application

upgrades.

Worked for the following Clients/Companies.

IBM

CMS (Centers for Medicare & Medicaid Services)

Oracle Corporation

BearingPoint

BAE Systems/United Defense

BellSouth

Nordstrom Inc.,

The Great Atlantic & Pacific Tea Company (A&P)

Dartmouth College

West Virginia University (WVU)

Oregon Health Science University (OHSU)

Southern Illinois University (SIU)

IMMIGRATION STATUS

US Citizen

TRAINING

Oracle Release12

OBIEE

Oracle 11i HRMS Implement Oracle HR and Payroll (US).

Oracle Workflow.

Oracle Grants Management.

SKILLS HIGHLIGHT

Oracle Products: Oracle Applications R12/11i (11.5.1,

11.5.3,11.5.4,11.5.7,11.5.8,11.5.9,11.5.10,R12)/ 10.7 SC / NCA, 11.0.3,

Accounts Receivables, Accounts Payables, General Ledger, Oracle Federal

Financials, HR/Payroll, Fixed Assets, Grants, Oracle Loans, Application

Object Library, Inventory, Bill Of Materials, Oracle Purchasing, Order

Entry, Order Management, System Administration, Customer Care, Service for

Communication, Labor Distribution, R11i Oracle Workflow, SQL* Plus

3.x/8.x., Developer 2K (Forms 4.5/ 5.0/6i - Reports 2.5/ 3.0/6i). SQL*

Loader, Export, Import, Explain Plan, TKPROF, SQL* Report, Designer6i,

Discoverer 10G/4.x, XML Publisher, Oracle Workflow.

Operating Systems: UNIX (Solaris 2.51, HP-UNIX 9.x, AIX 4.3.3), MS Windows

NT V4.0, Windows 2000/98/95/3.1, MSDOS 6.22

Languages: SQL, PL/SQL, C, PASCAL, FORTRAN

Databases: Oracle 7.x/8.x/9i/10G, MS SQL Server 6.0

Specialty Skills: Data Conversion/Migration, Forms Customization,

and Reports Customization.

Methodologies: Oracle Applications Implementation Methodology (AIM)

2.0.

Communications: Excellent verbal and written communication skills.

Other Products: BP LINK SC, MS Access97, MS SQL Server, TOAD, and SQL

Navigator 3.2, VB 4.0/5.0, and Access 97.

PROJECT EXPERIENCE

Apr'08 - Till Date

IBM / CMS (Centers for Medicare & Medicaid Services), Linthicum, MD.

Responsibilities:

. Currently working on Oracle Federal Financials (AR, AP, Loans, and GL)

applications support/development project for CMS (Centers for Medicare

& Medicaid Services).This project is being implemented and currently

supported by IBM.

. Extensively worked on XML (BI) PUBLISHER reporting in AR and Loans

Modules. Developed .PDF and .XML reports as a part of XML reporting.

. Developed/Customized CUSTOM (custom.pll) libraries to implement

changes in the Oracle receivables transaction and adjustment FORMS.

. Developed new custom Oracle Form (CMS Cascade AR Statuses) for Mass

Update of Custom AR status linked to the AR transactions using

Forms6i. Created and registered Custom Menu's and Custom Messages as a

part of form development.

. Developed/Customized the below reports as a part custom development in

Receivables and Loans Modules using reports6i.

AR Aging buckets report

AR Overpayments Report

Unapplied Receipts Register Report.

Loans Oversight Summary Report

Loans Oversight Details Report

Customer relationship listing report

935 Appeals Report

DCIA Report

. Customized the Claims processing interface that will create AP

Invoices and AR Invoices with the claims data from shared systems to

change the current fund account mapping logic in oracle.

. Conducted seminar on Oracle FORMS personalization.

. Conducted seminar on Custom Letters and supported the customization as

an SME.

. Resolved several MNT's (Manage Now Tickets) and Remedy Tickets as a

part of Production Support and implemented several HCR's (HIGLAS

Change Requests) as part of new development activities.

. Modified the Custom Letter Generation process as per the user's

requirements and also resolved the various issue with letters in

various instances.

. Modified the existing AR/AP interface programs to load the Medicare

claims data into Oracle Payables and Oracle Receivables.

. Customized AR/AP Netting FORM as per clients requirements.

. Assisted in development of custom interface program to run multiple GL

Interface processes simultaneously.

. Extensively used the Rationale tools like Clear case and Clear quest

during the development process.

. Creates TAR's (SR) with Oracle Support in resolving issues with oracle

Loans module and XML publisher reports.

. Created several Technical and Functional documents during the new

development tasks.

. Conducted Solution Review, Peer Review, and PE Review meetings for

reviewing Documents, Code and process performance.

. Performed analysis and testing for CPU Patches released by Oracle in

development and patch instances before deploying into production

instance.

Nov'07 - Apr'08

BearingPoint/Dartmouth College, Hanover, NH.

Responsibilities:

. Worked on support for Oracle11i Applications (GL, AP, AR, and OGA,

PA).

. Developed invoice templates and integrated them with BPA/AR

applications.

. Developed several custom reports to print output in PDF using Oracle

reports and Oracle XML PUBLISHER. These reports included several

LOGOS.

. Developed XML Data Templates and RTF Layout templates as a part of

reporting using XML PUBLISHER.

. Developed custom programs to Update Key Members information in Oracle

Project accounting and Grants Accounting modules.

. Provided the testers with various test cases to test the developed

programs/reports in UAT (User Acceptance Testing).

. Extensively used AOL and SYS ADMIN modules to integrate the

developed/Customized programs with Oracle applications in appropriate

modules, responsibilities and request groups.

. Designed and Developed conversion programs using PL/SQL, SQL*Loader to

load GL Balances data into GL through GL interface.

. Interacted with Oracle support to raise new SRs for resolving issues

encountered during the process of conversion.

. Delivered the Functional (MD 50, MD 200) and Technical Documents

(CV200, MD70) besides the code development.

May'07 - Nov'07

SITEL/Answerthink, Nashville, TN.

Responsibilities:

. Worked on Oracle11i Applications (GL, FA, AP, and AR) for a merger.

Client Logic, which is currently on Oracle bought another company,

called SITEL, which is in Lawson. The new company after merger is

named as SITEL and they decided to use Oracle going forward replacing

the Lawson.

. Developed conversion programs to load GL Transactions data from

Lawson financials applications into Oracle General Ledger through GL

interface.

. Developed several custom reports like AP Voucher, AP Check Voucher, AP

Invoice Print to print output in pdf and word using Oracle reports and

ORACLE XML PUBLISHER.

. Developed conversion programs to convert Fixed Assets from Lawson into

Oracle Assets through Mass Additions Interface.

. Developed custom programs to load Bank details from Lawson into Oracle

Payables.

. Designed and Developed program to load Vendor, Sites and Contacts

details from Lawson into Oracle Payables using the standard oracle

interface programs.

. Developed custom program to load AP invoices coming from an Access

based Telecom Database into Oracle Payables through payables open

invoice interface.

. Developed Custom reports using Discoverer 10G.

. Provided onsite training for the developers on Oracle Reports and

Discoverer 10G at the client site.

. Customized form functionality using FORMS personalization.

Dec'06 - May'07

BAE Systems/United Defense, York, PA.

Responsibilities:

. Worked on a new implementation of Oracle11i Applications (GL, AP, AR,

FA, INV, HR and PO).

. Designed and developed the conversion program to convert accounting

data from the legacy (cullinet) system to Oracle General Ledger using

GL interface/Journal Import program.

. Developed the Conversion program for converting Vendors and Open

Invoices data from legacy into Oracle Accounts Payables.

. Designed and developed the conversion program to convert the Customers

data from legacy into Oracle Accounts Receivables using Customer

interface.

. Developed conversion program to convert the entire inventory Items

into Master and child Organizations into Oracle Inventory application

using SQL*Loader and PL/SQL.

. Developed inactive vendors report using XML publisher.

. Designed and developed conversion program to load RFQ's from their

legacy system into Oracle Purchasing.

. Customized Journal Entry form to disable Approve Button using FORMS

personalization as an alternative to CUSTOM.pll customization.

. Developed conversion program to convert all the fixed assets from

Legacy Cullinet system into Oracle assets through Mass Additions

Interface.

. Customized Fixed Assets Account Generator using ORACLE WORKFLOW to

capture the Cost Center segment from distribution level instead of

Default for Book and Categories types.

. Involved in setting up prerequisites for the conversions like Asset

Categories, Payment Terms etc.

. Developed several reports in Fixed Assets using Oracle reports and

Oracle Discoverer 10G.

. Developed conversion program to convert all the employees from

Peoplesoft into Oracle using Oracle API's.

. Developed a program to terminate the employee using HR API based on

date in one of the DFF that came from PeopleSoft.

Nov'06 - Jan'07

RH Donnelly., Cary, NC

Responsibilities:

. Worked on a new implementation of Oracle11i Applications (AR, GL, AP,

HR, and Payroll).

. Designed and Developed conversion programs to load customers data into

Oracle Accounts receivables from legacy system using customer

interface.

. Developed conversion program to load all the Vendors, Sites and the

Open Invoices from Legacy system to Oracle Payables.

. Developed Employee demographic extract that pulls the data from Oracle

HR tables.

. Developed Payroll data extract to pull the bi-Weekly payroll data to

feed the same to Keystone where commissions are calculated.

Jun'05 - Dec'06

Nordstrom Inc., Seattle, WA.

Responsibilities:

. Worked in Development and Production support at Nordstrom Inc., in

resolving the Service Requests and Service Calls raised by various

business users across the company in Oracle 11i(11.5.10) Financial

(GL, AR, AP, FA, PA, HR) Applications.

. Developed PL/SQL programs to bring the lockbox data into Oracle

Receivables. Converted the AR Invoices information into Oracle using

Auto invoice interface in AR.

. Developed custom report for Invoice Printing, which includes LOGOS to

replace the legacy invoice printing.

. Designed all the inbound and outbound interfaces between Oracle and

Concur(Expense Management System).These interfaces include GL Code

combinations interface, Supplier Interface, HR Employee interface,

Payables Expense/Invoices Interface.

. Defined custom responsibilities and menus using AOL and SYS ADMIN

modules.

. Developed ACH Forecast reports to forecast the payment dates that help

the treasury department to keep sufficient funds in Bank before the

payment date for ACH withdrawal.

. Developed outbound interface programs from Oracle Fixed Assets and

Oracle Projects to Load data into COGNOS Budgeting Tool.

. Developed outbound interface program to load data from Oracle Payables

to Montrose System identifying the Duplicate Payments.

. Developed Conversion and Interface scripts to upload Bank information,

Supplier information, and GL Budget information.

. Developed several Oracle and discoverer reports as per the clients

business needs using Discoverer4.0.

. Developed several Custom reports like Supplier De-Activation Report,

Nordstrom Positive Pay Report, Nordstrom Supplier Audit Report to name

a few as per the user's request in reports6i.

. Developed several reports to print the report output in XML.

. Developed Custom libraries (custom.pll) to manipulate People form

functionality using forms6i.

. Tuned PL/SQL queries in packages to improve performance of the

outbound interface in GL.

Dec'04 - Apr'05

School Specialty Inc., /Oracle Corporation Appleton, WI.

Responsibilities:

. Designed and developed the following Conversions/Interface programs in

Oracle11i (11.5.9) Applications (OM, AP, AR, PO) modules.

. Customers (Conversion and Interface)

. AR Invoices

. Lockbox (Conversion and Interface)

. Sales Orders

. Supplier/Vendors (Conversion and Interface)

. Payables Open Invoices

. PO Receipts

. Purchase Orders

Sep'04-Dec'04

County Of San Diego/CSC, San Diego, CA.

Responsibilities:

. Supported the client on postproduction issues for the Oracle 11i

(11.5.8) Applications (GL, FA, AP, AR, INV, PO, Grants).

. Developed custom reports in reports 6i and Discoverer4 to replace their

legacy reports from kronos system.

Jul'04-Sep'04

Technicolor, Ontario, CA.

Responsibilities:

. Implemented Oracle 11i (11.5.9) Financial Applications (GL, AR, AP, FA)

for ROME.

. Worked on Customers interface, Auto Invoice, Lock Box Interface in AR

. Converted Suppliers Data and Open Invoices in AP.

. Customized the Dunning letters in AR.

. Customized several reports in GL, AP, AR, and FA to include the Italian

descriptions in the output using reports6i.

Apr'04-Jun'04

Maverik Country Stores, Afton, WY.

Responsibilities:

. Worked on Implementation of Oracle 11i (11.5.9) applications (AP, OM, AR,

PO, GL, INV, and BOM) for "Maverik Country Stores" which owns 170 Retail

stores across the country.

. Converted the data for

Suppliers,

AP Invoices,

Customers,

AR Invoices,

Open Sales Orders,

Inventory Items,

Item costs,

Bill of Materials,

Item On hand Quantities,

Approved Suppliers Lists

From their legacy (AS400) system into Oracle applications.

. Developed PL/SQL, and SQL*Loader scripts as a part of conversion process

to import the legacy data into Oracle applications tables.

. Interacted with the end users for mapping the legacy data to the Oracle

tables.

. Extensively used Discoverer4.0 and Oracle Reports for developing new

reports and customizing the existing report.

Apr'03- Apr'04

County Of San Diego/CSC, San Diego, CA

Responsibilities:

Implemented Oracle 11i (11.5.8) Applications (GL, AR, FA, AP, PO, Grants).

Developed custom programs to resolve post clone issues between different

Oracle Applications instances.

Developed and customized reports in GL, FA, AP, PO, and Grants using

reports6i.

Developed and Customized Discoverer reports in GL, FA, AR, AP, PO, and

Grants using Discoverer4.0.

Developed Custom reports for monitoring the Workflow exceptions.

Dec'02-Apr'03

USANA Health Sciences, Salt Lake City, UT.

Responsibilities:

. Worked on Implementation of Oracle 11i (11.5.8) applications (AR, AP, GL,

PO, INV, BOM, and MRP) for a pharmaceuticals company.

. Converted the data from the legacy (RENCS) system for the following into

Oracle applications for various organizations.

Vendors

Purchase Orders

Customers

AR Invoices

Inventory Items

Item Costs

Item Revisions

Forecasts

Bill of Materials

Routings

Lots

On hand Quantities

UN invoiced Receipts.

These conversions are done for US, CA, JP, AUS, NZ and TAIWAN.

. Created PL/SQL, and SQL*Loader scripts as a part of conversion process to

extract the legacy data from their existing applications and loaded them

into Oracle applications tables.

. Interacted with the end users and functional architects for mapping the

legacy data to the Oracle tables.

. Interacted with Oracle Support in regards to opening new TAR's (Technical

Assistance Requests) and resolved various issues.

. Developed and Customized Reports for users using Reports6i and

Discoverer4.0.

. Extensively used AOL and Sys.Admin modules for set up of various

concurrent programs, Request sets, and Valuesets and Descriptive

flexfields.

May'02-Nov'02

West Virginia University/Bearing Point, Morgantown, WV.

Responsibilities:

Worked on upgrade of Oracle 11i (11.5.3) Financial (AP, GL, PO, LD, HR,

Grants) for West Virginia University.

* Customized ALERTS in Requisitions and Purchase orders as per the client's

requirements.

* Modified the Vendors conversion program from Mainframe to Oracle during

the upgrade.

* Developed strategies for the successful conversion of Grants information

from the Client's legacy systems to Oracle. Responsible for coding data

conversion and migration programs to capture all the elements of Grants

module - awards, projects & tasks, project funding, budgets, expenditures

and Invoices

* Developed custom code to convert data from LD to Grants Interface table

and eventually loaded the data into Grants base tables through Transaction

Import Process

* Converted all custom reports from the version 2.5 to 6i as a part of 10.7

to 11i upgrade.

* Customized Expenditure reports (269,270,272) and invoice reports (1034,

1035) as per the state government rules that apply for this university.

* Customized billing extension process using client's business rules.

* Involved in the customization of "LD Costing Extract" that populates the

custom Oracle tables with the data from LD tables and custom tables in post

payroll process for sending files to the State.

* Created a "FTE process" to send the FTE files to State Dept. of Budget

and Finance twice monthly to facilitate release of the Payroll in

HR/Payroll.

* Developed "UHA FICA Extract" process to provide a report to the Health

Sciences Center with FICA Tax Exemptions for the employees with dual

appointments in HR/Payroll.

* Developed an error report that can report errors during any of the custom

payroll processes in HR/Payroll.

* Used Designer 6i as a repository for all the custom database objects and

for the dependent objects.

* Used Discoverer4.0 for the creation of complex views and reports.

* Extensively used AOL and Sys.Admin modules for set up of various

concurrent programs, Request sets, and Valuesets and Descriptive

flexfields.

Jan'02-May'02

IBM/The Great Atlantic & Pacific Tea Company, Montvale, NJ.

Responsibilities:

* Worked on implementation of Oracle 11i (11.5.3) HRMS (HR, Payroll)

* Developed Data Extracts and also the reports for the following tasks as

per the client's requirement.

Merrill Lynch National Union 401(K) Plan Contribution Tape and

Reporting.

Canadian Benefits-CCWIPP Monthly Tape and Reporting.

Canadian Payroll AERS (Employment) Tape and reporting.

* Customized and developed FAST FORMULAS developed are Dental Deduction

calculation rule, Flex Medical and Flex Dental Default Enrollment rules,

Hours Worked Derived Factor Calculation rule and Length of Service Date

to Use rule.

* Extensively used AOL and System Administrator modules for registering the

reports.

May'01- Jan'02

Oregon Health Science University/Oracle Corporation, Portland, OR.

Responsibilities:

* Developed conversion mapping strategies and successfully created programs

to convert the data from an access based system to Grants module. This

involved data validation, error reporting and use of custom and oracle

delivered API's. The project was accomplished in a shortest span of 5

months

* Created custom Grants recon. Report, LD recon reports as per their

business rules.

* Involved in customization of "Standard Invoice Based on Costs (Summary &

Detailed) Report in Grants Accounting module.

* Created a custom report for all expenditures with date range and award as

parameters, this report is usually run every Friday night.

* Customized oracle delivered expenditure reports as per the client's

business rules and migrated to the current version of oracle

applications.

* Designed and implemented custom interface programs to transfer payroll

costs to Project Accounting. Oracle implements this through LDM module,

instead a custom interface was written to transfer these costs to PA

. Involved in customization of "Schedule Lines" screen in Labor

Distribution module using Custom Libraries functionality. Also,

customized "Invalid Labor Schedule Natural Account - Expenditure Type"

report in Labor Distribution Module.

. Efficiently used Kintana deliver tool for migration of Reports and

Concurrent Programs between various development and production instances.

. Designed and Developed the following HR/Payroll reports like "Form 5500

Report" "Recruitment Aging report", "Recruitment Statistics report","

Employee Promotions/transfers Report"," US savings Bond savings report",

"Position Listing Report ". Also created concurrent programs and value

sets and integrated them with various instances Of Oracle Applications.

* Designed and Developed Data Warehousing reports which run against the

views created from HR/Payroll Database tables, also integrated them with

different instances of Oracle Applications using shell scripts and

concurrent program definitions.

Mar'01-APR'01

BellSouth/Oracle Corporation, Atlanta, GA.

Responsibilities:

. Worked on implementation of Oracle 11i (11.5.3) CRM, OM.

. Developed/Customized reports like "Transactions Type Report", " Order

Summary Report","Outstanding Holds Report"," Order By Item Report" in

Oracle Order Management module.

. Performed testing and upgrading for the modules like Customer Care,

Service for Comms., From 11.5.1 to 11.5.3. For adding new functionality

after thorough analysis of these modules. Also, given presentations to

client for the new functionalities.

. Assisted the DBA's in post patch implementation for setting up profiles

as per the client's requirements in various instances.

Jan'01- Feb'01

Southern Illinois University/Oracle Corporation, Carbondale, IL.

Responsibilities:

Worked on implementation of Oracle 11i (11.5.3) (PO)

Involved in analysis, design, coding and documentation for customization of

"Enter Requisition" and "Enter Purchase Order" screens as per the

client's business rules in Oracle Purchasing.

Extensively used AOL and System Administrator modules for registering the

forms with applications in various development and production environments.

Jun'00-Dec'00

BISYS Education Services., New Orleans, LA.

Responsibilities:

. Worked on implementation of Oracle (11.0.3) applications (GL, AP, AR,

INV, Order Entry)

* Customized Master Item Screen in Oracle Order Entry module, which

involved in modification of the Custom library, Creation of messages,

Defining Descriptive Flexfields and value sets.

* Customized Contact Center Screen in Customer Care 3I module as per the

Oracle Documentation to reduce data entry by passing global variables

between the forms when navigating from this screen.

* Designed and developed reports such as Sales Order Summary by Supervisor,

Sales Order Detail by Supervisor and integrated them with Oracle Order

Entry Application.

* Developed reports like BES Item Sales and Costs summary, BES Category

Sales and Costs Summary in Oracle Receivables Applications.

* Extensively used AOL and System Administrator modules for registering the

forms and reports.

* Performed tuning to improve the efficiency of the reports in modules like

Order Entry and Receivables.

Oct'99 - May'00

Examco. New Orleans, LA.

Responsibilities:

* Worked on implementation of Oracle (11.0.3) applications (AR, INV, OE,

and BOM).

* Imported items and Bill of Materials data from excel spreadsheets into

Oracle Inventory and Bill of Materials tables for Master and Child

Organizations. This process involved in using

SQL* Loader to import data from excel spreadsheets to staging tables,

designing,

Developing and executing various procedures and functions to insert

data into Oracle

Interface tables from staging tables, running concurrent programs

to transfer data from

Interface tables to Actual inventory and bill of materials tables.

* Also updated the Categories, Price Lists, Cost of Goods Sold Account, and

Revenue Account for the Items and BOM's Loaded.

* Customized Customer Entry Screen in Oracle Receivables to change

properties of the text items dynamically as per the user's requirement.

* Customized reports such as Pick Slip report, Unbooked Orders report in

Oracle Order Entry application.

* Developed reports like BES Sales, Units, Costs by Item and BES Sales,

Units, Costs by Product Line in Oracle Receivables Applications.

* Ran patches provided by Oracle to improve the efficiency of the Oracle

applications.

* Assigned new users with privileges by using System Administrator

Responsibility as required by company's management.

* Extensively used AOL and System Administrator modules for registering the

forms and reports

* Interacted with Oracle Support in regards to opening new TAR's (Technical

Assistance Requests) and resolving the existing TAR's.

* Created Custom Responsibilities to which were attached Specific Menus,

Forms and Reports for restricted user access.

May'99 - Sep'99

BPA Systems Inc., Austin, TX.

Responsibilities:

* Worked on implementation of Oracle (11.0.3) applications (AR, INV, and

OE).

* Imported historical customer Information from existing system into Oracle

Receivables applications for better Customer Management by keeping track

of Customers, Contacts and Call details for the future reference using

SQL* Loader and PL/SQL scripts.

* Developed Print Invoice form in a custom built application Oracle Order

Entry.

* Customized Pick Slip report, Unstaged Shipping Item Report and Cancelled

Order Report as per the user's requirement in Oracle Order Entry module.

* Developed Inventory Turn report used for forecasting purposes. This

report makes a projection as to for how many periods the current on hand

quantity of a particular item will meet the demand based on the past

figures.

* Customized Oracle delivered reports in Oracle Inventory Application such

as Serial no transaction register, Serial number detail reports, and

Missing item report as per the client's specifications.

* Created request for printing bar-coded labels for in BP.LINK/SC

application, which is linked with Oracle Applications.

* Customized Sub Inventory Transfer Module of BP.LINK/SC for changing the

menu using PL/SQL.

* Set the profile options as a part of printer settings using System

Administration Responsibility.

* Created Menus, Request Groups using AOL and System Administrator modules

for the developed forms and reports to associate them with different

application modules.

Apr '98- Feb '99

Shakya Technologies Ltd., India

Responsibilities:

* Worked on implementation of Oracle (11.0.3) applications (GL, AR, AP, and

PO).

Imported accounting data from legacy system to Oracle General Ledger

application which

Involved in populating the staging tables with data from the legacy

system using SQL*

Loader, Inserting the data into interface tables using PL/SQL Packages and

importing the

Data from interface tables to oracle General Ledger tables using Journal

Import Interface

Program.

Designed and developed PL/SQL package with various procedures, functions to

cross

Validate invoice information and load automatically into Auto Invoice

Interface tables in AR

Module.

Developed reports such as Outstanding Purchase Order report, Aged purchase

Order report to name a few in Oracle Purchasing.

Customized reports such as item details Listing, Cancelled Purchase Orders

report in Oracle Purchasing.

Customized oracle delivered reports such as Supplier balance evaluation

report, Print Invoice report in Oracle Payables.

Customized Enter Invoice Form in Oracle Payables to meet client

requirements.

Tuned SQL statements in several reports to improve the performance of

reports.

Defined alerts in the Applications.

* Created Quick Codes, Zooms and Descriptive Flexifields as a part of

Form Customization.

* Used System Administrator responsibility to create users,

responsibilities, Request groups and menus in the development and

testing environments.

* Coordinated with the client on a regular basis to gather business

requirements during the design phase.

Jul'97 to Mar'98

Production and Sales Department, BHEL, AP, INDIA.

This project was designed and developed to help the client cut costs

through better maintenance planning and a documented maintenance system

with a wide range of reports for decision-making.

Responsibilities:

* Created reports such as 'Maintenance Log Report', 'Cost Analysis for

Downtime Data' 'Schedule Maintenance Report', to name a few.

* Developed a form to update the status of all maintenance activities

including preventive, predictive and schedule maintenance on a daily

basis.

* Also developed a data entry form to enter machine, equipment, spares,

tools and skills details.

* Involved in developing optimized code for Server related Packages to

centralize the application through procedures, functions and packages.

* Created users and roles and implemented security at multiple user levels

by allocating a certain role to a specific hierarchy of employees.

Aug'96 to Jun'97(Part Time)

General Hospital, BHEL, AP, INDIA.

Automation of the entire hospital activities including registration, doctor

scheduling, pharmacy and laboratories, referral and medical reimbursement

billing and maintenance of other hospital records for a 160-bed General

Hospital.

Responsibilities:

* Created tables, views and indexes on appropriate table columns.

* Developed a data entry form for Patient Registration which distinguishes

between various categories of employees, based on which Medical

Reimbursement takes place.

* Also developed the 'Referral Billing Report ', which is generated based

on the type of disease, diagnosis, referred hospital, referred doctor and

accommodation type.

* Developed another report, which is used for the analysis of expenditure

incurred department wise.

* Interacted with the client on a regular basis for project

specifications.

* Involved in taking Physical and Logical Backups of the database.

Jan'96 - Jul'96(Part Time)

APTS. Ltd., AP, INDIA

Attendance recording system integrates with and extends the

functionality of access control mechanism and the associated software.

While the card reader based access control system logs all door

transactions and implements present time zones and access levels to the

office, the attendance recording system facilitates import of these raw

transactions via text files, implementing the office rules. This system

also facilitates database loading, maintenance backup and a powerful report

generation feature.

Responsibilities:

Involved in training the employees in Oracle 7.X, DOS6.22, and WINDOWS3.x.

Created schemas, tables and appropriate indexes on table columns at

database level.

Importing data from text files using SQL* Loader into oracle database

tables.

Developed forms to retrieve employee's attendance details and update

employee details and getting the reports from these forms by using form

parameters to pass the required parameters.

Developed "performance evaluation reports" for of the employees with

different parameters like Day wise, Month wise, Department wise and

Designation wise.

Extensively used PL/SQL code to write triggers, procedures, functions and

packages in Database and Forms.

* Created roles and implemented security at multiple user levels by

allocating a certain role to a specific hierarchy of employees.

EDUCATION

Bachelor of Engineering. (BE), OU, INDIA.

Honor's Diploma in Software Technology and Systems Management (HTM), NIIT,

INDIA.

Advanced Training in SQL Star International, INDIA.

HONORS/ACHIEVEMENTS

"Best Programmer of the Year, 1998"at Shakya Technologies Ltd., India.

Microsoft Certified Professional.

Misrosoft Certified Solution Developer.

Contact this candidate