Description
KMM Technologies, Inc. is looking for a SAS EBI/Forecast Server Developer with some Administration exposure for a project in Washington DC.
Customer recently migrated from a PC SAS environment to a Client Server SAS 9.2 environment with EBI and Forecast Server. Customer requires a Consultant to assist them with basic SAS Platform Administration tasks. But, more importantly, Customer requires a Consultant to help them to continue pushing users to adopt usage of the EBI and Forecast Server environments. As such, the Consultant will have a general understanding of SAS Platform Administration tasks as well as the entire EBI product suite (including SAS coding) in order to continue to help BASE SAS users migrate over to the web environment. Customer can accept this being somewhat of a learning environment for the Consultant in that, if the Consultant has most of the skillsets described herein (but not all), the Consultant will be afforded the opportunity to learn somewhat on the job.
The Services activities may include focus on the following areas:
EBI Developer (V 9.2 required - V 9.3 a plus, since an upgrade will occur this year)
- Leading or assisting with activities related to EBI usage definition, development, and/or implementation, including actions that may incorporate both reporting and distribution processes
- Understanding Customer's BI requests and translating them into actionable reports from acquiring relevant data, modifying data if needed, building the reports, outputting the reports, etc.
- Utilizing Enterprise Guide and its functionality to create project flows which could include aspects of data access, manipulation, summarization, and report generation to a variety of output formats and channels, etc.
- Using Information Map Studio and its functionality to map physical data to business elements.
- Using Web Report Studio and its functionality to create web reports. As an example, use filters and prompts created within information maps, provide report linking, modify report layouts, schedule reports to run automatically, etc.
- Using the Information Delivery Portal as a means for users to view reports
- Creating various OLAP cubes using functionality of OLAP Cube Studio. As an example, creating various dimensions and hierarchies, drill-through, aggregations, etc.
- Creating and registering Stored Processes from within Enterprise Guide
- Publishing Enterprise Guide reports directly to Web Report Studio
- Using the SAS Publication Framework to publish static content to SAS publication channels to be consumed within the Portal
- Creating and modifying SAS BI Dashboards using available functionality
- Utilizing the Add-in for Microsoft Office
- Understanding the interrelation of EBI components and when to use one over the other, and be able to provide guidance, technical expertise, mentoring and knowledge transfer within the Customer user community in the proper use of these SAS components
- Be proficient in Base SAS programming, SQL programming, as well as the SAS Macro language for use in making code more efficient
- Leveraging and utilizing SAS' Output Delivery System (ODS)
- Leveraging and utilizing SAS/ACCESS Interface to Oracle (predominantly)
SAS Platform Administration (V 9.2 required -must have Administration understanding but not necessarily in-depth experience - V 9.3 a plus, since an upgrade will occur this year)
- Exposure with SAS Management Console
- Exposure with creating users and groups
- Exposure with roles
- Exposure to creating both RDBMS and SAS libraries and importing data
- Exposure with SAS Folders
- Exposure with SAS permissions and security
- Exposure to creating and utilizing ACTs
- Exposure to creating portal pages, adding portlets and security portal content
- Exposure to creating and maintaining custom themes
- Understand the inter-relation between Linux OS and SAS Metadata permissions and security
- Exposure to LDAP authentication using PAM
- Exposure with JBOSS as a Midtier web Application Server
- Exposure with RedHat Linux
- Knowledge of Forecast Server (FS)
- Help users adopt it.
- Must know how to use FS and have knowledge of it, but not be a forecasting expert or know how to build forecasts.
- Knowledge of JMP
- Knowledge of Base SAS coding, to include use of Macro and SQL (using SAS/ACCESS to Oracle primarily)