Consulting Philosophy
I have three passions as a software analyst/Programmer:
I started with what was then called the Pick Operating System. This has now morphed and bifurcated into a family of highly scalable, highly efficient 'No SQL' database environments (called 'D2' or 'Multivalue' databases) that excel in ways that columnar databases like SQL Server do not - and are weak in ways that columnar databases are not - they are quite complementary, actually. I am not shy in saying that I do not know any Pick programmers who writes structured, robust code better than I do, or faster than I do.
Since that time, I've branched out into Visual Basic, SQL Server, HTML, and HTML/OS (now called Aestiva Array) to create Windows applications, Data Warehouses, and large, fast, robust data-backed websites.
Unlike most other programmers in this field, I use the Structured Programming Paradigm, and I have also taught Structured Programming, as it applies to Pick, and Pick-like systems.
- Using my expertise in business rules and process flows to create (or sometimes recommend the purchase of) solutions that fit my client's needs and corporate culture.
- Creating systems and structures that elegantly, efficiently enhance the storage and retrieval of data. I excel at the challenges of database design.
- Creating clear, concise, enjoyable and easy-to-use user experiences and interfaces. I am particularly good at this because i think like an end-user, not a coder. I also speak like a business person, not a techno-geek.
I started with what was then called the Pick Operating System. This has now morphed and bifurcated into a family of highly scalable, highly efficient 'No SQL' database environments (called 'D2' or 'Multivalue' databases) that excel in ways that columnar databases like SQL Server do not - and are weak in ways that columnar databases are not - they are quite complementary, actually. I am not shy in saying that I do not know any Pick programmers who writes structured, robust code better than I do, or faster than I do.
Since that time, I've branched out into Visual Basic, SQL Server, HTML, and HTML/OS (now called Aestiva Array) to create Windows applications, Data Warehouses, and large, fast, robust data-backed websites.
Unlike most other programmers in this field, I use the Structured Programming Paradigm, and I have also taught Structured Programming, as it applies to Pick, and Pick-like systems.
CRM Project (VB.NET front-end, Universe Database ERP Back-End)
Below are annotated screenshots from a recent project, a CRM system I wrote. As in many projects I am involved in, I anticipated the user's needs, and took the initiative for design and added features the users hadn't even thought of but immediately fell in love with and became dependent upon.
I actually created 'data object' classes for the back-end ERP system (which is running on a Multivalue database called 'Universe'). In this way, I made the application 'Database Neutral': one would merely have to write new data-object classes for the new database (SQL Server, Oracle, Cache etc.) and the app would run just the same. Flexibility and extensibility are also hallmarks of my work.
I actually created 'data object' classes for the back-end ERP system (which is running on a Multivalue database called 'Universe'). In this way, I made the application 'Database Neutral': one would merely have to write new data-object classes for the new database (SQL Server, Oracle, Cache etc.) and the app would run just the same. Flexibility and extensibility are also hallmarks of my work.
Resume
Samuel Claiborne
High Falls, NY
917-453-3786
tao.shamanics@gmail.com
Consulting Senior Programmer/Analyst
- Highly experienced consultant, proficient in assessing business needs and designing, coding and implementing software solutions.
- Create systems for the retail, wholesale, manufacturing, and financial services sectors.
- Craft custom applications that suit both business requirements and corporate culture.
- Aid in assessing third-party commercial applications for implementation and integration issues. Performing actual integrations.
- Experienced in data warehouse and data mart design and implementation.
- Great listening, writing and verbal communication skills.
- A deep understanding of critical business functions such as accounting, inventory control, retail (point of sale in brick and mortar as well as ecommerce), wholesale and manufacturing (bills of material, inventory, shop floor control etc.).
- Expert in creating database structures that address and solve real-world problems efficiently and rationally.
- All work is well documented so that others may maintain and build upon it.
- Expert at implementing modern user interfaces with Multivalue Database back-ends.
- Expert at not only meeting, but often anticipating clients needs by taking ’30,000 foot view’ of issues and systems.
Program/Analysis skills: Pick/Multivalue: BASIC/PROC/English-Access (Cache, Universe, Unidata, D3, Evolution, Reality, Mentor, Ultimate, Revelation). Other: Visual Basic and Visual basic .NET, Oracle and SQL Server SQL, MDX, SQL Server SSIS and SSRS, SQL Server Administration, HTML, Javascript, Aestiva Array, Excel (including pivot tables connected to a data warehouse), Access.
Documentation Skills: In addition to programming/analysis, I excel at the design and creation of flow charts and excellent technical and user manual documentation, including permuted indices and technical diagrams, utilizing: Smartdraw, Photoshop, In-Design, MS Office.
Recent project highlights:
2016 – Present – Major medical supply wholesale/retail/distribution company.
- Created Data Mart using Cache DeepSee Pivot Table-based product. This involved massive data ETL processes running via embedded triggers and the creation of SQL and MDX code to optimize complex data-intensive queries.
- Created object models and data classes of Cache Multivalue data to project into VB.NET in order to create modern VB .NET apps with Cache data as the back end, and utilizing Infragistics forms controls, resulting in a flexible modern front-end.
- Wrote VB.Net based intermediary applications to convert native Cache Multivalue data into Excel spreadsheets and pdfs, and to import Excel spreadsheet data directly into the Multivalue database.
- Applications support for existing, aged Multivalue ERP system.
- Wrote proprietary algorithms to parse free-form text into usable addresses using Levenshtein Distance calculations, and table and rules-based logic.
- General application support.
- RESTFUL applications research for interfacing Rocket Universe with JSON.
- Automated integration with CloudX system for subcontractor Accounts Payable.
- Created a modern Windows-based CRM system and several other Windows-based systems using VB .NET which interfaced seamlessly with a Universe Multivalue database back-end ERP. This project also involved creating indices, B-Trees, and intelligent search algorithms on the ERP side, in Pick Basic, in order to provide near instantaneous retrieval of over 6 million customer records, complete with all customer service interactions, contact information, which coupons had been sent to them over the life of their relationship with Cache, and their entire purchase history, with drill-down to the line-item detail level. All of this data was presented in a streamlined tabbed-window interface that users were delighted with.
- Wrote a customer acquisition dashboard in VB .NET using graphical data presentation tools.
- Helped spec. out and design two new E-Commerce sites, and helped vet the web development vendors.
- Spec'd out a browser-based Store-Web Order Fulfillment system implemented to allow multi-channel fulfillment, and wrote the client-side portion of the application as well as the fulfillment allocation algorithm. Specs included numerous flow charts and wireframes created with various graphics programs.
- Designed and implemented a SQL Server Data Warehouse which created a homogenous repository out of heterogeneous sales and customer information from multiple systems, including the Universe back-end ERP, the Postgre-SQL E-Commerce site, and several Oracle-based store POS system servers. A data warehouse is typically implemented by a team of people, but I designed, coded, and implemented the entire project, including all table design, all processes to handle slow moving dimensions, and Extract/Transform/Load functionality on all of the above systems, as well as within SQL Server Integration Services (SSIS). This system pulled literally hundreds of thousands of rows of data from these systems nightly, normalized it, tested it for accuracy, and inserted it into the warehouse, all automatically and without user intervention. In addition, a VB .NET program compared various key sales numbers down to the penny between the ERP system and the data warehouse nightly. Prior to Cache’s bankruptcy, the warehouse agreed to the penny for over 2 years straight.
- Designed and coded various webservice API calls for Cache’s ecommerce site.
- Designed and coded a highly secure, highly robust Cache Visa Application website with the Aestiva Array database/language environment. This site interacted with US Bank’s secure servers to give customers instant credit approval for an in-store visa application. It simultaneously fielded application requests from over 300 stores. It has had a perfect 100% uptime, zero error record from the first day of launch, in 2009, until Cache closed its doors in 2015.
- Worked on an Ultimate Multivalue Database ERP system, maintaining existing accounting, bills of material and inventory programs in Pick BASIC, Pick PROC, and the Pick English/Access database languages
- Developed new executive dashboards and other analytical platforms in VB .NET, utilizing Infragistics and other third party data presentation tools. These applications provided decision-makers with unparalleled graphical and numerical analysis of sales trends, inventory positions, and A/R volatility.
- Evaluated canned jewelry business software packages for conformance to business requirements, robustness, and user interface interaction and execution speeds.
Work samples at: www.samuelclaiborne.com/resume.html
Education: Simon's Rock College, Great Barrington, MA.