ETL / SQL Developer

Van Edward G. Petate

**** ****** *** *** **, Canoga Park, CA 91303

Phone No.: 818-***-**** Email: *********@*****.***

CAREER SUMMARY

Solution driven developer with 7+ years of in-depth exposure in developing custom solutions, maintaining and enhancing existing business processes. Well versed and experienced in all phases of software development life cycle and a critical thinker.

QUALIFICATIONS / SKILL SET

Oracle PL-SQL

Unix

JavaScript

Unix Shell Script

SDLC

Tuning

Java

Toad

SFTP

VB.NET

CTRL-M

VB Classic

MS TSQL

Informatica

MS Access

RELEVANT EXPERIENCE

2017 – Present CALIFORNIA HOME BUILDERS (CHB) Canoga Park, CA 91303, USA

Position: IT Specialist

-Manage and support all aspect of IT operations

-Provide strategic IT infrastructure & Software direction for the company

-Maintenance and modification of their existing system using RAD platform Alpha Five (xbasic)

-O365 exchange management

-Network and AD Management

2013 - 2017 INTERNATIONAL BUSINESS MACHINE (IBM) Quezon City, Philippines

Position: Application Developer: Oracle

Client / Project: Sprint US, Logistics Planning Team – Production Support

-Handled and supported for 6GL and I2S and JDA systems

-Monitored nightly job process via CTRL-M

-Handled, processed and executed 6GL’s inbound and outbound data to/from various system (PLSQL & Unix Shell Scripts)

-Handled, Supported and Debugged I2S, JDA and 6GL’s nightly batch job failures and issues, proposes fixes and documents persisting issues (Informatica, PLSQL & Unix Shell Script)

-Coordinates with neighbor system to ensure timely and proper execution of our nightly batch jobs.

-Led offshore team, worked closely to assist offshore colleagues and provide knowledge on “hows to” work on things

-Plans offshore Team’s work schedule rotation and weekend on-call delegations

-Creates weekly Report for Offshore Team’s Accomplishment

2010 – 2013 WESUPPORT INCORPORATED Makati City, Philippines

Position: Project Programmer

Client / Project: Philippine Long Distance Telephone (PLDT), IT - Home: Reports Team

-Handled and Supported PLDT’s Billing system (Kenan)

-Provided support for existing PLSQL packages, SP, function and UNIX shell scripts by participating on investigation and analysis to ensure data integrity of the system

-Developed ETL process to cater inbound and outbound file synchs from Kenan to neighbor systems using, UNIX scripts, external tables, SQLLoader and PLSQL, DBMS_scheduler, UNIX cron, FTP, SFTP

-Developed cron-java reports to generate excel-formatted reports for end-users

-Developed, modified, debugged and maintained PL/SQL packages, stored procedure, functions, triggers

-Provided tuning and optimization by rewriting and adding hints to existing SQL Queries by examining explain plan (via TOAD) to improve the system’s performance.

-Participated in various Data Migration / Synchronization for newly implemented systems and processes

EDUCATIONAL BACKGROUND

BS in COMPUTER SCIENCE AND INFORMATION SYSTEM

Centro Escolar University, Manila, Philippines 2006 – 2010

REFERENCES

Available upon request.

California Home Builders (CHB) 2018 - present

Position : IT Specialist

Alpha Five – A RAD platform which CHB’s Project Management System is built upon

Task

Development

Description

Pushed around 40 various enhancement ranging from form update, crystal

report, database corruption recovery

Technologies

Alpha Five, XBasic

IT Management

Task

Technology Implementation and Maintenance

Description

Oversee deployment and maintenance of a various technology (Software &

Hardware) AP, Switch, Server, Workstation, Printer, MFP, o365 + Exchange, Active Directory, Plangrid, Connectwise, QuickBooks, Submaster

Technologies

Alpha Five, XBasic

International Business Machines (IBM), Philippines

2014 - 2017

Collabera

2013 - 2014

Client : Sprint Nextel Corporation US

Position : Oracle Application Developer

JDA Batch Processes Support

Task

Production Support

Description

Provided support on JDA Nightly Batch Processes. Handles issues and

anomalies, Provides fix and documents for future references

Led offshore team, worked closely to assist offshore colleagues and

provide knowledge on “hows to” work on things

Led the offshore team on Knowledge and Tasks Transfer on weekly scrubs assisting them on parts they were not able to grasp

Plans offshore Team’s work schedule rotation and weekend on-call delegations

Creates weekly Report for Offshore Team’s Accomplishment for Onshores’ Review

Technologies

PL-SQL, Unix, FTP, Informatica, SM7, CTRL-M

I2 Batch Processes Support

Task

Production Support

Description

Provided support on JDA Nightly Batch Processes. Handles issues and

anomalies, Break- fix and documents for future references Records run times to trace slow processes

Technologies

PL-SQL, Unix, FTP, Informatica

MDS Batch Processes Support

Task

Production Support

Description

Supported MDS Nightly Batch Processes. Handles issues and anomalies. Break-

fix and documents for future references

Technologies

PL-SQL, Unix Shell Scripting, FTP, Informatica

MDS Synchronization

Task

Execution

Description

Executes synchronization of data from Production to lower environment, DB

Links are not permitted so have to use MS Access as an alternative to bash Production Table to Test. Results are extracted as input file for MDS System, once completed files are FTPed to external systems

Technologies

MS Access, PL-SQL, Unix Shell Scripting, FTP

We Support Incorporated, Philippines

2011-2013

Client : Philippine Long Distance Telephone (PLDT)

Position : Project Programmer

Address Synchronizer

Task

Support and Development

Description

Provided support for all address synchronization related issues and activities.

Investigates fallout records, provides fix then reinitiates data loading Enhances SP and shell scripts to cater business process changes

Technologies

PL-SQL, SP, Function, External Table, DBLinks, Unix Shell Scripting, Unix Cron,

Unix Grep,

DSQL (Dynamic SQL) - In-house developed process of extracting synch files FTPed to external Systems or network folders

Task

Support and Development (Enhancement)

Description

Fixes issues, failure and anomalies to ensures all daily, weekly and monthly extraction completes on-time.

Guides to colleagues on how to use this process

Creates new set of reports extraction directed to other systems

Identifies under-performing SQLs and formulates tuning and optimization

Added a module that monitors and notifies executives on the execution of critical extracts (esp Datawarehouse-bound extracts)

Technologies

DBMS_SCHEDULE, FTP, Explain Plan, SQL Tuning, Unix Grep, Unix mailx

DSQL SQL Optimization

Task

Development (Enhancement)

Description

There came a time where daily scripts had a bottleneck and big extracts ran 18hrs (some run over 24) and significantly affecting front-end users, Investigated and rewritten multiple SQL queries. Successfully reduced various SQLs execution time from 2-3 hours.

Technologies

SQL Hinting, Explain Plan, Tuning

NPA (Non-Paying Accounts)

Task

Development (Project)

Description

Developed a cron-java(jar) process that reformats a flat-file (csv) report of NPA

to an excel-formatted report, report is chopped per market zones, a separate report is for call-out which is the FTPed to a network directory for end-user’s consumption.

Technologies

Java, Unix Shell Scripting, Unix Cron, FTP

Collection To Go & Month To Date Report

Task

Development (Project)

Description

Developed an automated process that extracts monthly & month-to-date

collections total and report to excel with embedded formulas. The extract is FTPed to Finance Department their review.

Technologies

Java, PL-SQL, Unix Shell Scripting, Unix Cron, FTP

Bilis Komisyon (Quick Commission)

Task

Development (Project)

Description

Developed an automated process that generates report to track and pay sales

agents who sold Bilis Komisyon-type products. Half of the commission will be given immediately (daily run). The remaining half would then be given after the account’s 3rd successful billing (weekly run).

Technologies

PL-SQL, Unix Shell Scripting, Unix Cron, FTP

OFW Commission

Task

Development (Project)

Description

Developed an automated process which generates pipe-delimited file reports

to track and pay sales agents able to sell OFW Packages products.

Technologies

PL-SQL, Unix Shell Scripting

Welcome Letter

Task

Development (Project)

Description

Configured a DSQL-housed report of newly subscribed accounts to trigger a

generation of a welcome letter which will be included on their first Statement of Account (SOA)

Technologies

PL-SQL, FTP

Text blast

Task

Development (Project)

Description

Developed an automated process which generates a report of all subscriber

with their email contacts for Marketing Department subject for email blasting activities

Technologies

PL-SQL, Unix Shell Scripting

Philcom Hybrid PLP Migration

Task

Development and Support

Description

Migrated Philcom’s Prepaid Accounts to KENAN, processed accounts and

reviewed data integrity on KENAN side

Technologies

PL-SQL, Unix Shell Scripting

KENAN - Clarity Migration

Task

Development (Enhancement), Support and Execution

Description

Enhanced existing scripts for KENAN-Clarity cutover migration. Hinted SQLs

and altered some procedures and scripts to add parallelism to significantly improve execution time.

Executed and monitored scripts. Ensured data integrity

Technologies

PL-SQL, Unix Shell Scripting, Explain Plan, Tuning

KENAN - CRM Migration

Task

Development (Project) and Support

Description

Collaborated with CRM Team, to extract scripts needed for their migration.

Technologies

SQL, Unix Shell Scripting

PLDT-Smart Data Capping

Task

Development and Support

Description

Developed an automated snych file extraction and transfer for PLDT’s sister

company SMART to extract list of all subscriber and later on delta extracts, which will SMART use for data capping purposes.

Technologies

PL-SQL, Unix Shell Scripting, SFTP

Contact this candidate