PROFILE:

• 2 decades of experience in design and development of business applications utilizing Oracle/Java technologies in various capacities - as developer, tech lead and solution architect - in custom as well as packaged applications (Oracle E-Business Suite).
• Prolific coder with hands-on experience in wide range of Oracle technologies including backend development (SQL, PL/SQL), front end/middle-tier development (Oracle Forms, Java, OAF), report development (Oracle reports, BI Publisher), workflow development (Oracle Workflow) and Service Oriented Architecture (Oracle SOA, BPEL).
• Strong RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) experience in the context of implementing and supporting Oracle EBS. Good understanding of technical and application architecture of EBS, Application Object Library, customization and personalization standards.
• Techno-functional expertise in core financials and supply chain modules: GL, AP, AR, PO, INV, OM, QP.
• Strong analytical skills; ability to directly work with business stake holders to understand business needs and provide robust and efficient solutions; asking the right questions; focusing on the longer-term; not losing sight of the important for the urgent.
• Good at finding, nurturing and motivating the developers; focusing on the individual, not just on the process; reducing the cost of development by increasing the efficiency of the development process.
• Tech Lead experience on multiple projects with the responsibility of overseeing the technical design and development, ensuring best programming practices, setting coding standards, guiding junior developers, performing code reviews and providing utility components to improve productivity.
• Insights and best practices gained from working in a variety of environments such as custom OLTP applications, ERP, web applications and data-warehousing systems.
• Considerable business domain knowledge acquired from working in Oracle ERP (Financials and Supply Chain modules) and Insurance industry.

SKILL:

Languages: SQL, PL/SQL, Java

Oracle Tools/Technologies: Oracle Forms, JDeveloper, OA Framework (OAF), ADF, Oracle ReportsBI Publisher, Oracle Workflow, Discoverer, Oracle SOA, BPEL

Oracle Applications: General Ledger, Receivables, Payables, Purchasing, Inventory, Order Management, Advanced Pricing, WIP, BOM, Work and Asset Management (WAM)

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Technical Lead/Architect

Responsibilities:

• Work with the functional analysts to review the functional design documents.
• Work closely with the developers to produce the technical design and provide estimates for development work.
• Work with the middleware team to formulate the approach to move the data between the functional instance and the plant instances based on the data volume, frequency, security requirements.
• Establish/verify the best practices and coding standards.
• Provide common components such as error handling framework, flexible lookups, emailing and helpdesk ticket creation.
• Review the code before releasing it to for the testing.
• Work with the DBA team on instance availability, patch application and access issues.

Confidential, Philadelphia, PA

OAF developer

Responsibilities:

• Mostly focused on developing a custom OAF application within the Projects module that the client uses to create installation specifications, generate pdf documents based on the specifications, submit the documents to sub-contractors, architects and customers and track those communications.
• Created the data model and the database objects to support the application including the PL/SQL packages to implement the business logic.
• Developed several OAF pages as well as BI Publisher reports to achieve the desired functionality.
• Used pdf document APIs as well as BI Publisher APIs to run multiple reports with a single click of a button, merge the output of multiple reports into a single pdf document along with any supporting documents attached by users, and provide the combined document as a file download in the web browser.

Confidential, Columbus, IN

Solution Architect/Tech Lead

Responsibilities:

• Apart from leading the development team and owning the technical deliverables, interfaced with the business/functional team as well as with the enterprise architecture group to ensure company level standards are being followed in the project.
• Closely worked with the development team to design customizations, provide guidance in adhering to the customization standards of EBS including the standards for online patching, setting coding standards and perform code reviews.
• Developed conversions and interfaces related to orders, price lists, items, customers etc.
• Developed several Order line workflows where seeded workflows are not sufficient for the business requirements.
• Evaluated and selected various technology/infrastructure components based on the application needs as well as the long term technology roadmap of the company.
• Made decisions related to physical architecture, instance sizing requirements, instance strategy and disaster recovery.
• Formulated security/encryption requirements for data at rest and for data in transit within the application components as well as between the external systems.
• Performed attribute classification to come up with the right security level.
• Recommended appropriate integration patterns and tools (SOA, ODI, SFTP, EDI) for each interface to provide reusability, high availability, ease of monitoring and scalability.
• Worked with information architecture to formulate master data management, data governance, data quality improvements, reporting strategy and data warehousing.
• Consulted for this insurance company on a project to migrate the legacy payment platform to Oracle R12 (12.1.3) Payables. Insurance claims are initiated from a .Net front end, and after approval flow to a custom Oracle application via Oracle SOA Suite (11g)’s BPEL engine in real-time.
• Developed PL/SQL packages to implement the complex business rules to process the incoming payment requests, create suppliers, invoices and payments in Oracle Payables, some in real-time and some in batches. Used open interface tables as well as APIs to integrate with Payables.
• Developed BPEL processes to expose the PL/SQL APIs as web-services to the front-end application.
• At various stages of the processing on the Oracle side, responses are sent back to the front end via BPEL processes.
• Developed batch jobs to generate accounting, process clearings etc.
• Heavily used Sub Ledger Accounting tables to drive accounting related logic in the batch jobs.

Confidential, Indianapolis, IN

Responsibilities:

• Designed and developed several enhancement initiatives for this manufacturer of industrial coatings to provide customizations to the Oracle E-Business Suite 11i modules OM, WIP, Advanced Pricing, PO and AP: The projects included:
• Project to enhance the precious metal sales order processing: Since the precious metal prices change every market day, the amount invoiced to the customer is based on the precious metal price on the day the order is shipped and not when the order was booked.
• A custom screen is developed where users can enter the prices for various markets, currencies and metals, which are then used to insert/update the prices on hundreds of price lists using backend PL/SQL packages.
• Order line workflow has been customized to block the shipped line from fulfillment. A custom concurrent program re-prices the shipped lines with the latest prices and progresses the line to invoicing.
• Project to automate the return processing (RMR) of precious metal items where customers usually receive credit for recovered precious metal on a new sales order and the manufacturer keeps a certain percentage of precious metal.
• The return sales order is linked to a WIP job which consumes the return item and produces various precious metals through refining process. A custom program then goes through the completed WIP job and determines the amounts of metals recovered and splits them between customer lot and manufacturer lot through inventory material transactions.
• Design and development of a system to record and track the serial numbers that customers transmit along with an order.
• An interface is developed to import the orders and attach the serial numbers to the orders.
• A custom screen is developed which helps the users scan and verify the serial numbers at the time of booking. Another custom screen lets the users assign the serial number to various departments during the processing of WIP job that is auto created from the order.
• Finally, a third custom screen lets the shipping users to verify the serial numbers at the time of shipping.

Confidential, Dayton, OH

Lead developer in Oracle Applications

Responsibilities:

• Customize the seeded SOA/BPEL interfaces between WAM and Oracle EBS R12 modules Payables, Purchasing, Inventory and HR by adding pre and post PL/SQL hooks.
• Customize the user interface and functionality through the modification of SAPI.pll.
• Develop custom reports as well as provide ad-hoc one-time data extracts in response to user requests
• Troubleshoot the day-to-day user issues and provide data fixes where necessary, such as when records are stuck in the interface tables due to incorrect setups or data.
• Work with Oracle support on bug fixes and patches.
• Took part in other initiatives such as developing OAF extensions and personalizations in iSupplier, Discoverer reports in Project Accounting.