John Frampton Email & Phone Number

Provide business direction and management for all aspects of the company. Solutions-oriented software professional with extensive experience in software consulting, development, and engineering designed to provide stable, timely, and cost-effective business solutions to clients.

Port Washington, Ny, Us

Develop code to support Snowflake implementation. Use TDD to develop .NET code to support integration of ZenDesk (3rd party help desk) software. Implement code using TDD to handle customer data management (per CCPA)

SQL Server, Visual Studio .NET (C#), ASP.NET MVC (MVVM), Amazon Web Services, Microsoft Azure, Web API, ReactJS• Managing the design and implementation of a new sports-oriented social media site. All aspects of development including: database design, business class implementation, business class unit testing implementation, use of Web API to implement RESTful web services, implementation of web service unit testing, UI development using ASP.NET MVC as well as ASP.NET WebForms, implementation of ReactJS using ReactJS.Net. Initial set-up of database and web servers in AWS. Subsequent move of database and web servers to Microsoft Azure for cost savings.

Boston, Ma, Us

Performed technical lead function on adding new feature to Client Billing application. Met extensively with the billing group to determine their needs. Translated those needs using the Agile methodology (backlog refinement, sprint planning, etc.) Implemented the new functionality leveraging TDD/BDD methodologies. Spearheaded bi-weekly demos to show progress to the billing group. Worked on the in-house Client Billing application performing bug fixes and enhancements. Improved and enhanced various ETL packages in SSIS.

Parsippany, Nj, Us

Completed small projects using various Microsoft technologies. C#, SSIS, SSRS, SignalR

Producing Saas offering of internal applications in the automotive glass claims space. • Converting multiple in-house applications on various platforms (Web, Web Services, Desktop application) and written in various languages (C, C++, Delphi, VB6, “Classic” ASP) into a single, integrated web application to be sold as a Software-as-a-Service (Saas) offering. This application will allow minimally trained, insurance company call center representatives the ability to leverage the software to easily assign the correct, most cost effective glass repair or replacement for a given incident.• Implemented the use of servers on Amazon Web Services (AWS) as the application’s backbone for both a Load Balanced outward facing web as well as multi environment, secure database servers (PROD, QA, etc.) within the client’s Virtual Private Cloud (VPC) across Availability Zones on AWS. Also implemented SqlServer mirroring within the client’s VPC to ensure continuous uptime as well as SqlServer log shipping backup to an entirely different AWS Region for near-time Disaster Recovery.

Fridley, Minnesota, Us

Oracle 10g, Visual Studio .NET (C#), ASP.NET• Created the back-end data store to manage payments given to and expenses spent upon Health Care Professionals. This requirement was time sensitive as it was being driven by a Federal reporting mandate. • Created SSIS packages to perform ETL for data import and export with a 3rd party reporting company expert in the field of HCP reporting for the government.Visual Studio .NET (C#), WPF, Silverlight• Developed detailed validation process for RIA Services to existing Silverlight intranet application. Created WPF application targeted at the desktop for Administrative support of the Silverlight intranet application.

Visual Studio .NET (C#), ASP.NET, Telerik Controls• Re-architected and rewrote the company’s flagship Saas Time and Attendance product from a custom xml and JavaScript driven software resting on ASP.NET 1.1 to .NET 3.5 using Telerik controls, code-behind pages, AJAX, minimal unobtrusive JavaScript and current best practices. This software was the driving force behind the company being acquired by Asure Software of Austin, TX.

Minneapolis, Mn, Us

Visual Studio .NET (C#), ASP.NET, SQL Server• Business Objects, web pages, stored procedures and views. Consistent UI• SSIS package enhancements

Medford, Massachusetts, Us

Visual Studio .NET (C#), ASP.NET (MVC2)• Helped architect new website using ASP.NET MVC2. Implemented code at all tiers of the MVC design pattern. Made use of jquery2.js to create a very interactive user interface. Implemented a JSON model paradigm on the user interface to allow for complex logic to be performed on the page with a minimal amount of round trips to the server. Implemented custom AJAX calling procedure to standardize the user experience on server calls that resulted in major changes to the current page. Added custom ToJson and FromJson methods to the base ViewModel class. Implemented logic in Controller layer and above (the application implemented Helper and Worker layers to abstract logic away from the controller).Visual Studio .NET (C#)• Created a TFSJira Bridge service that provided the ability to synchronize to discrete bug tracking systems (Jira and Team Foundation Server). This included creating listeners for each system to capture notifications on bug creation or change as well the ability to update or create the same on the alternate system. Implemented with persistence logic to capture bugs that could not be persisted and place them in an xml file that would be used once the “down” system came back online.Sybase• Re-factored 3000 line stored procedure into approximately 30 smaller sub stored procedures in an effort to make the logic more robust and to provide for better exception handling and error reporting.

SQL Server, SQL Server Analysis Services, SQL Server Reporting Services, Web Development• Created new data cube using SQL Server Analysis Services in SQL 2008, the cube provided reporting data matching existing company reports.• Created new reporting solution using SSAS and T-SQL stored procedures, the data is used to populate the reports. • Added custom MDX queries used to generate accurate multi-level reports.• Implemented each report in a custom ASPX page using the SSRS ReportViewer, used standard .NET Web Controls to capture parameter values. • Created extensive code-behind to manage each report written in VB.NET

Weston, Ma, Us

SQL Server, Visual Studio .NET (C#), ASP.NET, JavaScript, Google Maps• Developed code to modify imported vendor boundary data to be Monster specific using SQL 2008 Geospatial data. • Used custom code and web service calls taking the modified data and generating Monster location overlays on the Google map on the Hiring homepage (hiring.monster.com). • Added Web Service parameters providing different resolutions for different zoom-levels. • Added modulo logic to the stored procedure call enabling a web.config value to determine how detailed the overlay boundary would be (i.e., how many boundary points per area will be returned) in SQL 2008. (June, 2008 – October, 2008)• Major contributor to Monster’s Enhanced Resume Search product (current product name is Power Resume Search). • Performed preliminary technical analysis using existing Resume Search products determining how they might best be leveraged into the new product. (October, 2008 – June, 2009)• Modified Monster Auto Complete type-ahead custom control for hiring specific usage. • Reduced code requirement to single control per page using the type-ahead with logic to re-initialize the single control for any text box requiring it. • Greatly reduced code overhead per page and increased page load times and performance, this control is used for Job Title, Location, Skills, Company and School text boxes.• Created a new Monster Nested CheckBox control that allows data to be recursively added to a manually generated check box list, indenting the sub-levels as the control is drawn on the page. This control is used on the new Enhanced Resume Search for Education Levels but is designed to use any appropriately recursive dataset.• Implemented caching of resume data returned from newly-purchased Monster partner, Trovix. • Completed various troubleshooting and ticket resolution assignments

Medford, Massachusetts, Us

JavaScript, Google Maps, Internet ExplorerCompleted a working Proof of Concept (POC) which was delivered within a two-week timeframe. The developed POC was implemented to integrate Google maps into an existing ASP.NET application in an exclusive Internet Explorer internal environment. Developed using JavaScript, JSON (JavaScript Object Notation), Google’s GMap interface and the Internet Explorer Modal Dialog box.

Attleboro, Ma, Us

Visual Studio .NET (C#), WinForms, SQL Server, SharePointArchitected and developed a bulk import tool to upload multiple documents with content types and content type field values using the Microsoft.SharePoint API. The application was developed as a WinForms stand alone application with a SQL Server back-end that allowed the user to enter data about their documents in Microsoft Excel, that data was then imported into SQL Server which served as the data store for the import tool.

Boston, Ma, Us

Visual Studio .NET (C#), ASP.NET, PHPCreated an “Inbound Single Sign On” for Eaton Vance Broker/Dealers, where employees from the Broker/Dealers companies were able to access the International section of EatonVance.com from their respective company’s network, without a special login. The employees were prohibited from accessing the site from other locations, and Broker/Dealers were able to be added or removed as needed.

New York, Ny, Us

SQL Server, Visual Studio .NET (C#), ASP.NETConverted the SquareCanvas web site to new CreativeHub web site using the code base with minor changes and creating an entirely new user interface in a two month period. I worked with newly hired CTO at the client site in a collaborative effort to mentor him in .NET and to produce the new web site.

New York, Ny, Us

SQL Server, Visual Studio .NET (C#), ASP.NETArchitected the database, business objects and web pages for the SquareCanvas web site. I interacted directly with the client to keep them aware of progress and issues. I managed a 3-man team of developers to get the web site complete in a very compressed time-frame.

SQL Server, Visual Studio .NET (C#), ASP.NETImplemented and enhanced a Commercial Off-The-Shelf (COTS) e-commerce package as a stop-gap measure for a time-sensitive web site. I made various custom modifications to the existing C# code, XML Packages and SQL procedures. These included adding additional authorization for a secondary partner ID, the ability to capture the customer's credit card and store it for back-end processing in the database and adding a FedEx Tracking hyperlink to the customer's Account History that launched a pop-up window displaying the tracking information. I populated the database with uploaded product data that was provided by the client. I completed the application through testing and into production within a four week time frame to enable the client to achieve a critical contractual obligation. The finished site provided a full e-commerce experience, including multiple user levels and administration features.SQL Server, Visual Studio .NET (C#), WinFormsDesigned and implemented a new WinForms application to provide customers with Proof of Delivery (POD). I created an entirely new data store, including tables and stored procedures to contain the data for this application. I created a set of separated DataAccess and Object classes to implement all of the application's functionality. I created a custom and extensible module for querying Shippers for files showing POD. In the case of FedEx, for which this application was built, I injected an XML request into an HTTPRequest stream and received an XMLResponse. I then parsed the Base64 Encoded text within the appropriate section of the XMLResponse into a pdf file. I used the Winzip command-line to compress all pdf files per customer into one file. The single file was then either e-mailed as an attachment in Lotus Notes or sent via fax to the client.

SQL Server, Visual Studio .NET (C#), ASP.NETImproved and enhanced existing architecture with recommendations for best-practice usage in .NET 2.0. Move Security model to .NET 2.0 Membership/Role provider model. Made website enhancements and upgrades. Created and implemented custom menu navigation control for proprietary environment. Developed custom overlay calendar control.

Boston , Ma, Us

SQL Server, Visual Studio .NET (C#)Designed and implemented a new application architecture using best practices and development methodologies. The application framework included a services framework providing Cryptography, Security, Data Abstraction, Exception Handling, Logging and Caching. The framework also included a base-class framework that provided Authorization, Validation and N-level undo, among others. Began implementation of Web Services for external data access.

SQL Server, Visual Studio .NET (C#), Crystal Reports, MS Access 2003Designed and implemented a new corporate software architecture using best practices and development methodologies. Designed a Trade Blotter application using object-oriented analysis and design. Developed the Trade Blotter application in C# using N-Unit to develop test cases and N-Doc to provide an on-going standardized help file for future developers and management. Tested the Trade Blotter application in a distributed QA environment. Deployed the Trade Blotter application using a .NET Setup and Deployment project. This application originally used embedded Crystal reports with a Crystal Report viewer, but was modified to provide those same reports via an ASP.NET Web application. Created Web Services for external data access.This assignment also involved troubleshooting and developing small applications to manage minor, one time problems.

VB, XML, XSLT, XHTML, WebsphereCoded upgrades to existing commercial software package. This entailed making code changes in the VB 6.0 base package, creating MQ calls to Websphere, transforming the MQ return into XML and then using XSL to transform the XML into XHTML. I also upgraded small, internal applications using C#.

New York, Ny, Us

VB.NET, XML, Teradata Database, SQL Server 2000Developed a WinForms application using VB.NET to facilitate user correction of Suspension files generated from the data warehousing process. Enhanced functional specification to a standard WinForms design using accepted UI layouts. Created and implemented technical specification including the application integration into the user’s existing Product Workbench application. Developed application including iterative changes from user feedback. Managed testing, bug fixes and final rollout.

Providence, Rhode Island, Us

ASP; SQL Server 2000, VB, VB.NET, C#, ASP.NET, StaffwareMaintained full responsibility for management of multiple teams of software engineers engaged in the creation and development of diverse professional software products designed to assist business in functioning more efficiently. Communicated technical information to business users at a non-technical level to help them better understand complete project life cycle. Created project plans and coordinated meetings throughout life cycle of project. Delivered software presentations to business users. Provided mentoring and training to other software engineers to include design tips, database structures, object-oriented programming, and database techniques. In charge of all phases of the Software Development Life Cycle (SDLC). Including: review of business requirements, development of functional specifications, Object-Oriented analysis and design, verification of new software integration into system architecture, development of technical specifications, code development including peer code reviews and iterative functional reviews with the customer, code optimization for middle-tier business objects as well as back-end SQL code and DTS packages, design and execution of test plans, deployment through the Development/QA/Production environments, ensured code management using Merant PVCS or Microsoft SourceSafe, creation of user documentation and support manuals. Evaluated and implemented third party tools, including: Infragistics Datagrid, Merant PVCS, Erwin Data Modeler, WebFOCUS Reporting Engine and Oracle 9i

Providence, Rhode Island, Us

ASP; SQL Server 2000Wrote full functional specifications covering new collateral data display for the Branch Locator Intranet application. I wrote a detailed design document for the same. I employed an n-tier architecture for the software solution. The solution consisted of new ASP pages, an existing COM object and a SQL Server database. The ASP pages were used for data presentation and gathering. They contained extensive JavaScript used for client-side validation as well as numerous VBScript functions to manage common server-side development tasks. Although a help file was not included, extensive help hints were included in the ASP pages using the ALT attribute. The existing COM object was used to provide isolated data access. The SQL Server database consisted of new table structures and stored procedures for data persistence. I also developed a test plan for the new application, including unit testing, integration testing, system testing and regression testing.

Boston, Ma, Us

ASP; Visual Basic 6.0; COM; SQL Server 2000Wrote full functional specifications covering new licensing area for the Division of Insurance. I wrote a detailed design document for the same. I designed an n-tier architecture for the software solution. The solution consisted of new ASP pages, a COM object and a SQL Server database. The ASP pages were used for data presentation and gathering. They contained extensive JavaScript used for client-side validation as well as numerous VBScript functions to manage common server-side development tasks. The middle-tier consisted of a COM object to encapsulate business logic and provide a straightforward interface for ease of use for junior programmers. The SQL Server database consisted of new table structures and stored procedures for data persistence. I also participated in developing a test plan for the new application, including unit testing, integration testing, system testing and regression testing.

Boston, Ma, Us

ASP; SQL Server 2000Brought in to see the project through to production. I created new ASP pages and enhanced existing ASP pages. I reverse-engineered existing JavaScript validation to server-side VBScript validation per the Commonwealth’s requirements. I developed stored procedures, scripted the entire database for a move to production and created transaction based DTS packages to move data downloaded form the mainframe onto the SQL Server. I provided a test plan for load and stress testing of the new application. I provided documentation to consolidate knowledge of the software for purposes of ongoing training and enhancements.

ASP.NET; VB.NET; ADO.NET; C#; MS Visual Studio.NET; SQL Server 2000; MS Visual SourceSafe 6.0Project manager and software architect in charge of full life-cycle development of new web site. I gathered required functional specifications from the client. I created technical specifications representing a .NET design for the website. I developed System.Web.UI.UserControl controls for use in this application to facilitate a common header and menu for all pages. I created the database-tier using C#. I created the business logic-tier using VB.NET. I created the presentation-tier using ASP.NET. I transferred data using ADO.NET. I provided documentation to consolidate knowledge of the software for purposes of ongoing training and enhancements.

SQLServer 2000; COM+; MTS; ActiveX controls; ActiveX components (COM); MS Visual Studio 6.0; MS Visual SourceSafe 6.0, Infragistics DatagridProject manager and software architect in charge of designing and deploying a new software product to replace the manual method of aggregating data to perform trades in the International Active Group. I gathered required functional specifications from the business user. I created technical specifications representing an n tier design for the software product. I developed ActiveX controls for use in this project and by other developers in the IT department. I designed and implemented COM objects and a graphical user interface (GUI) for the new software. I used COM+ to manage the object interactions on the different logical tiers, specifically using MTS to make efficient use of resources and to control some transactions. I provided a documentation mechanism to consolidate knowledge of the software for purposes of ongoing training and enhancements.

Providence, Rhode Island, Us

SQLServer 7.0, MSAccess 97, ActiveX component (COM); MS Visual studio 6.0; MS Visual SourceSafe 6.0; Visual InterDev 6.0; Active Server Pages (asp)Project manager and software architect in charge of re-designing and re-deploying an existing MSAccess phone bank call tracking program. I oversaw two VB/VBA developers. The first project was a migration from a de normalized stand-alone MSAccess program to a client/server version of the same with a SQLServer 7.0 back end and a stand-alone MSAccess GUI. This application is being used by the Business Banking section as a highly customized, contact management database. The second project was creating a new web-based call tracking system to be used by phone sales associates via the company intranet.

Boston, Ma, Us

Visual Basic 6.0; SQLServer 7.0, ActiveX component (COM); MS Visual studio 6.0; MS Visual SourceSafe 6.0; Visual InterDev 6.0; Active Server Pages (asp); eXtensible Mark-up Language (XML); n-tiered architecture, OLAPProject manager and software architect in charge of redesigning and redeploying an existing MSAccess reporting tool. I oversaw four VB developers. I designed and deployed an OLAP solution for the same data.The first upgrade was from the MSAccess program to a stand alone VB application with a SQLServer 7.0 back end. This application was to be deployed to 22 regional offices in an effort to standardize region reporting to the corporate office. The second upgrade was moving the VB front-end to the web. This allowed the corporate finance department the ability to extract reporting data via the company intranet/extranet.This project was designed using an n tier architecture. The middleware layer of COM objects incorporated the business logic. It also managed the passing of data to the end user and calls to the back-end. This design allowed for ongoing front-end and back-end updates, while keeping the business logic stable.

Boston, Ma, Us

Visual Basic 6.0; ActiveX component (COM); MS Visual studio 6.0; MS Visual SourceSafe 6.0; Visual InterDev 6.0; Active Server Pages (asp); eXtensible Mark-up Language (XML); eXtensible Style Language (XSL); SYBASE; n-tiered architectureI created a COM object in VB 6.0 to encapsulate the work of modifying, updating and adding office document properties from existing data in a SYBASE database to MS Office documents. This COM object accessed previously captured data and programmatically placed it in the Summary Properties section of MS documents (i.e. Word, Excel and PowerPoint). This allowed the MS SiteServer to crawl those documents during off-peak hours and compile data to be used in a site-wide search from the web. I created a thin-client program in VB to use this COM object. I packaged and delivered the software using MS Visual Studio 6.0 Package and Deployment Wizard. I worked in the Visual SourceSafe 6.0 version control system. I tested and documented the program. I completed the project in two weeks.I created a COM object in VB 6.0 to import XML-like data from a web site using the VB Internet control. I modified the data to be valid XML. I displayed the data on the web site using inline XSL. I worked in the Visual InterDev environment.

Boston, Ma, Us

Active Server Pages (ASP); ADO; Database Design; SQL; Stored Procedures; Triggers; MS Access; pass through queries; Visual Basic for Applications; DAOI implemented a web interface using ASP connected to a SQL Server to facilitate data access by remote users. I performed custom programming for the Fidelity Fund Management & Research Company (FMRCo). I enhanced and modified an existing SQL Server database containing Y2K data to be more reliable, consistent and accessible. I created and distributed user interfaces into the Y2K Compliance database using MS Access97. I converted existing Access databases to MS Access97 in a corporate effort to become Y2K compliant.

Database Design; SQL; Stored Procedures; Triggers; MS Access; pass through queries; Visual Basic for Applications; DAO; RDO; Crystal ReportsI performed custom programming for the Corporate Human Resources department. I upgraded and standardized an Access program to facilitate reporting for the Corporate Redesign Group. I created a program for the Corporate Retraining Group to select employees for reassignment and to track their progress. I converted existing Access databases to Access97 in a corporate effort to become Y2K compliant.

New York, New York, Us

Database Design; SQL; Stored Procedures; Triggers; SQL Server Administration; SQL Server Installation; Visual Basic; MS Access; pass through queries; Visual Basic for Applications; DAO; Active Server Pages (ASP)I documented existing Access databases. I implemented and administered a SQLServer 6.5 server farm. This included extensive use of complex stored procedures, triggers and views. I ported existing databases and programs to SQLServer 6.5. I created new programs using VB 5.0. I used ASP to make these applications accessible through the corporate Intranet.

Bloomfield, Ct, Us

Database Design; SQL; Stored Procedures; Triggers; SQL Server Administration; SQL Server Installation; Visual Basic; MS Access; pass through queries; Visual Basic for Applications; DAOI performed an emergency rescue of an irreparably corrupted native MS Access 2.0 database and its subsequent conversion to SQLServer 6.5. I improved the newly migrated system with a new GUI, pass-through queries and stored procedures for more efficient reporting.

New York, Ny, Us

Database Design; MS Access; Visual Basic for ApplicationsI planned, designed and implemented a television program tracking system in MS Access 2.0 to be distributed nationwide as a stand-alone program. This program is the preliminary reporting engine for BMI’s television royalty tracking.

Alm In It, Information Technology

Bachelor'S Degree, Psychology