Download PDF

Pierre de Prez

  • Greater Denver Area, US CO

Application Support & Business Reporting Specialist

Summary

  •  Solid understanding of ETL (Extract, Transform and Load) strategies and design using ETL solutions (Prism, ETI Extract and Informatica)
  • Level 2 support of a variety of applications
  • Developed functional specifications, flow charts, project plans and project budgets
  • Lead cross-functional teams to address business/systems issues
  • Experienced in the full SDLC (Software development life-cycle) including analysis, design, coding, testing and implementation of new projects and features
  • Proficient in developing SQL (Structured Query Language) for loading/extracting data from data warehouse
  • Excellent communication skills, written and verbal for both technical and non-technical staff at all levels
  • Wrote 200 page User Manual/Training guide for a Residential Management Application
  • Experienced with working with extremely large databases

Work experience

Oct 2003Feb 2015

Senior Consultant

NTT Data, working at Honeywell
  • Administered Microsoft Dynamics SL Project management ERP (Enterprise Resource Planning)
  • Developed and maintained factory floor proprietary Visual Basic (VB) applications
  • Maintained Client/Server web-based applications for Honeywell employees and Suppliers (~ 5k users)
  • Supported Oracle UCM/Stellent/Xpedio Content Management document repository
  • Lead team to convert reports from Microsoft Access ‘97 to MS Access 2003
  • Designed, maintained and modified ~100 VBA (Visual Basic for Applications) based reports
  • Administered Key Characteristics Oracle database (stored procedures, packages, views and queries)
  • Technical lead for report and query development
  • Provided maintenance and development support of FAIR (First Article Inspection) Tracker
  • Maintained the Parts Control System for International Space Station
  • Developed and tested best business practices for disaster recovery procedures

Skills

Application packages

Microsoft Dynamics SL, Oracle UCM

Desktop tools

Word, Excel, Toad, MS Access, MS Project, Powerpoint, Visio

Databases/DB tools

SQL Server, Oracle, SQL queries, PL/SQL, MS Access, MS Query, DB2

Application Support

Visual Basic for Applications
Visual Basic
Unix scripting
Security administration