SUMMARY:

• Experienced SAS Administrator and SAS Grid Administrator. Extensive experience of LSF Platform, SAS GRID, Platform RTM for SAS SAS EBI, SAS Metadata server, SAS Scalable Performance Data Server (SPDS), SAS OLAP, SAS/Security, SAS Environment Manager, etc.
• Experience with the installation/configuration/administration/performance - tuning/security-setting of Platform Suite (LSF/PM/GMS) and SAS server, on environments such as AIX with GPFS shared file system, RedHat Enterprise Linux (RHEL) with Clustered File System (CFS), both locally and in Amazon AWS Cloud. I have been working as the LSF and SAS server administrator for a group of 300+ SAS developers in a complex AIX or RHEL enterprise environment.
• Over 17 years of strong hands-on experience in analysis, design, implementation, and support of Data Warehousing and Business Intelligence using SAS and databases.
• Familiar with Base SAS, SAS EBI, SAS SPD Server (SPDS), SAS GRID architecture, SAS OLAP, Metadata Server, SAS/EG, SAS Environment Manager, SAS Enterprise Miner, SAS Macros, SAS ODS, SAS/Graph, SAS SCL language, SAS/Access, SAS Information Map Studio, SAS Web Report Studio, SAS/IntrNet, SAS/Connect, SAS/Share and SAS AppDev Studio, etc.
• Experience with Oracle and MSSQL databases and their integration with SAS, including SQL-passthru and working with partitions, experience with large volumes of data in complex corporate systems with SAS, knowledge of how to optimize SAS programs to work efficiently as measured in time and resources required for ETL and for presentation of the data. Experience of utilizing APIs like XML, SOAP, JSON to access 3rd party data sources.
• Knowledge of the efficiencies made available by utilizing middleware such as SAS SPD Server (SPDS) and OLAP server.
• Strong Unix, Linux and shell script skills. I single-handedly developed a commercial quality SAS job scheduling and alarm system “Production Control” (PrdCtl), using k-shell, Perl and Oracle. This system beat Control-M and IBM Tivoli, and has been the standard job scheduler for all SAS applications on Unix/Linux environment across Confidential (now Confidential ).
• Extensive experience with Agile development method, familiar with cloud based Agile tools like JIRA / Confluence, etc. Extensive experience in full project life cycle (SDLC), including analysis, design, development, job scheduling, version control, and release/deployment management, with various tools like Control-M, PAC2000, BMC, GIT, PVCS Dimensions, and CVS. Experience with production support in a 24x7 environment.
• Strong problem solving skills, including direct experience with production systems, and being “on-call”.
• Self-starter and team player, excellent communication skills. Worked in large project teams with both onshore and offshore architects, analysts, developers, testers and AIPs.

TECHNICAL SKILLS:

Platform: AIX, RedHat Enterprise Linux, Platform Suite (LSF/PM/GMS)

SAS: Base SAS, SAS EBI, SAS Metadata Server, SAS/EG, SAS Enterprise Miner, SAS Macros, SAS ODS, SAS/Graph, SAS SCL language, SAS/Access to RDMBS (Oracle, MSSQL Server, ODBC, MySQL, PostgreSQL, etc), SAS Web Report Studio, SAS Information Map Studio, SAS/IntrNet, SAS/Connect, SAS/Share, SAS AppDev Studio, SAS SPD Server (SPDS), SAS OLAP server, Platform Suite for SAS (SAS GRID architecture), LSF, RTM, SAS/Security, SAS Environment Manager, etc. Installation / configuration / administration of SAS BI Server, Metadata server and SPD server.

Databases: Oracle, MS SQL Server 2008 R2, MySQL5, MS Access 2000

ETL: Informatica Power Center 8.6.1/8.5.1/8.1.1/7.1.2, Informatica Data Analyzer

BI: SAS, Tableau

Languages: SQL, Java, HTML, JavaScript, C, C++, shell scripts, R

OS: Linux (Redhat), AIX, UNIX(Solaris), Windows, AWS Cloud EC2 instances

Tools: Tableau, SQL Developer, TOAD, JIRA Agile, Control-M, PVCS Dimensions, Git, Google Docs, CVS, Sentry, MS Visio, Excel, PowerPoint, Word, SharePoint, MobaXterm, BMC, PAC2000.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

SAS GRID Administrator

SAS Environment: AIX 7.1, GPFS shared file system, Platform Suite (LSF/PM/GMS), SAS Grid Control Server, four SAS Compute Nodes (each with 102G RAM and 14 quad-cores), SAS Metadata Server (32G RAM and 4 quad-cores), SAS Middle-Tier Server (32G RAM and 2 quad-cores), SAS Environment Manager, SAS Enterprise Miner, SAS SPD Server, SAS Visual Analytics, etc.

Databases: Oracle

Other Tools: JIRA, BMC, PAC2000, SharePoint, Visio, Microsoft OneNote

Confidential, Monterey Park, CA

SAS GRID Administrator

SAS Environment: RedHat Enterprise Linux (RHEL) 6.7, Clustered File System (Veritas CFS), Platform Suite (LSF/PM/GMS), SAS Grid Control Server, three SAS Compute Nodes (each with 192G RAM and 12 cores), two SAS Metadata Servers (each with 32G RAM and 4 cores), two SAS Middle-Tier Servers (each with 32G RAM and 2 cores), SAS Environment Manager, RTM, SAS Login Server, SAS/Security, etc.

Databases: Oracle, Microsoft SQL Server, DB2, DataDirect ODBC.

Other Tools: BMC, PAC2000, Microsoft Sharepoint, MobaXterm

Confidential, Los Angeles, CA

Lead SAS Administrator

SAS Environment: Two physical Linux servers (8 CPUs 192GB RAM per server, SAN RAID10 Disk Array), RedHat Enterprise Linux (RHEL) 6.6, SAS 9.4 on AWS cloud EC2 Linux server: AWS cloud EC2 server r3.4xlarge (16 vCPU, 122G RAM, SSD with RAID), RedHat Enterprise Linux (RHEL) 6.5. SAS/EG hosted on an AWS Cloud r3.xlarge as a RemoteApp application (on Windows Server 2008 R2).

Databases: Oracle 11G on AWS Cloud, PostgreSQL on AWS Cloud, MSSQL on AWS Cloud

Other Tools: Tableau, Agile JIRA, GIT.

Confidential, Denver, CO

Sr. SAS DW/BI/ETL Developer

Responsibilities:

• Single-handedly developed a commercial quality SAS job scheduling and alarm system “Production Control” (PrdCtl), using k-shell, Perl and Oracle. This system beat Control-M and IBM Tivoli, and has been the standard job scheduler for all SAS applications in Unix/Linux environment across Confidential .
• Involved in full project life cycle - analysis, design, development, unit test, and production support.
• Explored and analyzed SAS datasets, SPDS tables, SAS cubes using interactive SAS or SAS/EG.
• Designed and developed reusable codes in a multi-developer environment, using SAS macro programming, including autocall library and macro functions.
• Created complex customized SAS Formats.
• Extracted data from flat files, MS-SQL server, Oracle, DB2, and loaded the data into SAS dataset or SAS SPDS tables using data steps, SQL, SAS SQL-passthru to Oracle with or without partitions.
• Worked with analysts to understand and build complex business logic, cleaned up and standardized data to create meta tables, fact tables, dimension tables and detailed data marts, applied business rules during the process to derive valuable business information, using SAS data steps, SAS functions and CALL routines, SQL and various SAS procedures.
• Created N-Way aggregated SAS SPDS tables with all possible dimension values together with their associated detailed facts, created SAS OLAP cubes for slicing and dicing the summarized data at various levels, to display business measures across many dimensions.
• Created SAS programs to upload SAS fact tables, dimension tables and detailed data marts to Oracle, so that the data can also be accessed by Oracle power users.
• Optimized SAS programs to work efficiently as measured in time and resources (CPU, I/O, memory, disk space and network) required for program execution and for presentation of the data.
• Wrote SAS code that can be fully automated, scheduled and trigger notifications when unexpected conditions occur.
• Automated SAS programs execution by defining job dependencies, scheduling and alarming, involved in production deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

SAS Environment: SAS 6x/7x/8x/9x, SAS GRID Infrastructure, SAS Scalable Performance Data Server (SPDS), SAS/EG, Oracle 8i/9i/10g, DB2, UNIX, Sun OS, PrdCtl, CVS, PVCS Dimensions.