Banner Image

Skills

  • Creative
  • Database Design
  • Database Development
  • Design
  • Email Services
  • Etl
  • Linux
  • Microsoft
  • Microsoft SQL Server
  • Scheduling
  • SQL
  • Ssis
  • SSRS
  • Visual Studio
  • Windows

Sign up or Log in to see more.

Services

  • Database Design and Development

    $70/hr Starting at $140 Ongoing

    Dedicated Resource

    MS-SQL Database creation, Schema changes, Stored Procedure, Function, and View modification and creation. ETL creation using SSDT. SQL Job creation and scheduling. Complex query design

    CreativeDatabase DesignDatabase DevelopmentDesignEmail Services
  • Database Administration

    $70/hr Starting at $70 Ongoing

    Dedicated Resource

    MS-SQL Database creation, Schema changes, Stored Procedure, Function, and View modification and creation. ETL creation using SSDT. SQL Job creation and scheduling. Complex query design

    CreativeDatabase DesignDatabase DevelopmentDesignEmail Services

About

I have thousands of hours into database, ETL, SSIS, and SSRS creation and modification. Having worked as an Information Architect for HPE, on a team challenged with the task of getting to one source of truth for all HPE financials, I created database schema, tables, views, functions, and stored procedures. I created SSIS packages to move data from gold source to data warehouse, and from data warehouse to reporting. I have created hundreds of SSRS reports varying from simple table dumps to advanced design and functionality including parameters, matrix, drill-down, hide/show, etc.

As a database developer for Central Michigan University, I created ETLs that would pull data from flat text files and data warehouse tables, massage the data, and upload it to cloud CRM. I had to use advanced SQL queries to calculate fields for storing in CRM.

I also have experience working with MySQL, PHP, and linux scripting.