SUMMARY

Lead SAS System Engineer with Confidential Technologies, I architecture various clients GRID Environment infrastructure to enable its IT Business Analytics department to be tailored towards end - user centered while saving about 500 thousand dollars in SAS licensing for clients including Confidential, Confidential, Confidential Pharmaceuticals and Confidential . I helped changed the direction of Client SAS from SAS EG per user licensing to web based SAS Studio free licensing products and Terminal Server farm concept to enable secured and high-performance architecture. I also incorporated Hadoop into Client big data architecture to help drive SAS to RDBMs performance. I have installed and configured SAS Grid in 20 node cluster for production, 12 node Test and Dev platforms on Linux redhat 7 with Isilon clustered file systems.

TECHNICAL SKILLS

• Red Hat Linux Administration
• SAS ADVANCED PROGRAMMER CERTIFICATION (Training for SAS 9)
• SAS PLATFORM ADMINISTRATION (Training for SAS 9 on UNIX, windows)
• GIT
• JENKINS

PROFESSIONAL EXPERIENCE:

Confidential

SAS GRID ENGINEER

Responsibilities:

• Expert Level knowledge & Experience in SAS Grid Administration in 9.3 & 9.4 Versions including Installation & Configuration.
• Installation & Configuration of respective SAS Clients/Tools on user's Desktops.
• Responsible for all SMC Administration related tasks (user creation, group creation, library creation, managing security and permissions etc).
• I have architected, designed and implemented and installed SAS 9.4M3 GRID Intelligence Platform on Redhat 7.2
• I perform this installation using GPSF2 and Isilon file systems
• I architecture Active Directory server and mapped User permissions on folders to the SAS Files to maintain permissions after migration of data and users from windows single server to Grid
• Installed a clustered metadata server, web server and webapp servers for SAS Grid
• Expert experience with installation and configuration of Platform LSF, RTM and EGO used by SAS Grid, using scripts such as egosh.sh, lsadmin reconfig, badmin reconfig, bkill, bjobs, bhist etc.
• Familiar with IWA, PAM/AD/LDAP/Centrify/Kerberos authentication
• Expert understanding of SAS EBI authentication and authorization and security model, excellent experience implementing SAS Metadata security and access controls.
• Expertise of setup various DBMS clients for SAS Server on Unix, including Oracle, DB2, Teradata, Hadoop, Greenplum, MS SQL Server, ODBC, etc.
• Familiar connecting SAS with Kerberos secured Hadoop by ID kerberized and Hadoop proc sql connections.
• Advanced configuration experience with Apache Web Server, Tomcat, JBoss, BEA WebLogic Server, WebSphere and SAS Intelligence platform mid-tier Web applications
• System monitoring including monitoring LSF processes such as lim, mbatched, res, sbatched, etc.
• Submitting jobs using SASGSUB and its various options to output logs and files
• Created and modify LSF Queues based on user needs and department needs
• Configured High availability for SAS using Load balancing techniques
• Migrated over 100TB data from both Unix and Windows single server platforms to SAS Grid using proc migrated and other shells scripting techniques.
• Used GITHUB for SAS migration to maintain companywide legacy codes

Confidential

Lead SAS Engineer (CIGNA Denver CO)

Responsibilities:

• Deployed end user SAS applications and make sure all the client/server connectivity is intact without any performance issues.
• Managed SAS Connect server, Metadata Server, Object Spawner, OLAP server, Stored Process Server on the Linux environment
• Supported Users Migration from Hyperion SAS EG also making sure they have appropriate access and Users Credentials have been defined properly.
• Create Powerbroker Groups and Service ids to help users run jobs on Cigna specific batch tool
• Experience with SAS 9.4, 9.3 also Installed and Configured client components like SAS Enterprise Guide 7.12, PC SAS 9.4, 9.3 & 9.1, SAS Enterprise Miner 14.1and SAS OLAP Cube 4.3, SAS Information Map Studio 4.31 and Troubleshoot Technical Problems.
• Installed and configured SAS Access to Oracle, DB2, Teradata, atabase and Hadoop
• Configure Odbc.ini files to Connect to Hadoop And SQL,
• Interact with various teams to ensure a stable production environment, including but not limited to client facing support, application developers, business analysts, and infrastructure.
• Escalated the issues and worked closely with SAS Support in resolving issues related to users and environment.

Confidential

SAS GRID Platform Engineer

Responsibilities:

• Team lead on ongoing SAS platform migration from Solaris Unix platform to 20 node SAS production, 6 node UAT and 6 node development Redhat Linux Grid platform
• Created Database cataloging for all RDBMS including DB2, Sybase, SQL Server, Teradata and oracle
• Created bi-directional SSH Keys from server to server to enable users to seemingly transfer data between various platforms
• Created batch jobs with shell scripts to submit SAS autosys jobs
• Used SASGSUB command with Grid options to submit jobs to the SAS grid
• Created SFTP macros for SAS file transfer between Unix and LAN’s
• Set up Grid Option sets for various departments to run their jobs in queues that were assigned to them
• Used SAS Platform RTM and Environment manager to manage SAS Grid environment
• Worked on shared files system such as GPFS file systems
• Configured metadata server for high availability using SAS Grid Manager 9.4
• Configured LSF environments to observe queue priority and queue preemption
• Designed migration documentation project plan to meet required customer standards
• Configured CPU Utilization threshold on servers and apply loads to the grid
• Designed project implementation timeline and project delivery timeline templates
• Configured two other nodes in the Grid set up as Master candidates
• Coordinate with all end-users on specific applications needed to perform migration and specific application changes needed to be able to run the applications on the new platform
• Assisted SAS Institute to Load Balance workspace servers,
• Performed pre-migration testing on various applications components found in user environment
• Performed all code changes and migrated applications onto the new environment
• Performed post migration testing of all application and Grid enabled the applications to run on the platform Grid server
• Performing system administration and at the current ongoing project delivery timeline

Confidential

SAS Engineer

Responsibilities:

• I managed the entire SAS infrastructure platform for Federal Energy Regulatory Commission
• I design a three-tier server architecture of the Enterprise Analytical system
• I installed and configured the SAS Infrastructure platform for critical analytical applications to become functional.
• I led the design, installation and configuration project as a one-man team from start to finish completing critical project plans and meeting deadlines for the project delivery
• I was responsible for the day to day running of the SAS infrastructure platform and administering the platform performing duties such as Creating and adding users, groups, roles on the SAS Metadata server using management console. Identified configuration directory folders owners and security set up such as SASMeta, SASApp, creating Profiles for SAS Enterprise Guide and SAS Enterprise Miner Users, provide/grant access to the users
• Applied patches and hot fixes using SAS Deployment registry report on windows server
• Configured SAS PC file server to enable connectivity to Microsoft products
• Migrated the entire business analytics datasets from an old SAS environment to new SAS environment.
• I created a back-up strategy for disaster recovery purposes and tested data streaming capabilities and recovery points of the backup system
• Perform system performance monitoring using various software’s such Microsoft xperf to determine performance metrics such as disk utilization, system throughput, CPU utilization and memory utilization
• Helped train end-users on best practices and how to get the best utilization out of the configured applications
• Performed a detailed health check of SAS infrastructure with CPU, I/O, Throughput and Disk Latency testing with various system heavy SAS queries.

Confidential, Philadelphia

Sr. SAS Platform Engineer

Responsibilities:

• Query optimization using system admin tools to monitor CPU utilization, MEMORY utilization, DISK I/O, throughput, system Latency and network performance for SAS servers and services by individual PID’s
• Configured SAS environment manager to measure key system metrics and parameters
• Administers and monitors the overall health of the SAS platform and data warehouse.
• Performs performance tuning, capacity and utilization monitoring, backup strategy and disaster recovery planning.
• Applied patches and hot fixes as required using deployment registry tool in SAS to identify system specific hot fixes.
• Created and validated SAS Access to Hadoop
• Wrote simple proc Hadoop queries to test connectivity to Hadoop
• Securing metadata, including the following: metadata security, metadata permissions,
• securing content in the folder tree, secure access to SAS data, secure access to OLAP
• Data, secure reports, create and apply ACTs, and use SAS token authentication.
• Setting up data access, including registering libraries and tables in the metadata,
• Updating table metadata, setting up data access, troubleshooting data access.

Confidential . NEW YORK

Senior Associate (SAS Analyst)

Responsibilities:

• Produced SAS Ad-hoc reports from outcomes, utilization and claims data
• Maintained and ran weekly, monthly and Quarterly reports using SAS.
• Automated the entire monthly and Quarterly data update processes employing SAS Macros and involving reading large volumes of external files of different formats, data cleansing and manipulations.
• Modified legacy SAS codes to enhance appearance of Reports, ODS proc template and SAS Graph
• Produced excel, access and SAS batch files for scheduled execution.
• Developed a Data Dictionary tool that takes search terms and suggests table and variable names, used for quick ad-hoc reporting.
• Documented Production SAS Codes to meet ‘Best Practices’ requirements.
• Modified Legacy SAS Macros and New Macros
• Rewrote department SAS programs, improving their efficiency for time, memory usage and maintenance.
• Produced SAS Ad-hoc reports from outcomes, utilization and claims data and generating presentation graphs for clients
• Modified legacy SAS codes to enhance appearance of Reports, ODS proc template and SAS Grap