Software Developer Service

Gerardlouie M. Bal

Address: Unit *E, Ibiza Tower, Circulo Verde Condominium, Calle Industria, Quezon City, Philippines

Mobile: +639*********

E-mail: *******@*****.***

To have an opportunity to work for a company that offers diverse challenges and good working environment.

Company : Canon Business Service Centre

Location : BGC Taguig, Philippines

Position : Reports and Database Engineer

Duration : June 2016 – Present

Description : Canon Business Service Centre is an innovative company leading the charge to deliver quality Cloud Computing, Infrastructure Service and Service Desk.

Roles and Responsibilities:

• Develop and maintain client reports thru various reporting tools.

• Configures ETL processes and Dashboards to provide accurate business intelligence.

• Responsible in maintaining Data Warehouse.

• Performs analysis and investigation to fix issues and optimize data gathering to provide quality information.

• Adheres to Incident and Change Management procedures to meet SLAs and high system reliability.

Technical Skills: T-SQL (views, stored procedures, joins), SQL Server 2012/2014/2016/2017, SSRS, SSIS, SSAS, RDBMS, Data Modeling, Crystal Reports, Power BI (DAX, Measures, Power Query), Kaseya, BMC, Microsoft SCOM, Service Now, Powershell scripting, Visual Studio, SQL Management Studio

Company : Macquarie Financial Group

Location : Makati, Philippines

Position : Senior Application Support Analyst

Duration : November 2014 – May 2016

Description : Global provider of banking, financial, advisory, investment and funds management services.

Roles and Responsibilities:

• Provides daily operational support for several applications by troubleshooting incidents to identify root causes and solutions.

• Performs coding, unit testing and/or system configuration changes to resolve defects and/or develop new enhancements, utilizing standard procedures and techniques.

• Adheres to Incident and Change Management procedures to meet application SLAs and high system reliability (e.g. utilizes Remedy tools).

• Develops and maintains business and/or technical support documentation.

• Assisting with process improvements, system integration and BCP efforts.

• Create and modify reports based on client specifications.

• Proactively monitor system health and respond to alerts to provide high availability and performance of the application.

• Work closely with peers at other geographic centre around the world.

Technical Skills: SQL scripting, Sybase, DB2, ORACLE, UNIX, WinSCP, Infoview (Reporting tool), Remedy, Confluence.

Company : Manhattan Associates Software Pte. Ltd.

Location : Singapore

Position : Application Consultant

Duration : May 2012 – April 2014

Description : Manhattan designs, builds and delivers market-leading Supply Chain Commerce solutions for its customers around the world.

Roles and Responsibilities:

WMS implementation from requirements gathering, design, configuration, testing, go live support and user training.

Troubleshoot issues to provide short and long-term resolution to project issues.

Provide detailed functional and technical specifications for application modifications, enhancements, and new projects.

Develop and customize reports based on client specifications thru Crystal Reports, SSRS, and COGNOS.

Projects Handled:

1.CHANEL sites in Hong Kong and Singapore: One of the leading global fashion brands.

2.RedMart.com: A Singapore-based online grocer.

3.ASTRA Otoparts: Indonesia’s automotive component company producing and distributing spare parts for both two wheelers and four wheelers.

4.Thai Beverage (“ThaiBev”): Thailand's largest and one of Southeast Asia's largest beverage companies.

5.Lam Soon Edible Oils: Recognized as a major Fast Moving Consumer Goods (FMCG) player in South East Asia.

Technical Skills: SQL Server 2005/2008/2012, ORACLE9i, Crystal Reports 2008/XI, SSRS, IBM COGNOS, Salesforce, Windows Server 2003/2008/2012 R2, and IIS v6.0

Company : DHL Supply Chain Pte. Ltd.

Location : Singapore

Position : Senior Application Support Analyst

Duration : April 2010 – March 2012

Description : Information Systems – Logistic Supply Chain Systems

Roles and Responsibilities:

Provide L2 support for WMS applications.

Develop and customize reports based on client specifications thru Crystal Reports

Identify, troubleshoot and resolve software issues reported by clients within established SLA guidelines.

Perform root cause analysis and provide long-term resolution to application issues.

Initiate creation of defect report for application bugs and escalate to appropriate personnel.

Carry out changes to production changes as required.

Deliver exceptional customer service to clients by proactively communicating progress with support cases and ensuring correct prioritization and timely resolution of reported issues.

Projects Handled:

1.WMS (WM100i) Module: Web based Warehouse Management System (WMS). Runs on SQL Server 2005 database.

2.WMS (WM300i) Module: Windows based WMS developed by Manhattan Associates (Currently know as Manhattan SCALE). Runs on SQL Server 2005 database.

3.WMOS (WM500i) Module: Web based WMS by developed by Manhattan Associates (Currently know as Manhattan WMOS). Runs on Oracle 9i database.

Technical Skills: SQL Server 2005, ORACLE9i, Crystal Reports 2008, Windows Server 2003, UNIX, ASP.net, Remedy, and IIS v6.0.

Company : INDRA Inc.

Location : Philippines

Position : Software Developer

Duration : July 2006 – February 2010

Description : Information Systems - Logistic Systems

Roles and Responsibilities:

Perform application design, coding, testing, and documentation according to ISO standards.

Create extracts for client reports

Provide 24x7 on-call support to handle batch processes report extracts, data backup, etc.

Prepare test data to verify accuracy and completeness of systems.

Conduct code review and debug program errors.

Prepare documentation, procedures, and operating instructions.

Project Handled:

MERALCO IS – LS (Information Systems - Logistic Systems) The project’s role is to automate MERALCO’s procurement activities – from the initial request of the Requisitioning Offices, to the bidding and awarding of purchase orders, until the processing of payments from Finance.

Technical Skills: Mainframe using Software AG Natural, ADABAS, JCL, COBOL, Powerbuilder, and Remedy.

Expertise:

Crystal Report, SSRS report development

SQL Scripting and Database Administration

Application Analysis

Software Development Life Cycle (SDLC)

Financial Systems

Logistics Systems / Warehouse Management Systems

Software:

Applications

Programming Languages

Database

Crystal Reports 2008 and XI

SQL development (views, stored procedures, other sql scripts)

SQL Server 2005/2008/2012

SQL Management Studio, SSRS, SSIS

UNIX

ORACLE 9i

IBM Cognos

COBOL

ADABAS

Warehouse Management System

NATURAL

SYBASE

DBArtisan

JCL

DB2

AQT

Powerbuilder 10

WinSCP

ASP.net

MS Outlook, Word, Excel, and Powerpoint

C++

Visio

HTML

Software AG Mainframe

Salesforce and Remedy

Servers: UNIX, Windows Server 2003/2012 R2

Operating Systems: UNIX, Windows 95/98/2000/XP/7

College (2001-2005) : B.S. Computer Engineering

MAPUA Institute of Technology

Intramuros, Manila, Philippines

High School (1997-2001) : Claret School of Quezon City

Teacher’s Village, U.P. Diliman Quezon City

Elementary (1994-1997) : The Seed Montessori School

Zuzuaregi St.,Don Antonio Village, Commonwelt Quezon City

Date of Birth : March 25, 1984

Place of Birth : Manila, Philippines

Citizenship : Filipino

Status : Single

Languages : English, Tagalog

Objective

Work Profile

Summary of Qualifications

Education Details

Personal Data

Contact this candidate