Summary

• Around eleven years of experience in IT industry, all of which is in diversified fields of Application Software Development and Maintenance projects in PeopleSoft applications.
• Worked extensively in PeopleSoft technologies, on different platforms and databases.
• Has worked on MS-DOS, Windows NT, Windows 95, Windows 2000, Windows XP, and UNIX, Z/OS platforms.
• Has used ISO 9001 and SEI CMM LEVEL 5 quality procedures in executing his projects.
• Has good knowledge of the Insurance, Healthcare, Retail and Finance industries.
• Has good Project Management skills and being a certified PMP(Project Management Professional), applies the project management principles in the project.
• Being a PeopleSoft Certified Consultant, has excellent PeopleSoft technical knowledge as well as practical functional knowledge in both PeopleSoft Financial & HR applications.
• He has solid experience in PeopleSoft 7.0, PeopleSoft 7.5, PeopleSoft 8.0, Peoplesoft 8.3 (HRMS), PeopleSoft 8.4(Financials), PeopleSoft 8.8, Peoplesoft 8.9 and PeopleSoft 9.0 versions.
• Has been a Technical Lead for many projects, primarily Upgrades, both tools and application.

• Certified as Project Management Professional (PMP) from the Project Management Institute.
• Certified as Peoplesoft Certified Technical Consultant from Peopelsoft Inc.
• Sun Certified Programmer for the JAVA 2 Platform from Sun Microsystems, Inc.
• Certificate in General Insurance from Insurance Institute of America

Professional Experience
Project Name: Peoplesoft 9.0 Archival
Confidential,Baton Rouge LA, US
Role: Technical Lead
Duration: Jul’09 – Till Date
Environment: Peoplesoft Financials, Peoplesoft HR, Peopletools, Peoplecode, Application Engine, Component Interface, Integration Broker, Application Server, Web Servers, LDAP, Oracle 10g, Unix, PL/SQL, Crystal, SQR, Facets

Responsibilities:

Blue Cross had no strategy to archive the Peoplesoft tables. It had 7+ years of data in the system and performance was degrading slowly. This project was to develop a strategy to start with for archiving the Financials and HR modules, then develop and roll in into production.

• Studied the different Archival tools available in the market including IBM Optim, Solix Database Archival, Aplimation Informia Data Archiving.
• Performed an in-depth analysis of Peopelsoft’s Data Archive Manager.
• Developed the strategy for Peoplesoft Archival for Blue Cross based on the analysis and cost benefits.
• Did an in-depth analysis of the tables needed to be archived. And what all tables needed to be included to maintain the integrity and avoid data corruption.
• Allocating work accordingly to the team.
• Preparing a schedule for the project.
• Knowledge transfer to the team on how the Peopelsoft Data Archive Manager works.
• Making a questionnaire for the functional team to get the inputs on the criteria for the data to be archived for each archival object, legal retention requirements for the company, etc.
• Creating the Archival Objects for the Financial and HR modules.
• Developing the PS archival public queries to pull the data out of the current tables.
• Creating the history tables by cloning the current tables.
• In-depth analysis of the PSARCHIVE app engine.
• Develop required reports on the archival history tables.
• Develop new public queries and change existing queries so that right data is pulled.
• Working with the DBA’s to understand the database side and about the different types of storage, the size of the UNDO tablespace etc.
• Giving regular updates to the governance on the status of the project.

Project Name: Peoplesoft Financials 8.4 – 9.0 MP5 Upgrade, Peopelsoft HR 8.9 – 9.0 MP5 Upgrade
Confidential,Baton Rouge LA, US
Role: Technical Lead
Duration: Jan’08 – Jun’09
Environment: Peoplesoft Financials, Peopletools, Peoplecode, Change Assistant, Peoplesoft Security, SQR, Crystal, n’Vision, Application Engine, Component Interface, Integration Broker, Application Server, Web Servers, LDAP, MVS, DB2, Oracle 10g, Unix, PL/SQL, COBOL, SPUFI, JCL

Led a few projects.

Worked as a Technical Team Lead for all the projects above.

Responsibilities:

• Assisting in Re-Platforming issues. Working with Oracle to develop the plan and technical tasks needed to re-platform the database from DB2 to Oracle.
• Performing all the technical tasks – especially creating all the exports and import scripts and running the same. Splitting them across different machines to reduce the down time for the Go-Live.
• Playing a role in defining the charter, the scope of the projects, defining the roles and responsibilities, the communications and risk management plans for the Upgrade project.
• Deciding the strategy for the Upgrade and the order of the different projects. All projects were to be completed in around 1.5 years.
• Preparing the technical schedule for the Upgrade. Worked with the Functional team to complete the whole schedule.
• Preparing the environment strategy document. Deciding how many new 9.0 databases are needed for the Upgrade and which databases will be used for Initial pass, Test Move 1, 2 and 3. We are having 3 test Moves.
• Downloading all the Upgrade documentation from Customer Connection.
• Helping in preparing the Test Strategy.
• Preparing the Environment strategy for both Hr and FN Upgrade.
• Writing Technical Specification Documents for all customizations needed in 9.0 application.
• Re-applying all customizations and Unit testing the same. Documenting the test cases and results in Mercury.
• Upgrade of all Crystal and nVision reports.
• Upgrade of all public queries.
• Reapplying all PeopleCode, SQR, Application Engine customizations to the new delivered Peoplesoft 9.0 application. We do have a lot of customizations and interfaces in BCBS.
• Preparing dms scripts to automate the re-applying of new configuration in the test moves so that there is no manual effort.
• Applying all Required for Upgrade bundles for the Upgrade path.
• Applying the UPGCONVERT project and other files from the customer connection page to the source and target home directories.
• Helped the DBA’s understand how much database space is needed for the 9.0 databases, much much the target database will increase from begin to start of the upgrade, etc.
• Running Upgrade scripts using Change Assistant for the Initial Pass as well as the test moves. We are done with the Initial Pass and 2 Test Moves. Ran all the scripts and documented the run times for automated as well as manual steps to have a roll-out plan for Go-Live.
• Tuning the Upgrade app engines to bring down the Go-Live down time to the minimum. Had to work on a few sql’s in the UPG_IN app engine to bring down the run times of Group 4 which was initially running for 30-40 hours in Initial Pass and Test Move 1.
• Discussed and developed a strategy to run Runstats at suitable times to help the process to run faster.
• Some import scripts ran longer hence kept an eye online while they were running and made some changes like dropping indexes etc to bring down their run times. Ultimately brought the overall Upgrade run time to an acceptable range so that the down time is just a day apart from the week-end.
• Working with the users to resolve the defects logged in Mercury. Delegating defects to the team. And helping others resolve their defects.
• Making sure that the defects are not recurring during the next Move.
• Developed s strategy to copy all user profiles and passwords and their associated roles from production during Go-Live. Since the MVPRDIMP.dms script will import and replace all the data from the Source during each test Move. This avoided a lot of work by the security analyst to add the new users back into the system manually.(new users added into Production since the Copy of Production was taken and Go-Live).
• Also created a list of export scripts that need not run on the Go-Live week-end to save time. These export scripts will be run on the source the night before Go-Live and the .dat files will be placed in the data folder. Only the imports will run during Go-Live picking up the .dat files. This eliminates all the time it takes to run the export script. One big one is MVPRDEXP.dms
• Also developed a script to copy all Tree Data from Production except for the Query tree data. So that production changes need not be tracked and re-applied to the Test Move database or the Target database.
• Assisting in Performance Tuning. Helping the testing team to create the scripts needed to run.
• Also developing a strategy to bring down the run times for the Upgrade scripts like increasing the SGA size, allocating more CPU.
• There were a few defects which were data related and had to be applied after each test Move. Made a list of all those Go-Live fixes and applied it after each test Move.
• Cash management has a lot of changes between 8.4 and 9.0. Some table structures have changed, some new tables exist in 9.0. The conversion has some issues with bank statements concerning the statement id’s. New bank statement numbers are created with balance entries with the same asofdate. Created scripts to correct the issue so that both transaction and Balance data exist with the same statement number. Ran the scripts in every test Move after the conversion app engines run.
• Providing weekly status to Governance and management regarding the progress of the project.
• Trying to establish a good camaraderie within the team by involving anyone, trying to diffuse stress and taking everybody’s suggestions in consideration.
• Implementing all PMP principles in the project to ensure it’s success.
• Working with Time Admin issues in 9.0.
• Applying bundles T&L 6, 7 and 8 to fix major issues.
• Putting in all the customizations back after the Initial Pass.
• Putting in the Tax Bundles for testing and to fix some defects in Payroll.
• Allocating work to the team for the Go-Live week-end.
• Running the Change Assistant scripts on Go-Live. Ensured that the Go-Live was completed within the Go-Live window.
• Looked into the Post Go-Live defects and resolved the same in a timely manner by allocating them to the team.

Project Name: Peoplesoft HR 8.8
Confidential,Wilkesboro NC, US
Role: Technical Architect
Duration: Sep’06 – Jan’08
Environment: Peoplesoft HR, Peopletools, Peoplecode, Peoplesoft Security, SQR, Crystal, n’Vision, Application Engine, Component Interface, Integration Broker, Application Server, Web Servers, LDAP, MVS, DB2, COBOL, SPUFI, JCL

The project was to implement the Self-Service modules for Lowe’s. Lowe’s has around 250,000 active employees. To develop and implement the Self-Service modules has been a pretty challenging task.

Responsibilities:

• To discuss with Business users and develop the Business Requirement Document.
• To develop the detailed technical specification document for eProfile, ePay, eBenefits and Manager Self-Service.
• To customize and develop the application to suit to the needs of Lowe’s. Literally changed the entire delivered system. A lot of customizations were done.
• Unit test all developed objects.
• System and Integration testing of the entire application.
• To develop staging option so that the database is not directly updated with user updates during the batch window.
• Developed an app engine to populate the data back from the staging tables to the delivered tables once the nightly batch cycle was over.
• Created new functionality within eProfile. Created new prompt tables so that only certifications can be checked against the table before getting populated. Only approved certifications were allowed to be entered.
• One of the customizations in ePay was to print pay checks from the view Pay check page. Used xml to create the required customization and have the pay-check printed in the required format so that it fits on one page.
• To load test the application to see if it fits in use for the 3,00,000 Lowe’s employee base.
• Completely customized all the 4 eApps modules.

Project Name: Peoplesoft HR 8.3 - 8.9 Upgrade, Peoplesoft Financials 8.4
Confidential,Baton Rouge LA, US
Role: Technical Lead
Duration: Jul’05 – Sep’06
Environment: Peoplesoft Financials, Peoplesoft HR, Peoplesoft Time and Labor, Peopletools, Peoplecode, Change Assistant, Peoplesoft Security, SQR, Crystal, n’Vision, Application Engine, Component Interface, Integration Broker, Application Server, Web Servers, LDAP, MVS, DB2, Oracle 9i, Unix, PL/SQL, COBOL, SPUFI, JCL

These were several projects running in parallel. The first is the HR Upgrade( 8.3 – 8.9MP1), the second was the Financials Bundles project where we applied 88 bundles to the old release 8.4. It required immense technical skills to resolve all the defects and put in all customizations. Implemented the Web Clock functionality to log time for hourly employees. Extensive knowledge of T&L was required for the same. Extensively worked with Time and Labor rules and TL_TIMEADMIN app engine. Helped Blue Cross to wade through all the T&L issues and go-live on June 19th’ 06.

Was also involved in a study of whether to do re-implementation or just an upgrade from 8.4 – 8.8, the primary purpose being the client had completely customized their current version. I presented a report based on which we took the route to Upgrade.

Was also involved as the main Technical analyst in analyzing the option of changing over the platform from DB2 to Oracle or UDB and whether it should be done before the Upgrade or after. It was decided to do the re-platform after the upgrade was done.

Responsibilities:

• Playing a role in defining the charter, the scope of the projects, defining the roles and responsibilities, the communications and risk management plans.
• Checking to see what all bundles will make BCBS current.
• Running the scripts needed through Change Assistant to upgrade the Peopletools in Peoplesoft Financials to 8.46.08.
• Applying all the 88 bundles required for the Financials 8.4 applications. Modules included were GL, AP, PO, AM, IN, EX, CM, ePRO.
• Assisting in running the year-end Close process.
• Helping the functional team in performing the Fit-Gap analysis by running compare reports.
• Running the Upgrade scripts in Change Assistant to upgrade the HRMS application from 8.3 SP1 to 8.9 MP1. The applications upgraded were ESS, MSS, Benefits Administration, Payroll for North America, Human Resourses core, Time & Labor, eBenefits, eCompensation and eDevelopment.
• Laying out a strategy to implement 3 more modules Absence Management, ePerformance and eRecruit.
• Worked extensively on the GL Interface. Configured the activity groups to create valid Combinations on the HR side.
• Applied the tax bundles till 06-A in the Demo database.
• Performing both Initial Move as well as Test Moves.(the technical portion of running scripts)
• Upgrade of all SQR’s.
• Had a lot of problems with the Time and Labor module in 8.9 initially, especially with TimeAdmin. Worked on all these issues and resolved the same. Around half of Blue Cross’s staff is on Hourly payroll so had to make sure the punches were logged fine.
• Configured the Web Clock functionality so that Hourly employees can log their time using the application instead of the currently used Kronos system.
• Applied 6 bundles on HR 8.9 MP1 to fix some of the issues with Time and Labor.
• Ensuring that the Integration Broker is working well and that there is proper connection between HR and Financials.
• Worked on the AP extract process and PAYGL01 extensively.
• Upgrade of all Crystal and nVision reports.
• Upgrade of all public queries.
• Reapplying all PeopleCode, SQR, Application Engine customizations to the new delivered Peoplesoft 8.9 application.
• Communication with Peoplesoft regarding any defects found and applying the patches as and when provided.
• Configure the Peoplesoft HR in the new environment.
• Assisting to configure Peoplesoft security within the new upgraded 8.9 Peoplesoft system.
• Work to fix all the defects logged by the users in Mercury’s Test Director.
• Managing the project schedule to see that the project is running on time and is meeting the interim deadlines.
• Developed the Go-Live strategy and Time Table.

Education

Bachelor of Engineering in Electrical and Electronics