Ben Lopez

Ben Lopez

Senior Database Developer · Crocs

Denver, Colorado, CO

In My Own Words

Experienced Database Developer with a demonstrated history of working in multiple industries. Skilled in Trend Analysis, Visual Basic, E-commerce, Databases, and Active Directory. Strong information technology professional with a Computer Information Systems focused in Data Management from Colorado Technical University.

Work Experience

Database Developer/Engineer

Crocs

2016 – Present

• Worked with VP of Global Enterprise Applications on designing database to report royalty sales • Created views, stored procedures, triggers and queries to apply business rules to large sets of data • Created and documented all ETL and standard operating procedures pertaining to royalty database • Designed and implemented automated reports (i.e. royalty sales by licensor, financial consolidation comparison) that read appropriate SQL tables to pull latest pertinent data and present it in an accessible, easy to read way • Designed and implemented templates in Excel (i.e. add new SKUs, load FX rates) that allowed users to add data directly to the database • Created and scheduled ad hoc reports to automatically run in SAP Business Objects Web Intelligence • Created SSIS packages to automatically load data from disparate sources into SQL Server

Database Developer/Engineer

Data Headway, LLC

2014 – Present

Senior Database Developer/Engineer

TELUS Digital

2024 – 2025

• Optimized complex reporting queries • Mapped business processes and effectively delivered information via ad-hoc reports, dashboards, and data visualizations • Created Python scripts to automate time-consuming, manual data processes • Served as reporting expert and authority on problem queries

Senior Database Developer/Engineer

Aspira

2022 – 2024

• Designed databases to store important information regarding contact center information • Designed and implemented automated reports to track contact center KPIs such as average speed of answer, contact time, abandoned calls, etc. • Created and scheduled reports to be emailed automatically using Microsoft Access and VBA • Created SSIS packages to automatically load data from disparate sources into SQL Server

Database Developer/Engineer

Xcel Energy

2017 – 2023

• Designed databases to store important information regarding materials, employee time and substation construction projects • Designed and implemented automated reports to track materials and projects and tally employee time • Created and scheduled reports to be emailed automatically using Microsoft Access and VBA • Created SSIS packages to automatically load data from disparate sources into SQL Server

Database Developer

Envision Technology Partners, Inc.

2020 – 2022

• Created database objects (queries, views, procedures, etc.) to extract requested data on an ad-hoc and/or scheduled basis • Mapped data elements between end user application and database • Used SQL Profiler to optimize long-running queries and poorly performing database objects (triggers, procedures, functions, etc.) • Used Git/TFS to handle code review, collaboration, and version control

Database Developer

Kaiser Permanente

2016 – 2016

• Optimized several existing reports for faster, more efficient processing • Created batch files to organize and archive aging reports to optimize search time • Debugged and re-wrote VBA code to optimize reporting • Created and scheduled ad hoc reports to automatically run in SAP Business Objects XI

IT Manager/Database Developer

Madhava Foods

2014 – 2016

• Saved $40,000 per year in expenses by taking on role of IT Manager and supporting 40-50 user environment and firing outside IT consulting firm. • Designed and implemented various automated reports (i.e. weekly sales reports, leadership dashboard) that read appropriate SQL tables to pull latest pertinent data and present it in an accessible, easy to read way. • Stood up and administered stand-alone SQL Server 2014 instance to facilitate passing queries between automated Excel reports and Plex cloud-based databases. • Expanded VBA/SQL knowledge in order to further automate Excel reports and save the company money by not hiring independent specialist. • Created ad-hoc reports in Excel utilized by multiple departments.

IT Manager

ReadyCare Industries

2012 – 2014

• Saved $30,000 per year in productivity by initiating, designing and implementing a quoting tool using Excel, resulting in more efficient quoting and less required labor. • Designed and implemented an automated customer order form that read appropriate SQL tables to pull latest customer order info which has saved countless hours in required labor. • Designed and implemented tool to import purchase orders into database and saved countless hours in required labor. • Created and optimized stored procedures as part of a UPS ShipExec software implementation.

Data Entry

Pendum LLC

2010 – 2013

• Billing System Reconciliation • Work Order Management/Allocation • SOP Creation/Analysis • Integral resource on uploading data into MS Great Plains • Assisted with data conversion from OSI/ResQ to MS Great Plains • Designed and built dynamic spreadsheets utilized by Billing department • Ran mass update/delete/change statements • Remote resource • Took to heart the benefits of clear and concise communication with all team resources at all times

Purchase Order Manager

Skateamerica.com

2008 – 2010

• Purchase Order Review/Submission • Customer Order Allocation • Assistant Buyer • Assisted with data conversion from StoneEdge Order Manager to MS Great Plains • Designed and built dynamic spreadsheets utilized by Purchasing department • Limited resources within this small organization demanded excellent communication and organization

Education

Bachelor's degree

Colorado Technical University

2014 – 2018

Colorado Technical University

2014 – 2018

Interests

ChessReadingSkateboardingMotorcyclesbicycles

Skills

SQLExcelAccessVBASSISPython

Industries

LifestyleSkateSnowSurfBikeGolfDiveCreative AgenciesFashionFishingMoto & PowersportsMusicOutdoorRunStreetwearSwimTechTriathlonWakeYogaHealth & FitnessOther