Hugh Plappert

Hugh Plappert

Marketing Technology Consultant

Greater Minneapolis-St. Paul Area

Current
  • Senior Applications Developer at Onvoy
Past

see less...

13 more...

Education
  • Apostolic Bible Institute
Recommended
Hugh has 6 recommendations 6 people have recommended Hugh
Connections
113 connections
Industry
Information Technology and Services
Websites

Hugh Plappert’s Summary

TURN-AROUND SOMEONE ELSE'S MESS. OPTIMIZING UGLY CODE. REMOVE COSTLY BUGS. DECOMPILE AND DOCUMENT EXISTING APPLICATIONS.

Stablized what was thought to be 52 departmental applications. Documented them and found only 38 applications. Improved productivity and eliminated the daily calls to the VP to give an excuse for why the billion dollars in credit card transactions were not settled.

Took on a project that was estimated to cost over $1 million to build by I.T. Completed the application in 40 hours for less than $2000. The success was investigated by the VP of Finance and my hands were found clean. The application lasted for over 12 years with no bug fixes or enhancements.

The application took over 3 hours to execute and I found 4 logical bugs. Rewrote the application and it runs under 12 minutes with the bugs fixed.

Took a 48 hour automated process with many manual steps down to one button and processed in 3 minutes by enhancing the existing application instead of re-writing it in a more costly fashion.

The vendor said the 13 bugs would take at least 3 months and $50,000 to fix. I opened the code and rewrote one store procedure that fixed the 13 bugs in 8 hours of development time.... this is my first time to write a stored procedure.

Do you feel ill? What can The Report Doctor do for you?

NOTE: I HAVE 3 DAY WEEKENDS AND I AM LOOKING FOR PART-TIME CONSULTING WORK.

Hugh Plappert’s Specialties:

Marketing, Database, and Internet Marketing projects. I have had success as a Team Leader and as a Facilitator representing the marketing department to the IT department and vendors. I have over 25 years of experience.

Hugh Plappert’s Experience

  • Senior Applications Developer

    Onvoy

    (Privately Held; 201-500 employees; Telecommunications industry)

    June 2008 — Present (1 year 6 months)

    Converting SQL Reporting Services reports from 2000 to 2005 version. Moving the reports across servers. Updating the T-SQL behind the report to run more effecient.

    Rewriting T-SQL Stored Procs to incorporate data source changes, improve speed, improve the supportability of code, make the scripts re-runnable, and streamline the code while improving readability.

  • Database Consultant

    Lifecore Biomedical

    (Public Company; 51-200 employees; LCBM; Medical Devices industry)

    September 2008 — September 2008 (1 month)

    Wrote a front-end to a medical device inspecation database that would sync up changes from one copy to another copy. There were new records added to both of the databases. The challenge was to cross-ref the ID's from one database to the other database including child records. I saved the company time by being able to create the system without making changes to their FDA regulated databases. I was given two weeks to complete this emergancy assignment. It was completed, tested, and documented in 1 week and 1 hour from the minute I took the assignment working only on evenings and the weekend.

    What database ills does The Report Doctor need to look at for you today?

  • Consultant (COMSYS)

    RBC Dain Rauscher

    (Public Company; 10,001 or more employees; RY; Financial Services industry)

    October 2007 — June 2008 (9 months)

    * Role: T-SQL and DTS programming for loading data into a new data mart.

    * Marketing: Developed SQL for populating, analyzing, and reporting the Market Research Database.

    * Accomplishments: Took an existing SQL scripts that ran for 2 hours and re-wrote them run under 7 minutes, and significantly improved the integrity and quality of the data.

    * Data: Representatives, financial, and household data.

    * Technologies: T-SQL, and DTS.

    * Industry: Financial Planning

    * Details: Developed T-SQL scripts and DTS batch packages to populate data mart tables using SQL Server 2000. Audited and improved existing T-SQL scripts.

  • Consulting

    Consulting (Self-employed)

    (Self-Employed; Information Technology and Services industry)

    1994 — 2008 (14 years )

  • Consultant (Robert Half Technology)

    E Group

    (Privately Held; 11-50 employees; Marketing and Advertising industry)

    June 2007 — October 2007 (5 months)

    * Role: Support & Enhanced eStore, and designed and built source control system

    * Marketing: Developed a sales pipeline model, e-commerce sites, email marketing, behavior change modeling.

    * Accomplishments: Improved the quality and supportability of a number of websites. Built and support their new web and SQL development servers. Previous updates were coded on the live server.

    * Data: eStore data on SQL Server.

    * Technologies: C#.NET, Ajax, VB.Net, SQL Server 2000, Classic ASP, and Javascript

    * Industry: Incentive gifts, and Marketing.

    * Details: Developed web applications in Classic ASP, Javascript, and .NET. Used Ajax, email, and eStore technologies. Support over 100 web applications. Wrote the data layer in T-SQL in SQL Server 2000 and 2005. Researched and presented marketing tools and concepts for email, and sales pipeline. Introduced and wrote development standards for ASP and T-SQL.

  • Consultant (Northshore)

    CHS, inc (Formally Cenex)

    (Public Company; 1001-5000 employees; Logistics and Supply Chain industry)

    August 2006 — May 2007 (10 months)

    * Role: Application Support & Enhancements (wrote fixes for bugs, and developed enhancements to the existing web sites, managed up to 30 bugs and enhancements at one time)

    * Marketing: B2B Online Contract Management, CRM, Cross-Selling, Leads Management.

    * Accomplishments: Supported and fixed a number of bugs and data issues between JD Edwards One World, SQL Server, and customer data interfaces for 5 different enterprise websites.

    * Data: ERP, CRM, and online contracts, manifest, and ordering of fuel. Daily live transactions.

    * Technologies: C#.NET, SQL Server 2000, DTS, SQL Analysis Services, Classic ASP, and interfaced with JDE OneWorld,

    * Industry: Energy, and Logistics.

    * Details: Supported and developed a customer interaction system for ordering fuel shipments. Most of the development was in Classic ASP and T-SQL. Interfaced a lot with JDE OneWorld ERP system.

  • Consultant (Robert Half Technology)

    Adolfson & Peterson Construction

    (Privately Held; 201-500 employees; Construction industry)

    July 2006 — August 2006 (2 months)

    * Role: Database Programmer (improved the SQL and developed solutions to complex problems to be used by their reports)

    * Marketing: Developed Project Estimating Tools

    * Accomplishments: Audited and rewrote SQL scripts to run faster.

    * Data: Accounting and Estimating Databases.

    * Technologies: SQL Server 2000 & 2005, & SQL Reporting Services

    * Industry: Construction, and Project Management.

    * Details: Developed T-SQL solutions for complex data reporting across SQL Server 2000 and 2005 servers.

  • Consultant (CDI)

    Wells Fargo Bank

    (Public Company; 10,001 or more employees; WFC; Banking industry)

    June 2005 — July 2006 (1 year 2 months)

    * Role: Quality Assurance (Tested new changes before role out, and debugged production problems)

    * Marketing: Product Development.

    * Accomplishments: I was the go to person for both the developers and the business to address data issues and bugs.

    * Data: Live and test banking data from ATM Terminals, Internet, Phone Bank, Teller Terminals, and the Safe being posted to up to 40 different systems with over 7000 transactions a minute.

    * Technologies: SOAP/WSDL, WebSphere, z/Linux, and Eclipse.

    * Industry: Finance, and Banking.

    * Details: Tested, tracked, and reported on the quality of the banking interface systems including: web, ATM, phone, safe, and teller terminals. Reviewed SOAP XML input and output to validate each test case, or to debugged real banking problems.

  • Consultant (Robert Half Technology)

    Mindware Toys

    (Privately Held; 51-200 employees; Retail industry)

    February 2005 — June 2005 (5 months)

    * Role: Data Quality (Interfaced with an off-shore team and evaluated the usability of their data structure, identified problems and their source)

    * Marketing: Customer list management and cataloging.

    * Accomplishments: Wrote high quality SQL store procedures and functions to convert an abstract name field to business and personal entities and parse the person’s name while maintaining the relationship between the business and persons.

    * Data: Customer (1 million records) and Accounting databases, ERP systems (CatMan and Quark Corporate)

    * Technologies: SQL Server 2000, and DTS.

    * Industry: Catalog Marketing.

    * Details: Converted data from Universe database to SQL Server 2000. Wrote functions for breaking out business and personal names from one text field. Used T-SQL and DTS.

  • Consultant (Robert Half Technology)

    The Lacek Group

    (Privately Held; 51-200 employees; Marketing and Advertising industry)

    August 2004 — March 2005 (8 months)

    * Role: Data Quality (loaded weekly and monthly feeds, cleaned the data, wrote statistical solutions, and developed a batch process to examine the data and report problems)

    * Marketing: Loyalty Marketing, Database Marketing, and RFM.

    * Accomplishments: Wrote a data script to identify corporate accounts who were not taking advantage of their contracts with loyalty travel related companies.

    * Data: Data feeds from large corporate clients with up to 5 million records.

    * Technologies: VBScript, VBA, SQL Server 2000, Windows Host Scripts, and Pivot Tables.

    * Industry: Loyalty Marketing.

    * Details: Developed T-SQL, DTS packages, and VBScript to collect data from customer ftp sites, quality check, load into database, and develop reports.

  • Consultant (Technisource)

    Wells Fargo Home Mortgage

    (Public Company; 10,001 or more employees; WFC; Financial Services industry)

    May 2004 — June 2004 (2 months)

    * Role: Quality Assurance (wrote test plan)

    * Accomplishments: Delivered a QA guide for keeping a very fast pace application on track while minimizing bugs.

    * Data: CRM

    * Technologies: SQL Server 2000, and JSP.

    * Industry: Finance, and Mortgage.

  • Consultant

    GMAC-RFC

    (Public Company; 10,001 or more employees; GM; Financial Services industry)

    October 2003 — April 2004 (7 months)

    * Role: Data/Financial Analyst (evaluated the financial risk, ranges, and potential profits of remodeling dis-repair homes)

    * Marketing: Market Analysis of purchasing and selling dis-repaired homes.

    * Accomplishments: Presented the financial formula for deciding to purchase a dis-repaired home and how much profit could be made on it.

    * Data: Collect data from a number of structured and unstructured sources and dynamically adapted the structure in the database using DDL SQL.

    * Technologies: VBA, Transact SQL, DDL SQL, Pivot Tables, and MS-Access

    * Industry: Finance, and Mortgage.

  • Consultant

    Pioneer Press

    (Information Technology and Services industry)

    2003 — 2003 (less than a year)

  • Consultant (Technisource)

    Wells Fargo Home Mortgage

    (Public Company; 10,001 or more employees; WFC; Financial Services industry)

    September 2002 — September 2003 (1 year 1 month)

    * Role: Database Programmer

    * Marketing: Reporting on the sales closing process.

    * Accomplishments: Wrote the SQL for calculating fines and refunds for improper mortgages paperwork for 40 million mortgages. Processed $20 million dollars a day in fines. Had less than 24 hours to correct any calculation errors.

    * Data: Over 40 million mortgage application data warehouse records.

    * Technologies: VBA, Business Objects, and Sybase.

    * Industry: Finance, and Mortgage.

  • Database Developer

    Nextel Partners

    (Information Technology and Services industry)

    2001 — 2002 (1 year )

  • Consultant (Independent)

    Ramsey County

    (Government Agency; 501-1000 employees; Government Administration industry)

    October 2001 — March 2002 (6 months)

    * Role: Database Programmer & Analysis

    * Marketing: Developed a data source product for real estate entities to download property records.

    * Accomplishments: Wrote a model website and SQL interface to DB/2 and passed the I.T. test for security and load.

    * Data: Over 10 million property records

    * Technologies: ASP, VBScript, JavaScript, and DB2

    * Industry: Properties and Mortgage.

  • Senior Programmer/Consultant

    Northwest Airlines

    (Public Company; Information Technology and Services industry)

    1988 — 1997 (9 years )

Hugh Plappert’s Education

  • Apostolic Bible Institute

    1982 — 1985

Additional Information

Hugh Plappert’s Websites:

Hugh Plappert’s Interests:

American, Technology, and Business History

Hugh Plappert’s Groups:

UPCI

  •    ASTD National
  •    Northwest Airlines

Hugh Plappert’s Honors:

Hugh Plappert started his IT career in High School by training his teachers on the school's first computers in 1980. His commercial career spans over 24 years with many Fortune 500 companies.

He specializes in marketing database applications and projects. He has saved one corporation over $40 million a year and completed the project in 40 hours. Most of his hourly consulting assignments are completed in less than 1/6 of the allocated time.

He has worked with both large (over 40 million records) and small systems. Four systems built by Hugh Plappert have been in production 12 years without any changes or upgrades.

He was featured as an exemplary consultant in a RobertHalf Technology newsletter in 2005. He was recognized as the Consultant of the Year in 2003 by Technisource. He received 2nd place in the nation for the best Paradox database training curriculum.

Hugh Plappert’s Contact Settings

Interested In:

  • career opportunities
  • consulting offers
  • reference requests
  • getting back in touch

View Full Profile

Public profile powered by: LinkedIn

Create a public profile: Sign In or Join Now

View Hugh Plappert’s full profile:

  • See who you and Hugh Plappert know in common
  • Get introduced to Hugh Plappert
  • Contact Hugh Plappert directly

View Full Profile