Experience

Piston Data

• United States
• Advertising Services
• 1 - 100 Employee

• Director Of Information Technology

  • May 2017 - Present

  Oversee and implement data technology to meet the demands of our growing customers. Oversee and implement data technology to meet the demands of our growing customers.



Robert Half

• United States
• Staffing and Recruiting
• 700 & Above Employee

• Data Analyst

  • Nov 2015 - Present

  • Support for reporting database • Data modeling (Physical/Logical) changes to in-house ERP system • Developing PL/SQL scripts to incorporate changes to database structure • Reconciliation and exception reporting for data migration and validation • Building test environments • Diagnose/resolve PL/SQL code issues to fix corrupted data. • Support for reporting database • Data modeling (Physical/Logical) changes to in-house ERP system • Developing PL/SQL scripts to incorporate changes to database structure • Reconciliation and exception reporting for data migration and validation • Building test environments • Diagnose/resolve PL/SQL code issues to fix corrupted data.



Technip

• Oil and Gas
• 700 & Above Employee

• Data Analyst

  • 1991 - Jun 2015

  Technip, CA, 1991 to June 2015 Oracle DBA • Extracted financial/project data from ERP database for report distribution to various disciplines and managers. This involved developing custom application to parse data for use in Excel and Cognos Impromptu. Distribution done to network folders as-well-as email attachments. • Go-To person for discrepancy reconciliation during month-end closings. • Enabled company to efficiently switch ERP systems by migrating old Legacy systems to new. Involved creation of data links between databases, data mapping tables and exception reports. • Created needed and missing interfaces to ERP environment by developing custom GUI applications for Engineering, Procurement and Finance. Applications encompassed data entry, reporting, export and import. This helped save the company thousands of dollars in additional modules. • MS SQL 2008, 2012 Installation and administration • Database group leader for database teams in Houston and California • Oracle 8i to 12c Installation and administration • Implementation and Administrator for Oracle E-Business Suite R12. • Implementation and Administrator for Costpoint ERP system • Logical and physical data modeling for existing and new databases. • Developed backup strategies using Oracle IMP/EXP, DATAPUMP and RMAN • Install database/server application updates and patches. Show less