Logo FreelancerComment cela fonctionneParcourir les emplois Se connecter S'inscrire Publier un projet
EXPLORER
Excel Microsoft Project Management SQL Visual Basic
Profile cover photo
Vous suivez désormais .
Erreur de suivi de l'utilisateur.
Cet utilisateur n'utilise pas les utilisateurs à le suivre.
Vous suivez déjà cet utilisateur.
Votre plan d'adhésion ne permet que 0 suivis. Améliorez ici.
L'utilisateur n'est désormais plus suivi.
Erreur lors de l'arrêt du suivi de l'utilisateur.
Vous avez désormais recommandé
Erreur lors de la recommendation de l'utilisateur.
Une erreur a eu lieu. Veuillez rafraîchir la page et réessayer.
E-mail désormais vérifié.
Avatar de l'utilisateur
$50 USD / heure
Drapeau de UNITED STATES
$50 USD / heure
Il est actuellement 10:32 PM ici
Membre depuis le décembre 13, 2022
0 Recommandations

Michael J.

@mscottjordan

monthly-level-three.svg
5,0 (2 commentaires)
3,6
3,6
$50 USD / heure
Drapeau de UNITED STATES
$50 USD / heure
100 %
Travaux complétés
100 %
Suivant le budget
100 %
Dans les temps
N/A
Taux de réembauche

Microsoft BI Expert | Reporting & Data Analysis

Business Intelligence and Analytics Consultant for nearly 20 years specializing in data analysis and reporting development. As an expert level developer, I've designed and implemented hundreds of dashboards, KPIs, reports and automated decision support systems for small, medium, and firms as large as Microsoft. From design to launch, I'm exceptionally familiar with every step in the systems development lifecycle. My primary goal is to leverage my technical proficiency to develop tools that provide business owners with useful information and insights that drive innovation, increase productivity, and reduce wasted time and effort. And if you need assistance with MS Excel specifically, I can guarantee you won't be disappointed. Communication is absolutely key to truly understanding a challenge or opportunity and is likely my greatest non-technical strength. So if you have a problem that needs solving and are looking to find the most efficient and elegant solution, please reach out - I'd love to help you!
Freelancer Excel Experts United States

Contactez Michael J. concernant votre emploi

Connectez-vous pour discuter des détails via la messagerie.

Éléments du portfolio

Using visual basic forms to manage information on sheets within a workbook can be an intuitive way to interact with your information - this is a primary specialty of mine and not many freelancers have mastered this skill as well as I have.
Interactive VBA Forms / Worksheets
Example code on the back end of an Excel workbook to automate functionality.
Visual Basic Coding Example - Macros/Automation
Reporting visualization/dashboard highlighting key actionable measures.
Tables, charts, and an integrated Map
Categorically specific KPI Dashboards utilizing charts, ranked lists, and conditional formatting to quickly display summarized and pertinent information for easy digestion.
Dashboards with Conditional Formatting
Categorically specific KPI Dashboards utilizing charts, ranked lists, and conditional formatting to quickly display summarized and pertinent information for easy digestion.
Dashboards with Conditional Formatting
Categorically specific KPI Dashboards utilizing charts, ranked lists, and conditional formatting to quickly display summarized and pertinent information for easy digestion.
Dashboards with Conditional Formatting
Categorically specific KPI Dashboards utilizing charts, ranked lists, and conditional formatting to quickly display summarized and pertinent information for easy digestion.
Dashboards with Conditional Formatting
Dynamically updating pivot tables created from multiple data sources and using Slicers to select down desired data sets into aggregated totals.
Pivot Tables with Slicers
Highly interactive userforms designed in Visual Basic to perform data manipulation and reporting analysis functions within a macro enabled workbook.
Intricate Userform Designs in VBA
Highly interactive userforms designed in Visual Basic to perform data manipulation and reporting analysis functions within a macro enabled workbook.
Intricate Userform Designs in VBA
Highly interactive userforms designed in Visual Basic to perform data manipulation and reporting analysis functions within a macro enabled workbook.
Intricate Userform Designs in VBA
Highly interactive userforms designed in Visual Basic to perform data manipulation and reporting analysis functions within a macro enabled workbook.
Intricate Userform Designs in VBA
Highly interactive userforms designed in Visual Basic to perform data manipulation and reporting analysis functions within a macro enabled workbook.
Intricate Userform Designs in VBA

Commentaires

Modifications enregistrées
Montre1 - 2 sur 2 commentaires
Filtrer les commentaires par : 5,0
$500,00 USD
Great Communication and knowledge of MS excel!! Would hire again!
Excel Word Microsoft Microsoft Outlook
M
Drapeau de Mike L. @Mlofton8
•
il y a 4 mois
5,0
$140,00 USD
Michael went above and beyond to ensure my very intricate spreadsheet was impeccable. I appreciate his integrity in making sure the product was accurate. He was very communicative. I will absolutely use him for future projects.
Visual Basic Data Processing Excel Software Architecture Visual Basic for Apps
M
Drapeau de Melissa V. @MelissaVS1985
•
il y a 5 mois

Expérience

Senior Technical Consultant

Unify Consulting
juil. 2017 - Jusqu'à présent
* Responsible for 40+ Functional Specification documents * Created an in-house, Excel based, macro-enabled and fully integrated employee roster scheduling management tool saving the project close to $550,000 in avoided costs. * Project management documentation, scorecards, and progress KPIs. * Created custom ad-hoc reporting to evaluate project improvement; analysis resulted in 38% drive time reduction based on fully integrated Google Maps API to geolocate travel stops.

Business Intelligence Analyst

Aleutian Spray Fisheries
sept. 2016 - mai 2017 (8 mois, 2 jours)
* Combined disparate legacy data sources into a centralized relational database system for reporting support. * Created, implemented new perspective KPI intelligence reporting and resource management dashboards. * Automated operational and financial projections to provide options and suggestions to executive team. * Conducted deep dive investigations into long-term business problems to identify potential opportunities.

Senior Technical Analyst

Microsoft Corp
janv. 2016 - mai 2016 (4 mois, 1 jour)
* Project based contract responsible for providing critical feedback to the sales force management about meeting goals and objectives with respect to closing licensing expectations with the nation's top companies utilizing Microsoft products and services. * Designed and implemented systems using PowerQuery / PivotTable / SQL Server Management Studio / Visual Basic to improve efficiency and expediency in reporting to Sales Teams and Managers.

Éducation

Operations and Information Systems Management

Penn State University, United States 1998 - 2003
(5 ans)

Qualifications

Power BI for Excel Users

Koenig USA
2020
Proficient in the following areas: -Upload Excel data to Power BI -Connecting to data sources -Clean and transform your data with the Query Editor -Optimizing data models -Create and customize simple visualizations -Quick insights in Power BI

Advanced SQL: MySQL Data Analysis & Business Intelligence

Udemy Academy
2018
-Write advanced SQL queries to explore and analyze databases with MySQL Workbench -Learn how to use subqueries and temporary tables to handle complex multi-step data problems -Solve practical hands-on assignments and real-world eCommerce use cases -Analyze data across multiple tables with powerful MySQL JOIN statements

Microsoft BI Stack Certification

Microsoft Corp
2016
For annual programs in 2008, 2010, 2016

Contactez Michael J. concernant votre emploi

Connectez-vous pour discuter des détails via la messagerie.

Vérifications

Freelance préféré
Identité vérifiée
Paiement vérifié
Téléphone vérifié
E-mail vérifié
Connecté à Facebook

Meilleures compétences

Excel 2 Visual Basic 1 Microsoft 1 Project Management SQL

Parcourir les freelances similaires

Excel Experts in United States
Excel Experts
Visual Basic Developers
Microsoft Developers

Parcourir les présentations similaires

Excel
Visual Basic
Microsoft
Project Management
Utilisateur précédent
Utilisateur suivant
Invitation désormais envoyée !
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.