ERNESTO R. GUMPAL JR.
***** ** ***** **. ****, WA, 98031
Highly accomplished, goal-oriented and results-driven database engineer with a proven track record of success in the field of database administration for online transaction processing, decision support systems, data warehouse design, business intelligence and performance optimization. Demonstrated ability to tackle and succeed in all endeavors. Exceeds ongoing and overlapping deadlines in fast-paced environments, handles multiple assignments simultaneously and coordinates deliverables with key stakeholders in cross-functional groups.
Oracle 9i/10g/11g/12c, Teradata v12/v13, MS SQL Server, MySql, Greenplum (PostgreSQL), Timesten
Oracle 12c EM Grid, Oracle Data Integrator, Apex, Toad, Oracle Application Server, Siebel Analytics (OBIEE), Oracle Spatial, BEA Weblogic, IBM Websphere
PL/SQL, Unix Shell Scripting
Linux, Solaris, HP UX, IBM AIX, Windows NT
Value Added Leadership
Team and Cross-functional Leadership, Coaching and Mentoring, Project Management, Client Relations and Presentations, JPMC E2 ® - Expert Engineer Alumni
JP Morgan Chase & Co. (Singapore)
Position Title : Associate – Database Management Analyst Specialization : Database Administration / Plan and Build Engineer / Infrastructure Management Industry : Banking / Financial Services
Duration : Aug 2011 – Aug 2017
Provides services as technical lead for projects in the Oracle DB build and configuration space.
Works with project managers and disparate teams to ensure project delivery.
Renders consultation with application development teams regarding application integration with deployed databases.
Initiates build process and quality assurance improvements. Creates database maintenance plans to ensure data integrity.
Administers and maintains policies and procedures for ensuring the security and integrity of the databases.
Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.
Leads the efforts of installing and maintaining database management software; plan for and execute any required database upgrades and migrations. Highlighted Projects:
Build Process Improvements – Subject matter expert for build related improvements as the landscape for database build changes overtime.
Infrastructure Asset Management – Lead the efforts on automation opportunities for infra-live DB assets.
Oracle 11gR1 to 11gR2 Standalone and RAC Upgrade – Participated and conducted an out of place upgrade for development, dev-int, qa, uat, performance, production and DR environments.
SQL Server to Oracle 11gR1 Wave Migration – Supported a series of twelve monthly waves to migrate existing application data from SQL Server to Oracle.
Full-blown DB Stats Optimization – Designed a mechanism and developed a script to run table level statistics in parallel. The maintenance greatly reduced the amount of window time from three days to eleven hours.
Teradata Global Consulting Center
Position Title : Sr. Technical Consultant
Specialization : Database Administration / Professional & Managed Services Industry : Consulting
Duration : Oct 2010 – Aug 2011
Responsible for providing administration and support operations for Enterprise Data Warehouse environments and ensure availability and optimum data warehouse performance.
Carries-out post-production operations of customer's Data Warehouse and is responsible for the delivery of Database administration and operation functions according to Service Level Agreement with the customer.
Maintenance and control of database optimization, capacity, security and protection, configuration, scheduling, errors, and execution of maintenance utilities.
Professional consulting for clients across the Americas, EMEA and Asia Pacific regions. Highlighted Projects:
Intercontinental Hotels Group – A Managed Services client with thirty-two terabytes of data primarily focused on hospitality services around the globe. The main objective is to maintain a stable environment for providing a reliable data warehouse platform used by business intelligence applications.
Sara Lee Corporation – Covered the transition period in Chicago, IL and lead the project in the Philippines. The client is a global manufacturer and marketer of high-quality, brand name products for consumers throughout the world. Teradata as a consultancy provider, its goal is to support the data warehouse environment based on client requirements. Smart Communications Inc.
Position Title : Database Administration Supervisor Specialization : Database Administration / Database Design and Architecture Industry : Telecommunications
Duration : Aug 2007 – Oct 2010
Performs database administration and implementations for corporate platforms supporting over 5,000 employees and 40 million subscribers. Manages database servers, ensuring that each service has 100% availability.
Leads the Engineering, Planning and Design team within Database Administration and Support group. Involved primarily on pilot systems rollout to production which includes support throughout the SDLC.
Establishes internal processes and procedures for growing database systems that involves deployment control and quality metrics, database availability matrix, data retention policies and Capacity Planning.
Ensures availability and performance of production databases that support the system which is also required for Disaster Recovery platforms.
A team player. Works with various groups to ensure that the associated hardware resources allocated to the databases are running at an optimum performance.
Provides trend analysis to the service management team to enable them to make informed decisions regarding resource management.
Acts as Smart’s SPOC for problem escalation to Oracle development team and third parties as appropriate.
Key person for improvement, maintenance and troubleshooting of the databases to include rollout and patch upgrades.
Responsible for deployment of database changes submitted by the database development team. Highlighted Projects:
Teradata iODS Project - Piloted development and support for a hybrid OLTP/DSS on New Generation Intelligent Network. Integration of Smart buddy, Talk and Text, Red Mobile, PLDT Landline Plus, Smartbro services in one logging platform that is used for data mining and business intelligence analysis. Phase I includes Smartalk and Smartalk Plus unlimited promo transaction logs. Smart’s first implementation of Communications Logical Data Model.
Datawarehouse Proof of Concept - Evaluated a hybrid solution that would cater oltp and decision support systems. Oracle Exadata proof of concept held in Singapore. Greenplum and HP Neoview held in the San Mateo and Cupertino, CA respectively and Teradata held in the San Diego, CA and Philippines.
SmartMoney 11g Implementation - Smart’s first implementation of 11g RAC for in house development of SmartMoney application.
Greenplum Service Development / Production Support - A data-warehousing solution to provide historical data for mining and Analytics.
Navitaire International, LLC
Position Title : Software QA Engineer
Specialization : IT/Computer - Software
Industry : Aviation / Airline
Duration : Oct 2006 - Aug 2007
Involved in monthly software projects being deployed to international airline clients.
Responsible for verifying adherence to software quality standards.
Ensures the enforcement of software change and specifications with respect to correct system's process.
Geneva Airline Optimization Suite development.
EDUCATION AND CREDENTIALS
BS in Information Technology, Mapua Institute of Technology, 2004 o Academic Scholar 2003 / 2004
Teradata 12 Certified Professional, 2011
JPMorgan Chase & Co. – E2 ®: Expert Engineer Alumni o Jun. 2015 – Columbus, OH
o Oct. 2015 – London, UK
o Mar. 2016 – Brooklyn, NY
Teradata Factory, Makati City, November 2010
Teradata Advanced SQL, November 2010
Teradata Star-Schema Designs, Makati City, November 2010
Teradata Tools and Utilities, Makati City, November 2010
Introduction to Data Modeling, Makati City, November 2010
Introduction to Logical Data Modeling, Makati City, October 2010
Industry Asset Overview: LDMs, BIOs, BIMs and the EDWr, Makati City, October 2010
Oracle DBA round table, Disaster Recovery 11g, Makati City, August 2010
IBM Cloud Computing & Virtualization, Makati City, July 2010
IP Fundamentals, Makati City, July 2010
Intro to Teradata Database, Makati City, October 2009
Teradata SQL, Makati City, October 2009
Teradata Physical Database Design, Mandaluyong City, October 2009
Teradata Parallel Transporter, Mandaluyong City, October 2009
Oracle10g: PL/ SQL Fundamentals, Makati City, January 2009
Oracle10g: Database Performance Tuning, Makati City, August 2008
Oracle9i: Database Administration Fundamentals II, Makati City, September 2007
Oracle9i: Database Administration Fundamentals I, Makati City August 2007 SOFT SKILL TRAININGS
Customers, Conflict and Confrontation, Makati City, February 2011
Essentials of External Consulting, Makati City, January 2011
Effective Presentation Delivery, Makati City, December 2010
Communicating for Results, Makati City, December 2010
Enhancing Listening Skills, Makati City, November 2010
Planning an Effective Business Meeting, Makati City, November 2010
Leading an Effective Business Meeting, Makati City, October 2010
Business Writing: How to Write Clearly and Concisely, Makati City, October 2010
Communicating with Impact, Makati City, July 2010
Team Leaders Development Program & Service Excellence, Makati City, September 2009
Knowledge Management (people, process and platforms), Makati City, July 2009