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.)

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.

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