Objective

Seeking a challenging and growth-oriented position in the field of SAS System Administration/Engineering related job in East Coast and Mid Atlantic area.

Computer Skill

SAS Skill Profile: SAS Version 6.1.2 -V. 9.1.3-V9.2, SAS Base, SAS/SQL, SAS Programming, SAS Macro, SAS Data Warehouse / Administrator, Client/Server Strategies, Data Transferring by using SAS/Access, SAS / Connect and SAS /Share, SAS Intelligence Architecture, SAS Data Mining 5.1, SAS Meta Server, SAS Management Console, SAS Enterprise Guide Administration, SAS Integration Technology, SAS ETL, SAS OLAP Server and SAS Web Tools.
IT Service Vision: Performance Analyst and Administration on Basic Performance Data Warehouse
Web Servers:
Netscape, MS IIS 5, iPlanet, Apach, Tomcat, Weblogic
UNIX Systems Admin:
Solaris 2.5, 2.6, 7, 8, 9&10, in networking environment.
SAN & NAS: EMC, Disk & Volume Management: Veritas Volume Manager V2.6-V3.02, RAID0+1, RAID1+0 & RAID 5. Tivoli Storage Manager, Sun RAID Storage A5X00 & T3 System Administration. Experience with SUN Clusters 2.2 and 3.0.
SUN Hardware:
Maintenance, Troubleshooting and Repair SPARC & SUN Ultra Enterprise Server.
Enterprise Server: Experience with E10K Administration plus E220R, E450, E4500 & Sun Fire 3800, 4800, 4810, 6800 and posses SUN certification.

Other OS Environment:
Windows NT 4, 2000 & 2003 Server, HP-UX 10-11 on HP9000/700 workstation & HP9000/800 Server, BSD 3.3, AIX 5L and Linux Red Hat V. 5.1 & 7.2, and Fedora, SuSE Linux 6.2 & 7.3, Linux OS installation and Configuration, software installation and upgrade, Bash shell, building new Kernel and application environment, X-windows configuration, Networking Linux in a Heterogeneous environment.
RDBMS: Oracle Server 7, 8, & 8i installation on Solaris 7 & 8, Configuration & DBA support

Experience

July. 2009 – Now System renovation and upgrade specialist
Confidential,Lawrenceville NJ

• Project management, support and implementation by following CFR 11 DTS part 1, 2, and 3 and related SOP.
• SAS systems planning, architecture, project implementation, SAS systems installation and system integration and configurations by using SAS Management Console
• SAS data connection for SAS systems by setting up metadata. SAS security planning and implementation including SAS authentication and authorization setting up
• Computer upgrade in both hardware and software in large volume
• Software installation and configuration including SAS and lots of other different software.
• Software back up and encryption
• Technical support and trouble shooting

March. 2008 – July. 2009 SAS System Administrator Confidential,
Baltimore MD

• Provide production support for Constellation Energy Credit & Risk Team
• Supporting SAS, SAS/RD & SAS/EBI, OLAP, SPDS server
• Installing & Configuration and test for SAS Intelligence Platform product suite on UNIX platforms.
• Install, configure, test and maintain additional software components
• Monitor SAS system performance, including individual processes, overall disk, cpu and memory utilization and ability to assess growth and plan required upgrades
• Communicate issues and seek support and resolution from the software vendors
• Own and maintain SAS system, SAS Management Console, SAS Metadata Server, SAS OLAP and Stored Process Server and documentation.
• Migration and maintenance of code
• Maintaining metrics and resolving software issues.
  

Jan. 2007 – Feb. 2008 SAS System Administrator & Support Confidential,
Chicago IL
Manage the daily operation of the RDS servers (UNIX , Linux and Windows PC) including:

• System performance monitoring
• SAS ETL installation and customization to extract and transform data into data mart
• Writing complex queries by using SAS SQL
• System troubleshooting and problem solving
• Platform LSF job scheduling
• Create accounts and directories on UNIX and Set ACLs for users
• Install software updates and Maintain software licenses
• Configure software for optimal performance
• Advise RDS on system outages
• Develops specialized UNIX scripts to assist in the performance of regular work.
  

Oct. 2005 – Dec. 2006 Independent SAS consultant on several short term contracts

• Successfully accomplished several short term SAS project on
• SAS Enterprise Miner Server and Business intelligence Server set up and Configuration also including SAS Add-in for MS Office, SAS Information Map, Enterprise Guide and SAS Stored Process server setting up. for U.S. Bank St. Paul MN.
• SAS data warehousing engineering and SAS EG for J&J New Brunswick
• SAS Connect coding and SAS data manipulations
• SAS Intranet configuration and Weblogic Server configuration and support
• SAS Migration Project and SAS system migration planning, execution and validation from Windows NT to Windows 2000 with SAS upgrade from version 6.12 to SAS version 9.13.

April. 2002 – Sept. 2005 Confidential,
SAS System Architecture and Validation Lead Raritan NJ

• Responsible for Administration and Support of 27 SAS servers world wide of Johnson & Johnson Pharmaceutical R&D including installation, validation, technical upgrade, and system administration.
• Successfully implemented and lead on several SAS migration project from project resources planning, hardware selection, existing SAS system analysis, migration planning, migration execution, data and files transformation and final system validation. These include migration from UNIX to Windows 2000 server and Windows NT to Windows 2000 Advanced server.
• Configured SAS Web Report Studio enabling management and medical researchers and business users to find, interact with, create, and share reports based on corporate data. Built simple and complex reports that surface information from tables, OLAP cubes, and SAS Stored Processes.
• SAS Internet service package setup, configuration and support including Apach, Tomcat and Weblogic server support.
• Setting up and configured SAS BI tools such as SAS Intelligence Platform, SAS Add-in for MS Office, SAS Management Console, Java client, OLAP cube and ETL Studio.
• Responsible for SAS license administration and support for J&J’s hundreds of individual account with a total budget of $2 millions annually.
• Flawlessly conducted SAS system architecture and validation planning in Enterprise environment including SAS v.9.1.3 upgrading and migration, Lead SAS system validation team from project planning, budgeting, technology advancement to project management
• SAS Servers set up and System Integration, configuration and Technical Support including SAS v.9.1.3 Intelligence Platform setup and configuration, SAS v.9.1.3 workspace Server, Stored process server, SAS/Connect server, Metadata server and ETL server.
• Successfully implemented SAS System validation and documentation based on FDA 21 CFR Part 11 including SAS IQ, OQ and IQ Summary generation
• Accomplished SAS server migration, upgrade and system administration in both windows server and UNIX Server environment

.
April 2000 – March. 2002 Confidential,MD
SAS System Analyst

• SAS Client/Server Engineering on Sun UNIX and Systems Analysis
• SAS and UNIX system administration including user and group management, system back Up planning and trouble shooting
• SAS data processing and SAS programming
• Systems Planning and Analyses for SAS system
• Statistic Report based on requirements
• T-SQL programming on Sybase and DB2 and VBA programming on MS Access
• SAS Data set & table generation and data sets manipulation
• Oracle application development and administration to generate databases, tables

Feb. 1998- March 2000 Confidential,Alexandria, VA
UNIX Administrator and Systems Engineer

• Responsible for setting up Sun Enterprise Servers from hardware to Solaris OS configuration
• UNIX server configuration, Oracle 8i installation and configuration
• X.500 Directory Server Engineering and Administration
• Directory Server / iPlanet setup and Configuration
• LDAP Development and configuration
• Administration on Sun Enterprise mid-rang Servers
• Engineering Planning and Project Management
• Solaris Networking / Integration with Microsoft Windows
• Shell and Perl scripting as needed
• Security Design and Planning, Checkpoint Firewall, SUDO installation & configuration.

March 1995 – Dec.1997 Confidential,Saginaw, MI
Systems Engineer

• SAS Programming and SQL ad-hoc retrieval for management & decision support using MVS390. Responsible for analysis, design and specification of programs.
• Jr. System engineer on user and group account support
• Database application development by using Oracle 7.x, MS Access and Excel.

Oct. 1991 – Feb. 1994 Confidential,Baltimore, MD
Sales Engineer & Technical Support

• BSD and SUN OS systems engineering and Implemented training course for new recruits
• MS Access/VBA database setup for ad-hoc extract and loads for end user and decision support

Sept. 1984 – July. 1986 Confidential,Beijing, PRC
Marketing Support and PC Sales Representative
- Systems Sales engineer, Customer training / presentation

Education & Training

SAS Version 9.xx Skill & Knowledge Upgrade

• SAS-Using ETL Studio to Integrate Your Data
• SAS-Creating, Distributing, and Using SAS Stored Process
• Introduction to the SAS Business Intelligence
• Querying and Reporting Using SAS Enterprise Guide
• Creating and Exploiting OLAP Using the SAS System
• SAS v.9.x New feature and SAS v.9.x system engineering and configuration

Extensive Official SAP R/3 4.6c-4.7 Refresh Basis Track

• BC350 SAP Workplace and BC615 SAP ArchiveLink
• BC305 Advanced R/3 Administration and BC610 Workflow Development
• BC325 SAP Software Logistics & BC315 SAP Workload Analysis
• BC360 UNIX Oracle and UNIX SAP DB
• BC505 Database Administration Oracle
• CA080 mySAP PLM Project Management
• BC620 NetWeaver mySAP Techno SAP IDoc Interface Technology

Other Related Training

• Solaris 9 Upgrade Training and Solaris 9 Network Administration
• Administration of BEA Weblogic Server 7.0
• Project Management
• Computer & Computerized System Validation for the Pharmaceutical Industry
• Computer Validation and IQ/OQ and PRI CSV SOP
• Sun Enterprise System Performance Management
• Sun Systems Fault Analysis Workshop
• Sun Enterprise E10K Server Administration and Sun Fire E-Servers Administration
• Veritas Volume Manager (VM) and Disk management with DiskSuite
• Legato Networker/ SUN Storage Management w/ Backup
• Sun Hardware RAID Storage & T3 System Administration
• Sun Ultra Workstation and Enterprise Server Hardware Maintenance
• Perl Programming and J2EE and JAVA Programming
• Administering Security for Solaris[tm] 2.x Operating Environment
• Transact SQL Programming Intermediate Level
• Advanced Transact SQL Programming
• Solaris System Administration I & II
• Solaris TCP/IP Network Administration
• Shell Programming in Bourne, Korn and C shell
• SAP R/3 3.0 System Administration
• HP-UX 10/11 System Administration
• AIX 4.3 System Administration
• Oracle 8 / SQL / Oracle PL/SQL, DBA, Developer2000
• Data Warehousing / E – commerce
• SAS Programming (Intermediate) and SQL Processing with SAS System
• Advanced SAS Programming Techniques and Efficiencies
• Processing Database and Spreadsheet Data with SAS/Access
• SAS Macro Language and Client/Server Strategies Using the SAS System
• Building a Data Warehouse Using SAS/Warehouse Administrator
• UNIX Operating Systems V Re. 4 and UNIX C / C++ Training Course
• SAS Base / Data Processing & Information Sys Curriculum
• MBA, Dual major in MIS and Finance
• Quantitative and Statistical analysis Curriculum, MVS370 / JCL and TSO
• Internship: Database design and modeling for Westinghouse ATC system
• Bachelor of Science and Technology
• Major in Industry Automation and Control