We provide IT Staff Augmentation Services!

Oracle Resume

SingaporE

Experience Summary

  • 7.5 years of IT experience in Oracle Configurator – rules (CDL and Extensions), Structures, supporting runtime Configurator, developing templates for user interface, BOM and NON-BOM structure creation. CIO package. Batch processing and validation.
  • Calling CIO APIs in portal applications and OAF applications
  • Inventory, BOM, Order Management and Quote modules, - Item creation, org assignments, BOM creation (Option classes, models), handling order creation for testing, SR creations, ZOOM forms, negotiation holds, price list creation. Quote creation – customer and system creation. Quoting approvals. Quote to order conversion. Order imports.
  • Production support for all the Configurator applications in US and EU regions.
  • Extensive work experience in Install base and IStore modules.
  • Analysis, Design, Developing, Testing and supporting the application software for various web based, Client/Server applications using Java/J2EE technologies, CIO packages, AIM and SQL.
  • Specializing JSP, Servlets, XML (Sax and Dom parsers), UML, WebLogic/Tomcat, Oracle 10g, UNIX, Swings, Spring Framework, Design Patterns, Java Beans, JDBC, JavaScript, SNMP, NMI, Oracle Configurator.
  • Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL. Also experienced in sql-tuning for better performance.
  • Have experience and good knowledge of ERP, Motors, Data Storage, Hardware and Energies, Investment Banking, Private Banking, Finance, Insurance, Cargo and Travel Domain.
  • Exposure in varied business processes. In-depth technical and functional knowledge of Oracle Applications in Release 11.5.9/11.5.10.
  • Have good experience in end to end testing, system testing. Order to SR to Install base testing.
  • Proficient in Object Oriented Analysis and Design and Unified (UML) Object modeling techniques and Design Patterns.

Education


  • Master of Science (Software Engineering)
  • Bachelor of Science (Computers)

Language Certifications:



Japanese – JLPT, Level 4.

Job Title History



Technical Consultant (Oracle Configurator, JAVA/J2EE) Confidential, (Singapore) March 2009 – till Date
Techno/Functional Consultant (Oracle Configurator, JAVA/J2EE) (Confidential,Singapore) - Nov 2008 to March 2009
Techno/Functional Consultant (Oracle Configurator, JAVA/J2EE) (Confidential,India) - Aug 2004 to Nov 2008
Confidential,JAVA/J2EE/OAF developer - Sep 2003 to Aug 2004

Primary Skills



Oracle Apps (Configurator(11.5.7, 11.5.9, 11.5.10), Inventory, BOM, Quote and OM), JSP, Servlets, XML (Sax and Dom parsers), UML, WebLogic/Tomcat, Oracle Pl/Sql, Oracle 10g, UNIX, Swings, Spring Framework, Design Patterns, Java Beans, JDBC, JavaScript, SNMP, NMI.

Productivity Tools



Eclipse, Jdeveloper 9.0.3, PPM, Custom Rules Engine, Toad, Putty, WINSCP, SVN, Share Point, Visual Source Safe, Oracle Configurator Developer Tool, Log4j, SNMP4J

Operating System



Windows 98/NT/2000/XP/ 2003 and UNIX

DBMS



Oracle

Web Server/Application Sever

Apache, Tomcat

Open Source Components



log4j, snmp4j

Industries



ERP, Data Storage Canters, Motors, Hardware, Banking and Energies.

Engagement Overview


Project 1: Switch and Data – Confidential,US Client: Confidential, SINGAPORE Duration: Jan 2011 – Till date

Role: As Oracle Configurator lead handled the design and development of the entire flow of calling Configurator APIs from Equinix portal. Handled the middle tire design and development for front end and back end interaction until order booking. Created BOM and mapping interfaces for portal. Created rules and mapping interfaces for portal. Extensively used java extensions for importing and exporting the data to and fro from oracle.

Project 2: Confidential,US and EU Client: Confidential,SINGAPORE Duration: June 2010 – Dec 2010

Role: As Oracle Configurator lead handled the design and development of the entire flow of calling Configurator APIs from Equinix portal. Handled the middle tire design and development for front end and back end interaction until order booking. Created BOM and mapping interfaces for portal. Created rules and mapping interfaces for portal. Extensively used java extensions for importing and exporting the data to and fro from oracle.

Project 3: Europe Order Management IBTS. Client: Confidential,SINGAPORE

Role: As an Oracle Configurator consultant, aligning the BOM details for EU BOM structure to be in par with US BOM. New BOM development, model population, extensive java rules creation, creation of non bom models and heavy UI customization. Publication to calling modules – Quoting, OM and IStore modules. Order and quote creation. Usage based rules and usage based publication.

Duration: Feb 2010 – May 2010

Contribution: Development - Actively involved in

  • Interacting with Business analysts in analyzing and understanding the requirements, performing the impact analysis and develop Technical specifications
  • Estimating and setting development time lines using functional point analysis
  • Extensive usage of CIO API to support runtime Configurator.
  • User interface template creation. Dynamic user interface displays.
  • Developing CDL and Java Extensions.
  • Developing NON Bom models to support the customization.
  • Extensive User interface customization.
  • Usage based structure and rules
  • Publication to OM and Quoting.
Project 4: Europe Order Management Back end - Confidential,

Client: Confidential,SINGAPORE
Role: As an Oracle Configurator consultant, analyzed the requirement in front end portal Configurator – BOM development, model population, rules creation, creation of non bom models and heavy UI customization. Publication to calling modules – Quoting, OM and IStore modules. Order and quote creation. Usage based rules and usage based publication.

Environment & Tools: ORACLE APPLICATIONS 11I(11.5.10) WITH CRM, ISTORE, ISUPPORT, OCO, INSTALLED BASE, CONFIGURATOR, HTML, JAVA SCRIPT, JSP, JAVA BEANS/ SERVLETS , AK DEVELOPER, WINDOWS XP, ORACLE9I , SUN-SOLARIS, TOMCAT, ADOBE AND MACROMEDIA PACKAGES.

DBMS: Oracle 10g

Duration: Oct 2009 – Jan 2010

Contribution: Development - Actively involved in

  • Interacting with Business analysts in analyzing and understanding the requirements, performing the impact analysis and develop Technical specifications
  • Estimating and setting development time lines using functional point analysis
  • Extensive usage of CIO API to support runtime Configurator.
  • User interface template creation. Dynamic user interface displays.
  • Developing CDL and Java Extensions.
  • Developing NON Bom models to support the customization.
  • Extensive User interface customization.
  • Usage based structure and rules
  • Publication to OM and Quoting.
Project 5: Re-Engineering of Equinix Customer Care Portal (ECCP).

Client: Confidential,SINGAPORE
Role: As a Technical consultant, actively involved in Java/IStore, Oracle Configurator Applications Development, BOM, INV and OM,
Environment & Tools: Oracle Configurator, CIO Library, JSP, Ajax, Java Script, SQL, PL/SQL, Eclipse, UNIX, HTML, IPlanet and Tomcat.
DBMS: Oracle 10g

Duration: July 2009 – Oct 2009 – Currently in UAT Stage.

Description: As an Oracle and Java/J2EE Technical consultant extensively involved re-engineering UI in IStore, Requirement analysis, Pilot project execution, Design decisions of both front end and back end tire. Involved in flattening the User interface by talking to Oracle Configurator and BOM via a custom API. Development APIS in Configurator to take and push back data to front end. Involved in Complete design, development and testing life cycle by using Oracle SQL, PL/SQL, JSP, Servlets, Configurator CIO Objects, Ajax, load runner and QC. Involved in Configurator Rules, Non BOM model setup, UI template creation, publication, BOM model creation, Population of BOM items and models, Import of Models from external source(data file, legacy systems etc), setups and configurations, Profile setups, Functions and Menus creations based as the requirement.
Contribution: Production Support/ Development.

  • Analyze requirements by talking to BSAs, prepare TD, provide estimates for the project execution and prepare requirement specifications.
  • Extensive involvement in design decisions for both back end and oracle application tires.
  • Extensive involvement in development of custom APIs to talk to the front end and push back data to Oracle tables.
  • Customizing the Oracle Configurator UI pages, creation of NON BOM items, models, rule setups, importing of BOM items from external source and integrate Oracle Configurator with OM and Quoting.
  • By using the Standalone application pass the product parameter and develop APIs in Configurator and do further processing.
  • Worked extensively on Configurator UI Look and Feel based on the Equinix requirement to flatten the UI with dynamic data.
  • Customizing Oracle Configurator products and rules based on usage for OM, IStore and Quote modules.
  • Creating custom templates for SOW and other templates based on requirements.
  • Customization quote pages using JSP, servlets and java script.
  • Involved in writing quote APIs in PL/SQL and java.
  • Creating the PL/SQL APIs and register as concurrent programs.
  • Writing CIO wrappers.
Project 6: Implementation of Silver-BOE – Production Support.

Client: Confidential,SINGAPORE
Role: As a Technical consultant, actively involved in Java/Oracle Configurator Applications Development, BOM, INV, OM, ISTORE and Quote.
Environment & Tools: Oracle Configurator, CIO Library, JSP, Servlets, Java Script, SQL, PL/SQL, Eclipse, UNIX, HTML, BEANS/ SERVLETS, TOMCAT and ADOBE
DBMS: Oracle 10g

Duration: March 2009 – Till Date

Description: As an Oracle Technical consultant involved in Production support, analyze the requirement for enhancements in Oracle Configurator, BOM, Inventory and Quote modules, development and testing by using Oracle SQL, PL/SQL, JSP, Servlet, Configurator CIO Objects and XML Publisher. Involved in Configurator Rules, Non BOM model setup, UI template creation, publication, BOM model creation, Population of BOM items and models, Import of Models from external source(data file, legacy systems etc), setups and configurations, Profile setups, Functions and Menus creations based as the requirement.
Contribution: Production Support/ Development.

  • Handle production issues and change requests for Configurator and Quote modules.
  • Analyze requirements for the enhancements, prepare TD, estimates for the enhancement and prepare deployment documents.
  • Customizing the Oracle Configurator UI pages, creation of NON BOM items, models, rule setups, importing of BOM items from external source and integrate Oracle Configurator with IStore, OM and Quoting.
  • By using the Standalone application pass the product parameter and develop APIs in Configurator and do further processing.
  • Worked extensively on Configurator UI Look and Feel based on the Equinix requirement to flatten the UI with dynamic data.
  • Customizing Oracle Configurator products and rules based on usage for OM, IStore and Quote modules.
  • Creating custom templates for SOW and other templates based on requirements.
  • Customization quote pages using JSP, servlets and java script.
  • Involved in writing quote APIs in PL/SQL and java.
  • Creating the PL/SQL APIs and register as concurrent programs.
  • Writing CIO wrappers.
Project 7: Implementation of Java/J2EE Motors Application.

Client: Rosemount EMR Motors - Confidential,Configurator
Role: As a Techno/Functional consultant, actively involved in Java/Oracle Applications Development, BOM, INV, OM and Quote.
Environment & Tools: JSP, Servelts, Java Swing, SQL, PL/SQL, Eclipse, UNIX, UML, HTML.
DBMS: Oracle 10g

Duration: Sep 2007 – Feb 2009

Description: Rosemount EMR Motors integrated with Prime View Portal is proprietary information management system designed expressly for prime brokerage clients, featuring timely and efficient management of all trades, positions and balances.
Among its Unique Capabilities:

  • Internet Workstation: This internet-based workstation gives clients the flexibility of an on-line system without the hassle of additional software or the need to upgrade network computers. It operates in real-time, and all data is housed, maintained and stored by UBS
  • The Browser: Through the browser, clients can view summary level data with direct links displaying a variety of underlying detail, including historical data from inception
  • Extract Builder: Accepts and sends client trade extracts in the client form.

Contribution: Actively involved in

  • Interacting with Business analysts in analyzing and understanding the requirements, performing the impact analysis and develop Technical specifications
  • Estimating and setting development time lines using functional point analysis
  • Interacting with production support and upstream system members to resolve the data and system dependencies
  • Mentoring the team members in development
  • Release and change request management
  • Owing the database and system components and closing monitoring the impact of change request on these components.
  • Discuss with the customer to synchronize use cases with the customer expectation.
  • Involved in design of application framework using J2EE guidelines and most J2EE design patterns and Object Oriented Analysis and Design (OOAD) methodologies.
  • Application setups for Configurator in new 11.5.9 environments.
  • Remodeled existing client products including servers.
  • Design and development of User Interfaces using JSP, (J2EE), XML, XLS, XSLT, XSD, HTML and DHTML.
  • Developing GUI components using Swings.
  • Developed low-level and high-level design specifications.
  • Developed interface programs to load the customer information from legacy systems by using SQL*Loader, PL/SQL package and Custom Import Concurrent program.
  • Developed database triggers to report the changes to ‘Entered’ status line in the sales order change report and added a parameter to select the status.
  • Changed the Dynamic SQL to general SQL and used Bulk collect to improve the performance of the component.


Project 8: Implementation and production support EPCS-II.
Client: Confidential,USA
Role: As a Technical consultant, actively involved in the Implementation of Configurator (11.5.10) module, BOM, INV, OM and ISTORE.
Environment & Tools: Java, WebLogic/Tomcat, Servlets, JSP, AJAX, Design Patterns, UML, XML, SQL, JDeveloper, PL/SQL, Oracle 9i

Duration: Dec 2005 – July 2007

Description: Confidential,integrated with UBS banking J2EE application integrated with heterogeneous risk engines designed and developed to provide unified view of data for Credit Risk Community (CO, CA and CRA). CO/CA/CRA/Guests can retrieve position data for any given customer from the system both simultaneously and individually. Roles and privileges have been implemented to allow CAs and CRAs to help the COs in their daily tasks. By displaying the details of Customer’s Position in various levels of granularity, format and reports, it helps CO/CRA/CA analyze Customers position and take appropriate decisions about Customers Excesses on the products of ADP.

  • Design and development
  • Gather requirements and develop use cases.
  • Coordinating with the client in Design.
  • Involved in Knowledge acquisition from the client.
  • Studied the competitors in the market and discussed with the client to synchronize with their expectations, delivered documents on study.
  • Coded complex business cases and expose them to custom front-end (.Net) using Web Services.
  • Developed code for exposing Java objects to front-end (.Net) screen using WebLogic.
  • Design and development of Configurator User Interfaces using JSP, (J2EE), XML, XLS, XSLT, XSD, HTML and DHTML.
  • Developed stored procedures to populate data into custom schemas for displaying in the Front End .Net pages.
  • Optimized the SQL, PL/SQL block and stored procedures for better performance
  • Worked on the existing issues and produced the analysis report to the client.
  • Involved in design and development of database.
  • Production support and maintenance: Involved in the following production support activities
    • Attending the service request calls from client
    • Calls resolution followed by initial discussion with relevant department.
    • Modify the critical production programs to solve the issue.
    • Took the responsibility for coordinating the support team and scheduling the activities.

Project 9: Development of Platinum Client: Confidential,Japan – Oracle Configurator.

Role: As a software engineer, actively involved in the Implementation Platinum SDK.
Environment & Tools: Java, JNI, SNMP, C++, Java, Bounds Checker, Eclipse, MS Visual SourceSafe, Firebird.

Duration: Mar 2005 – Nov 2005

Contribution: Actively involved in

  • Participated in the discussion with the customer to synchronize use cases with the customer expectation.
  • Developed the design for communication layer module of the application and make sure that design reflects the use cases developed.
  • Extensively used TOAD for database access and SQL tuning.
  • Involved in design and development of database.
  • Optimized the SQL, PL/SQL block and stored procedures for better performance
  • Developed Database triggers.
  • Designed and Developed the interface program to load the Invoices from a legacy system into application’s DB using SQL*Loader, PL/SQL package and Open Interface Import Concurrent program.
  • Coded the JNI layer in which device level communication is developed in C++ and user level communication is done in core Java.
  • Constructing SNMP packets for sending and receiving device information.
  • Developed and API for the device communication layer which is responsible to interact with the device (receive and send information from the device) which uses the JNI layer APIs.
  • Contributed in system testing and compatibility testing of Platinum device communication component.
Project 10: Osmium DB Tools (Import/Export)

Client: Confidential,Japan
Role: As a Techno/Functional consultant, actively involved in full life cycle implementation.
Environment & Tools: Oracle, JSP, Servlets, Adobe Acrobat, Java Beans, SNMP, Java, Eclipse, SQL.

Duration: Feb 2007 – Dec 2007

Contribution: Actively involved in

  • AS-IS analysis
  • Preparing Technical Specifications, To-Be documents
  • Fitment and Gap Analysis.
  • Coded a User module in Import/Export tool which is responsible to extract the user information (userId, userGroup, etc) from the database (Firebird),
  • Write the extracted information to the CSV file.
  • Import the information back to the database.
  • Verification of various information while writing to the CSV file (Export functionality), such as if the user is the administrator, whose details will not be exported.
  • Verifying various conditions while importing (Import functionality) the information to the database: format for the file, empty or redundant data, etc.

Project 11 : UI customization for Extended Warranty.
Client : Confidential,Finland
Role : Involved in the design and development of customization to handle Clients
Extended warranty functionality
Environment & Tools: Oracle, Java, JSP, Servlets, JDeveloper, SQL, Pl/SQL.
Duration: Sep 2004 – Feb 2005
Contribution

  • Extensively used TOAD for database access and PL/SQL Development and sql tuning.
  • Created a custom trigger on the shipping tables, which would dump the data into custom tables the moment an order bearing items and warranties is ship confirmed.
  • This trigger would populate the data into 2 custom tables one with item information and another with warranty item information along with the serial number information in case of serialized parts.
  • Built the UI (user interface) using JSP which enables users to search and assign warranties for their orders.

Project 12 : Implementation project in OAF, Oracle Configurator 11.5.9 modules.
Client : Confidential,USA
Role : As a developer, actively involved in the Design, Implementation, Testing (UT, ST, and CT) using Oracle Application Framework.
Environment & Tools: Oracle, Java, JDeveloper, SQL, Pl/SQL, CDL, OAF.

Duration: Sep 2003 – Aug 2004

Contribution

    • Developed use cases
    • Involved in MVC Architecture development.
    • Developed UI using OAF.
    • Developed Configurator rules (Design charts, Explicit Compatibility rules, numeric rules and logical rules)
    • Developed Complex advanced expressions to validate user selections.
    • Exposed the valid data to OAF pages using java objects.
    • Written Test cases and test scripts
    • Involved in UT.
    • Involved in issue resolving pre/post go-live.

Hire Now