Post Job Free

Resume

Sign in

Oracle Sales

Location:
Fremont, CA, 94536
Posted:
January 24, 2013

Contact this candidate

Resume:

[pic]

SUMMARY

. **+ years experience in Administration / Software Development / Team

Leader / Architect / Project Management.

. Excellent Enterprise Architecture Design and Implementation in Core Java

and J2EE technologies like EJB, JDBC, Servlets, Portlet, JSP, Struts,

Spring, Hibernate, AJAX (DOJO), XML, PL/SQL in Web application

development and content management using Oracle/Weblogic 10g Apps Server

Portal, Weblogic Portal, Oracle Service Bus(OSB), Oracle Fusion

Middleware Product [OSB, Web Center 11g PS3/PS5) and Oracle UCM 11g].

. 8+ years of strong experience with Oracle Identity Management, Oracle

Portal 10g 10.1.4, Oracle Service Bus(OSB), Oracle Webcenter 11g,

Collaboration Suite, WSDL, Administration, architect, OID, SSO, OAM,

develop Java(PDK) and PL/SQL portlets, WSRP/168 portlet, JSR 268

portlets, Data Control, WSRP producer, ADF TaskFlow,, ADF Declarative

Component, Oracle Collaboration Suite, ADF skin, Oracle BI etc.

. Excellent Experience with Oracle Database 10g SQL and PL/SQL tuning, Java

stored procedure and packages.

. Worked on different Java design patterns like DAO, Session Facade,

Service Locator, Business Delegate, View Controller, Application

Controller etc. for implementation of Java/J2EE code.

. Developed applications for various industries including Insurance,

Telecommunication, Fund Management, Medical, Bottling plant, Engineering,

and Marketing.

. Implemented medium level ERP solution (Sales, Purchase, Manufacturing,

Accounts, Insurance and Inventory).

EDUCATION

. Master of Computer Applications (M.C.A)

. Completed Oracle SOA training course in Oracle University (Redwood

Shores, CA)

. Java and Internet Application from EI NET-3L (IIT Kharagpur), India

. Diploma in Computer Office management.

. Oracle client server Application from SQL Star International Ltd. India

. Brain Bench Certification in Java 2 Fundamentals and Java 2 Platform

Enterprise Edition (J2EE) 1.4. Web site http://www.brainbench.com/

(Transcript ID#: 6303759)

TECHNICAL SKILLS

Languages Java, C, C++ and PL/SQL.

J2EE Technologies Servlets, EJB, Struts, spring, Hibernate, AJAX.

Front end tools JDeveloper 10g, Eclipse 3.0, Net Beans 5.0 and WebSphere

Application Studio 5.0, Visual Studio 6

Tools KAPOW Migration Tool, Rational Rose, Enterprise Architect

Web Technologies HTML, XML & DHTML, CSS

Scripting JavaScript

Operating Systems Linux, Unix, Windows systems.

Web / Application Servers Oracle 10g Application Server Portal, Oracle

Web Center 11g SP3/SP5

RDBMS Oracle 9.x, Oracle 10g/11g and SQL Server 2000

Fusion Middleware Oracle Webcenter 11g(SP3/SP5) and Content (UCM)

Mobile Framework JQTouch mobile framework, Apple iOS SDK 4

PROFESSIONAL EXPERIENCE

Technical Architect/ Project manager/ Developer

Client: NetApp, Sunnyvale, CA

Project: NetApp Support Site (Aug, 10 - current)

Support the NetApp business to create/capture, management, deliver, and

retire electronic information accurately and consistently via modern

capabilities inherent in an Enterprise Content Management and Portal

solution suite while servicing the immediate content management needs of

the NOW NextGen project to revamp the customer and partner support

experience(http://support.netapp.com)

. Lead development team.

. Architect and design the system and also created technical design

document.

. Installation and configuration plan for Oracle Webcenter 11g (PS3/PS5)

and UCM.

. Implement UCM web services and consume from the webcenter portal

framework.

. Implement portal site with JSR 168/WSRP portlet, TASK FLOW, ADF faces

component, ADF Declarative Component, resource catalog, composer

framework component and portal ADF security (Integrate with OAM).

. Integrate portal resources with Oracle content management system(UCM).

. Integrate with external component like BI, SAP, Bugs Online, Audit

Management Tools etc. legacy services.

. Expose specific components to the Mobile users (Upload application

into Netapp Mobile Application Store).

. Content Migration experience with KAPOW Robots.

Environment:

. Server-Side:

o Operating Systems: Windows2000 Server/Service Pack 4.

o Application/Web Server: Oracle Portal 10.1.4, Oracle Webcenter

11g (PS2/PS3), Oracle UCM 11g

o JQTouch mobile framework, iOS SDK 4

o Java Environment: jdk1.6

IDE : JDeveloper 11g, TODE 9.x, Rational Tools.

. Database Server:

o Oracle Version: Oracle 11g.

. UML tool: Microsoft Visio.

Client: Delta Dental, San Francisco, CA

Project: B2B Claim processing system[Real time and Batch] (Sept, 09 - Aug

10)

I was involved on the following activities

. Design and architect the Oracle Webcenter 11g(PS2) and UCM 11g

component.

. Implement portal site with JSR 168/WSRP portlet, TASK FLOW, ADF faces

component, resource catalog, composer framework component.

. Developed Database components like index, procedure, packages etc.

Environment:

. Client-Side:

o Operating Systems: Windows 98/Pro/XP/Windows 7/Solaris/Linux

o Browser: Internet Explorer 4.0+, Netscape 5+.

. Server-Side:

o Operating Systems: Windows2000 Server/Service Pack 4.

o Application/Web Server: Oracle Portal 10.1.4, Oracle Webcenter

11g(SP2) and UCM 11g

o Java Environment: jdk1.5

IDE : JDeveloper 11g.

. Database Server:

o Operating Systems: Windows2000 and 2003 Server, Linux/Unix

o Oracle Version: Oracle 10g.

Client: RBS WorldPay, Atlanta, GA

Project: MOSS environment to Oracle Portal Integration (Sept, 08 - June,

09)

My.RBSWorldPay.US needs to migrate from current MOSS Environment to Oracle

Web Portal. It will provide OID user maintenance, upload sales documents,

and integrate current sales reports into Oracle Portal and Oracle SOA Suit.

. Lead portal developer and architect.

. Requirement gathering from the HR and Sales departments.

. Installation and configure and maintenance services of Oracle

Application Server and Fusion Middleware Product (SOA suit).

. Create technical design diagram (sequence diagram, Class diagrams and

Activity diagrams) with Microsoft Visio for OID user maintenance,

upload sales documents etc.

. Data modeling for user maintenance upload sales documents module.

. Integrate Oracle PeopleSoft data into Oracle Portal and also integrate

dataset from HR and Sales with the help of JSR 168/WSRP java and

PL/SQL portlet and BPEL Process [SOA Suit (Fusion Middleware

product)].

. Lead team for PL/SQL development.

. Configure Oracle Internet Directory (OID) for simplifying user

administration and create/edit/delete users and assign security groups

to the particular users with java stored procedure..

. Developed user attribute, user security, document upload, category and

secondary category entry screen with the help of PDK Struts and AJAX.

. Developed PL/SQL portlet, JSR 168/WSRP and dynamic page for Activate

and training for PCI Compliance.

. Omni Portlets for some simple web pages.

. Registered web, database and WSRP producer.

. Customize login and logout page.

. Testing and deployment in the production server.

Environment:

. Client-Side:

o Operating Systems: Windows 98/Pro/XP

o Browser: Internet Explorer 4.0+, Netscape 5+.

. Server-Side:

o Operating Systems: Windows2000 Server/Service Pack 4.

o Application/Web Server: Oracle Portal 10.1.4, Oracle Fusion

Middleware Product (SOA Suite 10.1.3.1.0), Oracle Webcenter 10g.

o Java Environment: jdk1.5

IDE : JDeveloper 10g, TODE 8.6, Rational Tools.

. Database Server:

o Operating Systems: Windows2000 and 2003 Server, Linux/Unix

o Oracle Version: Oracle 10g.

. UML tool: Microsoft Visio.

Client: County of Riverside, Riverside, CA

Project: Customize Intranet Website Development (April 2008 - Aug 2008).

County of Riverside intends to build a customer friendly website that

provides requisite information about Riverside County services, news, etc.

using Oracle Portal implementation. For this purpose following activities

have been completed:

. Lead portal developer with 5 develops.

. Installation and configure and maintenance services of Oracle

Application Server and Fusion Middleware Product (SOA suit).

. Requirement gathering from Accounts, HR and invoicing systems.

. Understanding the business process of Riverside County (Tax,

Utilities, Construction etc. ) and developed Fusion Middleware BPEL

process and integrate with the Oracle Portal system.

. Lead team for PL/SQL development.

. Create portal template, style etc. for the user interfaces (Living

here, Working here, Government, Emergencies etc.), these templates and

styles are using all the pages.

. Configure Oracle Internet Directory (OID) for simplifying user

administration and create a registration form to add, edit and delete

users using PDK portlet, now more than 3000 people using this

application.

. Developed struts PDK java, PL/SQL portlet and AJAX for data entry

screen for different applications (Department, News, online services

etc.).

. Integrate data from the different systems from Accounts, HR and

invoicing with the help JSR 168/ WSRP.

. Omni Portlets for some simple web pages.

. Registered web, database and WSRP producer.

. Export/Import transport set.

. Customize login and logout pages.

. Configure Ultra Search module for the site.

. Testing and implementation in the production server.

Environment:

. Client-Side:

o Operating Systems: Windows 98/Pro/XP

o Browser: Internet Explorer 4.0+, Netscape 5+.

. Server-Side:

o Operating Systems: Windows2000 Server/Service Pack 4.

o Application/Web Server: Oracle 10g Application Server Portal

10.1.4.1, Fusion Middleware [Oracle SOA Suite 10.1.3.1.0].

o Java Environment: jdk1.5

IDE : JDeveloper 10g, TODE 8.6

. Database Server:

o Operating Systems: Windows2000 and 2003 Server, Linux/Unix

o Oracle Version: Oracle 10g.

Client: Guitar Center, Westlake Village, CA

Project: Oracle Application Server and Portal Messaging Project (Sept 2007

- Mar 2008).

Guitar Center is integrating the Xstore POS system with their legacy back

office inventory management system. The primary objective of this

integration is to synchronize inventory balances between the two systems in

real-time to ensure associates see accurate information on either system.

The primary method for maintaining inventory accuracy between the systems

will be a JMS messaging implementation. For this purpose, following

activities have been completed:

. Lead developer with 8 developers.

. Understanding the total business process from Invoicing, accounting

systems.

. Multiple stores can consume messages JMS Messages. Make the necessary

changes to configuration files, deployment descriptors and test

harness.

. Deploy MDB's on multiple Xstore servers and configure them to listen

to message Xcenter Application server.

. Developed PL/SQL portlet, ESB, BPEL(Fusion Middleware) and JSP

168/WSRP java portlet for consume message and store into the database

and also integrate with invoicing and accounting system.

. Use database and Hibernate (DB framework) to persisted JMS messages

(until they are consumed). Substitute File based persistence for

Queues with Database persistence.

. Registered web and database providers.

. Design portal template, style for implement messages in to the web

pages.

. Use OC4J JDBC data source and integrate code to consume XML messages

On Xstore side.

. Use Entity Beans (EJB) for persistence.

. Use Log4J in the entire code base using framework.

Environment:

. Oracle Fusion Middleware (SOA Suite 10.1.3.1.0)

. Operating System: Linux

. Java Environment: jdk1.5.0_12

. IDE: JDeveloper 10g (10.1.3)

Database Server:

. Operating System: Linux

. Oracle Version: Oracle 10g

Client: Dunkin Brands, Canton, MA

Project: Customize Intranet Website Development (www.dunkinbrands.com) (

Mar 07 - Aug 07)

Oracle Portal is a Web Content Management System which is used at intranet

website for the creation, storage and management of DUNKIN intranet pages.

For this purpose following activities have been completed:

. Lead developer with 4 developers.

. Requirement gathering and understanding the business process from the

management team.

. Design system specification document for the intranet site that

include page group, page, portal template, style etc.

. Create technical design diagram (sequence diagram, Class diagrams and

Activity diagrams) with Microsoft Visio for their internet site, which

includes different department information, news, products etc. in the

company.

. Data modeling for their internet site, that includes department info,

news, products using the Microsoft Visio.

. Developed PDK portlets and PL/SQL portlet for showing news,

departments, product information into the intranet site.

. Registered web and database providers.

. Integration between E Business and Discoverer within Oracle Portal.

. Design portal template, style for home page, Department page and

product page.

. Security implemented in Portal group and users (i.e. HR department can

view only department pages.)

. Omni Portlets for some simple web pages.

. Customize login and logout pages.

. Configure Ultra Search module for the site.

. Testing and implementation in the production server.

Environment:

. Client Side:

o Operating Systems: Windows 98/Pro/XP

o Browser: Internet Explorer 4.0+, Netscape 5+

. Server Side:

o Operating Systems: Windows2000 Server/ Service Pack 4

o Application/Web Server: Oracle 10g Application Server Portal

10.1.4.1, Oracle Fusion Middleware (SOA Suite 10.1.3.1.0)

o Java Environment: jdk1.4.2_02

o IDE : JDeveloper 10g

. Database Server:

o Operating Systems: Windows2003 Server/Windows 2000 Server,

Linux, Unix

o Oracle Version: Oracle 10g

Client: YSI, Yellow Spring Ohio USA

Project: Customize Website Development (www.ysi.com) [ May 2006 - Feb 07 ]

YSI intends to build a customer friendly web site that provides requisite

information about their products to their customers. YSI also intends to

enable utilization of this web site for advancing marketing efforts. After

implementation of the site YSI's product sales increased four times. For

this purpose following activities have been completed:

. Lead developer with 5 developers.

. Requirement gathering and understanding the business process from the

higher management and sales department.

. Create portal template and style for user interfaces(Home,

Application, Support, Product Family, Product etc.) and create HTML

portlet for the page layout, Footer and Header interface.

. Data modeling for internet application with the help of Microsoft

Visio.

. Configure Oracle Internet Directory (OID) for simplifying user

administration and create a registration form to add, edit and delete

users using PDK portlet, now more than 40000 people using this

application.

. Developed struts PDK portlet for the content management, which

includes Product, Application, Support Product Family, News etc

all images also uploaded into the database.

. Developed JSP 168/WSRP portlet for integrate sales and invoicing

system into the oracle portal.

. Registered web and database providers.

. Properly implemented events and parameters for the page navigation.

. Customize login and logout pages.

. Omni Portlets for some simple web pages.

.

. Configure Ultra Search module for the site, that searching in Page,

Page groups, database and also the file system.

. Upgrade Oracle portal 10.1.2 to Oracle Portal 10.1.4.1

. Testing and implementation in the production server.

Environment:

. Client Side:

o Operating System Requirements: Windows 98/Pro/ XP

o Browser: Internet Explorer 4.0+/Netscape 5+

. Server Side:

o Operating System Requirements: Windows2000 Server/Service Pack

4.

o Application/Web Server: Oracle 10g Application Server Portal

10.1.4,

o Java Environment: jdk1.4.2_02

o IDE : JDeveloper 10g

. Database Server

o Operating System Requirements: Windows2003 Server/Windows 2000

Server/Linux/Unix.

Client: Glimcher, Columbus Ohio

Project: Customize Internal Website Development [ Jan 07 - Feb 07 ]

Glimcher is using this internal site for maintained the internal business

processes with the corporate office and different malls all over the USA.

They are flashing the latest news, management view, about the organization,

policies, reports etc. for the Glimcher people. Now Glimcher corporate

office and malls all over the USA properly synchronized with this site.

For this purpose following activities have been completed:

. Requirement gathering and understanding the business process from the

higher management.

. Create portal templates for user interfaces (Home, Product, location,

news etc.).

. Developed data entry screen with the help PL/SQL portlet for Product,

Locations, News etc. pages.

. Design Portal template for page showing up in the site (Home, Product,

location, news etc.).

. Oracle BI intergrades with Oracle Portal.

. Registered web and database providers.

. Properly implemented events and parameters for the page navigation.

. Configure Ultra search module.

. Testing and implementation in the production server.

Environment:

. Client Side:

o Operating Systems: Windows 98/Pro/XP

o Browser: Internet Explorer 4.0+, Netscape 5+

. Server Side:

o Operating Systems: Windows2000 Server/ Service Pack 4.

o Application/Web Server: Oracle 10g Application Server Portal

10.1.4.1.

o Java Environment: jdk1.4.2_02

o IDE : JDeveloper 10g

. Database Server:

o Operating Systems: Windows2003 Server/Windows 2000 Server,

Linux/Unix.

o Oracle Version: Oracle 10g.

Client : Inductis

Project : AutoModel [ March 2005 - April 2006 ]

AutoModel takes a customer file as input and develops customized customer

affinity models to create higher value marketing lists. Architecturally

there are three major application modules in the design of the AutoModel

Engine. The Web-interface module interacts with the user for inputting the

customer file along with the file format details. It also processes the

file and displays the file statistics such as the number of records

qualified for matching.

( Data Modeling.

( Match Controller system model. Match with the input customer file.

( Write store procedure for match system controller.

( Automodel conroller coding.

( Write store procedure for automodel.

( Use entity beans for EJB persistance.

( Testing and implementation.

Environment:

. Client Side:

o Operating Systems: Windows 98/Pro/XP

o Browser: Internet Explorer 4.0+, Netscape 5+

. Server Side:

o Operating Systems: Windows2000 Server/ Service Pack 4

o Application Server: Tomcat 5.0,Jboss 4.1.

o Java Environment: jdk1.4.2_02

o IDE : JDeveloper 10g

Connectiva Systems Ltd., Kolkata, India July' 04 - March 05

Senior Software Engineer

Project: ONEREViEW

ONEREViEW is a comprehensive RA tool designed for the telecommunications

industry. This solution includes a set of robust RA components that provide

functionality including data management, analysis, reporting etc that is

required to deliver full assurance functionality to telecom operators. It

has design time and run time components, allowing the user to specify the

problem at design time, schedule the runs and then have the results

published onto the file-system or Intranet in various formats as per the

users' need.

The functional components of ONEREViEW are:

. ETL Designer: Defines the extraction adapter, Configures the

transformation rules, and loads data to the selected database

. RAWorkshop: Prepares the data sources for analysis, defines the

actual matching criteria through dimensions and facts specification

. Launcher: Executes the Reconciliation

. Dataviewer: Provides view of the results, allows further drill downs,

saving of reports and setting alarms

. Issue Tracker: Creating and tracking issues

I was involved with:

( UML diagram with Rational XP.

( Data Modeling.

( Proceed to the Data viewer module to View your aggregate results and

do further drilldown.

( Matching between IN binary CDR data and Switch binary CDR data.

( Deploy the Portal framework for the user interface.

Environment:

. Client Side:

o Operating Systems: Windows2000 Pro/ Service Pack 4, Windows XP/

Service Pack 1

o Java Environment : jdk1.4.2_02, struts 1.2.5, JDO

. Server Side:

o Operating System Requirements : Windows2000 Server/ Service

Pack 4

o Application Server : WebLogic server 7, IBM WebSphere 5.1.

o IDE : IBM WebSphere Application Studio

o Java Environment : jdk1.4.2_02

o IDE : JDeveloper 10g, Eclipse

. Database Server:

o Operating System Requirements : Windows2000 Server/ Service Pack

4

o Oracle Version : Oracle 9.2.0.1

Celcius Technologies Ltd. (TCG Group Company), Kolkata, India Jun' 03 -

July 04

Software Engineer

Client: Iton LLC, USA

Project: Doc Assistance

The client Server application developing to Time Slot, Encounter of that

particular patient for a particular disease like neurology, gastro etc.

which has one to many relationship with Objects such as Databases,

Networks, Technologies, Storage etc. I was involved with:

. Designing database tables, creation of EJB component, stored

procedures, package for implementing the business logic, use JSP for

User Interface.

. Interacting with the Client Doctor's Team

Environment: JDK1.4, JDBC, JSP, EJB, Oracle 9, JBoss 4, Struts

Client: Iton, USA

Project: Jabber Chat Client

Instance Messaging service for one to many Buddies, Buddy List, Add &

Remove buddy, message alert, offline messages. I was involved in:

. Designing XML files,Using thread for communicating with one to many

buddies.

. Configuring Jabber Server 1.4.2 in Red Hat Linux 9.

Environment: C++, Jabber Server 1.4.2 in Red Hat Linux 7.3, Class Diagram

using UML Para diagram.

Client: Winstar, India

Project: Winstar Fund Management

This is a Web based Application for managing funds, investor transaction,

trade confirmation, Net assets. Create web based reports with Crystal

Report 9. I was involved in:

. Designing database tables, creation of VB component, stored

procedures, implementing the business logic, use ASP for the User

Interface.

. Interacting with the Winstar people.

Environment: VB6, ASP, SQL Server 2000, Crystal Report 9.

Client: Hutch, India

Project: SIM Card Recharging System

This is a Web based Application for recharging SIM cards. After recharging

of SIM Card, SMS with the balance will be sent to the mobile phone. I was

involved in:

. Implementaing with Java Servlet and JSP for the User Interface.

. Configuring iplanet Web Server.

Environment: Java Servlet, JSP, Oracle 8i, iPlanet Server

Cyber Craft, Kolkata, India Aug' 99 - Jun 03

Software Engineer

Client: Micro Electronics Ltd. Bangladesh

Project: Sales & Accounts Management System

This contains Sales, Purchase, Inventory, Payroll management System. It's a

client server based architecture, data transfer and consolidating data

within 8 branches all over Bangladesh. I was involved in:

. System analysis & Database design

. Designing and Developing class Modules.

. Created Store Procedure, Packages etc.

. Interacting with the Clients Technical Team.

Environment: VB.Net and Oracle 8i

Client: Royel Insurance Company, Bhutan

Project: Migrating Database

Migrating 10 Years of FoxPro Data into Oracle Database. Previous system

developed with FoxPro 2.5, then converted into oracle database, so need to

transfer all previous data into the new system. I was involved in:

. FoxPro database to Oracle Conversion.

. Developed Servlet to convert database.

Environment: JDK1.2, Servlet, Oracle 8i, FoxPro 2.5

Sumit Dey



Contact this candidate