Larry Garcia
Senior Business Analyst & Project Manager
Rancho Cordova,CA
Summary
Innovative technology professional with several years of diverse experience in Private and Public Sector projects. Skilled in enhancing systems and aligning technical solutions with business objectives. Proven success in leading projects from start to finish and contributing to organizational growth and success.
Overview
10
10
years of professional experience
5
5
years of post-secondary education
1
1
Certificate
Work History
Business Analyst
City of Rochester
Rochester, NY
01.2023 - Current
- Led product demonstration of Infor Public Sector applications for Refuse and Water Billing System Conversion Project - Mainframe to Cloud Services
- Project implementation strategy: Agile methodology; JIRA / Confluence, Smart Sheet for Project Management tools.
- Participated in requirements gathering, development of stories, analysis of business processes, recommendations to improve daily workflow to eliminate manual processes and improve operating efficiency.
- Developed and Unit Tested 30+ Custom Reports using IBM Cognos Reporting tool for monitoring and controlling Accounts Receivable Refuse and Water accounts.
Senior Project Manager
California Department of Transportation
Sacramento, CA
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, 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
- Adapted quickly to unexpected challenges or obstacles encountered during project execution, devising creative solutions without compromising objectives.
IT Project Manager - Contract
State of Colorado, Office of Information Technology
Denver, CO
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 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.)
Sacramento, CA
07.2020 - 06.2021
- Manage the implementation of ServiceNow applications 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
- Led cross-functional teams to deliver complex projects on time, ensuring client satisfaction and repeat business.
Business Analyst
Independent Contractor
Sacramento, CA
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
- Facilitated workshops for stakeholders to gather requirements, ensuring projects aligned with business objectives.
HRIS Manager
SBM Management Services
Sacramento , CA
12.2016 - 11.2018
- Lead the integration of iCIMS ATS application
- 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
Business Analyst
ProUnlimited
Folsom, CA
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
Education
Bachelor of Science - Business Administration - Human Resources Management
Colorado Technical University
Colorado Springs, CO 01.2013 - 12.2017
Skills
Certification
Project Management Professional (PMP), Project Management Institute (PMI)
Affiliations
- Project Management Institute
Timeline
Business Analyst
City of Rochester
01.2023 - Current
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
Business Analyst
Independent Contractor
03.2019 - 04.2020
HRIS Manager
SBM Management Services
12.2016 - 11.2018
Business Analyst
ProUnlimited
01.2015 - 11.2016
Bachelor of Science - Business Administration - Human Resources Management
Colorado Technical University
01.2013 - 12.2017
Consulting Projects
- Business Analyst, City of Rochester, Rochester, NY, 24 Months
- Senior Project Manager, California Department of Transportation, 7 Months
- IT Project Manager, State of Colorado, Office of Information Technology, 9 Months
- Engagement Manager, State of California, Department of Developmental Services, 1 Year
- Engagement Manager, Judicial Council of California, 1 Year
- Engagement Manager, California Department of Technology, 6 Months
- HRIS Manager, SBM Management Services, 2 Years
- Quality Assurance Manager, Baxter International, Robert Half International, 2 Years
- Payroll Implementation Consultant, Hospitality Management Corporation (HMC), 1 Year
- Implementation Consultant, ADP Workforce Now, 6 Months
- Business Analyst, Alameda County (AC) Transit, Oakland, CA, 6 Months
- Business Analyst, Kaiser Permanente, 2 Years
- Business Analyst, Lawrence Livermore National Laboratories, 6 Months
Applications
- PeopleSoft
- Oracle
- JD Edwards
- SAP
- Infor Public Sector
- Microsoft Office
- Office 365
- Google Applications
- Azure
- JIRA
- Confluence
- ServiceNow
- Salesforce
- ADP
- Ceridian
- Ascentis
- ICIMS
- Taleo
Consulting Projects
- Business Analyst, City of Rochester, Rochester, NY, 24 Months
- Senior Project Manager, California Department of Transportation, 7 Months
- IT Project Manager, State of Colorado, Office of Information Technology, 9 Months
- Engagement Manager, State of California, Department of Developmental Services, 1 Year
- Engagement Manager, Judicial Council of California, 1 Year
- Engagement Manager, California Department of Technology, 6 Months
- HRIS Manager, SBM Management Services, 2 Years
- Quality Assurance Manager, Baxter International, Robert Half International, 2 Years
- Payroll Implementation Consultant, Hospitality Management Corporation (HMC), 1 Year
- Implementation Consultant, ADP Workforce Now, 6 Months
- Business Analyst, Alameda County (AC) Transit, Oakland, CA, 6 Months
- Business Analyst, Kaiser Permanente, 2 Years
- Business Analyst, Lawrence Livermore National Laboratories, 6 Months
Similar Profiles
Sylvia GriffinSylvia Griffin
Literacy Aide at City of RochesterLiteracy Aide at City of Rochester
Olivia LavigneOlivia Lavigne
Pump Station Maintenance Mechanic at City of RochesterPump Station Maintenance Mechanic at City of Rochester
Alvin G. SimpsonAlvin G. Simpson
Education Enrichment Associate at City of RochesterEducation Enrichment Associate at City of Rochester