Application/Production Support in Oracle & UNIX, 5+ years, telecommute

Nisha Mishra

Email: ******.*****@*****.***

Contact Number -203-***-****

Cell Number -203-***-****

Experience Summary:

An experienced IT professional with Masters in Computer Science and OCA(Oracle Certified Associate) , Support Analyst with 5+ years working experience in production support, development and administering databases. Proven ability to identify problem, analyze possible solutions and determine best course of action to meet objectives

• Strong technical background with approximately 5 years of Production Support and solid project experience in SQL, PL/SQL, ORACLE 9i , UNIX,SHELL SCRIPTING , PERL SCRIPTING .

• Roles: Production Support Analyst , Oracle Developer and Administrator

• Knowledge of web technologies like HTM, Java and XML as required for database management

• Experience in Database design on the basis of URD as well as normalization of databases.

• Experience in application development and production support of large and critical network with 24/7 uptime.

• Conversant with ISO 9001 quality procedures, while executing projects.

• Good understanding and expertise of the Software development life cycle.

Certifications:

1Z0-007 - Introduction to Oracle 9i SQL

1ZO-047 - Oracle Database SQL Expert

1Z0-031 - Fundamentals of Database Administration – I

Technical Skills:

Operating Systems UNIX, Windows, SOLARIS

Languages SQL and Pl/Sql, Shell Scripting, Perl, JAVA

Database Oracle 9i

Web Technologies JAVA HTML XML XSLT

Tools and Utilities TOAD, PUTTY, AUTOSYS, SQL DEVELOPER, SQL LOADER

Educational Qualification:

Masters in Computer Application (MCA) - Cochin University of Science and Technology, Cochin, India

Bachelors in Mathematics (Honours) - Benaras Hindu University, Varanasi, India

Training Details:

Sl.# Title Location Organized by Duration

1 Entry Level Technology Program Hyderabad Satyam Computer Services Ltd 10 Weeks

2 TIBCO Training Program Pune Symantec Corporation 12 Weeks

Tibco Training Details:

I have gone through a 12 weeks training on TIBCO in Symantec Corporation on Rendezvous BW Designer, Tibco Administrator and JMS Server.

The training included the implementation of projects on the TIBCO suite. This also covered the basics of the messaging concepts like point to point, publisher subscriber etc. and certified messaging.

PROJECTS

CLIENT UBS Securities LLC DATE JUNE 2011 to Till Date

MODULE COMMODITIES TRADING SUPPORT

ENVIRONMENT UNIX

Project Description: Support the trading environment for the commodities group and ensure that all the trades are flowing as per requirement from Logical Information Management (LIM) to Commodity XL (CXL).

Responsibilities:

• Primarily involved in supporting loading the trades as and when requested by the traders

• Responsible for coordinating with the IT and equities and update any requests by being a part of the global service desk for the Commodity Support

CLIENT ADVANS IT DATE MAR 2010 to MAY 2010

MODULE Database Support and Administration

ENVIRONMENT UNIX, TOAD, ORACLE, SQL,

Project Description: Advans Social CRM, also called as fundraising system, is a social CRM for advancement with multi-organization, multi-currency, multi-lingual web based donor/alumni/member management system based on scalable architecture. The project was about developing a web application to facilitate donations and charity services. It can be used by both, the NGOs, the end receivers as well as the individuals and institutions who are involved in charity and donation services. It facilitates right from raising request for a donation till maintenance of all the records like gifts and donations of an entity for future reference.

Responsibilities:

• Primarily involved in development and administering of the database for this application.

• Responsible for coordinating with the front end team and resolving their issues with regards to the database.

• Contributed in the design of the application, reducing the inherent complexities of PHP.

• Post production supported the project with any upcoming issues with the Oracle database packages and procedures

• Provided support to the front end developers for technical issues which might come across .

• Coordinate with the team at onsite for a smooth deployment ,any change management or production issues .

CLIENT GSK (Under Mahindra Satyam) DATE FEB 2007 to MAR 2010

MODULE Production Support and Enhancement

ENVIRONMENT SQL, PL/SQL, ORACLE, UNIX, TOAD,PERL , SHELL SCRIPTING , XML ,XSLT

PROJECT Foundation DataWarehouse and Integration Hub

Project Description: This project was a data warehouse where we were loading data to a database using SQL Loader and further using the Oracle backend procedures and packages .It was critical to the business as it was dealing with the financial data for the client . In case of any issues arising in the running of the application, the team members need to identify the cause of the failure and also the solution to it and update its status at regular intervals .The applications Hub and FDW receive data from numerous other applications, process them and then send the data to several other applications for further processing and reporting.

Responsibilities:

• The core role was to keep the applications up 24/7 and to be in touch with administrators and users to help them and to resolve server and application related issues.

• Involved in the preparation & planning of incident, risk and change management procedural documentation for clients.

• Understanding and Troubleshooting complex customer issues on production environment. Responsible for identifying any bugs occurring in the applications as well as fixing them.

• Critical Situation Analyst: Defused hot situations and got quick technical resolution, skills in Customer Management. Identify the issue and either resolve or escalate to the appropriate team responsible for the components affected

• Exposure to all stages of Software Development Life Cycle.

• Take back ups of the database everyday using the export functionalities.

• Refresh the databases from production instances using export and import functionalities .

• Plan implementation of new applications as required and creation of reports for the business users.

• Analysis of Unix scripts , Oracle backend packages and procedures , scheduling of jobs through cron jobs etc in case of any failures .

• Key Responsibilities as part of daily activities as follows:-

a) Check email Alerts, Notification mails and any tickets in queue with their priority

b) If any jobs running for longer time. Check why stored procedure/jobs are taking lot of time to run .

c) Create Tables/Stored Procedures/Triggers/Views

d) Modify/create Unix scripts for scheduling various data cleansing scripts and loading process

e) Work on all issues related to database and Unix scripts

CLIENT SYMANTEC (Under Mahindra Satyam) DATE JAN 2006 to OCT 2006

MODULE Application Development

ENVIRONMENT SQL, PL/SQL, ORACLE, WINDOWS, TOAD, J2EE, NETBEANS

PROJECT Dashboard Application System

Project Description: The Dashboard Application System was a development project. This application took care of the project related information, associated with the group. In this the user can read or update the data related to the Project e.g. updating of details, allocating or removing or reallocating of the associate from the project. The access right in the Dashboard Application System is role specific and a user can have multiple roles. A user accessing a particular role can only view update, delete and insert data based on his privileges defined.

Responsibilities:

• Analysis of User Requirements

• Database design on the basis of URD

• Writing stored procedures, cursors, triggers required for the application.

• Identifying the normalized tables and indexes

ACHIEVEMENTS

I have received several appreciations from clients as well as within organization for the day to day project tasks.

I delivered BDP (Benefits Delivery Plan) for GSK for improving their application which was well recognized.

I received POB (Pats On Back) award from Mahindra Satyam for extraordinary performance in the project.

VISA STATUS: L2, EAD

References: Provided if required.

Contact this candidate