Public Sector Private Sector Non-Profit and Pro-Bono
Welcome to BSPEC - Customers and Industries
Past and Present Customers, Examples and Industries.
What do you want to find today?
A few examples of Past and Present Customers, and Industries.
Human Resources | Staffing | Health Care Created budget system for a 1/2 billion dollar budget compiled for 250+ cost centers. The system produced financials for revenue, expense comparisons and deviations on demand through migration with the medical centers accounting system. ...
Gathered requirements for the compilation of budgets.
- Procured hardware and software needs.
- Created database structure(s).
- Created user interface that enveloped all aspects of CRM.
- Extracted information from accounting system(s) to compare budget projections to actuals.
- Produced a dynamic reporting system for monthly financials and budget variance reporting.
Human Resources | Staffing | Health Care Created T.E.M.S. (Temporary Employment Management System) used for managing supplemental staffing. This system utilized MS Access and web-based systems for the front end and a myriad of data sources....
The system's purpose was to help match medical patient needs with employee pools using sophisticated algorithms (AI). The program is networked to about 20+ workstations and includes, need requests, reporting and integrates with the hospitals accounting and patient system(s).
- Gathered requirements from HR for temporary staffing needs.
- Developed data sources consisting of internal and external data sources.
- Modified/Enhanced over a 5-year span.
- Developed API interface to the hospitals accounting system for payroll and GL comparisons.
- Created search logic to match clients with employees to fulfill client orders.
Reporting | Statistical Reporting | Health Care Data analysis/reporting system which enabled users to query millions of record spanning decades of data.
The reporting system and results allowed user to filer and query in one place all the legacy sources (databases, APIs, etc.) with a desktop and intranet GUI interface....
Extracted data from a legacy server to show counts based on Demographic data and reasons for the Shock Trauma visit.
Implemented Demographic analysis to study of a population-based on factors such as age, race, and sex and reason for visit to the Shock Trauma Center (accident, health reasons and assaults (such as stabbing, gunshots, etc.).
Health Care | IT - Consulting | Government 1 of 3 member team tasked to audit the status of the Y2K switch of major HMO companies like Kaiser Permanente and Blue Cross Blue Shield. Job function was to audit all the computer systems that could impact providing services to The Social Security Administrations member clients. ...
The audit included status of assuring transparency of switch, testing methodologies, and contingency plans for system failures.
IT - Networking | IT - Database | Health Care Developed a data collection program used to retrieve data from imaging monitoring station on the East Coast. This program connects to Access database used by an imaging program at the sites. The program generates queries based on the last download to filter for only information not yet received. ...
The Client system resides at the site and does all the filtering on that computer then sends the filtered data back to the host/Central server for appending to an Oracle Database. The Oracle database would then attach to and Access Front End to monitor image requests.
GPS | IT - Consulting | Proto Typing
Developed a pilot training program for sea port navigation training. Integrated with a simulation system used for training - this program would randomly generate ghost ships sent to the simulation program via GPS coordinates.
Accounting and Finance | IT - Browser Development | Construction Built over 20+ desktop applications and moved 20+ business processes from Desktop Applications to the intranet and internet.
Systems included Client, Vendor, Employee portals
...
Internet Systems Included:
Corporate: Sales and Marketing, Building Schedules, Vendor Management, etc.
Customer Selection Sheets, Building Status Reporting, etc.
Vendor Purchase Orders and schedules, etc.
Employee Documents, Time Sheets, and BLOGs
IT - Desktop Development | IT - Security | IT - Networking
Created an Active Directory linking program allowing IT staff to easily link networked PCs to the desired Active Directory server. Utilized VB.NET and Windows API calls.
Reporting | Accounting and Finance | Telecommunications Enhanced the information system used to manage about 3,000 cell towers being built in DC, MD, VA and PA.
System Enhancements included an increase in speed by a factor of 10. Integrated legacy Databases with ad-hoc databases to pool information....
Implemented an Ad-hoc reporting system allowing all employees from administrative through upper management to build reports using self-derived wizards via GUI interface to translate user queries to complex data retrieval.
The web based reporting system runs on IIS, Server 2013 using asp.net (Mostly vb.net language) and SQL Server. Accomplished to increase system speed 10 fold by migrating a legacy Access database system to SQL Server and automating weekly vendor updates.
IT - Consulting | IT - Security | IT - General In the department of ARNIC in the division of Airport Technologies. This department is responsible many aspects of airport operation (Asset management, Security, Passenger verification, Biometrics and increasing the efficiency of airport efficiencies world wide.)...
MVS through 10, SQL server, XML, Subversion, QC, Enterprise Architecture, SCRUM, Agile. Full Product life cycle, Enhancements and modifications for both web site development and FAT clients.
Logistics | Professional Services | Government
Responsible for maintenance, troubleshooting and enhancements to Pathology system. Team work on a team of 5 people.
SQL Server, asp.net, VB6, VB.net, VBA, Microsoft office automation, web development.
Government | Professional Services | Finance Assisted in preparation and creation of IPOs for the banks current depositors.
When the banks got into financial trouble in 80s and 90s the IPOs were used to raise new capital to put the banks from the “red” back to the “black” financially....
Because the depositors were the ones at stake – they were offered the first claims to purchase from the IPOs new stock.
We helped in preparation of the IPOs ranging from – Initial Proposal(s), Red Herrings and accounting of depositors based on their current deposit amounts.
IT - Database | IT - Security | Government
Mainly was too enhance and fix issues with existing systems and core programs. Also required on site visits to new Navy ships (Air Craft Carriers, Submarines, etc.).
Telecommunications | GPS | Government The Equipment Location-Certification Information Database (EL-CID) was developed to provide an automated tool to support electronic processing of spectrum certification requests at NTIA. The database structure and design is based upon the new comprehensive database (the OSM Data Dictionary) being developed at NTIA to replace the GMF database that is currently used to support various spectrum management activities, particularly the frequency assignment process.
...
Contracted with ITT and IBM responsible for updates to a program called EL-CID (Equipment Location Certification Information Database) used to allocate the Electromagnetic spectrum for government agencies. The contact included participating in meetings with the NTIA, DOD (all branches) IBM and ITT for development reviews and discussions of PCRs. The development team managed the development environment certified as CMM Level 5.
Health Care | Logistics | IT - Database AON Corporation tasked BSPEC as Lead Developer on a project to migrate from an IBM-DB2 database through an MS SQL Database for applying new business rules and migration transformations to an ORACLE database....
This was done through a T1 connection from Boston, MA – Transformed in the Owings Mills, MD office(s) and pushed out to Chicago, IL.
The process “engine/program” (in Maryland) was written in VB6, MS Access and MS SQL Server (for user interface and ETL logic).
Logistics | Inventory | Health Care Automated their inventory system for tracking wholesale medical products utilizing MS Access, SQL server, PowerPoint, Word, Excel and Windows Server configuration.
...
The Inventory System included Bar Code scanning and just in time inventory.
Human Resources | Marketing | Health Care Sold T.E.M.S (Temporary Employment Management System) to Medforce and enhanced the existing system originally developed for the University of Maryland Medical System.
...
The enhancement includes public web access integration with external servers utilizing RSS from major job search web sites. The technologies used were XML, Microsoft Access, MS Office Suite, ASP.NET, VB.NET, ASP.NET, and SQL Server 2005.