Business Analyst

Allianz Life Insurance Company of North America

Contract Golden Valley , Minnesota, United States Posted 2 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Business Analyst (Contract)

$60.00 / Hourly

Golden Valley , Minnesota, United States

Business Analyst

Contract Golden Valley , Minnesota, United States Posted 2 months ago

Description

Expr as Business Analyst
Knowledge in Insurance annuities concepts
Should be able to understand the upstream and downstream applications integrating with the Policy admin system
Have basic SQL skills to look around data

Responsibilities
  • • Knowledge in Insurance annuities concepts
  • • Should be able to understand the upstream and downstream applications integrating with the Policy admin system
  • • Have basic SQL skills to look around data
  • • Excellent communication skills

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

Allianz Life Insurance Company of North America Vendors

( Login to see all the 8 vendors)
BearingPoint Inc
Write a Review

1676 International Drive
McLean
Virginia
www.bearingpoint.com ( 47 vendors)

Tata Consultancy Services
Write a Review

101 Park Avenue 26th Floor
New York
New York
www.usa-tcs.com ( 41 vendors)

HCL Technologies America Inc
Write a Review

330 Potrero Avenue
Sunnyvale
California
www.hcltech.com ( 34 vendors)

Job Summary

$60.00 / Hourly

Contract

Golden Valley , Minnesota, United States

Experience Level : Medium

Experience Required : 4 Year/s

Only Any

Posted : 2 months ago

Deadline : February 11, 2025 2 months ago

Job ID : Job0000017814

Allianz Life Insurance Company of North America

P.O. Box 1344

www.allianzlife.com

Request history8.1.32PHP Version2.26sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.75s)time
    • Application (510ms)time
    • 1 x Booting (77.46%)
      1.75s
      1 x Application (22.54%)
      510ms
      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 executed228ms
      • JobController.php#484clientfyi_final15.46msselect * from `jobs` where `job_slug` = 'business-analyst-95' limit 1
        Bindings
        • 0: business-analyst-95
        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_final100msselect `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_final660μsselect * from `users` where `users`.`id` = 240 limit 1
        Bindings
        • 0: 240
        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_final680μ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` = 240
        Bindings
        • 0: 1
        • 1: 240
        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.16msselect `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` = 240 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 240
        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_final350μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 240
        Bindings
        • 0: 1
        • 1: 240
        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_final11.12msselect DISTINCT email from `job_applications` where `category_id` = 29 and `status` = 1
        Bindings
        • 0: 29
        • 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_final550μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 17814 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 17814
        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_final900μ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_final52.25msSELECT 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.93msSELECT 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
          pDDHboZhiA760Ny8XQdPX8vNyo2pn87EDzdqBsXz
          _previous
          array:1 [ "url" => "https://pingjob.com/business-analyst-95" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /business-analyst-95
          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:18 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "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" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [ 0 => "18.217.156.194" ] "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 => "Fri, 25 Apr 2025 11:51:11 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IitmMjltMCtsb3hpTWhUcldaenViNWc9PSIsInZhbHVlIjoiNit3a1FsZlF1RUE0dzcrQ2syTFBpUElZL2lRWU1wWktFeERoOWVkbFd1MFEzREdPNm5WTWhhUE9lVmJSamQ0NlRpUTVwQWtQOXF1V2xIckNzcjYwQU0xcnU0bGhtbEtTak1Xek1pSUtKSnAwZGhwL2lvOUhaUStwbmhNR2RnTWIiLCJtYWMiOiI2ZWU1MmRhYTllZWE4ZjEwMzFjODFjNWFiZThmZDJlOGQ0OTQ3ZTVkMzBmOWU3ODI3ZDJjNjRmYjFlMDMyNjVlIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 13:51:11 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IitmMjltMCtsb3hpTWhUcldaenViNWc9PSIsInZhbHVlIjoiNit3a1FsZlF1RUE0dzcrQ2syTFBpUElZL2lRWU1wWktFeERoOWVkbFd1MFEzREdPNm5WTWhhUE9lVmJSamQ0NlRpUTVwQ" 1 => "laravel_session=eyJpdiI6Ijk5SjdCVXB6YVlUQ0Fya2xBNGU1WVE9PSIsInZhbHVlIjoia25nOEpiK1huV3dvRzczZGxoL2hWNG1BQ1IrVi9iSVRYdXpCcmlwdTVMbk9ZV21wVTZ2UDQvdTMxcDZLajJkTE9zN294cEVqV0N5bFVFRFpXM2llL2RQNWMreTdBYkFScUMvNWxiNUJpbDAzMVNKTjZuWUhOc1ZSc1FFN3NTYW4iLCJtYWMiOiI0YTc2Y2NjNjkxMTM1YWJhNzdlYTk1YWIyYjQ5YzcxYTlhMzY1YTdmZGY0ZTIyMTlmNjg2YWZiODA0NmYyNTA5IiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 13:51:11 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Ijk5SjdCVXB6YVlUQ0Fya2xBNGU1WVE9PSIsInZhbHVlIjoia25nOEpiK1huV3dvRzczZGxoL2hWNG1BQ1IrVi9iSVRYdXpCcmlwdTVMbk9ZV21wVTZ2UDQvdTMxcDZLajJkTE9z" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IitmMjltMCtsb3hpTWhUcldaenViNWc9PSIsInZhbHVlIjoiNit3a1FsZlF1RUE0dzcrQ2syTFBpUElZL2lRWU1wWktFeERoOWVkbFd1MFEzREdPNm5WTWhhUE9lVmJSamQ0NlRpUTVwQWtQOXF1V2xIckNzcjYwQU0xcnU0bGhtbEtTak1Xek1pSUtKSnAwZGhwL2lvOUhaUStwbmhNR2RnTWIiLCJtYWMiOiI2ZWU1MmRhYTllZWE4ZjEwMzFjODFjNWFiZThmZDJlOGQ0OTQ3ZTVkMzBmOWU3ODI3ZDJjNjRmYjFlMDMyNjVlIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 13:51:11 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IitmMjltMCtsb3hpTWhUcldaenViNWc9PSIsInZhbHVlIjoiNit3a1FsZlF1RUE0dzcrQ2syTFBpUElZL2lRWU1wWktFeERoOWVkbFd1MFEzREdPNm5WTWhhUE9lVmJSamQ0NlRpUTVwQ" 1 => "laravel_session=eyJpdiI6Ijk5SjdCVXB6YVlUQ0Fya2xBNGU1WVE9PSIsInZhbHVlIjoia25nOEpiK1huV3dvRzczZGxoL2hWNG1BQ1IrVi9iSVRYdXpCcmlwdTVMbk9ZV21wVTZ2UDQvdTMxcDZLajJkTE9zN294cEVqV0N5bFVFRFpXM2llL2RQNWMreTdBYkFScUMvNWxiNUJpbDAzMVNKTjZuWUhOc1ZSc1FFN3NTYW4iLCJtYWMiOiI0YTc2Y2NjNjkxMTM1YWJhNzdlYTk1YWIyYjQ5YzcxYTlhMzY1YTdmZGY0ZTIyMTlmNjg2YWZiODA0NmYyNTA5IiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 13:51:11 GMT; path=/; httponlylaravel_session=eyJpdiI6Ijk5SjdCVXB6YVlUQ0Fya2xBNGU1WVE9PSIsInZhbHVlIjoia25nOEpiK1huV3dvRzczZGxoL2hWNG1BQ1IrVi9iSVRYdXpCcmlwdTVMbk9ZV21wVTZ2UDQvdTMxcDZLajJkTE9z" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "pDDHboZhiA760Ny8XQdPX8vNyo2pn87EDzdqBsXz" "_previous" => array:1 [ "url" => "https://pingjob.com/business-analyst-95" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-25 11:51:11GET/business-analyst-95311140