Michael Maloy, Software Developer in Columbus, OH, United States
Michael Maloy

Software Developer in Columbus, OH, United States

Member since September 5, 2019
Mike has 20 years of experience working in database development. His primary database management system (DBMS) is SQL Server, but he has also worked with Oracle, MySQL, and Informix. Mike loves spelunking through data in search of nuggets of truth.
Michael is now available for hire

Portfolio

Location

Columbus, OH, United States

Availability

Part-time

Preferred Environment

Linux, Windows

The most amazing...

...code I've made reported and calculated the overall daily usage of high performance computers using job data that could span over multiple day ranges.

Employment

  • Business Data Analyst

    2014 - PRESENT
    Columbus College of Art and Design
    • Utilized student enrollment and financial data to generate reports in SSRS that are used by other departments for decision-making purposes.
    • Used PowerShell and SSIS to create data migration processes that integrated data between different applications.
    • Assisted in the management of the current data warehouse. I am presently working on the transition to a new SQL-centered data warehouse.
    • Designed data migration and integration tools using Microsoft Access and Excel.
    Technologies: Microsoft 365, Windows PowerShell, Microsoft SQL Server
  • Database Administrator | Data Systems Supervisor

    2009 - 2013
    Franklin County Department of Job and Family Services
    • Managed an application development team of six members.
    • Delegated tasks and assisted and directed my subordinates with their tasks.
    • Supported the project management team in developing requirements and timelines.
    • Developed database structures and maintained or upgraded existing applications.
    • Monitored the SQL Server database servers, report server, and backups; also administered the SharePoint environment.
    • Created or modified existing reports using SSRS.
    • Developed or modified internal data-centered workflows with SSIS.
    • Constructed and automated other internal processes using other technologies such as PowerShell and VBScript.
    Technologies: SharePoint, Microsoft 365, Windows PowerShell, Microsoft SQL Server
  • Database Analyst | Developer | Administrator

    2005 - 2006
    ProfitLine, Inc.
    • Improved back-end data models used by the company which resulted in considerable improvements in company efficiency.
    • Developed a more stable and flexible standardized system for all future clients to use.
    • Designed the stored procedures that were used by the developers of the client systems.
    • Analyzed and proposed data storage methods for use by new clients, implemented those methods, performed data updates, supplied data for reporting, assisted with query development for general tasks, and analyzed/modified indexes for performance.
    Technologies: Microsoft 365, Microsoft SQL Server
  • Database Analyst | Developer | Administrator

    2004 - 2005
    FedCel, Inc. (later purchased by ProfitLine)
    • Improved back-end data models used by the company which resulted in considerable improvements in company efficiency.
    • Developed a more stable and flexible standardized system for all future clients to use.
    • Designed the stored procedures that were used by the developers of the client systems.
    • Analyzed and proposed data storage methods for use by new clients, implemented those methods, performed data updates, supplied data for reporting, assisted with query development for general tasks, and analyzed/modified indexes for performance.
    Technologies: Microsoft 365, Microsoft SQL Server

Experience

  • FCDJFS Community Portal

    The community portal was an effort by Franklin County Job and Family Services to provide a resource that would help individuals who were in need of benefits (food, medical, cash assistance, and so on). The portal would give them access to necessary information regarding their case statuses without having to resort to waiting in long lines or phone calls that may not get answered.

    The project had barely started when I started my job as the team's supervisor and had a handful of users accessing the website. Throughout my tenure, the project grew in scope and user access. By the time I left, we had several thousand users of the portal and had attracted the interest of the state.

    Sometime after I left, the site was closed down, and a state-level portal was implemented. I choose to believe that the site, which was initially the brainchild of my supervisor, was the catalyst for a state-level resource that would help many more people in the state of Ohio.

    The link supplied goes to an information page that once housed the website.

  • Supercomputer Usage SQL Query

    While working for the Ohio Supercomputer Center, I wrote a SQL query that utilized the daily computer job logs for the supercomputers that produced a result set of the daily percentage of maximum potential usage rates for the different machines.

Skills

  • Languages

    SQL, T-SQL, HTML, JavaScript, Python, CSS
  • Storage

    SQL Server 2008 R2, SQL Server Reporting Services (SSRS), MySQL, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQLite
  • Frameworks

    Windows PowerShell
  • Tools

    Office 2010
  • Platforms

    Windows, Linux, SharePoint
  • Libraries/APIs

    jQuery
  • Other

    Microsoft 365

Education

  • Bachelor's degree in Computer and Information Sciences
    1989 - 2003
    The Ohio State University - Columbus, OH, USA

To view more profiles

Join Toptal
Share it with others