Software Engineer

NINO MICHAEL P. MERCADO

SUMMARY

Over a decade of Information Systems experience involving Systems Analysis, Application Development, Production Support and Operations.

EDUCATION

Bachelor of Science in Computer Science, 1998-2002

De La Salle University - Dasmarinas

Dasmarinas, Cavite, Philippines 4114

SKILLS

ETL and Automated Workflow Programming

SQL, PL/SQL Programming

Secure File Transfer and Encryption Protocols

Batch Scripting (Unix shell, Windows batch scripts)

Analysis and Support on Software Applications and Database

Document Template Programming

Bank Back-Office Operations and Support

Reconciliations Technology Support

Applications Manual Documentation

Incident and Change Management

Applications/ Technologies Used:

Opentext Cloud Managed Services Oracle (Toad, SQL Developer)

Pittney Bowes DOC1 Designer MS SQL Server

Fiserv Accurate Reconciliation Extensible Markup Language (XML)

CA7 Scheduler Paradox

Opalis and Sagent Automation Visual Studio

Talend Open Studio UNIX Scripting

Pentaho Data Integration (Kettle) CA Service Desk Manager, IBM Rational, Accurev, JIRA

Sagent Design Studio Snowflake database

WORK EXPERIENCE

Senior Software Engineer (September 2020 –Present)

Safeway Philtech Inc. through IT Managers Inc.

22F Bonifacio Stop Over, 31st Street, BGC Taguig, Philippines 1634

Automate system tasks in Shell scripts and Snowflake database

Create test plan and provide results for script review and deployment

Senior Systems Integrator (April 2017 –June 2020)

Opentext Philippines Inc.

31/F, Tower 2 RCBC Plaza, 6819 Ayala Ave. Makati City, Philippines 1200

Setup Clients/ partners connectivity

Ensure file routing of inbound/outbound files are routed and translated correctly

Deliver mapping configuration and implementation requests for Opentext Managed Services system

Design, develop, test and support UNIX scripts used in maps integration

Guide and mentor fellow integrators on service best practices and technical efficiencies

Analyse non-standard and large implementation jobs for technical feasibility and effort estimates

Lead and participate on integration support tasks during Client Acceptance Testing activities

Provide 3rd level support to Managed Services map and Trading Partner/ Client integration issues

Permanent night-shift (US Eastern time zone)

IT Consultant - UNIX Developer (March 2016 –March 2017)

Safeway Philtech Inc. through Information Professionals Inc.

22F Bonifacio Stop Over, 31st Street, BGC Taguig, Philippines 1634

Plan, assign and supervise daily system migration activities

Investigate and provide fixes on conversion issues

Design application modules / system based on user requirements and specifications

Develop file structures, interfaces, programs and reports specifications

Prepare test, conversion and implementation plans for approval of the immediate supervisor

Provide support and technical assistance to users of application system

Maintain system documentation / manuals for application systems

Recommends improvements to existing procedures to maximize effectiveness and efficiency

Shift work covering Asian and European time zones

IT Analyst and Batch Support (November 2012 – October 2015)

TD Securities – The Toronto Dominion Bank

1 Temasek Avenue, #15-02 Millenia Tower, Singapore 039192

Support and monitor Reconciliations (Fiserv), KYC (Goldtier), Business Intelligence and Reporting platforms

Support Paradox-based applications such as Correspondent Bank Report Analysis (COBRA) and Export/ Import Bills (EXIMBILLS)

Issue escalations (SDM) to various technology or source groups from within or outside the bank

Ensure customer communications are in place in the event of application issues such as batch failures or missing feeds

Driving issues from identification to resolution and ensuring they are properly logged, communicated and resolved within Service Level Agreement (SLA)

Identify recurring issues through weekly and monthly reports and escalating them for resolution

Achievements:

Successfully transferred and solely handled Reconciliations Technology overnight support from Toronto, Canada to Singapore in January 2013

Developed batch scripts and Excel dashboard to consistently monitor application feeds by April 2013

Onboarded KYC-Goldtier and ETL for Cognos batch support respectively from May and September 2014

Systems Analyst and ETL Programmer (March 2012 – November 2012)

Singapore Institute of Management through Renaissance Solutions Pte Ltd

461 Clementi Road Singapore 599491

Participate on Data Conversion activities

Data Profiling and Cleansing using SQL Developer and Talend Open Studio for Data Quality

Data Extraction using Pentaho Data Integration tool (Kettle)

Data Handling of Lecturer and Student Basic Information, Grades and Insurance records

Oracle SQL and Document Developer (January 2010 – March 2012)

NTUC Income through Recruit Express Pte Ltd

75 Bras Basah Road Singapore 189557

Programming and Data Mapping of Letter and Policy Documents (XML, DOC1 Designer)

Development of Automated Workflow (Sagent) jobs and ETL (Design Studio) plans for Documents generation and Archival

Planning and execution of Production job recoveries

Participation on Automation job conversion and testing from Sagent to Opalis

Research and Development duties for various projects

Perform production job monitoring duties to ensure Document generation is complete and archived

Achievements:

Enhanced and Deployed letters for Re-languaging and General Insurance upgrade projects in June 2010

Complete re-design of Automation jobs in December 2011

Application Consultant (April 2009 – November 2009)

National Computer Systems Pte Ltd (NCS) through PGI Infotech Pte Ltd

5 Ang Mo Kio Street 62 Singapore 569141

Understanding data mapping to SAP HR from Legacy HR Systems

Transforming data conversion rules into PL/SQL Scripts

Participate in daily running of ETL and PL/SQL Scripts for SAP Data loading

Resolving Data issues by data mapping and/ or script changes

Functional and Data Verification in SAP HR

Liaise with developers, system administrators and managers on issue fixes and system requests

Maintain database tables for extraction from legacy systems

Achievement:

Successfully migrated Legacy data to SAP eHR system by November 2009

Technical Analyst and Support (March 2008-March 2009)

Ascade Asia Pacific Pte Ltd

50 Kallang Avenue, #06-06A Singapore 339505

Carrier Cockpit Technical Support for global clients - BSS/OSS, Interconnect Billing, Routing

Software issue investigation through Program code and Trace files

Providing issue fixes using Oracle PL/SQL, VB.net, Java or XML

Working with system developers and project managers to ensure system fixes

Installation of Carrier Cockpit system and corresponding licenses

Issue fix testing prior to Service Pack release or installation

Maintaining customer build stream (System Core and Customer specific objects) using Accurev

Working in shifts covering Asian and European time zones

Achievement:

Migrated European customers under Sweden support team to Singapore Global Support by June 2008

Software Development Analyst (March 2007-March 2008)

Smart Communications Inc.

Convergent Platforms Group, SMART Tower, 6799 Ayala Avenue Makati City, Philippines 1226

Development and modification of Unix shell scripts, Oracle PL/SQL Stored procedures and packages

Working with Java developers in integrating Java and Oracle procedures

Preparation of Unit test scripts, production deployment list and Run-guides

Production issue/s investigation and debugging

Projects primarily consists of subscriber promos for Financial, Media and Value-added services

Midnight System deployment

Achievement:

Developed and deployed multiple Financial, Media and Value-added services

Systems Analyst and Programmer (March 2004 – March 2007)

UnionBank of the Philippines

142 Amorsolo St., Legaspi Village, Makati City, Philippines 1229

Software planning and development

Oracle PL/SQL, SQL for Trade Finance system

Globus Trade Finance system

ObjectPal and SQL in the Paradox 7 environment for E-Payroll System

Visual Basic 6 and SQL for Checks Inventory system

Systems user support

Project Documentation

Achievement:

Solely supported E-Payroll system using Paradox7 from March 2004 to December 2006

RPG IV Junior Programmer (September 2003 – February 2004)

Sara Lee Philippines – Intimate Apparel Division

Information Technology Department

Mamplasan, Binan, Laguna, Philippines 4024

Systems upgrading and development using RPG III and IV, Control Language in AS/ 400 environment

Generation of system user’s guide

Achievement:

Completed RPG AS400 training by November 2003

Administration Staff (January 2003 – June 2003)

De La Salle University – Dasmarinas

Office of the Registrar, Dasmarinas, Cavite, Philippines 4114

Encoding of pre-registration of students to the university database.

Validating of identification cards for summer enrolees.

Conducting of room-to-room evaluation for faculty members.

Tallying of daily faculty evaluation results.

Data Specialist (October 2002 - December 2002)

SPI Technologies Inc.

Content Sciences Inc.-Library Services Division, Sto. Nino, Paranaque City, Philippines 1704

Responsibilities:

Data validation and encoding

Data quality review

TRAININGS

Reconciliations Technology (November – December 2012)

Opalis 6.3 (October 2011)

Sagent Automation, Design Studio, DOC1 Designer (January - February 2010)

Carrier Cockpit (March – June 2008)

PERSONAL PARTICULARS

Philippines Address: Blk 9 Lot 2 Austria St Adelina 2A Pacita Complex Brgy San Francisco Binan Laguna

Contact Numbers: +63-949-***-**** / +63-2-8356 9802

Email: adi02g@r.postjobfree.com

ADDITIONAL INFORMATION

Date of Birth: 10 November 1981

Civil Status: Married

Nationality: Filipino

LinkedIn profile: www.linkedin.com/in/ninomercado

SkillSelect EOI ID: E0007559844

ACS Ref. no:1351944

Express Entry profile number: E000298744

Job Seeker validation code: 9019

References

Relation

Country

Contact Email

Al Jeffrey Lacambra

Mate – Secondary School

Philippines

adi02g@r.postjobfree.com

Benjamin Magtoto

Colleague - Unionbank

Philippines

adi02g@r.postjobfree.com

Jesser Bayot

Mate - University

Singapore

adi02g@r.postjobfree.com

Contact this candidate