Post Job Free
Sign in

Project Oracle

Location:
Pleasanton, CA, 94588
Salary:
$110000
Posted:
August 26, 2013

Contact this candidate

Resume:

Oracle Fusion Middleware

Summary

• Business Oriented Professional with 6 years dedicated to full life cycle IT development,

expertise includes ADF 11g, WebCenter portal, Oracle UCM, SOA Suite (10g,11g), ODI

Analyst, PL/SQL Developer.

• Oracle certified SOA 11g professional, cleared Oracle SOA Foundation Certification (1Z0 451)

• Strong experience in analysis, design, development and deploying business solutions using

Oracle Technologies.

• Extensively involved in all the phases of SDLC (Software Development Life Cycle).

• Proficient in Object oriented analysis, design, development and integration of complex

Enterprise and Web based applications like Intranet/Internet.

• Implemented multiple projects on BPEL SOA Suite using Jdeveloper 11g IDE.

• Implemented multiple projects using ADF (Application Development Framework) for End to

End solutions using WebCenter portal Document Service Task flows, ADF BC – EO, VO, App

Module, Web Services, Task flows, Java using JDeveloper 11g and JDeveloper 10g.

• Experience in integration of Oracle WebCenter portal, Oracle UCM, Oracle IBR and BPEL.

• Experience in installation of WebCenter portal, Weblogic server, UCM, Custom managed servers

for WebCenter PS5 and PS6.

• Experience in administration of Weblogic 10.3 Web Server.

• Experience in installing, configuring and configuration of SVN and Hudson.

• Extensively used ODI (Oracle Data Integrator) to extract data from different sources using Oracle

Data Integrator tools Topology Manager, Designer and Operator.

• Extensive experience in Oracle Back end (server side) PL/SQL Development i.e. Packages,

Stored procedures, Functions & Joins using SQL Developer as development tools.

• Quick learning and good grasping power, strong analytical abilities.

• Very good administration skills, organizational and interpersonal competencies along with

detail oriented and problem solving skills in the technology arena.

• Experience in using Agile methodologies in Software Development life cycle.

• Effective interaction skills, customer interaction, onsite offshore project coordination skills.

• Ability to work individually as well as in a team with excellent problem solving and debugging

capabilities. Self motivated and committed resource.

Certifications

• Oracle SOA Foundation Certification (1Z0 451)

Education

1

Oracle Fusion Middleware

• Bachelor of Engineering in Electronics & Communication, VTU University, Bangalore, India 2003

2007

Technical Skills

ADF(Oracle Application Development Framework) 11g,

Frameworks/Web

WebCenter 11g

Applications

Oracle Fusion Middleware 11g, Oracle SOA Suite 11g, and

Middleware

10.1.3.x, ODI (Oracle Data Integrator) 10g and 11g

Databases Oracle 10g, MySQL

Web Service SOAP, WSDL, XSD, XML

Technologies

Java, J2EE, SQL

Programming

Languages

Web/Application

Weblogic 10x.Oracle Applications Server

Servers

Platforms Windows NT/2000/XP/7, Unix.

JDeveloper 11g, Jdeveloper 10g, SQL Developer, SVN, Harvest,

IDE/Tools

Eclipse

Ant scripting

Scripting Languages

Professional Experience

2

Oracle Fusion Middleware

Accenture, US

Client : Ross Stores, CA, USA (Jun 2013 Current)

Role : WebCenter Admin

Project : WebCenter PS6 upgrade

Project Description

A Ross AM team is responsible to upgrade the current PS5 WebCenter environment to WebCenter PS6.

As a part of this upgrade, team is also responsible for

1. Upgrade and setup of Weblogic, WebCenter Portal, Spaces, IBR, UCM, WebCenter Custom

managed servers

2. Upgrading the existing WebCenter spaces application to PS6 and its customizations

3. Upgrading the existing WebCenter custom portal applications

Responsibilities

• Install Weblogic, WebCenter Portal, Spaces, IBR, UCM, WebCenter Custom managed servers

and its domain setup

• Upgrading the existing WebCenter spaces application to PS6

• Customize WebCenter Spaces Application according to Ross specific needs

• Upgrading the existing WebCenter custom portal applications from PS5 to PS6

Accenture, US

Client : Ross Stores, CA, USA (Apr 2013 June 2013)

Role : Tech Lead WebCenter/SOA Architect

Project : DI Sample Tracking

Project Description

A Ross PD is responsible for all product development with overseas vendors for their specific Product

Areas. Each PD (currently there are 8 total) works with between 3 12+ Product Areas. Within each

Product Area, multiple Vendors and Agents are helping to source products. In one season (there are

typically 2 per year), the PD could have upward of 300+ physical Samples that need to be tracked and

approved. However, all products must be photo approved which means there are another 500+ Samples

that need to be tracked to approval. The narrative below explains the details for the Sample request and

tracking process for pre production sampling which is a majority of the current Sampling completed today

at Ross DI.

The typical buying to sampling process begins with a Buy Trip where Ross goes overseas and selects

products we want to buy. In order for Vendors to ship our imports, all products must be photo approved in

Pre Production form before we allow Vendors to produce the items and ship them to Ross Stores. In

some cases, Ross requests a physical Sample in addition to a photo of the Sample.

• The Solution should provide DI Business with a standard workflow to request, track and manage

the Sample Requests, Deliveries & Evaluations with Agents/Vendors.

3

Oracle Fusion Middleware

• The Solution should facilitate communication and entry of key information for Sampling between

Ross, Agents, & Suppliers including key sample, product meta data & milestone dates.

• The solution should allow for the rejection of a Sample by Ross or the Agent.

• As sampling is an iterative process, the Solution should provide for multiple Sample

Rounds(requesting/evaluating a sample) for a Sample Request.

• The Solution should allow for Ross to cancel a Sample Request at any time.

• The solution should conclude the sampling process when a Sample is approved by Ross.

• The solution should allow for the use of images to convey information about the product/sample.

• The solution should allow users to update Status based on their role.

• The solution should allow users to view & edit Sample Request Data tailored by their user role &

permissions.

• The solution should provide an audit trail for each Sample Request

• The solution should allow for Agent, Supplier, and Sample Analysis

• Administrators should be able to create, update and delete users, and assign appropriate roles.

Responsibilities

• Providing overall Design and Architecture for the Business Requirements.

• Lead in Design & Development of Oracle WebCenter, UCM and SOA Applications

• Application Security Implementation and UCM Security Implementation using ACL security

• Implementation of DB operations using ADF BC and all the Transaction Management is handled

by BPEL calling ADF BC Web Service methods

• Integration of BPEL – UCM by calling UCM getFile WebService in order to get file from UCM and

send it as an attachment in Email

• WebCenter portal application – UCM integration by using various RIDC service methods

• Implementing various WebCenter portal Document Service task flows

• Implementation of BPEL 11g correlation process

• Installed/Configured WebCenter and SOA SUITE 11g in Development Environment.

• Installed/Configured Weblogic Server 11g in Development and Testing environment.

• Developed BPEL Composite Services using DB Adapters, Web Service Adapters, Email

Adapters and different Partner Links.

• Built and Deployed the Configuration Plans, SAR files (SOA Applications) using the EM

Console.

• Interacting with offshore team on various technical issues, knowledge transfers, design

discussions

Technology: WebCenter Portal, RIDC, UCM, BPEL, Java/J2EE, Oracle PL/SQL, WSDL

App Servers: Weblogic Server 10.3, SOA Server (Integrated)

Operating System: Windows, Unix

Tools & IDE: SVN, JDeveloper, PL/SQL Developer

Databases: Oracle 11g.

4

Oracle Fusion Middleware

Accenture, US

Client : Ross Stores, CA, USA (Nov 2012 Apr 2013)

Role : ADF Tech Lead

Project : Stores Data Management

Project Description

SDM is Stores Data Management user applications targeted at implementing a system to automate the

current manual processes of managing the Store information in excel documents. The primary business

functions for the Ross SDM application will be:

• Create and Manage the Store and Department hours

• Create and Manage the Store directory information

• Create and Manage the Departments, Attributes and Groups

• Create and Manage the Store Alignment Information

• CSV upload functionality for Attributes

• Generation of excel reports for various types data

Responsibilities

• Providing overall Design and Architecture for the Business Requirements.

• Lead in Design & Development of Oracle ADF

• Creating Data Sources, JNDI connections on Weblogic server

• Presenting the Demo of the application within various teams

• Interacting with offshore team on various technical issues, knowledge transfers, design

discussions

• Production support for the issues and advancements in the application delivered.

• Created Weblogic scripts for server monitoring, send notification emails in case servers down.

Technology: WebCenter Portal, RIDC, UCM, BPEL, Java/J2EE, Oracle PL/SQL, WSDL

App Servers: Weblogic Server 10.3, SOA Server (Integrated)

Operating System: Windows, Unix

Tools & IDE: SVN, JDeveloper, PL/SQL Developer

Databases: Oracle 11g.

Accenture, US

Client : Ross Stores, CA, USA (Feb 2012 Nov 2012)

Role : Tech Lead WebCenter/SOA Architect

Project : Vendor Indemnification Agreement

Project Description

5

Oracle Fusion Middleware

Ross Stores is currently undertaking a project known as the On Line Vendor Indemnification E Signature

project targeted at implementing a system to automate the current manual processes involved in obtaining

signatures from suppliers on vendor indemnification agreements. The purpose this document is to

provide the detailed technical design specifications for the future state process of the Ross On Line

Vendor Indemnification Agreement Electronic Signature process. The primary business functions for the

Ross Vendor Indemnification E Signature application will be

• New Vendor Indemnification Agreement Will provide the ability for Ross internal users to create

and manage a new Vendor Indemnification Agreement in the system and trigger the start of the process.

• Electronic Signature – Will provide the ability to attain an electronic signature on a vendor

indemnification agreement from Ross suppliers which will signify the suppliers binding agreement of the

terms of the vendor agreement.

• Vendor Inquiry – Will provide the ability for Ross internal users to inquire on the status of a Vendor

Indemnification Agreement with a supplier

• Template Management – Will provide the ability for Ross internal legal users to update the Vendor

Indemnification Agreement template and allow Ross internal A/P users to download the latest version of

the Vendor Indemnification Agreement template.

• Configuration – Will provide the ability for Ross internal users to manage and update configurable

properties of the application.

Responsibilities

• Providing overall Design and Architecture for the Business Requirements.

• Lead in Design & Development of Oracle WebCenter, UCM and SOA Applications

• Application Security Implementation and UCM Security Implementation using ACL security

• Implementation of Electronic Signature with custom fields in UCM

• Configuration of PDF Watermark in UCM and configuration for converting word documents to

PDF version in UCM and IBR

• Implementation of DB operations using ADF BC and all the Transaction Management is handled

by BPEL calling ADF BC Web Service methods

• Integration of BPEL – UCM by calling UCM getFile WebService in order to get file from UCM and

send it as an attachment in Email

• WebCenter portal application – UCM integration by using various RIDC service methods

• Implementing various WebCenter portal Document Service task flows

• Customizing the Document Service task flows

• Implementation of BPEL 11g correlation process

• Installed/Configured WebCenter and SOA SUITE 11g in Development Environment.

• Installed/Configured Weblogic Server 11g in Development and Testing environment.

• Developed BPEL Composite Services using DB Adapters, Web Service Adapters, Email

Adapters and different Partner Links.

• Designed and Developed WSDL’s and XSD’s, XSLT Transformations for the Message formats.

• Built and Deployed the Configuration Plans, SAR files (SOA Applications) using the EM

Console.

6

Oracle Fusion Middleware

• Interacting with offshore team on various technical issues, knowledge transfers, design

discussions

• Production support for the issues and advancements in the application delivered.

• Created Weblogic scripts for server monitoring, send notification emails in case servers down.

Technology: WebCenter Portal, RIDC, UCM, BPEL, Java/J2EE, Oracle PL/SQL, WSDL

App Servers: Weblogic Server 10.3, SOA Server (Integrated)

Operating System: Windows, Unix

Tools & IDE: SVN, JDeveloper, PL/SQL Developer

Databases: Oracle 11g.

Accenture, India

Client : Ross Stores, CA, USA (Dec 2011 Feb 2012)

Role : Analyst ADF Developer

Project : Capital Reporting

Project Description

The purpose of this project is to develop a GUI for CSV File Upload Capability for Budget, CER Master

Log, Forecast, New Store Alignment and ROI Status data for Capital Spend projects.

Responsibilities

• Development and Build the ADF application, deploying on Weblogic server

• Deploying ADF applications as ADF Library Jar files and using them into different ADF projects to

introduce reusability.

• Creating Data Sources, JNDI connections on Weblogic server

• Presenting the Demo of the application within various teams.

Technology: Oracle ADF 11g, Java

Scripting tools: Ant

App Servers: Weblogic Server 10.3

Operating System: Windows/Unix

Tools & IDE: JDeveloper 11g, SVN, SQL Developer

Databases: Oracle 10g and Netezza database

Client : Ross Stores, USA (July 2011 Nov 2011)

Role : ADF Analyst Developer

Project : APX Allocation Management

7

Oracle Fusion Middleware

Project Description

APX is a development of a tool which will provide a means for the user to easily input and manage

allocation criteria exceptions. This utility is referred to as the Allocation Parameter Execution tool (APX).

This document concentrates on two functions within the APX tool, the Need Calc Configuration (NCC)

function and the Worklist (WL) function. Data values are manually entered or systematically uploaded for

key pre defined elements of each function by product/location, facilitating the management of exceptions

within a global JDA Allocation (ACE) Need variable.

Maintaining data values utilized by an ACE Need variable in a separate, user friendly tool streamlines the

maintenance process. This process previously entailed Administrators (SWAT) directly inputting the data

values by location into the global Need variables in ACE using spreadsheets e mailed to them by the

Allocators and Analysts.

Responsibilities

• Development and Build of the existing APX ADF application for Release 3 defects, deploying on

Weblogic server.

• Deploying ADF applications as ADF shared Library files and using them into different ADF

projects to introduce reusability.

• Creating Data Sources, JNDI connections on Weblogic server

• Presenting the Demo of the application within various teams

Technology: ADF 11g

Operating System: Windows/Unix

Databases: Oracle 10g

Tools & IDE: Jdeveloper 11g, Oracle SQL Developer

Client : Ross Stores, USA (Dec 2010 June 2011)

Role : SOA 11g Analyst Developer, Offshore Team (India)

Project : Allocation Upgrade

Project Description

As part of the SOA Allocation Upgrade project, existing MAS interfaces are cloned to ACE and New

interfaces are built for Allocation Upgrade using BPEL and ODI. Both the “old” and “new” instances of the

Merchandise Allocation System will be operational for an interim period of 12 weeks prior the

decommissioning of the “old” instance (MAS). Interfaces sending data to and from the “old” instance will

be cloned or modified to point to the “new” instance (ACE) to support parallel operation of the two

instances.

All interfaces (even clones) will require at least a minor modification. This document will specify the exact

components to be modified and the new values for these components. The main categories will include:

8

Oracle Fusion Middleware

• Interface component name updates

• Integration related application process/procedure updates

• CA scheduling component updates

• Interface functional updates (if applicable)

• Additional considerations.

New interfaces include:

• IDM JPMC using BPEL and B2B

• CAQ Data Merge using ODI 11g

• Markdowns using ODI 11g

• Shrink Calculation using ODI 11g

Responsibilities

• Create Functional design and Technical design documents.

• Develop the interfaces between the systems using BPEL, ODI

• Develop Trading Partners using B2B

• Leading a 4 member team

• Deploy and maintain changes to the environment

• Increasing the team's performance by taking training on the latest products and updates from Oracle

• Code review and support for various modules

Technology : Oracle Fusion Middleware

Operating System: Windows/Unix

Application Servers: OC4J and Weblogic servers

Databases: Oracle 10g

Tools & IDE: ODI Designer tools, Oracle J Developer 10g

Client : Ross Stores, CA, USA (June 2010 – Nov 2010)

Role : SOA Developer

Project : IDM4RDM

Project Description

Ross Stores, Inc., a Fortune 500 and NASDAQ 100 (ROST) company headquartered in Pleasanton,

California, is the USA's second largest off price retailer with fiscal 2006 revenues of $5.6 billion. The

major deliverables of the IDM4RDM project are Reconciliation, Attestation and Reports. This project will

utilize SOA to deliver user account information into IdM Staging tables. The IdM reconciliation processes

will extract the user account information from the database views using Oracle Identity Management

Generic Technology Connector.

9

Oracle Fusion Middleware

IdM will provide reports which can be used to view user exceptions those are not present in SQL system

but still active in Oracle system.

IdM will also provide the business Attestation capabilities for Ross Store’s users. The identity system,

Oracle Identity Manager, can allow the IdM administrator to manage and generate attestation tasks.

Responsibilities

• Create Functional design and Technical design documents.

• Develop the interfaces between the systems with the help of ODI.

• Creation of GTC’s and the rules for the same using IDM

• Deploy and maintain changes to the environment.

• Handled all the phases of testing (Unit testing, Integration testing, UAT and Performance testing)

involving Reconciliation, Attestation etc.,

• Code review and support for various modules

Technologies: Oracle Data Integrator, Oracle Identity Management

Application Servers: Oracle Application Server 10.1.3.5

Databases: Oracle 10g

Tools & IDE: ODI tool

Client : Ross Stores, USA. (Dec 2009 June 2010)

Role : SOA Developer, India

Project : Remediation

Description

Remediation is the main part of ROSS Project. This will change the existing legacy connections between

the systems to SOA interfaces. Ross is currently implementing Retek Demand Forecasting (RDF) module.

By using RDF, Ross will improve its planning capabilities in three major areas, viz., pre season planning,

in season trending, and new store planning.

Responsibilities

• Create Functional design and Technical design documents.

• Develop the interfaces between the systems with the help of BPEL, ODI.

• Deploy and maintain changes to the environment.

• Increasing the team's performance by taking training on the latest products and updates from

Oracle.

• Code review and support for various modules.

Technologies: Oracle Data Integrator10g, BPEL

Application Servers : Oracle Application Server10.1.3.5

10

Oracle Fusion Middleware

Database: Oracle 10g

Operating System: Windows XP

Tools: ODI tool, JDeveloper 10g

Mahindra Satyam, India

Client : FUJITSU, Japan (Jan 2009 Nov 2009)

Role : Software Developer

Project : FMCS

Project Description

The module was a part of Fujitsu FMCS Project which deals with Item Dictionary. Fujitsu needs to develop

a sub system which will store the item, item details and its mapping with term name. This sub system will

expose interface so that other existing external sub systems can access item dictionary data.

Responsibilities

• Implemented functionalities using features provided by Struts MVC framework.

• Developing the user interfaces using JSP and JavaScript.

• Extensively involved in Client interaction.

• Worked on the Unit testing and Integration testing of the project.

• Code review and support for various modules.

Technologies: Java J2EE, Struts

Database: Oracle 10g, MS SQL

Operating System : Windows XP

Tools: Eclipse 3.3, JTrac Defect tracking tool

Mahindra Satyam, India

Client : FIDELITY, India (Oct 2008 Dec 2008)

Role : Developer

Project : IFNW – India Funds Network

Project Description

Fidelity India Limited, India Business is setting up a domestic Funds Network proposition, this IFNW

Project is the online portal for this business which provides the buying and selling of the Mutual

Funds(Fidelity MF/ other MF),by different users(IFA/Simple User/Direct Client). This whole application is

11

Oracle Fusion Middleware

built on JIL Framework (Struts/Spring/Hibernate) also we had the 3rd party integration with Talisma, IT

site, MFI, CPS through web services.

Responsibilities

• Implementation of Non Financial Transaction & Secure Messaging.

• Analysis, Development and testing of the assigned modules.

• Involved in Implementation & Validation of Contact Details in Customer Account Opening.

• Developing the UI and pojos using struts.

• As part of the Performance Analysis team, I was involved in Performance Testing.

• Logging & Exception Handling was improved for analysis.

Technologies: Java J2EE, Struts

Database: MySQL

Operating System : Windows XP

Tools: Eclipse

Mahindra Satyam, India

Client : Mahindra Satyam, India (Feb 2008 Sept 2008).

Role : Developer

Project : Enterprise Banking

Description

The Enterprise Banking is an internal Project which deals with provisioning the new users from

PeopleSoft in IDM. ODI transfers the new created users in PeopleSoft to the Oracle IDM database table.

The users created in Oracle IDM database table are provisioned in IDM by running Attestation task in

IDM. The project also includes Loss Prevention interfaces whose data is transferred to Netezza database.

Responsibilities

• Create Functional design and Technical design documents.

• Develop the interfaces between the systems with the help of ODI.

• Deploy and maintain changes to the environment.

• Increasing the team's performance by taking training on the latest products and updates from Oracle.

• Code review and support for various modules.

• Running the IDM Attestation task

Technologies: SOA

Database: Oracle 10g

Operating System: Windows XP

12

Oracle Fusion Middleware

Trainings

• Completed Entry level training program from Satyam computers

• Attended ADF training

• Attended Team building workshop

• Summits to enhance knowledge on new technologies.

13



Contact this candidate