VBA/Excel Developer

KPMG LLP

Contract Chicago , Illinois, United States Posted 4 months ago

 Write a Review Add Vendor   Add Contact  

About Position

VBA/Excel Developer (Contract)

$55.00 / Hourly

Chicago , Illinois, United States

VBA/Excel Developer

Contract Chicago , Illinois, United States Posted 4 months ago

Skills
Design Develop and Refine Excel-Based Calculators: Develop new Excel-based pricing calculators incorporating VBA macros to automate complex pricing calculations. Regularly evaluate and enhance existing calculators for optimal functionality efficiency and user experience. User Acceptance Testing (UAT) Support: Design execute and document UAT test scripts. Liaise with users to capture feedback identify defects and make iterative improvements.
Description

VBA and Excel Developer with UAT testing

Experience working with advanced Excel functions, including complex formulas, pivot tables, and VBA macro programming is essential.
Design, execute and document UAT test scripts

Responsibilities
  • Deployment and Go-Live Support:
  • Oversee the transition of pricing calculators from development to production, ensuring minimal disruption during deployment.
  • Provide immediate technical support during the cutover phase and after go-live, addressing issues swiftly for successful implementation.
  • Documentation and Technical Writing:
  • Create and update detailed technical guides outlining the architectural functioning, logic, and maintenance protocols of calculators.
  • Develop informative user guides and reference materials to assist end-users.
  • Regularly review and update documentation to ensure its accuracy and relevance.
  • Conceptual Understanding of Pricing Models: Collaborate with the business teams to understand detailed pricing requirements and reflect them technically within the calculators.
  • Collaboration and Meeting Facilitation: Actively interact with stakeholders to understand their needs, present updates, and receive feedback. Document meeting outcomes and actions, and ensure follow-ups are managed effectively.
  • Skills:
  • Expertise in Excel:
  • Experience working with advanced Excel functions, including complex formulas, pivot tables, and VBA macro programming is essential.
  • Proven track record of developing and maintaining advanced pricing models within Excel.
  • Documentation Skills:
  • Ability to explain technical concepts in a user-friendly manner.
  • Experience in creating clear, concise, and comprehensive user and technical guides.
  • Good to have knowledge on related Tools and Applications:
  • Office Scripts.
  • User-level knowledge of Microsoft SharePoint.
  • User-level knowledge of Microsoft Teams.
  • User-level knowledge of Jira
  • Familiarity with Pricing Models (Preferred, but not Mandatory): Understanding of various pricing methods (Time & Material, Fixed Fee, etc.) and the ability to align them with technical implementations.
  • Problem Solving: Strong logical and critical thinking abilities to troubleshoot issues and optimize calculator performance.
  • Education: Educational Background: A Degree in Business, Finance, Computer Science, Economics, or related field is preferred. A professional certification in a relevant field would be an advantage

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

KPMG LLP Vendors

( Login to see all the 6 vendors)
NTT DATA Inc
Write a Review

100 City Square
Boston
Massachusetts
https://us.nttdata.com ( 36 vendors)

Hexaware Technologies Inc
Write a Review

1095 Cranbury South River Road Suite 10
Jamesburg
New Jersey
www.hexaware.com ( 4 vendors)

Xoriant Corporation
Write a Review

1248 Reamwood Avenue
Sunnyvale
California
www.xoriant.com ( 2 vendors)

Job Summary

$55.00 / Hourly

Contract

Chicago , Illinois, United States

Experience Level : Medium

Experience Required : 5 Year/s

Only Any

Posted : 4 months ago

Deadline : November 15, 2024 4 months ago

Job ID : Job0000009364

KPMG LLP

3 Chestnut Ridge Rd

201-307-7000

www.kpmg.com

Request history8.1.32PHP Version2.62sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.31s)time
    • Application (313ms)time
    • 1 x Booting (88.08%)
      2.31s
      1 x Application (11.92%)
      313ms
      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_final11.26msselect * from `jobs` where `job_slug` = 'vbaexcel-developer' limit 1
        Bindings
        • 0: vbaexcel-developer
        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_final99.99msselect `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_final700μsselect * from `users` where `users`.`id` = 15599 limit 1
        Bindings
        • 0: 15599
        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_final670μ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` = 15599
        Bindings
        • 0: 1
        • 1: 15599
        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.04msselect `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` = 15599 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 15599
        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_final400μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 15599
        Bindings
        • 0: 1
        • 1: 15599
        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_final7.96msselect DISTINCT email from `job_applications` where `category_id` = 172 and `status` = 1
        Bindings
        • 0: 172
        • 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` = 9364 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 9364
        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_final4.87msselect * 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.71msSELECT 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.07msSELECT 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
          FnERRa93N9uHrzQxLEHmLrFD7XJHrDuzB1x8MrQp
          _previous
          array:1 [ "url" => "https://pingjob.com/vbaexcel-developer" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /vbaexcel-developer
          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.216.229.154" ] "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 => "92b3f23c2ca0000a-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "18.216.229.154" ] "x-real-ip" => array:1 [ 0 => "172.70.127.98" ] "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, 04 Apr 2025 21:37:21 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjN5R1lpeGZ3Q0labjlJd0k2S1FKTEE9PSIsInZhbHVlIjoiYkRVRm41NW4wR0w2bXV0a1kyOWRJTHkzYTk3czY2REt5SXJxczJ0bFJVQmUvbTVIL3hRM054dHRKN1l5WSt2aitkcXliSU1zZHNOTUNmMlorS05ZZDA3bm9HakJjb0ljdEZkU2pCZzA0WWw5UVYyYmN4Rll0MHRFeUpsUVhibTYiLCJtYWMiOiJkMTBhZDQwMDI4NzI1ZDBjMTZmMWY4ZDAwZjBkNWQ3MmYzMjc3YmEyY2Q4MmI1MGIyZDM1Nzg2NGFmNTlmYzhmIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 23:37:21 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjN5R1lpeGZ3Q0labjlJd0k2S1FKTEE9PSIsInZhbHVlIjoiYkRVRm41NW4wR0w2bXV0a1kyOWRJTHkzYTk3czY2REt5SXJxczJ0bFJVQmUvbTVIL3hRM054dHRKN1l5WSt2aitkcXliS" 1 => "laravel_session=eyJpdiI6IllSaTFyWEdUdkdtc2ZTRnhjcFZxUGc9PSIsInZhbHVlIjoiU1JtOW1nOHFnM2NDNUhMVE4rVFNnMzk1VDMrdEYzSm9XdmpLSzNmTE9xNGxwYWg2Wmo4R3UzMUlabWpJUmMySXdleVlpS2NFMHA3TnJrdlNWUWhEdkwxNy9WTlJrb0tmSUFORkhTY1J0WUtZUWFFOW90UGhoN1JvQVNYWjNqbGMiLCJtYWMiOiJjOGU2M2ZmYzczMjg2NWJkMzNhN2NiMzNkNTEyNDJmNzUzNDBiNzBmZWJkODY3ZGE1OGZiNTJjNjUzMjc0ZjgzIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 23:37:21 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IllSaTFyWEdUdkdtc2ZTRnhjcFZxUGc9PSIsInZhbHVlIjoiU1JtOW1nOHFnM2NDNUhMVE4rVFNnMzk1VDMrdEYzSm9XdmpLSzNmTE9xNGxwYWg2Wmo4R3UzMUlabWpJUmMySXdl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjN5R1lpeGZ3Q0labjlJd0k2S1FKTEE9PSIsInZhbHVlIjoiYkRVRm41NW4wR0w2bXV0a1kyOWRJTHkzYTk3czY2REt5SXJxczJ0bFJVQmUvbTVIL3hRM054dHRKN1l5WSt2aitkcXliSU1zZHNOTUNmMlorS05ZZDA3bm9HakJjb0ljdEZkU2pCZzA0WWw5UVYyYmN4Rll0MHRFeUpsUVhibTYiLCJtYWMiOiJkMTBhZDQwMDI4NzI1ZDBjMTZmMWY4ZDAwZjBkNWQ3MmYzMjc3YmEyY2Q4MmI1MGIyZDM1Nzg2NGFmNTlmYzhmIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 23:37:21 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjN5R1lpeGZ3Q0labjlJd0k2S1FKTEE9PSIsInZhbHVlIjoiYkRVRm41NW4wR0w2bXV0a1kyOWRJTHkzYTk3czY2REt5SXJxczJ0bFJVQmUvbTVIL3hRM054dHRKN1l5WSt2aitkcXliS" 1 => "laravel_session=eyJpdiI6IllSaTFyWEdUdkdtc2ZTRnhjcFZxUGc9PSIsInZhbHVlIjoiU1JtOW1nOHFnM2NDNUhMVE4rVFNnMzk1VDMrdEYzSm9XdmpLSzNmTE9xNGxwYWg2Wmo4R3UzMUlabWpJUmMySXdleVlpS2NFMHA3TnJrdlNWUWhEdkwxNy9WTlJrb0tmSUFORkhTY1J0WUtZUWFFOW90UGhoN1JvQVNYWjNqbGMiLCJtYWMiOiJjOGU2M2ZmYzczMjg2NWJkMzNhN2NiMzNkNTEyNDJmNzUzNDBiNzBmZWJkODY3ZGE1OGZiNTJjNjUzMjc0ZjgzIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 23:37:21 GMT; path=/; httponlylaravel_session=eyJpdiI6IllSaTFyWEdUdkdtc2ZTRnhjcFZxUGc9PSIsInZhbHVlIjoiU1JtOW1nOHFnM2NDNUhMVE4rVFNnMzk1VDMrdEYzSm9XdmpLSzNmTE9xNGxwYWg2Wmo4R3UzMUlabWpJUmMySXdl" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "FnERRa93N9uHrzQxLEHmLrFD7XJHrDuzB1x8MrQp" "_previous" => array:1 [ "url" => "https://pingjob.com/vbaexcel-developer" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-04 21:37:21GET/vbaexcel-developer311140