SUMMARY:

• 22 Years of advanced SAS programming, development and IT technical expertise.
• 11 years of SAS Platform Architecture, Administration, Implementing, Upgrading and Migration experience sine 2004
• In past 12 years, ran my own SAS consulting business and specialize in architect, design and implement SAS 9 Intelligence Platform various package bundles, including but not limited to, SAS BI Server, Enterprise BI Server(EBI), EDI Server, SAS BI Architecture, SAS Enterprise Miner, SAS Forecast Server, SAS Grid Manager, SAS Model Manager, SAS SPDS, SAS Visual Analytics, SAS Model Risk Management, etc. Had delivered some tough projects which SAS Consulting failed to deliver
• Expert experience with installation, advanced configuration and administration of SAS 9 Intelligence Platform and various SAS BI tools on Windows and Unix
• SAS BI Tools expert since 2004
• Expert experience with Platform LSF, RTM and EGO used by SAS Grid
• Familiar with IWA, PAM/AD/LDAP/Centrify/Kerberos autantication and SiteMinder Single Sign On(SSO)
• Expert experience setup and segregate SAS Intelligence Platform Dev, QA, Prod environments, including promotion of metadata repository, partial promotion of BI objects and associated contents and design BI content SAS folder structure to meet client requirements and implement security and change control process
• Expert understanding of SAS EBI autantication and authorization and security model, excellent experience implementing SAS Metadata security and access controls.
• Experience upgrade, migrate SAS environment from v8 to v9 and from SAS 9.1.3 to SAS 9.2, SAS 9.3, SAS 9.4
• Expertise of setup various DBMS clients for SAS Server on Unix, including Oracle, DB2, Teradata, Netezza, R/3, Hadoop, GreenPlum, MS SQL Server, Informix, ODBC, etc.
• Familiar connecting SAS with Kerberos secured Hadoop
• Provide complete SAS OLAP(HOLAP) Cube solutions(both version 8 and version 9) for business intelligence
• Years of consulting services experience in the industry
• Familiar with Cognos BI tools(with Cognos )
• Strong experience with Data Warehouse, ETL and OLAP tools
• Solid Java development and J2EE skills
• Advanced configuration experience with Apache Web Server, Tomcat, JBoss, BEA WebLogic Server, WebSphere and SAS Intelligence platform mid - tier Web applications
• Advanced experience with SAS System configuration and performance tuning on Enterprise-Class Unix Server with a large number of users shared environment
• Extraordinary technical leadership with excellent analytical and problem-solving skills

PROFESSIONAL EXPERIENCE:

SAS Administrator/Technical Manager

Confidential

Responsibilities:

• Installation, configuration and administration of SAS 9.1.3 EBI Platform
• Install and configure various SAS package bundles
• Train SAS consultants to use SAS 9 BI tools
• Migration of SAS environment from V8.2 to V9.1.3 on Unix, including setup of various DBMS clients
• Migration of large number of SAS User Community from Dev/QA to Prod on Unix
• Install SAS Service Pack, hotfix and upgrades.
• Create and maintain user and group metadata identity using bulk load macro tools
• Implement access control security in SAS Metadata Server.
• Promotion of SAS metadata repository and BI objects
• Implement SAS BI Dashboard Framework
• Upgrade EMiner 5.1 TO 5.2
• Fix problems for clients left over by SAS Consulting Services consultants
• Advanced configuration and administration of various SAS bundles and various BI tools(SAS Web Report Studio/Viewer 3.1,OLAP Viewer for Java, SAS Forecast Server, SAS Analytics Platform, Xythoys WebFile Server, Enterprise Miner 5.2,etc)

SAS Administrator

Confidential, Richmond, VA

Responsibilities:

• Setup, configure and administer SAS Servers and Services on Solaris(Share Server, Open OLAP Server, Load Manager, Apache Web Server, IntrNet Application Server, MDDB Report Viewer, IOM Server for Enterprise Guide, etc)
• Implement Change Management between SAS Development, Testing and Production environments on Unix using Harvest software
• Support SAS/Risk Dimensions, Mark-to-Market and VaR nightly production jobs
• Administer Java portal web application on BEA WebLogic Server on Unix
• Install, configure and administer SAS 9.1.3 Intelligence Platform all the components(Server-tier, Mid-tier and Client-tier) and tools on Solaris
• Deploy Mid-tier SAS BI applications(SAS ID Portal, Web Report Studio, Web Report Viewer, Web OLAP Viewer for Java, SAS Stored Process Web application, etc) to Web Server(Apache, Tomcat and WebLogic) on Unix
• Migrate SAS environment from V8.2 to V9.1.3 on Unix(including upgrade SAS Risk Dimension from 3.2 to 4.2)
• Manage metadata identities, establish connectivity to data sources, monitor storage usage and implement security access controls for various resources in metadata repository, etc
• Administer SAS Metadata Server, OLAP Server, Stored Process Server, Workspace Server, SAS ETL jobs, batch reports, Platform Job Scheduler and Xythos WebFile Server on Unix
• Configuration and performance-tuning for SAS Servers and SAS applications
• Create SAS OLAP Cubes, Information Maps and Stored Processes for users
• Manage SAS Intelligence Platform Development, Testing and Production environments on Unix
• Technical liaison between vendor, SAS users and Risk Management Group

SAS Consultant

Confidential, Charlotte, NC

Responsibilities:

• Drug Enforcement Agency(DEA) Prescriber, Pharmacy, Patient HOLAP Cubes Project
• Design and implement Pharmacy lookup tool, transaction query tool, SAS HOLAP model for DEA(Environment: Unix/SAS, SAS/MDDB, Java, JavaScript JSP/Servlet, Web Application Development, webAF, SAS custom tag, Tomcat)

SAS Consultant

Confidential, Redmond, WA

Responsibilities:

• Productionize SAS score modeling process on Unix
• Develop web-based online analysis and dynamic reporting system without using SAS/IntrNet software
• Using HOLAP approach to design and implement Life Time Value(LTV) Dynamic Web Reporting System(SAS/IntrNet application)

Java Developer

Confidential

Responsibilities:

• Develop subscriber and sponsor management use case for J2EE application using JBuilder6.0,Weblogic6.0 and Oracle8i
• Develop components using Java/JSP/Servlet/XML, such as: Event, Item, EventHandler, Transition, EJB, DAO, Servlet and JSP components
• Setup and configure develop and test environment

SAS Programmer/Analyst

Confidential

Responsibilities:

• Maintained and executed over one hundred SAS programs on mainframe and PC to implement monthly, quarterly data archival and reporting processes and ensure database integrity
• Wrote SAS programs to check integrity and consistency of databases
• Developed SAS AF applications on PC with SAS Screen Control Language
• Developed Macros to produce Ad-hoc queries and reports with SAS Macro Language
• Provided system and technical support for the department