 |
|
|
|
Excuse the length of and jargon within what follows but I'm assuming this page
is the only one that matters to your technology manager and lead programmer.
Unfortunately, I have had to alias the names of some of the firms because they
are smaller companies of between 50 to 100 employees and if known to have an
ongoing relationship with me, will suddenly be flooded by calls from recruiters
and consultants. Please forgive the colorful monikers. Once we're safely cloaked
by the privacy of your office I'll give you some names and numbers. Also, if
curious about anything of the not-so-recent past, please and kindly give me time
to pull up and review the project. Recently a lead-programmer asked me to detail
the MS Sql Server remote DTS command interface I wrote in 2003. He might as well
have asked me to fill in the blanks of Einstein's Unified Field Theory.
|
|
|
On-line registration, data tracking, and reporting. ASP II/VB.Net 05, MS SQL Server.
|
|
Conversion of Crystal Reports to ASP II/VB.Net 05.
|
-
Intranet-based, agent performance tracker. Agent, supervisor, manager, and director
views with date-range selector and drill down for management. Middle-tier business
rules for metrics. ASP II/VB.Net 2005, MS SQL Server.
-
Loader for point data. Logic to identify an agent without an employee I.D. number from
within a pool of random name aliases and name formats. VB.Net 2005, MS SQL Server.
|
Orchestrated a wide range of critical projects from inception through delivery and post-
implementation support as a single source, including:
-
ASP2/VB.Net 2005, IIS, MS SQL Server driven Internet Site for the remote administration and
on-line transfer of sample MP3 and Wav file promotional samples to prospective licensees.
-
ASP.NET based SQL Server 2000 DTS command interface, EDI order process controller,
mass e-mail program, and logistics tracking program.
-
Special VB.Net based inventory reconciliation programs, shipping programs, data mining
parsing programs for CSV inventory/sales reports to home office in Hong Kong, VB-based
Excel updates to financial management in Stockholm, XML parsing product-description
programs, and a CSV/FTP automated ordering system.
-
Interactive Web site #1: Over 50 pages of multi-tiered, hierarchical, Active Server
Pages of Logistics, Sales, Financial, and Managerial Reports used strategically by
satellite offices and customers worldwide featuring optional user drilldowns via pop-up
links. Also includes product VB-generated barcode download page, Web-based Crystal Reports,
and client-based Excel exporting, and rapid downloads via prepared stored procedures and
data buffering via nightly ran DTS jobs.
-
Interactive Web site #2: Direct Customer Ordering of Product featuring custom views per
customer, customer account information updating, and order confirmation. The ASP-based
back end administration pages for this site include per customer order modification with
a check box roster, various customer info views and order summaries, and a selective order
release interface.
-
Nightly built inventory and stratified sales reports generated by VB 6 and auto-emailed
via MAPI to partners worldwide.
|
|
Developed an on-line T-Metrics point versus reward cost
tracking system for incentive managers. ASPII/VB.Net 2005, Access.
|
Assisted and/or lead in the testing, development, and maintenance of:
-
An SSL ASP2/.Net’05 enterprise system for managing lab data, authenticating
users via the Vanderbilt Active Directory Store, utilizing SQL Server ’05
for roles/profiles, NUnit for Testing, Ankh/Svn for Source Control, and
interfacing with a second, Scitegic Pipeline Pilot program via SOAP.
-
Two graphic-only web sites: www.vanderbilt.edu/HTS and www.vanderbilt.edu/syncore
with .Net’05/ASP2 (although they've been somewhat modified since my departure).
-
A family of VB7 programs designed to read, analyze, store, and present FDSS robotic
data using a variety of algorithm combinations as specified by collaborators of
Vanderbilt’s High-Throughput Screening Facility.
-
VB7 programs for: Parsing and collating 384-page Excel workbook data generated by
a Blue Shift Imaging Analyzer; Scanning and reorganizing inventory tracking data
generated by an Echo Cherry Picker for the support of a Compound Library.
|
-
An on-line customer care center agent product-knowledge tester with scoring
and tracking. ASP Classic/VB6.
-
On-line product comparison charts.
|
Devised, researched, developed, and maintained full lifecycle interdepartmental
and data entry center applications including:
-
Client-Server VB6/SQL Server 2000 Data Entry Applications implementing
ergonomic design and control logic for rapid entry for up to 50
workstations (depending on function), integrating client-side detailed
error correction/proofing, auto-population, and server-side business rules.
-
Rapid OCR invoice scanning with error checking and auto-correction using
two third-party OCR ActiveX controls for cross verification.
-
Multi-profile, ASP workstation tracking program for resource management.
-
VB/FoxPro-Based PostalSoft-to-Access dB import application featuring a
type-conversion and column rename GUI.
-
ASP/VB6/IBMMainFrm/SQL7 n-tier logistics reporter with middle-tier business
rules.
-
VB6/SQL7 multi-facility equipment/user tracking application used by IT management.
-
VB6/SQL7 hourly time-ticket application used by all list programmers monitored
by accounting department.
-
Miscellaneous VB6-Based Data Conversion Utilities.
|
VB6/SQL 2000-based enterprise order-management system for a 20-workstation
customer service department and its management with over 30 GUIs featuring:
-
Order input, order parsing and capture via Web contractor export, and
auto-fax/auto-email status driven scripted order confirmation/update via MAPI.
-
Order logistics and routing with shaped-recordset drilldowns via hierarchical
flex grid controls.
-
Billing package featuring custom, auto-populated purchase order via printer
control (no Word template!).
|
Engaged by primary contractee, TARP, to assist in reporting interface development
on a multi-national call center program ushering European users from DOS to Windows
via a C++-based program.
-
Assisted lead programmer in Microsoft Visual C++ coding.
-
Established IQ Objects Smart Server reporting system with multi-level,
logon-based views featuring a variety of sales reports. Also formatted
all of the reports.
-
Migrated another aspect of reporting to Access Reports and Charts using
VBA scripting and T-SQL on SQL Server 6.5.
|
Vanderbilt was using a program from Cambridge Soft that utilized an Oracle database.
I learned to make a connection with it to extract some needed data and I'm vaguely
familiar with the subtle differences between T-Sql, and PL/Sql.
I learned Java II in 2001 while trying to stay busy at Grizzard between assignments
while that particular incarnation of the company was running amuck in its last days.
I loved the language but have since never had the opportunity to use it.
|
|
|
|