Sql Developer
Resume:
P.Sunil Herbert
*A Shirdi Sai Nagar,
Lakshmipuram Road,
Poonamallee,
Chennai - 600056
INDIA.
E-mail : **********@*****.***
: *****.****@*****.***
Mobile : +91-988*******
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