SHOUBHIK MUKHERJEE Contact No- (***) 782-***-****

Country of Origin: India.

Presently Located at: Bangalore, India

Permanent Residence No- (091**-********

Email Id- ez5xxo@r.postjobfree.com (Primary)

ez5xxo@r.postjobfree.com (Secondary)

OBJECTIVE: An ORACLE CERTIFIED ASSOCIATE in Oracle-9i and an Oracle-11g CERTIFIED EXPERT seeking to handle increasing responsibility and challenging assignments to harness my technical and analytical skills and be part of an environment that promotes team effort and provides opportunity for value based growth as well as career advancement while making a significant contribution to employer organization.

EMPLOYMENT HISTORY:

Total IT Experience: 5.4 Years.

Reason for Job Change: Onsite Opportunities.

Currently working on Oracle11g and have prior UNIX experience.

Onsite Experience: US – Florida (Tampa) 6months (14 July-2009 to 23rd Sept-2009 and 14 Nov-2009 to 23rd Jan-2010) on B1 Visa.

Organization Period Business Domain Designation

Wipro Technologies Pvt Ltd

11-Oct-2010 till Present.

BFSI (Banking, Finance, Securities, Insurance)

Module Lead.

Acclaris Business

Solutions Pvt Ltd, Kolkata,

India. 19-Aug-2008

To 29th Sept-2010.

Health Care.

Senior Software Engineer.

Infosys Technologies Pvt Ltd,

Bangalore, India 19-Dec-2005

To 14-Aug-2008. Banking & Capital

Markets (BCM). Software Engineer.

EDUCATION History:

Professional Certification:

Oracle Certified Associate from Oracle University (OCA), Aggregate of 92%.

Oracle Certified Expert from Oracle University (OCP), Aggregate of 90%.

DEGREE INSTITUTION YEAR OF PASSING AGGREGATE PERCENTAGE/GRADE

B.E In Electrical & Electronics Engineering(Visveswaraiah Technological University)

(Full-Time) Sri Siddhartha Institute of Technology, Tumkur, Karnataka 2005 First Class With Distinction

(73.2%)

ISC (Science) Frank Anthony Public, Kolkata 2000 76%

I.C.S.E

Frank Anthony Public, Kolkata 1998 70.2%

SKILL SETS: Currently working on Oracle11g oracle development.

Skill Last Used Expertise Level Relevant Experience

Oracle SQL/ PLSQL – 11g

Application Development. Currently Used Good. 5.4 Years.

Sybase Currently used. Good. 0.6 Years.

Tools – Plsql developer, Toad, EDI tool, Ws-FTP Pro. Currently used. Good. 4.5 Years.

Informatica- Development of

Mappings, Mapplets, Workflow and Transformations. More than 2 years ago. Good. 2.0 Years.

Autosys- Job Scheduling. More than 2 years ago. Average. 1.5 Years.

Unix. More than 2 years ago. Average. 1.5 Years.

Visual Basics. More than 2 years ago. Average. 1.5 Years.

Tools: IBM Clear case,

Svn, Microsoft Vss and Oracle Toad. Current. Good 4.5 Years.

PROJECTS & RESPONSIBILTIES

1). Company- Wipro Technologies Pvt Ltd, Bangalore

Period of employment: 11-Oct-2010 to till date.

Project 1: Lloyds Bank - Imaging and Workflow Automation.

Duration: Oct-2010 to till date.

(a) Responsible for enhancing/ maintenance of database and only point of contact for Filenet/J2EE team.

(b) Responsible for design and enhancement of data model.

(c) Developed Procedures/Functions/Triggers/DDL scripts.

(d) Also involved in defect fixing/analysis of root cause of defects during UAT phase.

(e) Involved in code reviews and code designs.

(f) Responsible for Knowledge Transfers and grooming of team members .

Skills and Tools: Oracle SQL/PLSQL-11g, Oracle Enterprise Manager.

2). Company- Acclaris Business Solution Pvt Ltd, Kolkata (Head office- Acclaris Inc. Tampa, U.S.A.)

Period of employment: 19-Aug-2008 to 27-Sept-2010.

Project 1: Crosby Benefit Systems, Fidelity –Platform Upgradation.

Duration: Nov-2009 to till date.

Was posted to Tampa, Florida U.S.A. (B1 Visa): Nov-2009 to Jan-2009

(g) Gathered requirements for upgrading platform for existing client Fidelity and new client Crosby.

(h) Developed reports in PLSQL which would fetch data from different environments and generate a common report for client to view net claims reimbursed by different employer groups.

(i) Developed programs to automatically substantiate claims when participants swiped their debit cards.

(j) Also involved to helping team members in knowledge transfers and technical help.

(k) Involved in code reviews and code designs.

(l) Promoted to Sr. Software engineer from software engineer based on my performance.

Skills and Tools: Oracle SQL/PLSQL-11g, PL/SQL developer and WSFTP-Pro.

Project 2: Bank of America Benefit Solutions –End to end Implementation.

Duration: Mar-2009 to Nov-2009.

Bank of America decided to change their vendor for claims processing for various Health plans like HSA, FSA, DEPFSA, HRA, DCRA etc to Acclaris.

(a). Was involved in Fileloads containing participant enrollment information in standard 834 format.

(b). Completely developed deposit fileload’s which was to process participant deposit information (coming from vendors in various formats like CDHP, Excel etc according to complex business logic and load it in the database, enabling participants to view their account balance through portal (developed in Java).

(c) Received my Manager’s appreciation for defect free program processing when demoed in onsite with client and my company IT- Vice president.

Was posted to onsite: Tampa, Florida USA (B1 Visa): Jul-2009 to Oct-2009

(a) Was involved in post- production support and provided support to day to day problems, queries raised by client to Operations department.

(b) Also responsible for working on new change request and bug fixes.

Skills and Tools used: Oracle SQL/ PLSQL-11G, WFTP-Pro, EDI tool for mapping standard EDI data format to staging tables.

Project 3: AT&T Tuition Plan –End to End Implementation.

Duration: Aug-2008 to Feb-2009. (Ongoing- Production support and Change Request).

(a) Was involved in requirements gathering for implementing 12 tuition plans. Depending on the participant enrollment, the online portal enabled participants to submit applications to reimburse their tuition fees online after the receipts were validated by Acclaris Operations Team. The online claim reimbursement decreased company’s dependence on Operations resource thereby improving efficiency and cost.

(b) Coding, unit-testing, database design, implementation of code design and approach.

(c) Coordinating with QA team to ensure code quality prior to production release.

(d) Single handedly provided production support activities. (Have complete end to end knowledge of

Design, code impact changes and business requirements).

(e) Presently involved in grooming new production support team which does data fix and immediate fixes based on SLA.

(d). Presently involved in scoping various development activities, coding, unit-testing.

Technology and Tools Involved: Oracle-11g, PLSQL developer, Front-end application (developed by Java team).

3). Company- Infosys Technologies Pvt Ltd, Bangalore

Period of employment: 19-Dec-2005 to till 15-Aug-2008.

Client: Fidelity Investments.

Project 1: STORE: Sybase to Oracle Re-Engineering- Benchmark.

Location: Fidelity Client Office, Bangalore.

Duration: Nov-2007 to Aug-2008.

As part of STORE (Sybase to Oracle Re-Engineering) initiative, Fixed Income (FIMT- Comprising of debt and bonds) decided to migrate all the Vendor data feed systems, which are more data centric and less dependent on applications, from Sybase to Oracle. This involved migrating all vendor feeds databases (presently six) to one schema and one database.

Responsibilities & Achievement-

Got an appreciation mail from client commending my defect less code and for learning new technologies within very short span of time.

1. Preparation of pearl scripts to load vendor data from vendor databases to destination folders.

2. Developing mappings, mapplets, workflows and sessions in informatica for loading vendor data from Sybase to destination tables in oracle after validation and transformation.

3. Writing SQL queries, joins, PLSQL procedures, Functions, Triggers to extract data from multiple sources before inserting into target tables.

4. Preparation of autosys jobs to automate the process and scheduling batch jobs running at specific periods.

5. Coding and self testing of application in various environments, defect tracking and code reviews.

6. Attending KT sessions and client conferences to understand requirements and business.

Skills Used: SQL, PLSQL, UNIX, Informatica8.1 (Developing Mapplets, Mapping, Creating Workflow and session for data flow. Creating scripts.), Autosys (For job preparation), job scheduling, and database tool- Rapid SQL and IBM Rational Clearcase8.1 for version maintenance.

Project 2: AI and Reporting

Duration: Feb2007 to Nov2007.

Was a part of Production Development Team responsible for designing procedures, packages, triggers and other database object, which would interact with the database in order to retrieve participant’s assets, and holdings, which would then be passed on to the front end (Informatica) to be viewed by the end user. AI is the main module, which included creating customer accounts, and adding transaction details while Reporting, which is the sub module, included generating reports of investment details for each participant.

Responsibility-

1. Single handedly managed the reporting module and working with the AI team in development.

2. Coding in SQL/PLSQL on TOAD tool along with rigorous self-testing as the code was deployed in various test environments before finally being deployed in production database.

3. Was also the backup Project Leader and have ensured that our deliverables meet the standards with frequent Code Reviews, Defect Tracking and Effort Estimation being done.

Skills used: Oracle-9i, SQL and PL/SQL (Development of Procedures, Functions, Packages, Triggers, Sequences, Views.), Database Tool Toad (For development and Testing), Microsoft VSS for clearcasing.

Project 3: Actuarial Application Corporate Actions

Duration: May2006 to Jan2007.

Was a part of the development team, involved in preparing requirement documents based on client needs, developing and testing Workbooks which are Excel applications supported by VB and fetching data from the database enabling a participant to view their retirement benefits (Defined Benefits) based on complex calculations as proposed by the clients of Fidelity (like- VNU, NCR, RHD).

Responsibilities-

1. Preparation of requirement document according to client needs.

2. Coding, self testing and running Regression Testing to prevent breaking of code.

3. Involved in Defect Prevention meetings and KT (Knowledge Transfer) sessions held regularly in order to maintain the Infosys quality standards before production delivery.

Skills used: MS- Excel, VB6.0, Regression Tool, SQL, PLSQL, Unix.

HOBBIES:

Cooking, Driving, Listening to Music, Visiting Places, Interacting with people and Surfing Internet.

MAJOR STRENGTHS:

Fast Learner and Good Listener, Adoptable, Persevering and taking Initiative, Good Communicator and Capable of leading and motivating a Team.

PERSONAL INFORMATION:

Gender

Marital Status Male.

Married.

Father’s Name Mr. S.Mukherjee

Permanent Address

23, Ballygunge Gardens, Kolkata

West Bengal.

Date Of Birth 11th June 1982.

Nationality Indian.

Religion Hindu.

Passport No: H3574512.

I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Dated: 06/04/2011 Shoubhik Mukherjee

Contact this candidate