**** ***** **** *******, #***

Fremont, CA *****

510-***-****

acow4n@r.postjobfree.com

Ramaa Subramani

To pursue a long-term career as an Oracle Applications analyst in a professional organization

OBJECTIVE

that will utilize my information technology experience for the development of the

organization.

SKILLS & • Over 10 years of IT experience and 7 years’ experience in Oracle Applications R12/11i (E

Business Suite), with focus on Oracle Financials modules (GL, AP, AR, PA,INV, PO,

ABILITIES

iProcurement, iExpense, HRMS, OTL, Oracle Alert Manager)

• Excellent knowledge of AOL (Application Object Library) and System Administration

Modules.

• Expertise in developing and customizing reports and forms in Oracle E-Business Suite

R12/11i, Oracle 11g/10g/9i/8i, Discoverer 10g/9i/4i/3i,Oracle Reports/Forms

10g/9i/6i/4.5/2.5

• Extensively worked on Oracle Discoverer (Desktop, Administrator, Plus, Viewer), which

includes report developments, discoverer administration, configuring discoverer and End

User Layer (EUL).

• Expertise in SQL and PL/SQL programming to develop stored procedures, functions,

packages and triggers.

• Extensively worked with Workflow builder, writing PL/SQL procedures for Workflow

and implementing them.

• Well versed with AIM Methodology and documenting the work done in a well-fashioned

manner.

• Experienced in using Oracle tools like SQL Navigator, SQL*Loader, Data Loader, FND

LOAD, SQL developer and TOAD.

• Writing and maintaining Technical Specification document MD70 and Functional

Specification document MD50.

• Familiar with Oracle Applications Framework (OAF) technology, especially with

personalization of existing OA Framework pages.

• Hands-on involvement in business requirement gathering, GAP analysis, process

mapping, solution design, configuration, setups, work around, interfaces, user training.

• Experienced in interacting with users, gathering requirements and testing of system

setups.

• Excellent analytical, presentation, communication as well as troubleshooting skills.

• Ability to work independently and as part of a team.

• Pleasing personality and a positive attitude enabling to bond with users and guide them

thru issues.

ERP

TECHNICAL

Oracle Applications R12/11i (GL, AP, AR, PA, INV, PO, iExpense, iProcurement, HRMS,

SKILLS

OTL, System Admin), Oracle Alerts, Oracle Workflow, Oracle Application

Object Library (AOL)

Operating Systems

Windows NT, Windows 2000,Windows XP, Solaris, UNIX, MS-DOS

Databases

Oracle 8i/9i/10g, Sybase 11, MS Access

Languages

PL/SQL Programming, ASP, Visual Basic, JavaScript, HTML

Software

Oracle Workflow Builder 2.6.1, Oracle Reports 6.0, Discoverer 10g,TOAD, Oracle ADI, SQL

Plus, MarkView, Optio Design Studio 7.8, MS Visual Source Safe, iPlanet, AQ Test, MS

Office 2013, Lotus Notes, MS Outlook, GroupWise, Merkur, Foglight, MS Project, Open

Project, Enterprise Architect, Balsamic, SnagIt, WinScp

Testing Tools

WinRunner 7.5, LoadRunner, SQA, SILK

Networks

TCP/IP, PC Anywhere, VNC

ORACLE APPS CONSULTANT, PRIMEZEN INC NJ

EXPERIENCE

September 2013 – December 2014

• Understanding the functional requirements of the client, Analysis and Review of High

Level documents mainly MD50 Functional Specification and resolve the issues

through functional walkthroughs.

• Developing custom interfaces between various Applications for integration.

• Developing reports through Oracle Reports and Oracle Discoverer.

• Used SQL loader to load data from legacy system and developed PL/SQL programs

to dump the data from the staging tables to the Interface Tables.

• Collecting Business requirement and leveraging with Oracle Applications

• Created Procedures, Functions and other database objects using SQL and PL/SQL.

• Defining Concurrent Programs, Executables.

• Customization and development Reports as per client requirements.

• Customized standard workflows as per the client need.

• Supported all go-live activities and post-production issues and bug-fixes.

• Preparation of MD070 Technical specification documents based on Functional

Specifications.

Environment: Oracle E-Business Suite R12, UNIX, Oracle Workflow Builder, Oracle

Discoverer 10g, Oracle Report Builder and TOAD

Page 2

SR. ORACLE TECHNICAL ANALYST, TRAVELPORT INC., NJ

April 2006 – April 2011

• Functional system administrator for the company’s financial system.

• Provided production support and troubleshoot tier II system and various user level

issues.

• Designed, developed and implemented new workflows and enhanced existing

workflows as per the business requirement.

• Developed and designed ad-hoc and management reports using Discoverer 10g.

• Acted as the technical point of contact and resource for a subset of larger project.

• Monitor and troubleshoot production environment for workflow related issues for

various purchase orders and requisitions.

• Involved in collecting and implementing data from each site for various inventory

items, users and approval hierarchy.

• Modified and updated data collection templates and documentation for various

inventory and employee information.

• Developed scripts to produce daily statistics reports for various aspects of the systems

such as purchase orders, requisitions, user accounts and assigned responsibilities.

• Modified custom Oracle Reports to incorporate new business requirements.

• Created technical specification documents for new customization to fulfill business

requirements.

• Provided training to other staff members as well as users on different tools.

• Documented various processes and user manuals.

Environment: Oracle Financials 11i, Oracle Discoverer 10g, iProcurement, TOAD, Merkur,

Fog light, Oracle Workflow Builder, Oracle Reports

SR. ORACLE CONSULTANT MIS, NEW YORK CITY HEALTH AND HOSPITALS

CORP., NY

August 2005 – November 2005

• Monitor and troubleshoot production environment for workflow related issues for

various purchase orders and requisition.

• Involved in collecting and implementing data from each site for various inventory

items, users and approval hierarchy.

• Modified and updated data collection templates and documentation for various

inventory and employee information.

• Developed PL/SQL scripts to produce daily statistics reports for various aspects of the

systems such as purchase orders, requisitions, user accounts and assigned

responsibilities.

• Modified custom Oracle Reports to incorporate new business requirements.

• Created technical specification documents (MD70) for new customization to fulfill

business requirements.

Environment: Oracle Financials 11i, IProcurement, TOAD, Merkur, Fog light, Oracle

Workflow Builder, Oracle Reports

SYSTEMS ANALYST, BURSON-MARSTELLER, NY

August 2002 – August 2005

Page 3

• Administrated and managed various aspects of the financial system for the firm

including managing user access at various levels.

• Performed and coordinated the up-gradation of Oracle Financials from version 11.0.3

to 11.5.9 (11i)

• Coordinated with Oracle DBAs and Unix Admins for keeping the system up.

• Experience with developing GAP analysis between business processes and Oracle

Applications.

• Developed, tested and implemented new workflows and alerts.

• Designed and enhanced management reports using Discoverer 4i.

• Worked with developers in resolving user issues and requirements

• In charge for closing each financial month in Oracle financials and data warehouse.

• Researched and developed system solutions for incorporating Sarbanes Oxley

regulations impacting internal systems.

• Provided technical support to users to various levels of users.

• Conducted firm wide user training for various modules of Oracle Financials.

Environment: Oracle Financials 11i, TOAD, MarkView, Optio, Discoverer 4i, WorkFlow, Self

Service Time & Expense

TECHNICAL SUPPORT ANALYST, CYBERSHIFT INC., NJ

April 2001 – February 2002

• Gathered business requirements from clients for further enhancements.

• Provided technical support to the clients for the Work Force Management and Time

and Attendance system.

• Manage and resolve complex issues in a high stress, constantly changing technical

environment.

• Consistently document issues and steps taken to resolve those issues.

• Interacted with web hosting service (USInet) for web site maintenance.

• Performed system and regression testing using test scripts before upgrading the

system.

• Enhanced and re-wrote the stored procedures in Sybase and Oracle to fix the bugs and

to fulfill new requirements.

• Coordinated between the clients and development team by translating the business

requirements into technical specifications

Environment: Oracle 8i,Sybase, AQ Test, iPlanet

BACHELOR IN COMPUTER SCIENCE FROM INDIRA GANDHI UNIVERSITY,

EDUCATION

1999.

COURSE IN ASP, JAVASCRIPT, ORACLE RDBMS, JAVA FROM RVCC, NEW

JERSEY.

WORK US CITIZEN

AUTHORIZAT

ION

Page 4

Contact this candidate