Post Job Free

Resume

Sign in

Sql Server Data Analyst

Location:
Los Angeles, CA, 90012
Posted:
August 03, 2023

Contact this candidate

Resume:

Cedric Black

Technical Proficiencies

Platforms: Windows 9x/NT/2000/XP/Vista/7, Window Server 2003/2008/2012/2019, Linux

RDBMS: SQL Server 6.0/6.5/7.0/2005/2008/2014/2017, MS Access

Languages: Visual Studio, Visual C#, Visual Basic 5.0/6.0, HTML, CSS, XML, YAML, JavaScript, VBScript, TSQL, DOS, Powershell, JQuery

Tools: Visual Studio 2008/2010/2012/2015, SQL Server Management Studio, IIS, Power BI, Azure

Professional Experience

Tacal Designs, Auburn, AL (Remote) Programmer/Data Analyst 06/2022-07/2023

•Converted MySQL and PHP web catalog application to .NET using Visual Studio, ASP>NET, C#, JavaScript, CSS and HTML Microsoft Access and SQL Server 2014/2017.

JL Morgan & Assoc, Birmingham, AL (Remote) Programmer/Data Analyst 01/2002-04/2023

•Developed and deployed public websites for hospitals to track patient response data for CMS HCAHPS, CMS OAS CAHPS,, CG CAHPS patient satisfaction, employee morale and home health care using Visual Studio Teams, MVC, ASP.NET, C#, HTML, CSS, VB-Script, Javascript, SQL Server 6.5/2005/2008/2014/2017.

•Developed and deployed intranet survey websites for JL Morgan employees to conduct phone interview surveys for hospital patients for CMS HCAHPS, CMS OAS CAHPS, CG CAHPS, patient satisfaction, employee morale and home health care using Visual Studio Teams, MVC, ASP.NET, C#, HTML, CSS, VB-Script, Javascript, SQL Server Management Studio, SQL Server 6.5/2005/2008/2014/2017. More than 2500 new surveys were entered daily

•Designed benchmark reports and datasets using Microsoft Power BI

•Designed and deployed custom website portal to access Microsoft Power BI reports using Visual Studio, WebAPI, Javascript and Powerc BI Embedded APIs

•Developed and deployed issue tracker system for tracking new software feature requests, enhancements and bugs using using Visual Studio Teams, ASP.NET, C#, HTML, CSS, Javascript, SQL Server Management Studio and SQL Server 6.5/2005/2008/2014/2017

•Designed, deployed and administered SQL server databases on dedicated servers hosted in the cloud to store CMS HCAHPS, CMS OAS CAHPS, CG CAHPS, patient satisfaction, employee morale and home health care survey response related data using SQL Server Management Studio and SQL Server 6.5/2005/2008/2014/2017. Production SQL server consisted of 28 databases, 90+ tables, 150+ views, 700+ stored procedures, 350+ user defined functions, 115+ jobs and 20+ million data records

•Developed processes to extract, transform and load hospital patient demographic and patient admissions related data from files uploaded daily via secure ftp by 100+ hospital clients to facilitate auto populating demographic data forhospital patient surveys conducted via phone and email

•Managed 3 VMs in Azure and 3 dedicated servers with LiquidWeb for staging and production webisites. Responsibilities included, administration, website management, database administration and troubleshooting software related issues

Disney, Glendale, CA Programmer/Data Analyst 09/2007 - 04/2008

•Worked on development team enhance intranet application to facilitate vendor shipment requests using Visual Basic 6.0, SQL Server Management Studio, SQL Server 2005, and Visual Studio 2003

•Worked on development team enhance intranet application to track project related charges for new theme parks using Visual Basic 6.0, SQL Server 2005, and Visual Studio 2003

•Enhanced stand-alone PC application used for tracking contract deals with theme parks using VB.NET, Windows Forms, Web Services, XML, SQL Server 2005, and Visual Studio 2003

Universal Music, Universal City, CA Programmer/Data Analyst 11/2000 - 02/2006

•Developed music labels intranet workflow system to facility music deal contract signatures contract deals using Visual Basic 6.0, VB-Script, Javascript, ASP 3.0/+, IIS 5.0, SQL Server Management Studio, SQL Server 7.0/2000, C#, Adobe Acrobat and Web Services

Education

Bachelor of Science in Electrical Engineering, University Of Alabama



Contact this candidate