Database Developer/ analyst

Name : Vandana N Vidwans

Contact Number : 650-***-****.

Experience Highlights

Extensive experience in the field of Database Administration,design, development,migration and upgrade Oracle(8i,9i,10g,11g) /Sybase(11.x,12.x,15.x)/vertica(5.x)/MySQL. Migration (from Sybase to Oracle, Oracle 10g to 11g), and development.Logical and physical data modeling. Performance tuning at server and application level for Sybase and Oracle. Install, upgrade Vertica. Also Access, Java, Perl, Awk, HTML, XML and PHP. Excellent communication and interpersonal skills.

Hardware

Linux, Unix, Windows.

Operating Systems

SUN Solaris, HP-UX, IRIX, Windows, Linux

Software

Sybase Adaptive Server 15.0,12.x, 11.9.2/11.5.1, 11.5, 10.x, Enterprise Connect Server (OMNI connectivity), Replication Server 11.x, 10.x, APT, DB-LIB, DWB, T-SQL

Oracle 11g/10g/9i/8i/8.x/7.x,OEM, PL/SQL, SQL Loader, export/import,physical and logical Data Guard,RMAN

Vertica, VSQL

Postgres, PSQL

MYSQL, DBArtisan

ERStudio, TOAD, XMLSPY, Data Wearhouse

HTML, XML, PHP, SAS

AWK, PERL 5.004, UNIX/DOS shell scripts

Training

Oracle Database Administrator Workshop I, II

Vertica

Bio Science: Trained in GCP, 21 CFR Part 11

SAS Course.

Python.

Project Details

Apsalar San Francisco, CA May'13 to Oct’15

Database Engineer

Apsalar’s platform is the leading mobile DSP powered by 1st party behavioral data, providing an advertising and analytics platform for direct marketers and agencies looking to acquire and optimize high-ROI mobile audiences at scale.

Design, develop and implement segmentation.

developing applications and systems in deadline-oriented environments.

Design, develop and implement Event based postbacks and self service postbacks.

Design new workflow for sales and operations campaigns,develop and implement.

Identify bottlenecks for performance, tune queries for better performance.

Analyze data and Create Audience for different clients for maximizing ROI.

Technology used: Solaris, Postgres, Python.

Innotas San Francisco, CA Apr'12 to Nov'12

Database Administrator

Leader in Cloud Solutions for Project Portfolio Management and Application Portfolio Management.

Move production servers to different machines in limited downtime.

Upgrade servers from 10.2.0.2 to 11.2.0.2.

Backup and Disaster recovery and consistency of databases.

Configure databases for real time and off line physical Data guard.

RMAN backups.

Performance tuning on server and database level.

Release patches/new versions in test/staging and production environments.

Technology used: Linux,Oracle 10g/11g.

Crowdstar Burlingame, CA Jul '11 to Jan'12

Database Architect

Social gaming.

Install, upgrade Vertica.

Use my extensive knowledge of statistics, social gaming, and Vertica to optimize game

development and tuning, analyze data for maximizing ROI.

Design schema, transform and loadand analyze data for various games.

Troubleshoot problems loading/transforming data and help analysts.

Genarate dash boards for audits and alerts for games using php and vertica.

Design, implement curl calls for publishers using php.

Create,Automate and manage processes for games analytics.

QA all parameters for games.

Technology used: Linux,Vertica.

Synarc San Francisco, CA Aug '05 to Jul '11

Sr. Database Administrator

Synarc is the world’s largests Central Radiology service dedicated exclusively to global clinical trials. It’s services integrate all aspects of the design and execution of medical imaging and molecular markers in

Clinical trials across a spectrum of diseases including Oncology, Arthritis, Osteoporosis, Neurology,

Orthopaedics and Cardiovascular disease.

Working nights/weekends as necessary to support all clinical trials.

Install,upgrade,manage database servers ( SYBASE / ORACLE).

Automate dump and load database with user access for SYBASE databases

for data transfers.

Migrate SYBASE databases from Solaris to Linux.

Backup and Disaster recovery and consistency of databases.

Configure database for physical and logical Data guard.

RMAN backups, RMAN Duplicate.

Help users in database related activities.

Create new databases for specific studies.

Analyze and cleanse the data.

Performance tuning on server and database level.

Release patches/new versions in test/staging and production environments.

Migration from Sybase to Oracle.

Technology used: Sun Solaris 2.8, Oracle 8i,9i,10g,11g,Data Guard,RMAN. Sybase 11.5.1,12.5.1,15.0, SAS.

Genentech South San Francisco, CA Sep '04 to May ‘05

Data Migration Lead

The project encompasses reengineering of Genentech’s contract management businesses processes, development of an analytical framework to analyze and represent Genentech’s contract management domain, development of an extensible business and system contract management architecture and, ultimately, the elevation of contract management to the status of a strategic core capability that drives competitive advantage, profits and shareholder value at Genentech.

Use Nextance XML-based product to create 'System of Record' for contracts.

Participated in Business process reengineering for different contract types.

Create AS_IS and TO_BE data flows.

Create data dictionaries for existing systems and Nextance System for data mapping and gap analysis.

Create web interface for terms glossary and documents for project using PHP and Apache.

Develop and document strategy for data migration and data cleansing.

Create and Design schemas for data cleansing.

Technology used: Sun Solaris 2.8, Oracle 9i, ERStudio,XML,Tamino Database.

MDL, San Leandro, CA June '04 to Sep'04

Database Engineer

MDL is the pioneering leader in discovery informatics. Over 1,000 life science companies supercharge their discovery engines with MDL software solutions to generate fresh ideas and make breakthrough discoveries. By synchronizing and streamlining the sharing and management of vital information and knowledge, enables scientists to work more efficiently.

DBA activities for their QA group for coreif software.

Configure Ethereal to inspect network packets for security purposes.

Technology used: Sun Solaris 2.8, Oracle 9i.

Bank of America, San Francisco, CA June ’03 to Feb ‘04

Senior Database Administrator

Convert recent books and records for the portfolio management system (Thompson Financial’s “Portia”). Analyze requirements, implementation plans, and schedules for Ab Initio ETL tool and Perl/bcp data distribution tool that moves data to the various (20+) database servers. Analyze, develop, enhance and troubleshoot production tracking tools for nightly trade processes using Oracle/Sybase PL/SQL, Transact SQL, Perl, CGI scripts in a Unix environment.

DBA activities for Oracle and Sybase servers such as: dump, load, performance tuning, create instances, install database servers, develop scripts for database maintenance.

Principal support for oncall rotation and troubleshooting of the nightly trade processing for Portia.

Technical Lead for tax lot process. Collaborate with business analysts to analyze data, physical and logical data modelling and develop and implement new methods for reconciliation of tax lots.

Create processes in Perl to transfer data between Oracle and Sybase.

Technology used: Sun Solaris 2.8, Sybase 12.5.,Oracle 9i,MySQL,Perl,DBArtisan.

InCyte Genomics, CA Sept ’02 to Nov ’02

Senior Database Administrator

Incyte Genomics keeps track of various DNA sequences, generates chromatograms, and collects information for the gene albums.

Support production databases (Oracle and Sybase).

Create a new database from existing one, with a new instance name.

Help in migration from Sybase to Oracle, and from File Maker Pro to Oracle.

Generate daily maintenance shell scripts for Sybase and Oracle servers.

Tune PL/SQL queries for better performance.

Tune and execute scripts for import/export.

Use RCS to put all scripts under source code control.

Technology used: Sun Solaris 2.7, Sybase 11.5.1, Oracle 8i.

INDUSA Technical Corp Oct ’01 to Aug’02

Senior Database Administrator/Architect

Sun Microsystems, CA Jun’98 to Oct ‘01

Senior Database Administrator/Architect

Global Technical Operations

GTO (Global Technical Operations), which supports over 500 Oracle and Sybase databases.

Database maintenance: refreshing data, consistency checking, defining and implementing backup strategies.

Performance tuning of configuration parameters, device storage, memory utilization and query tuning at application level.

Install Oracle Client/Server software. Perform database upgrades.

Define technical architecture for repeatable installations of databases, and backup strategies for the same applications in different environments such as production, function test, string, staging, development, etc.

Building servers (Sybase, Oracle) according to the requirements of the application

Supporting the environments and refreshing data from production as and when required

Database maintenance: refreshing data, consistency checking, defining and implementing backup strategies, upgrading servers.

Performance tuning of configuration parameters, device storage, memory utilization and query tuning at application level.

Data Modeling for various applications.

Senior Database Administrator/Architect/Support

During this period, worked in parallel on the following projects:

UltraModel

UltraModel is the vital Supply Chain Management tool for Platform Managers and Key Component Managers. It develops supply plans at Platform and Key Component levels, respectively, and at 3 week intervals it revises and publishes the plan for the next 6 quarters. The Supply Change Request (SCR) module issues the changes in the plan at both platform and key component level.

Technical Lead for supply planning and management.

Analyzed and designed enhancements in SCR module.

Developed Functional Specifications coordinating with user groups.

Involved in transition of source code from 'TeamWare' to 'ClearCase'.

Coordinated and interacted with Configuration Management group for code promotion.

Performed DBA activities such as dump, load and performance tuning at application and database level. User administration for Sybase database 11.5.1.

Performed User presentations/demos.

Set up of Webserver for development environment.

Set up Integration testing, development and staging environment.

Performed Integration testing.

Prepared Test Plans for the user acceptance testing.

Deployment of module releases.

Production support.

Technology used: Sun Solaris 2.7, JDK 1.1.7, Swing 1.0.3, Servlets, Java Web Server 2.0, JCTable package from KL Group, Sybase 11.5.1.

Master Reseller

Master Reseller allows users to determine inventory levels, days of supply, backlog, shipping and consumption rates with a single tool.

Technical lead/developer.

Re-engineered of Master Reseller to Operations Data Warehouse (ODW). ODW is the repository within Worldwide Operations which combines data from different sources using consistent naming conventions and conforming dimensions, allowing cross functional analysis for users from various functional groups.

Rearchitected the system as per ODW data model.

Developed, tested and promoted the code to the production environment.

Performed Query Optimization of queries during ODW transition.

Production support.

Space Management

Development Database Refreshes

Backups/Recovery

Technology used: Sun Solaris 2.7, JDK 1.1.7, Servlets, Oracle database 8.1.7, Pl/SQL,Java Web Server 2.0, Autosys for batch jobs.

Key Component Processing

Key Component Processing provides information for each product at Key Component level. It derives all key components from the Oracle ERP system and transfers them to a Sybase environment on a daily basis.

Technical lead/developer.

Provided database administration and support for the application.

Developed, tested and promoted the code to the production environment.

Performed Query Optimization.

Production support.

Utool/Avltool

Database Administrator for Utool/Avltool, an engineering application used to support Engineering Change Requests and Engineering Change Orders for manufacturing processes. It upgrades and integrates ECRs and ECOs with Oracle Manufacturing and MFG-PRO systems.

Support production databases for PDM suite of applications and provide application level support.

Installing Sybase 11.5, Sybase Enterprise Connect Server (Omni Connectivity), and Oracle 8i/8.0.5/7.3.4.

Database maintenance: refreshing data, consistency checking, defining and implementing backup strategies, upgrading servers.

Performance tuning of configuration parameters, device storage, memory utilization and query tuning at application level.

Technology used: Sun Solaris OS 5.x, Sun Solaris 2.8/2.7/2.6/2.5, Sybase Adaptive Server 11.9.2/11.5.1/11.5, Sybase 11.0.3, Sybase Enterprise Connect Server (Omni Connectivity), APT, Oracle 8i/8.0.5/7.3.4.

Silicon Graphics, CA Feb’97 – May’98

Senior Sybase DBA in Customer Support Division

Supported 3 different projects in parallel: ACE, DRP and SLIC for Worldwide Customer Service.

ACE

Install ACE shopfloor system for users’ defined processes whenever required.

Make changes in routings to reflect business decisions.

Remodeling of SRM (system remarketing).

Business analysis and implementation of new processes as per user requirements for SRM.

Train new users on ACE shopfloor system.

Understand business flow of each process in logistics: Challenge, Peripheral, SRM, Receiving, Indy/Indigo2, OOBA.

Install new Sybase test server for logistics.

Develop various web-based query reports, graphs using Perl, SybPerl and JavaScript.

DRP (designed and developed by LPA software)

Install DRP on servers.

Install Sybase servers for test system.

Upgrade to new versions and help planners whenever required.

Develop various daily feeds to system, e.g., demands, returns, reorder and sales data.

Install Sybase, DRP system for CRAY and Europe.

Develop various feeds to system for CRAY and Europe.

Database administration, maintenance, performance tuning and upgrades.

SLIC (designed and developed by LPA software)

Installation of the system

Database administration, maintenance and performance tuning

Technology used: Irix 6.4/6.2/5.3/4.0.1, Sybase Adaptive Server 11.0.3/11.0.2/10.0.2/10.0.1, Informix 2.10.00B, Perl 5.004, VPE 2.6.02, SmartStar 1.2.7.0.

Sun Microsystems, CA Dec’95 – Jan’97

Database Administrator

Technology used: Sun OS 5.4, Sybase System 11.0/4.9, DB-Library, C++

Board of Technical Examination Jan’95 – Nov’95

Project Manager

Technology used: HP-UX, Sybase System 10.0 Replication Server, APT, DWB, DB-Lib, T-SQL

BSES Ltd. Nov ’82 – Dec ’94

Project Manager

Technology used: HP-UX, Sybase System 10.0/4.0, APT, DWB, DB-Lib, T-SQL, AWK

Education

MS (Statistics), Bombay University

Contact this candidate