Managing Your Data Doesn't Have to be a Headache
Are you still cutting and pasting spreadsheets? Cut through the daily grind and automate the tasks that slow you down. It's easier than you think!
What if I told you that you can get Microsoft Power BI, the industry-leading tool for business intelligence—for free? That's right! You can download it today and start transforming your data instantly. Plus, Power Query is already built into Excel, giving you advanced data processing right at your fingertips.
I can show you how to automate your workflows like never before:
- Connect all your data sources at once—QuickBooks, SQL, spreadsheets, even file directories.
- Clean and transform data without risk.
- Generate real-time, dynamic reports for every area of activity.
It's time to take your business to the next level!
Help & Smart Solutions
- Complex data cleanup, reporting, analytics, and Excel spreadsheets.
- Optimize your CRM with Salesforce.
- Copywriting, marketing, and stunning graphic design.
I'll bring it all together—efficiently and effectively.
Microsoft Power BI
I offer Power BI solutions to extract, transform, and load your data into actionable insights. Get automated reports, interactive dashboards, or real-time analytics. I'll ensure you have the tools to make informed decisions and streamline daily business operations.
Salesforce CRM
As a certified Salesforce Admin, I offer:
- From-Scratch Implementation: End-to-end setup, including Sales and Service Cloud.
- Data Management: Import, export, cleanup, and optimization.
- Customization: Tailored Apps, Objects, and Fields to fit your business needs.
- Insights & Reporting: Clear, actionable Dashboards and Reports.
- Seamless Integrations: Native and third-party app configurations.
- Process Automation: Custom Flows that save time and eliminate manual work.
Approach
Ready for results? I'll tackle projects even when requirements are initially unclear, working alongside your team to identify goals and drive success. Whether it's finding untapped opportunities or creating custom solutions, let's move forward together! With a solid programming and IT background, I'll help automate your data services and streamline business processes for maximum efficiency.
Let's Connect
Tell me about your company and project—I’d love to hear what you’re working on! If it's a challenge I can help with, we'll discuss the details and find the best path forward. Call or email today, and let's make things happen!
Pricing & Payment
- Direct Contracting: Weekly invoices, ensuring you review work before payment.
- Project-Based Work: Single payments after completion or per milestone.
- Long-Term Options: Open to temp or full-time onboarding for extended projects.
Project Transparency – No Surprises
- Regular Updates: You'll always know what's going on with your project.
- Satisfaction Guaranteed: If you're ever unsatisfied, I'll work to make it right—no charge for undelivered work.
- Flexible Scope: If the project expands, we'll adapt as needed. You also have the option to pay for completed work and seamlessly transition the project to another team.
What I Won't Do
- Unethical work or jobs that feel like a "hustle".
- Data scraping or anything that violates someone's intellectual property or terms of service.
- Jobs beyond my ability to deliver in a timely manner.
Want to know a little more about me? Take a look at my work history below...
Work History
Salesforce Certified Administrator
Project Based, Hourly, or On-Call Salesforce Support · Freelance
2022 - Present · Remote
Offering support for data management, custom app development, and automation within Salesforce environment.
- Created reports, dashboard, and automated processes for client workflows.
Skills: Salesforce Admin · Slack · Zapier
Database Technician & Programmer
Schneider Electric · Contract
Oct 2022 - Aug 2024 · 1 yr 10 mos · Knoxville, TN · On-Site and Remote
Helped company transition data systems to SAP and created automation tools to streamline operations.
- Developed an Excel purchasing app to resolve complex model configurations, eliminating the need to manually maintain 100+ interdependent spreadsheets.
- Integrated Change Tracker to automate SAP and sales portal configurations.
- Handled various data conversions, lookups, and product matrices.
Skills: SAP · Microsoft Excel · Data Processing · Video Presentation
Application Clerk & Office Support
Tennessee Department of Human Services · Contract
Mar 2022 - Jun 2022 · 4 mos · Knoxville, TN
Helped clients with their application and case documents.
- Conducted research on TN.gov to compile and centralize relevant resources.
- Set up user interface on a virtual terminal for record inquiries.
- Developed address extraction and self-mailer process to improve delivery.
- Played a key role in transitioning office to a new Customer Kiosk system and created an Excel dashboard for usage/evaluation reports.
Skills: Microsoft Excel · IBM Terminal Software · Apple OS (iPad)
Downstream Production
Dura-Line · Full-time
May 2020 - Aug 2021 · 1 yr 4 mos · Clinton, TN
- Filmed and edited instructional and process videos for factory operations.
- Participated in SMED event to develop efficiency strategies.
Skills: Blender 3D (Familiar) · KdenLive · Production
Salesforce Database Team Member
Cirrus Aircraft · Contract
Feb 2020 - Feb 2020 · 1 wk · Knoxville, TN
- Contributed to data overhaul utilizing Salesforce, Excel, and Google Maps to merge incomplete or duplicate records for a targeted mass email campaign.
Skills: Salesforce · Microsoft Excel · Microsoft Teams
Design, Branding, & Print Professional
Creative Graphic Biz · Self-Employed
2007 - 2020
Developed branding solutions, marketing material, and digital content for various clients across different industries. See portfolio at https://behance.net/MatthewShockey.
- Cultivated strong client relationships, serving as their point of contact while collaborating with suppliers to ensure seamless project execution.
- Produced high-quality deliverables, including logo design, photo editing, copywriting, print media, website creation, and signage.
- Coordinated branding, print, and digital media for fundraising events and newsletters, ensuring effective promotion and engagement.
Skills: Graphic Design · Web Design · Web Hosting · Copywriting/Editing · Cover Art
Drafter & 3D Modeler
The Cabinet Shop Knoxville · Contract
2007 - 2020 · Knoxville, TN
Created floor plans, 3D models, and scaled photo overlays for construction sites and client presentations.
- Improved default CNC production files to increase efficiency.
- Developed spreadsheets for cut-lists and finances.
Skills: CAD · CNC Plotting / DXF Files · Blueprints / Technical Drawings
WordPress Developer
EssentialFoto.com · Personal Project
2015 - 2016
Developed and launched the Essential Foto plugin using CSS, PHP, and Subversion SVN.
- Handled web staging and MySQL database backup using phpMyAdmin.
- Created documentation and marketing material.
Skills: WordPress · MySQL · PHP · CSS
Skills
Data Tech
Salesforce, SAP, Excel, Power Query, and Power BI. Familiar with SQL and PowerShell.
Interface
IBM Terminal Software, FTP/SSH, CGI/API, Zapier, Synxis HRS.
Coding
Perl, Geany Editor. Familiar with PHP, Javascript, and Subversion SVN.
Web Design
WHM+cPanel, Interworx, Wordpress, Web Developer Tools, Analytics, HTML+CSS, SEO/SEM.
Production
Blender 3D (Familiar), CAD, CNC Plotting / DXF Files, Blueprints.
Video
KdenLive, iMovie, OBS Studio, Audacity, MS Power Point.
Graphic Design
Adobe Photoshop, Gimp, CorelDraw, Inkscape, NexusFont.
Branding and Marketing
Copywriting/Editing, Cover Art, Logo Design, Illustration.
Office
Microsoft 365, Libre Office, Teams, Slack, Windows OS, Linux OS, etc.
Support
Troubleshooting, IT Support, Customer Service.