Full-Stack Developer | Ministry of Environment, Science, Technology & Innovation (MESTI), Ghana

Details

• Collaborated seamlessly with a multidisciplinary team of researchers and stakeholders to align technical development with research-driven requirements.
• Led the design and development of the entire application, including the MSSQL database, ensuring optimized schema design, query efficiency, and scalability.
• Designed and implemented a dynamic dimension management system for creating, categorizing, and managing STI-related data, including CSV data uploads, configurable templates, and approval workflows.
• Developed advanced data configuration features allowing users to define formulae, create indicators, and link them to STI initiatives.
• Integrated data visualization tools, generating detailed graphic and tabular reports exportable in multiple formats and viewable in various chart types.
• Enabled support for multi-currency data inputs with automatic exchange rate conversions to a set reporting currency, facilitating consistent financial reporting.
• Built a robust user management system with customizable access rights, privileges, and an audit trail to ensure security and transparency.
• Created a content management system (CMS) for managing articles, photo galleries, and other content displayed on the client's React-based public website through an API integration.
• Engineered a public interface featuring data cards and published indicators managed seamlessly from the backend.
• Authored a comprehensive user manual with detailed documentation and screenshots, enhancing usability and onboarding for non-technical users.
• Conducted training sessions for all stakeholders and provided a train-the-trainer program during the handholding phase to ensure smooth adoption and operational efficiency.

Technical Highlights

• Database Development: Designed and optimized the MSSQL database, including schema design, query optimization, and stored procedure creation for maximum efficiency.
• Full-Stack Development: Delivered an end-to-end solution, including the creation of APIs, backend logic, and the application's frontend interface using ASP.NET.
• Dynamic Dimension Management: Implemented a system for creating, categorizing, and managing STI-related data with configurable templates and approval workflows.
• Data Visualization: Integrated advanced visualization tools for generating detailed graphic and tabular reports in multiple formats.
• Multi-Currency Support: Enabled multi-currency data inputs with automatic exchange rate conversions for consistent financial reporting.

Outcome

Rescued a project delayed for several months, completing development on time and exceeding client expectations. Delivered a scalable, user-friendly system for managing STI data, enabling streamlined data analysis, reporting, and publishing. Enhanced client satisfaction and public access to STI indicators through seamless integration with the Ministry's React website.