I am Trupti Patel having more than 4+ yrs of experience in Excel VBA and scrapping projects Open the websites and scrap the data as per clients requirements and format that data and provide to clients and provide good quality work.
I have created so many scraping projects from various websites. Recently I have created the macros for the creating folder,copying and pasting the files from one location to another, open the excel files and copy paste the data with perfect header with formatting with providing the status of the work. ex. while pasting the data DATE should be in fix format. etc.
I am also using selenium, iMacros, regex etc. tools for data scraping. I am working as a Service Data Analyst in Cummins Inc. in VBA Excel Macros, Excel formulas like Vlookup, Hlookup, Pivot Tables,Grouping, What if analysis, Data Validation, Naming, Sorting, Filtering etc.I have extract data for apetiz.com,Zocdoc.com, Linkedin - Profiles,Facebook etc.