Experienced professional with multiple skills looking for extra work. Very diligent, attentive to details, hard working and honest. Guru in MS Office Applications (company SME (Subject Matter Expert)) VBAs and Macros Knowledgeable in computer software and hardware problems Many years of customer service including managing a large team of customer service agents Excellent written and speaking communication skills I sell time by adding automation to any office product! Think about those repetitive tasks you do - the quarterly tax submission, the monthly sales report, the weekly client summary, the daily call stats. They can all be automated. If you have something in an office file (a csv of sales numbers, or a word report, or a daily email you receive with information) and you need to get it into something else, or do something with it, it can be automated. You may think "its easy - and it only takes 45 minutes once a week" - that's 2,340 minutes a year which is 39 hours a year. A whole week of every single year is spent doing something "easy". If you have a week a year to spend creating a PowerPoint, or emailing a client report, or whatever it may be then think about what else you could do with that time. Non-repetitive tasks are equally important - it may be a one time mailing or combining multiple datasets into one but the need for accuracy and speed may still make automation worth while. Based on East Coast of United States

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.

Data does not lie. The real challenge is that most individuals and businesses struggle to clearly understand what their data is actually saying. That is where I come in. I help businesses and individuals transform raw and messy data into clear, reliable insights through structured Data Analysis, accurate Data Entry, and thorough Accuracy Verification. As a results driven Data Analyst and Spreadsheet Automation Specialist with a B.Eng in Electrical and Electronics Engineering, I design scalable data systems that combine Microsoft Excel, Google Sheets, and modern spreadsheet software with advanced Data Analytics and Data Visualization to support faster and more confident decision making. My work includes building automated dashboards, end to end business workflows, and automation driven solutions using Power Query, SQL, Python, Visual Basic for Applications, Google Apps Script, Zapier, Google Forms, and Google Docs, allowing organizations to eliminate manual processes, maintain data consistency, and operate with clarity at scale. My work goes beyond one off dashboards. I design full business systems that continue to operate accurately over time. This includes sales tracking systems, operational dashboards, healthcare and performance reporting tools, ETL style data cleanup processes, and advanced Data Visualization that helps stakeholders instantly understand what matters. I also have strong experience in Financial Modeling, including building a driver based three statement financial model with forecasting, which demonstrates my ability to handle structured financial analysis at depth. What I help clients with - Automated dashboards with real time Data Visualization and KPI tracking - Custom Microsoft Excel and Google Sheets systems for business workflows - Data Analysis and Data Analytics for sales, finance, operations, and marketing - Data Entry systems with built in validation and Accuracy Verification - ETL style data cleaning and transformation using Power Query and SQL - Automation using Zapier and Google Apps Script for reporting and alerts - Financial Modeling and forecasting inside Excel - Spreadsheet software solutions that reduce errors and save time Why clients choose to work with me - I do not just present numbers. I build systems that continue to work efficiently after delivery - I focus on business outcomes, not just formulas or visuals - I communicate clearly, respect deadlines, and take ownership of results If you are still updating spreadsheets manually, dealing with scattered data, or making decisions without clear visibility, I can help you fix that. Tell me what you are trying to achieve, and I will design the data system that gets you there.

I am a systems analyst, software developer, professor and researcher with many years of experience and a PhD in Computer Science. I have developed systems for diverse industries and researched/published mostly in the areas of artificial intelligence and games. I'm also a polyglot with a long experience with languages such as English, French and Spanish.

MICROSOFT OFFICE SOLUTIONS ------------------------------------------ Over 25 years of experience… …with EXCEL (including VBA) creating automated spreadsheets, dashboards, pivottables, report templates, and other custom solutions. …with ACCESS (including VBA) creating easy-to-use, full-featured data apps, both large and small. …with POWERPOINT (including VBA) creating simple to complex report templates used in tandem with Excel and/or Access.* By leveraging my expertise with Microsoft Office and VBA, I can automate complex processes and create customized solutions tailored to your specific needs. I can create macros to automate repetitive tasks, develop custom add-ins to enhance functionality, and even integrate Office with other applications to create seamless workflows. Whether you're struggling with data entry, document formatting, or complex calculations, I can help you save time and reduce errors, so you can focus on what really matters – growing your business and achieving your goals. * Please note, my PowerPoint offerings do not include mind-blowing, eye-catching visual presentations. I’m definitely not right-brained enough for those projects! (In all honesty.) ETL DATA WORKFLOWS (EASYMORPH) ------------------------------------------------- Over 3 years of experience building simple to complex automated, no-code ETL solutions using the EasyMorph ETL application. An ETL (Extract, Transform, Load) designer is an expert in designing and implementing data integration processes. They can help you extract data from multiple sources, transform it into a consistent format, and load it into your target system. With my expertise in EasyMorph, I can create customized solutions to meet your specific data integration needs. ETL workflows can help you improve data quality, reduce data inconsistencies, and increase your operational efficiency. They can help you automate manual processes, integrate data across multiple systems, and provide valuable insights into your data. With an ETL solution, you can gain a competitive edge in your industry and make data-driven decisions to drive your business forward. Sometimes an “Excel” solution isn’t an “Excel” solution – it’s an ETL solution! Please refer to my “Excel vs Access vs ETL” Consultation for more information. IT WOULD BE MY PLEASURE to connect with you to discuss your project and what experience and skills I can bring to the table. With your vision, and my experience, we can create your perfect solution!

With over 20 years experience developing software, I help businesses and organizations grow by offering software assessment, consulting, and custom development. There are thousands of fantastic software developers out there, why would you choose me? One thing that sets me apart is that my approach is not to just simply develop a custom solution. I'll work with you to figure out if you even need custom development. Many times there are existing solutions out there that can get you going immediately. Selecting an already on the market solution can save you thousands of dollars, but they don't always suit everyone's needs. If after review, you and I both come to the conclusion that a custom developed solution is indeed the best route, then I'm happy to put together a formal proposal and build it for you. I absolutely guarantee customer satisfaction, and this is how I do it. I don't bill by the hour, you will always get a completely fixed price upfront, and that price will not change. With a fixed price you'll know down to the nickel how much you will spend for my services. Someone who works hourly is going to give you an "estimate" which will just be a guess. You may or may not already know that 50% of software projects go over their estimate, and of those 75% go over by double. Not only do I guarantee my price, I guarantee my work. Once the solution is complete, rest assured that if you ever find an issue/bug I’ll fix it for free. For Life. This is not a special offering accounted for by increasing the price, this is how I work. I stand behind every solution I create. While the software I develop is stable, and built to last, it’s always possible that something unexpected will occur. When this happens, I will always address this issue, no questions asked. And finally, I offer a 100% money back guarantee. So, before we get to building your solution, lets talk and find out what I can do for you.

Offering a complete electronic systems design and consultancy service. With small overheads I can impart a professional personal flexible service to deliver a quality reliable product at low design costs. An innovative, well-organised individual with an extensive background in electronic system design and product development. An effective, disciplined and reliable worker who has the ability to meet targets and objectives and has the persistence to achieve the highest standard in every undertaking My name is Dave Lelievre and I am an innovative, well-organised individual with an extensive background in electronic system design and product development. An effective, disciplined and reliable worker who has the ability to meet targets and objectives and has the persistence to achieve the highest standard in every undertaking. I have been an electronic design engineer for over 35 years after graduating in 1975 with a first class honours degree in Electrical and Electronic Engineering. I encompass the knowledge and resources to implement the following tasks in an innovative and imaginative way:- Digital Design including FPGA, high speed and microprocessor Analogue Design - Instrument, measurement and high voltage PCB Layout Product Specification and Reports EMC Compliance Consultancy Reverse Engineering - New replacement product with circuit diagram and parts list Test & Manufacture - Strong links with local companies to provide a full procurement, manufacture and test service. Software Development - Windows Visual Basic 6 and firmware in C Interface Design - Bluetooth, PCI, USB, RS232, RS485, I2C, SPI, VXI, VME Full System Design - Concept to fully tested and evaluated developed product

I am a talented software developer with an eye for details and excellent communication skills. I write software with maintainability in mind so that I deliver a robust solution to the customer. I do mainly .NET projects (windows forms, ASP.NET, WPF), I also work in Sql Server tasks. I have built a solid experience in working as a freelancer, so I know how to keep the buyer in the loop with clear communication and transparent deadlines.

Would you love to get rid of those boring, long, and repetitive tasks that seems to have no end and affects your productivity? Here's where automation takes place. It can help you to not only save time and money, but also helps you to reduce human error (which we all have been blamed for before). If you can relate with at least one of those things mentioned above, or you simply want to make your life at work at least a little easier, then you are in the right place! My experience and expertise can help your business to grow with the leverage of AI and automations. I can help you increase productivity by decreasing the time spent on tasks that will be done by computer programs. Here are some examples of where and how (but not limited to) we can work together: 👨🏻‍💻 Web Scraping There’s some data somewhere on the internet that you would like to have it stored locally on your computer, in a structured format, such as an Excel spreadsheet. We can create a Python script using libraries like Selenium to scrape data from multiple sources like: • Ecommerce Websites (Amazon, eBay, Walmart, etc.) • Social Media Profiles (Instagram, Facebook, LinkedIn, etc.) • Law Firms • And many other websites that you may think of 🥇 Ecommerce Development You have an Ecommerce business where you only rely on the platform itself (eBay, Amazon, etc.), and you would like to create an Excel user-friendly spreadsheet that contains all information about your items, customers, etc. that helps you keep a daily tracker that you can easily use and share with another team members. 🛠️ Script Automations You receive emails on a daily, weekly or monthly-basis, that contain files with sales reports. Then you need to download the file, and create a new report every time. 💻 User-friendly Spreadsheets You want to have tailored spreadsheets that suits your own business needs. Payroll Management, Inventory Tracker, Budget Tracker, etc. You name it! Clean and organize your current spreadsheets to help you declutter your work and make it easier to use. My expertise lies in creating tailored solutions that could be as similar as those mentioned above, or your own specific issues that needs to be solved. To help you create these solutions, I provide my expertise and experience using tools like: • Microsoft Excel (VBA, Power Query, Power Pivot) • Microsoft Power Automate • Make.com • Zapier • n8n • Automation Scripts with Python • ChatGPT (Open AI) With the correct use of these tools, we can create solutions that with only a couple of clicks will get the work done for you. You'll move from taking hours (or even days) of work to have your data organized, usable and readable within minutes. My main goal is not to only create tailored solutions or help you with your current projects, but also create a unique experience. I will achieve this by: 🌟 Active listening: I'll make sure to listen and understand what you are looking for by using probing questions and give you continuous updates on the status of your project, so you can let me know if you want anything to be improved or changed before its completion. 🤝 Communication: Once we start working together, I want you to feel comfortable and confident that your project is on the right hands. You will feel that you are side by side working with me while I communicate every step of the process as it's being worked on. 💼 Experience: Once your project is completed, I'll follow-up with you to make sure everything is running smoothly and as desired. Let's work together to make your job/life easier! ---------------------------------------------------------------------------------------------------------------------------- 🌟 "Brian took my clunky spreadsheet and turned into a smooth, automated and professional excel workbook. A lot of data is included and after Brian's work my time spent on manually inputting data will be far less! Brian was terrific to work with, great at clarifying my objectives, updating me with progress and then finessing a few little things for me once he was done. Will absolutely use again!" - Kate B. 🌟 "Brian defiantly understands Microsoft Excel, macro, vba, formula, automation. Don't think a second chance hire him for your project." - Derrick H. 🌟 "Working with Brian was a breeze. He has delivered everything as asked and on time, never hesitated to clarify things and communicated very clearly his progress, steps and when the result can be expected." - Santa S.

Hi! My name is Francis. Thank you for visiting my profile page. I am a trained Lean Six Sigma black belt who helps businesses in achieving their goals through quality control, continuous improvement and innovation. I also have over 12 years of experience in functional and reliability testing of power supplies. I am very familiar on use of test equipment such as multimeters, logic analyzers, oscilloscopes, as well as equipment for reliability testing such as environmental(temperature and humidity) and vibration chambers. In addition, I have handled a lot of process improvement projects for SMT manufacturing processes. On the sides, I lead a team of developers to build a shop floor management system for an SMT production facility to help it become a smart factory. My strengths are: - skilled in both hardware and software development. - experience in arduino, raspberry pi projects, and the likes. - experience in working with SQL, MS Access, ERP and MRP systems - familiar with test equipment. Can develop test automation software - well-versed in MS Excel macros. - has a good understanding of SMT manufacturing processes. - has an access to an SMT manufacturing facility (in case client decides to do mass production) - SMT manufacturing consultant - can offer 3D printing solutions. What I can offer: - MS Excel Macro solutions - Web/Data Scraping - hardware development (arduino, raspberry pi, iot, other microcontrollers) - Desktop application development - Database design - Develop Test Automation software - Process Documentation - Process Improvement - Process Automation