Experience on Oracle SQL, PL/SQL, ETL design and Development and ODI

Shibu Sarkar

Mobile: +91-898******* Email:***********@*****.*** Skype ID: shibu_sarkar

Professional Experience

Profile

- Overall 6+ years of experience

o Around 5+ years of experience in design, development, implementation, deployment, and management of software in Product

Engineering Services.

o Around 2 years of experience in Data Warehousing, ETL design & development .

- Experience in development on various platforms

- Experience in validation, verification and testing.

- Can easily switch between individual as well as team contributor roles.

- Good Understanding of the software development life cycle

- Self-Motivated, Responsible and Goal oriented. Ability to get along well with team members and motivate co-workers.

Employer History

• From April-2013 to till now at EBIW Info Analytics Pvt. Ltd., Kolkata as a Consultant.

• From August-2010 to March-2013 at ICRA Online, Kolkata as a Senior Associate.

• From March-2009 to July-2010 at Spectra Consultancy Pvt. Ltd, Kolkata as a Software Developer (Contractual).

• From March-2008 to February-2009 at Hindalco Industries Ltd., Belur as a System-IT Trainee.

• From April-2007 to October-2007 at ICS Call center, Kolkata as a Tech-supporter.

Assignment History

Oracle Communications Data Module (11.3.1.0.0) – (Company: EBIW info analytics pvt. ltd., Client: Zain Telecom, Saudi Arabia) (November 2013

– Present Day)

Role:– OCDM mapping, ETL Development & Design.

My role on this project is to perform a preliminary study of source data, mapping and design & develop part of the ETL for Stage to OCDM. Key

deliverables I am tasked with producing for this project are:

Design and develop the "Active Subscriber Base" calculation.

Fixed mapping for OCDM Reference and Base table.

Design and develop the ETL for Network Event Calculation.

Residential Password Management (RPM) & Personalize Services Dashboard (PSD) – (Company: EBIW info analytics pvt. ltd.,Client: Sasktel,

Canada) (July 2013 – September 2013)

Role:– ETL Development & SQL Performance Tuning.

My strategy was designed to meet the following requirements.

ETL development & SQL tuning .

Oracle Communications Data Module (11.3.1.0.0) – (Company: EBIW info analytics pvt. ltd.,Client: Grameen Phone, Bangladesh) (April 2013 –

June 2013 )

Role – ODI & ETL Development and SQL Performance Tuning.

A summary of work carried out is contained below.

Partially design & development on "Subscriber Active Base" calculation.

ODI interface development for Source to Stage and Stage to OCDM.

SQL tuning for inbuilt ETL of OCDM.

Insurance Explorer System – (Company: ICRA Online Ltd.) (October 2012 – February 2013 )

Shibu Sarkar

Mobile: +91-898*******

Email:***********@*****.***

Role – Database Developer.

A summary of work carried out is contained below.

Understanding the functional flow and logic.

Design the report & developed DB objects as requirement.

Asset Management System (AMS) – (Company: ICRA Online Ltd., Client: IDBI Bank, India) (April 2012 – October 2012 )

Role – Database Developer.

A summary of work carried out is contained below.

Understanding the functional flow and logic.

Design the report & developed DB objects as requirement

Design the Historical Data processing steps.

Data Analysis for EDC, ENI and P&C – (Company: ICRA Online Ltd., Client: Moody's, UK)

Role – Database Developer.

A summary of work carried out is contained below.

Understanding the functional flow and logic.

DB design & develop DB objects for the individual project.

Create Procedure & function to calculate "Ratio" as per business requirement

Payroll Management System, Government Provident Fund & Loan Modules – (Company: Spectra Consultancy Pvt. Ltd.,Client: India

Goverment MINT, Hyderbad, Nashik & Noida)

Role – Database Developer.

A summary of work carried out is contained below.

Setting up the application

Resolved user-end problems and provided full system support in total flow after implementation.

Designed & developed all reports as per user requirements.

Implement the Payroll Management System & giving training to the user.

Oracle Purchasing Module – (Company: Hindalco Industry Ltd, .Client: Hindalco Industry Ltd. (In-house Product), India)

Role – Forms & Reports Developer.

A summary of work carried out is contained below.

Understanding the functional flow

Develop reports as requirement.

Resolved user-end problems and provided full system support in total flow after implementation.

Vendor Rating System – (Company: Hindalco Industry Ltd, .Client: Hindalco Industry Ltd. (In-house Product), India)

Role – Forms & Reports Developer.

It was my first individual project. A summary of work carried out is contained below .

I design the total flow.

Developed Reports, Procedures and Triggers.

Resolved user-end problems and provided full system support in total flow after implementation

3

Shibu Sarkar

Mobile: +91-898*******

Email:***********@*****.***

Key Skills

ERP : Oracle 11i (Oracle Apps: Purchasing Module)

DBMS Packages : Oracle 9i,10g,11g & Microsoft SQL-Server

Front End : Forms 6i & 9i and Reports 6i & 9i

Operating System : Windows XP, Windows 2000 Server, Basic Linux.

Languages : Oracle SQL, PL/SQL,SQL-Server & T-SQL.

DWH Module : Oracle Communications Data Model (OCDM), Oracle Airlines Data Module (OADM).

Tools : Oracle Data Integrator.

Tuning : Oracle SQL & PL/SQL Performance Tuning.

Key Courses and Training

Institute Course Subject Certification Year of Study

SQL Star Pvt. Oracle Developer RDBMS, SQL, PL/SQL, Oracle Certified 2007-

Ltd., Kolkata Track. Forms 9i & Reports 9i. Assistance. (OCA) 2008

Education

Qualification

Exam Institute Board Year of Study %

B.Tech Dr. B. C. Roy Engineering West Bengal University Of

2002-2006 70.9%

(C.S.E) College, Durgapur, W.B. Technology

Nimta High School, North 24 West Bengal Council Of Higher

XII 1998-2000 56.5 %

Parganas, W.B . Secondary Education

Nimta High School, North 24 West Bengal Board Of

X 1996-1998 73.5 %

Parganas, W.B . Secondary Education

Languages

I am experienced in communicating with clients and have also over the years developed a network of people I can talk to about challenges that arise

during implementations. I use the power of the Internet to expand my communication paths and to provide quick solutions to business problems that

my clients are facing. I also take pride in knowing that when my clients have a problem they think of me first for the solution.

3

Shibu Sarkar

Mobile: +91-898*******

Email:***********@*****.***

Other relevant information

Contact No. : +91-898*******

Email Address : ***********@*****.***

Skype ID : shibu_sarkar

Passport No : F7314718

Address : 14 Swarupananda Sarani, P.O. Italgacha, P.S. DumDum, Kolkata-700079, West Bengal.

3

Contact this candidate