SUMMARY

• Over 7 Plus years of experience in the software analysis, design development, New implementation, Upgrade, customization and testing Of ERP, client/server, Data Warehouse and Enterprise Performance Management applications, for various clients in areas of Corporate, Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public sector undertakings, which includes 5 Plus years of PeopleSoft Experience within United States. Extensively worked in implementations of PeopleSoft Financials and EPM applications ranging from versions 8.4 to 9.1
• Expertise in technical role and good functional understanding during implementations, upgrades, interfaces reports development, conversion, migration, production support, operational procedures, scheduling, performance tuning, Application development and database solutions. Analyze and resolve support issues raised by the functional support team, guide and train support teams on new technology and functionality.
• Industrial domains include Transportation, Healthcare, Financial Insurance and Construction.

TECHNICAL SKILLS

Hardware: IBM PC Compatibles

Operating Systems: Windows 95/98/2000/NT, Ms - Dos, UNIX

Languages: SQL, SQR, PL/SQL, C and People Code

RDBMS: Oracle (8, 9, 10, 11) SQL Base, MS SQL Server and Sybase

GUI Tools: Forms 4.5 and Reports 2.5, Visual Basic, Autosys.

ERP Packages: PeopleSoft Financials.

People Tools: Application Designer, Security Administrator, Workflow.

Data Management Tools: Data Mover, Import Manager, Application Engine.

Reporting Tools: Query, Crystal, SQR, nVision, Tree Manager, Process SchedulerComponent Interface, Excel to CI, Application Messaging, Upgrade Tools Upgrade Assistant.

Version Controls: PVCS(Serena Change Man) and Microsoft Visual Source Safe.

PROFESSIONAL EXPERIENCE

Confidential, TX

PeopleSoft Techno Functional Consultant

Responsibilities:

• detailed test plans and technical documentation
• Provided Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR’s & Online.
• Worked on various SQL performance tuning tasks to reduce the execution time
• Customized the delivered pages and Debugged the peoplecode and the SQR reports for the requested requirements for AP & AR Aging reports.
• Customized various online pages according to the user needs
• Customized GL reports and interfaces according to new Integration conversion rules
• Customized Component Interface People Code to add extra functionality and validation
• Worked extensively on Application Designer to modify the existing record definitions, pages, components and menus
• Involved in user enhancement of people soft financials (AP,AR and GL) utilizing people tools and SQR reports
• Designed new pages and the SQR Reports for the new enhancements requested by the users from Tax Department for the BUnits under a Account for the specific period of that Physical year on modules AP, AR, GL modules tables (PS LEDGER, PS JRNL LN, PS JRNL HEADER, PS VCHR ACCTG LINE, PS VOUCHER, PS VENDOR) from AP and GL Tables.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.

Environment: PeopleSoft 8.8, Oracle 10G, Windows XP/NT/UNIX

Confidential, Roanoke VA.

PeopleSoft Techno Functional Consultant

Responsibilities:

• Provided detailed test plans and technical documentation
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Developed Custom Billing Online Components to Review Billing Summary and Custom processed data.
• Developed Enquiry page for Billing Invoices for Custom billing interface run.
• Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
• As a offshore and onshore team coordinator for China, India and USA.
• Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts
• Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR,PO LINE and PO LINE SHIP etc
• Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR’s & Online
• Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, Washington DC

Techno functional Consultant

Responsibilities:

• Develop technical specifications based on the Functional requirement document.
• Created technical specifications and built the online vendor attachments to be added at the vendor level.
• Developed technical specifications and built the process using application engine and People Code for the inbound and outbound interfaces between the PeopleSoft and the Maximo for the Purchasing requisitions and the Purchase Orders.
• Developed the technical specifications for the conversion of the existing projects, project activities, and project budgets, open purchasing documents, budgets, GL balances currently in the PeopleSoft financial database, the creation of grants sponsor/customers, the conversion or creation of grant s, and the establishment of billed balances by customer contract.
• Excellent experience in troubleshooting, debugging and tracing.
• The scope of Projects for conversion includes open, existing projects including CIP, Rail Construction, ARRA, Reimbursable, and Safety & Security.
• Developed technical specifications to provide MTA with the ability to perform a mass update of the Buyer field on the tables storing Items and Item Categories. The delivered functionality allows the Buyer field must be updated individually for each item and item category. If many updates must be made, it could take a significant amount of time to complete the effort.
• Developed excel to CI component interfaces to mass update the buyer data for the items and the Item Categories.
• Developed the custom SQR programs in addition to the delivered component interfaces for converting the existing data into PeopleSoft finance applications.
• Developed pseudo code and unit testing procedures in the technical specifications for the development team.
• Defined the system testing and integration procedures for System testing and User Acceptance testing.
• Created test scripts and test scenarios based on the functional and the technical specifications.
• Developed control reports, error reports and reconciliation reports for the interfaced and converted data.
• Developed Data integrity reports to validate the orphan data in the PeopleSoft tables.

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NJ

Techno functional Consultant

Responsibilities:

• Developed technical specifications based on the Business requirement document (BRD).
• Created user manual for the end users on the QCare to GL interface process for claims and premiums.
• Developed extract programs using sqr to send outbound and inbound GL and AP data from PeopleSoft programs to external systems QCare Claims and Revenue system.
• Performed data mapping of the external systems to PeopleSoft data.
• Developed user based online PeopleSoft mapping rules pages for the interfaces.
• Created custom records, pages, components for holding the mapping rules online.
• Created application engine program to load the mapping rules from the external files from QCare Claims system.
• Developed sqr programs which are executed on the remote applications (QCare) to improve the performance.
• Created partitions to improve the performance.
• Created different types of Oracle Partitions and sub partitions such as Range Partitions, Hash Partitions, and Composite range harsh partitions.
• Developed pages, components and application engine programs to create and maintain the partitions thru online PeopleSoft as part of the production maintenance.
• Fine tuned the long running custom application engine programs.
• Tuned the custom sqr programs to improve the performance adopting the load lookup tables and the array concepts.
• Fine tuned the custom queries to improve the performance.
• Improved the performance of the online application pages.
• Excellent experience in troubleshooting, debugging and tracing.
• Involved in performance tuning of the Application Engine programs.
• Developed error reports and reconciliation reports to track the errors and reconcile the source and target data.
• Supported the end users in providing the queries and assisted in testing of the interface in UAT.
• Coordinated with the DBA in migrating the PeopleSoft projects from development to SIT and UAT and Prod.

Environment: PeopleSoft 9.0, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NY

PeopleSoft Techno Functional Developer

Responsibilities:

• Developed custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications such as Outside Brokers Payroll
• Developed ADP Journals Import Custom process to load the Journals Accounting Entry Data into PeopleSoft General Ledger such as Cash Broker Payroll and Corporate payroll etc.
• Developed Independent Contractor payroll process custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications.
• Developed custom sqr process to capture the currency exchange rates from Bloomberg into PeopleSoft and send the rates from PeopleSoft to Outlooksoft.
• Automated the existing month end interfaces in PeopleSoft for the Operations.
• Developed the interface which runs on a daily batch schedule to load the projects into the PeopleSoft tree.
• Developed custom sqr and application engine programs to convert the historical data into PeopleSoft financial applications.
• Developed control reports, reconciliation reports and data integrity/validation reports for the conversion data.
• Customized the delivered ACH/EFT payments process to fit in the business requirements.
• Customized the delivered Positive Payment creation process (Crystal Check) to generate the file to be sent to the chase bank.
• Worked on the pay cycle process.
• Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables.
• Customized the delivered (Pay cycle) Payment selection and creation process.
• Developed application engine program using PeopleCode to extract the AMEX data from PeopleSoft expense data to generate the file to be sent to the American Express.
• Developed summary, detail and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision.
• Created new layouts, report requests, scope definitions, and used Report books to run the reports.
• Developed Expense Open Liability Report.
• Developed Summary and Detail Payment History report, Positive Payments Report and the Voucher register Reports in Accounts Payable.
• Developed Expense Report Detail Report and Expense reports by Business Unit in Travel and Expense Module.
• Customized the delivered check printing crystal report according to the business requirements.
• Developed multiples reports in General Ledger such as Ledger Verse Journal Integrity report, Custom GL Activity Report for AP/EXP all accounts by Department Id.
• Developed custom Trial balance Report.
• Modified the existing check printing Crystal report
• Worked on resolving the performance issues and fine-tuning of the Query/SQR programs.
• Explained the delivered PeopleSoft reports and their functionality to the end users.
• Provided 24/7 after hours support during the month end closing as and when necessary.
• Provided Level 3 support.
• Migrated PeopleSoft projects, objects, configuration data and various other components of the application into multiple database instances.
• Data Quality issues and day to production issues.
• Performed smoke/unit test to make sure the process and online applications are working per the requirements after the migration.
• Created Test requirements documents based on the functional specifications.
• Developed test cases and test scenarios based on the testing requirement documents.
• Performed negative testing to ensure the functionality as per the user requirements.
• Performed system integration testing and supported the end users in user acceptance testing.
• Tested the Online customizations.
• Documented and tested the PeopleSoft Batch process, inbound and outbound interfaces etc
• Tested the Reports for Data validations and reconciliation reports.
• Performed fit/gap analysis and system configuration.
• Configured the business units, banks, pay cycles for Voucher Payments and vendors etc.
• Changed the fixed assets depreciation calculation from Half Year Convention to Following Month for Straight Line method.
• Documented and designed the technical specifications for interfaces, reports, data conversion and validation.
• Worked with the end users and gathered information for designing the specifications for Vendor/Customer setup, Business Unit setup, EDI file etc.

Environment: PeopleSoft 9, SQL Server, Windows 2000/NT/UNIX

Confidential, VA

PeopleSoft Technical Developer

Responsibilities:

• Developed custom interface using App Engine program to load the data from the external legacy billing system into PeopleSoft Accounts Receivable.
• Used Application Engine to convert the historical data from the legacy system into PeopleSoft AR.
• Customized the delivered ACH/EFT payments process to fit in the business requirements.
• Customized the delivered Positive Payment creation process (Crystal Check) to generate the file to be sent to the chase bank.
• Keeping trace, debug options and researching the trace file to isolate the issue.
• Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables.
• Customized the delivered (Pay cycle) Payment selection and creation process.
• Developed application engine program using PeopleCode to extract the AMEX data from PeopleSoft expense data to generate the file to be sent to the American Express.
• Developed summary, detail and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision.
• Created new layouts, report requests, scope definitions, and used Report books to run the reports.
• Tested the Online customizations.
• Tested the Reports for Data validations and reconciliation reports.
• Involved in performance testing and fine-tuning of the Query/SQR programs.

Environment: PeopleSoft 8.9, Oracle, Windows 2000/NT/Unix

Confidential, NY

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in user enhancement of people soft financials (PO,AP,AR and Billing) utilizing people tools and crystal reports
• Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts
• Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR,PO LINE and PO LINE SHIP etc
• Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, COBOL, SQR’s & Online
• Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports
• Conducted Sessions on developing SQR, People Code and Application Engine, troubleshooting using SQR flags, People Code Debugger and Application Engine Trace
• Customized the Component Interface program to load the data into additional tables
• Worked on PeopleSoft Application Server Architecture and enterprise architecture
• Experience with agile development methodologies
• Provided detailed test plans and technical documentation
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Developed Custom Billing Online Components to Review Billing Summary and Custom processed data.
• Developed Enquiry page for Billing Invoices for Custom billing interface run.
• Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
• Provided Post implementation support as per the user requirements

Environment: PeopleSoft Finance 8.4, People Tools 8.42, PL/SQL, Oracle 8i

Confidential, NY

Peoplesoft Financial Technical Developer

Responsibilities:

• Lead developer in implementation and development of FP Accounting System.
• Responsibilities included design, development, documenting and user requirements gathering for writing the technical specifications for interfaces, conversion and reports including migration.
• Developed application engine programs to extract and interface data from PeopleSoft to be used by other subsystems.
• Developed interface program to generate the profit and loss reports, Balance Sheet reports and trial balance reports for the trading operations for the ASSETS and GICS, SWAP’s and FUTURE’s in tab delimited.
• Worked with functional team during the setup and configuration of the Journal Generator templates.
• Participated in fit/gap analysis and system configuration.
• Tested the Online customizations.
• Documented and tested the PeopleSoft Batch process, inbound and outbound interfaces etc
• Tested the Reports for Data validations and reconciliation reports.
• Involved in performance testing and fine-tuning of the Query/SQR programs.
• Data Quality issues and day to production issues.
• Designed and developed the summary and the detail trees for the reporting.
• Developed custom ledger templates, defined ledger sets, configured the ledgers for A business unit as a part of the ledger and summary ledger setup.
• Developed queries/crystal, nVision report layouts, report requests, report books and scope definitions and also developed cross tabular reports using Crystal where PS nVision could not be used to develop the reports as there are certain limitations to nVision.

Environment: PeopleSoft 8.4, Sybase, Windows 2000/NT/Unix