Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Automation,Excel VBA,JSON,VBA,XML freelancer for Need Excel Programming & Macros Wizard - Zoho Analytics & Sheets Experience job

Posted at - Sep 8, 2021

Toogit Instant Connect Enabled


Need immediate help with setting up automated process in Excel (using Macros) to do the following:

1. Ask for / accept a JSON file
2. Expand all nested records and lists etc.
3. Edit row 1 heading names, here are some examples:
a. Remove "ResumeParserData." (ie. if title is 'ResumeParserData.SubCategory' change to 'SubCategory')
b. Remove word "Segregated"
c. Remove "Experience.Employer"
d. Remove "Qualification" and add "Edu" before remaining text
e. Remove "Certification" and add "Cert" before remaining text
4. Add "1" after all headings where there may be multiple lines, some of these include:
a. Employer: EmployerName
b. Experience: ExpStartDate, ExpEndDate
c. Education: InstitutionName, City, State, Degree..
5. Eliminate duplicate text (cells) and empty cells from within each column so that all information STARTS in row 2
6. Test data and create new columns as needed:
a. If data in rows below row 2 is different from information in row 2, then create new column next to this row with same heading but add '2' ..... continue to do this until no more new data exists (ie. column "EmployerName1" will now have new column next to it with heading "EmployerName2")
7. Insert default text for columns / headings that have no value, for example:
a. If "EmailAddress" has no value, insert "Email Address"
b. If "Address.City" has no value, insert "City"

Ultimately, this will be built into a process that needs to do the following, but for now, I JUST need a quick tool to help me work with the JSON files and see if the output is accurate
1. Parse original resume through parsing software which delivers JSON file
2. Send / Import JSON file into Excel OR Zoho Analytics (which automatically expands all the nested records and lists)
3. Automatically edit data in file so that information is in only top 2 rows (I think this is necessary but I may be wrong)
4. Save as .csv and send to Zoho Writer for data to merge with template and create reformatted resume

About the recuiterMember since Mar 14, 2020 Abdurrasyid Lut
from Bolivar, Colombia

Skills & Expertise Required

Automation Excel VBA JSON VBA XML 

Candidate shortlisted and hiredHiring open till - Oct 8, 2021

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$19.48
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Data Mining And Management category.


Related Jobs


Latest In Automation Jobs


Latest In Excel VBA Jobs


Latest In JSON Jobs


Latest In VBA Jobs


Latest In XML Jobs