Bob Nolan Email & Phone Number

Philadelphia, Pa

New York, New York, United States

Key Accomplishments:• Designed and created a web-based wizard for the Salary Reduction Agreement enrollment process. The process was initiated by a participant, then transferred to an advisor, and finally returned to the participant for confirmation. Utilized ASP.NET, VB.NET, HTML, CSS, JavaScript, SQL Server tables and stored procedures, (DDL/DQL/DML/TCL), Crystal Reports.• Responsible for development and maintenance of the Payroll Processing system. Created SQL Server stored procedures, tables and functions, utilized DDL/DQL/DML/TCL. Created Crystal Reports.• Maintained and supported the company’s primary website and corresponding desktop application. System consisted of over 2.5 million participants with data housed in over 1,100 tables. Leveraged ASP.NET, VB.NET, HTML, CSS and JavaScript. Created SQL Server stored procedures, tables, triggers, views, and functions, using DDL/DQL/DML/TCL.• Assisted with the maintenance and support of various projects (MVC sites, APIs). Technologies included ASP .NET Core MVC, C#, WCF, HTML, CSS, SQL Server stored procedures, tables, views, and functions (DDL/DQL/DML/TCL), Postman, SOAPUI, WcfTestClient.• Designed and implemented an Online Pantry System with ASP.NET MVC, C#, HTML, CSS, JavaScript, SQL Server stored procedures, tables, views, and functions (DDL/DQL/DML/TCL).Responsibilities:• Was the primary contact to troubleshoot and resolve any issues in all environments, as well as to facilitate transfer of systemic knowledge to newly hired developers and consultants. Included ASP.NET, C#, SQL Server tables, stored procedures, and functions.• In charge of deploying over 25 projects to all environments.• Investigated and coordinated changes needed to migrate existing applications and database objects to Microsoft Azure.

Bohemia, Ny

Key Accomplishments:• Created a stand-alone code-generating application that accepted survey questions and answers as input and generated web code to create the UI. This significantly decreased development time. Application was created with C#.• Collaborated with management to coordinate user acceptance testing.Responsibilities:• Maintained and supported over 25 public-facing websites. Employed ASP.NET, C#, SQL Server stored procedures, tables, views, and functions (DDL/DQL/DML/TCL).• Created contact forms, online surveys, and contest entry forms via ASP.NET, C#, SQL Server stored procedures, tables, and functions (DDL/DQL/DML/TCL).• Created and supported admin tools to allow users to make simple changes to websites using ASP.NET, C#, SQL Server stored procedures, tables, and functions (DDL/DQL/DML/TCL).• Responsible for assigning tasks to teammates, code promotion, data analysis and data mining.

New York, Ny

Key Accomplishments:• Tasked with analyzing legacy applications. Subsequently converted these Visual Basic 6 applications to VB.NET.• Created essential technical documentation to facilitate the sale of the company.Responsibilities:• Responsible for all aspects of design, development, testing and documentation associated with migrating legacy applications (VB 6) to a supported platform.• Ensure “like for like” functionality between legacy and future systems through detailed functionality documentation and test plans.• Generate operations documentation associated with legacy applications to facilitate future support and maintenance.

New York, Ny

Key Accomplishments:• Tasked with gathering specifications and writing an application to import participant, allocation, transaction, and holdings data to facilitate client conversions. The application would accept client data from text/CSV/XLS files, map the data to InvestLink's database schema, access validation functionality, and submit the data to a job queue for processing. Leveraged VB.NET, SQL Server stored procedures, tables, and functions (DDL/DQL/DML).Responsibilities:• Developed and maintained a client-based application for administering Defined Contribution plans. The application allowed for the setup and administration of plans, funds, and participants, as well as associated data, for over 15 third party administrators nationwide. Worked with VB.NET, SQL Server stored procedures, tables, and functions (DDL/DQL/DML).• Worked as part of a team to develop and maintain multiple public-facing websites to provide participants, sponsors, and advisors with investment information and reporting. Data was retrieved from a SQL Server database via web services. Used ASP.NET, VB.NET, SQL Server stored procedures, tables, and functions (DDL/DQL/DML/TCL), Crystal Reports.

Melville, Ny

Key Accomplishments:• Built a web service to allow ASP.NET applications to access an approval management system, which had been constructed using the Microsoft Enterprise Library 1.1, and was not accessible to ASP.NET 2.0 applications. This saved approximately 200 man hours of time required to rewrite the system. Worked with ASP.NET and VB.NET.• Developed a web application to allow loan officers to request credits for borrowers. Loan data was retrieved from a database using a web service and then saved to a separate database, along with credit amounts. An email was then routed to the loan officer's manager, alerting them to the presence of the request, and allowing them to approve or deny it before it was processed. This saved over five hours of administrative work per request. Developed with ASP.NET, VB.NET, SQL Server tables and stored procedures (DDL/DQL/DML/TCL).• Constructed a system to handle customer privacy preferences. Data was loaded into the database manually using a web page, as well as through a nightly scheduled task that downloaded a third-party file from an SFTP site. The collected data was then transmitted to a third-party vendor, using a nightly scheduled task. The results of the transmission were recorded in the database for reporting purposes. Used ASP.NET, VB.NET, SQL Server tables and stored procedures (DDL/DQL/DML/TCL).Responsibilities:• Worked as part of a team responsible for a public-facing website, consisting of over 200 web pages and 350 tables containing more than 30 million rows of data. The team was also responsible for two intranet sites, comprised of over 1500 web pages, and 10 million rows of data in over 500 tables. Used ASP.NET, VB.NET, SQL Server tables, views, and stored procedures (DDL/DQL/DML/TCL).• Worked individually to create various tools as requested by management. Leveraged VB.NET and SQL Server tables and stored procedures (DML/DQL).

Huntigton, Ny

Key Accomplishments:• Developed an intranet-based application to interface with a third-party survey website. The application exported a list of individuals to contact, and then imported their responses and normalized the data into a database for research purposes. The application provided searching, editing, reporting, and data extraction and analysis capabilities. The solution was comprised of over 450 web files, 50 tables containing over 200,000 rows, and 230 stored procedures. Used ASP.NET, VB.NET, HTML, CSS, JavaScript, and SQL Server DDL/DQL/DML/TCL.• Created a web-based application to transfer data from a custom expense report system to a third-party enterprise-level accounting package. This eliminated the need to re-enter previously keyed data, saving approximately $1,000 per week for the organization. Leveraged ASP.NET, VB.NET, HTML, CSS, JavaScript and SQL Server tables and stored procedures.• Analyzed a third-party’s enterprise-level accounting database schema for the purpose of accessing data and presenting it on an intranet. Created the corresponding web application, giving senior management the ability to search on and display data, as well as generate reports. This eliminated the need to license and install additional client-based software, as well as the need to train any of the senior managers on the accounting application. Employed ASP.NET, VB.NET, and SQL Server tables and stored procedures (DDL/DQL/DML/TCL).Responsibilities:• Worked as part of a team to develop and maintain public-facing websites for financial organizations. Utilized ASP, ASP.NET, VBScript, VB.NET, HTML, CSS, JavaScript, SQL Server tables, triggers, views, and stored procedures.• Maintained and enhanced a client-based accounting application. Used Visual Basic 6 and SQL Server tables and stored procedures (DDL/DQL/DML/TCL).• Connected with business analysts to gather requirements