Luis F.Santiago Col n

PO BOX *** Cayey, P.R.***37 Cell: 787-***-**** Home: 787-***-****

Email: abygr2@r.postjobfree.com

Professional Profile

> IT professional with over 20 years of experience in Electronic

industry, Medical devices (FDA Regulated), Automobile, Bank and

Telecommunications industry.

> Hold different positions and responsibilities in IT. Such as IT Sr.

Business Analyst, System Analyst, Programmer Analyst, IT QA

validation, Business Intelligence.

> Experience on computer languages such as RPG, RPG IV, RPG ILE, RPG

Free-Format (with procedures), CLP, SQL, SDA, RLU API Calls, Data

Queues, Visual Basic, VB.NET.

> Experience on Computer system validation. Create and review Risk

assessment, Design Document, IQ, OQ and PQ documents.

> Experience on iSeries systems as administrator.

> IT 6 Sigma Green Belt Certified

> Strong ability to teach end users.

Technical Experience and Proficiency

Technical Skills:

> RPG (RPG IV,ILE, Free Format) Language. CLP, SDA (with subfiles), RLU,

Data Queues, ERP Mapics software (versions 5.0 and 6.0)

> iSeries Utilities: Showcase, Robot, Aldon.

> Microsoft Office (Word, Excel, Power Point, Access, Outlook, Project

Manager), Easy Label, Scanning software File Director

> iSeries OS troubleshooting and configuration

> QuikTrac Software (Barcode)

> HP ALM Quality Center

> Oracle SQL (8i)

Exposure to:

> SAP MM, SD, PP

> Visual Basic, VB.NET

> SQL (Triggers, Store Procedures, Constraints)

> HTML, PHP, CSS, JQuery, JavaScript

Professional Experience

Business Intelligence Administrator, Claro-Guaynabo, P.R 04/2013 - Present

> Develops, implements programs, and special projects related to the

information systems of the

Vice Sales and Marketing or Customer Service.documentation, system

enhancements, and project management. Apply the provisions to assure

compliance with current laws, regulations, local and corporate policies,

procedures and standard.

IT Business Analyst, Developer, IT QA Consultant. Puerto Rico 07/2012 -

04/2013

> Translate business requirements of an organization into logical and

technical operations to be performed by computer systems. Conduct all

system analysis activities in this area, including configuration,

programming, system design, documentation, system enhancements, and

project management. Apply the provisions to assure compliance with

current laws, regulations, local and corporate policies, procedures and

standard.

o PRMS Account Code automation system At Integra, A asco, P.R.

07/2012 - 04/2013.

. Modify PRMS system to include an option to automatically

assign General Ledger account to a Account Code system when a

MI (Miscellaneous Issue) transaction is created.

. Create menu options for create/update the Account Code.

. Create menu options for approval request.

. Create Functional and Test documentation following Corporate

procedures.

. Technology used: RPG IV, RPG Free format with SQL, ERP

system PRMS, AS400

o PRMS Forecast automation system At Integra, A asco, P.R. 12/2012 -

04/2013.

. Automatic load of forecast information to PRMS system

. Technology used: RPG IV, RPG Free format with SQL, ERP

system PRMS, AS400

o Software Test and Certification At Evertc Inc. Cupey Puerto Rico

09/2012 - 12/2012

. Test Web Software applications.

. Technology used: HP ALM Quality Center Software

Sr. IT Business Analyst, Pall Life Sciences-Fajardo, P.R. 05/2007 - 04/2012

> Support Mapics to SAP Data migration. Develop programs in RPG to extract

Mapics information used to load into the new SAP system. Support to

different sites, and countries.

o Duties includes: create programs to extract data from Mapics based

on the SAP requirement for Modules as such MM, SD, PP.

o Technology used: RPG Free format, CLP, SDA, Microsoft Excel,

MAPICS, DB2

> Support Mapics environments consolidation. Consolidate 14 environments in

1 environment. All company sites will be on one environment.

o Duties includes: create or modify programs that will be used in the

new environment, avoid conflict between sites.

o Technology used: RPG IV, RPG Free Format, CLP, MAPICS, AS400

> Project Manager on Scanning System, for Quality Assurance (QA) and Human

Resources departments. For QA to storage product documentation to

facilitate the retrieval of the documents that help internal and external

audit. For HR to storage Employees warnings.

o Duties includes: Work with a budged, recommends hardware and

software, research and hire external resources. Create or review

validation protocols such as Risk Assessment, Installation,

Qualification, etc. Create standard procedures and provide training

to users.

o Accomplishment: Now all documents can be retrieved electronically,

quick retrieval of documents.

o Technology used: SQL 2008 Server, File director

> Project Manager for Labeling System on Medical area. Define requirement,

software selection, and system validation following FDA requirements.

This project helps to increase label generation performance on packing

area. From one PC/Printer the system was changed to 3 new PC/Printers,

with capacity to expand to more equipment if required. Something that was

no possible before.

o Duties includes: Work with a budged, recommends hardware and

software, research and hire external resources. Create or review

validation protocols such as Risk Assessment, Installation,

Qualification, etc. Create standard procedures and provide training

to users.

o Accomplishment: New system is five times faster than previous, and

at the same time now packing area have three PCs instead of one.

o Technology used: VB6, SQL, Easy Label software

> Support in New Barcode system. Support project manager on development of

scripts used in the barcode system. Automation of Mapics inventory

transactions using barcode and scanners.

o Duties includes: Review validation protocols, create script

programs for the system and provide training to users.

o Technology used: SQL Scripts, Quik Trac

Programmer Analyst, Eaton/Cutler Hammer, Las Piedras, P.R. 07/1997 -

05/2007

> Develop of system programs in RPG, for Mapics software such as:

o Automatic order creation. Help to reduce backorder, creating orders

to fill shipping plant raw material inventory.

o Most of the programs were created on RPG, but some were created on

VB.NET. These programs were created as a complementary of the

system. Those programs allow the user to see quantity open of the

orders, and to see which shipments are on the process to be

completed.

o Accomplishments: Backorder decrease 45%.

o Technology used: RPG IV, RPG Free Format, CLP, RPG ILE Procedures,

RLU, SDA, AS400 SQL, VB.NET, AS400

> iSeries OS:

o OS software installation, Security administrator, and hardware and

software troubleshooting

> Overall duties include program system development, software installation

on iSeries system that includes operating system, and 3er party software.

Also user profile creation, and system administrator troubleshooting.

Also analyze and recommends new iSeries systems when the lease of iSeries

expire.

o Technology used: CLP, Work Management, Security, MAPICS, AS400

Programmer Analyst, Toyota de Puerto Rico, Hato Rey, P.R. 1996-1997

> Support of in house systems: Parts and Vehicle.

o Duties include creation and modification of in house Parts and

Vehicle programs.

> Automobile system program and data conversion from S36 to AS400.

o Duties: Change programs RPG and CLP (when necessary) to run in a

new AS400.

o Accomplishment: Running in a new system increase Automobile system

performance over 200%.

o Technology used: RPG II, S36 Procedures, DFU

Programmer/Computer Operator, Wittnauer International, Cayey, P.R. 1990-

1996

> System daily operations support.

> Develop programs when required.

o Duties include help in accounting department with the data entry,

reports generation, and program development in RPG for Mapics

system.

o Technology used: RPG II, Mapics, AS400

Education

> Bachelor's degree in Computer Science, Interamerican University,

Hato Rey, P.R. - 1990

> Associate Degree in Computer Science, Instituto Technologico,

Guayama, P.R.-1987

Contact this candidate