Long Hong

*** ***** ** ****: 650-***-****

San Bruno, CA 94066 Cell: 415-***-****

acvu54@r.postjobfree.com

SUMMARY

Thirteen years in Oracle Support Services supporting various applications include financial, manufacturing and Customer Relationship Management (CRM). Worked with various application releases: 11i, 11.0.3, 10.7(Character, SC & NCA), 10.6.1(Character & SC), 10.4.2, and 9.4.2 as a functional and technical analyst. Tasks involved application install, upgrade, patching, set up and 3rd party software integration, Windows XP/Windows 7, 2000, 2007. Twenty five years of data processing experience in data modeling, logical and physical database design (including performance analysis and tuning), project assistant plus programming on mainframe and product support in Oracle Financial Applications. Six years in the area of data modeling and database design for CODASYL (IDMS) and light experience with DB2. Applications include financial, manufacturing and order entry. Recognized by manager for outstanding problem solving and technical assistance to coworkers.

.

EXPERIENCE

City College of San Francisco (Culinary Department) 05/2016 - Present Senior Clerk

• Type, submit, and file TPAs for CAHS/CCST and any new program offered by CAHS, filing hourly paid assignment forms, personnel requisition forms, menus, and student application database.

• Heavy public contact by phone and in person with students, faculty, and other departments at CCSF

• Maintain a variety of operational, administrative, and student records, such as current and past student databases, accommodation and account log, faculty assignment log.

• Prepare and submit payroll for faculty, students, and classified staff.

• Maintain office supply inventory; order all office supplies.

• Process enrollment verification and other types of student academic history of CAHS program.

• Set up interviews, orientation dates, and tours for new students.

• Summer support: opening/closing kitchens, classrooms for trades people and engineers. Being on-hand to assist students and department advisor preparing for new semester.

• Answer basic questions about the department and programs.

• Hire and supervise student lab aides and college work study students to work within the department.

• Maintain department calendar (classrooms schedule, events, and other important dated events).

• Work closely with department chair and department advisor on projects such as, Wok on the Wild Side fundraiser, updating new student information package, maintaining marketing materials

• Attend monthly staff meeting and take detailed notes

• Disseminate and keep up-to-date new CAHS student applications. Responsible for initial processing of applications, under the direction of CAHS advisor. For example, ensure students are notified of incomplete applications and what is needed, explain the steps in the application process, answer general questions regarding applications and deadlines. Ensure new students have ordered their uniforms. Contact students regarding registration dates, orientation dates, other reminders as needed.

• Interface with the A&R Department to ensure students' major codes are entered and that they have the correct registration date; maintain the list of current and graduated students.

• Assist in disseminating and updating outreach and recruitment materials. City College of San Francisco (Academic Counseling Dept.) 12/2015 - 04/2016 Senior Clerk Typist (Promotion)

• Answer telephones promptly and professionally

• Respond to all voicemail messages for four office locations..

• Manage SARS/GRID electronic appointment system which includes, creating master templates, booking student appointments, marking attendance and printing out table and statistical reports.

• Maintain office files. Log and distribute incoming and outgoing office correspondence and mail.

• Duplicate and fax documents as needed.

• Prepare Microsoft and Excel documents and perform related computer skills using Access.

• Interact cordially, empathically, effectively and professionally with students, the public and CCSF personnel.

• Prepare and submit requisitions for supplies, furniture, and other office supplies. Keep track of inventory of said items.

• Prepare work assignment forms for counseling assignments.

• Keep track of counselors' flex schedules and sick leave.

• Print our records in the Banner computer system.

• Assist Department Chair in tracking budget expenditures.

• Assist Department Chair with audits and paperwork.

• Assist with special projects such as assessment of Student Learning Outcomes

• Maintain coverage schedule for front counter, receive and interview general student population and provides information on department activities.

• Perform other duties as needed.

Department of Election 10/2013 - 12/2015

Junior Clerk / Fed Election Deputy

• Make contact with other office personnel and inquire all the questions to the general public election.

• Gathers, prepares and maintains a variety of records, reports and documents relative to the Department of Elections’ operations.

• Recruits and trains poll workers all of whom administer mandated procedures and provide services to a linguistically and culturally diverse voting population.

• Maintains polling locations following the guidelines set forth by the departments.

• Proofreads official ballots and Voter Information Pamphlets in English and Chinese.

• Checks ballot measures and the proponent and opponent arguments and paid arguments that appear in the Voter Information Pamphlet.

• Maintains voter registration affidavits and verification of petition signatures.

• Organizes secure storage of voting equipment, materials and supplies.

• Provides information, such as voter registration, polling places, ballots, volunteering at the polls, to the public in a professional and courteous manner through email, over the phone or in person.

• Performs basic mathematical computations using addition, subtraction, multiplication and division of whole numbers, decimals and fractions; and other duties as assigned. DiGi Company

General Clerk-PT 12/2010 - 10/2014

• Maintain sort, examines, index, and file various documents and review these documents for accuracy and completeness.

• Perform a variety of mathematical computations in the preparation of requisitions and ordering of supplies and material

• Help set up filing system by typing, printing labels, putting labels o hanging folders.

• Prepare and track purchase requisitions and vouchers

• Retrieve document records, process work orders, order supplies and material

• Assist clients with questions and issues.

• Maintain office equipment by replenishing and servicing for fax, copier, scanner, trouble shooting computer problem.

• Perform other clerical duties as assigned.

Oracle Corporation, Redwood Shores, CA. 04/1995 – 07/2008 Principal Immediate Response Engineer (05/2006 – 07/2008)

Performed Testing Service engagement for the following clients:

• Quebec Province, Canada (Jan/2008 – July/2008)

Capacity Baseline and Instance Load Profile Testing.

Performed On site support for the following client:

• Applied Materials Inc. (Feb/2007 – May/2007)

• Master Card Inc. (Sep/2006)

Performed Testing Service engagement for the following clients:

• Cox Cable Inc. (Oct/2006 – Nov/2006)

Capacity Baseline and Instance Load Profile Testing.

• Beckman Inc. (July/2006 – Aug/2006)

Capacity Baseline and Instance Load Profile Testing.

• Dell Inc. (June/2006 – July/2006)

Capacity Baseline and Instance Load Profile Testing.

• Motorola Inc. (May/2006 – June/2006)

Business Flow Testing.

Principal Service Delivery Engineer (04/2003 – 05/2006)

Performed On site support for the following clients:

• Applied Materials Inc. (04/2003 – 05/2006)

Assisted Applied Material DBA groups on Oracle 8i migration and 9i implementation for their production Sun Solaris and HP platform. Resolved several major issues during 9i implementation for both platforms. Worked on site to support their production environment for 11.0.2 Oracle Manufacturing modules and Their 8i and 9i database. Assisted Applied Materials IT staff for their 11i (11.5.9) upgrade pilot project. The 11i pilot projects completed in 4 months.

• Veritas (06/2005 – 07/2005)

Assisted Oracle Solution Support Center on managing their critical application issues prior to their quarter end so Veritas can complete their merger with Symantec. Project completed on schedule. Senior Systems Engineering Specialist (01/98 – 03/2003)

Performed On site support for the following clients:

• SGI (06/2003 – 05/2004)

Assisted SGI IT Staff to completed 2 major projects: 9i upgrade (December 2003) and 11.5.9 upgrade

(February 2004). Worked w with SGI DBA to resolve several critical issues on Concurrent manager and Workflow prior to their 11.5.9 go live. Worked and resolved several P1 tars at SGI (March 2004).

• Sandia National Lab (01/2002 – 02/2002; 05/2002 – 06/2002) Performed 4 weeks (Jan 2002 – Feb 2002) on site support at Sandia National Lab, Albuquerque NM. Assisting functional users and DBA to resolve their critical issues in following applications: AP, FA, PA, PO, BOM, Engineer, INV and MRP. All critical issues were resolved and Sandia National Lab was able to implemented their 11.5.5 ERP and Manufacturing in March 2002. Several database issues were resolved prior to go live in March 2002. Phase II will be roll out in mid June with iProcurement and iSupplier Portal. Performed 4 weeks (May 2002 – June 2002) on site support at Sandia National Lab, Albuquerque NM. Resolved all critical issues and Sandia National Lab was able to implemented phase II iProcurement and iSupplier Portal in mid June 2002. Several database issues and 9ias were resolved prior to iProcurement and iSupplier Portal went live in June 2002

• Agilent Technologies Inc. (02/2001 – 09/2003)

Assisted Oracle Consulting team (DBA) at Agilent Technologies Inc. to resolve several issues: Express Server 6.3.2 environment for Oracle Demand Planning; AR Customer function; Research and applied up to date application patches for 11.5.3 release. Assisted Oracle Consulting team at Agilent Technologies on research of all applicable patch set E to be ready once Agilent ready to upgrade from 11.5.3 to 11.5.4.

• Veritas Inc. (05/2000 – 02/2001)

Assisted Veritas/KPMG CRM team on critical issue after gone live with 11.0.3 in November 2000. Assisted Oracle Solution Support member to be familiar with CRM 3iv2 module Sales on Line implemented at Veritas. Assisted Veritas financial users and IS&T staff on data fix in AR application due to out of balance in posting for month of January - Year End process for fiscal year 2000.

• Performed 1 week Remote Service as Apps DBA for JDS Uniphase Inc.

• Performed 1 week Remote Service for PacWest Inc. Assisting Oracle Remote Service DBA to complete task in cloning an CRM (OSC) 11i environment from a production staging environment.

• Xilinx Inc. (02/99 – 05/2000)

Worked on site as technical writer to help document all implemented customized extensions within Oracle applications. Tasks involved document Forms, Reports and Database objects: Tables, Views, Triggers and Alerts). Assisted their Production Control Administrator in developing a version control for future development of their customized components.

• Pacific Bell Directory Service (SBC) (11/01/99 - 11/30/99) Completed Financial applications upgrade from 10.6 SC prod15.1 to 10.7 SC 16.1 for their Internal audit division at San Francisco. Applied all Y2K compliance patches.

• Pacific Bell Directory Service (SBC) (11/01/99 - 11/30/99) Completed Financial applications upgrade from 10.6 SC prod15.1 to 10.7 SC 16.1 for their Internal audit division at San Francisco. Applied all Y2K compliance patches.

• Silicon Valley Group Inc. (06/99 - 10/99)

Completed Financial and Manufacturing applications upgrade from 10.6 to 10.7 16.1 at Scotts Valley facility. After completed 10.7 upgrade, install Projects 10.7 SC prod 16.1. Planed and applied all Y2K compliance patches to all applications. Assisted user testing for Y2K readiness project. Mentored a new hire to take over the account at the end of October.

• Homestake Mining Company (08/98 - 05/99)

Completed Financial applications (GL, FA, AP & PO) upgrade from 9.4.2 to 10.7 16.1 for 3 sites. Assisted client to merged their 1998 AP - 1099 data to one tape file. Help client to upload their 1999 budget to GL. Assisted their end users to redefined their FSG reports to use the new budget. Reviewed all applicable Y2K patches and applied them to their instances. Assisted their DBA to install ADI(Applications Desktop Integrator) for their financial users.

• KPMG LLC. (10/98 - 04/99)

Assisted KPMG consultants to implement their R2I project (Oracle Application R11 with set up). Help escalated critical issues to development.

• E*trade Securities Inc. (10/98 - 01/99)

Assisted Oracle consulting team to implement release 11.0.1 application modules: GL, FA, AP, PO and HR. Help Oracle consultants to escalated critical issues to development.

• Inprise Inc. (07/98 - 10/98)

Assisted Oracle consulting team to implement release 11.0.1 via Fast-Forward program. Assisted Ernst & Young consulting team on implementing 3rd party Sales Tax Integration Software: Vertex. Worked with Global Financial Applications developer on resolving Pl/Sql sales tax integration solution with AR & OE. Client went live on October 12, 1998.

• Sun Micro System Inc. (04/98 - 06/98)

Assisted client in balancing their AR book since they went live on October 1997 Help client correct their 4 months financial data. Assisted in reconcile AR to GL so they can closed their financial book for fiscal year 97/98.

• Fujitsu PC Company (01/98 - 03/98)

Help client correct their financial data and balanced their AR book for fiscal year of 97. Technical Specialist (04/95 - 12/97)

Performed product support for the following Oracle financial application: Account Receivable, Oracle Sales Compensation and Oracle Sales & Marketing.

Handling and resolved critical issues in product support for AR, Sales Compensation and Sales & Marketing. Also served as team leader for AR, OSC and OSM.

Performed training and assisting associate analysts in product support.

Enhanced and documented financial application support procedures for Oracle Worldwide Support team

Advanced Cardiovascular Systems, Santa Clara, CA. 07/1994 - 03/1995 Contracted Consultant

Performed enhancement and maintenance of the following CAS application systems: Account Receivable, General Ledger and Order Entry.

Performed analysis, programming, documentation, program modification and debugging of the aforementioned systems.

Performed data dictionary migration and product support. AMDAHL Corporation, Sunnyvale, CA. 03/1994 - 05/1994 Contracted Consultant

Performed impact analysis and enhancement to an existing in-house application system: FAST(Field Activity & Service Tracking).

Modified on-line and batch programs to accept additional serial id from new hardware developed by Fujitsu. Performed application maintenance according service order requested by users. USL Capital (US Leasing International), San Mateo, CA. 1992 - 1994 Senior Programmer Analyst

Performed enhancement and maintenance of the following application systems: Account Payable, General Ledger, Lease Tracking System and Maintenance Tracking System.

Developed retroactive tax adjustment for vehicles beyond lease term allowing company to apply back tax billing for any state. Served as key member on MSA General Ledger conversion team.

Assisted DP operation in analyzing disk space utilization and improving run times for month-end process.

First Interstate Bank, Los Angeles, CA. 1986 - 1991 Database Analyst/Administrator (1990 - 1991)

Shared responsibility with one other person for the data modeling, design, implementation and maintenance of databases (in IDMS) supporting 7 financial systems.

Performed data administration/data dictionary functions.

Defined and enforced program coding and JCL standards.

Implemented the PRESSPACK utility result in 60% disk space savings.

Redesigned portions of a vendor supplied IDMS application for 50% savings in run times. Senior Programmer Analyst (1986 - 1989)

Completed, implemented and enhanced a large custom-designed Performance Reporting System (PRS) that produced detail and summary reports for branches and each level of management, which resulted in reduced elapsed run times over 30%.

Served as key member on conversion of 3 financial applications during the installation of MSA General Ledger System software. Involved heavily in database CALC key Conversions.

Designed, programmed and implemented a Credit Charge/off Recovery system. Tenneco West Inc., Bakersfield, CA. 1982 - 1986

Programmer Analyst

Worked as Programmer Analyst on the following Cullinet Application System: BOM, INV, MRP and General Ledger. This includes analysis, programming, documentation, program

modification and debugging of the aforementioned systems.

Developed an in-house Mail Order System with substantial user interaction.

Converted all IDMS applications from DOS/VSE to MVS/XA in 6 months. TECHNICAL EXPERTISE

Software Tools: Oracle10g, 9i, 8i, 8 RDBMS, Sqlplus, Oracle ERP/CRM Applications releases: 9.4.2, 10.4.2, 10.5, 10.6.1, 10.7, 11.0.3 and 11i. Developer 2000, MVS COBOL/COBOL II, MVS JCL, TSO/ISPF, VSAM, IDMS Batch COBOL, IDMS DC COBOL, On-line Mapping Facility, ADS/On-line, ADSA, IDD, OLQ, CULPRIT, Logical Database Design, Physical Database Design, ADS/On-line Internals, IDMS Database Performance and Tuning, Data Modeling, CICS Command Level, DOS/VSE JCL, PC/DOS, PC/Windows, Word Perfect, Excel, Endeavor, PANVALET, CA SORT, DYNAM D/T and QUIKJOB.

EDUCATION

Computer Science - Bakersfield College, Bakersfield, CA, 1982 Certificate of Data Processing - Bakersfield College, Bakersfield, CA, 1981 Van Hanh University, Saigon, Vietnam

Contact this candidate