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 IN, 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 Workflow,
• Oracle Discoverer 10g/9i/4i, XML/BI Publisher, SQL PLUS, SQL Loader,
• Toad, 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

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. Multi Language Support Lead

Responsibilities:

• Lead and drive all Multi Language Support MLS enablement activities from off site for LATAM and Brazilian Portuguese.
• 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.