SUMMARY

• Over 17 years of experience in Information Technology industry. Over 16 years of experience in customization, implementation, supporting, and upgrading of PeopleSoft Financials, HRMS, Campus Solution, Student Admin, Financial Aid, and SCM using PeopleTools, PeopleCode, and SQR.
• AWE Approval Workflow Engine, PeopleSoft Test Frameworks (PTF), Strong experience in implementing and customizing the PeopleSoft Enterprises Performance Management (EPM).
• Six years of Ascential DataStage experience, moving data from Source to OWS, OWS to MDW and OWS to OWE.
• Expertise in implementing, administrating, customizing, and maintaining the role based Enterprise Portal Pack 8.4.
• Implemented Kofax Document imaging software and integrated with PeopleSoft. Proven experience of customization in BaaN, Baan Tools, common module, Sales and Distribution module Safari Report Writer as well as good experience in Oracle, PL/SQL, SQL, Developer/2000 (Forms, Reports). Excellent communication skills, strong analytical, and logical abilities in business analysis and technical documentation.

TECHNICAL SKILLS

Languages: C, C++, VC++, SQL, PL/SQL, PERL and Java

Test Tools: Quality Center 11, QTP, WinRunner6.0/7.1/7.5, LoadRunner6.0/7.6/8.0, Rational Robot, Rational TestManager, PeopleSoft Test Framework(PTF), Rational Performance Studio, AstraQuickTest, Silk Tester

Bug Reporting: TestDirector 6.0/7.1/8.0, Rational ClearQuest, PVCS Tracker and Bugzilla

OS: Mainframe, HP Unix/Sun Solaris, AS/400, Linux and Windows95/98/NT/XP

Web Technologies: Servlets, Applets, EJB, ASP, COM, COM+, DCOM, .Net Framework 2,3, 3.5, C# RMI and MQ Series

ERP Packages: PeopleSoft Financials 9.2, PeopleSoft Campus Solution 9.0, PeopleSoft HRMS 9.2, CRM 9.1 PeoppleTools 8.52 & 8.54, menus, pages PeopleCode, AWE Approval Workflow Engine, new App engines, Work Center/Dashboards, Pivot Grids, BI Publisher, PeopleSoft Update Manager, PeopleSoft Image, Change Assistance, Campus self - service, Contributor Relations, Financial aid, Recruiting and admissions, Student administration, Student financials, Student records, BaaN 4.0, PeopleSoft 6.x/ 7.x/ 8.x (FI, GL, AP, AR, CM, PO, AM, OM, HCM, HRMS, BN, PY, T&L, EPM, SD, eBenefits, eDevelopment, ePay, eProfile, eEquity, eRecruit Manager Desktop, SCM, CRM, Sales, Product, Service, Support, Leads, Call Center) General Ledger, AP, AR, cash management, Inventory Management, Back order Processing, asset management, Invoicing, Purchasing, Billing

Web Language: HTML, DHTML and XML

Front Ends: Visual Basic 6.0/5.0, Power Builder 8.0, and Developer2000

RDBMS: Oracle 7/8/8i/9i, SQL Server7.0, DB2 and MS Access

Scripting Languages: TSL, VBScript and Java Script

Database APIs: JDBC, ODBC and Active X Data Objects

Application Servers: Web Logic, Web Sphere, IIS, MTS, and PWS

Network: TELNET, FTP, HTTP, TCP/IP

Others: Visual Source Safe, MS Word, MS Excel, MS Power point, MS Front page, MS Outlook, Microsoft Project, Lotus Notes/Domino, Norton Ghost and ClearCase

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Consultant

Responsibilities:

• Upgraded PeopleSoft for the Financial 8.9 to 9.2, SCM8.9 to 9.2, HRMS 9.0 to 9.2, and Campus Solution 8.9&MP1 to9.1.
• Performed following:
• Database upgrade.
• PeopleTools Upgrade from .
• PeopleSoft Application Upgrade from 9.0 to 9.2.
• Applying Customizations to new version of the PeopleSoft.
• Completed a fit-gap analysis for the upgrade.
• PeopelSoft 9.2 not supporting Crystal Reports.
• Worked with the PeopleTools to create the Fields records, pages & menus.
• Worked with the Application engine programs.
• Worked with the integration broker programs.
• Worked with the Components interface programs.
• Working with following new tools Work Center/Dashboards, Pivot Grids, BI Publisher, PeopleSoft Update Manager, PeopleSoft Image, Change Assistance
• Developed technical specifications documentation for reports based on functional requirements and functional design document.
• Collaborated with cross-functional teams to design solutions.
• Creating the SQR Reports using the following tables PS LEDGER, PS GL ACCOUNT TBL, PS FUNDA TBL, PS GROUP CONTROL TBL, PS DEPT TBL, PS BUS UNIT TBL, PS BENEF PLAN TBL, PS BUDGET PERIOD, PS HR SETID TBL, PS JOBCODE TBL, PS LOCATION TBL, PS LOCAL TAX TBL, PS PERSON, PS ADDRESSES TBL, PS POSITION DATA, PS PRODUCT TBL, PS PROJECT, PS LEAD, PS MARKETING, PS CUSTOMER, PS PRODUCT, PS OPPORTUNITY, and PS CALL CENTER
• Designed and developed reports using OBIA technology set as per the functional and technical specs.
• Working with GL,AP,AP, Asset Management, Cash Management, EDI, EFT Setup with banks, eProcurment, eBilling, eInvoicing, ePurchising, Inventory Management, Order Management, Back-order Management, Strategic Sourcing., Project costing, Contracts, Commitment Management, Data Management, Travel & Expanses, Line Item Budgeting, Position Budgeting.
• Configured Mobile Inventory Management system, Vendors can review the item availability on Mobile devices such as Ipad Cell Phones.
• Integrated 3party Manufacturing system to PeopleSoft Inventory system & Item Management system.
• Implemented PeopleSoft FSCM 9.2 Treasury/Cash, Banks Setup and Processing,Cash Management
• Working with the ebenefits, eDevelopment, ePay, eProfile, eEquity, eRecruit Manager.
• Implemented Strategic Sourcing. Module & Created Strategic Sourcing seller and buyer sell event process
• Developed automation Framework for FSCM, HRMS, CS, SCM, EPM applications.
• Working with PTF PeopleSoft Testing Freamwork, working with PTF Client, PTF Environment, PTF Explorer, Test, Test Case, Test Editor, different Variables for the test cases.
• Configuring the Environment for PeopleSoft Test Framework (PTF) R1.Define configuration options, Installed a PTF client, Configure the Web Profile.
• Used QC 11 as a centralized repository for all the Testing Efforts.
• Working with QC Requirements, Test Plan, Test Lab, and Defect Reports.
• Very good knowledge in PTF integration with QC including PTF environment setup in QC, PTF execution option setup and test plan creation and defect tracking for metrics
• Designed and implemented PTF Test and Test Case naming conventions.
• Developed and implemented execution standards, test assets standards and Code Optimization standards.
• Developed more than 31 PTF library files, and 3000+ PTF tests.
• Very good working knowledge in usage of system variables, persistent variables, PTF scroll handling, HTML table operations and reserved key words where necessary.
• Maintaining PTF test by doing test level mass updates connecting to the database.
• Working with PTF components PTF Explorer, Test Editor, PTF Recorder, Log Viewer.
• Record and editing test steps, adding, copying, and deleting test steps & Creating and editing test cases.
• Implemented PeopleSoft FSCM 9.2 Treasury/Cash, Banks Setup and Processing,Cash Management
• Worked as a QA for PTF 8.52 complete tool testing, enhancement and implementation.
• Implemented PTF 8.52 across all PeopleSoft apps automation.
• Implemented PTF 8.53 across all pillars of PeopleSoft apps automation.
• View both test and test case in a single view & Debugging tests
• Conducted weekly meeting about the about testing defects such as critical 1, critical 2 issues
• Performed data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data.
• Performed developer's testing and debugging on the issues.
• Collaborated with other teams for issues originated due to data from source applications.
• Supported testing life-cycle.
• Supported migration and cut-over activities.
• Supported post go-live activities.
• Interpreted and applied directions originating at a higher level.
• Upgraded PeopleSoft Enterprises Performance Management 9.0 to 9.1 SP2 (EPM) for Financial, HRMS, SCM, Campus Solutions.
• Ran the delivered ETL jobs for the Financials, HRMS & Campus Solution products.
• Led the team of 8 to 10 people.

Confidential

PeopleSoft Consultant

Responsibilities:

• Upgraded PeopleSoft for the Financial 8.9 to 9.2, HRMS 9.0 to 9.2,
• Analyzed of functional requirements.
• Performed following:
• Database upgrade.
• PeopleTools Upgrade from .
• PeopleSoft Application Upgrade from 9.0 to 9.2.
• Applying Customizations to new version of the PeopleSoft.
• PeopelSoft 9.2 not supporting Crystal Reports.
• Developed technical specifications documentation for reports based on functional requirements and functional design document.
• Collaborated with cross-functional teams to design solutions.
• Performed data queries for analysis by understanding existing warehouse structures and being able to answer user questions regarding the data.
• Performed developer's testing and debugging on the issues.
• Collaborated with other teams for issues originated due to data from source applications.
• Supported testing life-cycle.
• Creating the SQR Reports using the following tables PS LEDGER, PS GL ACCOUNT TBL, PS FUNDA TBL, PS GROUP CONTROL TBL, PS DEPT TBL, PS BUS UNIT TBL, PS BENEF PLAN TBL, PS BUDGET PERIOD, PS HR SETID TBL, PS JOBCODE TBL, PS LOCATION TBL, PS LOCAL TAX TBL, PS PERSON, PS ADDRESSES TBL, PS POSITION DATA,
• Working with GL,AP,AP, Asset Management, Cash Management, EDI, EFT Setup with banks, eProcurment, eBilling, eInvoicing, ePurchising, Project costing, Contracts, Data Management, Travel & Expanses, Line Item Budgeting, Position Budgeting, Inventory Management Back-order processing.
• Working with the ebenefits, eDevelopment, ePay, eProfile, eEquity, eRecruit Manager & Strategic Sourcing.
• Implemented Strategic Sourcing. Module & Created Strategic Sourcing seller and buyer sell event process
• Working with following new tools Work Center/Dashboards, Pivot Grids, BI Publisher, PeopleSoft Update Manager, PeopleSoft Image, Change Assistance.
• Worked with the PeopleTools to create the Fields records, pages & menus.
• Worked with the Application engine programs.
• Configured Mobile Inventory Management system, Vendors can review the item availability on Mobile devices such as IPad Cell Phones.
• Integrated 3party Manufacturing system to PeopleSoft Inventory system
• Working with PTF PeopleSoft Testing Freamwork, working with PTF Client, PTF Environment, PTF Explorer, Test, Test Case, Test Editor, different Variables for the test cases.
• Developed automation Framework for FSCM, HRMS, CS, SCM, EPM applications.
• Working with PTF PeopleSoft Testing Freamwork, working with PTF Client, PTF Environment, PTF Explorer, Test, Test Case, Test Editor, different Variables for the test cases.
• Configuring the Environment for PeopleSoft Test Framework (PTF) R1.Define configuration options, Installed a PTF client, Configure the Web Profile.
• Used QC 10 as a centralized repository for all the Testing Efforts.
• Working with QC Requirements, Test Plan, Test Lab, and Defect Reports.
• Requirement Collection: PTF is basically evolved from PSscript which is an internal automation tool of PeopleSoft. With the help of PSscript and QTP we gathered the entire requirement for an automation tool during people tools 8.51.
• Worked as a QA to test the PTF on 8.51, automated PTF using QTP for regressions, handled PTF bugs and fixes. Did pilot testing on PTF 8.51 which helped to gather the requirement for PTF 8.52
• Very good knowledge in PTF integration with QC including PTF environment setup in QC, PTF execution option setup and test plan creation and defect tracking for metrics
• Designed and implemented PTF Test and Test Case naming conventions.
• Developed and implemented execution standards, test assets standards and Code Optimization standards.
• Developed more than 24 PTF library files, and 1600+ PTF tests.
• Very good working knowledge in usage of system variables, persistent variables, PTF scroll handling, HTML table operations and reserved key words where necessary.
• Configuring the Environment for PeopleSoft Test Framework (PTF) R1.Define configuration options, Installed a PTF client, Configure the Web Profile.
• Working with PTF components PTF Explorer, Test Editor, PTF Recorder, Log Viewer.
• Record and editing test steps, adding, copying, and deleting test steps & Creating and editing test cases.
• View both test and test case in a single view & Debugging tests
• Developing 183 SQR programs.
• Working with SQR Conversion programs.
• Working with SQC programs & including that programs into SQR.
• Working with Inbound and Outbound interfaces using SQR.
• Conducted weekly meeting about the about testing defects such as critical 1, critical 2 issues
• Worked with the integration broker programs.
• Worked with the Components interface programs.
• Supported migration and cut-over activities.
• Supported post go-live activities.
• Led the team of 8 to 10 people.

Confidential

PeopleSoft Financial Consultant

Responsibilities:

• Worked with a team of three to four members.
• Implemented PeopleSoft Enterprises Performance Management 9.1 SP2 (EPM) for Financials and SCM, RMS, INIT, GFI, TransView systems.
• Worked with Confidential Project.
• Worked with the business users and creating the functional specification.
• Worked with 110 Report Packages.
• Worked with 235 reports, generated using different transit databases, using Cognos reporting tool.
• Working with QC Requirements, Test Plan, Test Lab, and Defect Reports.
• Working the business user to gather the requirements and understanding the functionality.
• Trying to analyze the requirements and creating the functional requirements.
• Working with end users to gather the report requirements.
• Working with the SOUPUI to testing the XML files.
• Automating these scripts using the Groovy Scripts.
• Testing the load balancers scenario’s.
• Working with SOA, REST & Soap.
• Worked with functional people to understand the function requirements.
• Converted all the functional specs into the technical specs.
• Worked with various Dashboards, KPI’s & Reports for Financials.

Confidential

PeopleSoft Consultant

Responsibilities:

• Worked with a team of three to four members.
• Implemented PeopleSoft Enterprises Performance Management 8.9 SP4 (EPM) for Financials and SCM, HCM.
• Worked with functional people to understand the functional requirements.
• Converted all the functional specs into the technical specs.
• Designed and developed the PeopleSoft architecture for the EMP implementation.
• Identified the different hardware and software requirements for the EPM implementation.
• Created tables using PeopleTools.
• Worked with purchasing, Billing, invoices and e-procurement.

Confidential

Responsibilities:

• Led a team of three to four members.
• Implemented PeopleSoft Enterprises Performance Management 8.9 SP4 (EPM) for Financial (Student Admin and Hospital Financials Management), HCM, and SCM.
• Designed and developing the PeopleSoft architecture for the EMP implementation.
• Identified the different hardware and software requirements for the EPM implementation.
• Integrated all the images into the PeopleSoft EPM.
• Creating the SQR Reports using the following tables PS LEDGER, PS GL ACCOUNT TBL, PS FUNDA TBL, PS GROUP CONTROL TBL, PS DEPT TBL, PS BUS UNIT TBL, PS BENEF PLAN TBL, PS BUDGET PERIOD, PS HR SETID TBL, PS JOBCODE TBL, PS LOCATION TBL, PS LOCAL TAX TBL, PS PERSON, PS ADDRESSES TBL, PS POSITION DATA, PS PRODUCT TBL, PS PROJECT, PS LEAD, PS MARKETING, PS CUSTOMER, PS PRODUCT, PS OPPORTUNITY, and PS CALL CENTER
• Worked with GL, AP, AR, Cash Management, purchasing, Billing, invoices and e-procurement, student records, Campus Solution, Student Recruiting & Admissions.
• Worked with the EPM process and tools Extract, Transforms, and Load (ETL) process.
• Worked on the project that involves implementing PeopleSoft Financials, HCM, and SCM.
• Responsible for 3 warehouses such as Finance and HCM and the analytical deliverables via Cognos Enterprise Reporting.

Confidential

PeopleSoft Consultant / Architect

Responsibilities:

• Led a team of three to four members.
• Implemented PeopleSoft Enterprises Performance Management 8.9 (EPM) for Financial and CRM.
• Worked with GL, AP, AR, Cash Management, purchasing, invoices and e-procurement.
• Designed and developed the PeopleSoft architecture for the EMP implementation.
• Extracted the data from different Financial systems and CRM.
• Developing 40 SQR programs.
• Working with SQR Conversion programs.
• Working with SQC programs & including that programs into SQR.
• Working with Inbound and Outbound interfaces using SQR.
• Creating the SQR Reports using the following tables PS LEDGER, PS GL ACCOUNT TBL, PS FUNDA TBL, PS GROUP CONTROL TBL, PS DEPT TBL, PS BUS UNIT TBL, PS BENEF PLAN TBL, PS BUDGET PERIOD, PS HR SETID TBL, PS JOBCODE TBL, PS LOCATION TBL, PS LOCAL TAX TBL, PS PERSON, PS ADDRESSES TBL, PS POSITION DATA, PS PRODUCT TBL, PS PROJECT, PS LEAD, PS MARKETING, PS CUSTOMER, PS PRODUCT, PS OPPORTUNITY, and PS CALL CENTER
• Worked with GL, AP, AR, Cash Management, Billing, purchasing, invoices and e-procurement.
• Worked with the EPM modules such as Budgeting and Planning, Enterprise Balance Scorecards, Key Performance Indicators (KPIs), Customer Scorecards, and CRM Warehouse

Confidential

PeopleSoft Consultant / Architect

Responsibilities:

• Implemented PeopleSoft Enterprises Performance Management 8.9 (EPM) for Financial and CRM.
• Designed and developed the PeopleSoft Architecture for the EMP implementation.
• Identified the different hardware and software requirements for the EPM implementation.
• Worked with enterprise warehouse for the EPM.
• Working with Financial Service integration (FSI), Migrating all the Financials tables into the EPM Data Warehousing.
• Extracted the data from different Financial systems and CRM.
• Worked with the following EPM modules such as enterprise balance scorecards, budgeting and planning, Key Performance Indicators (KPI’s), customer scorecards, and CRM warehouse.
• Used Ascential 7.5 PowerMart to do ETL.
• Worked with GL, AP, AR, Cash Management, Billing, purchasing, invoices and e-procumbent.
• Worked with Data Loaders and Ascential jobs to load the data into the warehouse.

Confidential

PeopleSoft Consultant / Architect

Responsibilities:

• Implemented PeopleSoft Enterprises Performance Management 8.8 (EPM) for Financial, CRM, and HRMS
• Designed and developed the PeopleSoft architecture for the EMP implementation
• Worked with GL, AP, AR, Cash Management, Billing, purchasing, invoices and e-procurement.
• Extracted the data from different Financial systems and HRMS.
• Led teams of 5 to 6 people
• Created tables for the development of scorecards and KPI’s such as dimension and fact tables,
• Worked with GL, AP, AR, Cash Management, and procumbent data models to load the data into Financial data warehouse.
• Worked with different Financials analytics such as activity-based management, balanced scorecards, budgeting, and funds transfer pricing.
• Worked with different workforce analytics such as HRMS warehouse, workforce scorecards, and workforce rewards.

Confidential

PeopleSoft Consultant / Architect

Responsibilities:

• Implemented PeopleSoft Enterprises Performance Management 8.8 (EPM) for Financial.
• Imported the data from PeopleSoft Financials application to the EMP Financial warehouse such as General Ledger, Asset Management, and Projects.
• Worked with global consolidation module to setup the rules such as balancing account type rules, tolerance rules, ownership rules, and elimination rules.
• Eliminated inter-company transaction.
• Worked with GL, AP, AR, Cash Management, purchasing, invoices and e-procurement.
• Worked on the above upgrades that were conducted first in development environment; same process was conducted into UAT, COB, and production environments.
• Led teams of 10 to 15 people.

Confidential

PeopleSoft Consultant / Architect

Responsibilities:

• Implemented PeopleSoft Enterprises Performance Management 8.8 (EPM) for Financial, CRM and HRMS.
• Worked with PeopleSoft organization to get the PeopleSoft EPM environment certification.
• Built the implementation team for the project and hired PeopleSoft DBAs to install the software and configure all servers such web server and application server.
• Provided training to the Developers, and Support and Functional teams for PeopleSoft 8.
• Moved the data from legacy, CRM, Financials, HRMS, and SCM systems to the EPM Operational Data Store (ODS).
• Arranged the weekly meetings with the related teams for the updates on the project.
• Provided training to the Developers, and Support and Functional teams for PeopleSoft 8.
• Supported around 160 users.
• Set up the global consolidation tables for the Chartfields of the business unit, department, product, and operating units.
• Worked with GL, AP, AR, Cash Management, and procumbent data models to load the data into Financial data warehouse.
• Worked with different Financials analytics such as activity-based management, balanced scorecards, budgeting, and funds transfer pricing.
• Worked with different workforce analytics such as HRMS warehouse, workforce scorecards, and workforce rewards.
• Worked with Application Engine and SQR for new interfaces and reports.
• Led teams of 15 to 20 people.