PROFESSIONAL SUMMARY:

• Lead Architect/Project Manager on 6 SDLC implementations - PT 8.52, FSCM/HCM 8.8, 9.1
• 11 years of experience in architecting and developing applications, implementation, development, testing, upgrade and customization of PeopleSoft Financials, SCM and HRMS
• 10 Years functional experience in PeopleSoft FSCM & HCM suite and relationship to other PS modules.
• 10 Years of techno-functional experience using, configuring, troubleshooting and understanding FSCM and HCM/Payroll modules.
• 10 years of experience doing Fit-Gap Analysis and design sessions with end-users, requirement gathering and developing functional specifications
• Extensive experience doing business process re-engineering and recommendations across multiple platforms.
• Skilled project manager and consultant (functional and technical) for projects using best practices and methodologies.
• Experience in Business Processes of Banking, Retail & Advertising, Insurance, Health Care, Broadcasting, Communications, Public Services and Governmental Institutions.
• 11 years of experience in using People Tools such as Application Designer, Security Administrator, Data Mover, Import Manager, Work Flow, People Code and Process Scheduler.
• Extensive knowledge of Development Tools, Administration Tools and Reporting Tools (XML Publisher, SQR, Crystal, PS Query, Tree Manager and nVision).
• Certified and extensively used Testing tools (WinRunner, Load Runner, QTP) and testing methodologies
• Certified in QUEST-STAT Administration. Implemented successfully at several client sites.
• Excellent communication, team building and project management skills.

SKILL:

ERP: PeopleSoft Financials 9.2 (GL, AP, AR, AM, EPRO, OM, BI, EX, PC, PO). PeopleSoft HRMS (Time & Labor, Payroll, ESS)

Latest Project: PeopleSoft 9.2 Financials and SCM Implementation.

People Tools: PeopleCode, App Messaging, Integration Broker, Security Administrator, Process Scheduler, Application Engine, Workflow, Message Catalog, Database Agent, Message Agent. Application Package Level Coding.

Integration Tools: Component Interface, Application Messaging, Business Interlink, File Layout

Data Management Tools: Data Mover, Import Manager, EDI Manager, SQL PLUS, STAT

Reporting Tools: SQR, Crystal Reports, PS/Query, Tree Manager

Operating System: DOS, Windows 9x/NT/2000 Server/XP, UNIX

Languages: SQL, SQR, COBOL, PL/SQL, C/C++, and Java

Web Technologies: HTML, XML, Java Script, VB Script

Databases: Oracle, DB2, and SQL Server

GUI Tools: Visual Basic 6.0 and Developer 2000, Ultra Edit, TOAD, Edit Plus

Testing Tools: WinRunner, Load runner, Test Director, QTP

Servers: BEA Web Logic server, Apache, IIS

PROFESSIONAL EXPERIENCE:

Confidential

Security Implementation Architect

Responsibilities:

• Assisted Confidential to evaluate their security business process, hierarchies and processes.
• Made recommendations for how setup of security could best be utilized in support of the organization’s goals based on best practices
• Responsible for the setup and maintenance of FSCM, HCM modules.
• Responsible for gathering requirements and fit gap sessions for business process re-engineering.
• Designed and developed customized portal for the client to show for each real estate all of the components such ascontracts, maintenance pertaining to the property within one portal
• Provided functional and technical for the implementation of the IT Asset Management 9.0module with integration to Portal 9.0

Confidential

Senior Architect

Responsibilities:

• Responsible for the design and setup of ePro, Billing, AR, AP, PO, AM and GL
• Configured the integration between Asset Management and ePro,PO, AP, Receiving.
• Involved in daily resolution of issues related to Asset Management, Project Costing, PO, AP, AR, ePro and workflow. Shared services business model.
• Troubleshooting issues with Financial Gateway, Integration Broker
• Involved in Month End and Quarter End Accounting Processing.
• Customizations involving interfaces between HCM and Financials.
• Interact with business users to develop functional and technical design documents
• Leading the planning and implementation of upcoming 9.2 PeopleSoft Upgrade
• Project Manager for PeopleSoft 8.8 SP1 public sector HRMS/Time & Labor/Payroll upgrade from 8.9 to 9.0, consisting of 25+ team members
• Daily issues revolving around Workforce Administration, Organization (Position Management), e-Recruitment, Talent Acquisition, e-Performance, e-Profile, Self-Services, Benefits Administration, Compensations, Competency Management, Time and Labor, Absence Management, Performance Management, Career Planning, Health and Safety, Enterprise Learning.
• Responsible for project infrastructure, including project templates, processes, issues log, risk log and quality control
• Performed PeopleSoft Internet Architecture (i.e. PIA) technical assessment of client infrastructure
• Designed and configured PeopleSoft 8.42 Security and mentored client staff on configuration and setup and ongoing processes of security administration
• Assisted other project team members helping to solve functional and technical issues and researched solutions on software vendor's knowledge database.
• Managed on-site client relationship which included steering committee meetings and key stakeholder meetings.

Confidential

AVP/Technical Lead

Responsibilities:

• Lead Project Manager for HCM 8.8 to 9.1 MP1 upgrade, managing a project team consisting of over 30+ team members and two other project managers
• Coordinated and led activities between Infrastructure Project Manager, Development Project Manager, and Project Management Office as well as project team
• Collaborated with team on project upgrade strategy, approach, and plan
• Planned for and provided change management, communications management, migration, contingency plan and go-live activities.
• Served on PeopleSoft HRMS Payroll/Benefits/Pension team for functional testing, troubleshooting and end user support.
• Setting up Foundation tables. Hiring Employees-Personal, Employment & Job data Customizing HR Reports (Absence History, Mailing labels, Emergency Contacts etc.)
• Was involved in customization of Requisition Management, Job Applicant, Job Search, Applicant Search modules.
• Involved in implementation and configuration of AM, PO, AP, AR, ePro and workflow.
• Developed e-invoicing at guardian - automated requisition- voucher- pay cycle setup.
• Involved in developing, planning and building any new customizations
• Production Support tasks like DR, Unix AIX maintenance, PeopleSoft Security etc.
• Managing off shore support teams in Canada and india
• Interact with business users to develop functional and technical design documents
• Implemented Desktop Single Sign on for PeopleSoft Users at Guardian
• Integrates with LDAP and uses WebSeal for authentication
• Integrated with Active Directory to ensure single user id across desktop sign in, Inside Guardian Apps and PeopleSoft.
• Developed custom security and complex security scripts.
• Responsible for the design and implementation for Tools and Application Upgrade.
• Included design discussions based on functional role in each individual module
• Customization Analysis and Re-Apply
• Setup of security- Import and upload scripts
• Securing required databases, coordinating web sphere Admins, DBAs and Unix Admins etc
• Responsible for the design and setup of workflow for in ePro, PO and GL
• Implemented dynamic workflow, with custom application packages within ePro and PO
• Responsible for setting up epro Punchouts with Grainger, Dell, HP, CDW, MoreDirect etc
• Responsible for the design and setup of PeopleSoft architecture to bring hosting in house to Guardian from IBM (externally hosted)
• Implemented Peoplesoft Architecture internally - setup copies of databases, installation of PS, responsible for after restore scripts and PS Admin tasks - This project resulted in an annual savings of over 500K.
• Responsible for the design and implementation of custom interfaces from Guardian Inter and Intra Units and external vendors to and from PS.
• Included checks, EFTs, GL feeds, AP feeds, AR feeds and integration with TIVOLI as a nightly batch process.
• Used Informatica extensively for interface development
• Responsible for the design and setup of custom reports framework at GUardian. This custom framework consists of application packages that enable end users to run ad-hoc XML Publisher reports from a separate reports menu
• Designed and implemented XML publisher security
• Designed and published several XML reports - AP, GL quarter end, Month end closing process reports and Employee Vacation Days reports, Expense Reports etc

Confidential

Technical Lead/Architect

Responsibilities:

• Responsible for setup and design of AP, AR, EX modules. Involved in design of several complex customizations.
• Setup of Billing and AR interfaces. Customizations to Billing module to accommodate multi-level and split expenses.
• Responsible for the design and setup of workflow in Purchasing, Time & Expenses
• Both static and dynamic workflow designs used
• PO, T&E customizations (expense report modifications, time report mods, PO mods).
• Setup of PunchOuts to DELL, HP, OFFICEMAX, STAPLES
• Functional & Technical design, coding & testing of HCM, SQR batch reporting & PeopleCode.
• Assisted other project team members helping to solve functional and technical issues and researched solutions on software vendor's knowledge database.
• Managed on-site client relationship which included steering committee meetings and key stakeholder meetings.
• Collaborated with team on project upgrade strategy, approach, and plan
• Prepared and managed Project Plan, Budget, Risk log, Issues log, Status reports, meetings and other project related project office activities and documents
• Responsible for the design and setup of security in the PS system.
• Included design discussions based on functional role in each individual module
• Setup of user preferences based on functional role as well as one off basis
• Setup of security for technical team - developers, sysadmins, managers etc
• Scripts for maintenance and easy upload of security
• Designed a robust maintenance plan for post go live support
• Designed the central place for identifying health of projects in the system, termed “Project Jacket”.
• Project jacket provides an easy project centric interface to monitor the health of each project. It also acts as a tool to track the status of projects & provide statistics like variance etc.
• Customizations in PC module - enhanced searches, Ajax searches, project-id, Customer-Client hierarchy integration
• Responsible for the design and setup of STAT and related workflow for change management and version control
• Responsible for the design and implementation of custom client hierarchy module
• This module was designed to drive the client defaults onto various modules in the PS system in order to make transaction entry seamless and transparent.
• Also acts as a convenient place to define accounting entries, integrate rate plans and rate sets with projects etc
• Responsible for the design and setup of custom reports framework at JWT.
• Worked on resolving issues with HR to FIN sync with employee data load
• Batch schedule design and implementation
• Escalations and alerts in batch processes coordinated using custom shell scripts

Confidential

AVP/Technical Architect

Responsibilities:

• Implementation of PeopleSoft HCM Module ver. 8.8.
• Implementation of PeopleSoft Global Payroll whit Mexico country extension ver. 8.8 and its customization according to the processes.
• Coordinate and supervise the analysis, design, and develop phases of the project.
• Data Migration from Legacy systems.
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Responsible for setup and design of AP, AR, Billing,AM and PO.
• Configured IT Asset Management, Billing Interfaces
• Setup Voucher Approval Workflow
• Day to day issues involving check printing, ACH, duplicate checks etc.
• Involved in Month End and Quarter End Accounting Processing.
• Functional design of STAT workflow(change management tool) for object migration/ change procedures to meet with Audit regulations
• Technical deployment of STAT to all the developers on the team for change management
• Integrated STAT with PeopleSoft Security
• Certified STAT professional
• Responsible for the design and setup of Punchout in e-Pro with marketplace vendors
• Troubleshooting and maintenance of daily Punchout orders
• Worked with the network team to have Punchout work through firewall and proxy settings, setting up URLs, Connectors, node and gateway definitions
• Integrated Punchout orders with regular e-Pro workflow
• Implemented Punchout with 5 major vendors, looking to expand.
• Implemented ePro Global roll out for a successful Go-Live, followed by post go live production support and subsequent phases of the Global Requisitioning Project
• Responsible for the design and setup of line level workflow in EPRO 8.8 for 8 business units
• Certified Peoplesoft/oracle workflow designer and advanced EPRO professional
• Implemented catalog security using peoplecode and e-Pro, catalog management modules
• Technical expertise in maintaining updates with UNSPSC codes and custom catalogs.
• Familiar with setup and use of catalog manager
• Certified Informatica Developer
• Developed feeds to post data from AP to other systems like Investment Banking, Forecast Analysis, LDAP sync to peoplesoft etc
• Advanced knowledge in dealing with ETL issues, debugging.
• Certified TIBCO developer
• Developed EAI integrations with other systems within Confidential for sending real time and near real time updates to and from PS.
• Currently involved in preparing the upgrade project plans to chart the path for Oracle Database upgrade to Version 9i and PeopleSoft Tools upgrade to 8.49 and Application Upgrade to 9.0
• Responsible for maintaining the DEV, QA and STG boxes for peoplesoft administration tasks including weekend refreshes, web server and app server cache building, configuring new boxes etc
• Autosys jobs creation, maintenance
• Expenses module related enhancements and Maintenance

Confidential, Oceanport, New Jersey

Project Manager/Technical Architect

Responsibilities:

• Maintenance of HR, Payroll modules in peoplesoft and generate reports, queries.
• Year end 1099 reporting
• Developed a program to connect from PS Fin 8.8 to HRMS 7.5 - serves the purpose of employee self-service, complete with email functionality, security, W4 attachments, FTP and color coding.
• Scripted the upgrade path and scripts for upgrade from HRMS 7.5 to 8.8
• Worked as Post Production Technical team lead to resolve production issues in the earliest possible time. Involved in a key role during the Move to Go- Live for several Data Migrations and Data compare stages.
• Provided post-production support for the two GO-LIVE programs (SCM 8.8 & Fin 8.8).
• Utilized STAT for object migrations and compliance with SOX
• Led a team of 15 developers and met all the upgrade and testing deadlines
• Installed and used QTP, Load runner for testing scripts, test data loads and performance load testing
• Pivotal role in compares of patches and custom codes. Developed testing plans for ensuring custom code does not get overwritten
• Provided 24 hr post production support to resolve issues like verity no building, e-Pro shopping cart problems, configuration of ports, security issues etc after the upgrade.
• Responsible for the implementation and maintenance of EDI with Gentran.
• Experienced in interfacing Peoplesoft with Third Party systems for EDI/XML transactions
• Created business processes, schedules and EDI maps, Troubleshoot errors in 810’s, 850’s and 855’s
• Sterling Commerce certified Gentran Professional
• Upgraded from Gentran 4.0 through to 4.1, Created and ran the upgrade scripts, clean up on the Install nodes. Performance monitoring on the new upgraded system
• Responsible for the design and setup of line level workflow in EPRO 8.8 for 10 business units
• Integrated activities, business processes and online setup for seamless functioning of workflow, complete with worklist and email notifications
• Re-structured the modular approach of old workflow for better performance value.
• Also setup workflow in Purchasing 8.8, for routing PO’s from buyers.
• Designed archiving of worklist by date
• Responsible for the design and setup of Punchout in e-Pro with marketplace vendors
• Troubleshooting and maintenance of daily Punchout orders
• Technical deployment of STAT to all the developers on the team for change management
• Integrated STAT with PeopleSoft Security
• ASN receiving process - modified to be able to accept multiple receipts. Also SQL tuning of the app engine PO RECVLOAD
• Developed a price locking SQR to lock prices for certain items, based on a fixed date each month
• Performance and SQL tuning of Manage requisitions page and Manage Approvals in e-Pro.
• Fixed several bugs related to PS verity search and build in e-Pro
• Developed a process for Par-replenishment, to be able to pull stock, non stock, stockless items and create Pos and store room orders, off of the same run control page.
• Developed a color coding functionality for Voucher entry panel in AP, when a partial voucher is cut.
• Daily matching issues, check printing issues, voucher build errors.
• Developed a method to record wire transfers directly into PS AP, and a report for monthly wires.
• Developed several aging reports for AP.
• Worked with PS Query on a regular basis to develop queries in PO, e-Pro, AP.
• Certified PS/Oracle advanced developer
• IB node and gateway setup, message monitor, troubleshot errors in various channels, Extensively used message channels, Integration wizard
• Applied filters, transformations, translations for inbound and outbound messages
• Backup PeopleSoft security administrator - hands on experience with creating and maintaining users, requester setup, buyer setup, roles, permission lists for various affiliates.
• Responsible for the daily maintenance of Pyxis file uploads into the PS inventory system
• Administrator for the ATPAR handheld devices that are used at docks for ordering items below par
• Upgrades, Patches and regular maintenance of the Pyxis machines and ATPAR servers

Confidential

Senior PeopleSoft Consultant

Responsibilities:

• Set clear project goals and objectives. Established checkpoints and milestones at each stage of development. Handled time estimates.
• Created Project reviews, Status reports, Milestones Charts and logged every step. Developed several functional and technical specs
• Worked closely with functional team in Setup and configuration of AR, BI, AP and Purchasing.
• Monitoring application infrastructure including troubleshooting network degradation/slowness, understanding Web server and application server logs.
• Responsible for requirements definition, process analysis, fit/gap resolution, process design and implementation, functional application design, application configuration, testing, training, and cutover
• Responsible for setup and design of workflow in E-Pro and Purchasing. Workflow in 8.8 varies from 8.4 considerably. Implemented most of the workflow modifications by changing Application Packages
• Involved in developing Data Mappings from legacy to PeopleSoft for data transfer.
• Involved in developing monthly reports using EPM tools (Data Mining and Data Warehousing).
• Resolved several issues, bugs, fixes after the Financials Go-Live. Fixed errors with time & materials requisitions in E-Pro
• Implemented role-based activation of workflow processes for Gatekeeper role in E-Pro.
• Modified complex verity search page modification in Purchasing for requisition selection. Modified the PSWORKLIST page to transfer modified priority field values.
• Customized crystal checks printing process FIN 2025. Customized peoplecode on vendor setup pages
• Modified the TIN and W9 entry peoplecode in AP.
• Paycycle issues: Customized Paycycle process by changing the way the customer account number is recognized by the app engine process that kicks off the pay cycle process.
• Implemented several complex N-Vision Reports & DrillDown layouts in GL for Income Statements, Govt Fund reports.
• Developed several SQRs from scratch - Par replenishment Locations Order by BU, DEPT reports, PYXIS data conversion and interface report, GL detail by category report, Store room issues report.
• Performed performance tuning and troubleshooting for the SCM modules implemented.
• Customized the PO DISP process and the popo005.sqr, to eliminate formatting issues, calculate multi-line totals etc.

Environment: PeopleSoft Financials/SCM 8.8, People tools 8.44.10, AR, AP, BI, EPRO, PO, INV, GL, People Code, Application Engine, SQR, Crystal, PSQUERY, PS/nVision, Weblogic, Windows 2000,XP, Oracle 9.2i, SQL Server, and PeopleSoft Enterprise

Confidential, Memphis, TN

Senior PeopleSoft Consultant

Responsibilities:

• Provided online technical support for Supply chain and Financials modules for priority based post - production issues.
• Contributed to the creation of project planning deliverables such as a testing strategy, conversion strategy, development standards, configuration strategy and an interface strategy.
• Involved in setting up the General Ledger to implement the Journal processing, defining Journal Generator Templates and transferring journals to General Ledger.
• Organized, Planned and established controls within the team and defined decision check points and ensured quality assurance for the overall team outcome.
• Implemented Payment-Predictor to automate cash payments for the AP, AR modules.
• Set up Workflow for AP Voucher Approval, and Customization of AP pages according to the user requirement.
• Fixed E-Pro template creation errors - requisitions could not be saved based on custom templates due to an override error by a patch. Implemented a workaround for this issue.
• Resolved several SQL issues with the custom tables before loading the data using data mover scripts.
• Customized Vendor Maintenance Pages, AP setup and Configuration
• Implemented data conversion and data interface SQRs and file layouts to interface date with incoming vendors and vouchers data.
• Involved in developing Data Mappings from legacy to PeopleSoft for data transfer.
• Upgraded GL, AR and AP modules from 7.53 to 8.4 using the Upgrade Assistant
• Performed an enhancement to BIIVCSTS prior to integration that added the ability to change bills from NEW to pending status
• Developed Unit Test Plans and executed the plans to test the individual components like pages and SQR programs

Environment: PeopleSoft Financials 7.53/8.4 SP1, People tools 8.4,, Billing, Expenses, GL, Manufacturing, AR, AP, People Code, Application Engine, SQR, PS/nVision, Weblogic, Windows 2000, Oracle 8i, SQL Server, PeopleSoft Enterprise Portal.

Confidential, Kansas City

Senior PeopleSoft Consultant

Responsibilities:

• Created Project reviews, Status reports, Milestones Charts and kept a good log of every single step taken to achieve each and every customization
• Provided functional and technical support to ensure successful integration of the applications
• Tuning assignments included SQL, SQR, COBOL, Application Engine, Application Server, Process Scheduler, Nvision, PeopleCode and web related activities.
• Customized Order Management: Performed following activities in OM- Setup Application Messaging for EDI transactions of Sales Order Load (Inbound) and PO Dispatch (Outbound) and setup Chunking Rule.
• Involved in implementation of Single Sign On and integrated with LDAP server
• Customized Journal Entry Detail Report, FIN2001 to show correct chartfield values
• Extensively involved in troubleshooting pay cycle manager, which is a crucial application engine process in accounts payables & expenses
• Custom report to be used for reconciling PeopleSoft Purchasing to General Ledger
• Resolved rounding error issue that was causing AP VCHRBLD to flag valid vouchers in error.
• Developed and executed Unit Test Plans to test the individual components like pages and SQR programs executed as a system upgrade form v7.53 to v8.0. Responsible for identifying, modifying, and re-developing SQR programs, Crystal reports, PS Queries and PeopleCode programs to be compatible with the newer version
• Gathered response times statistics for various departments and processes and performed database tuning. Authored the SQL Server database security procedure and guideline documents, which improved overall database security management when installing the SQL Server, applying hotfixes, and patches

Environment: PeopleSoft Financials 7.53/8.0 SP1, People tools 8.10, People Code, Application Engine, SQR, PS/nVision, Crystal Report, Weblogic, Windows 2000, SQL Server, and PeopleSoft Enterprise Portal

Confidential, Louisville, KY

PeopleSoft Consultant

Responsibilities:

• Involved in the design and full life-cycle implementation of the application.
• Participated in requirements definition and documentation sessions with senior management and project team.
• Learned functional relationship between Procurement, AP and GL, and used functional panels extensively to aid in the creation of test data for various panels and processes
• Experience guiding others in solving complex technical problems in a PeopleSoft environment
• Facilitated an effective management plan to handle ongoing SQL Server performance monitoring and tuning.
• Worked on setup procedures for Reconciliation process in AP and also involved in the setup of Pay Cycle Manager in AP
• Developed interfaces with the legacy sub systems (GL and AP) using Component Interface, SQR, File Layouts and Application Designer.
• Involved in updating inbound GL, AR, AP interface using File Layout to reflect changes in 8.0.
• Rewrote the complete Payment Predictor program to map payments to an open item.
• Fixed the AR UPDATE step which did not insert values into PENDING ITEM when an item is created via a payment worksheet
• Customized the Application Engine program AP PSTPYMNT.BC050 to populate the APPL JRNL ID for the journal Generator to create journal lines
• Successfully reduced the time to run the billing interface program
• Developed interfaces with the existing legacy sub systems for payables, Billing, & General Ledger using SQR, EDI Manager, Application designer & PeopleTools
• Responsible for the implementation of the reporting solution for PeopleSoft Financials (GL, AR, AP, Billing, EX).
• Wrote SQR programs, including reports, data conversions, and interfaces to integrate GL.
• Extensively involved in the design and implementation of feeder system chartfield validation modified custom programs that load the billing interface staging tables with appropriate original invoice information from external order management system for credit memos
• Customized payment forms that come with PeopleSoft Payables and modify the crystal report to the form which matches the client specifications
• Assisted functional analysts and prepared data mapping for conversion and developed conversion strategy
• Used PS Query, SQR, Process Scheduler and Crystal Reports extensively
• Configured the GL Expense accounts for benefits taxes for the appropriate deduction class, so the GL interface can reference them as needed
• Wrote an SQR to change the length of each value of the GRADE field in SAL GRADE TBL, SAL STEP TBL, and SAL RATECD TBL from one or two characters to three characters
• Developed an inbound interface that reads file from AON (Health Care & Insurance benefits)
• Updated existing PeopleSoft labels in the Time & Labor Self Service Weekly Elapsed Time page (and in related pages that these fields appear) to accurately reflect the information
• Loaded data from flat files to various tables such as BEN PER DATA, BEN PLAN DATA and JOB in PeopleSoft database using Import Manager and structured query reports
• Created an interface to extract employee 401k demographic and contribution data from PeopleSoft and formatted an output file for American Express
• Tracked the usage of the company's vehicles using the Time and Labor module of PeopleSoft and transmitted the data to "Fleet Anywhere", an internal system
• Developed an interface to upload bonus or one time payments using excel into PeopleSoft
• Used Import Manager to move the data from the flat files and Excel files into PS-Tables
• Identified, tested and applied various patches/bundles for AP, GL, AR modules in the upgrade process on various environments (FS8DEV, FS8TST, FS8PROD).
• Assisted the technical lead with executing the upgrade steps using Upgrade Assistant
• Ran SYSAUDIT and DDDAUDIT reports and cleaned up the database prior to executing the initial pass of the upgrade

Environment: PeopleSoft HRMS 7.5, PeopleSoft Financials 7.53, People tools 7.53, People Code, SQR, Crystal Report, and Oracle 8.05