Advanced level in Microsoft Excel - some kind of familiarity with vba, even if it's just being able to record a macro and tweak it. Function in the like of pivot tables, nested formula and knowledge of less common but powerful worksheet functions like SUMPRODUCT, INDIRECT and MATCH/INDEX.
Competent using various Database software-MySQL, Microsoft Access, Oracle database. Retrieving of data out of the data sources from flat file and database application such as Microsoft Access, Microsoft Excel and Oracle database through ETL
Please see enumerated projects below for your review in considering my job application to your prestigious company.
Warhammer Toy Project
? Posting Warhammer products into ebay.
? Creating spreadsheets for Warhammer prorducts using MS Excel.
? Append data of Warhammer Products, URL Link and Price. And make use those data for analysis of cost and profit.
Leads Generation Project
? Handle scraping of contacts through linkedin, contact number, email address etc.
? Generating Email address through possible pattern or format of the contact person.
? Responsible for Quality assurance of the leads generated before sending it to their CRM database.
U.S. Retail Establishment Database Project
? Creating spreadsheet of1500 restaurants.
? Data Append of Address, zip code, and URL link.
Excel Data Entry and Spreadsheet work
? Data Entry of Tax Certificate that include Certificate number,tax collector’s fee,purchase date, interest rate, Certificate’s amount, etc.
? Dealing with real dollar figures in a sense that amount of certificate and it’s interest should be done accurately.
Reorganization of Contact Data
? Transferring data from PDF scanned contact details into Excel.
? Reorganization of data into proper rows.
? Data cleansing: removing duplicate data and removing special character.