PROFESSIONAL SUMMARY:

• 20 plus years with Database Management, Software Development, Desktop Support, as well as computer training would be most applicable for a IT position.
• Developed Confidential - based applications for the past 20 plus years and have specialized in several full cycle software developments and the implementation of high performance custom software applications.
• Utilize several high performance strategies and programming utilities,for applications and documentation as well as maintaining several databases averaging over a million records from various Access/VBA /SQL database tables and data-sets.
• Performed desktop support and end user training for my applications Of particular note for you and the members of your organization as you consider my skills are my strong accomplishments in combining business acumen with technical savvy to achieve improved operating efficiency internally.

• Designed a Excel/Access Reporting System to export data from financial instution data from excel to be imported in an (MS Access) application where end-users can perform various data selection and than be exported into various excel worksheet for quarter reporting .
• Designed an (MS Access/VBA) application system to convert data from a Legacy System to be imported in an (MS Access) application where end-users can perform data cleanup after which the data is exported into an (SAP) System Applications Products System. This system support multiple clients at one time. I designed this application using VBA and ADO.NET. It also has the capability of being uploaded onto SharePoint platform environment
• This system designed with an MS Access front-end that is connected to a secured SharePoint application 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 VBA-MS Access intake screens.
• Also provide the capability of export data to various output formats for data analyst
• Created several applications to track clinical research medical data, using, VBA-MS Access 2013/2007/2003 , and SQL Server, which enabled various clinical study group to manage deviations in construction projects and resolve them in a timely manner, avoiding millions of dollars in late rework cost
• Developed several data-set to track various medical Clinical research projects using VBA-MS 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 Confidential Heath Vault System, Partnership with Confidential. This system tracks Diabetic data captured through handheld devices. After which the results uploaded to Confidential. The data is data is downloading onto a SQL Server, where prepared for clinical research analyst
• Developed a Bail Bond Management tool for using VBA-MS Access 2003, and SQL Server, that automated tracking clients, indemnitor and financial bonds
• Accomplished professional in information technology domain with extensive work experience in Database Management
• Strong experience as a Programmer/Analyst and Database Developer with skills in VBA-MS Access 2003, 2007, 2013,Visual Studio 2013, Stored Procedures, Visual Source Safe, Data Dynamics Active Reports
• Experienced in entire project life cycle starting from system analysis to end user implementation.
• Proficient in developing Client Server systems using various relational databases...
• Excellent communications and inter-personal skills
• Effective in working independently and collaboratively in team effort
• Providing Desktop support in a Windows/MS Office 2013 platform helping and training end-users in various software applications (Windows XP, 7, 8 Operating System (OS) with MSOffice 2003, 2007,2010, and 2013)

TECHNICAL SKILLS:

• SSRS
• SSIS
• Confidential Office 2003-2019 Professional
• Confidential DAO-ADO
• ADO.NET
• Confidential Visual Studio 2018
• Visual Source Safe
• REDCap
• Sybase SQL Server
• Active Directory Users
• Crystal Reports.NET Framework
• SQL Server 2007-2018
• Confidential Office Profession 2007-2019 Word, Excel, Access, Powerpoint
• Exchange Server
• Borland Object Vision for Windows
• Oracle SQL Developer
• Adobe Lifecycle Designer
• Adobe Professional
• Remark Office OMR
• SPSS
• SAS
• SQL Express
• SharePoint 2007-2019
• SAP

PROFESSIONAL EXPERIENCES:

Confidential, Philadelphia, Pennsylvania

Senior Programmer/Analyst

Responsibilities:

• Design & Construction Operating Systems, is a Confidential Access formatted database used by Capital Programs.
• Confidential 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.
• 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: SQL Server Management Studio 17, Office Professional Suite, Deployment toolkit (MDT) 2010, Windows Server 2008, Windows7- Windows 10 Platform

Confidential, Philadelphia, Pa

Position Title: Database Programmer/Developer

Responsibilities:

• Analyzing the method of transforming windows XP platform into a Windows 7 platform.
• Reviewing existing migration tools and providing recommendations for improving performance of the migration process.
• Providing necessary change and support documentation.

Environment: Deployment toolkit (MDT) 2010, Windows Server 2003/2008, Vista & Windows XP, Windows7

Confidential, Redwood City, CA

Database Programmer/Developer

Responsibilities:

• Designed a reporting system to export data from Ms-Excel into an MS Access database conversion module to create reporting modules.
• Test programs or databases, correct errors and make necessary modifications.
• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Train users and answer questions.

Environment: Access 2010/2013, Confidential Excel 2010/2013Visual Studio

Confidential, Newark, DE

Database Programmer/Developer

Responsibilities:

• Developed an application to maintain a large number of relational tables allowing end-users to update Confidential Client information.
• Designed a system convert a databases 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: Access 2010/2013, Excel 2010/2013, ADO.NET. Confidential Visual Studio/SharePoint 2010/2013

Confidential, Reading, PA

Database Manager/Engineer

Responsibilities:

• Creating and Maintaining 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/end-user hardware/ software issues along with configuring desktop/laptops installing and upgrading software software applications.

Environment: Access 2003-2007/2010/2013 , ADO.NET, Visual Studio/SharePoint 2007, 2010

Confidential, Reading, PA

IT Manager

Responsibilities:

• Designed and developing web base recycling inventory using Visual Basic/SQL with a 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.

Environment: Confidential Access 2003-2007/2010/ Confidential Visual Studio/SharePoint 2007, Confidential Excel, PowerPoint, XML

Confidential

Communications Specialist Support Database Manager-Programmer

Responsibilities:

• Responsible for building and maintaining relational databases that house critical data for the Confidential -A and EPBS-A Maintain the Confidential -A SharePoint site at Bagram and individual SharePoint sites for the squadrons including EPBS-A (E) at Bagram, EPBS-A (S) at Kandahar, and EPBS-A (N) at Camp Marmal. Maintain the file structure on the SharePoint site, upload files and ensure accuracy of certain portions of the site.
• Provide improvements and maintenance of several separate databases with different information.
• Ensures integrity of databases for errors or outages within (48 hours) of an occurrence with specified resolution time met. Troubleshooting and fix errors associated with these databases. These datasets are built with Confidential Access with SharePoint as a file repository.

Environment: Access 2003-2007/2010/ Confidential Visual Studio/SharePoint 2007, Confidential Excel, Confidential PowerPoint, XML.