PROJECT MANAGER
2017, TELEDATA PHILIPPINES INC
Total years of experience :21 years, 5 Months
Deputed to CITIBANK PHILIPPINES
* Managed the build, deployment and relocation of Citibank end-user technology from Makati
Citibank Tower, PBCom and Net Lima Building to the new BGC Citiplaza Building.
* 5, 811 flex seats & 308 Citi Works spaces deployed with end-user technology across 17 floors in
Citiplaza building. 2, 265 desktops, 3, 364 monitors & 1, 441 Avaya phones relocated from CBPS
locations (PBCOM & NETLIMA) to Citiplaza. 496 desktops, 394 monitors, 53 Cisco phones & 51
LifeCam cameras relocated from ROHQ locations (PBCOM, Citisquare & Cititower) and
redeployed across ROHQ floors in Citiplaza.
* Successfully relocated about 5, 500 Citibank employees from various Business Unit that includes
critical unit with complex technical environment and platforms to new Citibank campus.
* Facilitated discussions with Citibank Business Unit managers and senior managers to identify and
analyze business requirements. Provided recommendations and managed user expectations for
smooth delivery of project.
* Led and managed onsite support of Migration vendor, IT and Infra technical team during UAT
and Go Live activity to ensure smooth user migration to new campus.
LEO S. FRESNILLO
IT Business Analyst and Tech Lead in OCBC Bank Information Technology dept performed various roles in Data warehouse and Business Intelligence team to support large projects and BAU tasks
Led collaboration with APAC users, developers and tech infra for scoping, collect business requirements and transform into technical requirements, set priorities and deliver quality BI Report on time across various departments.
Developed Extract, Load and Transformation Program, Batch Automation, Optimization, Data Mapping, Business Requirement Document, Program Specs, Production roll-out plant from small to large projects of OCBC Malaysia, Singapore and China EDW.
Contributed in Design and Build of EDW repositories, Capacity Planning, support and maintenance of Data warehouse/ EDW applications in DEV, SIT, UAT and Production environment.
Led and managed the System integration, Data migration, application installation, upgrade, data access control, tuning and maintenance of OCBC ETL/Business intelligence tools such as ODI, IBM Datastage, Connect Direct, Qlikview in multi-platform environment.
Reduced 80% of OCBC EDW Production Incident Report caused by High scale multiprocessing in Prod servers. Participated in IT Audit and Compliance review, Disaster Recovery and Service Management. Developed and improved the Batch automation processes, Code Release and resolve Incident reports by putting strict measures and controls resulting to substantial reduction in production incident cases.
Deputed to OCBC Bank Singapore
* Developed Extract-Transform-Load jobs for various data source system such as MIDAS plus, GIFS,
SIBS CIF, LOANS, Deposits and Commercial Loans and GE-OAC Life insurance.
* Reduced production problems, optimized and supported OCBC Enterprise Datawarehouse,
Operational Data Store, and Global Datawarehouse.
* Improved the batch run to meet SLA to users and downstream Datamarts.
* Assisted and supported Project Managers in various projects by providing effort estimations,
capacity planning and manpower requirement to develop small, medium and large projects.
* Provided technical assistance, training and coaching to project team members.
* Supported Infrastructure projects, software and hardware upgrade activities, and server
connectivity
Deputed to OCBC Bank Singapore
* Designed and developed automation scripts in Unix for daily and monthly processes to integrate
huge volume of data from local and international OCBC Branches to Datawarehouse system.
* Assisted Business Analyst and end-user in capturing business requirements, defining problems,
analyze change request, application development, enhancement, UAT and production roll-out.
* Supported daily and monthly BAU of Operational Data Store system. Produced Incident and
status report for management review.
LEO S. FRESNILLO
Performed the role of Supervisor and handled 5 programmers to maintain the EXPORT SYSTEM
nationwide. Conducted data gathering, user interviews, development, debugging and testing of
Export system enhancements. Acted as DASD administrator in Mainframe Dev server to do
housekeeping.
* Developed and supported 24 x 7 in-house CICS online programs and MVS COBOL batch programs
under Mainframe environment for EXPORT System.
* Report Project timeline, Incident report, Daily Batch status report to Senior Management for
evaluation.
* Led the development of the following projects in Export System: Y2K Project, Closure of Legacy
currencies, Retail Banking Group-ASD Requirements, GL and SL Requirements for Central Bank of
Philippines, FX Transaction Reports for Central Bank of Philippines, FX Trial Balance, Daily and
monthly IOPC Reports, Integration of Far East Bank and Bank of Philippine
Performed data gathering, analysis, design, development and testing of MMC Accounting system
using Magic Software 4GL.
* Received recognition from MMC Directors for resolving technical issue in Out-patient Pharmacy
Billing system that improves customer experiences and financial gain in Business.
* Produced regular project and incident status report to the senior management.
* Supported MMC internal users and liaise with external software vendors.
* Led the development, implementation and enhancement of the following Accounting system:
Computerized Imaging Institute Billing and A/R System, EDP Billing System and Accounting system
integration and Out-Patient Pharmacy Billing System
Led the user interview to collect business requirements, design, analyze and application development
for Telco, Manufacturing and government units.
* Developed and maintained Client-Server Online and Batch programs for 3 Major projects namely
Coconut Investment Fund Integrated System, PLDT Online Warehousing System and DAVAO OIL-
PLANT Integrated System
* Traveled in different parts of the country to setup and install business applications and databases
COMPUTER