IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life cycle (SDLC). I'm a problem solver with good communication skills. I have worked with clients at all levels. I bring this wealth of experience to my Upwork clients to effectively and efficiently deliver spreadsheet-based solutions to improve their business processes and save them time. Areas of proficiency and experience: - Complex Formulas (including Array Functions) - Advanced Lookup (including lookup on multiple values/fields) - Dashboards and Data Visualization - Power Query / Data Transformation and Loading - Complex Conditional Formatting - Performance Tuning - Data Validation - Tables and Pivot Tables - Charts - VBA/Macros - User Forms / Input Parameters - Helper Columns Notable Projects: - Automated payroll processing - Dashboards of varying complexity - Data analysis and survey charting - Stock Market Portfolio/Trade tracking (including equities, options, and futures) - Fulfillment/Sales/Inventory (e.g. amazon) - Modeling - Investment Performance and Trade Tracking/Reporting - Monte Carlo Simulation - Estimation/Invoices I am now freelancing exclusively and look forward to the opportunity to work with you.

- CorelDraw Macros and plugins; Scripting (VBA, Python, VBS) - 3D engineering models and products animation - Microsoft Excel and PowerPoint macros, add-ons, - Software Development (Visual Studio , C#, VB.net) - Backend Database connectivity (SQL Server, MySQL, Microsoft Access) - Graphic Designing (Adobe Photoshop, CorelDraw) - Digital Map making, GIS Mapping, cartography Number of CorelDraw Automation projects completed are more than 150. Here's a "brief List" of projects: Year wise Experience: ------------- Year 2024: ------------- Project 1. Preparing mockup of TShirsts by opening a shirt template and aloowing to test with different graphics to place on TShirt, select TShirt color from a color palette. Also allowing to save mockup fil1e on disk to load on later stage for editing. Showing customer data and colors used properly placed on template. Project 2. Automation of sticker making by getting Excel data and updating different CorelDraw templated using that data Project 3. Importing PDF files from specified folder and aligning them on CorelDraw template. Project 4. Take selected graphic files, process them and export them as ai format. Project 5. Load CorelDraw files from a specific folder and exports files to a specific folder, page by page, by name of page. Page names are names of colors. Export formats supported are: CDR, EPS, and AI. Project 6. Get a template, read text data from file and replicate the document pages by replacing text with the data Project 7. .Allow data read from from CSV file or manually add data to create designs based on the available templates and allow export to pdf. Project 8. Allow loading template, update clocks, texts etc. of the template from data entered by user or by fetching data from mysql database. ------------- Year 2023: ------------- Project 1. Import pdf when a barcode is scanned with a barcode scanner or if the file name is entered in a box. Option to rotate the graphics 90dg counter clockwise. A button to print document. Project 2. CorelDraw macro to add dimensions to selected objects and space them Project 3. CorelDraw macro to allow variable splitting of "cooler wraps" with dimensions Project 4. CorelDraw macro that loads data from Excel sheet and prepared a document based on exiting template, placing texts and images based on data from Excel. Project 5. Macro to get data about images sizes, import images , resize and place them at specified spacing Project 6. Macro to replace texts with shapes Project 7. Color querying macro like gdgmacro Project 8. TShirts texts preparations with different options More projects to be added later on.

Struggling with repetitive tasks and manual workflows? I’m here to help you save time, reduce errors, and scale smarter through customized automation and integration solutions. I specialize in: Google Sheets & Apps Script: Automating manual workflows, generating advanced reports, and building custom scripts. API Integrations: Connecting tools such as Xero, QuickBooks, Twilio, Stripe, and more with streamlined processes. Microsoft Excel (VBA/Macros): Creating tailored dashboards, automated reporting systems, and advanced formulas. Looker Studio Dashboards: Turning complex data into clear, actionable insights for executive teams. Every project begins with one goal: making your business more efficient. By understanding your workflows and pain points, I design solutions that are: Reliable 💻 | Scalable 📈 | Easy to maintain 🛠️ Clients appreciate my business-first, results-driven approach and clear, responsive communication. Whether you need spreadsheet automation, API/webhooks integration, or better data analytics, I’d love to make your business run faster and smarter. Let’s connect and discuss how I can deliver value to your team.

| 🏆 𝗧𝗢𝗣 𝗥𝗔𝗧𝗘𝗗 𝗣𝗟𝗨𝗦 + 🏆 | Dashboard and Business Intelligence Specialist | +15 years of building data solutions in Power BI & Excel 💻 | Google Sheets| MYSQL | Power Query | DAX | M | Available 16+ hours daily | Let's use your data for your company's Success! Hi, I'm Jaime and I'm here to work with you to solve your data visualization challenges. I will be pleased to share my experience in your project to ensure you achieve the most impactful results. Your data has a powerful history to tell. Let's work together to give it a clear voice. [𝗗𝗔𝗧𝗔𝗕𝗔𝗦𝗘𝗦 & 𝗗𝗔𝗧𝗔 𝗩𝗜𝗦𝗨𝗔𝗟𝗜𝗭𝗔𝗧𝗜𝗢𝗡] ✅ Power BI / Looker Studio/ Excel's expert. Design professional and visually appealing dashboards with all the details to support your organization-specific needs. ✅ +15 years working with multi-disciplinary teams in developing advanced Data visualization and Business Intelligence solutions with the implementation of Dashboard and KPIs to improve overall metric performance. ✅ Data modeling ✅ Power QUERY for data transformation ✅ Connection to databases with SQL [𝗦𝗣𝗥𝗘𝗔𝗗𝗦𝗛𝗘𝗘𝗧𝗦] ✅ Skilled in advanced Excel functions, including VLOOKUP, Index/Match, and XLOOKUP, for comprehensive data analysis. ✅ Excel at using Power Query for data cleaning and transformation, as well as DAX for powerful data expressions in Power BI.📊. 💹 Financial projections, budgeting, and modeling in Excel 💹 Produce dynamic dashboards and reports that offer actionable business intelligence. ⚙️ Streamlining tasks with strategic MACRO implementation [𝗜𝗡𝗗𝗨𝗦𝗧𝗥𝗬 𝗘𝗫𝗣𝗘𝗥𝗧𝗜𝗦𝗘] ✅ +20 Years of work in the aerospace Industry, I know what Kpi's will add value to your business and together we can create them for your projects. Your success is my priority! Let's combine your data with my expertise in Excel, Power Query, SQL, and data visualization tools to grow opportunities hidden within your numbers. Looking forward to supporting you and your organization in achieving your objectives! [𝗧𝗘𝗦𝗧𝗜𝗠𝗢𝗡𝗜𝗔𝗟𝗦] ⭐⭐⭐⭐⭐ "Extremely happy with the work Jaime did for our company and will be hiring him on an ongoing basis. He replied quickly and stayed in communication throughout. He added everything we requested and made suggestions on how to improve the visuals requested. He definitely knows Power BI and was able to do a complex job in a very short time. Great value for our money. It would have taken me weeks to do what he completed in a few hours." ⭐⭐⭐⭐⭐ "I had a fantastic experience working with Jamie and have hired him for another project. He's able to very quickly understand the challenges of a project as well as the desired output. His communication regarding his work is very detailed and clear, and it's apparent that he takes a lot of pride in his work. He communicates the progress throughout but is also very prompt in completing his work. I've already recommended him to friends."

Are you struggling with repetitive tasks, manual Excel work, or disconnected systems that waste hours every week? I help businesses automate workflows end-to-end using Excel VBA, APIs, and modern tools like n8n so you can save time, reduce errors, and scale operations. ✔ Automated 50+ business workflows ✔ Saved clients 10–20 hours per week through automation ✔ Built systems integrating Excel, APIs, and cloud tools I specialize in: • Excel VBA automation & custom tools • API integrations (REST, JSON, third-party platforms) • n8n / workflow automation systems • Data processing, dashboards & reporting • End-to-end business process automation Whether it’s automating Excel reports, connecting apps via APIs, or building advanced workflows using n8n — I focus on delivering solutions that actually reduce manual work and improve efficiency. Clients consistently rate me 5⭐ for reliability, problem-solving, and clean scalable solutions. If you're looking to automate your processes and eliminate repetitive work, let’s discuss your project.

I solve clients' complex needs with creative and intuitive Power Platform (PowerApps, Power Automate, and Power BI) as well as Excel, PowerPoint, and Word VBA/Macro solutions to ensure my clients can run their businesses more effectively and efficiently. Applying 20+ years of VBA and macro programming experience, I provide advanced data collection, analysis, and visualization solutions. I'm well versed in all aspects of project management from conception and requirements gathering through development, troubleshooting, training, deployment, and support. Clients have praised me for my attention to detail, the solutions and results I've produced, and my communication and collaboration skills.

🧠 𝐎𝐯𝐞𝐫𝐯𝐢𝐞𝐰 I help businesses get control over their data, automate repetitive work, and build dashboards that make decision-making faster and easier. If you're stuck with manual Excel spreadsheets, slow reporting, or data that looks "messy", I turn that into clean, automated systems. I work with Excel VBA and Power BI to build practical, real-world solutions that save time, reduce errors, and give teams the insights they need without the headaches. ⚙️ 𝐖𝐡𝐚𝐭 𝐈 𝐃𝐨 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 I've been building Excel VBA tools for 15+ years, and I love taking a messy, manual process and turning it into a clean, automated workflow. Clients typically see their reporting time drop by 50%–80%, and their teams can focus on analysis instead of fixing spreadsheets. 𝐓𝐲𝐩𝐢𝐜𝐚𝐥 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧𝐬 𝐢𝐧𝐜𝐥𝐮𝐝𝐞: • Quoting, invoicing, and pricing tools • Inventory and order tracking systems • Automated financial reports • Data cleaning and transformation tools • Workflow automation systems 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬, 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 & 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 For the past 8+ years, I've been building Power BI dashboards that turn raw data into clear, interactive visuals that teams enjoy using. My focus is on clarity, usability, and helping you get the answers you need quickly—without digging through multiple spreadsheets. I also support the full data workflow behind the dashboards, including data transformation, modeling, and analysis to help businesses make smarter decisions. 𝐖𝐡𝐚𝐭 𝐈 𝐃𝐞𝐥𝐢𝐯𝐞𝐫: • KPI and performance dashboards • Financial and sales reporting • Executive-level summaries • Operational analytics • Power-Query data transformation • DAX measures and KPI development • Data modeling • Trend and performance analysis 🏭 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐢𝐞𝐬 𝐈 𝐖𝐨𝐫𝐤 𝐖𝐢𝐭𝐡 Finance | E-commerce | Construction | Retail | Healthcare | Non-profits 🛠️ 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀 𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 & 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧 🔹Excel VBA (Macros) 🔹Excel automation systems 🔹Report automation 🔹Data extraction & processing 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 & 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 🔹Power BI 🔹DAX 🔹Power Query 🔹Power Pivot 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 & 𝐑𝐞𝐩𝐨𝐫𝐭𝐢𝐧𝐠 🔹Data analysis 🔹Dashboard development 🔹Data visualization ⭐ 𝐂𝐥𝐢𝐞𝐧𝐭 𝐅𝐞𝐞𝐝𝐛𝐚𝐜𝐤 "Shai made it easy and had great ideas to simplify our order form. We went from a multi-page, multi tab order system with more than 800 options to a one-line Order form with multiple self-populating fields. We're planning to work with Shai again in the future. Excellent job and thank you again!" — Christian, EcoDomo LLC "Shai is an excellent choice to work with. He delivered Power BI materials on a very tight turnaround for our organization. He really saved the day with his follow-up support and continues to help our materials best reflect our data. I highly recommend Shai for all his listed skill sets and I look forward to working with him again!" — Robert Sanchez, CipherTrace

"Ensuring the utmost data privacy and confidentiality in client conversations is my top priority. Your information remains secure and private, guaranteed." "Google sheets/ Excel Automation, Complex Formulas (Query, ArrayFormula, Indirect, Index-match, VLookup, HLookup, XLookup), BigQuery, Looker Studio and automated Data Entry Forms" "Admin Support, Shopify, DropshipZone, Wordpress, Monday,com, Data Entry" “Top Rate Plus, 100 % JSS, Full Time + Intuitive, streamlined Google Sheets spreadsheets that finally give you the reports you’re looking for. + User-friendly systems that are easy to learn …plus I include an “Instructions” page with detailed user interface. + These Google Sheets have built-in protections to guard against users accidentally breaking the system + Finally gain the clarity to make confident decisions based on accurate data – not a gut feeling. + Work with an expert who can help you discern the right system(s) to use in your situation: Google Sheets, Google Apps Script, and / or Google Tables TESTIMONIALS 1. “Very diligent and highly responsive. Recommended!” - Phillip Thompson, United States, Nov, 2024 _____________________________________________________________________ 2. “Javed is a very good freelancer. He has strong Excel Technical Skills and was able to complete a high quality output in a short period of time. I would highly recommend him for any Excel based work.”. - Payal Seth, Singapore, Feb, 2025 _____________________________________________________________________ 3. “Javed was very diligent, prompt in communication, and skilled in working with Google sheets and formulas. Very positive experience!” Imran Saleh, United States, Nov, 2024 _____________________________________________________________________ 4. “Javed's work and response time has been phenomenal. I see him truly putting his heart into keeping his clients satisfied. It's been an absolute pleasure working with him and I would highly recommend his services.” - Wael Hussain, United Arab Emirates, Feb, 2025 _____________________________________________________________________ 5. “Javed worked very fast and did great work on my project. He was very friendly and easy to communicate with. Highly recommended. Thanks Javed!” - Isaac Allen, United States – July, 2023 _____________________________________________________________________ 6. "The best. Period. Scores perfect in all categories." & “He is who you are looking for”. - Darrick Solomon, United States – April & May, 2023 _____________________________________________________________________ 7. "Javed is very committed, we gave him the project on Friday evening to be completed for Monday morning and he delivered the project on Sunday morning. We are really satisfied with his job and his quality. 100% recommended." - Alessandro Daniele, Czech Republic– January, 2023 CREDENTIALS Unlike many freelancers, this is my full-time work. You can count on me to be available during normal business hours. - Top-rated Up work Freelancer with many 5-star reviews - Clients ranging Worldwide; from Manufacturing to Real-Estate to e-Commerce - Bachelors Dual Degree in "Arts" and "Associate Engineering". - Various education online courses from spreadsheet experts. PROCESS 1. FREE INFORMATIONAL CALL - 25 minute call where I will listen to your goals and learn about your Current Google Sheet. 2. PROPOSAL - Within 24 hours after the call, you’ll receive a precise 1 or 2 pager proposal outlining the scope of work, hourly or fixed price, and timeline. 3. SCHEDULE - Once you approve the contract and put funds in Up work Escrow, I’ll build out your project. 4. REVIEW & APPROVE WORK - We'll hop on a live call where I’ll teach you how the new system works. If you see things you would like changed, I can do a few small edits for free, or we can discuss a budget for "phase 2" that fits for you. 5. CLOSEOUT - Once you are crazy happy with the outcome, I’ll close our Up work contract and you’ll be invited to leave a review. Thank you in advance for leaving a written review! If you have questions after using the system for a while, feel free to reach out. I’m happy to help and will stay with you until you’re 100% satisfied. NEXT STEPS Click the green “invite” button to begin the conversation! Looking forward to it, JAVED MEHMOOD DATA SECURITY I’m aware that I may have access to some of your confidential data. I’ll respect your data privacy and give you tips on how to safeguard this information once our project is complete. FAQ Q: Where do you live? A: I live in twin’s city Islamabad/ Rawalpindi (Pakistan) where I enjoy big city life, hiking in the woods/ hills, and gardening. Q: Do you bill by the project or by the hour? A: Depending on the scope of work and client satisfaction, project may be billed by project or by the hours as well. This helps both of us have clear scope expectations upfront. Also, this creates an incentive for me to get

Over the course of my career, I've developed a unique set of skills with SAS, VBA, JavaScript, HTML, REXX, COBOL, Assembler and MANY other programming languages. I have consistently demonstrated out of the box thinking and serious mad coding skills to quickly bring what most people thought was impossible, into reality. Let me work on your next project to bring your next dream to fruition!

I help businesses automate repetitive workflows and save 10–30 hours per week using Google Apps Script, Excel VBA, and API integrations. I’ve completed 100+ automation projects with a 100% success rate. Automating reporting dashboards Syncing data between apps via APIs Building custom CRM/workflow systems in Google Sheets Automating email / notifications Excel ↔ Google Sheets migrations ChatGPT API integrations AI-powered workflows Automated data processing