Sukhjit J.

Thank you for viewing my profile. I have more than 23 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, Car Dealer app, Inventory management,Tutor/Student Management, Bill of materials,Stock Portfolio Management, Time sheet and many other custom programs. 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, stored procedures, SQL views,TVFs,. I have migrated MS Access data to SQL sever on many occasions. Expertise in Downloading Yahoo Finance,Google Finance and Reuters finance data. Web scraping