Summary
Overview
Work History
Education
Skills
Tenpin Bowling
Timeline
Generic

EFREN G. IMPERIAL

Laverton

Summary

Strategic and analytical professional with 20 years of success in financial analysis and reporting. Talented in delivering advanced Excel and SQL reporting to plan, design, execute and evaluate report results. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel formulas and functions to produce data-driven reports. Expert in creating reports writing SQL queries and analyzing SQL data. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

24
24
years of professional experience

Work History

REPORTING ANALYST

ANZ
10.2014 - Current
  • Provides routine and AdHoc Reports for Financial Planning
  • Develops reporting and tools based on the requirement of the business using the following tools: MS Excel, Qlikview, MS Access, Visual Basic for Applications
  • Helps analyze data to be used on reporting
  • Maintains the Financial Planning SharePoint portal.

COMMERCIAL MIS ANALYST

ANZ GSO Manila
11.2011 - 10.2014
  • Provides scheduled, AdHoc MIS reporting and analytical support for the Corporate and Commercial business based in Australia
  • Takes ownership of the reports generated and ensures that meeting the time and quality requirements that are currently being followed
  • Understands thoroughly the outcome and broader purpose of the reports
  • Have regular engagement with the Commercial Leadership Team, District Executives, and Frontline managers (including broker managers and transaction managers).

DATA/BUSINESS PLANNING ANALYST (Business Marketing Operations)

MANPOWER INC (Assigned to: Microsoft Corporation)
01.2010 - 10.2011
  • Assists in Marketing Budget Planning and Monthly/Quarterly/Mid-year Scorecard review
  • Generation of Bi-weekly budget reports
  • Generation of Monthly, Quarterly and Mid-year Scorecard reports
  • Generation of other adhoc reports.

MATERIAL EXPEDITER (Material Management Group)

JAL INTERNATIONAL, assigned to AL-JUBAIL PETROCHEMICAL CO. (KEMYA)
11.2006 - 12.2008
  • Expedite delivery of materials and spare parts used in the equipment inside the Petrochemical plant
  • Monitoring of Stocks available of each spare parts through data extraction from SAP System
  • Weekly extraction of inventory data in SAP and report generation of pending deliveries.

MIS OFFICER (Collections Department / Credit and Risk Department)

CITIFINANCIAL CORPORATION, Member of Citigroup
11.2003 - 10.2006
  • Preparation of the following Daily/Monthly report: Agent Productivity, Portfolio Delinquency, Call Tracking, New Accounts, Payments, Bounced check and Data integrity Report
  • Administration and parameter maintenance of Collection System CACS (Computer Assisted Collection System)
  • Work on Ad-Hoc’s as required by the business
  • (e.g
  • Extraction of data, tool creation using Visual Basic for Applications, process automation).

Data Encoder (Collections Department / Credit and Risk Department)

SOFTWARE LABORATORIES, INC. (assigned to CITIFINANCIAL CORPORATION)
05.2003 - 11.2003
  • Maintains and Organize Customer information stored in folders
  • Collects and Encodes data coming from Collection Agencies into Collection System.

SOFTWARE PROJECT COORDINATOR

ALEXANDER RESOURCES INC.
01.2002 - 01.2003
  • Testing and troubleshooting of Customized Payroll software
  • Giving updates to end-users
  • Serves as backup for the IT specialist
  • Maintenance and Administration of SQL server
  • Migrating of data from old dos based payroll software into the new one.

DATA ENCODER

INNODATA PHLIPPINES
01.2001 - 10.2001
  • Encoding of scanned images into text file format
  • Creation of Word perfect Macros for faster data conversion
  • Proofreading and editing of documents/images.

Education

BS in Computer Engineering, Tertiary Education (unfinished) -

AMA Computer College
01.2002

Secondary Education -

University of Perpetual Help Rizal
01.1997

Primary Education -

Olivarez College
01.1993

Skills

  • Microsoft Excel
  • Microsoft Access
  • Visual Basic for Applications
  • SQL Queries
  • Conflict Resolution
  • Qlikview
  • Problem Solving
  • SharePoint Knowledge
  • Attention to details
  • Data Analysis
  • Process Modeling
  • Data Validation
  • Power BI Experience
  • Analytical mindset
  • Report automation
  • Business Intelligence
  • Data Integrity
  • Data Warehousing
  • Advanced analytics
  • Reporting procedures
  • Data tracking applications
  • ETL processes
  • Data Collection
  • Report Development
  • Data Cleansing
  • KPI Tracking
  • Web-based reporting tools
  • Data and Analytics
  • QlikView Expertise
  • QlikView Dashboard Creation
  • QlikView Proficiency
  • QlikView Development

Tenpin Bowling

sport that i play the best

Timeline

REPORTING ANALYST

ANZ
10.2014 - Current

COMMERCIAL MIS ANALYST

ANZ GSO Manila
11.2011 - 10.2014

DATA/BUSINESS PLANNING ANALYST (Business Marketing Operations)

MANPOWER INC (Assigned to: Microsoft Corporation)
01.2010 - 10.2011

MATERIAL EXPEDITER (Material Management Group)

JAL INTERNATIONAL, assigned to AL-JUBAIL PETROCHEMICAL CO. (KEMYA)
11.2006 - 12.2008

MIS OFFICER (Collections Department / Credit and Risk Department)

CITIFINANCIAL CORPORATION, Member of Citigroup
11.2003 - 10.2006

Data Encoder (Collections Department / Credit and Risk Department)

SOFTWARE LABORATORIES, INC. (assigned to CITIFINANCIAL CORPORATION)
05.2003 - 11.2003

SOFTWARE PROJECT COORDINATOR

ALEXANDER RESOURCES INC.
01.2002 - 01.2003

DATA ENCODER

INNODATA PHLIPPINES
01.2001 - 10.2001

BS in Computer Engineering, Tertiary Education (unfinished) -

AMA Computer College

Secondary Education -

University of Perpetual Help Rizal

Primary Education -

Olivarez College

Similar Profiles

CREATE PROFILE
EFREN G. IMPERIAL