Business Data Analyst
2014 - PRESENTColumbus 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 ServerDatabase Administrator | Data Systems Supervisor
2009 - 2013Franklin 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 ServerDatabase Analyst | Developer | Administrator
2005 - 2006ProfitLine, 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 ServerDatabase Analyst | Developer | Administrator
2004 - 2005FedCel, 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
Michael Maloy
Software Developer in Columbus, OH, United States
Member since October 29, 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
- Columbus College of Art and DesignMicrosoft 365, Windows PowerShell, Microsoft SQL Server
- Franklin County Department of Job and Family ServicesSharePoint, Microsoft 365, Windows PowerShell, Microsoft SQL Server
- ProfitLine, Inc.Microsoft 365, Microsoft SQL Server
Experience
- SQL 19 years
- MySQL 15 years
- SQL Server Integration Services (SSIS) 10 years
- SQL Server Reporting Services (SSRS) 10 years
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
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, CSSStorage
SQL Server 2008 R2, SQL Server Reporting Services (SSRS), MySQL, SQL Server Integration Services (SSIS), Microsoft SQL Server, SQLiteFrameworks
Windows PowerShellTools
Office 2010Platforms
Windows, Linux, SharePointLibraries/APIs
jQueryOther
Microsoft 365
Education
- Bachelor's Degree in Computer and Information Sciences1989 - 2003The Ohio State University - Columbus, OH, USA
