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 - Oct 20, 2023

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 Nov 11, 2022 Ajeet Parmar
from England, United Kingdom

Skills & Expertise Required

Automation Excel VBA JSON VBA XML 

Open for hiringApply before - Apr 17, 2024

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job

Offer to work on this project closes in 47 days!
Are you interested in this Opportunity?

Apply Now

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