Data Sql
Resume:
PO-CHING HUANG
*** *** ***** **. **** Covina CA *1791
Email: ac06ts@r.postjobfree.com
SUMMARY
I have been doing data warehouse/BI development and integration (SDLC) under Unix/Linux/Window and Oracle/Teradata/SQL environments. Utilized different ETL tools and wrote PL/SQL, SQL*Loader, SQL, Perl, UNIX shell languages and implemented Autosys scheduler system and Subversion (SVN reversion control system) for the past 10+ years. When Boeing moved IT staff to East coast, I took some time to travel extensively and care for my mother post-surgery. I am currently available and eager to return to work.
TECHNICAL EXPERTISE
Oracle Products:
Oracle DBMS, DBA, SQL, PL/SQL, SQL*Loader, Pro*C, Oracle Trigger, Oracle Web Server, Oracle Application, Oracle Financial (Rel. 11), Oracle Discover, Oracle Express, Oracle Enterprise Manager, Oracle EDMS
Operating Systems:
MS Windows, Linux/Unix, HP-UX, Solaris
Languages:
PL/SQL, SQL*Loader, SQL, Perl, UNIX Shell, C++, C, JAVA, HTML, JavaScript, EDI, XML
Databases:
Oracle DBMS, TeraData, SQL Server, Informix
Specialty Skills:
DataStage, Data Warehouse, Motif, X-Window, UNIX (IPC, TCP/IP Socket), Regular Expression
Methodologies:
ER Modeling, Start Schemas, OOA/OOD, OLAP/OLTP
Other Products:
T-SQL, SSIS, SSAS, SSRS, Autosys, Cognos, Hyperion, KI-Shell (workflow), AWK, Sed, and Subversion/CVS
PROFESSIONAL EXPERIENCE
The Boeing Company, El Segundo, CA
Data Warehouse Developer (Contractor) – 8/2003 to 5/2016
Analysis, development, implement, maintenance and performance tuning Boeing IDS financial data warehouse ETL (Oracle PL/SQL, SQL*Loader, SQL, Perl and Unix Shell) to populate the data into warehouse (Oracle 11g) from different systems
Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules
Enhanced the interfaces coding standard ensured the integrity, reliability and data quality of the Cognos reports. 24/7 production supports included data-fixed, bug-fixed, defect solution, fine-tune, optimize the system, production codes release procedure and maintain source code control system (Subversion)
The Boeing Company, Huntington Beach, CA
Data Integration developer (Contractor) – 10/2012 to 5/2016
Implemented enterprise data warehouse Autosys scheduler, Experience in IBM DataStage ETL tools, TeraData and Oracle database. Utilized Perl, Unix shell, PL/SQL, SQL, SQL*Loader and sFTP.
Implemented a production codes release procedure on subversion reversion control system (SVN).
Supported different teams (SQL Server, EDI/XML) on functional test, user acceptance test, pre-prod/production codes release, debug and troubleshooting.
Toyota Motor Sales USA, Long Beach, CA
Data Specialist (Contractor) – 10/2002 to 8/2003
Data Specialist in Toyota Order Management System (TOMS) project, supported in data population for functional test teams, performance test team, Training team and user accepted team
The data source come from DB2 database, Excel spread sheet, Vehicle Data Warehouse (VDW) and Toyota Motor Corp in Japan
The loading tools included SQL*Loader, PL/SQL, Excel Macro, ActiveX Components with Visual Base
Boeing Satellite System, El Segundo, CA
Programmer Consultant (Contractor) – 3/2000 to 4/2002
Implemented scheduler system for Boeing Cost Management System used AUTOSYS scheduler
The project is managing 300+ interface jobs between different applications which including Oracle financials, Data Warehouse, JIT, Fidelity HR and Legacy system
Wrote the PL/SQL code to map and populate data from Oracle financial PA to Enterprise Data Warehouse
Involved the
(CPR) project and utilized Oracle financial API to populate data into Oracle financial system
Nestle Foods USA, Glendale, CA
DBA/System Administrator (Contractor) – 1/1999 to 3/2000
Worked as a HP-UX System administrator and Oracle DBA for several applications
Supported Y2K testing/compliance
Integrated the Oracle Enterprise Backup Utility (EBU) on HP OmniBack for production systems and development systems
Oracle Corporation, El Segundo, CA
Principal Consultant – 8/1996 to 1/1999
Hughes Space and Communications, El Segundo, CA
Worked on ETL interfaces that involved interface with data warehouse from Oracle financial application and legacy system (mainframe)
Applied PL/SQL to perform the business rule and aggregate the data
Converted the legacy system into Oracle application data and installed Oracle Application Release 11(NCA) as an Oracle Financial DBA
Nextel Communications Inc., Oakland, CA
Replicated and transferred data in TRIS system to Oracle’s General Ledger, Data Warehouse and Commission system, including system architecture design, software re-engineering, and code implemented
Utilized PL/SQL language, Trigger, and Unix Shell scripts, apply Enterprise Data Management System (EDMS) tools to generate PL/SQL interfaces
Eaton Corporation, Eastlake, OH
Re-engineered financial application, utilized EDMS tools, set-up a development lab (HP-UX10.2) at remote site (Oracle offices), and supported ten developers
Performed tasks include system infrastructure setup, architecture design, system administration, DBA, EDMS support, and product test and delivery
Caesar’s Palace, Las Vegas, NV
Use EDMS mapping tools to map the flat file layout with PeopleSoft HR table schema
McDonnell Douglas, Long Beach, CA
Enhanced and integrated a three-tier Client/Server system which involved the broker’s daemons, client’s GUI (Oracle Forms 4.5), application servers and proprietary middleware
Hughes Space and Communications, El Segundo, CA
Integrated the Item Master and the Bill of Materials (BOM) projects at HSC from the Sherpa product data manager (PDM) and populated the data to JIT (a remote application) by using the PL/SQL, SQL*Loader, Pro*C and C languages
Computer Task Group, Inc., San Jose, CA
Programmer Consultant (IBM Subcontractor) – 1/1995 to 8/1996
Subcontract by IBM Consulting Group on a Workflow project for Hughes satellite analysis group to reduce model development time
Utilized C language with KI-Shell Workflow API library to access Oracle7 database
Utilized Product Data Management (Sherpa PDM), X-Window (Motif), KI-Shell workflow and Oracle DBA
COURSES
Oracle Database Administration, JAVA Programming Workshop,
Oracle Financial Technical Foundation, Oracle Application Release 11(NCA),
Oracle Express
C++ - UCLA Extension Program
X-Windows (Motif) - UCLA Extension Program
Advanced OOD/OOP using C++ - UCLA Extension Program
EDUCATION
New Jersey Institute of Technology, New Jersey
Master of Science in Computer Science
Tamkang University, Taipei, Taiwan
Bachelor of Science in Mechanical Engineering
Contact this candidate