Core Business Applications Analyst

• Mar 2022 - Present

Oracle Apps Techno Funtional

• Dec 2019 - Mar 2022

Oracle Apps Consultant

• Apr 2017 - Dec 2019

- Used seeded API(s) to create & update SR(s) - Used seeded API(s) to create & update Task(s) - Setup new task templates for creating & updating the task during SR cycle - Called custom form through personalization on Standard SR form & e-Business Center form - Opened inventory item in inventory & its pricing in oracle pricing module - Developed new custom module (based on OAF) for all customers of free zone - Generated pdf reports through jsp pages in Customer First module - Existing report changes as per business requests & demands - MRF change request – code pack preparation & testing along with MD-50, MD-70 & TE-50 - Package changes to fix the issue as per business requests & demands - Developed Lease Agreement reports - Developed concurrent for lease creation & deletion in property management - Developed Java Concurrent program for lease amendment reports - Developed functionality in jsp pages to call java applet form - Added VAT functionality for Customers of Free zone - Assigned fiscal classification codes & Tax registration number for Customers - Added VAT functionality for suppliers - Assigned fiscal classification codes & Tax registration number for Suppliers - Added VAT functionality in PO Line level - Jsp page calling through oracle form personalization - Arabic templates development in BI publisher - Opened different EITs in oracle HRMS. - Apply user Hooks on Self Service EIT pages - Developed and send reports through XML bursting procedure - OA page personalization in oracle core HR - Enabled DFF in custom Lookups through application object libraries - Added custom form in menu through personalization - Created custom pages for contingent worker and upload data through standard contingent worker APIs in HRMS - Created concurrent reports to send & show the data of receipts in AR Show less

Oracle Apps/OAF Technical Consultant

• Apr 2014 - Apr 2017

- Developed jsp pages in iPerform (Oracle Performance Management) custom module using Oracle JDeveloper - Generated pdf reports through jsp pages in iPerform module - Design & developed custom workflow processes - Used AME to run the workflow custom process - Added returned for correction functionality in the existing workflow - Developed discoverer reports in iPerform - Developed custom APIs in iPerform - Developed concurrent program to send notifications on the change of appraisal manager - Developed encryption & decryption procedures for exchanging the data - Developed WEB ADI for enrollments of employees (through APIs) in OLM for training classes - Open & register different EITs in core HRMS - Integration of Kronos Time & Attendance system with Oracle Payroll to create the elements for over time allowance - Developed Concurrent programs to generate XML for Time & Attendance reports - Developed Item Loading custom form to upload inventory items in the standard application after approval - Upload contingent worker data in core HR through APIs - Developed reports in AP - Design & developed the custom OAF Forms & APIs for Compliance & Ethics department - Custom Notifications from one user to another through Oracle Work Flow Builder - Created Salary deduction Elements with the help of Payroll APIs in oracle payroll - Developed custom OAF form for Asset transfer one department to another - Created Salary refund Elements in oracle payroll Show less

Oracle EBS / OAF Technical Consultant

• Apr 2013 - May 2014

- Data uploading from custom application tables into the Oracle HRMS module through Oracle HRMS APIs - Developed different reports of P2P process - Developed different reports of O2C process - Personalized the standard PO screen according to functional requirements - Customization through OAF using Oracle J Developer - Designing & developing custom forms (Search, Create, Update pages) using OAF to meet the clients' requirements - Developed custom workflows for sending the notifications in workflow hierarchy - Developed custom reports on XML publisher - Made different Technical Document Review (TDR) for different OAF custom forms development Show less

Software Engineer

• Mar 2012 - Apr 2013

• ETL Developments in Knowledge Management (Part of Oracle BI): - Involved in understanding of business processes and coordinated with business analysts to get specific user requirements - Worked closely with data warehouse architect and business intelligence analyst in developing solutions - Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones within tight deadlines - Involved in performance tuning of the jobs - Tuned the database queries to improve the performance of the query and indexing strategies - Defined various facts and Dimensions in the data mart and reviewed source systems and also proposed data acquisition strategy - Designed and developed various Pl/SQL stored procedures to perform various calculations related to fact measures - Imported table/file definitions into the Data stage repository - Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed - Extracted data from different schemas into one - Used Data Stage maps to load data from Source to target - Wrote complex SQL queries using joins, sub queries and correlated sub queries - Extensively used Auto sys for automation of scheduling jobs on daily, bi-weekly, weekly monthly basis with proper dependencies - Involved in performance tuning and optimization of Data Stage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data - Studied the PL/SQL code developed to relate the source and target mappings - Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes - Extensively worked on Data Stage jobs for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance Show less

Software Engineer

• Aug 2010 - Feb 2012

• Individual Life Administration System (Customize ERP for Insurance) - Analyzed, developed and maintained Oracle Forms and Reports for further enhancement, Of system - Developed the pl/sql codes on the basis of the requests for the change - Developed Bar coded Letter Reports for TCS Bar coded system - Data Migration (from one schema to another schema) during products setup using PL / SQL Developer - Created standard and adhoc queries according to the user requirements - Designed and developed MTV bulk upload form (for accounts department) which uploads data from excel sheets and after further processing it hits in accounting module of the system - All debits and credits of group accounts are necessary to check on this forms before insertions in permanent tables - Developed the agency activation process in agency module which dynamically activates or deactivates the agents - Implemented all database triggers, packages, procedure in activation process - Developed PL/SQL procedures using dynamic SQL • Mail Input System - Modified, maintained and developed the pl/sql codes and forms to for Enhancements - Created pl/sql packages and procedures to implement business requirements - Gathered requirements through detailed discussions - Developed the new process (through pl/sql procedures and triggers) for assignment of task to the users in claims department - Created setup based forms for task assignments to the users - Created auto id process (which automatically opens task in others departments) in this system • Call Center System - Member of the team that setup the project standards for development - Developed the call centre system which fulfills the requirements for live calls of clients - Created Parameterized reports which calls from forms and shows the summary of call centre - Used sqlloader to load data from csv files into setup tables for call center system - Integrated these forms in other system Show less