Louis Hemmi

Experience

• 

  Coastal Oil and Gas

  Jan 1984 - Jan 1987

  E&P Systems Coordinator

  Act as Project Manager, coordinating IT and Accounting. Report development on the mainframe (Easytrieve+). dBase II, Lotus 1-2-3, CPA

• 

  FERA Corporation

  Aug 1994 - Aug 1996

  Programmer/Analyst

  FERA is a consulting engineering company providing data acquisition and data management software, close-interval survey and other cathodic protection surveys, and CP testing hardware including data collectors and GPS-synchronized interrupters. I managed field projects and field survey crews, as well as developing technical reports and internal R&D.

• 

  American Express

  Aug 1996 - Feb 2002

  Team Lead, Product Development & Support

  Built QA Test lab, team leader of group of 9 software testers on multiple platforms. Greatest job I ever had -- love testing and coaching others.

• 

  USA Self Employed

  Feb 2002 - Feb 2007

  Principal

  After leaving American Express in the wake of 911 economy, worked freelance on hourly basis for many clients, and even got licensed to do Real Estate Appraisals. Even now, I still do a lot of work for the appraisers I've known and worked with. However, I love working with technology instead.Texas Certified Residential Appraiser - license# 1337310 (active and current)

• 

  Crossland Acquisition, Inc.

  Feb 2007 - Feb 2008

  Database Specialist

  Great job and people. Was supposed to be six month contract, but extended to a year before funding cut by Texas Department of Transportation.Crossland is the leading provider of Right of Way acquisitions in the state of Texas.

• 

  Dresser-Rand

  Mar 2008 - Jul 2013

  Tech II - Process Innovation

  Field Service Application Development & Support • Develop and support complex Access/Excel applications including a (1) field labor timesheet application, (2) job quote, estimate and project-tracking template, and (3) VB, MS Word command button/menu to allow access to product documentation in the field• Designed, implemented and support numerous Access and Excel applications, web pages for Field Service and Field Operations, including Formula One, Training, Global Technical Services, Strategic Measures, and Project Managers' pages on D-R Net .ASP.NET. • Effectively used MS Access, Excel VBA to collect labor hours, estimate project costs and sales, manage shop inventory, tool-container and truck inventories. • Administer a SharePoint site for global labor rates (Field Service), responsible for consolidating worldwide rates, categorizing as to Country, region, branches.• Global KPI data collection using SQL Server and Visual Studio for VB.• Used Oracle DISCO to report Supply Chain Measures, exporting to Excel and Access for analysis in order to gauge Supplier Cycle Time, on time Delivery and other Key Performance Indicators such as client feedback, parts defect tracking, and Account Manager (Salesman) support.• Trained in "Lean Sigma."• Performed user training in MS Access and Oracle applications. • Authored technical documentation and training materials for many software tools.• Key developer in automating collection and reporting of KPI information ("Strategic Measures") using Oracle DISCO reporting, MS Access, Excel, and SQL Server using Visual Studio 2008, VB backend.• Database modifications to make the program more "data-driven".• Business tier modifications to reduce the amount of changes needed as additional KPIs and drilldown flows are added.• Online descriptions of the KPIs.• Constant support of Field Service resources in the field and in the office via phone and Web-Ex.• Recognition for outstanding user support Show less

• 

  Weatherford

  Jul 2013 - Feb 2014

  Special Projects Programmer / Analyst

  Hands on VBA, Showcase, MS SQL Server . Excel VBA Dashboards to summarize and report. MS Access, Sharepoint, and Excel Database for Aberdeen, Scotland location. Global reporting on Manufacturing Open Orders, and Inventory Exceptions Toolbox. MS SQL Server - table & index design in preparation for migrating from MS Excel, SQL scripts to stored procedures, database optimization.Part of mass layoff (7,000 employees) on February 24, 2014. I no longer work for Weatherford.

• 

  BP

  Jan 2014 - Mar 2016

  • Work with Cornerstone On Demand (talent & learning management system) used by 21 million worldwide. This work encompassed catalog & content management, email triggers based on learning events, and basis for consolidation and integration of data from disparate sources.• Develop Excel and MS Access applications to enhance Data Quality reporting by shining a spotlight on course redundancies (duplicate courses in different platforms), and adherence to data standards. Identification of duplicates has been a high-impact goal.• Analyze data quality with accuracy and efficiency, look for patterns in the data and seek to interpret results, prepare clear reports on data quality, and work with stakeholders to resolve issues. • I have been adaptable to changing situations and competing requests, and thinking creatively while maintaining focus on delivering tasks.• Developed model to analyze learning venues and their hierarchy• Continuous improvements to reporting, especially KPIs and depicting them in graphical format, using Excel PowerPivot and heavy use of slicers.• Used SQL Server to report on monthly training-catalog growth/shrinkage. Show less •Define and check adherence to learning data standards & policies; managing data quality integrity for all learning content within BPs Learning Management System (LMS) •report on data quality for key stakeholders, and work with stakeholders to resolve data quality issues •developing tools, processes and reports (e.g. data quality processes), and administering and maintaining these tools•analyze data quality with accuracy and efficiency, look for patterns in the data and seek to interpret results, prepare clear reports on data quality, and work effectively with stakeholders to resolve issues. Show less

  • Data Quality Analyst -GLMS (Global Learning Management Services)

    Apr 2014 - Mar 2016

  • Data Quality Analyst

    Jan 2014 - Jan 2016
• 

  Digital Imperatives Appraisals

  Jun 2016 - now

  Certified Residential Real Estate Appraiser

  After getting laid off by BP, I decided to take advantage of my license that I got back in 2007 as a Certified Residential Appraiser. My ability to work with large quantities of data, and experience with complex queries has enabled me to successfully write high quality appraisals, based on the best data that is relevant to each assignment. No two jobs are quite the same.I still do freelance web pages, WordPress, etc. and am exploring opportunities that can benefit from my experience.