Technology Support Sas Administrator
Resume:
YING ZHANG
E-mail: *****.**@*****.***, Phone: 1-940-***-****
HIGHLIGHTS OF QUALIFICATIONS
•20+ years working experience and knowledge in various IT platforms: SAS, RHELinux / UNIX / Windows for HP/DELL/SUN Enterprise Servers, MSSQL / Oracle / Postgres / MySQL / Greenplum Database Systems and Network.
•Proficient in system administration and technology support. 10+ years experience as a SAS Administrator and excellent knowledge of SAS Foundation, SAS Grid and SAS VA.
•Skilled in Linux/UNIX Shell Scripting, C/C++, SQL and Ansible.
•Creative thinking and troubleshooting, strong organization and management skills, and demonstrated ability to work on multiple projects simultaneously.
•A great team player, quick learner, highly self-motivated, efficient and responsible.
•Excellent interpersonal and documentation skills.
WORK EXPERIENCE
Sr. SAS Platform Administrator 2019/11–now
JPMorgan Chase & Co., Dallas, TX, USA
•Provide Senior L3 support for AS Viya SA tasks on Cloud, SAS 9.4 Platforms, multi-tier environments, on AIX / RHLinux / Windows, including installation, administration, architecture, operations etc.
•Deploy, maintain, upgrade, tune etc. all SAS SA Tasks for SAS Viya 4 on Cloud.
•Deploy SAS 9.4 M7 Cost and Profitability Management with SSAS.
•Upgrade SAS 9.4 M4 to M6 and M6 to M7. Migrate SAS Metadata.
•Re-Deploy SAS 9.4 Mid-tier with SSL, update Apache Web Server.
•Set up SAS/Access to Oracle / Teradata / Greenplum / Hadoop / MSSQL etc.
•Apply SAS hot fixes, renew SIDs, configure SAS schedule jobs and monitor SAS systems.
•Manage metadata users and support end users if needed.
Sr. Consultant (SAS Platform Administrator) 2019/06–2019/11
CGI Federal Inc., contracted to the U.S SSA, MD, USA
•Administrate SAS 9.4 and Visual Analytics Platforms in a multi-tier environment.
•Monitor SAS Servers and users support.
Sr. LAN Analyst (SAS Administrator) 2015/10–2019/05
OneMain Financial Services, IN, USA
•Take the primary responder of SAS Grid and Visual Analytics Platforms and Users Support.
•Play a key role in SAS Grid and SAS VA platforms upgrade, including SAS Grid from SAS 9.3 Windows to SAS 9.4 RHEL, SAS VA from 7.1 Non-distributed to 7.3 Distributed, servers pre-installation, installation, configuration, migration and UAT etc.
•Perform SAS Software Administration, including software installation and configuration, updates, patches and Hotfixes, and license renewals on RHEL / Windows platforms.
•Provide SAS Platform Capacity planning, metrics and performance tuning.
•Achieve and maintain optimum SAS platform performance, reliability and availability.
•Manage metadata identities, users, groups, roles and scheduled jobs and so on.
•Use SAS Management Console to define connections to data sources, define libraries, and create metadata objects and folder structures.
•Manage permissions to metadata objects.
•Support SAS users, clients and tools, including PCSAS, SAS/Access, SAS Enterprise Guide and EMiner, Citrix VDIs, VMs and SAS Add-in for MS Office.
System Administrator (RH Linux, CentOS) 2015
Indiana Health Information Exchange (IHIE), IN, USA
•Maintained and troubleshot 200s RHEL Servers with Tomcat applications.
•Installed and configured CentOS and Oracle Server.
•Migrated VMware vSphere EXSi4.0 virtual machines.
•Monitored Linux Servers with Opsview.
•Set up and troubleshoot LOG Server, Log4j.
•Configured LOG Server and Opsview Server.
System Administrator (RH Linux, MS Windows, ORACLE, MSSQL, MySQL) 2014
BCforward, contracted to Indiana Department of Education, IN, USA
•Designed and Implemented solution for Oracle Red Hat Enterprise Linux System Migration.
•Installed and configured VMware vSphere EXSi5.5 host and virtual machines.
•Installed a Hadoop Server and Postfix MTA server on CentOS.
•Maintained and troubleshoot RHEL Servers for DNS, FTP, SFTP, Send mail, Mailman etc.
•Installed MS SQL Server 2012 Failover Cluster with two MS Windows 2012 nodes, Domain Controller, DNS, IIS and Network Load Balancing Cluster.
•Set up Moodle Learning Management System on MS Windows 2008 R2 Server, MS SQL Server 2008, Apache and PHP.
Systems Analyst III (SAS, RH Linux, MS Windows, MSSQL, MySQL) 2002-2013
PHR, Alberta Health Services, Alberta, Canada
•Provided technical leadership and solution architecture, improved IT infrastructure for PHR.
•Evaluated existing systems and designed and constructed performance integrated platforms to meet business requirements, including SAS and R, MSSQL, VM servers etc., and managed software development life cycle.
•Installed and configured new hardware and software.
•Performed all administrator functions to the all department Red Hat Enterprise Linux and Windows and Solaris servers for a variety of applications, including SAS, STATA, R, MSSQL, VM, Subversion, LAMP, TeleFrom, Freezerworks and CPAC&OPAL.
•Installed and configured and maintained MSSQL, MySQL, and Oracle Database Systems.
•Mentored and trained junior IT team members provided high level technical support and training to users in responding to help desk requests.
Senior System Analyst, Architect (UNIX, Win2000/NT, ORACLE and Network) 1998-2001
Computer Center of CHINA TELECOM, China
•Provided technical leadership and project management for infrastructure architecture to achieve successful business development and strategy execution.
•Contributed to solution analysis and system architecture, including analysis, design, planning, data integration, interfaces and implementation.
•Worked with business partners, vendors and IT strategy team to align technology solutions with business requirements.
•Worked as a project leader to develop Telecom Service Integrated Management System to improve telecom service operation and management. Achieved data sharing and highly automatic telecom service on a unified computer network platform.
•Participated in the development of Telecom Network Management System to achieve remote center management and real-time monitoring of Telecom Switching Exchanger Systems.
•Constructed Enterprise Integrated Network to improve enterprise network performance.
•Generated project documentation, trained team members and operators.
System Administrator (UNIX, ORACLE and Win2000/NT)/Programmer 1993-1997
Computer Center of CHINA TELECOM, China
•Provided technical support and system administration.
•Installed, configured, tested and administered system hardware and software.
•Developed and implemented backup and recovery strategies.
•Designed programs using C, Pro*C, PL/SQL and Oracle Developer 2000.
PROFESSIONAL CERTIFICATES
•"SAS Viya Administration Enhanced Tasks" (2020)
•"SAS Viya Administration Essentials" (2020)
•"SAS Data Integration Studio" (2019)
•"SAS Grid Manager: Administration" (2017)
•"SAS Visual Analytics 7.3: Using SAS Visual Data Builder" (2016)
•"Oracle Performance Tuning", "Oracle DBA Fundamentals II", "Oracle 11g SQL and PL/SQL", "Oracle DBA Fundamentals I" (2011, 2012)
•"Maintaining a Microsoft SQL Server 2005 Database", "Implementing a Microsoft SQL Server 2005 Database", "Microsoft SQL Server Administration" (2006, 2007)
•"Oracle Database and Applications Design Technology" (1996)
•"UNIX Administrator", "DEC Alpha Servers", "HP 9000 series Servers", "Disk Array", "Digital Unix Tru-Cluster", "Memory Channel Technology" (1994, 1997)
•"CISCO Switch/Router", "Computer Network and Communication", "CA Unicenter TNG Network Management" (1995,1998, 2000)
EDUCATION
B.Sc. Electronics and Information Systems, Ocean University of China 1993
Contact this candidate