MITALI SHAH
abmrls@r.postjobfree.com
** *** ****** ****, #****, San Jose, CA - 95134
Phone #: 908-***-****
QUALIFICATIONS
> 4 years of strong technical support experience in the software industry.
> 3+ years of experience in writing SQL queries.
> Experience in refreshing and manipulating data in tables using PL/SQL
procedures.
> Experience in maintaining and monitoring databases by Oracle Enterprise
Manager (OEM)
> Performance tuning of SQL queries and advising the application programmer
of the opportunities in tuning the application
> Extensive experience in setup, configuration, upgrade, maintenance,
performance monitoring and troubleshooting on different platforms like
Sun Solaris, Linux, HP-UX, AIX and Windows
> Involved in writing SOPs
> Excellent interaction with global and cross functional teams.
> Ability to bridge the gap between business needs and technology
> Excelled in performance while under pressure and met deadlines in high
demand client oriented environment
Work Experience
Sanofi-Aventis Pharmaceuticals, USA
Apr 07-Present
Sanofi-Aventis is dedicated to improve life by treating and preventing
human disease through the discovery and development of innovative
pharmaceutical products.
> Application Support Analyst
. Installing and Configuring Oracle 9i/10g database
. Understanding the existing Database Structure and suggesting the database
reorganization
. Installation and maintenance of Oracle database application software
which includes creation of database, installation/maintenance of Oracle
objects (function, procedure, views, packages)
. Designed and Implemented database security using and Oracle roles
privileges
. Created and maintained Databases and their objects like tablespaces,
datafile, redo groups, tables, indexes, views, materialized view etc
. Helped developer to install Oracle Client, troubleshoot and establish the
connection to Oracle database
. Installed and Configured Clinical software Clintrial 4.X and Clintrace
2.X .To manage user access rights and parameters, to query the database,
to manage coding dictionaries and to code data
. Support all production Clinical Data Management Oracle 9.X/10.X database
applications worldwide, clients use these database applications for FDA
approval
. Currently working on Pharmacovigilance Drug Safety System called AWARE
(Aware is a AERS application from Oracle) to create, modify and
inactivate access to the application. Initiate or authorize change
control for the application. Being involved in the maintenance of the
validated status during the operation phase (change control process and
anomaly management)
. Troubleshoot Database performance issues using Automated Workload
Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
. Monitoring Alert Log Files
. Created various OS authenticated users on the databases
. Supporting web-based customised application for the different
business needs.
Responsibilities include:
. Work with the end user for their application access
issue
. Help users to write SQL queries in Oracle database
. Manage global user application issues, requests and resolution using
ticket tracking system HP OpenView
. Provide training to end users on Oracle applications
. Maintaining internal case study database(KBD) which can help the team for
future issue
. Run weekly/monthly pre-defined reports using Oracle
Sqlplus/Toad
. Involved in extensive design of sql and shell scripts
. Maintenance and support of Oracle Clinical v4.5.1
. Citrix metaframe presentation server administration
Global Documentum based application: It is used for the management and
storage of product related documents that needs to be retained for a longer
period. It also supports the development of submission related documents
and publishing of reports in a validated compliant system.
. Currently working on GDMS being involved in the maintenance of the
validated status during the operation phase (change control process and
anomaly management)
. Supporting CRF Workflow application, designed to capture Case Report Form
(CRF) images via scanning or Faxing. Troubleshoot the issues related to
CRF Submission, Refax Management, PDF Generation.
. Working with Network Administrators to fix issues that occur
with LDAP synch job
. Administrating and maintaining the blogs of Research and
Development
System/Application Testing:
. Wrote and executed system test cases, performed installation,
qualification and UA Testing
. Tested application security features, including session expiry, passwords
and compatibility across multiple browser types and encryption levels
. Designed test plans and defined cases for functional,
integration system, and user acceptance testing
Environment and Tools: Windows 2000 Server, Oracle 10g/8i/9i, TOAD,
Documentum 5.X suite, MS SQL Server 2000, SQL Plus, Apache Tomcat
Viru Electronics, INDIA
Jan 05-Jan 06
Viru Electronics is renowned organization in the field of hardware and
technology. It has the best servers, and advanced technology to offer.
> Technical Support Analyst
. Actively participated in gathering of user requirement and system
specification
. Managing security, which includes monitoring and controlling database
access, assigning permissions to application owners
. Helped developer to install Oracle Client, troubleshoot and establish the
connection to Oracle database
. Provide technical support on UNIX and Oracle related issues
Environment and Tools: Windows 2000 Server, Oracle 8i/9i, PL/SQL, SQL Plus
SKILLS
Technical: Personal:
Technologies: PL/SQL, C/C++, Visual Basic, Excellent analytical, leadership
HTML, Matlab and communication skills
Databases: Oracle 10g/8i/9i, MS SQL Server, Organized, self starter and hard
MySQL 4.0 worker
Web Server: Apache, Oracle Application Multi-tasker with a strong sense
Server, Netscape Enterprise Server, and IIS of responsibility
Reporting Tool: Crystal Reports 4.5, Oracle Productive as both individual
Reports 3.0 contributor and team member
Documentum 5: Documentum 4i/5.X, Documentum
Content Server 5.2.5/5.3
OS: Unix, HP-UX, SunOS, VAX/VMS, Windows
Protocols: TCP/IP,UDP,HTTP
Tools: MS Excel, Word, Visio, Outlook,
PowerPoint, MS project
EDUCATION
M.S, Electrical Engineering University
of Bridgeport, CT GPA 3.7
B.S, Instrumentation and Control Engineering S.V.I.T, Gujarat
University, India GPA 3.7
[pic]