USIGAN, RICHARD, R.

Blk-* Lot-* Kalusugan St. Franville V Caloocan City

Mobile# 090********

ade2rb@r.postjobfree.com

Qualifications

Solutions-focused, team oriented, had a technical skill in Talend/Visual Basic/QlikView/C#.NET technologies and QMC Server management with broad-based experience and hands-on skill in the successful implementation and develop of highly effective automation and technical support solution. Proven ability to successfully develop a tool in an organization's critical support requirements, identify deficiencies and potential opportunities, and develop innovative solutions for increasing reliability and improving productivity

Technical Skills

Quality Assurance Testing using Jira, Confluence and MSSQL

Talend Data migration/Bigdata Tool

Linux command and shell scripting, RDP, System Acceptance Testing, Oracle, MySQL (Present)

C#.NET, QlikView,Visual Basic 6, VBA Macro,SAP Scripting, Web Automation, Data Conversion and Migration,Accounting Tool Automation, and VB.Net

Application auditor in QlikView

Ticket management

Knowledgeable in (PHP,C#.Net,ASP.Net,Jscript.VbScript,HTML,Notepad++)

Database (MSAccess, MSSQL 200*-****-****, Create Store Proc, PostgreSQL, Redshift AWS, Oracle)

Server Admin (QlikView Management Console)

Talend ETL tool, Data Migration, Talend Administration Center

Data warehouse

ETL

Trainings

BIG DATA SCHOOL

scrum master training

agile foundation

talend foundation

Professional Experience

Data Engineering Specialist

(Accenture INC.)

July 26, 2018 – Present

Jira

Confulence

mssql

MySQL

Oracel

Postgresql

ETL Talend

putty-linux scripting

talend administration center (tac) support

data migration

2017Jan – July 26, 2018

Applications Development Developer III

(TELUS INTERNATIONAL PHILIPPINES)

2017Jan – July 26, 2018

ETL Data Modeler

QlikView Developer

BigQuery

CloudSQL

Data Staging

Talend Developer

Star Schema

Support of Ticket Management

Maintenance and Setup in Section Access

Reload monitoring of QlikView Management Console

QlikView Trouble-shooting

Project Enhancement

Documentation(CMR, Users Story, UAT)

Projects

Current Project: Sales Opportunity Dashboard

Description: This project will create approximately 72 yearly hours in reporting efficiency savings and provide the ability to show historical and future information in regards to TI business opportunities

Process: This project is ETL project that extracted data from SalesForce thru Talend(ETL Tool) and the data will process and upload it in Google Cloud Platform Server(GCP). This data will get by QlikView and save it in QVDs and create again the Data Model.

Project Name: Supercell

Description: Supercell is CRM data has 2 kinds of tables which is the Daily Created Ticket and Daily Ticket Response and need to have a BI reporting tool.

Process: Extract CVS file data from Google Email using Qlik Web Connectors API and save it in QVDs and make ETL process to have Data Model

Project Name: Kaseya POC integrating PM.com (Enhancement)

Description: Kaseya POC is a project that contains ticket resolutions and monitoring per department and computes the total work hours per projects, per task per resources using PM.com

Process: Combining the existing tool of Kaseya POC tool and PM.com

Daily Duties:

Daily reporting in DWH - Daily Stand up thru Google Hangout

Tools:

BI Tools : QlikView, Talend

Server: QMC and GCP

Database: Access, MSSQL, MySQL

Programing Skills: VBA, VB.Net(Window), C#.Net(Window), VB6, QlikView, Scripting

Knowledgeable in (PHP,C#.Net,ASP.Net,Jscript.VbScript,HTML,Notepad++)

Business Intelligence Developer

(Sunpower philippines ltd.)

2014may – 2016 Dec

C#.NET windows application

QlikView Developer

Server Admin of QlikView Management Console

Support of Ticket Management

Maintenance and Setup in Section Access

Reload monitoring of QlikView Management Console

QlikView Trouble-shooting

Report migration - App Audit

Visual Basic Application Developer

Documentation

Visual Basic DEVELOPER (IBM Philippines)

2011 – 2014 May

IT Consultant (6/2011- - 5/2014)

Under by Aspire IT, Deployed in IBM Philippines

Create AutoMailer in Lotus Notes and Outlook, Consolidation tool, Forecasting tool, SAP Scripting, PDF conversion, Create Automation in Retail and Dispute Management, Fix Asset, Blocked Invoice,Upload data from PDF to SAP, Data conversion and Migration, Internet Downloader tool, Payroll computation tool, Benefits computation tool, Document Clipping, Tax wire Discrepancy report tool, etc., IT support, Users Manual and documentation.

VB Programmer (Nov/2010 -May/2011)

Sysbit Jakarta

Support Jakarta POS using ISS in 900 stores, Create 3rd party program for Mango and Zara stores, Create ISS security password creator program in server. Implement ISS in Malaysia and Singapore Golf Store.

Visual Basic DEVELOPER (IBM Philippines)

IT Consultant (12/2009- - 11/2010)

Under by Aspire IT, Deployed in IBM Philippines

Create AutoMailer in Lotus Notes and Outlook, Consolidation tool, Forecasting tool per region, SAP Scripting, PDF conversion, IT support, Users Manual and documentation.

Quality Assurance (7/2009- 11/2009)

I.T. Manager Inc. (Client: Hewllet Packard Philippines)

Codes, test, documentation and support the RAMP Project and PAT(Portfolio Analyzer Tool) Project using the Unit Test Case and documentation of the project.

VB.Net Programmer (2/2009- 6/2009)

Planet Sport Inc.

Support, develop, documentation, server maintenance, data consolidation, create stored proc. And database maintenance.

IT Consultant (8/2008- 1/2009)

Prime Tech Inc. (Client: Aboitiz 2 GO)

Create automation, conduct training/demo, test and codes. TAME (Tequila Automatic Macro Extraction) Accounting Tool. This is the Web base automation.

IT Consultant (8/2007- 7/2008)

Information Professional Inc. (Client P&G and Colgate Palmolive)

Support SAP data, create Management tools for GDM Department on P&G

Create monthly and daily sales template report

Junior Programmer (1/2007- 7/2007)

Core Application Service Inc.

Support accounting system

Education

Bachelor of Science in Information Technology

Polytechnic University of the Philippines (Commonwealth Campus) 2002 - 2006

Contact this candidate