OPERATING SYSTEMS: Windows Workstations and Servers (Web, DB, File)
SOFTWARE: Visual Studio 2017, Team Foundation Server (TFS) 2013, SQL Server 2014/2016
WEB SERVERS: IIS, Microsoft Azure (Cloud Services, Web Apps), Amazon Web Services (SES)
SOURCE/VERSION CONTROL: GitHub, Visual Studio Team Services, Team Foundation Services (in - house and online), SVN
Senior Software Developer
- Designed and Developed a dynamic application to allow users to create and manage surveys/assessments
- Configured and tested Amazon Web Services (AWS) for bulk email
- Created custom handlers to receive the responses (bounces, complaints) from AWS SES
- Managed multiple databases in the Dev, Test, and Prod environment
- Managed the pushes from Dev to Test and from Test to Prod
- Assisted data-analysts with Tableau reports (providing data, debugging calculations, researching functionality, etc.)
- Created a drag and drop UI to allow the user to:
- Easily create an assessment with questions, different answer types (radios, checkboxes, textboxes)
- Save blocks of text or multiple questions as templates to drag in to other assessments
- Save assessments as templates to reuse
- Installed and configured a Tableau report server
- Designed and developed an interface to allow the report developers to setup the parameters that would show up on the end-users’ screens as filters.
Data-warehouse Developer, Software Developer
- Designed a data-warehouse based on the customer needs
- Analyzed data sources to develop fast (as possible) and robust imports into the fact, dim, and valid value tables in the warehouse.
- Created jobs that reported details based on what we needed to know from each import.
- Created an Excel ribbon and templates to deliver the Pivot Tables, Charts, and Reports to the customer.
- Created custom reports that allowed the customer to update data back into the database
- Analyzing and debugging data issues. Providing the customer with understanding and alerting them to flaws/bugs in their existing systems.
Web Developer / Database Administrator
- Meet with clients to gather requirements and assess their business needs
- Design databases in SQL Server 2014, and using Entity Framework 6
- User management from multiple system types (Web server, FTP server, CPanel accounts)
- File upload and parse contents into the database
- Generate and manipulate charts based on the uploaded data
- Create and maintain multi-million dollar advertising campaigns
- Built an Excel-like grid control with arrow navigation, auto-complete depending on field type, CTRL keys (save, home, new, etc.), show hide columns, move columns, client-side sorting, row/col/field highlight, and validation
- Built Windows Services that do the following:
- Connect to a mail server
- Parse emails into the database
- Read emails
- Send auto-responses based on the purchase request in the email and the current inventory/prices
- Based on email requests; Create an FTP directory, Generate Excel files, Zip the files up and put them on an FTP server, create an FTP user account, and send the login information to the user
Web Developer / Database Administrator
- Installed and configured SharePoint Portal Services on IIS 7 for both the development machine and the staging machine.
- Developed Web parts and enhanced existing SharePoint screens using Microsoft SharePoint.
- Designed a database that could support the complexity of the Web application as well as provide dynamic reporting.
- The Web application allowed the user to:
- Add new form fields
- Drag and drop the fields anywhere on the screen
- Add tables and other form elements
- Select the style from a Cascading Style Sheet
- Edit an existing form (this would also save the layout and version for auditing purposes)
- Managed the Web servers for development, testing, staging, and production
- Managed the Database servers for development, testing, staging, and production
- There were two previous attempts by several programmers to build this application but it proved to be too complex. The timeline for publishing the application to production could not be moved. I was able to complete the project within the remaining three months meeting the deadline and all of the requirements.
- Designed and developed a Web application using MVC 4, WCF, Razor, NHibernate, and Spring.Net.
- Created a service layer that contained all of the interfaces, models, and data access objects (DAO’s) that were used by the Web project.
- Created many controllers and over 250 views.
- Designed the CSS for the site layout.
- Wrote various jQuery functions.
- Setup all of the NHibernate mappings as well as the Spring.Net configuration.
- Install and configure SQL Server and SSRS.
- Created reports using SSRS.
- Created an SSIS package to export data to CSV files.
- Trained a team of 10 developers from various backgrounds how to develop in ASP.Net using C# 4.0
- Created a Test Project that we used to write our unit tests using NUnit.
Software Engineer / Team Lead
- Lead a team of five senior software engineers in developing an application with ASP.Net using C# and .Net Framework 4.0 for The Arc Montgomery County
- Installed and configured:
- The SQL 2008 R2 database server which doubled as the Report Server (SSRS)
- Installed and configured each machine for the developers to run Visual Studio 2010 and connect to TFS 2010
- Designed and developed an application in ASP.Net using C# and .Net Framework 4.0 that would allow the user to define fields, forms, and the layout of the fields on those forms which would then become part of the application.
- Created a document store in SharePoint to keep all project related documentation.
- Managed user access to the document repository using group permissions.
- Once the user creates the form they can apply rules to it such as who may view it, and at what point would it notify another user to take ownership or approve the form.
- Designed a relational database that stores the form and form field configurations. The same database would store the data captured by the forms and keep a history of changes made to the form configurations as well as a history of the data that has been changed via the form(s)
- I was responsible for the system-wide architecture which included all of the above modules and their communication.
Software Engineer / Team Lead / Architect
- Meet with clients to gather requirements
- Write the requirements documentation for review and sign-off
- Analyze the needs of the client with the available budget/resources, and clients current environment to come up with one or more proposals for the technology which would be best to implement
- Write the proposed Software Architecture Document (SAD) for review and sign-off
- If needed I would setup the development, testing, staging, and production environments. This included installing the OS per server as well as installing and configuring the software for the database server, (SQL Server, MySQL, PostgreSQL, Oracle, etc.), Installing and configuring the software for the source control server, (VSS, SVN, TFS, etc.), e. Installing and configuring the software for the application server(s), (IIS, Apache/Tomcat, PHP, Perl, etc.)).
- Developed Web Services in C#.Net to download ZIP files, automatically extract, and parse the data in the directories storing relevant experiment data to be used in the algorithms for climate model predictions. The algorithms included the integration of World Wildlife Fund (and other third party contributors) to predict the affect future climate would have on the different species of wildlife
- Developed a portal in ASP.Net that the scientists could use to collaborate, merge/overlay data, and then generate visual maps of the whole world zoom-able down to region, state, city, etc.
- The visual map contains overlays with the highlighted coordinates and information generated by the experiment data used (map overlays developed with ASP.Net, JSON, AJAX, and XML)
- The maps were downloadable in (KML, XML, Excel) as well as printable in different formats (PDF, PNG, TIFF)
- Developed the admin section of the portal in ASP.Net as well which allowed the lead scientist to create groups, approve applying users, create rules, and manage the content that would show up throughout the site
- Developed a Web application in ASP.Net for Goodwill that allowed them to manage sites throughout the globe. It has the ability to manage employees, inventory, accounting, and best practices by cross-referencing the practices used and ROI
- Technical consulting, designing and architecting solutions, applications, and business flow
- Installing and configuring servers and development machines including the development environments
- Administrating the Visual SourceSafe database
- Data-modeling, and administration
- Choosing the best technology for the client based on what the end product will be as well as time, money, and quality.
- Designing Flash forms and movies using Macromedia MX Studio
- Developed an interface for molecular-diagnostics test results and reports using Windows Presentation Foundation (WPF) written in C#.Net (The user interface (UI) was designed to display real-time results from the Analytical Systems (AS). The AS accepts blood samples and then evaluates the spectrum of reflected light to diagnose a result. This result was then sent via XML transfer to the WCF services written in C#.Net which then updated the database.
- Developing services to communicate to the instruments running the molecular-diagnostics using Windows Communication Foundation (WCF) written in C#.Net (The XML transferred from the AS would be imported by the WCF service and then updated the main database; There were Data Reduction (DR) processes that then fired off and calculated the results that were received from the AS).
- Designed and developed stand-alone simulators that mimic the behavior of an instrument using Model View Controller (MVC) written in C#.Net; (For the initial design of the classes and interfaces I used Visio 2007 and later Enterprise Architect; To develop the software I used Visual Studio 2008 Team Foundation Server and C#.Net).
- Writing requirements and use-cases
- Designing and building the databases: (Three of the databases were created using SQL Server (using all of the features listed in the summary above as well as asymmetric keys for encryption), One of the databases were created using Informix (IBM DB2)).
- Helping team members with the initial installation, setup, and configuration of the projects (Visual Studio, Visual Source Safe, SQL Server, Informix (and then IBM DB2), Subversion, IIS, etc.)
- Assigning modules to team members and giving guidance as needed
- Building some of the more advanced modules and the mobile application using ASP.Net
- Assigning use-cases to team members
- Testing, regression, troubleshooting for team members as needed
- Code-reviews (not coder-reviews)
- One of the Web applications were written in C#.Net running on Windows Server 2003/IIS 6 with a SQL Server 2005 database
- One of the Web applications were written in Java running on Linux/JBoss with an Informix (IBM DB2) database
- Meeting with senior level federal staff members to gather requirements.
- Developing custom research and clinical applications using the latest programming methodologies.
- Installed and configured SQL Server 2005, Visual Studio 2005/2008, and Visual SourceSafe 2005 on servers and developer machines.
- I designed (with the help of my team), modeled, and build the databases.
- Develop and maintain a central code library allowing the sharing of code among the various projects.
- Met with vendors to discuss common off the shelf products (COTS) integration with our systems to meet requirements.
- Complete project documentation and diagrams for each audience-type (developers, UI designers, management).
- Developing Windows Services using C#.Net to perform tasks such as ETL functions and file system maintenance.
- Writing Web Services using ASP.Net to interact with a SharePoint Portal Server
- Developed open-source applications using JSP with a PostgreSQL database running on an Apache Tomcat server.
- Creating Excel Graphing Macros in VB 6.0
- Creating additional ribbons for MS Outlook using Visual Studio Tools for Office (VSTO)
Sr. Developer/Team Lead
- Administrating the Siteminder Single Sign-on (SSO) for the entire National Institute of Health. This allows the employees of the NIH to login once and have access to all of the applications throughout the NIH intranet. The developers for the NIH intranet applications can access the user's credentials to check the employee's permissions and personalize the applications.
- Installed and configured Siteminder Single Sign-on (SSO).
- Installed and configured Web Agents for participating application servers.
- Developed a vulnerability tracking system (VTS) that watches the NIH domain for security breaches, viruses, and out of date security patches. Once an "alert" is found it is logged and an incident is created. Administrators then take the alerts and/or incidents thought a complex flow adding and editing the sensitive information to finally resolve the issues.
- Co-developed the NIH Pioneer project that allowed scientists and doctors to apply for a five year grant to research whatever they wanted. This had to be very secure and scalable. The first day the application was released to the public there were over 10,000 unique users.
- Debugged PHP source code for a common off the shelf (COTS) program installed for content management systems.
- Using SQL XML to import scan-data that is generated when the scanning software (Retina, Sara, and ISIS) is run. The scans generate complex XML that is stored on the file system or exported from their own proprietary databases. For a while just an XML import schema was sufficient. New versions of the scan software created inconsistent XML formats which forced me to import using SQL XML in stored procedures to validate, modify, and then import the data.
- Installation and configuration of the Infragistics software.
- Implementation of the Infragistics control libraries throughout the applications.