SUMMARY

• More than 15 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Over 11 years of experience as a Technical Lead in designing and developing complex solutions for E - Business suite, Oracle Cloud ERP Financials and Oracle Cloud HCM clients.
• Extensive technical and functional knowledge on Oracle Fusion - Oracle Cloud ERP Financials.
• Extensive experience in OIC(Oracle Integration Cloud) in designing and developing end to end integrations between legacy applications and the Oracle Cloud ERP and HCM systems.
• Extensive experience in OCI(Oracle Cloud Infrastructure), spinning up and configuring DBCS(Database Cloud Service), JCS(Java Cloud Service), VMs(Virtual Machines) and OIC Instances and installing the OIC Agents on various servers.
• Strong Knowledge in designing, developing and publishing SOAP and REST Web Services.
• Extensively worked on implementing SSL Certificates, PGP encryptions, SSH Keys for end to end intransit and data at rest encryptions.
• Strong experience in developing custom applications using JCS (Java Cloud Service), JCS-SX (Java Cloud Service- SaaS Extension) and VBCS (Visual Builder Cloud Service) environments.
• Expertise with OracleADFBusiness Components, Web servicesADFfaces,ADFTask flows and Data Controls.
• Architected and developed many custom applications in JCS, JCS-SX and VBCS environments. Extensive experience in integrating various applications with Oracle Cloud using FBDI, ADF and HDL scripts.
• Key programming skills include Java, Python, J2EE, JSF, OracleADFFaces, HTML, XML, XSLT, JDBC, JSP, Java Script and EJB
• Extensive knowledge in Oracle ERP Cloud security. Implemented data security by creating multiple custom roles and applying function security and data privileges. Secured custom applications using JWT tokens and SSO (Single Sign On) features.
• Designed solutions to migrate complex customizations from R12 to Oracle Fusion Cloud using BI Publisher, JAVA Web Services and ESS (Enterprise Scheduler Services).
• Worked on multiple Oracle ERP full cycle implementations and complex upgrade projects.
• Have very good experience in end to end implementations of Oracle Cloud ERP, Oracle EBS 11i, R12 & R12.2.4.
• Extensive knowledge in Technical and Functional aspects of various Oracle Cloud ERP modules.
• Strong knowledge in JAVA, OAF, ADF, SOA, XML, XLST and XPath.
• Extensive experience in developing reports using BI(Business Intelligence) Publisher, FRS (Financial Reporting Studio) Reports and OTBI (Oracle Transactional Business Intelligence) reports
• Extensive knowledge in performance tuning SQL Queries and PL/SQL Programs.
• Strong debugging skills in complex programs and applications.
• Extensive experience with analysis, design, development, customizations, upgrade and implementation of Oracle E-Business suite.
• Extensive experience in GL, SLA, AP, CM and PO modules of Oracle 11i and Oracle 12.
• Strong Knowledge in Oracle FAH(Financial Accounting Hub)
• Strong Functional & Technical knowledge in Oracle Supply Chain modules like Oracle Purchasing (PO), Inventory (INV), BOM (Bill of Material), Order Management (OM)
• Detailed understanding of R12 Subledger Accounting, R12 Payables & Payments flows.
• Strong knowledge in Oracle EBS Tax(EB-Tax)
• Extensive experience in writing SQL Queries, PL/SQL Programs and integrating legacy applications using Inbound and Outbound interfaces.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Extensive experience in R12.2.2 & R12.2.4 EBR(Edition Based Redefinition) features, standards, upgrade procedure, as well as online patching.
• Executed software projects for Human Resources, Pharmaceutical, Manufacturing, IT, and Banking industry
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

ERP: Oracle Cloud ERP Financials(Versions Release 12 to Release 21), Oracle E-Business suite. Versions Release 11i, Release 12 and Release 12.2.4)

Development Tools: OIC(Oracle Integration Cloud),VBCS(Visual Builder Cloud Service),Oracle JDeveloper, Oracle BI Publisher, Weblogic Server, SQL Developer, SOAP UI, Postman REST Client, SVN, Reports 6i/10g, Forms 6i/10g, Discoverer 9i/10g, TOAD 7.x/8.x/9.x, SQL*Plus, Eclipse, JDeveloper File Zilla, Putty, Tectia SSH, SQL Loader, Kintana and PVCS

Functional Modules: General Ledger (GL), Financial Accounting Hub(FAH), Fixed Assets(FA),Subledger Accounting (SLA), Accounts Payables (AP), Order Management (OM), Purchasing (PO), Projects (PA), Oracle Inventory (INV), Oracle Process Manufacturing (OPM) and Oracle Contract Management (OCM).

RDBMS: Oracle 8.i/9i/10g/11g/12c/19c, Oracle EBR(Edition Based Redefinition)

Languages: JAVA, Python, SQL, PL/SQL, J2EE, UNIX, BPEL, C, XML, HTML, PHP, JavaScript, AJAX.

O/S: Windows7, Windows NT/2003 Server, Windows XP 2002, Windows Vista, UNIX

Processes: Agile Project Management(JIRA), IBM’s QMS (Quality Management System)

PROFESSIONAL EXPERIENCE

Enterprise Technical Manager

Confidential, Las Vegas NV

Responsibilities:

• As an Enterprise Technical Manager architected OCI(Oracle Cloud Infrastructure) to support various custom extensions to the Oracle ERP and HCM SaaS applications, integrations between the legacy and SaaS applications, Storage and SFTP Requirements.
• Created Oracle OIC, VBCS, JCS, DBCS, IDCS and Virtual Machine Instances. Implemented Load Balancers, SSL Security and PGP Encryption.
• Architected RAC DBCS Instances and Schemas to support OIC Integrations and enhanced logging and notification requirements for various Audit, Cyber Security and ITGC purposes.
• Designed and developed generic PL/SQL Packages, Shell Scripts and OIC Integrations to ensure standardization and optimize the integration development with reusable code.
• Extensively involved in Oracle ERP Cloud Purchasing, Accounts Payables, Fixed Assets and Project Accounting implementation projects and designed integrations between Oracle ERP and third party systems like Ariba and Clarity.
• Designed and developed reusable Outbound OIC Integrations to automate the file transfer to various vendors.
• Designed and developed data base schemas and tables to configure the OIC integrations, log integration runs, validate control totals and generate email notifications.
• Worked with Oracle A-Teams, Product Managers and Support Teams while building and configuring the OCI(Oracle Cloud Infrastructure).
• Trained the team on how to use the reusable PL/SQL utilities, Shell Scripts and generic OIC integrations while creating the integrations between the legacy and Oracle Cloud environments.
• Created generic PL/SQL packages using Java to archive, copy, move the files.

Senior Software Developer

Confidential, Las Vegas NV

Responsibilities:

• As a Development Team Lead architected multiple complex ADF applications in the JCS-SX environment. Conducted trainings and knowledge sharing sessions with the team members and explained the design architectures, coding standards and best practices.
• Designed a complex regulatory application to put invoices on hold for the vendors that are not complying with various gaming control boards, by defining complex rules to verify the Supplier Certificates, Supplier Classification Codes, Certificate Expiry Dates, Spend Limits etc.
• Written complex SQL analytical queries to identify the YTD Open Invoice Amount, YTD Payment amount for invoices that fall under a specific gaming control board.
• Extensively involved in Oracle ERP Cloud Fixed Assets and Projects implementation project and designed integrations between Oracle ERP and third party systems like Ariba and Clarity.
• Designed a custom scheduler application using Quartz libraries to schedule various custom jobs within the JCS-SX environment.
• Designed a complex application which involves running multiple HCM Extracts, BI Reports, parse the files and then transform using complex mapping rules and error handling logic and send it to Oracle Instantis by calling CRUD API and various Oracle cloud Web Services.
• Designed a complex XSL template to generate Bank Remittance file by applying complex grouping criteria. These groupings were not possible using the standard Oracle eText templates.
• Designed and developed an application to track and pay the winning gaming tickets that were sent via postal mail. The application is responsible to automatically create Suppliers, Supplier Addresses, Sites, Site Assignments, Invoices based on the ticket information entered on the custom application.
• Created BI Publisher report to download the Suppliers and Supplier Sites in the FBDI Format so that users can run the report modify multiple suppliers and upload the file to Oracle to speed up the mass vendor update process.
• CreatedMaster Details ADFpages in JCS-SX(Java Cloud Service - SaaS Extension), to enter gaming Ticket Details.
• Implemented Oracle Cloud Security by creating various custom roles and data security privileges to restrict access to the custom application to only authorized users.
• Created reusable ADF task flows to optimize and reduce the development effort for multiple custom application requirements.
• Addressed performance issues with BI(Business Intelligence) report by tuning the SQL Queries.

Senior Application Developer

Confidential, Tampa FL

Responsibilities:

• Designed solutions to migrate complex outbounds and customizations from R12 to Oracle ERP Cloud applications using BI Publisher, Web Services and ESS (Enterprise Scheduler Services).
• Designed custom Web Services to load Journal Entries from legacy applications into Oracle Cloud ERP Finance applications.
• CreatedADFpages in JCS-SX(Java Cloud Service - SaaS Extension), to book Accrual Journals, with Master Detail Tables, Master table Detail Form and Tree Tables.
• Created complex ADF task flows to optimize and reduce the development effort for multiple custom application requirements.
• Created many JAVA Packages to implement complex ADF Models.
• Created ADF Error handling frameworks to enhance end user experience by providing detailed user-friendly error messages.
• Provided solutions to retrofit hundreds of R12.1.3 customizations for Oracle ERP upgrade project, to be compatible with online patching.
• Provided training to the team members on Oracle 11g EBR (Edition Based Redefinition) features, Editioning Views and established standards to prevent migration of customizations that are incompatible with online patching.
• Responsible for leading a development team in delivering solutions to our customer in the Procure to Pay division.
• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Key projects handled so far include ADF Custom Application Development, 11i Production Support and Release 12 Implementation/upgrade.
• Developed custom ADF Application for the client to track and manage all the Oracle E-Business Suite customizations
• Trained end users for R12 Payments and R12 Payables Modules Functionality. Developed XML Templates for Payments files.
• Customized the functionality of R12 Payments Module to meet the client’s payment requirements.
• Extensively worked on performance tuning of SQL Queries to improve the performance of the daily and monthly jobs.
• Developed several outbound programs in General Ledger to transfer the P2P Journal Entries to the various Legacy systems
• Developed complex Funding programs to automate the transfer of funds from a single Legal Vehicle to different branches.
• Developed critical VPD solutions to segregate and secure the data when some of Business Units were sold off.
• Developed many Discoverer Reports in AP & GL Modules which will help users to monitor the performance of Procure to Pay process.
• Development of UNIX Shell Scripts. Developed Inbound and Outbound Interfaces like GL Interface and Supplier Master Interface.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Worked on Oracle Fusion Applications POC development to evaluate the best approach to retrofit all the complex custom processes to Oracle Fusion Applications.

Environment: Oracle Applications Release12.0 and 12.1.3,10g database, Reports 6i/10g, SQL Developer, PL/SQL, Toad 8.x/9.x, Putty, Discoverer 10g, UNIX

Senior Application Developer

Confidential

Responsibilities:

• Utilize in-depth knowledge of functional and Technical experience in Oracle ERP in conjunction with industry and business skills to deliver solutions to customer.
• Developed various JAVA Concurrent programs for custom business requirements.
• Developed ADF and OAF applications for custom business requirements. Created custom ADF page to define mapping which acts as a single mapping source for various integrations.
• Responsible to design standards, best practices and solutions to upgrade from R12 to R12.1.3
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Extensively worked on performance tuning of SQL Queries to improve the performance of the daily and monthly jobs.
• Developed several outbound programs in General Ledger to transfer the P2P Journal Entries to the various Legacy systems
• Developed complex Funding programs to automate the transfer of funds from a single Legal Vehicle to different branches.
• Fixed performance issues with the VAT Register jobs for Great Britain.
• Fixed Performance issues with the Data Base triggers and improved the performance of the Journal Import program for US.
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Environment: Oracle Applications 11.5.10/12.0 , 10g database, Reports 6i/10g, PL/SQL, Toad 8.x/9.x, Putty, Discoverer 10g, UNIX