P.Sunil Herbert

*A Shirdi Sai Nagar,

Lakshmipuram Road,

Poonamallee,

Chennai - 600056

INDIA.

E-mail : ac3lgb@r.postjobfree.com

: ac3lgb@r.postjobfree.com

Mobile : +91-988*******

+91-984*******

SUMMARY

I have above Ten years experience in ORACLE,PL/SQL,Unix,Performance tuning,Core DBA,PostgreSQL, and 1 year in VB6.0, Database programming, emphasizing, interface design, document management,client-server, SQL SERVER,HPQC

EXPERIENCE AND SKILLS

Having above 10 years of experience in the IT industry with an emphasis on distributed

systems utilizing Oracle,PL/SQL,UNIX,HPQC,PostgreSQL.

DBA Concepts that includes Backup and Recovery using Import and Export utilities and RMAN.

Values technical excellence and hard work.

Strong background in the successful application of Client/Server Technology.

Actively involved in the development, implementation and maintenance of application

programming using Oracle 10g, PL/SQL, Visual Basic,Crystal Reports as well as customized Reports on the Windows platform.

Well versed in Tuning SQL and PL/SQL

Also has excellent communication and interpersonal skills.

Seeks to use the latest State-of –the-art technology to give competitive business solutions.

Implemented Backup & Recovery strategies using RMAN and Hot/Cold backup for Oracle 11g/10g/9i databases in Solaris, AIX and LINUX environment

Experienced in oracle migration using exp/imp and Datapump (expdp/impdp).

Cloning and Re-building the databases from Production to other Environments in a short time using various methods like EXP /IMP, HOT/COLD and DATA PUMP.

Analyze the index if necessary rebuild or Coalesce index to rectify index fragmentation.

Analyze the table for fragmentation issue and rectify.

Tuned database for optimal performance using AWR, STATSPACK, TK Prof, EXPLAIN PLAN, ADDM and Performance views.

Involved in migration of Oracle 11g to PostgreSQL 9.4 using Ora2Pg tool.

EDUCATION

B.E (Electronics and Communication)from University of Madras, Chennai,

PGDCS(SSIL,CHENNAI)

CERTIFICATIONS

Brainbench Certified Oracle PL/SQL – Transcript Id# : 1730308

(http://www.brainbench.com/transcript.jsp?pid=1730308)

Achievements/Recognization

FTR(First Time Right) Award winner in AtoS

TECHNICAL KNOWLEDGE

Skill Set

Software

Client Server

Visual Basic 6.0, Power Builder 5.0, Developer 2000.

Databases

Oracle 11g, SQLServer2000, MySql, MS Access,PostgreSQL 9.4

Server Side Technologies

ASP, RMI, Servlets, JavaBean.

Languages

SQL,PL/SQL,C, C++, Java,PERL 5.1

Scripting Language

JavaScript, VBScript.

Markup Languages

HTML.

Operating Systems

Unix,Windows 2000/NT/98/95, DOS

Reports

Crystal Reports 8.0

Components Design

COM / DCOM, ActiveX

Distributed Technologies

XML.

Tools

Oracle Enterprise Manager(OEM),TOAD,SQL Developer,PL/SQL Developer,HPQC,Ora2Pg,Strawberry PERL / Activestate Perl,Putty,RMAN,Datapump,Export/Import Utilities

ETL

DM Express

CAREER PATH

Organization

Designation

Period

RNTBCI Pvt Ltd

Technical Lead/Asst Manager -Technical

Feb -2015 To Jan-2017

Cognizant Technology Solutions Pvt Ltd

Senior Associate –Project

Mar-2014 To Dec - 2014

Atos India Pvt Ltd.

System Analyst

Nov-2010 To FEB-2013

Proteam Technologies Pvt Ltd

Tech Lead

Feb -2008 To Nov-2010

CSS Corp Pvt Ltd

Tech Lead

Aug -2007 To Feb - 2008

Oracle Financial Services Software Ltd(formerly iFlex Solutions Ltd)

Associate Consultant

Dec 2004 To Jan 2007

Protonweb Solutions Ltd

Technology Team Member

Sep’2003 to Nov 2004

Computer Software College,Chennai.

Faculty

July’1998 to Aug’2003

PROJECT DETAILS

Current Project:

02/2015 – Tilldate FSC,RPIC,CPROS,Prospr

Client Renault France

Environment Oracle 11g,Oracle 10g,My SQL,PL/SQL,SQL Developer,PostgreSQL 9.4

Tools Ora2PG

PROJECT DESCRIPTION:

oTechnical support for all the projects of Renault in Database.

oSQL Query tuning

oGathering Database Statistics using ANALYZE and DBMS_STATS Package.

oDatabase Design Validation

oAnalysis of STATSPACK Report and AWR.

oDefragmentation of Tables and Indexes using SHRINK and Coalesce, IMP/EXP and DBMS_REDEFINITION Package.

oData Migration of Oracle 11g Database to PostgreSQL9.4 Using Ora2PG

oInstallation of Strawberry Perl,Activestate Perl.

oConfiguring Ora2pG by setting parameters in Ora2pg.conf configuration file.

Roles / Responsibilities:

* Data Loading with SQL*Loader

* Tuning SQL and PL/SQL Programs

* Writing DB Procedures

* Execute Modules, Code Review.

* Used effectively Export and Import Utilities

* Database Optimization

* Backup and Recovery

* Data Migration

03/2014 – 12/2014 Business knowledge functionality(BKF),OpServer

Client THE HARTFORD

Environment Oracle 11g,Oracle 10g,PL/SQL,UNIX,DM Express

PROJECT DESCRIPTION:

Opserver is a OLTP system managed by IMS.

Used to find Scoring & Pricing information for commercial applications

It internally calculates pricing

Data gets loaded to opserver from BKF Core – Sql Loader – Opserver

Internal sources for BKF are premium and loss

External sources is EBC(Electronic business center)

BKF is a Commercial Lines system.

DB Size is 3TB.

ROLES AND RESPONSIBILITIES:

Understanding KT documents provided.

Getting KT from TCS.

Preparing understanding documents for daily topics.

Preparing and maintaining Questionaire.

Maintaining KT Tracker.

Reviewing team member’s UD.

Involved in Reverse KT

Sending daily KT feedback to onsite.

Understanding the back end Functions, Procedures and Packages in existing system.

Training taken for Oracle,PL/SQL Basics for team members

Data Migration of Mainframe Data to Oracle Database using ETL Tool DM Express.

Project 1:

11/2010 – 02/2013 GCF Lot19Bis,GCF Lot20,FMA Lot1,FMA Lot2, FMA Lot3

Client RENAULT

Environment Oracle 11g,Oracle10g,PL/SQL,HPQC,UNIX,Sql Developer

GCF : Gestion contact France (France Management Activity)

Simplify the Sales Force administrative and management tasks

Improve the effectiveness of Renault Marketing Campaigns

Sales Representatives in the Dealer management (450 equipped with “Dossier Client Pilotage des Contacts” Customer File Management Activity

150 Marketing Managers equipped with “Dossier Client Pilotage des Contacts” Customer File Management Activity

Central Administrators (Dossier Client Pilotage des Contacts (Customer File Management Activity)

4500 Sales Representatives equipped with ISIS application “Dossier Client Suivi des Contacts” Customer File Follow-up Activity

Roles / Responsibilities:

* Requirements Analysis

* Data Loading with SQL*Loader

* Tuning SQL and PL/SQL Programs

* Writing DB Procedures

* Execute Modules, Code Review.

* Coding, Unit testing & Write test cases

* Used effectively Export and Import Utilities

* Development

* Database Optimization

* Writing SHELL Script for launching the Batch.

Project2:

11/2010 – 02/2013 FMA Lot1,FMA Lot2, FMA Lot3

Client RENAULT

Environment Oracle11g,Oracle10g,PL/SQL,HPQC,UNIX,Sql Developer

FMA : Fleet Master Application

Fleet Master is a Sales Agreement Portal which is used by Dealers & Fleet Support Agencies within Renault to create Incentives for Fleet purchases of Renault Vehicles which is called as Agreements.

These Agreements are then reviewed, tracked & approved by various levels of Financial Controllers

The exact Models against which the Incentives are offered can be identified using attributes (e.g. Transmission, Engine Type)

The profitability of each set of incentives will be calculated. This will be used to determine if the agreement is automatically approved or if it needs the approval of the Financial Controller.

The Agreement Status field is used to control the approval process, the changes you may make to this field are restricted.

After an Agreement has reached Pending Approval status it becomes read only for all users except Agreement and Financial Controllers

After an Agreement has reached Approved status, no changes are permitted to the Agreement which would result in greater financial exposure for Renault

Once an Agreement is in Released status and the Order and Payment start dates been reached then customers \ dealers may make orders and receive payments on an Agreement

An Agreement Summary report can be generated for an Agreement .

Roles / Responsibilities:

* Requirements Analysis

* Data Loading with SQL*Loader

* Tuning SQL and PL/SQL Programs

* Writing DB Procedures

* Execute Modules, Code Review.

* Coding, Unit testing & Write test cases

* Used effectively Export and Import Utilities

* Development

* Database Optimization

* Writing SHELL Script for launching the Batch.

Project 3:

02/2008 – 11/2010 POS-HSB

Client ALMAQAR HSB

Environment Oracle9i,PL/SQL

Team Size 12

POS is Point of sale System developed for ALMAQAR Libya, Basically designed and developed for Restaurant. This online system has several modules such as File, User/Employee, Time sheet, Product, Accounting, Purchase,Inventory, Client Details. I have been involved in DB design and writing various DB procedures,Triggers and also involved in performance tuning of Existing system.

And also interacted with client for requirement analysis and finalizing the project.

Roles / Responsibilities:

* Requirements Analysis

* Database Design

* Data Migration

* Tuning SQL and PL/SQL Programs

* Writing DB Stored Procedures,Triggers

* Execute Modules, Code Review.

* Coding, Unit testing & Write test cases.

* Development

* Database Optimization

Project 4:

08/2007 – 02/2008 EIP

Client SOCIETE GENERALE, Bangalore

Environment Oracle9i,PL/SQL

Team Size 10

EIP is Employee Improvement Program that has specifically used for SG employees and has lot of modules such as TLN,SECURITY,INSIGHT,TIMEWARE . I have been involved in creating various stored procedures for various modules that can be called from UI.mainly involved in TLN Dashboard that is nothing but generating reports for employees that shows mobile and landline subscription and consumption details of all the employees of SG.i have also involved in dynamic upload of various Files and involved in mapping of files with database objects for employee details.

Roles / Responsibilities:

* Requirements Analysis

* Database Design

* Data Migration

* Tuning SQL and PL/SQL Programs

* Writing DB Stored Procedures,Triggers

* Execute Modules, Code Review.

* Coding, Unit testing & Write test cases.

* Development

* Database Optimization

Project 5:

01/2005 – 01/2007 FLEXCUBE – Consumer Lending

Client BANCO DE CHILE, SICREDI Brazil

Environment Oracle9i,PL/SQL, Developer 2000, Visual Basic 6.0,

Operating System Unix,Windows

Team Size 25

FLEXCUBE, No 1 banking product developed and promoted by iflex solutions is being implemented and running live in various major and minor Financial Institutions of over 140 countries. Some of the customers using FLEXCUBE includes major International banks like CitiBank, UBS, Kuwait Bank, African Banks, IMF, Bangla Bank etc.. and Indian Banks like HDFC bank, Syndicate bank, Kotak Mahindra bank, Dhanalaxmi bank etc..

FLEXCUBE is divided in different modules depending on the functionality of Banking system. All the modules and various Interfacing systems are being continuously enhanced in order to meet the client’s requirements.

FLEXCUBE consists of modules like:

Loans and Deposits

Accounting

Funds transfer

Money Market

Messaging

Foreign Exchange

Standing instructions

Bills and collections

Letters of credit

Interfacing

Securities

Static Maintenance.

The Consumer Lending (CL) Module is a new module in FLEXCUBE to cater to the lending needs of banks and other financial institutions. It comprises Loan origination and Loan Processing functions. The CL Module interfaces with the core module of FLEXCUBE for Accounting, Messaging and MIS. APIs are developed to enable seamless integration with other modules of FLEXCUBE. Hence other modules can create Loans, make payments to existing loans etc by calling the relevant functions of the loans module.

Roles / Responsibilities:

Testing of CL Module

DB Procedures

Implementation

Data Migration

Mapping

Development of new PL/SQL packages, functions and procedures, tables, sequences Oracle Forms etc.. for the implementation of second phase changes (CL 2.1) for Banco De Chile, Chile.

Tuning of the existing packages, tables and Forms of modules like Loans and deposits and Accounting and worked on for performance and incorporating new enhancements.

Involved in Integration Testing, debugging and support during the release of CL 2.1 and 2.2.

Involved in BDC and SICREDI site issues.

Preparation of Program Specification, UTP and Unit Testing.

Kernel Support during the Qualification Testing for CL 2.1 release.

Generation of Advices for Coupon Books in CL.

Preparation of DS, coding and Unit Testing for Prepayment Penalty and VAMI charge for loans, Payment Invoices and follow up for LH Sweden in CL3.0 major release.

Project 6:

05 / 2004 – 12/2004 Cradlei

Client NKF S’pore

Environment Visual Basic.Net, VB6.0,Oracle 9i, Crystal Reports and Windows XP.

Team Size 6

Cradlei is designed to automate the entire Hospital management and Call center activities,it is incorporated with Dialer(PDS) to make automatic dialing for Call center.it is fast and has more featuers in it.It has very large database.Many activeX controls used in it.

Roles / Responsibilities:

Analysing the Requirement Specifications

Screen Design for Creation of new Classification, Folder and documents.

Preparation of Functional Specification Document.

Preparation of Detail Design Specification.

Coding

Preparation of Unit Test Plan.

Involved in Unit testing and defects debugging.

Passport Details

Passport No : L7220093

Date of Issue : 19-02-2014

Date of Expiry : 18-02-2024

Place of Issue : Chennai

Contact this candidate