Profile of RUDRAJIT DAS

Personal Information:

Date of Birth: 28th October 1982. Age: 28

Gender: Male. Education: B.Tech in IT.

Relevant IT Experience: 6 years 1month. Location: HYDERABAD.

Designation: Working as a US Consultant - Technology for Deloitte Consulting India Pvt. Ltd.

Permanent Address: Present Address:

43, Ananda Abasan, 1-11-183/A & B,

Fartabad, Amtala, Creative Homes, Flat: 202,

Garia Station Road. Shyamlal Building, Begumpet.

Kolkata: 700084. Hyderabad- 500016.

Home: +913*-******** (Kolkata)

Mobile: +91-801******* (Hyderabad) Office: +91-40-667*****.

Email: e8e6g7@r.postjobfree.com and e8e6g7@r.postjobfree.com.

Summary:

I am presently working as an US Consultant Technology for Deloitte Consulting India Pvt. Ltd. I am proficient in SOA, AIA, Oracle Application Framework (OAF), Application Development Framework (ADF), BPEL, Java, Java Swing, JSP, Servlet, PL/SQL, Oracle and Sybase. I am capable of learning new technologies and tools quickly. I like managing team-oriented projects and I enjoy it.

Employment History:

Company Name Position Held From Date To Date Period

Cogentech Management Consultants (P) Ltd, Kolkata Trainee Consultant Dec 2004 May 2005 5 Months

Conacent Consulting (P) Ltd, Kolkata. Junior Consultant June 2005 Mar 2006 10 Months

Oracle India Pvt. Ltd, Hyderabad. Software Engineer Mar 2006 June 2007 15

Months

Oracle India Pvt. Ltd, Hyderabad. Senior Application Engineer June 2007 May 2010 35

Months

Deloitte Consulting India Pvt. Ltd, Hyderabad US Consultant - Technology May 2010 Present 8 Months

Technical Skill Sets:

Index Language Experience in

months

1 Oracle Applications - Projects Suite 15

2 Oracle Applications – Functional Administrator 36

3 Oracle Applications – Functional Administration 36

4 CRM – Spread Table - jtf grid 36

5 CRM – Scheduling Chart / Gantt Chart 36

6 Oracle Applications – FND Module 36

7 Oracle Forms 6i 40

8 Oracle Applications – OA Framework ( OAF ) 59

9 Java 73

10 Java Script 73

11 Java Swing 73

12 Servlet 73

13 Java Server Pages ( JSP ) 73

14 HTML 73

15 XML 40

16 Oracle 8i, 9i and 10G 73

17 PL/SQL 73

18 Sybase 11.9.2 15

19 Microsoft Access 73

20 UNIX 73

21 Linux 73

22 MS-DOS and Windows 73

23 XML Publisher 20

24 Application Development Framework ( ADF ) 15

25 Service Oriented Architecture ( SOA ) 15

26 Application Integration Architecture ( AIA ) 11

27 BPEL 15

28 XLST 14

29 XLS FO 14

Trainings Attended:

Training Name Duration

in Days Provided By

Oracle Ebusiness Suite – Oracle Projects 14 Oracle India Pvt. Ltd

Oracle Project Management 14 Oracle India Pvt. Ltd

Oracle Projects- Costing table structure 7 Oracle India Pvt. Ltd

Analyzing Trace and Debug log files 2 Oracle India Pvt. Ltd

Advanced PL/SQL 10G 4 Oracle India Pvt. Ltd

Workflow configuration and debugging 4 Oracle India Pvt. Ltd

Oracle Forms 6i 4 Oracle India Pvt. Ltd

Advanced Java Programming 4 Oracle India Pvt. Ltd

AIA Training 3 Deloitte Consulting India Pvt. Ltd

Academic Qualification:

Degree School / Institute Percentage Session

B. Tech. In Information Technology (I.T) International Institute of Information Technology 73.59%

(Average) 2000-04

12th W.B.H.S.E. Board Andrews College 52.00 % 1999-2000

10th W.B.S.E. Board A.K Ghosh Memorial School 72.33% 1997-98

Trainings Provided:

Training Name Duration in days Company

Application Development Framework ADF 14 Deloitte Consulting India Pvt. Ltd.

Oracle Application Framework OAF 10 Deloitte Consulting India Pvt. Ltd.

Professional Projects:

1. SFDC Integration with BANN ERP for Bio-Rad (SOA):

Presently I am working on a fusion middleware integration project, where in I am creating SOA interfaces interconnecting Sales Force with BANN. The details of the component are as follows:

a)Process Work Orders from SFDC To Bann SOA implementation:

In this process I have created BPEL process which will be triggered by Scheduler or will be invoked by Custom application. The process will retrieve all the WO details from SFDC using SFDC API’s and will process WO’s one by one and will post it in the Bann ERP. After successful creation of BANN WO number the same will be updated in the SFDC tables, else error details will be mailed with WO number and transaction will be marked as error. And the audit files gets created for tracking purpose.

Coding languages used: BPEL, Java, PL/SQL, shell script.

Database: Oracle 11g.

Tools: JDeveloper 11.1.1.3.0.

Company: Deloitte Consulting India Pvt. Ltd.

Client: Bio-Rad.

Duration: Dec 2010- Present.

b) Process Parts Order SFDC to ERP SOA implementation:

In this process I have created the BPEL process which will invoked from scheduler in a timely manner to retrieve the Parts orders requested in Sales Force. Then the process will initiate the order creation process in BANN ERP and will update the SFDC back with the order numbers. And in case of any failure notifications are sent to admins

and the records are updated accordingly with error status.

2. R12 Implementation for ON SEMICONDUCTOR :

I have worked as an individual technical contributor (Tech lead Developer) for this

project. I have worked on the RICEW objects for this client. The RICEW components

developed by myself are as follows:

a) SOA outbound interface for iExpense to Bank:

I have created a SOA outbound process using Application Integration Architecture (AIA) 11g and BPEL 11g for iExpense module. A custom business event will be raised from APPS and OA Adapter will be listening to the event. Once received the BPEL process will be fetching data from different staging tables using DB Adapter and will be routing to different provider ABCS using EBS, which in turn will creating different bank formatted transaction file for different entities and will be either emailing the file to the bank or will be FTPing the file to the bank lock box server.

b) GL-JE Approval Work Flow:

I have extended this existing customized workflow from 11i to work in R12.

c) Expense Report Approval Workflow:

I have extended the existing Expense report workflow to satisfy customers need.

d) Printed PO Report:

I have converted an existing rdf report from 11i to BI Publisher report in R12 with related changes.

e) Inventory Item Search Application:

I have created a search application in OAF which will help customers to search inventory items with ease and will enable them to take the repot in xls format.

f) Form for maintaining Historical exchange rates for Assets of FA module:

I have created a Form which will enable users to maintain the historical exchange rates of the assets of FA module.

Coding languages used: AIA, BPEL, Java, PL/SQL, shell script.

Database: Oracle 11g.

Tools: JDeveloper 11.1.1.3.0.

Company: Deloitte Consulting India Pvt. Ltd.

Client: ON SEMICONDUCTOR.

Duration: May 2010- Nov2010.

3. Fusion project for Landolex

Created four ADF forms (Order Submission, Oder Review/Edit, Order Search, and Order Maintenance) for Landolex project.

Company: Deloitte Consulting India Pvt. Ltd.

Client: Landolex

Duration: May2010 – Sep2010.

3. ADF Integration with OAF

I was working in a 12.1.3 project of integrating ADF applications with OAF. So here I am creating different type of ADF applications any trying to embed it within an existing OAF page. With the completion of this project customer will be able to embed small ADF applications directly inside OAF page without any change.

Software: Application Development Framework (ADF), java, xml, PL/SQL.

Company: ORACLE INDIA PVT LTD.

Duration: June 2007 – May 2010.

4. Oracle Application Developer for Application Object Library’s (AOL) ATG Setups - Development / Maintenance:

I was one of the global owners of the FND module of Oracle Applications and I use to develop, enhance and maintain the following parts of Oracle Applications 11i as well as R12.

A. Functional Administrator

i) Security > Grants / Permissions /Permission Sets.

ii) Core Services >Lookups / Messages / Profile Categories/ Profiles /Functions /Menus /Caching Framework/ Personalization

B. Functional Developer

i) Security > Objects/ Permissions/ Permission Sets

For front end/User Interface part we use OAF (Oracle Applications Framework) and for backend we use Oracle 10G. So I have to develop new pages in OAF, which uses prepared statement and callable statement to interact with the database. I also have to tune backed queries and write PL/SQL packages, procedures, function, and triggers. This product intensively uses Java Object Oriented approach along with Collection framework.

Software: Oracle Application Framework (OAF), Java, Xml, PL/SQL and Oracle 10G.

Tools: JDeveloper 11.1.1.2.0 and Eclipse.

Company: ORACLE INDIA PVT LTD.

Duration: June 2007 – May 2010.

5. CRM Spread Table /JTF Grid - Development / Maintenance:

I was the sole owner of this component. This is a java bean with front end as java swing, embedded in the Oracle Forms and is used widely in Oracle Apps for displaying data in a tabular format. It works with Oracle Forms event system to display the data from the database table. It also provides export and sorting facilities. It retrieves the data by sending events to the TCA server and receives bunch of data in response. It stores the data using java collection model and maintains its own caching framework in a performant way. It uses java object Oriented and multithreaded approach for communication with the database via the TCA server.

Software: Oracle Applications (Apps), java, java swing, PL/SQL.

Company: ORACLE INDIA PVT LTD.

Duration: June 2007 – May 2010.

6. CRM Scheduling Chart / Gantt Chart - Development / Maintenance:

I was the sole owner of Gantt chart, which is also a multi threaded operation enabled, java bean with front end as java swing, embedded in oracle forms and synched up with forms event system. Mainly used for scheduling purpose by Field Service Team of Oracle Apps. It has a resource pane, which lists the resources on the left side, and a time browser pane on the right side, displaying the corresponding assignment in bar format for the resources. This bean supports internal drag and drops operation as well as drag and drop from any Forms component. This is mainly a multithread model that uses java object oriented approach for scheduling purpose. It uses almost all of collection framework for storing purpose, multi thread model for different scheduling and refresh of the client Ui. It also uses the worker thread model for dispatching events to the TCA server and for server client communication.

Software: Oracle Applications (Apps), java, java swing, PL/SQL.

Company: ORACLE INDIA PVT LTD.

Duration: June 2007 – May 2010.

7. Java Adapter for REST services - Project - Development:

I was also executing one security project to provide a java interface for calling all the java api’s of Oracle Apps using restful service. On completion of this project, product teams and customers of Oracle Apps will be able to call all IREP java public methods using REST interface rather than SOA interface. This mainly uses java reflection features for instantiating different classes and calling the methods of different class. It also has sql interaction for validation the data from the db table which is stored as per Oracle Apps standard.

Software: Oracle Applications (Apps), java, xml, PL/SQL.

Company: ORACLE INDIA PVT LTD.

Duration: June 2007 – May 2010.

8. ERP Project Suite-Finance:

I was working in the GPS team of Oracle India Pvt. Ltd and was one of the global owner of the Oracle Projects Suite. I was use own the following components:

a. Project Management

b. Project Costing

c. Project Billing.

Client: All global users of Oracle Apps namely HEWLETT-PACKARD JAPAN, TATA CONSULTANCY SERVICES LTD, CAPGEMINI CONSULTING INDIA PRIVATE LIMITED etc.

Software: Oracle Ebusiness Suite-Projects.

Company: ORACLE INDIA PVT LTD.

9. Site Office System (SOS):

The Software handles whole activity of Site Office, right from fault entry to allocation to different sets, job slip issue, DRB (daily Report Book), Time Sheet processing, OT/APP statement, Material usage list etc. And finally it generates the reports.

Software: JDK1.3, JSP 1.1, Java Swing, Jakarta Tomcat 5.0.27, JFreeReport

0.8.3e, Sybase 11.9.2.

Operating System: Windows 98, Linux 8.0.

Client: Calcutta Electric Supply Corporation (CESC) LTD.

Company: COGENTECH CONSULTING PVT LTD.

Duration: Dec’2004 to May’2005.

10. Site Office System for High Tension (SOSHT):

The Software handles whole activity of Site Office, right from HT Fault entry, Scheme Job, Diversion to allocation to different sets, job slip issue, LB (Ledger Book), Time Sheet processing, OT/APP statement, Material usage list etc. And finally it generates the reports along with enquiries.

Software: JDK1.3, JSP 1.1, Java Swing, Jakarta Tomcat 5.0.27, JFreeReport

0.8.3e, Sybase 11.9.2.

Operating System: Windows 98, Linux 8.0.

Client: Calcutta Electric Supply Corporation (CESC) LTD.

Company: CONACENT CONSULTING PVT LTD.

Duration: June’2005 to March’2006.

11. Site Office System for Maintenance (SOSMNTC):

The Software handles whole Maintenance Cell activity, right from Regional Office Job entry, Site Office Job Entry to maturation of cases to allocation to different sets, job slip

issue, DRB (Daily Report Book) , Form Material, Labor, Material recovered, reused list etc. And finally it generates the reports along with enquiries.

Client: Calcutta Electric Supply Corporation (CESC) LTD.

Software: JDK1.3, JSP 1.1, Java Swing, Jakarta Tomcat 5.0.27, JFreeReport

0.8.3e, Sybase 11.9.2.

Operating System: Windows 98, Linux 8.0.

Client: Calcutta Electric Supply Corporation (CESC) LTD.

Company: CONACENT CONSULTING PVT LTD.

Duration: Jan’2006 to March’2006.

College Projects:

1> Have executed a project on “Banking System” with front-end VB & backend Oracle. This system keeps track of all the transactions of the Bank i.e. receiving of money by Cash / by cheque, Payment of money by cash / by cheque etc. It also provides facilities for adding new clients or closing of A/c of clients. This system also generates report about a particular client up to a date / till to day.

2> have executed a project on “Computerized Visitors’ Record Maintenance System” with Oracle 8i and V.B. It keeps tracks of all records entered from the reception and keeps inter departmental communication through LAN (by the use of WinSock).

3> have executed a project on “Real Estate Management System” with JSP using Java image compression. This website will be for selling and buying of properties. One can upload the scanned picture of his property, which will be automatically compressed and stored in the server. This web page also makes use of a package called upload bean to save the data in the server database.

4>have executed a project on “CD Library Management System” using front end Java Swing and backend ORACLE 8i. This system completely handles the CD stock and maintains the database automatically. Admin can add CD to stock. User can have the status of particular CD as on date etc. We can also update and delete records and finally can have reports of CD stock as on date or for specific period.

Extracurricular Activities:

1) Played as school Captain in Inter School Cricket Competition in the year 1994, 1995, and 1996.

2) Played C.A.B under 13 from Srirampur Kalyan Samity (S.K.S) Club in the year 1994.

3) Played as vice Captain in interclub tournaments for S.K.S.

Hobby:

Playing cricket, snooker, knowing more about new programming languages, meeting and knowing new person, riding speedy bikes dancing and surfing net.

Place: Hyderabad (RUDRAJIT DAS)

Contact this candidate