SUMMARY

• Over 12 years of experience in IT Professional in Oracle EBS R12 Technical experience in design, development and customization of RICEWF and Java components using SQL, PL/SQL, OAF, ADF, BI Publisher reports, Oracle Workflow, UNIX Shell Scripting, Integrated SOA - Gateway, SQL*Loader, Spring Boot, AWS Cloud, etc. Tools experience includes TOAD, Oracle JDeveloper (10g, 11g and 12c), SQL Developer, Putty, Win SCP and Eclipse.
• Strong experience in building OA Framework pages (using Jdeveloper 10g, for EBS R12.1.x, R12.2.x), to address various requirements of Oracle Procure to Pay (like Supplier Management, Invoice management, etc.) using MVC, BI Publisher Integration, Advance Tables, Search/Create Pages, Master-Detailed Advanced Tables, Parent Child relationships, Enumerators, Partial Page Rendering, Add/Delete rows, File Uploads, Processing Page (hour-glass), Record Coloring, Procedure calls, Switcher, Conditional rendering of fields, Dynamic enabling/disabling of Checkboxes, SPEL/OADataBoundValueViewObject, etc.
• Strong experience in building ADF pages (using Jdeveloper 11g and 12C), implementing MVC Layers, ADF Faces, Data Controls, BindingContext, Table-in-Table layouts, View Links, Trees, TreeModels, Interactive Action/Selection Listeners, Report/File downloads (using fileDownloadActionListener, VO writeXML, Glasspanes), StyleClass, Method/Invoke Actions, Page/PhaseListeners, EBS Integration (embedded/standalone), Weblogic/Glassfish deployments. Special mention for implementing the EBS-SDK Session Management/Sharing critical for deploying ADF pages in on-prem EBS applications (using fndext.jar)
• Strong experience in Java, Microservices architecture, building Spring Boot Applications/Webservices (GET/POST RESTful services) using Spring Annotations, Autowiring, Object(JSON)/XML Mappers, Prepared/Statements, Add/ExecuteBatches, CallableStatements, ResultSets, ArrayLists, Input/OutputStreams, HSSFWorkbook, RTF/FOProcessor, ValidatorFactory, GZIPInput/OutputStream (compression), Http/ServletRequest, FilterChain, IOUtils, HashMap, Threads, Log4j2, Tomcat, RestTemplates, ResponseEntities, HikariCP, Hibernate, Direct connects, Junit, Mockito, Power-mockito, Maven, GitHub, etc.
• Strong Experience in AWS Cloud infrastructure, Integration with AWS S3 bucket repositories, AWS Batches, Athena, IAM, Step Functions, Secret Managers, EC2 instances, ECS Clusters, Cloudwatch, Cloudformation/templates, Simple Email Service, Simple Queue Service, AWS RDS (Oracle, Postgres, MySQL), DynamoDB. Extensively used AWS-SDKs like Amazon Athena Client Builder, Start/GetQueryExecutionResult, GetQueryResultsRequest, Amazon SQS Client Builder, ReceiveMessageResult, Send Message Request, delete Message, AmazonS3 Client Builder, uploadMultiPartFileToS3, AccessControlList, PutObjectRequest, ListObjectsV2Result/Request, S3ObjectSummary, S3Object Input Stream, AWS Secrets Manager Client Builder, Amazon Simple Email Service Client Builder, SendRawEmailResult, AmazonDynamoDBClientBuilder, ScanSpec, QuerySpec, ItemCollection, putItem, etc.
• Strong in Oracle 11g/12c SQL and PL/SQL Tuning using Exadata DB storage level Smart scans, Partitions, Partition pruning, Indexing (Unique/Nonunique), Full/Index/Parallel Hints, Execute Immediate, RAISE/Exceptions, PRAGMA Routines (Autonomous/Exception), Parallelism, Serial Direct reads, FTS vs Index performance comparisons, Collection Objects (Bulk, For-All, Save Exceptions, etc.), Table/Record Types, Cost Based Optimizer, Explain Plans, etc.
• Strong experience in development of Oracle EBS P2P and O2C Interfaces and Conversions (using SQL Loaders, Standard Interface tables, Standard Imports, UTL FILE, UTL HTTP, DB LOBs, DBMS JSON/XML DOM Parsers, DB Wallets, Payload/Files generation/placing, etc.)
• Strong in Oracle R12.2 EBS critical features like Online Patching, Multi Org Access Control, Security Profiles, Editioning, Policy Contexts, Custom objects deployment (XDF, AD ZD, etc.).
• Strong Experience in business flows of Oracle Procure to Pay modules including PO, INV, AP, IBY, HRMS, SLA and GL.
• Trained in SOA Suite 12c Cloud Service (separately experienced in Oracle Jdeveloper 12c Suite and Weblogic 12c through extensive ADF pages build/deployment): Oracle SOA Suite 12c Quickstart Download/Installation, Integrated/Standalone Weblogic Server 12c (Managed Servers, Controls, Data Sources, Deployments, etc), Fusion Middleware Control 12C, Enterprise Manager, Oracle SOA Suite Cloud Service Console (PaaS), SOA Composite Application creation (using Template), BPEL Processes, WSDL Files, XML Transformation files, XSDs, DB Adapters, OSC Adapters (Integration with Oracle Sales Cloud), BPEL Process components like variables, Partner Links, Variable Assignments (using Assign Editor), XSLT transformation (using Custom Activity Templates), Deployment using SAR files into Integrated Weblogic Server, and Testing using Fusion Middleware Control console, and knowledge in Oracle SOA Cloud Service deployment.
• Trained in Oracle Cloud Infrastructure (OCI/IaaS - very similar to AWS IaaS where having vast experience in implementation/development): Regions, Availability Domains, Fault Domains, High Availability Designs, Tenants, Compartments, Bare Metal, VMs, Containers (Registry/Dockers/Kubernetes), Functions, Vertical/Horizontal Scaling, Autoscaling, File/Object/Archive/Block storage, VCNs, Internet/NAT/Service Gateways, Load Balancers, IAM (Users/Groups/Policies), RAC/Exadata/Autonomous Databases (Oracle).
• Project experiences include multiple full life cycle Implementations and Upgrades.
• Used RTF, PDF and Microsoft excel templates for BI Publisher reports and bursting to meet various report design requirements. Used OA MEDIA to print Company logos is BI Publisher reports.
• Experience in designing and developing Web-Services using Oracle Integrated SOA-Gateway (ISG). Implemented these Web-Services for External Applications by exposing through ISG layers. Also, created PL/SQL packages to call External Web-Services exposed to Oracle R12 using DB Wallets, UTL HTTP, and DBMS LOB (for Payloads).
• Experience in Supplier, Supplier Site, Supplier Contact and Employee Conversions to migrate legacy Supplier data to Oracle R12 EBS system
• Experienced in writing AIM documents including MD050, MD070, CV040, CV060, TE020 and BR100.
• Experienced in implementing ProActive Analyzers for Business users.
• Experience includes working with migration/version control tools like Clearcase, PVCS and Kintana.
• Experienced in participating in multiple CRP(s), SIT, UAT and Go-live phases of the projects. Provided support during and post Go-Live activities.
• Directly supported Business Users, assisting them in using the various Solutions developed and released in UAT/Production instance
• Highly efficient in working closely with Oracle support to resolve seeded application issues by creating and monitoring Oracle Service Requests (SR).
• Very strong in tuning code for improved code performance. Highly efficient in debugging code in very short turn over time.
• Experienced in Onshore-Offshore model Implementation and proven excellence in leadership skills.

TECHNICAL SKILLS

Primary Skills: Oracle EBS Technical Development (RICEW Components), Interface (Inbound and Outbound), Conversions, ADF, OAF, EBS-SDK (Session Management), Weblogic Server, Glassfish, BI Publisher, Workflow builder, Spring Boot Applications, Spring Webservices, AWS Infrastructure, AWS-SDKs, Java Applications.

Packages (Incl ver): Oracle EBS 12.2.6, 12.2.5, 12.2.4, 12.2.2, 12.1.1, 12.0

Modules: Purchasing (PO), Account Payables (AP), Payments (IBY), Inventory (INV), Sub-Ledger Accounting (SLA), General Ledger (GL), Order Management (OM), Release Management (RLM), Account Receivables (AR), HRMS (HR) and Absence Management Modules

Operating Systems: Win 10, Win 8, Win 7, UNIX

Languages: Oracle SQL, PL/SQL, Java, UNIX Shell Scripting

Development Tools: Toad, SQL * Plus, SQL Developer, JDeveloper, BI Publisher, Putty, Win-SCP, Eclipse

Database: Oracle 11g, 10g, 12c.

Version Tools: PVCS, Kintana, Clearcase, Perforce, GitHub

Documentation: MD050, MD070, CV040, CV060, TE020, BR100

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Senior Oracle EBS Technical Consultant

Responsibilities:

• As a Senior Oracle EBS Technical Consultant, contributed in design and development of AP/IBY/SLA/GL/PO Interfaces and Conversions in R12.2.6 (using SQL, PL/SQL, SQL Loaders, Standard Interface tables, Standard Imports, UTL FILE, UTL HTTP, DB LOBs, DBMS JSON/XML DOM Parsers, DB Wallets, Payload/Files generation/placing, etc.), and also front end configurations like Concurrent program, Request Sets, Profiles, Lookups, Forms Personalization, XML Publisher and Workflows.
• Contributed in SQL and PL/SQL Tuning using Exadata DB storage level Smart scans, Partitions, Partition pruning, Indexing (Unique/Nonunique), Full/Index/Parallel Hints, Execute Immediate, RAISE/Exceptions, PRAGMA Routines (Autonomous/Exception), Parallelism, Serial Direct reads, FTS vs Index performance comparisons, Collection Objects (Bulk, For-All, Save Exceptions, etc.), Table/Record Types, Cost Based Optimizer, Explain Plans, etc.
• Built OA Framework pages (using Jdeveloper 10g, for EBS R12.1.x, R12.2.x), to address various requirements of Oracle Procure to Pay (like Supplier Management, Invoice management, etc.) using MVC, BI Publisher Integration, Advance Tables, Search/Create Pages, Master-Detailed Advanced Tables, Parent Child relationships, Enumerators, Partial Page Rendering, Add/Delete rows, File Uploads, Processing Page (hour-glass), Record Coloring, Procedure calls, Switcher, Conditional rendering of fields, Dynamic enabling/disabling of Checkboxes, SPEL/OADataBoundValueViewObject, etc.
• Built ADF pages (using Jdeveloper 11g and 12C), implementing MVC Layers, ADF Faces, Data Controls, BindingContext, Table-in-Table layouts, View Links, Trees, TreeModels, Interactive Action/Selection Listeners, Report/File downloads (using fileDownloadActionListener, VO writeXML, Glasspanes), StyleClass, Method/Invoke Actions, Page/PhaseListeners, EBS Integration (embedded/standalone), Weblogic/Glassfish deployments. Special mention for implementing the EBS-SDK Session Management/Sharing critical for deploying ADF pages in on-prem EBS applications (using fndext.jar)
• Built Microservices and Spring Boot Applications/Webservices (GET/POST RESTful services) using Spring Annotations, Autowiring, Object(JSON)/XML Mappers, Prepared/Statements, Add/ExecuteBatches, CallableStatements, ResultSets, ArrayLists, Input/OutputStreams, HSSFWorkbook, RTF/FOProcessor, ValidatorFactory, GZIPInput/OutputStream (compression), Http/ServletRequest, FilterChain, IOUtils, HashMap, Threads, Log4j2, Tomcat, RestTemplates, ResponseEntities, HikariCP, Hibernate, Direct connects, Junit, Mockito, Power-mockito, Maven, GitHub, etc.
• Implemented AWS Cloud infrastructure, Integration with AWS S3 bucket repositories, AWS Batches, Athena, IAM, Step Functions, Secret Managers, EC2 instances, ECS Clusters, Cloudwatch, Cloudformation/templates, Simple Email Service, Simple Queue Service, AWS RDS (Oracle, Postgres, MySQL), and Dynamo DB. Extensively used AWS-SDKs like Amazon Athena Client Builder, Start/GetQuery Execution Result, GetQueryResultsRequest, Amazon SQS Client Builder, Receive Message Result, Send Message Request, delete Message, AmazonS3 Client Builder, upload MultiPartFileToS3, AccessControlList, PutObjectRequest, ListObjectsV2Result/Request, S3Object Summary, S3Object Input Stream, AWS Secrets Manager Client Builder, Amazon Simple Email Service Client Builder, Send Raw Email Result, Amazon DynamoDB Client Builder, ScanSpec, QuerySpec, ItemCollection, putItem, etc.

Confidential, Columbus, IN

Senior Oracle EBS Technical Consultant

Responsibilities:

• As a Senior Oracle EBS Technical Consultant, contributed in design and development of Interfaces, Conversions, OAF pages, Web-services and Reports for Oracle R12.
• Developed multiple OA Framework pages to address requirements of Cross Dock Management (WMS), Change Order Management (OM), dynamically rendered Search/Edit Pages for Staging table corrections, and Exception Handling Page (RLM)
• Implemented various OAF functionalities including Search/Create Pages, Master-Detailed Advanced Tables, Parent Child relationships, Partial Page Rendering, Add/Delete rows, File Uploads, Processing Page (hour-glass), Record Coloring, Procedure calls, Switcher, Conditional rendering of fields, Dynamic enabling/disabling of Checkboxes, Extracts/Reports (configured with BI Publisher), etc.
• Specific OA Framework related experiences include automatic checking of child nodes in Advanced Tables based on checking of parent nodes checkboxes, creation of new VO objects dynamically (using createViewObject” method), adding new VO rows (using “createRow” method), enabling/disabling checkboxes/fields in OAF pages (using SPEL/”OADataBoundValueViewObject”)
• Led OA Framework-PL/SQL integration processes for Cross Dock Management and Change Order Management Solutions, by creating road maps for development, explaining duties to team, coordinating onsite-offshore calls and Unit testing the final solution.
• Designed and developed Web-Service subscriptions (APIs) using Oracle Integrated SOA-Gateway (ISG). Implemented these Web-Services for External Applications by exposing through ISG. Also, created PL/SQL packages to call External Web-Services exposed to Oracle R12.
• Integrated OAF with BI Publisher using XDO TemplateHelper Utility to seamlessly download Search results in form of a BI Publisher Report. Used Microsoft Excel Templates as report layout.
• Used CAVAJ to decompile seeded Class files to read and analyze existing OAF controller Java codes
• Monitored adcgnjar Utility and OACore bounces to implement OAF pages in Oracle Applications.
• Implemented Oracle ProActive Analyzers for Business Users. The total list of Analyzers included 50+ seeded Analyzer programs.
• Implemented custom solution to send E-mails to Users by assigning Business Events to the ProActive Analyzer concurrent programs. Internally, the Business Events were assigned subscriptions to send E-mails using server MAILX utility.
• Developed Inbound Interfaces from External systems via Middleware, which used ODI to load the inbound data into Oracle system.
• As part of Cross Dock Management Solution, actively worked on LPN creation logic (using “wms container pub” APIs), Material Receipts/Transfers of Inbound Shipments (using “mtl material transactions”), and Pick release process for Internal Sales Orders (using “wsh picking batches pub” APIs).
• Worked on Multiple Organization Access Control (MOAC), MO Global Security profiles, and handling that in custom codes using MO Global Set Policy Context feature of Oracle R12 (MO GLOBAL.SET POLICY CONTEXT)
• Worked on “AD ZD TABLE” APIs to create/update Custom Edition Views. For revising existing columns, worked on creating new #columns and re-running “AD ZD TABLE” API
• Experienced in Implementing User Defined Attributes (UDA) for Order Management (Order Headers and Lines).
• Implemented Pre Attribute Change and Post Attribute Change Business Events for Order Header and Order Line UDAs.
• Directly supported Business Users in Warehouse Plants, assisting them in using the various Solutions (Cross Dock Management, Change Order Management, etc.) developed and released in UAT/Production instance.
• Coordinated with onshore/offshore team during design, development and support phase of the project.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR’s) on seeded performance Issues
• Identified areas of Improvements and changes wherever applicable to custom codes and development standards, in-order to mitigate gaps and thereby improving overall quality of deliverables.

Environment: Oracle Applications R12.2.4, R12.2.5 - Order Management (OM), Release Management (RLM), Receivables (AR), Oracle Application Framework (OAF), BI Publisher Reports, Oracle Integrated SOA-Gateway, Oracle 11g/10g, SQL, PL/SQL, ProActive Analyzers, SQL*Loader, UNIX Shell Scripting, Java.

Confidential, Dallas, TX

Senior Oracle EBS Technical Consultant

Responsibilities:

• As a Senior Oracle EBS Technical Consultant, contributed in design and development of the Implementation of Oracle R12 Purchasing, Inventory and Supplier Conversions from end to end.
• Participated and actively led in thorough and requirement gathering sessions and detailed business mapping workshops running over multiple months in initial phase of the project.
• Designed and developed multiple Interfaces to and from third party systems (e.g. Warehouse management systems, Demand Planning systems, etc.) by integrating with following Oracle modules: Inventory (INV), Purchasing (PO) and Pricing (QP).
• Developed multiple OAF pages to address specific requirements including Advanced Tables, Table-in-tables, Parent Child relationships, Search, Partial Page Rendering, and File Uploads.
• Integrated OAF with BI Publisher using XDO TemplateHelper Utility to seamlessly download Search results in form of a BI Publisher Report. Used Microsoft Excel Templates as report layout.
• Worked on extension of seeded OAF pages in HRMS module by implementing new logic in Controllers
• Used CAVAJ to decompile seeded Class files to read and analyze existing OAF controller Java codes
• Monitored OC4J and Apache server bounces after incremental changes in OAF pages
• Developed various Inbound Interfaces to include Item Master, Material Transactions, Purchase Orders, Requisitions and PO Receipts.
• Developed various Outbound Interfaces to include Item Master, Purchase Orders and Price List.
• Designed and developed Supplier, Supplier Site and Supplier Contact Conversions to migrate legacy Supplier data to Oracle R12 EBS system.
• Worked extensively in Interface tables and Import programs (e.g. Import standard PO, PO Req Import, Receiving Transaction Processor, etc.) to meet the requirements of Inbound interfaces.
• Worked in Payables Interface tables and Supplier Open Interface Import programs to meet the Conversion requirements of Supplier records from legacy to Oracle.
• Worked on standard HR APIs to meet Conversion requirement of HR data from legacy system to Oracle.
• Involved in development of multiple complex reports using BI Publisher tools
• Involved in developing PL/SQL stored procedures to meet the Interface and Conversion requirements.
• Experienced in EDI mapping for PO Outbound Interface to EDI 850 and EDI 860 standard formats.
• Configured Data upload tools (More4apps) to seamlessly upload data into Oracle application.
• Wrote AIM documents including MD050, MD070, CV040, CV060, TE020 and BR100.
• Coordinated with onshore/offshore team during design, development and support phase of the project.
• Involved in fixing code issues raised during SIT (System Integration Testing) and UAT (User Acceptance Testing) and worked with oracle support team through Service Requests (SR’s) on seeded performance Issues
• Identified areas of Improvements and changes wherever applicable to custom codes and development standards, in-order to mitigate gaps and thereby improving overall quality of deliverables.
• Actively Involved in Pre and Post go-live activities, including deployment.

Environment: Oracle Applications R12.2.2 - Purchasing (PO), Inventory (INV), Payables (AP), Sub-Ledger Accounting (SLA), General Ledger (GL), Oracle Application Framework (OAF), BI Publisher Reports, Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting, More4apps, EID, UTL FILE package, Java

Confidential, Erie, PA

Lead Oracle EBS Technical Consultant

Responsibilities:

• Worked as a Lead for Oracle 11i to R12.2.2 upgrade for various Oracle modules including Purchasing (PO), Payables (AP), Sub-Ledger Accounting (SLA), General Ledger (GL) and Receivables (AR).
• Involved in analysis of the Oracle 11i custom Code remediation suggestions generated by Panaya tool on upgraded Oracle R12 system.
• Involved in creating Project tracker to track and monitor the Oracle 11i custom code changes compatible with Oracle R12 standards.
• Redesigned and modified Oracle 11i custom codes and tested for Oracle R12 compatibility for various new Oracle features including XLA tables in Sub-Ledger Accounting, HZ tables in TCA architecture, IBY tables in Payments, ZX tables in Oracle Tax and XLE tables in Oracle Finance Architecture (Legal Entities).
• Worked on configuration and implementation of Multiple Organization Access Control (MOAC) by introducing MO Global Security profiles and handling that in custom codes using MO Global Set Policy Context feature of Oracle R12 (MO GLOBAL.SET POLICY CONTEXT).
• Actively implemented Oracle provided Edition views (e.g. PO HEADERS ALL#) to replace ALL tables to meet Oracle R12.2.2 standards of online patching.
• Worked on “AD ZD TABLE” APIs to create/update Custom Edition Views. For revising existing columns, worked on creating new #columns and re-running “AD ZD TABLE” API.
• Worked on XDFGEN.pl, AD ZD finalize, cutover and cleanup. Clear with concepts of Run and Patch Edition.
• Involved in customization of Oracle workflows wherever a change in Oracle 11i codes is necessary to meet Oracle R12 standards.
• Worked on fixing multiple Performance issues due to existing Oracle 11i codes by introducing new Indexes and modifying PL/SQL join conditions.
• Involved in end-to-end Code reviews by coordinating with development team and resolving defects and performance issues.
• Coordinated with onshore/offshore team for open clarifications/issues raised by development team and resolving them in short turnaround time to close gaps.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.
• Actively resolved post Go-live code bugs and performance issues and also led development team through the resolution process.

Environment: Oracle Applications R12.2.2 - Purchasing (PO), Payables (AP), Sub-Ledger Accounting (SLA), General Ledger (GL), Receivables (AR), Oracle Application Framework (OAF), BI Publisher Reports, Oracle Workflows, Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting, Online Patching, Java

Confidential

Senior Oracle EBS Technical Developer

Responsibilities:

• Worked as a Senior Oracle EBS Technical Developer for R12.0 Implementation project of Oracle Projects Accounting (PA), Project Contracts (OKE) and HRMS (HR).
• Designed and developed multiple Interfaces, Conversions, OAF custom webpages, BI Publisher Reports, UNIX Shell Scripts, SQL*Loaders, Workflows.
• Implemented various OAF functionalities including Advance Tables for search, Table Parent Child relationships, Page Partial Renderings, File Attachments, File Uploads, Record Coloring and Page Partial Rendering.
• Integrated OAF with BI Publisher reports, enabling download of search results from Advanced Tables by implementing XDO Utilities.
• Extensively created multiple Stored Procedures using PL/SQL to meet the Interface and Conversion requirements.
• Implementing Bursting Control files in BI Publisher reports to meet various emailing and distribution requirements.
• Worked on Oracle standard workflows (PO Approval) and customize it to meet specific requirements of Approval channelizing based on Approval amounts.
• Implemented Decryption utilities in UNIX shell scripts to decrypt the secured legacy HR data during HR conversion to Oracle.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.
• Actively resolved post Go-live code bugs and performance issues.

Environment: Oracle Applications R12.0 - Projects (PA), Project Contracts (OKE), HRMS (HR), Oracle Application Framework (OAF), BI Publisher Reports, BI Publisher Bursting, Oracle Workflows, Oracle 11g, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripting, Java

Confidential

Oracle EBS Developer - OAF

Responsibilities:

• Extensively developed multiple Oracle Application Framework (OAF) pages from scratch for Product Information Management (PIM) Module.
• Worked on extension of seeded OAF pages in PIM module by implementing new logic in Controllers.
• Implemented H-Grid Tree, View Links, Partial Page Renderings, Parent Child relationships, conditional rendering of fields, dynamic enabling/disabling of Checkboxes, etc.
• Developed specific requirement of automatic checking of child nodes in H-Grid tree, based on checking of parent nodes checkboxes, creation of new VO objects dynamically (using createViewObject” method), adding new VO rows (using “createRow” method), enabling/disabling checkboxes/fields in OAF pages (using SPEL/”OADataBoundValueViewObject”).
• Created new VO objects in Controller and attached to seeded LOV fields of PIM pages.
• Used CAVAJ to decompile seeded Class files to read and analyze existing OAF controller codes.
• Extensively used XML TemplateHelper utility to import customer and extended OAF pages in Oracle applications.
• Monitored OC4J and Apache server bounces after incremental changes in OAF pages.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.
• Actively resolved post Go-live code bugs and performance issues.

Environment: Oracle Applications R12.0 - Product Information Management (PIM), Oracle Application Framework (OAF), Oracle 11g, SQL, PL/SQL, Java

Confidential

Oracle EBS Developer - OAF

Responsibilities:

• Worked as an Oracle EBS Technical Developer for R12.0 Implementation project of Oracle HRMS (HR), Oracle Time and Labor (OTL) and Absence Management.
• Designed and developed multiple Interfaces, Conversions, OAF custom webpages, BI Publisher Reports, UNIX Shell Scripts, SQL*Loaders, UTL FILE and Fast Formula.
• Extensively created multiple Stored Procedures using PL/SQL to meet the Interface and Conversion requirements.
• Implementing Bursting Control files in BI Publisher reports to meet various emailing and distribution requirements
• Worked on extension of seeded OAF pages in HRMS module by implementing new logic in Controllers
• Used CAVAJ to decompile seeded Class files to read and analyze existing OAF controller codes
• Used SQL*Loader and Control Files to meet Conversion requirement of HR data from Legacy system to Oracle.
• Wrote and customized multiple Fast Formula to calculate Employee Absence Balance for various Accrual Plans.
• Involved in System Integration Testing (SIT), User Acceptance Testing (UAT) and Go-live phase of the project.
• Actively resolved post Go-live code bugs and performance issues.

Environment: Oracle Applications R12.0 - HRMS (HR), Oracle Time and Labor (OTL), Absence Management, BI Publisher Reports, Bursting Control File, Oracle Application Framework (OAF), Oracle 11g, SQL, PL/SQL, Java