SUMMARY

DELIVERY / PROJECT MANAGEMENT / ERP Aligning PeopleSoft Financials/HRMS with Business to create solutions and opportunities that drive change Dynamic, innovative professional with proven track record designing, developing and delivering successful cost-effective, high-performance ERP technology and information systems solutions. Result-driven, analytical problem-solver with extensive experience in identifying opportunities and developing new business strategies and implementation framework to meet challenging multinational business demands. Twelve years of experience in the Information Technology Industry that includes 10 plus Years of PeopleSoft Financials HRMS experience, and 5 years of Project Management/directing offshore IT COE works and on-shore IT Development. Having worked with Big 5 consulting firms like PwC and Accenture while implementing following PeopleSoft modules:

Applied international standard and procedures for the processes. Particular areas of expertise include strategic planning, staff motivation and:

Keyword Summary:

PeopleSoft Financials SCM Ver 6.X to 8.9 ., PeopleCode, PS Query, PS nVision, Application Engine, SQR, HTML, Unix Shell Scripting, COBOL, Designer/2000, Visual Basic, PowerBuilder, Oracle 11g, Autosys, ControlM, Informatica, Datawarehouse development.

Operating Systems: Sun Solaris Ver 10, Sun Sparc, HP-Unix, Windows NT 4.0, XP, 2000, Vista. IBM Compatibles, Sun Classic, Citrix RAS, Sun Ultra. PROFESSIONAL EXPERIENCE SELECTED ACCOMPLISHMENTS

Work Summary

Confidential

Assistant Vice President

• Designed Flattened Tree Tables that gets refreshed every night during the Batch Initiation process that increases the performance of Combination Editing during the Jgen processes for different feed loads
• Defined and maintained Combination Edit Rules using the Account, Department and Product Tree Structure, and attached the Combo Rules to the Proper Ledger of the Business Unit.
• Combination ChartField templates are created and linked to proper ledger templates and Identified/created combination edit rules and edits groups. Tree structures and hierarchies are created for query security and rollup groups.
• Designed Ledger Vs Journal Integrity SQR report which checks for all the Journals posted and unposted to Ledger and to check which Business Units are out of sync between Ledger and Journals before the main close period each month. Ran Mass change process to close the Period for all PeopleSoft Financials modules every month.
• Identified and created business units, tablesets, and SetIDs and defined installation options and specified journal error processing options and approval options. Defined New Journal Sources and Journal Templates for New Feeds for GL module from different feeder systems. Defined ledgers, ledger templates and linked to ledger group and business unit. Journal sources, speed types and recurring journals are defined online.
• Created PS/n Vision reports to create consolidate by BU reports, Month End Balance Sheets and customized the Income statement reports. Involved in meeting with Functional Users to understand the Business requirements. Involved in Fit Gap analysis and was responsible for finding the gaps between the OnBase system and PeopleSoft Financials. Create and maintained Accounts, Security Access, Operator Classes.
• Develop/maintain mission-critical PeopleSoft HRMS applications and modules. Supported over 2,500 employees by applying timely patches, fixes and tax updates to PeopleSoft version 8.16.
• Assist Payroll, Benefits and HR users with troubleshooting and issue resolution involving W-2 printing, leave accrual adjustments and annual Benefits Open Enrollment.
• Analyzed and programmed on team upgrading PeopleSoft HRMS 7.5 to 8.0. Included upgrade of custom SQR programs, panels, menus and tables troubleshooting and debugging.
• Played key role in creating first Web-based Open Enrollment processing system. Included extensive testing, debugging and problem solving to reconcile calendar vs. fiscal year processing.
• Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 8i/9i Databases, table partitioning and Oracle Standby Server.
• Data warehouse development using ETL tools like Informatica and PL/SQL coding for the PeopleSoft ABM and GL environment.
• Applied SOX Controls for all the development work across globe. Using SDLC methodologies from Development to Migration into Production environment. Maintaining Business requirement documents into SDLC for future audit purposes.

Confidential

Project Manager ERP Systems

• Modified the existing Mass change Template/Definition that can retire high volume of Assets and also do high volume of Asset Re-Categorizations. Designed Developed Customized module called Contract Management Initiative for Purchasing Department to do a On-line Data Entry of the New Contracts and Supplier Contracts and also to do Query for the Q/Care Load. Designed a customized SQR program to upload Q/Care Data from Mainframe to PeopleSoft. This module will give you a List of Contracts Supplier Contracts which is used to show the Federal Government for going Public.
• Developed Customized Application Engine process to update the Open periods automatically for GL and AP modules. Customized Application Engine for bringing the PO Reference fields while doing automated requisition sourcing to PO.
• Set up and maintained interfaces between PeopleSoft Benefits module and legacy benefit system. Created, modified and maintained custom SQR programs. Upgraded custom SQRs version 7.5 to 8.0 . Worked on PeopleSoft teams with up to 1400 IT staff, end-users and consultants. Supported 35,000 employees in 40 states. Assisted users in developing procedures for maintaining data integrity.
• Customized the delivered SQR program to create Active Journal Entry transactions from the acquired Vytra Health plans company. Designed new SQR program to convert all the history ledger transactions into the ledger table.
• Modified the Journal Entry templates which uses only the specified ChartFields and amount fields required by the company. Tracking user Sign in and Sing out activity by running the system defined Audit table. Coordinated annual Open Enrollment processing. Analyzed and supported interfaces to and from Legacy HR systems to PeopleSoft HRMS systems.
• Projects included full life cycle development of new benefits enrollment system, which converted paper-based enrollment to online procedure saving 50,000 annually in costs.
• Helped Business Partners in Defining New General Ledger Business Units and corresponding financials modules Business Units for newly acquired company and tested out the transaction flow from AP module to GL module and PO Module to AP module. Doing Production support and resolving business issues by customizing the PeopleCode, or doing Data manipulation using Oracle SQL plus as per the business requirements and approvals.

Confidential

PeopleSoft Financials Lead

• Added PeopleCode to created default values for ActivityID, Resource Type, Resource Category, Resource Sub Category and Analysis type based on the PC Business Unit and ProjectID in the Journal Lines pages.
• Developing the data mapping, specifications for the conversion and interfaces. Have developed data mapping of Vendors, Vouchers, Journals, and Bank Reconciliation for the conversion and interfaces. Programming of the conversion, interface and reports programs using SQR, Application Engine. Working on customization of PeopleSoft process using PeopleCode and Application Engine. Designed, Developed several SQR reports and interface programs for end-users to meet Business requirements. Applying Bundles and Patches for AR modules. Applying Patches for AR UPDATE Application Engine program to remove the unique constraint errors in PS PENDING ITEM and modified the AR UPDATE program. Involved in doing on-line changes PeopleCode changes. Scheduled processes to run at a specific time and/or run recursively at a specific interval using Process Scheduler.
• Coding includes SQRs, PL/SQL, Message Agents and Custom developed PeopleSoft pages. System administration managing upgrades, applying PeopleSoft patches, Installs, User security, Database Design Tuning. Maintaining the NetOut Process and helped the users to do the NetOut process between Vendors in AP and Customers in AR and provided documentation to Users as to how to maintain Customer and Vendor relationships and to maintain Parent/Child relationships for more than one customer or vendors to be able to do Netouts. Running the Billing, Receivable and General Ledger interface to load all the Invoices from a third party system Right Angle into the PeopleSoft BI module then running AR Interface to load all the Pending Items in AR module, and then run the Journal Generator to load all the Accounting Entries into the GL module.
• Created a Customized SQR process to load all the AR Pending Items from third party system Nucleus into PeopleSoft. This SQR creates Accounting Entry lines rather than depending upon the AR UPDATE Application Engine process to create for it.
• Creating and deleting Temp Tables during the conversion process dynamically to avoid any increase in the table space of the database. Automated the process of running LockBox process to apply payments of Customers and then to run AR PREDICT app engine to apply the payments as per the payment predictor.

Confidential

Tech Team Lead PeopleSoft Technical / Functional Consultant

• Designed the UAT documents and submitted to all the Super Users. Helped the users in the on-going UAT testing for all the modules. Played as a Production support team member to support the users online in the Modules of Projects, Purchase Order, Accounts Receivable, General Ledger, Asset Management and Budgets.
• Upgraded PeopleSoft 7.5 Financials to PeopleSoft 8.17 using Upgrade Assistant, Data Mover. Ran numerous .dms scripts, .sqr scripts using Data Mover and also created a Flow Chart for the Client to let them know the flow of data from PeopleSoft 7.5 to PeopleSoft 8.17 using the new Upgrade Assistant Tool and Data Mover Tool. Defined the Upgrade Jobs and assigned to the Step process and then assigned to the Task in the Upgrade Assistant.
• Defined relationships between Multiple AR Business Units using Tree Manager, created Rollup Tree Nodes for Multiple AR Business Units. Defined Receivable processing for AR Business. Enabling GL distribution, Auto numbering and VAT.
• Converted all the System setup tables from 7.59 to 8.17 database for testing of all the 8.0 modules and report to the development team and as well to PeopleSoft Customer Connection site for any updates on those typical problem which has any fixes. Data Conversion of Assets and Proj Resource data of PeopleSoft 5.0 to 7.59/8.0. This PeopleSoft Financials 5.0 is from the previously acquired company.
• Established Asset Processes by Defining the Accounting Entry Template, Defining Asset Books and setup of Asset Classes. Defined CAP types. Modified the SQRs of Accounting Entry Detail Depreciation and Net Book Values . Customized the SQR program, which Loads Transactions into base Asset Management tables from the Financial and Lease Interface tables.
• Customized Application Engine programs for Asset Management, Project Costings and General Ledger modules also created customized Application Engine Program from AM -to -PC Interface. Customized the pages for Journal Entry, Purchase Order entry to remove INVALID VALUES Error, which has been reported as the common problem with PeopleSoft in most of the Translate or Prompt tables. Designed the SQR program so as to give exception reports, which gives the result of converted rows, not converted rows etc. Created Temp tables for the Conversion purpose dynamically and deleting the tables after conversion is completed.
• Defined new Process Definitions and appended new flags to get a good log file for any SQR Process ran for error. Upgraded SQRs from PeopleSoft 7.59 to 8.0. Upgraded these SQRs for their new tables of PeopleSoft 8.0 and new system variables.

Confidential

PeopleSoft TechnoFuncitional - Consultant

• Flowchart and Documentation for the Conversion Process is being presented and explained to the client before any conversion process is run in the Test or in Production environment. Assigned Budget Users from the Tree Manager tool for their respective departments. Imported the Budget Cube data back into the Ledger by running the Import Cube process through the Import Cube pages. Imported only the Initial phase of the Budgets.
• Converted Lease Information into Asset Management Modules and also customized the AM001TAX.SQR program to calculate the correct flat rate tax. Created New Project IDs if not existing in the 2000 projects for 2001 Projects, these were also done dynamically to check if the 2000 Projects are present or not.
• Converted new Activity Ids, Categories and Subcategories. Converted all the detail budgets for the Projects, Activities, Category and SubCategories from a flat file to PeopleSoft tables using SQR. Created and modified the existing Excel macros, which give the Output files from the Input, excel files Excel files of Dexter system with all the Projects, Activities, Category and SubCategory and Budgets cost in a line. Built online queries using Query tools and gave to Users to run those queries and the users either used to update the data and send the file across to me, then I used to Upload them using SQR.
• Helped the Users on-line in running their SQR reports to setup defaults for Individual users in the Operator preference panels. New panels were designed and new process definitions are being added to run the customized SQR and Crystal from PeopleSoft panels. Mock runs of Actual Data converted in Test environment of PeopleSoft, then User Acceptance Testing was done. Sign-off being procured from users based on UAT on Test environment.
• Converted all the Chart Of Accounts like GL Accounts, Departments, and Products etc from Legacy Dexter system to PeopleSoft 8.13 online while converting the data into the system. Crosswalk and Mapping table are also created online using Application Engine and the PeopleCode 8.13. Using PeopleCode 8.13. And File Object types, Flat files are being open and close during the Conversion process.

Confidential

PeopleSoft Technical Conversion Lead.

• All the Conversion Programs are written in SQRW language and they are being run through the SQR client window instead of PeopleSoft panels, this step was taken to give the Command through command line parameters of the SQRW.
• Provided a detailed design description of the Conversion process and step-by-step procedure as to how the conversion will take place from the extract file to the PeopleSoft tables. Conducted training sessions with user on SQR Suggested the use of the SQRW tool instead of Informatica which saved money for the client
• Interacted with clients regarding the Extract Input file format so that they bring out all the information necessary to do the data conversion successfully.
• Converted the Accounts, Department, Products, Budgets and Statistical Codes through SQR programs. All the General Ledger data were converted first and then the Budgets data have been uploaded into Proj Resource table for analysis type BD1 and BD2.
• Converted all the Tax Vendor Information from the Legacy Metro systems Great Plains Software to PeopleSoft 7.5 in limited time duration of two months.
• The Employee/Vendor information was also converted by giving them the Vendor Classification code as Employee during the conversion process.
• All the Tax vendors when converted are being checked for their 1099 classification, if they are 1099 then their TaxID is also being populated along with the Vendors information.
• During the Vendor conversion created a flat file from Vendors, which gives the Legacy Vendor ID's, and PeopleSoft Vendor ID's. This is used during the Open Purchase Order conversion, because this file consists of the Legacy Vendors, which are also present in the Open Purchase orders, so that the PeopleSoft Vendor ID can be assigned directly to the PeopleSoft tables.
• Converted all the Open Purchase Orders as dispatched from the Legacy system to PeopleSoft 7.5 and ran the SQR program through the SQRW client.
• All the online Pending Items in the Accounts Receivables were converted in a Group of 250 line items to improve performance of the Oracle database. These online pending items have been converted as not posted items so that the user/client will verify before posting it to the GL.
• Managed Anderson Consultants and programmers to meet their ends during the process of enhancements and customization of the PeopleSoft panels and records.
• During the Process of Data Conversion gave training and overview of PeopleTools and SQR to Accenture formerly known as Andersen Consulting employee so as to make them learn the SQR tool for their use in future.