SUMMARY:

• 18+ years of experience in design and development of business applications utilizing Oracle 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, OBIEE), workflow development (Oracle Workflow) and Service Oriented Architecture (Oracle SOA, BPEL).
• 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) and Insurance industry.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java

Oracle Tools/Technologies: Oracle Forms, Oracle Reports, JDeveloper, Oracle Workflow, OA Framework(OAF), Application Development Framework (ADF), Discoverer, BI Publisher,Oracle SOA, BPELOracle Applications: General Ledger, Receivables, Payables, Purchasing, Inventory, Order Management, Advanced Pricing, WIP, BOM, Work and Asset Management (WAM)

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

Responsibilities:

• Currently working as a Solution Architect for this engine manufacturer on a project to migrate a legacy order management application to Oracle R12 (12.2.4) Order Management and Release Management. Closely working with the project implementation team to provide architectural guidance in several domains and to ensure enterprise level standards are being followed.
• 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. Closely worked with the functional team to align the functional design with the company level ERP design as well as rationalizing the customizations.

Confidential, Cleveland, OH

Responsibilities:

• Consulted for this insurance company on a project to migrate the legacy payment platform to Oracle R12 Payables. Insurance claims are initiated from a .Net front end, and after approval flow to a custom Oracle application via Oracle SOA Suite’s BPEL engine in real-time. Complex business rules are implemented in PL/SQL packages to process the incoming payment requests, create invoices and payments in Oracle Payables, some in real-time and some in batches. At various stages of the processing on the Oracle side, responses are sent back to the front end via BPEL processes. A number of batch jobs are in place to generate accounting, process clearings etc. Worked on design and development efforts on the middle and database tiers (SOA and Oracle) and interfacing with Oracle Payables.

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

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.

Confidential, Cleveland, OH

Responsibilities:

• Designed and developed an extension to the commission tracking system that is tightly integrated with Oracle Applications 11i modules GL, AP and AR for the brokerage division of this business services company. This application tracks the commissions earned by the financial brokerage division and the commissions payable to the sales reps working for the division. The application was originally designed to handle various insurance products (I was involved in the initial development of this application from ). The new initiative was to extend this application to track the commissions involved in the financial products division (401k, pension funds, IRAs etc).
• As the lead developer and analyst, closely worked with the business users to formulate technical solutions. Started by understanding the business processes and the legacy application used by the financial brokerage division. Formulated the functional solution involving initial data conversions, data consolidation, front-end screens, manual setups and programmatic interfaces between the two applications.
• Created the database schema objects to support the new development. Developed a number of PL/SQL packages to implement the various business rules and to support business activities. Developed multiple screens using OAF and Oracle Forms to support one-time setups as well as transaction processing. Performed data extraction from the legacy application and converted customers, customer invoices, vendors and vendor invoices. Built various interfaces to AP, AR and GL. Lead a small team of developers and testing efforts. Provided batch processing utilizing Unix shell scripts. Periodically supported other development efforts, provided bug fixes and resolved performance issues.

Confidential, Cleveland, OH

Responsibilities:

• Helped this manufacturer of residential and industrial coatings transition a legacy application based on Oracle Forms to a web-application. This application is used by plant personnel to fill the paint into appropriate containers and assign them to the docking stations. The new strategy, which implements a typical three tier architecture, is designed to reduce the cost of software (by utilizing open source web server and IDE) and the cost of maintenance (by eliminating the need to deploy the Forms on each terminal).
• A J2EE web application developed using MyEclipse 6.0 is deployed to the open source Tomcat 5.5 server. Developed the Java classes which encapsulated the application logic and the JSP pages which provided the front end and the servlets which linked the two. Moved most of the business logic embedded in the Oracle Forms to PL/SQL packages which were then linked to the Java classes through JDBC. Utilized JavaScript to drive some front-end logic and CSS to provide consistent look and feel across the application.

Confidential, Atlanta, GA

Responsibilities:

• This was a development lead role in a team that implemented GL and AR modules for this provider of executive compensation packages. Involved in various development efforts in GL and AR, including conversions (historical journals, customers, invoices), interfaces (invoices, lockbox) and custom reports.

Confidential, Austin, TX

Responsibilities:

• This project was a re-implementation of GL,AP,FA,PA and PO modules to consolidate 3 separate 11.0.3 instances (Americas, Europe-Middle East-Africa and Asia Pacific) into a single global 11.5.10 instance for Oracle’s client Confidential Computers in Austin, TX. Part of the interfaces team, I was responsible for designing and developing interfaces in Purchasing.

Confidential, Harrisburg, PA

Responsibilities:

• Worked as lead developer during the implementation of Oracle Applications 11i (11.5.10.2) for this manufacturer of lawn-care products. Apart from designing the technical solutions, responsible for providing assistance and guidance to developers to ensure best coding practices and adherence to Apps standards. Involved in various development efforts in Purchasing, Payables, Order Management and Receivables including but not limited to the following:

Confidential, Cleveland, OH

Responsibilities:

• Worked as a PL/SQL resource for the Mortgage division in two major projects aimed at making the mortgage process paperless; one is to send and receive the title requests electronically and the other is to enable the borrowers to sign the mortgage note electronically.

Confidential, Cleveland, OH

Responsibilities:

• Designed and developed a custom application called ‘Commission Accounting System’ for the insurance brokerage division of this business services company. This application is a comprehensive solution to the insurance business needs of the company and interfaces with other applications such as General Ledger, Receivables and Payables.

Confidential, Richfield, OH

Responsibilities:

• Worked as a PL/SQL and tuning resource on a project to enhance a data warehousing application that serves as online electronic part catalogs for automobile parts.

Confidential, Wooster, OH

Responsibilities:

• Part of the technical team that implemented Oracle Applications 11i modules General Ledger, Payables, Receivables, Purchasing, Human Resources and Payroll for this grocery chain.

Confidential, Toledo, OH

Responsibilities:

• Designed and developed data warehouse applications for this leading glass manufacturing company. Some of the tasks:

Confidential, Cleveland, OH

Responsibilities:

• Designed and developed Direct Ship application for this electronics distribution company. This system enables the shipment of some parts directly to the customers of the client from the suppliers of the client and eliminates additional cost of loading, unloading and storage.

Confidential, Dayton, OH

Responsibilities:

• Technical assistance in the implementation of Oracle Applications 10.7 Financials, Order Entry, Purchasing, WIP, Inventory modules for this publishing company. Most of the work done was in Financials and custom extensions to Oracle Applications. Some work included report development in other modules mentioned.

Confidential, Indianapolis, IN

Responsibilities:

• Developed reports and forms using Forms 4.5 and Reports 2.5 to extend the functionality of Oracle Applications 10.7 SC for a manufacturer of and motivation products in Indianapolis, IN and Champaign, IL.

Confidential, Evansville, IN

Responsibilities:

• Developed ‘Price Point Generation System’ that automates the revision of sticker price for the selected merchandise of this retail footwear company. Developed ‘Open to Buy System’ that reflects the difference between the planned and existing inventory for a store. Used SQR, PL/SQL and Forms 4.5.