SUMMARY:

• Expertise is Oracle E - Business Suite (EBS) around 13+ Years as a Techno Functional Consultant on various stages of the project implementations, upgrade & Support.
• Well versed with Financial Modules (AP, AR, GL, FA and CM), SCM (PO, INV, WIP and BOM), HRMS and Other concepts like PA, TCA, QP, WSH, GL, CE and AOL.
• Extensively worked on CEMLI (Configurations/Customization, Extension, Modification, Localization and Integration) components.
• Experience in various process flows like P2P,O2C,R2R
• Thorough insight in Designing and Developing Data conversions, Interfaces using Oracle Open Interfaces and Oracle Public API’s.
• Excellent analytical skills in Analysis and business requirement gathering(BRDs) from end users and experience in design using functional requirement documents(FRDs) MD50 and CV40, technical requirements documents (TRDs) MD70 and CV60 documents using Application Implementation Methodology (AIM).
• Proven ability to quickly learn and apply new technologies with strong technical background. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TOOLS:

• SQL*Loader,
• SQL*Plus,
• PL/SQL,
• OAF,
• Oracle Developer Suite 6i/10g,
• Oracle Workflow,
• TOAD,
• Data Loader,
• UNIX,
• JDeveloper,
• BI Publisher,
• Harvest workbench,
• WinSCP,
• Putty and Reflection FTP.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Apps Techno Functional Consultant

Responsibilities:

• Designed and Developed AR Invoice outbound Interface in XML format with required information.
• Designed and Developed DRAP Alert to Notify Buyer of Variance report in XML Publisher.
• Designed and Developed Y-State Inbound Interface that takes Input from SOA and loads transactions into database Objects and the same data from database objects is loaded into Custom tables. Based on the transaction type, the receipt method and bank details are updated on AR Transactions using API - ARP CT PKG.UPDATE P.
• Developed OAF page as per business requirement.
• Developed Y-State report in Discoverer.
• Developed custom reports DEBMUL (Debit Multiples) and CREMUL (Credit Multiples) report in Discoverer.
• Design and Developed Direct Debit Exception report in XML Publisher.
• Design and Developed Citi Bank Check printing for Dubai and Abu-Dhabi.
• Preparation of migration components list and loading them using the FNDLOAD.
• Understand business requirement and preparation of MD070s for Enhancement/Change Requests, Interfaces and Extensions.
• Required functional setups are done for testing the Interfaces and reports developed.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AR, OM, PO, AOL and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Oracle Workflow, Win SCP, Putty, UNIX and SQL*Loader.

Confidential, Boston, MA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Preparation of migration components list and loading them using the FNDLOAD.
• Integrating DRM and Oracle R12 for Segment value hierarchies through the Interface.
• Implementing Beeline (legacy) to Oracle EBS R12 Interface.
• Developing the Code to get various extracts form systems like Oracle, Agility Systems.
• Understand business requirement and preparation of MD.070’s for enhancements, Interface &extensions
• Configuring the Functional setups required for testing the Interfaces and reports
• Creation of personalization’s to meet the requirements and developing the AOL objects where ever required.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AOL and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Oracle Workflow, Win SCP, Putty, UNIX and SQL*Loader.

Confidential, Salt Lake City, UT

Oracle Apps Techno Functional Consultant

Responsibilities:

• Responsible for Creation/registration of AOL objects for Profiles, Value sets, Concurrent programs, etc.
• Involved in the feasibility analysis of the migration of the SBC legacy system into the Oracle Applications R12 system and documented the AS-IS Business Process and framed the solution for the TO-BE process system.
• Modify Order Line Workflow to use government generated invoice number as an AR invoice number and developed the Workflow for HTML notifications and Adhoc users/roles for sending notifications to external email lists.
• Designed and Developed interfaces for various Third Party Logistics (3PL’s) clients based out in Europe, South America and South-East Asia in Order Management, payment and on-hand interfaces for the Stockiest system for the Indonesia market.
• Developed & customized report like Daily Sales Report, Member Final Transaction Report & Print Purchase Order Report’ to XML Publisher Report. Customization PO Approval Workflow to BPA Quantity Agreed Validation.
• Designed and Developed vendor payment files for various countries (Colombia, Panama, Ecuador, Mexico, Guatemala, Dominican Republic and Poland) and Wells Fargo Bank Statements to EBS (USA).
• Created of MD 50’s for some of functional requirements that are discussed with clients.
• Involved in functional configuration and creating Test cases for UAT.
• Configuration of Payables and Receivables systems.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AR, PO, OM, AOL and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Oracle Workflow, Win SCP, Putty, UNIX and SQL*Loader.

Confidential, Denver, CO

Oracle Apps Techno Functional Consultant

Responsibilities:

• Proactively work with business organizations to identify technology initiatives to drive productivity opportunities, operational efficiencies, or increases in customer satisfaction.
• Perform systems analysis of submitted business requirements to define optimal technical solutions.
• Development of various Interfaces for Inventory and WIP like Material Variance, updating Item attributes, printing the labels Carton and Small packages, BOM Explodes up to 5 levels.
• Assigning of tickets to resources based on the precedence.
• Providing work level estimates for projects to establish work plan’s, Lead the design and develop of enhancements and provide the effort estimate to the Corporate Applications platforms.
• Ensure release communication (scope, requirements, and release schedules) are maintained and delivered to the appropriate business owners. Actively manage any changes to releases including broad communication of any changes.
• Work closely with the IT management team, Vendors, and QA staff throughout the development lifecycle to resolve any release scope changes using a formal change management process.
• Development of Test scripts and Coordination with users and IT team for successful completion of UAT.
• Maintain Executive Dashboard and Metrics reporting for Corporate Applications.
• Involved in Production support activities. Analyzing the root cause on the issues and fixing the issues.

Environment: Oracle Applications 11.5.10.2/R12 (GL, AP, AR, PO, OM, AOL, WIP, BOM, INV and System Administrator), Reports 6i, XML Publisher Reports, JDeveloper, Oracle 10g, TOAD, SQL*Plus, PL/SQL, OAF, Win SCP, Putty, UNIX and SQL*Loader.

Confidential, Seattle, WA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed Electronic payment file generation program for Deutsche Bank (Japan, Slovakia, Canada and France).
• Developed electronic payment file generation program for HSBC bank (South Africa and Australia) in payables module.
• Developed Program serves as a wrapper to launch generate programs for Wells Fargo, Deutsche Bank and HSBC electronic payment batches.
• Developed and Customized various Interfaces, reports like update payment priority for unpaid invoices, Shell scripts to download files from Wells Fargo secure client, Sales Order Acknowledgement Report, customizing AP Bank Descriptive Flexfield to add Sender ID and SEPA Payments segments..
• Sales order conversion program in Order Management module.
• Mailer program for emailing of account statements to customers
• Created technical documents MD 70 and installation documents.
• Involved in Unit testing and creating Test cases.
• Created AOL objects for all development work.

Environment: Oracle Applications 11.5.10.2 (GL, AP, AR, PO, OM, AOL and System Administrator), Reports 6i, Oracle 10g, TOAD, SQL*Plus, PL/SQL, Win SCP, Putty and SQL*Loader.

Confidential, Oklahoma City, OKC

Senior Oracle Apps Technical Consultant

Responsibilities:

• Handling of conversions for “ Confidential Acquisitions” SIT and “ Confidential Acquisitions” EIT in HRMS Module.
• Developed the outbound interface for Confidential United Health Extract Program in HRMS, Oracle Advanced Benefits and Payroll Modules.
• Developed report for Confidential Personal Fact Sheet/Confirmation Statement - (Monthly by Benefit Group) OKC Print Shop.
• Generating Payment Reconciliation data from Oracle Payable module to OB10 System for matching all the E-Invoices.
• Preparing and maintaining the Data mapping between legacy and central repository.
• Co-coordinating and managing the technical development and functional setup activities.
• Responsible for conversion, and implementation of Oracle General Ledger, Oracle Payables, Accounts Receivables and Purchasing Modules.
• Developed outbound interface for GL Entries data file from Oracle to Black-line system.
• Developed inbound interface load data from OB10 System into Oracle Purchasing and Payable modules.
• Designed, implemented and analyzed Oracle application processes. Provided business flow diagrams for new enhancements.
• Developed Unbilled Receivables extract in Oracle Receivable module.
• Involved into producing Functional, Technical Specification, build walkthroughs, scope change, testing, integration, migration to Production.
• Creating and maintaining Applications, Responsibilities, Users, Concurrent Managers, Programs, and Menus, Function, Profiles and Flex fields under Oracle System Administration role.
• Maintain day-to-day operations of Oracle Applications and technical support.

Environment: Oracle Applications 11.5.10 and Release 12 (GL, AP, AR, PO, Oracle HR and Payroll, Oracle Advanced Benefits, AOL and System Administrator), Reports 6i, Oracle 10g, AOL, TOAD, SQL*Plus, PL/SQL, FTP, Work flow, SQL*Loader & Oracle 9i.

Confidential, Atlanta, GA

Technical Consultant

Responsibilities:

• Worked as a Technical Consultant for Confidential RICE components.
• Creating and maintaining Applications, Responsibilities, Users, Concurrent Managers, Programs, Menus, Functions, Profiles, Define Request Sets and Flex-fields under Oracle System Administration role.
• Involved in developing BEE interface using Oracle Apps standard API (pay batch element entry api ) and PL/SQL.
• Developed Conversions, inbound and out bound interfaces as per client requirement.
• Responsible for Creating/ registering AOL objects like Profiles, Value sets, Concurrent programs, etc.
• Worked on several technical design documents for the interfaces and conversions from GEAC system to Oracle.
• Responsible for re-work (bug fixing) during System integration testing.
• Developed scripts to register custom tables and table columns in APPS using AD DD package.
• Developed outbound interface for active employee data into Maxmo tool.
• Development and Customization of Oracle Standard Reports.
• Analyzing the root cause of repetitive issues and proposes an action plan for improvement to the management with work around.

Environment: Oracle Applications 11.5.10 (GL, AP, AR, PO, AOL & System Administrator), Reports 6i, Oracle 10g, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

Confidential, Boston

Consultant

Responsibilities:

• To make technical specifications on apps module.
• Developed Test Scripts (TE20 Documents) for various objects.
• Report Customization of Oracle Applications modules.
• Registration Customized objects for various modules
• Customized Print Purchase Order standard report as per client requirement.
• Analysis of Report/Interface Specifications.
• Registering Concurrent Programs using PL/SQL script file.

Environment: Oracle Applications 11i (GL, AP, PO, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

Confidential, Colorado

Consultant

Responsibilities:

• Involved in Migration of Objects (Reports, Interfaces, PL/SQL) from 11.5.3 to 11.5.9.
• Co-ordination with on-site team.
• Familiar with AOL and System Administrator.
• Developed and worked with interface various modules.
• Registration of Forms, Reports, Concurrent Programs and Tables.
• Customization of Reports as per the business requirements.
• Prepared test cases as per functional design to test the interface end-to-end.

Environment: Oracle Applications 11i (GL, AP, PO, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, SQL*Loader & Oracle 9i.

Confidential

System Engineer.

Responsibilities:

• Responsible for Creating/ registering AOL objects like Profiles, Value sets, Concurrent programs, etc.
• Prepared detailed design based on functional design and high level technical design.
• Prepared test cases as per functional design to test the interface end-to-end.
• Responsible for re-work (bug fixing) during System integration testing.
• Knowledge of Multi Organization concepts.
• Worked on Concurrent Programs like SQL*Plus, PL/SQL Stored Procedure and Oracle Reports.
• Testing the Developed Components with Front-End Tools.
• Worked on Production Support to fix the issues logged by the application users.
• Prepared Technical Design Documents.
• Worked with PVCS and Remedy to migrate the objects from one instance to other instance. Created migration documents for migration purpose.
• Register Concurrent Program using PL/SQL script.

Environment: Oracle Applications 11i (HR, Payroll, GL, AP, AOL & System Administrator), Reports 6i, AOL, TOAD, SQL*Plus, PL/SQL, FTP, UNIX, SQL*Loader & Oracle 9i.

Confidential

Trainee Associate

Responsibilities:

• Developed Master forms and transaction forms using Visual Basic 6.0
• Involved to design the database and develop scripts for creating the master-child tables.
• Developed Data Reports using Visual Basic 6.0
• Developed shell scripts to move data files from windows system (local system) to UNIX server.
• Developed SQL*Loader scripts to load data into Oracle tables.
• Involved to convert SQR reports into Oracle Portal 9i.
• Developed SQL*Loader scripts to load data into Oracle System.
• Setting up the application at the clients place and giving training to the end users.