***** ** *** *** • SAN BENITO, TX *****

PHONE 956-***-**** • E-MAIL ac6afh@r.postjobfree.com

MANUEL R. GARCIA II

EDUCATION

University of Texas at Brownsville Brownsville, TX

Bachelors of Science in Computer Science

PROFESSIONAL EXPERIENCE

Mar16-Current The University of Texas System - Irving, TX

Access Control Analyst

PeopleSoft SSA – Security Analyst for HCM, FMS, Campus Solutions, and Enterprise Portal.

Define, configure, and administer PeopleSoft access control across multiple instances and applications which includes interacting and working closely with multiple teams to implement access control roles and permissions.

Troubleshoot, reported problems pertaining to the PeopleSoft applications access control and integrity.

Configure security objects that adhere to Oracle/PeopleSoft/UT System development standards and best practices, and document the security infrastructure so that it may be interpreted, maintained.

Create SQL scripts for various projects and fixes.

Assist with bundles and upgrades.

Assist ISA’s or other campus personnel with security related issues.

Create User Profiles and assign Permission List and Roles in Multiple environments.

Migrate projects, roles, permission list and other objects across multiple environments.

Create Query security – add tables to query trees for access

Create Permission List for FI, HR, and CS.

Create Roles for FI, HR, and CS.

Perform daily, weekly, and monthly security audits.

Sep15-Mar16 The University of Texas at Rio Grande Valley - RGV, TX

Programmer Analyst II

PeopleSoft ISA - Information Security Administrator - Assisted in the design and implementation for the Security matrix for PeopleSoft at UTRGV. Manage all security changes, additions and issues.

Oracle Conversion from PeopleSoft – Assisted with gathering data from PeopleSoft that was needed in Oracle for conversion

Assist Functional users with PeopleSoft in the HR and FI modules in several environments.

Oracle – Duties include making code changes, modifying SQL, and assisting the Business Analyst with issues and testing in Oracle.

Data Hub - Coordinate, Plan, and Design data structures for interface and reporting solutions to fulfill business needs for third party applications.

Feb13-Aug15 The University of Texas at Brownsville - Brownsville, TX

Sr Programmer Analyst

PeopleSoft ISA - Information Security Administrator – Assisted in the design and implementation for the Security matrix for PeopleSoft at UTB. Manage all security changes, additions and issues.

Business Analyst – Assist HR and Finance functional users with PeopleSoft in the HR and FI modules in several environments. Create and fine tune queries.

PeopleSoft Interface lead – Manage all interfaces communicating with PeopleSoft via inbound or outbound.

PeopleSoft Conversion from Datatel - Manage data errors by tracking, analyzing, and resolving issues. Assist in the mapping of data between both databases.

Data validation an QA testing- create PeopleSoft queries to pull data from PeopleSoft to compare with data from Datatel and verifying data coming into PeopleSoft appears in the correct Screens.

SQL – Use SQL Server to create queries, create views, for data audits and reporting.

Use Informer Web Reporting Tool to create reports and pull data for data validation

Assist with hardware issues in Datacenter such as servers and UPSs.

Datatel – Setup approval request using Spiceworks and SharePoint, Pull data and create reports from GUI, and remove mnemonics from users to avoid security risk.

Perform quarterly Access Security reports for compliance for PeopleSoft and Datatel.

Sep12-Feb13 AGIII Contractors - Harlingen, TX

IT Manager

In charge of all IT needs – hardware, networks, software, phones, email, website, and printers, etc.

Setup and manage networks in all locations

Oversee IT projects – Managing vendors and consultants

Implement IT solutions for constructions projects – Hardware needs, Software needs, data management needs and all reporting needs.

Manage construction projects

Feb06-Sep12 The University of Texas Health Science Center - RAHC Harlingen, TX

IMS/Lan Support/Network Specialist

Desktop - Supporting, installing, and maintaining all hardware and software at the RAHC. RAHC locations include, Harlingen (2 locations), Edinburg, McAllen, and Laredo. Hardware consists of PCs, laptops, tablets, printers, plotters, fax machines, etc. Installation and configuration of operating systems - Windows (XP, Vista, Windows 7), Mac OS X (Snow Leopard, Moutain Lion, Lion) Installation and support on all Microsoft Office Products, enterprise applications- PeopleSoft, antivirus software, firewall software, and encryption software. Other duties such as imaging PCs and local PC security are included in this job role. Provide support for mobile devices such as smart phones(iPhones, Android phones, and Blackberry’s), iPads, and different tablets.

Software Support and Analyst – Assist users with PeopleSoft on functional and technical issues. Assist Researchers with analyzing data and creating reports. Maintain and modify database for ITNET in all RAHC locations.

Data Network Support - This will include trouble shooting, daily repairs, additions and changes. Setting up and configuring WiFi for new construction. The network mainly consists of Cisco routers.

Video Network Support - This will include maintenance of video circuit as well as daily operations supporting interactive video classes, meetings, and seminars. Brands of equipment include Creston, Polycom, Extron and APC UPSs.

Telephone Support - Support includes daily installation, programming, and repairs of telephone system and equipment. The current phone network is a NEC system and uses analog, digital and ip phones.

Audio Visual Support - Support includes installation, setup, and repair of audio visual equipment. Equipment used projectors, audio systems, microphones, wireless microphones, lavaliere microphones, video cameras, and digital recording equipment.

IT Project Manager – Manage all special projects for Rahc locations for outside vendors and contractors – Network installs and upgrades, Phone installs and upgrades, Computer lab remodels, Audio and Video installs and upgrades, and Video teleconference installs and upgrades.

Security Camera support, maintenance, and installation – Supporting the existing security camera system for the UTHSCSA Police Department at all RAHC locations. Install and maintain all new VOIP cameras for all other departments in different RAHC locations.

May03-Apr05 Valley Baptist Health System - Harlingen, TX

Analyst/Application Specialist

Lead in Lawson (Oracle) to PeopleSoft (SQL Server) implementation in payroll, included data validation, customization, testing, training, and go live.

Trained by CSC consultants and worked on the initial configuration of both Human Resources and Payroll. Involved benefits, deductions, earnings, workflows, etc.

Assist Human Resources with functional needs ex: troubleshoot functional malfunctions using People Tools, and research functional procedures with People Books and PeopleSoft call center or online support.

Design, create, and implement additional PeopleSoft pages using People Tools, People Code, and PeopleSoft query.

Create process flow charts and standard operating procedures for various business functions in Accounting, Pharmacy, Human Resources, Gift Shop, Materials Management, Business Office, Print shop, and Decision Support.

Created various reports using Crystal Reports, Access, query analyzer

Kronos Workforce Central - security administrator, system Administrator, analyst, report writer, and user support specialist

Assisted with Kronos upgrade

Created sophisticated Pivot tables combining data for different applications such as PeopleSoft, Kronos, Lawson, TSI, etc.

Assist Human Resources with all data validation, special customizations such as crystal reports, People Soft queries, SQRs, etc.

Assist in the monthly financials by performing audits and validating data.

Support current business software Lawson and write Oracle SQL for updating, adding, deleting and manipulating data on Lawson Oracle database.

Developed a process to implement a system wide pay raise to over 2500 employees in over 100 departments, using SQL, Excel, and Access.

Lead in Lawson (Oracle) to PeopleSoft (SQL Server) implementation in SCM and EPM, included data validation, customization, testing, training, and go live.

Assist in Lawson (Oracle) to PeopleSoft (SQL Server) implementation in Financials, included data validation, customization, testing, training, and go live.

PeopleSoft security administrator, create users, roles, permission list, and preferences, in the FMS and HCM modules.

Analyst for IDX medical records modules, screen developer and report writer.

Data Analyst for all Health System Departments.

Dec02-Feb03 The University of Texas at Brownsville - Brownsville, TX

Computer Technician

Computer Software support

Setup networks, computer labs and offices

May02-Aug02 Valero Energy Corporation - San Antonio, TX

IT Summer Internship

Developed Information Technology Application Management (ITAM). Application used to help keep track of project planning and maintenance.

Developed Graphical User Interface (GUI) in Visual Basic 6.0 for data entry and maintenance.

Developed back end in Oracle 8i -- created tables, created views, created triggers, and wrote stored procedures used SQL Navigator as development tool.

Feb02-May02 The University of Texas at Brownsville - Brownsville, TX

Network Technician

Infrastructure ( network wiring, router setup and testing)

Terminate different media ( wiring, schematics and testing)

Set up videoconferencing equipment

Test and maintain building UPSs (Uninterruptible Power Supplies)-- 80KBA

Experience with routers, switches, patch panels, hubs, and DSU/CSU(Data Service Units/Channel Service Units)

Sep01-May02 The University of Texas at Brownsville - Brownsville, TX

Math/Computer Science Tutor

Individual tutoring in math

Subjects: Calculus I, Calculus II, Pre Calculus, Trigonometry, Algebra, Discrete Math, Elementary Statistics, History of Math, Contemporary Math, Geo Structures and Basic Math

Individual tutoring in Computer Science Courses

Subjects: Programming I, Computer Foundations, Digital Logic, Computer Literacy, Multi Media/Web Design, and System Analysis and Design

Sting Success Tutor

Instructs math tutorial classes for first year freshmen

SOFTWARE & PROGRAMMING KNOWLEDGE

PeopleSoft, App Designer, STAT, Service Now, SQL Developer, SQL Plus, Golden, Ultra Edit, Ultra Compare, Microsoft Office – Excel, Word, Power Point, Access, Outlook, Visio, Auto Cad, Auto Desk, Adobe Master Collection Suite, Crystal Reports, Pinnacle, Remedy, Oracle Business Intelligence, Veritas, Matworx, People Code, Netviz, C++, J++, Lisp, Assembly(Motorola & Intel), Access, SQL, HTML, Mathmatica, MFC (Microsoft Foundation Classes), VBA (Visual Basic for Application), Visual Basic 6.0, and Oracle 8i

PEOPLESOFT EDUCATION COURSES

Using PeopleSoft - Fundamentals

PeopleTools I / PeopleTools II - Accelerated Rel 8.44

Base Benefits - U.S.

Payroll 8.8

FSCM Delta Class

PeopleSoft HCM Delta Class 9.0 to 9.2

PeopleSoft Fluid User Interface 8.55

PeopleSoft PeopleTools I / II 8.55

PeopleSoft IntergrationTools I / II 8.55

PeopleSoft Approval Framework 8.55

PeopleSoft PeopleTools Security 8.55

PeopleSoft FSCM Security 9.2

PeopleSoft HCM Security 9.2

PeopleSoft HCM Self-Service Applications 9.2

PeopleTools Portal & PeopleSoft Interaction Hub Admin

Contact this candidate