Home Word Format Printable Text Format Contact Send E-mail

PEDRO J. FIGUEROA Mobile: 210-789-1769 http://www.PedroFigueroa.com/ SUMMARY * HP NonStop SQL Database Administrator with over 10 years of experience as a DBA * Experience designing, managing, and tuning Tandem/NonStop SQL & NeoView databases for various applications * Over 4 weeks of HP professional training for the NonStop SQL DBA role EXPERIENCE Jan 2010 – Current Verizon Business, Sterling, VA TEAM LEAD & SENIOR HP NONSTOP SQL DATABASE ADMINISTRATOR * Managing a five member team on IT consultants. * Responsible for managing and improving database performance and stability for the Verizon Business Invoicing system that bills out $130 million a month. Environment: Itanium NonStop May 2008 – August 2008 AT&T, San Antonio, TX AD-HOC SQL PROGRAMMER * Created SQL programs to generate data requested by clients. * Documented procedures and information as needed. * Improved logical and physical database design and modeled, query designed, and coded. * Performed performance evaluation of the marketing database. * Generated a report with data from two different marketing tracking databases. The report was very detailed and made the marketing personnel’s job much easier to monitor customer trending by markets and products across the entire company. Environment: Teradata, Business Objects and MS Excel. June 2007 – February 2008 HP, Houston, TX ENTERPRISE DATA WAREHOUSE/IHUB DATABASE ADMINISTRATOR * Supported the Enterprise Data Warehouses and iHUB Databases. * iHub is the world’s largest production database, handling tracking parts and orders for all of HP business.  If you have a part number for anything all the way down to a resister, HP can tell you where the part came from, what system it was placed into and who bought that system.  It also was being tied into the NeoView Systems to handle multi-terabyte queries faster than any other system on the market. * Worked with a team of two other DBAs to ensure systems availability and to work with service desk personnel from Australia, India, UK, and the USA.  Environment: Tandem/HP NonStop, NonStop Blade Servers, NeoView, SQL/MP and SQL/MX. May 2007 GE Healthcare, Seattle, WA INTEGRATED IT SOLUTIONS CLINICAL SERVICES CONSULTANT * Updated automation processes for Pathway deployment. * Refined TACL macros to add or improve functionality. * Documented procedures and added information as needed. Environment: Tandem/HP NonStop Itanium Systems, OSS, SQL/MP, TACL, TMF, SQL-Magic, DDL/DML, Prognosis and S-Series Systems. June 2006 – April 2007 SunGard, Salem, NH SENIOR HP NONSTOP SQL DATABASE ADMINISTRATOR * Created Standard Operating Procedures for HP NonStop SQL/MP database design, query design, coding, performance evaluation, and optimization and security. * Audited HP NonStop SQL/MP code to improve code, system, and database performance. * Developed tools to facilitate HP NonStop SQL/MP database design & management. Environment: Tandem/HP NonStop, SQL/MP, TACL, TMF, DDL/DML, Prognosis, SQL-Magic, and S-Series Systems. September 2004 – June 2006 Evertec Inc., San Juan, PR SENIOR HP NONSTOP SQL DATABASE ADMINISTRATOR * Headed project to build new HP NonStop SQL/MP database to hold the data for ATM (ATH), POS, and Credit Card Transactions, as well as several retail clients for all of Puerto Rico, the Caribbean Islands, and several major banks in Central and South America. * Created Standard Operating Procedures for HP NonStop SQL/MP database design, query design, coding, performance evaluation, optimization, and security. * Audited HP NonStop SQL/MP code to improve code, system, and database performance. Environment: Tandem/HP NonStop SQL/MP, TACL, RDF, E/R, TMF, SQL-Magic, DDL/DML, Prognosis, Power Designer, Attunity, and K & S-Series Systems. April 2004 Securities Industries Automation Corporation - SIAC, Brooklyn, NY HP NONSTOP SQL DATABASE ADMINISTRATOR * Created Standard Operating Procedures for HP Nonstop SQL database design, query design, coding, performance evaluation & optimization * Helped design procedures for updating & managing a 24/7 system * Audited Tandem SQL code to improve code, system & database performance Environment: Tandem/HP NonStop, SQL/MP, TACL, K & S-Series Systems August 2003 – December 2003 Fiserv EFT, Portland, OR HP NONSTOP SQL DATABASE ADMINISTRATOR * Developed TACL and HP NonStop SQL/MP program to generate DDL files for quick and accurate cold site database rebuild. * Created Standard Operating Procedures for NonStop SQL database design, query design, coding, performance evaluation, and optimization. * Developed tools to facilitate NonStop SQL database design and management. Environment: Tandem/HP NonStop, SQL/MP, TACL, RDF, TMF, DDL, Measure, Prognosis, Batchcom and S-Series Systems. June 2002 – September 2002 Sabre, Southlake, TX HP NONSTOP SQL DATABASE ADMINISTRATOR * Supported Databases for Web Services at TraveloCity.com. * Created Standard Operating Procedures for NonStop SQL database design, query design, coding, performance evaluation, and optimization. * Developed tools to facilitate NonStop SQL database design and management. * Created and modified tables for use with the pricing system for Sabre clients. * Helped design procedures for updating and managing a 24/7 system. * Audited Tandem SQL Code to improve code, system, and database performance. Environment: Tandem/HP NonStop, SQL/MP, RDF, DDL, Tedit, UNIX Shell Scripting, Guardian 90, Power Designer, Clear Case, and S-Series. August 2000 – March 2001 A.G. Edwards & Sons Inc., St. Louis, MO HP NONSTOP SQL DATABASE ADMINISTRATOR * Headed project to rebuild SQL databases for Dow Jones News updates, (used by all investment brokers) involving SQL database design, query design, coding, and performance evaluation. * Designed SQL and TACL programs to automate daily and weekly database tasks. * Developed many tools to facilitate NonStop SQL database design and management. Environment: Tandem/HP NonStop, SQL/MP, TACL, DDL, Tracker, Measure, Prognosis, Enscribe, RDF, EMS, FUP, Report Writer, Peruse, Tedit, Spoolcom, NetBatch/Batchcom, Guardian 90 and K & S-Series. August 1997 – April 2000 West TeleServices, San Antonio, TX HP NONSTOP SQL DATABASE ANALYST III * Headed major projects working on client databases for AT&T, MBNA, Providian Financial, and Citibank Visa. * Supervised an eight member team of NonStop Database Analyst II. * Developed programs and procedures for training NonStop Database Analyst II. * Designed and deployed NonStop SQL database and TACL programs for database architecture and optimization. * Managed multiple projects with varying time lines and ensured all projects were completed within time lines and accurate data integrity. Environment: Tandem/HP NonStop, K& S Series, TACL, NonStop SQL/MP, EMS, RDF, TMF, Measure, Spoolcom, NetBatch/ Batchcom, Guardian 90, COBOL85, and C. TECHNICAL QUALIFICATIONS * HARDWARE Tandem/HP NonStop & Neoview * SOFTWARE DDL/DML TACL Peruse Tedit SQL/MP & MX RDF Enscribe EMS Guardian 90 GoldenGate FUP Shadowbase Prognosis Report Writer Spoolcom Oracle 8i Measure Tracker MS Excel MS SQL 6.5 TMF HTML/DHTML/CSS UNIX Shell Scripting MS Access NetBatch Batchcom Power Designer Clear Case SQL Magic PROFESSIONAL TRAINING HP NONSTOP TRAINING * HP NonStop TACL programming (U4199S). * HP NonStop Concepts & Facilities (U4147S). * HP NonStop Conversational Interface (Self Study Training). * HP NonStop Report Writer (Self Study Training). * HP NonStop SQL/MP Overview (Self Study Training). * HP NonStop SQL/MP Essentials (U4181S). * HP NonStop SQL/MP Query Design for Performance (U4183S). * HP NonStop SQL/MP database management (U4180S). * HP NonStop SQL/MX Database for SQL/MP Users (U4185S). * HP NonStop SQL/MX Basics (U4184S). * HP NonStop SQL/MX Query Analysis and Tuning (U8529S). * HP NonStop SQL/MX Database Management (U86175). ORACLE * Oracle Enterprise DBA Part 1A: Architecture and Administration. * Oracle Enterprise DBA Part 1B: Backup and Recovery. * Oracle Enterprise DBA Part 2: Performance and Tuning. * Oracle Enterprise DBA Part 3: Network Administration. IBM WebSphere MQ Series Training * IBM WebSphere MQ Advanced System Administration (VM305) EDUCATION * University of Texas-San Antonio, San Antonio, TX, Business Administration and Information Systems. * University of Houston-Downtown, Houston, TX, Information Systems. * Texas A&M University, College Station, TX, Computer Science.