Joseph Randy M.
Microsoft Access, Excel, SQL Server & Custom Web App Developer
🎯 My team and I build custom business applications: Microsoft Access databases, Excel/VBA tools, SQL Server back ends, and the custom web apps that replace them when a business outgrows Access or Excel. I have over 25 years of experience in "all things data". Please read on! 🌟🌟🌟🌟🌟🌟 100% JSS and TOP RATED PLUS with over $1M earned on Upwork! 🌟🌟🌟🌟🌟🌟 I am near Cincinnati, OH, and have expert developer experience with Microsoft Access (MS Access), VBA (Visual Basic for Applications), and really "all things data". Specifically, Microsoft Access Administration, Microsoft Access Programming, and being a Microsoft Access Developer. Please allow me a few minutes to describe why I am the perfect and best fit for your project. 📌 What I build now: ✔️ Custom web apps: database-backed business apps that run in the browser, often replacing an Access database or a set of spreadsheets ✔️ Moving Access and Excel to SQL Server (Azure or on-prem) or to the web ✔️ Microsoft Access: new databases, fixing and speeding up existing ones, forms, reports, VBA and multi-user setups ✔️ Excel and VBA: macros, financial and forecasting models, dashboards and multi-sheet reports ✔️ Automation and integration: order and EDI workflows, data imports and exports, APIs 📌 Non-Technical reasons you should hire me: ✔️ Always get a timely response to any message ✔️ Receive frequent updates without having to ask continuously ✔️ I will commit the hours needed to get the tasks done quickly ✔️ I am trustworthy and down-to-earth ✔️ I understand the human element and focus as much on "EQ" as "IQ" ✔️ I understand "end users" and test with this in mind BEFORE sending anything back to you for review. ✔️ I understand business and that you need "value-add". I will add value immediately. 📌 Technical Reasons you should hire me: ✔️ I worked at Fidelity Investments for 15 years and started their Business Intelligence Team, which managed around 75 mission-critical Access Databases for the firm. During this time I: ★ Worked with Microsoft Access (MS Access) and VBA (Visual Basic for Applications) to create an administration system to manage all the company's hundreds of other rouge Microsoft Access Databases (MS Access) applications. ★ Devised a strategy and roadmap for each Access Database we discovered to either upgrade to SQL Server, Oracle, or MySQL back-ends, convert the front-end to a web application, or leave it as is. ★ Used Informatica Power Center as an ETL platform ★ Used Access, Oracle, SQL Server, and MySQL databases and also Oracle Goldengate ★ Used Power BI, SAP Business Objects, Web Focus for reporting platforms. ✔️ After Fidelity Investments, I joined another fortune 500 financial institutions where I continued to use Microsoft Access (MS Access), VBA (Visual Basic for Applications), Microsoft Excel (MS Excel), Informatica PowerCenter / Developer / Analyst / Power Exchange, Oracle, MySQL, SQL Server, Tableau, Cognos, PowerBI, SQL Developer, and ER Studio in the Information Management Organization. ✔️ During my 25-year career, I have experienced all things "data" that you can imagine. I consider myself an overall expert in the “Information Management” space, from creating / managing complex Excel and Microsoft Access (MS Access) database applications to complex data mappings and reading and writing to any source you can imagine. ✔️ I also have much experience in database modeling, star schemas, reporting tools such as Tableau and PowerBI, normalization, database structures, SQL in general, and up-sizing Microsoft Access (MS Access) application back-ends to Oracle, SQL Server (Azure or on-prem), or MySQL. ✔️ I have led multi-million-dollar transformational development projects for enterprise-wide operational data stores consolidating data from over 30 sources across the enterprise. 🎯 I have complete libraries of reusable VBA code, forms, and reports which I can quickly add to any new MS Access or MS Excel Application to make them extremely nice, very quickly! 🏁 I can complete tasks on a tight deadline with proper testing and well-written code with comments for better readability. I can deliver the quality work you deserve. 🏆🏆 I take pride in my personal Upwork Profile, having the perfect Job Success Score (100% JSS), the "TOP RATED PLUS" badge, and the numerous 5-star client reviews. Please read some of the responses from my previous clients, and I think you will quickly agree that I am a perfect fit for your project and you can put your trust in me.
Earnings and projects
An estimate from an earlier read
Last 6 months: $51k
Billed in all: $1,994,229$1.99M
$5.1k in the last 6 months
Across 11 contracts
Across 528 contracts
Earnings, last 30 days
Dotted: longer than usual between two readings.
Skill rankings: Top 0.19% in Microsoft Excel
Top 1% in 4 of 7 skills, ranked by MRR among everyone on Upwork with the skill.
- #4Microsoft Access862 freelancers · 🇺🇸 #4Top 0.46%🇺🇸#4 of 223
- #7Microsoft Access Programming321 freelancers · 🇺🇸 #6Top 2%🇺🇸#6 of 120
- #12Visual Basic for Applications1,453 freelancers · 🇺🇸 #7Top 0.83%🇺🇸#7 of 296
- #23Database Design2,161 freelancers · 🇺🇸 #10Top 1%🇺🇸#10 of 296
- #26Data Modeling1,203 freelancers · 🇺🇸 #14Top 2%🇺🇸#14 of 228
- #62Microsoft Excel32,523 freelancers · 🇺🇸 #39Top 0.19%🇺🇸#39 of 4,623
- #124SQL12,903 freelancers · 🇺🇸 #49Top 0.96%🇺🇸#49 of 1,997