Post Job Free

Resume

Sign in

Oracle ERP Consultant

Location:
United States
Posted:
October 07, 2009

Contact this candidate

Resume:

Husain Husna

SUMMARY OF QUALIFICATIONS

* Years Oracle Configurator implementation experience across project cycles.

 Working on application development platforms like Java, JSP, PL/SQL and Oracle Applications products.

 Extensive experience in Oracle Configurator developer – User Interface Design, Rules & Functional Companions.

 Extensive knowledge in Oracle ERP Application modules such as BOM, Inventory, Order Management, IStore, Quoting.

 Experience in designing, developing, testing and supporting RDBMS based applications, which involves programming with Oracle tools such as Forms 6i, Reports 6i, PL/SQL.

 Strong in object oriented design and development – Java, JSPs, Servlets.

 Excellent troubleshooting, de-bugging and problem-solving skills.

 Exceptional focus and follow through abilities, with record of efficiency and productivity.

 A committed team player with extensive organizational and interpersonal skills.

 M.S. in Computer Science from University of North Texas, Denton GPA(4.0/4.0)

 Awarded the Best Master Student of the year in the Computer Science Department

TECHNICAL SKILLS

• Oracle e-Business Suite 11i ( Configurator, BOM, INV, OM, Quoting, Advanced Pricing)

• Java, JSP, Servlets, Beans, ASP.NET, JavaScript, CSS, HTML/DHTML, PHP

• SQL, PL/SQL, Reports 6i, and Forms 6i

• C, C++, Perl and JAVA (1.4) , J2ME, XML, XSL

• UNIX, LINUX, MS Windows XP/Vista

WORK EXPERIENCE

Lion Apparel, OH 02/2009 - Current

Role : Technical and Functional Consultant

Environment : Oracle Applications 11i (Order Management, iStore, Oracle Configurator,

Inventory, BOM)

Responsibilities:

• Technical and Functional consultant for Configurator implementation.

• Rule writing in a way to avoid any maintenance inside Configurator structure in future

• Designing of MD50 and MD70 documents for Extensions and Rules

• Providing a BOM architecture for reducing number of Configurator models

• Resolving all Bugs and Publishing (Remote and Local) issues

• Designed and developed an extension to validate all the client specific Text features using regular expressions at runtime just before saving the configuration.

• Designed and developed an extension to show a display grid using JSP for Size selection of the product

• Designed and developed an extension to capture data at runtime and show it in the descriptive flex fields at OE line details

• Designed and developed an extension to display customer specific data/Option classes to User at runtime based on the calling application OM/ iStore.

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications.

• Designed and developed JSP pages for Istore Catalog sections with HTML description content, Images and customized prices.

• Responsible for publishing content for Istore.

• Creating UI’s as per client requirement.

Flowserve, TX 06/2008 - 1/2009

Role : Technical and Functional Consultant

Environment : Oracle Applications 11i (Order Management, Oracle Configurator,

Inventory, BOM)

Responsibilities:

• Technical and Functional consultant for Configurator implementation

• Developed Extensions which creates an attachment to spit out the BOM selections and Price into a custom RTF file for quote report. The output is saved to 'quoteReportPath'. Developed Extensions to create attachments for Report

• Designed and developed an extension which is invoked on command to default the Unit types to either US or Metric System. This extension changes all the Unit types to the respective defaults overriding the preferences if any that have been selected. This extension helps the user to quickly switch between different standards without having to change each unit type

• Designed and developed a functionality to support parts/Items which are not yet defined in the BOM. This functionality was incorporated to complete a configuration even if the BOM item the user is looking for is not available. In such a case the user hits on the ‘Other’ tab which launches a custom JSP page which will allows the user to enter his desired item Name, Qty, and Price. A Dummy Part is created in the BOM which is selected whenever the user completes giving his custom item description at runtime. Dummy Item Name, Qty and Price are then displayed in the Quote Output report.

• Developed Extensions which Set the Lead times on the Items. This extension fetches the Fixed Lead Time for all the items in the model. This lead time is then displayed to the user during the configuration process. For each BOM Item, get Lead Time from MTL_SYSTEM_ITEMS. This extension is implemented by the java program leadTime.java.

• Designed and developed a functionality called as Default Selection. The Extension is used to set default values which is invoked onCommand when user clicks button. Extension reads Quote Number and Quote Version for default quote from property file.

• Designed and developed an extension which is invoked by all the User inputs that have been defaulted by logic rules. The objective of this extension is to convert the state of these options from LTRUE to UTRUE. This is necessitated by the fact that defaulted options are not hard selections and do not fire off any rules downstream.

• Developed Configurator Extensions using Java and CIO API to dynamically set values of Integer Features and Decimal Features

• Developed a JSP pages which transferred data from the Configurator runtime to a Staging tables

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans, overseeing the development work etc.

• Rule writing and BOM redesigning.

• Resolving all Bugs and Publishing (Remote and Local) issues

ThermoKing, MN (division of Ingersoll Rand) 01/2008 – 05/2008

Role : Techno - Functional Consultant

Environment : Oracle Applications 11i (Oracle Configurator 11.5.10, Inventory, BOM, Order Management)

ThermoKing offers wide variety of color options for the Customer to pick at Case/Kit level and also different colors for the different zones. The complexity involved in creating and maintaining the finish color zone and the paint color options on the BOM bill structure that have many possible color combinations and handling high volume of data involved in the process.

Responsibilities:

• Technical and functional consultant for Oracle Configurator implementation.

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans.

• Configurator Extensions created and attached to each case model through configurator extension rule. This extension will enable the paint selections made by the user in the run time configurator during the sales order entry in the order management to save as the configurator attributes.

• Java Extension for maintaining Color Selection. JSP page pulls up data from SQL tables and then using an extension we populate the selection made into the Configurator.

• Update Configuration is a Java Concurrent Program based on Oracle Configurator (CZ) CIO java API's. This program accepts Config Header ID and Config Rev Number as parameters and updates the configuration for the models with the corresponding paint color zone and color selections coming from legacy system.

• Create, publish and deploy models as initial setup. Later all the updates to the BOMs need to be refreshed and maintained in CZ as well.

Rackable Systems, CA 03/2006 – 12/2007

Role : Techno - Functional Consultant

Environment : Oracle Applications 11i (Oracle Configurator 11.5.10, Inventory, BOM, Order Management)

Responsibilities:

• Technical and functional consultant for Oracle Configurator and Quoting implementation.

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans.

• Designed and Developed an Extension for “Automated Configurator Testing”. Extension allows the super-user/tester submit their test cases using an Excel spreadsheet at any given time, location and see the test result without going through the usual process. Excel spread sheet will have the same choices as available in the Configurator User Interface, to create a look alike feel. Test results can be saved for future testing when there is an enhancement or addition or change of items. This helps the tester to determine whether the rules and extensions written inside the Configurator are creating a valid configuration or not. The test cases are independent of the Rules and extensions developed inside the Configurator.

• Responsible for developing Configurator Extension (Functional Companion) using Java and CIO API to solve attributes saving problem, model validation, and add product search function to the existing UI.

• Responsible for researching, finding solution, fixing production issues, cleaning up backlogs, releasing the fixed to production.

• Support several stages of testing and fixing defects that come along the way.

• Responsible for creating new models for most of Rackable products. The most complicated model involves around 300 rules (Numeric rules, Logic rules, Comparison and Compatibility rules, CDL statement rules…)

• Creating and modifying UI for the new and existing models.

First American RES, CA 8/2005 – 03/2006

Role : Technical and Functional Consultant

Environment : Oracle Applications 11i (Oracle Configurator 11.5.10, Inventory, BOM, Quoting)

Responsibilities:

• Technical and functional consultant for iStore, Configurator and Quoting

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans, overseeing the development work etc.

• Created functional specifications for a custom program to create totals, features and options and to create rule folders.

• Assisted in Rule writing and BOM redesigning.

• Developed Functional Companion to get attribute from runtime configuration model then write into CZ_CONFIG_ATTRIBUTES table.

• Developed Functional Companion to get parameters from existing Oracle Forms, modify these parameters with business rules and get values from database tables then write into runtime configuration model.

• Developed Functional Companion to add search functions for the configurator by calling PLSQL procedures, using customized JSP pages to modify the return value from PLSQL procedures, then put finial value into runtime configuration model.

• Developed Functional Companion to get parameters from runtime configuration model, according to the business logic, sort and sequence these values then produce system id string, put it back into runtime configuration model.

• Developed and modified JSP pages for configurator model.

• Customized existing JSP pages according to business need.

• Responsible for technical design MD70 for all Functional Companions.

F5 Network, WA 01/2005 – 08/2005

Role : Technical and Functional Consultant

Environment : Oracle Applications 11i (Order Management, Oracle Configurator,

Inventory, BOM

Responsibilities:

• Technical consultant for Configurator implementation

• Responsible for the setup and configuration of Configurator.

• Involved in Process Mapping, Gap Analysis and Module design and implementation for iStore, iPayment and Configurator.

• Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans, overseeing the development work etc.

• Interacting with the ERP group and Websphere group to make sure that iStore, iPayment and Configurator integrate with all the related modules like Order Management, HTML Quoting, Receivables, Inventory, Bills of Materials and Work In Progress.

• Assisted in Rule writing and BOM redesigning.

• Developed Functional Companions, Custom JSP pages for requirements.



Contact this candidate