Oracle Applications Analyst
Resume:
Fremont, CA *****
*****.*********@*****.***
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