Objective
A challenging position as a “Full Stack” developer with Microsoft Technologies, bringing to bear my expertise with enterprise level .Net technologies, database performance improvement, troubleshooting, network administration, systems analysis, data obfuscation, and statistical analysis. I am comfortable with new technology and capable of learning new ones. I have a .NET accreditation from Penn State.
Professional Experience
CVS/Aetna 1/22 – Current:
Full Stack Programmer. Performing
updates to existing products including bringing them up to Payment Card
Industry Security and Accessibility standards.
Skills required: ASP.NET, C#, T-SQL, VB.NET.
Delaware Health and Social Services 3/21 – 11/21: Database Specialist.
Analyze and convert the Foxpro based STD*MIS system to DEERS
Improve database performance of DEERS
Skills required: SQL, Troubleshooting network systems.
International Database Consultant 4/19 – 3/21:
Assisting DBA’s in need of database optimization expertise.
Skills required: PL/SQL and T-SQL
Clients include Dick’s Sporting Goods, Hospital Real de San Andres, Lost Battalion Publishing, Proto.Business.
Analyze and convert the Foxpro based STD*MIS system to DEERS
Improve database performance of DEERS
Skills required: SQL, Troubleshooting network systems.
International Database Consultant 4/19 – 3/21:
Assisting DBA’s in need of database optimization expertise.
Skills required: PL/SQL and T-SQL
Clients include Dick’s Sporting Goods, Hospital Real de San Andres, Lost Battalion Publishing, Proto.Business.
Cotiviti, 6/19-12-19: Served as a full stack programmer, specializing in SQL and VBA. Tasks centered as first responder to failures in the organization processes that have evolved over time into 1,000+ different stored procedures, views, and VBA applications covering a dozen databases. Performed SQL performance enhancement to with database stored procedures. Created documentation for troubleshooting methods and tools. Languages included T-SQL and VBA. Packages included SSMS and Access. Development methodology followed the Agile process.
Proto.Business 7/17–4/19: Principal Engineer. Served as .Net Developer and AI DBA. Created interfaces from commercial programs to the Seraphim AI MVC system. Tasks included code updates, server setup and maintenance in the Azure Service Fabric and Cloud environments. Languages required included C# and T-SQL for code updates to the ASPDotNetStorefront product. Served as a DBA for management of the SQL Server database for the store systems, and proprietary updates to the Variety, Variability and Value of the data input to the Seraphim AI code. Created documentation of processes, code change requirements to third party adaptation to Seraphim. Other required skills are Compare, OOP, VBA, Windif, XSLT and a working knowledge of XML and JSON data structures.
Accomplishments include a total rewrite of legacy code, C, VB, and Ad-Hoc SQL to contemporary professional standards.
DST Systems 1/12-7/17: Senior Software Developer and DBA. Primary duties involved supporting Market Prominence with Oracle, and CareConnect with SQL Server. Main focus is implementation of new features, aligning them with UX philosophies and troubleshooting performance problems with mature customers. Both Market Prominence and CareConnect are 'N' tier enterprise wide client server systems, following the MVC design pattern. Created documentation DQ’s, IQ’s, OQ’s, for software implementation, as well as establishing benchmarks, testing and implementation. Performed data maintenance tasks based on current business needs. Architected code changes in .NET 2.0, 3.5, 4.5 supported by T-SQL, based on business and system requirements. Created reports using RDL and RDLC. Used the SQL Server Profiler tool to monitor the performance of the SQL Server Database. Troubleshoot production performance issues on an enterprise wide system as needed. Technical skills required: .NET 2.0, 3.5, 4.5 ASP.NET, C#, Fiddler, GUI, OOP, Oracle’s PL/SQL, RDL, RDLC, SOAP, SQL Compare, SQL Server Management Studio 2012, SQL Server Profiler, SSIS, SSRS, Talend, T-SQL, VBA, VB.NET 9.0, Visual Studio 2008, 2010, 2013 and XML. Development methodology followed the Agile process.
Accomplishments include increased database performance with a rewrite of stored procedures for data sets with over a billion records to complete in 36 hours vice 25 days.
Liberty Mutual Assurance 11/10-12/11: DBA. Created documentation and SQL scripts supporting data conversion tasks. Created one off code to convert data from legacy systems to current platform. Performed Data Maintenance tasks based on current business needs. Architected code changes in .NET 2.0, 3.5, and T-SQL, based on business and system requirements. Created reports using RDL and RDLC. Used the SQL Server Profiler tool to monitor the performance of the SQL Server Database. Technical skills required: .NET 2.0, 3.5, ASP.NET, C#, RDL, RDLC, SQL Server Management Studio 2005, SQL Server Profiler, SQL Server, T-SQL, VBA, VB.NET 9.0, Visual Studio 2005, Visual Studio 2008, and XML.
CMC Energy Services 1/10-10/10: Senior Developer, DBA. Developed LITS, an N-Tier Model View Controller architected client entry and data importer to day to day applications. This project involved taking on an unfinished product to bring it to completion. This involved batch processed main frame data updates from outside sources, user updates, writing stored procedures, monitoring the performance of the SQL Server Database, User Interface Updates, and establishing View Model WPF Data binding connections. Technical skills required: .NET 3.5, C#, Infragistics, the Object Relational Mapping (ORM) package LLBLGEN, OOP, SOAP, SQL Server Management Studio 2008, SQL Server Profiler, SQL Server, T-SQL, VBA, Visual Studio 2008, WebServices, Winforms, WPF, and XAML.
Constellation Energy 5/09–11/09: Data Validation Quality Assurance Tester. Project melded 4 databases into a unified database. This involved the creation of a C# Winform application that downloaded and compared data blocks, outputting both to corresponding success and failure logs, as well as creating Ad hoc SQL commands to assist in troubleshooting missing data. Technical skills required: .NET 3.5, C#, GUI, Oracle’s PL/SQL, SQL Server Management Studio 2005, SQL Server, T-SQL, Toad, VBA, Visual Studio 2005 and Winforms. Development methodology followed the Agile process.
Lockheed Martin 7/08-12/08: Senior Software Engineer, Data Masking Specialist. Projects were Foresight and EAIT. Both projects were browser based, Thin Client Server Systems for providing management reports on various projects within the company. My role was to implement, test, data mask, and test data compliance, performance, and troubleshoot updates in the Webform based presentation layer and C# based business layers. My duties extended to troubleshooting stored procedures within the database. Using Visual Studio Team System 2008, I created performance tests and established benchmarks for the EAIT project. I was also the sole implementer of a data obfuscation project to maintain project security. This first involved testing a third party, Configurable off the Shelf product, Data Masker™, but lead to the independent creation of a C# based Winform application. This application data masked the QA and Test databases. Code development involved identification of data to be masked; creating rules for different data types; developing maintenance processes and supporting documentation with emphasis on maintaining referential integrity and consistency of the masked data. Performed monthly implementation and reporting of the data masked. Technical skills required: .NET 3.5, ASP.NET, C#, Data Masker™, Fiddler, OOP, SOAP, SQL Server, T-SQL, VBA, Visual Studio Team System 2008, WebServices, WebForms, and Winforms. Development methodology followed the Agile process.
Wyeth (Now Pfizer) 10/07-5/08: Senior Software Engineer. My role was as primarily staff augmentation, providing manpower where needed. Primary task was integration of “Configurable off the Shelf” third party software packages into a mainframe/network environment. This included installation of an international secure FTP system to reduce transit time of time sensitive eCTD documentation. Cost savings of this installation was estimated at 1.5 million dollars on the first day of operation. I also wrote the GMP documentation, including DQ’s, IQ’s, OQ’s, for software implementation, as well as establishing benchmarks, testing and implementation.
Other tasks included installation of “Black Box” testing of new systems. Code review of newly developed C# applications. The creation of C# modules and Oracle SQL Stored Procedures to support new applications. Provided code commenting and system analysis, of the upgraded the P2P system. Technical skills required: .NET 2.0, Classic ASP, CSS, C#, Oracle’s PL/SQL, SOAP, Toad, and XML.
Accomplishments include saving Wyeth an estimated $1.5 million with the first project completed in six weeks.
IBM 1/07-7/07: Senior Developer, QA Tester, Data Masking Specialist. Using VB.NET, developed a Windows Service for the PARS to PIIN interface. PARS, or Police Arraignment System, is a Sybase based Client Server System, and PIIN, Police Integrated Information Network, is an Oracle based Web Service System. Using Use-Cases provided by IBM Software Architect, created both batch processing and event driven data transfer modules interfacing these modules. Tasks included troubleshooting the Oracle and Sybase stored procedures supporting the interface and the generation of consistent and coherent masked test data for proper testing of dataflow using a VB.NET application. The VB.NET application scrambled numbers based on a seed based random number generator for consistent results and a lookup table referenced system for personal, town and street names. Technical skills required: SOAP, SQL Server Management Studio 2005, Oracle’s PL/SQL, SQL Server, T-SQL, Toad, VBA, VB.Net, WebServices and XML.
Accomplishments include removing blocks preventing the PARS-to-PIIN from moving forward for 18 months.
GlaxoSmithKline 8/06-12/06: Developer. Working in the Small Projects Department, gathered requirements from Scientists, designed, tested and implemented various programs to assist in the quantifying of data and pivot tables for pharmaceutical studies. Began work architecting and data modeling the Specimen Transition program to update location and space availability of test animals. Technical skills required: .NET 2.0, SOAP, Oracle’s PL/SQL, Toad, Winforms, VBA and XML.
Accomplishments include improved efficiencies of data analysis for scientists and I was nominated for GSK’s “Beyond the Boundaries” award.
TNS Media Intelligence 10/05-7/06: Developer, Project Manager, QA Tester. Using NUnit, performed “White Box” testing of upcoming projects MediaWatch™ and Branded Products™. Created multithreaded test harness to test these products. Gathered requirements from customers, monitored system role out, and served as first level support. Technical skills required: .NET 1.1, C#, OOP, SOAP, T-SQL, and Winforms. Development methodology followed the Agile process.
Accomplishments include analysis of database blocks and resolutions.
Lost Battalion Games 8/04-5/09: Part Time Position. Web Master, Search Engine Optimization Specialist. Supported the eCommerce site www.lostbattalion.com. This involved rolling out the eCommerce package and updates, maintaining the SQL Server database, providing customer communications, creation of new HTML and ASP pages as required. Technical skills required: .NET 1.1, ASP.NET, C#, Google Adwords, HTML, VBA, VB.NET, Visual Studio, and Webforms.
eHealth, (now Siemens Health Systems) 4/2002 to 9/2005
Quality Assurance Software Engineer
Received 3 cash awards for innovation and excellence.
Using .NET, designed, and implemented a Quality Assurance Program that melded mainframe applications into a Windows environment.
Using VB6, developed Statement Confirmation via Web System. Project saved company $2.1 million over the next 4 years.
Using .NET, developed a number of applications, automating manual processes, and saved over a 2,000 man hours in the first year.
Using .NET developed a text-mining program.
Using .NET, created a HIPAA compliant databases, maintenance processes, and documentation for both the QA and Test environments. Databases were fully data masked with consistent obfuscated data produced from my code written in VB.NET. The task involved identification of data to be obfuscated, creating subroutines for the different data types, and logging masked data. Numbers were obfuscated using a seed based random number generator for consistency. Names were transformed via lookup tables.
Served as customer support.
Completed Visual Studio NET certification, including C#, VB.NET, and Rational Rose UML.
Completed training in Agile methodology.
Languages and packages used: .NET 1.1, C#, ISIS, JCL, MS Access, NT 2000, MS SQL7, VBA, VB6, VB.NET, and Winforms.
Shared Medical Systems, (now Siemens Health Systems) 2/1998 – 4/2002
Software Consultant
Earned two merit raises and awards for individual achievement and effort
Served on a SWAT team for process improvement with Medicare billing software.
Using VBA, C++, SYBASE SQL, was a developer for the Novius™ laboratory automation software.
Created troubleshooting, automation, and customer interfaces.
Using SYBASE SQL and C++, served as an applications programmer for OPENLab™, a two tier client server system that automated hospital laboratory functions from registration to billing.
Provided mentoring and training for an expanded department.
Served on QA team.
Languages and packages used, C++, VBA, VB6, OS/2, Rexx, SQL7 , SYBASE SQL, SQL Server, Winforms, and Crystal Reports.
Battlefield Design Group 11/1995 – 2/1999
DBA, Programmer, Game Designer, Historian
Part Time Position. DBA and Game Designer for computer strategy game “Road to Moscow.”
Created player interfaces. COM and ActiveX calls were used for graphics, sound, and network play.
Received training in ActiveX. C++, Network and modem “Head to Head” play, and “Fit and Form” functionality.
Skills required were front-end functionality, Installshield™, COM, C++, VBA, DBA, artificial intelligence, WinForms, and QA testing.
Siemens Medical Systems 8/1986 – 12/1997
Field Service Engineer
Maintained Computed Axial Tomography scanners (CAT Scan), Magnetic Resonance Imagining (MRI), as well as a variety of supporting peripherals, including digital cameras PLC’s and ultrasound units.
Was team leader, mentor, and trainer of area FSE’s
Served in Siemen’s TAC Center. This position was reserved for only the best system troubleshooters.
Maintained Computed Axial Tomography scanners (CAT Scan), Magnetic Resonance Imagining (MRI), as well as a variety of supporting peripherals, including digital cameras PLC’s and ultrasound units.
Was team leader, mentor, and trainer of area FSE’s
Served in Siemen’s TAC Center. This position was reserved for only the best system troubleshooters.
Electronic Arts 3/1986 – 8/1986
Programmer, Game Designer Revised and published “Road to Moscow.” Over 4,000 units were sold.
Languages used, Basic and Assembler.
AJ LaCourse 9/1985 – 8/1986
Robotics Programmer, Industrial Electronics FSE
Using Hewlett Packard programmable controllers (PLC), programmed industrial controllers and created robots to automate manufacturing plant functions.
Provided Electronics Field Service for a variety of industrial equipment.
NL McCullough 7/1984 – 7/1985
Beta tester for NL Industries computerized sensor truck. This was the first digital data integration of Neutron/Gamma Ray/Magnetic/Sonic sensor arrays with computerized recording and laser camera readouts.
Responsible for maintenance and repair of all high energy sensors, and electronic explosive controls used in the Ark-La-Tex district.
Ba’rac 2/1983 – 7/1985
Programmer, Game DesignerUsing Commodore Basic, and Assembler, created published the computer game “Road to Moscow” for the Commodore 64. This was a computer strategy game pitting the German Army against the Red Army in World War 2. Was nominated by GAMA for Game of the Year.
Using Forth, was support programmer for the computer game “Star Crystal.”
Technicare 6/1982 – 2/1984
Installer
Installed Digital Subtraction Angiography Machines. This involved adapting a digital video front end to 3rd party X-ray systems. It required initiative as installations were often working alone on these projects in different cities every other week.
Received training in high-tension electronics, VMS, DEC PDP-11 series computers, Matrix cameras and customer relations.
Skills required were System and component level troubleshooting; microprocessor-based controllers, X-Ray adjustments and customer relations.
United States Navy 11/1975 – 5/1982
Missile Fire Control Technician
Member of the Personnel Reliability Program and held a secret security clearance.
Serviced missile battery radars on the USS Oklahoma City, CG-5 and the USS King
DDG-41.
Served as work center supervisor on USS King. Received battle efficiency E.
Was trained in parts procurement and leadership, high-tension electronics, radio frequency principles, hydraulics, digital and analog electronics, synchro and servo systems.
Skills required were system and component level troubleshooting in all manner of electronic systems.
References
Lorenzo Liti
Manager, Cotiviti
(484) 368 4711
Amy Vrahas Hall
Software Engineering Executive
(571) 236-2605
Colin Sillamen
VP Software Development Manager at HealthCareIT
colesillaman@gmail.com
(484) 365-3900
Commercial Products
Seraphim
Updated data input algorithms from previous code blocks to current object-oriented standards. I am under a confidentially agreement for the work performed, but I can say this involved converting from a number of older languages (C++, VB, ad-hoc SQL) to state of the art, .NET Framework 4.7.3, code for running in a cloud environment.
AspDotNetStorefront.
Customized the Vortex Product AspDotNetStorefront for customers specific needs.
Text-Mining
Architected, developed, and implemented a text-mining program that can sort through very large files for specific data based on coordinates and search functions. Patent submitted.
Road to Moscow (Windows 98)
Designed and developed of all levels of the program and tools.
Programmed in C++ and COM. Supported with Excel, and VBA.
Master of Magic
Unaccredited concept designer.
Road to Moscow (Commodore)
Copyright 1984, Ba’rac Software Limited and later, Electronic Arts.
Approximately 4,000 sold.
Star Crystal (Apple)
Copyright 1985, Ba’rac Software Limited
Approximately 500 sold.
No comments:
Post a Comment