Data Architect
S4D Consulting LLC
Total years of experience :9 years, 11 Months
-Design of a Enterprise Data Architecture for the Ministry of Health(MOH) in Ghana and the Ghana Health Services(GHS)
-Business requirements analysis
-Design of the Conceptual and Logical data architectures
Tools used: Excel, Oracle Data Modeler, Drawio, Trelo
-Design and development of the Enterprise Data Warehouse(EDW) Conceptual, Logical/ERD and Multi-dimensional data models for the Staging, Operational Data Store(ODS) and main Data Warehouse respectfully to facilitate data analysis for the One Equity bank platform
-Data clean and organization for the Core Banking System(Finacle) and the numerous channels data in the EDW
-Data Quality Management
-Design and development of reports on OBIEE and Power BI
-Project effort coordination within my team and with other teams
-Stakeholder engagement
-Development of ELT data pipelines on ODI 12c
-Business requirements analysis
-Level 1 support to business users on BI and Data Engineering tickets
-Delivery of various projects including Anti-Money Laundering(AML) monitoring, Risk Management report, operational and analytical reports, KPI reports among others
Tools used: Oracle Database 11g and 12c, ODI 12c, OBIEE 12c, Power BI(Desktop and Web), Shell scripts, Azure SQL Database, SQL, PL-SQL, T-SQL, Python, Oracle Data Modeler, Jira
-Data integration from a number of the organization's systems to data warehouses and data marts.
-Data modelling and cube design.
-Data visualization and reporting.
-Data cleanup and organization.
-BI user support to users in 118 countries.
-Maintenance of a complex BI infrastructure
Tools used: Microsoft BI stack(Excel, SSIS, SSAS, SSRS, Power Query, Power Pivot, Power View, Power BI, Azure Virtual Machines, Azure SQL Database, Git, Jira, Agile DevOps
• Working closely with non-technical staff, to translate and negotiate non-technical requirements into a detailed technical specification
• Continuously developing the company B.I road map
• Building metadata repositories
• Working with a team in developing BI solutions for the different lines of business(Life, Medical, General and Pensions)
• Oracle BI User Administration
• Implement and manage a large-scale BI infrastructure
• Coordinate efforts between the BI developers, System Analysts, Business Analyst and DBAs in implementing BI solutions
• Research and development
• Translating business needs into technical specifications
• Continuously assess and document data quality
• Training of trainers
Tools used: Oracle Database 11g and 12c, ODI 12c, OBIEE 12c, Power BI(Desktop and Web), Shell scripts, Azure SQL Database, SQL, PL-SQL, T-SQL, Python, Oracle Data Modeler, Jira
•Core duties here are requirement collection from business departments, analysis, reports design, data mining, data integration, data warehousing, data analytics and reporting/visualization.
•Migration of reports from other technologies/applications to Oracle BI Publisher.
•ETLs for data migration in the InCMS system upgrade project
•Data mining, integration and warehousing
•Team management
•Reports development for Design and Construction System(DCS), Customer Management System(CMS) and Facilities Database System(FDB).
•Onsite requirements collection and analysis and documentation
•Data Clean up
•Software development, testing, implementation support and maintenance
•Reports development for ERP systems
•Onsite requirements collection and analysis and documentation
•Batch processing and systems automation
•Carrying out unit and system tests and subsequent implementation of new features
•Systems documentation
•Training of Trainers
• Data cleanup and analysis
• Integration of Cellulant mobile wallet, USSD services and Mobiles apps
• Troubleshooting and error fixing on interfaces with MNOs, Merchants and Banks
• User training
• Use Oracle Business intelligence (BI) technology to create Statistical reports that are used by the management to monitor progress of various departments in an organization
• Software analysis, code analysis, software review, identification of code metrics, system risk analysis, software reliability analysis
• Design, Develop and Install developed components that meet the business needs
• Perform integration of new applications with the existing systems
• Performing extensive tests on the software during the time of its development and making necessary changes to the code whenever necessary, and then reporting results
• Work closely with the IT department to ensure the application is efficient and user data is secure
• Design and implement applications databases
• Using sound and smart programming techniques to import user data contained in Excel sheets into the system using JAVA, SQL, PL/SQL, and Oracle database, to enable the processing of this data into useful information.
Development POS application on Win CE device (iwp 250) using C#.
mplementation Till integration solution.-Implement and support backend and frontend Microinvest software system for both retail shops and restaurants
Implement Smartvista (SVFE, SVBO and SVCG) bank switch used to handle transactions from POS and ATM devices and also for card generation purpose