Bradley Dawson
**** ******* ******* #***, *******, TX 77077 Home: 832-***-**** Cell: 832-***-****
ac4h7b@r.postjobfree.com
Excel Expert
A knowledgeable and solution-focused Professional seeking a challenging position with an innovative organization to apply my diverse skill set and continue to learn and grow. Possesses a solid command of technologies, tools and best practices. Valuable team member with the ability to work closely with team members to achieve diverse goals.
Safety, 1st Aid, CPR
Pivot Tables & Charts
Charts
Dropdown lists
MS Access
Advanced Formulas
Power Pivot
Visual Basic Macros
Dashboards
MS Word
Data Analysis
Power Query
Conditional Formatting
Array Formulas
PowerPoint
Experience
Various short-term freelance contracts February 2017 - Present
WALKER ENGINEERING/RANDSTAD, Houston, TX
BIM Coordinator (contract), August – November 2016
Create electrical shop drawings for field installation
Update drawings to reflect changes made during field installation
Notable Accomplishments:
Created a program to read 3D object info into Excel. There it was organized and assigned ID numbers. Another program inserted blocks using this list, identifying size and elevation.
WAUKESHA PEARCE INDUSTRIES, Houston, TX
Generator Application Engineer, December 2013 – February 2016
Applied knowledge and expertise in preparing proposals for natural gas powered generators.
Used spreadsheets for estimating projects
Prepare BOM’s and do calculations using spreadsheets.
Create and prepare Excel parts lists for import into new JD Edwards Enterprise One ERP system.
ROBERT HALF TECHNOLOGY, Houston, TX
CAD Specialist/Logistics Analyst Contractor, January – September 2013
Used spreadsheets for:
Center of gravity and counterweighting calculations.
Proper railcar selection based on dimensions and carrying capacity.
Welding design for load securement to railcar.
A1 PERSONNEL, Houston, TX
Programming Contractor, Feb – Aug 2012 (temp)
Visual Basic programming of Excel Applications for the City of Houston.
Develop an Emergency Preparedness Disaster Risk Assessment Tool in Excel
Extend and advance functionality to include automatic data extraction from surveys, data sorting and easy printing of charts.
MBCI, Houston, TX
Production Engineer/Programmer, Feb 2006 – Sep 2011
Led in designing sheet metal roofs, siding and foundational structure.
Composed and managed program databases for engineering, estimating, and drafting departments.
Rewrote a program and revised the output from a non-editable printout to Word format to ensure greater flexibility in the final report.
Wrote a program that served as an efficient product cost estimating tool, which was distributed to estimating department, sales representatives, and customers.
Other Professional Experience:
AEP-SPAN
Production Engineer, Feb 1999 – Feb 2006
Used Excel for wind load calculations
Engineered Commercial Concepts
HVAC Application Engineer, Dec 1996 -Jan 1999
Created spreadsheet applications to perform heating and cooling calculations and size electronic components and motors for units.
Turner Engineering
Electrical Engineer, Jun – Nov 1996
Used Excel to create panel schedules and calculate wire and conduit sizing
Eisenbeck Engineering
MEP Engineer, Dec 1995 – Jun 1996
Used Excel to create panel schedules and calculate wire and conduit sizing
Education
Bachelor of Science, Mechanical Engineering
The University of Texas at Austin – Austin, TX