SUMMARY

• About 7 years of experience in Analysis, Design, Development, Testing and Implementation of Software Applications using Oracle E - Business Suites (EBS) R 12.0.3/11.5.10 spread across Implementations, Production Support, Data conversions and Customizations.
• Accomplish 2 Full Lifecycle End-to-end Oracle Applications Implementation (One in Oracle EBS R12.0.3, and other in R11i).
• Strong Subject Matter Expertise (SME) in Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Extensive experience in Configuration and Support of Oracle Application Modules which include General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Order Management (OM), Inventory (INV), Purchasing (PO), me-Expense, Fixed Asset (FA) modules.
• Profound noledge of Oracle Application Implementation Methodologies (AIM).
• Expertise in Design and Configuration of Chart of Accounts, Ledger, Multi-Org Structure, Revenue Recognition and Multi-Org Access Control (MOAC).
• Expertise in Design and Developments of reports required for day-to-day activities and statutory reporting purposes using Oracle Reports 6i, XML Publisher.
• Expertise in Enhancement of teh Oracle Standard Forms using Custom.pll and Forms Personalization.
• Extensive Programming experience in Oracle 10g/9i/8i, SQL, PL/SQL.
• Expertise in Data Conversion and Interface development using Oracle Standard Open Interface, Applications Programming Interfaces (API’s).
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Familiar wif teh Standard Documents (MD 50, MD 70, MD 120, CV 40, CV 60)
• Strong noledge and experience wif SQL Scripts, SQL*Loader, UTL FILE package. Hands experience wif Oracle Import / Export and Oracle API and build packages & functions.
• Experience in Quality Testing process, Test Script preparation and execution.
• Experience in environments requiring Direct Customer Interaction during Specifications, Documentation, Design, Development and Implementation phases.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell Scripting

RDBMS: Oracle 10g/9i/8i

Oracle Tools: Forms 6i, Reports 6i, XML Publisher, Application Desktop Integrator (ADI)

Database Tools and Utilities: SQL*Plus, SQL* Loader, Toad, SQL Developer, Data Loader, FNDLOAD

Operating Systems: UNIX, LINUX, Windows 7/2000, MS DOS, Solaris 8.0

PROFESSIONAL EXPERIENCE

Confidentiap, Phoenix, AZ

Oracle Techno-Functional Consultant

Responsibilities:

• Involved in Requirement Analysis, Design and Develop, This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec)
• Functional design and design review of Oracle Applications data conversions, interfaces, custom reports and custom applications.
• Provided production support on Oracle on various modules
• Interacted wif end users and functional architects for mapping teh legacy data to teh Oracle tables
• Managing a team for support of Oracle Financials (General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA) modules)
• Developed customized solution for clients. Coordinating wif business users and functional team members for teh functional requirement
• Worked for Procure to Pay (P2P) Process and Order to Cash (O2C) Processes and module integrations wif Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Order Management (OM) and Inventory (INV) wif in EBS System
• Designed and developed new Forms in Forms 10g/9i and Reports in Report 10g/9i for Custom Application through Concurrent Request from Oracle Forms Custom Applications, which is implemented wif Oracle Financial Release R12 Modules
• Developed data entry forms, complex and template forms in Forms 10g. Creation of Pop-up Menus and maintaining Master Detail relationship
• Analyzed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Worked on various workflow customizations across SCM modules including Order Management and Purchasing
• Team up wif functional teams and customer's staff and produce desirable results
• Preparing functional/technical specifications for reporting, interfaces and customizations
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files

Confidential, Wayne Pennsylvania

Oracle Applications Techno Functional Consultant

Responsibilities:

• Enhanced OLM modules like Contracts, Account Payable(AP), Account Receivable(AR), Purchasing (PO) and Order Management (OM) modules
• Coordinated wif onsite team and customer.
• Prepared enhancement object specifications for development.
• Prepared and validated AIM Documents.
• Responsible for teh understanding teh Functional documents (MD50) and preparing Technical designs (MD70).
• Responsible for training technical developers teh custom and standard functionalities.
• Responsible for development and validation of PL/SQL Packages, SQL Loader scripts.
• Developed and customized Forms and Reports.
• Experience in Unit and integration testing of various objects.
• Developed new Reports and customized standard Reports.
• Experience in development of workflow (OM Module).
• Prepared various AIM Documents( MD70, TE20, MD120)
• Wrote PL/SQL packages to assist customized workflow.
• Experience working in AP, AR, PO, OM, INV
• Developed inbound and outbound interfaces.
• Designed MD70 for TCA Party Conversion.
• Worked on initial data load (data conversions) for TCA Parties (Customer and Vendors)

Confidential, Salt Lake City, UT

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Reviewed MD50 functional design document & Prepared MD70 Tech design for development work done.
• Worked on Procure to Pay (P2P) cycle which includes Items and Categories, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Worked on teh Sales Order API in OM (Order Management) to update teh price of teh items (Sales Order Lines) when teh new price is less than teh old price for those orders that are not booked or shipped as a part of price protection feature to teh customers.
• Developed Customer Interface program to transfer and validate Customer data from legacy system into AR (Account Receivables).
• Customized reports in OM and Inventory (INV) such as: Pick Slip Report and Open Orders wif deliveries.
• Customized Account Payables (AP) Reconciliation Reports like Accounts Payable Trial Balance report, Posted Invoice Register and Posted Payment Register.
• Worked as a production support resource to analyze teh Trace Files and fix deadlocks in existing production environment.
• Designed and created descriptive Flex fields for Oracle Inventory and Oracle Purchasing modules.

Confidential, Yardley, PA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Designed and implemented tables, views, constraints and database triggers associated wif data utilities and application enhancements.
• Responsible for development activities in both teh front-end and back-end as well as taking lead role in analysis and designing part.
• Created teh Oracle database structures and involved in teh data loading activities using SQL*Loader.
• Developed customized PL/SQL programs (triggers, stored procedures, packages) in order to implement business rules and referential integrity.
• Involved in analyzing, designing & developing teh various Forms and Reports containing teh business logic.
• Worked on performance tuning and testing of teh Oracle PL/SQL database Packages, procedures and triggers of various applications.
• Fixing teh problems in PL/SQL code and any problems wif DDL scripts for tables and indexes and escalating teh issues in severe cases to teh development and other support teams.
• Performed Data Analysis, Coding, Debugging and Testing Troubleshooting, Error Trappings and Data validations.

Confidential

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in Business Re-Modeling, Business Requirements and System Test Planning and Support of Oracle Applications 11i
• Analyzed Solution before proposing it to teh Client, help influence Client Design Decisions and imparted Domain Training to Project Teams
• Configured new Chart of Account Segment Structure per Business Requirement
• Define and set-up Set of Books, Currency Rate Conversion, and Revaluation Process.
• Successfully implemented teh GL Module wif pre-requisite set up. Follow teh AIMS methodology to implement it.
• Design & Developed GL Interface programs to import teh data from B@ncs24 system wif required field’s validation into Oracle Applications.
• Design & Developed Oracle Reports to show teh individual Account Balance (outstanding + breakup) as on date in teh client specified formats.
• Analyze & designed PL/SQL Programs to cross-check teh incremental GL Account Balances of Oracle Applications compared it wif B@ncs24 system. This is helpful for Reconciliation process on day to day basis.
• Involved in Reconciliation process of Oracle Applications GL Account Balances wif GL Account Balances of B@ncs24 system. Help out in identifying teh root cause for mismatch in both sides of teh account balances.
• Consulted wif customers on Issue Resolution, Test Planning and Execution.
• Involved in Month-End & Year-End Period Closing Process.

Confidential

Responsibilities:

• Worked as a Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
• Studied and evaluated functionalities of various modules.
• Defined Set of books, accounting flexi field structure.
• Prepared Setup documents (BR100) for Accounts payables & Accounts Receivable.
• Created Responsibilities wif menu exclusions as part of SOD & tested all teh menus & functions.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Prepared Test Scripts for Integration Testing (TE040).
• Handled post go-live user support.
• Developed teh training material for teh users.
• Involved in business analyst activities, partnered wif business to gather requirements, design new process, end-to-end flows.
• As a Business Analyst Designed detailed Process Flow, establish Security And Control Requirements

Confidential

Jr. SQL Developer

Responsibilities:

• Performed daily monitoring of databases for availability and performance metrics
• Reviewed log files from overnight and batch processes for significant events
• Review SQL and PL/SQL for Production and sub-environments to ensure accuracy and optimization
• Manage and monitor failover/standby environments for teh production system
• Designed, tuned and developed packages, procedures and functions to perform database activities
• Assisted in optimizing existing SQL, PL/SQL packages
• Developed work flow diagrams, data flow diagrams and data mapping documents
• Assisted Database Administrators, Web Administrator, Release Manager, Quality Assurance Manager, and other ITO staff, as warranted to expedite software fixes that effect production, data quality, and access