Oracle Data

Leslie (Li) Huang

** ********* ******

East Brunswick, NJ 08816

Home: 732-***-**** ************@*****.*** Cell: 732-***-****

OBJECTIVE

A position in Oracle Database development/administration.

SUMMARY

Oracle DBA/Developer proficient in developing, designing and managing

Oracle Database. Extensive experience with Oracle database 10g, SQL,

PL/SQL, C/C++ and Shell scripts on Windows and UNIX platforms. Knowledge of

financial, insurance/annuity and telecommunications industries. Excellent

analytical, troubleshooting and communication skills. A strong team player.

TECHNICAL SKILLS

Language: PL/SQL, SQL, Shell Script, C, C++, Pro*C

Software: Oracle 10g/9i/8i, SQL*Plus, SQL*Loader, Oracle

Enterprise Manager, Oracle RMAN, Oracle Reports Builder,

Oracle Discoverer, Visual Studio C++ 6.0, SQL Server,

Toad, Erwin, PVCS, Remedy.

Operating UNIX Sun Solaris, Microsoft Windows

Systems:

PROFESSIONAL EXPERIENCE

PRUDENTIAL FINANCIAL, Iselin, NJ 1999 - 2010

Annuities Information Technology

Oracle Specialist/System Developer

Developed and enhanced LifeCad and RCM annuity administration systems.

Managed development, QA, UAT and production databases. Designed and

developed RCM schema. Developed interfaces between multiple annuity

systems, under UNIX and Windows environment.

. Developed stored procedures, packages, functions, triggers and views in

Oracle database to generate the interface files, populate reports and

outputs to communicate between multiple annuity systems, and converted a

database from formal system to LifeCAD MP in Oracle when system was

replaced up to date, using SQL(DDL, DML), PL/SQL, Oracle Reports, Oracle

Discoverer, and Unix Shell Scripts. Created materialized views to

replicate data between databases for reporting system.

. Created and configured databases. Created storage structures and security

authorizations, and implemented database schema with SQL*Plus, Toad and

OEM. Loaded data into database with SQL*Loader. Exported and imported

databases to move/copy/refresh databases. Maintained UNIX shell scripts

to manage and monitor databases and processes.

. Developed and implemented Backup/Recovery strategy to ensure data

retention requirements. Configured settings of RMAN for database backup

and recovery. Created RMAN backup and recovery scripts to automate the

processes.

. Designed data model, created schema, normalized and de-normalized data to

achieve business data integration and system performance using Erwin for

RCM, a Replacement Case Management annuity system. Developed and

implemented physical model. Created tables, indexes, users and roles,

etc. Developed functions, stored procedures and packages using PL/SQL,

as core processing of RCM in Oracle. Enhanced functionalities of RCM in

programs based on business requirements.

Leslie (Li) Huang

Page Two

Home: 732-***-**** ************@*****.*** Cell: 732-***-****

Oracle Specialist/System Developer, (Continued)

. Support the LifeCAD MP and RCM production. Maintained shell scripts to

auto build the executables. Created autosys jil to run scheduled batch

jobs on UNIX. Troubleshot and resolved problems of production batch and

autosys jobs.

. Supported database and application users. Installed Oracle client and

setup working environment for users. Provided technical consultation and

data analysis to users. Supported development and QA team.

. Tuned database structure and application code to improve performance.

NAVISYS, INC., Edison, NJ 1998 - 1999

Programmer/Analyst

Worked on data model and functionality enhancements of LifeCAD MP, which

was running on n-tier client server environment and contained an Oracle

database on UNIX/NT server and Windows NT/95 clients, based on customer's

requirements.

. Maintained data models, including conceptual and physical model and

database script, using PowerDesigner, for Allmerica LifeCAD project.

Created tables, views, indexes, sequences, constraints, functions and

stored procedures in Oracle database using SQL and PL/SQL.

. Program C/C++ utility functions to perform core LifeCAD MP Process and

provide an intermediate interface for Frond End APIs, using C/C++ and

PL/SQL.

MACROSOFT, INC., Parsippany, NJ 1997 - 1998

Developer/DBA

Provided software technical support for Nortel Telecommunication Marketing

data analysis, under Unix and Windows NT environment.

. Involved in data modeling, database creating for the Wiltel Telemarket

Campaign Oracle database. Pre-processed the data with shell script and

loaded data into database with SQL*Loader. Created views, functions and

stored procedures to analyze data, generate business reports and update

the database, using SQL, PL/SQL, and Pro*C.

. Developed script files to analyze and process data, and produced the

customized data information base on American Business Information (ABI),

Computer Intelligence (CI) and Nortel Installed Base data sources, using

Shell scripts and Unix/C.

EDUCATION

MS, Computer Science, NJIT, Newark, NJ

BS, Chemical Engineering, Fuzhou University, China

CERTIFICATION

Certified Oracle Database Administrator (OCP)

Contact this candidate