David D Helsley

I am a seasoned IT professional looking for challenging work in Business Intelligence. During my years I have had many successful engagements as developer, administrator, lead and manager.  For the past fifteen years my focus has been helping clients with Business Intelligence.

Roles:

BI/DW Consultant – Fifteen Years

My BI experience is usually hands-on, broad and deep. For most clients I help them architect their environment then design and document the processes and procedures to build it. Usually I end up as the lead on their ETL or presentation team, helping them master the required skills and create appropriate policies. I’ve worked with proponents of Inmon’s EDW and Kimbal’s bus approach, but most of my work has been in line with Kimbal’s approach.

ERP Consultant – Three Years

I provided CNC, security and tools advice and support for JDE ERP implementations. In most cases my time was spent guiding training and problem solving. I designed and documented many import, export and interface processes that I helped the client’s staff create and implement.

IT Management – Three Years

Our team supported four sites utilizing Windows and HP-UX servers and Windows clients over a WAN. We were responsible for replacing Novell with Windows and active directory, and adopting the MicroSoft office suite. I also managed the technical team during the implementation of JDEdwards ERP at two of our sites.

Application Management – Two Years

We saved an unstable and ill managed ERP application. The CIO brought me in because we had experience rescuing a similarly troubled application. No big secret – create best practice policies and procedures for application management, automate as much as you can, and train your staff how to do it.

Application Development and Maintenance – Twelve Years

After three years programming in the Army, I spent many years designing, coding and maintaining applications in many languages on mostly VAX and Unix platforms. The methods and tools I mastered in the Army allowed me to excel as an analyst and programmer.

Education

I earned my B.S. in Business from the University of Cincinnati with a focus on information processing systems.

Contact

(814)480-9944   

ddhelsley@GMAIL.COM

 

Talents/Tools

Tool

Type

Years

Level

Last Use

Talend Open Studio

ETL

5

Architect

Current

InforSphere DataStage

ETL

7

Architect

Current

Informatica

ETL

1

Novice

2001

MSSQL Reporting Services

BI

5

Architect

Current

MicroStrategy

BI

4

Architect

Current

MSSQL

DB

16

Admin

Current

DB2

DB

10

Developer

Current

Oracle

DB

8

Developer

Current

Java Script

Prog

5

Hack

Current

MS Windows

OS

20

Admin

Current

Linux

OS

5

Hack

2014

Unix

OS

5

Developer

2001

Data Modeling

Skill

25

Expert

Current

Process Modeling

Skill

30

Expert

Current

MS Office Tools

 

20

User

Current

JDE CNC

 

5

Master

2001

JDE Tools

 

5

Master

2001

Clients and Employers

MOOG – Ten years leading the data warehouse effort and providing architecture and administration support.

Erie Insurance – Six months leading the team that developed their ETL process.

Target – Four months as their MicroStrategy lead, assuring penetration of the tool in their user community and liaising with their offshore team.

Dollar General – Hosted MicroStrategy implementation proof of concept with NetApp.

San Diego Airport Authority – Five months helping their team master DataStage and MicroStrategy in support of their PeopleSoft EPM implementation.

RentWay – As the Director of BI, I developed the architecture, approach and budget for the implementation of our DW. In the end the company was bought out and the plan was never executed.

Oracle – Six months installing and configuring PeopleSoft EPM for several of their clients.

Temple Inland – Two years leading their data warehouse team. Three years providing CNC and tools support on two of their JDE OneWorld ERP rollouts.

O’Gara-Hess & Eisenhardt Armoring Company – Provided JDE OneWorld CNC support as needed over a two year period.

LSI Industries – Three years managing their IT infrastructure and staff. Two years managing their ERP application and team.