George Sheen

US Citizen

IBM CERTIFIED IT SPECIALIST

IBM CERTIFIED IT INFORMATION (DATA) ARCHITECT

**** **** **.

Richardson, Tx 75080

Phone: 972-***-****

Email: ac6dlm@r.postjobfree.com

Objective

Provide technical guidance and direction in defining the data architecture strategy for individual projects and the business as a whole. Work with senior management, technical and client teams in order to determine data requirements and best practices for advance data manipulation, storage and analysis strategies in a data warehouse environment.

Profile

Experienced IBM Certified Senior IT Specialist, IBM Certified IT Information (Data) Architect and IBM Certified DB2 Solution Expert with concentration on AIX, CICS, DB2 UDB, Linux, Oracle, PopleSoft, z/OS and WebSphere Application Server on z/OS and UNIX platforms.

Extensive IT experiences with roles ranging from System Programmer to IT

Architect. Industry experiences in automotive, banking, distribution, energy & utilities, financial services, healthcare, insurance, life sciences, manufacturing, and telecommunication.

Has strong expertise in capacity planning, disaster recovery, financial analysis,

performance analysis and tuning, project management, requirement analysis, security

design, system development and system integration.

Qualifications

Database Architect with over 17 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.

Extensive hands on experience using Oracle 12c, 11g, 10g, 9i, DB2 and SQL Server databases and several of its tools.

Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.

Solid experience translating business requirements into conceptual, logical, and physical data models.

Implement best practices and methodologies in data analysis, design and modeling.

Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation, including ETL across different platforms, DB2 to Oracle VLDB databases and flat files.

Management and development of an enterprise tailored taxonomy. Categorized internal and external data collections and ensure users find the information they need with speed and precision.

Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.

Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.

Provide guidance and work leadership to less-experienced staff members.

Professional Experience

Citi Technology Inc. Feb 2015 – May 2018

Oracle DBA Irving, TX

Key Responsibilities

Backup and Restore strategies during disaster scenario.

Migrating and moving data between environments.

Provide support and resolve issues.

Troubleshoot Oracle Data Guard environment.

Troubleshoot Database Performance problem.

Participated in the installation and configuration of Golden Gate, Troubleshoot Golden Gate replication issues, applied database patch and Golden Gate patch, and monitored database replication using OEM Grid Control.

Experience and Skills

Experience as an Oracle Database Administrator .

Knowledge in installation and configuration of Oracle Enterprise Server software.

Expertise in data migration and movement technologies such as RMAN, Datapump, Exp/Imp, Transportable Tablespaces etc.

Working knowledge of Data guard replication.

Knowledge on ASM DG.

knowledge of UNIX / LINUX operating systems with shell scripting.

Expertise in backup / restore strategies.

Basic troubleshooting on performance problem.

Knowledge on Migration and upgrades from different Oracle versions.

Researched and resolved DBMS system problems and assisted in the resolution of application problems

Established DBMS system security standards and support Security Administration in maintaining access controls.

Apply PSU patches to 11.2.0.4 version of oracle databases including rolling patch for RAC Systems.

Monitor performance and tune all DBMS subsystems.

Support application performance review and tuning efforts.

Provided UAT, DEV Database request support for application developers.

Implemented High availability using Data Guard and Golden Gate

Installed Oracle 12c on many development servers and UAT servers.

Installed ORAAS on many development servers and UAT servers.

Database Security Architect/DBA Contractor

AT&T

May 2013 – Feb 2015

Performed business analysis, logical and physical database design using CASE tools for AT&T Corporate wide legal and managerial consolidated financial statements. Provided data architecture designed to eliminate discrepancies in managerial and legal results.

Architecting & implementing enterprise & business segment OLTP solutions.

Expert level production & development database administration – all platforms.

Logical and physical database design, modeling & implementation of enterprise. Customer and household profitability data warehouse.

SQL Server and Informix to Oracle migration for a suite of enterprise applications.

Expert level stored procedures development in Oracle, SQL Server & DB2 environments.

Expert level UNIX shell script development for automating ETL processes, data loads, instance data migration & database or file system backup and restores.

Responsible for the installation/migration of Oracle databases in the industry application systems. Participated in the installation and configuration of Golden Gate, Troubleshoot Golden Gate replication issues, applied database patch and Golden Gate patch, and monitored database replication using OEM Grid.

HR SUITS application development converting C++ code to PL/SQL

Application DBA Contractor

Client: Citi Group

Mar. 2011 – May 2013

Architected and implemented development environment in support of 20 databases at infancy to 500+ at peak.

Installed and configured database systems for company’s Production, QA, and development servers.

Citi bank branch/ ATM infrastructure architecture, design and deployments.

Managed computer system capacity planning and allocation worldwide, provided synchronized global source code access, selected and deployed a uniform set of Java, C++ development tools, identified and created system-level script as needed to automate redundant tasks, and defined and maintained a standard technology stack definition for both Production and customer deployment.

Enabled non-stop product development by software engineers.

Ported products to run on Linux, Solaris, HP-UX, AIX, and Windows x64.

Successfully commercialized large in-memory planning by widening products from 32-bit to 64-bit.

Established alliance relationships with all major system vendors in support of company’s C++ and Java product development and implementation.

Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development. Organization all existing data models, data flows and data dictionaries into a Meta Data Repository. Created physical models of all databases and logical models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.

Assisted application development in the installation/migration of Oracle database servers including 11.2.0.3 RAC/Data Guard using OEM/Grid infrastructure.

To provide 24 x 7 application support for PROD/UAT/STAGE databases

Provide FULL support for IST/ DEV/TEST databases

To process STRs/SIRs related to application changes and problems.

To restore PROD dumps to UAT/DEV/ IST environments based on user needs and masking/data scrambling if required

To provide support for app related changes such as Object creation, schema creation, altering schemas etc

To maintain object level permissions and grants

To setup maintenance jobs for daily/weekly/monthly processes for purging, performance stats etc

To run update statistics on a periodic basis

To monitor DEV / IST / UAT server resources and performance

To provide support for SQL tuning and suggestions for performance improvement

To work closely with development teams to assist in overall database design, such as creating normalized databases, helping developers tune queries, assign proper indexes, and aiding them in creating triggers and stored procedures.

Responsible for logical backup (schema level export) and restore (schema/table level import)

To develop, implement & maintain application data archive & purge processes as necessary for DEV / IST / TEST / UAT / PRD / COB database environments

Data Base Administrator

Client: JP Morgan Chase & Co.

Feb. 2010 – Mar. 2011

Worked closely with the system architect, data management director, product manager, and end users to develop the requirements and system architecture for a new customer centric repository (CCR), designed to be both the system of record for clients and the source for statistical analysis.

Designed and implemented the logical and physical data models for the CCR.

Chase bank branch/ ATM infrastructure architecture, design and deployments.

Data Architecture for Internet Data Aggregation. Provided data models and data maps (extract, transform and load analysis) of the datamarts and feeder systems in the aggregation effort.

Designed and implemented a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the Chase/Morgan merger.

Designed the Information Model for transformation of the Traditional Credit Product infrastructure.

Responsible for Oracle database performance, tuning analysis, and capacity planning.

Database Administrator

Client: Kaiser Permanente

Aug. 2008 – Feb. 2010: IBM Global IT Delivery

Clean and maintain the database by removing and deleting old data.

Working knowledge designing, developing and manipulating Oracle databases, data warehouses and multidimensional databases.

Responsible for Oracle database performance, tuning analysis, and capacity planning.

Relies on experience and judgment to plan and accomplish goals.

Performs a variety of tasks.

Works under little or no supervision; reports to the manager and allowed a certain degree of creativity and latitude.

Data Architect, IBM Global Services

Client: Department of Labor Industry, PA

Apr. 2007 – Aug. 2008

Physical data architecture and technical data architecture design under SOA

Defined data stores

Defined the key software/hardware components required to implement the physical concept

Developed Data Migration Plan

Advised on Database Performance/Tuning/Measurement

Produced Oracle Real Application Cluster and Automatic Storage Management architectural decisions and Architecture Overview Diagram work products

Logical and physical database design for an OLTP internet business to business communications and information system designed to help major financial institutions find, negotiate and agree to custom-tailored complex investment instrument transactions such as futures, options, swaps and other derivatives.

Data Architect, IBM Global Services

Client: California State Automotive Association (CSAA)

Oct. 2003 – Apr. 2007

Logical Data Architecture design

Physical Data Architecture design

Defined the conceptual and logical model of the data resources

Developed the physical data model of the database

Developed Storage Management Plan

Advised on Database Performance/Tuning/Measurement

Assisted with performance/scalability testing, and provided general assistance within the development and production testing environments.

Data Architect, IBM Global Services

Client: Aventis Pharmaceutical

Jul. 2001 – Oct. 2003

Physical Data Architecture design

Developed Storage Management Plan

Designed Physical Data Model

Advised on Database Performance/Tuning/Measurement

Implemented Middleware to support client-developed Web Portal application in drug discovery process of TLC (Target, Lead and Candidate).

Jul. 1988 – Jul. 2001 – IT Specialist, IBM Corp.

Market Support Representative for IBM Product Support Organization, Dallas

Product supported: CICS, DB2, IMS, MVS/ESA

Advisory System Integrator for IBM Southeast Region MVS Support, Irving

Product supported: MVS/ESA Availability

Senior IT Specialist for IBM Global Services, Dallas

Product supported: OS/390, z/OS, CICS, DB2, WAS

Key Courses and Training

Introduction to the Value and Governance Model of Service-Oriented Architecture

Design SOA Solutions and Apply Project, Technical, and Operational Governance

Technologies and Standards for SOA Project Implementation

Developing Applications with a Service-Oriented Architecture

Advanced Database Recovery and Repair in Oracle 10g

DB2 UDB for z/OS V8 Database Administration Workshop - Part 1 (DVL)

IBM Tivoli System Automation for Linux 1.1: Automating Complex Systems

IBM Tivoli Storage Manager 5.3 Overview

A Reference Architecture for Strategic Outsourcing and Service Delivery

Project Management Orientation (PMTO)

Client Consulting for IT Architects

Architectural Thinking for Experienced Professionals

Oracle9i Database Administration: Manage an Instance

IBM Global Services Method for Technology Integration Professionals

The IT Architect: An Introduction

Java Programming Advanced

Education

Ph.D. in Business Administration

Madison University, United States of America, 2002

Dissertation Title: A MODEL FOR THE DEVELOPMENT AND IMPLEMENTATION OF CORE COMPETENCIES IN INFORMATION TECHNOLOGY SERVICES COMPANIES FOR SUPERIOR FINANCIAL PERFORMANCE, 2002

Master of Science in Accounting

The University of Texas at Dallas, United States of America, 1997

Master of Business Administration in MBA

The University of Texas at Dallas, United States of America, 1995

Master of Science in Physics

Texas Christian University, United States of America, 1974

M.S. in Physics

National Taiwan University 1973

Languages

English Fluent, Chinese (Traditional) Fluent, Japanese Good, German Basic

Contact this candidate