Worked on several projects for General ledger Utility System (GUS). GUS is used by Retail Accounting Department of Wells Fargo Bank. GUS is an in-house developed application used to automate the reconciling and balancing process of the branch lines. It is a multi-platform, multi-language, real-time, on-line, batch and client/server system.
The GUS system front end is coded in PowerBuilder and runs in a client/server environment, which consists of PC's and NT servers.
The GUS on-line system accesses several applications to obtain information:
- TellerVision ORACLE database which is located on a UNIX server to extract teller transaction information
- RH and RE databases on the mainframe (DB2) via Message Units (MU) to extract detail transaction information
- WEBS/HOGAN database on the mainframe, via MU, to extract name and address information
GUS on-line provides the business unit with the following capabilities:
- Reconciles Cash Line accounts for all branch AUs
- Reconciles and processes Manual Error Correction (MEC) lines
- Reconciles and processes Tree Lines
- Keeps track of Teller's Cash Differences
- Match/Merge/Transfers Cash Differences
- Maintains AU/Unit hierarchy
- Maintains database for exception code handling
- Create/Print/Reprints customer letters
- Sets/updates security for each user, even at window level
- On-line view of the Teller Journal for 20 business days
- Creates electronic adjustments to GL and Customer accounts
- On-line view of the Relational History (RH & RE) data
- On-line retrieval and view of customer account information from OT/HOGAN
Project involved: Savings Bond Project, AU Expansion Project and Automate Suspense Project.
Duties: discuss requirements with users, write Powerbuilder, Oracle and Visual C++ programs.
Designed and implemented Electronic Account Opening functions on Image Enhanced Case Management System(IECMS). IECMS is a workflow software that used to manage customer accounts. The front-end was written in PowerBuilder. User can process the tasks from a task list. Each task was linked with a image document which will be show on the screen after the task was opened. The embedded image processing was done by PixTools/EZ OCX - a product of ActionPoint Inc. IECMS had functions to scan documents into the system which was coded in VB. The VB program used ADO to connect to a Oracle backend. It can validate the user inputs like account number, task type, etc. then it will create a control file and send it to a daemon. The daemon will create a new task in database. IECMS can also receive fax and load into database. That part was written in VC++. The back-end included Oracle and FileNet. Duties include discussing requirements with end users, programming with VB, Powerbuilder and PL/SQL.
Designed and implemented Settlement and Billing System(S&B) using VB6, Powerbuilder 6.5, Access, Excel, Crystal Report, Pro*C, SQL*LOADER and PL/SQL.
S&B is a system that PG&E used to verify the charge or payment
it got from California Electric Power Exchange Market (PX) for it's Electric Power Supply Department. S&B use Pro*C program to load input files into database, then use VB, Excel, Pro*C
programs to do charge calculation and reconciliation. S&B has a lot of reports written by
Crystal Report. S&B has functions to send monthly revenues and expenses to a SAP system of accounting department. S&B need to get meter read from a SQL Server database. Wrote Transact-SQL and VB code to automaticly download the monthly meter read of 108 generation resources every day.
Wrote VB based windows, reports and Excel workbook. Wrote Pro*C code. Wrote Developer/2000 code.
Wrote Powerbuilder PL/SQL code in the project of converting S&B System from VB to Powerbuilder.
Worked on user interface design, database design. Did Oracle performance tuning, system analysis and support.
Designed and implemented Electric Supply Settlement System (ES3) using Oracle and PowerBuilder(5.0, 6.5, PFC).
ES3 is used to verify the charges/payments PG&E got from California Electric Power Exchange Market(PX)
for it's Electric Power Demand Department. ES3 use Powerbuilder written batch programs to load
files into database as it input, then use PL/SQL stored procedures to do the charge calculation
and reconciliation. ES3 has a Powerbuilder written GUI to let user issue commands, view results
and generate reports.
Wrote stored procedures using PL/SQL, Wrote PowerBuilder based windows, reports using PFC. Wrote PowerBuilder batch programs to validate
and load flat files into database. Designed and implemented FTP Data Exchange Server using PowerBuilder
The Data Exchange Server works as an window NT daemon. It help ES3 to do both in and out remote file
transfer. Designed and implemented automatic file generation using PowerBuilder and oracle dbms_job.
Wrote Perl, CGI program on NT server for automatic email processing.
Designed and implemented Contract Tracking and Reporting System(CTRS)
using PowerBuilder(4.0, 5.0, PFC) and ORACLE database under Window 95
and Macintosh OS 7.5.5. CTRS is used to provide real time access to critical
information related to LMMS U.S. Government Prime Contracts, Commercial
Contracts, Basic Ordering Agreements, and Subcontracts. The functions included
are tracking control and reporting information from the time the
contract is issued through the completion of the closure process and inquiry of
history or closed contracts. The Report Generator has several level drill down functionality
to ensure the user can get their desired report easily and efficiently.
Responsibilities included planning, database system analysis and designing,
Powerbuilder base object class designing, integrating, PowerBuilder and PL/SQL coding, debugging and testing.
Wrote C++ program to access user logon information on window NT domain and pass it to powerbuilder.
Designed and implemented Telephone Number Administration (TNA) project using PowerBuilder 5.0, PFC
and Sybase. Functions included in TNA are telephone number inquiry/update, telephone number use update,
telephone number descriptor update, generate new prefix, assign RSOC use descriptor, host specific
RSOC, etc. Involved in user interface design. Wrote Powerbuilder and Sybase code.
Generated installation diskettes using Powerbuilder Installation generation utility.
Designed and implemented customized SmartStream software for Showcase Financial
Project. SmartStream is a workflow software developed by Dun & Bradstreet Software
and written in Sybase and PowerBuilder. New and modified functions include:
Browse Account and Journal, Current Accounting Period Authorization, Canceling
Journal, Multiple Entity Period Close, Canceling Invoice, Receivable Document, Remittance, On Demand Payment, Payment Control etc. These modifications were in Accounts Payable, Accounts Receivable, General Ledger, Purchasing and Asset Management modules of SmartStream. Helped setting up SmartStream software in testing servers, education servers, production servers. Wrote documents for business requirements, system requirement, installation, migration procedure etc. Wrote PowerBuilder 4.0 scripts and Sybase System 11 Transact SQL. Carried out PowerBuilder and Sybase system testing and trouble shooting in SmartStream.
Worked for IBM Consulting Group. Major projects and accomplishments:
International Clearing System project for Bank of China headquarters SWIFT message processing. The project environments were MS-Windows, OS/2, AIX, VSE/ESA, PowerBuilder, Visual C++, MFC, ODBC, OLE, Oracle, PL/SQL, DB2/2, ADW, etc.. Duties include system design, performance optimize, PowerBuilder program functional specifications and consultant. Wrote a C++ class using Visual C++. This class can let PowerBuilder user trigger a main frame CICS transactions under APPC(LU6.2) communication. Wrote Oracle Pro*C program.
Financial Reporting System for Bank of China Guangdong. This project was used to generate various financial report from ledger records and do a validation against about two hundred rules. The project environments were MS-Windows, OS/2, Powerbuilder 4.0, DB2/2. Involved in system design PowerBuilder coding, performance optimize.
Airline Information System for Beijing Capital Airport. This system was used to manage airport information which include airline information, customer information, weather, airplane information, etc. The project environment were MS-Windows, AIX, PowerBuilder 4.0 , DB2/6000. Designed system architecture, algorithms and screen flow. Coded and tested client software using PowerBuilder 4.0.
Designed and implemented Trade Information Management System(TIMS). TIMS was a workflow software that used to manage SWIFT message processing for the Globe Trade Finance Department. The system environment are PowerBuilder and Oracle. Did a lot of PowerBuilder consulting work and also designed several PowerBuilder objects like datawindow control for data entry, general error message processing function, etc. Involved in requirement discussion with end users. Implemented several modules like Issuance, Amendment, Inspection, Exception, etc..
Worked as a team member on Programming Management System - a world wide distributed system which included several subsystems like supply, program planing, travel control, transportation control, etc. System environment are MS-Windows, ODBC, OLE, Sybase, SQLBase. Development tools are PowerBuilder, Visual C++, MFC. The project were using object oriented programming technique. Involved the design of GUI standard and the Standard Object Classes and implemented it under PowerBuilder. The Standard Object Classes include window classes, datawindow classes, menu classes, control classes, transaction object, etc.
Designed and implemented Banking Business System and Letter of Credit System, coding using PowerBuilder, C, C++, Sybase, ODBC, OLE. Working environment were MS-Windows, Netware, OS/2, VSE/ESA. As a hands-on technical lead of a team of three. Interfaced with users to gather requirements. Wrote functional specifications. Prepared project plans including estimates, tasks, schedules and resource assignments. Wrote technical design specifications. Designed and normalized database tables. Programmed extensively using Transact SQL. Carried out software testing and implementation. Applications include daily banking business processing, letter of credit business processing (import or export letter of credit issuance, inward or outward collections, etc.). Detailed work include window design, record format design, LAN and host APPC(LU6.2) communication design, electronic journal
design, database design and report design.
Image application program development for marketing department of AIG. Developed program for picture animation, zooming, as well as sound effect using C under MS-DOS environment.
Implemented a Management Information Systems for a manufactory using COBOL on HP-3000.
