Reliable and results-driven IT professional with 15+ years of experience in the financial and manufacturing industries. Demonstrates strong analytical, communication, and problem-solving skills, with proven ability to quickly adapt to new environments. Eager and committed to contribute to team success and prepared to deliver meaningful insights to achieve company goals.
Overview
30
30
years of professional experience
Work History
Data Analyst
Atria Wealth Solutions, Inc.
06.2022 - Current
Responsible for performing data analysis and providing immediate resolutions to unlinked, duplicate, missing and erroneously closed accounts ~200 accounts daily
Identifies discrepancies between custodial and canonical data and creates specifications for implementation in production database (up to 10K accounts per ticket)
Writes SQL queries to support data analysis and management ad-hoc report requests
Creates user stories to initiate system improvements based on recurring issues identified during data analysis
Supports testing activities to validate accuracy, reliability and functionality of developed systems before deployment
Migrated Co-holder data by creating a separate contact record for co-holders, linking the accounts and including them in respective household ~100K records
Developed Unio-based Erisa quarterly position reports based from decommissioned Sisense system
Developed and implemented ETL process to include WIS accounts from various data providers into Unio ~50K accounts and ~30K contacts initially then ~20 accounts daily
Developed and implemented ETL process to add Pershing beneficiaries data into Unio ~500K records weekly for 4 months
Food & Nutrition Assistant
Poway Unified School District
02.2022 - 06.2022
Under the direction of an assigned supervisor, assisted in quantity preparation, packaging and serving of foods at Poway High School
Assisted in maintaining nutrition centers, equipment and utensils in a clean, safe and sanitary condition
Assisted in the set up of serving areas
Performed cashiering and recordkeeping duties
Full-time Mom and Housewife
03.2011 - 01.2022
Having migrated from the Philippines, I took time away from my professional career to raise my two young children and manage our household
Meanwhile, I also attended various online and weekly computer courses offered at San Diego Continuing Education
Systems Analyst
Rizal Commercial Banking Corp.
09.2007 - 02.2011
Supervised the design, development and implementation of various interface applications to link the existing mainframe-based RCBC core banking system to acquired solutions, TAPS and Guava Suite
Assigned as lead systems analyst to design and supervise programmers for the development of new java-based interface systems that would link these acquired solutions to the new Oracle-based RCBC core banking system, Finacle
Assigned as lead systems analyst for the customization of Guava Suite for Treasury Operations. Roles include business requirement analysis, specifications writing, documentation of operational procedures, reports development using Guava Reporter and SQL Services
Provided 24/7 technical support
IT Manager
Pacific Plans, Inc.
05.1997 - 08.2007
Started as Methods and Procedures Analyst, promoted to Sr Business Analyst/AsstManager, and subsequently became the Manager in the company's IT division supervising analysts and programmers while reporting directly to the VP for IT Division and to the EVP and COO of the company for confidential projects
Over the span of ten years, my responsibilities included migration of the clipper-based, stand-alone pre-need application systems into an integrated Oracle-based system and its subsequent conversion to a web-based online system
Primarily responsible for preparing audit and management reports such as sales, collections, trust funds, persistencies and valuations
Headed the Systems Documentation and Quality Assurance Group to ensure that appropriate systems documentation and operating procedure manuals are maintained
Provided 24/7 technical support
Engineering Staff
Air Technology, Inc.
06.1995 - 02.1997
Developed assembly process manuals to standardize a/c installation and obtain optimum man-hour utilization
Developed the manufacturing set-up for the localization of imported a/c parts
Developed and implemented computerized Change Request System to manage engineering change requests and implementation
Developed and implemented computerized Inventory System to manage issuance, monitoring and ordering of local and imported a/c parts
Education
MS Computer Science - Coursework completed
Mapua Institute of Technology
Makati
01-2008
BS Industrial Engineering -
Mapua Institute of Technology
Manila
01-1995
Skills
Data Analysis
Business and Systems Analysis
Software Design and Development
Technical Documentation
Data and Systems Migration
Quality Assurance
Project Management
Technologies
Oracle (Designer 2000, Forms 4.5 and 6, Reports 2.5 and 6), PL/SQL, Oracle Integrator, VB6, VB .Net, ASP .Net, Java, SQL Data Transformation and Reporting Services, TOAD, Microsoft Excel, Eclipse, Netbeans, HTML, CSS, DBeaver, JIRA, Oracle, SQL Server, MS Access, Sybase, PostgreSQL
Timeline
Data Analyst
Atria Wealth Solutions, Inc.
06.2022 - Current
Food & Nutrition Assistant
Poway Unified School District
02.2022 - 06.2022
Full-time Mom and Housewife
03.2011 - 01.2022
Systems Analyst
Rizal Commercial Banking Corp.
09.2007 - 02.2011
IT Manager
Pacific Plans, Inc.
05.1997 - 08.2007
Engineering Staff
Air Technology, Inc.
06.1995 - 02.1997
MS Computer Science - Coursework completed
Mapua Institute of Technology
BS Industrial Engineering -
Mapua Institute of Technology
Similar Profiles
Jessica McBeeJessica McBee
Compliance Administrative Assistant at Atria Wealth Solutions/NEXT FinancialCompliance Administrative Assistant at Atria Wealth Solutions/NEXT Financial