Page 1 of 5

Alejandra Garcia Lopez - Data Entry & Content Formatting Specialist

Location: Medellín, Colombia

Compensation Range Discussed (USD): $1,000 - $1,300/month

LinkedIn Profile | GitHub | email: aleja012020@gmail.com | Phone: +57 3005778494

Summary

Data Analyst with Bachelor’s Degrees in Business Administration and International Business and 2.5 years of experience supporting US-based clients in the logistics industry at PRIMO (progressing from Operations Analyst to Data Analyst). Prior to this, gained foundational experience as a Data Analyst Intern at ISAGEN. Managed large volumes of shipment and billing data, migrating and structuring massive datasets—including a project with 14 tables of up to 80,000 rows each—into SQL (MySQL) databases. Her expertise centers on standardizing structured and unstructured data from internal systems like Primus and client emails using advanced Excel tools such as Power Query, Pivot Tables, and XLOOKUP to ensure zero errors. Translates cleaned data into interactive Power BI dashboards tailored for sales teams, and utilizes Canva and PowerPoint for static, visually professional presentations, while leveraging ChatGPT to optimize formulas and streamline content formatting.

Meet Alejandra

This video from our screening interview provides a look into Alejandra's background and experience:

Candidate Snapshot

US-based Data Entry & Analysis Experience

• 2.5 Years of US Market Operations: Dedicated entirely to supporting a US-based logistics firm, managing accurate operational reporting and logistics tracking for clients across various US states and global companies with local US offices.

• Logistics Industry Specialization: Navigated fast-paced logistics operations, meticulously updating delivery times, delays, and service performance metrics where minor data variations heavily impact transit directions.

Large Datasets & Visual Documentation Formatting

• Complex Dataset Structuring: Proven capacity to handle massive information structures, executing an end-to-end migration project that involved joining and cleaning 14 separate tables containing up to 80,000 rows each using MySQL.

• Unstructured Data Standardization: Routinely extracts and cleans highly unstructured inputs from raw emails, diverse client formats, and external Excel files. Performs initial Exploratory Data Analysis (EDA) to trim information, remove duplicates, and validate variables before system integration, culminating in a strict error-documentation process to prevent future data inconsistencies.

• Client-Aligned Visual Presentation: Translates cleaned databases into polished visual materials for external stakeholders and sales teams. Uses a "storytelling" methodology specifically within Power BI to present complex information clearly to non-technical audiences. For static dashboards and visually professional backgrounds, she utilizes Canva and Microsoft PowerPoint, ensuring layouts match exact client standards.

Data Entry Expertise

• Direct Operational Data Entry: Holds over a year of dedicated experience as an Operations Analyst entering critical, structured and unstructured shipment information into specialized proprietary logistics software (Primus).

• Proactive Quality Control: Built specialized tracking files using conditional formatting to isolate discrepancies—such as duplicate entries and cost anomalies—prior to final delivery, ensuring zero-error reporting for high-priority accounts.

AI Tools Experience

• Workflow Optimization via AI: Actively incorporates ChatGPT to troubleshoot advanced Excel formulas (e.g., calculating day differentials between dates), significantly decreasing data processing time and maintaining focus during highly repetitive formatting tasks.

• Ongoing Technical Upskilling: Currently studying Cloud technologies to better understand underlying architectures supporting modern AI platforms and integrations.

Education

• Bachelor’s Degrees in Business Administration and International Business | Universidad de Medellín (2023)

• Technical Degree in Software Development | SENA Academic Alliance Program (2018)

Tools Used

• Data Structuring & Entry: Microsoft Excel (Power Query, Pivot Tables, XLOOKUP, VLOOKUP, Conditional Formatting, Data Validation), MySQL, Primus (Proprietary System).

• Presentation & Formatting: Canva, Microsoft PowerPoint, Power BI.

• Productivity & AI: Microsoft Office 365, Notion, ChatGPT.

Key Qualifications & Highlights

• Dual Business and Technical Foundation: Combines Bachelor's Degrees in Business Administration and International Business with a Technical Degree in Software Development. This intersection allows the swift navigation of unstructured business documents alongside complex Excel queries, executing operational data entry while clearly understanding underlying system integrations.

• Error-Free Delivery for High-Stakes Operations: Engineered targeted tracking mechanisms to pinpoint anomalies—such as cost discrepancies or data duplicates—before final delivery. This rigorous documentation and quality control workflow guarantees precise outputs for stakeholders making critical decisions.

• Rapid Adaptability to Proprietary Platforms: Demonstrates a fast learning curve within specialized internal software environments. Mastered internal logistics application systems through a short initial shadowing period, swiftly transitioning to independent data entry and management within two weeks.

• Stakeholder-Driven Layouts & Formatting: Translates raw analytical inputs into visually polished presentations tailored to strict external client guidelines. Employs a specific "storytelling" approach, ensuring non-technical audiences can easily digest complex information while maintaining high-quality brand consistency.

• Systematic Task Organization: Proactively utilizes Notion boards to track daily deliverables and deadlines, ensuring focus, motivation, and accuracy during highly repetitive quality control workflows.

Screening Interview - Key Observations

• Ongoing Technical Upskilling & Independent Projects: Currently studying Cloud technologies to stay aligned with modern architectures, specifically noting that many AI platforms operate closely with cloud environments. Additionally, detailed an end-to-end data project where information was aggregated from internal sales teams, external terminals, and proprietary software. Cleaned unstructured inputs—such as raw transit dates, carrier details, and costs—using SQL and Excel Power Query to build an interactive dashboard that enabled sales teams to filter logistics data based on customer priorities like price or service speed.

• Task Preferences & Strengths: Thrives in roles that demand extreme attention to detail and adaptability under pressure, specifically noting that in logistics operations, minor numerical variations can drastically alter transit directions. Highly enjoys workflow optimization and relies on an initial Exploratory Data Analysis (EDA) approach prior to data cleaning to thoroughly understand variables, identify unnecessary columns, and detect errors before processing.

• Areas for Improvement: Openly acknowledged a challenge in speaking up or presenting different perspectives to senior team members. Noted finding it difficult to propose alternative execution methods when working with individuals who possess more industry tenure, indicating an initial hesitation to push back on established senior directives.

• Continuous Learning and Process Optimization: Demonstrated a strong focus on continuous learning and workflow improvement, mentioning the initiative to optimize daily operations by proactively exploring new Excel formulas and leveraging ChatGPT to troubleshoot complex date calculations and streamline repetitive data tasks.

• Systematic Organization: Demonstrated a focus on structured task management, mentioning the proactive use of Notion boards to track deadlines and deliverables.

• Client-Centric Communication and Adaptability: Demonstrated strong communication skills tailored for non-technical audiences, mentioning the use of a "storytelling" approach in presentations to simplify complex datasets. Additionally, adapts to strict client requirements by aligning expectations upfront to ensure final reports and dashboards match the exact data structures requested by external stakeholders.

• Queries and Current Pipeline: Primary queries regarding the position were technical, specifically asking for more details about the exact data the hiring company works with and the day-to-day data challenges. Additionally, noted being in the early stages of a separate interview process with a Colombian company, currently waiting for a technical interview round.