MICHAEL LOPENA MENESES

Address: ** **** ****** ******* ** 10701

Email: abz2ed@r.postjobfree.com

Cell Phone : 914-***-****

RELEVANT EXPERIENCE

An experienced ERP developer, analyst, educator and a leader with over 10 years of experience in the

various areas of the ERP (Enterprise Resource Planning) and Systems Analysis and Design.

Experience includes a concentration in implementation of Glovia ERP / PRO-IV solutions.( Glovia is a

subsidiary of Fujitsu, and is one of the world’s most experienced and solidly backed enterprise software

firms). Has deep knowledge of the entire manufacturing system and the entire financial system. Has

excellent background in ORACLE PL/SQL programming and developed thousands of ORACLE Stored

Procedure, Triggers, Functions and Packages.

• Strong Experience in all aspects of Manufacturing.

• Strong Experience writing complex queries in PL/SQL.

• Strong Experience writing Oracle Stored Procedures, Triggers and Functions.

• Strong Experience in Database Performance tuning.

• Strong Knowledge of best practices related to database design, data integrity and normalization.

• Strong Experience with ETL process.

• Strong Experience in importing/exporting data to/from the Oracle Database using the SQL

Loader and the TOAD Import/Export Utility program.

o CSV to Oracle Database

o Excel to Oracle Database

o Oracle Database to CSV

o Oracle Database to Excel

KEY ACCOMPLISHMENTS

Glovia Consultant at Caterpillar Corp. - (January 2012 – May 2013)

Company Name : Caterpillar Corporation, Peoria, IL

Roles and Duties/Responsibilities:

• Educate some of the key players in the planning dept and IT dept on the business of Glovia’s

MRP. How it works, how it generates the schedule, how to read the planning exceptions,

how to read the planning results.

• Proposed database maintenance every month like re-indexing of database, running the

database analysis, archive of the very large database, cleaning up all temporary files.

• assisted the users on their daily issues.

• Developed an Oracle Package that automatically completes the work order.

• Developed an Oracle Package that consolidates the shipments that is an output from the MRP

systems.

• Responsible for the BOM download program, utilize the use of SQL loader for the project.

• Created a new index file for a 24 million rows, this helps the processing time for the other

team who uses the file for their report.

• Responsible for the creation of an oracle view for better and easy data access by the third

party software.

• Responsible for the creation of an oracle stored procedure that output the data to the reference

cursor. This will give the third party application an output from the stored procedures. The

stored procedure was used as a data set for their report.

• Developed the Scan on Receipt Project. The idea of the project is to capture the segment 18

of the EDI and stored that to the table.

• Developed EDI 860, this is the PO/Supplier Change EDI.

• Responsible for Data Extraction of the following: Engineering Data, BOM components and

Planning data into Existing Oracle Database.

• Responsible for Data cleansing, normalization, summarization and integration of data for the

MRP project.

• Converted some Glovia flat screen to a GUI screen.

• Responsible for the creation of a complex stored procedures that will be used for the Oracle

Report.

• Responsible for the Extraction of the engineering data to the BI tools.

• Responsible for the Loading of the BOM to the BI tools.

• Responsible for the OLTP and OLAP; Duties Includes:

o Writing stored procedures and call a SOAP web service for the following Transaction

and Analytical Processing

Sales Invoice

Vendor Invoice

Work Orders

Inventory Movement

Accounts Payable

Accounts Receivable

Sales Order

Work Order

Quality

Glovia Consultant at Daktronics - (January 2010 – January 2012)

Company Name : Daktronics – Brookings South Dakota

Roles and Duties/Responsibilities:

Responsible for Glovia 4 to Glovia 9 Migration. Duties Include the following

•

- Created a project plan for migration.

- Converted all pro-isam files to oracle table

- Converted all update programs to oracle stored procedure.

- Setup a new oracle sequence number for odometer.

- Created a new user profile for Glovia 9, a total of 385 users in all facilities.

- Created a training plan for the end users.

- Setup education environment for the end users.

• Responsible for applying the latest patch of Glovia.

• Developed an Oracle Job that automatically empty all work tables.

• Created an oracle stored procedure that outputs the data to the reference cursor. The stored

procedure was used as a data set for the SQL report.

• Developed an oracle view for better query of the datasets. The view was used by the SQL report

as a data set for the SQL report.

• Developed a job that runs the statistics on the table every month.

Glovia Consultant at Maxima Technologies - (January May 2009 – December 2009)

Company Name: Maxima Technologies – Lancaster, Pennsylvania

Roles and Duties/Responsibilities:

• Responsible for the development of Automatic Payment.

• Responsible for the development of the Net Change automation.

• Assists the end users on the daily issues specially the EDI process.

• Support the high level design, build / development, testing, roll out, training and change

management activities associated with implemented new Customer Release processes and

systems on an enterprise scale.

• Automate the Work Order MFG Close. This automation saves the Planning Department 20 or

more hours of work every week.

Sr. Systems Analyst - Glovia USA - A Fujitsu Company (Sept. 17, 2007 - April 30, 2009)

Analyze customer requirements and create a technical specification of the project.

•

Analyze customer requirements and propose a project estimates.

•

Maintain customer’s patch level up to date.

•

Glovia Customers that I worked for are the following :

•

Daktronics - South Dakota

o

Metal Works Processing - Texas

o

Oilstate - Texas

o

National Oilwell Varco - Texas

o

RTI - Alabama

o

Maxim Lighting - California

o

Glovia ERP Senior Analyst Programmer - American Railcar Industries / American Car

Foundry Company ( August 27, 2001 - Sept. 14, 2007)

Documents all process and procedures for Glovia system usage.

•

Caters all Glovia User’s requests and questions.

•

Conducts a user training on the BRC system. Responsibility Includes

•

Setup the tax jurisdiction table for US and Canadian Plant.

o

Setup default value for some customers.

o

Setup default value for inventory transactions.

o

Setup default value for Accounts Receivable and Accounts Payable.

o

Authored all Oracle stored procedure that enhances all the custom functions performance.

•

Authored the automatic creation of the shipping documents after the sales order was done.

•

Authored a job scheduler program written in PRO-IV. This program fires every night and

•

executes all the functions maintained in the database.

Converts all mainframe programs to a PRO-IV program. Duties include the following:

•

Created all ORACLE Stored Procedure and interface it with PRO-IV.

o

Created a PRO-IV utility program that will extract data from EXCEL Spreadsheet.

o

Act as a Project Leader in migrating GLOVIA 4.2 to GLOVIA 7.1. Duties were as

•

follows -Creates lists of all custom functions and custom

files.

Activated series of steps in migrating custom function from version 4.2 to 7.1. These

o

steps explain how to migrate the custom files and functions to GLOVIA 7.1.

Converts all custom files to ORACLE 9i.

o

Converts all custom functions to GLOVIA 7.1.

o

Tests all custom functions. Test includes a documented test scripts.

o

Invented a new menu system for all the users.

o

Member of the team that converts the Engineering Project System from the mainframe to a

•

WEB Application using a .NET Platform. VB.NET was the software used to code the project.

Implemented inquiry screens for Web Application.

o

Responsible for all FTP processes, created a script that would generate a flat file and transfer

•

this file into another environment (from SQL to ORACLE). Created the actual data information

using the DTS package of MS-SQL service.

Authored an ORACLE Databases View where the data comes from the other databases (MS

•

SQL) thru GATEWAY. This Database View was used in our GLOVIA custom function.

Implemented some ways economical/practical approach in saving supplies like bond papers.

•

Have added an option to all report programs whether the user wants to download it to Excel, or to

print it on the screen or to the printer. The strategy used was to view the report first and figure

out if the user has to print the hardcopy,

Assigned to re-write the Billing Repair Card that is integrated to GLOVIA. Six developers

•

customized the BRC system and I was the 7th person who successfully handled this. The said

system was not efficient enough because of the program structure. Solutions to resolve the

problems are as follows:

- Converted some PRO-IV function to stored procedures

•

Re-structured the program flow by eliminating unnecessary procedure calls.

o

Converted all updates to stored procedure.

o

Converted non-GUI screen to a GUI screen

o

Systems Consultant - Modis Consulting. (Jan. 25, 2001 - August 24, 2001)

Assigned to support American RailCar Industries (ARI) for their daily activity. Activity

•

includes the following:

Responsible for the maintenance of the GLOVIA systems.

o

Responsible for all customization projects on GLOVIA systems.

o

Responsible for all the troubleshooting on both GLOVIA and Non-GLOVIA

o

application.

Senior Programmer Analyst - Merz Pharmaceuticals (Aug. 26, 2000 - Jan 19, 2001)

Controls the customization program on Sales Order, Work Order and Detail Capacity.

•

Authored the customization program that automates the conversion of Sales Order to Word

•

Order.

Supervising Application Engineer - Uniserv Systems International, Inc.

(formerly Weserv) - Fujitsu Company (November 1997 - January 2000)

Supported Various GLOVIA customers in ASIA and USA:

•

MERZ Pharmaceuticals, Greensboro, North Carolina, USA (Nov - Dec 1999) - Responsible for

migrating Chess 3.2 (Glovia) to 4.2 standard GUI program. Responsible also for the development of SO

to WO automatic conversion program.

LACIE Int’l - Responsible for the migration of Chess 3.2 to Glovia 4.2. Work done in Glovia

International at El Segundo, California, USA (Oct - Nov 1999)

EATON Corp. - Beverly, Massachusetts, USA (Jan 1999 - May 1999) - Responsible for the

development of the worldwide distribution feature customization in GLOVIA. Activities involved were

analysis and design, programming and testing.

DELL - Penang, Malaysia (June - October 1998)

Involved in Dell’s migration activity for Y2K testing and documentation.

•

Responsible for the preparation of all necessary documents for Y2K i.e. the test script, base

•

procedure, test case master list, test case matrix, date query and the function level documentation.

PHILIPS - Makati / Las Pinas, Philippines (January - May 1998)

Involved as Lead Support Engineer in Philips customization project in Makati and Las Pinas.

•

Performed Superlayer software installation for Philips in Las Pinas.

•

Conducted QA Testing for the following projects:

•

Performed system testing on the module of Accounts Payable of FinWise - a financial

•

application product of WeServ Systems International.

Involved in the development of Human Resource Professional (HR-PRO) as a lead

•

analyst/designer.

•

Designed the Training Module of the HR-PRO

o

Supervised the development of the project.

o

Train some personnel’s involved in the project.

o

Incharge of Weserv’s Home Page using HTML.

•

Part of the team that converts Chessa 3.2 (text based) to GLOVIA GUI. Project done at Fujitsu

•

Philippines - Weserv’s Office in Makati City, Philippines

Acted as Instructor for the following in-house training : Manufacturing Industry for Fujitsu

•

Philippines Account Managers, GLOVIA Sales Order, Costing & Financials.

Analyst/Programmer - Toyota Motor Philippines (April 1996 - September 1997)

Acted as the team leader of the finance and administration team.

•

Involved in reconstructing the payroll system under AS/400 using RPG/400 as the development

•

tool.

Involved in customization activity of Import/Export system using Microsoft Foxpro.

•

Involved in customization activity of Fixed Assets module using Clipper version 5.0

•

Responsible for module “one check voucher several payee” of Toyota Motor Philippines.

•

Analyst / Programmer - Toyota Motors / Dammam, Kingdom of Saudi Arabia

(July 1994 - February 1996

Responsible for the development and execution of Toyota Motors - KSA inventory systems,

•

from

requirement gathering down to implementation.

Responsible for the installation of the network operating system - LANSMART.

•

Responsible for the development of the following in-house systems:

•

Inventory multi-user system

o

Billing system and

o

Procurement system

o

Maintains of all running Inventory system.

•

Implemented the nationwide inventory system. This involves the module

•

testing, on-site connectivity testing, preparing/updating the user’s manual and training.

Worked on users request regarding program bug corrections, program modification and

•

enhancements, additional function and reports.

Lead Programmer - First Women’s Credit Corporation (November 1992 - May

1994)

Responsible for the development of the payroll system using MS Fox Pro 2.6

•

Acted as one of the analyst and lead programmer for the loans granting module of the loans

•

management system.

Analyzed business process, wrote process flows and program specifications.

•

Coded programs for the on-line granting module. Responsible for the module testing and

•

enhancement.

Other duties were ensuring data integrity and protection. Monitoring the databases for LMS

•

requirements and fragmentation.

Responsible for the daily and monthly backup of all databases nationwide. Generates a

•

consolidated report thru the database coming from all branches.

Responsible for the development and maintenance of the users authority management system.

•

Involved in the orientation and training of end-users on Loans management system.

•

TRAININGS & COURSES ATTENDED:

October 18, 1993 - Computerized Accounting Systems For Decision Making, held at Hotel

•

Intercontinental, Makati, Philippines

Comprehensive system analysis and design - Feb. 24 - March 25, 1995

•

Introduction to IBM AS/400 - March 1 - 5, 1995

•

Basic RPG programming - March 8 - 19, 1995

•

Advance Object Programming in Clipper - Jan - March 1995

•

FoxPro for windows Programming - March - June 1995

•

Oracle 7 in-house Toyota Motor Philippines - June - July 1996

•

RPG/400 in-house Toyota Motor Philippines - April - May 1996

•

Supply Chain Management in-house Toyota Motor Philippines - Jan - Feb 1996

•

February 1998, Supervisory Management, held at Angelinos Pasay Road Makati City

•

July 26- 30, 1999, Building Web Applications Using Visual Interdev 6.0, held at Dominion

•

Bldg., Makati City, Philippines

February 2003, Introduction to Visual Basic.NET

•

Glovia Financials - July 12 to 15 2004 held at ACF headquarters. Training conducted by a

•

consultant from Glovia (Ms. Carol Autry).

Glovia Multi-Currency - Sept 13 - 15 held at ARL headquarters. Training conducted by a

•

consultant from Glovia

EDUCATIONAL BACKGROUND:

October 1992, Bachelor of Science in Computer Science, University of the East, Recto Manila

•

March 1988, Jose Abad Santos High School, Reina Regente Binondo, Manila, Philippines

•

March 1984, Rosauro Almario Elementary School, Kagitingan Stree Tondo, Manila, Philippines

•

Contact this candidate