Michael Maloy
Verified Expert in Engineering
Software Developer
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.
Portfolio
Experience
Availability
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.
Work Experience
Business Data Analyst
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.
Database Administrator | Data Systems Supervisor
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.
Database Analyst | Developer | Administrator
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.
Database Analyst | Developer | Administrator
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.
Experience
FCDJFS Community Portal
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
Skills
Languages
SQL, T-SQL (Transact-SQL), HTML, JavaScript, Python, CSS
Storage
SQL Server 2008 R2, SQL Server Reporting Services (SSRS), Microsoft SQL Server, MySQL, SQL Server Integration Services (SSIS), SQL Stored Procedures, 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
The Ohio State University - Columbus, OH, USA
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring