SUMMARY

• Six plus years’ experience in Information Technology that included gathering requirements, analysis, design, development, and implementation of business applications systems in People soft and languages like C, C++ and databases like Oracle and SQL Server.
• Progressive Technical experience in customization, implementation, development, deployment, integration, data conversion, training, reporting and support of People soft 9.1/9.0/8.9/8.8/8.4/8.0/7.5 Financials (General Ledger, Accounts Payables, Accounts Receivables, Billing, Asset Management, Grants) SCM (Inventory, Manufacturing, Order Management, Purchasing, eProcurement, Cost Management,) ESA (Projects, Contracts, Expenses and Treasury) on both Windows and NT platforms.
• Strong PeopleSoft technical skills include People Tools (Application Designer, People Code, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, Workflow, Query, Data Mover, Security Administrator, and Definition Security), SQR, nVision and Crystal Reports.
• Uploading data from flat files to PeopleSoft tables using Application Engine/ Component Interface/ File layout combinations and SQR programs.
• Proficient in preparing complex reports usingSQR 6.14/4.X/3.X, PS Query
• Experience in using Integration Tools like Component Interfaces and Application messaging for interacting with in and outside People Soft applications.
• Created test cases and test scripts for testing applications.
• Experience in designing databases and client - server architectures and expertise in PL/SQL and SQL*Plus.
• Excellent troubleshooting and problem-solving skills.
• Exceptional verbal & written communications skills and Presentation skills
• Team worker with excellent inter-personal communication skills, high degree of drive and initiative, ability to work with a variety of teams and individuals at various levels in IT and user departments.

TECHNICAL SKILLS

Operating Systems: Windows NTwUNIX

Databases: Oracle 9i/8/7.xwMS SQL ServerwDB2

Applications: General Ledgerw Accounts Payablew Accounts Receivable Order Managementw Billingw Inventory EProcurement w Purchasing w Project Costing Asset Management w Treasury w Travel& Expenses Cash Managementw Deal Managementw Risk Management

Programming Languages: C C++ Perl

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior PeopleSoft Consultant

Responsibilities:

• Worked as part of the Bug Fix and Performance Enhancement team to resolve issues for Treasury (Cash Management, Deal management, Risk Management) module go live.
• Modified the ACH transactions XMLP report to exclude the ignored transactions.
• Developed several reports for Warrants, including monthly and daily reports using XML publisher.
• Designed and created new XML publisher report templates in RTF for various reports, including Warrant status and Depositories Account Balance.
• Created indexes to increase the fund post balancing page performance. It initially used to take 5 minutes for the page to load after creating indexes it dropped to few seconds.
• Created custom for Investment Pools within Cash Management.
• Modified Application package people code to reject test transactions from NIC. This discards the whole transaction if the customer field contains test characters from NIC.
• Created audit record to store the changed market price for the TX COLL HDR record so that they can change the market price back to the old one when the table gets loaded with zero market price for particular security id.
• Extensively wrote Data Fix scripts to fix production data as per the requirements
• Changed component people code to make the monthly investment pools page load successfully which was not functional due to people code errors.
• Outstanding warrants page was giving error while opening because one of the records was not built. So built the record so that the page loads without errors.
• Made configuration changes to W14 file type which is an outbound file.
• Modified the Message Subscription People Code on the messages to generate error messages and send them back to users if errors were encountered in the ComponentInterface.
• Developed Financials applications, including cash management, deal management and risk management modules.
• Maintained Security and created new Roles and Permissionlists, to grant PeopleSoft single sign on access, amount approvals, run various processes to the end users.
• Worked extensively in both People soft and third party databases in integrating and customizing views and tables.
• Wrote Custom SQL scripts on different databases and migrated them likewise.
• Identified migration issues to UA environment and resolved them which were documented and re-migrated.
• Involved in moving objects from one environment to the other and also helped in supporting Production environment.
• Created queries as per user’s requirement using query manager.

Environment: PeopleSoftFSCM9.0(Treasury(CashManagement,DealManagement,RiskManagement)) People Tools 8.49 (App Designer, Application Engine, Component Interface, PS Query, Tree Manager, IB) People Code, SQR, Crystal Reports, XML Publisher, Oracle, UNIX.

Confidential, San Antonio, TX

People Soft Technical Consultant

Responsibilities:

• Involved in the tuning of various AP &GL related PS queries.
• 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.
• Customized the delivered (Pay cycle) Payment selection and creation process.
• Developed Batch processes using SQR’s and App Engine Programs.
• Data Mapping and Conversion of Asset Management, Project Costing, General Ledger, Procurement, and Accounts Payable via Component Interface.
• Involved in writing functional document to load vendor details using Flat files and AE process
• Worked with Accounts Payable, General Ledger, Cash Management on various Customizations, which involves Positive Pay, Vendor Interface, Automation of journal Entries, Service Fee Automation, Cash Reserve Priority
• Implemented GL Year end closing process GLPPCLOSECOBOL-SQL Process.
• Customized delivered GL SQR's (GLS 7010, GLS 7002, GLS7014) to run the reports for 'ALL' Business Units
• Worked with Accounts Payable, General Ledger, Cash Management on various Customizations, which involves Positive Pay, Vendor Interface, Automation of journal Entries, Service Fee Automation, Cash Reserve Priority
• Involved in Development of GL Interface sqr, which reads flat file containing journals and loads into ps jrnl header, ps jrnl line and custom table ro jrnl trailer. The file is opened for reading with open command when header row is loaded it checks for header edit rules and valid header data is inserted into jrnl header.If line data is loaded.
• Worked with users helping run nVision reports/ Crystal Reports and giving security permission and solving day-to-day PeopleSoft problems.
• Designed and developed custom AP to GL interface, AP to PC interface and customized PC to GL interface.
• Created custom Application Package that triggered a series of custom accounting defaults to populateChart fields for Project Costing, Requisitions, Procurement, eProcurement, Accounts Payable, and General Ledger.
• Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL
• Responsible for developing templates for requisition goods and services in purchasing, Journal entries in GL, customer details in AR applications.
• Communicating with Finance business users in gathering requirements, translate business requirements into technical specification then build and implement those solutions.
• Work with functional users to document specifications for programs and reports and obtain sign off on specifications before commencing with programming.
• Improved the Performance and carried out modifications to numerous PS queries.
• Analyzing and Debugging not working functions/business process.
• Involved in customizing the PeopleSoft delivered reports according to user requirement

Environment: PeopleSoft Financials 9.0(AP,AR,PO,CM,GL,AM,E-PRO), PeopleTools8.48, Workflow, People Code, Application Engine, PS Security, Process Scheduler, Component Interface,Tax ware Enterprise version 4.3, Application Messaging, File layout, SQR, Crystal Reports, n-Vision, JCL, COBOL Windows XP, DB-2 8.0.

Confidential, Atlanta, GA

People soft Technical Consultant

Responsibilities:

• Established business units, Distribution Codes, journal sources and accounting entry templates.
• Developed configuration documents and migration documents for all the moduleslike Account payables, General ledger and Account Receivable
• Maintained good documentation standards for all the development done in accordance with Business Requirements.
• Setup AP Matching & tolerances.
• Setup AP withholdings for BU specific requirements.
• Setup & configure Accounts Payable for BU specific requirements for depreciation.
• Setup SETID, Chatfield, Allocations, Business Units, Locations, Trees etc.
• Participated in creating Component Interfaces from the existing components
• Involved in creating CI Based Services and Operation
• Developed a custom journal upload program that load Journals for all the Business Units with cash offsetsfrom a flat file.
• Participated in calling inbound synchronousweb Service with no security and also using PS security
• Involved in consuming and Testing services from the client
• Involved in creating external Web Service and consumed outbound synchronous Web Service.
• Used Integration Broker the system in order processing.
• Created Budget Uploads for Project Costing through Component Interface
• Involved in debugging Integration broker Logs
• Participated in calling external web service with security through SSL
• Involved in updating the existing Web Services
• Participated in Integration BrokerPeople soft Customer Connection cases
• Involved in writing People code to execute web service
• Implemented chart fieldcustomization.
• Specialized in resolving problems associated with eProcurement Approval workflow, Requisitioning, and Sourcing POs
• Developed Commitment Control Reports like Budget status report, Budget transaction details, Trial balance of appropriation and Negative balance report.
• Developed Test Plans, Test Scripts and Test Cases for Inv, PO, ePro, CM and Billing.
• Customized EProcurement page (PV REQ FORM) so that the Requisition is saved before the user jumps to a different server and also developed Eprocurement pages for users so that they can update their own personal information.
• Wrote complex SQL Queries using joins, unions and nested sub-queries. Created index on Queries for improving the performance.
• Used STAT (Version control) for Migrating the Projects, Production changes, Enhancements, Production Fixes.

Environment: PeopleSoft Financials 8.9(AP,AR,PO,CM,GL,AM,E-PRO), People Tools8.48, Workflow, People Code, Application Engine, PS Security, Process Scheduler, Component Interface, Application Messaging, File layout, SQR, Crystal Reports, STAT, XML, HTTP, SOAP, WSDL, Web Services, CI, IB, Windows XP, Oracle 9i.

Confidential, New York

People Soft Technical consultant

Responsibilities:

• Developed/ modified Record definitions, Pages, Components, People Code, Custom SQR’s, Inbound and Outbound interfaces based on 8.8 upgrade changes in AR, GL, and AM modules
• Investigated the impact analysis on functional changes, gathered upgrade information, existing customizations and prepared technical design specs.
• Created Component Interface for delivered component ORDENT FORM.
• Created Custom Application Engine program to create Order using the new component interface and data from the staging table.
• Involved in creating an XML message in the 8.0 FDM systems with the Order information which is sent through the Web methods middleware to the 8.8 FSCM System for Order Fulfillment.
• For all the Sales Order Returns, a job is used to create the Receipts in the 8.8 system which trigger the Credit Action on the 8.0 system to give the Customer credit. It uses Web methods to post the data into 8.0 FDM system.
• Involved in developingInterface table, Staging table and Mapping tables.
• The 8.0 FDM systems transfers all the Inventory and AP journals from the sub ledger to 8.8 FSCM sub ledger and post them into 8.8 system GL from CM ACCTG LN and VCHR ACCTG LN using an SQR process.
• Bug Fixing in AP while Printing checks (run control problem)
• Involved in writing an Component Interface process which will move all the 8.0 FDM products to 8.8 FSCM process.
• After Depletion process a new custom process SLOMMARK is used to Mark lines for billing This new Application Engine process will extract the marked lines for billing records into a staging table and the new process will pull all the new records from the staging table and writes into a flat file.
• Customized POPO005.SQR, Purchase Order generating SQR program as per Client needs.
• Involved in writing a custom SQR process that reads input file for the Distribution types, Order Groups and the Staging Table for the Distribution Sets.
• Involved in the Performance Tuning of SQR’s and application data tables to suit the client requirements.
• Documented test scenarios and cases.

Environment: PeopleSoft Application 8.0 and 8.8; People Tools 8.42 and 8.46, Oracle 8i and SQL Server 2000, SQR, Security, Application Engine, Application Messaging, People code, Web methods and Workflow.