Mobile: +91-9949917776
E-mail: h.deivendran@gmail.com DEIVENDRAN.H
Objective:
Looking for a significant position in Oracle PL/SQL Programming that utilizes my Technical skills with commitment to company excellence.
Current Organization:
• IBM Global India (P) Ltd, Hitech – City , Hyderabad.
Experience Summary:
• Over all 3+ years of experience in the IT industry of which 2 Years in PL/SQL.
Having extensive experience in PL/SQL Programming such as - Developing Stored Procedures, Creation of Triggers, Developing user - defined Packages, Handling Oracle Supplied Packages, Handling user defined and & Built-in exceptions.
Having exposer in Query optimization using SQL trace, AUTO trace, STORED outline,
STATUS PACK for handling Performance tuning.
Having knowledge in Oracle DBA activities like Objects Creation, Backup, Indexing, SQL Tuning, Data Loading, Table Designing and Managing Tablespaces.
• Having knowledge in VB 6.0 , ASP and Crystal Report
• Having exposure in Unix platform
• Worked as Software Engineer in Mansoft Microsystem Software Pvt Ltd, Bangalore
Between June 2003 and February 2006
• Worked as Programmer at Soffia software solutions, Madurai from Aug’ 1998 to Mar’ 2000
Qualifications:
• Master of Computer Applications in Madurai Kamaraj University,.
• Bachelor of Science in Physics, Madurai Kamaraj University.
Project Highlights:
1) Supply Chain Management -Datawarehouse and Business Intelligence:
Client : CELESTICA –Canada -Toronto
Environment : Oracle 9i, Oracle Workflow and AIX Unix/Win 2000,Toad
Duration : March 2006 – Till Date
Role : PL/SQL Developer
Description : The new, scalable data warehouse is the repository for all Supply Chain, Shop Floor and Human Resources information in Celestica. It contains data from all the major information systems used world-wide (BPCS, OMAC, SAP, SFDM, GRForce, SCE, Aspect, Matrix), from all Celestica manufacturing, distribution and repair sites, using flexible Oracle reporting technology including Oracle Discoverer.
Some of the benefits of the new system are:
A single interface for all of your data warehousing requirements:
Customized queries that can be shared with other users, Instantaneous Ad-hoc reporting
Enhanced summary and drill-to-detail capabilities,Faster Performance on a Scalable platform
Access to online training materials and quick reference guides
Responsibilities:
Creating primary object like table, views, indexes, store procedures, triggers, function.
Creating views, Synonyms and integrity constraints for data protection.
User management involves creating users, granting & revoking roles.
Optimizing and Montitoring the instance to achieve low loading severs and minimal response.
Interacted with external OS files with the help of Oracle supplied packages-UTL_FILE.
To Check all jobs are running successfully or not and taking the action on failure.
Supporting servers for 24*7 availability for solving all day to day problems from user side.
2) Integreatz:
Client : Marshal Engineering, Hosur
Duration : October 2004 – February 2006
Environment : Oracle 9i.
Role : PL/SQL Developer
Description : The Product of ERP deals with the best business solutions for Enterprise related process. It includes various Modules Like Customer order Processing, Purchase Order Processing, Inventory,Design of BOM, Manufacturing Resources planning, Quality Control. It contains reports of Various Modules and views for user friendly approach designed in crystal reports. All business Processes works with minimal customization.
Responsibilities:
Created functions for various modules as per the requirement with exceptions handling.
Created packages with integration of stored procedures, functions, variables, cursors.
Having Knowledge in creating and handling various type of index.
Created Triggers to maintain the history of vendors & customers.
Created different kind of partition with huge amount of data.
Handled PL/SQL tables effectively for Bulk Insert & Retrieve.
Submitting jobs with regular interval with the help of predefined package DBMS_JOB.
3) Gateway:
Client : Dellvac Manufacturing Company.
Duration : March 2004 – August 2004
Environment : Oracle 8i, Crystal Report 7.0
Role : PL/SQL Developer
Description : This software was being developed to reduce the paperwork at office and everything was prepared automated. The name of the product was Gateway and it was consisting of different modules like Leave Processing System, HR Information System (HR), Finance, Engineering, Project Allocation, Facilities, and reporting Information System, mailing, Notice Board, Down Loads etc as main modules.
Responsibilities:
Created Stored procedures with handling of built-in exceptions and user defined exceptions .
Created Triggers to maintain the history of employees
Handled database objects using Views ,Synonyms ,Sequence and Index.
Handled some of technical methods for Query optimization.
Create reports on crystal reports as per specifications.
4) Hotel Management System:
Client : Hotel Taj, Chennai
Duration : February 1999 – August 1999
Environment : Visual Basic 6.0, SQL Server, Crystal Report 7.0
Role : PL/SQL Developer, VB Designing, Report Developer
Description : The Application is designed for the Management purpose of the Hotel administrative people to get reports and Status of the Hotel Room Availability and more. The project contains the four modules. They are Front office, Billing, Inventory, and Payroll. The reports are designed in the Crystal reports.
Responsibilities:
Query Programming and writing stored procedures.
Forms designing, Coding and Testing.
Functional & Technical Assistance to team members.
Create reports on crystal reports as per specifications.
5) Information System of Banking:
Client : Sri Ram Chits , Madurai / Duration : Sept 2003 – Febr 2004 / Team size : 5
Environment:VB6.0,SQL Server,Crystal Report/Role : Query Developer,Form&Report designing
Description : Banking domain project that keep track on the customer details such as loan details, cash deposits, cash withdrawals, monthly customer transactions, monthly deposits(RD).
6) Automated Billing Enhancement:
Client: Touchtel Customer services,Chennai /Duration : Sept 1999 – Febr 2000/Team size : 4
Environment : ASP,Unix, Oracle 8, Java Script / Role : Query and Form designing ,Testing
Description : The subscribers can get bill information for their telephone number. When the service number is dialed. it will ask for the telephone number for which bill details are required. Then the system will check in database and retrieve the details
Additional Responsibilities included:
1. Table Design - Designed Tables based on Normalization by enforcing constraints to ensure integrity of database and Designed External tables for data loading from flat files.
2. Data Upload- Loading data from flat file given by client into oracle database using SQL Loader 10.1.0 & control file in both windows and Unix.
3. PL/SQL Wrap - Wrapping PL/SQL codes for usage at client place.
4. DBMS Package - DBMS_JOB ,UTL_FILE ,DBMS_SQL ,DBMS_DDL ,DBMS_UTILITY
Handled Wherever necessary.
5. Created Reports using Crystal Report as per specifications.
Software Skills :
Operating System : Windows XP/NT, UNIX
Languages : Visual Basic 6.0, C, C++
RDBMS : Oracle 8/8i/9i, MS - SQL Server 7.0,Toad
Web Tools : ASP, HTML, Java Script, VB Script
Reporting Tool : Crystal Report 7.0
Personal Profile :
Alternate Phone No : 9441231893 (Raj Kumar).
Alternate E-Mail : h_deivendran@yahoo.co.in
Address : 10/2, Kother street, Tirucencode (04288 – 258728)
Salem district , TAMIL NADU.
|
|
