• Ken Sheffied - Internet Sales/Business Development

  • Using tech to capture data to drive decision making

  • Experienced professional with CompTIA Certification

  • Team Player ready to contribute

Duties - converted to SOP and possible Optimization


Work Samples

App Development

Now Just Click on the images below to check the google sheet and google calendar to see the real time update. Don’t forget to check your email for an automatic confirmation email!!!!

Summary of concept

I built a web app using free tools to demonstrate my ability to enhance work flow and incorporate tech into real world problems.  This is a possible solution to trouble ticket workflow through:

  • Easy trouble ticket logging: Users report issues, prioritize them, upload photos, and receive confirmation emails effortlessly.

  • Appointment scheduling: Connect directly to Google Calendar, eliminating scheduling hassle.

  • Automatic data organization: Submissions fill a Google Sheet with a dynamic filter, prioritizing based on user ratings for instant insights.

  • Collaboration and control: Share sheets and calendars with permissions, ensuring transparency and efficient teamwork.

This helps to boost:

  • Boost productivity: My web app skills save time and frustration, freeing up your team to focus on core tasks.

  • Enhance transparency: Clear communication and data access empower informed decision-making.

  • Scale with ease: Free platforms and web apps mean cost-effective solutions that adapt as your needs grow.

You can scale by:

  • Granular Permissions: Effortlessly control who can access and edit specific information within the Google Sheet and Calendar, ensuring both collaboration and data security.

  • Strategic Sharing: Grant access to specific teams or individuals, promoting transparency and collaboration without compromising sensitive data.

  • Adaptable Structure: Easily modify permissions as teams grow or responsibilities shift, ensuring the app aligns with evolving workflows.

  • Real-Time Updates: Automatically propagate changes across shared sheets and calendars, keeping everyone informed and aligned, 24/7.

Content Creation/ Video Editing

This is an explainer video I created for a doctor to use in her waiting room. It explains a new Medicare program for patients with two or more Medicare conditions. I began by following a script and aligning stock images and video to the script. I edited the second part to answer only the questions the doctor requested. I blurred the slides with the doctors information.

Social Media Marketing

Social Media Marketing

This is a a Facebook business account I created for the subcontractor for the doctor from above. The purpose of the account was to inform doctors of the new Medicare program and offer his services. I ran several directed ad campaigns targeting doctors and physician assistants. I created reports featuring visual, actionable data. I created all the static ads and videos.

Click FB Icon Below

〰️

Click FB Icon Below 〰️

Database Creation and Analysis

Data Design

I collected data from 3 areas: customer, product, sales. I converted this data to cvc format and imported to Excel.

Data -

Custom forms in Access standardize data entry into the underlying tables for quality control. The linked forms enable validated data collection into the database.

Forms -

- I established relationships between tables using primary and foreign key. I related the tables using customer id, product id, and sale id.

Relationship

I imported Excel sheets to Access tables being sure to verify data type ensuring data integrity. Fields were populated automatically.

Tables -

The queries I developed involved several fields from all three tables. The database was able to quickly answer my questions using the relationship between tables, criteria, and sort functions.

Queries -

The reports clearly answered the question posed and produced a table with filter functions.

Reports -

Insights

What 3 products have the highest sales from this month last year? Answer: wall paintings, photo frames, leather sofa. Click icon to see report

?? -

What category of furniture sold the most last year? Which category performed the worst? Answer: bathroom category sold the most and the storage category sold the least. Click icon to see report

?? -

?? -

What product sold the most last year? How many sales did that product have? How many are currently in inventory? Answer: bathroom, 60, 157. Click icon to see report

Data Set from Excel Workbook


While basic, I believe this showcases the critical foundation needed to take on more complex data challenges. Although I lack advanced analytics expertise currently, I understand how to capture, organize, and make use of core data. I would be happy to walk through the Access database I created in person.

Other Skills

  • Education/Training

    15 years of experience as a teacher, trainer, and administrator.

  • Microsoft/Google Applications

    Highly proficient with full suite of Microsoft Office and Google Workspace applications, spanning from Word to Excel to PowerPoint as well as Google Docs/Drive tools. Skilled at using all production software to optimize workflows and collaboration across organizations.

  • Professionalism

    Accountable, responsible employee who will be at work, on time, and engaged.