Summary:

Confidential is a senior level certified Techno-Functional PeopleSoft Consultant with Seventeen 17 plus years of experience. He has completed nine 9 full life cycle projects and four 4 upgrades. His experience includes but is not limited to requirements gathering, fit/gap analysis, functional specification development, technical specification development, coding, security, setting up permissions lists roles based on security, data conversion, system testing, training, documentation and troubleshooting. He has experience developing in PeopleSoft FSCM versions 6.x through 9.2. Sat holds a MS in Computer Science.

Highlights:

• Seventeen 17 plus years of PeopleSoft financials experience.
• Former employee of PeopleSoft Professional Service Group PSG
• Has both business knowledge and technical expertise.

Skills:

• PeopleSoft: FSCM: 6.x through 9.2 - Project Costing PC , Contracts, Billing BI , Accounts Payable AP , Accounts Receivable AR , SPro, Asset Management AM , General Ledger GL , Inventory INV , EPM, Order Management OM , and Purchasing PO , PeopleSoft Security
• Tools: PeopleSoft Application 9.2, People Tools 8.53, People Code, Application Engine, Component Interface, Excel to CI, File layout, SQL, DML, SQR, Crystal Reports, Upgrade tools and procedures, Data Mover, Upgrade Assistant, Siebel, Informatica, Data Mover Tool, Import Manager, PowerBuilder, WinRunner, LoadRunner, ftp voyager
• Security: Configuring PeopleSoft Permission Lists and Roles and setting up Security
• Migration Tool: Quest STAT Software
• Job Scheduling Tools: AUTOSYS, TIDAL and PeopleSoft Process Scheduler
• RDBMS: Oracle, Sybase, MS SQL Server, DB2, Informatica

Professional Experience:

Confidential

PC Techno Functional Consultant

• Currently working as Project Costing Techno-Functional consultant at PeopleSoft 9.2 Financial Upgrade/implementation. Tools release is 8.53. Here are highlights from current assignment.
• Gathered Business requirements and created Business Requirement Documents BRD .
• Created Technical Design Doc TDD from Functional Design Doc
• Configured Project Costing modules including setting up PC business unit and chartfield configurations.
• Setup Rate Set and other Project Related Variables.
• Worked on Various customizations that involve changing PeopleSoft Pages, Components, Records and other related objects.
• Customized delivered app engines between sPro PC.
• Created Security Roles for users
• Working with 9.2 Upgrade team for Project Costing enhancements.

Confidential

PC -CA Techno Functional Lead

• Worked as lead Techno-Functional Consultant on a PeopleSoft 9.1 Financial Upgrade/Implementation. Role includes Setting up and Customizing Project Costing module. Besides doing technical development my duties include writing Functional/Technical specs for other members of technical teams and help them understand the functionality of the system. Started this Project as Lead Project Costing Consultant with KPMG and was retained by client for post go-live support. Following are key items achieved/delivered during this Project.
• Configured Project Costing Module for the Schawk which included setting up new Business Units and Project Costing Chartfields.
• Designed and Developed Custom Intercompany Process. Schawk is a Multi-National company and they needed something more than delivered PeopleSoft Inter/Intra Unit sharing process.
• Designed and Developed Custom WIP WIP Reversal Process.
• Designed and configured Integration between Time Labor and Project Costing. This includes customization of PC TL TO PC app engine.
• Configured Cost Billing Rate sets.
• Multiple Customization in Project Costing/Contracts/Billing/AP Modules which Included App Engines, Pages, Components, Menu Integration Broker.
• Helped team in configuring integration between Agile and Peoplesoft. Agile is being used as Product Management tool in Schawk.
• Helped OBIEE in data mining .
• Coordinated with Testing team to successfully test and implement Customization and Oracle patches/releases.
• Did Post Go-Live and Coordinated with Offshore team in deploying new changes.
• Wrote extensive SQL queries using Oracle Development Tools and created custom queries using PeopleSoft Query Tool.
• Developed/Re-design and Configured Security for Users and Super Users. Developed PeopleSoft and SQL data security report queries used by both the security and internal audit teams to identify the end-users, role assignments and access permissions for 9.1 system. Created and modified the Security Roles/Permissions/Profiles based on new requirements. Created new Query trees and provided secure access to those based on the roles.

Confidential

PC-CA Techno Functional Lead Consultant

• Worked as lead techno functional resource on a PeopleSoft Financials Upgrade Project from version 8.4 to 9.1. The Project went live with Project Costing, Contracts, Billing, Asset Management, GL, AR, AP and SPro modules.
• Involved in Major Customizations to Contracts and project Costing Module.
• Customizations include Changing Fee, Contracts Terms and amendments, Revenue and Billing Worksheets, Withholding Pages.
• Setup Security for Users. That included setting up Permission List, Profiles, and Roles.
• Created a new Custom Component and Page for Contracts History.
• Wrote an App engine to Convert 8.4 Rate Sets to 9.1.
• Customized Pricing and other Pricing Interface App Engine to accommodate Government Contracting requirement.
• Performance Tuned following App Engines and in some cases cut down the running time up to 80 .
• CA FEE
• CA LIMITS
• PC PRICING
• PC INTFEDIT
• PC CA TO PC
• PC SUM RFRH
• PSA ACCTGGL
• CA BI INTFC
• Created Technical documents and wrote user training guides.
• Used Quest STAT tools for all project Migrations between environments.
• Created DMS scripts for Upgrade process and Historical data Conversion.
• Wrote Extensive SQLs and Created Queries as needed.

Confidential

PC-CA Senior Technical Developer

• Worked as senior technical Resource on new PeopleSoft Financials Project Implementation version 8.8. Project went live with Project Costing, Contracts, Asset Management, GL, AR, and Billing modules. OM, AP and Inventory modules are in SAP which interfaces with PeopleSoft through various interface programs.
• Led the team in addressing gaps in Project Costing Contracts Modules and customized Project Costing App Engines to meet government guidelines.
• Created new App Engines for Burdens Pricing and Re-pricing.
• Wrote Multiple SQR for reporting purposes.
• Analyzed gap in Rate Templates and added new source and target criteria.
• Worked with performance enhancing team and did extensive tuning of App Engines, SQRs and People Tool objects to speed up major processes and reduce page load times.
• Customized Rates Template Component Interface.
• Creating strategy for go-live, cutover plans, risk management, Interfaces and Conversion while working with PMO project management office team to implement PeopleSoft applications.
• Worked extensively on archiving data from PeopleSoft Tables.
• Conducted extensive PeopleSoft Training sessions in a classroom setting to train Employees on How to navigate menus/PS panels, Create Public/Private Queries, Create Run Controls to run Processes, Run the Reports and Processes, Create Trace Files for debugging and move Pages and Queries data to Excel.
• Created test scripts and played a key role in Go Live process and Beta testing the system.
• Post go live production support, fixing bugs, new enhancements.
• Mentoring client employees for production support and development.
• Used Stat and Remedy Software s to do PeopleSoft Migrations between the environments.
• Also Participated in HR Upgrade Project from 8.4 to 9.1.

Confidential

PC-CA Senior Technical Developer

• Worked as senior resource on a PeopleSoft 8.4 financial project for a large Drugs Development Service company. Participated in complete life cycle of the two projects. Role included designing and implementing PeopleSoft Projects, Contracts, Billing and Accounts Receivable modules for a separate business unit of the company. Responsibilities included legacy system data conversion, writing interfaces between old and current system, PeopleSoft objects development and customizations using People Tools, Application Engine Programs, Component Interface, Excel to CI, File Layout, Queries, SQRs and Crystal Reports in Oracle database. Wrote Interfaces to Load Legacy Customers and Contacts, Rate Templates, Project Activities and Employees. Did extensive tuning of Application Engine and SQR programs to enhance system performance. Other responsibilities include supporting the current production system for other business units of the company.
• Besides that participated in HR Time Labor Project. Main role was to Convert and Translate custom PeopleSoft objects to German language. That included extensive changes to PeopleSoft Objects and SQR reports. Beside that wrote several SQR reports for users.
• Participated in PeopleSoft Financials Application upgrade from version 7.53 to 8.42. Role included Comparing and Migrating PeopleSoft Objects, SQR and Crystal reports. Helped team to identify customization and reapplying the customizations in new environment. Ran Data Mover scripts to import export data.
• Participated in PeopleSoft Financials Application and Tools Upgrade Project from release 8.42 to 8.44. Role included running compare reports, reapplying the customizations and stress test the application. Besides that participated in HP UNIX Server upgrade event.
• Developed coding and migration standards for the team and did code reviews for other technical team members. Defined developer's security access and set change control procedures in place for coding and customizations.
• SOX IT Change Management - Over past 2 years have implemented and executed a SOX 404 compliant approach for handling break-fix and application service requests which require formal finance and IT sign-off for each of: commencement of work, specifications, acceptance testing, and migration to production.

Confidential

Senior/Lead Technical Developer

• Worked as a lead technical consultant on PeopleSoft 8.8 Corning Upgrade team. Role included designing and upgrading PeopleSoft Projects, Contracts, ePro, AP, AR, Inventory, and GL Modules.
• Responsibilities included but not limited to Applying existing PeopleSoft customization in 8.19 and bringing them forward and applying in 8.8 version. Also customizing delivered PeopleSoft Objects and creating new objects to implement new functionality as identified by the current business processes. Besides that, I functioned as lead technical resource to debug and resolve current issues in application. Worked on ePro module to include new functionality to add multiple header and line comments, add new Chart Fields on Line Details page, added multiple header and line comments on PO workflow. Resolve the database conflicts in ePro to make the process work as designed.
• Designed the go-live strategy for the project implementation at client site as project was developed at an off-site location in Philadelphia. Participated in post go live support and helped client to resolve the issues quickly and effectively. Helped the client user groups to understand the new changes and assisted them in learning to use new features of the system. Besides that help the Corning project support team to understand all the new customizations and changes and gave them hand on training and support to learn the new system quickly

Confidential

Senior Technical Developer

Senior technical consultant and key member of the PeopleSoft Billing, Contracts and Projects team at Siemens Medical Services SMS . Helped the client implement the PeopleSoft 8.4 Billing, Contracts and Projects modules. Participated in the complete life cycle of the project with the consulting partner PeopleSoft and Anderson Consulting Group. Job responsibilities include new development, conversion programs and integration between PeopleSoft modules. Wrote Application Engine applications to facilitate new development and made extensive use of PeopleTools objects to create new records, pages, components and menus to implement new functionality. Designed and developed SQRs, Crystal Reports and Query enhancements to produce online and batch reports. Helped the other team members to develop new PeopleSoft objects and processes. Functioned as the support person for the PeopleSoft production system and resolved the day-to-day issues.

Confidential

Senior Technical Developer

• Senior technical consultant and key member of the PeopleSoft Financials team at the Verizon Network Integration project. Participated in the complete life cycle of the project with the consulting partner Price Waterhouse Coopers while implementing PeopleSoft Financials Project Costing, Order Management, Accounts Payable, Billing, Accounts Receivable, Asset Management GL Modules. Responsible for PeopleSoft development and system stress test. Also acted as an advisor for post go-live planning. After go-live the primary responsibility shifted to supporting all seven system modules. Day-to-day activities included executing production fixes, implementing new patches, performing new development using People tools, maintaining PeopleSoft security and writing SQRs, Crystal Reports and Queries. Also maintained responsibility for running all PeopleSoft batch jobs through Autosys a job scheduling tool. Finally, participated and designed the Quote conversion OM interface from Siebel to PeopleSoft and PeopleSoft to Siebel using Informatica as Data Warehouse tool.
• Worked as technical team lead for Phase 2 of the project in conjunction with Accenture. The main role was to review all the functional and technical design documents prepared by Accenture and to assist them in developing and fine tuning the application.

Confidential

Technical Developer

Member of the Supply Chain team, working alongside Deloitte Consulting in implementing PeopleSoft Supply Chain at a public service and utility company at Washington DC. Main role was to customize the PeopleSoft Supply Chain software, which includes Accounts Payable, Purchasing and Inventory. Responsibilities included creating records, panels, menu items, panel groups and writing extensive PeopleCode to deliver required functionality. Customized Application Engine processes and moreover performed extensive customizations and modification in the existing application.

Confidential

Technical Consultant

Member of Account Receivable Team at a Major Accounting Firm, which developed Business Engagement and Results tracking project. Responsibilities include customizing the AR module of PeopleSoft 6.0 and performing new development at the same time. Job includes database administration, modifying and writing new SQR reports, design panels, create new records, write People Code assign operator security and work with process scheduler

Confidential

Technical Consultant

Member of the PeopleSoft Manufacturing team at Fairchild Semiconductor Company. Performed a PeopleSoft upgrade and numerous customizations. Responsibilities included performing an extensive 'Item Id' customization converting an 18-character field to 25 characters in all tables, sub records, panels, sub panels, SQRs and COBOL programs. Also responsible for testing and migrating the changes to the development environment running on an Informix database using Data Mover and other PeopleSoft utilities. Maintained responsibility for creating records, designing and developing panels, writing PeopleCode, creating menus and assigning operator security to panels.

Confidential

Technical Consultant

Designed and developed a complete reserve valuation system for Zurich Insurance Group. The system was developed using object oriented technology with the help of PowerBuilder and MS SQL Server tools. It was designed to transfer data from Excel worksheets into database tables and provides windows based user interface. The system gives the actuaries and underwriters the ability to see all possible details about existing contracts. As a lead developer, role was to design new applications, code and test the system.

Confidential

Technical Consultant

Designed and developed a complete inventory control and warehousing system for Tommy Hilfiger. The system was developed using SQR as reporting tool, PowerBuilder as Client and Sybase as RDBMS. Designed extensive interfaces for running the SQR Reports from PowerBuilder on UNIX environment. Designed and developed numerous users friendly windows based interfaces to input and edit data and print reports. Extensively used object oriented methodology during design and development.

Confidential

Technical Consultant/Technical Lead

Successfully designed and developed an information system for Rohm Hass, a fortune 500 chemical company. The system was developed to provide the sales people and top management, with current information on their product line and resources. It helps the sales team in their presentations to the clients about their products and present future availability of the products. The system was designed using PowerBuilder and Sybase. Role on the team was to design and develop the panels to display information and update the database tables.

Confidential

Technical Consultant

Was member of a team which developed a forecasting system for Dell Computers, a fortune 500 computer manufacturing company. This system was developed using PowerBuilder as GUI Tools and Oracle as RDBMS. Role in the team was to download data from text files into the database tables and design panels to display and edit information at the front end.