Oracle Apps Technical Consultant
Experis
Total years of experience :11 years, 9 Months
• Create Location Setup Of Dubai Operating Units
• Create Grade and title Setup for Dubai Operating Units
• Create New Responsibility and Security Profile.
• Create inbound process for Employee Data creation from Taleo to Oracle.
• Create Outbound Process to flow data from Oracle to Multiple Application.
• Migrate Employee data from sql loader use of oracle API
• Form Personalization.
• Define and Create DFF and KFF.
• Create Package and Procedure for EIT and SIT.
• Create Package for Oracle APPS(HRMS
• Write Procedure, Function, View, Package.
• Create procedure and function for SIT and EIT.
• Create Concurrent Program for inbound and Outbound Process.
• Create Custom API for Oracle HRMS.
• Create concurrent programs and package for HRMS, Payroll Module, AR and AP module
• Form Personalization.
• Create API for seeded table.
• Create Lookup and it migrate to other instance USING Putty.
• Deploy Rest service using Integrated SOA gateway.
• Using ACE tool for deploys custom code for other Instance.
• Define and Create DFF and KFF.
• HRMS Functionally support.
• Create Package and Procedure for EIT and SIT.
• Create Package for Oracle APPS(HRMS, PAYROLL).
• Write Procedure, Function, View, Package.
• Form personalization.
• Create procedure and function for SIT and EIT.
• Data Base Maintenance, Performance tuning.
• Writing T - SQL queries, Store procedure, Functions, triggers and Cursor, Create backup and restore the database and troubleshoot the requirement.
• Data Conversion and data loads from various database and file structures
• Created views to restrict access to data in a table for security.
• Creating Product Table Structures and Transactional Table structure.
• Mapping of Table MS SQL 2012 to Oracle through ODI.
• Write Procedure, Function, Package in Oracle Apps.
• Form Personalization in Oracle Apps.
• Backend Support.
• Writing T - SQL queries, Store procedure, Functions, triggers and Cursor, Create backup and restore the database and troubleshoot the requirement.
• Data Conversion and data loads from various database and file structures
• Created views to restrict access to data in a table for security.
• Extraction of Legacy Data from different Billing Agencies from different database platform.
• Creating Table Structures for all 3 Discoms of Rajasthan (JVVNL, AVVNL & JDVVNL) according to the structure required by Billing Software.
• Study of Legacy Data of different current Billing Agencies of RSEB.
• Mapping of Legacy Data of different Billing Agencies according to destination database.
• Helping Team Members to understand the Utility requirements from Migration perspective and co-coordinate with them to make understand the Logics that has to handle during Migration.
• Preparing Migration Logic between Legacy Data & different tables of ELP Soft.
• Formatting & Cleansing of Legacy Data according to the table structure or through different schemas and sequentially uploading the same in SQL Server for transformation that has to be uploaded in different tables of destination database (ELP SOFT).
• Interacting with Functional Team, Technical Team & Client for finalization of all the logics that has to be incorporated while Scripting Store Procedures.
• Transformation of Legacy Data according to Logics Provided by Utility and Functional Team.
• Scripting of Store Procedures for CRM & Billing Tables that are required by the Billing Engine.
• Uploading of Legacy Data into CRM & Billing Tables of Destination Database.
• Unit Testing of Migrated Data through Billing Engine (ELP Soft) and preparing the exceptional list that has to be handled during migration.
• Preparation of Check List that includes relationship between different tables of CRM & Billing and preparation of data validation list which is incorporated before and after migration.
• Enhancement of SP’s and reviewing Team Members task periodically.
• Designing different structure for CCC Application.
• Data Migration for CCC.
• Implementation of SBM (Spot Billing machine) logics and integration with MBC module.
• Provide technical support to QA/QC Team.
• Tariff mapping in New Billing System.
• Preparation of Proto-types for the Development Team.
• Successfully Designed and developed Data Synchronization Tool between CRM and GIS.
• Maintenance and enhancement of SBM module.
• Writing SP’s trigger’s and queries.