About Me
RDBM/DBMS: SQL Server 2014/2012/2008R2/2008/2005/2000/7.0, MySql Server v5.x, Ms-Access
- Intermediate knowledge in MySQL 5.x
Database Tools: SQL Server Mana...
Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, Sql Developer, Toad for Oracle, Visual Studio .NET 2012/2010/2008/2005/2003, T-SQL, Data Transformation Services (DTS), OLAP,OLTP,DBCC
Reporting Tools: Crystal Reports versions 8.5,9,10 & 11, SQL Server Reporting Services, Ms-Excel, VB Data Reports and Ms-Access Reports, Micro Strategy, Power BI
Programming Languages: VB 6.0, VB.NET, C#.NET, ASP.NET, PL/SQL,T-SQL, HTML,VBA for Excel
- Fair knowledge in Java using NetBeans IDE 6.1, J#.NET & Borland C++
- Fair knowledge in Python
- Very Good understanding of XML
Operating System/Servers: Windows Server 2003 Enterprise/Windows XP, Windows Server Enterprise, Windows Server 2008 R2 Enterprise/Windows 7, Windows 9x/Windows 2000/Windows NT, IIS 5, 6
ETL Tools: Data Transformation Services (DTS), SQL Server Integration services (SSIS)
.Net Frameworks: .Net Frameworks 1.0/2.0/3.0/3.5/4.0/4.5
Advanced PC User: Strong capabilities with Microsoft Windows Platform, Microsoft Office Suite (Excel, Access, Word, Outlook, PowerPoint, FrontPage) and Windows DOS
Intermediate Ubuntu Linux User
Advanced knowledge of systems analysis & design
Ability to learn and easily understand any object-oriented programming language
Working knowledge of enterprise networks
Ability to setup a basic network
Show More
Skills
Portfolio Projects
Description
This project used an IBM WebSphere Client to connect to a message queue server in Sweden, the applicationpulls the messages in an XML file format, the XML files are dumped onto a server in Ghana. The data isthen extracted from the XML file and stored in an MS-SQL Database
Show More Show LessDescription
This project was built for the IT department to automatically receive user complaints via email, the administrator then automatically assigned the logged job to the relevant IT staff based on their skills setup. Once the issue is resolved the administrator sends an email back to the complainant and once the complainant is satisfied, the open ticket is closed.
Reports were generated in open, pending and closed tickets
Show More Show LessDescription
The main aim of this project was to create an application that collects and stores clients details, collects and stores their deposits on a daily basis, their daily deposits can then be withdrawn on a monthly basis. Various reports are also generated.
Basically this was a mini-micro finance project
Show More Show Less