SUMMARY:

• About 11+ years of experience in IT Industry with expertise in Requirements Gathering, Development, Testing and Implementation using Oracle and Java.
• Expertise in design, development and customization of Oracle e - business suite products like Confidential (OPM) and Discrete Manufacturing with strong knowledge on Oracle Advanced Supply Chain Planning (ASCP), Inventory, Oracle Purchasing and Order Management.
• Good working knowledge of order to cash (O2C) process, procure to pay (p2p) and Supply Chain business flows
• Good working knowledge of Trading Community Architecture (TCA), Oracle Project Accounting, Oracle GRC (Governance, Risk and Compliance Manager) and Oracle PCG (Preventive Controls Governor)
• Skilled in Forms and Reports Customizations, Data Conversions, Version Up gradation development of Interfaces and workflow customizations.
• Good knowledge in Oracle Complex, Maintenance, Repair and Overhaul (cMRO) and good understanding of table structures of Oracle Projects and Enterprise asset management (eAM).
• Experience in Application System Administration activities like creating concurrent programs, application user setup, defining responsibilities, values sets, flex fields, registering menus, defining Business Events, developing forms and reports, providing support to apps users for any technical issues.
• Highly skilled in Oracle Database Programming with Queries, Triggers, Stored procedures and PLSQL packages.
• Excellent programming skills in SQL, PL/SQL, C, and C++ along with strong understanding of object oriented methodologies and software life cycle.
• Strong knowledge of Application Object Library (AOL) and knowledge of System Administration.
• Proficient in Database design and SQL Performance Tuning.
• Good knowledge on workflows, XML/BI Publisher for creating templates and Oracle Application Express (APEX)
• Experience in building rules, approver groups, attributes and conditions in AME
• Excellent communication skills, interpersonal skills, leadership qualities, systematic approach and ability to work effectively in fast paced environments. And ability to mentor junior developers.
• Ability to work independently in any product/ service business because of ability to rapidly grasp and assimilate knowledge associated with that business.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++

Web Technologies: JSP, XML, HTML, DHTML

Databases: Oracle 9i / 10g

Operating Systems: Linux, Windows 2000/NT/XP and MS-DOS

Tools: /Utilities: Forms 6i/10g and Oracle Reports 6i/10g, XML Publisher, SQL Navigator, Toad, PLSQL Developer, JDeveloper, Visual Basic, Workflow Builder 2.6.3.5.0, SQL Loader, Discoverer

Oracle Applications(ERP): Confidential (GMA, GMI, GMD, GME, GMF, GMP), Oracle Inventory, BOM, WIP, Oracle Purchasing, Order Management and Advanced Supply Chain Planning (ASCP), Oracle Projects, Accounts Payables, GRC

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Responsibilities:

• Worked on developing a total custom Job Traveler report used in the shop floor for manufacturing the doors.
• Developed a single XML template to generate different styles of output dynamically
• Bursted the report to different printers in each shop floor line based on the subcomponent produced in each line in the shop floor and provided the ability to print multiple copies
• Generated barcodes for instant scanning in shop floor
• Used Oracle APEX to specify the printer location bursted in the shop floors
• Generated images to be printed in the report so that it can be used in building the door configurations
• Developed a Safety stock and Min-Max workbench in determining the min-max/safety stock values for MRP planned and Min-Max planned items. Usages from the legacy system were imported and a monthly process is run to determine the usages for each month based on the type of the item.
• Created a form from scratch to display the usages for each item and enable the users to change the calculated min-max values and update the item master/safety stock of the item
• Created new concurrent programs to import usages from legacy
• Created a report for calculating the monthly usages and displaying the calculated usages as an excel for the business to review using the XML templates
• Developed a custom program to book the sales orders automatically as part of a custom scheduling process.
• Mentored a few junior developers technically.
• Developed custom reports to depict the Demand and Supply pegging to a product/item. These ASCP reports were used to determine the immediate supply of the items for meeting the demand of a product on a specific date.
• Analyzed and fixed the issues on the integration-piece of Buy Design in creating the * items, BOM and Routings for each configured assembly in the system. The quotes are entered in the integrated system and then imported into the Oracle system.
• Developed program to interface customers in Buy Design to facilitate quote creation. The interface program picks up all active and inactive customer sites and gets the data synced up through SOA service calls.
• Developed program to interface Items and products to generate the configured parts and the pricing items

Environment: Linux x86, Windows XP, Oracle 11g, PLSQL, Subversion

Confidential, Dallas, TX

Responsibilities:

• Worked extensively in developing invoice interfaces for multiple sources.
• I was also involved on some Vertex integrations with Oracle e-Business suite
• Worked on form personalizations as per the client requirements.
• Responsible for authoring the technical design documents
• Worked on few performance intensive queries and fine-tuned them for better performance.
• Was involved in customizing some standard forms like PO, Requisitions, Invoice workbench, Corrections, Capital projects as well few custom forms.
• Developed interface program which generates the pdf images of each isupplier invoice using BI Publisher and XML bursting.
• Was involved in few conversions like item/category conversion, user/employees conversions.
• Worked extensively on PO Approval workflow customizations, hold approval workflows.
• Was involved in defining views, tables and concurrent programs, lookups, values, value sets, messages, attachments as part of enhancements.
• Resolved few complex issues with less turn-around time
• Have written quite a few Unix shell scripts as part of ESP schedules and monitored the ESP jobs scheduled as part of the lights out processes.
• Worked on AME for generating the approval groups in the requisition approval workflow. Created new rules, approver groups and attributes as part of the enhancements.
• Was instrumental in determining the Corp defaulting logic in code combinations
• Was awarded for excellence in results, being most reliable and innovative by the client twice.

Environment: Linux x86, Windows XP, Oracle 11g, Toad, Borland Starteam

Confidential, Dallas, TX

Responsibilities:

• Developing interface program using API’s to load the approved supplier list. The item lead times are computed based on the allocation percent of the supplier to each item in the organization.
• Implemented new feature called the cost roll-down - which computes the cost of packaging material along with the base unit item cost. I was part of requirement gathering to the unit testing of the changes.
• Developed interface program, which in-turn uses the oracle API to upload the price list data onto the Oracle.
• Was involved in some testing of order to cash process
• Developed few custom reports using oracle discoverer depicting few information on the sales orders, their statuses, pack slip information, pick slip information
• Was involved in defining views, tables and concurrent programs as part of the enhancements
• Developed an interface program to define and upload item substitutions and defining their relationships

Environment: Linux x86, Windows XP, Oracle 10g, PL/SQL Developer, Visual source safe

Senior Application Consultant

Confidential, Harleysville, PA

Responsibilities:

• Developed new forms in Oracle Inventory module that captures few essential details of the Items which caters to the customers requirement
• Involved in functional design discussions in order to understand the customer requirements.
• Developing new forms in New Product Development module to capture the recipe details in a matrix format to suit the customer requirements
• Using workflows to customize few notifications that need to be sent from the OPM Regulatory to the users for generation of labels. These labels are then pasted on the
• Extensively involved in data conversions from legacy system to Oracle system - Develop PL/SQL packages/scripts to load items/formulas/recipes onto interface tables.
• Developed an interface program to load the Item Categories into Interface tables using PL/SQL and Importing Item Categories using standard Import program
• Register custom Forms and Reports in Oracle Applications, creating Request Groups and assigning to appropriate responsibilities using System Administrator in Oracle Applications.
• Used Oracle Discoverer in designing some of the reports
• Tune custom code for Performance and Easy Maintainability.

Environment: Linux x86, Windows XP, Oracle 10g, Oracle Forms 6i and Reports 6i, XML Publisher.

Confidential

Senior Applications Engineer

Responsibilities:

• Worked on number of customer enhancements with using JTF architecture where the front end changes were done using JSP’s.
• Wrote number of new methods in the factory and bean and have generated number of Rosetta files.
• Worked closely with Product Management team in designing and building customer enhancements.
• Was actively involved in providing solutions for various customer issues both functionally and technically
• Worked with Customer support representatives from various time zones in providing resolution of issues/queries
• Played critical role in mentoring the new comers with the coding standards, providing technical assistance and functional trainings.
• Having good knowledge on Engineering, Visit Work Package and Long term planning modules
• Handled lot of major enhancements single handedly to be delivered to the customer.
• Involved in writing Technical Design Document for all the enhancements
• Performed lot of UI - JSP changes, generation of LDT for region additions and attribute additions
• Worked with Customer support representatives from various time zones in providing resolution of issues/queries
• Worked on performance intensive queries for the issues reported by customers having heavy setup in airlines
• Have prepared documents that were given to the customer which provided steps for execution of the new features.
• Appreciation from the customer for providing a very user friendly UI and for very quickly implementing one of the major feature.

Environment: SQL, PL/SQL, JDev, SQL Navigator

Confidential

Responsibilities:

• Implementation of Discrete and OPM Modules and suggesting customizations wherever required
• Development of new features in OPM modules of releases 11.5.10 and R12 using SQL, PLSQL, Forms 6i, Reports 6i and Pro-C
• Working closely with Product Management team in designing and building the new requirements of customers.
• Providing workaround solutions for various customers issues both functionally and technically
• Performance tuning of various time intensive batch programming and SQL queries
• Working with Customer support representatives from various time zones in providing resolution of issues/queries
• Creating LDT files for the new Profiles, Messages, Concurrent Programs, Lookups, Request groups and ODF for Database changes.
• Handled the implementation of new R12 requirements in OPM Planning like complex routes, sequence dependency and calendar convergence projects
• Worked closely with the BOM team to come-up with a common calendar design for Discrete and Process Manufacturing.
• Modified the BOM calendar form in-order to cater to OPM requirements
• Worked extensively with the Oracle Inventory team for the Inventory convergence projects and was involved in developing technical design documents for MRP planning modules
• Involved in preparing high level design documents and detail level design documents
• Worked extensively on APS Data collections from source to the demand servers, analyzing the data in APS collections work bench, running ASCP plans in generating plans to meet the demand and finally feeding back this data to OPM for real implementation
• Extensively used explicit cursors and REF cursors
• Wrote scripts to migrate data from 11.5.10 to 12.0 tables
• Improved the performance of major queries for item substitution project
• Have created ODF for table and view changes.

Environment: SQL, PL/SQL, Oracle Forms and XML Publisher

Confidential

Analyst Programmer

Responsibilities:

• Have worked on inventory modules in recording the various transactions that are made like the subcontract issue/returns, maintenance issue/return and inventory issue/return.
• Was primarily involved in coding stored procedures in Microsoft SQL Server 2000.
• Actively involved in developing a test framework
• Involved to the great extent in complete unit and system integration testing of the modules
• Wrote scripts that aided me in unit testing
• Won appreciation from the manager for showing quick response time for the issues reported and for resolving the issues very quickly.

Environment: ASP. MTS and SQL server 2000 on Windows 2000