We provide IT Staff Augmentation Services!

Business Intelligence Administrator Resume

PR

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

Hire Now