Summary:

• 20 years of SAS development and maintenance, including work with BASE SAS, SAS Macro, SAS/CONNECT, SAS/SCL, SAS/AF, SAS/ODS, SAS/BI, SAS/EBI, SAS/EG, SAS/Access Oracle/Ingress/Informix/Datacom/IMS , SAS/IntegrationTechnologies, SAS/InformationDeliveryPortal, SAS/Teradata.
• Strong experience in the professional design, development, and analysis of SAS applications in multiple environments, including SAS/UNIX/LINUX, SAS/Mainframe, and SAS/PC.
• Strong Unix shell KSH, CSH, BASH , DOS .bat , and MVS clist scripting experience 10 years.
• Fifteen 15 years of professional data and programming conversions from SAS/6/7/8/9 and prior.
• Strong experience in development, reporting, and data manipulation using SAS, SQL, and EXCEL.
• Two 3 years of statistical modeling in CONSUMER LENDING with Ford Motor Credit Company, and one 1 year of TRUST DEPOSIT REPORTING with City National Bank.
• Senior Level Programmer Analyst and Project Leader to develop, enhance, and maintain applications in SAS Software via JES2, MVS, OS, CA-7, CLIST and JCL.
• 5 years of SAS/BI and SAS/EBI with Metadata/Administrative and Data Mining experience.
• Application expertise in Quality Control reporting, Profitability reporting, Production Forecast report development, Color Graphics report development, Mailing List development and processing, Medical Claims reporting.
• Adherence to System Development Life Cycle approaches Experience includes writing specifications including instructions for other programmers to follow , with extensive coding, testing, documentation, and training.
• Extensive experience in migration of data and applications between platforms: MVS-to-Unix-to-PC, using SAS/JMP/DATAFLUX/dBASE/LINUX software.
• 3 years of LINUX/RH6 usage and administration with CentOs5.3 virtualization.
• 12 years of piecemeal advertising campaign management assistance 12 months total experience .
• 5 years of medical claims analytical programming BCBSM, Humana, EBCBSNY
• Weeks of Teradata/SQL-Assistant and SAS/Access to Teradata.
• 1 year of CRO/Clinical-Trials data processing.
• 14 days of SAS/DI-Studio and SAS/Admin Management Console work in Cleveland PNC Bank .

Skills:

• Architectures: Client Server, Distributed and Component-Based: VTAM, VSAM, ASCII, ANSI, EBCDIC
• Methodologies: System Development Life Cycle
• Languages: JAVA, C/C , VB, PL/SQL, SQL, SAS, FOCUS
• Platforms: Windows 3.X/ 98 /NT/2000 AND UNIX Solaris, AIX, Redbrick, and Linux
• Back Office: TOMCAT-APACHE, IIS
• Messaging: Notes, MSOffice, EMC2
• Databases: Oracle 7.X/8I, MS SQL Server, DB2, Sybase, Objectivity and MS Access DB2 QMF, SPUFI , IMS DB/DC MFS , Focus 6.0 OS/MVS , PC Focus 5.0, Oracle 6.0 7.0
• Web Technologies: HTML, XML, JSP, JavaScript, C, C , C , VBScript

Professional Experience:

Confidential

develop and maintain programs to pull Lease Renewals report data from Teradata with highest efficiency, and to push the resulting reports with SAS9.3 and SAS/EG5.1 unattended to MicrosoftPowerPoint10 for presentation to highest management. I explain data processes to high management. I develop and provide User documentation to maintain knowledge flow amongst operational staff beyond my individual contract contributions.

Environment: SAS9.3/base/macro/connect/access/graph via SAS/EG and SAS/DMS on Windows 7 Enterprise Edition, plus PuTTY and SQL Assistant on Linux. Minor use of SAS9.3 on MVS but my data access is limited there. Use of WinSCP and MS Office and SAS tools.

Confidential

installation/troubleshooting and application development for predictive analysis of cruise bookings revenue stream. I coordinated Oracle data ETL under Linux, and instructed four other SAS programmers on use of SAS/DataMiner and SAS/ForecastStudio for development of Predictive Models in SAS9.4 Software. I developed and provided User documentation to maintain knowledge flow amongst operational staff beyond my contract contributions.

Environment: SAS9.4/base/macro/connect/access/graph/ForecastServer/EnterpriseMiner via SAS/EG and SAS/DMS on Windows 7, plus PuTTY on Linux. Use of WinSCP and MS Office and SAS tools.

Confidential

Oversaw the migration of a large Linux/Oracle file to SAS/BaseDataset, and instructed two other SAS programmers on how to use the resulting dataset for the desired Wells Fargo analytics and reporting purposes.

Confidential

Managing Loan Loss Prevention data with Strata, Teradata and SAS9.2 on Linux platform, in support of Automotive Loans Loss Prevention Modeling. Use of Teradata/SQL Assistant, Teradata/SASCONNECT, SAS/DMS, SAS/EG, SAS/DataMiner, and Strata 4.2, with Credit Scoring data and Loss Prevention data credit-loan records . Creation of credit-score-update routine in Teradata and productivity reporting in SAS/Connect/Base/Excel.

Environment: SAS9.2/base/macro/connect/access/graph via SAS/EG and SAS/DMS on Windows 7, plus PuTTY on Linux. Use of WinSCP and MS Office and SAS tools.

Confidential

Migrating mortgage banking data with SAS9.2 from Oracle on AIX platform to Teradata on Linux platform, in support of Mortgage Loss Prevention Modeling.

Environment: SAS9.2/base/macro/connect/access via SAS/EG and SAS/DMS on Windows 7, plus PuTTY on Linux. Use of WinSCP and MS Office tools.

Confidential

Migrating 500-module SAS9,13 reporting application systems from MVS/zOS/SAS9.13 processing environment to Linux/SAS and MVS/zOS/WPS processing environment.

Environment: Lotus Notes8.5 office productivity software WebApp and Sysco office productivity software Jabber .

Confidential

• Moving customer banking records between AIX/Oracle and LINUX/Teradata platforms, and migrating application programs to LINUX environment. Use of Microsoft Office office productivity software SharePoint/TouchPoint .
• WellsFargo/IT Re-platforming Project to move existing SAS applications and data from Oracle/AIX/CRON configuration single-threaded, with no strategic software to Teradata/Linux/AutoSys configuration multi-threaded, with SAS/GRID and SAS/BIS strategic software .
• Use of SAS9.1.3 Software on Unix and Windows/XT, and SAS9.3 on Linux and Windows8.
• Use of PuTTY emulator on WindowsNT, plus IPSwitch file transfer package
• Implementation of batch processes in Unix and Windows, and interactive/foreground SAS processing in EG and DMS modes.
• Development of scripts Korn shell scripting on Unix and .bat scripting on Windows .
• Use of CA-UnicenterR11/AutoSys, Citrix emulator, MyED emulator
• Use of IQNavigator timekeeping software
• Use of Extra MVS emulator.
• Use of Hummingbird/Exceed X11 UNIX environment emulator.
• Work with BASEL I II credit accords for mortgages.
• Work with credit scoring data for mortgage and card issuances, and predictive modeling using SAS/DataMiner and SAS/RiskDimensions software.
• Use of SAS/EBI, SAS/EnterpriseMiner, SAS/IntrNet, SAS/Grid, and SAS/Forecasting strategic software packages, plus SAS/Base, SAS/Stat, SAS/ETS, SAS/AF, SAS/SCL, SAS/SQL, and SAS/OR traditional packages.
• Use of SAS/EG, SAS/ODStoWeb, SAS/ODStoExcel, SAS/StoredProcesses, SAS/OLAPCube , SAS/Macro.
• Use of CA11 Autosys scheduler.
• Knowledge of data sets, base SAS, OLAP Cubes, Stored Processes, Web Report Studio, Data Integration Studio, Enterprise Guide, and LSF Scheduler on AIX.
• Experience with user admin, group admin, db connection set-up.
• Routine experience to create and update support documentation.
• Routine assisting in migration and upgrading to SAS 9.3, including ad hoc and triage of issues.

Confidential

• Maintenance and enhancement of medical claims analytics software package. Statistical analysis of medical claims data for adherence to cost savings opportunities and charge assignment opportunities. Goal was to validate Medicare Claims as being truly assignable to Medicare or instead to primary providers.
• Moving ICD9 codes to ICD10 codes.
• Use of SAS9.1.3 Software on MVS/zOS and SAS9.3 on Windows7.
• Use of Passport emulator on Windows7, plus ISPF/TSO on IBM Mainframe primarily batch z/OS but sometimes foreground.
• Development of CLISTs MVS scripting language

Confidential

• Use of SAS 9.2 on Linux CentOS 5.3 host
• Contracting with TAJ
• Development of AF scripts for automated point-and-click naive processing success.
• Use of SAS/EG/Base/Stat/AF/ETS/FSP/IntrNet/ODS/InformationTechnologies suite software, in Linux emulator CentOS environment.
• Maintenance and enhancement of clinical research analysis and reporting software package. Monitoring of clinical trials achievements for adherence to FDA guidelines and reporting requirements.

Confidential

• Hands-on access configuration to get Oracle data feeds into SAS Data Warehouse datamarts based on SAS/Management Console metadata profiles for SAS/Connect.
• Use of SAS/EnterpriseBusinessIntelligence Software to convert SAS thick-client platform reporting processes to SAS/Portal thin-client web-based reporting processes.
• Use of SAS/DataIntegrationStudio Software to access production data from Oracle tables on UNIX to SAS tables on Windows XP.

Confidential

Hands-on access to old Dell laptops and new HP laptops, with HP proprietary program to move each GM staffer's professional project files and data files to new platform with minimal disruption to user productivity and preferences.

A daily hour of efficiency was achieved for each GM staffer due to improved hardware/software/network startup times.

Confidential

• Hands-on configuration of SAS/Share Software on SunOS Unix platform, for research organization with 50 networked Unix software users. SAS 9.1.3 Software, Solaris10 host, Sun Ultra platform.
• Consulted with research data users on methodologies for processing shared clinical data CRO .
• Prepared Systems and User documentation for processing of CRO Clinical Research Organization and CDISC Clinical Data Interchange Standards Consortium data.
• Development of BASH scripts for automated point-and-click naive processing success.
• Contracting through CYBER Technology, Inc.

Confidential

• Developed and enhanced SAS/AF/SCL-based application for preparing voluminous management year-end Equal Employment Opportunity reports.
• Developed and maintained the EEO Master Program personnel management reporting process utilizing SAS with STORED PROCEDURES and ODS.
• Processing inputs from flat-file FOCUS extracts and outputs to EXCEL WORKBOOKS WITH MULTIPLE WORKSHEETS, plus outputs to HTML Intranet web pages
• Responsible for the migration of data and programming from SAS 8.1/NT to SAS 9.2 PC/XP.
• Upgrading of SAS 9.1.3 programming to SAS 9.2 generally allowing outputs of data to Excel workbook pages via XML .
• Use of DATAFLUX aka DBMSCOPY to convert EXCEL files to SAS TRANSPORT.
• Coordinated with Veterans Administration programming staff in Minneapolis/St. Paul.
• Prepared miscellaneous Department of the Interior data reports utilizing SAS.
• SME Subject Matter Expert for SAS/AF programming and implementation.
• Development of SAS/AF scripts for consistent point-and-click naive processing success.
• Development of DOS/ .bat scripts for automated and consistent point-and-click naive application installation and processing success.
• Contracting through Elite Business Systems, LLC.

Confidential

• Developed and maintained the MANIFEST dealer sales of OnStar System reporting system, utilizing SAS ODS reporting to WEB from SAS/Access Oracle Data extracts.
• Migration of programming and data from SUN/Unix to PC/XP, with conversion from SUN/Unix/Oracle to PC/XP/SAS and PC/XP/EXCEL to PC/XP/SAS and back.
• Used BASE SAS, SAS Macro's, and SAS/CONNECT to pull Oracle data into SAS for detailed manipulation and unattended report generation.
• Developed SAS/Batch processing modules on Windows-XP for unattended processing.
• Generated sales performance reports at car-dealership-level for US and Canada markets.
• Used TOAD data management software to view Oracle data and test Oracle/PLC SQL queries, and to occasionally pull Oracle data into CVS tables for viewing with EXCEL.
• Exporting extracts from ORACLE using SAS for OUTPUT TO EXCEL WORKSHEETS
• Pulling data from COGNOS for reporting with SAS/Connect for SAS/BI-Portal and SAS/EBI.
• Use of COMPILED BAT and DBMSCOPY/DATAFLUX to automate jobs.
• Demonstration of JMP7 versus SAS Software for making Sales Analytics Reports.
• Use of SAS/AF and DOS/ .bat for development of scripts for automated point-and-click naive processing success.
• Sales campaign management assistance for Cadillac dealership sales incentives.
• Use of Perl regular-expressions.

Confidential

• Development of POPS9 Demand Forecasting Application utilizing SAS.
• Migration of data and programming from SAS/8.1/NT to SAS/8.1/PC/XP and back.
• Developed, enhanced, and mentored in on-line modules of a Data Tuning Control System.
• Performed extensive SAS/AF window development: drag-and-drop of CONTROLS onto FRAMES and coordination of underlying SCL program instructions.
• Wrote user and system documentation with images .
• Coded, tested both system and user , and trained users both one-on-one and small groups .
• Coded SAS/AF on-line programs on Windows2000 networked server.
• Enhanced FRAME ENTRY screens.
• Wrote SCL and ODS under SAS/BI and SAS/EBI for POPS9 processing.
• Analyzed records for data completeness and statistical soundness MEANS, SUMS .

Confidential

• Testing and pre-purchase justification of the SAS/INTEGRATED TECHNOLOGIES product.
• Used SAS/BASE/MACRO/CONNECT analytic software, EXCEL and WORD desktop software for analysis and development.
• Wrote REDBRICK DB2 modules for pass-thru execution of extract modules in SAS via SAS/ODBC.
• Wrote ORACLE PLC modules to SAS/SQL for direct execution in SAS via SAS/CONNECT2DB2 across network.
• Used Hummingbird emulator from PC Platform on Windows2000 to AIM and REDBRICK servers.
• Used LOTUS/NOTES enterprise software.
• Testing of SAS/BI and SAS/EBI packages for acquisition.

Confidential

• Development, maintenance, and enhancement of FORWARDS oil supply line distribution reporting system utilizing SAS
• Used SAS/BASE/MACRO/CONNECT/RISKDIMENSIONS analytic software, EXCEL and WORD desktop software. Millions of records analysis.
• Use of SAS/RD/DWA/MDDB/Base/ETS/Access: Sybase on AIX and NT platforms plus VPN.
• Discussed CHANGE-CONTROL software options with PROJECT MANAGEMENT, but no change-control was implented technology was in its infancy about this at the time .
• Wrote logic modules to troubleshoot records that were identified by the master collection module as containing missing Data, and used artificial-intelligence rules to fill in the missing data and restock the data to the central database.
• Used NT Platform with direct-connect and VPN-connect facilities.
• Wrote an Artificial Intelligence module to mimic process used for filling in blank information based on various available constraints in other parts of the data, for DASHBOARD financial derivatives investments processing system.
• Utilized SAS/Risk Dimensions Software.
• Use of Windows2000 and SQL-Server platforms with VPN/FTP.

Halliburton Company, SAS Programmer Analyst