Management Data

Lina Hwang

Temple City, CA

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

626-***-****

Summary

Experienced Information System Consultant, Database Analyst,

Administrator, Developer, Data Modeler and Data Analyst with critical

thinking and analysis skill, specializing in the following fields:

Database Administration Data Modeling Data Management

Project Analysis Project Management Process Automation

Architect Design Applications Support Reporting system

Data warehousing Security Control Trouble Shooting

Professional Experience

Kaiser Permanente Pasadena, CA 2000 to 2011

America's leading integrated health plan, Healthcare Systems.

Data Management Lead, Reporting Consulting Group (Category - Database

Administration)

Teradata Database administration, Project management and Applications

support (2005-2011)

.

. Primary DBA to migrate National HealthCare information system from Oracle

platform to Teradata Platform

. Teradata Clarity database designed, administrated, managed and trouble

shooting .

. Designed and maintained Security Control for compliance with SOX &

HIPAA rules include Database Views, Roles, Profiles, Users Account

setup, Users Access control.

. Supported ETL of data loading issues and trouble shoot data related

issues.

. Collaborated with cross functional teams to manage several database

projects.

. solved databases and applications problem, made the process more

efficient and improved the upgrade releases process to cut short the

system down time and reduced the costs for the projects

. Consulted Project leads and developers of database related issues.

Oracle Database administration and Applications support

(2000 - 2005)

. Oracle Database architecture, engineering and administration

. Analyzed requirements with Business partners for hospital information

including supply chain, pharmacy, patient records, etc.

. Data Warehouse Data analysis, design logical data models and physical

database schemas

. Databases Design, Administration, management and maintenance

. Databases Backup and Recovery plan and coordination.

. Designed and programmed daily and weekly data refresh Automation

process.

. Created database objects for tables, users, roles, profiles, grants

. Identified innovative, cost effective ways to implement and support

physical databases technologies.

. Troubleshoot and resolved database, load and reporting issues.

Oracle Corporation El Segundo, CA 1996 - 2000

Consulted business partners of Oracle database projects.

Oracle database and applications problems trouble shooting.

Senior Consultant

. Designed, built, administered Hughes satellite components data

management project database

. Built databases and developed applications, users tools and

programming.

. Trouble shooting Universal Studio's billing system. Universal Studio

billing system replication databases were down, trouble shooting

replication databases re-activated the database replication

activities.

. Trouble shooting Dept. of Water Resources, Sacramento Oracle Financial

Applications.

Other Experience

. The primary DBA to design Pacific Bell 411 system (Operator

automation system) for southern California

. The primary Database Scientist successfully automated L.A. Air Force

Base projects control system

Education/Training

. Bachelor of Science, Physics, Fu-Jen University, Taiwan

. Graduate school, Physics, Marquette University, Wisconsin

. Graduate school, Electrical Engineering - Computer Science, Cal State

Long Beach, California

Technical Skills

Platforms and Tools

. Operating System: Unix Sun Solaris, Unix AIX, Window NT

. Databases: Oracle 10g, Teradata V12

. Data Modeling tools: Erwin, Oracle Design Tools

. Programming Languages: Unix Shell Script, SQL, other vendor

reporting tools

Skills

. Project Management

- Project Analysis and Plan

- Process and function design

- Cross function team coordination

. Data modeling & implementation

. Database Strategy, Architect Design and support

- Database administration & management

accounts and security control

- Backup & Recovery

- space management

- platforms transformation

- views, triggers, procedure, functions Design and Programming

- data loading, import and export, data conversion

- Data architect, analysis, management, trouble Shooting

. Data Management

- Data Arhitect design, data analysis

- ETL support include data loading, import and export,data

migraton

- Data Manuplatation include transformation, Conversion

- Trouble shooting

. Applications Development and support

- Database Applications development and Process Setup

- automate manual tasks, Process,Unix shell script design and

programming

- user Interface and reporting Infrastructure design and support

. Users Support and consulting

[pic]

Contact this candidate