Senior Reporting and Database Developer
United Nations Office for Project Services
مجموع سنوات الخبرة :19 years, 11 أشهر
The UNOPS ICT Unit become part of the Finance Group within UNOPS and is responsible for architecting, designing, delivering, and managing all UNOPS ICT infrastructure and business applications, undergoing a transformation from being a service provider to becoming a strategic business partner.
Responsibilities:
Analyzes UNOPS business processes and systems with a view to designing and developing reporting and analytics applications / functionality
Designs and implements reporting and analytics functionality within UNOPS business applications or within UNOPS reporting platform(s)
Performs technical review and testing of code for reporting and analytics applications / functionality
Embeds relevant knowledge management and innovation within the ICT Development function
Implement Store Procedures, Functions and Views SQL Server Transact-SQL
Design and implement Visualisation platforms (Power BI, Tableau, G suite)
Developing reporting and analytics applications / functionality within large and complex enterprise IT environments
Working on Unit4 Business World/Agresso workflow and security, Forms, Report Creator Tool, and Agresso Customisation Tool (ACT)
Design reporting solutions with structured and unstructured data relating to data integration, data flow, data warehouse, and business intelligence.
Performance tuning and scalability, and usability of reporting and analytics applications
Team member in UNOPS ICT Enterprise Reporting Team which is a unit responsible for the development, delivery and maintenance of organization-wide reporting information for internal use, external partner use and for public use. The team’s flagship product, the Workspace, is a platform for internal use integrated with ATLAS that incorporates information from all UNOPS practices and all data sources within UNOPS and presents the information using rich visualizations designed to aid understanding and action.
In Jan 2016 the organization replaced ATLAS with Unit4 Agresso, I was involved in the requirements gathering and reports and dashboards development in Finance, Procurement, Engagement/Project Management, Human Resource and Payroll, in addition to handling security and administration tasks related to Agresso.
Responsibilities:
Implement Store Procedures, Functions and Views using SQL Server Transact-SQL
Support the data warehouse ETL process
Provide technical and business support
Participate in design reviews of solutions with structured and unstructured data covering data integration, data flow, data warehouse, and business intelligence.
Conduct interviews with application stakeholders, facilitate data-modelling sessions, write
business and technical requirements, and apply standards and best practices.
Manage business and product owner relationships and enable their understanding and appreciation of technical possibilities and constraints.
Analyze existing databases and identify opportunities for data consolidation and design improvement.
Take responsibility for overall integrity, quality, accessibility and accuracy of information across multiple reporting applications.
Implement visualization component and features based on reporting elements through the Workspace infrastructure.
As a team member in the Department of Planning in Head Quarters-Amman, I’m the technical lead responsible for the Results-based Monitoring system which is a data warehouse solution facilitates the data collection process per log frame including Head Quarters and Fields Implementation plans for all Departments/Programmes at the agency wide level, with a set of predefined reports with ad-hoc reporting tool containing programmatic information across all programmes and is integrated with financial and human resources information. It is based on Microsoft SQL technology and designed using data warehousing programming methodology.
The RBM also comes with a tool to improve project management cycle for all active projects across the Agency, this functionality permitted identified focal points to monthly assess the expenditure rate and implementation progress of projects using a the same assessment technique used for indicators. The system, in collaboration with External Relations and Communications Department, was also updated with grant agreement data along with key reporting dates so that managers could easily access reporting dates for projects and the key documentation for those grants was also uploaded.
Also “Action Tracking” mechanism is lately presented in the RBM to assist in quarterly follow-up of agreed actions pertaining to a wide range of areas such as risk mitigation implementation, agreed evaluation recommendation and audit findings like JIU and UNBOA, respectively.
Responsibilities:
- Leading the Project Technical Resource Team of the RBM (Results Based Monitoring) Initiative to direct the development and provide technical operational support of the established, intranet-based, management portal.
- Working with technical specialties from ISD, ERP and programmatic areas lead the design and implementation and documentation of UNRWA data warehouse that is used for management reporting such as strategic plans, financial, human resource and project reporting.
- Designing and building web-based applications and the associated databases(s)/data warehouse(s)/datamart(s)/cubes/ETL(s) for capturing data using data capture sheet related to certain programmatic monthly reporting.
- Developing business reports and dashboards extracting and transforming data from the RBM system, an UNRWA data repository, using SQL server and associated BI tools.
- Working with external experts such as Microsoft Consulting Services and other non-technical specialties to ensure compliance with UNRWA's application development standards and management information needs.
- Facilitating the fine-tuning of the portal and associated contents as required.
Define Systems specifications for BI solutions, meeting with the clients and define the requirements, writing proposals, design and implement a complete BI solution using Microsoft technologies, analyzing and building performance monitoring dashboards with all required KPIs.
Senior Buisiness Intelligence, manage scope of work and define system specifications to fulfill business needs and clients requirements in order to achieve project goals and client satisfaction, manage and monitor team members and assign appropriate roles with the opportunity to follow up on tasks and monitor individuals or teams performance, Participate in pre-Sales activities, prepare Proposals and RFPs, provide complete BI consultancy for different kinds of businesses especially in Telco industry.
Main focus is SQL Server 2005/2008/2008R2 and Business Intelligence Technologies, including, Integration Services, Reporting Services, Analysis Service, and Performance Point, PowerPivot, ProClarity, MDX.
Projects:
• UNRWA RBM BI Project - Jordan
• Ministry Of Justice BI Project - Jordan
• Starcomms BI Project - Nigeria
• Multi-Links BI Project - Nigeria
• Vodafone BI Project - Ghana
• MTN BI Project- Liberia
• Royal Jordan Air Force BI implementation - Jordan
Work as a Software Engineer in Workflow Department, analyze, design, develop, implement and deploy workflow solutions and business process automation using Ultimus BPM Suite and Microsoft .NET Technology, Work with clients to customize a workflow process, develop custom code and scripts to meet the process automation requirements, implementing integration with third party software's using .NET
Projects:
• Ministry of Foreign Affairs - Jordan: Business processes automation and implementing workflow solution and database desktop and web applications with reporting services using .net 1.1
• Ministry of Presidential Affairs - UAE (Abu Dhabi): Business processes automation and implementing workflow solution for with couple of HR e-services presented on Ministry local intranet developed using .net Framework 2.0
• Jordan Institution for Standards & Metrology - Jordan: Implementing automated workflow processes (120 business processes).
• National Information Center - Sudan: Business process automation and implementing Workflow solution.
Work as a .Net developer to build and develop desktop and web applications.
ASP.NET
VB.NET
MSQL
Crystal Reports
Microsoft Certified Solution Developer using VB.NET