Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 30th Jul 2021
BSA Resource requires advanced Microsoft Excel skills. Must be able to create Pivot Tables and use VLOOKUP's to merge / determine variables between sheets, etc. This person will be pulling data from Service Now, using external excel sheets to categorize data (country to region mapping), doing aged calculations using current date versus created date and categorizing incidents using this information. Experience with Power BI is preferred.
Mandatory Skills:
Strong knowledge and experience in working with MS-Excel, Pivot Tables and graphs.
Experience with ServiceNow (ITSM) in extracting data, creating tickets.
Metric Reporting resource skilled using Excel pivot tables and VLOOKUP's. Will pull data from different sources (including ServiceNow, ACD's, etc.) together to produce metric reports for senior management.
Ability to organize findings into a PowerPoint or interactive dashboard a plus.
The resource must be capable of needing minimal instruction, able to work independently, good communication skills and ability to capture reporting requirements and create reports.
MUST –
Advanced Excel skills: pivot tables, formula writing (VLOOKUP), figure-making
Database access capabilities: Structured Query Language (SQL) for query writing
Power BI skills: connect to datasets and build interactive reports
Database access capabilities: Structured Query Language (SQL) for query writing