TECHNICAL SKILLS:

Languages/Frameworks/IDEs: C#, VB.Net, VB6, ASP.NET MVC, WCF, REST API, JavaScript, Angular, XML, Entity Framework, LINQ, Classic ASP, Visual Studio, Salesforce/SOQL, SSIS, Jira, ServiceNow.Operating systems Windows 10, Windows OS, Linux, DOS

Databases: Oracle 10g/11g, SQL Server 2014/2008

Version control: SVN, TFS, GitHub

WORK EXPERIENCE:

Confidential, Charlestown, MA

Lead Developer

Responsibilities:

• Senior member of a dispersed team of developers supporting the triage of enhancement tasks and issue resolution in a Salesforce/.Net/SQL Server, SSIS and integrations environment. All processes focused on the management of sensitive Group, Member, Provider and Claims data.
• Use of Salesforce Workbench query environment and visual studio to troubleshoot and resolve the issues associated with the aggressive rollout of the Salesforce implementations.
• Review SOAP APIs to identify areas to remove memory leaks, improve performance, increase scalability and implement REST API principals.

Confidential, Bourne, MA

Web Developer

Responsibilities:

• Development of Classic ASP based web sites with SQL Server 2014 serving as the back end for a highly data driven architecture. Heavy use of JavaScript, jQuery/AJAX and Transact - SQL to customize the front end, data driven business logic. Extremely high paced customer focused environment.

Confidential, Quincy, MA

Software Engineer

Responsibilities:

• Object oriented analysis, design and development of c#/asp.net application that support the complex electronic billing / EDI process management process. The requirements, design & development process of the Telecom EDI invoicing configuration system requires a solid understanding of relational database design principals and the EDI 811 transaction set. Dynamic data driven menus and feature rich functionality are supported by a rock solid and complex object oriented, N-tier architecture.
• Design and development of C#/asp.net MVC electronic invoice quality analysis reporting system. This applications data source is derived from a comparison analysis of electronic file billing data to monthly system data.
• As the principal software developer for the electronic billing team, my main responsibilities include managing a large number of customer facing projects through their software development life cycle with a very challenging and dynamic work environment.
• Principal technical lead on all Oracle electronic billing/EDI applications and supporting .net/Oracle systems development life cycle.
• Technical project lead developing the Oracle electronic billing/ EDI process moving it from a largely manual operation to an automated process.
• Responsible for creating requirements & detailed specifications documents for C# & database developers to work from.
• Technical lead for resolving customer escalations & disputes regarding billing transactions.
• Lead daily meetings to set goals with other team members regarding day to day, monthly & quarterly projects and initiatives.
• Responsible for management the transmission process of electronic invoices to clients exceeding $40 million of billing / month.
• Subject matter expert for development of supporting .net and Oracle/Sterling Integrator ETL EDI process.
• Design, develop, test and maintain customized Oracle procedures and ODBC file maps supporting over 1,200 billing files and 300+ external customers.
• Collect & review external customer requirements with electronic billing team to ensure the specifications meet the customer’s needs.
• Identify and resolve day to day production electronic billing configuration problems and issues.
• Document and implement, development, and test Oracle Stored procedures & views used to create electronic customer bills.

Confidential . Boston, MA

Systems Development Specialist

Responsibilities:

• Helped move development team from an AS400 environment into a .Net development environment.
• Supported development and maintenance of legacy VB6/SQL Server 2000 application and supported new development of VB.net & C# applications that serviced a variety of internal needs.
• Applications were developed to utilize SQL Server stored procedures with dynamic SQL.
• Developed and supported VB.net applications that served as front-end for a legacy AS400/DB2 data environment. These systems were built with a clearly defined client and server component architecture in mind.
• Developed and supported development of SQL Server DTS packages for various data loads.

Confidential, Hingham, MA

Consultant

Responsibilities:

• Developed DTS packages and stored procedures that imported data into tables used by a financial securities broker activity auditing system.
• Developed and tested stored procedures that detected exception data conditions used in the broker auditing system.

Confidential, Boston, MA

Developer

Responsibilities:

• Developed and tested an electronic performance review application. The first version of this application was developed as a VBScript/ASP/Access system and was redesigned as a Visual Basic/SQL Server system to provide more user-friendly features. The system has a user base of approximately 300 users.
• Interfaced heavily with CMS Open time and billing system. This system was developed as an ASP/SQL Server system.
• Developed and tested Library reservation and administration system to assist attorneys with the search and reservation process of references in the legal library. This system was developed as a Visual basic, ASP and SQL Server.

Confidential, Woburn, MA

Consultant

Responsibilities:

• Converted a collection of Access 2000 Applications into a single VB/SQL Server/Access/Crystal Reports application. That utilized an object oriented VB/COM+ architecture to process the service calls, repair and maintenance of cooling systems. The Process included the development of DTS Packages for information transfer to and from a BPCS database on a AS400 System.
• Designed and administered user/group level security in an SQL Server and Access 2000 environments that serviced a user base or approximately 50 users.

Confidential, Hopkinton, MA

Consultant

Responsibilities:

• Converted an Access application ( Confidential ) into a VB/Access app. That utilized VB/COM+ to process the calibration data storage and facilitate report data archiving process. The data/order entry system is the backbone of the company’s business.
• Designed, developed and tested DoubleTrack application that allows the user to scan or manually enter, organize, administer pipette information. This application helps the office personnel track the pipettes as they enter and exit the calibration process. This application uses Visual Basic for a front-end technology and Access for the backend. It also uses a barcode scanner as an optional input tool.

Confidential, Newton, MA

Developer/Analyst

Responsibilities:

• Helped maintain mission critical, object oriented Visual Basic application (SPOT) that had employed the use of ActiveX Controls of the client side and very complex server-side COM objects. This application was used to facilitate the company's retail operations of 20 stores through the use of Citrix client/server architecture.
• These applications involved used VB/COM+, SQL server, XML and SQL-DMO.

Confidential, Boston, MA

Web Developer

Responsibilities:

• Designed, developed, maintained and tested a collection of web sites associated with Confidential e-commerce connectivity services shopping site, which leveraged VBScript, JavaScript, HTML, IIS 4.0 and Transact SQL Server 7.0.
• Developed key areas of the site that utilized ASP, ADO, VBScript, JavaScript, HTML/DHTML, and SQL to develop complex, browser- independent application features and tools such as plan and product catalog display, shopping comparison, data sorting and filtering, shopping wizards and methods, promotions, geography management and product catalog cross-sell.

Confidential, Boston, MA

Systems Analyst

Responsibilities:

• Maintenance of the SQL Server 7.0 database architecture in support of the corporate internet and intranet web sites.
• Developed and maintained entire family of over 70 Transact SQL stored procedures used to provide functionality and content for entire multisite corporate web initiative.
• Developed Visual Basic COM application that received mutual fund data feeds from external sources and processed it to provide data to be presented in the corporate web site. This COM object updated three separate SQL Server environments with substantial critical mutual fund data.