SA 046 SAN ANTONIO, JAGOBIAO
MANDAUE CITY CEBU, 6014
- | --|-
ANDRE WALTER D. ROBIN
KEY SKILLS
ANALYTICS
:
Experienced Business Systems Analyst/Data Quality Analyst that focus on
analyzing, and problem solving related to data, types of data, relationships
among data elements within a business system or IT system using various
RDBMS and reporting tools.
TEAM PLAYER : Enjoy sharing of knowledge and encouraging development of others to achieve
specific team goals.
Refined planning and organizational skills that balance work, team support and
ad-hoc responsibilities.
SKILLS
WORK HISTORY
SQL (Oracle/Teradata/SQL Server/MySQL)
SQL Tools (Oracle SQL Developer/Teradata SQL Assistant/SSMS/SQL WorkBench/J
Microsoft Power BI
Business Objects Infoview / BI Reporting
Amazon Web Services (Athena)
Basic knowledge on ETL process
SAP Netweaver Portal
SAP Data Manager (Repository)
Project Management
HP Quality Center / HP ALM – Quality Center
PLM Enoiva
MS Office
PC Building
Basic PC troubleshooting
Auto CAD
MFG Pro
SENIOR BUSINESS SYTEMS ANALYST – MDM COE LEAD
Lexmark Research and Development Corp.
Lexmark Plaza 3 Samar Loop cor. Panay Road
Cebu Business Park, Cebu City
December 07, 2009 – Present
MDM COE Team Leader
MDM COE UAT coordinator
Analyze and mine business data to identify patterns and correlations
among the various data points.
Map and trace data from system to system in order to solve a given business or system
problem.
Design and create data reports and reporting tools to help business executives in their
decision-making.
Perform statistical analysis of business data.
Write SQL scripts based on the given business rules and responsible for improving data
quality and presenting conclusions gained from analyzing data using various RDBMS
and statistical tools.
Working closely with data architect and project managers on system development and
business users on writing test cases for User Acceptance Testing and identify data
related problems and resolutions.
Ensures that realistic data quality expectations are consistent with business processes
and conforms to the quality expectations.
Validate data in line with the business rules and come up with a report for data
governance council meeting in Lexington.
Ensure that adequate information gathered including changes on business rules applied
to every SQL query used in the scorecard.
Perform data profiling and cleansing.
Diagnose root cause for poor data quality.
Develop and implement process and procedures to rectify such data
and the processes that generated it.
MATERIAL PLANNER/PRODUCTION PLANNER – LOGISTICS DEPARTMENT
LEAR Corporation EEDS and Interiors
Lear automotive Services (Netherlands) B.V. Philippines Branch
MEZ 1, Lapu-Lapu City, Cebu, Philippines 6015
February 02, 2009 – December 04, 2009
Page | 2
Support and participates Six Sigma initiatives
Handle material requirement planning and procurement for both
direct materials.
Communicate to supply coordinator and vendor or any material
expediting/procurement issues.
Checks and sees to it that the production scheduling is entered on
time and correct.
Analyze the expediting report every week and make a critical list to
be distributed to all production Supervisors, Managers and
warehouse personnel.
Maintain accurate periodic materials inventory data for effective
planning and control.
Coordinate fully with production planners regarding changes on
production schedules and priorities.
Coordinates with warehouse supervisor and storekeepers regarding
materials inventory status and issuances.
Responsible for material procurement and tracking of all active
prototype and sample parts.
Performs data entry adjustment and maintenance of system files
related to inventory.
Provides management report ( i.e. inventory, airfreight, AETC, etc…)
Dispose and analyze inactive materials (re-use, rework, offer to other
plants, scrap)
Participate actively in company-initiated activities. (i.e. cost reduction
program, safety program, etc.)
Andre Walter D. Robin
Comply with company rules and regulations EH and S policy.
Does other duties and functions as maybe assigned by Materials
manager.
Prepares and submits Airfreight request to supply coordinator for
critical parts.
Prepares and submits monthly QOS report. Measurable is AETC.
Prepares and submits actual raw material inventory every week.
Prepares a list of parts to be cycle counted every week.
Responsible in assuring that appropriate safeguards are in place,
which have direct impact on the health and safety of associates and
the environment.
Responsible in maintaining the highest level of integrity in its business
dealings with associates, people and organizations wherever we
operate to its highest ethical standards.
Maintains a friendly relationship with suppliers as well as with the
internal and external customers.
SAMPLES PLANNER – PRODUCT RESEARCH AND DEVELOPMENT DEPT.
Mehitabel Furniture, Inc. Plant 2-LFI
Tac-an Road, Talamban, Cebu City, Phillipines
Jan. 23, 2007 – February 06, 2008
Page | 3
Coordinates and updates sample shop manager and PRD manager on
current work loads of PRD sample shop.
Plan, schedule, and monitor sample construction in the sample shop
according to priorities.
Issue cutting lists to sample shop and planning section for the
construction of the sample items.
Ensures that sufficient customer specifications is in order for a sample
to be completed (hardware, locations, type, finish, packing, and other
related tasks.
Maintains systematic filing of all materials and documents as well as
communications received.
Review materials requirements lists and ensure the timely availability
of required materials and hardware in coordination with
planning/inventory.
Generate material requirements planning for materials needed by the
sample shop on a regular (monthly) basis.
Raise materials purchase requisition based on material requirements
of an item(s) to produced or base on the generated MRP for
purchasing or foundry work.
Monitor and follow up purchase requisitions submitted to Purchasing
to ensure that materials requested arrive on time.
Coordinate and monitors sub-contractors for job-out work, costing
and schedule compliance.
Receives material requirements.
Update material requirements list regularly.
Andre Walter D. Robin
Monitor the status of sample items regularly
Receives materials requirements
DELIVERY PLANNER – PRODUCTION CONTROL DEPARTMENT
Taiyo Yuden Semi-conductor (Phils), Inc.
MEPZ I , Lapu-Lapu City, Cebu Philippines 6015
EDUCATION
TRAININGS
Uses highly sophisticated application software for planning, sales, and production
control.
Responsible for all shipments of all LF LK products (semiconductors) for Taiyo Yuden’s
Sales Centers.
Responsible for scheduling of shipments of ordered items and quantity for Taiyo
Yuden’s Sales Center.
Receives orders from Taiyo Yuden’s Sales centers from Singapore, Hong Kong, Taiwan,
Korea, China, Japan, USA, and Germany.
Checks and confirm through Electronic Data Interface (EDI) the delivery schedule based
on the availability of stocks, work force, and machine.
Answers request from Sales center through phone and e-mails.
Prepares shipping details for each sales center.
Monitor Shipment plan vs. actual shipment
Coordinate with the production and sales supervisor, and production line leaders
regarding the urgency of the ordered items in the production area and sales section.
Discuss the total shipment and remaining purchase orders (PO’s) with the planning
supervisor.
Administers Basic Orientation Program for new intake employees
BACHELOR OF SCIENCE IN COMPUTER ENGINEERING
University Of San Jose-Recoletos
Magallanes St. Cebu City
1998 – 2003
ORACLE DATABASE 12C R2 : INTRODUCTION TO SQL ED 2
Oracle University Training Class
DB Quest Inc.
Unit 2606 Antel Global Corporate Center, #3 Dona Julia Vargas Avenue,
Ortigas Center Pasig City 1600
March 13 – March 17, 2017
5’S JAPANESE HOUSEKEEPING TRAINING
Plant Gabriela Training Room
Lear Corporation, MEPZ I Lapu-Lapu City
Cebu, Philippines 6015
COMPUTER TECHNICIAN
IECEP-TESDA Training Center
Archbishop Reyes Avenue, Cebu City, Phils.
July 11, 2005 to July 15, 2005
Page | 4
Andre Walter D. Robin
PERSONAL COMPUTER TROUBLESHOOTING
Rm. 213, University of San Jose-Recoletos
Magallanes St. Cebu City Phils.
February 2003
PERSONAL COMPUTER BUILDING
PC Builders Club, Cebu City Headquarters
March 2, 2002
MARITIME TRAINING
University of Cebu
Maritime Education and Training Center
Alumnos, Mambaling, Cebu City, Phils.
October 02, 2006 to October 10, 2006
BASIC SAFETY TRAINING
( Regulation VI/1 of the 1978 STCW Convention, as amended )
PERSONAL SURVIVAL TECHNIQUES
( IMO Model Course 1.19 )
FIRE PREVENTION AND FIRE FIGHTING
( IMO Model Course 1.20 )
ELEMENTARY FIRST AID
( IMO Model Course 1.13 )
PERSONAL SAFETY AND SURVIVAL RESPONSIBILITY
( IMO Model Course 1.21 )
Page | 5
Andre Walter D. Robin