Data Management

Irvin Gonzalez

*** ******** *****,

Lafayette, CA, 94549

Cellphone no.: 925-***-****

Email Address: ***.********@*****.***

OBJECTIVE

To utilize my experience in Business Analytics and project implementation

to streamline an organization's business processes and increase its

productivity. Driven to develop my knowledge in both Management and

Information Technology to come up with innovations that would exceed

business goals.

SKILLS and ABILITIES

Databases: Oracle, MS SQL, MS Access

Back-end Tools: SQL Server Enterprise Manager, SQL Query Analyzer, Toad,

ETL Programming, MS Access

Front-end Tools: MS Visio, Excel, Word, PowerPoint, Crystal Reports,

PeopleSoft Reports Manager, WebEx, Remote Desktop, Citrix,

Hyperion, Cognos, MS DOS, FTP, Telnet/ SSH clients

Industry Concepts: Financial Reporting (US GAAP and IFRS), Regulatory

Reporting (FFEIC 031 Call Reports, FFIEC 101, FR Y-9C),

Basel II Reporting, Compliance Metrics, Productivity

Reporting (KPI and PQI), Management Reporting, Problem

Ticket Analysis, Vendor Management, Software Development

Life Cycle (SDLC) including analysis, design, development,

testing and implementation

Testing Applications: Mercury Quality Center, Mercury Test Director

Analytics: Expert in analytical reporting using Crystal Reports, SQL

queries and advanced Excel features like complex formulas,

pivot tables and charts. Strong analytical, pattern

detection as well as problem solving abilities, and

meticulous on quality and timeliness of deliverables.

EXPERIENCE

Basel II Business Analyst (Contract) July 2010 -

Present

Bank of the West San Ramon, CA

Controllers Department

Basel II Requirements Gathering: Regulatory Reporting (US GAAP) and

Shareholder Reporting (IFRS) Data and Business Requirements

. Analyze report forms and instructions to identify data needs as well as

business logic.

. Conduct work sessions with SMEs to document current state process flow

diagrams.

. Organize and lead data workshops with technology, development team, and

Subject Matter Experts (SMEs) to determine data as well as business

requirements.

. Coordinate with business units, development team, project team and

technology on an ongoing basis to communicate the information needs of

each group, derive and execute action plans, set meeting deadlines and

establish standards.

. Evaluate data gathered from multiple source systems, reconcile

differences, decompose high-level information into details, abstract up

from low-level information to understand, and distinguish optional user

requests from what is required.

Financial Data Mart Reports Automation Initiative

. Prepare data and business requirements for all regulatory reports with

loans and deposits data.

. Analyze Easytrieve (mainframe) queries and derive data requirements and

business logic from it.

. Create data mapping between report field requirements and database

tables.

. Produce gap analysis to determine interim solutions as well as long term

solutions.

. Perform data reconciliation and testing between data sources.

Reports/ Business Analyst February 2008

to April 2010

Lawson Software Taguig City, PH

Product Development

Achievements:

. Designated as the process SME for Sweden reporting and compliance

metrics.

. Calibrated to Reports Analyst III.

. Assigned as the Technical and Analysis Lead of the team.

. Promoted two major projects to production which were used by top

management (CEO, SVP, VP)

. Nominated for a Lawson award by automating a process that cut total man-

hours by 80%.

Reports Database Migration and Integration

. Spearheaded the migration and integration of Swedish reports including

compliance, productivity, key performance indicator (KPI) and product

quality index (PQI) to a new centralized data warehouse for consolidated

reporting.

. Coordinated with senior management, process owners, product managers and

technology in the US, Sweden and Philippines to document data and

business requirements.

. Created functional and technical specifications which include database

relationships, pseudo codes, and SQL scripts.

. Managed large amounts of data to be mapped, extracted, transformed and

loaded into a new data warehouse using SQL scripts and stored procedures.

. Performed heavy data reconciliation, testing and analysis in both

instrument and aggregate levels using SQL and MS Excel.

. Designed report prototypes in MS Excel and Crystal Reports to be tested

by the end-users as part of UAT.

Implementation of Report Enhancements

. Led the implementation of reporting enhancements to the product

development briefing book which include compliance metrics, productivity

metrics, KPI and PQI.

. Coordinated with senior management and product owners to gather and

document data as well as business requirements.

. Reverse engineered SQL scripts, script logic, DTS packages and formulas

since no documentation existed for the current reports. Created

functional and technical specifications from the process of reverse

engineering.

. Conducted testing by creating test cases, running the test cases in both

transactional and aggregate levels and saving the results to obtain sign-

off to go-live.

. Performed data reconciliation and data analysis with products owners to

ensure data integrity

Analysis and Technical Lead

. Led the investigation and resolution of data issues that arose from the

team's daily processes particularly during month-end reporting.

. Assisted in implementing process improvement techniques such as reports

automation and self-service reporting to cut down on man-hours and

initiate a more efficient business process.

. Coordinated with product managers to improve their compliance and

productivity metrics grade by doing data analysis and investigation.

. Team expert on technical concerns regarding MS SQL programming, Data

warehouse objects, and MS Excel formulas, pivot tables and charts.

Reports Generation

. Generated weekly, monthly, quarterly, yearly and ad hoc reports used to

track compliance, productivity and product quality reports to Lawson

senior management in the US, Sweden and Philippines.

Business Process Analyst January 2006 to

February 2008

Citigroup Makati City, PH

Citi Business Services

Achievements:

. Promoted to Assistant Manager.

. Designated as deputy team leader.

. Implemented process improvements to improve countries' (BG and SK)

financial reporting metrics grade to A.

. Implemented automated solutions to dramatically improve accuracy and

shorten production time of general ledger to subsidiary ledger

reconciliation reports.

Basel II Data Acquisition and Data Quality

. Coordinated with key business groups and technology from NY, FL, London

and India to drive out end-to-end solutions.

. Documented business and functional requirements gathered from the

different source systems owners that were required to feed into a new

data warehouse.

. Implemented data feeds from CEEMEA (Central and Eastern Europe, Middle

East, Africa) based source systems into Citibank's largest data

warehouse.

. Performed data mapping and data reconciliation for all source systems of

the 32 CEEMEA countries.

. Reconciled global Finance and Credit Risk data regarding all wholesale

portfolios in Citigroup to provide the inputs required for Basel II.

. Participated in Systems Testing and UAT to ensure data quality and

accuracy before providing the sign-off to going live. Created test cases

and test scripts in Mercury Quality Center.

. Spearheaded the STAR (Strategic Technology for Analysis * Reporting )

production support team which aims to improve data quality in the STAR

data warehouse, investigate and resolve data integrity issues, and

generated reports to be presented to Citibank Management and Country

Financial Controllers

Financial Reporting Operations for Bulgaria and Slovakia

. Provided business process and system support for head office financial

and management reporting.

. Supported the implementation of project tasks and system enhancements

affecting head office and regional reporting.

. Introduced process improvement activities for a more efficient financial

and management reporting. Improved both BG and SK's metrics grade to A.

. Provided Country Financial Controllers and Chief Financial Officer with

financial and management reports by querying and consolidating data from

various data warehouses

EMEA (Europe Middle East and Africa) Project Deputy Team Lead

. Provided production support to EMEA's finance data warehouse by

investigating and resolving data issues of data warehouse end users and

running data warehouse jobs.

. Created several SQL scripts to query and link different tables in the

data warehouse to ensure data quality.

. Participated in implementation of projects by gathering business

requirements, documentation and creating SQL scripts for testing

. Provided recurring and ad hoc reports as well as analysis to Citibank

Management in New York. Migrated MS SQL Server based reports and queries

to Oracle.

. Led the production support and process automation of the Transactor-

Erecon team and introduced process flow improvements to the general

ledger - subsidiary ledger reconciliation process.

Application Support Specialist January 2005 to

December 2005

Banco de Oro Universal Bank Pasig City, PH

IT Operations

. Conducted UAT testing with the Development team and end users. Deployed

production programs to the entire bank or in selected departments.

. Provided bank-wide support to end-user application concerns. This

entailed problem isolation and coordination with different departments or

vendors to address an issue.

. Installed and tested necessary software to workstations of the different

departments and branches of the bank.

Program Assistant September 2003 to

January 2005

Metrobank Foundation, Inc. Makati City, PH

Grants Program

. Managed, modified and maintained the Grants MS ACCESS database and

produced various reports using the database.

. Coordinated various donation turnovers, Memorandum of Agreement Signing,

training workshops, and allocated the budget for the said events.

. Preliminary review of project proposals received per month and drafted a

summary matrix of the proposals to be presented to the Executive

Committee for their final decision.

. In charge of troubleshooting software and hardware related problems.

. Assisted in maintaining and editing the Metrobank Foundation's website.

. Recommended technical requirements for an event.

. Produced multimedia presentations for events for the Metrobank

Foundation, Manila Doctors Hospital and Manila Doctors College.

EDUCATION

Bachelor of Science in Management Information Systems (MIS)

1999 - 2003

Ateneo de Manila University, Quezon City, PH

Ateneo de Manila High School

1995 - 1999

Ateneo de Manila Grade School

1987 - 1995

REFERENCES

Available upon request

Contact this candidate