Chetan Gajjar
Contact: +919*********/+919*********
E-Mail: *********@*****.***, *********@*******.***
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