Dan Black Email & Phone Number

Greater Philadelphia Area

Greater Philadelphia Area

Developing T-SQL queries to feed Data Insight Report Writer

Montgomeryville, Pa

Installed & Managed MS SQL Server 2014 Express & Report ServerDeveloped scheduled jobs & reports in T-SQL Developed ad-hoc reports using T-SQL and MS AccessManaged Windows Server 2003/ 2012 R2 (Users, File access, GPO)Managed company cell phones with Verizon & AT&TResponsible for administration of all PC's across three sites and travelling salesmen

Greater Philadelphia Area

MS SQL Server Integration Services development, Develop & Test Stored Procedures, MS Access scheduled process managment.

Greater Philadelphia Area

MS SQL Server Integration Services development, Develop & Test Stored Procedures, MS Access scheduled process managment.

Greater Philadelphia Area

Ad-hoc reporting and data analysis with MS Access 2007 & MS SQL Server 2008 R2

Mt Laurel, Nj

Developed Mass Updates using Fidelity LPS Developed AdHoc Reports HyperionExperience with large databases

Greater Philadelphia Area

Map & plan route for scheduled appointmentsEfficiently Scan & upload select medical chartsOccasional travel to Pittsburgh area offices

Greenville, South Carolina Area

Design agency wide database to track business intelligence using MS AccessDesigned, developed all requested reports for the boardDesign and maintain website design using Joomla CMS dhgh.org

Created numerous simple to complex queries involving self joins, correlated subqueries, CTE’s and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS. As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SSRS for a library database. Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities. Created an ETL solution that reads Product, Vendor, and Order data from an FTP server into a SQL Server database. The solution also validated incoming data and performs notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports and charts using the new SSRS 2008 reporting functionality (Tablix control, new charting features). The reports were set up for automatic delivery based on data-driven report subscriptions.Installed MOSS 2007 and configured an intranet portal that contains a wiki and a site template accessible to only authorized groups according to business specifications.Implemented numerous backup and recovery plans based on data availability requirements and the potential impact of data loss after considering and analyzing different backup and recovery strategies.

Conversion of databases from Microsoft Access to MySQLAccess Query and Report Writing for ClientsWebsite design in Linux, Apache, MySQL, and PHP.PHP enhanced pages for bethhavenbaptist.org & missionaircare.orgComposed Bible-Online PHP application for the above two websitesWebCalendar, Gallery, Simplog, Zina, CRELoadedRemoval of spyware/adware and viruses from client computersSetup and administration of 20 Windows (NT, 2K, XP) PCs, several Macs & Linux serverInstallation and automation of Windows patches, Anti-virus updatesRemote administration and support of all office computersSupport for MS Office, Peachtree, KMA fund raisingSetup and maintenance of networked laser printersSetup and maintenance of disk imaging and restores of Windows PCsSetup and administration of tape backups and automated backups over the network and disk-to-disk on the server

Working with main components of Office 2000 (Word, Excel, Access, & PowerPoint)Maintenance of Access 2000 DatabaseOversee Patient survey from mail out to filing completed surveys

Working with main components of Office 2000 (Word, Excel, Access, & PowerPoint) Maintenance of Access 2000 DatabaseOversee Patient survey from mail out to filing completed surveys

Informix 4gl Database Applications DevelopmentMaintain Extension Office apps and BJU Press customer database programTest PowerBuilder applications developed in houseHelp Desk - installing hardware upgrades and taking calls

Design, implement, and test aircraft modifications into the F-15 simulators in FortranUpdate on-line documentation using Word Perfect

Ma, Church Ministries

Bs, Electronic Engineering Technology