SUMMARY:

• Experienced Oracle Applications analyst having over 10 years of IT experience with specialization in Oracle Applications R12/11i (E Business Suite) responsible for supporting growth and maintenance activities necessary to manage/maintain the existing application base in accordance with controlled systems development lifecycle (SDLC) and global design standards.
• Over 8 years’ experience in Oracle Applications R12/11i (E Business Suite), with focus on Confidential modules ( GL, AP, AR, PA,OM, INV, PO, iProcurement, iExpenses, 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.
• 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).
• Identify and document aspects of the following under supervision: As-Is Processes, Business Requirements, To-Be Solutions, Functional Specifications and Configuration, Setups and work around.
• Experienced in interacting with users, gathering requirements and testing of system setups.
• Collaborate with technical development teams when addressing aspects of new implementations, functionality enhancements, application updates and performance issues.
• Assist with issue resolution and work directly with users on Tier II and III Help Desk issues; initiate and manage Service Requests (SRs) with Oracle Support.
• Ability to diagnose, research and resolve problems within and between modules in timely manner.
• Execute assigned tasks associated with projects, maintenance and BAU activities.
• Pleasing personality, excellent communication skills and a positive attitude enabling to bond with users as well as team members and guide them through complex application functionality.

TECHNICAL SKILLS:

ERP: Oracle Applications R12/11i ( GL, AP, AR, PA, INV, PO, iExpense, iProcurement, HRMS, OTL, System Admin), Oracle Alerts,Oracle Workflow, Oracle Application Object Library (AOL), Oracle ADI

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

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

Software: 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, SnagIt, WinScp, PC Anywhere,HP Project and Portfolio Management (PPM); HP Service Manager

Testing Tools: WinRunner 7.5, LoadRunner, SQA, SILK

PROFESSIONAL EXPERIENCE:

SR. IT BUSINESS ANALYST

Confidential, TX

Responsibilities:

• Work with Oracle and Application Development to identify and resolve system issues affecting business processes.
• Manage the production introduction projects and changes into the production environment using the application support plan. Provide proactive input on support plans for applications that affect any business processes related to the application.
• Track patches and configuration solutions from analysis to production release. Ensure the solution meets all requirements, is fully tested, and compliant with all IT policies and procedures. Communicate the status of the system impact and solution to all key stakeholders.
• Monitor all systems affecting critical business processes to proactively minimize service interruptions.
• Track and report all current and potential risks to maintaining business services.
• Identify and champion business and technical opportunities for improved services.
• Insure all support activities throughout the IT Customer Support organization are maintained to the highest standards.
• Supporting user acceptance, regression and other required system testing, ensuring that the system and/or related integration issues are identified, researched and closed in a timely manner.
• Execute production deployments and data loads in production.
• Provide technical solutions to non-technical individuals.

Environment: Oracle ERP R12, OBIEE, TOAD, HPSM, PPM

Sr. Oracle Business SYSTEMs analyst

Confidential, NJ

Responsibilities:

• 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 in corporate 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.
• Assisted users and the team in User Acceptance Test (UAT) leading to approval sign-off.
• Initiate, track and close service tickets relating to Oracle Applications for the business.

Environment: Oracle Financials 11i, Oracle Discoverer 10g, iProcurement, TOAD, Merkur, Fog light, Oracle Workflow Builder, Oracle Reports

Sr. Oracle Consultant

Confidential, NY

Responsibilities:

• 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 in corporate 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

Confidential, NY

Responsibilities:

• 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