SUMMARY OF QUALIFICATIONS

• Very large database design and implementation using Microsoft SQL Server 2000, Oracle, Access, and custom designed databases.
• Windows applications design and implementation using Visual Basic, Visual C/C++, Access, Crystal Reports, SQL Reports, .NET, and Source Safe.
• Object-oriented design and implementation using Visual Basic, C++, and Active-X DLLs and controls.
• Webpage design and implementation using Microsoft Interdev and .NET, HTML, XML, and ASP.
• Imbedded applications design and implementation using Appforge for the Palm OS platform. PIC microcontroller development using the MPLAB C Compiler for PIC18 MCUs.
• Additional experience with InstallShield, UNIX, MASM, VBA, CLIPPER, DBASE, Robohelp, Visual Analyst, and Erwin.

PROFESSIONAL EXPERIENCE

August 2008 – August 2009, Confidential,Orlando, FL, Principle Systems Analyst

As an employee of GDIT, Mr. Sempronio provided software development services to the National Guard. His primary duties were to support the National Guard\'s subsystem of the Army’s DTMS system. The subsystem collects personnel and financial data from the 54 states and territories and consolidates it for electronic delivery to the ARMY DTMS system. Mr. Sempronio’s previous experience with the TROUPERS project allowed him to quickly transition to the DTMS project since both projects rely on the same data sources. Mr. Sempronio supervised and worked alongside a consultant to help meet a deadline for data delivery. The ongoing project is implemented using SQL Server 2000 databases and relies heavily on DTS processes, stored procedures, and custom Visual Basic code. Mr. Sempronio was the sole developer in charge of supporting the application as well as having the responsibility for the day to day operations of the system. Mr. Sempronio used his SQL and Visual Basic skills to maintain and enhance the system. Mr. Sempronio worked with National Guard IT personnel to resolve infrastructure issues associated with the project. Other duties included preparing weekly status reports, attends project meetings, and briefing project personnel on status and issues.

March, 2003 – July 2008, Confidential,LLC, Bethesda, MD
Owner

As a contractor, Mr. Sempronio provided software development services to the National Guard under a contract through CACI. Using ASP, SQL Server, InfoPath, and SQL reporting services, he supported the Acquisition Planning Board (APB) application which is used to track project budgets. His primary duties, though, were in support of TROUPERS, an application that tracks training plans for units within the National Guard. Using Visual Basic, Access, SQL, and Crystal Reports, he maintained the TROUPERS application and associated utilities. To meet a mandate, he successfully migrated the application platform from Access 97 to Access 2003 and also converted the data access layer from DAO to ADO. This required major changes to the underlying data access methodology within the application. Using Visual Basic, he developed a standardized data access method to aid in the code conversion process. After analyzing the application, he created a software library to reduce the amount of duplicated code which made the code more maintainable. To further support this effort he rewrote major portions of the code that supports the underlying business rules. He worked with members of the Data Warehouse team to support the export of data from TROUPERS into the Operational Data Store (ODS). He developed stored procedures to aid the Data Warehouse team in extracting data that is used by external applications. Using InstallShield, he created the install packages that were used to distribute the TROUPERS application to the 54 states and territories.

Mr. Sempronio is the sole proprietor of PFD Systems, LLC, a consulting firm specializing in PC desktop and Palm OS applications utilizing Visual Basic, C, Appforge, Access and other database products. He developed and markets StarParty, a Palm PDA application designed to aid observational astronomers at the telescope. StarParty was developed using Appforge under the Visual Studio 6.0 platform, and Access. Access query macros were created to processes information from over a dozen external data sources to create star and object catalogs which are then converted for the Palm application. As a contractor, Mr. Sempronio provided software development services to AutoDocs in support their product IPDAS. IPDAS, developed in Visual Basic and SQL, automates the costly, labor-intensive task of preparing documents associated with patent and trademark applications. Mr. Sempronio’s responsibilities include Visual Basic development, maintenance, and integrating document management systems, including iManage and DocsOpen to the product. He also aided in the creation of an in-house document management system. Using Appforge under Visual Basic and Access, developed a Palm PDA application to display product cost information for the salesmen of the IPDAS product based on the number of user seats a customer is interested in purchasing. The application maintains information in an Access database, which is then converted to Palm database files (PDB) when a salesman hot syncs their PDA.

December, 1999 – March, 2003, Confidential,MD, Senior Systems Analyst

Mr. Sempronio developed a client and Web based system to collect information on 40,000 participants for the National Lung Screening Trial (NLST), under contract to the National Cancer Institute. The client system, developed in Visual Basic is deployed at study centers in hospitals throughout the country. The system exchanges information between an Access and Oracle database using Web technology with a main server located at the Collection Central office. In addition, the system interfaces with information contained in another study’s Access database and also in the study’s Access based active recruitment system database. To support the National Study of Health and Activity (NSHA), Mr. Sempronio integrated components necessary for the automated transmission of interviewer data from field-based laptops containing an Access database to the Oracle database on the host computer. He created an interface using Visual Basic in the interviewer management system; developed a common interface for accessing Crystal Reports from both Visual Basic and web-based applications; developed scripts on the ConnectRemote communication server to control data flow between systems; and developed a daemon process to process the transmitted data. Using Visual Basic and Oracle, Mr. Sempronio developed the Medical Evidence of Record system, which enabled users to edit medical provider information collected by interviewers in the field. The system included a receipt system to track medical records and also recorded payments made to the medical records providers. The system interfaced with the in-house accounting system by means of an Access database. Using HTML, ASP, JSCRIPT and XML, Mr. Sempronio maintained a web-based management system that was used by study management personnel to monitor the progress of interviewers. Mr. Sempronio also established a Visual Basic user group and was responsible for the group’s web-based information system that was developed using HTML, APS, and stored information on an Access database. He coordinated monthly meetings where he and others gave talks on technical and programming topics. The user group provided developers with installation and configuration guidelines, coding practices, standards, and a code library.

1998 – 1999, Confidential,Gaithersburg, MD, Senior Software Engineer

As a senior software engineer and technical lead, Mr. Sempronio analyzed, designed, and implemented the Automated Insurance Compliance System for the Maryland Motor Vehicle Administration. Working in Visual Basic 6.0 and SQL Server 7.0, he developed an application to capture real-time flight information to feed an interactive voice response system for the Baltimore-Washington International Airport. Mr. Sempronio also developed Active-X DLLs, user controls, and servers to support in-house development. Mr. Sempronio used Visual Analyst to create dataflow diagrams for the project.

1997 – 1998, Confidential,Columbia, MD, Staff Software Engineer

Working as a staff engineer on a team of developers, Mr. Sempronio supported the ongoing development of SMART, an NT-based C++ application that provides field-level diagnostics to Deere & Company repair personnel. He also supported the Bookmark and Online Documents team in making enhancements and design changes. Working in Visual Basic 5, Mr. Sempronio developed a data installation management console application that provides an interface (both GUI and command line) that allows Deere Corporation data specialists to install online documentation at dealerships across the country; the application interfaces with either an NT server with Sequel Server 6.5 or an NT workstation. In addition, Mr. Sempronio worked with other RWD personnel to produce various client-oriented documents, including proposals and gap analyses.

1994 – 1997, Confidential,Bethesda, MD, Senior Systems Analyst

Mr. Sempronio supported LaserD production software consisting of dozens of DOS, CLIPPER, and Visual Basic applications that scan, process, and archive financial documents to CD-ROM for retrieval by LaserD clients. His responsibilities also included working with production personnel and the Network Services Group to ensure that these processes worked as expected. Mr. Sempronio used Visual Basic, Access, and Crystal Reports to develop accounting usage reports for Disclosure’s Global Access Internet products. In addition, he developed software using Visual Basic and CD-R (writable) technology to archive scanned images to CD-ROM for subsequent conversion into fiche and future products. Mr. Sempronio supported LaserD Client, a DOS-based search and retrieval engine for a CD-ROM financial imaging database consisting of more than 2,000 discs. He also added display and printing support for Edgar ASCII text documents. Using RTLink, Mr. Sempronio added overlaying technology to reduce memory requirements. In addition, he used Access to develop statistical reports for marketing staff. Mr. Sempronio worked with the Network Services Group to support the in-house wide area network on which the retrieval and storage system resided. He successfully updated and migrated network servers to state-of-the-art hardware. Mr. Sempronio also participated in the updating of network workstations and other network hardware and performed network system administration duties as required. In addition, he educated developers in methods to reduce network resource overuse.

1986 – 1994, Confidential,Gaithersburg, MD, Senior Systems Analyst

As a senior systems analyst/project manager, Mr. Sempronio developed and supervised monthly updates of PartsMaster, a DOS-based search and retrieval engine for a CD-ROM logistics support database consisting of over 40 data files. Over 2500 clients used PartsMaster. He also developed PartsMaster APL, a companion product containing Navy ship allowance and parts inventory lists on four CD-ROMs, and Specmaster, a DOS-based front-end search and retrieval engine for a CD-ROM imaging database. Mr. Sempronio was solely responsible for the design of each application’s user interface, shared in the design of all databases associated with the products, wrote the initial user documentation for each product, and developed the methodology for using the products on any IPX- or NETBIOS-based local area network (LAN) using Optinet (CD-ROM network server software). Mr. Sempronio developed and implemented turnkey asynchronous communication servers used at customer sites with terminal servers that allow dumb terminals to access the CD-ROM products; he adapted the system to be marketed as a dialup service via TYMNET and direct dial. Mr. Sempronio created and supported custom standardized C and Assembly libraries used for all in-house and marketed products. He managed PC software development for all in-house and marketed products and oversaw the requirements analysis, design, coding, and documentation activities of seven programmers. Mr. Sempronio held weekly classes to train programmers in various aspects of software development, and he worked closely with marketing personnel to define end-user requirements. He developed installation programs and scripts to support marketed products and utility programs to test CD-ROM players, and he provided technical support to customers both verbally and on site. Mr. Sempronio established and maintained a company-wide; multi-network LAN based on Novell 3.x NetWare and supporting more than 60 users. He also supported network printing, bridging, and routing to a VAX and a UNIX system. In other work, Mr. Sempronio developed EEO Resource, a CD-ROM-based multimedia product to train human resources personnel in aspects of equal employment opportunity.

1985 – 1986, Confidential,Lanham, MD, Senior Lead Analyst

As a senior lead analyst, Mr. Sempronio implemented an automated system to provide support to various offices within the U.S. Army’s Davidson Aviation Command. He was involved in all aspects of implementation, including documentation and training, and worked on a network of four Intel 310 computers running SCO UNIX 3. Mr. Sempronio developed the software using the INFORMIX relational database, with custom needs implemented in C.

1985, Confidential,VA, Senior Systems Analyst

As a senior systems analyst, Mr. Sempronio designed and implemented an inventory control system to track the sale and lease of personal pagers. The system was developed on a 68000-based NCR tower running UNIX version 5. Mr. Sempronio developed the system using the relational database UNIFY, its supporting utilities SQL and RPT, and custom C code. The system communicates with various models of paging terminals (the devices that transmit to pagers).

1983 – 1985, Confidential,McLean, VA, Senior Systems Analyst

As a senior systems analyst, Mr. Sempronio designed and implemented template-processing software to aid programmers in developing screen and keyboard intensive applications. He also designed and developed SOURCELINK; this communications program, marketed by The SOURCE (the predecessor to AOL), was written in BASIC and ASSEMBLER and operated on PCs or Apple II computers. Mr. Sempronio served as network manager for the in-house NESTAR local area network; his duties included resource allocation, file archiving, preventive maintenance, and repairs.

1982 – 1983, Confidential,Greenbelt, MD, Senior Programmer

Mr. Sempronio was a senior member of a technical team that designed and developed a real-time, data communication system consisting of a network of Z-80 microprocessors. He developed assembly language software to provide protocol conversion between the National Aeronautics and Space Administration’s (NASA’s) worldwide communication network (NASCOM) and local flight dynamics displays at NASA’s Goddard Space Flight Center Orbit Computation Facility. Mr. Sempronio was solely responsible for the communications interface between the master processor and the nine other slave processors, and he completed the work on a Tektronix development system (8550) along with a Tektronix logic analyzer.

1980 – 1982, Confidential,Rockville, MD, Systems Analyst

As a systems analyst, Mr. Sempronio developed software, in Assembly for the Intel 8080, to control the operation of the High Resolution Telescopic Spectrograph Experiment on Space Lab II, which flew on Space Shuttle Mission 51-F. He completed a system on a TRS-80 Model I computer that calibrated high-speed digital phase shifters, tested their operation, and created EPROM-based lookup tables from which performance results were plotted. The data was used to simulate a four-phase radar signal. Mr. Sempronio developed software to collect, analyze, and plot impact data from a light gas gun.

1980, Confidential,Alexandria, VA, Systems Analyst

As a systems analyst, Mr. Sempronio designed and developed a microprocessor-controlled system to determine faults in electronic equipment. He also developed a minicomputer system to process electronic intelligence parameters.

EDUCATION

CA, A.S. Electronics