This website is decicated to solving business problems using Information Technology.
Ashish Kumar (Technology Consultant)
I help businesses achieve efficiency and productivity by implementing software solutions.
I have over thirty years of experience in the IT industry. During my long career, I have been an entrepreneur, software architect, inventor, consultant, IT project leader, software developer, and a mentor. I have worked in variety of domains such as retail, financial, transportation, banking, telecommunications, EDI, and manufacturing. I have worked extensively on system architecture, database design, data warehouse design/ implementation, and integration projects. I am a creative thinker and out of the box problem solver.
How I help grow small to medium size businesses
IT (Information Technology) is an integral part for any business to success and grow. Small or medium size businesses often do not have the resources to have an in-house IT person. Those who do often find themselves tangled in the vast and complex field of software. I help businesses to solve their needs by using the right software only as a tool. My solutions save money for customers. I provide support for these systems for further customization and enhancements.
Examples of my services:
- Add functionality to your existing off the shelf system(s)
- Build custom software
- Leverage my vast experiences spanning mutiple industries
I work with the following technologies
- Microsoft .Net C#, VB.Net
- Microsoft SQL Server, MS Access
- Microsoft Office automation/VBA macro programming
- Oracle databases and PL/SQL
- GIT Hub
- A number of open source tools, technologies, and frameworks
- Microsoft/MacOS/Linux operating systems
My other work
The embedded systems are also evolving. You do not need an electrical engineering degree to create control systems of your own using simple boards like Raspberry Pi & Arduino boards. Systanix is going one step further to out the power of the PC and realtime programming using databases to create even smarter systems.
Some archived projects
Before email spam was even added to common vocabulary, I created a rule based spam filter for mail servers. Also, take a look at a store and forward messaging app, developed using Perl and Oracle database.
Fun stuff I developed
Utilities/Tools I developed
If you use 1&1 or any other bargain windows hosting site, most likely, you are required to use dynamic sql for DDL. This utility would do such conversion using regular expressions. 1&1 SQL Formatting utility
If you are like me, you like to get most bang for your code. In the object oriented world you get this by creating reusable objects. I recently started using web user controls in ASP.Net An ASP.NET Web user control is similar to a complete ASP.NET Web page (.aspx file), with both a user interface page and code.Create reusable web user controls in ASP.Net
I am sure you have developed applications dealing with multiple types of databases like SQL Server, MYSQL, or Oracle. Sometimes it is very convenient to just link the tables in a Micrsoft Access database and work with Microsoft's Jet Oledb provider. I have developed a class using C#, which you can include in your code to make linking and unlinking of tables, a breeze.Linking/Unlinking tables in MS Access using .Net
The XportXML utility, will help you copy relational data (a bunch of related tables) to another SQL Server. There is no rocket science behind the utility as such. It automates many mundane tasks like writing the query to export the data in hierarchical order, and creating XSD schema.XportXML utility to export relation data across SQL Servers
Call me now at 732.690.8870