Post Job Free

Resume

Sign in

Sr ETL Developer & Analyst

Location:
Brooklyn, NY, 11237
Salary:
40000
Posted:
February 08, 2011

Contact this candidate

Resume:

ZHENG WEI

ufzsvc@r.postjobfree.com

646-***-****

OBJECTIVE

Masters degree graduate with 7 years professional IT experiences, qualified for career opportunities where Oracle EBS 11i/12i development, Hyperion data warehouse implementation background will be of value.

KEY QUALIFICATIONS

• 7+ years Oracle development experience and 3+years Hyperion maintenance experience

• Proficient in PL/SQL Development, Oracle Report Builder 6i/10g, BI publish, and OA frame Development.

TECHNICAL SKILLS

• Oracle Application:, GL, A/P, A/R, Oracle FA, Cash Management. Core HR, Recruitment, Payroll, EPB, EPF

• Languages: T-SQL, PL/SQL, Java, PHP, UNIX Shell Script, HTML

• Report: Oracle Report Builder 6i/10g, BI Publisher

• Databases: Oracle: 8i/9i/10g, SQL Server 2000, MySQL 5.0,

• ETL Tools: Data Loader, SQL*Loader,

•Other Tools: Oracle Form Builder 6i/10g, Oracle Workflow Builder, JDeveloper(OAF), Toad

EDUCATION&CERTIFICATION

M.S., Information Technology Rutgers, the State University of New Jersey USA 09/2009-05/2010

B.S., Computer Science Tianjin University CHINA 09/1997-07/2001

IBM Certified Specialist AIX V4.3 System Administration 07/2001

IBM Certified Specialist Domino R4.6 for AS/400 Technical solutions 05/2001

WORK EXPERIENCE

The City College of New York New York USA 06/2010-present

Database Developer

ChangHongIT Co., Ltd Beijing, China 04/200*-**-****

ERP Team Manager

Centel Kingdom Co., Ltd Beijing, China 07/2001-12/2003

Software Engineer

PROJECT EXPERIENCE

CCNY 06/2010-Present

• MySQL database maintenance involving backup and restore and table data updating

• Developed Server end PHP program and transfer through SSH FTP

• Desktop support involving installing VMware and Linux fedora development environment setup

United Electronics Co., Ltd Beijing China 11/2007-04/2008

Oracle EBS R12

• Participanted in implementing A/R receipt applying invoices procedure.

• Developed PL/SQL procedure and worked on Order Import interface in OM, Purchase Order Import interface in PO Interface

• Designed and Developed A/R, A/P GL reports with report builder 10g

• Modified the Self service page item property on OA Frame with JDeveloper

• Developed SQL*Loader and PL/SQL programs Validated and interfaced AP Invoice data from Legacy system into Oracle AR

• Developed PL/SQL procedure and export XML file and build report using BI publisher

BoHai Bank of TianJin Tianjin China 07/2007-09/2007

Oracle EBS (11.5.10)

(Oracle Enterprise Planning and Budgeting, Oracle Enterprise Performance Foundation)

• Developed PL/SQL Procedure to load and validate dimension, fact, and measure data from legacy data into EPF open interface

ChangHongIT Co., Ltd Beijing China 04/2004-08/2007

Oracle EBS (11.5.8)

• Participated in implementing Order to Cash process and Requisition to pay (RTP) process.

• Participated in implementation of Hyperion data warehouse, Migrate reports from Oracle reports to Hyperion.

• Convert flat file data into Oracle database with SQL*LOAD and develop PL/SQL validation function

• Developed Script to migrate data through Data loader.

• Design and development of reports such as AR receipt voucher with Reports 6i

Centel Kingdom Co., Ltd Beijing China 07/2001-12/2003

• Responsible for constructing the triggers, tables, functions, views, user defined data type in the MS SQL server 2000

• Designed web application system using PHP accessing MS SQL server store and retrieve data



Contact this candidate