Data Analyst (Oracle / SQL

United health Group

Contract Minnetonka, Minnesota, United States Posted 8 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Analyst (Oracle / SQL (Contract)

$45.00 / Hourly

Minnetonka, Minnesota, United States

Data Analyst (Oracle / SQL

Contract Minnetonka, Minnesota, United States Posted 8 years ago

Description

Title IT Internet Data Analyst/Architect Intermediate Description Looking for a resource to specialize in data mining, data manipulation, data conversion and data research. Working with oracle and sql databases. SQL skills a must. Java development skills a plus. Ability to write conversion programs.

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

United health Group Vendors

( Login to see all the 22 vendors)
Akkodis
Write a Review

1 Independent Drive
Jacksonville
Florida
https://www.akkodis.com/ ( 81 vendors)

Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 vendors)

Accenture Ltd
Write a Review

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

Job Summary

$45.00 / Hourly

Contract

Minnetonka, Minnesota, United States

Experience Required : 5 Year/s

Posted : 8 years ago

Deadline : November 27, 2016 8 years ago

Job ID : Job0000006807

United health Group

9900 Bren Road East

www.unitedhealthgroup.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.33sRequest Duration691MBMemory UsageGET {slug}Route
    • Booting (2.07s)time
    • Application (259ms)time
    • 1 x Booting (88.87%)
      2.07s
      1 x Application (11.13%)
      259ms
      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 executed192ms
      • JobController.php#484clientfyi_final6.9msselect * from `jobs` where `job_slug` = 'Job0000006807' limit 1
        Bindings
        • 0: Job0000006807
        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_final81.95msselect `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_final590μsselect * from `users` where `users`.`id` = 6101 limit 1
        Bindings
        • 0: 6101
        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_final730μ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` = 6101
        Bindings
        • 0: 1
        • 1: 6101
        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.93msselect `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` = 6101 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6101
        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_final300μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6101
        Bindings
        • 0: 1
        • 1: 6101
        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_final9.97msselect DISTINCT email from `job_applications` where `category_id` = 39 and `status` = 1
        Bindings
        • 0: 39
        • 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_final420μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 6807 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 6807
        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_final800μsselect * 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_final44.48msSELECT 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_final43.47msSELECT 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
          owUpQy2zsPbcsXmeBGZKs6r1hQUGtRRDYIGb8qsd
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000006807" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000006807
          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 => "18.118.171.28"
  ]
  "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 => "91eeba5508230046-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.118.171.28"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.126.29"
  ]
  "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 => "Tue, 11 Mar 2025 23:10:56 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNwZFJtMjJVUHVHT3NFMmhqcVRXS1E9PSIsInZhbHVlIjoiVmVhbk5DZ2RiMG9tOW1SK3REMTF1UGM2M2JsaTVxaHdwUUVyaEYwZ1JQSkNjNXpZSmU0MkdnTEUwZ0NHY3ZMcW5FeW9zK2V2UmYvVktSbVNUR05FZ2U1cmErcGNGUVd2UDV6T2dXOVMwV2Z0UzNvbHlWY2dmNlhUbmtIeWliRnoiLCJtYWMiOiI4N2UzOGM2NzYxNWUzM2M2ZjgxYmEyMTZhZWIzYjMyMTAxYjFhNTRhMDQwNDY0NDZhNWEzODI0NWY5NzMzMjljIiwidGFnIjoiIn0%3D; expires=Wed, 12 Mar 2025 01:10:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InNwZFJtMjJVUHVHT3NFMmhqcVRXS1E9PSIsInZhbHVlIjoiVmVhbk5DZ2RiMG9tOW1SK3REMTF1UGM2M2JsaTVxaHdwUUVyaEYwZ1JQSkNjNXpZSmU0MkdnTEUwZ0NHY3ZMcW5FeW9zK ▶"
    1 => "laravel_session=eyJpdiI6InZQNGw4N3dyRHlPU1JEd1U0MzBQb2c9PSIsInZhbHVlIjoiVnNUQXVpSTlnTThsUzlLMUN5cUIyQUNnL2RSNXI4UFRwb09YTjFxSWlQNkd5YzlhRElMb2pZcHQyZEpRVDIrQjFya3lHT0tPMmJwODc4ZDRYdEdFNy9RTldNVk1IbGZ0WDBqUytUUU84K0dxSVFQeWlvOXp1aEFwN1ZON2IyNVMiLCJtYWMiOiJmNjdhNTU2N2U1MjMzNTc2NzYxNjY3NWEwMmUwNzRlNjdmNjc1YjYxYzQ5NTYyODVkOGFkOGVkMDE3MTQxYjY1IiwidGFnIjoiIn0%3D; expires=Wed, 12 Mar 2025 01:10:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6InZQNGw4N3dyRHlPU1JEd1U0MzBQb2c9PSIsInZhbHVlIjoiVnNUQXVpSTlnTThsUzlLMUN5cUIyQUNnL2RSNXI4UFRwb09YTjFxSWlQNkd5YzlhRElMb2pZcHQyZEpRVDIrQjFy ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNwZFJtMjJVUHVHT3NFMmhqcVRXS1E9PSIsInZhbHVlIjoiVmVhbk5DZ2RiMG9tOW1SK3REMTF1UGM2M2JsaTVxaHdwUUVyaEYwZ1JQSkNjNXpZSmU0MkdnTEUwZ0NHY3ZMcW5FeW9zK2V2UmYvVktSbVNUR05FZ2U1cmErcGNGUVd2UDV6T2dXOVMwV2Z0UzNvbHlWY2dmNlhUbmtIeWliRnoiLCJtYWMiOiI4N2UzOGM2NzYxNWUzM2M2ZjgxYmEyMTZhZWIzYjMyMTAxYjFhNTRhMDQwNDY0NDZhNWEzODI0NWY5NzMzMjljIiwidGFnIjoiIn0%3D; expires=Wed, 12-Mar-2025 01:10:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InNwZFJtMjJVUHVHT3NFMmhqcVRXS1E9PSIsInZhbHVlIjoiVmVhbk5DZ2RiMG9tOW1SK3REMTF1UGM2M2JsaTVxaHdwUUVyaEYwZ1JQSkNjNXpZSmU0MkdnTEUwZ0NHY3ZMcW5FeW9zK ▶"
    1 => "laravel_session=eyJpdiI6InZQNGw4N3dyRHlPU1JEd1U0MzBQb2c9PSIsInZhbHVlIjoiVnNUQXVpSTlnTThsUzlLMUN5cUIyQUNnL2RSNXI4UFRwb09YTjFxSWlQNkd5YzlhRElMb2pZcHQyZEpRVDIrQjFya3lHT0tPMmJwODc4ZDRYdEdFNy9RTldNVk1IbGZ0WDBqUytUUU84K0dxSVFQeWlvOXp1aEFwN1ZON2IyNVMiLCJtYWMiOiJmNjdhNTU2N2U1MjMzNTc2NzYxNjY3NWEwMmUwNzRlNjdmNjc1YjYxYzQ5NTYyODVkOGFkOGVkMDE3MTQxYjY1IiwidGFnIjoiIn0%3D; expires=Wed, 12-Mar-2025 01:10:56 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InZQNGw4N3dyRHlPU1JEd1U0MzBQb2c9PSIsInZhbHVlIjoiVnNUQXVpSTlnTThsUzlLMUN5cUIyQUNnL2RSNXI4UFRwb09YTjFxSWlQNkd5YzlhRElMb2pZcHQyZEpRVDIrQjFy ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "owUpQy2zsPbcsXmeBGZKs6r1hQUGtRRDYIGb8qsd"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000006807"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-11 23:10:56GET/Job0000006807311140