Personal Details
Visa / WP held :Working
Holiday Maker Visa E-mail :
Nationality :Kenyan
Other :
Location :
Mobile :
Date of Birth :4th
January 1980 Post Code :
Education & Qualifications
2006
BSc
(Hons) Computing and Information Systems awarded by London
Metropolitan Univ.
2004 International Advanced Diploma in Computer
Studies accredited by NCC
1999
International Diploma in Computer Studies (IDCS) accredited by
NCC
2001 MCP , MCSD
Profile
Software Developer with almost 4 years building medical
applications for Insurance firms managing healthcare using
Visual Basic 6.0, SQL 7.0, Crystal Reports 8.0.With
most recent experience developing with VB.NET, SQL
2005, Crystal Reports 10.0 on .NET platform. Worked
on product migration and enhancements for medical insurance
solutions. Experience of SDLC which has included gathering
business requirements through to implementation and training,
with full knowledge of OO methodology using the Unified Process.
Seeks contract work being immediately
available for both interviews and starts for most locations
within the U.K. having recently arrived from South Africa.
Technical Skill Summary:
Operating systems:
Windows Server 2003, Win XP, Windows Server 2000, Win NT.
Languages:
VB.NET, VB 6.0, ASP, HTML, VBScript, T-SQL
Databases:
SQL Server 2005/2000/7.0
Database Objects:
OLE DB,
ADO, DCOM, COM+ , MDAC
Network Connectivity:
HTTP,TCP/IP
Software:
Visual Studio 2005,Crystal Reports 10/8, Visio, Ms Word, Ms
Excel, Ms Access, Ms Project, UML, IIS
References available on request
EMPLOYMENT HISTORY
Mar
2007 – Jul 2007
[snip], Kenya.
[snip] are a software house whose niche is in providing
business driven solutions for the Insurance Sector.
Software Developer / Team Leader
Contracted to oversee the migration of existing application
developed in VB 6.0 to .NET platform. A bespoke ERP software for
[snip],a service driven Insurance Company.
The
product was comprised of the following core modules;
Security Module
Was solely responsible developing a security module whose
specifications was that it should be role based, that users and
their respective user role be defined and that permissions be
mapped to the relevant user. My tasks was as follows;
-
Translate Gap Analysis document and produce Technical
Workflow Process showing the logical flow of the Business
process.
-
Design and construct the respective tables to hold the
information of users, users groups and permissions. Using
SQL Server 2005 running on Windows Server 2003 SP1.
-
Construct stored procedures using T-SQL to perform INSERT,
SELECT, UPDATE, DELETE functions within the Data Access
Layer (DAL). Using SQL Server 2005 running on Windows Server
2003 SP1
-
Construct methods within the middle–tier to channed calls
from the Front-end to the database and be able to
intelligently know which users had been given what level of
access permissions in the system .Using VB.NET, .NET 2.0
Framework, COM+,ADO
-
Designed user friendly forms and produce code to enable the
administrator to define the roles, capture user profiles and
map the respective roles to the users of the system. Using
VB6.0,VB.NET
CRM Module
An
already existing module i was responsible in upgrading and
integrating functionality to capture debtors information. My
tasks were as follows.
-
Translate the Gap Analysis document and producing a
Technical Workflow Process showing the logical flow of the
Business process. Using OO methodology Use Cases and UML.
-
Lead a team of 3 to migrate the entire module to .NET and
bug testing. Using VB.NET,.NET Framework 2.0,SQL Server
2005, Windows 2003 Service SP1
-
Design and construct the respective tables to hold the
debtor information. Using SQL Server 2005 running on Windows
Server 2003 SP1.
·
Construct
stored procedures using T-SQL with joins to enable debtors to be
captured. Using SQL Server 2005
-
Produce code for methods
within the middle–tier to channed calls from the Front-end
to the database and be able to intelligently prompt the user
to define debtor depending with the specific business
rule.Using VB.NET, .NET 2.0 Framework, COM+,ADO
-
Design the user friendly
forms to promp the user to capture the debtors using VB.NET
Medical Module
An
already existing module written in VB 6.0.This being a very core
module where claims were captured and validated and authorised
against the individual member balance. My tasks were as follows;
-
Translate the Gap Analysis document and producing with a
Migration Plan as to how this was to be achieved.
-
Lead a team of 3 to migrate the entire module to .NET and
bug testing. Using VB.NET,.NET Framework 2.0,SQL Server
2005, Windows 2003 Service SP1
-
Optimise Queries, Cursors and User Functions to enhance the
overall performance of the module Using SQL Server 2005
-
Redesign the visual basic forms to enhance the look and feel
of the module and make it more user friendly. Using VB.NET,
VB6.0
-
Make adjustment within the middle- tier component of the
module to cater for changes of business rules as to how
claims are captured and validated. Using VB.NET, COM +, ADO
-
Redesign the reports to cater for customization changes as
specified in the Gap Analysis Document. Using Crystal
Reports 10.0
Financial
Management Module
A
brand new requirement needed by the client, I was solely
responsible in coming up with the critical module that would
enable the Client to monitor financial transactions. My tasks
were as follows;
-
Gather requirements from the Client and translate this to a
Technical Workflow Process showing the logical flow of the
business process. Using OO Methodology Use Cases and UML.
-
Design and construct database tables as part of the Data
Access Layer.Using SQL Server 2005 , Windows 2003 Service
SP1
-
Construct stored procedures using T-SQL for data
manipulation within the database. Using SQL Server 2005 ,
Windows 2003 Service SP1
-
Delink this module from medical while at the same time
intergrating the cheque printing functionality within FMS
that was originally part of the medical module.This was a
complex task as the architectural design had to be reviewed
and logic separated in the middle tier where business rules
resided. Using VB.NET, .NET Framework 2.0 , ADO
-
Design menu items and user friendly forms for the Client to
pass required input parameters. Using VB.NET
-
Designing up reports such as debtor statements and cashbook
to enable the Finance Departments be able to monitor
transactions. Using Crytal Reports 10.0
-
Provided End User Training to the Finance Departments
through walkthroughs and PowerPoint Presentations.
Achievements:
-
The Financial Management System has enabled the Client to be
able to monitor transactions in such a way that payments are
authorised within the medical module and debtors assigned.
This has made it very easy for Finance to quickly generate
reports upon payment of cheques.
Technical
snapshot:
VB.NET, COM+, Enterprise Services, Crystal Reports 10.0, SQL
2005, Windows Server 2003, .NET Framework 2.0,ADO, MDAC
2005 – 2006
Sabbatical - Full time varsity studying for BSc before returning
to work for [snip].
Aug
2001 – Dec 2004
[snip], Kenya.
Part
of a 4 man team involved designing, implementing and maintaining
a highly complex medical solution for [snip, a service
driven organization with a global presence.
A 3
tier medical application with a SQL Server backend, the middle
tier involved COM+ components running on Component Services when
using Windows 2000 Server or Higher. The frontend was designed
using Visual Basic 6.0 and ASP
My
duties and responsibilities were as follows,
Client Server Application.
·
Gather requirements from the Client and translate the business
gap analysis document into a Technical Workflow Process showing
the logical flow of the business process. Using SSADM
methodology and flowcharts to illustrate business flow
·
Design and construct database tables and generate table schemas
as part of the Data Access Layer. Using SQL Server 7.0/2000 ,
Windows NT
·
Construct stored procedures using T-SQL to perform INSERT,
SELECT, UPDATE, DELETE functions to be able to allow user to
input, save as well as retrieve data. Using SQL Server 7.0/2000
running on Windows NT.
·
Responsible in optimising the database using indexes using SQL
Server 7.0/2000
·
Worked on a section of the middle-tier that holds the logic of
the software. This logic was made up classes and global modules
using VB6.0, COM,MTS
·
Designed and coded user friendly forms for purposes of data
capture of claim and CRM information. Using VB6.0
·
Was
solely responsible in coming up with dynamic reports for the
entire application. This included Statistical reports, Member
balance statements, Audit reports using Crystal Reports 8.0.
·
Was
solely responsible in integrating excel functionality into the
application for importation of member and claims information
VB6.0 , MsExcel.
·
Provided End User Training through PowerPoint presentations and
one-to-one walkthroughs. Using Ms PowerPoint.
Web Module
·
Was
partly responsible in designing and producing code for the
middle-tier using IIS,Webservices,VB6.0
Achievements:
·
The
Client has increased its business revenue significantly over the
years as the solution has enabled it to accommodate high net
worth portfolio of clients.
Technical snapshot:
VB 6.0, COM, Crystal 8.0, SQL 7.0, 2000, MTS, OLE DB, WIN NT,
HTML, ASP, VBScript, IIS, Ms Excel
|
