Eric Lahr
Corvallis,OR
Summary
Information technology professional with strong background in system analysis and optimization. Known for driving improvements in system performance and process efficiency. Team-oriented with focus on achieving results and adapting to changing needs. Skilled in data analysis, systems integration, and problem-solving.
Overview
25
25
years of professional experience
6
6
Certification
Work History
AWS Senior Data Engineer Customer Insight & Analytics
Travelers
11.2020 - Current
- Continuing focus on large scale corporate initiative to give employees immediate, relevant customer information.
- Engineered projects to pull data through API or data stream from third party agents such as Qualtrics, Telium, and Maxymiser using Python, Terraform, Snowflake, SQL, Javascript, AWS Services and more.
- Participated in agile ceremonies, daily stand-ups, sprint planning and story refinement.
- Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
- Experience with Agile (Rally and Jira), Oracle SQL Developer, Snowflake and Snowpipe, Databricks, DBT, Pipelines (Jenkins and GitHub Actions), GitHub, Docker, AWS Services (s3, Glue, Lambda, KFH, Step Functions, RDS, DynamoDB, Athena, CloudWatch, VPC, SecretsManager, IAM, SNS, EventBridge), API, Postman, Confluence Documentation
- Ability to quickly incorporate new technology through documentation research.
Senior Operations Administrator, Technology/Operations Analyst 5
Kroger
07.2014 - 11.2020
- Commissioned to develop numerous applications, programs, systems, displays, and electronic forms to provide tools and information for warehouse staff and management.
- Employed a number of scripting and database tools as well as Python, Django, Bootstrap, and Javascript to achieve this objective.
- Upon request, developed a web-based equipment checkout application for the warehouse. It provides current location and status of equipment, reports on maintenance and maintenance history, and features pictures and checkout history of associates and assets. Designed the PostgreSQL database, and wrote over 1000 lines of Python, HTML, and CSS code. Configured Nginx and Gunicorn to serve the application. System is still in use years later, has expanded to other locations, and was chosen over a corporate alternative as the default app of this type.
- Responsible for training and coordinating a team of support technicians. Assigns and mentors projects as needed.
- Complete Full Stack creation of a warehouse intranet featuring applications and displays hosted on a physical linux server under my own supervision and initiative. This gives management a true, real-time view of warehouse activity and led to changes that improved efficiency and output greatly.
- Experience with Linux and Microsoft server and client OS, VMWare virtual server administration, Microsoft SQL Management Studio, SSIS and SSRS.
- Created several AutoIT, VB, Batch, Python, Perl, and PowerShell scripts to automate recurring processes.
- Full System Administrator responsibilities including server installation and maintenance, anti-virus patching, and monthly update cycle.
- Managed numerous software and hardware projects including scope definition, schedule and work assignments, risk identification, and working with stake holders.
- Outstanding member of core team that replaced every network component and cable in Warehouse Fulfillment Center. Upgraded from HP ProCurve to Cisco.
- Updated Domain Controllers from Microsoft Windows Server 2008 R2 to Server 2012 R2.
- Created entire backup system from scratch including installing tape drive, server, and applications. Devised and implemented backup strategy.
- Led a large scale security project to bring warehouse within PCI compliance. Works diligently to maintain compliance through monthly scans and meetings.
Automation Specialist
Southern Nevada Health District
09.2008 - 05.2014
- Constructed a SQL database of more than 1,000 network devices.
- Built queries for this database using 3rd party software.
- Created custom SQL queries for this software and used both custom and out of the box queries to manipulate data and build complex reports into a clear, concise format and presented these reports to administration giving a true picture of the IT footprint for the first time.
- Saved countless labor hours by creating a library of complex software installations.
- Packaged software into workable, background, or user-friendly installation routines and installers capable of being distributed to all devices and platforms using Windows Scripting Language, VB Script, AutoIT, batch scripting, MSI, SMS and other technology.
- Achieved full software license compliance and saved money for the Health District by amassing a thorough software inventory, comparing it with purchase records, and working with vendors.
- Presented and recommended cost-saving software alternatives to Administration.
- Maintained, debugged and optimized automation programs.
- Tested, automated and whitelisted software to be used in secure environments.
- Worked with IT Trainer to develop user curriculum.
- Demonstrated confidentiality adhering to HIPAA standards.
Education
BSIT -
University of Phoenix
Las Vegas, NV11.2001
Associates degree - Computer Networking and Systems Technology
ITT Technical Institute
Las Vegas, NV05.1999
Skills
- Business process improvement
- IT asset management
- Reporting skills
- Troubleshooting skills
Certification
- Modern Javascript, Udemy, Nov 2019. Credential ID UC-LD5U45AI
- Complete Python Bootcamp, Udemy, Nov 2017.
- MCSA - Microsoft Certified Solutions Associate, Microsoft Issued Apr 2012. Credential ID D719-3171
- MSITPRO - Server Administrator (Windows 2008 Server), Microsoft Issued Feb 2010. Credential ID C729-5160
- MCSA - Microsoft Certified Systems Administrator (Windows 2000), Microsoft Issued Aug 2002
- MCSE - Microsoft Certified Systems Engineer (Windows 2000), Microsoft Issued Aug 2002
Timeline
AWS Senior Data Engineer Customer Insight & Analytics
Travelers
11.2020 - Current
Senior Operations Administrator, Technology/Operations Analyst 5
Kroger
07.2014 - 11.2020
Automation Specialist
Southern Nevada Health District
09.2008 - 05.2014
BSIT -
University of Phoenix
Associates degree - Computer Networking and Systems Technology
ITT Technical Institute
Similar Profiles
Patricia LeMondPatricia LeMond
Unit Manager at TravelersUnit Manager at Travelers
RAYMOND R. CLARKE, JR.RAYMOND R. CLARKE, JR.
Director, Agile Product Owner at TRAVELERSDirector, Agile Product Owner at TRAVELERS
Shaun ReillyShaun Reilly
Auto Liability Unit Manager at TravelersAuto Liability Unit Manager at Travelers