Hhema Alapati

U.S. Citizen

SUMMARY OF QUALIFICATIONS:

•More than 20 years of experience in Requirements Gathering, Writing Functional/Technical Specifications, Configuring, Production Support, Administering Year End Close, Analysis, Design, Development, Upgrade, Implementation, Enhancement, Conversion, Scheduling,

Integration, Interfacing, Reporting, Retrofitting, Quality Assurance roles for Public Sector, Health Care, large- and small-scale Private Sector PeopleSoft Financial and SCM applications starting version 6.0 to version 9.2.

•About eight years of Public Sector PeopleSoft Experience with California City background check cleared.

•About two years of Health Sector PeopleSoft Experience in Los Angeles and St. Louis.

•Functional Expertise with PeopleSoft FSCM in Implementations, Security, Configuring Sales/Use TAX changes, accruals, Year End Close, budgeting, auditing on Receipt Accruals, setting up eProcurement clients like Office MAX, setting up EDI with Amazon, TOYSRUS, all levels of security for Clients.

•Technical expertise with People Tools 8.x, Change Assistant, Update Manager, SQR 7.0, Maintain Security, Process Scheduler, Process Monitor, File Layout, PeopleCode8.x, Tree

Manager, Utilities, Application Engine, PS Query, Crystal Reports, nVision, Application

Messaging, Component Interface on ORACLE, SQL SERVER, MS Access databases.

•Aggressive Production support using Control M, SSH, OPAS tracking systems, document maintenance systems, following change management SOX compliance directives and procedures.

•Well-rounded and experienced learning new technologies. Interaction with Business/Users in requirements gathering, analyzing, designing and documenting the Functional Specifications, advising the documentation efforts of Test Scripts or Test Plans for Regression/Integration/UAT/Unit Testing.

•Good communication and interpersonal skills, teamwork.

Skills:

•ERP: PeopleSoft FIN/SCM 9.2, 9.1, 9.0, 8.8, 8.4, 8SP2, 8SP1, 7.5, 6.0

•Modules: GL, AP, AM, KK, BI, PO, OM, AR, INV, Cost Mgmt, PC, CashMgmt, ePro, sPro, Expense, SS, Help Desk.

•KK Enabled Modules: AP,PO,INV(Commitment Control)

•Development Tools: Application Designer

•Integration Tools: Application Messaging, Component Interfaces.

•Reporting Tools: SQR, nVision, PS Query, Crystal Reports, and Tree Manager.

•Data Mgmt & Batch Tools: Data Mover, Mass Change, Application Engine, import Manager and Process Scheduler.

•Administration Tools: Security Administrator, Object Security, and Workflow Administration

•Databases: ORACLE, SQL SERVER, SQLBASE, SYBASE, DB2, MS Access

•Industry Experience: Financials, Purchasing and Manufacturing.

Education:

B. S. in Electrical Engineering from NAGARJUNA University, AP 1988

PROFESSIONAL EXPERIENCE:

City National Bank, Los Angeles 12/16–08/23

PeopleSoft 9.2 FSCM in Production Support role.

•Production support for AM, AP & GL modules.

•Prioritizing ServiceNOW (SNOW) Incidents, Requests, Tasks, Changes, Problems, and catching up accordingly.

•Performing root cause analysis by reaching the respective Finance, Controllers departments.

•Deciding on work around and/or long-term solutions through customizations/enhancements based off meetings’ outcomes.

•Resolving Issues keeping in view Compliance and/or RISK.

•Involved in Upgrade from PeopleSoft 9.1, PTools 8.54 to PeopleSoft 9.2, PTools 8.56

•Creating and tracking the enhancements in JIRA board.

•Gathering requirements, preparing the tech Docs, getting the enhancements through SDLC.

•Creating Change Controls after final Pre prod QA, attending CAB in getting the migration Sign Offs.

•Implementing Migrations by coordinating with System Admins, developers, Business Users within migration window.

•Coordinating with Application Support for establishing new Message way Transmissions.

•Implementing integrations from Coupa to PeopleSoft and interfacing from PeopleSoft to Cadency.

•Facilitating new Business Units, new AP, GL interfaces.

•Supporting daily interfaces inbound and outbound to all the modules at various points.

•Communicating with Clarity Appln for payroll related interface issues.

•Establishing every year schedules considering upcoming holiday calendar.

•Closing Month ends and Year ends in Actuals Ledger, generating files for the parent company Royal Bank of Canda, RBC meeting SLAs.

•Attending Internal/External Audit and/or Regulatory meetings to clear the questionnaire with procedural documentation being followed within the company.

HILTON, REMOTE 06/16–10/16

PeopleSoft 9.2 FSCM Tier 1 Consultant

•Production support for AP, GL, AM, OM, PC modules.

•Resolving Issues based on priority and migration of solutions for Allocations, Chart Field Combinations, Journal Source codes, Origins, Data link BU Setups, Tree Migrations, nVision Layouts.

•Delivered small projects to resolve process issues, delivered or customized, and migrated through the established migration path.

•Provided Functional Specs and Technical Specs Install Plans, Back out Plans, UT Plans, Test Results Details, gathered and recorded approvals on tasks, and migration validations.

•Performing and requesting PEER Reviews on the Incidents and Work Orders within the Team.

•Continuous monitoring of Journal Errors and following up with Business Users and resolving both online and backend and having AutoSYS schedule Journal Gen on adhoc basis to facilitate smooth month end and quarter end closing.

•Monitor process failures due to server failures getting servers rebooted, getting the failed processes deleted within process monitor, and running new process through Auto SYS.

•Participating CAB, Change Advisory Board meetings for CRQs, Change Requests.

•Following up with Users in getting the information related to the issues and getting their acceptance before closing the tickets.

City of Los Angeles, Los Angeles, CA 02/13 – 05/16

PeopleSoft 9.1 Sr. FSCM Consultant

•Handled Fiscal Year End Close in the system with modules PO, ePro, SS, KK, AP, AM, GL.

•Documenting procedures for Mass PO Close on both converted and non-converted POs.

•Business requirements gathering and documenting Functional Specifications for customizing the Receipt Accruals Program to have the Sales Tax Accruals also on the File.

•Finding the root cause and Resolving Purchase Orders/Requisitions that have negative encumbrances.

•Creating and Maintaining Bid Factors, Events, Event Responses, Awarding Events, Analyzing Bids.

•Working with Controller's office to resolve commitment control related issues.

•Releasing encumbrances by performing finalizations on certain vouchers to have the budget back for new orders.

Avery Dennison Corporation, Brea, CA 03/12 - 01/13

PeopleSoft Financials Lead Consultant

Provided expertise in support of PeopleSoft Financial (including AP, AR, BI, GL and AM modules) in the analysis, design, development, and integration between business applications.

Accenture 12/11 – 03/12

Procurement Production Support

PeopleSoft 9.1FSCM Consultant

Procurement Production Support for Health Care industry for the implementation of Ascension Health Hospitals and Pharmacies, like Kaiser Permanente Works.

City of Los Angeles, Los Angeles, CA 02/11 – 11/11

PeopleSoft 9.0 FSCM Consultant

Conversion efforts from SMS side for the FMS interface during the FMIS to FMS upgrade.

Chartfield changes are being incorporated by configuring the roll views and utilizing Roll1 and Roll2 processes.

Kaiser Permanente OneLink Support, Pasadena, CA 02/10 – 02/11

Procurement Implementation/Support PeopleSoft 8.9 FSCM Consultant

Support CRP Central Refill Pharmacy, WMS Warehouse Management System, and Pharmacies during Phase I Pilot Implementations.

Support Wave I through V for Materials Implementations throughout Northern California

City of Los Angeles, Los Angeles, CA 01/08 – 12/09

FSCM TechnoFunctional Lead for Upgrade

PeopleSoft Application Upgrade from 8.8 to 9.0 PeopleSoft FSCM

Configuring/Year End Close/Budgeting/Maintenance support for 8.8/9.0 PSoft FSCM (PO,ePro,AP,GL,INV,SS,KK)

AXIUM International Inc, Burbank, CA 06/07 01/08

Programmer Analyst

PeopleSoft Application Upgrade from 8.8 to 9.0 PeopleSoft FSCM

And People Tools Upgrade from 8.45 to 8.49

Development/Maintenance support for 8.8 PSoft FSCM(AP, GL, Cash Mgmt, AR, BI)

Maintained the HRMS AP Interfaces for Avalon, DVI and DVX systems.

Designed & Developed Bank Reconciliation search Page to verify the reconciliation data.

SPRINT, Reston, VA 10/05 06/07

Sr. PeopleSoft Consultant

Legacy SPRINT maintenance support for 8.4 PSoft FSCM(AP, PO, ePro, Expenses) during NEXTEL merger period.

CBRE, Orange County, CA 04/05 – 10/05 Sr. PeopleSoft Consultant

Handled Conversions for 8.8/8.9 PeopleSoft CRM (Help Desk and MIX application internally developed) from MS Access systems like (Re Start, Real Hound).

California State University Oxford International, Los Angeles, CA 02/05 – 04/05 PeopleSoft Consultant

Retrofitted FINANCIALS/SCM (GL,AP,AR,AM,BI,PO,KK) SQR’s during 7.5 to 8.4 upgrade.

Developed couple of Departmental reports.

BANDAI America Inc, Cypress, CA 02/04 – 12/04 PeopleSoft Consultant

Handled blue tickets raised during Upgrade from 8SP1 to 8.8 and EDI transactions for FINANCIALS & SCM (OM,INV,CM,PC,AR,GL)

Developed an interface to facilitate the user in Finalizing the PO acknowledgments for the 850 transactions obtained from the Amazon.com customer.

Developed EDI 855 flat file generation for the Finalized PO Acknowledgments.

CorVel Corporation, Portland, OR 03/03 – 02/04 PeopleSoft Consultant

Development of SQRs for GL and AP for 8SP2 (PIA) and production support for AR, AP and GL Issues.

HONDA, Marysville, IN 11/02 – 02/03 PeopleSoft Consultant

Handled PeopleSoft AP module 7.5 to 8.4 upgrade.

Contact this candidate