Allen Wrinkle - Resume'

Objective:

To leverage 27 years of experience delivering IT solutions and an extensive education to deliver higher quality hands-on Agile Coaching and Project Management to a few key clients.  Willing to travel.  One of the few people with PMP, PMI-ACP(Agile Certified Practitioner), and CSM (Certified Scrum Master)

 

As part of the project team, if the situation demands, fully willing to fill other roles on the team including creating BI(Business Intelligence) dashboards, SQL data conversion/data validation, business analysis, test plan creator, data transformations, training.  I’ve just about done it all.

Open to Corp to Corp arrangements only.  Full-time,  part-time,  short-term, long-term, as-needed.  On-site or telecommute (at a lower rate) available.

Uniquely compete in two ways:

(1)    Price 

(2)    Flexibility – I want to be the resource buffer IT and business departments call to step in, complete tasks or projects, then step away until needed again(unless full-time is needed).  This is another way to save because in the real world, work comes in waves.  I only want to work when you have a lot to get done. 

Flexibility also comes in to play with the breadth of types of work I can do.  It is difficult to find one person who can do as many types of things as I will do.  This saves on transition of resource costs.

I want to be the first person you think of when you have something that needs to be done RIGHT, ASAP.

ALLEN HASRUN 100 MILES IN ONE DAY AND 203 MILES IN 3 DAYS.  I THINK THAT SHOWS HE HAS THE PERSEVERANCE TO PLAN FOR AND ACCOMPLISH CHALLENGING GOALS AND DEAL WITH CHALLENGES ON A DIFFERENT LEVEL THAN MOST PROJECT MANAGERS YOU MIGHT MEET.”

Dr Jay Tarnow, MD

 

Potential Roles

IT Project Manager/Agile Coach/Scrum Master

After having been a PMP for over 11 years and also being both PMI-ACP (Agile Certified Professional) and CSM (Certified Scrum Master), I am uniquely qualified to both strategically kick projects off on the right path or step in to get them back on track.  Even part-time I can add significant value to any project in a more cost-effective way.  I specialize in balancing the Agile approach of delivering value quickly with the roadmap/fiscal responsibility required by traditional approaches.  I know how to communicate across business and IT and know how to keep focused on high-value deliverables and getting around road-blocks.

Technical Trainer

Have taught almost all types of technical courses all the way from systems analysis/Data Modeling down to the most advanced SQL programming class.  My unique career position perfectly matches me for the cyclical compensation tied to class availability and travel. 

BI (Business Intelligence) dashboard creator

I am an expert on at least three types of BI tools (Oracles OBIEE, Tableau, and Excel Pivot Tables) and certified Spotfire Author.  I can quickly add significant value in a short time using these or other BI tools. 

Oracle BI XML Publisher

Have developed reports using this tool. 

Expert Data Modeler/Database Designer

Have designed and developed huge systems.  Written and taught many courses on data modeling and database design.

SQL Language Expert

I’ve written and taught classes on SQL but also have extensive experience writing procedural languages including Microsoft T-SQL functions/procedures as well as Oracle PL/SQL.

Data Migration Specialist

My career has been filled with migrating data from one system to another.  I’m particularly good at going in to the back-end of systems, analyzing the databases, and understanding how to transform data from one system to another. 

Systems Implementation /Integration Specialist

Expert at implementing a number of commercial software applications including Salesforce, I.H.S (EH&S Application), HR systems, PMWeb,  MRI, Etc.  I know what questions to ask and how to plan these projects.

PMO Standards Developer

I have helped establish the standards, procedures, and reporting systems for three separate PMOs.   Not a full-time job I want but I can help set one up.

Commercial Software Support Outsourcing

Have extensive knowledge and would be willing to remotely administer/support a few commercial software applications such as MRI, I.H.S. (ESS), Tableau Server.

Business Analyst

Able to step in to gather and document requirements, create and execute extensive test plans, query back-end databases and provide data quality reviews.

 

Education/Certifications/Training/Volunteer Positions

PMP

Project Management Professional (11 years) ID# 56483, 2002

PMI-ACP

Agile Certified Practitioner (since 2012)

CSM

Certified Scrum Master (Jan 2012)

MBA

Masters in Business Administration – University of Houston – 1991 – Cum Laude

BS Computer Science

Lamar University – 1987 – Cum Laude

Tableau BI Development

Both desktop and server administration Version 8.0

Steering Committee

Retired from steering committee of the Phoenix Scrum Users Group.

Spotfire Authoring

To be completed in September 2014.

SQL Expert

Numerous examples of being an SQL Expert/Trainer

Data Modeler

Certified Data Modeler instructor by Oracle corp.

 

Recent Example  Projects (many more were done.  Usually manage 5-8 projects at one time)

2013-2015

OBIEE Business Intelligence Dashboard Project Manager/Developer (utilizing Agile concepts)

Created complex views as a middle tier to a commercial Employee Health and Safety application (I.H.S. – ESS) and then developed extensive interactive Business Intelligence dashboards that were used in board slides to report EH&S metrics.  Metrics included things such as TRIR, Near Miss, Incident rates, Performance Safety Management

2011-2015

I.H.S. Essential Suite EH&S application support/administration/enhancements

Provided support, customized screens, upgraded, provided administration services for I.H.S. Essential Suite 7.4-7.6 for modules including Incidents and Task Management.

Create Oracle BI XML Publisher reports to merge data from ESS and EAM for a Compliance Assurance project.

2013

Business Analyst/Testing/Data Quality Consultant

Provided support on a Baker Hughes EH&S SAP implementation by creating comprehensive test plans, documentation, data extracts/loads into a custom database for data quality assurance and testing, pre-production application testing, wrote complex data validation/QA queries in SQL.

2012-2013

Project Manager/Agile Coach for Data Warehouse – Commercial Real Estate.

Trained product owners and helped them develop, prioritize, and groom their backlogs.  Worked with the DEV team to deliver in sprints.

Transformed two business units into allies of IT by personally pioneering the Agile approach to incrementally deliver high-value data into the data warehouse which integrated data from accounting systems and other sources and made the data available via Excel Pivot and particularly Tableau Dashboards.  Utilized Sql Server Analysis Engine as well as Relational sources.   System was a huge success and transformed the business’ view of the Agile approach to product delivery.

2012-2013

Project Manager for custom Salesforce application which automated/replaced 5 existing applications.

Developed requirements, selected vendor, managed vendor/development, managed/assisted in data migration from legacy system, managed company-wide training/implementation of the new system.  Huge success in integrating Legal, Acquisitions, and Property Management.  Developed custom reports, trained users.

2012

Project Manager for various vendor selection/ Implementation projects

Managed evaluation, demos, proof of concepts, system integration, and final successful launch for property tax outsourcing, SAAS construction project management system, and a number of others.

2012-2013

Tableau Dashboard Developer

Developed many Business Intelligence Dashboards which integrated data in to charts and graphs from a number of data sources.  Provided training to business users as well as other developers.    Introduced/utilized combo waterfall/Agile approach.

2012-2013

MRI Support/Application Development

Provided commercial software support/customization services for commercial real estate accounting system. Also provided development with queries/analysis to help build the data warehouse.

2011-2012

OBIEE Dashboard development/I.H.S. application support

Used Kaanban techniques to deliver BI Dashboards using Oracle’s OBIEE tools. Also administered/customized a commercial software application designed to manage incidents for an oil and gas company.

2009-2011

Designed and developed entire interactive web application for behavioral science applications.

Architected the database, created data layer, business logic layer, set up security, and developed a complex, interactive web application using C#, Visual Studio, and DEVEX add-ins.  Used Agile/Scrum techniques to deliver the solution iteratively.

2010-2011

PeopleSoft Data sanitizing Project

Wrote complex SQL to identify data conversion anomalies and wrote scripts to cleanse the data for Shell Oil Company.

 

 

Additional Prior Roles (Not necessarily willing to do now but shows breadth of experience)

Data Modeler  - Expert / Physical database design - Expert

Business Analyst

.Net Developer

Database Administrator (Oracle/SQL Server)

C#, JavaScript programmer, Developer Express

Oracle BI XML Publisher Developer

Parent Coach

Systems Architect

General Manager

Oracle SQL/PL-SQL Expert

Microsoft SQL/T-SQL Expert

Technical Trainer

 

Industry Experience

Commercial Real Estate (Leasing, Property Management, Accounting)

Oil and Gas (E&P, Refining,  Pipeline, EH&S, Compliance Assurance)

Employee Health and Safety (EH&S) applications (designed 800 entity application for Texaco)

Public Utilities

Mortgage

Inventory Management

Medical

Behavioral Sciences

Accounting/Finance

Human Resources

 

Employment History

5/2013-present

Clarity Solutions, Inc.

Senior Agile Project Manager/Scrum Master/Business Intelligence architect/developer .Available for full-time or other part-time assignments.

3/2012-5/2013

Cole Real Estate Investments

Manager, Commercial Real Estate Project Management (Agile pioneer)

9/2008-3/2012

Clarity Solutions, Inc.

Senior Agile Project Manager/Senior Development Lead (see client list)

12/2006-9/2008

El Paso Oil and Gas

Senior Project Manager

10/2004-3/2006

Aegis Mortgage Company

Senior Technical Project Manager

3/2001-8/2004

Shell Oil Products, US

Senior Systems Analyst/Project Manager

6/1996-2/2001

Texaco

Senior Systems Analyst/Project Manager/Data Modeler/Systems Architect

1996-9/2008

Clarity Solutions, Inc.

Part-time Consulting in addition to other jobs (see client list)

1987-1996

Continuous employment

Companies like Texas Eastern Products Pipeline, BSG, Intellitech, Relational Concepts, Top System.  Small consulting companies. 

Older Client List/Projects (showing breadth of industry knowledge

 

 

 

11/2011-2015 (mixed part-time/full-time)

Noble Energy, Inc (Senior Agile Project Manager utilizing Scrumban to develop OBIEE Dashboards, develop complex system interfaces with external vendor systems, scripts for data comparison/cleanup, EH&S Application support for I.H.S. software.  Also introducing Agile concepts to teams early in the adoption process and utilizing Agile concepts for non-IT projects).  Merged data from ESS/EAM to provide input for a Compliance Assurance project.

 

 

2013-2014 *

Baker Hughes – SAP EH&S customization.  (part time)

 

09/2009-10/2011

Self Management Company LLC (Senior Agile Project Manager/Scrum Master / Web Development Manager/Technical Lead / Data Modeler/ .net/C#/JavaScript/SQL developer)

 

9/2008 - 09/2009

Linn Energy (Senior Project Management Consultant - PMO)

 

12/2006-9/2008

El Paso Oil and Gas(Senior IT Project Management Consultant – PMO)

 

10/2004-3/2006

Aegis Mortgage Company (Senior Project Manager for Secondary Marketing)

 

3/2001-8/2004

Shell Oil Products, US(Senior Systems Analyst/Project Manager)

 

6/1996-2/2001

Texaco   (Senior Systems Analyst/Project Manager/Data Modeler/Systems Arch.)

 

7/1999 9/2001*

Abbott Laboratories (Data migration/Commercial software implementation)

 

6/1999-10/2000*

 

Baxter Healthcare (Data migration/EH&S Commercial software implementation)

 

12/1998*, 4/1999*,

 8/1999*,10/2000*

Burlington Industries (Training: Advanced complex SQL Queries/Data Modeling)

 

3/2005-4/2007*

Flying J Inc. (Refinery payroll software development) 

 

2/2001-9/3003*

Halliburton (Incident reporting custom software development)

 

6/1998-11/1998*

Radian International (Incident reporting custom software development)

 

         

*Part Time