Swetal Gajjar

  • gajjar.swetal@gmail.com

Work History

Work History
May 2011 - Present

Lead Database Architect

iNDx Technologies INDIA Pvt. Ltd.
  • Understand and compile customer requirements into requirement documents, presentations and wire-frames.
  • Grouping and prioritizing the tasks for development and testing and creating a project plan for the same.
  • Handling customers demo single handedly.
  • Interacting with various third party vendors working on various software components.
  • Implemented and managed automated code testing and deployment to test, development and production environments using Hudson.
  • Designed and implemented database designs as per customer's business requirements.
  • Tracking of database activities on regular basis to foresee any possible issue.
  • Daily backups of the production database using oracle's data-pump tool. This process was automated using crown jobs in Linux.
  • Troubleshooting performance related issues in the database designs and/or database configurations encountered due to any major change requests.
May 2011 - Oct 2010

Senior Application Engineer

Oracle Corporations

Development Activities

  • Designed and developed various modules to add to the product functional productivity.

  • Designed and developed upgrade process for upgrading previous versions of the product at client site (Production) to the current version.

  • Designed and developed migration process for upgrading previous versions of the product at client site (Production) to the current version.

  • Code Reviews.

DBA Activities

  • Performance tuned database using various oracle initialization parameters.

  • Optimized BAD SQLs causing poor performance of the applications. Used tools like Oracle Enterprise Manager and stat pack reports for the same.

  • Cold Backups.

  • Managing Oracle Databases.

  • Implementing Oracle automatic tuning features.

  • Installing and running more than one Oracle versions on a server with databases running for every Oracle version simultaneously.

Support Activities

  • Fixed data issues on Client’s Development and Production Databases.

  • Analyzed and fixed various challenging issues reported by client well in time.

  • Created patches and release notes for the resolved issued reported by the client.

Jun 2006 - Sep 2010

Senior Software Developer

Phase Forward Inc

Development Activities

  • Designed and Developed Web extension of Waban LIMS for clients in Oracle Application Express.

  • Developed Web extension of WabanSCE for clients in Oracle Application Express.

  • Developing Waban SMS Web application using Oracle Application Express.

  • Developed few pilot projects using Oracle Application Express.

  • Maintaining and controlling changes to database objects using Sybase Power Design Model.

  • Reviewing, Implementing and Testing changes done to existing Waban LIMS database installation scripts.

  • Redeveloped an application with database for testing team in Microsoft Access 2007.

  • Code Reviews.

DBA Activities

  • Performance tuned database using various oracle initialization parameters.

  • Optimized BAD SQLs causing poor performance of the applications. Used tools like Oracle Enterprise Manager and stat pack reports for the same.

  • Load Testing Waban SCE to determine software bottle necks.

  • Cold Backups.

  • Managing Oracle Databases.

  • Implementing Oracle automatic tuning features.

  • Upgrading Oracle 9i Databases to Oracle 10g

  • Installing and running more than one Oracle versions on a server with databases running for every Oracle version simultaneously.

Support Activities

  • Fixed data issues on Client’s Development and Production Databases.

  • Analyzed and fixed various challenging issues reported by client well in time.

  • Created patches and release notes for the resolved issued reported by the client.

Jun 2005 - May 2006

Programmer Analyst

CRISIL Mumbai
  • Converted few two TIRE applications to N-TIRE applications using Visual Basic & Oracle 8i/9i.

  • Analyze and Improve the Performance of Software (Performance Tuning in Oracle Server 8i/9i)

  • Analyze and Design new Software as per the Business Requirements. (Study Business & User Requirements and prepare Required Process Flow and also design a feasible approach for automated system that can be built.)

Mar 2003 - Jun 2005

Software Executive

Appeline Cosmetics And Toiletries Limited
  • Designed software for Purchase System which was from completely manual till then. It is a Server/Client based application developed in Visual Basic 6.0 & Oracle 9i. It is a highly secured application & also generated enquiry letters, Purchase Orders & maintains everything right from Delivery Schedules & History to Payments & Invoices. Also It keeps track of Market Fluctuations, and other such activities. The Software was developed using Visual Basic 6.0 & Oracle 9i.

  • The project is based on Server Client Concept and handles complete database of the company related to the Sales & Transfer of products within & outside Country, manufactured by that group of companies. It is highly secured package that handles everything right from maintaining item list to generating invoices & maintaining Payment details. Invoices are prepared according to the taxes applicable on different items in different state. The Software was developed using Visual Basic 6.0 & Oracle 9i.

  • The project is based on Server Client Concept and handles complete Database of the employees in an organization. The inputs are given from Finger Print Readers and Digital Cameras. It calculates the total working hours and generates a salary slip at the end of every month. It also generates many required official documents like Appointment Letters, Joining Letters/Reports, Transfer / Suspension / Termination Letters. Performance Report for every Employee is also generated on a quarterly and as and when required basis. The Software was developed using Visual Basic 6.0 & Oracle 9i.

  • Also looked after the Design and Maintenance of Hardware & Networking of the company in various branches across country.

Apr 2001 - Mar 2002

Software Consultant

BEC Chemicals Limited
  • Designed and Implemented OFFICE AUTOMATION system. The system was designed in Microsoft Excel using various Macros & VBA Application. The project handles complete data right from Raw materials purchased to the production of finished goods, process details, daily as well as monthly & till date reports generation. It keeps track of Stores, Engineering Workshop, & Accounts and generates timely reports accordingly. It also generates Salary slip at the end of the last day of the month.

Apr 2000 - Mar 2001

Software Consultant

Bakul Aromatics & Chemicals Limited
  • Designed & Implemented OFFICE AUTOMATION system.

    The Software was developed using Lotus 123 as per customer’s request.

    The project handles complete data right from Raw materials purchased to the production of finished goods, process details, daily as well as monthly & till date reports generation. It keeps track of Stores, Engineering Workshop, & Accounts and generates timely reports accordingly. It also generates Salary slip at the end of the last day of the month.

  • Also Maintained Hardware of the Company for the Contract Period.

  • Provided General Computer Awareness and Utility training to Employees.

Education

Education
Jul 1996 - Jul 2001

Bachelor of Engineering in Computers

Mahatma Gandhi Mission College Of Engineering and Technology. Navi Mumbai. Mumbai University.

Skills

Skills

Operating Systems

Linux, MS-Dos, Windows

Routine Packages

MS Office, Open Office, Microsoft Visio, Sybase Power Designer, Microsoft Project.

Development Packages

Oracle Application Express, Visual Basic, Crystal Reports, C, C++, HTML, SeleniumHQ, Hudson

Database

Oracle 8/8i/9i/10g/11i, MS-SQL, SQLITE, MS-Access, MongoDB