| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
Phone: PHONE NUMBER AVAILABLE, email: EMAIL AVAILABLESAS BI PLATFORM ADMINISTRATIONSkills ProfileLanguage/Script SQL PERL HTML PL/SQL KORN SHELL Red Hat Linux 7.9 AWK Java Script Unix 6.x/7.xSoftware 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 TierEducationBoston University, Boston MADegree: MS Computer Information SystemsTufts University, Medford MADegree: MS PhysicsUniversity of Science and Technology, GhanaDegree: BS PhysicsCertifications/TrainingArchitecting on AWS 2022SAS Grid Manager: Administration course 2017ICAgile Certified Professional (ICP) 2017CompTIA Security+ Certification 2017Certified Base Programmer for SAS9 2007Oracle Certified Professional (DBA) 2005Employment HistoryAccenture LLC Arlington, VA July 2014 PresentSAS BI Administration Consultant, Accenture Federal ServicesAccenture Project: Department of EducationSAS 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 andmigrated 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-tierarchitecture (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 createmetadata 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 forMicrosoft 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.2Included migration of SAS Enterprise Guide, Enterprise Miner, Forecast Studio, Simulation Studioprojects. 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 andset 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, scanServer 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 EducationSAS Enterprise Miner and SAS Enterprise GuideSAS 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 teamPre-installation setup, installation, and the post-installation and configuration. Performed impact assessment and knowledge transfer of configuration of SAS/ACCESS to Greenplumand 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 onprojects 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 CloudInstalled and configured the following SAS modules on the Amazon cloud (AWS)Base SAS SAS Office AnalyticsSAS LASR Analytic Server SAS Visual AnalyticsNon-distributed mode SAS/ACCESS Interface to ODBCSAS Metadata Server SAS/CONNECTSAS 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 monitorthe 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, bestpractices, support and training of SAS business intelligence tools and applications. Created and promoted SAS standards, methodologies, tools and knowledge that are geared towardsAccenture SAS business operations. Assisted in building SAS skill and team building to encourage shared learning.Accenture Project: Center of Excellence B&P Fraud PreventionSAS 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 serveron 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 clientWindows 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 2014Senior 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 andmaintained SAS licenses. Coordinated testing of platform once updates, patches and configuration changeswere 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, Teradataand 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 toMetadata Repositories, tables and data definitions on Unix Server. Set up and secured metadata folder structures. Created metadata profiles for clients using the SASManagement 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 helpusers with day-to-day UNIX accounts setups and access problems for SAS applications. Supported SAS/IntrNet application services. Restarted servers and Load Managers automatically afterreboot. 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. Theseincluded DBAs, Data Warehouse, Monitoring and Performance, UNIX, and System storage teams.Library of Congress Washington D.C. August 2004 July 2005Application 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 InternationalDevelopment Aid programs requested by the Congressional Research Service Analysts.US Census Bureau Suitland, MD February 1999 August 2004IT 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 formatcatalogs for population and housing variables. Developed perl, awk, and korn shell scripts to manipulate data files and to invoke SAS programs inbatch mode during system integration. Developed a SAS IntrNet application to generate reports of comparison statistics of demographicsurvey 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 theproduction system during system planning, design, and documentation. |
