Chetan Gajjar

Contact: +919*********/+919*********

E-Mail: acv5lf@r.postjobfree.com, acv5lf@r.postjobfree.com

Senior Level Assignments

A versatile, high-energy technocrat with the distinction of executing prestigious projects of large magnitude within strict time schedule

Database Administration~ Software Development~ Project Development

Location Preference:Gujarat,Mumbai,Hyderabad,Pune,Bangalore,Noida, USA

Industry Preference: IT &Manufacturing

PROFILE SUMMARY

A competent professional with over 12 years of experience in:

Application Development Software Development Production Support

Database Administration Project Management Team Management

●Currently associated with Shairu Gems, Surat as Sr. Software/Project Manager

●Skilled in Oracle SQL, PL/SQL, Oracle 8i,9i,10g 11g, Oracle Developer Suite 10g /6i and Oracle Reports 10g/6i(D2K), Vb.Net, Vb 6 and VBA programing for Excel technologies, etc.

●Proficient in developing Oracle PL/SQL Packages, Stored Procedures, Functions, Triggers and Cursors

●Expertise in managing multiple technology service areas of IT Infrastructure outsourcing which enables the management of many complex business processes to seamlessly optimize and manage event driven processes

●Significant experience of working with customers, project managers & technical teams for securing & executing concurrent projects (Please confirm)

●Working knowledge of Database Performance Monitoring, Performance Tuning, System Administration and Basic Network Administration

●Excellent communication and interpersonal skills with proven abilities in resolving complex infrastructure

CORE COMPETENCIES

●Handling database activities like creating database & managing tablespace, parameter changes, Rman backup &Rman Recovery and Index ManagementOracle Job Process

●Supporting Data Centre Operations Management for providing 24X7 support; coordinating with vendors relating to all technical aspects of IT infrastructure

●Ensuring performance tuning, backup and recovery, space management and user management for the clients

●Analyzing& identifying potential issues with computer systems, performing routine audits of systems and software

●Managing the overall administration, configuration and maintenance of application servers and databases

●Addressing queries regarding the Information System / Software & extending onsite support to the clients including maintenance of software

ORGANISATIONAL EXPERIENCE

Since Jan’10 with Shairu Gems, Surat as Sr. Software/Project Manager

Key Result Areas:

●Developing procedures, functions for triggering the database

●Responsible for optimizing query

●Handling diamond manufacturing& inventory, sales, process cycle, time management, performance evaluation etc., for whole diamond software ERP module

●Handling Canteen Management System, Point System and MFG System

●Creating Online Transport Management System,Task Management System in Oracle forms & Report 10g

Feb’09-Dec’09 with Keysoft Creation Pvt. Ltd., as Software/Project Manager

Key Result Areas:

●Developed the following:

oMoney Transaction System (Oracle Xe, Oracle Forms)

oOrder Management System (Oracle Xe, Oracle Forms )

oModule for report form and reports for Accounting Package by using (C#, SQL Sever 2005, Stimulsoft Report)

May’08-Jan’09 with Auro Mfg. Pvt. Ltd. (Blustar Diamond group) as Software Developer

Key Result Areas:

●Worked on stock inventory system like Oracle 9i, Oracle forms 10g

●Updated Inventory modules for existing system

●Developed CRMSMS (Customer Relation Management System via SMS (VB.Net 2005,SQL Server 2000)

●Involved in development for KP Jwellers, Surat

Apr’03-May’08 with Shairu Gems, Surat as Software Programer

Key Result Areas:

●Involved in development of the following:

oManufacturing / Stock Management System (Oracle 8i, Forms6i, Report6i)

oBarcode System for Manufacturing Management System (Oracle, Forms6i, Report6i )

oAttendance System Using Barcode (Oracle, Forms6i, Report6i, Visual Basic 6.0 )

oLive Stock for Analysis System (Visual Basic 6.0)

EDUCATION

●Post Graduate Diploma in Computer Application from South Gujarat University, Gujarat in 2001(1st Sem. complete}

●Master in Computer Application from Softech Computer Academy, Udhana in 1999

●B.Com. from South Gujarat University, Surat in1999

●12th from School, location, Gujarat Secondary Board Higher Secondary Certificate Examination in 1996

●10th from School, location, Secondary School Certificate Examination in 1994

Others

●Oracle 1Z0-051-ENU Oracle Database 11g: SQL from Institution, location

PROJECTS

●Successfully completed projects on:

oInventory System

oPartner Achievement System

oUrban Health Center Achievement System

oMLM (Multi Level Market) System

oChemical Consumption & Budgeting System

Other Projects:

●Developed FAS (Financial Accounting System) such as Sales, Purchase, Challan, Order, Cash Book, Bank Book, Account Master, Account Group Master, Quotation Book and it’s Related Reports

●Developed Kerosene Distribution System at NIC (National Informatics Center) as Student Level at NIC Center, Bahumali Building, Nanpura, Surat

ITSKILLS

Database: Oracle 11g/10g/9i/8i, MS-Access

Languages: SQL, PL/SQL, vb.net, Vb6, VBA

Oracle GUI Tools: Oracle Developer Suite 10g /6i

SQL Utilities: Export & Import

Report Tools: Reports 10g/6i (D2K) Crystal Report 7,9,10

Office Applications: Microsoft Office 2007/2003/XP/2000/97(Word, Excel, PowerPoint, Access)

Operating Systems: Windows Server 2008-2003, OEL Linux 5, 6, DOS, Windows-7/VISTA/2003/XP/2000/NT/98

Query Tools: TOAD 9.x, PLSQL Developer 8.0, SQL*PLUS

OS: Windows 98, WinNT 4.0, Windows 2000 Server/Client

Languages: SQL-PLUS/SQL, HTML, ASP, FOXPRO

RDBMS: MS Access 97-2000-Xp, Oracle 8i, 9i, SQL Server 7.0-2000

GUI Tools: Developer Forms 4.5 / 5.0/ 6i, 10G, Visual Basic 6,VB.NET,VBA Prog. in Excel

Reporting Tools: Developer Reports 6i.10G, Crystal Reports 7- 8.5

PERSONAL DETAILS

Date of Birth: 1st Feb’1979

Address: 75/Pankajnagar Society, B/H Balajikrupa Society, Near PalanpurJakatnaka

Palanpurgam Road, Surat-395 009

Languages Known: English, Hindi and Gujarati

LinkedIn Profile https://in.linkedin.com/pub/chetan-gajjar/15/699/b92

Contact this candidate