SUMMARY

• Around 9 Years of experience as Oracle E - Business Suite Techno Functional Consultant with proven expertise in Implementation, Customization, Upgrade and Support of Oracle Applications ( R12 and 11i)
• Expertise in Design, Development and Support of Oracle Forms, Reports, Interfaces, Conversions, Extensions, APIs in the Financials modules of Oracle E-Business Suite R12
• Implementation of Setups and configurations in Oracle Projects Accounting (Projects Costing, Projects Billing) and its integrations with AR, AP, SLA and GL.
• Strong expertise in Design and Development of Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML/BI Publisher Reports and API’s
• Proven experience in design, development and support of core processes in Oracle E-Business Suite using Pro*C and Unix Scripting
• Expertise in developing complex APIs, extensions, interfaces and conversions using SQL and PL/SQL
• Reengineered Oracle Projects Billing and Oracle Contracts processes for Federal Customers helping them to upgrade from Oracle Projects 11i to R12.2.4 and saving 70 million USD in upgrade costs for them.
• Experience in creation/modification of AIM documents MD050/MD070/MD120.
• Performance Tuning of Oracle Applications and SQL & PL/SQL, using SQL Advisor, SQL Tune, TKPROF.
• Involved in Oracle Fusion Data Migration for the Projects Module.
• Experience in using the Agile Methodologies in application development.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, views, Collections, records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.

TECHNICAL SKILLS

• Oracle E-Business Suite R12/11i
• Oracle Projects Accounting( Billing and Costing)
• Expenditure Costing and Accounting
• Interface of transactions to Projects ( Transaction Import ) and from Projects ( Interface Invoice to Receivables )
• Revenue and Invoice Generation
• Expenditure
• Revenue and Invoice Adjustments
• Auto Accounting
• Agreement
• Funding and Budgets
• Intercompany Billing
• Oracle Subledger Accounting (SLA)
• Create Accounting and interface of Expenditure and Revenues of Projects to SLA
• Oracle Accounts Receivables (AR)
• Interface of Draft Invoices of Projects to AR
• Oracle Accounts Payables (AP)
• Supplier Invoice and adjustments and their import into Projects for Costing and Accounting
• Oracle PL/SQL
• Procedures
• Functions
• Packages
• Collections
• Objects and Records
• Bulk operations
• SQL Query Building
• Oracle Database 11g/10g/9i
• Tables
• Views
• Synonyms
• Context Variables
• Virtual Private Database
• Performance Tuning
• Pro*c
• Oracle Forms
• Oracle Reports
• XML Publisher/BI Publisher Reports
• Oracle AOL ( Application Objects Library )
• Oracle Application Framework ( OAF)
• Datawarehousing ETL using Oracle PL/SQL and Job scheduling using crontab Unix and Autosys

PROFESSIONAL EXPERIENCE

Confidential, California

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD20 (Functional Spec) and then writing CV040 (Technical Spec) for the new functionality
• Design and development of new processes, reports, extensions and APIs to process the business logic
• Design/Development of Oracle Forms 10g to capture new funding modifications, bill group, project setup and invoice review
• Design/Modification of processes of Revenue Generation and Invoice Generation for billing the federal contracts using Pro*C
• Development of new API’s and enhancing Public API’s to capture additional fields and validations
• Development of Extensions for the processing of Cost Reimbursable and Fixed price contracts
• Modification of outbound Interface to AR which interfaces Projects Invoices
• Doing Cost Benefit Analysis of the price quoted by the suppliers on the request of buyers.
• Cost Calculation of Project and profit analysis.
• Develop feasibility studies and business plans to support new lines of products and services
• Development of SF1034 / SF 1035/ SF 1443 reports using XML/BI Publisher.
• Modification of AOL Objects like lookups, value sets, reports parameters, messages, menus and functions.
• Design/development of database objects like tables, views, synonyms, sequences, packages, procedures, functions using SQL, PL/SQL
• Creation of MD050, MD070 and MD120 Documents for the implementation of Federal Contracts billing

Environment: PL/SQL, Pro*C, Oracle Forms and Reports, XML/BI Publisher, Oracle 11g, Oracle E Business Suite(EBS) R12 12.2.4+, Projects Accounting (PA), Sub ledger Accounting (XLA), Accounts Receivables (AR), Oracle Project Contracts ( OKE), SQL Developer, Form Builder, Report Builder, OAF.

Confidential, California

Oracle Apps Techno Functional Consultant

Responsibilities:

• Design and Modification of the Intercompany Invoice Generation Process to honour transactions across legal entities in a single OU
• Design and Modification of Oracle Forms like Implementation Options, Provider receiver controls and invoice review
• Design and creation of new API’s and Public API’s
• Creation of new process called Invoice Regrouping using Pro*c and PL/SQL which enables customers to generate invoices based on a division ( called bill group)
• Development of Extensions to override Customer site and vendor
• Modification of Auto Accounting parameters to include legal entity parameters
• Modification of AOL Objects like lookups, value sets, reports parameters, messages.
• Design/development of database objects like tables, views, synonyms, sequences, packages, procedures, functions using SQL, PL/SQL
• Modification of the Interface to AR process to include Provider and receiver legal entities
• Creation of MD070 documents

Environment: PL/SQL, Pro*C, Oracle Forms and Reports, XML/BI Publisher, Oracle 11g, Oracle E Business Suite(EBS) R12 12.1.3, 12.2.2, Projects Accounting (PA), Sub ledger Accounting (XLA), Accounts Receivables (AR), SQL Developer, Form Builder, Report Builder, OAF

Confidential, New Jersey

Oracle Applications Techno Functional Consultant

Responsibilities:

• Support and enhancements for the Oracle EBS 11i implementation of Projects Accounting
• UAT Support for the Upgrade of 11i to R12
• Customizations and API development as per the business needs of the bank
• Running the Concurrent requests and building custom reports using Oracle reports and XML/BI Publisher
• Development of views, packages, procedures, functions and other database objects for reporting purpose using PL/SQL and SQL.
• Issue tracking and resolution of Oracle Project Billing Module implementation in the bank
• Performance Tuning of the queries and the packages developed.
• Migration of entire objects to SIT, UAT environments and supporting the process.
• Analysing the issues, impact analysis, maintaining the technical documents.

Environment: PL/SQL, UNIX, Oracle Forms and Reports, Oracle 11g, Oracle E Business Suite (EBS) 11i and R12, Projects Accounting (PA), Sub ledger Accounting (XLA), General Ledger (GL), Toad, Unix putty, Autosys

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Development of new reports and custom forms
• Re-implementation of Oracle Apps 11i and R12 with upgraded features
• Mapping the Inbound Interfaces to oracle projects for transaction import
• Monitoring and troubleshooting the interfacing problems
• Implementation support of Oracle Projects Module
• Develop Oracle forms and reports 6i using developer 2000
• Develop API’s, Extensions, Conversions and Interfaces using PL/SQL
• Develop customer views, tables and other database objects used in staging and interfacing
• Support oracle projects implementation and resolve the issues during the re-implementation

Environment: PL/SQL, Oracle Forms and Reports, XML/BI Publisher, ODI, Oracle 11g, Oracle E Business Suite(EBS) R12 / 11i, PA, XLA, AR, GL, AP, SQL Developer, Form Builder, Report Builder, OAF