Edmar Ocampo

💼 15+ years' experience in Data Analysis

⚙️ Automating Excel | Google Sheets Reports

📊 Create insightful Charts | Visual

🥇 Strong, Creative Top-Rated Analytics Expert

𝙇𝙚𝙩'𝙨 𝙨𝙞𝙢𝙥𝙡𝙞𝙛𝙮 𝙔𝙤𝙪𝙧 𝘿𝙖𝙩𝙖 𝙈𝙖𝙣𝙖𝙜𝙚𝙢𝙚𝙣𝙩 𝙏𝙤𝙙𝙖𝙮! 👇👇👇

🎯Data Geek | Analytics 📊

✅Collecting and managing data, including exploratory data analysis

✅Identifying trends and patterns in complex datasets

✅Quality assurance and data cleansing, using MS Excel and Power Query

✅Producing interactive dashboards, graphs, tables, pivot tables, pivot chart and other visualizations, using MS Excel, Power BI, and Spotfire

✅Creating presentation decks using PowerPoint (or similar)

✅Providing written reports on findings

🎯Microsoft Excel and Google Sheet Expert

✅Create, modify and do stunning formatting on spreadsheet

✅Calculation and Accounting

✅Auditing and repairing spreadsheets

✅Data modeling and transformation

✅Data Entry and Cleansing thru Power Query

✅Data sorting, filtering and duplicate removal

✅Generation of charts, graphs and dashboard

✅Maximize use of pivot tables

✅Utilize look up, excel functions

✅Creating basic and complex formulas

✅Perform conditional formatting

✅Simplify task using basic code and macros

✅Google Sheet linkage using Importrange and Query Function

🎯SQL Expertise for Querying Task 💻:

✅Writing SQL queries to extract data from databases.

✅Using advanced SQL techniques such as subqueries, joins, and window functions to extract complex data.

✅Creating and optimizing indexes to improve query performance.

✅Optimizing SQL queries for better performance.

🎯Freelance Experience 💼:

I have a wide range of freelance experience from 2022 to 2025.

My tasks included data cleanup 🧹, codebook revisions ✏️, data linkage 🤝, mapping review 🗺️, data exploration/analysis 🔍, formula generation 💡, look up and chart generation 📈, spreadsheet auditing 🔎, process simulations 💻, risk assessments 🔍, process documentation creation 📝, cost reduction programs implementation 💰, KPI monitoring systems review 🔎, Interactive Real Estate Dashboard 🏠, Activity Log and Time Tracker ⏱️, Google sheet look up formula optimization 📊, Student Evaluations Infographic and Business plan, Pricing Calculator, Google sheet COGS file clean up, Interactive Dashboard for list of Clients, Compound interest calculator, Meta Rolling Data Dashboard, Google Ads Dashboard, Customer Journey Pipeline Dashboard, Email Marketing Dashboard, Income & Expense Analysis, Product Monitoring Template, Revenue Report Dashboard, Salesfoce Health Check Dashboard, Goal Tracker, Sales Dashboard, Bracelet Logs Dashboard, Customer Conversion rate, Employee Efficiency, Payroll Dashboard, Customer Lifetime Value Dashboard, Medical and Supplies Dashboard, Car Dealership Dashboard, POS and Booker Summary Template, KPI - Retail Production Statistics Report, Retail Origination Report, Google Sheet Tracker Template, Service Count Reconciliation, Survey Data Preparation and Analysis Task, Program Dashboard and Analytics, Audition Analytics, Immigration Dashboard, Financial Dashboard, Trading Strategies Performances Tracker, Calendar Monitoring Sheet, Closer Metrics KPI Tracking, Sales Data Conversion, Royalty Dashboard, Pay Tracker and Pay Projection, Tarrif Calculator, Cash Flow Google Sheet Update and Financial Model formatting in Microsoft Word and Excel 📄💼.

I have also worked on various tools like Google Sheets 💻, MS Word and Powerpoint ✏️ for tasks like creating templates 🎨 , formatting documents ✂️ etc.

My freelance experience also includes working on projects like ‘Covid 19 Survey’ 🦠 , ‘Data Linkage’ 🤝 , ’ Data Exploration’ 🔎 , ‘Real Estate Template’ 🏠 , ‘Gantt Chart’ 📊 , ‘Election Result Comparative Analysis’ 🗳️'Dashboard Design' 🖥️ 'Spreadsheet Tutorial' etc.

Is there anything else you would like me to help with? 😊 Let's Connect!!!