RAFAEL LLERA VEGA

Cond. Astralis, Apt. ***

**** ***** **** ***

Isla Verde Carolina, PR. 00984-9402

Email: addqil@r.postjobfree.com

Cel: 939-***-****

PROFESSIONAL SUMMARY

Well rounded and organized leader with twenty (20) years of experience in information systems, and business process. Adaptive and creative problem solver, both as team lead and individual contributor, have successfully managed small to large scale projects. Excellent strategic, administrative and analytical skills permit working well within cross functional teams. With a thorough knowledge of accounting cycles and audit practices for, manufacturing operations, banking, wholesale and retail industries have developed excellent business acumen.

Have extensive experience with SDLC, waterfall methodologies, agile familiarity and technical writing. Working for various industries, such as: Utilities, Manufacturing, Pharmaceuticals, Wholesale & Retail and Banking, have obtained widespread knowledge of regulatory requirements, such as SOX, FDA (GxP and 21CFR Part11), EPA, GAAP, among others. An expert in gathering user requirements and converting them into process improvement results.

TECHNICAL SKILLS

Business: Customer Relationship Management Application, (CRM), Departmental Budgets. Computer Systems Projects & Strategies. Computer System Validation, ITIL, SOX, DRP/BCP, Infrastructure Management, GIS, PMO, Six Sigma, GxP, EPA, GAAP, Technical Writing, Electronic Document Management, IT Audit and compliance, Business Continuity and Disaster Recovery Plans.

Technical Writing: MS Word, PowerPoint, SnagIt and a general understanding of tools, Adobe, Publisher. Skilled in the use of hyperlinks and annotations on documents.

Languages: SQL, Visual Basic/.Net, COBOL, RPG III, FORTRAN.

Databases: Access, Oracle, SQL Server, My SQL.

Operating Systems: Window, iOS

Networking: LAN, Wireless, DNS, DHCP, TCP/IP

Tools: MS Office, Outlook, Visio, MS Project, Crystal Reports, SQL Server Reporting Services (SSRS), ArcMap, Salesforce and MS Dynamics.

Applications: People Soft, SAP, Computron, MACPAC.

WORK EXPERIENCE

Independent Contractor: 2016- Present

Project Manager:

Strategic Consulting PR

Have provided an assortment of services for the local governmental agency ASSMCA.

oTeam lead in the conversion of a CRM system running on Salesforce to MS Dynamics for Substance Abuse and Mental Health home licensing application.

oAssisted the IT department in answering two OGP audits for the 1st prepared a Risk Assessment and Impact Analysis and the 2nd answered an Information Technologies (IT) internal controls.

oAssisted in the preparation of the IT 2018-2019 fiscal budget, values over $2M and identified 5 strategic projects critical to the success of the agency.

oManaged design, development, and implementation of modifications to the agencies’ statistical patient service application “Sistema Estadístico Perfiles de Salud “(SEPS), critical to keeping control of patients and services and a cornerstone to the agencies federal funding requirements. Worked closely with SAMSHA requirements.

oManaged design, development, and implementation of an application to support one of many services the agency provides, LEY 22.

oDeveloped a Business Continuity and Disaster Recovery Plan for a government agency.

Implemented a Fleet Management Application for Protective Consulting Services (PCS) providing a state-of-the-art cloud-based solution. As part of the effort reviewed a number of cloud-based products, provided a cost-benefit analysis and recommended the final solution. Key objectives and deliverables:

oPre-configured travel reports per shift by period.

oMap visualization and location tracking with start and end times and stops during the shift, both on the Web and mobile phone.

oReal-time notifications via text messages and/or emails.

oDemarcation of areas of interest (geo-fences), such as facilities and Points of Interest (PoI) on maps with in-out notifications.

oSave detailed driver information assigned to each vehicle.

oIn addition to safeguarding both drivers and assets, providing opportunities for cost reduction associated with fuel usage and aggressive driving.

4Elements Group

oProvide PM, and technical support for infrastructure projects at the Schneider Regional Medical Center (SRMC) in St. Thomas in the below:

oInformation Gathering (Discovery), Existing Environment Documentation.

oDetailed Planning, Design, and Implementation of New Network Core Infrastructure.

oDesign and Implementation of Wireless Access Network Pilot.

oImplementation of New Server Infrastructure.

oStorage Area Network Implementation

oProvided detailed diagrams of the water treatment plants and locations of security equipment Google Earth, Visio, Powerpoint and WORD for the Water treatment plants project documentation.

Puerto Rico Aqueducts & Sewer Authority (PRASA), San Juan, PR 2008-2014

Manager Special Advisor/PM

Led a Systems Technology organization in support of the Non-Revenue Water division, a strategic section of the local Water Works Utility operation with a budget of $12M and an expected return of $65M per year. Supervised a total of 30+ FTEs between office and field personnel.

Managed SME and technical teams provisioning services for Customer Services, Customer profiling, field Operations, Income Optimization, Customer Geo-Referencing, and Business Intelligence.

In this effort:

oDirected design and development teams in the implementation of field PDAs handheld units configured with GMS connectivity, application programmed in MySQL, interfacing with SQL Databases via Web Services.

oManaged team developing BI solution for Income initiatives and Field Route optimization. Utilized lean six sigma methodologies and MS solution products such as SQL Server, Analysis Service, SharePoint Resources, WEB Services, and EXCEL PowerPivot. This approach has since scaled up from the Non-Revenue section as a cooperate BI solution for field operations.

oLed design and implementation of ETL project, for extraction of data from the corporate billing and accounts receivable systems (SAP/ISU) into support applications and tools implemented at the Non-Revenue division. Used MS SQL databases and SQL scripting for extracting data at daily, weekly and monthly intervals.

oLed design and development of multiple Income Optimization tools in support of specific operational processes, such as Field Meter Changes, Customer Service, Field Operations, Identification, and Processing of non-compliant customers and water operational loss.

oDirected the implementation of a GEO-Database for the geo-referencing of the corporation’s 1.2m customers. In addition to managing field operatives gathering physical information, the team integrated multiple layers of georeferenced data from other agencies and systems, Property Tax (CRIM), Power and Light Agency (AEE), among others. Used MS SQL database, and SQL Scripting, ARCMAP and Python.

oLead the development of technical and user documentation on the projects mentioned above.

As an individual contributor supported other corporate projects such as:

oManaged Facility Electronic Surveillance pilot, later budgeted as a corporate initiative. Led the design, implementation, and negotiations with Anixter, Grainger, Aeronet, and PCR Consulting for (6) water distillation sites required for installation and programming of video surveillance, alarms, and access control of the sites.

oServed as IT SME team member for negotiations, design of the procurement, implementation, operation, and maintenance of an Integrated Security System for corporate facilities. The technological components include video surveillance, access control, intruder alarms, and security guard services.

Wyeth Pharmaceuticals, Carolina, PR 2008-2008

Service Delivery Manager/PM

As individual contributor lead the development of an ITSM strategy using ITIL methods and policies.

Addressed areas for Change Management, (Desktop Management, Data Center and Networking services) for the two (2) manufacturing sites in Puerto Rico.

Supported senior management in the implementation of the organizations PMO initiative and served as IT representative on said team.

Pfizer – Worldwide Technology Infrastructure (WTI), PR & Latin America 2004-2008

Service Delivery Manager (SDM), Puerto Rico & Latin America/PM

Implemented World Wide Corporate Infrastructure Strategies (ITIL) for PR and Latin American regions.

Supported five (5) manufacturing sites in PR, and ten (10) spread throughout Central and South America involved in manufacturing and sales.

Functioned as Team Leader and Individual Contributor, managing teams of over 25 members and budgets ranging up to $3M, engaging internal and external players as required.

Responsibilities entailed identification, development, and execution of transition plans relative to corporate, and plant IT transformation of responsibilities, resources, and budgets.

oAs the SDM in the region required to present WTI strategies to site leads and collaborate with local IT directors, managers and staff for smooth transitions.

oLocal plans created for transitioning based on data gathering efforts and Global/Local requirements.

Other areas of focus:

oIntegration of Latin America infrastructure to Corporate Computer Management Data Base services along with Change Management Process (ITIL).

oIntegration of Corporate WAN program, providing site WAN redundancy, converting T1 connectivity to Metro Ethernet.

oEnsure Corporate SLA attainment for services.

oIdentify IT strategies to improve service and lower cost for the sites by assessing:

Outsourcing opportunities were implemented for continued standardization and improvement of Hosting Services, Wireless connectivity, and Desktop Management Services.

Pfizer – Manufacturing Site – Barceloneta, PR 1988-2004

Team Lead/IT Manager/SME

Provided IT services and support to the manufacturing sites in various roles both as IT Manager and SME.

IT areas or responsibilities Desktop Management, Network services, Data Center Infrastructure, such as AS400, Exchange Servers, Aval and Nortel PBX, WEB Services, HP File Servers, CISCO switches and routers in addition to supporting MRP and General Accounting applications, such as MACPAC, PeopleSoft, ePO Maestro.

The teams comprised upwards of 15 FTEs, colleagues and contractors, with a yearly budget > $2M.

Maintained service SLAs while implementing cost containment, measuring cost reduction at 10% to 12% year over year of ongoing services.

Led corporate SOX and DRP initiatives as SME and technical writer.

Developed over 50 policies and procedures for the IT department’s security, operational, and DRP environments.

Maintained service SLAs while implementing cost containment, measuring cost reduction at 10% to 12% year over year of ongoing services.

As Technical Lead and SME supported various business units, implementing systems & solutions within a highly regulated environment FDA, EPA, OSHA, ISO9000, and GAAP. Specific projects:

oEnvironmental Health & Safety - programmed in MS Access a Mass Balance and Molecular Analysis application for estimating the amount of waste generation relative to product process for EPA reporting. Programed a Waste Management tool in MS Access for reporting solid waste within the production activity.

oLed the plant’s Information Protection Guidelines (IPG) and 21CFR Part 11 initiatives.

oLed the plants’ Y2K (DRP/BCP) covering SOX requirements.

oProvided technical supported the Materials Management, MRP II, Scheduling, Procurement and Inventory control, programming in RPG III on an AS400, and MS Servers with dBase III and VB.

oFinance unit responsible for general & cost accounting, programmed in Paradox a multiuser budgeting and forecast applications.

In addition, assisted with audits from various regulatory agencies FDA, EPA, and GAAP. Areas of support and technologies.

Provided clear, concise user and technical documentation for the systems supported.

Deloitte Haskins and Sells 1983-1988

Senior Consultant/PM

Provided programming, and consulting services for clients within different industry groups, i.e., manufacturing, banking, insurance, and broadcasting:

oSavings and Loans Banks – Performed IS Audits supporting external yearly audits for banks on the island as well as in Miami. Using statistical analysis tools (Deloitte proprietary) extracted transactions from general accounting systems for financial Audit teams.

oBanco Agropecuario de San Salvador - Led sub-project designing a PC based network strategy for communicating EOM statistical results from local offices, up thru area, regional and finally to corporate headquarters. Managing a budget of $3M supervising a staff of 5 FTEs.

Designed, programmed and supported multiple accounting applications:

oMRP II model in Lotus 123

oGeneral Ledger Application in RPG III for a Broadcasting and Tuna manufacturing concern.

oOrder Processing & Inventory Control for a Rum Distillation company in RGP III.

Led internal control audits for clients, focusing on the banking industry, insurance, retail &wholesale in both PR and US.

Developed RFPs for various clients seeking IT solutions in the area of Wholesale & Retail, Ocean Transportation and Utilities.

EDUCATION

EDP University, San Juan, PR 1983

B.A. Computer Science, Minor in Accounting and Business Administration

Contact this candidate