I have more than 22 years of MS Access/Excel/VBA/VB/SQL Server/Azure/Visio automation/MySQL/Zillow API/Google Finance API/Optionslam API/Alphavantage API/US Census API/Browser Automation/Word Automation/Mail merge/Yahoo Finance/XML/Google Sheets/Google API/Outlook/Web-scraping development experience. I have worked on Sales Quotation Project Management, Contact Management System,Car Dealer app, Inventory management,Tutor/Student Management, Bill of materials,Stock Portfolio Management, Time sheet and many other custom programs. I have been developing MS Access based solutions since MS Access 95 I have created Multi language MS Access based solutions. I have long experience in Data Scrubbing/cleansing, removing duplicates, normalizing,making it ready for import into other systems. I did integration of MS Access/Excel based applications with Enterprise ERP systems and CRM systems(Great Plains, Infor SX, Microsoft CRM,Progress,Maximizer,Sage, QuickBooks, Goldmine,ACT,Salesforce).I have built hundreds of custom programs for clients. Most of the time I can take modules out of my previous work. That helps me to bring down the cost. Expertise in Data Extraction from different file formats (SQL server Data, MS Access, csv, text, xml. html, edi, doc, docx, xls, xlsx). I have converted many old MS Access/Excel solutions to newer versions of MS Access. I have been working with MS Access front end solutions with SQL server as backend. To make the program run efficiently I have used pass through queries,Functions, stored procedures, SQL views. I have migrated MS Access data to SQL sever on many occasions. Built tools for MS Word automation, extracting Document revisions, metadata.
Thanks
SJ