SUMMARY OF QUALIFICATION

• Enterprise level data architect, systems design, data/database process, BI solutions, data gathering and integration, data warehouse and ETL development extensive experiences in data centers and hosting services.
• Eighteen year experience and in-depth knowledge of database, data, and functional needs of various business areas and of different industries
• Technical leadership in problem resolution and technical architect for large, complex database/application systems

PROFESSIONAL SKILLS

• Databases: Oracle 7/8i/9i/10g/11g/12c, SQL Server 2000/2005/2008/2012 Platforms: Unix HP UX, Sun Solaris, AIX , Linux, Windows 2000/2003/2008/2012
• ETL/ERP/BI: Oracle E-Business Suite, IBM InfoSphere ETL Data warehouse architect, SAS. Development: UNIX/Windows shell, PL/SQL, T-SQL, Perl, Toad, ERwin, CASE Studio, ER Studio Data Disciplines: ETL, data warehouse, data architecture, data modeling logical physical and relational - dimensional , metadata repository, data security, and data quality. Systems and Database Tools: VERITAS Netbackup Oracle and SQL Server Oracle RAC, RMAN, Oracle DataGuard Oracle Grid Control, StatsPack SQL Server Replication, Log shipping, AlwaysOn, SQL Mirroring, Application support: Cognos, SAS, PeopleSoft, SAP, Hyperion, Oracle EBS, Oracle Applications

PROFESSIONAL EXPERIENCE

Confidential

• Oracle 11gR2 RAC support for WebLogic portal application AHRS , Cognos and data warehouse, IBM InfoSphere DataStage configuration, Oracle Data Warehouse CDC and ETL . Database development with Toad
• SQL Server Integration Service, SQL Server Windows Cluster and SQL Server EMC Cluster support. Remedy ticketing system support. SQL Server replication
• DISA Oracle database STIG Security Technical Implementation Guides compliance implementation
• Awarded HP Enterprise Services Certificate of Excellence June, 2014 , received thank-you letter signed by brigadier general David K. MacEwen April, 2014

Confidential

• Installed, configured and managed Oracle E-Business R12 on Linux. Architected and migrated the production from one environment to other with incomplete backup.
• Architected and built centralized monitor/alert systems for connected multiple hosting sites internationally , hundreds of servers Windows, Linux and Unix , hundreds of databases Oracle and SQL Server
• Architected and integrated HSP Hosting Service Portal , WhatsUp Gold, BMC, Oracle OEM, SQL Management Studio, HP ServiceDesk and other COTS products to serve hosting service and customer needs.
• Architected and executed DR disaster recovery solutions between different hosting sites, to utilize Oracle Data Guard, SQL Log Shipping, etc and canned monitoring and alerting mechanism.
• Architected and developed large Oracle database migration solution between different platforms and between different hosting sites.
• Designed and developed large amount of Unix Shell, Window batch scripts for monitoring database backup status, database job status, database agent mode, database replication, standby database status, database file size and log size, among many other critical issues.
• Provided database availability solution with SQL/Oracle Standbys, Oracle RAC, SQL database mirror, database replications.
• Very large database architect and support for SAP, PeopleSoft, SAS, Oracle Application, MS SharePoint, etc.
• Served as technical architect for the US Navy's Planning and Budgeting Information System PBIS implementing Hyperion BI and system enhancement. Applied database and BI expertise to seize business opportunities and grew the project from one Oracle engineer into a full BI project that placed seven people in a year and generated two million dollars revenue.
• Served as technical lead for Transportation Security Administration's Transportation Worker Identification Credential TWIC project in the area of system/data integration, database security and system design and build-out that involved Microsoft BizTalk, IBM WebSphere portal, Oracle SQL Server databases, NetIQ, image scan/store/retrieve processes.
• Served as Enterprise Architect on the Modified EO/EP Determination System MEDS project for Internal Revenue Service's Tax Exempt and Government Entities TE/GE Division. Followed IRS EA Standards and proposed a strategic plan to address the existing system's inefficiency and weakness in the area of image capture and transmission, system performance and data security. Evaluated and suggested WebSphere MQ, WebMethods Information EAI Broker, EMC Captiva, SQL Server, etc.
• Helped building and leading the BearingPoint's Business Intelligence and Data Management Technical Solution team for public services to support all federal, state, local, and higher education programs.
• Proposal and Statement of Work SOW technical architect support of the Customer Data Integration CDI project for Presbyterian Healthcare Services, Alberta Health and Wellness's BI services, Information Technology Data Management Services of the State of New Jersey's Department of Energy's Division of Purchase and Property, among others.

Confidential

• Led project on database side among cross-functional teams. Gathered and analyzed business requirements. Reviewed database related artifacts, such as metadata, logical and physical models. Supervised developers with query tuning, table/index design and space growth planning.
• Led in a project of trouble-shooting performance issues. Worked a strategy and program mimic Oracle's system trigger to detect problem ahead of time to SQL Server's weakness . That resulted avoiding system unexpected downtime, a problem had been around for years.
• Expert with developing T-SQL based SQL Server backend application file processing and data loading, error detecting, business logic checking . Database backup, restore, lock-checking, database replications.
• Migrated Oracle 8i database into 9i with Oracle RAC support. That dramatically enhanced company's web site performance.

Confidential

• Fully responsible for EDISON data warehouse with data loaded from legacy system project Oracle DBA support. Extensive work on database physical design, database and SQL query tuning. Provided Ab Initio ETL developers and testers with SQL tuning and code reviews. Following Capital One and industry standard to resolve data and database security, performance and database design related issues.
• Utilized Oracle database partition and tablespace transport features to migrate terabytes of data both tables and indexes online and in/out database. Optimized table/index storage parameters, accurately predict tables/indexes growth to get the best physical database design and capacity planning, terabytes of data can be moved in new data and out old data database periodically.
• Fully responsible for Capital One's EDISON data warehouse project Oracle DBA support. Extensive work on database and SQL query tuning, database physical design.
• Fine tuned the ETL processes loading data into large multi terabyte data warehouses using Ab-Initio, SQL Loader and other homegrown tools.
• In charge of two major data warehouse production database support 30 TB and 25 TB each . Monitored additional 20 production Oracle databases daily.

Confidential

• Production, testing and development of SQL Server 2000 DBA support for company online applications. Database backup and recovery, performance SQL tuning, space management, database securities and replications
• Data modeling and Database design with Erwin 4.0 on SQL Server. Database development with extensive use of stored procedures and triggers to keep data in sync and to enforce business rules.
• Migrated data between databases with own ETL tools written in T-SQL and DTS packages. One of the databases was successfully reduced from 4G to 200M after redesign and optimization.
• Web development with ColdFusion, .Net VB and SQL Server. Helped web developers with generating XML data feeds between databases.
• Designed and developed CRM application with Excel VBA and SalesLogix for click-through data. Users can download the data through Internet in Excel format. Results were well received among sales and marketing people.

Confidential

• Involved in architecting GTSI's new fulfillment system NGFS , data modeling and database logical/physical design with ERwin. Supported PeopleSoft Financial application Oracle based
• Developed and documented process to support database development, testing and data migration for NGFS Fulfill System and JIT Just in Time database applications. Programmed Oracle stored procedures to increase developer's productivity and to keep data integrity.
• Database monitoring, trouble-shooting with DBArtisan, self-developed shell and PL/SQL scripts. Responsible for database backup and recovery, resource management, performance tuning and design tuning with SQLab Xpert, and database securities.

Confidential

• Using limited resource and time to quickly single-handed developed those SQL Server 7 database. Wrote simple web interface for the database. The databases were used by AOL worldwide analyst team to monitor AOL's 30-million user experience, and by client/host/network developers to trace software and system problems.
• Designed and developed data process routine to parse and summarize gigabits of raw data daily ASCII, Excel and Binary formats with limited hardware capacities. Developed stored procedures, DTS packages, VB and Perl programs to process and store the data into database.