Summary
Overview
Work History
Education
Skills
Certification
Extracurricular Activities
Seminars Workshops Attended
Languages
Objective
References
Timeline
Ma. Dialika Bantog

Ma. Dialika Bantog

Bacoor

Summary

BI Development Specialist at PIC Philippines Inc. with expertise in SQL coding and stakeholder management. Architected BI solutions that improved operational efficiency and aligned with business objectives. Managed complex IT projects from conception to deployment, ensuring timely delivery and adherence to budget. Proven leadership and problem-solving skills foster effective collaboration in dynamic technology environments. Tech-savvy innovator with hands-on experience in emerging technologies and passion for continuous improvement. Skilled in identifying opportunities for technological enhancements and implementing effective solutions. Adept at leveraging new tools and methods to solve problems and enhance productivity. Excels in adapting to fast-paced environments and driving technological advancements.

Overview

24
24
years of professional experience
1
1

Certified Lean Six Sigma Black belt

Work History

Technical Project Manager/Solution Architect

Freelance
Manila
08.2023 - Current
  • Devised comprehensive project strategies and scopes, addressing all phases from ideation to implementation.
  • Managed multiple project teams using System Development Lifecycle (SDLC) and Agile methodologies.
  • Gathered and analyzed stakeholder requirements through meetings and interviews, producing detailed business documentation.
  • Conducted thorough risk assessments to identify risks and formulate effective mitigation strategies.
  • Implemented process improvements, significantly enhancing efficiency across departments.
  • Coordinated communication among internal teams, vendors, clients, and stakeholders throughout project lifecycles.
  • Developed strategies for seamless deployment of solutions into production environments.
  • Maintained knowledge of industry trends and advancements in technology to drive project success.

BI Development Specialist

PIC Philippines Inc.
Pasig City
11.2021 - 03.2025
  • Owning and completing project tasks as part of the digital transformation of Genus within time scales. Including delivering planning, and stakeholder management activities. Including requirements definition, SQL coding using stored procedures, and possible updates for Power BI datasets.
  • Undertake or support the monitoring of BAU processes as directed, including undertaking root cause analysis, advising on remediation options, and, if required, delivering a solution, including any early lifecycle support as needed.
  • Supporting operational and BAU change requests and issues, completing change request tasks as assigned, through to the completion of early life support.
  • Working closely with the different stakeholders, recommend, plan, and implement database and data warehouse enhancements and release upgrades, ensuring that the development is in line with business objectives and standards, using Microsoft On-Premise Database and Azure Cloud, as well as Cognos BI.
  • Work closely with data architects, data modelers, and software developers to ensure data lineage from Multi-ERP (Oracle and D365), and other internal systems, is properly designed for BI solutions.
  • Working with developers, architects, analysts, and product owners to ensure the testing script is understood, and that the acceptance tests track the desired functionality.
  • Identify, report, and fix material bugs and deficiencies in the tools used, utilizing internal and external resources.
  • Map and document our BI processes and environment.
  • Develop, maintain, and document our BI development standards.
  • Architect BI solutions for new and existing BI reporting solutions for different business units.
  • Maintained updated knowledge through continuing education and advanced training.
  • Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
  • Upskilling the Genus resource where required.

Project Manager

RGP (Hong Kong) – Philippine Branch
Makati City
03.2021 - 10.2022
  • Project delivery of client initiatives, which includes the implementation and rollout of the company system, following agile and/or hybrid processes. The role includes the provision of SME skills in the Telephony (Genesys) platform, infrastructure, and integration to other systems such as CRM, core banking systems such as Oracle and D365, payment hub, tellering system, banking financials data warehouse, and CDP reporting to maximize the return on investment; driving individual projects to accomplish the agreed outcomes within the program, and the delivery of the outcome within the scope.
  • Ensure that all deliverables comply with the Client’s branding, design, usability, security guidelines, and requirements.
  • Reviewed project risks and devised proactive strategies to avoid potential roadblocks.
  • Implemented effective communication protocols between internal teams working on different aspects of a given project.
  • Monitored progress of each project to ensure timely delivery of deliverables in accordance with established quality standards.
  • Works closely with various business stakeholders, IT, and vendors to determine and translate business requirements in line with the company initiatives into project requirements, and ensure the acceptability and timeliness of project deliveries, and that they are within budget.
  • Manage projects from start to close, applying the PM Methodology (initiate, plan, execute, monitor and control, and close) to achieve project objectives.
  • Provide the single point of contact for assigned business and technology aspects in the implementation of new systems and platforms, or changes to systems and platforms.
  • Enable a successful convergence of business requirements to technical solutions.
  • Identifies project priorities and cross-functional dependencies to ensure that the assigned projects meet the set deadlines.
  • Analyze the risk factors of the projects that will be implemented using risk management tools to ensure that they comply with the client's standards.
  • Performs other related tasks, which may be assigned from time to time.

Assistant Project Manager

Genie Technologies Inc.
Makati City
05.2018 - 01.2021
  • Responsible for leading/managing Projects and ensuring that it is within timeline and budget.
  • Understand client existing and non-existing data sources such as Microsoft SQL Server, MySQL, data files such as csv and Microsoft Excel as well as data from other cloud data sources, full and identify appropriate action to address business problems.
  • Ensure a high standard of communication and liaise between client, team and other departments involve in the project.
  • Do Project Implementations with documentation and technical consultations for Business Intelligence Tools such as Qlikview and Qlik Sense.
  • Identify scope and limitations of the project during business requirements gathering.
  • Create Proof of concept through dashboards development for prospect clients and demonstrate how Business Intelligence can be a tool to help them with their business through establishing Key Performance Indicators (KPI) and be able to arrive to a sound decision.
  • Lead development and implementation of Business Intelligence Applications such as Qlik Sense, Qlikview and Power BI based on client specified requirements.
  • Assist existing clients for their operational needs based on the signed Maintenance Service Agreement which is not limited to data modelling and other backend modification and enhancements as well as platform upgrade and re-training.
  • Troubleshoot escalated client support and maintenance issues on a day to day basis.
  • Create training materials and retrofit according to client needs and provide training to staff and clients.

PH IT Team Lead

Salmat Services Inc.
Pasig City
08.2011 - 04.2018
  • Responsible in leading Data Management Team in providing technical support and expertise in executing automated and manual processes to handle data required for inbound calls and outbound dialling using ITIL methodology as well as assist in the development of automation packages using MS SSIS and stored procedures using Agile/Scrum and Waterfall methodology.
  • Work with Genesys and Avaya Telephony Management staff, ETL creation developers and others to improve dialling treatments and data wash procedures as well as database administrators in construction and maintenance of data warehouse.
  • Create adhoc database queries and data extracts for reporting and data analysis using MS SQL Server 2005, 2008, 2017.
  • Assist in Hermes Reporting (an internal reporting platform) maintenance and troubleshooting using PHP programming.
  • Assist in Kana, Qlik and Purecloud troubleshooting through backend investigation.
  • Assist in documentations and process improvements through research and development.
  • Assist team members on their daily tasks which include Incidents, Service Requests and Problem Action Item assignments and administrative needs which include but not limited to establishing Key Performance Indicators, Operational Rhythm Manuals, Philippine Data Privacy Awareness, identifying critical processes, creating Business Continuity Plan and other process documents needed from time to time with implementation.
  • Assist as Change Coordinator in IT related changes that are being deployed through documentation as well as deploying own changes to production.
  • Assist in other functions as assigned by the Manager.

Applications Developer II

Alta Resources
Pasig City
07.2009 - 09.2011
  • Responsible for providing technical support and expertise in both project development, implementation and maintenance, including building and supporting through Microsoft platforms in using PeopleSoft 8.4 and 8.9 Technical Skills like PeopleTools, PeopleCode, Application Engine, Component Interface, Workflow, PeopleSoft Security and Query Manager for all existing Peoplesoft CRM Module applications with Interaction Intelligence and Email integrations with working knowledge of common and custom-made configurations such as creating User profiles, attributes creations and etc.
  • Worked hand in hand with .net developers for Web based application integration as well as creating SSIS packages, SQL Scripts and stored procedures for automated data extraction, transformation and migration, verification and other services surrounding the needs of the company’s clients which includes but not limited to full life cycle implementation using Microsoft SQL Server Business Intelligence Development Studio 2005, SAP Business Objects XI R2 with SAP BW Experience developing BOBJ Universe, WEBI Queries Data warehousing and reports generation using Crystal Reports.

Freelance System Analyst/Developer

Bank of the Philippine Islands
Makati City
02.2009 - 07.2009
  • Responsible for Object-Oriented Systems Analysis, Design and Development of Foreign Banks Reconciliation in a Client-Server environment to maximize man-power, streamline unnecessary processes and generate accurate reports for management using Visual Basic 6.0, Crystal Reports and Microsoft Access 2003.

Senior Software Engineer

Accenture Delivery Center Philippines
Makati City
08.2008 - 11.2008
  • Trained to provide technical support and expertise in both project implementation phase and maintenance mode, including building and supporting interfaces to multiple platforms in using Peoplesoft technical skills like PeopleTools, PeopleCode, SQR, Application Engine, Component Interface, Workflow, PeopleSoft Security, and Query Manager with project simulation in Peoplesoft HR Module.
  • Also well versed in Peoplesoft Financials, Customer Relations Management, General Ledger and Order Management Modules.

MIS Supervisor

Philsteel Holdings Corporation
Legazpi Village
11.2006 - 07.2008
  • Responsible for heading the software development, implementation and maintenance team in client-server application for day to day operational support as well as enhancement of existing systems to computerize the business processes, and help to streamline the business processes of the user departments in the company and its subsidiaries such as Inventory, Cost Accounting, Accounts Receivable, Accounts Payable, General Ledger, Payroll with HRIS and Timekeeping, Customer Relations Management and Order Management with Credit and Collections using Visual Basic 6.0, Crystal Reports, Microsoft Access, SQL Server 7.0 and SQL Server 2000 of Philsteel group of companies with Object-oriented Analysis and Design.
  • Also responsible for web development and administration using Macromedia Studio MX.
  • Identification and revision of policies and procedures of MIS department for ISO 9001:2000 (Quality Management Systems) and 14001:2004 (Environment Management System) Certification with documentation and implementation.

Database Administrator

Embassy of Pakistan-Washington, D.C.
Washington, D.C.
10.2004 - 09.2006
  • Control connection of users to database, creation of stored procedures, daily, weekly, monthly and yearly backup of database, to ensure security of the data at all times using Microsoft SQL Server (7.0, 2000) and Microsoft Access (97, 2000, 2003), plays a major role in software development using Visual Basic 6, database installation and troubleshooting, server and network troubleshooting (Software and Hardware) when needed.

System Analyst/Programmer

Philmetal Products Inc.
Legazpi Village
03.2004 - 09.2004
  • Software Development, Software Maintenance and Technical Support using Visual Basic 6, SQL Server 2000 and Microsoft Access (97 and 2000).

Programmer

IDM Inc.
Madrigal Business Park, Alabang
11.2002 - 08.2003
  • Programming data conversion using COBOL, UNIX Sun Solaris and VI Editor.

Assistant LAN Administrator

BPI Operations Management Corp.
Intramuros
04.2001 - 05.2001
  • Responsible for LAN troubleshooting, Network Installation, Server set-up, Programming using Visual Basic 6 and Printsoft (Printer software) and PC troubleshooting (Software and Hardware).

Education

B.S. - Computer Science

De La Salle University-Dasmariñas, Dasmariñas, Cavite, Philippines
01.2002

Visual FoxPro 6 -

Informatics Computer Institute, Imus, Cavite, Philippines
01.2001

Skills

  • PeopleSoft 84
  • PeopleSoft 89
  • PeopleTools
  • PeopleCode
  • SQR
  • Application Engine
  • Component Interface
  • Workflow
  • PeopleSoft Security
  • Query Manager
  • net 2003
  • net 2008
  • net 2017
  • Python
  • Oracle 8i
  • Oracle 12c
  • DynamicsNAV
  • Dynamics 365
  • ErpNext
  • MS SQL Server 2000
  • MS SQL Server 2005
  • MS SQL Server 2010
  • MS SQL Server 2014
  • MS SQL Server 2017
  • MS SQL Server 2019
  • MS SQL Server 2022
  • MS Master Data Servces
  • Azure Data Factory
  • Azure Databricks
  • IBM Cognos
  • MySQL
  • Azure DevOps
  • Github
  • MS Access 97
  • MS Access 2000
  • MS Access XP
  • MS Access 2003
  • MS Access 2007
  • Crystal Reports 8
  • Crystal Reports 9
  • Crystal Reports 10
  • Crystal Reports 11
  • Microsoft SQL Server Business Intelligence Development Studio
  • MS SSIS
  • MS SSAS
  • MS SSRS
  • Stakeholder management
  • Project management
  • Root cause analysis
  • Requirements gathering
  • Agile methodologies
  • Change management
  • Azure Data Factory
  • Azure Analysis Services
  • SAP Business Objects XI R2
  • SAP BW
  • BOBJ Universe
  • WEBI Queries
  • Data warehousing
  • Interactive Intelligence telephony
  • Avaya telephony
  • Kana Enterprise
  • Qlik Sense
  • Qlikview
  • Power BI
  • Purecloud
  • Visual FoxPro 6
  • Java
  • PHP 50
  • MS Windows Server 2000
  • MS Windows Server 2003
  • MS Windows Server 2012
  • MS Windows Server 2016
  • Azure Server
  • MS Windows 2007
  • MS Windows 7

Certification

  • Certified Lean Six Sigma Green Belt, 02/04/23
  • Certified Lean Six Sigma Black Belt, 03/07/23

Extracurricular Activities

Treasurer, Career Development Society, De La Salle University, 06/1998 - 03/2002 Member, Network of Computer Science Students, De La Salle University, 06/2000 - 03/2002 Member, Alumni Association, De La Salle University, 05/2002 - Present

Seminars Workshops Attended

  • Project Management Professional, IMC Education, UAE, Online, 02/06/23 - 02/21/23
  • Lean Six Sigma Master Class, IMC Education, UAE, Online, 11/26/22 - 12/25/22
  • Seamless Philippines 2019, Terrapinn, SMX Convention Center, Pasay City, 09/25/19 - 09/26/19
  • AWS Builders Online Series, Amazon Web Service, Amazon Online, 08/27/19 - 08/28/19
  • Techtonic Summit, Microsoft Philippines, SMX Convention Center, Pasay City, 06/22/18 - 06/23/18
  • 20466C – Implementing Data Models and Reports with Microsoft SQL Server, Wizardsgroup Training Center, Unit 2801 88 Corporate Center Sedeño cor. Valero sts. Salcedo Village, Makati City, 08/17/15 - 08/21/15
  • 20463C – Implementing a Data Warehouse with Microsoft SQL Server, Wizardsgroup Training Center, Unit 2801 88 Corporate Center Sedeño cor. Valero sts. Salcedo Village, Makati City, 04/13/15 - 04/17/15
  • 20461C – Querying Microsoft SQL Server, Wizardsgroup Training Center, Unit 2801 88 Corporate Center Sedeño cor. Valero sts. Salcedo Village, Makati City, 03/16/15 - 03/20/15
  • Kepner-Tregoe Problem Solving and Decision Analysis, Manila Execon, The Discovery Suites, 25 ADB Avenue, Ortigas Center, Pasig City, 07/06/13 - 09/20/13
  • AMEX Security Training, Salmat Services Inc., 3rd Flr. 18/20 Bldg. Upper McKinley Road, McKinley Hill, Taguig City, 10/29/12
  • Soft Skills Training, ALTA SE Asia Inc., 34th Floor Wynsum Corporate Plaza, F. Ortigas Jr. Rd., Ortigas Center, Pasig City, 03/01/10 - 03/05/10
  • Security Awareness Training, ALTA SE Asia Inc., 34th Floor Wynsum Corporate Plaza, F. Ortigas Jr. Rd., Ortigas Center, Pasig City, 07/26/09
  • PeopleSoft Simulation, Accenture Philippines, 14th Floor Cybergate 3, Pioneer st. Mandaluyong City, 10/14/08 - 11/07/08
  • PeopleSoft Bootcamp, Accenture Philippines, 14th Floor Cybergate 3, Pioneer st. Mandaluyong City, 09/15/08 - 10/13/08
  • PeopleSoft Accounts Payables, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 09/03/08 - 09/05/08
  • Business Writing, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 09/02/08
  • PeopleSoft Order Management, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 08/29/08 - 09/02/08
  • PeopleSoft General Ledger, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 08/28/08 - 08/29/08
  • PeopleSoft Accounts Receivables, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 08/27/08 - 08/28/08
  • Task Organization, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 08/26/08
  • Facilitating Meetings, Accenture Philippines, 22nd Floor Cybergate 2, Pioneer st. Mandaluyong City, 08/25/08
  • Basic Essentials for firefighting, Steelcorp of the Philippines, Km 140 Brgy. Munting Tubig, Balayan, Batangas, 10/2007
  • Quality Management System 9001:2000 and Environment Systems 14001:2004 ISO Certification Seminar, Rosehall Consultants, Steelcorp of the Philippines, Km 140 Brgy. Munting Tubig, Balayan, Batangas, 05/2007 - 06/2007
  • MSDN Connection Student Developers’ Night: A Lap Around ASP .NET, Microsoft Philippines, Inc., 16th Floor, 6750 Ayala Avenue, Makati City, Philippines, 06/28/06
  • WPF: The Developer Experience, Microsoft Philippines, Inc., 16th Floor, 6750 Ayala Avenue, Makati City, Philippines, 06/27/06
  • Mobile Developer Conference, Microsoft Philippines, Inc., The Makati Shangri-la Hotel, Makati City Philippines, 05/10/06
  • Software Innovations Philippines, Microsoft Philippines, Inc., The Makati Shangri-la Hotel, Makati City Philippines, 05/08/06 - 05/10/06
  • MSDN Connection Evening: VB 6 to VB .net, Microsoft Philippines, Inc., 16th Floor, 6750 Ayala Avenue, Makati City, Philippines, 04/20/06
  • Microsoft Developer Convention, Microsoft USA, Kennedy Convention Center, Washington, D.C., USA, 02/20/05
  • Microsoft Developer Days, Microsoft Philippines, Inc., Shangri-la Edsa Plaza Hotel, Ortigas, Pasig City, Philippines, 06/08/04 - 06/09/04

Languages

Filipino
First Language
English
Proficient (C2)
C2

Objective

I am a person who believes in making a difference in whatever place, position, or situation I am put in. I make sure to always go the extra mile and exceed expectations as much as I humbly can. I value integrity and honesty above all. My ideal working environment is a place where everyone is regarded with the same respect and dignity, where values and commitment drives every person, where teamwork is the name of the game, where learning is an unending thirst, and where smiles and laughter and humor abound amidst a professional workplace.

References

References available upon request.

Timeline

Technical Project Manager/Solution Architect - Freelance
08.2023 - Current
BI Development Specialist - PIC Philippines Inc.
11.2021 - 03.2025
Project Manager - RGP (Hong Kong) – Philippine Branch
03.2021 - 10.2022
Assistant Project Manager - Genie Technologies Inc.
05.2018 - 01.2021
PH IT Team Lead - Salmat Services Inc.
08.2011 - 04.2018
Applications Developer II - Alta Resources
07.2009 - 09.2011
Freelance System Analyst/Developer - Bank of the Philippine Islands
02.2009 - 07.2009
Senior Software Engineer - Accenture Delivery Center Philippines
08.2008 - 11.2008
MIS Supervisor - Philsteel Holdings Corporation
11.2006 - 07.2008
Database Administrator - Embassy of Pakistan-Washington, D.C.
10.2004 - 09.2006
System Analyst/Programmer - Philmetal Products Inc.
03.2004 - 09.2004
Programmer - IDM Inc.
11.2002 - 08.2003
Assistant LAN Administrator - BPI Operations Management Corp.
04.2001 - 05.2001
De La Salle University-Dasmariñas - B.S., Computer Science
Informatics Computer Institute - Visual FoxPro 6,

Similar Profiles

CREATE PROFILE
Ma. Dialika Bantog