SUMMARY:

A position as Lead Software Engineer or Data Integration Engineer with a technologically challenging firm, where my years of experience with IT tools, my team leadership and group mentoring abilities, and my ability to find and implement non - obvious solutions can be put to best use.

TECHNICAL SKILLS:

Methodologies: Agile/Scrum, Keane Productivity Management, OneProcess, SEI CMM, ISO 9000, PMI BOK, IBM TPM, Full Lifecycle Testing, OOD/OOA, RUP.

Operating Systems: Windows 2003 Server, Win XP, Win NT, Win 9x, Win 3x, UNIX, Linux, Sun Solaris

Server Applications: Informatica PowerCenter 9, Internet Information Server 3-6, MSMQ, IBM MQSeries, Commerce Server 2000, MS BizTalk Server 2000, HPExtreme

Languages and Development Tools: T-SQL, Ansi SQL, PL/SQL, .NET 1.0 - 3.5, Visual Studio.NET, LINQ, UML, C#, VB 1.0 - .Net, MVC 2-3, ASP, ASP.Net, AJAX.Net, HTML, JavaScript,JSON, JQuery, XML, XSD, W3C DOM 3.0, SOAP, Web Services, SourceSafe, Subversion, GhostDoc, Doxygen, Win32 API, C

Databases: MS SQL Server 6.5 - 2008R2, MS Access, Oracle 10g, PL/SQL Developer, Oracle Forms, Oracle Reports, Stored Procedures, Triggers, SQL Profiler, ERWin, ADO.NET, DTS, BCP, SQL Server Reporting Services, SQL Server Integration Services

Applications: Version One, MS Office (all versions), MS Project, Visio

Other: TCP/IP, LAN, LDAP, Internet, Intranet, Extranet, Security, Encryption

EXPERIENCE:

Senior Integration Developer

Confidential, Tampa, FL

Responsibilities:

• Technologies included Informatica PowerCenter 9, SQL Server 2008 R2, SSIS, CA Workload Automation(Autosys), C#.net, VB.net, SFTP
• Responsible for creating ETL functionality to move data off of DB2 and Oracle databases into a SQL Server based data warehouse.
• Responsible for creating a series of interfaces with Informatica PowerCenter to replicate and replace data extract processes on DB2.
• Responsible for writing business rules and functional specifications for new data extracts.
• Responsible for insuring that interface changes exhibited 99.9% correct data.
• Responsible for migrating changes through UAT and Production, as well as training other developers on the migration process.
• Responsible for writing SQL stored procedures to achieve high volume ETL operations.
• Responsible for documenting and working with Informatica support to resolve bugs in the PowerCenter Developer tool.

Senior Technical Consultant

Confidential, Tampa, FL

Responsibilities:

• Technologies included Visual Studio 2008-2010, .NET 3.5-4, SQL Server 2008 R2, T-SQL, Stored Procedures, Confidential, Web Services, AJAX.NET, JQuery, N-Tier development, OOD.
• Responsible as a lead team member for developing a customer focused health insurance enrollment web site for our client, Collibrium Partners. This site used a Model/View/Presenter framework with a highly complex object model to deliver multiple individualized health insurance offerings to customers.
• Responsible for designing and implementing a web services client used to push medical investigator enrollment information to a SalesForce.com web service.
• Responsible for implementing version two of a web front end for the SalesForce web service.
• Responsible for designing a Confidential service for our client, Aramark, to provide a persistence layer for their sports facility suite management application, SuiteWizard.

Consultant

Confidential, Temple Terrace, FL

Responsibilities:

• Technologies included Visual Studio 2005, .NET 2.0, C#.Net, ASP.Net, SQL Server 2005, TSQL, Stored Procedures, Web Services, AJAX.NET, JQuery, N-Tier development, OOD.
• Responsible as a team member for developing changes to Confidential ’s MVSS application. This application is used by Confidential customer service agents to manage customer accounts.
• Responsible as a team member for deploying new code versions to production.
• Changed stored procedures to prevent SQL injection attacks by replacing dynamic SQL with compiled stored procedures.

Consultant

Confidential, Tampa, FL

Responsibilities:

• Technologies used include Visual Studio 2010, .NET 3.5 - 4.0, C#.Net, VB.Net, ASP.Net, MVC3, SQL Server 2008 R2, SSIS, LINQ, Confidential, Web Services, Windows Services, and Cincom Eloquence
• Responsible as a team member for development of a comprehensive insurance policy quoting and enrollment system for Confidential ’s customer, AIG. This application was designed using the ASP.NET MVC3 framework.
• Responsible for designing and coding complicated SQL schemas to support dynamic insurance policy definitions.
• Responsible for designing and implementing data auditing processes using Change Data Capture.
• Responsible for designing and coding a system to generate PDF based notifications of policy based legal documentation. This system interacted with an AIG web service using Confidential to retrieve data to generate the required legal notifications.

Consultant

Confidential, Largo, FL

Responsibilities:

• Technologies used include Visual Studio 2008, .NET 3.5, C#.Net, VB.Net, ASP.Net, CSS, JSON, JQuery, SQL Server 2008, SSIS, LINQ, Confidential, Web Services, Windows Services, and Microsoft Message Queuing, and TamirSSH.
• Responsible for full life cycle development of the LRT Referral Service, a batch system that grabs files from an SFTP server, decrypts them, performs extensive validation logic, and finally inserts them into the database with SSIS. This implementation required rewriting parts of the open source TamirSSH library for our purposes.
• Responsible as a team member for designing and coding new functionality for Elavons EAGLE system. This included designing ASP.NET components, C# class libraries, and optimizing and in some cases rewriting existing SQL procedures and SSIS packages.
• Responsible as part of a team for remediating an in the wild SQL injection attack. Was first team member to correctly identify the exploit vector and purpose of the attack. Personally identified all rows of corrupted data, and provided cleanup scripts to remediate same. Provided a pattern for rewrite of the system to prevent further attacks.

Consultant

Confidential, St. Petersburg, FL

Responsibilities:

• Technologies used include ASP.NET, CSS, Javascript, MVC 2, JQuery, JSON, Visual Studio 2010 Team System, SQL Server 2005, C#.NET, LINQ, Dynamic LINQ, LINQ to Entities, Version One, and SSIS in an Agile/Scrum environment.
• Responsible for design and coding across all tiers of the HSN website for the Mobile 2011 project. This includes table, stored procedure, and trigger design on the database level, as well as data layer object design, business object layer object design, and front end ASP.NET and MVC2 framework page design and coding.
• Responsible for designing and coding ETL operations for the Powered by HSN project. This included SSIS, table, stored procedure, and trigger design and coding.
• Responsible for design, and coding of the Assimilation Email project. This includes complex SQL code to randomly assign and persist ABTest groups for each recipient, as well as extensive proof of concept work with LINQ to Entities and Dynamic LINQ used to filter selection criteria flexibly.

.Net Software Engineer

Confidential, St. Petersburg, FL

Responsibilities:

• Technologies used included Visual Studio 2008 Team System, SQL Server 2008, SQL Profiler, SSIS, C#.NET, LINQ2SQL, Microsoft ORM Mapper, UML, Visio, ASP.NET, Confidential, and Microsoft Message Queue.
• Primarily responsible for developing Jabil One, a supply chain optimization tool that calculated all costs associated with Jabil After Market Services operations, including freight costs, direct labor costs, equipment costs, and parts and materials costs. This effort involved working with the project sponsor and subject matter experts to gather all requirements, designing both the calculation API, a SQL Server database, a website to maintain the user input data, and designing and coding all ETL operations necessary to populate the database with background data.
• Primarily responsible for designing and coding a generic SmartQueue class that wraps any of three separate types of queues, either a generic in memory Queue, a persistent Microsoft MessageQueue, or an Oracle Advanced Queuing Service queue.
• Responsible as a team member for coding a Confidential implementation of a web service used for automating Confidential failure reporting.

Developer

Confidential, Pinellas Park, FL

Responsibilities:

• Technologies used included Visual Studio 2008, SQL Server 2008, ASP.NET, Crystal Reports, Web Services, Microsoft Message Queue, VB, XML, Subversion, HPExtreme.
• Responsible for writing a COM Interop DLL that connected a VB6 era legacy application to a Message Queue that fed print jobs to HPExtreme.
• Responsible for writing several Confidential webservices, enabling our client to submit large numbers of insurance claims efficiently in the case of a natural disaster.

Programmer Analyst

Confidential, St. Petersburg, FL

Responsibilities:

• Technologies used included Oracle 10g, PL/SQL Developer, Oracle Forms, Oracle Reports, SQL Server 2008, Visual Studio 2008, .NET 3.5, VB6, Windows Services, Microsoft Message Queue, Visual SourceSafe
• Responsible as member of team that provided 24/7 third tier support for several major enterprise applications within Fidelity, including ClientView, E-Reports, DataExpress, VICS, and CommView.
• Responsible for designing and coding new development efforts for compliance with PCI security standards.

Senior Software Engineer

Confidential, Clearwater, FL

Responsibilities:

• Technologies used included VB6, JavaScript, AJAX, ASP.NET, .NET 2.0 - 3.5, C#, SOA, UML, Microsoft Message Queue, SQL Server 2000 - 2005, SSIS, SSRS, Clustering, Red Gate, MS Report Server 2005, Visual SourceSafe, Subversion, Microsoft Project, encryption, web services and XML.
• Team leader for full lifecycle development of an n-tier web-based enrollment application. This project involved a migration from a VB6 application to a more robust .NET system with additional functionality. Activities consisted of all project management duties, primary requirement gathering, design/code/test of the extensive business object layer using OOD principles, supervision of design/code/test of all other layers, coordination of all integration test and user acceptance testing, and responsibility for project completeness and on-time delivery.
• Team leader responsible for full lifecycle development of a debit card creation and management system. This system consisted of a Service Oriented Architecture using Microsoft Message Queue, multithreading, web services, windows services, and encryption technologies to issue debit cards to all PlanFirst debt management program participants
• Solely responsible for full lifecycle development of a mission-critical ACH transaction management API that was used to process all transactions by PlanFirst clients. This application tracked successful transactions, verified their completion, persisted all exception history, and managed the entire problem resolution process.
• Responsible for all database design, tuning, and maintenance of all company databases. Routinely coded all “difficult” SQL stored procedures. Reviewed all SQL code written by developers and tuned or rewrote same for performance issue resolution. Implemented naming standards, and designed and coded ETL operations with SSIS. Recommended purchase and deployment of various data tools including the full suite of Red Gate tools.
• Responsible as lead designer for a series of major Confidential processes involving interaction with the Automated Clearing House (ACH) network.
• Determined hiring requirements, reviewed qualifications, interviewed, negotiated compensation, and approved for hire all development resources offered employment.
• Responsible for tasking all development resources.
• Responsible for mentoring all development staff and preparing them for the responsibilities of full lifecycle development duties.

Lead Web Architect

Confidential, Dunedin, FL

Responsibilities:

• Promoted to Lead Web Architect from software engineer in July 2005.
• Technologies used include ASP, ASP.NET, SQL Server, T-SQL, VB.NET, C#, ADO, ADO.NET, JavaScript, XML, AJAX, DotNetNuke 3.11 and 4.0, Visio for Enterprise Architects, UML, and Microsoft Project.
• Team Leader responsible for software development within a small Internet-based organization. Determined development tools, SDLC processes, QA processes, and Data Warehousing practices. Extensive involvement in hiring, training and mentoring a development team of 8-10 resources. Extensive interaction with all areas of the company up to the CEO level. Performed a number of different roles as needed by the organization, including DBA, Architect, Lead Web Developer, Business Analyst, and QA Lead.
• Solely responsible for OOD/OOP of Business Object Layer and Data Layer of a migration project of company's most heavily trafficked web portal from VB6 to C#.NET.
• Responsible for performance tuning and troubleshooting of SQL Server 2000 databases.