Highlights

• Extensive experience as an Oracle DBA in Oracle 7/8/8i/9i/10g and 11g (RAC);
• Lead administrator in Oracle Hyperion EPM (Essbase/Financial Rpt,Workspace,Shared Services, WA, Planning….etc);
• Intensive admin in Peoplesoft HRMS and Financial systems;
• Well developed skills in those common OS: Unix, Linux , Windows;
• Enhanced experience in EssbaseSQL server, Weblogic, Apache and Autosys;
• Cross trained in Oracle ODI and OBIEE in application setup, configuration;
• Excellent oral and written communication skills;
• a US citizen;

01/2008- Confidential,NJ

Installed and configured Oracle 11g RAC system in Linux;
Setup and configured the RAC monitoring and tuning system;
Created and configured all DEV/TEST/UAT/Prd instances;
Daily administration of the RAC database and RMAN backup:
Performed admin responsibility for top sessions and I/O monitoring, index optimizations, statistics update, database and query tuning, performance enhancement, space administration, security management, archiving and trace file follow up, trouble-shooting and resolving issues, maintenance of oracle dba_directories and external tables , related shared drive “gfile” among the 4 nodes and daily backups..;
Executed support for critical Month End Reportings by refreshing databases in related environments and scheduled to run multiple batch jobs via cron and CA Autosys systems;
Participated and supported Developers in code review, code testing/tunings and migrations ;
Reviewed and applied system patchings in all needed database , application and performed the related migrations in all environments;

Installed and configured Oracle Hyperion EPM application system in load balance environment under Linux;
Set upconfigured and administrated Essbase Service, Essbase cubes and EAS tool;
Set up, configured and administrateded all the Hyperion modules to fit oracle RAC system: Shared Services, CoreServices,Workspace, Financial Reporting, Web Analysis, HFM, Planning , Strategic Finance,DRM Smart Views…etc
Performed daily support to the clients in all the applications : issue troubleshooting ,Application server load balancing, batch server administration, web server enhancement and regular maintenance ;
Support all monthly application refresh for Planning, Essbase Applications and application migrations-- etc.Ñ

Peoplesoft role is continuing as required

02/2004—01/2008 Confidential,NJ
Oracle Application DBA and Admin for Hyperion and Peoplesoft
Installed, upgraded and patched for Oracle database engine and application tools (Oracle 9i/10g); Peoplesoft7 - Peoplesoft8 etc) in UNIX environment;
Performed weekly DB production support in Payrolls for different sites: Day-to-day Dev/test/QA/Sandbox database and programming support for developers, new users in data conversion, application upgrade, business globalization and all ongoing projects-- data loading, data manipulation, data security, data modification and change, data backup, Sql and PL/SQL creation and testing, performance testing, fix and patch testing, database creation and refresh;

Installed and configured Hyperion 7 system in load balance environment under windows ;
Set up and configured Essbase Service, Essbase cubes and EAS tool;
Set up and configured all the Hyperion modules to fit oracle 10g: Financial Reporting, Analyzer, Planning , Strategic Finance…etc
Performed daily support to the clients in all the applications : issue troubleshooting ,Application server load balancing, batch server administration, web server enhancement and regular maintenance ;
Support all monthly application refresh for Planning, Essbase Applications and application migrations-- etc.

Installed Web servers, PIA, tuxedo and jolt, Application Server, and batch server for Web oriented Peoplesoft applications; configured and maintained the whole entirely workable system among web server (heap size configuration, port management, report repository administration, URL setup), application server (Tuxedo setup, internal services optimizations, port administrationÑ), batch server (Cobol, SQR, Crystal Report, Application Engine) and database server (system configuration and enhancement, SGA optimization, Redo logs, Rollback segments, Temporary tablespace and archiving administration) which sitting in separate physical servers.
Extensively communicated with application managers, technical managers, functional managers, developers, system and network administrators, and end users for different projects;

01/2000—7/2003 Confidential,NY
Lead Oracle DBA for Peoplesoft, Menugestics, QuarkExpress, etc
Installed, upgraded and patched for the Oracle database engine and application tools (Oracle 7-8i-9i; Peoplesoft7 - Peoplesoft8 etc);
Weekly DB production support for Payrolls for different sites: Day-to-day Dev/test/QA/Sandbox database and programming support for developers, new users in data conversion, application upgrade, business globalization and all ongoing projects-- data loading, data manipulation, data security, data modification and change, data backup, Sql and PL/SQL creation and testing, performance testing, fix and patch testing, database creation and refresh;
Data modeling for seasonal Benefits relational Database. Set up and graphic concept and logical data model; sized and created database, objects, indexes, and views, administered and maintained database;
Designed/implemented DSS and Sandbox databases including creation and maintenance of scripts to customize, rebuilt and maintained all objects within the Oracle database to meet the special requirements from clients; Created database link and applied data replication using Material Views to update DSS database; ran and collected statistics for evaluation of different options for optimization, performance configuration and testing, reporting system establishment;
Monitored and maintained big sized image assets database. Created and administered BLOB, Bfile objects. Configured and optimized the system for batch uploading process for thousands and thousand images. Tuned database for quick browse of any images;
Installed Web servers, PIA, tuxedo and jolt, Application Server, and batch server for Web oriented Peoplesoft applications; configured and maintained the whole entirely workable system among web server (heap size configuration, port management, report repository administration, URL setup), application server (Tuxedo setup, internal services optimizations, port administrationÑ), batch server (Cobol, SQR, Crystal Report, Application Engine) and database server (system configuration and enhancement, SGA optimization, Redo logs, Rollback segments, Temporary tablespace and archiving administration) which sitting in separate physical servers.

06/1998 --1/2000 Confidential,NJ
Key Oracle DBA for Peoplesoft Finance
Administered both development and production database environments.
The administration work including
Installed Oracle and Peoplesoft, Created and maintained Peoplesoft databases, set up Peoplesoft File server, Peoplesoft Workstations, Peoplesoft Batch Environment, installed and set up Peoplesoft Tuxedo and Jolt;
Set up, maintained, and tuned Peoplesoft Application Server, Process Scheduler, Web server, and configuring PSQRYSRV, PSQCKSRRV, PSAMSRV, PSAUTH;
Upgraded, fixed, and patched Peopletools and Applications, scheduled and automated Application Server and Process Scheduler;
Supported and worked with Oracle/Peoplesoft developers and end users in programming, SQL tracing and tuning, data management, etc);
Monitored and administered performance and processes, both on 2 _ tiers and 3_tiers;
Oracle Data modeling and RDBMA architecture testing and evaluation, administered Oracle roles, user, security, and handled database change requests;
Created, maintained, and tuned tablespaces, datafiles, rollback segments, redo logs, pfile, control file, etc;
Administrated server maintenance, disk space, and partition in oracle8 and all other Oracle DBA and programmer work: SQL and PL/SQL, Database Administration, Backup and Recovery, Tuning performance, and Replication.

11/1995 -- 6/1998 Confidential,NJ

Maintained and programmed in manipulating financial data, which provides daily and historical data from Balance Sheets, Income Statements, Cash Flow Statements and other financial/accounting information for publicly traded worldwide companies;
Wrote and maintained SQL and PL/SQL statements, which were extensively applied by various kinds of processes. SQL statements were related Load function, Processes, Financial Ratio Calculation, Statement Balance Checker, and other Updating and Deleting functions;
Developed and supported database for developer, for test, and for production, applied backups and data recovery, exported and imported tables, and set up batch processes;
Database Configuration setup, including control files, Redo Log, rollback segments, p-file management, and control file maintenance, database creation, and etc;
Worked on estimating data storage needs, data loading and made optimal physical placement for best performance.
Worked on management of tablespaces , application objects, table constraints, triggers, clusters, indexes, and etc.


Utilities
Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11ix OEM, SQL*Loader, SQL* NET, SQLPLUS, SQL & PL/SQL, RMAN, Oracle Tuning Pack,
Oracle Management Pack, Oracle Discoverer, Oracle Developer 2000,
Quest Central, Spotlight, Toad, Sqllab, Sql Navigator, Space Manager, Standby database, Autosys

ERP:
Oracle Financial, Peoplesoft Financial/HRMS,
Oracle Hyperion BI
Oracle ODI
Oracle OBIEE
Menugestics, QuarkXpress …

OS:
UNIX, Linux, Windows (XP , Vista..), MVS, Dos,

RDBMS:
Oracle 7x/8x/8i/9i/10g/11i, Essbase ,SQL Server, db2 UBD

WEB SERVERS:
Weblogic, Apache

OTHERS:
SAS, HTML, Websphere Appl Developer, Java Pascal, Visual Basic, Excel, Quattro Pro
Microsoft Cluster, Citrix, Veritas, SQR, Tuxedo and Jolt, Cobol complier, Ewin, ReflectionX, PCanywhere VPN, PAL

OCP for Oracle 7.3.4/8x/ 8i
Professional Training:
Oracle 7.3.4 and 8x /8i/ 9i/10g/11g
Oracle Advanced Replication
Solaris 8 administration (Sun)
Peoplesoft Server Administration on Unix/Oracle and NT
Peopletools
Peoplesoft Data Management
Oracle Hyperion BI applications
Sql Server 7.00
DB2 UDB 7.1

MBA in Finance