Job Description :
IDEALFORCE has a Contract position available immediately for a Technical Business Analyst to join our customer in Salt Lake City, UT. This position is like to move into a permanent position in the future. This is an ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Only applicants who can work in the United States are considered.

Job Requirement :

-Work with Client to implement the AssetWorks CPPM AiM 9.x application upgrades. (Upgrade to AiM 9.4 is in progress. AssetWorks releases 1 major release (9.x, 10.x, 11.x etc and 3 to 4 ‘dot’ releases per year
-Maintain, develop and modify BIRT reports and SQL queries for AssetWorks AiM upgrades as required over the course of the contract.
-Add reports in support of new modules added in implementation of new AiM releases over the course of the contract.
-Add reporting and analysis to support SUCCESS metrics and the new SUCCESS +/Cognos requirements. Includes TOC, Full Kit, Change Order Management, Workload Management, WIP and other SUCCESS initiatives not yet defined. (Project Manager Project Readiness in AiM)
-Convert existing BIRT AiM reports to allow them to run inside the AiM Framework.
-Work with DTS and AssetWorks to support Windows servers for AiM, AiM IQ, Pentaho, and BIRT over the course of the contract.
-Complete removing requirement for the UCWords function from all BIRT Reports.
-Assist with the implementation, training and development of the AiM IQ Business Intelligence Tools to support the SUCCESS initiative and the new Cognos reporting environment
-Prepare the Microsoft Access application ‘Supplier Rating Manager (SRM)’ for integration with the new Supplier Rating module in AiM 9.x by linking the existing Access tables to the AiM Oracle tables.
-Create the AiM IQ ETL (Extract/Transform/Load ) code to migrate SRM Data to the AiM Supplier Rating module.
-Create the AiM IQ ETL (Extract/Transform/Load ) code to migrate AiM Data to the Facilities Disaster Recovery Program (FDRP
-Create the AiM IQ ETL (Extract/Transform/Load ) code to synchronize FiNet and AiM Vendor contact information.
-Work with AssetWorks and DTS to resolve the issues with AiM 9.x, AiM IQ, the FiNet Interface and the Pentaho ETL tools.
-Design, test and implement a replacement process for the PowerBuilder FiNet to ISF Interface. Work with DTS to create a new application to support the CBA Budget
process that extracts data from the Sybase Data Warehouse, integrates with AiM Oracle tables and is used to provide ISF Budget reporting.
-Work with AssetWorks to synchronize the Risk Property database with the AiM Buildings database.
-Work with AssetWorks to move UDF (User Defined Fields) data to new core columns in the AiM database.
-Create dashboards in support of the SUCCESS initiative using AiM IQ, BIRT Analytics and Cognos
-Convert the MS Access FDRP application to a standalone ‘run time’ application for deploying to laptops without an Office Professional License requirement.
-Provide updates, modifications, and additional functionality as required by the change.
-Design, develop, and implements processes and reporting to support the new TOC Full Kit approach to Project Management.
-Work with Goldratt Consulting to design, develop and implement new functionality and reporting as they develop new processes for Development, Improvement, Real Estate, ISF Budgeting and Maintenance groups.
-Provide updates, modifications, and additional functionality as required by the change in leadership of client''s Maintenance group.
-Provide support for AiM, AiM IQ, BIRT, PowerBuilder, Pentaho, DataParse, SQL, Javascript, PHP, SUCCESS Plus, Cognos and other issues as they occur in normal business operations.
-Analyze and resolve new program and process issues as they occur in day to day processing. Document the resolution and review both the resolution and the analysis process with the assigned FTE.

Additional Information :
- "All your information will be kept confidential according to EEO guidelines".
- All candidates who are authorized to work in US are encouraged to apply.
- Candidate should clear the Background check prior to commencing the assignment.


Email your candidate/s resume to joseph dot shelton at along with the following details: Rate, Current location and Availability

Disclaimer : The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.