Oracle Developer

Sham Rao

* ******* **

Woburn, MA - *****

Ph: 714-***-**** (C)

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

OVERVIEW

. Over 9 years of experience in the Information Technology industry

emphasizing on all the stages of software development lifecycle,

including design, development, testing, implementation and

maintenance.

. Excellent experience in Oracle Applications modules such as GL, AP,

AR, PA, PO, FA, OTL, HRMS, Payroll, MPS, MRP, INV, and ASCP, with

hands-on experience in Reports, Interfaces, Conversions, and

Extensions (RICE).

. Extensive experience in working with Developer 10g (Report and

Forms), Discoverer 10g, Oracle 10g, PL/SQL development creating

packages, procedures, functions, and database objects, Oracle

Workflow Builder, BI publisher 10.1, Import and Export utilities,

and Unix Shell Scripts.

. Experienced in environments requiring direct customer interaction

during specifications, design, development, and product

implementation phases and building reports using Oracle Discoverer,

Business Objects.

. Sound knowledge and experience in data warehousing concepts such as

data mart, facts, and Starflake and Snowflake schema, and experience

in developing business applications using Visual Basic, HTML, Java,

J2EE, JSP, JDBC, and XML

. Experience in working with Retek Merchandising System and Retek Data

Warehousing.

SKILL SETS

. OPERATING SYSTEMS: Unix, HP-UX, SCO-Unix, AIX, Sun Solaris, Windows

NT/ 2000

. ERP: Oracle Applications 10.x/ 11.x/ 11i/R12 (GL, AP, AR, PA, FA,

PO, OTL, MPS, MRP, INV, ASCP, HRMS, iProcurement), Retek

. LANG/ TECH: SQL, PL/SQL, Java 1.x/ 2.x, J2EE, EJB 1.x, JSP 1.x, XML,

Visual Basic 5.0/ 6.0, UML, C, C++, HTML, DHTML, ASP, Applets,

JavaScript, Unix Shell Scripts, VBScript, Perl

. DATABASES: Oracle 7.x/ 8.x/ 8i/ 9i/10g, MS SQL Server 6.5/ 7.0, MS

Access, DB2

. SERVERS: Apache Web Server, Tomcat, MS IIS 4.0/ 5.0, Netscape, LDAP

3.x, JBoss 0.9

. TOOLS: Oracle Tool (OWB 2.x, TKProf, Explain Plain, Alert Manager,

Import/Export), Developer 10g (Forms 6i/10g, Reports 6i/ 10g),

Business Objects 5.x, Designer 6i, Discoverer 4i/10g, SQL*Loader,

Crystal Reports 6.x/ 7.x, TOAD 7.x, MS Office Suite (Excel,

FrontPage 2000), Kintana, FTP, Cool:Plex, RPG, JDBC 2.x, JDK 1.x,

JDeveloper 10g.

EXPERIENCE

Fujitsu America, Inc - MBS (Managed Business Services), Burlington, MA

Oracle Applications Development

June 2007 - Present

Working as Sr. Oracle Consultant and providing support and

implementation to clients McDonalds Corporation, Delano Regional

Medical Center, MasTec Inc.

McDonalds Corporation

. Being responsible for technical/functional development/support on

Project Accounting and financial modules of Oracle Applications.

. Being responsible for performing several customizations as part of

enhancements which includes PL/SQL packages, Alerts, Interfaces,

Discoverer Reports, XML Publisher Reports and Standard Oracle

Report, Forms personalization, Workflows, Customizing self-service

pages using Oracle Application Framework.

. Being responsible for coordinating with offshore team for

development of customizations and support issues.

. Resposible for coordinating with OBIEE team in assisting

customization.

. Interacting with client to get the requirements and preparing

specifications.

Environment: Oracle Applications 11.5.10/R12 (GL, AP, AR, PA, FA, PO,

iExpense, iProcurement, HR), Unix - AIX, Oracle 10g, Developer 6i

(Forms 6i, Reports 6i), PL/SQL, Toad 7.0, Kintana, Discoverer 10g,

BI Publisher 10.1, OBIEE, JDeveloper 10g, Oracle Workflow Builder,

Oracle Application Framework (OAF).

MasTec Inc.

. Acting as Functional consultant for supporting Project Accounting

Costing/Billing module.

. Implementing Multi-org and Multi-currency features for the new

company aquired by MasTec Inc.

. Giving solutions to users to meet the business needs.

. Performing custom enhancements, preparing functional specification

and coordinating with devopment team to complete the tasks.

. Performing support through orgainized ticketing system and resolving

the issues within the specified SLAs.

. Testing and releasing to users new enhancements and training users.

Environment: Oracle Applications 11.5.10 (PA, AP, AR, PO, HRMS,

Payroll, Inv), Unix - Sun Solaris, Oracle 10g, Developer/2000 (Forms

6i, Reports 6i), PL/SQL, Toad 7.0, Discoverer 10g, Oracle Workflow

Builder.

Longos Bros. Fruit Market

. Acting as sole Functional/Technical consultant for giving the

customer solution as well as developing the solutions in

HRMS/Payroll.

. Coordinating with users and giving end user training.

. Performed post production support.

. Working with Oracle on Service Requests.

Environment: Oracle Applications 11.5.10 (HRMS/Payroll, FA), Unix - Sun

Solaris, Oracle 10g, Developer/2000 (Forms 6i, Reports 6i), PL/SQL,

Toad 7.0, Kintana, Discoverer.

Delano Medical Regional Center

. Being responsible for customization required for implentation of AP

and PO module.

. Performed supplier conversion, AP interfaces (inbound/outbound),

reports using XML Publisher

. Coordinating with offshore by providing them requirement

specification and testing the customization.

Environment: Oracle Applications R12(GL, AP, FA, INV), Unix - AIX,

Oracle 10g, Developer/2000 (Forms 6i, Reports 6i), PL/SQL, Toad 7.0,

XML Publisher Reports.

Jacobs Engineering Group Inc., Pasadena, CA

Oracle Applications Development

August 2005 - May 2007

. Working as an Oracle Consultant

. Being responsible for technical development on Project Accounting

and Financial modules of Oracle Applications

. Developing several new complex forms and reports using Oracle Forms

and Reports 6i for the implementation of Global Financial System

(GFS) and Labor Costing and Distribution (LCD)

. Being responsible for successful implementation of Labor Costing and

Distribution (LCD) that includes processing employee timesheets

through Oracle Time and Labor (OTL), costing the timesheets,

generating pay data files for employees, and interfacing to ADP to

generate Payroll

. Calculating and distributing the labor cost, employee accruals, and

actual and cost fringes to GL and PA

. Customizing standard Oracle Forms such as expenditure inquiry using

Oracle Forms personalization

. Being responsible for developing several Unix Shell Scripts in AIX

based operating system

. Writing interfaces using APIs for Project Accounting and Oracle Time

and Labor (OTL)

. Working on enhancements to the developed customizations and post-

production support for the customized modules.

Environment: AIX, Oracle Applications 11.5.10 (GL, AR, AP, PA, HRMS, OTL),

Unix Shell Scripts, Oracle 8.x/ 9i, Developer/2000 (Forms 6i, Reports

6i), PL/SQL, Toad 7.0, Kintana

ARCO Aluminum, Louisville, KY

Oracle Applications Development

May 2005 - July 2005

. Worked as an Oracle Consultant

. Responsible for technical development on Financial modules of Oracle

Applications

. Responsible for analyzing, documenting, and creating new AP invoice

interface and AR lockbox program

. Responsible for developing new reports using Oracle Reports 6i

Environment: Oracle Applications 11.5.9/ 11.5.10 (GL, AR, AP, Financial),

PL/SQL, Oracle 8.x/ 9i, Developer/2000 (Forms 6i, Reports 6i),

Discoverer/2000 4i, Toad 7.0, MSTSC

Ross Stores Inc., Bay Area, CA

System Development

December 2004 - April 2005

. Worked as an Oracle Consultant

. Worked for the client having dress for less stores in 25 states

. Responsible for creating new custom batches using Korn shell and

PL/SQL procedures and functions for Retek Data Warehousing (RDW)

. Responsible for production support for Retek Data Warehousing (RDW)

- Data Warehousing Interface (DWI) and RMS batches

Environment: Sun Solaris 5.6, Retek, Unix Shell Script (Ksh), Oracle 9i,

Developer/2000 (Reports 10g), PL/SQL, Toad 7.0

MasTec Inc., FL

Oracle Applications Implementation

August 2004 - November 2004

. Worked as an Oracle Applications Consultant

. Developed new forms using Oracle Forms 6i for Project Accounting

module namely ITS vendor setup, DOT generic form, DOT estimate form,

and DOT cash application form.

. Created new alerts using Alert Manager responsibility in order to

automatically send email to the concerned managers when the entered

and billable quantities exceed estimate and budget quantities

. Created new tables, and registered them with Oracle Application

. Registered flexfield columns in order to use custom flexfields in

custom forms

. Developed several complex reports using Oracle Reports 6i namely

Billing Sub Accrual Month-To-Date, Quantity-to-Date, Bid Price

Estimate Report, and Weekly Billing Reconciliation Report

. Performed system administration tasks such as registering customized

applications, programs, and executable, created application users

and responsibilities, customized menus, attached menus to

responsibilities, and finally added this to user using AOL

. Responsible for post-production support

. Wrote MD70 technical documents and installation scripts

Environment: Sun Solaris 5.6, Oracle Applications 11.5.4/ 11.5.9 (GL, AR,

AP, PA, FA), PL/SQL, Oracle 8.x/ 8i, Oracle Tool (Alert Manager),

Developer/2000 (Forms 6i, Reports 6i), Discoverer/2000 4i, Toad 7.0

iOmega Corp., Salt Lake City, UT

Oracle Applications Upgrade

February 2004 - July 2004

. Worked as an Oracle Applications Consultant

. Worked for the client, providing high value data storage and data

protection solutions to protect, secure, capture, and share digital

information

. Worked for the client, offering businesses and consumers a

comprehensive data recovery services solution

. Upgraded Oracle Applications from 11.0.3 to 11.5.9

. Responsible mainly for upgrading existing interfaces and developing

new interfaces in 11.5.9

. Upgraded interfaces that included auto invoice import program and

inbound MPS SO and PO quantity

. Developed Payable open interface import program for the European

operations

. Developed inbound on-hand available quantity to bring the on-hand

available quantity from the client's partners site on daily basis

. Wrote two different outbound demand forecast interface to publish

forecast to two different client's partners with separate

requirements

. Worked on the tables that used to write the Advance Supply Chain

Planner (ASCP) interfaces such as MSC_DEMAND, MSC_SUPPLY,

MRP_GROSS_REQUIREMENTS, and MRP_RECOMMENDATIONS

. Upgraded OM order import validation program according to the new

changes to the schema of OM from 11.0.3

. Upgraded custom forms using flint utility, and developed new reports

in ASCP

. Customized Oracle Workflow process using Oracle Workflow Builder 2.6

. Wrote Unix Shell Script to perform various operations such as

importing and exporting files to partner's FTP sites and for various

other validations

. Used various Oracle utilities such as SQL*Loader, UTL_FILE, PL/SQL

packages, and Toad for development purposes

. Provided post-production support for Financial as Supply Chain

modules

Environment: HP-UX, Sun Solaris 2.9, Oracle Applications 11.0.3/ 11.5.9

(GL, AR, AP, PA, OM, INV, MRP, MPS, ASCP, iProcurement, Financial),

PL/SQL, Unix Shell Script, Oracle Tools (OWB 2.6), Oracle 8.x/ 8i,

Developer/2000 (Forms 4.5/ 6i, Reports 2.5/ 6i), SQL*Loader, Toad 7.0,

FTP

Slough Borough Council, Berkshire, UK

Oracle Applications Development

August 2002 - September 2003

. Worked as an Oracle Applications Consultant

. Worked for the client that had replaced their two financial systems

with new integrated financial system and required new auto invoice

interface to Oracle Applications with a willingness to setup

automatic receipts (direct debit)

. Customized and developed new reports

. Set up auto invoices that included defining invoice source and

grouping and line ordering rules and descriptive flex fields that

included line and invoice transaction

. Performed conversion of legacy customer, invoice data, and bank

receipt information into Receivables using SQL*Loader programs

. Customized lockbox processing in order to schedule the process to

run automatically every morning

. Responsible for interfacing through Accounts Payable open invoice

import program

. Written Shell Script in order to format data required by PL/SQL

procedures to generate formatted output file for running lockbox

processing

. Customized transaction entry form by including check digits in the

field containing transaction number in transaction window using

custom library

. Customized Financial Reports using Financial Statement Generator

(FSG) by defining row sets, column sets, row orders, and display

sets

. Imported bank details for customer in AP tables using SQL*Loader,

and generated output file using UTL_FILE utility for direct debit

(automatic receipts) setup

. Uploaded budget amounts from spreadsheets into Oracle General Ledger

using budget upload

. Customized Purchase Order Print Report as per the client's

requirement in Accounts Payables

. Created technical and user documentations, provided support to the

users, and solved day-to-day problems

. Responsible for user training and user interaction

Environment: Unix, Sun Solaris, Oracle Applications 11i (GL, AR, AP, PO),

PL/SQL, Oracle 8i, Developer/2000 (Reports 6i), SQL*Loader, Toad 7.0

United Parcel Services (UPS), Middlesex, UK

Oracle Applications development

November 2001 - July 2002

. Worked as an Oracle Applications Consultant

. Worked for the client, the world's largest package distribution

company that transported over 3.5B parcels and documents annually

. Customized the Credit Analysis Reports in Order Management

. Developed a custom package for importing orders through order import

open interfaces in Order Management

. Worked on performance of SQL queries using Explain Plain and TKProf,

and optimized the queries using hints

. Worked on GL interface to bring legacy journals into Oracle, and

worked on FSG reports

. Developed complex report using Oracle Reports 6i for export

declaration for producing the report to customs department

. Worked extensively on report attributes such as report triggers,

program units, attached libraries, and built-in packages

. Worked extensively on format triggers, formula columns, summary

columns, placeholder columns, and reference cursor query for

developing the reports, and prepared complex data model and data

layout in Oracle Reports 6i

. Wrote SQL queries and PL/SQL functions and procedures extensively

Environment: Oracle Applications (OM, GL), SQL, PL/SQL, Oracle 8i, Oracle

Tools (TKProf, Explain Plain) Developer/2000 (Reports 6i)

Dalkia, Middlesex, UK

Oracle Applications Development

May 2001 - October 2001

. Worked for the client, one of the leading providers of energy that

integrated services management to businesses throughout the UK and

Ireland, established in the UK for over 30 years, and provided

solutions in partnership with client's organizations in both the

private and public sectors

. Developed technical and functional specification for interface

between feeder system and Oracle Applications

. Reviewed existing data output requirements as shown in the original

P1TK specification, and confirmed if correct or proposed amendments

. Specified and provided extract from EROS for data conversion

purposes

. Prepared and included format options available for data output

. Prepared import validation checks to be made when loading

transaction data from EROS to P1TK, and proposed error handling

requirements for action in either system

. Specified and provided EROS report to advise new and changed meters

that could be used to amend meter set up in P1TK

Environment: AS/400, EROS, Oracle Applications 11i, DB2, RPG, Cool:Plex

EzCampaign Mytelligence, Tuscon, AZ

Interface Development

October 2000 - April 2001

. Worked for the client that enhanced organizations by providing

intelligent marketing services by making use of intelligent

personalization and capitalizing on customer loyalty by way of one-

to-one marketing service and increased brand awareness

. Developed Campaign Analyzer Module that will perform various tasks

including maintaining, scheduling, setting rules, and mailing for a

particular campaign

. Developed and deployed the Entity and Session Beans (EJBs) in JBoss,

an application server, and used Tomcat as a web server

. Worked on all the beans that maintained database transaction with

the backend MS SQL Server satisfying the ACID properties

. Used Netscape Directory Server extensively to implement LDAP

. Implemented database queries using standard Java API from Netscape

for standardization and ease of future interface enhancements

. Developed a query builder interface using Java Applets that will

perform a query to LDAP server, wherein the user could create a list

of leads called as mailing list

. Worked extensively with XML, DTD, and UML diagrams

Environment: Java 2.0, J2EE, EJB 1.2, JSP 1.2, Servlets, XML, UML,

Netscape, LDAP 3.0, Apache Web Server, Tomcat, JBoss 0.9, Oracle 8i, MS

SQL Server, JDBC 2.0, JDK 1.2, JBuilder 4.0, ERwin 3.5

Bulls Eye Marketing Pvt. Ltd.

Leads Generation System Development

. Worked for the client, a marketing company that provided services in

marketing various products of their clients, wherein the essential

part was to generate leads or potential buyers of the products and

to campaign for the product

. Developed the software that facilitated the uniform lead collection,

lead passing, and recording of sales lead feedback from their

partners

Windows NT, Visual Basic 5.0, PL/SQL, Oracle 7.x, ERwin

Oriental Insurance Ltd.

Vehicle Insurance Package Development

. Developed the comprehensive vehicle insurance software package that

automated the entire insurance process such as policy production,

billing, and claims processing

. Developed the package that was web-enabled

. Responsible for meeting with clients to develop specifications and

design from those specifications

. Estimated the cost-based on the design, and trained the end users

and/or Quality Assurance personnel

Environment: Windows NT, Java 2.0, Servlet, JWS, JavaScript, HTML, JDBC,

MS FrontPage 2000

EDUCATION

. Masters in Computer Applications

Contact this candidate