sample profile for cv

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Profile & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Mobile: +91-9949949827

E-mail: h.amitabh@gmail.com                                                         AMITABH.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      :           9441296570

      Alternate E-Mail           :           h_amitabh@yahoo.co.in

      Address                       :           52/A, Nehru street, Shanti Nagar (04288 – 258165)

                                                      Salem district, TAMIL NADU.

Download Resume Format