Roy Magtibay

Manila, Philippines

ac93fe@r.postjobfree.com

ac93fe@r.postjobfree.com

+639*********

PROFILE

Roy has more than 12 years of IT experience, working primarily on technologies such as Teradata Tools and Utilities, Teradata GCFR Framework, SAS DI, Informatica PowerCenter, Cognos Framework, Sybase IQ, Oracle, COBOL, Control-M, and UNIX shell scripting.

Roy possesses deep technical knowledge and consulting capabilities in Data Warehousing, ETL/ELT Design and Development, Testing, Systems Analysis as well as general business knowledge on several industries such as Financial Services, Tele-Communications, and Healthcare Services. He also possesses a good communication and analytical skills necessary in addressing technical issues and delivering proper and most desirable solutions to the client.

KEY SKILLS & TECHNOLOGIES

SKILLS

ETL/ELT Design and Development

Systems Analysis

Communication and analytical skills

Team Leading

Mentoring

TECHNOLOGIES

Teradata SQL, SQLPlus/PLSQL, Teradata Tools and Utilities, GCFR, Informatica PowerCenter, SAS DI, LINUX / UNIX Shell scripting, CONTROL-M, Oracle RDBMS, COGNOS, HP ALM, IBM TSRM, COBOL, Python, Microsoft Office.

PROFESSIONAL

EXPERIENCE

ETL Lead / Technical Consultant in a Large Financial and Banking Company, January 2015 to March 2019

Recently assigned as Technical Lead in Singapore with more than ten dev team members reporting from offshore.

Working as an ETL Technical Consultant with experience in several projects for a large international bank.

Lead in developing codes using Teradata GCFR Framework, following coding standards and best practices.

Doing impact analysis across systems.

Supporting to resolve issues encountered by SIT testers and UAT users.

Key resource in Control-M development.

Exhibit skills in UNIX scripting to help automate tasks.

Create code packages, tests packages and help to prepare code packages for Test and Production implementations.

Supports Production Implementations.

ETL L3 Production Support Lead in a Large Healthcare Company, August 2013 – December 2014

Addressed daily incidents reported by production control team

Did fast-tracked development and implementation of permanent fixes for code bugs in production.

Addressed in timely manner ad-hoc tasks requested by business users.

Monitored the status of offshore deliverables scheduled for release and communicate the same to onshore.

Created SDLC documentations per release processes to ensure all the required Release documents are ready and reviewed prior to implementation.

Represent Development Team during Client Reviews of Release deliverables.

Systems Analyst in a Large Telecommunication Company, November 2009- July 2013

Roy was once an ETL QA Test Engineer and subsequently became a Systems Analyst in a Telecomm Company’s Business Intelligence and Mobile Commerce Unit.

He was a data warehouse Systems Analyst leading various in-house projects involving business requirements gathering, data discovery, functional requirements, applications development, reports development, and an L3 BAU production support.

Became SME of Legacy Data Warehouse and responsible to assist business users in data consumption for strategic planning and participating in newly developed EDW program.

Develop ad-hoc UNIX scripts to create ad-hoc reports to meet the need of business users.

Ensures that quality and availability of data are maintained in EDW.

Works in close liaison with different teams, internal and external partners, in in-house projects and program roll-outs.

Work closely with BI Analytics team in drilling through data from EDW to come up with correct and clean reports as per higher management’s direction.

COBOL Programmer for Large Bank Companies, January 2007- October 2009

Roy’s project engagement included customization and development of Core Banking System product to cater the business needs of the client bank.

Developed and customize new functionalities as enhancement over core banking solution (BaNCS) base version as per client’s requirement.

Exhibit exemplary performance in SIT, UAT and Production support through application of company's best practices in fixing defects.

Gained knowledge in consumer banking industry retail products such as Deposits, Loans, Contingents, and Trade Finance.

WORK HISTORY

ETL Technical Consultant in Teradata, Manila, (2015 – Present)

Staff Application Developer Teradata in IBM Solutions Delivery, (2013 - 2014)

Systems Analyst in Globe Telecom, (2010-2013)

COBOL Programmer in Software Laboratories Inc. / Tata Consultancy Services / United Coconut Planters Bank, (2007-2009).

EDUCATION

BS Computer Engineering, (2006)

AMA Computer University, Philippines

Contact this candidate