Analyst Engineer

Title:Programmer

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

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE:

ZIP:

CANDIDATE ID: 2921623

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE: 519-***-****

EMAIL: ******.******@*********.**

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS: financial, programmer, jcl, programming, lien, ftp, microsoft, sql,

database, engineer, systems analyst, civil, claim, accounting, claim

REVISION: 08-SEP-02

RESUME:

NAME:

ADDRESS:

CITY:

STATE/PROVINCE:

ZIP/POSTAL CODE:

COUNTRY: US

EMAIL: Home: ******.******@*********.**

PHONE: Home: 519-***-****

CANDIDATE ID:

CITIZENSHIP: United States

Citizen or National

EDUCATION: Bachelor Degree

EXPERIENCE: 8 Years

WILL RELOCATE: Yes --

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: $55,000/yr

HOMEPAGE:

COMMENTS:

HOTSKILLS:

EMILIO DELEON

245 NORTHMANOR CRESCENT

KITCHENER, ONTARIO

N2N 3C4

PHONE: HOME - 519-***-****

WORK - 519-***-****

EXT. 5809

PROFESSIONAL SUMARY

An experienced SAS Programmer/Analyst with a wealth of experience in the

Financial and Health Care Industry. Over 5 years experience in SAS

programming. Experience in dealing with and managing large datasets

involving millions of insurance claims records. Experience in Year 2000

compliance. A problem solver with a strong technical skills.

EDUCATION

B.S

. in Civil Engineering - Tarlac State University, Philippines

B.S

. in Military Science - Philippine Military Academy, Philippines

TECHNICAL TRAINING:

SAS Intermediate Programming, SAS Institute, Canada

SAS Macros, SAS Institute, Canada

Visual Basic

LANGUAGES: HARDWARE: OPERATING SYSTEMS:

SAS 6.12 (PC Version) IBM PC TSO/MVS (w/ISPF editor)

SAS 6.09 (Mainframe) IBM Mainframe MS Windows 95

SQL MS WINDOWS NT

JCL MS DOS

VISUAL BASIC

ANCILLARY SKILLS:

SAS MACRO PROC MEANS File Transfer Protocol (FTP)

SAS BASE PROC TABULATE MS WORD

SAS SQL PROC FREQUENCY MS EXCEL

SAS ARRAY DATA NULL MS ACCESS

PROC PRINT PROC DATASETS

PROC SUMMARY PROC COMPARE

PROC SORT PROC REPORT

EXPERIENCE

4/98

- PresentManulife Financial

Position: VALUATION ANALYST/SAS PROGRAMMER

Developed, maintained and enhanced current user production programs.

Implemented improved controls to current systems. These productions

programs are written in SAS, APL, and Visual Basic.

Performed health care analysis and created ad-hoc reports using SAS.

Edited and managed large mainframe files and libraries in a TSO/MVS

environment using JCL, FileAid, and ISPF Editor.

Calculated statutory reserves for the different lines of Health Care

business including Life, Health, Dental and Disability by applying

different actuarial models and statistical analyses. Developed a new

application for calculating statutory reserves using Microsoft Access

and VBA.

Utilized TABULATE, PRINT, SUMMARY, FREQUENCY,REPORT, AND DATA NULL for

ad-hoc reporting and database management.

Created Macros, Arrays, SORT, and Merging for preprocessing of

production and ad-hoc reporting.

Worked with SAS LOGS to decode errors, DATA STEPS to write reports and

wrote data to SAS output files.

Downloaded information from the Mainframe into MS EXCEL and ACCESS using

File Transfer Protocol (FTP).

Transferred SAS results/datasets to Excel using Dynamic Data Exchange (DDE).

1/95

- 3/98Manulife Financial

Position: CLIENT REPORTING ANALYST/SAS PROGRAMMER

Produced special reports for Group Benefits' clients by utilizing both SAS

and Microsoft Excel. Produced accurate and timely financial reports to

clients by applying knowledge of both underwriting and accounting

principles. Ensured that all internal accounts are up-to-date and agree

with the financial reports.

Worked as a Business Analyst for a project on improving and refining

current procedures. Also contributed to the successful completion ofa

project to integrate the business of former Confederation Life to Manulife

Financial.

Worked as a Systems Analyst on the Y2K project to ensure that all our

systems and files are year 2000 compliant.

Tested and modified SAS programs where applicable for Y2K compliance.

Produced ad-hoc reports using PROC Tabulate, Summary, Print, and Frequency.

Tested and Modified Excel files and macros for Y2K compliance.

9/91

- 12/94Confederation Life Insurance Company

Position: SYSTEMS CO-ORDINATOR/SAS PROGRAMMER

Provided technical assistance to Underwriting and other departments with

respect to general questions and problems concerning the operation of

administration systems. Contributed to department efficiency and to the

overall efficiency of the insurance operations by assisting in the

coordination of improvements to policyholder reports and inter-department

procedures.

Maintained and documented systems manuals. Communicated up-to-date

procedures for computer systems by publishing revisions to the

Underwriting Systems manuals.

Contributed to the efficient operation of insurance systems by assisting

in the monitoring of output, investigation of errors and solving problems,

and designing and testing changes to the systems.

Produced ad-hoc reports by programming in Mainframe SAS. Utilized JCL

Contact this candidate