Learn Data Skills
Beta
Alan Eisenhour

Alan Eisenhour

Data Analytics Engineer

Seeking new opportunities | Austin, Texas Metropolitan Area

Technologies

My Portfolio Highlights

My New Course

Data Manipulation in SQL

My New Track

Python Programmer

My New Course

Analyzing Data in Tableau

Data gardener, nurturing insights to bloom and thrive in the data ecosystem.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to R

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Enverus | Sep 2019 - Feb 2023

Data Engineer | Data Delivery

Developed data pipelines and managed entitlements for multiple database platforms to support the integration of RS Energy Group's Prism data lake with Enverus' data delivery models. • 2-time “Team of the Quarter” winner for expediting data delivery of Integrity and HPDI data pipelines to Amazon Aurora PostgreSQL, SQL Server and Snowflake databases. • Achieved 95% on-time, weekly delivery of Public Petroleum Data Model (PPDM) and successfully migrated two Oracle database models for customer EOG Resources. Skills: Amazon Web Services (AWS), Amazon Athena, PostgreSQL, Snowflake, SQL Server, SQL Server Management Studio (SSMS), Spark SQL, DBeaver, JIRA, Confluence, GIt
Show More

Drillinginfo | Aug 2017 - Sep 2019

Data Engineer | DI Analytics | DS9 Team

Managed the monthly data manufacturing updates for several DrillingInfo (DI) Analytics’ TIBCO Spotfire applications. Updated ETL processes for a new company-wide data warehouse (DS9). • Automated and parameterized SSIS environment variables with JSON config files for Wellbore Spacing R-scripts resulting in 60% reduction in cycle-time. • Collaborated with Product team, Engineering, DBA’s and IT through several SQL Server upgrades and a data center migration while ensuring customer data availability. • Developed string-matching logic for over 4 million Permit records with 95% confidence-level. Skills: Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Microsoft Visual Studio, TIBCO Spotfire, JIRA, Confluence

Freelance Consulting | Oct 2015 - Aug 2017

BI Data Analyst | SQL Reporting Developer | Data Science Student

Provide freelance consulting in organizing operational expenses into a database and creating reporting for a security monitoring company; studying new Data Science subject matter through coursework in Python, R, and visualizations in Tableau. Skills: Microsoft SQL Server, Microsoft Excel, Python (Programming Language), R (Programming Language), Tableau

Dell Inc. | Sep 2012 - Oct 2015

Metrics & Reporting Consultant | Dell Software Group Marketing

Drove demand generation for Dell’s largest acquisition at the time (Quest) within the Dell Software Group. • Derived 25K global sales leads by data mining Salesforce contacts and vetting regional “Do Not Call” policies. • Achieved 40% reduction of manual exceptions for sales contest payouts through database redesign and SQL logic therein, as well as training 15 sales liaisons in 20 different countries regarding contest eligibility rules. • Aligned sales channel hierarchy for 7+ million global account party sites to coincide with actual/forecasted sales volumes and pipelines; identified opportunity for creating reporting consistency. Skills: Relational Database Design, Data Analysis, Microsoft SQL Server, SSMS, SSIS, DTS, ETL Processes, SSAS, OLAP, Data Warehousing, Teradata, Salesforce, Microsoft Excel, PowerPoint, SharePoint, VBA

Dell Inc. | Mar 2008 - Sep 2012

Business Analysis Consultant | Global Audit and Transformation

Transformed Dell’s data infrastructure and business model into a total solutions provider through multiple Software and Services mergers and acquisitions. • Conceptualized, developed and integrated new Enterprise Business Intelligence data warehouse that adheres to global standard definitions/ processes. Oversaw Quality Assurance for implementation of the same with a special focus on Orders, Items, Financial RUM, and Customer. • Defined and delivered key stakeholder business requirements for the Mergers and Acquisitions dashboard and Customer Master Data Management projects. • Persuaded over 200 Finance, Sales, and Marketing Users to migrate from legacy reporting developed over the course of 8 years in prior role to the Worldwide Sales Transformation dashboard. Skills: Relational Database Design, Data Analysis, Business Process Improvement, Quality Assurance, Microsoft SQL Server, SSMS, SSIS, DTS, ETL Processes, SSAS, OLAP, Data Warehousing, Teradata, Oracle, Microsoft Excel, Microsoft Access, Microsoft Word, PowerPoint, VBA, Business Objects

Dell Inc. | Oct 2000 - Mar 2008

SQL Report Developer | Business Intelligence Data Consultant

Built all aspects of Finance and Sales Attainment reporting for the Americas Business Unit supporting Large Enterprise, Public, and Small Medium Business sales segments. • Saved hundreds of hours annually and significantly improved accuracy by delivering account-level purchase history to 80+ analysts through OLAP data cubes, enabling Quarterly Business Reviews, discounting analyses, and quota setting. • 80% reduction of more than 300 financial and sales reports by documenting key demographic and frequency foci for the Simplify Report Initiative. • Increased visibility of high-growth businesses through the integration of EMC and Software/Peripheral product hierarchies into the Dell Data Warehouse and creation of shadow P&L’s. • Reconstructed and redesigned ELT process for existing downstream pipeline reporting after migration of two in-house client-supported systems into Salesforce in less than two weeks. Skills: Relational Database Design, Data Analysis, Business Process Improvement, Microsoft SQL Server, SSMS, SSIS, DTS, ETL Processes, SSAS, OLAP, Data Warehousing, Teradata, Oracle, Salesforce, Microsoft Excel, Microsoft Access, Microsoft Word, PowerPoint, VBA, Business Objects

Dell Inc. | May 1996 - Oct 2000

Project Consultant | Worldwide Procurement and Cost Planning

N/A

My Education

Take a look at my formal education

Bachelor's of Science (BS) in Mathematics with a Statistics concentrationThe University of Texas at San Antonio | 1992

About Me

Alan Eisenhour

Alan hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free