Database Development and Management

Randy Murphy

(0)

Starting at

$

50

/hr

About this service

Summary

🎯 I have over 25 years of experience in MS Access, MS Excel, and VBA. I can complete your project quicker and with better quality than anyone. Wonder why and how? 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.
📌 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.

What's included

  • Microsoft Access, VBA, and Microsoft Excel Development

    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

  • Data Extration

    Don't have any data? I'll scrape some for you! Have data, but it's very raw? I'll clean it for you! Have data, but not sure what to do with it? I'll analyze it, provide useful insights, and create stunning visualizations! Trying to build a machine learning model? I'll use state-of-the-art techniques to develop the best model possible! I possess the art of modeling and interpreting large, complicated data sets via predictive and descriptive data mining methods using Knime and python. More than 10+ years of experience in the following technologies: ETL: SSIS, Pentaho, Talend Database: SQL Server, MySQL, PostgreSQL, Oracle Data Visualization: Tableau, Power BI (with DAX), SAP Crystal Report, SSRS. Cloud: AZURE Data Factory and SSIS in AZURE Data Modelling, Database Design, DBA / Database development, and Performance Tuning, ETL Architecture and ETL solutions Design and Development. Snowflake Web Application: ASP.net (C# and VB), PHP No-SQL (Elastic Search and Apache Solr, MongoDB).

  • Data Visualization

    A dynamic result - oriented professional with about 15 years of experience in Data Analytics and visualization with various BI and analytics platforms in Retail (Target/ BELK/ BBBY) and Supply Chain domain ( GT Nexus - Infor) using Power BI, MicroStrategy and Birst.

Skills and tools

Data Visualizer
Database Engineer
Database Specialist
Access
Microsoft Excel
MySQL
Power BI
Tableau

Industries

Software Engineering
Database
Data Visualization

Work with me

More services

Business Intelligence Solutions

STARTING AT

$300/hour

hourly rate