I. Qualifications

• Over twelve years analyzing Ellucian Banner System HR/Payroll data and over ten years Oracle Finance and Banner Finance data analysis experience.
• Over seventeen years' experience with Oracle 8, 8i, 9i, 10g , 11g Database Administration and Development Oracle 8 8i Certified Professional Database Administrator .
• Over twelve years' experience in supporting and implementing Banner System.
• Extensive experience in developing C, SQL, PL/SQL, Pro C ActionScript in Flex Application, Interface design and Oracle Report Substantial experience in C , Visual Basic, COBOL IBM Assembler, Unix Shell scripts and Argos reporting tool.
• Strong problem solving skills with extensive experience in analyzing, prototyping, testing, troubleshooting and training end users.
• Motivated self-starter with strong attention to detail and proven ability to work within multiple engineering functions to resolve problems.
• Strong technical verbal and written communication skills.
• Bilingual: English and Chinese Reading, Writing and Speaking .

II. Professional Experience

HR/Payroll Module Lead/Sr. Banner System Program -

Confidential

• Serve as a Module lead of Supporting Banner HR/Payroll System, troubleshooting and problems resolving the system pays 6000 employees by BW, SM, WK and MN. Supporting Fiscal Year Budgets Roll processes. Supporting Banner users by writing detailed user menu procedures also assisting HR/Payroll users with verbal instructions to resolve any problems.
• Developed YU customized programs running through Banner Job Submission such as Faculty assignment upload and Employee salary increase.
• Supporting Banner Effort Certification and Labor Redistribution application. Identifying the causes of errors and providing solutions. Created document and excel worksheet in power point to demonstrating the problem causes and how to fix the issue for web meeting with users. Communicated with Finance directors and managers in Effort Certification and Labor Redistribution related issues.
• Designed, Developed and implemented web application for student field work placement using Flex Builder. Developed and implemented Student Housing web application using Oracle Web Toolkit.
• Served as a project lead of the Banner HR/Payroll System conversion. Responsibilities included developed conversion and implementation plans, benefits deductions mapping, earning codes mapping, wrote converting scripts and functions, converted HR/Payroll module data from Legacy system to Banner system using CTOOL and PL/SQL scripts, Converted Finance FOAPLs and Grant Funds from legacy system to Banner system using PL/SQL scripts. Developed testing plan for integration test and user acceptance test. Developed interface programs packages such as TALX, union fund etc. Created customized reports using SQL and PL/SQL. Provided management with critical analysis and consultation on Banner HR/Payroll and Finance system.

III. Prior Employment and Experience

Lead Programmer/Analyst-

Confidential

• Served as a project lead when analysis, design, development, installation and maintenance are required for support and/or enhancements to SCT Banner HR/Payroll application. The system pays 5000 employees each week and is heavily customized to conform to strict Union requirements. The system also provides AP, GL data for Oracle financial system as well as the base HR data, which is uploaded each day.
• Developed and maintain documentation for system procedures and programs. Provide technical assistance by responding to inquiries from users regarding errors, problems or questions about programs.
• Trained end users and technical support staffs to use programs. Install and test programs at client site. Monitor performance of programs after implementation.
• Designed and coded interfaces for new third party applications such as EEO Analysis and Reporting tool, Drug and Alcohol test applications and Employee Time Keeping System etc. Create and schedule jobs for those interfaces.
• Acted as Banner Upgrade Project Lead. Responsibilities included upgrading Banner HR/Payroll application from v5.3 to v6.2, modifying Pro C programs, Oracle Forms and Oracle reports based on company business rules converted interface programs, PL/SQL scripts from Windows 2000 base to UNIX base converted NT schedule jobs to Unix cron jobs created user test plans and made functional test cases for users. My job entails creating numerous new reports using PL/SQL and Oracle Report 6i.

Programmer/Analyst

Confidential

• Served as a member of the Banner System implementation team consulting, analyzing and developing to improve and enhance the SCT Banner System. Responsibilities included database conversion, converting HR/Payroll and Student modules data from Legacy system SQL server database to Banner system Oracle database using PL/SQL. Wrote customized application processes using Pro C and PL/SQL to add new features for end user requirements. Created customized reports using PL/SQL. Implemented database trigger to perform business rules and wrote stored procedures to improve system performance.
• Assisted management in developing a student system implementation plan and advised on technical solutions and problem solving. Provided management with critical analysis and consultation on Oracle and Banner system.
• Supported Banner Student System, troubleshooting and resolving problems supported multi-campus Banner users by writing detailed user menu procedures for individual Banner and customized processes also assisted Banner users with verbal instructions to resolve any problems.
• In my additional role as a Datamart Administrator, I was responsible for installing, upgrading and monitoring Datamart.

Software Engineer E7

Confidential

• Worked on project Solution of All Language Tools SALT . Responsible for writing the requirements of Configuration Package Builder/SALT interface. Wrote a training program in C for synergy phone developers for practice in using SALT to test their programs. Assisted Training Instructor in training classes.
• Worked on Configuration Package Builder CPB project. Wrote the CPB requirement and design plan analyzed, designed and implemented relational database for CPB. Wrote user interface of CPB with VB6.0. Integrated all CPB forms and converted the CPB database from access97 to an Oracle database including data mapping.
• Worked for 3G Phone Development Group. Responsible for writing technical requirements based upon marketing requirements designing documents, coding and implementing the computer games Mindblaster and Falling Number in C language.

Oracle DBA/Apps Developer

Confidential

• Administrated and maintained Oracle database provided database space analysis and performance tuning Provided backups and consistency checks via Unix shell scripts installed Oracle server.
• Converted data from SQL Server to Oracle database.
• Modifying and maintaining the in-house Accounting System. Wrote and enhanced the system in C involving SQL.
• Designed, coded, tested and implemented the Inventory Tracking System to track items from the ordering phase to the selling phase maintaining customer, suppliers and warehouse information and generating invoices and reports written in C and Visual Basic.

Automation and Instrumentation Engineer/Manager-

Confidential

• Acted as project lead in the development of a Potential Electrical Eye Instrument to diagnose the health of the human eye. Wrote programs in C for an eye-measuring device.
• Programming in C for measuring instruments of human blood changes.
• Project presentations to top level management and users.
• Supervised seven-man team of New Technology Development Department.

Instructor

Confidential

Taught the following college courses:

Electronics.

• Electrical Engineering.
• Introduction to Computer including Basic and Assembler Language .
• Automation and Instrumentation Controls for the Chemical Industry.
• Researched the Automatic Control System of Apple II microcomputer for drying malt barley in making beer.