Business Objects consultants

Pennsylvania Department of Transportation

Contract Harrisburg , Pennsylvania, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Business Objects consultants (Contract)

$75.00 / Hourly

Harrisburg , Pennsylvania, United States

Business Objects consultants

Contract Harrisburg , Pennsylvania, United States Posted 7 years ago

Description

Short Description The resource will develop and deliver Business Objects reports from existing transactional data stores as well as ODS and OLAP data stores. Complete Description Business Objects Senior Developer The resource in this position serves as a Business Objects Reporting and Data Mining programmer for the Bureau of Business Solutions & Services. The incumbent will develop and deliver Business Objects reports from existing transactional data stores as well as ODS and OLAP data stores. This includes transactional, operational and analytical systems. Technologies leveraged include Business Objects XI and Oracle 10g. Job Duties 1. Analyze reporting needs (in various forms ranging from detailed report specifications to general descriptions of business need) and develop solutions using Business Objects technologies, including Crystal Reports, Web Intelligence, Excelcius.2. Analyze multiple requests and requirements for BOBJ solutions, rationalize these requirements and design common BOBJ services and sharable reports to satisfy these needs.3. Design BOBJ universes to serve as a source for operational and analytical reports.4. Work with other technical team members to integrate Business Objects solutions with Microsoft .NET applications

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

Pennsylvania Department of Transportation Vendors

The Judge Group Inc
Write a Review

300 Conshohocken State Road - Suite 300
Pullman
Pennsylvania
www.judge.com ( 7 vendors)

Job Summary

$75.00 / Hourly

Contract

Harrisburg , Pennsylvania, United States

Experience Required : 5 Year/s

Posted : 7 years ago

Deadline : August 30, 2017 7 years ago

Job ID : Job0000009940

Pennsylvania Department of Transportation

1101 South Front Street

www.dot.state.pa.us

Request history8.1.31PHP Version3.52sRequest Duration692MBMemory UsageGET {slug}Route
    • Booting (3.06s)time
    • Application (459ms)time
    • 1 x Booting (86.96%)
      3.06s
      1 x Application (13.04%)
      459ms
      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 executed201ms
      • JobController.php#484clientfyi_final9.13msselect * from `jobs` where `job_slug` = 'Job0000009940' limit 1
        Bindings
        • 0: Job0000009940
        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_final85.09msselect `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_final640μsselect * from `users` where `users`.`id` = 48781 limit 1
        Bindings
        • 0: 48781
        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_final530μ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` = 48781
        Bindings
        • 0: 1
        • 1: 48781
        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_final740μsselect `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` = 48781 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 48781
        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` = 48781
        Bindings
        • 0: 1
        • 1: 48781
        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.34msselect DISTINCT email from `job_applications` where `category_id` = 189 and `status` = 1
        Bindings
        • 0: 189
        • 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_final400μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 9940 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 9940
        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_final770μ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_final46.84msSELECT 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_final48.25msSELECT 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
          0heobTr8WK4PRcQafTGGnGGdcdiQnfHkBaU7ZOce
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000009940" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000009940
          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 => "92071af4bdfcfa21-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.70.130.174" ] "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, 14 Mar 2025 22:11:13 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhDaEdlc2IrRnVob0dxeHNZcThJY0E9PSIsInZhbHVlIjoid29GcUpOeExoTDZob21SeU5WRytndityNnhCN0xYVnpjdFpocjZLRGpoWkY5MmJpZG9CVDhOa05INmVYbmZvcHZGdmtMZ0VGQ3RnOVEzWlBuTDJNWEN3TzVzWVg3NXY4RnlsMytnK3BBalZSd3RqczBqVEtjQjhpYTFjeitaNWkiLCJtYWMiOiI2MTc2NmMxNzVmNDJmZTI3YTFhNmJmMzdhMjQzMTBmMmI3YmJhY2IzMWYxYWI5MmExNGZhNjQ5YjUwZGVjN2VkIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 00:11:13 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkhDaEdlc2IrRnVob0dxeHNZcThJY0E9PSIsInZhbHVlIjoid29GcUpOeExoTDZob21SeU5WRytndityNnhCN0xYVnpjdFpocjZLRGpoWkY5MmJpZG9CVDhOa05INmVYbmZvcHZGdmtMZ" 1 => "laravel_session=eyJpdiI6IlpScTA4Y0pFQXkrR3FINWN6NmpTeUE9PSIsInZhbHVlIjoiSWVXeCtDaksvUEZQQ1piRVhxT3ozRGVVbkY3c0taQmY4SmMveHpteS9jR082ai81Sjl3ZlQ2a1ZRT0pzOHo1UWpTRnRWRi9WRUZyc1JwdU5uOERNaGhkQW1iMHVDcUZYM1ovUnlhcFhSSHJXaGtwYmN5ZGtyMkJJV2pxdmR1R1QiLCJtYWMiOiI2NDYyYjRlOWY0NTZkNThhNzFlMDU5YmU4ODQwNWM5MTMxNWViNjM0NmRjODRhOTczYjg4NDhmZTg1Y2Q3YTIxIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 00:11:13 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlpScTA4Y0pFQXkrR3FINWN6NmpTeUE9PSIsInZhbHVlIjoiSWVXeCtDaksvUEZQQ1piRVhxT3ozRGVVbkY3c0taQmY4SmMveHpteS9jR082ai81Sjl3ZlQ2a1ZRT0pzOHo1UWpT" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhDaEdlc2IrRnVob0dxeHNZcThJY0E9PSIsInZhbHVlIjoid29GcUpOeExoTDZob21SeU5WRytndityNnhCN0xYVnpjdFpocjZLRGpoWkY5MmJpZG9CVDhOa05INmVYbmZvcHZGdmtMZ0VGQ3RnOVEzWlBuTDJNWEN3TzVzWVg3NXY4RnlsMytnK3BBalZSd3RqczBqVEtjQjhpYTFjeitaNWkiLCJtYWMiOiI2MTc2NmMxNzVmNDJmZTI3YTFhNmJmMzdhMjQzMTBmMmI3YmJhY2IzMWYxYWI5MmExNGZhNjQ5YjUwZGVjN2VkIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 00:11:13 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkhDaEdlc2IrRnVob0dxeHNZcThJY0E9PSIsInZhbHVlIjoid29GcUpOeExoTDZob21SeU5WRytndityNnhCN0xYVnpjdFpocjZLRGpoWkY5MmJpZG9CVDhOa05INmVYbmZvcHZGdmtMZ" 1 => "laravel_session=eyJpdiI6IlpScTA4Y0pFQXkrR3FINWN6NmpTeUE9PSIsInZhbHVlIjoiSWVXeCtDaksvUEZQQ1piRVhxT3ozRGVVbkY3c0taQmY4SmMveHpteS9jR082ai81Sjl3ZlQ2a1ZRT0pzOHo1UWpTRnRWRi9WRUZyc1JwdU5uOERNaGhkQW1iMHVDcUZYM1ovUnlhcFhSSHJXaGtwYmN5ZGtyMkJJV2pxdmR1R1QiLCJtYWMiOiI2NDYyYjRlOWY0NTZkNThhNzFlMDU5YmU4ODQwNWM5MTMxNWViNjM0NmRjODRhOTczYjg4NDhmZTg1Y2Q3YTIxIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 00:11:13 GMT; path=/; httponlylaravel_session=eyJpdiI6IlpScTA4Y0pFQXkrR3FINWN6NmpTeUE9PSIsInZhbHVlIjoiSWVXeCtDaksvUEZQQ1piRVhxT3ozRGVVbkY3c0taQmY4SmMveHpteS9jR082ai81Sjl3ZlQ2a1ZRT0pzOHo1UWpT" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "0heobTr8WK4PRcQafTGGnGGdcdiQnfHkBaU7ZOce" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000009940" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-14 22:11:13GET/Job0000009940311140