Freelancer profile translated to English.

Description

I work as a Data Specialist with experience in Microsoft Excel, Power Query, and Power Pivot.

I work with companies, freelancers, and administrative teams to organize, clean, and transform their data to make it more reliable, consistent, and easy to use in reports, dashboards, and internal processes.

I can help you with Data Cleaning, Data Quality, and Data Management tasks in Excel, especially when working with messy files, duplicate data, inconsistent formats, or manually updated reports.

My services include:

- Data cleaning and normalization in Excel.

- Detection of duplicates, format errors, and inconsistencies.

- Data transformation with Power Query.

- Modeling with Power Pivot.

- Automation of recurring reports.

- Creation of simple dashboards and tracking charts.

- Data preparation for analysis, reporting, or internal decision-making.

- Improvement of Excel files to reduce manual work and errors.

My focus is on having organized, validated data ready to work with. If your company wastes time cleaning files, manually reviewing data, or updating repetitive reports, I can help you simplify that process.

Industry field of expertise

Languages

Spanish
Native or bilingual
Italian
Fluent

Workplace preferences

Remote only

Primarily works remotely

Family Upholstery & Furniture Repair Business
Data Specialist (Excel) | Back Office
March 2021 - Today (5 years and 3 months)
Milán, Italy
- Design and maintenance of a centralized database in Microsoft Excel for order tracking using unique identifiers, improving the traceability of historical records.

- Organization of data related to orders, billing, and digital documentation, maintaining a clear structure for internal consultation and tracking.

- Implementation of data validation rules and field standardization to reduce manual errors and inconsistencies in records.

- Quality control of information through review of duplicates, incomplete fields, and discrepancies between documents, orders, and internal records.

- Development of an accounting support tool in Excel using Power Query to extract, transform, and load key data from PDF invoices.
Data Quality Data Cleaning Data Validation Data entry clerk Microsoft Excel
Agro - export and Mining Companies
Occupational Medicine
May 2014 - December 2018 (4 years and 7 months)
Trujillo, Peru
- Weekly consolidation of Security and Human Resources data into a master Microsoft Excel file, maintaining an organized structure for historical consultation.

- Cleaning and standardization of columns, formats, and key fields to improve data consistency and reduce manual entry errors.

- Application of data validation and Data Quality rules to maintain more reliable, complete, and easy-to-review records.

- Coordination with different areas to resolve missing information, inconsistent data, or records that needed review.

- Creation of weekly reports in Excel with pivot tables and charts for tracking incidents, medical assistance, occupational exams, and fit/unfit status.

- Preparation of information for internal reporting, facilitating operational monitoring and identification of areas with a higher number of incidents.
Microsoft Excel Data entry clerk Data Reporting Data Quality Data Validation