- Can get the data cleansed off the 92K records.
- Have expertise in Data handling, cleansing and performing the ETL operations on data, so that it matches the target system where the data needs to be imported.
- Will confirm with you the data after the cleansing before porting on to the target system.
- Have Exposure to Salesforce and have handled data import/export making sure the constraints are handled and all data rows uploaded. to the system.
- Have done one such Salesforce data clean up and formatting, and many data validation projects (Freelancer).
- The target could be any system.
Sample complicated projects completed via Freelancer using Macros
- Canada based Heating Design Soln: Have implemented a very complex heating model, selection of wires based on Amp, Volt, Resistance, and the total amps for the rooms not exceeding a certain threshold. If so reiterate the solution with the next available wire model.
-For a Canadian firm Tax firm - based on employee, wage, hours, resideing province based on the reference tables calculate the Provincial and the Fed tax. Each Province having its own reference tables plus the Federal references and you have to have many combinations before calculating the deductions. The calculations matched the Canadian Govt Tax agency calculations.
- Dynamic Drop Downs - There are five levels of categories in which the each category should depend on previously selected one like which Field, HR Manager, Manager, Location as this needs to be