Support the IT structure and processes of the business.

Provide data warehouse and reporting for multiple pharmaceutical companies. As a key member of the Reporting team, worked with Operations and Client Service teams to deliver optimal BI solutions for internal and external clients.• Create complex adhoc MySQL queries on a daily basis using MySQL Workbench 8.0• Develop and modify MySQL stored procedures to power reports• Create and maintain MySQL views for ongoing maintenance• Build and deploy reports via JasperSoft Studio 7.9.0 Pro• Burst reports to clients via email using roster-driven logic as well as manual distributions• Develop and maintain alerts for data and process errors• Troubleshoot database issues and devise solutions on a daily basis• Perform ETL database and table transformations on Linux platform• Develop and modify Bash shell scripts using VIM• Create automated report scheduling utilizing Crontab in Bash• Versed in GitHub and SourceTree for Jasper Report versioning• Experience in Java in the context of generating Jasper reports from MySQL stored procedures• Utilize NetBeans for Java application development• Skilled in NaviCat for basic spreadsheet to database table conversion• Fluent in Snagit visual markup editor software• Familiar with FileZilla for file transfer protocol (FTP) uploading and downloading• Experience in communications platforms such as Zoom and Microsoft Teams

Investigate Medicaid fraud in the state of Georgia by auditing the state’s managed care data.• Create ad hoc T-SQL queries daily using 2008/2012 SQL Server Mgmt Studio (SSMS)• Build and deploy reports through Reporting Services (SSRS)• Develop and modify stored procedures to power reports and job agents• Perform ETL database and table transformations using Integrating Service (SSIS)• Diagnose and repair hardware and software issues for team associates• Manage ID activation and hardware inventory for Atlanta office

One of a group of ten selected out of 400 candidates to complete a six month term at CareerBuilder, specifically on the BI Architecture Team. Training at CareerBuilder is a continuous learning experience in an accelerated environment with a 25+ TB Data Warehouse utilizing 2008 Microsoft SQL Server.• Create T-SQL queries & stored procedures using SQL Server Management Studio (SSMS)• Versed in all services of Business Intelligence Development Studio (BIDS)• Publish ad hoc reports through Reporting Services (SSRS) and Report Builder• Utilize multiple Cubes created through Analysis Services (SSAS).• Perform ETL processes on databases and tables using Integration Services (SSIS)• Assigned special projects beyond job scope, such as creating look-up tables from uploading Excel spreadsheets