Greg Duffie Email & Phone Number

Mclean, Va, Us

Experienced Senior Microsoft SQL Server Database Developer, Administrator, and Architect with a solid background in the healthcare industry. With over 18 years of practical experience in database and IT roles, I am dedicated to optimizing data management solutions that enhance patient care.My expertise lies in designing and maintaining high-performance SQL databases, crafting intricate queries, and implementing scalable architectures for critical applications. Currently, I lead the development and maintenance of a custom-built scheduling system for dialysis patients and nursing staff, streamlining operations and ensuring seamless healthcare services.Throughout my career, I have thrived in dynamic environments, collaborating with diverse teams to ensure data integration, security, and compliance. My strong analytical skills and commitment to staying updated with industry trends enable me to drive transformative change and improve business processes. As a meticulous problem solver and effective communicator, I eagerly embrace new opportunities to contribute to advancing cutting-edge database technologies and revolutionizing the healthcare landscape.

Pittsburgh, Pa, Us

We provide high-speed, managed WordPress hosting for businesses looking to improve their website performance, get more leads, and close more sales.Want a professional, high-performance website and tools to help you grow your business? We provide web hosting that is scalable, secure, and reliable for any size company. Hosting with 37SOLUTIONS allows you to focus on growing your business without worrying about technology. Schedule an appointment to learn about our Digital Marketing & Managed Information Technology Services.

Pittsburgh, Pennsylvania, Us

Think BIG Engine specializes in custom web development, search engine optimization (SEO), search engine marketing (SEM), pay-per-click advertising (PPC), social media management (SMM), social media marketing (SMM), website hosting, analytics, and conversion optimization for select verticals.We help entrepreneurs and business owners who want to increase their online businesses. Consumers are looking for a reputable brand to trust before they buy. Unlike traditional marketing, Think BIG Engine helps businesses grow brand awareness, create website funnels, drive targeted traffic, and update their sites which results in increased profits from hot leads and customers.

Washington, Dc, Us

Microsoft SQL Server database developer for e-discovery software, Ringtail, used by legal consultants to collect, process, review, analyze, and produce documents for depositions, hearings, and trials.Frequently helped clients manage and troubleshoot their terabyte-sized databases with billions of rows in multiple tables.Recreated multiple SSIS packages in raw T-SQL to save the company and clients millions in licensing fees. Developed a throttling system to increase or decrease the amount of data being loaded through this process depending on the server load and contention to ensure that users weren't impacted by the load process.Loaded 43 million rows of hash data from the National Software Reference Library (NSRL) into a table in 52 seconds. The hashes were needed to suppress unnecessary files when loading evidence into the system.Wrote data standards for the development team in 2007 which is still in use today. Presented lunch-and-learns to coworkers to help them understand proper T-SQL coding techniques.Subject matter expert for several areas of Ringtail including RDX Imports, Flat File Imports, Injestions, and Productions.Architected a custom audit tracking system with T-SQL triggers before such systems were natively available in SQL Server.Developed message queuing system in partnership with my Hack-a-thon team to add notifications and alerts to Ringtail.Wrote SQL interview questions used by database and application developers to help with interviewing potential candidates. Assisted with onboarding by writing documentation and helping set up machines for new hires.Architected and developed a database and stored procedures used in a web app to track customers involved in a class-action lawsuit for a well-known petroleum conglomerate.Wrote hundreds of tSQLt tests to verify stored procedures and database upgrades work as expected.

Cranberry Township, Pa, Us

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.

New York, Ny, Us

Microsoft Access development

Indianapolis, Indiana, Us

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.

Birmingham, West Midlands, Gb

Inventory auditing and control

Led staff of 10 employees and several temporary workers who processed over 33,000 real estate documents and 3,200 loan files per month while maintaining a 3–4 day turnaround and increasing quality by 6%.Built an Access database to log, track and ship all real estate documents and boxes for frequent investor loan sales averaging $45MM per sale.Administered a custom-built Access application used by over 75 employees across two states to search for and track specific loan documents related to mortgage transfers.