ERNESTO R. GUMPAL JR.

***** ** ***** **. ****, WA, 98031

+1-253-***-**** ac6115@r.postjobfree.com

PROFESSIONAL SUMMARY

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.

SKILLS SUMMARY

Database Technologies

Oracle 9i/10g/11g/12c, Teradata v12/v13, MS SQL Server, MySql, Greenplum (PostgreSQL), Timesten

Database Middlewares

Oracle 12c EM Grid, Oracle Data Integrator, Apex, Toad, Oracle Application Server, Siebel Analytics (OBIEE), Oracle Spatial, BEA Weblogic, IBM Websphere

Programming Languages

PL/SQL, Unix Shell Scripting

Operating Systems

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

WORK EXPERIENCE

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

TECHNICAL TRAININGS

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

+1-253-***-**** ac6115@r.postjobfree.com

Contact this candidate