SAS Admin/Programmer

John K Owusu-Djamboe

**** ******* **** ******, **********, VA 22191

Phone: 571-***-****, email: ********@*****.***

SAS BI PLATFORM ADMINISTRATION

Skills Profile

Language/Script

• SQL • PERL • HTML

• PL/SQL • KORN SHELL • Red Hat Linux 7.9

• AWK • Java Script • Unix 6.x/7.x

Software

• Base SAS 9.1/9.2/9.3/9.4 M48 • SAS Enterprise Guide 4.1/4.3/6.1/7.1

• SAS/IntrNet • SAS® Grid Manager: Administration course

• SAS Viya 3.5/4 • SAS/ACCESS to DB2, ORACLE, Hadoop

• SAS Macros • ODBC, Teradata, Netezza, SAP HANA

• SAS Integration Technology BI Platform • JBoss Server, SAS Environment Manager

• RHEL 7.9, Windows server • SAS Web Infrastructure kit – SAS Stored

• SAS Management Console • Process Web Application Middle Tier

Education

Boston University, Boston MA

Degree: MS Computer Information Systems

Tufts University, Medford MA

Degree: MS Physics

University of Science and Technology, Ghana

Degree: BS Physics

Certifications/Training

Architecting on AWS 2022

SAS® Grid Manager: Administration course 2017

ICAgile Certified Professional (ICP) 2017

CompTIA Security+ Certification 2017

Certified Base Programmer for SAS9 2007

Oracle Certified Professional (DBA) 2005

Employment History

Accenture LLC – Arlington, VA July 2014 – Present

SAS BI Administration Consultant, Accenture Federal Services

Accenture Project: Department of Education

SAS 9.4 M8 Installation:

• Supervised upgrade of SAS 9.4 M7 to SAS 9.4 M8 and applied all hotfixes required by SAS on all environments.

SAS Viya 4 install

• Leading and supervising install of SAS Viya 4 on Amazon EKS.

Accenture Project: US Census Data Lake (CDL)

SAS 9.4 M7 Installation: Three-Tier Architecture

• Upgraded SAS 9.4 M6 to SAS 9.4 M7 and applied all hotfixes required by SAS on the following environments –

DEV, TEST, STAGE and PROD environments.

• Reduced the SAS footprint of the CDL STAGE environment from a three tier architecture to a one tier and

migrated all applications from the 3-tier to 1-tier.

• Installed and configured SAS 9.4 M6 software on AWS Cloud Linux serves. Deployment was a three-tier

architecture (metadata, compute, mid-tier). Deployed and configured SAS on five environments, namely, DEV,

TEST, ITE, STAGE, and PROD.

• Configured SAS/ACCESS to Hadoop 3.1 and connected to Hadoop cluster on Linux RedHat 7.6 .

• Deployed R 3.6.0 software on SAS Linux servers and installed R packages from the Census CRAN MIRROR for users.

• Configured SAS/ACCESS to Oracle and connected to Oracle servers on the DEV, TEST and PROD environments.

• Installed SAS client tools including SAS Enterprise Guide on windows 2012 R2 servers and assisted users to create

metadata profiles to connect to SAS Foundation on Linux.

• Created job aids and user guides for SAS users to submit SAS jobs to Hive through SAS Studio, interactive and batch.

• Used SAS Management Console to manage users, groups, roles and access control and metadata access.

• Developed Unix scripts to monitor the SAS Environment for SAS workspace usage, CPU and memory and storage.

• Installed and configured SAS Viya 3.5 for AFS for the Fraud analysis project.

Accenture Project: Defense Logistics Agency (DLA)

SAS 9.4 M4 Grid Installation: Three-Tier Architecture

• Assisted in grid installation and configuration of SAS Studio, Enterprise Guide, Enterprise Miner, SAS Add-in for

Microsoft Office, SAS Data Surveyor and Data Integration Studio.

• Provided guidance on SAS System Administration to peers.

• Applied hot fixes to all tiers in SAS Grid installation.

• Troubleshooting of application errors during testing and production support.

• Created Unix scripts to monitor the SAS grid environment for performance and stability.

• Supported knowledge sharing and transfer to developers.

• Assisted with troubleshooting user problems associated with SAS Studio, Enterprise Miner, and EG applications.

• Assisted in code and data migration efforts, and knowledge transfer.

Accenture Project: Veteran Affairs – VBA EDW (Project Allegiance)

Served as the lead SAS Administrator responsible for architecture, configuration, enhancement, and maintenance of the enterprise SAS environment at VA Office of Performance Analysis & Integrity (PA&I)

• Performed full migration of SAS 9.4 M1 on 64 bit windows 2008 R2 server to 9.4 M3 64 bit RHEL 7.2

Included migration of SAS Enterprise Guide, Enterprise Miner, Forecast Studio, Simulation Studio

projects. Using cport/cimport to migrate data sets from windows platform to Linux environment.

• Performed SAS environment design and monitoring using windows/Unix batch scripting as a wrapper for SAS monitoring programs and applications on windows server 2008 R2 and RHEL Linux platform.

• Performance tuning of SAS software and client application.

• Performed capacity and utilization planning and management of SAS environment.

• SAS client application security management.

• Developed scripts to monitor and clean up the SAS work area, put SAS server startup scripts in auto reboot and

set up SAS Deployment backup and recovery tool for the SAS environment.

• Performed SAS application upgrades and hot fixes on both windows and Linux platforms.

• SAS 9.4 M1 and M3 installation and configuration on server machines and client workstations.

• Established a stable and reliable SAS environment with high reliability and dependability.

• Developed a system to monitor the SAS environment for bottlenecks and failures.

• Developed and installation and configuration job aids based on VA policies and industry best practices.

• Used SAS Management Console to manage users, groups, roles and access control and metadata access.

• Supported SAS users with server connection configurations and SAS module access issues.

• Configured SAS Environment Manager extended monitoring to monitor platforms, servers and services, scan

Server logs for particular events and create alerts. Used the Report Center to create logs for auditing.

• Performed knowledge transfer to users to address application performance issues including memory, CPU, and I/O bottlenecks.

• Educated users on programming efficiency to minimize creation of temporary files that fill up server drives and SAS virtual memory.

• Trained users on standards and best practices in using SAS software and applications.

• Developed SAS code for analysts and programs to create reports.

Accenture Project: Department of Education

• Installed the following SAS tools to provide a managed service for Department of Education

SAS Enterprise Miner and SAS Enterprise Guide

SAS Analytics Pro - Base SAS, SAS/STAT, SAS/GRAPH, SAS ETS

• Performed the post-installation configuration including SAS/ACCESS to Greenplum on Linux 7.1 server.

• Laid out server system specifications and requirement for the deployment.

• Created SAS installation procedure documentation and SAS environment monitoring and alert documents.

• Completed installation and configuration of SAS Analytic Pro on TSYS pre-prod and prod Linux servers.

• Configured SAS Enterprise Miner to connect to server .

• Transferred knowledge of SAS 9.4 installation and configuration to members of the Linux team

Pre-installation setup, installation, and the post-installation and configuration.

• Performed impact assessment and knowledge transfer of configuration of SAS/ACCESS to Greenplum

and administration of the SAS environment.

• Documented the installation and configuration of SAS Enterprise Miner client workstations.

• Trained associates on SAS programming skills and efficiencies techniques.

• Trained users to run SAS Enterprise Miner applications.

• Trained Sys Ops group on SAS server monitoring techniques.

Accenture Project: AFS – Accenture Federal Services

• Installed PC SAS software including JMP for AFS associates aspiring to pick up SAS skills for a new project or for career growth for knowledge expansion and business development.t

• Helped develop SAS skills and tools needed by AFS associates to execute current responsibilities on

projects that use SAS.

• Counseled AFS associates on business decisions and potential uses of SAS applications.

• Provided documentation to AFS associates to help build SAS skills and expertise.

• Introduced associates to SAS programming techniques providing SAS programming tips.

Accenture Project: Center of Excellence – SAS Visual Analytics on Amazon Cloud

•Installed and configured the following SAS modules on the Amazon cloud (AWS)

Base SAS SAS Office Analytics

SAS LASR Analytic Server SAS Visual Analytics

Non-distributed mode SAS/ACCESS Interface to ODBC

SAS Metadata Server SAS/CONNECT

SAS Viya 3.5

• Installed and configured PostgreSQL database server on cloud.

• Installed SAS Viya 3.5 on Amazon EC2.

• Installed and configured SAS system requirement for the Business Intelligence deployment.

• Transferred knowledge of SAS 9.4 installation and configuration to members of the Analytics team at the Department of Education.

• Configured SAS/ACCESS to PostgreSQL database and imparted knowledge of configuration and administration of the SAS environment to Analytics team.

• Configured and administered the SAS LASR server and train associates how to administer and monitor

the LASR server instance for maximum performance.

• Trained associates on SAS programming skills and efficiencies.

• Trained users to run SAS Enterprise Guide applications and connect to the SAS server environment.

• Performed knowledge transfer of SAS debugging techniques and program efficiency tips to associates .

• Participated in the ‘Center of Excellence’ project to provide SAS business solutions, leadership, best

practices, support and training of SAS business intelligence tools and applications.

• Created and promoted SAS standards, methodologies, tools and knowledge that are geared towards

Accenture SAS business operations.

• Assisted in building SAS skill and team building to encourage shared learning.

Accenture Project: Center of Excellence – B&P Fraud Prevention

SAS Fraud Framework on Amazon cloud

• Performed the installation of SAS Fraud Framework for Government, Enterprise Case Management, Financial Crime Monitor (FCM) and Social Network Analysis (SNA).

• Owned the installation, configuration and testing of SAS Fraud Framework, Enterprise Case Management, and SAS Social Analysis Network software on the Amazon cloud (AWS) on a Linux server.

• Installed Windows client tools that include Base SAS, Credit Scoring for SAS Enterprise Miner Client, SAS Enterprise Guide, SAS Enterprise Miner Personal Client, SAS Model Manager Report Registration Client, Text Miner Personal Client.

• Installed and configured the PostgreSQL database server to communicate with the SAS serve.r

• Train users to run SAS Fraud Framework (SFF) and SAS Social Network Analysis (SNA) applications.

• Set up and configured metadata profile for users to be able to connect to SAS application services.

• Performed knowledge transfer to users on query optimization and process monitoring.

• Trained associates on SAS programming skills and efficiencies.

Accenture Project: Center of Excellence – LLP Kohls Client

• Led the installation, configuration and testing of the following SAS products on a Windows 2012 server

on the Amazon cloud (AWS). These included SAS/ACCESS to Oracle and ODBC.

• Installed and configured the SAS Enterprise Miner client and SAS Enterprise Guide on the client

Windows server.

• Transferred knowledge of installation of SAS 9.4 M2 on windows 2012 server to the Analytics team. This involved administering the pre-installation setup for third party tools and opening up the required inbound and outbound ports on the Amazon cloud to allow communications to the SAS server.

• Set up Windows accounts on the SAS server for Analytic team members.

GEICO Insurance Corporation – Chevy Chase, MD July 2005 – June 2014

Senior Systems Engineer/SAS Administrator:

• Installed/configured/maintained PC SAS 9.1/9.2/9.3/9.4 for 300 Geico SAS users. Maintained SAS/CONNECT scripts for remote connection from PC to UNIX 7.1 and Mainframe SAS.

• Applied maintenance/hot fixes and service packs to client PC SAS and SAS UNIX server installations and

maintained SAS licenses. Coordinated testing of platform once updates, patches and configuration changes

were made.

• Installed/configured/maintained UNIX SAS 9.1/9.2/9.3 on three AIX 6.1/7.1 virtual servers.

• Installed/configured/maintained SAS/ACCESS interfaces to DB2, Oracle, SQL Server, ODBC, Netezza, Teradata

and PC File on AIX UNIX Server and established connectivity to these data sources.

• Installed/configured SAS Enterprise Guide 4.1-6.1 on client PCs to connect to UNIX SAS.

• Installed SAS Integration Technology BI tools on UNIX servers and configured SAS Enterprise Guide to

Metadata Repositories, tables and data definitions on Unix Server.

• Set up and secured metadata folder structures. Created metadata profiles for clients using the SAS

Management Console, assisted them to run applications using the workspace and stored process servers.

Added users and manage their access. Administered repositories and metadata.

• Performed tuning and routine maintenance to ensure ongoing availability and optimal performance of the environment.

• Developed specifications for UNIX cleanup scripts and monitor SAS work area and virtual memory to maintain a stable production and test environments.

• Developed UNIX startup scripts and maintenance scripts to monitor the SAS environment for I/O, memory, and disk space utilization. Develop scripts to wipe out idle SAS user processes that were consuming system resources and affecting performance.

• Developed UNIX scripts to recycle the SAS metadata servers and cleaned out workspace Server logs to save file system disk space. Support SAS users with platform errors, performance tuning, prevention of failures, or optimizing the environment.

• Analyzed business requirements to determine impact on the environment.

• Worked with the Unix Administrators to test out SAS system applications after server upgrades and help

users with day-to-day UNIX accounts setups and access problems for SAS applications.

• Supported SAS/IntrNet application services. Restarted servers and Load Managers automatically after

reboot. Recycled SAS/IntrNet application servers and ports and clear request log daily.

• Attended meetings with other technical groups supporting SAS users to improve the environment. These

included DBAs, Data Warehouse, Monitoring and Performance, UNIX, and System storage teams.

Library of Congress – Washington D.C. August 2004 – July 2005

Application Developer/SAS Administration:

• Involved in migrating SAS data to Oracle 9i consolidated database, validating requirements and generating reports to provide customers with weekly, monthly, and annual reports on Congressional Research Service personnel data.

• Assisted in installation, configuration, and documentation of SAS/IntrNet and other SAS Servers and tools and provided SAS/Oracle programming skills to Congressional Research Service SAS user community.

• Utilized SAS development tools (SAS/IntrNet, SAS Macros, ETL Server to manage data, SAS/Access to address SQL databases (Oracle) to support the development, implementation and use of multiple SAS Solutions for Congressional Research Service Analysts.

• Developed a SAS web application using SAS/IntrNet and JAVA scripts/HTML for USA International

Development Aid programs requested by the Congressional Research Service Analysts.

US Census Bureau – Suitland, MD February 1999 – August 2004

IT Computer Specialist

• Created demographic, social, economic, and housing statistical estimates from survey sample data for sites in the United States using Base SAS, SAS macros and UNIX routines on a Unix server.

• Extracted source files and metadata from spreadsheet and tab-delimited text files into SAS and created multi-dimensional tables for dissemination on CD-ROM and Census Bureau web site for the American Community Survey (ACS) tabulations.

• Wrote SAS macro code to re-format and recode variables in data dictionary and created format

catalogs for population and housing variables.

• Developed perl, awk, and korn shell scripts to manipulate data files and to invoke SAS programs in

batch mode during system integration.

• Developed a SAS IntrNet application to generate reports of comparison statistics of demographic

survey profiles for Analysts and Statisticians in the Demographic Survey Division of the Census Bureau.

Utilized TopDown FlowCharter 5.0 and Visio 32 to create data and process flow diagrams for the

production system during system planning, design, and documentation.

Contact this candidate