We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

San Jose, CA

SUMMARY:

  • Having 10 years 10 months years of experience as an Oracle applications (E - Business Suite) Tehnical consultant,with expertise in Financials (General ledger (GL), Account Receivables (AR), Account Payable (AP), Payments, Cash Management, Fixed Assets(FA)), SCM (Order Management (OM), Purchase Order (PO), Oracle Inventory ( INV) , shipping (WSH)), and Oracle Projects (Project Costing, Project Billing and Project Contracts), Oracle Time and Labor (OTL), XML Gateway, System Administrator(FND).
  • Worked on Implentation, Support, Upgradation projects and having experience in AIM methodology. Excellent analytical skills in Analysis and business requirements gathering from end users to help design MD50 and design MD70 documents.
  • Expertise to develope RICEW ( Reports, Interfaces, Conversions, Extensions and Workflows ) components.
  • Good exposure in Order to Cash (O2C ) and Procure to Pay (P2P) Business flows.
  • Expertise in Design/Development of Interfaces using Oracle opens Interfaces and Oracle Public API’s
  • Excellent in Data conversion/integrations from Legacy/external systems into Oracle Applications using PL/SQL, SQL*Loader etc .
  • Extensively worked on Oracle Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
  • Good exposure in BI Publisher(XML Publisher), which includes report development objects like data templates and RTF’s.
  • Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Advanced PL/SQL data types like Record Type, Table Type, Bulk Collect and SQL * Loader scripts.
  • Expertise working with Oracle 7.x/8.x/9i/10g/11g, Developer 2000, PL/SQL, Forms 6i/9i/10g, Reports 6i/9i/10g, SQL * Loader, Discoverer 3.x/4.x/10g and XML/BI publisher 5.6.2.
  • Experienced with Performance Tuning, Optimizing SQL, PL/SQL scripts and with UNIX shell scripts
  • Used Trading Community Architecture (TCA) APIs to create/Update Parties and Relationships.
  • Experienced in Customization Forms and Forms Personalization.
  • Experienced in performance Tuning and analyzing using Tkprof, SQL Trace, and Explain Plan.
  • Involved in analysis, design, development, testing and implementation of medium to large scale projects.
  • Strong communication skills with ability to manage expectations of Business and IT users. Possess good organizational, analytical and problem solving skill.
  • Onsite client experience in United Kingdom, Romania and United States.

TECHNICAL SKILLS:

ERP: Oracle applications 11i/R12 (Financials, O2c, PTP,Projects and OTL).

Development Tools: Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i/, Oracle WorkflowOracle Discoverer 10g/9i/4i, XML/BI Publisher, SQL*PLUS, SQL*LoaderToad, SQL Navigator

Databases: Oracle 11g/10g/9i/8i Languages PLSQL, XML, UNIX Scripts

Operating Systems: Windows XP/NT/2000/98/95, UNIX, LINUX

WORK EXPERIENCE:

Confidential, San Jose, CA

Oracle Apps Technical Consultant

Responsibilities:

  • Involved as the Reports and Extensions Lead at onsite (US).
  • Driving Delivery of complex workflows like Requisitions, PO Approval and AP Invoice.
  • Developed Bank of America payment interface using BAFF and UBAFF formats
  • Co-ordinations with onsite (including client) and offshore on regular basis.
  • Daily updates to management on progress, issues, risks and resolutions.
  • Interaction with functional team for effort estimates on CR and feasibility study.

Environment: Oracle applications R12, Unix, Oracle Database 11g. Modules SCM, AR, GL, PA, AP. Windows-2007, Unix

Confidential

Oracle Apps Technical Consultant. Technical Lead

Responsibilities:

  • Involved in the scoping activities of the project.
  • Created the ramp plan and execution plan for the project. This had to undergo multiple iterations and planning activities
  • Understand the requirements and get POC done for some objects along with client and internal resources. Propose feasible solutions.

Environment: Oracle E-Business Suite R12 (Multi Language enablement of 2 languages), Unix, Oracle Database 11g . Modules SCM, AR, GL, PA, AP.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Assisted client in technical questions/ understanding.
  • Also presented the demo for MLS along with the key technical changes needed
  • Co-ordinate with project team from US and Mexico to make sure the MLS patch is applied and tested properly.
  • Identified risks and issues and their mitigation actions for MLS.
  • Helped Functional team with queries and data for MLS testing for localization requirements.

Environment: Oracle E-Business Suite R12 (Multi Language enablement of 2 languages), Unix, Oracle Database 11g .

Confidential

Oracle Apps Technical Consultant / Conversion Lead

Responsibilities:

  • Lead and drive all data conversion of the project
  • Assisted client in technical questions/ understanding.
  • Lead the technical team for data conversion and get deliverables complete from the team
  • Co-ordinate with client for conversions and helped schedule/complete data mapping activities
  • Identified risks and issues and their mitigation actions for conversions.
  • Escalated risks to project leadership to ensure proper mitigation.

Environment: Oracle E-Business Suite R12, Unix, Oracle Database 11g . General Ledger, Payables, Receivables, Assets, Cash Management, Human Resources, Purchasing, Inventory, Bill of Material, Work in Process, Projects, Project Contracts, India Localization, Order Management

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Lead the team in India to complete the technical aspect of the deliverables of Oracle Applications
  • Designing the high level technical solution from the functional and business requirements for the extensions.
  • Creating detailed technical designs from functional specification documents for the deliverables
  • Handling major extensions for modules Oracle Project Costing and Oracle Project Contracts.
  • Building the code of complex objects for the extensions.
  • Reviewing documents and code of other peers for quality
  • Helped team members find solutions for their challenges in their deliverables.
  • Interact with functional team members for understanding the requirements and solution designing from a process perspective and also end to end technical testing of the deliverables.
  • Provide status updates to all other key members of the project.

Environment: Oracle applications R12, Unix, Oracle Database 10g. Project Costing, Projet Billing and Project Contracts, Developer 10g, Xml Publisher, Unix, Shell Scripts.

Confidential

Oracle Apps Technical Consultant / Lead

Responsibilities:

  • Lead the team in India to complete the technical aspect of the deliverables of Oracle Applications
  • Designing the high level technical solution from the functional and business requirements for the conversions and Interfaces.
  • Creating detailed technical designs from functional specification documents for the deliverables
  • Handling all Major Interfaces and conversions for the GL module.
  • Building the code of complex objects for the conversions and Interfaces.
  • Reviewing documents and code of other peers. (quality)
  • Helped team members find solutions for their challenges in their deliverables.
  • Interact with other technical teams from Client and other vendors for solution designing from a process perspective and also end to end technical testing of the deliverables.
  • Provide status updates to all other key members of the project.

Environment: Oracle applications R12, Unix, Oracle Database 10g/8i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Shell Scripting, TOAD. Oracle Financials

Confidential

Oracle Apps Technical Consultant / Lead

Responsibilities:

  • Lead and Manage the Bangalore Team. The complete offshore team was spread across locations.
  • Provide Daily status updates to all other leads from offshore and onsite.
  • Developing Technical Designs and code for the conversion of Receivables Open Invoice conversion and Receipts Conversion.
  • Making Technical Design of other reports like Standard Invoices, Superbill, Statements, etc. for junior resources to do the build.
  • Worked on workflow customization
  • Also designed and developed XML publisher reports.
  • Reviewing documents and code of other peers. (quality)
  • Helped team members find solutions for their challenges in their deliverables.

Environment: Oracle applications R12, Unix, Oracle Database 10g/8i, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Shell Scripting, TOAD. Oracle Financials (AR, AP, GL) and Supply Chain Management (OM, Pricing)

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Developing Technical Designs for the conversion of Payables Open Invoice conversion.
  • Build of the components Payables Open invoice conversion
  • Review of documents and code done by other peers.
  • Helped team members find solutions for their challenges in supplier conversion and Bank account creation.

Environment: Oracle Applications R12, 11.5.10, Oracle 10g/9i, Unix, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Shell Scripting, TOAD. Oracle Financials (AP, GL)

Confidential

Oracle Applications Technical Consultant

Responsibilities:

  • Developed the Inbound for receiving Purchase Orders
  • Developed 2 outbounds for sending Invoices and Credit Notes
  • Developed Oracle Discoverer Business Area and Reports for error handling.
  • Developed the HTTPS and Servlets programs for the connectivity of third party systems
  • Usage of XML Gateway in a customized way. This includes DTD and XML along with connection establishment using a core JAVA.
  • Developed the RMA return custom check program in Revel
  • Handled the whole technical coding for MTIC
  • Developed an interface to created receipts in receivables from bank statement.
  • Contra project complete technical handling. Build a Contra form which knows of AP and AR balances for dealers (customer and supplier). Also developed reports. Mentoring and leading a junior resource from Romania.
  • Part of the support team where we handle trouble tickets and close them in time.
  • Travelled to United Kingdom and Romania for Gechnical work and Knowledge transfer.

Environment: Oracle Applications 11i, Oracle 8i/9i, Unix, Pl/SQL, SQL*Plus, SQL*Loader, Reports 6i, Shell Scripting, TOAD, Discoverer 4i/10g. Oracle Financials (AR, AP, GL, CM), Oracle Projects (PA), Oracle Time and Labor(OTL), XML Gateway, Order management (OM) and Oracle HRMS

Confidential

Oracle Applications Technical Consutant / Developer

Responsibilities:

  • Module Lead for the Oracle General Ledger (GL) module. There were a total of 3 members working for the module.
  • Complete Analysis of each and every object and solutions for the same which was to make the objects Multi-Org compliant.
  • Active participation in problem solving for other modules whenever possible.
  • Handled all Major Interfaces for the GL module.
  • All deliverables delivered on time which includes the Code, Documents (MD70, UTC and Code Reviews). All objects tested thoroughly and hence complaints from the client.
  • Done Code Review for other Modules like AP, PA and PO

Environment: Oracle Applications 11i (GL, AP, PA and PO), Oracle 8i, Forms6i, Reports 6i, PL/SQL, SQL*Loader, Unix.

Confidential

Oracle Applications Technical Consutant / Developer

Responsibilities:

  • Have worked on Purchasing Track. Even though the timelines have been very aggressive have delivered the objects on time with negligible defects ratio.
  • Also have helped other team-mates whenever help was required. Also help in making a document for K-Net which gives the table level changes (PO) from 10.7 to 11i.
  • Also worked on 11i BPR and 11i SSR projects as part of 11i upgrade. The objective of this project is to streamline the existing Planning and Procurement process for the ‘Buy’ components in Confidential specific Plant (i.e. the SBC-T plant.)It also deals with the approach for SSR i.e. Solution Sourcing Rules for Global Sourcing Rules Impact in the existing price book available in 10.7 to make in order with the oracle 11i standards at Master Org Level (ZGL organization).

Environment: Oracle Applications 11.5.9 and 10.7, D2K Forms 6i and Reports 6i, Unix, Oracle 7/8i, PL/SQL, SQL*Loader, Unix.

Confidential

Oracle Applications Technical Consutant / Developer

Responsibilities:

  • Created business area using complex SQL query
  • Developed 16 reports in Oracle Discoverer.

Environment: Oracle Applications 11.5.8, Oracle Discoverer 4.1.47, Oracle Fixed Assets (FA).

Confidential

Oracle Applications Technical Consutant / Developer

Responsibilities:

  • Developing Reports using Oracle Discoverer. Includes creation of Business Areas in Discoverer Administration and Developing Reports in Discoverer Desktop and Discoverer Viewer.
  • Developing TDs and UTCs.
  • Created a User Guide.
  • Created other documents like Installation Documents.
  • Also was a part of the complete support phase of the project.

Environment: Oracle Applications 11.5.8, Oracle Discoverer 4.1.47, Oracle Time and Labor (OTL), Project Accounting

Hire Now