Highlights:

Skills:SAS, MVS JCL

Goal:To be able to work in Missouri Texas and have my own business someday.

Certification:SAS PROGRAMMING COMPLETION, MVS COMPLETE ATTENDANCE & ITIL COMPLETE ATTENDANCE

SAS 10/2003 - current
CITIBANK, SINGAPORE, SINGAPORE Singapore
Industry: BANKING
Develop SAS programming
1.) Citibank N.A.-Singapore October 2003 – Present Asia Pacific Processing Center SAS/MVS Programmer Citibank APPC is the primary data processing center located in Singapore that offers full data center facility services to all the under countries under the Citigroup umbrella within the Asia Pacific Region as well as Latin America (LATAM), Europe and EMEA (Middle East countries). Services run on multiple hardware environments such as the Mainframe, Midrange and Wintel. Responsibilities: • Performed SAS programming on the Mainframe platform, and PC SAS-coding. • Extraction of Data from Mainframe, FTP files for downloading and Upload data to PC-SAS to generate the graphs to be posted in the WEB. • Monitor the high usage of Jobs in Mainframe and inform users if there jobs are hanging. • Perform validation on derived datasets and following the standard operating procedures during the validation process • Conducted Trend analysis of all the CEC, LPAR, Country Batch and Online Usage using SAS. • Develop documents and executes SAS programs for the purpose of creating datasets for analysis, producing data listings, summary tables and performing ad-hoc analysis. • Creates job streams and support production jobs that builds the PDB’s in mainframes. • Performs debugging of SAS programs • Used data _null_ and proc report to generate the outputs. • Automate jobs by creating Request for change, Creating Changeman Package and PJMR to schedule the job in the Tivoli Scheduler. • Troubleshoot Program if JOB abends. • Supervised and trained two junior-level of SAS programmers. • Managed all SAS database operations and updates. Collected data from local and remote MVS/VM systems; also collected and archived all SMF/RMF data. • Produced Monthly Chargeback for system charges and actual usage of each country. • Generate reports either in HTML, PDF, and CSV formats according to the client specifications. • Knowledgeable in Data Warehouse, data extraction from one or more source for the purpose of query and analysis. • Controls for managing data sources/stores on any platform accessible to SAS, in any format accessible to SAS and process flows which data moves from source to targets. • Ability to work on multiple projects simultaneously and meet the deadlines as and when required. • Participate in Monthly departmental meetings and provide the necessary inputs on how to improve the standards. Environment: Mainframe, SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Macro, Excel--
SAS PROGRAMMER 03/1997 - 12/2002
WORLD OF INFORMATION TECHNOLOGY, SINGAPORE, SINGAPORE Singapore
Industry: AGENT
• SAS programmer with over 10 years of experience in analysis, design, development, testing and validating the applications. • Knowledge on SAS/Base, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macro.
2.) World of Information Technology-Singapore March 1997 – December 2002 SAS Programmer a.) PROJECT: SINGHEALTH INFOCOM December 2001- December 2002 Responsibilities: •Enhanced and developed application for Case Mix Report System for Hospital using PC-SAS. •Performed data loading and generation of reports using Microsoft Query Analyzer. •Performs all SAS programming required for hospital statistical analysis and reporting. •Reviews case report form (CRF) design. Programs edit checks from the Data Management Plan specifications. Creates derived-analysis datasets. Executes analyses specified in the protocol or the Statistical Analysis Plan (SAP) under the guidance of the project statistician. •Produce tables, listings, and figures for the clinical study report (CSR). •Validate SAS programs that produce derived-analysis datasets and data analyses. •Conducted evaluation and analysis of requirements and performed programming/coding using SAS/ABAP (SAP) •Perform adhoc duties at may be assigned from time to time. •Attend user’s query and Meeting . Environment: PC b.)PROJECT: DBS Bank Singapore April 2001 – June 2001 Responsibilities: • Enhanced and developed new application for different departments of DBS Singapore. • Gathered and analyzed requirements in order to develop new request of Bank Reporting systems (including Summary Tables, Form Tabulations, Statistics and Derived Datasets) . Environment: PC c.)PROJECT: National Computer System Pte Ltd (Singapore) March 1997 – March 2001 Responsibilities: • Responsible for maintaining the existing Mainframe SAS production programs • Developed and revised SAS programs such as downtime, tape, printer, prime/nonprime, DASD (direct access storage device) usage, idnetids, ftp usage, ftp and nje ids and conversion of network program from COBOL to SAS. • Coding the flat file and performed testing of data • Prepare the monthly SLA (service level agreement) report for customers. • Analyzed and troubleshoot errors of JCL and SAS programs. Environment: Mainframe--

AMA COMPUTER UNIVERSITY PHILIPPINES 03/1985 - 03/1989
, , Philippines
Degree: Bachelor's Degree
Major:COMPUTER SCIENCE
Bachelor of Science in Computer Sience

SAS PROGRAMMER SAS