Glenn Lehman

[email protected]

Objective

Recent college grad with a keen eye for detail and a passion for analytics, experienced in business and data analytics, ETL processes, data wrangling, project management, and documentation. Adept at ensuring data accuracy and integrity through meticulous review and validation. Proficient in critical thinking, problem-solving, and effective communication, with a solid foundation in mathematical analysis. Driven by an insatiable curiosity and a commitment to continuous learning, eager to leverage my expertise to enhance data management and documentation processes. Dedicated to continuous improvement, collaborative teamwork, and delivering exceptional results.

Professional Experience

Business/Data Analyst/Power BI

Laconia Housing and Redevelopment Authority (LHRA)
October 2023 – April 2024
  • Enhanced data integration and infrastructure using Power BI, importing and cleaning data from text files, and transforming the information for consumption via interactive dashboards.
  • Utilized advanced Excel functions such as Filter, VLookup, and XLookup to optimize spreadsheet formulas and ensure data accuracy.
  • Identified and corrected errors in undocumented Excel sheets caused by poor version control, improving overall data reliability.
  • Implemented SharePoint lists in small work group team sites to streamline data collection and enhance collaboration.

Data Analyst/Python Developer/Manager

Granite State Dispatch (DSP)/Amazon Logistics (AMZL)
October 2019 – October 2023
  • Automated the conversion of weekly driver scorecards from PDF to Google Sheets using Python, enhancing data accessibility and analysis.
  • Developed custom Google Sheets to calculate driver bonuses, improving accuracy and efficiency in compensation management.
  • Established a comprehensive process for vehicle assignment and driver tracking, optimizing resource allocation.
  • Designed a fleet maintenance tracking system model in SQLite to streamline maintenance schedules and record-keeping.
  • Implemented a user-friendly interface for data entry and retrieval.
  • Utilized SQL queries for data analysis and reporting.

Delivery Associate

Amazon DNH2
October 2019 – March 2020
  • Provided training for new drivers (ride along and software).
  • Worked in new areas to ensure correct geo pin settings.

Business Analyst

Lehman Group Inc
June 2007 – July 2019
  • Established strategic, technology, and operations goals.
  • Evaluated technology needs and solutions including hardware, network, VOIP and SaaS (Buildium, G Suites, MS Office including access, Slack, Asana, Zoom).
  • Implemented technology solutions.
  • Developed Google sheets as required for resource planning.
  • Implemented AODocs over Google Drive as a cloud-based document storage system.
  • Developed workflow control within Buildium.

Real Estate Investment Analyst/Agent

Century 21 At The Helm
May 2006 – November 2007
  • Determined investing goals (budget, ROI, loss-to-lease, cash-on-cash return, and more).
  • Formalized investment requirements.
  • Created Excel sheets for rapid investment evaluation.
  • Located investment properties meeting investment requirements.
  • Tracked real estate clients in access database.

Business Analyst/Document Reduction Specialist

Ajilon - PA Department of Transportation
March 2006 – June 2006
  • Analysis of system requirements.
  • Developed software specifications.

Data Architect/Data Governance

TEK Systems – Pa American Water
November 2005 – January 2006
  • Maintained Erwin repository of data models/data dictionary.
  • Mapped data conversion from AS-400 to MSSQL.

Data Conversion (Various to MSSQL)

Ajilon - Administrative Office of Pennsylvania Courts
July 2005 – November 2005
  • Analyzed existing county system map to the state system.
  • Met with stakeholders to determine current data usage/definitions.
  • Wrote SQL procedures to clean, shape, and import data.

Developer (VB)/Report Writer

Peak Solutions - Transcore – EZPass
January 2005 – July 2005
  • Developed reports from MS SQL with Crystal Reports.
  • Determined matrix for correct interstate distribution of funds.

Data Architect/Database Admin/VB/SQL Developer

TEK Systems - RR Donnelly - Financial Business Division
October 2003 – December 2004
  • System coding (VB).
  • SQL procedure development.
  • Maintained Erwin model repository/data dictionary.
  • Database tuning (Oracle – with DBA team).
  • Analyzed requirements to develop custom document management solution.
  • Data modeling.

Data Analyst/DBA/VB Developer (Contractor)

Target Systems - Merchant Express Money Order
May 2001 – October 2003
  • Designed and developed polling software for money order devices (Back end).
  • Maintained customer service database including research of lost payments (Access).
  • Developed software for auto auction sales lanes.
  • Developed software for chemical QA lab testing results.
  • Designed test procedures for software.
  • Documented code.
  • Produced user guides.

Software Development/Recruiter

US Navy – Career Recruiting Force/Submarine Service
October 1979 – June 2001
  • Installed CRM throughout New England.
  • Performed initial CRM system user training.
  • Analyzed marketing data to establish goals.
  • Created automated work procedure process (full-stack).
  • Created staffing projection software (full-stack).

Skills

  • Databases Used: Access, AS-400, MongoDB, MSSQL, MySQL, Oracle, PostgreSQL, SQLite
  • Data Skills: Python, R, SQL, Pandas, NumPy, Excel, Matplotlib, Seaborn, Power BI, Statistical Analysis, Machine Learning, Data Cleaning and Preparation
  • Tech Skills: JavaScript, HTML/CSS, SQL, Git, Docker, Linux, REST APIs, Cloud Computing, CI/CD
  • M365 Skills: Access, Excel, Teams, SharePoint, Lists, Power BI, Power Automate
  • Soft Skills: Communication, Teamwork, Problem-Solving, Time Management, Adaptability, Leadership, Critical Thinking

Education

Southern New Hampshire University

Bachelor of Science - Graduation: Dec 2024

Computer Science w/Focus on Data Analytics

Bachelor of Arts - Graduation: Dec 2024

Mathematics

Military Service

United States Navy

Recruiting
1992 - 1997
  • Conducted recruitment efforts, demonstrating strong interpersonal and communication skills.
  • Trained and mentored new recruits, fostering a positive and productive environment.
  • Analyzed recruitment data to improve strategies and outreach efforts.
Submarine Service
1979 – 1992
  • Served, demonstrating strong leadership, teamwork, and technical skills.
  • Gained valuable experience in high-pressure environments, contributing to mission success and operational efficiency.
  • Read blueprints and technical manuals to create procedures for the repair of nuclear submarines in planning and estimating, defining the requirements for entire projects.