The last week (Friday), my short-term contract was concluded.
I completely redesigned SQL Server Database of the Client’s Inventory Replenishment (Vendor Managed Inventory - 3rd Party Logistics) Management and Reporting Tools with building normalized database design preventing suppliers’ duplicating, providing efficient suppliers selection tools by various criteria, developed SQL Stored Procedures, SSIS packages for importing data from various sources, compactly and eye-friendly redesigned User Interface with presenting most important data on one screen, automated repetitive users’ tasks with Access Macros and VBA.
The simplified Database redesign is presented below.
In the old database Suppliers were duplicated.
I am working with Microsoft Access 2013 and came to conclusion that Grey Background "MS-DOS style" (Colors "Text 2, Lighter 60%" or "Text 2, Lighter 80%") is much more eye-friendly (for example, for sales persons spending 8 hours daily) than a white or bright background. About Font Color: it's #17365D (dark-blue).
Would you agree with my choice or you know better (for users' eyes) combination?
I continue working on a contract position related to redesign of SQL Server and Access based Supply Replenishment Reporting Tools.
At this point (beginning from the last week of February), I am working on a new assignment related to redesigning a Big Client's Access Database.
1. SQL Server 2014 Developer Edition, fully functional but not for commercial use (producing demos is allowed);
2. Excel 2013 with PowerPivot, fully commercial;
3. Visual Studio 2013 Professional, also fully commercial.
In September-October 2015, I attempted to contact with Microsoft about getting fully commercial license for SQL Server 2014 and its total cast.
Their ballpark estimate was around $12,000 for 2-3 more servers with Windows Server 2012, Azure, SharePoint and some other stuff.
I was not able to get from Microsoft people anything in writing.
So, for now, I am producing various Demos to attract potential customers: small business owners who need various kinds of business reporting that allow timely detect transactional discrepancies, irregularities and unusual activities.
The table below shows "Valentine" name popularity in 2001-2015 (USA). The PDF file for full "Valentine" history (1880-2015) is also attached.
At the end of the day, I am attaching three Charts for "Valentine", "Valentina" and "Valentin" (Female and Male Form in Russia and some other former Soviet Republics).