Ernesto C. PerezPersonal email: ecperez12@yahoo.comPermanent Address: 42 Simon St., Filinvest Homes, 4024, Binan, Laguna, PhilippinesMobile phone number: +639064440546

PROFILE

Self-motivated Sr. Business/Reports Analyst, with over 10 years experience in application support and reports development plus years of experience in dealing with all types of clients and managers. Apply my Customer Support background, Communications Skills and Reporting Capabilities to deliver Technical Support that exceeds client’s expectations and needs. Focused, disciplined and is a positive, strong, confident presenter. Gets along well with co-workers with a strong work ethic, and adapt quickly to continually changing work atmosphere.

WORK EXPERIENCETeleTech (0632) 71873112nd Floor, Robinsons Cybergate Plaza, Mandaluyong City 1554 Philippines

Senior Analyst (October 8, 2012 to present)Assigned to Enterprise Intelligence Group – GBS Lead Report Project Development for Senior Executives Interfaced with different sites and act as the Senior Business Analyst for their reports/system

requirements Interact with different Senior Managers and gather and clarify business reports requirements. Understand the business processes to identify the value drivers associated with the project. Contributing to the enhancement of reporting process flow and generation Provide Corporate KPI’s and Compliance Metrics reports Provide development and ticket troubleshooting support for reports develop by the EIG team Interact with different Managers, customers and gather and clarify business reports

requirements Develop reports for business managers from different data sources (SQL & Oracle) and

reporting tools (VMWare, Crystal Report, SSRS, SSAS, OBIEE & Excel spreadsheets)

Infor/Lawson Philippines Solutions & Services Center, Inc. (0632) 860-8000 local 793814th floor One World Square, Upper Mc Kinley Hills,Bonifacio Global City 1634, City of Taguig

Senior Business/Reports Analyst (June 2007 to August 31, 2012)Assigned to Business Systems and Reporting Provide level 3 support for reports develop by the BRS team Provides Senior Executives Corporate KPI’s and Compliance Metrics Lead Report Project Development for Senior Executives Interfaced with different sites (St. Paul, Minnesota, Stockholm, Sweden and Philippines) and

acted as the Senior Business Analyst for their reports/system requirements Interact with different Managers and gather and clarify business reports requirements. Understand the business processes to identify the value drivers associated with the project. Contributing to the enhancement of reporting process flow and generation Used LBI as report generating tool for various internal customers Championed the Documentation activities for the BSR group and provided expertize in SDLC

and CMMI process

Develop reports for business managers from different data sources (SQL & Oracle) and reporting tools (Crystal Report & Excel spreadsheets)

Intel Technology Philippines, Inc.Gateway Business Park, Javalera, Gen Trails, Cavite (046) 433-6820

IT Systems/Application Support Specialist (May 2003 to June 2007)Assigned to VF Reports and Systems Provide excellent sustaining support for reports develop by the BRS team Interfaced with different sites (Chandler, Malaysia, China, Costa Rica and India) and acted as

the Business Analyst for their reports/system requirements Interact with project teams with Application Developers, Testing Analysts, and Project

Managers and gather and clarify business requirements with the customer to understand the business problem.

Understand the customer’s business processes to identify the value drivers associated with the project.

Chaired bi-weekly meeting with different counterpart to resolve reports/system issues/concerns

Develop reports for manufacturing, planning, logistics and finance from different servers using SQL, Oracle, Crystal Enterprise, Crystal Report and Excel spreadsheets

Provide excellent sustaining support for the Virtual Factory reports/system Documented customer requirements (HLR), created design documents (DDD), provided test

scripts and installation guide including bat files, produced user guide and participated in Technical Review Group (TRG) and Change Management Board (CMB) process.

Continued to contribute to the training program of Intel University

Business Data Analyst (Aug 2000 to May 2003)Assigned to Planning Simulation System Interfaced with different sites (Chandler, Malaysia, China) to define their automation/system

requirements Chaired weekly meeting with different counterpart to define BKM and resolve project

issues/concerns regarding simulation. Analyzed system throughput and identified bottlenecks by using simulation models Reduced cycle time of a manufacturing system and reduced WIP Evaluated impact of changes in operating procedures, layout and processes through

simulation Developed buffer strategies and layouts to build superior systems based on Theory of

Constraints (TOC) Identified as one of the pool of trainers of Intel University

Technology Development Engineer (Nov 1996 to Aug 2000) Partner with local and foreign vendors to develop process and equipment to increase

production Delivered 2 locally developed equipment through partnership with vendors. One of the

equipment was also exported to other Intel site. Analyzed process and equipment and develop concepts and procedure to improve

productivity Introduce hands free materials transfer systems Introduce 3D modeling and mechanical and thermal analysis software Increased equipment utilization and improved work-flow Performed time studies and improved operating procedures to reduce manufacturing costs

INDUSTRIAL AUTOMATION/CONTROL

Air Hydraulics Authority Inc.

Carlo J. Caparas St., Bo. Ugong, Pasig City

General Manager (April to Oct 1996) Develop and implemented the business plan for Air Hydraulic Authority of Atlantic Plus Pacific

group of companies Handled sales and service of Air Compressor and introduce pneumatic and hydraulic system Conducted pneumatic and hydraulic training for the Sales and Marketing team

Festo Inc.Km. 18 West Service Road, South Super High Way, Paranaque 776-6688

Key Account Consultant (Jan 1991 to March 1996) Develop and handled the business plan for VIP customers Headed of the service and technical department Design and implement local exhibit design, set up and egress. Conduct new pneumatic product training for Sales and service personnel’s. Provided automation symposium for customersSpecial Projects Engineer (Oct 1986 to Dec 1990) Handled direct sales and service VIP customers Head of the service and technical department and in charge of local exhibitions Conducts new pneumatic product training for Sales and service personnel’s Conducts technical training for service and sales engineers Defined spare parts stock inventory and control

Technical Service Supervisor (July 1984 to Sept 1986) Headed the technical and service department and control box design and assembly In charge of exhibit design and set up Defined control box and accessories standards and inventory Conducts product training for Sales and service personnel’s

Technical Service (July 1981 to June 1984) Headed the technical and service department Design and assembly control system Define service schedules for service technicians Conducts technical training for service and sales engineers

Technician (Nov 1979 to June 1981) Provide service to customers Design and assembly control system Assist in the technical training for service and sales engineers

EDUCATION Business Management in De La Salle University (under graduate 1981) Industrial Technician major in Mechanical technology Don Bosco Technical College (March

1977 to Sept 1980)Award: Best in Workshop (Drafting)

High School, Don Bosco Technical Institute (June 1973 to March 1977). Preparatory technician course (Machine Shop)

TRAINING AND CERTIFICATION Certificate of Attendance in “Oracle9i Advance PL/SQL” (June 2006) Certificate of Attendance in “Oracle9i Database Administration Fundamentals I” (February

2006)

Microsoft Certificate of Achievement in “Course 2093 Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services” (July 2004)

Microsoft Certificate of Achievement in “Course 2373 Programming with Microsoft Visual Basic.net” (June 2003)

Center for Project Management Certificate of Achievement in “Managing Projects to Success” (April 2003)

Microsoft Certificate of Achievement in “Programming with Microsoft Visual Basic” (June1999)

COMPUTER SKILLS Platforms: IBM PCs Operating systems: Microsoft Windows Languages: VISUAL BASIC Software: Pro E, AutoPlan, Visio, Microsoft Projects, Microsoft Office, SQL, Oracle and

Crystal Enterprise system PLC Programming: Festo PLC, Matsushita, Entrelec and Maxtech Ladder logic programmer

TRAINING ABROAD Festo Pneumatic Pty., Ltd. Australia (July 5 to 31, 1981)

Control Box Assembly Basic PLC Programming

Festo GmbH & Co. Singapore (June 18 to 22 1990)Service Workshop

Festo KG (April 22 to May 1993)Hanover FairSales and Service Workshop

CHARCTER REFERENCESName Position Company Contact Number

Mr. Cocoy Lopez Sr. Manager Concentrix Philippines +6393-99033959

Mrs. Myla Obcena Manager Hubwoo +63 2 828 6940

Ms. Pinchy Czarina Ijiran Sr. Business Analyst Infor PSSC Inc. +639178035840

LIST OF MAJOR ACCOMPLISHMENTS

TelectechITFM

Spearheaded the development and maintenance of the ITFM that provided financial visibility of IT expenditures. ITFM resides in Vmware’s IT Business Management Suites – Out-of-the-box Reporting where in the system provides Executive dashboards and Cost Analysis. Maintaining the Cost Model periodically by adding/deleting elements and changing dependencies to reflect the current IT organization. The tool also provides immediate value to typical IT organizations, and introduces best practice object types, and common allocation rules that are used to allocate cost end-to-end, from the GeneralLedger to the Business Units. If needed, it can easily be enhanced to reflect any organization cost structure and data sources.

MSBITapped to be the BA for the Crystal report migration to MSBI and have completed the design documentation for almost all Teletech client well ahead of schedule. Also was task to be the Project Lead for the conversion and migration of Crystal report to MSBI, meeting, training and coordinating with various departments within Teletech to ensure flawless transition to the new reporting tool. Also created user guide documentation on MSBI reporting, subscription and support.

SSRS Created several SSRS reports that help Work Force, Operation and other departments. Some of the major report are the Kronos vs. Switch (Workbooth), Unmapped and Mapped Skills, Global Active Headcount and others

OBIEEAssigned to be one of the early engagement resource from EIG PH to help in dashboard development, validation and troubleshooting for Utilization and CSS group reporting projects. Developed several dashboards for CSS and as my BA part of the project, created user guides on system access to ticket creation. Also created documentation for the support team.

Infor/Lawson PSSC Inc.Sr. Business AnalystProvided business report solutions to PSSC (Philippines), M3 (Sweden) and S3 (St. Paul, Minnesota) Sr, Managers and generated Ad Hoc reports to aid Sr. Manager to assess time spent by the resource on a certain project and activity and also problem ticket metrics report. Provided technical expertise on SDLC process and created templates for Requirements and Design documents and championed BSR documentation activities

SLA Compliance ReportingGenerated and maintained SLA compliance reports for the briefing book and for the monthly, quarterly S3, M3 and X3 product platforms.

Business Intelligence ReportingI was the key resource for Crystal Reports and have conducted training for some of the business groups within Infor PSSC. I was also tapped by the X3 platform director to help out in the development of cloud reporting using Crystal Report to fix and upgrade report integrating bar code technology and automatic language conversion of the reports.

Intel Technology Philippines Inc.IT Systems/Application Support Specialist and REPORT BUSINESS ANALYST Provide business report solution for the different site system/report requirement. Work with project teams Application Developers, Testing Analysts, and Project Managers on large projects. Recipient of the Intel TMG (Technology & Manufacturing Group) Excellence Award for the Bin split Rank Generation and Assembly Test Planning Solution demonstrating Supply Network and Factory Responsiveness 16 May 2006. On smaller projects, perform the project management function, including scope, time and quality including data quality management. Interpret system/report requirement, converting it to a system requirement, provide the different data

sources to be used for the report/system development and identify the best report/system solution. Develop data loaders and reports using SQL, Oracle and Crystal Enterprise system and provided training and sustaining support. Drive resolution of report/system by participating in VF forums and provided prompt resolutions. Major projects involvements are ATD ATPS, WCCG ATPS, MARS VF Reports, and IA CBOM bundle 1, MFO Deviation Reports.

SIMULATION AND MODELINGAs the Business Data Analyst for Flash, I have analyzed system throughput and identified bottlenecks by using AutoPlan simulation models. We have successfully reduced cycle time of a manufacturing system and evaluated impact of changes in operating procedures, layout and processes through simulation.

Introduce 3D modeling with mechanical and thermal analysis using Pro E software. The tool greatly helps understand the mechanical fatigue and thermal stresses which dies/packages.Result of the analysis brought about changes in material specifications and process that are now being used as the BKM.

TOP LINER REMOVERConceptual design and supervised fabrication of the Top Liner Remover. The system was developed to address the manual removal of the top liner from the dies films and eliminate material damage. Fabrication and commissioning of the system was done with in a two month period and was successfully integrated to the assembly process flow. The said equipment was also ordered and used by other site.

GANTRY ROBOT SYSTEMMember of the design and commissioning team responsible for promoting hands free material handling system. The Gantry system is a pick and place systems for magazine loading/unloading for die attach machine and JIT oven.

JIT OVENDesign and organize fabrication of the JIT Oven. The oven is a top loading oven to be used for die attach magazine. The system is part of the Gantry system.

Festo Inc.PLCC DEVICE EXCHANGERCircuit design, Installation, Programming and Commissioning of Quad pack integrated circuit handling control system from plastic tube to magazine / magazine to tube using Pre-programmable controller for its logic operation and Pneumatic components for the actuators.

PULSEMATIC CONTROL DEVICECircuit design, Installation, Programming and commissioning of pulsematic control system. The system design controls the diversion of powdered milk from main hopper to sachet hopper / sachet hopper to main hopper including minimum / maximum level of both hoppers. The system also controls the air, pulse ejection of the dust collection system of the sachet hopper. The system was made possible by using electronic level control and programmable logic controller for its system operation.

GLATT POWDER DRYING MACHINECommissioning, Trouble shooting, calibration and rehabilitation of the Glatt powder drying machine. The Glatt powder drying is utilized to dry alcohol based powder mixture (medicine). The system uses Pneumatic logic control for its systems operation and Electrical control for the turbine motor.

POWDER FILLING MACHINERehabilitation of powder filling machine. The system before rehabilitation uses mechanical cams and electrical limit switches. With the old system's output were 40 cans per min. After rehabilitation and replacement of the control mechanism to Electrical and Pneumatic logic controls, the system is now capable of filling 70 cans per min. and a much accurate over and under fill control system.

GAS BOXDesign, Installation, Programming and Commissioning of the Gas Box from manual to semi automatic control system. The Gas Box is a gassing chamber wherein powdered filled can are subjected to vacuum and nitrogen pressure to prolong the storage life of the powdered milk. The pre-programmable controller installed monitors the vacuuming time, nitrogen purging time and cycle time. It also controls the vacuum pressure in which if vacuum pressure is not attained, an alarm would indicate such failure.

LIQUID FILLING MACHINEDesign, installation and commissioning of volumetric filling, gravity filling and other filling system using Pneumatic, Electrical Pneumatic and Electronic control system for different types of liquid for different types of industry.

LIQUID LEVEL CONTROL SYSTEMDesign, installation and commissioning of various kinds of liquid level control system using Pneumatic, Electrical Pneumatic and Electronic components for minimum / maximum level control and over / under fill for liquid level control.

3 LEVEL ELEVATOR CONTROL SYSTEMSDesign, installation and commissioning of 3 level elevator with 3 remote switch boxes (2 switch per box, 1 box per floor), over shoot safety devices, emergency stop push button and emergency stop door open system. The system is controlled by electrical logic circuit.

PRINTING MACHINE USING SILICON PADDesign, installation and commissioning of Electrical Pneumatic control for manual, semi-automatic and automatic logic control. The manual control is used for individual actuation of the printing pad and the ink mixing process. The semi-automatic sequence is similar to the automatic cycle but single cycle only. The automatic cycle is the continuous cycle of the system.

LEVEL CONTROL FOR SILOS / HOPPERSDesign, installation and commissioning of level control of different silos using Electrical Pneumatic and Electronic control system. The system also includes the vibrator / knocker, opening / closing of gates, conveyor motors and weighing systems.

SILK SCREEN PRINTING MACHINE (FLAT AND ROUND MATERIALS)Design, installation, commissioning and programming of flat and round materials silk screen machine using Pneumatic, Electrical Pneumatic and Electronic control system for different types of silk screen application.

BOTTLE BLOWING SYSTEMDesign, Installation, Programming and Commissioning of bottle blowing machine. The machine is used in line a bottle conveying system wherein the bottles are being inverted and blown by clean air prior to the filling operation. The systems logic operation is controlled by a Pre-programmable controller and Pneumatic components for the actuators.

GROSS LEAK MILITARY BOMBINGDesign, Installation and Commissioning of the GROSS LEAK MILITARY BOMBING control system. The system is utilized for the testing of integrated circuits to different pressure for a

certain period of time. The pressures are set for commercial and/ or military use I.C. by means of a selector switch. The system controls 12 bink's pot chamber and could be run simultaneously.

POLYMOLD ON LOAD SYSTEMDesign, Assemble, Commissioning and Programming of the POLOMOLD ON LOAD SYSTEM. The system utilizes air over oil system to attain high accuracy in the positioning of the lift cylinder. This system was used for the mat finished integrated circuit to eliminate scratches on the package. The system was highly appreciated by the end user and has solved one of their major problems. The system now produces less than 1% reject from scratches from as high as 30% before the system was installed. The main control used in the system was a pre-programmable logic controller.

PICK AND PLACE FOR POLYMOLD DEFLASH, TRIM AND FORM ON LOAD SYSTEM.Assist in the concept design, installation, programming and documentation of the Polymold deflash, trim and form on load system. The system is designed to eliminate scratches on the matt finished packages. The system utilized a pre-programmable controller type FPC 202 for its logic operation, D.C. motor for the magazine lifter, electronic and proximity switches for its input signals and pneumatic cylinders and solenoid valves for its working elements. The system utilized the pick and place principle to feed the matt packages one at a time to eliminate package to package scratching. The system has eliminated the on load scratching by 100%.

SCISSOR LIFT CONVEYING SYSTEMThe system was designed to control the flow and transfer of the materials from one conveyor to the next conveyor. The system was designed to ensure the proper distribution of the material and monitoring of the flow of the materials. The system utilized electrical components for the logic operation, pneumatic stopper and lifter cylinder.

SACHET FILLING SYSTEMElectro-pneumatic circuit design, assembly, installation, documentation of the control system. The former system was purely manual with mechanical linkages. With the installation of the Electro-Pneumatic control, the system improves the quality and filling accuracy of the system at the same time increase productivity by 100%

Other simple robotics system of different types controls for different types of application and different types of industry.