Software Data
Resume:
MILDRED M. ALAYAN
Carol Stream, IL 60188
Cellphone No: 630-***-****
E-Mail Address: ********@*****.***
Eighteen years solid experience in the IT industry. Five (5) years exposure in banking system (CA/SA, payroll, financial, remittance and loans systems), three (3) years in telecommunications, 1.5 year in software company and 8.5 years in the IT department of mailing houses. Expertise in IBM mainframe in the field of systems programming, DASD management, VSAM file management, JCL coding and installing various software. User of SUPRA RDBMS for four (4) years. SUPRA Database Administrator for three (3) years. Possess programming skills in both mainframe (MANTIS, REXX, COBOL, SAS, Vision Results, Transformer SPG) and PC(Clipper, MS-Access, PReS) environment. Had systems administration background in SCO UNIX. Certified internet professional having knowledge in Dreamweaver, HTML, Perl programming, CGI and internet server management.
Educational Background
Master in Computer Science (MCS)
De La Salle University
Taft Avenue, Manila
Philippines
Bachelor of Science in Statistics
University of the Philippines
Los Baños, Laguna
Philippines
Technical Environment
HARDWARE IBM Mainframe (3090 and 9121-320), PC, Imac
OPERATING SYSTEM MVS/ESA, SCO-UNIX, MS-DOS, Microsoft Windows
SOFTWARE (Mainframe)
SOFTWARE (PC) TSO/ISPF, JCL, RACF, SDSF, SMPE, SMS, TCP/IP, STOPX37, JobScan, NetMaster, VTAMPRNT, FAVER, ZEKE, ZEBB, ZARA, File-Aid, IBM Utilities (DFDSS, DFSORT, IEBCOPY, IEBGENER, ICEGENER, IDCAMS, etc.), FATS/FATAR, AF-Operator, Omegamon for MVS
SAS, SPSS, StatGraphics, Microsoft Word, Microsoft Excel, Visio, Powerpoint, WordStar, Word Perfect, QEdit, SideKick, QuatroPro, Lotus 1-2-3, Flow, MS-Access, Elixir Desktop Application Suite – for font, form and graphics converter and editor, Opus, Transformation Suite, DbDirect, PageMiner, PreS, InDesign, Microsoft Photo Editor, Datatools Twins, Macromedia Dreamweaver
LANGUAGES MANTIS (4GL), COBOL, DYL280 (Vision Results), REXX, Transformer Statement Parameter Group (SPG), 4090 Xerox printer Page Description Language (PDL), RPG (in AS/400), Clipper, C, Pascal, MS-Access, HTML, PERL, CGI scripting
DATABASES SUPRA RDBMS, VSAM, MS-Access Foxbase, DBASEIII+
Work Experience
1. June 2007 – May 2011
Programmer
BTS - CCS
Computershare
6 Hope St.
Ermington NSW 2115
Australia
• Used GPD/Jef and Perl programming language to set-up document for laser printing, DSS/ Viewpoint archiving system and email broadcasting for registry and commercial jobs, adhoc and contract jobs;
• Maintained ex-Permail contract jobs that are still in PreS;
• Performed quality check from time to time. Checked the sample output generated by other programmers;
• Set-up and maintained contract jobs. Automated the processing of contract jobs.
• Had been involved in the conversion of some ex-Permail contract jobs from PreS to GPD
2. June 2006 – May 2007
Programmer
Permail Pty Ltd
Unit 1/ 706 Mowbray Rd
Lane Cove NSW 2066
Australia
• Pre-processed data coming from clients to conform to Australia Post specifications using MS Excel, MS Access, and Datavac;
• Set-up documents using PreS programming language for laser printing and/or archiving per client request. Provided samples to the client for job approval then processed the live data when job is approved.
• Maintained some contract jobs that have transactional data. Applied some changes to the PreS code per client request.
3. May 2005 to February 2006
IT Specialist
JW Mailing Services
5 Chicago Ave.
Blacktown NSW 2168
Australia
• Pre-processed data coming from clients to conform to Australia Post specifications using MS Excel, MS Access, and Datatools Twins;
• Set-up jobs by mail merging data with text/forms, printed samples and sent them to clients for approval;
• Set-up laser printers and inkjet machine and organized the printing of the client approved inkjet and laser jobs
• Developed and maintained data entry system for some clients to handle returned mail, request for change in mailing information, request for cancellation/ deletion from the database.
4. February 2002 to April 2005
Laser Programmer
Mail Marketing Works
2/2-6 Orion Road,
Lane Cove NSW
Australia
• Responsible for ensuring that texts and lives are set up correctly and completed in timely manner.
• Set-up text requirements in accordance with job specifications using Indesign and Elixir desktop software
• Scan/clean signature, logo and other image files and convert them to TIFF and EPS image files
• Do document formatting by coding PreS script
• Spool files to laser printing
• Update job bags and prepare samples for laser printing
5. August 2000 to January 2002
Technical Support Analyst
Elixir Software Asia Pacific
(based in Sydney Australia)
• Received and analyzed customer problem, coordinated with support/development personnel for resolution of customer problems regarding any of the Elixir software products and product license issues;
• Conducted pre-sales software presentation and support;
• Prepared training material for double byte support;
• Conducted Elixir software trainings to existing customers
4. April 1999 to July 2000
Systems Programmer (Mainframe)
Allied Information Services, Inc. of the Philippines
• Evaluated hardware requirements, including CPU, main storage, channels, auxiliary storage, and tunes hardware configurations to meet management performance objectives;
• Researched, evaluated, installed, maintained, and supported operating system software. Installed operating software systems, updates and replacements, including all product evaluation steps plus backup/recovery procedures, conversion, and data center installation letters.
• Provided technical support services to application development and the data center personnel. Detected, analyzed and resolved problem in the operating environment.
• Installed, upgraded, customized various software used by the company.
• Performed RACF security administration tasks:
- Created user profile
- Reset user profile
- Created dataset profile
- Granted dataset /other resources access to users/group
- Ran and analyzed reports showing the different access violations
5. April 1997 to April 1999
Operations Analyst II/ Analyst-Programmer
Allied Information Services, Inc. of the Philippines
• Served as the primary analyst/programmer for Transformer Statement Parameter Groups (SPGs) and 4090 Xerox printer Page Description Language (PDL) under the mainframe billing system. These software are used to reformat the bills and various letters sent to customers.
• Retrofitted the Y2K enhancements on the Mainframe COBOL programs, copybooks and JCL’s for them to be Y2K compliant;
• Provided technical support for the Output Processing Center (OPC). Trained OPC personnel on TSO, JCL coding, Transformer SPG and PDL ;
• Coded/modified Mainframe COBOL programs, SAS and DYL280 programs for report and file generation requested by the client.
6. August 1994 - April 1997
Programmer/Database Administrator
Computer Operations Department (COD)
Philippine National Bank
• Supervised and trained Database Administration Team personnel who were assigned in different SUPRA/MANTIS based applications (payroll, financial remittance and loans systems);
• Designed the data structure best suited to the applications, to the operating environment and to anticipated future needs;
• Established and enforced standards for database design and use of databases;
• Developed and administered systems and procedures for protecting and monitoring the security of data and data bases and for back-up and recovery;
• Performed modifications and maintenance of data base structures, utilization, standards and access methods, as required by changes in objectives, equipment, software and performance requirements;
• Ensured proper allocation of DASD space and other resources for all applications;
• Installed and customized software (SUPRA and MANTIS) to mainframe.
• Maintained the VSAM files of Retail Banking System (CA/SA) and all in-house developed applications of the Bank
• Maintained the DASDs of the Bank and trouble-shoot DASD related problems;
• Served as the mainframe change control coordinator for SUPRA, MANTIS and JCL;
• Coded Mantis and REXX programs for the Database Administration Group.
• Provided technical support to the Applications Development and Maintenance Group.
• Received COD Employee of the Quarter award for exemplary performance.
7. August 1993 - August 1994
Computer Operator IV
Electronic Data Processing (EDP) Department
Philippine National Bank
• Installed and customized SCO UNIX on PC’s to be used as the O/S for the stand-alone Loans System;
• Installed SUPRA System and upgraded MANTIS version in IBM 3090;
• Created and modified SUPRA base tables, base views, links, indices, and granted access privileges on users;
• Performed maintenance activities for DASD volumes, SUPRA databases and VSAM files;
• Coded and tested programs for Trial Balance and Profit & Loss Data Entry and Diskette Reporting System (FSBr) using Clipper / Foxbase;
• Downloaded programs and data of SUPRA/MANTIS based Loans System from mainframe and uploaded to Unix-based PC to test the performance of the computerized loans system in stand-alone PC;
• Documented the downloading and uploading procedures and installation of SCO UNIX O/S, SUPRA and MANTIS in PC.
8. March 1992 - August 1993
Bank Clerk
Loans Team, Application Development Group
EDP Department
Philippine National Bank
• Coded and revised programs and JCLs of the SUPRA/MANTIS-based Loans System in IBM 3090;
• Consolidated various bank financial reports (e.g. Trial Balance and Profit and Loss) using in-house developed systems;
• Converted the loan accounts of PNB Rizal Avenue Branch for the computerized Loans System;
• Updated the user’s manual of the computerized Loans System.
9. July 1991 - March 1992
Programmer/Statistician/Part-Time Teacher
Planning and Special Project Division
Philippine Women's University
• Made statistical programs in SPSS software for housing monitoring survey data gathered as of June 1991 which were used for the Australian housing project;
• Made statistical analysis report based on the generated analytical tables, log regression and logistic regression models using the gathered data;
• Designed questionnaire and mailed to different companies to determine their computerization needs. The gathered data were used as input in designing training programs.
• Taught WordStar and Lotus 1-2-3.
Contact this candidate