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