Development Analyst

Elisa Bautista

***-* ******** ******

Bartlett, IL 60103

Residence: 630-***-****

Cell: 630-***-****

***********@*******.***

SUMMARY

Detail and results-oriented Database Analyst and Administrator with

practical experience and demonstrated success in the development,

implementation, maintenance and support of Oracle databases and Oracle

based-application systems. An information systems professional with strong

analytical skills and experienced in all phases of the project life cycle,

including requirements gathering, design, development, implementation and

support. Proven ability to deliver effective solutions within the

prescribed timeframe and budget.

TECHNICAL EXPERIENCE

. Languages: PL/SQL, SQL*Plus, C, COBOL

. Scripting: KSH/CSH shells, Perl, SED, AWK, HTML

. Operating Systems: UNIX Solaris 8, 9 and 10, HP UNIX, Linux

. RDBMS: Oracle 8i, 9i, 10gR2

. Protocols: SQL*Net, OID, FTP

. Tools: dbca, Erwin, OEM, Data Guard

PROFESSIONAL EXPERIENCE

Convergys Corporation, inc., Cincinnati, OH 1992 to 2009

1988 to 1990

A global leader in customer management, business and operations support

systems (BSS/OSS) solutions and Human Resources management services.

Database Consultant, Itasca, IL (2001 - 2009)

Lead Database Analyst and Administrator for a comprehensive billing and

customer care solution for global wireless operators.

Accomplishment Highlights:

. Improved the security of sensitive data stored in the production database

of a wireless service provider to reduce fraudulent activities. Designed,

developed, and implemented a data encryption process using Triple Data

Encryption Standard (DES) procedures of the Oracle obfuscation toolkit to

mask the clear text data.

. Reduced by 87% the runtime of the billing software's database objects

migration across three system releases, a process that would otherwise

have caused the client's production database to be offline for at least

30 hours was completed in 4 hours. Led the team of database analysts in

the development and implementation of this multi-release migration

package.

. Streamlined the development testing process of database objects by

developing and implementing a private database schemas concept that

provided each user the ability to create their own copy of the product's

database objects for individualized testing on the same development

database.

. Enhanced the availability and recoverability of the internal work

management system's production database by implementing two remote

standby databases, allowing for a quick failover in case of production

database failure.

. Designed and developed performance-tuned custom PL/SQL, Ksh shell and

Perl scripts for database tables and data conversion for feature releases

of the billing software, which had a 100% accuracy rate during deployment

to the production databases.

Responsibilities Included:

. Created and maintained Oracle 8i, 9i and 10g databases for development,

integration, and system testing needs of the application development

groups.

. Performed database cloning, data loads and refreshes, and Oracle-related

configuration and set-up of database servers.

Elisa Bautista Page 2

. Analyzed, designed, and implemented logical and physical database

structures using the Erwin modeling tool, PL/SQL, SQL and shell scripts

and UNIX source code control system (SCCS) procedures.

. Analyzed system specifications and developed PL/SQL procedures and

packages, triggers, views and other database objects for use by the

application software.

. Developed patch scripts and packages to deliver database objects and code

updates to production databases.

. Installed, patched and upgraded Oracle RDBMS software. Migrated databases

to the next higher Oracle release.

. Performed troubleshooting, identification, and resolution of issues

related to the database.

. Created and maintained UNIX ksh/csh shell and Perl scripts that automated

basic operation, administration, and maintenance (OA&M) activities to

support and monitor multiple databases.

. Assisted application development groups in developing complex and

performance tuned SQL query statements.

. Created and published 'How To' technical documentation for internal use.

Also wrote installation documents and user guides.

. Provided development rough order magnitude (ROM) and detailed estimates

for database development work.

. Conducted staff meetings and reviews of technical work. Provided training

to new group members.

Database Administrator, Itasca, IL (1996 - 2001)

Database Analyst and lead installer for a rules based mediation system that

translated any standard Cellular switch data format to a flexible and

configurable downstream format.

. Designed, developed, and maintained Oracle 7 and 8i databases and

database schemas for this product, delivering one major release and two

minor releases per year.

. Led the installation team in the development of the installation package

and its implementation in the client's test and production servers.

. Progressively improved the performance and efficiency of the database set

up for this product by performing sizing and tablespaces load balancing

based on anticipated data volume.

. Created and maintained comprehensive schema documentation for use by the

application development group and production DBAs.

. Migrated Oracle 7.3 databases to Oracle 8i.

Senior Technical Consultant, Itasca, IL (1992 - 1995)

Team lead, with a full development workload, of a group that supported a

wireless carrier grade switch provisioning application, a PC-based system

written primarily in Microfocus COBOL.

. Ensured the accuracy and timely delivery of custom enhancements to the

client's production system by coordinating, assigning, tracking and

reviewing the work of 7 staff members.

. Provided technical support to team members, client management services

group, other development groups, as well as the clients.

. Provided contingencies and/or expedited solutions to problem situations,

technical or otherwise.

. Wrote and published internal technical documentation.

Systems Analyst, Itasca, IL (1988 - 1990)

Designed, programmed, implemented and supported the switch provisioning

application.

. Customized the product to meet client requirements.

. Performed on-site new client set ups and existing client upgrades,

including pre-installation planning, software and hardware configuration

and installation, initial database loading and synchronization, system

start up and user training.

CCC Information services, inc., Chicago, IL 1991 to 1992

A provider of total vehicle claims management systems to the insurance

industry.

Systems Analyst

Developer on a PC-based collision estimating system written in C, with

interfaces to both IBM mainframe and STRATUS application systems.

Elisa Bautista Page 3

Other prior experiences include Systems Analyst and Programmer Analyst

positions of increasing responsibility.

EDUCATION

University of Santo Tomas, Manila, Philippines (1979)

Bachelor of Science in Biochemistry

Cum Laude

Manila Data Processing and Training Center, Quezon City, Philippines (1981)

COBOL and Assembler Programming

Bellcore Training and Education Center, Lisle, IL (1996)

Introduction to UNIX Systems and UNIX System Programming Tools

Oracle Training Centers, Chicago and Schaumburg, IL (1996 - 2000)

SQL and PL/SQL, Database Administration, Data Modeling and Database Design,

Database Backup and Recovery, Database Performance Tuning

Contact this candidate