Summary
Overview
Work History
Skills
Websites
Certification
Skills Proficiency
Volunteers
References
Timeline
Generic

Loida Mandasoc

Naga City,Philippines

Summary

Results-driven Informatica ETL Developer and Software Engineer with extensive experience in coding, testing, deployment, and technical documentation. Proficient in Informatica PowerCenter and BDM Tool; adept at implementing solutions that align with business objectives. Known for adaptability in dynamic environments while effectively managing multiple tasks under pressure. Committed to driving innovative business solutions through comprehensive knowledge of web technologies.

Overview

15
15
years of professional experience

Work History

Senior Software Engineer

CWT Philippines, Inc.
Manila, Philippines
12.2019 - Current

Industry: Recreation Facilities and Services (Travel)

  • Providing solutions by working directly with the Solutions Architect to understand the requirements using the ETL Tool (Informatica PowerCenter) for implementation, as well as all related extraction, transformation, and loading of data functions in the company.
  • Identify, prioritize, and execute tasks using Agile methodology.
  • Perform review, code debugging, validation, and verification testing.
  • Collaborate with internal teams and onshore counterparts to fix and improve products.

Data and Analytics Engineer

DXC Technology
Manila, Philippines
05.2019 - 12.2019

Industry: Tobacco

  • Developed efficient cloud-based solutions to resolve customer-specific business problems while supporting organizational goals.
  • Collaborated with, and followed guidance from, the project/technical manager.
  • Analyze, design, and implement data ingestion using AWS Cloud resources such as CLI, S3, and Redshift.
  • Write low-level ETL design and data model documents.

Team Lead (Informatica ETL Developer - Data Migration)

Accenture, Inc.
Manila, Philippines
03.2018 - 05.2019

Industry: Logistics

  • Transformed existing data to fit new environment using Informatica Developer (Big Data Management).
  • Facilitated key improvements and operational support.
  • Leads developers by providing instructions and assignments.
  • Facilitated team meetings enhancing collaboration.
  • Executed application development lifecycle including enhancement, debugging, implementation, and testing with Informatica Developer (BDM).

Component Owner / Senior ETL Developer

DZ Bank AG
Frankfurt, Germany
06.2015 - 03.2018

Industry: Financial Services (Banking)

  • Designed and implemented effective business solutions using Informatica PowerCenter Tool.
  • Participated in various client projects involving Informatica PowerCenter 9.x/10.x for business solutions.
  • Authored technical design blueprints detailing functionality and system architecture for banking solutions.
  • Supported data modeling processes by implementing structural changes.

Sr. Software Engineer (Informatica ETL Developer and Production Support)

Accenture, Inc.
Manila, Philippines
06.2012 - 06.2015

Industry: Publishing

  • Escalated unresolved technical matters to appropriate channels.
  • Analyzed technical issues to execute solutions, leveraging the Informatica PowerCenter Tool.
  • Communicated potential challenges effectively, fostering better understanding among stakeholders.
  • Ensured completeness during project rollouts across various environments, including production and QA.
  • Addressed defects within the production support process efficiently.

SharePoint Developer

Accenture, Inc.
Manila, Philippines
03.2012 - 06.2012
  • Creates and updates codes according to the internal team's demands.
  • Ensured swift resolution of operational concerns as they occurred.
  • Designed and implemented a customized SharePoint interface for streamlined IM/DD&A processes.
  • Ensured functionality and efficiency of capability-focused SharePoint site.
  • Refreshed online content based on provided instructions.

Software Engineer (MicroStrategy Developer)

Accenture, Inc.
Manila, Philippines
10.2011 - 03.2012

Industry: Telecommunications.

  • Created tailored solutions using the MicroStrategy Reporting Tool.
  • Designed, evaluated, and deployed a Business Intelligence solution leveraging MicroStrategy components.
  • Analyzes and addresses reporting issues.
  • Developed validation procedures using SQL to align results with specified criteria.

Secondary Sub-Lead, Point of Contact (POC), Training Coordinator

Accenture, Inc.
Manila, Philippines
07.2010 - 10.2011
  • Contributed to strategic planning alongside the Center Bench Lead regarding capability advancements.
  • Conducted training sessions to enhance skills.
  • Facilitated multiple initiatives aimed at enhancing organizational capabilities.
  • Communicated critical concerns directly with Center Bench Management.
  • Facilitate the process of finding replacements for trainings when needed.

Skills

  • Informatica PowerCenter
  • Informatica BDM Developer
  • Oracle SQL Developer
  • Oracle TOAD
  • Agile Methodology
  • Waterfall Methodology
  • Data Warehouse
  • Unix
  • MicroStrategy reporting
  • Rally
  • JIRA
  • HP-ALM
  • Hue/Hive
  • Git Lab
  • Design and development
  • Data extraction
  • Design reviews
  • Strong debugging
  • Scope development
  • Analytics
  • Technical writing
  • Performance optimization
  • Project management
  • Problem-solving mindset
  • Staff education and training
  • Requirements gathering
  • Technical analysis
  • BI tools
  • Software documentation
  • Team leadership
  • Testing and debugging

Certification

  • EF SET English Certificate, 73/100, C2 Proficient, 03/01/21
  • Big Data Management 10.1, Specialist Certification, 10/01/18
  • Kompaktkurs: Data Integration, SAS Education, 11/01/15
  • Data Integration and ETL with Oracle Warehouse Builder, Oracle University, 03/01/11

Skills Proficiency

  • English Language, P3 - Advanced, 15+ Years, 2025
  • Filipino Language, P3 - Advanced, 15+ Years, 2025
  • Microsoft Office Suite, P3 - Advanced, 15+ Years, 2025
  • Informatica PowerCenter, P3 - Advanced, 13 Years, 2025
  • Agile Methodology, P2 - Proficient, 11 Years, 2025
  • Oracle SQL Developer, P3 - Proficient, 11 Years, 2025
  • JIRA, P2 - Proficient, 9 Years, 2025
  • Unix, P2 - Proficient, 9 Years, 2025
  • Informatica Developer BDM, P2 - Proficient, 1 Year, 2019
  • Rally, P1 - Novice, 1 Year, 2021
  • Hue / Hive, P1 - Novice, 1 Year, 2019
  • Git Lab, P1 - Novice, 1 Year, 2019
  • HP - ALM, P1 - Novice, 1 Year, 2019
  • AWS Resources (CLI, S3, Redshift), P0 - Trained, 3 Months, 2019
  • SQL Management Studio 2012, P0 - Trained, 3 Months, 2019
  • SAP PowerDesigner, P1 - Novice, 2 Months, 2018
  • Waterfall Methodology, P2 - Proficient, 3 Years, 2015
  • Oracle TOAD, P2 - Proficient, 3 Years, 2015
  • SAS Data Integration, P0 - Trained, 1 Month, 2015
  • Microsoft SharePoint, P1 - Novice, 3 Months, 2012
  • MicroStrategy Reporting, P1 - Novice, 6 Months, 2012
  • Application Testing - Solutions, P0 - Trained, 1 Month, 2012
  • Application Component Detailed Design, P0 - Trained, 1 Month, 2012
  • Data Integration and ETL with Oracle Warehouse Builder: Part 1 & 2, P0 - Trained, 1 Month, 2011

Volunteers

  • Secondary Business Continuity Plan Coordinator, DXC Technology (Philippines), Inc., 09/01/19, 12/01/19
  • Training Instructor, Accenture (Philippines), Inc., 06/01/12, 06/01/15

References

References available upon request.

Timeline

Senior Software Engineer

CWT Philippines, Inc.
12.2019 - Current

Data and Analytics Engineer

DXC Technology
05.2019 - 12.2019

Team Lead (Informatica ETL Developer - Data Migration)

Accenture, Inc.
03.2018 - 05.2019

Component Owner / Senior ETL Developer

DZ Bank AG
06.2015 - 03.2018

Sr. Software Engineer (Informatica ETL Developer and Production Support)

Accenture, Inc.
06.2012 - 06.2015

SharePoint Developer

Accenture, Inc.
03.2012 - 06.2012

Software Engineer (MicroStrategy Developer)

Accenture, Inc.
10.2011 - 03.2012

Secondary Sub-Lead, Point of Contact (POC), Training Coordinator

Accenture, Inc.
07.2010 - 10.2011
Loida Mandasoc