JB Jesumbo O.

Excel Expert, Excel Automation, Power Query, VBA/Macros, Google Sheets

𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁-𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | 𝟳+ 𝗬𝗲𝗮𝗿𝘀’ 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 | 𝗘𝘅𝗰𝗲𝗹 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 + 𝗩𝗕𝗔 + 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 + 𝗗𝗔𝗫 + 𝗦𝗤𝗟 + 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 + 𝗗𝗮𝘁𝗮 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻 I help businesses automate reporting, clean messy data, and build dashboards that drive faster, smarter decisions. If you’re stuck with slow reports, scattered data, or time-wasting manual processes, I’ll build solutions that work fast, scale smart, and impress stakeholders. I’ve supported startups, enterprises, and operational teams across industries, optimizing Excel systems, automating reporting, and delivering interactive dashboards that drive action. 💼 𝗪𝗵𝗮𝘁 𝗜 𝗗𝗼 𝗕𝗲𝘀𝘁 ✅ 𝗘𝘅𝗰𝗲𝗹 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 & 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 • Power Query, Macros, VBA, Formulas, and workflow streamlining • Save hours weekly by automating reporting, fixing broken sheets, and streamlining workflows ✅ 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱𝘀 • DAX-powered insights, drill-down KPIs, and sleek design • Real-time tracking with Power Query, SQL, and API integrations ✅ 𝗦𝗤𝗟 & 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 • Data modeling, transformations, and reporting pipelines • Scalable data models and ETL pipelines (Azure Data Factory, Databricks) ✅ 𝗣𝗗𝗙 𝘁𝗼 𝗘𝘅𝗰𝗲𝗹 𝗖𝗼𝗻𝘃𝗲𝗿𝘀𝗶𝗼𝗻𝘀 • Fast, accurate extraction of tables, reports, or presentations from PDF to Excel or Word ✅ 𝗗𝗮𝘁𝗮 𝗖𝗹𝗲𝗮𝗻𝗶𝗻𝗴 • Data Cleaning and Transformation via Excel, SQL, & Python • Automated quality checks to remove errors before they reach decision-makers ✅ 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 • End-to-end analytics that answer not just what happened, but why 🛠️ 𝗧𝗼𝗼𝗹𝘀 & 𝗧𝗲𝗰𝗵 𝗜 𝗨𝘀𝗲 • Excel, Power BI, SQL, Power Query, DAX, VBA • Azure Data Factory, Databricks, Python • Tableau, R, Google Sheets 🌟 𝗥𝗲𝘀𝘂𝗹𝘁𝘀 𝗜’𝘃𝗲 𝗗𝗲𝗹𝗶𝘃𝗲𝗿𝗲𝗱 🚀 Built fully automated Excel + Power Query reporting systems that cut manual reconciliation time by 80%+ with one-click refresh for new data drops. 💡 Automated complex Excel workflows using Power Query, Power Pivot, and advanced formulas, replacing fragile manual processes with scalable systems. ⚙️ Cleaned, normalised, and reconciled large messy datasets (barcodes, SKUs, financials, inventory, CRM exports), eliminating false variances and data errors. 📊 Automated cost & pricing model for a trailer company → eliminated manual updates, added live dashboards, delivered “what-if” pricing scenarios. 📈 Built an operational Power BI dashboard for a utility firm; slashed costs & improved response times ⚙️ Transformed a messy 64-page PDF into a clean, structured Excel database; 100% accuracy, less than 24 hrs. 🧠 Developed an Excel Macro with a clickable pop-up that displays dynamic, line-level details ✅ 𝗪𝗵𝘆 𝗖𝗹𝗶𝗲𝗻𝘁𝘀 𝗖𝗵𝗼𝗼𝘀𝗲 𝗠𝗲 • Fast and accurate delivery. • 7+ years of experience with SQL Reporting, VBA, and Power BI Dashboards • Experience with data cleaning, analysis, BI reporting, and dashboard storytelling • Trusted by teams to deliver insights, not just pretty visuals • Microsoft Certified (PL-300) 𝗖𝗹𝗶𝗲𝗻𝘁 𝗥𝗲𝘃𝗶𝗲𝘄𝘀: ⭐⭐⭐⭐⭐ "𝘌𝘹𝘤𝘦𝘱𝘵𝘪𝘰𝘯𝘢𝘭 𝘱𝘳𝘰𝘧𝘦𝘴𝘴𝘪𝘰𝘯𝘢𝘭𝘪𝘴𝘮 𝘢𝘯𝘥 𝘢𝘵𝘵𝘦𝘯𝘵𝘪𝘰𝘯 𝘵𝘰 𝘥𝘦𝘵𝘢𝘪𝘭!" ⭐⭐⭐⭐⭐ "𝘏𝘪𝘨𝘩𝘭𝘺 𝘳𝘦𝘤𝘰𝘮𝘮𝘦𝘯𝘥𝘦𝘥" ⭐⭐⭐⭐⭐ "𝘏𝘪𝘴 𝘢𝘵𝘵𝘦𝘯𝘵𝘪𝘰𝘯 𝘵𝘰 𝘥𝘦𝘵𝘢𝘪𝘭 𝘸𝘢𝘴 𝘳𝘦𝘮𝘢𝘳𝘬𝘢𝘣𝘭𝘦; 𝘩𝘦 𝘮𝘦𝘵𝘪𝘤𝘶𝘭𝘰𝘶𝘴𝘭𝘺 𝘤𝘢𝘱𝘵𝘶𝘳𝘦𝘥 𝘢𝘯𝘥 𝘰𝘳𝘨𝘢𝘯𝘪𝘻𝘦𝘥 𝘦𝘷𝘦𝘳𝘺 𝘥𝘢𝘵𝘢 𝘱𝘰𝘪𝘯𝘵, 𝘦𝘯𝘴𝘶𝘳𝘪𝘯𝘨 𝘵𝘩𝘢𝘵 𝘵𝘩𝘦 𝘧𝘪𝘯𝘢𝘭 𝘱𝘳𝘰𝘥𝘶𝘤𝘵 𝘸𝘢𝘴 𝘯𝘰𝘵 𝘰𝘯𝘭𝘺 𝘢𝘤𝘤𝘶𝘳𝘢𝘵𝘦 𝘣𝘶𝘵 𝘢𝘭𝘴𝘰 𝘶𝘴𝘦𝘳-𝘧𝘳𝘪𝘦𝘯𝘥𝘭𝘺. 𝘏𝘦 𝘮𝘢𝘥𝘦 𝘮𝘺 𝘭𝘪𝘧𝘦 𝘴𝘰 𝘮𝘶𝘤𝘩 𝘦𝘢𝘴𝘪𝘦𝘳, 𝘢𝘯𝘥 𝘐 𝘵𝘳𝘶𝘭𝘺 𝘢𝘱𝘱𝘳𝘦𝘤𝘪𝘢𝘵𝘦 𝘵𝘩𝘦 𝘦𝘧𝘧𝘰𝘳𝘵 𝘩𝘦 𝘱𝘶𝘵 𝘪𝘯𝘵𝘰 𝘵𝘩𝘪𝘴 𝘱𝘳𝘰𝘫𝘦𝘤𝘵. 𝘐 𝘸𝘪𝘴𝘩 𝘐 𝘩𝘢𝘥 𝘮𝘰𝘳𝘦 𝘮𝘰𝘯𝘦𝘺 𝘵𝘰 𝘱𝘢𝘺 𝘩𝘪𝘮 𝘣𝘦𝘤𝘢𝘶𝘴𝘦 𝘩𝘦 𝘪𝘴 𝘸𝘰𝘳𝘵𝘩 𝘵𝘦𝘯 𝘵𝘪𝘮𝘦𝘴 𝘮𝘰𝘳𝘦 𝘵𝘩𝘢𝘯 𝘸𝘩𝘢𝘵 𝘐 𝘱𝘢𝘪𝘥! 𝘐 𝘸𝘪𝘭𝘭 𝘥𝘦𝘧𝘪𝘯𝘪𝘵𝘦𝘭𝘺 𝘣𝘦 𝘩𝘪𝘳𝘪𝘯𝘨 𝘩𝘪𝘮 𝘢𝘨𝘢𝘪𝘯 𝘢𝘯𝘥 𝘸𝘪𝘭𝘭 𝘢𝘤𝘵𝘪𝘷𝘦𝘭𝘺 𝘴𝘦𝘦𝘬 𝘰𝘶𝘵 𝘰𝘱𝘱𝘰𝘳𝘵𝘶𝘯𝘪𝘵𝘪𝘦𝘴 𝘵𝘰 𝘸𝘰𝘳𝘬 𝘸𝘪𝘵𝘩 𝘩𝘪𝘮 𝘪𝘯 𝘵𝘩𝘦 𝘧𝘶𝘵𝘶𝘳𝘦. 𝘐𝘧 𝘺𝘰𝘶'𝘳𝘦 𝘭𝘰𝘰𝘬𝘪𝘯𝘨 𝘧𝘰𝘳 𝘴𝘰𝘮𝘦𝘰𝘯𝘦 𝘸𝘩𝘰 𝘥𝘦𝘭𝘪𝘷𝘦𝘳𝘴 𝘩𝘪𝘨𝘩-𝘲𝘶𝘢𝘭𝘪𝘵𝘺 𝘸𝘰𝘳𝘬 𝘸𝘪𝘵𝘩 𝘢 𝘲𝘶𝘪𝘤𝘬 𝘵𝘶𝘳𝘯𝘢𝘳𝘰𝘶𝘯𝘥, 𝘭𝘰𝘰𝘬 𝘯𝘰 𝘧𝘶𝘳𝘵𝘩𝘦𝘳 𝘵𝘩𝘢𝘯 𝘑𝘉. 𝘏𝘪𝘨𝘩𝘭𝘺 𝘳𝘦𝘤𝘰𝘮𝘮𝘦𝘯𝘥𝘦𝘥!" 🧭 Let's Build Something That Makes Your Data Work Harder. Stop wasting hours on manual reports or cluttered Excel files. Whether you need a one-off automation, a Power BI dashboard, or a full reporting overhaul, I’ll help you unlock your data’s true potential. Available for ongoing or one-off projects.🚀 📌 Ready to transform your reporting and take control of your data? Send an invite or message now; I respond fast and deliver even faster. Let's talk.