Colin Sillaman - FTP Directory Listing

climbmoujeanteaSoftware and s/w Development

Dec 13, 2013 (3 years and 8 months ago)

113 views






Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748




Colin Sillaman


Summary of Qualifications


Mr. Colin Sillaman is a seasoned web developer with deep and broad experience in
.Net

as well as other
Microsoft development and database technologies. He has extensive experience with
SQL Server 2008
R2

inclu
ding
SSIS Packages
,
SSRS
,
SQL
Role Provider, .NET MVC Framework, web services,
AJAX

and other relevant technologies including particularly strong mid
-
tier and operating system
knowledge. Mr Sillaman holds several Microsoft development certifications and
in his most recent
assignment
s

developed a front
-
end for FDA regulatory reporting

for
Blue Cross Blue Shield

and for
Pfizer
.


Professional Experience


April to

Blue Cross Blue Shield (Willmington, DE)

Present

.Net Developer/SQL DBA

C#, MVC, ASP.NET, SQL Se
rver, SQL Report Services, SSIS, Telerik.
Architect/Developer for the development of a federally mandated Summary of Benefits
and Coverage web portal and report of plan benefits to customers. The Blue Cross Blue
Shield solution involves the extraction of e
xisting caba data from the mainframe,
processing of that data in SQL Server via multiple look
-
ups, functions and manipulations,
presentation in the web portal with further logic processing, fund benefit calculations via
migrated logic from Federal Governme
nts Fund Calculator (xls to sql) providing for a legal
Safe Harbor. The generation of a final report based on a full amalgamation of changes
and calculations as enhanced by the portal before emailing and providing printed reports
of a plan benefit to custo
mers.


12/11 to

ANEXINET (REED Technologies, PA)


03/12

.NET Developer

C#, ASP.NET, AJAX, Telerik Web Controls, CSS and javascript, custom control interfaces
in a web
-
part sharepoint 2010 solution providing for a conversion of manual operations to
a sharep
oint 2010 workflow data and document collection system for Reed’s clients
specifically Pfizer. The system provided for a front
-
end collection point of product data in
accordance with FDA regulations for submission and approval processing. Sharepoint
2010 .
NET, XMLDocument repository system backend using Mark Logic integrating
Telerik and Ajax for front
-
end customs web part controls within the sharepoint 2010
solution. I developed all the core classes, dal layers and server routines which provided
for serial
ization and de
-
serialization of XML Data which included complex hierarchical
classes, security layers, xmltextreader layers, custom front
-
end web
-
part forms and
controls, handled most integration issues. As the whole repository was a collection of XML
Docu
ments features included dynamic data fetches of xml lookup data of FDA lists based
on keywords entered by user, values in drop down list representing either urls to other
data paths and dynamic behind form calls, web services and components etc.


12/10 to

JUDGE CONSULTING GROUP (CHOP / TOLL Brothers / TRION, PA)


10/11


.NET Developer

CHOP

-

Developed front end portal in C#, ASP.NET, javascript, CSS and Ajax integrating
with Magic Ordering System via web services and SQL Server. Solution provided a





Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748

replace
ment to paper based equipment ordering for all hospital staff, workflow and
approvals system. SQL Server 2008 R2 used my role included the creation of all stored
procedures, queries, performance and query optimization as well as the development of
all fron
t end components.

Toll Brothers



C#,ASP.NET and Ajax System providing for a Product Catalogue and
Community Catalogue System provided a replacement for paper based management of
product and community options available for sales in communities and offerin
gs of models
and elevations sold. The options linked to those with full details of prices, features and
notes. Toll Brothers is a national builder with offices and communities throughout the
country. Features included approvals and workflow, version manag
ement and phase out
controls at all component levels. My role included the creation of objects and components,
stored procedures performing complicated inserts, updates and joins across multiple
tables, index enhancement and query optimization.

Trion


C#,

WCF Biztalk EDI solution integration of WCF’s handling business rules and
validations; following SOA patterns with the Biztalk environment space. SMAT a MVC
front end solution providing a custom interface for Transformation design, SQL Server as
both stag
ing and target database. All components leveraged injection using Castle within
the Microsoft Framework, data access points made extensive use of the Entity
Framework. All database activity was performed via stored procedures and queries with
emphasis on p
erformance tuning.


06/09 to

COMSYS (TECHNOTECTS/WEST PHARMACEUTICAL, PA)

12/10


.NET Architect / Developer

C#, ASP.NET, Ajax, Telerik Controls solution providing for a web based cemetery office
management system. Point

to
-
point business solution tracking
everything from sales
leads, burials, client placement and genealogy. This is a ground up development
encompassing all elements of the business


in scheduling, grounds maintenance, stock
and inventory, sales leads and conversion, legal deed management, do
cument
management etc. Mapping layers will include


Google earth, bing, and custom map
rendering etc. Technology is c#, asp.net, ajax, telerik controls, report services, SQL 2008
r2, .net framework 4.0. System supports multiple security entry points, full

crud operation
and controls. Tasks included conceptual data models, process flows and sequence
diagrams. Cost estimates and full implementation to a marketable solution. SQL Server
tasks included the creation of proc generators, views, and custom stored p
rocedures.


06/09 to

WEST PHARMACEUTICAL, PA

07/10


.NET Architect / Developer

VB.NET, Ajax, ASP.NET solution re
-
architecting and engineering of West’s centralized
Security Management System original system was a database driven environment with
distribute
d db’s running the various floor manufacturing software systems. A new portal
was developed using asp.net and Ajax, backend database was enhanced and re
-
factored
to support ADSI & Active Directory Authentication. Database was centralized using a
custom rep
lication layer. Generic auditing was introduced at the database level.
Technology leveraged includes ADSI, CLR objects, web services, report services, Ajax
and ASP.Net. New .net developments in web and forms based products as a part of the
Kearny upgrade.
Other activities include report services, generic data management
layers, replication, development of generic auditing, active directory global updates,
asp.net & win. Form development, QA, test and validation documentation, functional





Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748

specification docume
ntation and data migrations using SSIS packages for plant upgrades.
Tasks included conceptual data models. Cost & time estimates and full implementation.



06/08 to

ALLIANCE GLOBAL SERVICES

05/09



(
OHANA SEARS REBATE SYSTEM, DE / EPITOME SYSTEMS, PA)




.
NET Architect / Developer

C#, ASP.Net, Ajax, Sql Server my roles included architect, offshore lead, specification
design and implementation. Design architect & code for the core qualification layers which
processed rebates from receipts entered matched tra
nsactions and provide for a rebate
award based on extensive rule sets. Development consisted of the portal .net c#, SQL
server rules engine for rebate awards, ssis packages importing transaction data and
integration of the data within the central repositor
y. The rules engine had to deal with a
vldb receiving a million transactions a day; spanning offers and purchases over extensive
periods there was significant use of partitions and index tuning and optimization.



07/06 to

EPITOME SYSTEMS, PA

06/08


.NET T
eam Lead /Developer

VB.NET, ASP.Net, Ajax & Infragistics solution where I ran offshore and onshore
development teams totaling a maximum of 15 developers. Focus was UI and Core
Architecture for EDM and BPM interface. Role included specifications, write
-
ups
for
offshore, daily scrums, development, coding, team lead, management and delivery
reviews of software leveraging .Net, Ajax, SQL Server, Izenda Reporting, included
significant use of Infragistics throughout the system. This tool is now being used for the

State of Delaware project. Tasks included conceptual data models, process flows and
sequence diagrams. Cost estimates and full implementation to a marketable solution.


2002 to

CONTRACT TRAINER

05/06

MCT Trainer
-

.NET / SQL Server / Navision / MS CRM /
Windows / Solomon / Great

P
lains

As a contract trainer would teach a variety of classes:



.net development core framework, Winforms and asp.net in both C# and VB.net



.net extensibility for Navision, Solomon and Microsoft CRM.



Windows 2003



Biztalk.



Commerc
e Server.



Navision



MS CRM



MS SQL Server


2002 to

YSMOS LLC & YSMOS SDN. BHD

05/06


Owner / Business Development / Architect / Business Analyst /
Developer

Concurrent with all other activities.

Architecture & Business Solutions design & Contract Training, B
usiness Development,
Project Management.

Developments included:



ASP.NET / SQL Server / SQL Server Reporting Services






Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748



Carrier Compliance
-
Transportation Solutions Genpro Inc. N.J.



Reporting & Management Tools SQL Server Reporting Services


Genpro Inc. N.J
.



Public Portal
-

Genpro Inc. N.J.



Work Flow A&P Claims Management


Genpro Inc. NJ.



Claims Management


Genpro Inc. NJ.



Membership System & Event Management System


Eastern Produce Council



Workflow & Process Development (Environmental Sampling)


KAM Con
sulting
Services.



Enterprise CMS & HRMS System


YSMOS Retail Product Solutions.



Training Web Portal Solution


Etek Training.



Subscription / E
-
Commerce Systems.



Workflow & Work Process Development.



SQL Server Replication Check Cashing Chain


TellerMetrix
.



Database reconstruction for Department of Home Land Security.


Contract Training Etek Training (.NET C#/VB, SQL Server, Great Plains, Solomon,
ASP.NET, .NET Compact Framework, SQL Server Reporting Services, SQL Server OLAP
(SQL Analysis Services), MDX)


Consulting Services provided to Genpro NJ Inc., Department of Home Land Security,
Merrill Lynch.



Establish YSMOS L.L.C. July 2003



Fairleigh Dickinson Paramus N.J. Computer Training .NET Development



November 2002 arrived US from Malaysia.


2002/01

YSMOS SDN
. BHD

Architect / Lead Developer

-

Contract Architect & Solution Development Microsoft
Asia/Pacific Region.

Architect / Lead Developer
-

SPR, MRCB.

Gap Analysis of Microsoft Premier Customers in South East Aisa. Hong Kong Jockey
Club, E
-
Genting, SPR, OOCL

P
resentations SQL Server 2000 in the Enterprise Philippines.

Training Delivery for MS Malaysia SQL Server, OLAP (SQL Analysis Services), VB /
COM+ Enterprise Development.

VB.NET, ASP.NET, Web Services Training Material.

Onyx Review at RHB for Microsoft. Tra
ining for RHB Data Warehouse & SQL Server.
Training to RHB personnel through Microsoft in Analysis Server and SQL Server.


1998/07 to

VICTORIAN ELECTORAL COMMISSION

2002/01

Architect / Lead Developer


Designed and wrote custom replication for 70 SQL Server
s.



Designed, built and manage the Replication mechanisms which supplied data from 54
Distributed SQL Server Databases to the TallyRoom & Web Server for the State
Election and Municipal Elections. This included a new Model, which was more suited
to the busi
ness offering greater flexibility, administrator control, tracking and reliability.
The nature of the business required dynamic control of tables replicated, tracking of
the data at all stages, re
-
distribution of table sets based on ranges of a day’s activ
ity
or date ranges, and re
-
issuing of a remote site's data via the replication mechanisms.





Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748

Whilst maintaining data versions, transaction integrity and performing fundamental
conflict resolution, and disaster recovery switch over.



Built both the Client Inst
allation Routines and Middle Tier Transaction Server auto
installs used to set up all layers of the application, Active
-
X registration, ADO, ODBC,
and Registry and auto install of Transaction Server Packages. At the Middle Tier auto
registration of all Bus
iness Objects (approximately 200) including security, transaction
states, Package headings and auto generation of those packages this has now been
extended to include COM+.



Establish environment controls and procedures.



Develop Business procedure tests
and software tests to review planned
implementations.



Capacity plan and control for databases (production, acceptance testing,
development, and stress servers).



Co
-
ordination of System Administration.



Develop and further enhance utilities to aid in the dep
loyment of VEC’s distributed
environment.



Design and support the Control Configuration Management targeted at utilities for
remote deployment of data and databases throughout the distributed environment.



Provide technical advice and risk assessment on oper
ational and replication functions
in conducting Municipal and State Elections.



Initiate and develop archiving development activities.



Developed prototype standards and models using COM+, Active Directory and SQL
2000 in an effort to establish dynamic Datab
ase switching from the Middle
-
Tier. This
involved extending the Active Directory User Class and Computer Class, building
routines in VB, which read those attributes and passed them to the Middle
-
tier to
enforce dynamic data switching. This included dynamic

generation of SQL Procedures
and Database Standards.


1998/02 to

CONSULTING / DEVELOPMENT / TRAINING

1998/07


Consulting had been both as an independent and under the umbrella of Aspect, this work
has often been in the space of Application Design and Deve
lopment, XML and SQL
Server.



Servier Laboratories
-

Sales Rep and Drug Purchases conversion of OLTP Database
to a Data Warehouse.



ANZ Bank Loan and Product Analysis


Development

Contract Development for Praxa included the Sony In
-
Flight System, TAFE Online

Education System.



E
-
Cat Authoring Tool (This was a medium term project designed to establish a
beachhead for Praxa in the E
-
Commerce Space. It integrated technologies such as
SQL Server, VB, Microsoft SiteServer
-

ECommerce, Telstra’s Surelink. In essence

a
VB client allowed a non
-
web based author to create and construct a working Web Site
on their client. Viewing of the Client Side Web was done via the App making use of the
Explorer Control


this made it independent of any local Web Services. When happy
with their work they would dial their E
-
Commerce Provider pay for the establishment of
the site via Surelink and a full Data
-
driven E
-
Commerce Site was built on the Server
including the Database. This authoring tool was demonstrated to Microsoft as an
exam
ple of functionality that could be achieved, Telstra, and various other ISP’s.
Telstra has bought full ownership of the code and concept).






Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748



Sony In
-
flight System (This is a Web based system developed for Sony by Praxa


and bought by South African Airlines
as a running in
-
flight system. From this system
passengers can select movies, pay as they go, perform duty free shopping, play
online games with other passengers etc.. Technologies incorporated SQL Server,
Netshow Theater Server/Player, VB Active X, Dynami
c HTML, Internet Explorer , E
-
Commerce for on
-
line shopping).



Developer Days Office 2000 1998 (Whilst at Praxa I presented at the Microsoft
Developer Days Lectures on Office 2000 (Beta 2) Melbourne, Sydney, Brisbane).



Contract Training I have provided my s
ervices to Aspect, Spherion, IT&T, Accord,
Auldhouse and Educom. As an MCT Curriculum has included all Windows 2000 & NT
streams, Development Visual Basic & Visual Interdev, Site Server E
-
Commerce, Site
Server, SQL Server 7.0 & SQL Server 2000, IIS, and XM
L. Biztalk 2000, E
-
Commerce
2000. My evaluations have consistently been excellent to good.


1997/01 to

GLOBAL KNOWLEDGE NETWORK

-
Melbourne, Australia

1998/02

Consultant /Lead Instructor

Taught full range of NT Courses, and Development Courses (Visual Studi
o 6.0) , SQL
Server

Since joining Global Knowledge Network in August 1997 I had been actively developing
Courseware, providing Training on Microsoft Official Curriculum (in topic areas as
Currently teaching VB 5.0 Fundamentals & Advanced, Web Development u
sing Active
Server Pages, Visual Java, SQL Administration, SQL Implementation of a Database
Design, SQL Performance Tuning Optimization, NT Core Technologies, NT
Administration, NT Enterprise). Consulting & Strategy overviews of Transaction Server &
Web ba
sed solutions. Built and performed two Technical Seminars to an audience in
Melbourne & Sydney on Internet Technology using ActiveX Controls, ActiveX Code
components, MS SQL Server and Transaction Server. Reviews of both Seminars were
listed as excellent.

Marketing of Courses and creating Advertisements for Marketing Personnel.

Appeared in Australian Business Review under Movers & Shakers Oct. 21st 1997, PC
Week People on the Move Oct. 24th 1997.



1992/03 to

MICROSOFT APAC REGION

-
Sydney, Australia

1997/0
1

Lecturer / Consultant


Consulting for Large Corporate Clients.



Travel throughout Australia & South
-
East Asia Training Trainers, Solution Providers
and large Corporate Customers in the above products.



Present at Large Conferences Technical & Sales, Micro
soft Strategies, Software and
Innovations.

Products included SQL Server, Visual Basic, NT 4.0

Countries of responsibility included Australia, New Zealand, Singapore, Malaysia,
Thailand, Vietnam, and Philippines.

Microsoft APAC (Asia Pacific) Regional Hea
d Office. Lecturer / Consultant.

Lead MS SQLServer, Active Server Technologies, Visual Java,

MSAccess, Visual FoxPro.


Subject Range of Lecture :
-



NT 4.0 Core, NT 4.0 Enterprise, NT Administration, MS SQLServer Admin, MS
SQLServer Implementation, VB 5.0, V
isual Java, MSAccess, MS Visual FoxPro.
Active Server, Transaction Server, Merchant Server.






Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748



As a Lecturer for Microsoft APAC (Asia Pacific) Regional Head Office. Had trained in
every country throughout South East Asia Region. The Region consists of Austral
ia,
New Zealand, Singapore, Indonesia, Malaysia, Thailand, and Vietnam offering
courses in NT 4.0, SQL Server, Visual Java, Active Server Technologies including
Transaction Server, IIS 3.0, Merchant Server, Visual FoxPro, VB 5.0 & Access. The
standard cou
rse is a weeks training which is in
-
depth and too advanced technical
audiences.



Had been a key presenter at a number of conferences local and overseas. These
include the Microsoft Global Summit in Toronto where my talks focused on ODBC,
DMO & DRA. Bond Un
iversity for the Australian Education Conference, and various
presentations throughout South East Asia on SQL Server & Client Server Strategies.
Including large Banks & Corporate Customers.



Joined Microsoft in 1992 as a Contract Employee working in the Pro
duct Support Area
focusing on MS
-
Access, FoxPro & SQL Server. Then became the lead for all ODBC
support issues for all of South East Asia.



In 1994 I was recruited by the Microsoft Institute as a Lecturer and lead for two of their
Development Products sinc
e then the role has expanded to MS SQL Server, NT 4.0,
Active Server Technology including Merchant & Transaction Servers, Visual Java,
Access, FoxPro.



As the lead for a product group I was responsible for quality of training material and
give final approv
al before it is released to the channel. Dealt directly with the course
creators in the States and beta tested the training material and sent my
recommendations back to the USA in regard to changes and enhancements.



Had worked on the Self
-
paced trainer C
D
-

'Mastering Visual FoxPro'
-

the first of the
Mastering series CD's at Redmond SA.



Had presented three sessions at the Microsoft Global Summit in Toronto on ODBC /
SQL Server to System Engineers from around the world.



Had presented at the Education Foru
m at Bond University two sessions on Windows
95 in the classroom and one session on BackOffice in the High School and
Universities infrastructure.



Was the first to teach SQL Server in Indonesia which added credibility of our ATEC's
efforts there to win a l
arge SQL / VB solution in their Justice Dept.



Was the first to run a SQL Course in Vietnam (Hanoi), Philippines & Indonesia.



Was doing Consulting for MCS here in Australia for large Corporate like Pacific Power,
Commonwealth Bank, Westpac. (NT, SQL Server,

& Internet Solutions).



Designed the evaluation model that has been adopted by Microsoft & the ATEC's for
evaluating a Trainers performance in Class for Microsoft’s new auditing model.



Was the first to run the SQL Internals course for our APAC Product Supp
ort personnel
in Australia.


Technical Skills

C#,
ASP.NET, WCF, MVC,

Visual Basic,
VB .NET, Java, ASP
, COM+, Excellent XML, Good
SOAP
,
XSLT, Visual Studio Team,

Biztalk Server, MS CRM Customization, Navision Customization, Solomon
Customization,
SQL Report
ing Services
,
OLAP (SQL Analysis Services
) Development, Commerce
Server, Excellent Database Skills,
SQL Server OLTP and OLAP (SQL Analysis Services), SQL
Server

Notification Services, SQL Reporting Services,
SSIS Packages, SQL Role Provider
, strong
Middle
Tier, Web Services, Strong Operating System, Windows 2008, 2003, 2000, XP, Win 7.


Documentation Skills

UML’s, BRS, SRS, SAD, SDD, cost estimates and time estimates, scrum management, process flows
and ucase designs.








Cardinal Data Systems, Inc.




Chr
is Beatty
-

201
-
690
-
3748 x 720

Cardinal Data Systems, Inc. 29L Atlantic Avenue


Suite 343


Ocean View, DE 19970
-
9155 fax: 201
-
690
-
3748



Education

MCT, MCSE, MCDBA, Multi
ple MCP’s,

Bachelor Education, Dip. Ed.