Greg Duffie

Apr 2007 - Present

SQL Server Developer

FTI Consulting, Greentree, PA

• Lead SQL Developer on web-based evidence collection application used for tracking and processing hard drive data.
• Completed auditing system that uses triggers and dynamic SQL to track changes to any 2000/2005 database.
• Used SCRUM method of Agile software development to coordinate with project team and achieve quick results.

Jan 2006 - Present

Owner

37SOLUTIONS, Pittsburgh, PA

• Manage web hosting (cloud and traditional) for small to medium businesses in the Pittsburgh area.
• Web design and development using open source tools including Community Server, WordPress, Joomla, Drupal, WikiMedia, OpenCart and Magento.
• General IT consulting for small business looking to improve performance, throughput and efficiency.
• PC repair and maintenance including hardware upgrades, virus/spyware removal, performance improvements, security testing and networking.

Jan 2002 - Apr 2007

SQL Server Developer, DBA

Communifx, Cranberry Twp, PA

• Expertise in data cleansing, warehousing and reporting on databases up to 200GB for companies including Verizon Wireless, Verizon Online, LendingTree, CheckFree, Audible, DAD’s Pet Care, Vonage, Bank One/Chase and Sheetz.
• Assisted Senior DBA with database design, performance tuning, maintenance, hardware configuration and security on 7 internal development servers and 2 external production servers.
• Proven ability to write efficient queries, stored procedures, functions, DML and DDL as well as extensive work migrating DTS packages to SSIS during conversion from SQL Server 2000 to 2005.
• Performed data scrubbing, standardization and matching on millions of records using custom SQL scripts, Visual Basic 6/.NET applications, SSIS Fuzzy Lookup/Grouping and third-party tools like Mailroom Toolkit and DoubleTake API.
• Administered MicroStrategy BI installations, maintenance, upgrades and websites. Developed reports that analyzed direct mail, email and website metrics such as demographics, psychographics, opt-in ratios and response rates.
• Assisted network administrator with purchase decisions, software evaluations, SAN/NAS/DAS hardware configuration, tape backups/administration, capacity planning, networking and maintenance on 20+ servers and 50+ workstations.
• Worked with internal and external clients on project requirements, specifications, planning, proposals and pricing.

May 2000 - Nov 2001

Programmer, Application Support for Indiana State Department of Health

SCB Computer Technology, Indianapolis, IN

• Provided 1st, 2nd and 3rd-tier support on HIV/STD programs, Time & Activity systems and Inventory & Surplus applications as well as Novell GroupWise, Microsoft Office and Windows 9x through NT.
• Enhanced a Visual Basic 5.0 utility to update Access databases via email so that 200+ remote users didn’t have to spend up to 180 minutes downloading 200-800KB updates over a dial-up network.
• Developed a VB 5.0 and Access 97 application to calculate employees’ paid time off balances for Human Resources as an alternative to printing/reviewing over 700 individual reports.
• Worked in a team to help HIV/STD department retrieve data from their SQL Server 7.0/Access 97 VBA application by writing EDI procedures in Access 97 VBA and administering the daily data transfer. Reduced data-entry errors on the Access front-end by improving the data validation routines.
• Developed a ColdFusion 4.5 intranet application to track inventory and surplus items throughout the organization and converted the original FoxPro database to Oracle 8i.
• Worked with a team of developers on version 5.0 of their Time & Activity system by programming complex maintenance screens using ColdFusion 4.5, Oracle 8i, JavaScript and HTML.

Expert, 8 years

SQL Server

Eight years in analysis, development, design and warehousing with approximately two years in administration. Extensive experience with T-SQL, Query Analyzer, Enterprise Manager, SSMS, BIDS, DTS and SSIS. Some experience with Reporting Services, Analysis Services, replication, log shipping and database mirroring.

Beginner, 5 years

Visual Studio

Five or more years developing or troubleshooting stand-alone and client/server applications.

Intermediate, 2 years

Microstrategy

Two years on development, configuration and administration of all three tiers.

Advanced, 15 years

Operating Systems

Windows 3.1 through Windows 7

Some experience with SuSE, Ubuntu, Sun Solaris and OpenOffice.

Beginner, 1 year

Oracle

One year of development using Oracle 8i, SQL*Plus and TOAD.

Beginner, 2 year

Teradata

Two years of experience with Queryman/SQL Assistant, OLELOAD, FastLoad, FastExport.