SUMMARY:

• Confidential certified HCM, EPM and FMS developer.
• SQL Server and Oracle certified SQL developer.
• US Federal Security clearance.
• More than 15 years of experience in development and consulting on Confidential Applications.
• Production support, design, implementation, coding, testing Confidential ERP Modules.
• Customization Confidential reports using Hyperion, SQR and Crystal Reports.
• ORACLE, DB2, MS SQL Server development using SQL and ODBC drivers.
• OLTP, Warehousing, ETL data processing experience.
• Confidential version and platform upgrades.
• Data migration between client’s and Confidential databases.
• Experience with gathering and analyzing user requirements, performing fit/ Confidential analysis and prototyping.

TECHNICAL SKILLS:

Software Tools:

PeopleSoft Application Designer, BI (XML) Publisher, Workflow Approval Engine, Integration Broker, Query, Crystal Reports, SQR, nVision, Mass Change, Data Mover, Process Scheduler, Application Engine, T - SQL, PL-SQL

PeopleSoft Modules: HCM, Time and Labor, Payroll, Position Management, Enterprise Learning Management, General Ledger, Asset Management, Accounts Payable, Accounts Receivable, Treasury, Performance Management, Order Management, Inventory, Billing, Project Costing, Allocation Manager, Budgeting Planning, EPM Warehouse, EPM Data Marts, EPM Data Loader, EPM Global Consolidations.

Warehouse ETL Tools: IBM Websphere DataStage, Informatica

Programming Languages: People Code, Java, HTML, C++, C, COBOL

Operating Systems: Windows NT, OS MVS, TSO, Unix

Data Bases: Oracle, DB2, MS SQL Server, Sybase

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco.CA

Consultant

Tools: PeopleTools 8.54, Application Engine, PS Query.

Responsibilities:

• Functional design and implementation of transition of Confidential employees from elapsed time processing to Kronos based Punch Time Clock.
• Configuration of Time&Labor tables to setup Shift, Schedule, Workgroup data and development of migration scripts to propagate changes to the production instance.
• Development of the Punch Time Clock rules using Confidential Time&Labor Rule Processor. Creation Time&Labor custom rules as well as usage of delivered template rules.
• Troubleshoot development issues in the Time Administration process using AE Trace and stage data in the temporary tables.
• Integration Absence Management data into Confidential Time&Labor Module.
• Implementation of PS Query to compare payable time of the elapsed and punch schedules. PS Query results were presented as excel report with side by side comparison.
• Development PS Query reports for verification and analyses of Time Administration data.

Confidential, Portland, OR

Confidential Consultant

Tools: PeopleTools 8.54, Application Engine, SQR, PS Query, PeopleCode, BI (XML) Publisher, Workflow Approval Engine.

Responsibilities:

• Implementation of Confidential ELM 9.2 to facilitate handling school teachers license and certification data.
• Customization of Confidential Search Framework for ELM.
• Configuring ELM database for Learning searches.
• Setup of Learning Catalogues. Development interfaces from proprietary SMT module to load school teacher categories, classes and programs data into the Confidential ELM.
• Customization of Learning Catalog pages.
• Integrated ELM module user interface into the Position Management module. Built custom interface to collect employee’s licensing and certification data and transmit it to the Oregon County Educational Office.
• Time & Labor, Benefits Administration upgrade 9.1 to 9.2. Resolving T&L rules issues related to the new design of TL TIMEADMIN AE.
• Customization of existing Time&Labor rules for the seamless conversion of employees absence hours.
• Created Time and Labor custom module for electronic transmittal of school coaches punch carts. The process was designed to transform paper forms to electronic data entry. Implemented using PeopleCode, SQR and Workflow Approval Engine.
• Developed improvements and customizations for HCM Workforce Development Module. Improvements were targeted to reduce support efforts and make the module technical support free in the future.
• Provided customizations for HCM Contract Payment Interface (CONTPAY1.SQR). Improved Contract Payment calculations logic and created PS Query Tool reproducing the same calculations and used as verification method.
• Converted FSM Purchased Orders Workflow 9.0 to Workflow Approval Engine 9.2. Implemented Workflow Approval Engine for FSM Inventory, General Ledger and Accounts Receivable. This work included conducting fit/ Confidential analysis, writing functional specifications for gaps, data conversion, configuring setup tables, writing and executing test scripts, writing training materials, training users.
• Converted existing FSM Crystal reports to Oracle BI (XML) Publisher.

Confidential, Portland, OR

Confidential Consultant

Tools: PeopleTools 8.4, Application Engine, Integration Broker, Allocation Manager, Data Manager, PeopleCode, Oracle, PL-SQL

Responsibilities:

• Confidential Planning & Budgeting 8.9 upgrade. Module customization to provide multi Business Unit handling in the same Budgeting Model.
• DataStage ETL performance improvements. Customizations of delivered maps using Oracle table partitioning and parallel processing methodology.
• Created maintenance plans as part of the on-call support for ETL nightly batches.
• Maintenance plans included set of actions to mitigate risks due to the batch interruptions or performance degrades.
• Developed PS custom application module to handle “Quarterly Federal Budget Forecast”. The module consists of rule based setup, batch processing, on-line page based analytical tool and db output functionality.
• Created PS custom application module “Internal Operating Cost”. Development included rule based setup, AE batch processing and on-line analytical tool.
• Developed “Forecast to Complete” analytical tool to handle Federal Project Forecasts. The tool ETLs EPM data from various sources, runs batch processing to enhance data, allows users to make on-line data analysis and launch financial on-line reports in real time.
• Developed HCM Position and Job Data Models for SSRS OLAP reporting. ETL HCM Position and Job data to EPM. Flattening Position and Job data to create hierarchical structures. Provided functional analysis and verification of HCM data using SSAS and Excel Sharepoint.

Confidential, Chicago, IL

Confidential Consultant

Tools: PeopleTools 8.4, Application Engine, Tree Mover, PeopleCode, Oracle, PL-SQL

Responsibilities:

• Global Consolidations 8.8 implementation. Consolidation Ledger Template Chart Fields customizations. Journal Entry / Approvals modifications. GC Model configuration troubleshooting.
• EPM Warehouse 8.3/8.8 upgrade. Compare reports, identification of client’s customization, applying customizations to 8.8. Running, analyzing, restructuring upgrade scripts. Developing QA documentation for the system tests.
• EPM Data Loader performance improvements using materialized views and index modifications.
• EPM Data Mart Builder production support, integration with 3-rd party applications, provided solutions to bypass inconsistencies in the data loads of non-PS applications.
• Developed functional analysis and Proof of Concept for the customized Tree Mover process. The goal of this customization to replace 3 step FMS-EPM Tree Mover process with one step custom process.

Confidential, Chicago, IL

Confidential Consultant

Tools: PeopleTools 8.4, Application Engine, PeopleCode, DB2

Responsibilities:

• Performance improvement and fine tuning of the Budgeting Model Staging process. Process running time decreased from 6 to 2 hours.
• Developed enhancements for the Model Recalculation process. Provided functionality to run process in the debug mode for easy problem analysis.
• Applied SP2 Bundle 2 code upgrade to the Budgeting 8.8
• Improved performance of the custom Chart Field conversion process. Process running time decreased from 30 hours to 4 hours

Confidential, Pleasanton, CA

Confidential Senior Developer

Tools: PeopleTools 8.4, Application Engine, SQR, Integration Broker, Messaging, PeopleCode, Informatica PowerMart, SQL Server, DB2, Oracle

Responsibilities:

• Providing training sessions on the new features of Budgeting 8.9. Development and execution Budgeting 8.9 test scripts.
• Technical after production support of EPM Warehouse Data Enhancement Tools, Data Manager and Data Allocation Manager.
• Sustained development and enhancements of EPM ABM module.
• Performance tuning of EPM Budgeting Staging Process
• Assisting PS customers with Budgeting setup issues
• Modifications for the Budgeting HR extracts SQR processes
• Resolving issues with Messaging Data transfer Capital Acquisition Plans from FS AM to EPM Budgeting.
• Setup Informatica PowerMart maps to ETL data from PS HR and PS FM to EPM Budgeting.

Confidential, Orlando, FL

Consultant

Tools: PeopleTools 8.3, Application Engine, SQR, Crystal Reports, PeopleCode, SQL Server

Responsibilities:

• Implementation user definable Asset Depreciation calculation methods.
• Performance improvement of Asset Depreciation Allocation.
• Development Crystal Reports using Assets defined through Project Trees.

Confidential, San Jose, CA

Consultant

Tools: PeopleTools 8.1, 7.5, Application Engine, PeopleCode, SQR, Process Scheduler, Data Mover, Message Agent, PL-SQL Oracle

Responsibilities:

• Subcontract by Confidential to develop PS Archiving solutions for NEC Electronics, Kichler Lightning and Darden Restaurants.
• Implemented Confidential interface to the client Archive Engine. This project allows client to submit and execute Confidential Archive Processes outside of Confidential and improves performance and functionality.
• Developed API interface to Confidential Process Scheduler to submit a process request outside of Confidential . API functions are implemented using Confidential Message Agent and Oracle PL-SQL stored procedures.
• Provided functionality to set up and launch from Confidential Archive Engine on the Unix Server.
• Customizations and tuning Confidential SQR and Application Engine programs for purging and archiving Order Management, Inventory, AP and AR.
• Developed Data Mover scripts for Confidential Project deployment on client environment.
• Converted SQR programs written for PS v 7.5 into PS Application Engine programs for v 8.x

Confidential, Dublin, CA

Consultant

Tools: 8.1, 7.5, HTML, SQR, Oracle, Web Client, Crystal Reports, Oracle

Responsibilities:

• Financial Applications upgrade from Confidential version 7.5 to 8.1
• Client customizations tuning and conversion to Confidential version 8.1
• Implementation of Human Resources Intranet Self Service using PS Tools 7.59 and Web Client. Implemented Self Service functionality allows employees and managers access to Human Resources through Internet web browser.
• Developed SQR interfaces between PS AR and Financial Systems of Bank of NY and Chase Bank.
• Provided Production support for PS HR and Financial systems.
• Developed interface between PS HR module and eProcurement. Interface allows automated updates of ePro Buyers and Approvers data.
• Designed and developed a set of custom AR reports and processes for generation of AR Statements and Invoices.
• Developed Interface between client legacy system and GL module to provide automated conversion legacy data into PS GL journals. Redesigned the GL Activity Reconciliation report to allow reporting on the daily account activity.

Confidential, Palo Alto, CA

Confidential Consultant

Tools: PeopleTools 7.5, SQR, Sybase, Transact SQL, Crystal Reports

Responsibilities:

• Implementation of Order Management, Billing, Inventory
• Customized the delivered functionality. Provided enhancements for Export Control and Licensing.
• Batch process improvements using SQR, T-SQL and Stored Procedures.
• Data conversion from Legacy Systems to Confidential OM/BI System
• Order Management and Billing Reports using Crystal Reports and SQR
• Order Management - Billing Interface customizations.
• Project Costing reporting and control data improvements.
• Production Support.

Confidential, San Bruno, CA

Consultant

Tools: PeopleTools 5.1, 7.5, SQR, Crystal Reports, nVision. DB2

Responsibilities:

• Financial System (General Ledger, Asset Management, Accounts Payable) upgrade from PS 5.1 to 7.5 (DB2, OS MVS, Windows NT)
• Customized and developed new financial reports using SQR, Crystal Reports and nVision.
• Provided customizations and performance optimization of GL and AM batch processing.
• Problem solving and enhancements to the on-line processing for GL, AM, AP.
• Production Support.

Confidential, Pleasanton, CA

Business Analyst

Tools: PeopleTools 5.1, 6.0, 7.0, SQR, COBOL, SQL Server, Oracle

Responsibilities:

• Participated in all stages of PS EPM FSI implementation.
• Developed interfaces to GL and Treasury modules.
• Designed and developed Cash Flow Generation Engine. This module produces a set of cash flows for any financial instrument, which are used to appraise the financial performance of an institution. The two primary Confidential Funds Transfer Pricing engines—the FTP RATE and FTP FRATE engines - use this engine. Was nicknamed “Maestro Cash Flow” by PS FSI team members.
• Developed multi platform SQL DB access module for batch and on-line data manipulation using PS Application Engine.
• Developed utilities for data migration between client’s and PS databases.
• Developed new and customized existing reports using SQR and Crystal Repots.