HOME

LoeblCom Services has a broad array of experience which we can draw upon when we deal with your project! We know you will benefit from our experience from past projects and our problem solving skills. We will do our best to incorporate these ideas to make a better product for you our client.

You will benefit from saving money by our experience and save time. We have learned from our mistakes and know "the things to watch out for"!

We have done consulting work in the following industries:

Oil and Gas

Geokinetics

I developed a template using VBA code in Excel to put the various worksheets in an Excel "Fee Build Up" into an acceptable format for upload into an Oracle database system. I worked closely with the members of the Oracle team to develop this acceptable format. This "FBU" is used in various countries around the world. The "uploader" program is used to upload North American, Latin American, and Australian exploration projects into Oracle which allows for a better cost analysis to take place which in turn saves the company millions of dollars and makes them more competitive in their bidding processes.

Shell Oil & Gas

Summary: Designed several Access databases which produced analytical financial reports based on user selected criteria. The data from these databases was used to produced MS Excel charts or pivot tables, so the data could be more quickly analyzed. The quicker analysis led to better decisions being made and several million dollars will be saved both currently and into the future.

Another project that was designed was to decommission an older existing non-Access application. The data was exported to an Oracle database and I used an Access database which linked to this to produce several user defined reports which could be analyzed within the database or sent to MS Excel for a pivot table view. This led to data being more accessible and costly tax penalties will be avoided.

Citation Oil And Gas

Summary: LoeblCom Services provided advanced MS Excel training services to this company.

Electrical

CenterPoint Energy

Summary: Erik Loebl (EL) worked to build SQL Server applications and MS Access database applications. EL built in department data driven intranet site with SQL as the database and an internet site to accept contractor inspections. EL extracted data from an SAP system and produced analytical, intuitive reports for the managers that saved hundreds of thousands of dollars!

Reliant Energy

Summary: LoeblCom Services was responsible for performing data analysis, reporting and information management, as well as process improvement which resulted in big financial savings for this customer. The following list includes some of LoeblCom Services accomplishments:

A "Work Order Management Database System" was implemented. This is an Access database which uses data from SAP transactions to formulate "intelligent" reports. The reports share important awareness data with the employees to whom the work orders belong.

An "Equipment Management" database was implemented. This database uses data from SAP transactions to give "at a glance" insight to which equipment is in stock, on order, pending removal from the field, and pending on a current order. This report gives awareness to when a particular piece of material may become in short supply so proper preparations may be made to acquire more in a time conscience manner.

A contractor inspection website request form was implemented using ASP, HTML, and XML technologies as the front-end interface, and SQL Server on the back-end database. This website, located at http://www.centerpointenergy.com/inspection, allows contractors to make requests for inspections from their web browser. This enhances the inspection request process, normally handled by phone, by reducing errors due to incomplete or misunderstood information. Information is entered at the website portal, validated by the job number, then results are emailed and sent by pager to the respective employee handling the job.

The Major Underground Engineering Department intranet was implemented. ASP, HTML, CSS technologies were used. The purpose of this site is to centralize storage of PDF formatted work order reports and inventory reports, as well as to provide a point for departmental communication.

The BallPark Estimates database application (BallParkEstimates.mdb) which aids in accurately estimating customer jobs. This is an Access database and produces Excel reports.

2 Quattro Pro Applications to an MS Excel Format, the Motor Start Application and the Voltage Drop Application (VoltageDrop.xls).

A "Transformer Load Management Database System". This database holds Transformer load information compiled since March, 2001 to June 2007. The purpose of this database is to monitor the history of a transformer at certain GLNs and Work Centers. Excessive loading could cause problems for the customer. These problem areas are being notated in the database.

Many accounting reports were developed from MS Access queries using SAP data. These reports include among others, Plan vs. Actual Cost Reports, Cost Element reports, 5 year Moving Average reports, Material Usage reports. ASP.Net to build a web driven "Standard Requested Service Utility", to upgrade the MUDG Intranet from ASP. These access stored procedures.

VB.Net and SQL Server were used to build an Inspection Website, Relay Monitoring, which both have email capabilities, and Relay Monitoring which loops through hundreds of tables using a SQL query.

XML on the Inspection Website to validate Work Order numbers

Excel and Access VBA to manipulate data.

MS Access was used to build the MUDG Vehicles database, Storm Power Outage Tracking System, Cable Management Database, UDG_Events Database, MUDG Metrics Scorecard Database, MUDG_EmployeeSurvey Database, CellPhoneUsage Database, MUDG_Vehicles Database, MUDG_EmployeeSurvey Database, ReconcileWorkCenters Database, BallPark Estimates Application Database which produces an Excel report, DGN_Processor Database which reads picture files.

A software utility was built to extract Lotus Notes email populate a MS Access database table.

ASP, HTML, and CSS techologies were used to build and administer the SaltyDog Fishing tournament application. MS Excel was used to build the "Goals and Performance" Spreadsheet, Quattro Pro Motor Start program to Excel format. SAP was the primary source for all report data.

HVAC

 Aspen Manufacturing

Summary: EL used the VBA language to produce an MS Excel program which analyzes and merges 2 text files (both dealing with air conditioning information), perform various calculations, and produce an output in a usable format.

PS: We have been working with this customer for over 3 years!

Costruction

Associated General Contractors - (Houston Chapter)

Summary: LoeblCom Services designed an Access database which tracked current membership and the classes they attended, committees they served on, the dues they paid, events they were involved in, and other information relevant to each member.

Medical

 Texans Childrens Hospital

Summary: LoeblCom Services designed a MS Access database to track and record the amount of hours a physician worked at a specific clinic.

Electronic Computer Outlet Services (contract for doctor's office)

Summary: When a MS Access database becomes operationally slow or needs to be upgraded to MS SQL Server, LoeblCom Services has been involved with the upgrade. EL worked to upgrade a database holding doctor information from the Soapware software which used an MS Access backend to a MS SQL Server backend.

Financial/Banking

Bank of Texas

Summary: LoeblCom Services provided help troubleshooting an existing database.

Communications

 Cumulus Broadcasting-Houston Office

Summary: An Access database was built to manage communications information regarding agencies and advertisers.

Lawsuit Reform

 Texans For Lawsuit Reform

Summary: This database containing large amounts of membership data was already build. The data was queried to provide complex reports.

PS: This has been our repeat customer for over 10 years!

Real Estate

 The Gustafson Group

Summary: This database project was an upgrade a MS Access 95 application to MS Access 97 database then to MS Access 2000 then to a MS SQL Server with an Access 2000 project as the front end. The database contained real estate information, and was migrated by LoeblCom Services to a MS SQL Server database. EL created all the views, stored procedures and backup plan for the database. The tables were imported using SQL Server's DTS feature. The performance of the database was increased substancially and it can be accessed from the web.

PS: We have been working with this customer for over 6 years!

Education/Training

 Computer Technology Research Education Center

Summary: LoeblCom Services provided MS software applications, VBA, and VB training for this education company.

PR Media

 Media Candy PR

Summary: LoeblCom Services provided Access consultation for troubleshooting strategies with current database. Help required issues with joins and duplicated data on past imports, etc.

Painting

 R & M Service Company Inc.

Summary: LoeblCom Services provided Access consultation for paint bidding application. This was an Excel project dealing with usability (VBA code issues) when upgrading from a prior version of Excel.

Automotive

 Gulf States Toyota

Summary: LoeblCom Services provided Access consultation to provide enhancements and advice for a current database implementation. New enhancements sped up productivity over 60%.

and others...come back for more...

Websites Design And Implementation

 LoeblCom Services has designed and implemented the following websites:

http://www.loebl.com

http://www.dietsolutionprogramreview.com

http://www.potenthealthsupplements.com

http://www.miracleshappentoday.com

http://www.podcastpreacher.org

http://www.saltydog.info

http://www.iglesiacristianashekinah.org

http://www.alightinthemidstofdarkness.com

http://www.shadowoakspool.org

Click on the other links to find out more information or, Click here for a Project Request Form to procure LoeblCom Services for your next project.

Thank you for your interest!

Erik Loebl MCSD, MCT, A+
(713) 409-7041 Houston, Texas
erik [at] loebl [dot] com