Maintenance Pvt Ltd

Master of Computer Application having *.* Yrs of experience as Database developer cum administrator in Informix 11.70

Working with Synova Innovative Pvt Ltd and Contractor For IBM Banglore

Working on IBM Informix 11.70 as well as 11.50, Informix 4GL and Oracle 10G

Designing database in IBM Informix 11.70 (i.e. create store procedure, trigger, view-queries, Functions, Database design and maintenance)

Worked on Oracle sqlplus loader utility.

Automated backups using a combination of full, incremental ontape backup utility.

Maintaining Transactional logical log backups

Export/Import of Informix databases.

Load/Unload of Informix database as well as tables.

Maintenance of production database & development database which includes dbspace space management, user creation, privileges, roles etc.

Tracing, troubleshooting with database performance and tuning issues.

Tuning SQL queries

Informix Enterprise replication development & maintenance.

Strong in the complete Software Development Life Cycle (SDLC) including requirements analysis, design, programming / testing and implementation of major systems.

Learner, Sharing, Good grasping capability.

Good communication & Interpersonal skills and the ability to work in a team environment.

ACADEMIC QUALIFICATIONS:

Bachelor of Science (B.Sc.) from North Maharashtra University in the year 2005.

MCA (Master of Computer Applications) from Pune university in 2008

CERTIFICATION

1Z0-007 Oracle certification in FEB-2011.

IBM Informix System Administrator certification In June 2013.

TRAINING

DBA track admin-I course in 2010 from seed-InfoTech, Pune.

IBM Informix Performance tuning seminar in June 2013 Mumbai.

TECHNICAL SKILLS

§Language: C, C++, Coré Java, HTML

§Database: SQL SERVER 2005, Informix 11.70, ORACLE 10G XE

§Operating System: Windows 2008, XP, 7, Linux, Unix

EXPERIENCE

Tenure Organization, Place Designation

18th Mar 14 to till date Synova Innovative Technologies Pvt Ltd Application Developer 17th Mar 11 to 11th Mar 14 Avanti Software Solutions Pvt Ltd, Pune Database Developer 01st Jan 08 to 31st May 08 Daccess Security Systems, Pune. Trainee 13th July 09 to 30th Apr 10 K.Narkhede Jr. College, Bhusawal Lecturer

WORK EXPERIENCE:

PROJECT:1

Name : AT&T (16 Layer A links to 5ESS-PUSH switches)

Duration : April 15 to till date

Role : Database Implementation(informix 4gl)

Organization : IBM India Pvt Ltd. Banglore

Environment : Informix 11.50, informix 4gl, Unix

Responsibilities

•Designed and implemented modifications in production and tracking systems.

•Programmed and updated forms and functions with Informix 4GL

•Executed test changes for existing systems as per business needs.

•Analyzed and resolved application development issues and maintenance problems.

•Created Tables, Constraints, Indexes, Privileges, Roles, Cursors, sequences, synonyms.

•Granted resources, privileges and roles to users

•Developed Stored Procedures, Functions & database Triggers

PROJECT:1

Name : AT & T (Windows Upgrade Phase2)

Duration : November 14 to March 15

Role : Database Implementation (PL SQL)

Organization : IBM India Pvt Ltd Banglore

Windows Migration : Migrate crystal reports to Ms Excel using Perl scripting and Oracle database.

Environment : Oracle 10G, MS SQL Server, Windows server 2003, MS- Office, UNIX (Putty), Perl Scripts

Responsibilities :

•Migrated existing sql server tables to oracle and crystal report to MS Excel using Perl scripting.

•Worked on sqlldr using shell scripting to load data from flat file to Oracle database.

•Took the initiative and migrated more than 80 existing Crystal reports to Excel reports using Perl scripting and Oracle database

•Used Perl Scripting and shell scripting to display report in required report format.

•Developed the UNIX scripts using KORN shell to automate jobs.

•Migrated the application from Non-relational to relational database application..

•Used FTP(File Transfer Protocol) for download report Ms Excel file in windows server.

•Worked with users on application problems. When these problems were the result of code bugs, fixed the bugs and worked with quality assurance analysts to verify the corrections.

•Trained new developer to assist in ongoing system support and maintenance.

PROJECT:3

Name : AT & T (LIDBIB)

Duration : Jun 14 to till date

Role : Database Implementation (PL SQL)

Organization : IBM India Pvt Ltd Banglore

LIDBIB : Added New service LIDBIB to existing application

Environment : Informix 11.50, SQL, PL/SQL, Unix, Informix 4GL

Responsibilities :

•Designed and implemented modifications in production

•Programmed and updated forms and functions with Informix 4GL

•Executed test changes for existing systems as per business needs.

•Updated stand alone programs and developed test plans.

•Database Refresh

PROJECT:4

Name : AT & T (SOP-P)

Duration : Mar 14 to Sept 14

Role : Database Implementation (PL SQL)

Organization : IBM India Pvt Ltd Banglore

SOP-P Project : Its a telecom project in that, I worked for Migrate the user id to another user id using procedures and as per requirement give the permissions for desired users.

Environment : Informix 11.50, 4GL, SQL, PL/SQL, Unix

Responsibilities :

•Database Refresh

•Programmed and updated forms and functions with Informix 4GL

•Implement and maintain database security (create and maintain users and roles, assign privileges).

•Work on database objects like Procedures, Functions, SQL etc

PROJECT: 5

Name : LBT(Local Tax Body)

Duration : Jan 13 to Mar 14

Role : Database Design, Implementation (PL SQL, Query Tuning) & Maintenance

Organization : Avanti Software Solution Pvt. Ltd. Pune.

LBT (Local Body Tax) Project: Local Body Tax is online interactions between Municipal corporation and vendor’s who import export different goods to one place to another place, Municipal corporation and employees and Municipal corporation and government

Environment : Informix Server 11.70, 4GL, SQL, PL/SQL, Windows 8, XP, 2003, Linux Oracle 10g

Responsibilities:

•Installation, configuration and upgrading of IBM Informix server software and related products and creation of databases

•Implemented table partitioning to improve performance and data management.

•Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.

•Assists with impact analysis of any changes made to the database objects.

•Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

•Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.

•Implement and maintain database security (create and maintain users and roles, assign privileges).

•Maintain Backup & restore using ontape, Import, Export, load, unload utility.

•Maintain Logical Log backup.

•Maintain space management.

PROJECT: 6

Name : Retail Management System for Sweet Mart shop

Duration : May 2012 -Dec 2012

Role : Database Migration, Implementation (PL/SQL, Query Tuning) & Maintenance

Organization : Avanti Software Solution Pvt. Ltd. Pune.

Detail Description : The Retail Management System developed for Sweet Mart Shop. It is the

Application developed to fulfill requirements of owner and customer.

Database design & administration as per customer’s business cycle like Sales, purchase, purchase order entries in the database. Retrieving reports from the database as Stock of items as per item name wise, item category wise; Stock of item as per from date to date wise; Item name wise sales stock, purchase stock, opening item stocks & closing balance stock; Supplier name wise purchase item quantity & their details.

Platform : Informix, SQL Server 2005

Responsibilities:

•Installation, configuration and upgrading of IBM Informix server / SQL Server software and related products and creation of databases

•Migrate database from SQL Server 2005 to Informix 11.70.

•Developed Informix Enterprise replication & its maintenance.

•Implement and maintain database security (create and maintain users and roles, assign privileges).

•Maintain Backup & restore using ontape, Import, Export, load, unload utility.

•Maintain Logical Log backup.

PROJECT: 7

Name : Egovernance for Corporation

Duration : Jan 12- May 12

Role : Database Design, Implementation (PL SQL, Query Tuning) & Maintenance

Organization : Avanti Software Solution Pvt. Ltd. Pune.

Detail Description : The Egovernance is developed for the Municipal Corporation. It is the

Application developed to fulfill requirements of owner and customer.

Database design & administration as per customer’s business cycle like Property tax, Water Tax, CFC (Citizen Facilitation Center) entries in the database. Retrieving reports from the database.

Platform : Informix, Oracle 10g

Responsibilities:

Installation, configuration and upgrading of Informix software and related products and creation of database

Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.

Assists with impact analysis of any changes made to the database objects.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

Performs database re-organizations as required to assist performance and ensure maximum up time of the database.

Implement and maintain database security (create and maintain users and roles, assign privileges).

PROJECT: 8

Name : Gate Pass for private organization

Duration : November 11 to December 11

Role : Database Design, Implementation & Maintenance

Organization : Avanti Software Solution Pvt. Ltd. Pune.

Detail Description : The Gate Pass is developed for the private organization system for security purpose. It is the application developed to fulfill requirements of owner and customer.

Platform : Informix 11.70

Responsibilities:

Installation, configuration and upgrading of IBM Informix server software and related products and creation of databases

Assists with impact analysis of any changes made to the database objects.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.

Implement and maintain database security (create and maintain users and roles, assign privileges).

PROJECT: 9

Name : Library Management System

Duration : May 11 – Oct 11

Role : Database Design, Implementation (PL SQL, Query Tuning) & Maintenance

Organization : Avanti Software Solution Pvt. Ltd. Pune.

Detail Description: The Library Management System is developed for the Government Library. It is the

Application developed to fulfill requirements of owner and customer.

Database design & administration as per customer’s business cycle like Book information, Member information, Issue of book entry, Return book entry, Periodic books entry, Membership Renewal, Close membership details transaction entries & their supporting master forms entries in the database. Retrieving reports from the database as Library member wise issue books & periodical books details, Library member wise return books & periodical books details, Available books & periodical books details.

Platform : Informix 11.70

Responsibilities:

Study of Informix server software.

Installation, configuration and upgrading of Informix server software and related products and creation of databases

Performs ongoing tuning of the database instances.

Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

Implement and maintain database security (create and maintain users and roles, assign privileges).

Personal Information

ØDate of Birth : 22nd May 1985

ØPassport No : J4315998

ØPAN no : BAYPM3454P

ØAddress : Flat No. 302 Shakti Nilayam, Nandini Layout, Yashwantpur, Banglore -560096

ØMob No : 096********, 077********

ØEmail id : *****************@*****.***

ØLanguages : Marathi, English, Hindi

ØReferences : Available on request

Contact this candidate