
Ahmad
Data Science Analyst
Skills

Bekijk mijn diensten


Portfolio
Werkervaring
Senior Data Analyst & Spreadsheet Specialist
Freelance • Freelance
Jan 2025 - Present • 1 yr 9 mos
Engineered end-to-end data cleaning, data formatting, and business intelligence analytics solutions for global corporate clients, e-commerce brands, and financial teams. Specialized in resolving complex data integrity issues by transforming messy, unstructured, and duplicate-heavy raw datasets into standardized, audit-ready, and highly scalable spreadsheets. Demonstrated deep technical expertise across Microsoft Excel, Power Query, Google Sheets, SQL, and Power BI to build automated data transformation pipelines. Streamlined reporting workflows by establishing automated ETL (Extract, Transform, Load) routines that extract data from disparate sources—such as PDF invoices, CRM exports, biometric attendance logs, and POS transactional records—and parse them into structured, unified database architectures. Key Responsibilities & Professional Accomplishments: • Data Hygiene & Standardization: Applied advanced data deduplication, text casing normalization, data type validation, and column mapping routines to eliminate data entry errors and prevent system import failures. • Workflow & Pipeline Automation: Built automated Power Query workflows and customized formula frameworks (XLOOKUP, INDEX/MATCH, SUMIFS, LET, LAMBDA) to reduce manual processing time by over 80% while ensuring 100% calculation precision. • Business Intelligence & Visual Reporting: Designed dynamic KPI summary cards, interactive dashboards, slicers, and automated Pivot Tables to give business owners real-time, actionable insights into revenue streams, inventory levels, workforce punctuality, and operational overhead. • Audit & Compliance: Executed strict data auditing protocols to identify missing SKUs, reconcile financial variances, detect duplicate payroll entries, and uphold uncompromising standards of data confidentiality, privacy, and precision across all project deliverables.
Data Analyst
Fiverr • Freelance
Jan 2025 - Present • 1 yr 9 mos
Provided end-to-end data cleaning, formatting, and analytical solutions for global clients. Focused on resolving data integrity challenges by transforming unstructured, duplicate-heavy datasets into standardized spreadsheets. Leveraged advanced Excel functions, automated workflows, and dynamic Google Sheets templates to reduce processing errors and accelerate decision-making. Designed intuitive Pivot Tables, automated formula structures (XLOOKUP, INDEX/MATCH), and workforce audit dashboards to translate dense data into operational insights.