VIKASH KHANTWAL

• Having 13 Yrs. of IT Experience in OIC Integration (FBDI Import, FTP Adaptor, REST Adaptor,DBCS Adaptor, Oracle Cloud Adaptor,ESS Job Integration, SOAP), VBCS (Web Application), Oracle Fusion BI Publisher, , Integrated SOA gateway, Oracle Apps Technical (P2P, O2C), Oracle PL/SQL Developer, Forms and Reports Developer and Oracle Applications like XML publisher, Unix Shell scripting, OTBI, Informatica Tools, SQL Loader.
• Experience includes Development and Customization of Oracle Forms, Reports, XML publisher, Customized Interface (Inbound/Outbound). Involved in the continuous enhancements and fixing of production problems. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances. Developed PL/SQL triggers to update, insert on temporary table for back-up and history purpose. Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart. Created scripts to create new tables, views, queries for new enhancement in the application using TOAD. Created indexes on the tables for faster retrieval of the data to enhance database performance. Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Involved in data loading using PL/SQL and SQL
• Loader calling scripts to download and manipulate files. Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
• Plus. Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving the performing. Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching. Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Expertise in Oracle Reports 6i, SQL and PL/SQL database programming. Having good knowledge in Other Utilities TOAD, SQL LOADER, SQL
• UTL_FILE. Having good Knowledge in UTL file utility to perform the file operation (Read, Write) Operation on Flat file. A Committed team player with organizational and interpersonal skills.

• Windows 7/8, Windows XP/NT/03, Windows Server r16, Linux HP-UX Server, Oracle 9i, Oracle 10g, Oracle11g, Oracle Cloud/Fusion, FTBI, OIC, Oracle Apps Technical r12 (SCM), Oracle Forms 11g, Reports 10g, 11g, XML Publisher, BI publisher, OTBI Reports, SQL, PL/SQL, ORACLE FORMS & REPORTS, XML PUBLISHER, SQL
• Loader, Data Loader, TOAD, Developer 2000 (Forms10g and Reports 10g), Oracle Fusion/Cloud, SQL
• Plus, PL/SQL DEVELOPER, TOAD, PUTTY, WINSCP

• Capgemini India Private Limited, Senior Consultant, 03/17/23, Present, BLACK & VEATCH (EBS TO FUSION MIGRATION) PPM module, Develop & Migration Oracle Integration to call the FBDI import program and call procedure to migrate the data from EBS to DBCS then after load program add data in fusion module., OIC integration, VBCS, Oracle Fusion BI publisher.
• Capgemini India Private Limited, Senior Consultant, 08/15/23, Present, Oracle AMES Project (Novelis Account), Oracle EBS Application Developed and Custom Inbound/Outbound Interface with SOA gateway as Rest API with MuleSoft., Oracle Fusion BI publisher, Oracle Apps Technical SCM, Linux, Unix, Pl/Sql, Oracle Forms and Reports, Informatica.
• Tech Mahindra Pune Hinjewadi, Senior Software Engineer, 12/06/17, 02/26/23, Trace & Reconnect & Mpower, Oracle Forms Application Developing and Support., Oracle BI publisher, Oracle Apps Technical, Linux, Unix, Pl/Sql, SOX Audit, Oracle Forms and Reports, Informatica
• Bajaj Allianz Life Insurance Private Limited, IT-Programmer, 08/27/15, 12/04/17, Forms and Reports Generation of ULIP module in Insurance Domain, Oracle Forms, Reports, Toad, Sql loader, Oracle 11g, Oracle Forms, Reports, Toad, Sql loader, Oracle 11g
• Anchor Electrical Private Limited, Oracle Developer, 08/01/11, 08/22/15, Financial Report of (Account General), Oracle Forms, Reports, Toad, Sql loader, Oracle 11g, Oracle Forms, Reports, Toad, Sql loader, Oracle 11g

English, Hindi

• Lead the team in collecting requirements from the client, carry out technical analysis, and determine the man-hours necessary for the tasks. Hold daily stand-up meetings and collaborate with the client during project calls.
• Oracle Fusion BI publisher Report, OTBI and OIC Integration (FBDI Import, FTP Adaptor, REST API, ESS Job Integration)
• Oracle EBS Technical Works on Forms Customization, New Forms Creation, Purchase and Supplier Report on Oracle Reports and XML publisher.
• Designed Oracle forms and reports and work on Oracle Forms Upgrade Project 11g to 12c.
• Managing the Reports (Excel, Pdf) reports monthly weekly and event bases.
• Involved in performance tuning of PL/SQL and SQL codes.
• Personalized forms as per the requirement.
• Developed financial (GL BATCHES AP/AR) reports and customization in Oracle reports.

• Passport Number: Z3970573
• Father's Name: Mr. Kamlesh Khantwal
• Date of Birth: 04/05/85
• Gender: Male
• Marital Status: Single

• Certification of oracle GEN AI Certification 2024
• Certification in Oracle and Java.
• Attended Workshop on Cryptography Project on (VB.NET).
• Python Certification from Programmer AI
• SQL certifcation from Code boot.

• Good Hand experience in reconciliation to Reconnect Tools to reconcile the finance entry .
• Good experience on SOX auditing controls (16,21,53) and present the evidence proof in front of internal audit and External Audit quarterly , Half yearly and Yearly basis.