Developer Data
Resume:
USIGAN, RICHARD, R.
Blk-* Lot-* Kalusugan St. Franville V Caloocan City
Mobile# 090********
***************@*****.***
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