Programmer for the MsAccess 2007-2019 (D.C.O.S.) Design & Construction Operating Systems, is a Microsoft Access formatted database used by Capital Programs. DCOS bridges the gap between various internal systems to ensure a fundamental way to centralize the data from all the systems, have real-time “tracking” information, and better design, construction, and contract accountability. The front-end is in Access with the back-end is SQL Server. Capital Projects maintances the upgrade, construction of all the schools within the School District of Philadelphia. DCOS program consists of various SQL procedures, view and tables as well SQL scripts. • Design, convert, and upgrade front-end from Msaccess 2007 to MsAccess 2016 database conversion modules. • Test front and back-end procedures, correct errors and make necessary programming modifications.• Write and code logical and physical SQL Server database descriptions and specify identifiers of database to management system or direct others in coding descriptions.Environment: Microsoft SQL Server Management Studio 17 , Microsoft Office Professional Suite, Deployment toolkit (MDT) 2010, Windows Server 2008, Windows7- Windows 10 Platform

Kaspick Client [Contractor Consultant] Boston Ma.Position Title: Database Programmer/Developer Oct'14 - Jan '15• Designed a system to export from Ms-Excel into an MS Access database conversion module to create reporting modules. User can filter via year , Client Id # Etc and than be export into various Ms-Excel Reports.• Environment: MS Access 2007/2010/2013, MS Excel 2010/2013Visual Studio/SharePoint 2010/2013

Responsibilities: • Converting, Creating and Updating and Maintaining UPS Medical Client System. This application maintained through a large number of relational tables allowing users to update various Medical Client information. I’ve updated this system to take data from the Legacy System, imported into the MS Access Conversion Database Tool System, the data is cleaned and uploaded to a new SAP System. (Legacy System - MS Excel - MS Access - MS Excel - S.A.P ) • Provided technical assistance and training to end-users.• Designed a system to convert a databases from a Legacy System to be imported in an MS Access conversion module to perform data cleanup be export into an (SAP) System Applications Products System. This system support multiple clients at one time. It also has the capability of being uploaded onto SharePoint platform environment. Environment: MS Access 2010/2013, MS Excel 2010/2013, Visual Studio/SharePoint 2010/2013

• Maintaining DEFENDANT (CLIENT) DATA TRACKING AND REPORTING SYSTEM This large-scale web base application maintained through a large number of relational tables allowing users to update various Defendant/Indemnitor/Bond information. • Provided technical assistance and training to internal, company owned retail, joint venture, and wholesale partners users.• Maintained companywide E-mail user profiles, security requirements and E-mail traffic monitoring, project planning, system development, implementation, application deployment and documentation• Maintained network backup mechanisms and security for physical medias. • Resolved client PC hardware/ software issues along with configuring desktop/laptops installing and upgrading software applications. Environment: Access 2003-2007/2010/2013, Visual Studio/SharePoint 2007, 2010.

Designed and developing web base recycling Inventory using Visual Basic/SQL with a Microsoft Access2010 interface. This large-scale system maintained a large number of relational tables allowing users to input new recycling locations , edit existing information within the database, this system also interacts with a GUI calendar object and to executes reports, spreadsheets, etc, developed using the advance Access procedures and Crystal Reports. The system is fully object oriented, utilizing all aspects of Visual Basic object oriented technology.

• Designed (VB-MSAccess/SQL/SharePoint, Excel) Military Project Inventory System for the US Department of Defense/Air Force. This system designed with an MSAccess front-end that is connected to a secured SharePoint server with the back-end on a SQL database server. The system produces various CUB and WAR data reports along with various data analyst from data captured thru various intake screens. Also provide the capability of export data to various output formats for data analyst. • Designed (VB-MSAccess/SQL) Military HelpDesk System for the US Department of Defense/Air Force. to track IT Issues and software /hardware inventory at several bases in Afghanistan.

• Created several applications to track clinical research medical data, using, VB.Access 2007/2003, and SQL Server, which enabled various clinical study group to manage deviations in projects. • Developed several data-set to track various medical Clinical research projects using VB, Access 2003, and SQL Server, that automated submitting users’ requests and migrated and prepares data for clinical research to be published in various medical publications.Co-Developed the Microsoft Heath Vault System, Partnership with Microsoft and Morehouse School of Medicine. This system tracks Diabetic data captured through handheld devices. After which the results uploaded to Microsoft site. After data is captured on the site, data is download into a SQL Server, and is prepared for clinical research analyst.

• Designed and developed a large-scale system DEFENDANT (CLIENT) DATA TRACKING AND REPORTING SYSTEM using Visual Basic/SQL with a Microsoft Access2000 interface. This large-scale system maintained a large number of relational tables allowing users to input new defendants, edit existing information within the database, this system also interacts with a GUI calendar object and to executes reports, spreadsheets, etc, developed using the advance Access procedures and Crystal Reports. The system is fully object oriented, utilizing all aspects of Visual Basic object oriented technology. • Maintained the integrity of the CBC database (1/2 Million Records), and enterprise communications to branch locations through a formal software engineering methodology which provides a functional creation, use, sharing, and distribution of data.• Provided technical assistance and training to internal, company owned retail, joint venture, and wholesale partners users.• Maintained companywide E-mail user profiles, security requirements and E-mail traffic monitoring, project planning, system development, implementation, application deployment and documentation• Maintained network backup mechanisms and security for physical medias. • Resolved client PC hardware/ software issues – CD-ROMs, cables, and memory, etc. • Configured PC’s, installed and upgraded software applications.Environment: SQL 2000, Visual Basic 6.0/ Access 2000-2003

• Analyzed, designed, coded, implemented, debugged, and documented several existing/ new PC applications (Clipper, FoxPro, RBase, Paradox, Etc.) • Installed and setup various software packages and provided user support via. LAN (Novell 3.11). • Evaluated and provided the training needs of the user community group and conduct PC software training workshops. Environment: dBase, Clipper, FoxPro, RBase, Paradox

• Providing support to N.F.I. Truck Terminals nationwide. • Designed & implemented mainframe to PC download data applications using dBase/Clipper, and provide PC software support. Environment: dBase, Clipper

• Evaluated designed, coded, troubleshot, Implement, provided support and training for various PC systems and software.Environment: dBase, Clipper

• Provided system support, and training to center staff and students. • Installed setup, and configured PC hardware and software as well as provide evaluation of software packages. • Designed and customized software package called the Head Start Data Manager (dBaseII-IV) under a grant from U.S. Dept. of Health and Human Services. • Installed, configure the hardware/software, and conducted HSDM training classes for Head Start agencies throughout various US cities. • Also functioned as the C.S.P.C.D. DP/MIS Manager Environment: dBase, Clipper