Manager Oracle
Resume:
Robert T.C. Chen
******@*****.***
Summary
An innovative IT Solution DBA/Architect with an extensive background in
Information Technology consulting, Grid computing, Project & Portfolio
Management. Highly successful in evaluating, selecting, implementing and
upgrading technology and solutions for corporations in financial services,
banking, software service, retail, manufacturing & distribution industries.
Strong experience in design, development and implementation of applications
and technologies in the RDBMS, PeopleSoft, SAP and Risk Management world.
Successfully managed internal, external, on-site and off-shore consulting
resources and ensured project success within the triple constraint.
Areas of Expertise
. Strategic logical/physical design and planning in all relational
databases platform
. Experienced in data conversion, replication, and patch and disaster
recovery Project/Portfolio management in a matrix organizations
structure.
. Application Software Product Development, data warehouse architecture, E-
Business Suite and security auditing.
. Highly effective liaison and diplomatic change agent who, without formal
authority, won the trust of diverse stakeholders and forged partnerships
across conflicting interests to assemble cross-functional teams that
executed swiftly and reliably.
. Strong technical manager who delivered major systems on time and within
budget by negotiating cost-effective service level agreements with
offshore development vendors, and leveraging extensive experience leading
and executing full project life cycles
. Research and evaluate software and new technology to enhance the
data movement and integration.
. PeopleSoft Practice development and establishing off site/ Off Shore COEs
(Centre of Excellence).
. Project and Portfolio Management, SDLC/PMLC methodologies, Best Practice
and Change/Version Control...
. Application Architecture Evaluation and Software Selection.
. Solution Configuration, integration, migration, conversion and
Implementation (PeopleSoft, WorkBrain, Field Glass, Ensemble. CODA,
BankWare etc.)
. Managed internal, external, on-site and off-shore consulting resources.
Experiences
Fitch Ratings Corporation, New York City, NY
2010 - present
Senior DBA/Architect
A global rating agency committed to providing the world's credit markets
with independent and prospective credit opinions, research, and data. With
50 offices worldwide, Fitch Ratings' global expertise, built on a
foundation of local market experience, spans across capital markets in over
150 countries.
. Re-design and implementation of the database infrastructure, including
Failover, Disaster Recovery, Performance Monitoring, Capacity Planning,
and Automation of database related processes.
. Provided advice in Table Partitioning in alignment with logical/physical
modeling, data replication by using Golden Gate, DataGuard and Advanced
queuing.
. Lead/participate in database projects and work with partners to bring
projects to successful and timely completion.
. Plan, design, enhance, and maintain decision support database solutions
using Oracle OBIEE, Oracle EE RAC 11gR2 and Netezza Technologies.
. Drive data standardization, data integrity and quality, identify to
promote Data Warehouse best practices and patterns for data models.
. Leverage in-depth knowledge of database clustering technologies to design
and administer several clustered warehousing databases by using Oracle
Weblogic 11g.
. Performed complex query tuning for mission critical Web applications and
used analytical functions.
. Performed batch load from MS SQL 2008 to Oracle database by using Oracle
Data Integrator for SAP BW and ECC.
. Work with the application development groups to design ER data models and
Dimensional data models.
. Perform database management tasks including database infrastructure
design, automation of data loads, performance tuning, SQL programming,
space management, backup/recovery(RMAN), and version control.
Northrop Grumman Corporation, New York City, NY
2009 - 2010
Senior DBA/Architect
A leading global security company whose 120,000 employees provide
innovative systems, products, and solutions in aerospace, electronics,
information systems, shipbuilding and technical services to government and
commercial customers worldwide.
. Monitor and optimize database performance as it relates to partitioning
strategies, index tuning, ETL, and query optimization on a Data
Warehousing environment.
. Responsible for installing, designing, patching and migrating Oracle
10.2.0.3 to 10.2.0.4 in AIX, Windows, HP/UX, Linux and Sun environment
with Data Guard and RMAN.
. Applies comprehensive business processes, application design and
functional knowledge in problem resolution.
. Responsible for decisions impacting a team and may provide input into the
decision making process for larger decisions. Proposes and defines
solutions and standards which may impact a team or the organization.
. Translate the logical data model into physical data model for optimum
performance and for integrity of relational data. Work with project teams
of programmers in fine tuning queries for optimal database performance.
. Provides leadership and expertise in investigation and resolution of
performance related issues for warehousing and complex system
environments. Creates and maintains database logical and physical
designs.
. Implements improvements to process and code used for automating
maintenance and operational tasks in various systems including critical
complex systems, warehousing systems and other OLTP systems, using
PL/SQL, PERL, shell.
. Leverage in-depth knowledge of database clustering technologies to design
and administer several clustered warehousing databases.
. Collaborate with release teams to provide analysis, design,
development, ETL process and testing guidance and support.
. Evaluated Oracle features and product to complete the Proof of Concept
for new platform.
Societe Generale, New York City, NY 1999
- 2008
Senior DBA
One of the main European financial services companies and also maintains
extensive activities in others parts of the world.
. Led team responsible for development across multiple environments,
related to fixes/patches, enhancements and upgrades to existing
functionality including code changes and code review to existing objects,
interfaces and conversions necessitated by data fixes, functionality
patches, and upgrades; as well as production support tasks related to the
identification, tracking and resolution of issues found in the production
environment.
. Architected and Rationalized global HRMS (HR, Payroll Interface, ESS,
MSS, eProfile, eDevelopment, eRecruit, ePay, Talent Managements,
Compensation and bolt-on modules and interfaces) Application portfolio.
. Developed business strategies to create new or enhance existing
conversions and interface programs to meet the user requirements. These
will include, technical analysis, technical design (technical
specifications), development, unit testing, unbundling of code,
customizations, and documenting code using PeopleSoft HCM 8.8, SP1 Tools
8.49 and Oracle 11G Platforms.
. Responsible for installing, designing, patching and migrating Oracle
9i/10g/11g and Sybase ASE 15.0, Rep 12.6 for global critical
application. Setup Backup and recovery process by using RMAN and Data
Guard
. Completed to support Sybase and Oracle data warehouse architecture in
large terabyte environment.
. Monitored database by using Oracle Stats pack, AWR and ADDM reports.
. Responsible to build DR servers by using EMC SRDF, BCV, Oracle RAC,
VERITAS Cluster Server and implement change control procedure.
. Tune the configuration parameters for all Sybase/Oracle/MSSQL Server for
better performance of relational databases by analyzing system resource
utilization.
. Maintain SQL security, SQL Agent job scheduling, planning, monitoring and
creating user accounts for proper access; and; SQL/Server system tables;
SQL Profiler and Enterprise Manager; and Server monitoring to ensure
adequate CPU, disk space, and memory on all SQL servers
. Managed and completed the implementation of EMC/SAN/VERITAS migration
between NY and NJ.
. Creation and review of Technical Designs; unit testing; bundling/un-
bundling of code using PeopleTools 8.49 and Oracle 11G Platforms.
. Complete the project to convert UDB/DB2 to Oracle for LOANIQ application.
. Complete three full lifecycle PeopleSoft HR and Benefits Administration
implementation
. Evaluate Oracle features and products and establish policies and
procedures.
. Designed and implemented to replicate data from Paris (Oracle 7.1) to NY
(Sybase 12.5) for BDR project by using Sybase Direct Connect, Oracle
Transparent Gateway and setup streams replication in 10g.
. Completed the migration for Calypso application to Sybase 15 for Fix
Income derivatives.
. Built a firm-wide technology community and efficiently engaged over 300
people across business and technology areas to define standards, identify
issues and present resolutions in the Desktop, Network, Server and
Storage technology domains.
Lehman Brothers, New York City, NY
1997 - 1999
Senior DBA
A global investment bank serving the financial needs of corporations,
institutions, governments and high-net-worth investors worldwide.
. Responsible for a subset of the development, customization and
integration work associated with the expansion of the current PeopleSoft
baseline to include new modules and/or new functionality to existing
modules.
. Responsible for installing and designing Sybase Adaptive Enterprise
server 11.5.1 and Oracle 9i for global critical application.
. Responsible for evaluation and development of PeopleSoft, Business
development and managing internal and external projects.
. Design and create two way Sybase replication between London, NY and Tokyo
for trading application.
. Designed disaster recovery plan between WFC and NJ cites.
. Responsible to setup database standards and guidelines to manage and
maintain Oracle, MSSQL and Sybase relational databases
. Implemented global replication data synching strategy by using Oracle and
Sybase.
Prudential, Roseland, NJ 1996 -
1997
Senior System Architecture, DBA and Project Leader
A Fortune Global 500 and Fortune 500 company whose subsidiaries provide
insurance, investment management, and other financial products and
services.
. Responsible to tune the configuration parameters within Oracle Server for
better performance of relational databases by analyzing system resource
utilization.
. Responsible to do the project management for planning, design and
implementation resource management to complete VLDB project.
. Defined the backup and disaster recovery procedure for
Oracle/MSSQL/Sybase server.
. Implemented production master database shrunk and designed disaster
recovery plan and server failover mechanism.
. Led development of overall cross channel/product OnePru architecture
focusing on the knowledge-based business applications and object/data
modeling.
Lehman Brothers, New York, NY 1995 -
1996
Senior UNIX SA and DBA
A global investment bank serving the financial needs of corporations,
institutions, governments and high-net-worth investors worldwide.
. Designed the performance monitoring by using STATSPACK, OEM, UTLBSTAT and
UTLESTAT for oracle servers.
. Development, test, migration and scalability reviews of the Oracle E-
Business Suite
. Manage and maintain solid backup, recovery, disaster recovery planning
and implementation, shell programming, database migration and system
changes.
. Responsible for the migration and patch for Sybase, Oracle and MSSQL
database to and from different organization environments (production,
dev, testing, etc) and coordinate strategies to move data between
databases.
. Create and update database policy and procedures documentation.
. Interfaced with London, HK and Tokyo to setup replicate sites, routes and
define data server function classes and function strings.
. Responsible to develop Replication system disaster recovery, warmstandby
and latency checking.
. Responsible for installing and designing Sybase Replication server 11 for
global critical application.
. Led the Technology Selection Process to identify eBusiness product
components. Responsible for business requirement development, project
management, vendor relationship management, issue resolution, technology
due diligence, & selecting final products.
Technical Addendum
Applications: PeopleSoft Enterprise (HR, payroll & Benefits), PeopleSoft
General Ledger, PeopleSoft Financials Expenses, PeopleSoft
EnterpriseOne, Oracle E-Business Suite, Calypso, Loaniq,
Opics, Opus, Summit, Oracle Discover, Oracle Fusion, Oracle BI
tool OBIEE, Oracle Data Integrator (ODI), Oracle SOA, Oracle
Fusion, SAP Business Suite, SAP NetWeaver
Databases: Sybase, Oracle, Informix, MS SQL and UDB/DB2
Hardware Platforms: Sun Fire v280, v880, v1280 server MP-690, MP-670,
Sparc 5, Sparc 10, Sparc 20, Sparc 1000, Enterprise 3000,
4000, 4500, 6000, M5000, EMC Symmetrix 3600, 3700, 8530.
Ultra 1, Ultra 2, Ultra 5, AT&T 3B2 (600, 1000), RS6000, IBM
3090, IBM 36xx.
Operating Systems: Linux, SunOS 4.1, 4.1.1, 4.1.2, 4.1.3 and Solaris
2.3/2.4/2.5/2.6/2.7/2.8/2.10, Windows (9x, XP, 2000, 2003,
NT), Citrix, SCO, Digital UNIX V4.x, IBM AIX V4.x/V5.x, HP
UNIX 10.10, MS-DOS 6.2, Novell NDS, Netware 4.x
Network Env: Windows (2000, NT), Netware (3.x, 4.x), NFS, NFS+,
TCP/IP, IPX/SPX, MS Terminal and Citrix
Web Servers/Tools: Weblogic 11g, BEA/Tuxedo server 6.5, BEA/Jolt V1.1,
IBM Websphere, IE 5.x/6.x/7.x, Netscape, Firefox, MS front
Page, HTML, DMTML, XML and Notes R6
Languages: SQL, PL/SQL, Basic, MF-COBOL 5.x, Merant COBOL, C, C++,
FORTRAN, Pascal, Assembly, RPG II, DL/1, IMS, TSO
Software: Sybase Replication server 15.0, 12.5, Sybase Open Client (DB-
Library, CT-Library), Sybase Open Server, SQR, ISQL, Transact-
SQL, Sybase Audit Server, APT, DWB
Oracle 8i, Oracle 9i, Oracle 10gR2, Oracle 11g, sqlplus,
PL/SQL, Oracle RAC, Oracle RMAN, Dataguard, Streams,
Enterprise Manager(OEM), MS SQL 2000, MS SQL 2005, MS SQL
2008, DB2 UDB, Informix 7.2
Unix Shell (C, Korn and Bourne), Perl, Sunview, X11R4, X11R5,
X-Windows, Motif/OSF, Open Look, Sun ODS, Sun Net Manager, Dec
Athena (Kerberos, Zephyr, Moira), Framemaker,, Lotus Notes,
DBArtisan, Erwin, PowerDesigner, Informatica PowerMart,
ESSbase, RDJ, MQ Series, Tibco, BMC SQL-BackTrack, BMC Patrol,
Platinum Enterprise DBA, CA Autosys, Oracle Fusion Enterprise
Application, Sybase IQ, Quest, TOAD, VERITAS Netbackup, HP
Openview, Oracle Designer 2000, Oracle SQL Developer
People Tools: Application Designer, Application Engine, Component
Interface, Business Interlinks, Application Messaging, Objects
peopleCode, Process Scheduler, Upgrade assistant, Security
Administrator, XML Messaging, Application Upgrader, Import
Manager, Data Mover, PS Query, Work Flow Designer, Crystal
Report, nVision, SQL/SQR
Version Control: STAT V4.x from Quest and Schema Manager from Oracle
Disaster Recovery: VERITAS HA (High Availability) cluster, VERITAS
Cluster Server(VCS), EMC SAN/SRDF/BCV, Oracle, Real
Application Clusters(RAC) Grid, Automatic Storage Management
(ASM), Cluster Ready Services (CRS), Weblogic Cluster
Project Mgt. Tools: Visio, MS Project 2000 and MS Office 2000
Education: MS in Computer Science - Stevens Institute of Technology
Hoboken, NJ
Contact this candidate