Vaishali Bhatia
15088700755
135 East main Street K10, westborough MA 01581
Current Location: US
Title: / SQL/PLSQL Programmer and Oracle DBAWork Experience: / 5 years
Skills: / SQl, PLSQL, JAVA, JDBC, Oracle, SQL Server, Dreamweaver, HTML, XML, Oracle Portal
Industry: / Consultancy,IT/ Computers Software
Highest Degree Held: / B.E/B.Tech (Computers) ,IETE
Gender: / Female
Date of Birth: / 31st August 1975
Detailed Resume:
Vaishali Bhatia
Have 5+ years of strong experience in Information Technology in development, Analysis, Administration, Implementing, Testing and maintaining of E-commerce, B2B Portals, web Portals and Oracle Database Developer, data modeling, data architect, DBA using Oracle7.x/8.1.5/8.1.6, Oracle 9i, Oracle 9iAS, PL/SQL, SQL, OLAP, WebDB Unix shell scripts, SQL server, Sybase 11.x, Java, J2EE, JDBC, XHTML, XML, XSL, HTML, DHTML, SOAP, JavaScripts, CSS, Macromedia Dream weaver 4.0, Macromedia Fireworks 5.0, Flash 5.0, front page 2000, GIF animator, Adobe photoshop6.0, ODBC and IBM Technologies (Visual age for Java, Web sphere 3.5./4.0, HTTP Server 1.3.19). Extensively worked on SQL, PL/SQL and Unix shell scripts to write maintenance script for Oracle and System administration in UNIX. Involved in Oracle Server Administration, Advanced Replication Server, Parallel Server, Multidimensional database, Distributed Database system study, analysis, design, development, testing and implementation with expertise in online transaction processing (OLTP) and multi-user systems involving large and distributed databases. Used utilities like SVRMGR30, Oracle Database Assistance, Oracle Enterprise Manager, and TKPROF for monitoring database performance. Hands on experience in ORADIM, ORACLE Net 8 Assistance, ORAPWD, and LSNRTC. Performed database backup and recovery using OCOPY80, RMAN, mirroring Redo log, Hot, Cold, NT and EXP/IMP. Worked with Pharmaceutical ,Financial and telecom clients like Wachovia Securities, Charles Schwab & co,Verizon wireless Inc, and exposed to FDA regulations and 21 CRF part11.
Skills Summary
Hardware & OS Front-end & Backend Languages Tools
Intel X86 Systems Windows NT 4.0/2000Professional/ Advanced Server Windows 95/ 98,Unix AIX 4.3.3 C, HTML, HTML, DHTML, Oracle 8i Server Administration, Sybase, DB2, SQL PL/SQL, Office 2000. C, C++, Java 2, Java Scripts, J2EE Java Servlets Java Script, VB Script, C, C++, HTML, DHTML, SQL/PLSQL PL/SQL, SQL*PLUS 3.3/8.0/8.1.5/8.1.6, TKPROF, SVRMGR30, Oracle Net 8Assistance,Oracle Enterprise Manager, Oracle Replication Server, Oracle Database Assistance, EXP/IMP, SQL Loader, Performance Tuning by using TKPROF as well as Clustering and Indexing, Backup/Recovery, OLAP, WEBDB. In Sybase whole Sybase GUI and command level SQLs on Unix. Transact SQL for SYBASE. JDBC, Dreamweaver3.0/4.0, Fireworks 4.0.Adobe PhotoShop 5.5. Jrun3.0 Microsoft Visual Studio 6.0Visio 2000. Visual Source Safe
Wachovia Securities, NC Oct 02 -- Till date
Description:
Wachovia Securities developed this system to monitor the Credit risk, which is evitable risk, faced by Wachovia Securities and other lending institutions entering into loan contracts. Credit risk is a risk that arises if a counter party does not honor or fails to fulfill his contractual obligation. To minimize the impact of credit risk Wachovia Securities offers Credit Derivatives. The Loan Contract systems keeps track of the various kind of Credit Derivatives sold to the customers and at what price. Wachovia Securities currently offers the following different types of credit derivatives: Credit Default Swaps, Credit Spread Option, Credit-Linked Notes (CLN), Total Return on Swap. As a DBA/ Developer/ Data Modeler/Architect in Oracle 8i and Oracle 9i with Oracle 9i application server (Oracle 9iAS), Designing database, developing PL/SQL and maintaining database in Oracle Parallel Servers environment. Implementation of the test strategy to the actual Database. Wrote PL/SQL blocks, Stored Procedures, Functions, Packages. Conversion from access to Oracle Metasolv schemas. Using SQL LOADER utilities migrate flat files to database. Wrote Unix shell scripts for automation. Activities involved in Monitoring, Tuning, auditing users, assigning roles and privileges, backup and recovery. Involved in partition designing and tablespace and table partitioning for data warehousing purpose using Oracle 9i, Oracle 8i, SQL, PL/SQL, Core Java, MQ series, JDBC APIs. Java script, XML, XSL, HTML, DHTML, J2EE (JSP-Servlets-EJB) and Unix shell scripts.
Environment:
Unix, HP-UX, Sun Solaris / NT, Oracle 8.1.7/9i, Oracle 9iAS, 9i App Server, PL/SQL, SQL, Unix Shell Scripts, OEM, Java, J2EE, Java script, XML, XSL, HTML, DHTML, JSP, Servlets, EJB, SQL SERVER 2000, Sybase, Microsoft Management Console, ERWIN4.0, SQL LOADER, EXP/IMP, SQL NAVIGATOR, TOAD, MS VISIO, Business Objects,oracle PDK
RESPONSIBILITIES:
• Involved in designing database, developing PL/SQL and maintaining database.
• Creation/Configuration of Oracle databases under different environments like Production /Development / Testing
• Upgrade, Migration of Oracle software and database from Oracle 8.1.6 to Oracle 9.0.1
• Created tables, indexes, and queries, stored procedures to implement the desired functionality-using PL/SQL in Oracle.
• Design and create Data warehouse schema using Star Schema methodology and program for ETL functions using Informatica
• Production database trouble shooting after analysis of Alert logs and trace files that support OLTP applications.
• Wrote Portlets using Oracle PDK (Portal development kit) for Java (Jdeveloper) and SQL/PLSQL.
• Created Portal Pages, which are dynamically assembled and formatted according to the portlets and layout chosen for the page, thus ensuring access to the very latest information.
• Automated many UNIX maintenance tasks by writing scripts and programs, also evaluated existing Korn Shell scripts and enhanced the performance of them
• Customized Portal gadgets provided my Oracle as per the Customer requirements.
• Customized the Reports portlet to have custom layouts, which can display report data in a tabular layout (all table or view rows display in a single box) or form layout (data from each row displays in a separate box on the form). You can also use color, fonts to conditionally highlight particular rows and columns in reports.
• User management on UNIX/Unix Administration- providing requested working environment to users, adding/deleting users, resource allocation to users, user account maintenance & accounting of users.
• Involved in Monitoring, tuning & auditing users, assigning roles & privileges to the users.
• Developed a backup and recovery test strategy based on Company rules taking into account the existing hardware resources.
• Involved in conversion/migration of database from access to Oracle. Wrote PL/SQL blocks, Procedures, Functions, Packages. Conversion from access to Oracle schemas. Using SQL LOADER utilities migrate flat files to database.
• Worked with tables creation, Index analysis, Turning, PL/SQL, Stored Procedure, Trigger development, Rules and Defaults.
• Wrote several UNIX Shell scripts to automate the process of analyzing the alert logs, trace dump files and send pager messages if any errors were written to these files and also to check various critical database parameters.
• Wrote Unix Shell scripts for tracking the outputs of the objects
• Wrote UNIX shell scripts for automation activities involved monitoring, tuning, auditing users, assigning roles and privileges, backup and recovery.
• Used PL/SQL packages, worked on query optimization, data migration and loading.
• Implemented the oracle Replication using the Snapshots, Multi-master and refresh groups.
• Extensively involved in tuning Sql code, database tuning.
• Setup and implementation of backup and recovery procedures for databases using Verities Net backup, RMAN, Log miner.
• Involved in configuration and implementation of RMAN utility (Oracle 8i/Oracle 9i) for backups and recovery.
• Configured and implemented the Oracle Standby databases.
• SQL Query Tuning and Optimization for improving response time using Explain Plan, SQL Trace and TKPROF.
• SQL*NET /Net * 8 connectivity/ Names server configuration for client server connectivity.
• SQL tables were created with referential integrity and queries were developed using SQL, SQL*PLUS and PL/SQL
• Moved the business logic for all the Java Applications from their Interfaces to the Oracle Server by writing Packages, Functions and Procedures in PL/SQL with good error handling routines
• Used HTML/DHTML/ XHTML /JavaScript /CSS for front-end development
• Generate static and Dynamic pages by using JSP, XML, XSL and HTML
• Wrote Connection Pooling utility using Core Java and JDBC APIs.
• Designed and coded JSP pages, Java Servlets for different user interactive Web pages
• Involved in partitioning, allocating table space and table partitioning for data warehousing purpose.
• Involved in creating/moving/migrating databases, restoring database from a disk corruption, configuring for distributed databases, scheduling jobs, and automating the routine tasks using Shell/SQL * Plus/OEM event scheduler.
• Involved in load testing and capacity planning of the Production/Development databases.
• Involved in loading the data using SQL LOADER utility, importing and exporting database.
Verizon wireless Inc. TX Oct 01 to Sep 02
Sr. Oracle/PL/SQL consultant
Environment:
HP/Sun Solaris / NT, Oracle 8.1.7/9i, Oracle 9iAS, 9i App Server, OEM, PL/SQL, SQL, Java, Java script, XML, XSL, HTML, DHTML, JSP, Servlets, SQL SERVER 2000, Microsoft Management Console, SQLLOADER, EXP/IMP, SQL NAVIGATOR, Unix Shell Scripts
Description:
As DBA/ Developer in Oracle 8i and Oracle 9i with Oracle 9i application server (Oracle 9iAS), Designing database, developing PL/SQL and maintaining database in ORACLE PARALLEL SERVERS environment for Verizon, Inc. Implementation of the test strategy to the actual Database. Wrote PL/SQL blocks, Stored Procedures, Functions, Packages. Conversion from access to Oracle Metasolv schemas. Using SQL LOADER utilities migrate flat files to database. Metasolv is software used for telecom network elements equipment inventory, customer network assignment, network provisioning, DSL provision and etc. Wrote Unix shell scripts for automation. Activities involved in Monitoring, Tuning, auditing users, assigning roles and privileges, backup and recovery. Involved in partition designing and tablespace and table partitioning for data warehousing purpose using Oracle 9i, Oracle 8i, SQL, PL/SQL, Core Java, JDBC APIs. Java script, XML, XSL, HTML, DHTML, and Unix shell scripts.
RESPONSIBILITIES:
• Involved in designing database, developing PL/SQL and maintaining database for Verizon.
• Creation/Configuration of Oracle databases under different environments like Production /Development / Testing
• Upgrade, Migration of Oracle software and database from Oracle 8.1.6 to Oracle 9.0.1
• Created tables, indexes, and queries, stored procedures to implement the desired functionality-using PL/SQL in Oracle.
• Involved in conversion/migration of database from access to Oracle.
• Wrote PLSQL blocks, Procedures, Functions, Packages. Conversion from access to Oracle schemas. Using SQL LOADER utilities migrate flat files to database.
• Moved the business logic for all the Java, ASP Applications from their Interfaces to the Oracle Server by writing Packages, Functions and Procedures in PL/SQL with good error handling routines
• Automated many UNIX maintenance tasks by writing scripts and programs, also evaluated existing Korn Shell scripts and enhanced the performance of them
• Used PL/SQL packages, worked on query optimization, data migration and loading.
• SQL Query Tuning and Optimization for improving response time using Explain Plan, SQL Trace and TKPROF.
• SQL*NET /Net * 8 connectivity/ Names server configuration for client server connectivity.
• SQL tables were created with referential integrity and queries were developed using SQL, SQL*PLUS and PL/SQL
• Wrote several UNIX Shell scripts to automate the process of analyzing the alert logs, trace dump files and send pager messages if any errors were written to these files and also to check various critical database parameters.
• Worked with tables creation, Index analysis, Turning, Stored Procedure, Trigger development, Rules and Defaults.
• Wrote UNIX shell scripts for automation activities involved monitoring, tuning, auditing users, assigning roles and privileges, backup and recovery.
• Used HTML/DHTML/ XHTML /JavaScript /CSS for front-end development
• Generate static and Dynamic pages by using JSP, XML, XSL and HTML
• Extensively involved in tuning Sql code, database tuning.
• Involved in configuration and implementation of RMAN utility (Oracle 8i/Oracle 9i) for backups and recovery. Configured and implemented the Oracle Standby databases.
• Involved in partitioning, allocating tablespace and table partitioning for data warehousing purpose.
• Involved in creating/moving/migrating databases, restoring database from a disk corruption, configuring for distributed databases, scheduling jobs, and automating the routine tasks using Shell/SQL * Plus/OEM event scheduler.
• Involved in load testing and capacity planning of the Production/Development databases.
• Involved in loading the data using SQL LOADER utility, importing and exporting database.
CHARLES SCHWAB & Co Inc., San Francisco Sep00 to Aug01
Project: Fixed Income Trading
The Fixed Income module is a comprehensive trading and risk management system for fixed-income securities and derivatives. Fixed Income extensive coverage of emerging markets debt makes it an ideal system for trading operations in emerging market debt instruments, corporate bonds and exchange-traded futures and options.
Environment: Unix, NT, ORACLE 8.0/8.1.5/8.1.6, SVRMGR30, Oracle Net 8.1.6Assistance, Oracle Database Assistance, Backup And Recovery Utility, Exp/Imp, Replication Server, Oracle Migration Tools, ORADIM, ORAPWD MSSQL, Java 2.0, JSP, Java Servlets (JSDK2.0 & JRun 3.0), Java script, Oracle Enterprise Manager, HTML, DHTML, Macromedia Dream Weaver 4.0/Mx
Responsibilities:
• Installation of Oracle8i on Windows NT and Unix and database tools like OEM, Performance/Diagnostics Pack
• Creation/Configuration of Oracle 8i databases for Oracle Financials and under different environments like Development/Testing/Production
• Used PL/SQL packages, worked on query optimization, data migration and loading.
• Involved in conversion/migration of database from access to Oracle. Wrote PL/SQL blocks, Procedures, Functions, Packages. Conversion from access to Oracle schemas. Using SQL LOADER utilities migrate flat files to database.
• SQL Query Tuning and Optimization for improving response time using Explain Plan, SQL Trace and TKPROF.
• SQL tables were created with referential integrity and queries were developed using SQL, SQL*PLUS and PL/SQL
• Wrote UNIX shell scripts for automation activities involved monitoring, tuning, auditing users, assigning roles and privileges, backup and recovery
• Worked with tables creation, Index analysis, Turning, Stored Procedure, Trigger development, Rules and Defaults.
• Capacity Planning and High availability solutions using Advanced Replication, Oracle Failsafe for production databases
• Generate static and Dynamic pages by using Java, XML, XSL and HTML
• Designed and coded JSP pages, Java Servlets and Java Beans for different user interactive Web pages
• Designed the User interface (UI) for the application using Dream weaver, CSS, fireworks and Flash.
• Working with developers for application tuning on SQL and PL/SQL
ALZA Pharmaceutical, Palo Alto, CA Jan99 to Aug00
Oracle Programmer/Developer /Java Developer