Microstrategy Developer

State Compensation Insurance Fund

Contract Pleasanton, California, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Microstrategy Developer (Contract)

$85.00 / Hourly

Pleasanton, California, United States

Microstrategy Developer

Contract Pleasanton, California, United States Posted 4 years ago

Description

Technical Knowledge and Skills Experience in MicroStrategy schema definition, design, implementation, maintenance, cubes, and Report development
Very strong SQL skills
Exposure of any one reporting tools will MicroStrategy, Business Objects
Good understanding of SDLC.
Design layout of reports and determine the best way to present data to end users.
Experience Building dashboard.
Experience with query optimization strategies for building reports.
Desired Qualifications and Certifications MicroStrategy Certification
Must have exceptional experience on MicroStrategy 10.4 and above in areas of administration, installation, upgrade and troubleshooting.
Must have Project experience in enabling single sign on authentication and integration with .Net framework portal application.
Must have Real life project experience in mobile integration
Must have project experience in integration of Essbase application with Microstrategy
Good knowledge of IIS and windows administration.
Building and developing reporting solutions on MicroStrategy BI
Endtoend implementation of Business Intelligence (BI) projects, especially in scorecards, reports, cubes, & dashboards
Creating and loading cubes, report caches and maintaining distribution services
Knowledgeable on admin functionalities of MSTR such as User creation, ACL, Movement of objects using Object manager, setting up of Enterprise Manager, security filters, subscriptions
Hands on experience on Installation and Deployment of MicroStrategy objects from Development to QA and Production environment.
Development and Support experience on MicroStrategy BI
Experience in customerfacing roles for requirements gathering and architecting solutions for BI projects
Trains and mentors less senior team members and business users.
Good analytical, interpersonal & communication skills, and proactive attitude
Indepth Knowledge in Data ware housing concepts, databases and advanced SQL.
Experience in building custom Java/SDK solutions, consume web services, Xquery, jSON, subscriptions/schedules to interact with MicroStrategy reports/report service documents.
Experienced in integration with Hadoop Ecosystem and search engines like Solr.
MicroStrategy Engineer who will work with the team on existing MicroStrategy development projects and also provide support. This individual will work across business and IT project teams to develop new reports and dashboards

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
Job Summary

$85.00 / Hourly

Contract

Pleasanton, California, United States

Experience Required : 5 Year/s

Posted : 4 years ago

Deadline : July 21, 2020 4 years ago

Job ID : Job0000020997

State Compensation Insurance Fund

1275 Market Street

415-565-1234

www.statefundca.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries10Models140MailsGateSessionRequest
Request history8.1.32PHP Version5.69sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (4.94s)time
    • Application (751ms)time
    • 1 x Booting (86.79%)
      4.94s
      1 x Application (13.21%)
      751ms
      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
      10 statements were executed420ms
      • JobController.php#484clientfyi_final85.25msselect * from `jobs` where `job_slug` = 'Job0000020997' limit 1
        Bindings
        • 0: Job0000020997
        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_final204msselect `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_final620μsselect * from `users` where `users`.`id` = 50873 limit 1
        Bindings
        • 0: 50873
        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_final520μ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` = 50873
        Bindings
        • 0: 1
        • 1: 50873
        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` = 50873
        Bindings
        • 0: 1
        • 1: 50873
        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_final12.4msselect DISTINCT email from `job_applications` where `category_id` = 116 and `status` = 1
        Bindings
        • 0: 116
        • 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_final490μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 20997 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 20997
        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_final970μ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_final60.87msSELECT 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_final54.38msSELECT 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
          NFqrgzPOiFRug5ALCqyExgKp2Qkbg2Is7a4yiv2R
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000020997" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000020997
          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"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.23.131.3"
  ]
  "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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "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 => "92dbf626ae62eae0-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.23.131.3"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.126.68"
  ]
  "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 => "Wed, 09 Apr 2025 18:10:34 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZiWFphY2hoaG1LL1Y5K3RWN3Q1aXc9PSIsInZhbHVlIjoiOTJOOEptcXg5b2ZnMEVFUlQzSUY1bUFqWWFJb3NjRGxRTGlZK3luR2NMTC9oVEpJNndTYllaN3owcW9hYlhHbmJtWWRnem9VZmp1U1RqQk5FNGRDSjVQb2hlME1QS3lUY2JNSlA0OGJOeC9JNjFmcnVvVEFYSHp6SDdyd3lhZ1QiLCJtYWMiOiI1YmVkY2Q2N2YyODIxMDQxZjQ3ODdlNmZkYjQ3MmZkYTVkY2RiNmI5ZDlmYzAwNmQ2NDhmODI1YzE1MzU2YTZkIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 20:10:35 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImZiWFphY2hoaG1LL1Y5K3RWN3Q1aXc9PSIsInZhbHVlIjoiOTJOOEptcXg5b2ZnMEVFUlQzSUY1bUFqWWFJb3NjRGxRTGlZK3luR2NMTC9oVEpJNndTYllaN3owcW9hYlhHbmJtWWRne ▶"
    1 => "laravel_session=eyJpdiI6Imp5dVZHL1FNNDh6ekpoWDA2WWlwVVE9PSIsInZhbHVlIjoiZGpTa1kzS3U5MXBEVzU0RmRvUWE2bHVySVJwRVNGaXA3eVNpSDEvQ3JiSDdOb254dVhIM2E5ZzdmVWxZQTFneXY5ekVmZHUzQ2dPWkJpbHc0RWVCVHJYeVlHRVY4ZDZrbVBiV2RoL2RmZWcxZ1p5VXRJVjJoTzJPREJmamQxQnkiLCJtYWMiOiI2NmZlMTRjNGQwYWM4NjliZTU2NTUxNDFjYTIxODJjZjhmY2JmZDQyYTNmZDJlZDlhNGE3MTA4MDYyNTkwMmJkIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 20:10:35 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Imp5dVZHL1FNNDh6ekpoWDA2WWlwVVE9PSIsInZhbHVlIjoiZGpTa1kzS3U5MXBEVzU0RmRvUWE2bHVySVJwRVNGaXA3eVNpSDEvQ3JiSDdOb254dVhIM2E5ZzdmVWxZQTFneXY5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZiWFphY2hoaG1LL1Y5K3RWN3Q1aXc9PSIsInZhbHVlIjoiOTJOOEptcXg5b2ZnMEVFUlQzSUY1bUFqWWFJb3NjRGxRTGlZK3luR2NMTC9oVEpJNndTYllaN3owcW9hYlhHbmJtWWRnem9VZmp1U1RqQk5FNGRDSjVQb2hlME1QS3lUY2JNSlA0OGJOeC9JNjFmcnVvVEFYSHp6SDdyd3lhZ1QiLCJtYWMiOiI1YmVkY2Q2N2YyODIxMDQxZjQ3ODdlNmZkYjQ3MmZkYTVkY2RiNmI5ZDlmYzAwNmQ2NDhmODI1YzE1MzU2YTZkIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 20:10:35 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImZiWFphY2hoaG1LL1Y5K3RWN3Q1aXc9PSIsInZhbHVlIjoiOTJOOEptcXg5b2ZnMEVFUlQzSUY1bUFqWWFJb3NjRGxRTGlZK3luR2NMTC9oVEpJNndTYllaN3owcW9hYlhHbmJtWWRne ▶"
    1 => "laravel_session=eyJpdiI6Imp5dVZHL1FNNDh6ekpoWDA2WWlwVVE9PSIsInZhbHVlIjoiZGpTa1kzS3U5MXBEVzU0RmRvUWE2bHVySVJwRVNGaXA3eVNpSDEvQ3JiSDdOb254dVhIM2E5ZzdmVWxZQTFneXY5ekVmZHUzQ2dPWkJpbHc0RWVCVHJYeVlHRVY4ZDZrbVBiV2RoL2RmZWcxZ1p5VXRJVjJoTzJPREJmamQxQnkiLCJtYWMiOiI2NmZlMTRjNGQwYWM4NjliZTU2NTUxNDFjYTIxODJjZjhmY2JmZDQyYTNmZDJlZDlhNGE3MTA4MDYyNTkwMmJkIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 20:10:35 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Imp5dVZHL1FNNDh6ekpoWDA2WWlwVVE9PSIsInZhbHVlIjoiZGpTa1kzS3U5MXBEVzU0RmRvUWE2bHVySVJwRVNGaXA3eVNpSDEvQ3JiSDdOb254dVhIM2E5ZzdmVWxZQTFneXY5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "NFqrgzPOiFRug5ALCqyExgKp2Qkbg2Is7a4yiv2R"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000020997"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-09 18:10:35GET/Job0000020997310140