Full-Stack Developer | Ministry of Finance, Ghana

Details

• Collaborated with key stakeholders, including Ministry staff and UNDP representatives, to align the application's functionality with financial reporting needs.
• Designed and implemented a robust back-end system for managing data uploads, segment definitions, ledger accounts, and budget versions.
• Developed dynamic dashboards and custom reports, enabling users to analyze Climate Finance data by various dimensions and drill into details through interactive data grids.
• Built features for uploading data via templates, ensuring seamless integration of data from CSV and TXT files into a structured database.
• Created a secure user management system with roles, menu access controls, and detailed audit trails for tracking data changes and user activities.
• Designed the front-end dashboards for easy visualization, with export options and tools for customization, including chart type selection, palette changes, and pivot functionality.
• Authored a comprehensive help manual integrated into the application to guide users on system navigation and functionality.
• Conducted extensive training sessions for stakeholders and delivered presentations to UNDP, ensuring all users were equipped to utilize the system effectively.

Technical Highlights

• Data Integration: Seamlessly integrated the application with the GIFMIS system to fetch and process ERP data for financial reporting.
• Database Optimization: Designed and optimized the MSSQL database, including schema design, query tuning, and stored procedure development to handle large datasets efficiently.
• Custom Reporting: Enabled multi-dimensional reporting with features for historical GDP analysis, budget version comparisons, and user-defined analytical dashboards.
• Content Management: Integrated a content management module for uploading and tagging multimedia content relevant to Climate Finance.

Outcome

Delivered a user-friendly system that transformed raw financial data into actionable insights, aiding decision-making for Climate Finance initiatives. Enhanced transparency and accountability by providing stakeholders with detailed dashboards and exportable reports. Received positive feedback from stakeholders and UNDP for delivering the project on time and exceeding expectations.