• Job Description

  Req#: 23-07982
  Job Description:
  Requirement:
  • CRM currently uses requirement location and service area to define where the requirement needs to be mitigated.
  • This needs to be refined and new data and fields added.
  Credit Service Area:
  • Currently, project assets have locations but do not have service areas.
  • CRM only stores the projects location.
  • The Pooled Credits pools use the location of the project to establish the credit pools de facto service area.
  • These credits may be used incorrectly if service areas are not properly defined.
  Service Area Fee versus Requirement Location:
  • Upgrade Refund Functionality.
  • The refund functionality needs to be streamlined.
  • When a refund is issued, either a negative revenue should be generated or a positive expenditure created.
  • Neither occurs currently in CRM and a manual entry is made.
  Credit Releases:
  • Currently, the credit release function can only be utilized after a credit release has been authorized.
  • The proposed credit release, credit release ledger, and debit forms are all maintained in separate Excel ledgers outside of CRM which need to change.
  • Cost Allocations to Service Area and mitigation type.
  • DMS assigns all program costs including administrative costs to mitigation types and geographic regions.
  • Currently, none of this information is stored in CRM or NCAS.
  • CRM assigns costs to projects, contracts, and funds/programs.
  • On multi-credit projects, CRM doesnt know how much of the costs are assigned to the different mitigation types.
  • These costs need to be assigned to a service area and broken down into mitigation types.
  Revenue Upgrade:
  • Currently, the revenue entity captures all revenue for DMS however, it is unconnected and unlinked with customer invoices and vendor refunds.
  RFP Entity:
  • Currently, RFP data and RFP results are tracked in an Excel spreadsheet. The data is needed to assess the need for RFPs to acquire mitigation credits. The data is also needed to describe how prices (both awarded and not awarded) have changed in the marketplace.
  Create STIP Entity:
  • The IMS TIP module and data were not migrated from IMS to CRM.
  • CRM has Projected Impacts as part of the Request module but there is no data available as the TIP entity was never created.
  STIP Module Upgrade for Mitigation Targeting:
  • When NCDOT submits mitigation orders to DMS, DMS tracks the mitigation order by TIP and categorizes it across three levels: forecasted projection, acceptance data, and permitted requirements.
  • Currently, CRM can only provide permitted requirements or unmet permitted requirements for forecasting.
  • Accepted data is not in a format where it could be used and projection data is not yet stored.
  Mitigation Target Tables:
  • Mitigation Target tables are highly desired as these values determine snapshot program needs by service area and time.
  • To create these, net assets, unmet requirements, and future requirements need to be known. Future requirements may be projection data, acceptance data, or requirements with a future due date.
  Sum and Calculated Fields:
  • CRM currently doesnt have many sum fields. Most of the data is entered in small pieces called lines.
  • The user relies on charts to sum up the data.
  • Unfortunately, charts only work when views have been added that allow the user to select the chart.
  • Data Validation / Data Cleaning
  Perform Data validation/screening:
  • Reports.
  • Various reports need to be created to extract data from the system.
  • Training and Project Documentation.
  • Training and documentation of the system are important as changes to the system have been and are progressing at a rapid pace.
  • DMS is requesting some training and documentation on the updates.

• About the company

  We are a team of technical visionaries who joined forces to form a company that would gather the best and brightest talent in the world. The company uses this talent to help other organizations fulfill their technological dreams and goals and make them a reality. Welcome to Cynet Systems Inc. – a premier staffing and recruiting company – a nationally and locally certified diversity firm.

Notice