Banner Image

Skills

  • Data Management
  • Database Development
  • Microsoft Excel
  • Requirements Analysis
  • Database Design
  • Design
  • Email
  • Etl
  • JSON
  • Microsoft
  • Microsoft Access
  • Microsoft Office
  • Microsoft Outlook
  • Microsoft Word
  • Office Assistant

Sign up or Log in to see more.

Services

  • MS VBA - Word, Excel, Access, Outlook

    $40/hr Starting at $400

    ...

    Data ManagementDatabase DevelopmentEmailMicrosoftMicrosoft Access
  • SQL Database Design

    $50/hr Starting at $500

    - Review raw data and formats, and reporting requirements - Document Translation of raw data supplied in various formats, txt, JSON, XML, Excel, etc into database tables, views, keys with full scalar...

    Data ManagementDatabase DesignDatabase DevelopmentDesignEtl

About

Finding meaning in data

Experience:
-Designed and Built Azure SQL survey database
-Designed Summarized Financial Trial Balance (FTB) SQL Reporting Database to allow for faster retrieval of Period over Period comparisons by Multiple criteria periods were Year, Quarter, Month
-Wrote All Queries for subsequent Reports for financial Trial Balance databae
-Built Excel VBA tool to read parse and deliver ACN data
-Built Excel VBA tool to Read thousands of Excel spreadsheets from Sharepoint site and normalize data into 3 clean importable output files.
-Built IT department project resource Supply vs Demand Access database Using VBA reading Sharepoint Excel Files to input department resource availablity and read Excel files of Project demand for resources for next 18 months.
-Built Tableau Story on IT Resource Supply vs Demand
-Built Excel VBA tool to Read formatted Application generated OUTLOOK email errors, and parse the OUTLOOK emails to an Access database to Enable tracking of certain network application errors by Machine, Department, and a host of other variables in the emails. There were over 20 Network Application errors and each was for a different application and formatted differently.
-Built VBA Excel tool to accelerate the clean up of a poorly formatted spreadsheet output from another application. What took 45 minutes or more of manual reformatting regularly was reduced to about 5 minutes.
-Designed, coded, and created installer for VB.NET Client/Server Issue Tracking database. The design was a Fat client VB.NET front-end connected to a Network location Access Database.
-Taught introductory Database, SQL, and reportwriter classes.
-Gaining experience with SSRS, and SSIS
-Built Stories and cleaned data with Tableau

I have seen the move from data entry to the age of using data in all its myriad forms. I like to look at data streams for organizations and help create reports, dashboards and KPI to provide performance markers for success and discover new meaning in their data.

Work Terms

I am glad to work on the schedule of your time zone. I prefer to communicate extensively through the requirements process by whatever means works best for you but, sufficient to ensure your needs are met. Instant messaging, Email, Conference Calls, and mobile phone all work for me for communication. I prefer to agree upon scope and requirements, deliverables and look and feel where applicable prior to initiating work. When working, I prefer to work in as object oriented a manner as possible (Modules, classes, and functions). This allows for easier documentation and easier future maintenance. I prefer to use safe pay.