Pauline B. Pacuan
Quezon City
Summary
Results-driven IT professional with 14 years of experience in the industry and 1.5 years in education. Expertise in Audit Operations and IT support, specialising in Premium Audit, data validation, and compliance reporting. Skilled in managing SQL Server and AS/400, resolving data issues, supporting UAT, and ensuring accurate financial and audit outputs.
Overview
16
16
years of professional experience
Work History
Audit Operation Analyst – Mid/ IT Operation Anayst (Premium Audit)
Arch Global Services Inc.
03.2014 - 05.2025
- Data collection and Analysis gathering data from various resources such as Policy documents, billing system, back-end reporting and audit reports to verify Premium calculations thru SQL server database and SQL/400
- Ensuring the accuracy and compliance of audit reports through Quality assurance review
- Adjusted policy premiums and bulk-loaded rejected claims data into the database via AS/400.
- Executed data corrections through back end (SQL Server and SQL/400).
- Performed data quality checks in back end (SQL Server).
- Loading of claims data feed through UNIX server and running program through Toad and oracle as we provide for Manual correction to the specific team
- Executed programmes to generate weekly, monthly, and quarterly financial reports for business and finance using WINS (AS/400).
- Communicating with audit vendors, updating internal systems and preparing reports on Audit status.
- Conducted UAT and functional testing.
- Knowledgeable in IT Application control (Input control, processing controls, output control)
- Knowledgeable in IT General Controls (Logical Access, Change Management, Back up and Recovery)
- Understood NCCI regulations and guidelines.
- Manual loading of data through back end in WINS
IT Developer
EClaro Internationals Inc / Arch Global Services Inc.
02.2011 - 03.2014
- Designing and coding software applications based on user specifications
- Developed user interfaces and field functions based on business requirements.
- Testing and debugging the software to ensure it functions correctly and identifies and resolves issues.
- Conducted user acceptance testing to validate software functionality against user requirements
- Created data mapping documents to clarify data relationships and structure for better application integration
- Maintained and updated existing applications to ensure continued functionality and relevance in user operations
- Prepared comprehensive software documentation to assist users in understanding functionality
IT Professor
BestLink College of the Philippines
05.2009 - 10.2010
- Instructed back-end database design and programming techniques
- Taught logic circuits integrated with programming concepts
- Facilitated training sessions on Microsoft applications for student proficiency
Education
Bachelor of Science - Computer Science
St. John Technological College of the Philippines
Quezon City05-2009
Skills
- MS Word, MS Excel, MS Access
- Data Integrity Checks
- Data Verification
- Database Reporting
- MS Excel
- Pivot table analysis
- AS/400 systems
- SQL Server
- SQL/400
- Functional Testing
- User acceptance testing
- UAT testing
- Quality assurance review
- Audit Compliance
- Compliance audits
- Audit analysis
- Premium audit
- Financial Auditing
- Quality assurance review review
- SDLC
- Process control
- Strategic Analysis
- Workflow Analysis
- Multiple programming languages
- Code Review
- Written communications
- Verbal communications
- Communication skills
- Decision-making
- Relationship Management
- Operational Metrics
- Critical analysis techniques
- Standard process development
- Additional skills
- Relationship Management
Websites, Portfolios, Profiles
http://www.linkedin.com/in/pauline-pacuan-b8027453
Timeline
Audit Operation Analyst – Mid/ IT Operation Anayst (Premium Audit)
Arch Global Services Inc.
03.2014 - 05.2025
IT Developer
EClaro Internationals Inc / Arch Global Services Inc.
02.2011 - 03.2014
IT Professor
BestLink College of the Philippines
05.2009 - 10.2010
Bachelor of Science - Computer Science
St. John Technological College of the Philippines