Management Data, member Software Beta Tester and Evaluator

Francis V. Cawit

**** ******* ****

LOS ANGELES CA 90065

Cell Phone - 213-***-****

Email - ************@*****.***

******@*****.***

Objective

To work in company where I can apply, contribute; share my finance & computer professional expertise.

Experiences

2001 – 2010 Los Angeles County Office of Education (LACOE) –Downey California 90085

Sr. Programmer & System Analyst – Information System

• PeopleSoft programmer that support School Financial Services (SFS) which provide fiscal accounting responsibilities for numerous school districts.

• Develop a PeopleSoft ACH program for the School Financial Services (SFS). This program reduces the monthly printing of the hard checks that cut down man hour cost and expense.

• Develop a PeopleSoft program automating the yearly Internal Revenue Service (IRS) 1099 reporting, data upload, verification, validation, testing and printing. All processes is in full compliance with the IRS requirements..

• Full knowledge of IBM/OS390; MVS/TSO, JES2-JCL; SQL; Microsoft SQL Server, Business Object/Crystal Reports; SQR: FOCUS; QMF; Monarch, Attachmate – Data Warehouse, data interfaces, uploads and data manipulation.

• Full knowledge of Data Project Management related to any School Districts from planning, designing, development, costs and expense analysis, from stage testing to production implementation.

• Provides all the job documentation to assure all are properly in place for developer’s future references.

• Provides technical support, online & personal visit assistance to all school district as needed.

• Full knowledge of Microsoft Fox Pro and Access and Visual Basic

2000 – 2001 Presbyterian Intercommunity Hospital

Washington Blvd. Whittier CA 90054

Sr. Financial System Analyst – Quality Management Division

In charge of the yearly Information System reports to comply with Joint Commission (JCO) requirements.

• In charge of the monthly data interfaces to the hospital financial ledger system.

• Compile data for Budget and forecasting as needed.

• Design databases used by the Quality department generating important reports for the upper management.

• Serve as the focal point for clearing and assisting any technical issues related to quality management department.

1986 – 2000 Cigna Healthcare of California

505 North Brand Glendale California – 90025

Sr. Financial System Analyst - Finance Division

• In charge of all the monthly data job interfaces from the financial local server to MVS/IBM mainframe posted to our monthly General Ledger.

• In charge of designing databases for the General Accounting, databases interfaces through ODBC and used as bases for generating any financial accounting reports

• Support and develop SQL that generates numerous Ad Hoc reports for the CFO & Sr. Managers.

• Develop program using MS-Access automating the monthly bank reconciliation process for the companies numerous bank accounts.

• In charge of Data Warehouse, store program procedures that generates all the finance daily and monthly reports..

• Designed Crystal Reports as needed.

• Provide support for any software training and resolved any technical issues as needed.

• Full knowledge using Microsoft Office Software.

• Prepare policy and technical documentation for Finance Department guidance and references.

Education

1977–1979 - De La Salle Graduate School of Business - Manila Philippines

• MBA - Financial Management

1971 – 1975 – University of the East – Manila Philippines

• BSBA – CPA (Philippines License).

1985 – Computer Learning Center (CLC) – Wilshire Los Angeles CA

Certificates:

• Reports Design using SAP - Crystal Reports

• Reports writing using Focus – by Information Builders

Contact this candidate