SUMMARY

• Total 10+ Years of Experience as Oracle EBS Consultant Providing Solutions of Upgrade, Maintenance, Testing and Production Support in 11i and R12.
• Experience in Financial Modules such as Account Payables (AP), General Ledger (GL), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Project Accounting (PA), Oracle Project Management (OPM), Oracle Internet Expenses (iExp), Oracle Time and Labor (OTL), Sub - Ledger Accounting (SLA), Trading Community Architecture (TCA), Cash Management (CM), iSupplier.
• Functional Responsibilities: Requirement Gatherings, Functional Gap Analysis, Configuration, Training End Users, Writing Training Guides.
• Technical Responsibilities: Designing Custom Technical Solutions, Code Fix and Data Fixes
• Experience working on end-to-end Procure to Pay (P2P) and knowledge of Order to Cash (OTC).
• Proficient in SQL and PL/SQL.
• Experience working on RICE Components.
• Knowledge of Setups. E.g. COA, Calendars, Currency Rates, Cross Validation Rules. And Ledgers
• Experience of developing conversion programs and Interfaces (Inbound & Outbound).
• Experience in using tools like SQL *Loader, Data Loader, FND LOAD.
• Knowledge of Writing/Modifying UNIX Shell Scripts.
• Creating WEB ADI’s to load data in to oracle upon business requirement.
• Proficient in Performance Tuning SQL statements using SQLTRACE and TKPROF.
• Involved in QA Testing process and coordinated with end users for UAT.
• Experience of writing Technical/functional specification documents using AIM Methodologies.
• Performed Fundamental administrative tasks Including Registering Concurrent Programs, Flex Fields, Value Sets, responsibilities and Menus.
• Coordinated with Oracle support to resolve application issues, bugs and TAR/SR management.
• Production support, bug fixing and enhancement.
• Working Experience at Different Locations (United Kingdom, Poland, USA, India).
• Coordinated and Planned with Various Teams for Release Roll Out plans and Maintenance Plans in Support Projects.
• Exceptionally well organized with Strong Communication, Inter-personnel, Analyzing Skills and a desire to learn new technologies and tools.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS

ERP: Oracle Applications Release 11i & R12

Databases: Oracle 9i, 11g.

Programming Languages: SQL, PL/SQL, UNIX & OAF

Development Tools: Forms & Reports 6i/10g, Xml Publisher, Workflow builder

ERP Modules: AP, AR, GL, SLA, PA, TCA, FA, iExpense, OTL, CM, PO

Version Control: Clear case

Migration Control: Kintana, Serena, Git Hub, SVN

DB Tools: Toad, SQL Developer

Additional Tools: BMC Remedy, Service Now, Git Hub and Hyperion Brio, OBIEEHP QC, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Support

Responsibilities:

• Responsible for handling R12 Production Support Issues for the Components Developed.
• Assisting in the Month end Closure Activities.
• Post clone Validations for multiple Instances.
• Manage the ticketing support queuein JIRA.
• Developing Conversion Programs to modify data as per business Requirements.
• Developing Interface Programs to Interface data to Power BI System.
• Developing a Mass Asset Retirement Process to Retire Assets which are not in Use by the company.
• Designed, Developed and Rolled Out EDI Invoicing Process for multiple Countries.
• Developing Unix Scripts for Interfacing 3rd party systems to receive data on daily basis.
• Creation of Tables and Loading Data using SQL Loader for performing Conversions.
• Migrating Codes across Lower Instances as part of Testing Cycle.
• Fixing Bugs Identified by users during the Testing Phase.
• Running Adhoc Reports requested by user when required.
• Preparing MD-50 & MD-70 Documents.
• Developing New XML/BI Publisher Reports as per Client Requirements.
• Preparing Standard Operating Procedures (SOP) for Production Issues.
• Providing Status on Open Items during Daily/Weekly Status Meetings.

Environment: - Oracle E-Business Suite R12, Window 7, Oracle 11g, Toad, JIRA, Forms & Reports 10g, XML Publisher, Workflow builder, SVN, Web Services (SOAP), Linux.

Confidential, Denver

Oracle EBS Developer/Support Analyst

Responsibilities:

• Requirement Gathering and Analysis for the Upcoming Reynosa Implementation.
• Preparing MD-50 & MD-70 Documents.
• Created Automated GL Reversal Journals Program for some sources.
• Working on PRODUCTION Issues for already Implemented SPARTA.
• Developing New BI Publisher Reports as per Client Requirements.
• Working with Oracle through Service Request for Seeded Issues and bugs.
• Preparing User Manuals and assist users in UAT Enhancement Testing
• Preparing Standard Operating Procedures (SOP) for Production Issues.
• Providing Status on Open Items during Daily Status Meetings.
• Providing Handoff for Offshore Team on open Issues.

Environment: - Oracle E-Business Suite R12.1.3 (AP, GL, AR, PO, INV, OM) Window 7, Oracle 11g, Toad, GitHub, Forms & Reports 10g, Xml Publisher, Workflow builder

Confidential, Chicago

Oracle EBS Consultant

Responsibilities:

• Created New Rollup Groups, Summary Templates and tested the Funds Checking Functionality as Part of Budget Organization changes requested by the Business.
• Knowledge of defining Accounting flex field Structure, Cross-Validation rules and Ledgers.
• Preparing MD-50(Functional Design Document) for Various Reports and Interfaces to understand Functional Requirements.
• Performing Functional testing for AP, GL, FA and PO Modules to understand and document Existing Business process.
• Responsible for handling daily Production issues related Financial Modules.
• Implementation of Withholding Invoices Functionality for Foreign Supplier.
• Creation of Shell Script to FTP Files to Third party vendors.
• Supporting Business for UAT (Finance Modules) after every Patching Activity to verify the Functionality.
• Knowledge of Defining Fixed Asset setups like Category/Asset key/Location key flex fields.
• Knowledge of Defining Fiscal Year, Calendar and Depreciation methods locations and book Controls Under Fixed Assets.
• Resolving Issues in FA related to differences in Corporate and Tax books.
• Web ADI Creation for Fixed Assets Module.
• Migrating WEB ADI templates from one Instance to another using FND LOAD.
• Developing Custom BI Publisher Reports as per Requirements.
• Writing/Executing Scripts to perform various extracts from database.
• Implemented Positional Hierarchy Workflow in Purchasing as per business requirements.
• Modification of Existing OBIEE reports for CAFR as required by business.
• Preparing User Manuals and assist users in UAT Enhancement Testing
• Monitoring critical issue progress to avoid SLA violations and customer escalations.
• Tracking recurring issues and provide Permanent fixes.
• Documenting Issue Resolutions.
• Coordinating with DBA for the Maintenance Activities.
• Working along with Oracle Support through metalink for escalated issue analysis and resolution.
• Provide Month/Year end Closing Support

Environment: - Oracle E-Business Suite R12.1.3 (AP, FA, PO, CM and GL, HR, PAYROLL) Window 7, Oracle 11g, Toad, Serena, BMC Remedy Software, Unix, Forms & Reports 10g, Xml Publisher, Workflow builder, OBIEE

Confidential, Schaumburg

Oracle EBS IT Analyst

Responsibilities:

• Involved in requirement gathering with Confidential Business.
• Presenting Technical/Functional Documents to business users and Approvals from Business.
• Converted required Confidential Projects to Zebra Operating Units using Microsoft Projects Integrator.
• Created New Project Templates for Zebra Operating Units.
• Created New Projects Under Zebra Operating Units.
• Created Resource Assignment for New Zebra resources for Zebra Projects.
• Coordinated and supporting business user during CAT (Customer Acceptance Testing).
• Provide Post Production Support and Extended care support.
• Prepared User Manuals as per Business requirement.
• Worked on Production Issues related to other Financial Modules (AP, GL, FA, AR, iExp).
• Developing Reports as Per Business Requirements.
• Preparation of GL Extract for the Legal Audit Purpose.

Environment: - Oracle E-Business Suite R12.1.3 (Oracle Project Management (OPM) Window 7, Oracle 11g, Toad, BMC Remedy Software, Service Now

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Working on Daily Production Issues across Finance Modules (AP, GL, IEXP, PA, AR, and OTL).
• Analyzing the system and raise RFC for Enhancements and Performance.
• Implemented Setups and Profile Options related to iExpense.
• Done Setup for Assigning Signing Limits and supervisors for iExpense Approvals using AME.
• Performing Data Fixes and Code Fixes.
• Preparing/Modifying Reports as per user Requirements.
• Knowledge of Setting Up Suppliers and Setting Up of Invoice tolerances
• Tracking recurring issues and provides Permanent fixes.
• Preparing Status Tracking Report on the Current issues and Permanent Fixes.
• Provide Month/Quarter/Year end closing support.
• Documenting Issue resolutions.
• PersonalizediExpense attachment upload page to include “Note” to the users at the Organization Level.
• Coordinating with DBA for the Maintenance Activities.
• Coordinating with Oracle through Service Request for standard bugs.
• Supporting the Month end/Quarter End/Year End Closure Activities.
• Supporting Confidential Custom Applications.
• Primary Escalation Contact for the EMEA region.

Environment: - Oracle E-Business Suite R12.1.3 (PA, AP, GL, OTL, OPM, IEXP, FA) Window 7, Oracle 11g, Toad, BMC Remedy Software, Kintana, Unix, Forms & Reports 10g, OAF

Confidential

Oracle Apps Consultant

Responsibilities:

• Responsible for analysis of functionality integrating other system with the PA Modules.
• Coordinating with Business users during CAT (Customer Acceptance Testing) for R12.1.3 Upgrade.
• Implementing Code/Data fix and testing the Functionality after Implementation.
• Preparation of Technical Design Documents for the newly/modified component in the existing System.
• Worked on Production Issues and Alerts to meet customer needs.
• Worked on Form Personalization Issues.
• Preparation of As-Is document and To-Be documents.
• Worked on11.5.10 minimum baselinepatch upgrade to theInternet Expensefor Oracle Support.
• Handling Client Meetings and providing status to Confidential Management.
• Providing data extracts as per user requirements.
• Converting Existing RDF reports in to XML Publisher Reports.

Environment: - Oracle E-Business Suite 11.5.10(PA, OPM, OTL, AP, AR) Window 7, Oracle 9i, Toad, BMC Remedy Software, Kintana, HP QC

Confidential

Oracle Apps Support Analyst

Responsibilities:

• Responsible for handling Production issues related to Financial Modules and Custom Applications.
• Extensively participated in Month/Year End Closing Activities.
• Providing adhoc-reporting data from business users during critical year-end, Month end process.
• Clearing the Error Interface transactions.
• Responsible for handling Customized interfaces issues
• Monitoring critical issue progress in order to avoid SLA violations and customer escalations
• Working along with Oracle Support for escalated issue analysis and resolution.
• Communicating to all the stakeholders, getting the approval for the down time. Presenting the weekly status, SLA reports to Confidential team.
• Working on Data fixes and Code Fixes.
• Co-ordinate with business users to complete the User Acceptance Testing and log the defects in the PPM client Tool.
• To identify and to implement best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios. Extensive Disaster Recovery tests are conducted every year.
• Documenting Issue Resolutions.
• Problem Management: To assist the Incident Management team to drive downs the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.
• Supporting Confidential Custom Applications (FIRE, e-BAM, e-Check, e-Sar).
• Preparing the Release Rollout plan and make sure that proper code is migrated across various instances via Kintana and Clear-Case tools.
• Tracking the various stages in the life cycle of the project using the Client Specific tool COMPASS.
• Following Change management, release management processes to ensure quality during production migration.
• Gaining knowledge on the Inbound and outbound applications and resolving cross application tickets.

Environment: - Oracle E-Business Suite R11.5.10 (AP, AR, OM, GL, PA, iEXP, FA, Confidential Custom Applications) BMC Remedy, Kintana, Clear-Case, Oracle 9i, Toad, SQL* Plus, UNIX, PL/SQL, Forms & Reports 6i/10g, Hyperion Brio

Confidential

System Engineer

Responsibilities:

• Underwent rigorous training in Oracle PL/SQL, SQL, and Unix Shell Scripting.
• Trained to analyze customer business systems and requirements.
• Trained to Document Functional/Technical Design Documents as per AIM.
• Testing the Existing Business Process and Documenting Test Results.
• Trained on Communication Skills and User etiquette.
• Understanding Project SDLC and implemented the same for in-house projects.

Environment: -Oracle 8i/9i, Toad, SQL* Plus, UNIX, PL/SQL, SDLC concepts, Master Craft