Asdrubal Josue S.

Excel VBA, Google Sheets & Power BI Automation Expert

Top Rated Plus | 100% Job Success | 117+ projects | 5,100+ hours I design and improve Excel, Google Sheets, Power BI, and AppSheet solutions that automate repetitive work, reduce reporting errors, and transform complex business data into clear, actionable information. My expertise goes beyond building spreadsheets. I analyze business processes, data structures, reporting requirements, and technical limitations to create solutions that are accurate, maintainable, and aligned with how each company actually operates. CORE EXPERTISE 📊 Microsoft Excel & Data Automation • Advanced Excel formulas and dynamic reporting models • VBA macros and custom workflow automation • Power Query data extraction, cleaning, transformation, and consolidation • Power Pivot and relational data models • PivotTables, interactive dashboards, and management reports • Financial, operational, production, and performance trackers • Repair, optimization, and documentation of complex workbooks • Conversion of manual processes into automated tools 📈 Power BI & Business Intelligence • Interactive dashboards and executive reports • Data modeling and relationship design • DAX measures, calculated tables, and time-intelligence logic • Power Query and M transformations • Financial closing calendars and reporting periods • Monthly, weekly, yearly, and rolling-period analysis • Rolling 12-week and year-to-date reporting • Previous-month and previous-year comparisons • Ranking, KPI, variance, and trend visualizations • Analysis and correction of inconsistencies between comparative charts • Report navigation, filters, slicers, bookmarks, and drill-down experiences • Assessment of source-data quality and granularity before development • Technical feasibility analysis when the available data does not support the requested level of detail For example, I have worked with Power BI reporting requirements involving financial closing dates, monthly views beginning in January, rolling weekly views, PMONTH/PYEAR comparisons, and validation of whether source systems contain sufficient transaction-level detail. ⚙️ Google Workspace & No-Code Automation • Google Sheets systems and advanced formulas • Google Apps Script development • Automated emails, reports, files, and recurring processes • Google Drive and Google Docs integrations • AppSheet applications connected to business data • Forms, approvals, data-entry tools, and workflow applications • Zapier integrations and cross-platform automation • Maintenance and improvement of existing Google Workspace solutions 🏭 Process Engineering & Business Operations As a Mechanical Engineer, I also bring practical experience in: • Process analysis and continuous improvement • Manufacturing and production operations • PET preform and container manufacturing • Quality assurance and test design • Research and development • Technical customer service • Project evaluation and implementation • Identification of bottlenecks, risks, and data limitations • Translation of business requirements into technical specifications • Documentation, stakeholder communication, and project coordination This engineering background allows me to understand not only how to build a tool, but also why it is needed, how people will use it, and whether the underlying data can reliably support the expected result. WHY CLIENTS CHOOSE ME • Top Rated Plus with a 100% Job Success Score • 117+ Upwork projects and 5,100+ logged hours • Strong combination of technical development and business analysis • Clear communication in English, Spanish, and Portuguese • Experience across finance, manufacturing, aerospace, real estate, IT, education, fitness, wine production, QA, SEO, and other industries • Proactive recommendations and honest feasibility assessments • Solutions focused on accuracy, usability, scalability, and long-term maintenance One client described me as an “Excel guru” who is fast, thorough, friendly, and proactive. Another highlighted my ability to solve complex technical problems while remaining flexible and easy to work with. If you need to automate a process, improve an existing workbook, create a Power BI dashboard, build an AppSheet application, or determine whether your data can support a proposed solution, send me a brief description of your current process and desired outcome. I will help you identify the right approach and turn it into a practical, reliable solution.