# Project Management and Delivery

# Prepare Daily, Weekly & Monthly Reports, BAU task

# Database Design

# Trouble Shooting

# Performance Tuning

# Database Integrity

# Replication

# Maintenance Job

# Installation / Migration

# Backup & Recovery

# Job Scheduling

# Creation of Device / Segment / Database

# T-SQL , PL/SQL

# Import / Export

# Unix Shell Script

# Project Management

# Prepare daily, weekly and monthly reports

# Database Design

# Trouble Shooting

# Performance Tuning

# Database Integrity

# Replication

# dbcc, update statistics, reorg rebuild

# Installation / Migration

# Backup & Recovery

# Job Scheduling

# Creation of Device / Segment / Database & Database Objects (table, view etc.)

# T-SQL (stored procedure, trigger etc.)

# bcp

# Unix Shell Script

# Perl Script

# Database Clustering using Sybase OpenSwitch

# Production Support in Monitoring Tool using Geneos (working as Lead Admin)

TIBCO EMS Admin Jobs :-

# Broker Creation & Upgrade

# Creation of Topic / Queue / Route / Bridge etc

# Trouble Shooting

# Performance Tuning

# Load Balancing

# Monitoring Broker

Worked as a LIMS Consultant in the LabWare US Support Team, the role primarily involved providing Technical Support for LabWare LIMS product which runs on Oracle, SQL Server, Sybase. Provided technical support to various customers across different verticals like Healthcare, Oil & Gas, Manufacturing, Pharmaceutical, Food & Beverage etc.. Worked on Labware LIMS v 5.0.2.

Sr. Software Engineer in a team of 4 persons and involved in analysis of Power Builder codes & Development. The job included writing power builder code and back-end programming in Oracle 9i & SQL Server. Core product developer of LVL

Job included :

# Involved in analysis of Power Builder codes & Development.

# The job included writing power builder scripts and back-end programming in Oracle & SQL Server.

# Analysis of customer’s requirements, study of requisite enhancements and bug fixes, design and development of subsystems.

# Preparation & compilation of Change Impact & Test Script documents.

# Performed unit tests according to the Test Cases developed.

# Attended Customer queries and problems over e-mail/telephone and provided solutions / workarounds to customers worldwide.

# Prepared Daily, Weekly & Monthly Customer Support documents and circulated the same to concerned authorities.

Software Developer in a team of 22 persons and involved in analysis of Power Builder codes. The job included power builder code study, preparation of business logic written in front-end on the proposed system. Screen Design using JavaScript, Middle tier development including database interactivity using JSP,EJB. Tools using Oracle JDeveloper, Version Controller using PVCS, Application server using Oracle 9iAS and database using Oracle 9i.

The project is to prepare a proposal on the Management Information System for PWD Department (Govt. of Madhya Pradesh), which has number of offices in the State. The proposed system will help the management in timely acquiring the information from all the offices located in the state, which will help in taking timely and effective decisions. The system will link all the offices with the corporate office and automate their day to day operations.

ROLE : Leading a team of 5 persons and involved in analysis and designing of the prototypes. The job included system study, preparation of Data Flow Diagrams, Entity Relationship Diagrams, Table Structures, Screen designing & development using Developer 2000, module identifications and preparation of technical write up on the proposed system. Screen using Forms 6i & reports using Reports 6i. Created tables, indexes, database stored procedures and triggers on PL/SQL.