Andre Walter Robin

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