ServiceNow Developer W2 Candidate only

Job Description:

• Primary Tool: particularly focusing on tools like ServiceNow (Or equivalent) Software for asset management, process standardization, and dashboard development
• Database Tools: SQL, APIs, ETL Tools (e.g., Informatica, Talend)
• Visualization Tools: Recommended Software Reporting, Power BI (if external visualization is required)
• Form Tools: Recommended Software Form Builder or third-party digital form solutions
• Process Tools: BPMN (Business Process Model and Notation) or equivalent process-mapping tools "

Preferred Skills:

• Recommended Software Asset Management Expertise
• Experience in implementing and customizing Recommended Software (Example: ServiceNow) Asset Management modules.
• Knowledge of CMDB (Configuration Management Database) for asset tracking and integration.
• Proficiency in workflows, reporting, and automation.
• Recommended Software Dashboard Development
• Skills in building dynamic dashboards with data visualization features such as heat maps.
• Knowledge of integrating real-time data from external databases into software.
• Expertise in implementing drill-down menus and query-based search functionalities.
• Expertise in integrating Product Software with external databases like WebEOR, SEAM, and OSL via APIs, ETL tools, or data connectors.
• Proficiency in data cleaning, transformation, and consolidation from multiple sources.
• Skills in ensuring data integrity and consistency across systems.
• Strong knowledge of database systems, including SQL and non-SQL databases
• Experience with database integration and querying tools
• Expertise in using ETL (Extract, Transform, Load) tools to connect and process data between systems.
• Proficiency in ensuring real-time data synchronization. "

Day-to-day Responsibilities:

• Identify and recommend skilled professionals / teams

Targeted talent Proficiencies:

• Asset data integration, dashboard development, and workflow design.
• Tools such as ServiceNow, SQL, And ETL for real-time data management and integration.
• Standardization of processes and form redesign, ensuring compliance with USPS policies.

Training:

• Provide necessary support for training USPS staff and knowledge transfer as required

Data Integration:

• Collect, clean, and consolidate asset data from WebEOR, SEAM, and OSL databases.
• Ensure real-time synchronization of data for accurate and up-to-date asset tracking.

Dashboard Development:

o Design and implement a user-friendly dashboard featuring:

• Heat Map: Visualize asset distribution across the United States, with a legend for easy interpretation (e.g., regional asset density, color-coded by type).
• Query Search Function: Enable users to search for assets using keywords and apply filters.
• Drill-Down Menu: Allow users to refine searches by location, asset type, ownership, status, or other criteria.
• Interactive Selection: Include an interactive selection system (Buttons) to filter by asset type (MPE, Systems, ).
• Asset Detail Display: Once an asset type is selected the dashboard must display a detailed list of the selected assets and their relevant details.

o Include export and reporting functionality for analyzed data.

Dashboard Maintenance:

• Daily Maintenance: - Monitor data synchronization to ensure real-time updates are reflected accurately.

- Perform error checks and address discrepancies in asset data promptly.

- Verify system uptime and respond to any performance issues.