Luis F.Santiago Col n
PO BOX *** Cayey, P.R.***37 Cell: 787-***-**** Home: 787-***-****
Email: ***************@*****.***
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