SAS Developer

Elevance Health

Contract North Haven, Connecticut, United States Posted 6 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SAS Developer (Contract)

$55.00 / Hourly

North Haven, Connecticut, United States

SAS Developer

Contract North Haven, Connecticut, United States Posted 6 years ago

Description

Required Skills SAS, SQL, ETL, Data Warehouse, complex data mining analysis, Claims data, queries, reportsMUST HAVE HEALTHCARE BACKGROUND AND CLAIMS DATA EXPERIENCEExperience with EDWard is a plusPhone InterviewDescription Responsible for developing and executing more complex data mining analyses. Primary duties may include, but are not limited to Determines how decision support systems will provide the data required to make effective business decisions. Performs modeling of information sources and flows. May coordinate the activities of a project team and monitors project schedules and costs for own projects. Develops strategic report applications from the Data Warehouse. Establishes and maintains excellent knowledge of data warehouse database design, data definitions, system capabilities, programming languages, and data integrity issues. Develops and supports complex data warehouserelated applications for business areas requiring design and implementation of database tables. Conducts training on use of applications developed. Payment Innovation Background Client

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Elevance Health Vendors

( Login to see all the 9 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Accenture Ltd
Write a Review

1345 Avenue of the Americas
New York
New York
www.accenture.com ( 51 vendors)

Infosys Technologies Ltd
Write a Review

6607 Kaiser Drive
Fremont
California
www.infosys.com ( 27 vendors)

Job Summary

$55.00 / Hourly

Contract

North Haven, Connecticut, United States

Experience Required : 3 Year/s

Posted : 6 years ago

Deadline : September 22, 2018 6 years ago

Job ID : Job0000014014

Elevance Health

220 Virginia Avenue

317-488-6000

www.ElevanceHealth.com

Request history8.1.31PHP Version2.38sRequest Duration685MBMemory UsageGET {slug}Route
    • Booting (2.08s)time
    • Application (299ms)time
    • 1 x Booting (87.45%)
      2.08s
      1 x Application (12.54%)
      299ms
      3 templates were rendered
      • frontend.job-viewjob-view.blade.php#?blade
      • admin.flash_msgflash_msg.blade.php#?blade
      • layouts.themetheme.blade.php#?blade
      uri
      GET {slug}
      middleware
      web
      controller
      App\Http\Controllers\JobController@view
      namespace
      prefix
      where
      as
      job_view
      file
      app/Http/Controllers/JobController.php:482-507
      11 statements were executed216ms
      • JobController.php#484clientfyi_final16.92msselect * from `jobs` where `job_slug` = 'Job0000014014' limit 1
        Bindings
        • 0: Job0000014014
        Backtrace
        • app/Http/Controllers/JobController.php:484
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • User.php#78clientfyi_final88.78msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc
        Bindings
        • 0: employer
        • 1: agent
        Backtrace
        • app/Models/User.php:78
        • app/Http/Controllers/JobController.php:491
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#493clientfyi_final680μsselect * from `users` where `users`.`id` = 11581 limit 1
        Bindings
        • 0: 11581
        Backtrace
        • app/Http/Controllers/JobController.php:493
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Vendor.php#57clientfyi_final790μsselect count(*) as aggregate from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 11581
        Bindings
        • 0: 1
        • 1: 11581
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • Vendor.php#57clientfyi_final1.69msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 11581 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 11581
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#500clientfyi_final410μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 11581
        Bindings
        • 0: 1
        • 1: 11581
        Backtrace
        • app/Http/Controllers/JobController.php:500
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • job-view.blade.php#17clientfyi_final8.92msselect DISTINCT email from `job_applications` where `category_id` = 95 and `status` = 1
        Bindings
        • 0: 95
        • 1: 1
        Backtrace
        • view::frontend.job-view:17
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • job-view.blade.php#450clientfyi_final450μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 14014 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 14014
        Backtrace
        • view::frontend.job-view:450
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#101clientfyi_final1.08msselect * from `categories` where `job_count` >= 1 order by `job_count` desc
        Bindings
        • 0: 1
        Backtrace
        • view::layouts.theme:101
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#102clientfyi_final52.4msSELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:102
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#103clientfyi_final44.2msSELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:103
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Category
      138Category.php#?
      App\Models\Job
      1Job.php#?
      App\Models\User
      1User.php#?
          _token
          NMxxPoQEoxJhbMTVcJvJEES9gcfS41LteegvW1X4
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000014014" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000014014
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:25 [ "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "3.138.183.117" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "cf-ray" => array:1 [ 0 => "916a275a3a736501-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.138.183.117" ] "x-real-ip" => array:1 [ 0 => "172.69.17.18" ] "host" => array:1 [ 0 => "pingjob.com" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sun, 23 Feb 2025 21:01:55 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImdVUVVoakJHR2FHYXo1UENxN3RoNlE9PSIsInZhbHVlIjoiTGJXb3NySm1nQ0h5b0pQUHdwcm1pTFIvWHgyelNGVGw4YUlKcWY0NXRRbVJLOW1KcmtxZVpyR1BsN0ljdUhSNncwUFJZQXdId2JUMXZZUkFaZ2VXbm5jcVlpSzE2MndSM2xNVG4rWEVRdU1HbVNaQjJ0dCthRG5wQWNpVHphNGMiLCJtYWMiOiIzYmI0Y2Q4OWU4MTkyODQ2NjkyMTk5Y2FmNmE2MjIyNTQ0YTgxOWMyOWJmNmM4YWYxNjJhOWVhZjdkNTc3NDI4IiwidGFnIjoiIn0%3D; expires=Sun, 23 Feb 2025 23:01:56 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImdVUVVoakJHR2FHYXo1UENxN3RoNlE9PSIsInZhbHVlIjoiTGJXb3NySm1nQ0h5b0pQUHdwcm1pTFIvWHgyelNGVGw4YUlKcWY0NXRRbVJLOW1KcmtxZVpyR1BsN0ljdUhSNncwUFJZQ" 1 => "laravel_session=eyJpdiI6IjBpTkdJNVhJZVVnT0dPWWVQMTFyS0E9PSIsInZhbHVlIjoiR0QzSEV4U3I0TGdQdnBxZE0vNkxFTnEvZG5JYXJxMVhSWnFLajBIWTlHTmZUTmlXOGhmRFZTVEFMNnRuV1BFTTBKRC9YVDFmOHVTQlhCR2pzak1xQm8rVXRmVTFlRVU2cDdLV295OSszaEdQTzVJYjByNW1xcE9xU3lRUWh3bmMiLCJtYWMiOiI0MjUxM2U3ODZjMmIwYzc2OThkZWZkOWVkOTRhNjQyYzlmZGUzZjc1MDc1NDg5MDhiNDgyZTA1YzQ4MTg5MmRkIiwidGFnIjoiIn0%3D; expires=Sun, 23 Feb 2025 23:01:56 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IjBpTkdJNVhJZVVnT0dPWWVQMTFyS0E9PSIsInZhbHVlIjoiR0QzSEV4U3I0TGdQdnBxZE0vNkxFTnEvZG5JYXJxMVhSWnFLajBIWTlHTmZUTmlXOGhmRFZTVEFMNnRuV1BFTTBK" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImdVUVVoakJHR2FHYXo1UENxN3RoNlE9PSIsInZhbHVlIjoiTGJXb3NySm1nQ0h5b0pQUHdwcm1pTFIvWHgyelNGVGw4YUlKcWY0NXRRbVJLOW1KcmtxZVpyR1BsN0ljdUhSNncwUFJZQXdId2JUMXZZUkFaZ2VXbm5jcVlpSzE2MndSM2xNVG4rWEVRdU1HbVNaQjJ0dCthRG5wQWNpVHphNGMiLCJtYWMiOiIzYmI0Y2Q4OWU4MTkyODQ2NjkyMTk5Y2FmNmE2MjIyNTQ0YTgxOWMyOWJmNmM4YWYxNjJhOWVhZjdkNTc3NDI4IiwidGFnIjoiIn0%3D; expires=Sun, 23-Feb-2025 23:01:56 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImdVUVVoakJHR2FHYXo1UENxN3RoNlE9PSIsInZhbHVlIjoiTGJXb3NySm1nQ0h5b0pQUHdwcm1pTFIvWHgyelNGVGw4YUlKcWY0NXRRbVJLOW1KcmtxZVpyR1BsN0ljdUhSNncwUFJZQ" 1 => "laravel_session=eyJpdiI6IjBpTkdJNVhJZVVnT0dPWWVQMTFyS0E9PSIsInZhbHVlIjoiR0QzSEV4U3I0TGdQdnBxZE0vNkxFTnEvZG5JYXJxMVhSWnFLajBIWTlHTmZUTmlXOGhmRFZTVEFMNnRuV1BFTTBKRC9YVDFmOHVTQlhCR2pzak1xQm8rVXRmVTFlRVU2cDdLV295OSszaEdQTzVJYjByNW1xcE9xU3lRUWh3bmMiLCJtYWMiOiI0MjUxM2U3ODZjMmIwYzc2OThkZWZkOWVkOTRhNjQyYzlmZGUzZjc1MDc1NDg5MDhiNDgyZTA1YzQ4MTg5MmRkIiwidGFnIjoiIn0%3D; expires=Sun, 23-Feb-2025 23:01:56 GMT; path=/; httponlylaravel_session=eyJpdiI6IjBpTkdJNVhJZVVnT0dPWWVQMTFyS0E9PSIsInZhbHVlIjoiR0QzSEV4U3I0TGdQdnBxZE0vNkxFTnEvZG5JYXJxMVhSWnFLajBIWTlHTmZUTmlXOGhmRFZTVEFMNnRuV1BFTTBK" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "NMxxPoQEoxJhbMTVcJvJEES9gcfS41LteegvW1X4" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000014014" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-23 21:01:56GET/Job0000014014311140