Joe Lougee

Independant IT Consultant

Location
Portland, Maine Area
Industry
Information Technology and Services

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Joe Lougee know in common
  • Get introduced to Joe Lougee
  • Contact Joe Lougee directly

View Joe's full profile

Joe Lougee's Overview

Current
  • Independant IT Consultant at Self Employed
Past
  • Sr. Database Administrator and Systems Analyst at Nortech Systems
  • Systems Engineer at Infor
  • Systems Engineer at Lilly Software Associates
  • Systems Engineer - Sub-contractor at Rochester School Distrinct - Rochester, NH
  • Systems Technical Support at Lilly Software Associates
Connections

459 connections

Joe Lougee's Summary

Information Technology professional with strong background in Database Administration, Server Administration both Windows and Linux, Application Development and Database Schema Design(OLTP,OLAP,DSS). Kimball University Alumni, also aware of Inman and data-vault approaches.

Managed several RDBMS's and application installation, implementation, upgrade, conversion (between vendor boxed applications) and migration (between RDBMS) projects. Very approachable, effective communicator at all levels, dedicated to high quality solutions and results.

Specialties: Oracle (7-11g) and MS SQL Server (6.5-2012) schema development (normalized and demoralized solutions), SQL scripting focused in Oracle PL/SQL and MS SQL Server T-SQL but MySQL as well, process automation, and customer satisfaction.

Application programming experience in C# in VS2005-2012, Java, C++ with C++Builder, Delphi (object Pascal), Visual Basic and VB.NET, and ASP.NET, ADO.NET. Capable of tracing many languages.

Seasoned scripting language experience in Windows Command Language, VBScript, JavaScript, AutoIT and Automate; currently learning PowerShell.

Joe Lougee's Experience

Independant IT Consultant

Self Employed

September 1998Present (16 years 1 month)

Numerous engagements and roles generally focused on data migration, conversion, consolidation, transformation/cleansing, technical project management, application development (web and form). Projects could be ERP implementations, or conversions between vendors, ETL/ELT, reporting, or application enhancements.

Clients are focused in manufacturing; data includes real time collection from floor processes, ERP, Financial, CRM, QC, EDI etc.

Data Services Manager

Diversified Communications HQ

Privately Held; 501-1000 employees; Media Production industry

December 2013May 2014 (6 months) Portland, Maine Area

In addition to duties and responsibilities as Database Developer / Administrator:
* Managed a full time staff of 3 - 4 employees and 2 contract resources.
* Hiring manager for Data Services Group.
* Conducted Daily Progress Meetings.
* Conducted monthly one-on-one's with staff.
* Consulted to impact of proposed enterprise solutions and enterprise data availability.
* Provided guidance and when necessary implementation of data solutions.

Database Developer / Administrator

Diversified Communications HQ

Privately Held; 501-1000 employees; Media Production industry

March 2010May 2014 (4 years 3 months) Portland, Maine Area

Focused on Administration and Development of Production, Staging, Test and Development Environments. Work ranges from monitoring, tuning and development of custom applications, and feature enhancements to boxed solutions. Also responsible for data migration and integration between many systems and formats.

Contributions include:
* architecture guidance and implementation of new ODS, MDM and BI structures
* application maintenance related to a database integrations and internal MDM implementation of data merge operations
* after consulting business, developed and implemented custom "golden record" logic to marketing database entities.
* migration of enterprise reports from a proprietary system to MS SSRS
* identification and remediation of report issues
* recommendation and where appropriate execution of data profiling and cleansing tasks
* design and experimentation of new marketing suppression database system
* data migration for new acquisitions
* ETL design, development, maintenance and troubleshooting of multiple external vendor integrations
* other process automation; including consistent database recovery in a multi-server, multi-instance, multi-database interconnected environment, issue notifications, mass record imports and modifications
* peer skill development and mentorship
* reverse engineer, and knowledge transfer of multiple LOB systems data structures
* architecture and tool recommendations

Generally focused on the MS Database and BI stack.
Also involved with migration, integration and a management of multiple databases on multiple MySQL instances on multiple Linux servers.

Solutions Data Architect II

Visual Business Solutions

Privately Held; 11-50 employees; Computer Software industry

May 2009March 2010 (11 months)

Primary functions are a continuation of the duties performed at Lilly Software Associates and Infor, only now at the channel partner level.

Those duties include: Technical project management aspects and custom development of customer implementation, migration and conversion projects to establish Infor VISUAL solutions at customer sites.

Additional duties where database, network, exchange and CRM administration for internal systems and coordination with external vendors.

Sr. Database Administrator and Systems Analyst

Nortech Systems

Public Company; 501-1000 employees; nsys; Electrical/Electronic Manufacturing industry

January 2006May 2009 (3 years 5 months)

Manage day to day database operations, user response time performance troubleshooting. Advise and architect new database queries (SQL), schema objects and database applications to support business need. Design, consult and implement ETL tasks. Design and execute database software and application upgrade projects. Architect and execute data scrubbing and rename operations. Involved in all database management, schema design, report generation, and in-house database application development to support business requirements.

Systems Engineer

Infor

Privately Held; 10,001+ employees; Computer Software industry

October 2004January 2006 (1 year 4 months)

Continuation of duties with Infor after acquisition of Lilly Software Associates, Inc.

Performed systems field service for Infor's ERP suite. Services included Relational Database Management Server installation, application database setup, Infor ERP software installation / upgrade, inter application communication and client configuration. Also performed application performance troubleshooting related to software response time over the network or with application SQL and the underlying Relational Database Management Server.

Systems Engineer

Lilly Software Associates

September 1999October 2004 (5 years 2 months)

Performed systems field service for LSA's ERP suite. Services included Relational Database Management Server installation, application database setup, LSA ERP software installation / upgrade, inter application communication and client configuration. Also performed application performance troubleshooting related to software response time over the network or with application SQL and the underlying Relational Database Management Server.

Systems Engineer - Sub-contractor

Rochester School Distrinct - Rochester, NH

September 1998June 2000 (1 year 10 months)

Configured and maintained school district computers consisting of over 600 workstations and 10 servers across 11 campus locations throughout the city; created web sites using HTML, ASP, VBScript and JavaScript to provide users with real-time interactive experience; developed application to allow system administrators to update network and security configuration and policies from one interface using Borland Delphi.

Maintained student privacy policies.

Systems Technical Support

Lilly Software Associates

July 1999September 1999 (3 months)

Phone and email support for systems infrastructure supporting the Lilly Software Associates ERP software suite. This included Windows Servers running Gupta SqlBase and Oracle Databases. Also assisted with Software installation, client or server reconfiguration, database backup and recovery scenarios and other tasks associated with the availability of the ERP software at customer sites.

Joe Lougee's Courses

  • Independent Coursework

    • Microsoft Data Warehouse in Depth

Joe Lougee's Skills & Expertise

  1. Microsoft SQL Server
  2. Databases
  3. SQL
  4. T-SQL
  5. Oracle
  6. Visual Basic
  7. JavaScript
  8. Technical Support
  9. Database Design
  10. ERP
  11. C#
  12. VB.NET
  13. Windows Server
  14. Visual Studio
  15. VBScript
  16. Integration
  17. PL/SQL
  18. Database Administration
  19. Delphi
  20. Process Automation
  21. ETL
  22. HTML
  23. Windows
  24. System Administration
  25. Troubleshooting
  26. Servers
  27. IIS
  28. Crystal Reports
  29. Software Development
  30. Visio
  31. XML
  32. .NET
  33. Requirements Analysis
  34. ASP
  35. ASP.NET
  36. Access
  37. Networking
  38. SharePoint
  39. Software Project Management
  40. SSIS
  41. Operating Systems
  42. Business Analysis
  43. Business Intelligence
  44. Web Applications
  45. Web Services
  46. Data Warehousing
  47. Systems Analysis
  48. SQL Tuning
  49. SSRS

View All (49) Skills View Fewer Skills

Contact Joe for:

  • career opportunities
  • consulting offers
  • new ventures
  • job inquiries
  • expertise requests
  • business deals
  • reference requests
  • getting back in touch

View Joe Lougee’s full profile to...

  • See who you and Joe Lougee know in common
  • Get introduced to Joe Lougee
  • Contact Joe Lougee directly

View Joe's full profile

Not the Joe Lougee you were looking for? View more »

Viewers of this profile also viewed...