Paden Allen
Senior Consultant at North Rock Consulting- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
North Rock Consulting
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Senior Consultant
-
May 2023 - Present
-
-
-
TC Energy
-
Canada
-
Oil and Gas
-
700 & Above Employee
-
Application & Automation Developer
-
Mar 2021 - Mar 2023
JOB RESPONSIBILITIES: Develop Power Apps for US Gas Projects (USGP) Automate reporting and build dashboards using Power Bi Streamline repetitive or manual tasks utilizing Power Automate Environment Owner and Release Engineer for USGP non-prod, prod environments MAJOR PROJECTS: Material Procurement (Power Apps, Power Automate) - Ongoing • Automates creation of purchase requisitions from service provider’s bill of materials (BOM) • Utilizes artificial intelligence to match BOM to internal material master list (SAP) • Power App tracks status of receiving BOM, finding SAP match, requesting quotes from suppliers, comparing quotes, accepting quotes, and submitting purchase requisitions • Estimated cost savings of $9 million/year USGP Benchmarks (Power Apps) • Standardizes data collection and analyzes year-over-year project cost factors from 3,396 projects to predict estimates for future projects • 307 internal users and over $1.9 billion worth of project data inputted • Creates Class 5 estimates (+/- 25%) in seconds rather than a week USGP Contractor Bot (Power Apps, Power Automate, Power Bi) • Automates collection of project safety data from external contractors • 61 internal users who oversee 472 external contractor users • Eliminates manual data entry, saving 960 hours and $100,000 per year • Consolidates and captures contractor submissions from a single email • Analyzes monthly data trends and monitors contractor response rates USGP Project Deliverables Tracker (Power Apps) • Monitors up to 309 project deliverables throughout the lifecycle of the project • Tracks project phase approvals, providing accountability for missing deliverables • Accounts for project variability and allows for customizable deliverable packages per project Engineering Project Tracker (Power Automate, SharePoint) • Documents project engineering notes, estimates, and concerns • Utilizes SharePoint Web APIs to automate 60% of required manual entry columns Show less
-
-
-
Grant Prideco™
-
Oil and Gas
-
100 - 200 Employee
-
Texas A&M University Capstone Project
-
Jan 2020 - May 2020
• Automated drill pipe test reports using User-Centered Design approach in Publisher • Resulted in 63% less errors, 80% increase in user satisfaction, 33% reduction in task time • Automated drill pipe test reports using User-Centered Design approach in Publisher • Resulted in 63% less errors, 80% increase in user satisfaction, 33% reduction in task time
-
-
-
TC Energy
-
Canada
-
Oil and Gas
-
700 & Above Employee
-
Measurement Engineering Intern
-
May 2019 - Aug 2019
• Developed webpages to display current measurements of analyzers for 90% of meter stations using CSS, HTML, and JavaScript • Pioneered pipeline liquid accumulation tracking tool to monitor past, present, and predict future trends for 50,000 miles of pipelines in Power Bi • Standardized reporting site issues, repairs, and upgrades in order to accurately appraise cost of projects in Excel • Managed presentation to Board of Directors on power of 4D Construction/Inspection Tool • Developed webpages to display current measurements of analyzers for 90% of meter stations using CSS, HTML, and JavaScript • Pioneered pipeline liquid accumulation tracking tool to monitor past, present, and predict future trends for 50,000 miles of pipelines in Power Bi • Standardized reporting site issues, repairs, and upgrades in order to accurately appraise cost of projects in Excel • Managed presentation to Board of Directors on power of 4D Construction/Inspection Tool
-
-
-
TC Energy
-
Canada
-
Oil and Gas
-
700 & Above Employee
-
Measurement Engineering Intern
-
May 2018 - Aug 2018
• Reduced by 99%, time needed to create remote station data sheets using VBA • Presented to Board of Directors on impact of Hurricane Harvey upon Houston Children’s Museum, resulting in thousands of dollars in donations to museum • Reduced by 99%, time needed to create remote station data sheets using VBA • Presented to Board of Directors on impact of Hurricane Harvey upon Houston Children’s Museum, resulting in thousands of dollars in donations to museum
-
-
-
City of Sugar Land, TX
-
United States
-
Government Administration
-
300 - 400 Employee
-
Engineering Intern
-
May 2017 - Aug 2017
• Collaborated with Senior Engineering Manager to improve City’s Flood Early Warning Systems • Illustrated need to update all 16 existing flood gauges and add 12 additional gauges by mapping out flood data in Bluebeam Revu • Prepared documents for City Council, outlining current issues with alerting citizens of imminent flooding threats • Resulted in City Council’s approval for $200,000 FEMA grant to update flood/rain gauges • Collaborated with Senior Engineering Manager to improve City’s Flood Early Warning Systems • Illustrated need to update all 16 existing flood gauges and add 12 additional gauges by mapping out flood data in Bluebeam Revu • Prepared documents for City Council, outlining current issues with alerting citizens of imminent flooding threats • Resulted in City Council’s approval for $200,000 FEMA grant to update flood/rain gauges
-
-
-
ASAP
-
United States
-
Software Development
-
1 - 100 Employee
-
Delivery Driver
-
Feb 2016 - Apr 2017
-
-
-
Honda of Lake Jackson
-
United States
-
Motor Vehicle Manufacturing
-
1 - 100 Employee
-
Salesperson
-
Nov 2014 - Mar 2015
• Enhanced interpersonal skills, emotional intelligence, and my ability to resolve conflicts • Enhanced interpersonal skills, emotional intelligence, and my ability to resolve conflicts
-
-
Education
-
Texas A&M University
Bachelor's degree, Industrial & Systems Engineering -
The University of Texas at Austin
Coding Bootcamp, Full Stack Web Development -
Brazosport College
Associate of Science - AS, 3.96 -
George Ranch High School