|
|
| John Lien |
|
Summary
|
A highly motivated professional seeking a leadership role within a progressive
company that encourages unlimited growth potential. An excellent creative
team player who is driven by challenges. Over 10 years experience in the
internet in general including architecture, development, support and management.
Programming skills include: HTML, JavaScript, DHTML, XML, Cold Fusion, ASP,
VBScript, VB 6, VB.NET, C#.NET, ASP.NET, Win Forms, COM Interop, COM, SQL Server (6.5, 7.0 and 2000), TSQL,
Perl, Java, Crystal Reports 8, Crystal .NET, Commerce Server 2002.
|
| Experience |
2/2004–
Present Citco
Technologies
Fort Lauderdale, FL
Senior Developer, Corporate & Trust Worldwide
I was hired by Citco technologies to lead the team of 4 developers they had and
to architect the next version of their internal systems in ASP.NET. Their
systems were in VB6 and SQL 7, and they wanted to migrate everything to SQL
2000 and VB.NET using ASP.NET as the presentation model moving away from the
thick client.
-
Initial conversion of some of the routines used by the VB6
applications was done through COM Interop and VB.NET. Accomplished a
20% code migration in the first implementation of the core suite of tools they
possessed.
-
Created documentation for standards of code writing, and HTML construction for
the team to follow based on Microsoft’s standards and a mix of the best
techniques I had learned from my various dealings with .NET in different team
environments.
-
Assisted in getting the team up to speed on .NET in general and ensuring
they programmed the ".NET way" instead of using some of the bad techniques
from VB6 to ensure the application when ported fully to .NET would be scalable
and robust.
-
Wrote a specification document for the re-programming of their systems to
facilitate a need to cut down the amount of time that was posted through to
their accounting system. This assisted in cutting down the amount of
lines of data in the accounting system by summarizing time by client currency to
each company.
-
Revised an application written in VB6 to report on time spent in a
company for a client. Added additional functionality, and re-wrote all the
stored procedures based on the document created above.
-
Programmed a posting engine in VB.NET, as a windows service, implementing XML to communicate the time from the
above application to post through to the accounting system (CODA). This
engine was programmed to be fault tolerant and to trap errors and store them in a
database in XML format. This data was then replicated to each office and viewed by them
to fix any errors in the posting and re-post.
-
Wrote application using COM Interop to a .NET Winform to facilitate reporting
errors from the posting engine to the accounting
system. This allowed them to re-submit the XML document after
repairing any system settings if there were errors. It used XSL to
transform an error document to a user readable information screen, both from
the accounting system and our own custom errors sent through the system.
|
|
8/2003– 2/2004
Chhabra / Metability
Weston, FL
Contract Developer
Chhabra group hired me to work on various projects, most notably a Commerce
Server deployment at some point in the near future. Some of the tasks I am
currently working on include:
-
Modification to a backend system utilizing web services and XSL / XML. Applied
new logic to system and SQL Server 2000 database to handle CVV2 credit card
processing from the commerce system to the back office implementation, all work
was done in C#.
-
Construction of sales extranet in C# to enable a sales force outside the
company to manage their own coupon codes. These codes are used to track sales
and give commissions with percentage off the purchase to the consumer, and base
percentages to the Manager and Salesman. 3 levels of security built in
utilizing the .NET Authentication infrastructure. Modifications to the same
backend system talked about above to facilitate. Tasks to note which were
preformed:
-
Built a web service in C# to feed reporting information from the backoffice to
the sales extranet.
-
Implemented reports for the extranet listed above in Crystal Reports .NET on an
application server that fed the web server using web services integral to
Crystal Reports .NET. Heavy modifications to the Crystal Reports web service to
carry over parameters and build datasets were done.
|
| |
8/2002– 8/2003
Rexall Sundown, Inc.
Boca Raton, FL
Web Technical Lead
Rexall Sundown, Inc. had a bunch of websites in dire need of updating, their
previous web team had been let go, and they needed someone to bring their
websites into the present and beyond. I was hired to the team at Rexall to help
architect and build a new web infrastructure. This is where I really polished
my .NET skills. The projects we worked on utilized the .NET runtime
exclusively:
-
Lead team of 4 developers on various projects in the organization ranging from
intranet, extranet and internet applications.
-
Architected the SQL 2000 database and specifications document on QMS (Question
Management System) which was a question handling system for all information
submitted from end users through our websites. This facilitates the regulatory,
scientific and technical operations side of the business to be integrated into
this communication medium.
-
Built a common framework of VB.NET assemblies for all websites to utilize. Some
of the functionality in that framework includes:
-
Individual sub system – Individual sign ups throughout all websites had the
ability to share logins, or not based on some properties set in the object
layer. Company decided to not, due to individual brand needs, but functionality
remained.
-
News postings – The ability for each website to have its own news postings
-
Error handler – Common error handler for all websites that sends detailed
information to support email address to ensure that any troubles with the
websites can be addressed.
-
ECard – Electronic cards functionality for a kids website, so that cards can be
swapped in and out, and shared across multiple websites.
-
Encryption – Utilizing 256bit AES (Rijndael) encryption algorithms, built a
common encryption object / routine for all the libraries internal to use. This
was used to encrypt passwords with passwords and credit cards with a 32 byte
key.
-
Product – All of Rexall products go through this library and can be fed to any
number of websites by passing or setting a few parameters.
-
Commerce Server 22002 .NET implementation – Utilized CS2002, VB.NET and ASP.NET
on the MET-Rx website to start the company doing commerce on the web. Learned
the basics of CS2002, and progressed to learn CS2002 intimately. Documented the
procedure to lock down the site utilizing Microsoft’s best practices
documentation and applying it to our hardware and software infrastructure. This
was a massive project, which encompassed nearly reprogramming the entire Retail
2002 site to fit the needs of the MET-Rx brand, and make it look sharp and
fresh.
-
Implemented a number of template systems using ASP.NET for each of our
websites, refining the structure each site. This was a common set of
functionality for each of the websites that was implemented with user controls
throughout the site. Some of that functionality was to print the page, e-mail
to a friend and a dynamic menu.
-
Built a marketing program in C#.NET using win forms for the sales force of
MET-Rx to take to road shows, and collect data on people at conventions.
Information included name, address, city, state, zip and types of products they
use (for sports nutrition). The information was collected into a strongly typed
dataset and saved out as XML and e-mailed to the team for placing in a database
(SQL 2000) for data manipulation and reporting.
|
|
|
4/2001 – 8/2002
Promero.com Pompano
Beach, FL
Team Lead / Senior Developer / Application Development Manager
Promero was built from the best of best technologies, and personnel from a
previous company ByeByeNOW.com. My role in this new company was to bring
my knowledge of those technologies from ByeByeNOW and build a multitude of
product offeringings from them. Some of my responsibilities include:
-
Examined existing ByeByeNOW technologies and their usability for Promero.
-
Was mentor and lead to the team of 5 developers working on various projects on
Promero’s new product offerings.
-
ByeByeNOW content engine.
-
Reworked this engine to allow it to be more extensible and allow us to resell
the content to multiple distribution channels. This was done using SQL 2000,
ASP and VBScript on IIS 5.0 and Win2k servers.
-
Reprogrammed content engine into JSP / Servlets / Beans.
-
Architecture of an XML interface to the content engine using XML and XSLT.
Currently building the prototype using ASP.NET and web services.
-
VOIP - Promero licensed a technology from Cosmocom, which is an open-ended
technology (using VBScript and XML to create IVR).
-
Integration of this technology with our CRM (VOIP, PSTN, Web, Email and Chat)
using SQL 2000, VBScript and ASP.
-
Construction and architecture of a Smart 1-800 routing product known as Smart8.
This system is for managing, adding, deleting and updating campaigns, groups
and agents in a distributed call center situation. This system was built on
ASP, VBScript, JavaScript and SQL 2000.
-
CRM – Promero had licensed a technology from Onyx for their customer
relationship management software. This software is utilizing ASP, VBScript and
SQL 2000.
-
Extended CRM with additional fields, integration with E-commerce engines and
VOIP product offering re-writing some of their ASP to accommodate.
-
Integration of this to our Cold Fusion E-commerce engine (able commerce)
through an XML interface to the CRM using ASP and XMLDOM.
-
Assisted in upgrading the systems to SQL 2000 from SQL 7.0 across the Internet
applications.
-
Built a stored procedure generator on personal time for utilization in the
organization and distribution as freeware using VB.NET. Check my website for
more details.
|
|
3/2000 –
3/2001
ByeByeNOW.com Pompano
Beach, FL
Team Lead / Lead Developer
The main responsibilities in this position were to lead the effort of
taking control of our intranet / extranet and internet websites from a
contracting firm (ICI) located in Dallas, Texas and head the new internet
development department.
-
Worked with the team that originally built the websites for four weeks to get a
familiarity with the architecture.
-
Took lead of said team to ensure the launch of a new version was done on time,
and bug free.
-
Assisted in coding the application, which was in VBScript, ASP and with a SQL
7.0 backend
-
Managed workflow processes.
-
Acting liaison between ICI and ByeByeNOW ensuring changes and functionality of
the website were done to spec of the management team at ByeByeNOW.
-
Built a hard-core team of developers to repair, modify, upgrade and maintain
the website for ByeByeNOW.com.
-
Was lead programmer to said team of 12 developers working on various projects
on the ByeByeNOW.com's Internet, Intranet and Extranet projects which utilized
XML, ASP, VBScript, JavaScript and SQL 7.
-
Fleshed out the development workflow with 1 Development, 1 Staging, 3 web
and 3 database servers for redundancy working behind Arrow Point load balancing
solution. This included configuring, installing and managing the Visual
SourceSafe 6.0, Visual Interdev Server and debugging on the Development
machine.
-
Implemented a Persisted XML recordset and developed technology to automatically
update the XML dataset across multiple web servers through a custom built ASP
XMLHTTP API to ensure the web sites scalability and enhanced user experience.
|
| |
6/1998 –
3/2000
Power
Images Fort
Lauderdale, FL
Web & Internet Administrator / Sr. Programmer / MIS
Brought in to rebuild the internet department, take control of the servers
and hardware, and turn the department around.
-
Worked with Mac web servers, and various other technologies (perl, shell
scripts, tango, butler) to integrate and bring all of those under one
technological roof of ASP, VBScript JavaScript and SQL server.
-
Duties included the programming, and architecture of all web applications built
for the clients. The technologies of choice at Power Images were ASP, VBScript,
JavaScript and SQL 7.0.
-
Re-programmed the Miami Dolphins web site. This site had a publishing engine
built on a legacy code that was extremely limiting. Re-programmed all legacy
code into ASP using ADO and SQL 6.5 backend.
-
Identified old equipment that was in need of upgrading to ensure
growth and scalability and installed said equipment.
-
Configured and established a Linux box for use as DNS / mail server on
premises. Locked the box down using SSH then closing all ports not
required, and applying patches to it regularly.
-
Managed web team to ensure sites were done on time, efficiently and to customer
satisfaction.
-
Initiated a PDC & BDC using a dual Pentium NT 4.0 server running IIS 4.0 to
centralize logins and passwords, simplifying their legacy account management
system.
-
My administration duties included these hardware platforms and OS's:
-
Windows NT 4.0 with IIS 2.0 / 3.0 and SQL Server 6.5 as the new path for
upgrading legacy sites, and initiating new sites
-
Linux 2.0.1 & Redhat 6.0 as the new mail / DNS server
-
Irix 6.2 SGI Indy boxes with Netscape Enterprise Server 2.01 for legacy sites
-
Mac OS 8.1 with Webstar web server and Butler / Tango combination for legacy
database driven web pages
-
Windows NT 3.51 with Netscape Enterprise Server 2.01 & Netscape Mail Server
2.1 for legacy e-mail
-
Instrumental in the re-programming of Weston’s Towntalk from a kludge perl
script into a fully automated, integrated, extendable backend administered
online community programmed in Cold Fusion with a SQL 6.5 backend.
|
|
12/1994 –
6/1998 Shadow
Internet Services, Inc. Miami, FL
System Admin / Office Manager (final title)
Hired at Shadow as one of the first employee’s. Started with the
company when there were less than 20 customers and worked them up to 1500
customers before hiring more people. Total number of customers when I
left was 3000+.
-
Started as Technical Support and developed strong interpersonal skills.
-
Worked in billing, sales and finally advanced to Office Manager / System
Administrator (supervising / training personnel / managing systems).
-
Instrumental in implementing billing system in Microsoft Access for managing
the growing customer base.
-
Gained mastery in HTML 1.0, 2.0 and 3.0 successively.
-
Learned to program utilizing PERL through CGI outside working hours.
-
Developed online ordering systems for e-commerce solutions in ASP in IIS 3.0.
-
Migrated Microsoft Access billing system to SQL 6.5 billing system.
-
Forged the technology that allowed customers to view their billing information
securely online, as well as time online, dual login and other vital account
information. This was initially done with IDX, and IDQ and eventually ported to
ASP and IIS 3.0.
-
Gained knowledge in VBScript using ADO to connect to both Access and SQL 6.5
backend.
-
Self taught skills in the UNIX environment allowed me to move into a System
Administration position taking care of all the hardware and software present.
The technologies used here were Shell Scripts, Perl, etc.
-
Built, repaired and consulted on new computer systems as well as implemented
internal computer systems upgrade paths.
-
Administered, upgraded, backed up and restored both clients and internal SQL
6.5 databases.
-
Gained experience working with SunOS, Solaris, Linux, Windows NT, Windows 95,
Windows 3.1, Windows for Workgroups, Mac OS pre 8.0, ODBC, MS SQL Server 6.5,
Visual InterDev, Visual Basic and PhotoShop.
|
|
Additional Experience
|
Ever since my first taste I have immersed myself in the internet. External from
the above experiences, some of my work has included a control panel for an ISP
built in Perl on a BSDI box (qualserve.net). This included installing the web
server, configuring sendmail and allowing customers to edit / add / delete
accounts in their domains through that control panel. The control panel
allowed the customers to add pop accounts, edit those pop accounts, adding
mailing lists and editing FTP settings.
Additional work included designing and building web sites for various companies
(aaawatch, watchamillion, etc.), and a computer hardware store turning to the
web for E-commerce (MITCorp, Shadow.com) and much more.
|
|
Personal
|
I am a hard working, dedicated individual with an appetite for learning and
experiencing new challenging roles and duties. I'm not satisfied until my
assignments are completed successfully. If there is an area of expertise that I
must achieve, I'll make the necessary sacrifices to achieve this expertise.
Case in point, when I was first hired at Shadow Information Services, I had
until that moment, only barely knew PC’s and never used Unix (having gotten my
first IBM PC Clone in August of 1994, before that I only had a Commodore 64). I
worked hard and became system / network administrator for all servers, and
those who use them (roughly a 3,000 user base by the time I left) in less than
2 years.
I am capable of learning new things quickly, effectively and efficiently.
I thrive on a good challenge.
|
|
Education
|
1992 -
1994
Bauder
College
Miami, FL
-
Associates Degree in Electronic Engineering
-
Graduated college with a GPA of 3.7
-
Tutored classmates
-
Currently working on getting my MCSD certification
|
|
Interests / Hobbies
|
I enjoy carpentry and do it yourself jobs. I also enjoy my son more than
anything else in the world. If I am not fixing up the house or playing
with my son, then I am sitting in front of my computer learning more, or
reading about new technologies.
I also enjoy playing MMORPG’s on occasion in my free time. I have loved
computers since I was 14, and starting programming with my first computer,
which was a Commodore 64 using basic.
10 Print “Hello World!”
20 Goto 10
|
|
|