This is a list of internet projects I have created.
SpeedVisit.com - online customer tracking application for small businesses to record basic customer demographic information using any web enable device. Doesn't require hardware or software. Employees can use their own internet enabled devices to record customer visits. Created using CakePHP, mySQL, and HTML.
- website to give some information about prepaid credit cards in Canada
which I created after researching them to select best card to use when
traveling. Gets 300-500 unique visitors per month. Created with CakePHP, mySQL backend and static HTML. http://www.canadaprepaidcreditcard.com/
- website I created to present photos of Vancouver, BC fountains and
water art. Created with WordPress, customized templates and NextGEN Gallery WordPress plugin
and modified index page. Gets 300-500 unique visitors per month. http://www.vancouverfountains.com
online forum for discussion on public transportation systems which I
created to learn phpBB open source php bulletin board, and how to use
Google Transportation data files. Created with open
source php bulletin boardphpBB with customized index page and modified
CanadianAlien.com - online
tutorial on how to use Usenet or Newsgroups. Created with php and straight-up static HTML.
Gets 300-500 unique visitors per month consistently since 2000.
Clipped - an
online comic I created to present my cartoon character doodles. Created
with Google's Blogger . http://clippedcomic.blogspot.ca/
Public geo-mapping of Vancouver Car2Go Location data over one year
showing plot of
car locations by lat and lon by count of times cars at that location.
BeginBI.com - website for
business intelligence service offerings. Created with WordPress and custom template and plugins. http://www.beginbi.com
business intelligence blog. Created with WordPress and custom template and plugins. http://www.canadabusinessintelligence.com
IT is Biz - blog on IT and
business and what can be done to harmonize them. Created with WordPress and custom template and plugins. http://www.itisbiz.com
Redirect domain name to different web host by changing dns servers.
Manage web hosting with cPanel and web host administrative features.
Setup and use redirected domains as add-on or sub-domains on web hosting.
Purchase, configure and use SSL and SSL certificates.
Manage web hosting with MySQL database and php.
Install, configure and use MySQL Server on local machine.
Install, configure and use MS SQL Server (2005, 2008) on local machine.
Install, configure and use PHP on local machine.
Install, configure and use ASP on local machine.
Install, configure and use Apache Web Server on local machine.
Configure and use IIS Web Server on local machine.
Setup and use FTP accounts on web hosting.
Setup and use Email accounts on web hosting.
Setup, configure and use variety of email clients and accounts (eg POP/IMAP/SMTP).
Use FTP with variety of FTP clients (eg Filezilla, VBA)
Use FTP and web hosting cPanel to change file permissions.
Create and manage MySQL databases using phpAdmin, MySQL Workbench and php code, inclulding create databases, tables, and update, insert records.
Install, configure and use web analytics including installing, configuring, and operating Piwik open source php/MySQL analytics software.
Setup, configure and use Google Analytics.
Setup, configure and use Google Adsense.
Setup, configure and use Google Adwords.
Install, configure and use a wide variety of open source Customer Relationship Mangement systems (eg SugarCRM)
Install, configure and use a variety of Content Management Systems, and discussion board and forums, and blog systems (eg Drupal, WordPress, phpBB)
Use a wide variety of web services and APIs (eg Car2Go, Google Maps)
Setup protected directories on web server using htaccess permissions and Frontpage permissions.
Use wide variety of web development software including: Dreamweaver, NVU, NotePad++, text editors, Visual Studio, Contribute, and many others.
Use wide variety of graphics applications to create logos, banners.
Use variety of coded procedures to create/send/receive email messages (eg, PHP, VBA, ASP)
Use wide variety of IP and network tools including Sam Spade, Windows command line (eg ipconfig), Windows Task Manager/Services, and many others to monitor, diagnose and troubleshoot network and connectivity issues.
Use website monitoring services to track website and web hosting uptime.
Create mde versions of Access mdb files for production use.
Create Access form pivot tables and charts.
Create Access queries (eg select, update, make table, union, parameterized, pass-through, delete, and join tables.
Use Access/VB standard Functions (eg string manipulations, date transformations) and create User Defined Functions in queries.
Create Access Forms including sub-forms and Events to automate functionality.
Create VBA to automate query, form, report, external functionality.
Create Access form pivot tables and charts.
Examples of advanced Access functionality:
Create sophisticated multi-user, n-tier applications with client/server 'frontend/backend' architecture with Access, SQL Server, Excel, flat file, MySQL backend.
Extract, transform and load data from various formats and systems to cleanse, reformat, aggregate, concatenate, join, transform data including multi-million row recordsets.
Create Access datamarts and datawarehouses.
Create ad hoc to very complex queries, incorporated into VBA code, or that are run by VBA code.
Create connections using ODBC, ADO, DAO, OLE DB, coded or via application features, to data sources ranging from Business Objects Universes, Oracle databases, csv/tab delimited/flat files, web pages, SQL Server databases, application backend databases (eg, Pivotal CRM, MS Dynamics, Outlook, Lotus, etc).
Deploy Access frontend application via Citrix Presentation Server to allow remote users throughout North and South America to use application.
Use VBA code to recurse folders on network to identify files, extract information from files and import it into database.
Use Access VBA to create customized Excel documents from data within Access as specified by end user action (see example code).
Create method whereby Access frontend application is retrieved for end user so they always have newest version from central location.
Create User Defined Function to calculate net time in hours between two date/times that excludes out of work hours, holidays and weekends see example code)
Types of MS Access applications I have developed but I have developed many other Access tools and used Access for other activities:
Employee timesheet data collection and reporting
Residential HVAC inventory management and reporting
Document management system
Mortgage and loan quote collection and reporting
Mortgage and loan application operations and reporting systems
Sales leads management system
Contact management data cleaning system
CRM customer letter printer
CRM sales/lead/ranking system Americas
CRM sales/lead/ranking system Global
Survey results aggregation system
Employee assignment and timesheet system
Sales opportunities/leads/CRM aggregation and reporting system
Wholesale wine inventory management system
General SQL, RDMS, query, data connection activities. - back to top
Install, configure and use MySQL Server on local machine.
Install, configure and use MS SQL Server (2005, 2008, Express) on local machine.
Create tables, and update, insert records, and create views, stored procedures and data connections with MS SQL Server (2005,2008, Express, Compact Edition), MySQL Server, Access, MS Query, VBA DAO, ADO, OLE, ODBC.
Use MS SQL Server SQL database as Access application backend, creating views and store procedures to be used by frontend.
Use Access for ETL, datamart/datawarehouse, reporting, alerts, and advanced analytics. See Advanced Access section above and BI stack section below for details.
Use MS SQL Server to create data connections, tables, and queries as report datasources.
Use MS SQL Server Reports and Business Intelligence Development Studio to create SSRS reports.
Use MS SQL Server SSIS/DTS to extract, transform and load data.
Use SAS to connect to and extract data from remote datasources and export query results.
Install, configure and use Business Objects Edge BI 4.0 including Apache Java Server, Apache Web Server.
Use Business Objects XI to query Universes and export query results.
Use Crystal Reports to create reports from a variety of datasources.
Create Qlikview applications using variety of datasources.
Create Tableau reporting applications using variety of datasources.
Use R to perform regressions, ANOVA, and other statistical operations.
Installed, setup, configured and tested a variety of BI and analytic software including:
Intelligence Stack using MS Access and Excel - back to top
I have created the entire BI "stack" using MS Access and Excel.
The resultling suite of applications is similar in functionality
and use to SAP Business Objects, Oracle BI, MS SQL Server
SSIS/SSAS/SSRS, and any other integrated business intelligence software.
Extract, Transform and Load (ETL)
ODBC, ADO, DAO, OLE DB, FTP connection from Access.
Extract data from various sources into Access.
Transform data in Accdess using queries and VBA functions.
Access VBA to extract regularly.
Create star/snowflake schema fact and dimension tables in Access.
Use Access Make Tableor Select queries depending on
Create datamarts/datawarehouses in Access..
Create reporting datasets in Access..
Ad-hoc queries in Access.
Connect Excel to Access datasets.
Use Excel pivot table to create cube.
Excel Pivot table to slice n dice cube.
Excel Pivot table to create calculated fields and items.
Excel pivot table/chart view.
Access form in pivot table/chart view.
Dimensional queries on measurse and dimensions on Excel pivot
Use VBA to change Excel pivot table row and column values.
MS Query, ADO, DAO, OLE DB connection to datasets created in
Excel used to create structured, special purpose reporting,
refresh using VBA.
MS Query to connect and query datasources to use data in Excel by using Excel MS Query features or using VBA to automate and incorporate MS Query into Excel application code.
Use Excel formulas alone or in complex combinations (eg, string functions, conditional statements, mathematical functions, etc)
Pivot table and charts including using VBA automation to change row, column and page fields and data dependent on other values, events, user input.
Use ADO and DAO data connections and events to retrieve data from remote data source in response to user input.
Complex updating of Data Validation list ranges from remote data sources including resizing of named data ranges to accommodate changed list size.
Creating sophisticated Excel applications including forms that user input is guided using data validation, hide and show of fields and rows, changing form color, locking and unlocking cells, etc.
Creating user input tracking functionality that records user input by date/time, before and after changes, either by writing to hidden worksheet, to external database, to external log file.
Create innovative functionality to have Excel form submit user input data when user is complete, by sending all form field data in flat file to hidden network share, so data can be used immediately for operational and reporting purposes.
Create innovative functionality where Excel form can retrieve previously exported data into blank form to allow user to continue where they left off, or another user to continue form completion.
MS Windows Mobile OS develop Vancouver bus schedule app that sent MMS message with bus stop location to Translink, and intercepted return message to display the stop's routes and scheduled times. Saved route and scheduled times in SQLite database for local viewing and save cost of sending new MMS.
Create SpeedVisit.com web pages to have form factor to fit mobile screen size.
Own an HTC HD2 Windows Mobile phone, that I have flashed with new bootloader and Android Gingerbread ROM.
Create simple Android apps using Android SDK and Eclipse IDE.
Use OneMobi cross device application development tool to test web app form factor on iPhone, iPad and other mobile devices.
I have a wide range of skills, knowleldge and experience working
with computer hardware from installing hardware, to configuing Windows
Operating Systems, installing and configuring a wide range of software
from Operating systems, to server technologies, to desktop applications:
PC configuration and setup including installing network cards, soundcards, graphics cards, RAM, hard drives, fans, BIO configuration, partitioning hard drives.
Using advanced encryption tools and methodologies (eg TrueCrypt encrypt entire system, partitions, files, syncing encrypted files with Dropbox)
Software installation and customizationn ranging from standard desktop software to web servers.
Advanced Windows user (eg command line, system configuration)
Use Windows Scheduler, VB script, batch and executable files to automate Windows tasks.
Use virtual machines (eg VMWare, VirtualBox)
Use and setup VPN.
Setup, configure and use networks including cable/DSL routers, hubs, IP webcams, splicing and fitting Cat5 network cable and connectors, networked printing, shared folders, and network storage.