Gil Standen gstanden@netsrc.us www.netsrc.us Midwest Office, 1101 Thornwood Drive St. Louis, MO 63124 Work: 314-989-1445 Northeast Office, 160 E. 91 Suite 1L New York, NY 10128 Pager: 314-424-5868 Objective Oracle DBA position with requirements including, but not limited to: 10+ years general DBA prod/dev major corporate experience; 8 years Oracle DBA major corps. (5000+ emps/$2B+ year rev) incl. heavy PROD and DEV support; extensive app DB support background, including validated CFR-gov't regulated pharmaceutical and financial apps; dev support including in-house and canned app mods, as well as teamwork performance tuning.   Experience Aug 2003-Present  US Department of Agriculture (Unisys/Teksystems) St. Louis, MO Oracle Financials 11i DBA •   Gov't US Dept. of Agriculture Financial System implementation phase I production rollout •   Configure 11i printers •   Install Online Documentation •   Install/Clone Apps 11i instances •   Write HP-UX paging/alert text-processing/space_mgmt/online backup shell scripts •   Provide support remotely via VPN connection   May 2003-Present  Stillman Real Consulting, dba SRC, LLC St. Louis, MO Managing Consultant Client List, NetSRC: SJA, Attorney at Law, Legal Systems Web Database Project October 2003 - Present •   Build PHP system to deal with proposed changes in RESPA/Regulation Z •   Consolidate address systems into new online database •   Provide auto-generated email response to lenders •   Provide online customer account access •   Construct back-end database for website functions FFR Bandwidth Digital, Inc. March 2003 to present •   App DB data load, front-end re/design/enhance, data scrub/mine/assoc., reporting. •   Highly specialized data storage, retrieval and reporting design •   Direct activity of database design consultant •   Create interfaces for loading of new data per mgmt. specs •   Implement database changes both on back-end database and front-end GUI interface •   Modify table structures as necessary to support user functionality enhancements •   Data clumping (row-level) •   Meet tight database design deadlines and milestones •   Design ERP output report formats and export paths •   Test and produce final data output formats •   Verify accuracy of data •   75% TC, 25% On-site   Aug 2000-Mar 2003 Purdue Pharmaceuticals Stamford, CT Fairfield County Sr. Oracle DBA UNIX (HP-UX & SUN) Operating System running Oracle International Pharmacovigilance Adverse Event System Customization Project (IPAES) Technical Manager, IPAES phases II and III •   Prepare IQ/OQ documents, obtain all approval signatures, and execute on validated systems •   Manage database and application security •   Write and submit emergency database IQ/OQ documents for IPAES phase III production •   Work closely with ISQA Validation Specialist and Business Owner on validation documents •   Export, script execution, space management, and critical condition alert system development •   Create and validate new production Oracle database for Phase III implementation •   Work with UNIX SA/app developers to upgrade production validation environment •   Tune, troubleshoot and customize vendor-delivered reports •   Apply updates and patches to validated CFR-compliant versions of application •   Integrate several CFR-compliant legacy databases into IPAES production system •   DBA Projects Manager IPAES phases IV and V •   Coach and technical guide to team members in CFR and company standards and procedures •   Periodic activity review to management on IPAES tasking and interfacing methodologies •   Communicate critical sub-task issues among speciality teams •   Ensure compliance of IPAES db-related tasks with CFR validation documentation and protocols Oracle Clinical (OC) Application Production Roll-Out DBA Projects Manager, OC production Ramp-Up •   Prepare project plans and task forecasts •   Mentor DBA consultant hired to work exclusively on OC project •   Manage database and application security •   Streamline CFR compliance of international change control procedures •   Work closely with vendor and IT Tech Team to prepare and execute validation documents •   Install CAVS (Computer Assisted Validation System) •   Determine proper interoperability and inter-compliant patch releases •   Ensure data integrity •   Support OC Production Database •   Guide changes on validated production to ensure Int'l Change Control Board compliance •   Moderate weekly team meetings to ensure request-groups were summing to project milestones •   Manage consultant work on project plug-ins (TRW Autocoder, IR, CAVS, et. al) •   Facilitate tasks needed to implement post-production modules and customization Manufacturing Systems Support (Validated Systems) •   Support electronic batch-release projects •   Manage CIIM Validated Legacy migration (Oracle 6.0.37 DEC-VAX to 7.3.4 HP-UX) •   Facilitate POMS-SAP Pharmacy Dispensing Interface •   Install BARCODE and CYCLETIME manufacturing material-tracking subsystems R&D LIMS Application DBA •   Create and Validate (IQ/OQ) several Oracle databases on schedule •   Execute numerous IQ/OQ documents for application code upgrades •   Improve relations with Ardsley R&D LIMS team •   Provide good technical guidance and database expertise •   Accomodate last minute users requests •   Provide detailed agendas and keep meetings focused on issues at hand •   Plan and implement archive logging for LIMS production database Financials Systems DBA (Oracle Financials and SAP liasion) •   Oracle Financials 10.7 and 11i production support •   Troubleshoot concurrent manager problems •   Facilitate and execute database-related pieces of external interfaces to other database systems •   Support migration of Oracle Financials to SAP Financials •   Install/Deploy/Post-Production Interfaces (including CFR compliant Validated sub-systems) •   Support IXOS-SAP Accounts Documentation System production installation (Validated I&C) •   Implement Vertex TAX calculation system and supervise consultant activity (I&C) •   Manage Capital Budgeting Interface (I) DBA DR Team Lead, SAP Disaster-Recovery Simulation Daily Production database support including Validated Medical, Sales/Marketing, & Corporate Validate install of Audrey Audit Application Validate install of Magic Solutions Help Desk and Change Management Application Extensive training in the HP implementation of UNIX Operating Systems   Jan 2000-Jul 2000 Mallinkrodt St. Louis, MO Consultant, Regulatory Affairs •   Data support of NDA and Generic Drug FDA submissions •   Development of EVA-compliant e-submission of drug application documents   Jun 1997-Sep 1999 Maritz St. Louis, MO Oracle DBA II •   Installation, reconfiguration, and patching of Oracle Financials version 10.x and 11.x •   Database administratiUpgrade company financials to Oracle Financials 11i (fresh install and support) •   Test ADSM/v3 with BMC Sqlbacktrack •   Pilot install of Oracle on OS/390 mainframe. •   Coordinate with UNIX SA to create scripts for various tasks •   Rebuild Tablespace with 3rd party tools (Platinum TSReorg) and Oracle tools (exp/imp, loader) •   Move instances among environments via cloning (preferred) and exp/imp (special situations) •   Consult on oracle inter-platform communication with oracle (MVS-UNIX and UNIX-MVS) •   Install various oracle plug-ins (Developer 2000 & Oracle Reports 2.5.5) •   Coordinate with UNIX system admins to create scripts for various tasks •   Daily support of Oracle 7.x and 8.x databases •   Coordination with SQL Coding Staff   Aug 1995-Jun 1997 IT Corp. St. Louis, MO Oracle DBA and IT Project Systems Manager •   Ensure CFR compliance of analytical sample data with all applicable CFR sections •   Ensure compliance with Resource Conservation and Recovery Act (RCRA) Permit •   Provide integration services to on-site consultants and be vigilant over project interests •   Manage on-site Data Operations •   Supervise full and part time staff •   Plan layout and installations of equipment and network cabling •   Cost-contain subcontracted IT-related services •   Plan and manage IT-related project expenses and yearly budget •   Redesign hardware and software configurations on short-notice •   Build work relations with IT Corp. professionals at other US and int'l locations •   Provide on-call 24-hour additional technical assistance to keep plant running •   Project Manager, backup technologies •   Present to upper-management on best backup technology option •   Show new backup system could up project net by $7.8 million dollars •   Revise and expand backup software regularly •   Write custom backup software for project •   Implement High-Availability (HA) to support TTU 24x7 processes •   Update hardware and software allowing government administrators remote-access •   Project Manager, scientific data indexing •   Ensure data ready for spot audit by Gov't regulators, watchdog groups, and staff •   Manage timely and accurate delivery of lab results via modem •   Manage compliance with EPA, RCRA (CFR) and Missouri DNR data regulations •   Write RFP for $3 million dollar project lab contract bidders •   Manage all aspects of scientific sampling program •   Contact subcontracting lab project manager and staff daily •   Ensure lab couriers comply with highway transport of hazmat regulations •   Implement industrial plant process control and shipment system •   Collect 100 plant operation parameters via PLC's using ladder logic •   Support interface of Wonderware/Oracle data collection system to PLC’s •   Work with PLC process controls consultants •   Design IT system to package and track CFR-regulated placarded material shipments   Mar 1991-Aug 1995 UCSD La Jolla, CA Laboratory Database Manager •   Managed data collected on chemical compounds •   Export of data to other systems for analysis and processing   Education UCSD San Diego, CA Bachelor of Science - Chemistry Computing, June 1991 •   Focus in scientific computing & data management   Additional Educational Certifications •   Oracle 9i R2 Oracle (Purdue) 2003 •   MS SQL Server Installation and Admin.New Horizons 2003 •   Oracle Portal Purdue In-house 2002 •   SAP BC360 UNIX/ORACLE Rel. 4.6SAP (Purdue) 2001 •   SAP BC505 Database Administration - -Oracle SAP (Purdue) 2001 •   Oracle Names Purdue In-house 2001 •   SAP 50 R/3 Basis Technology SAP (Purdue) 2000 •   Installation of Oracle Applications Version 11 Oracle (Maritz) 1999 •   Administration of the Oracle 8 Database Oracle (Maritz) 1999 •   12-hour Tutor Cert.and Training Course Adult Basic Ed. 1997 •   Certified Oracle DBA Oracle Corp. 1996 •   Oracle DBA I Oracle (IT Corp) 1995 •   Oracle DBA II Oracle (IT Corp) 1995 •   Intro to SQL and PL/SQL Oracle (IT Corp) 1995 •   Oracle Backup and Recovery Oracle (IT Corp) 1995 •   Tuning the Oracle Database Oracle (IT Corp) 1995 •   Tutoring Certificate Dev. Lrng. Lab 1978   Professional Associations •   New York Oracle User's Group (NYOUG)   Continuing Education •   SAP 50 R/3 Basis Technology 8/28 - 8/29/2000 •   SAP BC360 UNIX/ORACLE for SAP, Rel. 4.6 11/05 - 11/09/2001 •   SAP BC505 Database Administration - Oracle 11/19 - 11/21/2001 •   Oracle Names 10/2001 •   Oracle Portal 02/2002 •   Installation of Oracle Applications Version 11 Oracle Corporation 1999 •   Administration of the Oracle 8 Database Oracle Corporation 1999 •   Goal Setting and Planning 10/16/01 •   Performance Partnership 10/08/01 •   Dynamics of Teams 07/31/01 •   Active Listenting 06/18/01 •   Management Assessment 09/22/00 •   Effective Team Player 1998 •   Coping with Stress 1998   FDA CFR-Compliant Validated Systems Training •   Polaris SDLC Purdue 2002 •   Magic Solutions Change Management Purdue 2002 •   Problem Management Purdue 2002 •   Corp Data Center Physical Security Purdue 2002 •   Logical Data Security Purdue 2002 •   IT Disaster Recovery Plan Purdue 2002 •   Validated Wkstn Op & Maint Purdue 2002 •   Backup/Restore/Archive Purdue 2002 •   Database Maintenance Purdue 2002 •   Change Management Purdue 2002 •   SOP Creation, Revision Purdue 2002 •   Time Wizard Time Keeping Purdue 2002 •   Project Portfolio and RAID Log Purdue 2002 •   cG*P Mandatory Training Purdue 2002 •   SOP Deviation Purdue 2002 •   System Maintenance Purdue 2002 •   Database Maintenance Purdue 2002 •   Change Management Purdue 2002   Awards •   Support Award Purdue 2002 •   Quality Works Award Maritz Inc. 1998 •   Exclusively Yours Award Maritz Inc. 1998 •   Team Peak Performer Award Maritz Inc. 1998 •   Tutor Outstanding Recognition Certificate ABE 1997&1998 •   Outstanding Achievement Award Tutoring Dev. Lrng. Lab 1978   Volunteer Activities •   Sisters of Carondelet Art Show Fair Exhibitor Artist Convent 1999 •   Adult Basic Literacy (ABE) Program Volunteer Tutor Adult Basic Ed.. 1997-1999 •   St. Paul Church Senior Center Floor Restoration Project Manager St. Paul's Church 1997   Philanthropy •   National Children’s Cancer Foundation 1997 •   United Way of Greater St. Louis Builder of the Community 1997 & 1998 •   Carondelet Community Betterment Federation 1999