We provide IT Staff Augmentation Services!

Sas Consultant / Sas Grid Administrator Resume

Cleveland, OH

SUMMARY:

  • Over 16 years of experience in IT industry involving complete Software Development Life Cycle & Database Management i.e. analysis, design, coding, implementation, and testing.
  • Communication and Requirement Gathering is an imperative part of the job, as it involved getting directly in touch with the Business Partners and the Marketing Head.
  • Domain Expertise in Financial, Insurance, Telecom, Healthcare, HR Benefit, Public Health/behavioral health and lending products.
  • Expert in SAS 9.1, 9.2, 9.3 and 9.4 - Installation, Configuration, Migration and Platform Administration.
  • Expertise in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ODS, PROC/SQL, SAS/STAT and SAS Language.
  • Extensive implementation in procedures and performed data analysis and generated interactive, dynamic reports using various SAS procedures such as PROC PRINT, CONTENT, SORT, COMPARE, FREQ, MEANS, SUMMARY, REPORT,TABULATE, and TRANSPOSE.
  • Experience working on SAS with different operating systems i.e. UNIX, RHEL, Windows and Mainframe.
  • Experience with core software applications, including SQL/DB2 and Data Models, database design and file management techniques.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS SAS/CONNECT, SAS/STAT, SAS/AF, SAS/SCL, SPSS

SAS Procedures: PRINT, REPORT, TABULATE, FORMAT, FREQ, MEANS, SQL and SUMMARY

Operating Systems: MS-DOS, SCO-UNIX, NT SERVER 4.0 and WINDOWS 2000

Mainframe: IBM Mainframe OS/390, TSO/ISPF, JCL

Languages: C++, Java

IDEs: Visual C++ 4.0, Visual Basic 4.0, 5.0, 6.0 and Visual Interdev 6.

Databases: Sybase, MS SQL Server 6.5, 7.0, 2000,2005,2008 MYSQL, DB2, Oracle9i

Internet: HTML, ASP, XML, VBScript and IIS

Middleware: COM, DCOM, and MTS

Back office: Ms. Exchange2000 and SMS Server

Dot Net: VB.Net, Asp.Net

Mobile Computing: Win CE HPE 3.0, Embedded Visual Basic 3.0

Reports: Crystal Reports, Vs View (Active X Control)

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

SAS Consultant / SAS Grid Administrator

Responsibilities:

  • Managed authorization permissions for users, groups and created ACT’s
  • Extracted users from Microsoft Windows Active Directory and synchronized in SAS Metadata.
  • Installed and configured SAS Environment Manager-Report Center for administration, monitoring and auditing for report purpose
  • Successfully established SAS to R connectivity by updating SASv9.cfg file and tested R code in SAS Enterprise Guide
  • Established SAS to SQL Server connectivity.
  • Starting stopping SAS and LSF services

Environment: O/S - RHEL 7.3, Platform LSF 9.1.3, SQL Server, SAS Version 9.04.01M4 SAS Metadata Server - SAS Metadata Server 9.4, Mid-Tier Server - SAS Web Server, SAS Client Installs - SAS Enterprise Guide 7.13, SAS/IML, SAS Forecast Studio 14.2, SAS Time Series Studio 14.2

Confidential, Washington, DC

SAS Consultant / SAS Grid Administrator

Responsibilities:

  • Reviewed existing SAS Grid configuration and established best practices standards to handle day to day activity in SAS Grid environment.
  • Reviewed and updated SAS code to accommodate grid processing using autosignon and rsubmit option.
  • Enabled SAS Enterprise Guide logging, Workspace server logging and sastrace option for troubleshooting purpose.

Environment: O/S - RHEL 6.2, Platform LSF 9, SAS Metadata Server - SAS Metadata Server 9.4, Mid-Tier Server - SAS Web Server, SAS Client Installs - SAS Enterprise Guide 7.11

Confidential, Reston, VA

SAS Consultant / SAS Grid Administrator

Responsibilities:

  • Successfully migrated/converted SAS datasets, SAS Format Catalog, SAS Programs, SAS Macro, OLAP Cube, Stored Processes, Information Map, Web Reports and SPDS dataset from SAS 9.2 Grid to SAS 9.4 Grid.
  • Successfully migrated user’s application that required interaction with various database i.e. Oracle, DB2, Sybase and SQL Server.
  • Successfully migrated SAS application, Unix Shell Scripts and Autosys jobs from Solaris to Linux
  • Resolved post migration issues and working with SAS user community to fine tune and improvising SAS processes.

Environment: O/S - RHEL 6.2, Platform LSF 9, SQL Server, DB2, Oracle SAS Metadata Server - SAS Metadata Server 9.4, SAS Management Console 9.4, Mid-Tier Server - SAS Web Server, SAS Client Installs - SAS Enterprise Guide 7.11, SAS Data Integration Studio, SAS Visual Analytics 7.2/7.3, SAS Add-in for MS office, OLAP Cube.

Confidential, Charlotte, NC

SAS Consultant / SAS Grid Administrator

Environment: O/S - GNU Linux, Platform LSF 8.0.1, SQL Server, DB2,Teradata, Oracle SAS Metadata Server - SAS Metadata Server 9.4, SAS Management Console 9.4, Mid-Tier Server - SAS Web Server, SAS Client Installs - SAS Enterprise Guide 7.11, SAS Data Integration Studio, SAS Visual Analytics 7.2/7.3, SAS Add-in for MS office, BMC Remedy

Responsibilities:

  • Migrated 3500 users from Bacardi GRID to SASCOE GRID, Developed SAS Program/utility to read /etc/passwd & /etc/group file to compare and validate user identity in SAS Bacardi & SASCOE platform.
  • Liaison between the SAS user community/Managers and the SAS Platform to resolve issue occurred during pre-migration and post migration phase.
  • Optimization/fine tuning of SAS/SQL DB2 query, Subject matter expert on resolving DB2 connectivity issue
  • Maintaining cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise.

Confidential, Louisville KY

SAS Consultant / SAS Grid Administrator

Environment: O/S - IBM AIX 6.1, Unix, SAS Grid, LSF 7.0, GPFS File System, RTM 2.0.8, SQL Server 2008, Oracle 11g, Netezza SAS Metadata Server - SAS Metadata Server 9.3, SAS Management Console 9.3, Mid-Tier Server - JBoss-4.2.3.GA Remote Services, SAS Compute Server - SAS Enterprise Miner Server 6.2, SAS Client Installs - SAS Enterprise Miner Clients 6.2, SAS Enterprise Guide 5.1, SAS Data Integration Studio 4.2

Responsibilities:

  • Managing SAS Grid environment 14 nodes cluster equipped with high availability, failover, switchover/migrate and fault tolerance.
  • Managing day to day operation starting from the onboard process of a new user, Creating user space/quota on GPFS file system, creating personal library in SAS management console, creating data library for SPDS, Oracle and SQL Server.
  • Starting Stopping SAS GRID/ LSF nodes for maintenance purpose.
  • Managing and submitting jobs through SASGSUB SAS Grid Manager Client Utility and changing the job priority queue for users from lower to medium or high. Monitoring SAS jobs submitted on grid either using LSF commands or through RTM 2.0.8
  • Monitoring and assigning user space quota/folder on GPFS General Parallel File system using GPFS commands i.e. mmcrfileset, mmlinkfileset, mmdelfileset and mmedquota.
  • Scheduling jobs through crontab on AIX Unix
  • Troubleshooting Netezza, Oracle, SQL Server connection issue using SAS and creating DSN entry for the database.
  • SAS 9.4 Installation fulfilling Pre Requisite Requirements, Download SAS Software Depot, Installed and configured SAS 9.4 software including SAS Metadata, Compute server and SAS Web Server.
  • SAS 9.2 to SAS 9.4 Migration Migrated more than 900 plus users/groups/roles, from SAS 9.2 to SAS 9.4, using user imports macro %mduextr %mducmp %mduchgv %mdsecds. Successfully migrated Enterprise miner 6.2 projects/models to version 13.2
  • Installed and configured SAS APM 9.4 Audit, Performance and Measurement for resource monitoring and metadata reporting purpose.
  • Installed and configured SAS Environment Manager and SAS Environment manager agent, SAS Studio 3.2, and Enterprise Miner 13.2
  • Troubleshooting SAS-related performance issues by working with customer’s systems administrators, network administrators, web application server administrators, database administrators and/or storage administrators.
  • Monitoring for availability and then installing SAS updates patches maintenance releases and hot fixes.
  • Controlling user access to various parts of the SAS system, using ACT, granting permissions to read, write, create or view reports and data within the system

Confidential, Atlanta, GA

SAS Business Intelligence Lead

Responsibilities:

  • Lead in-house and consultant staff in the development of ETL programming into a production based system.
  • Designed, developed and maintained STARS/HEDIS and coding applications.
  • Trained and mentor programming staff in BI methodologies.
  • Evaluated and help implement database cleanup, design and migration to new or improved configurations and or platforms. Documented SAS Enterprise Business Intelligence initiatives.
  • Produce analysis datasets, reports and or graphics for surfacing in applications.

Environment: O/S - Linux, SAS Metadata Server - SAS Metadata Server 9.3, SAS Management Console 9.3, SAS Compute & MidTier Server - SAS Workspace Server, SAS OLAP Server, JBoss-4.2.0.GA, SAS Remote Services, SAS Client - Web Report Studio, information maps, SAS Enterprise Guide 5.1, Dataflux dfpower 8.1, Dataflux management studio2.3

Confidential, Atlanta, GA

Sr. SAS Consultant/SAS Platform Administrator

Environment: O/S - HP-UX 11.31,Unix,Windows Server 2008, Teradata 5500/5550, Teradata SQL Assistant, SQL Server 2005/2008, Oracle 10g, Tidal, Informatica, SAS Metadata Server - SAS Metadata Server 9.2/9.3, SAS Management Console 9.2/9.3, Mid-Tier Server - JBoss-4.2.0.GA, SAS Remote Services, Java Development Kit/ JRE 1.6.0 24, Web Report Studio SAS Compute Server

Responsibilities:

  • Performed pre- installation and pre-deployment preparation for installing SAS 9.3 Software i.e. downloading SAS Software depot, validating depot, obtaining SAS Plan File, Installing Java JDK package, Installing Third Party software and validating SAS Service account/External (SASInstall, SASSRV and SASDemo) and granting service account Administrative level privileges.
  • Installed and configured SAS 9.3 software using SAS Deployment Manager 9.3 for Windows Server 2008 R2 x64 bit (two machine installation), including SAS Metadata Server, Compute/SAS Application Server JBoss- Mid-Tier Services.
  • Established Windows Security measurement for SAS 9.3 environment, which include Securing SAS configuration directories Lev1 at directory/subdirectory level and Operating System level.
  • Established metadata identity for user’s accounts in SAS Management Console, Assigning relevant groups and roles. Creating user’s folder in windows in SAN Drive and user is made owner of the folder, granting them relevant privileges.
  • Migrated Users from SAS 9.1.3 to SAS 9.3 Environment, Migrated SAS code written in Enterprise Guide 4.2 to Enterprise Guide 4.3.Migrated SAS dataset/Code from Nexus to Polaris datacenter
  • Creating metadata server report using User Import Macro (%mdumap %mduextr), extracting user and group metadata from a metadata repository. Keeping track of number of user, their personal and Login details.
  • Installed and configured database and providing database connectivity using SAS i.e. Oracle 10g client, updating oracle TNS entry, Teradata Client ver. 13.10.00.00 , SQL Server 2005/2008.
  • Coordinated with IT management and infrastructure team to implement SAS Product Hotfix/Patch, release upgrade activity and act as liaison to SAS for any support issues. Managing and tracking SAS products inventory and license updates for SAS servers and end users.
  • Performed SAS Post Installation task, making sure all the SAS services are running fine, installing client i.e. Enterprise Guide, DI Studio and making sure client is connected to SAS server. Closely monitoring all SAS servers and their services/processes on daily basis.
  • Working with the SAS user community to perform periodic code reviews to insure that SAS applications are utilizing efficient design principles and adhering to internally published best practices. Coordinated with users and managed the deployment of content, code, and configuration changes to schedule production loads/jobs.
  • Checking the status and operations of SAS servers and processes, including starting, stopping, validating and/or pausing the servers/processes used in the SAS system.
  • Monitoring, logging, and troubleshooting SAS servers and processes, including error messages and using system logs or setting logging options as well as options within SAS Management Console (SMC).
  • Troubleshooting SAS-related performance issues, such as optimizing memory usage or tuning servers for performance improvement.

Confidential, Minneapolis, MN

Project Manager/Architect

Environment: SAS 9.2, JAVA, SQL Server 2005/2008 in Windows environment

Responsibilities:

  • Diagnoses of HIV or AIDS infection among persons by Age, year of diagnosis, United States and 5 U.S. dependent areas
  • Person living with a diagnosis of HIV or AIDS by Age, year of diagnosis, United States and 5 U.S. dependent areas
  • Adolescents and young adults living with an HIV or AIDS diagnosis

Environment: SAS V9, EG 4.2, SAS XML Mapper, SPSS, SQL Server 2005/2008 in Windows environment.

Confidential, Atlanta, GA

SAS Consultant

Responsibilities:

  • Developed and designed Agency, Contract Agency, Program Award, Site, Aggregate HCPI/HERR, Community Planning, Program Information and Planned vs. Delivered reports. Summarized categorized data and produced multidimensional/drilldown reports.
  • Developed Complex SQL Queries/Views/Joins to produce reports successfully. Performed functional and content testing.
  • Liaison with seniors, developers, and technicians regarding ETL processes, data Integration, migration, performed tuning, bottlenecks situations, implementation and designing.
  • Developed and designed ETL process for data extraction, developed and monitored SAS jobs/utilities, which triggers SAS program in batch mode and generates required datasets to produce the report
  • Implemented ETL process that involved SQL Server, flat files and XML files, parse, cleanse audit, reformat and loaded data into various data sources as per client’s requirements and business rules.
  • Coordinated and worked with ITSO team, resolved and tracked issue pertaining to SAS Batch job in Development, Staging and Production environment.
  • Developed and designed multidimensional, drilldown reports and feedback using PROC REPORT, PROC TABULATE, PROC MEANS, PROC SQL, ODS/HTML, PROC TRANSPOSE and DATA NULL .
  • Installed and Configured Object Spawner as a window services on the Server to interact SAS programs/batch jobs with Java based application.
  • Optimization and performance tuning/monitoring of Planned vs. Delivered report, instead of using SQL pass-through query in SAS, Created Views in SQL Server to improve the performance.
  • Successfully implemented of Migration from SAS 9.1 to SAS 9.2, tested existing SAS program/jobs/utilities and ensured no ambiguity exists.

Environment: SAS V9, EG 4.2, SAS XML Mapper, SQL Server 2005/2008 in Windows environment.

Confidential, New York, NY

SAS Consultant

Responsibilities:

  • Implemented business rules pertaining to financial and insurance products i.e. Retirement Plans, Supplemental Retirement Plans, SEP, IRAs, Keoghs and After-Tax Annuities.
  • Analyzed previous adhoc management requests and developed analysis datasets based on the trends.
  • Maintained customer “Historical and Marketing” data in terms of extracting data from backend and providing the results to marketing team.
  • Created reports using BI Server i.e. Web Report Studio, Enterprise Guide and Microsoft office integration
  • Designed Information maps view using Information map studio, implemented rules for policy, premium and payment data.
  • Implemented procedures for analysis and reporting purpose PROC FREQ, MEANS, SUMMARY, TRANSPOSE, FLIST, COMPARE, FORMAT, REPORT, DOWNLOAD, EXPORT and IMPORT.
  • Created complex and reusable Macros, extensively used macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
  • Created SAS Macro to extract data for analysis purpose and simultaneously data is being pulled in a excel sheet which generates Pivot Reports, Graphs and various statistical reports.
  • Automated production and Ad-hoc process to improve the performance of the current system.
  • Implemented Dynamic Data Exchange feature of SAS for importing and exporting of data from and into SAS, and Excel.

Environment: SAS V9 -BASE, SAS-SQL, SAS-Macros in Windows/Unix Environment.

Confidential, Charlotte, NC

SAS Consultant

Responsibilities:

  • Helped in developing SAS mappings, PL/SQL code to fix issues in production Database.
  • Extracted large amount of data from various SAS data sources using SAS/BASE and SAS/Macro programs.
  • Cleansing and updated the existing SAS code to run the process efficiently.
  • Design and develop ETL processes to load data from multiple source system databases (SQL Server, and flat files) into the DW (SQL Server).
  • Produced statistical reports using PROC FREQ, MEANS, REPORT, TABULTE, and ODS/HTML.

Environment: SAS V9 -BASE, SAS-SQL, SAS-Macros SQL/PLSQL and Spotfire in Windows/Unix Environment.

Hire Now