Shashvat G.
MohaliIndia
100% Job Success
Top Rated

Senior Microsoft Access VBA SQL Server Programming Expert

25+ Years of Extensive Experience in Business Software Applications Development. Develops POS CRM ERP for Retail/Wholesale/Manufacturing/Service-Sector Businesses using MS-ACCESS-VBA & SQL-Server. Automates Business Processes like Managing Clients, Quotes, Purchase Orders, Work Orders, Production Control, Inventory Control, Invoices, Employees, and Accounts. Most of my experience is in development of ERP Systems using MS Access as Frontend and SQL Server as Backend. I have specialization in developing cloud-based solutions in MS-Access where database is hosted online (SQL Server or MySQL hosted in Azure/AWS or general hosting). I too develop solutions in MS-Access to run applications on Mobile-Tabs (Microsoft Surface Pro). I have developed a software product named Billing Register, which is a fully functional Business Management System. It has all kind of modules like POS, Invoicing (A4, Letter, A5, Legal, Thermal Paper of 2”/3”), Sale/Purchase, Auto Tax Calculation, Quick Discounting Method, Credits/Receipts/Payments, Inventory/Stock Management, Barcoding (Design/Print/Scan), Production Control, Accounting/Bookkeeping, Lead Management, Marketing (Data Collection, Campaign, Emailing, SMS), Quick Record Searching, Color Coding of Records, Performance Reports (Export Data in Excel, Auto Emailing of Reports), Employee Theft Control, Support for Touch Based Screens, and much more. Summary of my skillset in MS Access, SQL Server, Outlook, MS Excel, and MS Word Programming is as below: • MS-Access-VBA, Macros & SQL-Server belongs to my core capabilities. • Using MS Access & SQL Server as development platform since 1998. • Exposure to all the flavors of MS Access (Access 97 to Access 2019) & SQL Server (7 to 19). • Strong hold on C#, ASP.Net, HTML5, CSS, PHP, and Rest-API. • Proficiency in Sending/Reading emails via Outlook as well as without Outlook. • Proficient in importing/exporting data to/from Excel with all data checks. • Proficiency in auto creating Word Documents/Letters/Emails via dynamic parsing of Smart-Tags. • Developed 50+ MS Access based applications to run on mobile (Microsoft Surface Pro). • Developed 50+ applications having SQL Server as backend in Cloud Hosting, Microsoft Azure, and AWS. • Developed 50+ applications having MySQL as backend in Cloud Hosting, Microsoft Azure, and AWS. • Upgraded 100+ applications from older version of MS-Access to latest version of MS-Access. • Developed 400+ small/big solutions using MS Access as frontend having MS SQL Server as well as MS-Access as backend. • Strong hold on Book Keeping, Accounting, and generating business KPIs. • Sound exposure of almost all kind of business domains (Manufacturing, Trading, and Service Sector). Served almost 400+ business types. • My solution-oriented approach enables me to deal with any challenge irrespective of the problem type/size. • Currently, whatever project I work on, there is very small portion of project which may require me to study further or challenge me on how to get the work done, because more than 95% of the work is of type which I have already done in the past.
Work history

Shashvat G. has more jobs. Create an account to review them
Skills

Skills

  • Visual Basic for Applications
  • SQL Programming
  • Application Integration