Life Insurance Data
Resume:
HING CHOY
West Orange, NJ ****2
(H) 973-***-**** **********@*****.***
SENIOR SYSTEMS ANALYST
Expertise in application design, development and maintenance of systems
using Oracle 10g, MS Access, Peoplesoft EPM, PeopleTools, UNIX shell
script, Perl, Actuate, DB2, SQR, COBOL, CICS, JCL, VSAM, Javascript and
HTML. Learn and master new computer technology quickly and work diligently
to complete assigned projects on or ahead of schedule. Excellent
collaboration and interpersonal skills.
TECHNICAL SKILLS
HARDWARE IBM AIX, IBM/3090, MVS/ESA, Sun Solaris, MS Window XP
Professional
SOFTWARE PeoplesTools, EPM, Oracle, MS Access, SQL, PL/SQL, SQL-
Loader, SQL, UNIX shell script, SQL+, Toad, Actuate Basic,
Actuate Console, SQR, Perl, Javascript, Java, SQL Server,
Cognos, PowerPlay, Hummingbird Exceed, IBM Tivoli Maestro, Lotus
Script, Notrix Rexx, Revolve, Intersolve PVCS, StarTeam.
DB2/SQL, CICS, IMS DB/DC, DL/1, ADABAS, COBOL, COBOL II,
INTEREST, XPEDITER, PRO/EDIT, QMF, SPUFI, CEDF, SDF, ABENDAID,
TSO/ISPF/CLIST,
OS JCL & UTILITIES, VSAM, PANVALET, Easytrieve,
ChangeMan.
PROFESSIONAL EXPERIENCE
Metropolitan Life Insurance, Jersey City, NJ 2001 - 2009
Information System Consultant
Major Projects:
CXO Reporting: As Lead Programmer, developed data mart reporting system
that provided more consistent reports across LOBs.
. Conducted data analysis and data mapping. Created and tested all
tables and SQL-Loader scripts to load the tables, stored procedures to
process data and UNIX shell scripts to execute the SQL-Loader and
stored procedures in Maestro JS Console.
. Supervised and trained a team of 3 Programmers on SQL-Loader script
and stored procedure.
. Produced system that allowed users to develop standardized headcount,
resource and direct expense reports and saved time to generate them
from 1 week to 30 minutes.
. Used Oracle 10G, MS Access, MS Excel, SQL-Loader, SQL/PL, UNIX Script,
EPM, PeopleTools Application Designer, Cognos 8 and IBM AIX.
EPMT, Chimes/Apex/Clarity Integration: As Lead Programmer, enhanced
existing programs and financial data mart application.
. Analyzed systems to incorporate Apex and Clarity data to Chimes. Made
recommendations to change tables, SQR programs, Maestro and UNIX
script.
. Enhanced database to enable users to better manage programs, projects
and financials through the Clarity tool. New database also established
a common set of processes and tools which increased efficiency and
transparency.
. Enhanced and maintained Maestro objects.
. Provided production support to resolve data issues and ensured job
streams in nightly batch window were run to completion by schedule.
EPM HR Actuate Reporting: As Lead Actuate developer, developed system of
batch and ad hoc Actuate reporting that HR used to analyze employee
headcounts, demographics and turnover.
. Conducted data analysis, data mapping and defined reporting security,
front end integration and report formats.
. Worked with HR users to establish report requirements.
. Developed, tested and implemented Actuate reports using Actuate
eReporting v9 and Java scripts for Web interface.
. Assisted developers with technical issues and debugged report errors
using Actuate server console.
. Supported HR users resolve daily problems that arose from execution of
reports and data issues.
. Conducted system testing for Actuate upgrade from v8 to v9.
HING CHOY
Page 2
(H) 973-***-**** **********@*****.***
Metropolitan Life Insurance...continued
EPM Financials: As Lead Programmer, co-developed an enterprise warehouse, a
comprehensive and scalable data warehouse that enabled multi-level
reporting for financial analytics and workforce analytics.
. Created table objects using PeopleTools Application Designer.
. Developed and unit tested SQR programs to load tables and for data
quality reporting.
. Analyzed impact to implement Unicode to all the character fields in
enterprise warehouse applications.
. Worked closely with DBA group to resolve data issues.
Metropolitan Life Insurance, Pearl River, NY 1996 - 2001
Independent Contractor
CAS (Client Acquisition System): As Lead Programmer, Web-enabled an
existing Underwriting (PURR) and Policy tracking (SCAT) system.
. Enhanced COBOL CICS programs invoked by Web client to retrieve and
update data on DB2 database and VSAM files.
. Participated in design and architecture of different Web Enablement
components: Websphere App Server, CICS Transaction Gateway/Client,
CICS 4.1 MVS and DB2.
. Supervised two programmers who implemented changes in COBOL CICS
programs.
. Collaborated with Web developers to develop and debug programs, and
resolve performance and data integrity issues.
. Prepared and presented documents of impact analysis and proof of
concept results to management.
Level II Policy: As Lead Programmer, designed and implemented level II
Policy Change Validation System to validate benefits for new policy or
policy change in term of age class, expiration date, minimum and maximum
amount requirements.
. Analyzed KATS application to identify all programs and database tables
affected by new requirements.
. Created new tables, altered existing tables and VSAM files, and
modified existing CICS/COBOL II programs.
. Loaded data into new and altered tables using DB2 utilities.
. Maintained DB2 database and resolved database issues for KATS using
DB2 utilities.
Apprise Information Systems, Morristown, NJ 1995 - 1996
Independent Contractor
. Member of the Claim Assist System development team.
. Developed system to capture worker's compensation data so company
could meet new reporting requirements set by NCCI.
. Used COBOL II, CICS, DB2, VSAM, Micro Focus COBOL, Revolve and
Intersolve PVCS Version Manager.
NYNEX Mobile Communications, Pearl River, NY 1992 - 1995
Independent Contractor
. Member of the INFO2000 development team. Performed user interface,
program design, coding, testing and implementation of processes,
including billing, account receivables, collections, order entry,
customer-account management, and usage analysis.
. Co-developed system that provided sales, discounts, and revenue data
to sales department so it could monitor activities of major account
wholesalers for pricing strategy. Used IMS DB/DC, DB2, VSAM, COBOL
II, MS Access and MS Excel.
. Enhanced system by altering DB2 tables, SQL tuning, program redesign,
and job consolidation.
. Developed INFO2000 system on IBM 3090 using DB2, CICS command level,
COBOL II and VSAM.
EARLY CAREER EXPERIENCE
Worked as a Programmer / Analyst, Senior Programmer and Consultant for
companies in the insurance, medical and transportation industries.
EDUCATION
B.B.A. in Computer Systems; Baruch College, City University of New York
B.S. in Accounting; State University of New York
at Binghamton
Contact this candidate