DigitalOnQ, Digital Media Processing/Storage Windows Application/Platform, Consulting (Seattle, WA)
The DigitalOnQ software is designed to manage digital media (photo, audio and video) collected by evidence technicians and police officers at crime scenes and incidents using various digital camera technologies including body-worn cameras deployed department-wide to police officers. I designed, developed and delivered the software with such features as a custom thumbnail viewer, on-the-fly thumbnail generation for different platforms, encryption and digital media authentication, body-worn camera integration (several models/vendors) and image editing capabilities.
EvidenceOnQ Hosted Cloud Platform, Evidence and Crime Scene Management, Consulting (Seattle, WA)
The Web & Cloud Services is a platform for providing evidence and crime scene management solutions via a subscription based model. Clients would be able to access the functionality via either a vendor-hosted Web interface or via customer-provided application utilizing a unified Cloud-based infrastructure and RESTful APIs.
Architected and developed the platform and delivered a library of RESTful Web services that can be hosted on a local server or in the Cloud.
EvidenceOnQ Desktop/Web/Mobile Evidence and Crime Scene Management, FileOnQ Inc. (Seattle, WA)
Designed the architecture and Lead a team of developers in developing a desktop product that manages the storage and tracking of physical files and digital documents within large enterprises, utilizing barcode technologies to track the history of creation, movement and access of physical files and digitized documents throughout their life.
Also, designed and developed a companion ASP.Net product to allow users perform similar functions to the desktop product from remote locations through a browser, and a Mobile solution including in-vehicle PDTs (Laptops) and several models of the Motorola barcode-equipped mobile platform devices including MC65 and MC75 running Windows CE, all of which communicated with the host server via 3G/LTE wireless connections or via synchronization once docked at the HQ.
Project Manager/Chief Architect – Integrated Software Solutions, WA (Claremont Tech. Group, Seattle WA)
OnQ was a document management solution running in a 16-bit environment. Many factors deemed this product obsolete from both a technological and functional perspectives. To ensure the continuing life of the product, ISS had decided to improve it by porting it to a 32-bit platform and rethinking its strategic and marketing direction. As the project manager and chief architect, my responsibilities involved:
- Help set the strategy for the new product
- Introduce new technology where appropriate
- Manage the undertaken effort to ensure successful, on-time, within budget delivery
- Architect/design the new solution
Consulting Architect – The Frank Russell Company, Washington (Claremont Tech. Group, Seattle WA)
The Frank Russell Company was undertaking an effort to set standards for an Enterprise Architecture that maximizes reusability and sharing and enforces standard usage of technology across the different business units. Key technologies considered included Distributed design, XML, Browser technology, data storage, and massaging systems.
As a consulting advisor, I helped the architecture team and business analysts set the direction and provided expertise in the various technologies being considered.
Chief Architect – TMS – Office of the State Treasurer, Washington (Claremont Tech. Group, Seattle WA)
The Washington Treasury had an existing aging mainframe system that was becoming hard and expensive to maintain and enhance with new features. The office of the Treasurer published a RFP for a new system that utilized new technology. The system maintained cash, debt, investment, and portfolio information for the state of Washington. The project involved Object Oriented Architecture and Design of a n-tier distributed system utilizing UML, Visual Studio Suite 6.0 (C++, VB, Interdev...), MTS, MSMQ, SQL Server 7.0, ERWin, and Rational Rose. After 2.5 years, 3 months ahead of schedule, the system was delivered and put into production, all financial systems balanced to the penny.
- Oversaw the technical proposal effort and conducted the final technical presentation to the Deputy Treasurer and about 40 individuals from the department’s technical and business staff. Our firm won the bid against IBM Consulting, KPMG and Anderson Consulting among others
- Designed the application architecture framework to support multi-tier LAN and Web deployment
- Designed the security infrastructure to support the protection of the system from unauthorized access, and role-based object/data viewing and editing
- Managed a team of 8 consultants and 15 in-house developers throughout the different phases of the project including business re-engineering, functional specification, application architecture, all UI and module development activities and testing
Senior Systems Architect – Odyssey Project, Weyerhaeuser Inc., Oregon (Claremont Tech. Group, Seattle WA)
The project required the development of a DCOM-based multi-tier, distributed enterprise system to perform daily sales and inventory allocation activities of the Wood Products business. The project followed object-oriented methodologies and was implemented using UML, Visual C++, Visual Basic, DCOM, MTS, ODBC, ADO, and SQL Server 6.5 & 7.0.
- Architected and designed the middle tier of the application, allowing transaction integrity, dynamic data formatting, resource sharing, and simplified deployment, management, and maintenance
- Designed the data location and movement schemes within the whole system, allowing real-time sharing of data between remote sites and other existing systems, such as accounting
Chief Architect – Vendor Bliss – Colonial Pacific Leasing Company, Oregon (Claremont Tech. Group, Seattle WA)
Vendor Bliss linked Vendors, Brokers, and Customers to the client’s computer network via Dialup/Dedicated Internet connections to automate the credit approval and lease estimation process. The software utilized Internet technology and was developed using Visual Basic 5.0, COM/ActiveX, Active Server Pages, and Visual C++.
- Designed the technical infrastructure of the application
- Designed and developed encryption and authentication modules to provide a security framework for the application
Tech. Team Lead – LeasePak – Colonial Pacific Leasing Company, Oregon (Claremont Tech. Group, Seattle WA)
LeasePak managed lease, customer, asset, and profitability information for the enterprise. The project utilized Sybase SQL Server 11, C, embedded SQL, and TCP/IP Sockets in a UNIX environment
- Lead and mentored a team of 16 analysts in the design, and construction of a data translation and movement system that allowed the sharing of data between legacy applications and the client/server environment
- Executed system performance tuning and successfully reduced processing time including nightly stored procedures by up to 95%
Senior Analyst - En-Vue Enterprise - New Technologies Department (STS Systems, Montreal QC)
En-Vue Enterprise was a Data Warehousing support application for the retail market. The application was developed in Power Builder 5.0 and Sybase SQL Server.
- Helped design the logical and physical models
- Wrote Stored Procedures and Triggers
- Fine-tuned the application (query and plan analysis, index selection, and selective module rewrites)
- Analyzed front-end application and recommended changes where required
Senior Analyst - Allocator's Workbench – New Technologies Department (STS Systems, Montreal QC)
Allocator's Workbench was a sophisticated warehouse inventory allocation and replenishment/distribution system that generated distributions from warehouses to stores. The application involved extensive use of statistical methods to derive allocation quantities based on detailed historical sales.
- Designed the logical and physical models
- Wrote major parts of the mathematical/statistical forecasting models/modules used in the software
- Developed all number crunching modules in C as DLLs, and developed parts of the GUI in PowerBuilder
Product Manager – Stock Replenishment System – Research & Development (STS Systems, Montreal QC)
This was an enterprise-wide automated replenishment and distribution system, that automatically generated purchase orders and distributions based on sale forecasts for up to 998 stores and 4 years of full SKU sales history. The system was developed in Business Basic on the DG Aviion, DG MV/AOS, and the IBM RS6000 platforms.
- Supervised a team of 13 analysts and customer support personnel
- Designed and developed software modules according to new release specifications
- Developed support tools in C and C-Shell (UNIX)
- Supported (including on the phone and pager) existing and newly developed modules
- Managed software bug lists and followed up with clients to insure problem resolution and customer satisfaction
- Traveled to client sites as a consultant to assist on the technical aspects of presentations and courses
- Delivered technical courses to employees and customer support staff on automated replenishment software
- Delivered seminars in the STS Retail Convention on automated replenishment and the STS software