EXPERIENCE SUMMARY

• Oracle ERP Techno - Functional Consultant with 9 years and 9 months of experience in offshore and onsite client facing roles and implementing/delivering multi-geography projects across diverse domains.
• Involved in various phases of projects including requirements analysis, solution and design, hands-on development, testing, application maintenance and deployment for end-to-end solution offering.
• Expert in developing PL/SQL Packages, Oracle XML Reports, Oracle Forms. In depth knowledge in Oracle PL/SQL programming and has knowledge in writing PL/SQL packages, stored procedures and functions, OAF Personalization, XML Publisher Reports, Cognos Analytics Reports, Oracle Discoverer, etc.
• Having implementation and production support background in Oracle Payables, Oracle Receivables, General Ledger, Cash Management modules. Experience in Inventory, Purchasing, iProcurement, Advanced Collections, TCA, Order Management, etc.

TECHNICAL SKILLS:

ERP - Oracle EBS:  Oracle Applications e-Business Suite R12

Modules: Accounts Payables (AP), Account Receivables (AR), General Ledger (GL), Cash Management (CE), Purchasing (PO), iProcurement, Advanced Collections (IEX), TCA, System Administrator, Application Developer

ERP Tools:  Report and Forms Builder 10g, BI Publisher, Cognos Analytics Reports, Discoverer, Noetix Views, Workflow Builder, SQL Developer, TOAD, PL/SQL developer, Oracle JDeveloper, Putty, WinScp

Programming Languages:  PL/SQL, SQL*Plus

Databases:  Oracle 9i, 10g, 11g

Version Control Systems:  PVCS, eChangeman, SVN

Other Tools:  MyGIT, Remedy, eChangeman, Kintana An

EMPLOYMENT HISTORY:

Confidential

Techno-Functional Consultant

Responsibilities 

• Conduct meetings daily with Project Manager, Functional Owners, DBAs.
• Building, modifying reports with Cognos Analytics Tool (on to of Noetix Views) that is scheduled to replace existing Discoverer Reports.
• Noetix Views modification and query updates with Noetix Workbench version 6.5.
• Preparation of Unit Testing scripts, Functional Testing documents for the existing processes that includes all the standard Functional Flows across AP, AR, GL, PO, iProc Modules, etc.
• Functional Testing of Financial Modules and applications after the upgrade to 12.2.4.
• Functional Testing of Financial CEMLI components after modification and retro-fitments with the upgrade.

Confidential

Onsite Technical Development Team member 

Tampa, US

Responsibilities 

• Conduct meetings daily with Citibank Functional and Technical Leads on requirement analysis, design and testing.
• MD70 design and review for the RICEW components.
• Preparation of Unit Testing scripts, Functional Testing documents.
• Complete Design and Development and Testing of PLSQL package AP Supplier/Site Update program for Future End Date Removal.
• Development and modification of PO Requisition Tracking report using Discoverer Admin, Desktop. Building Discoverer View query.
• AP Workflow Notification update for SSI Invoice program.
• Unit testing PLSQL programs with Sample Data and sharing and discussing test results with business for review and validation.
• SSI Invoice (Java Application) functional end to end testing for Workflow process.
• OAF Form Personalization of iProc Additional Attributes for prompt update.
• PLSQL Program performance testing and tuning

Confidential

Onsite Data Transformation Team 

Minneapolis, US

Responsibilities

• Conduct meetings daily with Business Data Owners, Legacy and Oracle Functional Analysts for CV40 preparation.
• CV40 Preparation that includes Building Extraction Logic, Source, Destination data mapping, Writing Business Purpose, Reconciliation Methods, building SQL for reconciliation.
• Transforming Legacy Data into Specific Oracle Template format for Data Conversion.
• Loading data into Oracle, doing validation and Import.
• Inform Data Owners, Legacy Business about error data.
• Correcting Validation Errors that fails Oracle Standard validation and fixing PL/SQL code.
• Working on bugs and enhancements on Inventory On-Hand Balance, Item MinMax loader, ABC Assignment, User Defined Safety Stock, Item Default Stock Locator inbounds conversion programs.
• Preparing Final Reconciliation report after Data Conversion process completes in Oracle.
• Unit testing conversion programs with Sample Data.
• Run Pre-Validation of data before actually loading into Oracle.
• Informing Business about the Data Loading Status about Success and Error Records after data conversion program completes at Oracle.
• PLSQL Conversion Program performance test

Confidential

Offshore Techno-Functional Consultant 

Responsibilities

• Resolving all critical technical issues raised by the business users in Oracle Financial Applications.
• Trouble Shooting.
• Supporting Accounts Payables, Accounts Receivables, General Ledger, i-Expenses, i-Procurements standard and custom interfaces and reporting.
• Helping Onsite and Offshore co-ordination and Client and Mattel business and co-ordination.
• Conducting the reconciliation activities, period close activities during month-end.
• Involved in detailed level impact analysis, regression testing with business users on change requests so that these do not impact existing functionalities
• Performance tuning on existing processes and monitoring database health on every day basis
• Performance Improvement process of other PL/SQL inbound and outbound interfaces, views, etc.
• Unit Test plan design and execution

Confidential

Techno-Functional Consultant

Responsibilities

• Preparation of Functional specs, Technical design for Enhancement, Outputs, Reports, Interfaces.
• Trouble Shooting.
• Supporting business on day to day activities.
• Conducting everyday meetings with 4 shores (Brazil, US, UK, India) and updating customers with the process improvement.
• Solving issues and delivering new Change requests.
• Supporting Brazil month end issues, i.e. accounting issues, Scoring Engine Performance issues, data issue, reconciliation issue, interface issue.
• Development of Brazil Bank Return Process that involves 8 custom PL/SQL packages
• Development and support for Outbound PL/SQL Programs like Collection Campaign and integrating with Brazil Bank Collection Process.
• Performance Improvement process of other PL/SQL inbound and outbound interfaces.
• Unit Test plan design and execution

Confidential

Senior Developer and EBS Technical Consultant  

Responsibilities

• Daily meeting with client Experian and understand their requirement in the implementation phase.
• Designed and written PLSQL conversion programs for AR invoice, AR receipts, AR Customer interface.
• Implemented the method of custom validation part of interfaces with external table and validation rule file. Where the required query and conditions were kept in a file and in the interface, we used an external table to access the file on run time and hence made the validation dynamic, only simple change in the rule file(a simple excel file) would be sufficient to add a new validation. This idea got a very good appreciation from customer.
• Designed Complex Invoice Print Report, Statement Print Report for Experian US where we made use of Bursting Control, XML Sub Templates, etc.
• Designed Dunning Letter Report, Invoice Print report in Japanese Language for Japan ACare Project.
• Have worked on Bank Statement Import for Japan ACare unit.

Confidential

Technical Consultant

Responsibilities

• Designed and written PLSQL outbound conversion programs for AR invoice, AR receipts from Oracle 11i
• Designed Outbound PLSQL Interfaces for US Finance Charges, AR Statements to Billing,
• Designed Outbound Interface for AR to OMCF (Billing system for UK Experian)
• Designed AR Invoice Print Report for Experian US, Statement Print Report for Experian US and UK.
• MD70 and Unit Test Plan design and execution.
• Have worked on Bank Statement Import program.

Confidential

Technical Consultant

Responsibilities

• Design and Development of Oracle Financial Interfaces like AR Invoice and Receipt import, AP Invoice import with PLSQL programming.
• Development of complex report across modules like Oracle AR, AP, GL, OM, PO, etc.
• Building new and complex report for customer as part of enhancement.
• Development of custom PF Forms for AP and custom Mining module forms.
• MD70, Unit Test Plan Design
• Meeting with clients for requirement analysis and design

Confidential

Technical Developer 

Responsibilities

• Testing and bug fixing of Reports for AR, AP, etc.
• Bug fixing on custom PLSQL GL Journal Import
• Development of Custom Transaction and Receipt Register report for AR as part of Change Request.
• POC on OAF with JDeveloper 9i for Self Service application of HRMS.
• Custom Finance CForm Design for AP as part of CR.