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 (Oracle & Microsoft), 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:

• 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 (11i)
• SAP MM, SD, PP
• Visual Basic, VB.NET
• SQL (Triggers, Store Procedures, Constraints)
• HTML, PHP, CSS, JQuery, JavaScript

PROFESSIONAL EXPERIENCE:

Business Intelligence Administrator

Confidential, PR

Responsibilities:

• 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

Confidential

Responsibilities:

• 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.
• 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
• PRMS Forecast automation system At Integra, Añasco, P.R. .
• Automatic load of forecast information to PRMS system
• Technology used: RPG IV, RPG Free format with SQL, ERP system PRMS, AS400
• Test Web Software applications.

Technology used: HP ALM Quality Center Software

Sr. IT Business Analyst

Confidential, Fajardo, PR

Responsibilities:

• 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. create programs to extract data from Mapics based on the SAP requirement for Modules as such MM, SD, PP.
• TRPG Free format, CLP, SDA, Microsoft Excel, MAPICS, DB2
• Support Mapics environments consolidation. Consolidate 14 environments in 1 environment. create or modify programs that will be used in the new environment, avoid conflict between sites.
• 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.
• 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 to users.
• Now all documents can be retrieved electronically, quick retrieval of documents.
• SQL 2008 Server, File director
• Project Manager for Labeling System on Medical area.
• Define requirement, software selection, and system validation following Confidential 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.
• 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 to users.
• 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.
• Duties includes: Review validation protocols, create script programs for the system and provide to users.

Technology used: SQL Scripts, Quik Trac

Programmer Analyst

Confidential, Las Piedras, PR

Responsibilities:

• Automatic order creation. Help to reduce backorder, creating orders to fill shipping plant raw material inventory.
• 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.
• RPG IV, RPG Free Format, CLP, RPG ILE Procedures, RLU, SDA, AS400 SQL, VB.NET, AS400 iSeries OS:
• 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.

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

Programmer Analyst

Confidential, Hato Rey, PR

Responsibilities:

• Support of in house systems
• Parts and Vehicle.
• Duties include creation and modification of in house Parts and Vehicle programs.
• Automobile system program and data conversion from S36 to AS400.
• Change programs RPG and CLP (when necessary) to run in a new AS400.
• Running in a new system increase Automobile system performance over 200%.

Technology used: RPG II, S36 Procedures, DFU

Programmer/Computer Operator

Confidential, Cayey, PR

Responsibilities:

• System daily operations support.
• Develop programs when required.
• Duties include help in accounting department with the data entry, reports generation, and program development in RPG for Mapics system.

Technology used: RPG II, Mapics, AS400