Management Project

Sylvia Jean Garcia

Email: *******@*****.***

Phone: 512-***-****

Professional Profile

An IT Professional with experience within several areas of the SDLC of private and government sector project implementations. Nine years of software implementation experience in banking services, financial services, public sector, higher-education, energy, and healthcare services. Range of experience includes software analysis and design, business process analysis/design, business process re-engineering, software fit/gaps, programming, and project lead experience.

Skills Summary

PeopleSoft Delivery Skills

PeopleSoft Treasury Financial Gateway Cash Positioning

Business Process Fit/Gaps Waterfall & Agile (SCRUM) International Banking

System Design/Configuration

PS FINC/HCM experience

Requirements gathering Systems Design Documentation

Query & Reporting (HCM & Finc)

Data Mapping/Conversions PS Payroll, Ben. Admin, T&L

PS Production Support

BPT/UAT Testing

PeopleSoft Experience

PeopleSoft Treasury 9.1 Consultant

Empire Treasury Advisors; Dallas, TX

March 2012 – May 2012

PeopleSoft Treasury Consultant for Mortgage Services company in Dallas, Texas. PeopleSoft Treasury Consultant for a Retail Industry Services company in Denver, Colorado.

• Business and requirements analysis of fit/gaps in AP and GL business process integration with Cash Management.

• Architected and provided expert contributions about architecture and processing during the design phase, build phase, and testing of Wires and reconciliation.

• Fit/Gap presentations on internal business processes and PS Treasury functionality using PS Cash Management, Reconciliation, EFTs, Bank Polling, Integration Broker, Financial Gateway, and Cash Positioning.

• Mapped business processes against proposed and recommended PeopleSoft Treasury solutions.

• Design and configured a solution for previous PS Banking setup which implemented one SetID,

IT Consultant

M2K; Houston, TX

March 2011 – March 2012

QA Lead for a software development company for web based applications in the Healthcare and Energy business sectors.

• Agile (SCRUM) project environment; testing of web-based applications in .Net environment.

• Development of QA Testing Plan, Use Cases, Test Cases and Test Scripts.

• Product evaluation and use of RedGate SQL Generator for load testing of large amounts of data.

• Development of SQL and C# code for testing and web application.

• Able to take up a technical role when needed, SharePoint Administrator, Jira Administrator, and SQL Management tools for data generation for QA and developer testing.

• Business and software in the Oil & Gas and Healthcare ERP sectors.

PS Enterprise Treasury 9.1 Advisor

Johnson & Associates; Des Moines, Iowa

April 2011 – June 2011

PeopleSoft Consultant Advisor for a private sector insurance company and their internal PeopleSoft support-technical team.

PeopleSoft Treasury 9.1 demo and presentation of Treasury specific activities, events, and business processes. This demo was used to help the client determine the uses and needs of the PS Treasury system for their business environment before purchasing the Treasury module.

Development of training documentation for PeopleSoft Treasury specific events.

Training for in-house PeopleSoft implementation technical support team.

Presentation and training documentation developed for Treasury Cash Management, Deal Management, Risk Management, Integration Broker, Financial Gateway, and international banking reconciliation processes, cash sweeps, EFTs, Settlements, and Treasury Accounting.

Business processes and documentation relates to private sector insurance services.

PS Enterprise Treasury Implementation Lead 8.9

State of Delaware Project; Dover, DE

October 2006 – April 2009

PeopleSoft 8.9 Treasury Lead for a state-wide implementation; lead the business process requirements gathering for over 100 state organizations, Fit-Gaps, system design, configuration, implementation, BPT testing and module documentation.

.

Configuration of use of (BSA) Bank Statement Accounting, Accounting Templates, Auto-Accounting processes, In-House Banking within the Treasury Module.

Configuration of bank transfers, EFTs, and ACH transfers.

Worked with Bank of American, PNC, and Wilmington Trust on BAI files, conversions, file transfer testing, reconciliation of banking files and 3rd party financial software files.

Analysis and configuration of Treasury integration with AP, AR, and GL modules.

Testing of configuration of the CM configurations, test scripts, and Quality Center/Test Director.

Data analysis, data mapping, data conversion, and query building using SQL, and PS Query.

PS HRMS Techno-Functional 9.0 Consultant

UT Medical Branch; Galveston, TX

May 2006 – October 2006

PeopleSoft Technical-Functional Consultant provided reporting development for the UT Medical Branch University on a new implementation.

.

Development of queries and reports for TAM, T&L, Ben Admin, Student Admin, and Payroll. (HRMS modules on PS 9).

Analysis of UTMB legacy time and labor systems to PeopleSoft Time and Labor with KRONOS, data integration for report development.

Documentation, view/query development, data conversion, data mapping, and PeopleSoft – KRONOS data integration.

• Development of data warehouse views and queries using PS Query, TOAD, SQL, and Crystal Reports 9.0.

PS Financials Techno-Functional 8.4 Consultant

State of Indiana Project; Indianapolis, IN

February 2006 – May 2006

PeopleSoft Consultant provided system configuration, end-user training, documentation, reporting, and production support for AP, AR, PO/ePro, KK, GL, TR, AM, and Contracts during the pre and post go-live period.

End-user training on purchasing and pay cycle modules.

Ad-hoc configuration for different modules when needed included Banking Administration, AM, Contracts, KK, and AP.

Ad-hoc query and report development for different modules, as needed.

Development of end user user-guides for pay cycles, manual payments, budget checking, budget journals, voucher reversals, and PO sourcing processes.

Business Process Flowcharting of financial processing for the different financial modules (Contracts, PO, ePro, and AP).

Production support for end-users on different modules, as needed (AP, AR, PO, ePRO, Contracts, KK, GL).

PS Financials-HRMS Techno-Functional 7.5 Analyst

State of Texas Project; Austin, Texas

November 2002 – June 2005

PeopleSoft Analyst liaison between technical and end-user departments on the State of Texas PS implementation, worked with business users for requirements gathering, technical team for implementation requirements, and production support for end-users.

• Experience working with PeopleSoft Financials, HRMS, and PS Payroll.

• Business process requirements gathering and technical information for implementation.

• Data mapping of data elements across different financial systems, documentation and testing.

• User support and maintenance of financial systems; KPMG Performance Accounting (PA), MIP, and PeopleSoft Financials. Support and maintenance of HRMS and Payroll modules.

• Experience with state of Texas payroll, HR, Medicaid, DDS, and TANF

• Trouble-shooting of HHSAS financial applications issues. End user system and functional support; trouble-shooting of production issues.

• Development and maintenance of internal data warehouse system for legacy and current financial data. Development and maintenance of stored procedures, views, and reports.

• Development of adhoc reports using Excel, SAS datasets, PeopleSoft Query, TOAD, and SQL.

Career History

NeosConsulting Group, Senior Consultant; August 2005 – January 2006

Railroad Commission, IT Programmer (Oil & Gas); November 2001 – November 2002

Maxim Group, Senior Consultant, July 2001 – November 2001

I.T. Masters – Software Engineer, June 2000 – June 2001

USAA – Systems Analyst (Banking Systems), January 1999 – June 2000

Formal Training

Oracle University – PS Cash Management

Oracle University – PS Deal/Risk Management

Education

Texas A&MI University- BBA in Computer Information Systems

Contact this candidate