Surendra Kotloni

Oracle EBS OAF/ADF Developer

acv25l@r.postjobfree.com

Mobile: 832-***-****

Experience Summary

Having 9+ years of experience in Fusion Applications, Oracle Applications 11i/R12 including Designing, Developing, Customizing, Testing and Implementation of Oracle SCM, Finance and Project Accounting Modules.

Strong development skills with Oracle SQL,PLSQL,UNIX Programming, Oracle Reports, Oracle Forms, Oracle Application Framework(OAF), Application Development Framework(ADF), Oracle Web ADI, BI Publisher(XML Publisher), Java, J2EE, JSF and Oracle workflow.

Extensive experience in working with Fusion Applications, Oracle Applications 11i/R12 Finance modules such as Oracle Payables (AP), oracle Receivables(AR), General Ledger(GL), Fixed Assets (FA), Cash Management (CM), E-Business Tax (EBTax), Sub ledger Accounting(SLA), Trading Community Architecture (TCA) and working experience in SCM modules such as Purchasing (PO), Order Management (OM), Inventory (INV),Project Accounting (PA), iProcurement, iSupplier and iReceivables.

Contributed for various types of oracle Apps projects (Implementations, Support/Maintenance and Upgrade).

Expertise in Procure to Pay (P2P) and Order to Cash (O2C) flows.

Expertise in developing RICEF components (Reports, Interfaces, API’s, Conversions & Extensions, OAF) in Oracle Applications E-Business suite 11i and R12.

Profound Experience in development of Application Object Library (AOL) like registration of Concurrent Programs and Reports, defining Profile values, Value Sets and Descriptive Flex Fields (DFF).

Proficient in using SQL*Loader, PL/SQL and APIs for data Conversions and Validations worked on Stored Procedures, Functions, Packages, Database Triggers.

Expertise in the Customization, Extensions and Personalization of OAF Components.

Good work experience on Application Development Framework (ADF) including ADF Faces / ADF UI, ADF Business Components (ADF BC4J / ADF BC), ADF Security and ADF Task Flows.

Worked on the Implementation of Fusion Applications Project.

Good Experience in creating, maintaining and managing SR’s with Oracle Support via Metalink.

Experience in Performance Tuning (OAF, SQL and PL/SQL) using Bulk Collect/Bind, Apply Index and Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF.

Proven ability to deliver the task on time with excellent quality and customer satisfaction.

A good team player and leadership skills, capable of quickly adapting to new challenges and environments. Ability to work independently and lead teams.

Insightful experience in all phases of the system development /implementation life cycle (SDLC).

Good working knowledge of all the stages of Applications Implementation Methodology (AIM), Agile Methodology and Oracle Unified Method (OUM).

Having Fair knowledge on Oracle Fusion Application Cloud Products (SaaS, PaaS and IaaS).

Exposure on Oracle Service Oriented Architecture (Oracle SOA), ODI, OBIEE, Oracle Application Express (APEX) and Informatica.

Educational Qualifications

Bachelor of Technology in Electrical Engineering from National Institute of Technology (NIT), Durgapur, West Bengal, India.

Technical Skills

ERP : Fusion Applications, Oracle Applications 11i, R12

Databases : Oracle 9i/10g/11g

Operating Systems : UNIX, Linux, Windows NT/ XP, 2003, 2007,2008

Languages : Oracle SQL, PL/SQL, Core Java, J2EE, JSF, UNIX shell scripting

Oracle Tools : Oracle D2K Reports 10g, BI Publisher / XML Publisher, SQL*Plus, Jdeveloper 9i/10g/11g

Other Tools : SQL*Loader, TOAD, WinSCP, Putty, HP PPM, Clear Quest, Harvest,

CVS, Subversion (SVN), HP Quality Center, FTP, SFTP and Filezilla.

Middleware : Oracle SOA, Oracle ADF 11g, ODI and OBIEE

Project Experience

Client: Michelin (Greenville, SC) (Jan 2016 - till date)

Role: Senior Oracle Apps Technical OAF Consultant

Environment: Oracle Applications R12 (12.1.3)

Michelin is a tire manufacturer Company. It is one of the three largest tire manufacturers in the world.

Responsibilities:

Developed new OAF Page in iProcurement to import BPA Item catalog images.

Worked on OAF VO Extensions and CO Extensions on multiple pages in iProcurement and iSupplier modules.

OAF Personalization done for numerous pages in iProcurement, iSupplier, iReceivables and Oracle Login Page.

Developed custom Interface to Import the Ghost Card / Credit Card Transactions into Payables using Payables Open Interface Import.

Customized the seeded API PO_CUSTOM_PRICE_PUB. GET_CUSTOM_PO_PRICE hook to maintain the unit price entered by users for Requisitions against the BPA.

Developed scripts to synchronize the data between Purchasing and iProcurement.

Modified PO Create Workflow for iProcurement requirements.

Additionally performed AOL/Sysadmin activities to create new Responsibilities, Menus and attach read only OAF pages.

Preparing technical document and installation documents for developed components delivered through Agile Methodology.

Good Exposure on Oracle Approvals Management (AME).

Interact, analyze and understand the requirements thoroughly with the Business Analyst. Always ensured high quality in the deliverables.

Performed Patch impact analysis for Oracle SR patches.

Client: Avaya (Coppell, TX) (Nov 2015 – Jan 2016)

Role: Senior Oracle Developer

Environment: Oracle Database 11g

Avaya Inc. is an American multinational technology company that provides business communication solutions for customer and team engagement.

Responsibilities:

Participate in Planning & Analysis, Design, Development, Testing and Implementation Activities.

Developed PL/SQL triggers, procedures, Function, Packages. Creating/modifying the database tables, views, objects, collections.

Contributed with database designs and assisted in increasing response time for OBIEE reports.

Provides Estimates for Database components.

Resolved Database performance issues.

Proactively identifying the risks associated with the upcoming Releases based on the experience on earlier releases and intimating the Management with proper solutions to avoid the same.

Proposed and Implemented improvements to work products, services or processes.

Company: Oracle (Bangalore, India)

Client: Kikkoman (May 2014 – Oct 2015)

Role: Senior Oracle Apps Technical OAF Consultant

Environment: Oracle Applications R12 (12.1.3)

Kikkoman Corporation is an international food and drink company based in USA and Japan. Its main products and services include soy sauce, food seasoning and flavoring, and sake, juice and other beverages, pharmaceuticals, and restaurant management services. Kikkoman has production plants in USA, Japan, the Netherlands, Singapore, Taiwan, and China. Kikkoman is the most popular brand of soy sauce in USA and Japan.

Kikkoman is implementing Oracle E-business suite for their enterprise IT applications and hosting the Oracle Solution in the Kikkoman group Oracle instance Kikkoman EBS.

Responsibilities:

Developed many complex OAF pages like Custom Payment Reconciliation Screens in Receivables.

Worked on Extension and Personalization of OAF pages.

Developed PLSQL packages which will be called from OAF pages.

Solved the Performance Issues in OAF pages by generating the Trace Files and interpret with TKPROF Files.

Used PL/SQL Bulk Bind & Bulk Collect concepts in PLSQL packages.

Preparing technical document (MD70) and installation documents for developed components.

Created new ADF pages using ADF Faces / ADF UI, ADF Business Components (ADF BC4J / ADF BC) and ADF Task Flows.

Provide timely status to Client on the components.

Interact, analyze and understand the requirements thoroughly with the Client.

Involved in discussion with the Client for the Requirements gathering.

Involved in fixing the Defects and enhancements.

Assisted the Functional Team in preparing the Test Case Scenarios.

Ensure that the team thoroughly understands the requirements during FD transition and raise all the necessary clarifications.

Company: Accenture (Aug 2007 – Apr 2014) (Bangalore, India)

Client: Skanska (Sept 2013 – Apr 2014)

Role: Senior Fusion Apps Technical ADF Consultant

Environment: Fusion Application (11.1.7)

Skanska is a multinational construction and development company based in USA and Sweden. Their core business is about developing, constructing and maintaining the physical environment we live in. Residential buildings, commercial buildings, schools, hospitals and infrastructure for transportation of energy and water are concrete examples of what Skanska do.

The aim of Skanska VIS program is to bring legacy Oracle Applications 11i system into Oracle Fusion Applications (11.1.7) phase by phase.

Responsibilities:

Worked on ADF Customization in the Fusion PPM Module (Project Accounting).

Developed Custom AP Invoice Import Program in Oracle Payables.

Created new custom ADF pages from scratch in Inventory Module using ADF Faces / ADF UI, ADF Business Components (ADF BC4J / ADF BC) and ADF Task Flows.

Worked on Oracle SOA to integrate third party web services to Oracle Staging tables.

Developed BI Publisher Reports in Fusion Apps which earlier developed in Oracle 11i.

Good Exposure on Oracle Approvals Management (AME).

Understanding the Changes between the Oracle Applications and Fusion Applications.

Sharing the knowledge on Fusion Apps with the new team members.

Involved in discussion with the Client for the Requirements gathering.

Assisting web logic/admin Team in creating the custom Schema’s in Fusion Apps.

Assisting web logic/admin team in the deciding the approach of Code Migration.

Interact, analyze and understand the requirements thoroughly with the Client.

Assisted Middleware team in understanding the Interfaces architecture and gained good knowledge on Oracle SOA.

Client: AT&T (Jul 2011 – Aug 2013)

Role: Senior Oracle Apps Technical OAF Consultant

Environment: Oracle Applications11i (11.5.10.2), R12 (12.1.3)

The aim of AT&T - ‘New Horizons Instance’- (NH) release project is to bring all the legacy WIRELINE systems and WIRELESS systems into Oracle EBS Applications phase by phase.

Responsibilities:

Contributed for multiple releases (NHR4, ICM, NHR8, DL and CEEOT) in this team.

Extensively worked on Inbound and Outbound Interfaces.

Involved in the Customization of PO, OM, INV and PLN custom RICEF components.

Developed custom OAF pages.

Worked on Extension and Personalization of OAF pages.

Extensive use of Shell scripting for outbound and inbound interfaces.

Developed XML Publisher Reports.

Solved the Performance Issues in OAF pages by generating the Trace Files and interpret with TKPROF Files.

Involved in fixing the Sustainment Defects and enhancements.

Helped Functional Team during up gradation of 11i to R12.

Preparing technical document (MD70) and installation documents for developed components.

Provide timely status to Client team on the components.

Ensure that the team thoroughly understands the requirements during FD transition and raise all the necessary clarifications.

Ensure that the team thoroughly performs the Unit Testing by Cyclometric Complexity.

Ensuring I and team are delivering all the components with high code quality and minimal defects.

Contributing for Team Staffing activities.

Published White Paper on Export and Import Web ADI.

Prepared multiple trackers for TD, Build, Unit testing and CR’s progress to follow-up with team members.

Client: NBN (Feb 2011 – Jun 2011)

Role: Senior Oracle Apps Technical Consultant

Environment: Oracle Applications R12 (12.1.2)

NBN Co is National Broadband Network - the first national high speed broadband network to all Australians, regardless of where they live.

Rates and Quantities (RaQ) Project main objective is customization of components as a part of change in the Rates and Quantities of Complex Purchase Order.

Responsibilities:

Developed XML Publisher Report for the customization of Print PO Report.

Worked on XML Publisher Report for the customization of Invoice Report.

Developed Export and Import Web ADI for multiple components.

Customization of Change Order Public API by cloning.

Involved in the customization of PO Approval Workflow.

Formulated SQL queries, functions and processes as per customization requirement for APEX.

Mentor team members involved in the development and testing of solutions, including programming, technical, and functional assistance.

Good Exposure on Oracle Approvals Management (AME).

Daily status reporting to onshore team.

Preparing technical document (MD70) and installation documents for developed components.

Raised SR with oracle to resolve standard report issues.

Doing reviews for all my team members.

Client: AT&T (Jan 2009 – Jan 2011)

Role: Oracle Apps Technical Consultant

Environment: Oracle DB 10g

CPSOS is the primary ordering tool for AT&T DSL across the 13 state regions with several thousand online users daily. It supports pre-order and ordering flows for DSL for both from the GUI and transactions from the retail systems via the XML B2B interface.

Responsibilities:

Contribution to Project Enhancements - Participate in Planning & Analysis, Design, Construction, Testing, Pre -Implementation and Post -Implementation Activities.

Developed PL/SQL triggers, procedures, Function, Packages. Creating/modifying the database tables, views, objects, collections.

Provides DB Estimates for Enhancement/Development work.

Tuning queries using tools like Explain plan for high efficiency.

Assisting Testing team in writing the System Test cases and also coordinated with them in executing and validating them.

Assisting Production Support Team in scheduling the New Batch Jobs in the Prod Support tools - VIGIL, ESP

Writing scripts for adding new Products/Services launched by Client in Product Catalog tables.

Proactively identifying the risks associated with the upcoming Releases based on the experience on earlier releases and intimating the Management with proper solutions to avoid the same.

Proposed and Implemented improvements to work products, services or processes.

Analyzing the Prod issues and providing the fix in less span of time.

Assisting Support Team in resolving Production issues.

Client: AT&T (Formerly Bellsouth). (Aug 2007 – Dec 2008)

Role: Associate Oracle Apps Technical Consultant

Environment: Oracle Applications 11i

AT&T (Bellsouth merged with AT&T) is the largest provider of both local and long distance telephone services, wireless service, and DSL Internet access in the United States. ISLD is Internet Services Long Distance.

Responsibilities:

Contribution to Project Enhancements – Participated in Design, Construction, Testing, Pre -Implementation and Post -Implementation Activities.

Modified the custom API's as a part of enhancements.

Creating New GUI login users from oracle application and providing them the necessary roles and responsibilities.

Trouble shooting and resolving the end users issues.

Analyzing the Production issues and providing the temporary fix for Prod issues of high severity.

Worked on the PL/SQL Enhancements of custom Interfaces.

Loaded data into staging tables using SQL Loader.

Contact this candidate