DELLA NICHOLSON

Labor Category: SAS ADMINSTRATOR

Address:

**** ********* **** ******* **

Phone: 919-***-****

Education:

North Carolina Central University, Durham

oBachelor of Associate Degree: Political Science – 1995

oMaster of Computer and Information Science Degree – 1998

Project Management certified PMP

professional training:

OSU – Data Mining and CRM (with Enterprise Miner)

OSU – Database Marketing (with Enterprise Guide)

OSU – Advanced Data Mining

OSU – Base SAS Programming

OSU – Data, Process, and Object Modeling

certification:

SAS Institute, Cary NC, Certification: FAST TRACK Platform administration 9.2-9.3

FAST TRACK Data Integration Studio administration 9.2

Visual Analytics 6.3/6.4 Administration

SAS for HADOOP

Installing and Configuring the Platform for Business

Analytics

SAS LASR Analytic Server Administration

PROFESSIONAL AFFILIATIONS:

SAS Global Forum volunteer, 2011

SAS/OSU Analytics Day attendee, 2011

PROFESSIONAL SKILLS:

SAS PRODUCTS:

SAS/Base SAS/Macro SAS/Access

SAS/SQL SAS/Graph SAS/Connect

SAS/Integration Technologies Web Report Studio Enterprise Guide

SAS/ETL Server SAS Management Console SAS Information Map Studio

SAS DI Studio SAS IntrNET SAS Administrator

SAS Stored Processes Enterprise Guide SAS/ACCESS to Teradata

SAS Administrator 9- 9.2 -9.3 SAS BI Dashboard Delivery Portal

Map Studio, OLAP Cube Studio SAS Information Delivery Portal

SAS Information Delivery Portal Visual Analytics, Grid

Other Languages: Oracle, JavaScript JSP, Netezza, HTML, Sybase, DB2, Teradata, Business Objects, SQL Server, JAVA

Operating Systems: UNIX, Solaris/AIX, Mainframe, Windows, Linux

Version Control: Apache Subversion

Scheduler: M-Control Autosys, Trivoli, LSF and Cron

Cloudera: Hadoop and Impala

PROFESSIONAL EXPERIENCE:

SAS Consultant with over 30 years’ experience

Cigna 02MAY2015 – Present

Cigna, Connecticut

SAS Administrator

Configured and Installed SAS Foundation 9.3/9.4, SAS Metadata BI Server 9.3/9.4, SAS Grid 9.4 and SAS Visual Analytics 6.3/6.4

Installed and configured SAS Server environment including Metadata and Mid-Tier Servers

Implemented security and workspace administration in SAS Management Console

Applied SAS Hotfixes, Maintenance Release, and License Renewal as required

Created SAS Access Interface to Oracle, Teradata, Hadoop, Impala, DB2, SQL Server, and other files systems connections in management console

Installed and Configured SAS Clients: SAS Enterprise Guide, SAS Enterprise Miner, Base SAS, SAS Model Manager, Microsoft Add-in Client Installation.

Metadata configuration (create roles/Users/backups/libraries/Data source)

Installed and configured of SAS software and components including SAS solutions in production grade environments

Administered Hadoop and Impala

Installed and configured of SAS software and components including SAS solutions in production grade environments

Configured and Installed Hadoop and Impala

Created shell script programs

Configured and administered SAS modules and tools such as SAS/Connect and SAS/Access, and SAS Data Integration Studio

Developed SAS programming and scripting

Created ETL automation using SAS DI studio

Created data structures, data manipulation, queries efficiency techniques, application development and automation.

Responsible for Monitoring, Logging, and Troubleshooting SAS Servers

Randstad Technologies 15DEC2014-01MAY2015

Bank of America, Charlotte NC

SAS Administrator

Upgrade from SAS 9.3 to 9.4 and applied hot fixes

Installed and configured of SAS software and components including SAS solutions in production grade environments

Grid Administration

Metadata configuration (create roles/Users/backups/libraries/Data source)

Responsible for Grid Migration

Created ETL script using SAS DI studio

Created data structures, data manipulation, queries efficiency techniques, application development and automation.

Responsible for Monitoring, Logging, and Troubleshooting SAS Servers

Mapped data from multiple sources (including Oracle, flat files, Excel), built and implemented the data flows and loading the data into a SAS Analytical/Reporting data mart.

Designed, developed, deployed and maintained analytic applications and data structures.

Developed of SAS DI jobs, load schedules, and release management

Integrated and managed data mappings from the client’s data sources (Oracle, Netezza, Teradata) to the SAS Analytical data mart

Created Stored Processes to provide the users of the Reporting Data Mart easy access to the data.

Gathered data requirements and designed and developed data marts and performed analytical and tested, and promoted DI jobs into SIT, UAT and prod environments.

Installed, designed, developed and deployed DW applications using the SAS version 9 Intelligent Platform technology, architecture and resources in a Solaris 9 or 10 environment

Designed complex logical and physical data models on an enterprise scale (star schema, snowflake, normalized)

QUALEX CONSULTING SERVICES INC JUN2014 – 12DEC2014

DOJ Department of Justice

Installed, configured, and administered SAS Enterprise software

Secured the SAS configuration on each server Machine

Checked status and operate servers

Applied Hot Fixes/patches, new licenses to SAS environment, licensing upgrade and migration

Grid Administration

Monitored server activity and administered logging

Established formal, regularly scheduled backup process

Add users and manage access

Established connectivity to data sources

Set up metadata folder structure

Integration of SAS software with systems and other third-party software

Provided pre- and post-implementation documentation

Engineered application implementations based on requirements and sizing assessments

Configured, managed, monitored and debugged mid-tier software such as Websphere

Developing tools and software to manage SAS and third-party software

Diagnosing, documenting, reporting, and resolving system problems

Developed Reports

Developed SAS EBI dashboards

QUALEX CONSULTING SERVICES INC JAN2014 – JUN2014

MLS Sport Center, NewYork

SAS Administrator/ETL Developer

Installed, and configured the SAS Enterprise BI Infrastructure

Performed/Insured proper backups of metadata and business data

Monitored SAS Server resources and reporting usage(s)

Applied Hot Fixes/patches, new licenses to SAS environment.

Designed, implemented, and maintained security on SAS Metadata and Linux for users

Designed, implemented, and executed change control to SAS DI jobs, and SAS codes using subversion

Responsible for the systems design, implementation, and maintenance of SAS solutions across an enterprise-wide cross-platform

Extracted, transformed, and loaded data from SQL Server repositories to Teradata

Implemented enterprise software installations and managed, diagnosed, debugged designed, and prototyped SAS and third-party enterprise software systems.

Installed, administration and maintenance of SAS Enterprise software and solutions. Integrated SAS software with systems and other third-party software.

Engineered application implementations based on requirements and sizing assessments.

Configured, managed, monitored and debugged mid-tier software such as JBoss

Developed tools and software to manage SAS and third-party software.

Diagnosed, documented, reported, and resolved system problems.

Ensured delivery of technology solutions such as Performance Tuning, Capacity Planning, Disaster Recovery, User Support, Backups, Training and Documentation

Developing tools and software to manage SAS and third-party software

Developed SAS EBI dashboards

Migrated and tested program codes in IST,UAT and PROD Environments

QUALEX CONSULTING SERVICES INC APR2013 – JAN2014

JPMorgan, Wilmington Delaware

SAS Administrator

Configured, managed, monitored and debugged mid-tier software such as JBoss

Migrated and tested program codes in IST,UAT and PROD Environments

Converted program codes to Teradata

Created Teradata volatile queries and tables

QUALEX CONSULTING SERVICES INC 21JAN2012 – APR2013

Highmark Healthcare

Develop SAS code and BI Dashboard for Health Care Industry.

Combine Avaya call center and Inquiry data to create percentage values for performance guarantee and work force planning statistics.

Developed stored process report calendar programming

Created information maps and OLAP cubes for reports using data from data warehouse

created reports using SAS report studio

Deployed reports to SAS information delivery portal

State of North Carolina Medicare, Raleigh, North Carolina JAN 2012 – 20JAN2012

Lead SAS Development Analyst/Engineer

Used SAS DI studio to Load dimension table into Teradata

Installed, and configured the SAS Enterprise BI Infrastructure

Interfaced with other support teams, customers, and vendors

Created star schema and snowflake schema

Created fact tables

Populate star schema tables using the SCD type 2 loader with the surrogate key method

Develop change data capture transformation

Deploy jobs for scheduling

LabCorp, Informatics Reporting, Burlington, North Carolina Oct 2011 – JAN2012

Lead SAS Development SAS/Administrator

Administered in a multi-tiered topology SAS9 environment

Used AIX infrastructure with GPFS and AMC storage.

Developed pricing forecasts/models.

Administered SAS EBI, High Performance Analytics, Enterprise Miner, Data Management Server, SAS Scoring Accelerator for Teradata, SAS Model Manager

Created SAS application based on specification from clients and developed an export file system that accessed APPMETA tables (Clients, Accounts).

Automated report to be sent via FTP. Created weekly and monthly reports.

Define business requirements and specifications for clients involved in Datalink project.

Created and implemented custom remote portlet for the datalink SAS application system.

CSC, North Carolina Medicaid Management System, Raleigh, NC JAN 2009 – Oct 2011

SAS Senior EDI /SAS Administrator

Administered the use of LSF Scheduler including Platform Flow Manager, Event files, and job dependencies using SAS management console. Built monthly SAS warehouse with SAS/Data Integration Studio software for Credit Reporting.

Interfaced with other support teams, customers, and vendors

Developed tools and software to manage SAS and third-party software

Installed, Configured and administered of SAS Enterprise software and solutions

Responsible for the systems design, implementation, and maintenance of SAS solutions across an enterprise-wide cross-platform

Configured, managed, monitored and debugged mid-tier software such as Tomcat

Schedule jobs using Tivoli scheduler

College Foundation Inc Sept 2008 – Jan 2009

SAS Business Intelligence Specialist, (College Foundation Inc – Raleigh, NC)

Task consisted of implementing and optimizing SAS products within existing infrastructures (Windows and AIX). Use Data Integration to develop data warehouse

Developed SAS OLAP reporting structures and complex dashboards using SAS portal and other dashboard technologies Develop cubes

Provided oversight support to the design, development and QA teams. Defined areas of improvement to optimize data flows. Designed, developed, and wrote complex and original software code, specifically focusing on reporting and Business Intelligence functions for the corporate business and analytic team

RBC Bank, Raleigh, North Carolina Jan 2004 – Sept 2008

Senior Database Specialist Lead

Designed ETL objects mappings, using mapping operators, transforming data with data Stage using transformation operators

Applied Hot Fixes/patches, new licenses to SAS environment.

Interfaced with other support teams, customers, and vendors

Installed, and configured the SAS Enterprise BI Infrastructure

Configured, managed, monitored and debugged mid-tier software such as Tomcat

Developed tools and software to manage SAS and third-party software

Designed process flows, deployed and populated staging area objects and populated the DB2 Enterprise Model Warehouse.

Designing of the data model to support the user requirements Wrote test cases, test scripts and execution plans to support UAT in data validation on the CDW.

Created metadata for target data, Use Table loader Transformation

Develop slowly changing Dimension, Create metadata for source data

North Carolina Central University (NCCU), Durham, NC May 1990 – Jan 2004

Data Warehousing Manager, Office of Research, Evaluation and Planning

Managed teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training and defining support procedures.

Worked closely with the Data Architects and Data Integration Developers to translate the requirements into technical data specifications. Gathered, validated and documented data requirements down to the column level, in direct support of business requirements and priorities for specific data-driven and Data factory related projects

Develop data warehouse

Contact this candidate