Timothy J Curtin

860-***-****

adx5j5@r.postjobfree.com

Summary:

• To design, develop and implement web-based solutions in ASP.Net using C# or VB.net in an n-tier client-server environment using the Microsoft.Net platform.

• To implement Business Intelligence via SSRS and SSIS for disparate system integration and reporting. Technical Skills:

• SharePoint Server 2010, ASP.Net, ASP, DHTML, AJAX, XML, MSXML, SQL Server SSIS 2008+, SQL Server Reporting Services 2008+, SQL Server 2008+, Stored Procedures(T-SQL), Triggers, C#, Visual Basic.Net, VB6, VBA, VBScript, JavaScript, CSS, HTML, MS Access app dev, Excel Macros, Crystal Reports, COM+, IIS5+, SSL, e-commerce, Credit Card Gateway, Transaction processing. LIGHTSWITCH 2012 Web-based UI development. Infor Lawson Process Automation, Lawson HR, JSON processing, JQuery, JSON Education & Certifications:

• MCSD .Net, (Microsoft Certified Solution Developer)

• MCAD.Net, (Microsoft Certified Application Developer)

• MCP (ASP.Net, SQL Server), (Microsoft Certified Professional)

• MSMVP-ASP.Net (Microsoft award), MS Most Valuable Professional. For industry contributions for education.

• MCT (Microsoft Certified Trainer)

Professional Experience:

Collins Aerospace, Windsor Locks, CT August 2019-Present Principal Specialist

• Team architect overseeing all principals of SDAT web interfaces, associated reporting engines and system automation.

• Develop-normalize SQL Server databases to support supply chain initiatives as well as stored procedures, triggers and views.

• Strategized database indexing for report performance optimization.

• Develop SDAT ASP.Net web application for supplier tracking and maintenance

• Administer Azure Windows Server IIS installation and execution. Monitor SiteMinder integration with IIS for server security.

• Built SSRS report server, manage user security access. Develop SSRS reports and integrate with ASP.Net web application for ease of reporting and download

• Design and build ETL processes for loading monthly data submissions for Collins’ businesses for performance and quality supplier reporting

• Mentor colleagues in the development and management of all the above for accurate and efficient coding, logic and architecture design

• Coded and developed C# console application for connecting with Google API for address submission and earth coordinate responses for supplier update and global plotting on SDAT web page interface. Center for Human Development, Springfield, MA Sep 2017-Aug 2019 Software Developer

Responsibilities:

• Develop, restore, maintain downloaded SQL Server database backups from hosted solutions and ensure restore to production environment via SSIS ETL process. Extracted clinical and financial data into data warehouse for SSRS reporting

• Develop stored procedures, views, tables, triggers to manage data in SSRS corporate reporting portal.

• Developed asp.net applications in C# for tracking incidents that occur in one of 128 clinical locations within MA and CT.

• Develop and maintain several SSIS packages for ETL integrating data from several restored databases for clinical metrics as well as billing and budgeting applications into our data warehouse.

• Trained new hire to understand the SDLC and best practices for solution implementation.

• Developed/Maintained ASP.Net/C# web forms applications for Excel automation as well as data collection for external agency reporting.

• Maintained legacy MS Access/VBA applications for versioning of Office applications as well as SQL Server/ODBC upgrades.

CT Children’s Medical Center, Rocky Hill, CT May 2016-Sep 2017 Systems Analyst

Responsibilities:

• Develop Infor Process Automation (IPA) to extract HR data from Lawson HR system to text file for submission into ADP payroll/HR system. This was UAT/Dev for a new implementation. Integrated custom SQL Server database with stored procedures for a validation engine and logic for xref of HR data coding.

• Created several template documents for specification and user acceptance testing (UAT)

• Utilized SharePoint for Standard Work documentation (Standard work, specifications and templates).

• Integrated IPA with MS SQL Server databases and Landmark (Lawson) database

• Developed xml file extract from Lawson HR to xml file. Developed XSLT stylesheet to transform Lawson formatted XML to Job board proprietary format.

• Developed integrated SQL Server – Lawson HR extract to Cornerstone hosted training web-based application Barnes Aerospace, Farmington, CT Oct 2011- May 2016 Senior Software Developer

Responsibilities:

• Develop ASP.Net/VB.Net business applications for end user support and configuration.

• Develop SSIS 2008 packages for nightly ETL between world-wide divisions to local data warehouse.

• Develop SSRS 2008 Reporting solutions and integration into MS SharePoint 2007+.

• Created SharePoint SSRS subscriptions for email attachment.

• Develop SQL Server 2008 Stored Procedures/triggers for data maintenance.

• Maintain SharePoint Server 2007 web content and deploy ASP.Net web applications.

• Develop web user interfaces with Microsoft LIGHTSWITCH for data maintenance.

• Responsible for data migration for file system documents into MQ1 Document Management System. Worked with vendor to prepare data files, file path Excel document and migration database. Allowed local engineering staff to QA their technical documents to assure accurate load into said system. Belcan Engineering Group (Hamilton Sundstrand)

Sep 2007-Oct 2011

Sr. Consultant

Responsibilities:

• Developed web-based solutions via ASP.Net and VB.Net as well as SQL Server.

• Aggregated several data sources such as Excel spreadsheets and Access databases into one SQL Server database. Developed tools for data cleansing and worked with users for data cleansing process.

• Responsible for initial user-interface and architecture design for software deliverables.

• Responsible for migrating 50+ legacy web applications to current Microsoft technologies (classic ASP and ASP.Net 1.0).

• Support over 50 Supplier Quality Systems via information gathering from several business customers.

• Migration of legacy MS Access applications to SQL Server driven solutions via stored procedures, triggers, and DTS jobs to ensure HS inspector quality via email notifications for eye exams, supplier audits and contractor audits. Tek-Systems: Farmington, CT Jan 2007-Sep 2007

Consultant

Responsibilities:

• Supported company solution for State of New Jersey Board of Education for upload of student transcript files and ETL process for parsing into data warehouse using ASP.Net/C#.

• Developed several ETL (DTS) process for import into data warehouse. Fiserv Lending Solutions, Rocky Hill, CT 2006-2007 Software Developer

Responsibilities:

• Developed and maintained several internal ASP.Net/C# intranet applications to support Customer Service as well as the company intranet portal.

• Developed B2B web service communication with other parcel information providers via XML for parcel data and comparable sales.

• Converted XML stream into HTML via XLST transformations for sorting and querying. Fuss and O’Neil Technologies, Manchester, CT 2004-2006 Senior Developer/Analyst

Responsibilities:

• Developed ASP.Net components interaction with Crystal Reports to export Data and images to PDF format via stored procedures with dataset binding. Data was provided by interoperability with ARCIMS (GIS) mapping system via streaming XML/XSLT to provide data and parameter configuration.

• Data is transmitted via XML over HTTP. Data binding is used with ADO.Net strongly and weakly typed datasets. Temporary state data is stored in SQL Server via stored procedures. Triggers are used for data auditing for historical changes to data in configuration tables.

• Assessor data is retrieved via Data Access Layer (DLL) and stored procedures. Used JavaScript and DHTML for client-side functionality for tab and menu controls.

• Developed Image Management System to store Assessor Image data for uploading of photo imagery.

• Developed ‘Sky Dust’ data collection system for University of Rhode Island for to store atmospheric particle information and image upload.

• Built a Pocket PC Field data collection system with Sprint DB product. Microsoft Active Sync was used to synchronize compact Access database to desktop database.

• Integrated ‘Project number generator’ in asp.net I generated JavaScript and XML with XMLHTTP component and SOAP Web Services for generation and validation of new project number. Integrated ‘New Project Generator’ with Deltek Vision system.

• Co-developed Project Management system for National Real Estate developer to manage project data with Access 2003 VBA and MSDE (Microsoft Desktop Engine).

• Integrated Outlook and Exchange server for synchronization of Tasks and Contacts with MSDE. Successfully configured ‘Outlook Model Guard’ security features in Outlook/Exchange and Active Directory to allow OLE automation of synchronization process between Access and Outlook.

• Built several Crystal Reports and Access reports, user interface for Accounts Receivable financial analysis on a clinical billing system.

• Currently developing Pocket PC application for field data collection and integration with Bluetooth GPS device using Visual Studio 2005, Windows Mobile 5.0, and SQL Mobile 2005.

• Provide consulting services in developing business applications using Microsoft development technologies as listed above.

Contact this candidate