SUMMARY:

• Over 10+ years of extensive experience as Oracle Application Technical Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
• Experience in implementation, Migration, Customization and Production support of various modules in Oracle Applications with major focus in Inventory (INV), Purchasing (PO), Order Management (OM), Accounts Receivable (AR), and Accounts Payables (AP).
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
• Expertise in designing and implementing Oracle Alerts and Lookups.
• Fair Knowledge in customizing existing OAF Screens, Forms and Reports as per business needs.
• Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
• Dexterous in Customizing Oracle Reports and developing new Reports by using Oracle Report 6i/10g and XML Publisher (BI Publisher).
• Developed new Concurrent Programs, Custom Forms and Flex Field Customizations.
• Extensively used TCA (Trading Community Architecture) to create customers in AR.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow and modified the formats using XML publisher for customizations as per client specification.
• Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL FILE, Oracle packaged APIs etc.
• Expertise in Requirement analysis, System design, Dataflow designs, Support, Development, Testing, Documentation and Design reviews.
• Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
• Experience in customizing Oracle Workflows such as the PO approval process, Order/Line flow to send user notifications based on the business requirement.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
• Excel in team collaboration, quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS:

Technical: Strong Technical skillset and background of development in Oracle E-Business suite RICEW (Reports, Interfaces, Conversions, Enhancements, Workflow) Components in SCM, Financials and HR modules. SQL, PL/SQL, XML Publisher. Workflows, Form Personalization

Functional: Excellent Techno-functional knowledge in Order to Cash, Procure to Pay cycles.

Tools Used: PL SQL Developer, TOAD, Putty, Data Loader, BI Publisher, Forms & Reports 6i, Forms 10g, Workflow builder 2.0. Oracle ERP Modules including Oracle Purchasing, Inventory, Account Receivables, General Ledger, Account Payables, Order Management.

Methods: Software Development Life Cycle (SDLC), Product Life Cycle Management (PLM) Application and Oracle AIM Methodology(Application Implementation Methodology)

PROFESSIONAL EXPERIENCE:

Confidential - Orrville, OH

Oracle Apps Technical Consultant

Environment: Oracle R12, Oracle Database 11g/10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQLUNIX Scripting, WinSCP, Putty, ALM HP Quality Center, Control-M.

Responsibilities:

• Involved in the Analysis phase of the project.
• Preparation of MD70 Design documents from MD50.
• Development of Inbound Interface.
• Creation of Purchase Requisitions using Requisition Import process.
• Creation of Purchase Orders from Global Blanket Agreement and Approved Supplier List.
• Backflush of Raw Material Quantities from Ship to Warehouses.
• Email alerts to Users for the errors during the Purchase Order creation process.
• Development of custom Forms.
• Involved in the Analysis, Design, Development, Test and support phases of the Project.
• AR Invoice Interfaces.
• Account Payables to Suppliers during the Procure to Pay process.
• Oracle Forms personalization to achieve business requirements.
• Involved in registration of Forms, Reports using AOL.
• Created Oracle FND Messages
• Created Descriptive Flex fields.
• Created Oracle Form Functions.
• Created Oracle Database Triggers to send the data during an update on the tables.
• Performance tuning for SQL queries.
• PL/SQL packages to extract the data and FTP the files to External systems.
• FNDLOAD to migrate the Concurrent Programs, Lookups etc. to other Oracle instances.
• Preparation of Unit test scripts.
• PL/SQL packages to extract the data from Oracle tables and perform the operations.
• Creation of Oracle Request Sets and Concurrent programs.
• Sales Orders conversion in Order Management.
• Item Conversions in Inventory.
• Inbound and Outbound Interfaces.
• Shipping Interfaces to Other systems.
• Development of PL/SQL BULK collects to load huge volumes of data.
• PL/SQL Object types.

Confidential - Phoenix, AZ

Oracle Apps Technical Consultant

Environment: Oracle Applications Release12.2.4 (GL, AP, AR PO, INV, HR, OM), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, Forms Builder, Report Builder, Workflow builder, JDeveloper.

Responsibilities:

• Working in the production support team designing and developing RICE components for enhancements (Change Requests and Service Requests) in supply chain and financial modules.
• Working closely with the functional team to know the requirements and work according to MD 50 Document and prepare Technical Design Documents.
• Hands on experience in creating XML/BI Publisher reports, RDF reports as per the client requirements on AP, AR, OM, GL, PO, INV, Core HR modules.
• Resolving the issues and migrating the changes to the Production Environment using the Version Control tool like SVN.
• Hands on experience in customizing the Oracle Seeded Reports and migrating them in production environment.
• Hands on experience in Form Personalization’s and using Custom.pll.
• Worked on extending OAF pages which include creating CO, AM, VO, EO components, creating radio buttons, LOV (Inline and External) on pages.
• Worked on Forms Personalization for adding a new menu in Tools ‘Create Contract’ which on click executes the procedure and invokes a request submission.
• Worked on Version Control software to check-in codes and integrated with SVN for file migration. Used FND-LOAD to migrate concurrent programs, request sets, forms menus and Personalization, by downloading the LDT files.
• Query optimization and tuning using tools like PL SQL Developer and TOAD.

Confidential - Holland, OH

Oracle Apps Technical Consultant

Environment: Oracle Apps EBS R12, PO, INV, OM, AP, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow, OAF.

Responsibilities:

• Worked as Oracle Apps Data Migration Consultant in various Oracle Implementations,
• Specializing in modules like OM, PO, INV, AP.
• Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated .fmx executable file to $AU TOP on forms server of client.
• Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables. Implementation involves design and development of various objects using Oracle SQL & PLSQL, Oracle Forms, Oracle Reports and Oracle Discoverer.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).
• Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. Its displays the discount amount calculated for that order basing on the payment terms of the order.
• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.
• Automated the process of encrypting and archiving.
• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.
• Developed PL/SQL scripts for validating the data and Storing the data into MTL SYSTEM ITEMS INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
• Used Bulk Collect feature to improve performance.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables.
• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.
• Developed Order Constraint, Process Constraints, Pick Release Program.
• Developed Sales Order And Price List Form Personalization.
• Developed and worked on various customer facing reports.
• Extensive experience in database querytuning(Explain Plan and TKPROF utility) of Reports.

Confidential - Wood Dale, IL

Oracle Techno-Functional Analyst

Responsibilities:

• As anAAR Team member, workedon designingand implementing theOracleEBS11i/R12OracleApplications. - Order to Cash andProcure to Pay, andHR Modules.
• Coordinated and participated the entire phase of the project which included initial operations analysis, business process re-evaluation,integration,testing,training,conversions, customizations and documentation and implementation of modules.
• Involved and Performed functionalsetup/configuration for a new organization Sweden to OracleFinancial, HR,and Supply Chain Modules.
• Designing, coding, and testing interfaces, conversions,reports,forms, and extensions.
• Developed and testedcustomers, Items,BOMs,Vendors,andPrice Lists Conversionsfor Telair SwedenImplantation. PerformedImport Process to loadthedata from interface toOracle tables.
• Modified and Tested EDI OrderInterfacesusingAPIs.
• Performed Auto Invoice and Auto Create Processusing OpenInterfaces.
• Designed,Modifiedand testedHREmployee Time Entry/ITAR formsand packages.
• Designedand testedinvoices/shippingrelatedreportsusingXMLPublisher,andOracleReports.
• Performed and ResolvedOracleWorkflow related issues/errors inOM/Purchasing.
• Performedtechnicalspecification design, development, unit testing, system integration testing, UAT and maintenance ofOraclee-business suite of Applications.
• Assisting and Performing patch’s testing in dev, test, and productionsystem.
• Created and modifiedSQL scripts,functions, triggers, procedures, tables and views.
• Assists the other developers in coding and testing usingOracleApplications.
• CoordinateOracleservice requests and drive them to a final resolutionfor functional or technicalissues. Resolvingproduction issues for existing Organizations and fixes bugs in the programs.

Confidential

Senior Technical Account Manager

Environment: Oracle Apps EBS R12, PO, INV, OM, AP, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow, OAF.

Responsibilities:

• Working for Oracle Advanced Customer Support, provide expert support during different phases of Oracle E-Business Suite implementations.
• From discovery sessions, analysis and requirement gathering to Documentation/Solution reviews for standardization. Functional and Technical expert solutions in critical stages of a project to help client and implementation partner in successful implementation.
• Core working areas are Interfacing/APIs, integration development and building out of the box business solutions.

Confidential

Project Management

Responsibilities:

• Prepare & Review project plans with partner.
• Conduct meeting with UBL management and partner on different issues.
• Share expert opinion and inputs from Oracle perspective.
• Ensure quality and on time completion of activities.
• Conduct UAT sessions, issues resolution and sign off
• Ensure target go-live completion (HR and Payroll for international BGs gone live and signed off)
• Help team build APIs for data checks and validations for employee historical data migration
• Split up activities in short activities and set target dates to ensure deliverable quality and on time completion
• Prepare plan for short activities and get follow ups
• Get the status on different plans from partner, review it and share with client
• Review Solution design documents and get sign off from client
• Supervising customized application components of Funds Application and it’s integration with standard application.

Confidential

Senior Technical Account Manager

Responsibilities:

• Data review and mapping on standard data templates
• Help client in data preparation and cleansing
• Build APIs for data checks and validations before uploading to interfaces
• Documentation and sign off

Confidential

Senior Technical Account Manager

Responsibilities:

• Configuration of new entity with complete setups
• Implementation of solution to the new entity setting up ledgers and OUs
• Data review and mapping on standard data templates
• Help client in data preparation and cleansing
• Build APIs for data checks and validations before uploading to interfaces
• Documentation and sign off

Confidential

Senior Technical Account Manager

Responsibilities:

• Conducting knowledge sessions with client to make users understand the data template for a particular data set
• Data review and mapping on standard data templates
• Help client in data preparation and cleansing
• Build APIs for data checks and validations before uploading to interfaces
• Documentation and sign off