Philip A Green

Pittsburgh, PA

336-***-****

336-***-****

ac8qm8@r.postjobfree.com

ac8qm8@r.postjobfree.com

Forty years of broad-based IT experience including project management, software development,

statistical analysis, and systems administration. Extensive knowledge of large-scale data analysis using

numerous databases on multiple platforms. Roles as a lead developer, project leader, and systems

administrator on highly complex projects with short deadlines using state-of the-art forecasting tools.

10+ years as SAS Enterprise Admin (application & systems). 30+ years of SAS development.

20+ years of supporting interfaces to large databases (Oracle, MS SQL, Sybase, Teradata, DB2).

Experience Summary

Energy Information Agency, US Department of Energy, Washington, DC 07/18 to 2/19

SAS Administrator and Architect

Systems Maintenance of three SAS 9.4 M3 and SAS 9.4 M4 Linux platforms. Patches & Updates.

User Problem Tickets. Update & editing of SOPs. Performance monitoring with Solar Winds & Linux.

Build-out of SAS Environment Manager. Splunk Certified User with additional advanced training.

Planning for version upgrades SAS 9.4 M3 to M4 & M4 to M5.

Successful prototype of Stored Process based tool for SAS Code Vulnerability Analysis.

SAS/Linux utilities for user count and user identification.

Work Safety and Insurance Board, Toronto, ON, Canada, 03/18 to 6/18

SAS Administrator and Architect

SAS DB2 Installation & Configuration à

oInstalled SAS/Access DB2 Interface Product

oConfigured DB2 User Group, adding Windows users & access rights.

oConfigured SAS DB2 Libraries & fixed existing Oracle &SQL Server SAS Libraries.

Wrote utility for SAS DB2, Oracle, SQL Server Libraries to

ocompare SAS DB Libraries to Source DBs,

oupdate table entries,

ocheck the readability of registered tables.

Installed IWA for SAS Single Sign-on to Windows 2008 & 2012 R2 Servers configurations.

Deployed Terminal Server as a multi-user user client interface for SAS EG and EM.

Configured SAS Job Scheduling thru SAS EG and SAS MC.

Installed SAS Model Manager and Social Network Analysis (Fraud Detection) Products.

Configured SAS Data Management/DataFlux. Forecast Studio

Wrote System Overview, User Training & Operational Manuals.

Drafting MS-DOS & Power Shell Scripts to Automate Start/Stop of SAS Windows Services.

Texas Attorney General’s Office, Child Support Enforcement, Austin, TX, 07/17 to 10/17

SAS Administator

Wrote SOP environment setup document & supported POC for post-installation setup.

Wrote utilities for SAS DB2 metadata update & SAS folder listing in SAS 9.4 M3.

Review of existing SAS system requirement documentation.

Support of SAS SSO & SAS Adaptor utilities.

Designed utility for automating Web Report package deployment.

MedSolutions\eviCore, Franklin, TN, 11/17 to 6/17

SAS Administrator

Full User and System Support with LINUX and MS-DOS Scripting.

Production Servers Upgrades à

oDrafted an SOP for the creation of new SAS ODBC Libraries.

oSOP Creation for SAS EG Client Installs to Desktop Support Team & End-Users.

oMigration of DEV servers to SUSE LINUX from Windows & ODBC drivers updates.

oSAS queries of Metadata Registry data.

oMetadata registration of SAS ODBC Libraries with 22,000+ Tables and Views.

oFixed configuration/installation issues on Windows 9.3 and LINUX 9.4 SAS servers.

Data Management/DataFlux /Visual Analytics Upgrades à

oFull installation of Visual Analytics SIDs on Data Management/DataFlux environments.

oLicense updates to the Data Management Server and Studio to fix product inclusion issues.

oCreation of formal Start/Stop SOPs for Data Management/DataFlux.

oPrototyping of Data Cleansing Applications.

oFixed configuration/installation issues on two four server Windows 9.4 Platforms.

oAuthored and tested first successful submission of web anonymous jobs from an external server to the Data Management Server.

PNC Bank, Pittsburgh, PA, 5/15 to 07/16

SAS Administrator

oAssisted fixing a metadata cluster failure on a large SAS 9.4 M2 GRID configuration

oSAS EG, EM, CA-7 batch, & RMS post-install problem fixes using log analysis & SAS MC Tests

oPOC installation of Hadoop to a non-GRID Production server.

oUn-install & re-install of Teradata Clients to SAS GRID compute nodes.

oRedesigned applications a long-running GRID forecasting application that exceeded the available workspace for CCAR HEIL and HELOC models supporting Dodd-Frank compliance.

oRedesigned SAS IML CCAR HELOC applications that ran too long.

oWrote a utility to

osummarize storage usage by user & automatically email user-level reports to users

oplan the management of user space utilization

oextract RMS based performance data.

Fix of user problems. Training on SAS DS2. SAS MC Library and User Upgrades.

Connecticut Dept of Education, Hartford, CT, 03/15

SAS Administrator & Architect Consultant

oAssisted with planning of a prototype SAS 9.4 Window/LINUX configuration with interface to IBM

GPFS file utility, using SAS Visual Analytics and SAS DI.

oReviewed coding & configuration of SAS Visual Analytics/SAS DI Reports.

US Army, Fort Knox, KY, 9/14 to 12/14

SAS Administrator & Architect

oServer installation/configuration of SAS 9.4 AIX server with meta, compute, mid(web) tiers.

oFollow-up testing of SAS prototype applications

Transfer & optimization of applications from existing SAS 9.3 server

Assurant Solutions, Miami, FL, 11/13 to 08/14

SAS Administrator

oMaintained & upgraded a complex generic high-volume, multi-national extract/repository build

process supporting eighteen major claims and reserving applications.

oComponent tools included SAS 9.3, Oracle 11, SQL Server, LINUX scripts, and CRON scheduling.

oInstalled SAS EG 5.1 and PC SAS 9.3 remotely for users in Miami, Atlanta, the UK, Germany,

Argentina, and Brazil.

oMentored SAS EG based applications for senior actuarial and statistical users.

oUrgent trouble-shooting for access & application problems with support facilitated in Spanish.

oHelped plan the physical migration of SAS/LINUX servers.

Capital One, McLean, VA, 5/13 to 10/13

Senior SAS Analyst

oReviewed a major statistical application.

oImplemented two BASIL II scoring processes for commercial loans.

oEvaluated Teradata extract options for PC SAS.

oCompleted SAS training tutorial course on GRID/LSF installation and job submission.

oModified long-running jobs for GRID/LSF submission including

1) running PROC SCAPROC on programs to generate GRID enabled jobs

2) defining keys definition for GRID submission with function grdsvc_enable and cmd gsubmit

3) enabling programs with function grdsvc_enable to parallel load balance & rsubmit batch tasks

4) checking GRID job status using LSF cmd bjobs from LINUX

Tools include SAS9.3, SAS (Grid/LSF, EG, PC), LINUX, Teradata 11.

CSC, Baltimore, MD, 01/11 to 05/13

Systems and SAS Administrator

SAS Administration:

oBuilt DEV& QA instances of a PROD SAS EBI server with image copy & host name change utilities.

oCreated SOP for SAS EBI server shutdown and start-up on three tier, two server configuration.

oInstalled an interface to DEV Oracle DBs with Oracle 11 for SAS 9.2.

oCustomized fixes of cloning bugs for SAS Content Server, SAS Object Spawner, SAS Stored Process Server, & Web Applications.

oUpdate of SAS/JAVA/Oracle Web applications.

oPrototyping of SAS EG, SAS BI Dashboard, SAS OLAP Cube, & SAS GRID/LSF Applications.

oAdded space to DEV and QA servers.

oUpdate of License Files & passwords for SAS Internal Accounts.

oCRON backup of metadata, application, and systems files.

oClient Server Installation of Teradata 13.10.and interface to SAS 9.2.

oCreation of SAS BI interfaces profiles for Oracle and Teradata DBs.

Administration of UNIX/Weblogic,Oracle OBIEE, Informatica 9.1

oStop/Start WebLogic servers with specialized SOPs for load balanced & clustered servers to fix Oracle data sources, support application deployment, & resolve routine domain problems.

oCRON automation of Web Logic log copying. Web Logic server trouble-shooting.

oInstalled three instances of Informatica 9.1, PowerCenter,& DataQuality.

oUpdated Informatica 9.1 license keys & server stop/restart SOPs.

oWrote stop/restart SOPs for Oracle OBIEE with routine restarts. Creation of map viewer data sources.

oPerformed performance tuning. Augmented disk space and memory. Added new users.

Bank of America, Charlotte, NC,10/10 to 12/10

SAS Programmer & Statistical Analyst

oUpgraded a strategic resource forecast system for support tasks

oeconometric modeling using step-wise regression and ARIMA

ovalidation using formal test plans.

oSAS 9.2 on PC SAS using PROC ARIMA and SAS ODS.

Dept. of Medical Assistance, State of NC, Raleigh, NC, 4/10 to 10/10

SAS Administrator and Application Analyst

oAdministration and oversight of SAS Financial Management & Forecast Studio Servers

oWeb Logic server restart.

oWrote a procedure for verification of server usage using Windows Terminal Services Manager.

oDrafted plans for the creation of DEVL/Test SAS servers.

oWrote SAS batch submission scripts using MS-DOS commands.

oInstalled PC SAS software from SAS Software Depot.

oCompleted one week course at SAS-Cary on Platform Administration.

oApplication projects included

odocumentation of Medicaid processing

obuilding of inputs for statistical forecasts, and validation of forecast input files.

oValidation using ad-hoc SAS comparison programs.

oApplication software tools included

oSybase

oWindows OS Tools (MS-DOS Scripting, Terminal Services Manager),

oSAS 9.2 (PC & Mainframe),

oSAS Financial Management and Forecast Studio,

oSAS EG, SAS DI Studio, SAS MC, SAS Management Console.

National Science Foundation, Alexandria, VA, 10/09 to 10/10

SAS Programmer/Administrator

oDeveloped a validation process for expenditure and compliance data submitted by grant recipients.

oValidation processing includes both standard and ad-hoc reporting.

oMy team received a commendation from Federal IT Mgmt for compliance/reporting excellence.

oFully trained an analyst in SAS without prior background in one month.

oInstallation of SAS 9.2 and the development of specialized EXCEL interface utilities

oValidation using regression testing and IBM Rational Tool Suite.

oApplications included use of

oSybase

oWindows & MS Office (VISIO, PowerPoint, Word, EXCEL/VBA)

oPC SAS 9.2.

Highmark Blue Cross/Blue Shield, Pittsburgh, PA, 01/09 to 10/09.

Tech Lead/SAS Admin

oProduction support (24/7) and enhancements to Legacy Proprietary ULTRA system

for non-Medicare and non-Dental claims processing and oversight.

oTroubleshooting for SAS batch and SAS/SCL online platforms.

oBack-up of application libraries used for SAS/SCL frames.

oInstallation of PC SAS 9.2.

oValidation using regression testing and IBM Rational Tool Suite.

oSAS 6.09, SAS 8.02, SAS & SAS/SCL 9.1.3 on MF, PC SAS 9.1.3.

oTERADATA, DB2, CLIST, JCL, and ENDEVOR.

Southern California Edison, Los Angeles, 08/08 to 12/08.

Technical Lead/Admin

oPlanning of

olicense upgrade from V6.09 to V9.1.3

omigration of PC/MF SAS to EG/AIX.

oLoading of UNIX user IDs and passwords to SAS Metadata Server.

oTroubleshooting of SAS problems on MF, PC, and AIX.

oDesign of SAS Web Reporting Interface for AIX using SAS App Dev Studio.

oValidation using IBM Rational Tool Suite.

oSAS 6.09, SAS 8.02, SAS 9.1.3 on MF, SAS 9.1.3 on Enterprise Guide AIX,

oUNIX shell scripts

oWindows & MS Office (VISIO, PowerPoint, Word, EXCEL, VBA).

Wells Fargo Retirement Plans, Rosedale, MN, 03/08 to 08/08.

SAS Programmer/Admin

oUpgrades to production applications for performance tuning, and error fixes.

oConversion of SAS macros into object oriented SAS view and data step processing.

oUsed SAS I/O data vector functions for SAS datasets & UNIX files/directories access.

oBuilt a generic SAS email macro.

oValidation included

ostructured UNIX searches of production code,

oautomated comparison of expected and actual results,

orevision of program documentation.

oSAS 8.02 (Macro, SAS data vector I/O functions, SAS view), UNIX Korn SHELL Scripts.

GMAC RFC, Bloomfield, MN, 06/07 to 02/08

SAS Programmer/Admin

oDocumenting & rebuilding a high-volume statistical process for forecasting mortgage

delinquencies and loss reserves.

oSAS Admin activities included

obuilding of generic utility processes for large volume sort & sort/summation,

oUNIX batch SAS execution

outilization review of UNIX servers,

omigration/transfer of production files.

oinstalled and prototyped demos projects for SAS EM, SAS EG, SAS OLAP Suite.

oORACLE/SQL Table loading from SAS datasets using SAS pass-thru for Oracle SQL

oInformatica loading of tab-delimited files.

oSupported production job scripting and oversight with TIDAL scheduling.

oProject management of upgrades for monthly production processes.

oSAS 9.13 (Macro, SAS/SQL, ORACLE/SQL, Enterprise/BI),

o UNIX X-Windows SAS 9.13, UNIX Scripts, Informatica ETL.

Textron Financial, Providence, RI, 11/06 to 10/07

SAS Programmer/Admin

oProgram maintenance and documentation for SAS version migration (V6 to V8).

oSAS 6 and SAS 8 (Macro, ODS/HTML, SQL), Oracle, UNIX X-Windows SAS 8,

UNIX Korn Shell Scripts. Windows NT.

oWriting disaster recovery documents and interfacing an off-shore team.

Kaiser Permanente, Oakland, CA, 08/05 to 11/06

Technical Project Manager

oReport and Master File development for multiple regions and legacy systems.

oProduction mainframe reporting.

oManaged design of vendor master file update of addresses derived from

oexternal third-party databases.

ointernal medical claims MF VSAM files.

oSupervised competitive bidding with major mailing list firms based on

ocomparative list matching scores

odeveloping new data collection process for comparative scoring metrics.

oTeam Lead for review of manual procedures and development of formal SOPs for legacy systems in preparation for ESS conversion and SOX compliance.

oProject management with drafting of proposals, designs, functional prototypes.

oSAS 9 (Macro, ODS/HTML, SQL), Windows NT, COBOL, OS/JCL,

Republic Mortgage Insurance, Winston-Salem, NC, 02/05 to 07/05

SAS Analyst/Admin

oClient server SAS SCL code to process proposals for mortgage insurance on secondary loans.

oPanel & table design with parameter checking, user selected loan filters, & final reporting.

oDrafted end-user procedural documentation.

oSAS SCL product installation.

oCreate specialized SAS libraries with SCL catalogs to support compile applications. SAS8 & SAS9

(Macro, ODS/HTML, SQL), Windows NT.

Wells Fargo Home Mortgage, Frederick, MD, 10/04 to 02/05

SAS Programmer

oValidation and documentation of mortgage loan statistical systems.

oWrote complex queries in SAS SQL.

oExtracted rule sets from reference tables to build generic count validation algorithms.

oWriting of structured validation reports for SOX requirements and coding of parallel

validation programs in generic SAS macro.

o Evaluation of overall validation procedures.

oCreated directories and monitored job execution in UNIX.

oSAS9 (Macro, ODS/HTMLSQL), SAS EG, and UNIX (Korn Shell).

Carlson Marketing Group, Plymouth, MN, 07/04 to 10/04

SAS Programmer/Admin

oReengineering and documentation of standard reports.

oDesign of EXCEL and ACCESS/SQL DB interfaces.

oWrote queries in MS VBA/ACCESS/SQL and SAS SQL.

oRemote submission of jobs on NT server using SAS/CONNECT .

oCreated specialized indexed large scale (50+GB) SAS library, updated monthly, for the analysis of Customer Loyalty Programs.

oCreated integrated formal operational documentation using MS Word, EXCEL, and VISIO.

oValidation using standardized test plans and creation of formal operational documentation.

oSAS9 (Macro, ODS/HTML, CONNECT, SQL),

Federal Home Loan Mortgage Corp, McLean, VA, February 2004 to May 2004

SAS Programmer

oDevelopment, reengineering, and maintenance of standard reports using common routines.

oValidation using comparison of extracts from parallel set of relational tables resident in UBD, MS ACCESS, and Sybase.

oProduction migration to UNIX and mainframe from PC.

oSAS8.02 (Macro, ODS/HTML, CONNECT, SQL), PERL, and UNIX.

Bristol-Myers Squibb (BMS), New Brunswick, NJ, 11/02 to 01/04

Principal Implementer

Designed & developed of a comprehensive statistical system for the à

oAnalysis of drug stability

oPrediction of release estimates consistent with FDA 21 CFR par 11 guidelines

oAutomated editing of an optimal stability model thru a specialized step-wise regression

oSubsequent automated generation of unbiased slope and intercept estimates

oSupplemental analysis of drug degradation and dissolution

oValidation to standards of FDA, client, vendor including test plans, audit trail outputs, and detailed functional documents

Supported by

oExtensive graphic analysis

oODS output

oVBA Front-end..

oPC SAS8.02 (Macro, Statistics, Graphics, ODS/HTML/RTF/PDF).

Dun & Bradstreet, Bethlehem PA, 6/02 to 08/02

SAS Analyst/BI Admin

oBuilt a summation program for commercial lender and borrower credit data

oSpecification of test plans and program documentation.

oPilot PC SAS EIS/OLAP windows menu driven reporting process.

oValidation included test plans, test database queries, and detailed functional documentation.

oMainframe usage with JCL, SAS6 (Macro, Statistics), COBOL, DB2/SQL (QMF, SPUFI).

oPC SAS in SAS8 (Macro, Statistics, Graphics, EIS, OLAP), DB2/SQL UDB/SQL.

Lab Corp, Burlington, NC, 11/00 to 01/02

Financial Analyst

oReporting systems for validation of SAS clinical repositories & managed care/hospital sales.

oAd-hoc reporting to support sales proposals and senior management requests.

oReview of new account setup processing, clinical utilization statistics & external investor reporting.

oAnalysis of medical claims to support reimbursement, fraud detection, & customer profiling.

oValidation processing included data quality assurance of source databases on mainframe & sales accounting servers.

oCritical data editing issues included clinical usage (CPT), account setup, customer billing, and financial reporting to investors.

oMF JCL SAS 8.02 (Macro, Statistics), COBOL, PL/1, DB2/SQL, FTP, & CICS.

oCitrix Server SAS (Macro, Statistics, Graphics, EXCEL/file interface), ACCESS/SQL, UNIX, Teradata/SQL, PERL, Hyperion/Essbase and MUMPS.

LEXIS-NEXIS, Charlottesville, VA, 06/00 to 11/00

SAS Programmer

oDesign of phrased conversion from in-house IDMS/SQL/ADSO system to in-house client

server system with SYBASE data repository.

oMaintenance of existing IDMS/SQL/ADSO maps.

oValidation of conversion reporting to legacy processing.

oMainframe usage with COBOL, CULPRIT, ADSO, and SAS.

oServer usage in SYBASE and Business Objects.

oSupport documents in Word, EXCEL, ACCESS/SQL, and VISIO.

IBM Global, Durham, NC, 7/99 to 02/00

Senior SAS Programmer

oMarketing reports for Kodak/Qualex in MF SAS/DB2/SQL and COBOL II/DB2/SQL.

oMajor batch applications for overall file expansions in SAS/DB2/SQL and DFSORT.

oDevelopment of automated generic tools for GDG record length expansion, and source/data set.

oMigrations using JCL, REXX, CLIST, MACRO SAS, and ENDEVOR.

oValidation included structured test plans, test databases, automated comparison of expected and actual results, and reengineering documentation of legacy processes.

oWord, EXCEL, VISIO, ACCESS/SQL, Visual Basic, and Lotus Notes in Windows NT.

AT&T Wireless, West Palm Beach, 05/99 to 06/99

Programmer

oDocumentation of legacy DEC FOCUS reporting.

oConversions of reports to SAS on UNIX Teradata/SQL server.

oValidation included user review of extracted business rules.

Fleet Mortgage, Florence, SC, 11/98 to 03/99

SAS and System Programmer,

oUpgrades test tape retention & overall systems resource usage and cost allocation.

oDevelopment of generalized utilities for creation and update of keyed ISPF tables.

oValidation included structured test plans, test databases, documentation of legacy processes

and newly installed software.

oDeveloped generalized utilities for remote print and EDI/FTP.

oUsage in JCL, SAS Macro, CLIST/REXX/DMS, and ACF2.

oDocumentation using MS Word, VBA, EXCEL, VB and VISIO.

ALLTEL, OKC, OK, U.S. Banking, 07/98 to 11/98

Programmer

oConversion of Commercial Loan DB from EDS to ALLTEL for a recently acquired bank.

oData Element Mapping and use of standard ALLTEL conversion software.

oValidation using structured test plans, & evaluation of standard ALLTEL conversion tools.

COBOL, Easytrieve, & ACCESS/SQL in IBM VSE/VM/CMS ported thru Windows 95.

1ST Tennessee Bank, Memphis, TN, 01/98 to 06/98

Programmer

oDeveloped end-user systems for support of loan processing.

oDesign and usage of signature card system.

oALLTEL ALS and HOGAN interfaces.

oValidation included structured test plans, test databases,documentation of legacy processes.

oMF JCL, COBOL II, DB2/SQL, CICS, FOCUS, PLATINUM, INTERTEST.

Various Mainframe Projects, 08/97 to 01/98

oPension and seniority applications as well as enhancements to CA CAS MRP system.

oEnhanced end-user tools for online DB2/SQL update and scrollable browse.

oJCL, COBOL II, DB2/Oracle/SQL, CICS, EZTRIEVE Plus. SPF2, PLATINUM, INTERTEST, SAS607, CULPRIT, ADSO, and IDMS/SQL.

Pacific Bell, San Ramon, CA, 12/96 to 06/97

Lead Programmer

oRan splits for three area codes.

oGeneralized system for all fixed format file conversions in NPA splits.

oValidation included structured test plans, test databases,& phased testing

oDocumentation of

olegacy processes

ouser operational and functional guides.

oJCL, COBOL II, VSAM, SYNCSORT, SAS 6.08, CLIST/REXX, and DMS.

Various Mainframe Projects, 9/95 to 11/96

oApplications include health insurance and credit card processing.

oValidation included structured test plans, test databases, phased testing.

oDocumentation of legacy processes, user operational/functional documentation.

oJCL/CLIST/REXX, COBOL II, VSAM, CICS, DB2/Oracle/SQL, Oracle, LIBRARIAN, CHANGEMAN, FTP with UNIX server access. SAS 6 (ACCESS/SQL/AF/ CONNECT/MACRO).

o

BDM, Montgomery, AL, 11/94 to 08/95

Programmer and Tech Lead

oConversion of a child support DB for the State of Alabama from VSAM to DB2/SQL

oApplication and VSAM table design.

oValidation included structured design, structured test plans, phased testing, user presentations, and performance benchmark testing.

oJCL, COBOL II, VSAM, IBM utilities, SQL (Pro-Edit, SPUFI, QMF), CICS, IDMS/SQL, ADSO, TELON, and MS ACCESS/SQL.

Various Mainframe Projects, 02/91 to 12/94

oJCL, DMS panels/tables, VSAM, IBM Utilities, CLIST, COBOL, PL/1, CICS, IMS DB/DC,

IDMS/SQL/ADSO, DB2/SQL/QMF, CULPRIT, SAS (MACRO, FSP, GRAPH, DB2/SQL,

VSAM, IMS, CONNECT), REXX/CLIST.

oReports/graphics for SMS performance measurement.

Arizona Nuclear Power Project, Phoenix, AZ, 07/88 to 12/09

Technical Lead

oMenu driven reporting and DB update for scheduling, labor distribution, purchase

order/material management, capital budgeting, plant modification tracking, performance management EIS/end-user report generation.

oValidation included structured test plans, phased testing, and performance benchmark testing.

oIBM mainframe and PC SAS 5 & 6 (MACRO, FSP, GRAPH, DB2/SQL, VSAM, IMS) invoked by REXX/CLIST, AF, and JCL.

Various Mainframe Projects, 05/79 to 07/88

oVaried MF projects using OS/JCL, DMS panels/tables, VSAM, IBM Utilities, CLIST,

oCOBOL, PL/1, BAL, CICS, IMS DB/DC, IDMS/SQL/ADSO, DB2/SQL/QMF,

oDATACOMM/IDEAL, CULPRIT, SAS (MACRO, FSP, GRAPH, DB2/SQL, VSAM, IMS).

INA/CIGNA, Philadelphia, PA, 04/78 to 04/79

Senior Programmer

oFASTTRACK quarterly reports to Insurance Standards Office for revenue, loss, catastrophe.

oBalanced Ledgers to journals, & rebuilt damaged ledger files

oHomeowners history with parameterized data collection.

oValidation included structured test plans, phased testing, performance benchmark testing, and comparison to external ledgers. JCL, COBOL, PL/I, FORTRAN.

Various Projects on Minicomputers, 12/76 to 03/78

oHealth care, emergency services, and pensions applications.

oFORTRAN, BASIC, ALGOL (DG NOVA), SAS/SPSS (IBM).

Enabling Technologies

Mainframe Programming à COBOL I/II (12 yrs), FORTRAN, PL/1 (4yrs)

IBM à ISPF/JCL/CLIST/REXX/VSAM/IDCAMS/CICS, IBM Utilities, SYNCSORT (12 yrs)

Library Management à PANVALET/LIBRARIAN, CHANGEMAN/ENDEVOR (4yrs) Mainframe Testing à INTERTEST/ABEND-AID (4 yrs)

MS Tools à WORD, EXCEL, VISIO, PROJECT, POWERPOINT, MS-DOS Scripting (10 yrs),

Web à HMTL, JAVA (2 yrs)

SAS Codingà MACRO, GRAPH, STAT, FSP, AF/SCL, SQL, SHARE, CONNECT (20 yrs)

SAS EBI 9.1/9.2/9.3/9.4 à Enterprise Guide, OLAP, Enterprise Miner, BI Dashboard, SAS Grid,

Admin (6 yrs)

Legacy Mainframe DBsà IMS DB/DC, IDMS/ADSO (4 yrs)

DB2/UBD à SQL, PLATINUM, BMC, SPUFI, QMF. LOAD UTILITIES (4 yrs)

SQL àMS ACCESS, SQL/Server, SYBASE, TERADATA (4yrs), ORACLE (6 yrs).

UNIX /LINUX Admin àShell Scripting (5 yrs), Web Logic Server (2 yrs), OBIEE, Informatica (1 yr)

Education

BS, Economics/Statistics (Wharton School, University of Pennsylvania), 1976.

Certifications & Training

Examination I, General Mathematics, Society of Actuaries.

Formal training at SAS Institute in SAS EBI Server v9.2.

Splunk User Training & Certification.

Contact this candidate