Larry Garcia
Rancho Cordova
Summary
Dynamic Senior Project Manager with a proven track record at the California Department of Transportation, adept in Agile methodologies and SQL analytics. Successfully led multi-million dollar projects, enhancing operational efficiency and user acceptance testing. Recognized for exceptional project planning and business process analysis, driving impactful results in complex environments.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior Project Manager
City of Rochester, New York
Sacramento
01.2023 - 03.2025
- Infor Public Sector Refuse and Water Billing System Conversion Project - Mainframe to Cloud Services
- Project implementation strategy: Project Plan creation, Agile methodology; Project Management tools: JIRA, Confluence, Smart Sheet
- Participated in requirements gathering, development of stories, analysis of business processes, recommendations to improve daily workflow to eliminate manual processes and improve operating efficiency
- Daily Scrum, Sprint Planning and Review
- Developed and executed functional unit test and QA of Infor Public Sector applications
- Converted 40+ mainframe reports using Cognos / Infor Reporting Tool, SQL based analytics tool added with Infor Public Sector application
Senior Project Manager
California Department of Transportation
Sacramento
05.2022 - 12.2022
- Managed Development and User Acceptance Test cycle for Go-Live of the CalTrans Encroachment Permit System (CEPS), COTS Infor for Public Sector (IPS), Rhythm for Civics On-line portal
- Project Budget $3.5M
- Project implementation strategy: Agile methodology, utilizing SharePoint and JIRA as Project Management tools, managed all communications between Visionary Integration Professionals (VIP) consulting team, Infor Developers, CalTrans project team, CalTrans IT Technical Team, Project Stakeholders and Executive Sponsors
- Hosted weekly project status meetings, Daily Scrum, Developed Project Plans/Reports, Dashboards, Identified Project Risks and Mitigation
- Post Go-Live July 2022 to present: Release Management of all CEPS Stories, Bug Fixes, Enhancements, and Maintenance fixes
IT Project Manager - Contract
State of Colorado, Office of Information Technology
Rancho Cordova
08.2021 - 04.2022
- Manage the implementation of ServiceNow ITAM, IRM, ITBM, CSM and ITSM applications with various State Agencies, including development of Project Charter, Project Plans and RACI, Contract & SOW management, Project, and Portfolio Management (PPM), UAT planning, Risk, Issues, Decisions Actions and Change (RIDAC) mitigation, Weekly Status reporting and Executive Steering Committee updates
- Reconciliation of implementation partners project hours to ensure deliverables and burn rate in alignment with project plans
- Project budget $1.9 million
- Managed all communications with C-Level Management, Project Stakeholders, Project Team members, Agency representatives, IT Directors, Implementation Partners and ServiceNow management team
- Host daily stand-ups meetings, resolve issues, remove roadblocks to maintain forward progress and results
Engagement Manager
Enterprise Networking Solutions, Inc. (ENS-Inc.)
Rancho Cordova
07.2020 - 06.2021
- Manage the implementation of ServiceNow application ns with various State of California Agencies
- Develop response to RFO and RFP, provide Project Portfolio Management (PPM), staffing requirements, Level of Effort (LOE) estimate, budget planning, (Budgets over $1 million) product recommendations and business analysis
- Earned product certifications in ServiceNow: ITSM, CSM and HR Service Delivery
- (Versions: Quebec, Rome) to provide client solutions during Pre-Sales cycles; design and development of solutions
- Led successful cutover of Palo Alto Network Firewall project: California Department of Developmental Services
- Managed client relationships, Monthly Project Status Reports, reconciliation of project hours, and burn rate
Independent Contractor/Business Analyst
Sacramento
03.2019 - 04.2020
- Business Analyst at Sacramento Municipal Utilities District - SMUD SAP Payroll Project 2,400 Employees, Union Payroll, Bi-Weekly
- Partner with Legal Department, HR, Payroll, and IT Teams, manage project requirements and test strategy
- Created entity relationship (ER) diagrams of HCM modules; illustrate data flows and processes
- Configured JIRA for Regular Rate of Pay Payroll project
- Managed Kanban board; led weekly project team status meetings; identified and resolved system issues, prioritized tasks, discussed critical issues with management team, recommended solutions to improve business operations
- Created reports linking multiple spreadsheets using VLOOKUP, Pivot tables, date formulas and IF Statements to automate and validate tests results
- Respond to CalPERS Audit of premium earnings subject to pension calculations
- Test and implement pay code changes for workers reporting COVID-19 Time entries
HRIS Manager
SBM Management Services
12.2016 - 11.2018
- Company Overview: McClellan, CA
- JD Edwards (JDE) 7,000+ Employees, Union and Non-Union, Multi-States and International |Weekly & Biweekly Pay
- Lead the integration of iCIMS ATS application and JD Edwards E1 Upgrade
- Created project timeline, user test cases, led project planning sessions, published weekly project status, worked with developers and external vendors to build integration of iCIMS to JDE
- Developed training material and end user guides
- Improved new hire processing by 80%
- Developed reports using SQL queries for Senior Leadership Team; monthly analysis of Employee Turnover Rate and maintain HR dashboard
- Support reporting of EEO-1, Bureau of Labor Statistics (BLS) Census, Compensation Planning, Performance Management, Health & Safety statistics (OSHA), Ensure compliance with Fair Labor Standards Act (FLSA), Employee Survey Feedback, Leave of Absence tracking (FMLA) and maintenance of Employee Training records; develop Ad-Hoc Reports via JDE Insight Report writer application and Excel
- Research and resolved HR/Payroll data issues with IT team, validated payroll tax calculations
- Managed system configuration: Business Units, Job Table, Benefit plans, Earnings and Deductions; Analyze and create test cases to validate system changes
- Proof of Concept using Salesforce for custom Labor planning; worksite performance reporting
- Direct reports; staff of 2 HR Coordinators and 2 HRIS Analysts
- McClellan, CA
Business Analyst
ProUnlimited
Folsom
01.2015 - 11.2016
- ERP: PeopleSoft 9.0 Human Capital Management (HCM); Financial, Supply Chain Management (FSCM) - Support Payroll production for 15,000 Multi-State & International Employees; Weekly Pay Cycle
- Project Budget $4.5 million
- Managed configuration tables to support system / application upgrade
- (PeopleTools)
- Created Business Requirements Documents (BRD’s) for reimplementation of PeopleSoft 9.0 to 9.2
- Developed software project documentation, functional specifications, User Acceptance Test (UAT) cases, developed Automated tests using SOAP UI; created test strategy, test status (SCRUM), weekly reporting of incidents
- Software Development Life Cycle (SDLC)
- Tested enhancements to Core Human Resources, North American Payroll, Global Payroll (UK), Accounts Receivable, Accounts Payable, General Ledger processes including Standard Journal Entries (SJE), Lockbox payments, Application Engine (AE), Custom reports and Interfaces
- Required knowledge of SQL to support production issues
- Led cross-functional team of six participants through all test cycles
Business Analyst at UC Davis Medical Center
- Identity Management (IM) project
- Oracle, PeopleSoft, ServiceNow
- Map existing business processes; document current state of employee onboarding systems from Campus and Health Center; provide analysis of system break points
- Implemented SharePoint Repository for IM Team to manage requirement documents and unit test cases
- Conducted code reviews with Development team
Business Analyst
Western Client Initiative, Inc. | State of California Air Resources Board (CARB)
- Document current state of 2019 business processes for Annual Board of Directors meeting
- Developed Standard Operating Procedures and Job Aids to comply with government requirements
- Create Business Requirement Documents (BRD’s) including diagrams of workflow for Compliance Instrument Tracking System Service (CITSS) application developed by GDIT
- (General Dynamics Information Technology)
- Document Cap-and-Trade Program workflow for California participants, Canadian Provinces Nova Scotia and Quebec
- Developed user acceptance test (UAT) cases for quarterly application enhancements
Business Payroll Consultant
Raley’s Supermarkets
West Sacramento
- PeopleSoft HCM, RED Prairie (JDA) Time & Attendance System - 120 stores in California and Nevada
- Provide production support for 15K employees Union and Non-Union, Audit Timesheet data, weekly pay cycle and Identify requirements and test strategy for system upgrade
- Managed inquiries from state agencies regarding: verification of employment, benefits, garnishments, termination payroll, unclaimed wages, retroactive payroll calculations
- Conducted research to identify trends in payroll best practices.
Education
Bachelor of Science - Business Administration - Human Resources Management
Colorado Technical University
Colorado Springs, CO12-2017
Skills
- SQL analytics
- User acceptance testing
- Project plan development
- Agile methodologies
- JIRA
- MS Project
- Project Planning
- SDLC
- Agile methodology
- Project management
- Business process analysis
- Requirements gathering
Certification
Certified Project Management Professional (PMP), Project Management Institute (PMI)
Consulting Projects
- Senior Project Manager, City of Rochester, New York, 02/21 - 02/23, Accounts Receivable Refuse | Water.
- Senior Project Manager, California Department of Transportation, 05/22 - 12/22, Caltrans Encroachment Permit System.
- IT Project Manager, State of Colorado, Office of Information Technology, 08/21 - 04/22, ServiceNow ITSM.
- Engagement Manager, State of California, Department of Developmental Services, 01/22 - 01/23, ServiceNow ITSM.
- Engagement Manager, Judicial Council of California, 01/22 - 01/23, ServiceNow Temporary Assigned Judges Program.
- Engagement Manager, California Department of Technology, 01/22 - 07/22, ServiceNow Customer Service Management.
- HRIS Manager, SBM Management Services, 12/16 - 11/18, iCIMS Implementation. JD Edwards Upgrades. Workday RFP.
- Quality Assurance Manager, Baxter International, Robert Half International, 12/16 - 11/18, PeopleSoft. HR Payroll 7x – 8x.
- Payroll Implementation Consultant, Hospitality Management Corporation (HMC), 01/18 - 12/18, Ascentis HR / Payroll.
- Implementation Consultant, ADP Workforce Now, 01/19 - 06/19, Tufts University, Destination XL.
- Business Analyst, Alameda County (AC) Transit, 01/19 - 06/19, PeopleSoft HR, North American Payroll.
- Business Analyst, Kaiser Permanente, 01/19 - 01/21, PeopleSoft HCM, Taleo, My HR Project.
- Quality Assurance Manager, Baxter International, Robert Half International, 01/19 - 01/21, PeopleSoft. HR Payroll 7x – 8x.
- Business Analyst, Lawrence Livermore National Laboratories, 01/19 - 06/19, PeopleSoft HCM Upgrade 8.0 to 8.9.
Affiliations
- Bowling League Vice President, The Apex Bowling Center, Placerville, California
- Marital Arts Instructor/ Sport Karate Coach, Premier Marital Arts, Elk Grove, California
References
References available upon request.
Timeline
Senior Project Manager
City of Rochester, New York
01.2023 - 03.2025
Senior Project Manager
California Department of Transportation
05.2022 - 12.2022
IT Project Manager - Contract
State of Colorado, Office of Information Technology
08.2021 - 04.2022
Engagement Manager
Enterprise Networking Solutions, Inc. (ENS-Inc.)
07.2020 - 06.2021
Independent Contractor/Business Analyst
03.2019 - 04.2020
HRIS Manager
SBM Management Services
12.2016 - 11.2018
Business Analyst
ProUnlimited
01.2015 - 11.2016
Business Analyst at UC Davis Medical Center
Business Analyst
Western Client Initiative, Inc. | State of California Air Resources Board (CARB)
Business Payroll Consultant
Raley’s Supermarkets
Bachelor of Science - Business Administration - Human Resources Management
Colorado Technical University
Similar Profiles
Agustin GonzalezAgustin Gonzalez
Deputy Sheriff at Wayne County New YorkDeputy Sheriff at Wayne County New York
Renee BreanRenee Brean
Officer Wellness Clinician at City of Rochester, Rochester Police DepartmentOfficer Wellness Clinician at City of Rochester, Rochester Police Department
Nick LauriniNick Laurini
Head Soccer Coach - Girls Academy & Premier at Rochester New York Football Club (RNYFC)Head Soccer Coach - Girls Academy & Premier at Rochester New York Football Club (RNYFC)