PROFESSIONAL SUMMARY:

Two ORACLE Peoplesoft Certifications Done

• Over more than 14 years of IT experience with 10 years in PeopleSoft Financials, HRMS, and EPM especially 1 Year in Peoplesoft HRMS V8.9/9.0/9.1 Benefits Administration, Core HR, Payroll Interface, Global Payroll, NA Payroll, and Compensation and 10 years in Peopleosoft Financial v 9.2/9.1/9,0/8.x/7.5 General Ledger 5.5 years, Asset Management, Accounts Payables, Account Receivables, Billing, Project Costing, Expenses, Purchasing, and Contracts .
• Extensive 3.3 Years experience in PeopleSoft EPM v 9.0/8.x Global Consolidation, Activity-Based Management, and Fund Transfer Pricing implementation, customization, and upgradation related technical experience, and also experience in Data warehouse with Informatica Ver 5.2 and 6.2
• Experience in PeopleTools - Application Engine, Application Package, Integration Broker Message version Peopletools 8.40 to 8.53.06 further 8.54 and Service Version PeopleTools 8.48 and above upto 8.54 , XML Publisher, XML Publisher with eText Template and Word Template, Peoplecode, PS/Query, PL/SQL, SQRs, MF COBOL Netexpress and Server Express , Crystal Reports, PS/nVision, Process Scheduler, and Interfaces in PeopleSoft versions 9.2/9.1/9.0/8.x/7.x, Tree Manager, Import Manager, Upgrades, Data Mover, and Utilities.
• Experience in Fusion Middleware Applications Oracle Data Integrator, AIA
• Experience in Spreadsheet Journals Import Using Webservices Using Excel Spreadsheet and Peoplesoft Integration Document Object
• Experience in Module Development, Interfaces, Data Conversions, Data Migrations and Report Writing using SQR , PeopleCode and PeopleTools.
• Involved in Debugging, Troubleshooting and Testing of SQRs and PeopleSoft Applications.
• Experience in STAT migration Tool for migrating object definitions.
• Developed and customized several reports using XML Publishert, XML Publisher with eText Template, SQR, PS/nVision and Crystal Reports.
• Extensively used Application Engine, Process Scheduler, and Component Interface in PeopleSoft Peopletools 8.x/8.xx include 8,53.06 and above upto 8.54 .
• Created WorkFlow rules for approval and control requisition authorizations through workflow-enabled approvals.
• Knowledge of PeopleSoft Portal and PeopleSoft Internet Architecture PIA
• Extensive knowledge and experience in accounting and finance field.
• Experience in Oracle 11g/10g/9.x/8.x/7.x, COBOL, Linux, UNIX, Shell Scripting in UNIX, MS Access, Visual Basic, Visual C , C, C , Visual Foxpro, LISP, PROLOG, JDBC and ODBC, JAVA, JAVA APPLETS, JAVA Scripts, ASP, VBScript, MS FrontPage and Dreamweaver.
• Have excellent communication and analytical skills clear understanding of Accounting and business procedures and ability to work as an individual and also as a part of team.

TECHNICAL SUMMARY:

• Two ORACLE Peoplesoft Certifications Done
• Completed Certificate of Participation in PMP Project Management Professional Course Certificate
• PeopleSoft Modules:
• Peoplesoft HRMS Modules: Benefit Administration, Payroll Interface , Core HR, Global Payroll, NA Payroll, and Compensation , Peoplesoft Financial Modules: GL,AM,AP,AR,Billing and Project Costing and Peoplesoft EPM GC, FTP and ABM .
• PeopleSoft Technologies:
• PeopleCode, Application Engine, Application Package, Application Designer, Query manager, Tree manager, Process Scheduler, Process Monitor, Configuration Manager, Data Mover, PS Data Achieve Manager
• Integration Tools:
• Peoplesoft Integration, Document Object, Business Interlink, Component Interface Using People code and C, C , VB Script, Java Script , Application Messaging, and File Layout Objects
• Fusion Middleware :
• Oracle Data Integrator ODI , AIA

Reporting Tools: XML Publisher, SQR, Crystal reports, PS n/Vision , XML Publisher with eText Template

• Data Warehouse :
• Informatica Ver 5.2 and 6.2 Others:
• ORACLE, UNIX, LINUX, HTML, C, C , VC , VB, Visual Foxpro, VISIO, MF-COBOL, OOP, OOAD, DBASE, FOXPRO, FORTRAN, PASCAL.

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Techno-Functional - Lead

• NTT Communications is in the process of carrying out PeopleSoft Implementation across its affiliates as part of Global ERP GERP project.
• The Global implementation is carried out in several Waves to implement PeopleSoft FSCM Financials and Supply Chain Management modules. Global ERP initiatives, each affiliate will conduct BUSINESS PROCESS REENGINEERING and implement standardized business processes without change.
• Wave-1 to include nine NTT affiliates, divided into three groups and also the implementation of wave1's three groups completed and also gone to go-live.
• Group-1: Korea, Vietnam and Indonesia
• Group-2: Taiwan, Com Asia, Malaysia and Singapore
• Group-3: Emerio and Thailand
• Group1 is implemented with 6 Modules GL,AP,AR,AM, EX and PR/PO Modules for all three affiliates
• Group2 is implemented with 6 modules GL,AP,AR,AM, EX and PR/PO Modules for all three affiliates and additionally implemented BI, CA and PC Modules for only Malaysia and additionally implemented BI for Taiwan
• Group3 is implemented with 6 modules GL,AP,AR,AM, EX and PR/PO Modules for Emerio Singapore and Malaysia.

Roles Responsibilities:

• Analyzes requirements, developed technical design specifications, and Performed impact analysis
• Worked Product effort estimates reviews
• Software Development, Unit Testing and Integration/System Testing
• Application Support
• Created production release notes and scripts
• Created documentation and manuals as necessary.
• DCT preparation and handling
• WBS maintaining for each activity in Development, Test and Go-Live
• NAQ for analysis the functionality and requirements
• Guiding and Maintaining the development tracking on each tasks new add-ons and supports
• Preparation of Scenario Scripts and Datasheets for conducting all sources of SIT, and UAT on all modules
• Preparation for User Manual, Walk-Thruogh session for understand to the users

Environment: PeopleSoft FSCM 9.1 GL, AR, AP, EX and PR/PO, BI, PC and , PeopleTools 8.52 SQR, Application Engine, Component Interface, Peoplecode, Data Mover, PS Query, PS Connected Query, Oracle 11g, XML Publisher with RTF word Template and nVision

Confidential

PRINCIPAL APPLICATIONS ENGINEER

• Support Development : For the Support Development in Peoplesoft GL, According to the SLA, the assigned BUGs are fixed perfectly without any escalations. The Bugs are covered the following areas : Application Engine, Peoplesoft Integration, COBOL, SQR, Peoplecode, Records, Pages, Components, Menus, Integration and etc.
• New Development : Completed three New Development projects.
• 3. Spreadsheet Journal Import Using Webservices : This Journal Import using webservices helps to enter two different journals like Actual and Budget. The Actual journal is maintaining as worked before and adopted the same in Peoplesoft Integration Webservices. The Budget Journal is also able to enter with user option to switch over from Actual to Budget or Budget to Actual and also enter different types of Budget Category.
• Salient Features :
• Created a document object based request-response webservice to accept request of an upload to journals, there will be an attribute in the request to identify the target table so that the same service can able to handle upload to different
• target journal tables.
• Used Excel VB and created the request message and submit to integration broker to make the journal upload request
• Enabled user authentication using tokens such as PS user tokens or SAML tokens
• Created a document object based request-response webservice to accept request of list of values of chartfields, there will be attributes of a business unit and chartfield name, and as of date journal date in the request to identify the chartfield values that are available for that business unit and as of date. The response will provide the list of values. The returned list will honor the setid security and chartfield security granted that user similar to working on journal entry page.
• Used Excel VB and created funcations that able to create the request message and submit to integration broker to make chartfield values list request, and retain the values during the session. The functions are generic to handle anyone of the chartfields
• Created UI controls on the Journal import spreadsheet to allow user to invoke the functions and validated the chartfield values including manually entered without prompts.
• Created UI controls on the Journal import spreadsheet to allow user to invoke the functions and obtained the chartfield values, either serving as a prompted list for user to select values of a chartfield for a particular journal line.
• Modified batch spreadsheet journal upload to handle the new xml message format, as well as able to upload to different target journal table according to the reqest message attribute
• Environment used : Peoplesoft GL 9.2, PeopleTools 8.52/8.53/8.54 SOAPDoc, Document Object, Sefvice, Service Operations, Handlers, Messages, Routing, and Node.
• 2. Fusion Accounting Hub : This is covered features for integrating the PeopleSoft Enterprise General Ledger with the Fusion General Ledger. The purpose of this integration is to facilitate sales of the Fusion Accounting Hub to current PeopleSoft GL customers via the co-existence strategy. Customers can continue to use their PeopleSoft General Ledger and simultaneously take advantage of the Fusion GL features.
• The integration addresses the following requirements:
• a. Upload chart of accounts values from PeopleSoft to Fusion
• b. Map PeopleSoft Business Units/Ledgers to Fusion Ledgers
• c. Convert chart of accounts values from PeopleSoft to Fusion values
• d. Transfer GL journals from the PeopleSoft GL to the Fusion GL
• e. Allow drilldown from the Fusion GL to the PeopleSoft GL
• Environment used : Peoplesoft GL 9.2/9.1, PeopleTools 8.52/8.53.8.54, Oracle Data Integrator ODI , and Fusion GL Application.
• 1. Financial Accounting Hub : The Process Integration for Financial Accounting Hub to PeopleSoft GL provides centralized accounting services to Oracle customers for non-Oracle transaction systems. Financial Accounting Hub provides a centralized, rule-based accounting engine that performs accounting for events that are created by the non-Oracle source transaction systems. As part of Oracle E-Business Suite, Financial Accounting Hub is tightly integrated with Oracle General Ledger and is designed to use the accounting structures defined in E-Business Suite to post the subledger accounting entries.
• The Key benefits of this Process Integration Pack PIP :
• Provides a canonical layer that enables PeopleSoft GL to consume accounting entries from Financial Accounting Hub and simplify integration of legacy systems.
• Enables upgrades and allows the integration to remain synchronized with new releases of the edge applications.
• Reduces total cost of ownership for all parties.
• Integration Points :
• The Financial Accounting Hub to PeopleSoft GL integration uses integration points to publish and subscribe data and web services to expose services and service operations for applications that do not share the same financial database.
• The Process Integration for Financial Accounting Hub to PeopleSoft GL delivers these integration points:
• Synchronization and validation of reference data from PeopleSoft to Financial Accounting Hub, such as currency exchange rates, chart of account values, ChartField combinations, and accounting period statuses.
• Accounting entry integration point :
• Populate the accounting entry table in PeopleSoft GL with subledger accounting entries from Financial Accounting Hub.
• Financial Accounting Hub Reversal from PeopleSoft Journal Delete :
• Correct accounting entry transactions that enter PeopleSoft GL with erroneous information.
• Drill back to source Financial Accounting Hub entries :
• Drill back from PeopleSoft GL journal entries to subledger journals in Financials Accounting Hub.
• Environment used : Peoplesoft GL 9.2/9.1, PeopleTools 8.51/8.52/8.53/8.54, Integration Broker, AIA for PIP, Peoplesoft Enterprise Components, and oracle E-Biz.

Confidential

CONSULTANT

PetSmart has approximately 1100 retail stores in both the United States and Canada supported by the main Store Support Group headquarters in Phoenix, AZ and a Canada Support Group located in Toronto, Canada. In addition there are Distribution Centers located throughout the United States. PeopleSoft is an ERP application for human resource management. In PETsMART, Peoplesoft HRMS application is implemented for automating HR Processes, Compensation processes and Benefit administration.

Roles Responsibilities:

• Analyzes requirements, developed technical design specifications, and Performed impact analysis
• Worked Product effort estimates reviews
• Software Development, Unit Testing and Integration/System Testing
• Application Support
• Created production release notes and scripts
• Created documentatioin and manuals as necessary
• Major involvement in the reapplying of SQRs.
• Developed and recustomized the existing components, Application Engine, Application Packaging, SQR, Peoplecode programs to meet the client requirement.
• Developed Functional and Technical Spec for the HR, Payroll and Benefits Reports.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Prepared to load the dependent detail from Benefits Administration vendor BUCK.
• Prepared to generate the UHC Interface file
• Prepred to Communicate eligibility changes to CVS/Caremark.
• Prepared ESPP Eligible-Ineligible Interface
• Prepared Hartford STD Data Pull
• Prepared UHC PetSmart FSA Outbound Interface
• Prepared Succession Planning 2009
• Prepared MetLaw Eligibility Deduction Interface
• Prepared Hewitt Dependent Audit - Outbound
• Prepared Hewitt Dependent Audit - Inbound
• Prepared Annual Salary/Merit Upload
• Prepared Hours and Earnings Report US only
• Prepared Earns and Works History File
• Prepared Peoplesoft to ADP Payroll Upload File
• Software Used: Peoplesoft HRMS V8.8 benefits, Core HR and Compensation , PeopleTools 8.44, SQR, Crystal and nVision

Confidential

We are is providing Peoplesoft Application Development and Support Services for Manpower's Global Solution Delivery-Operational Effectiveness team GSD-OE . The Supporting tasks are defined as : Peoplesoft Enterprise Finanancial Management Solutions - including General Ladger, Accounts Payable, Accounts Receivables, Asset Management, Billing and Employee Expenses. Peoplesoft Enterprise Service Procurement and Peoplesoft Enterprise Procurement. I involved the activities such 1.Software Coding as well as unit, integration and regression testing, 2. Creating Software documentaion, 3. Creating Test Plans, Test Cases and Test Scripts, 4. Supporting quality assurance activities, system testing and user acceptance testing, 5. Providing Development Support and Providing production Support.

Roles Responsibilities:

• Analyzes requirements, developed technical design specifications, and Performed impact analysis
• Worked Product effort estimates reviews
• Software Development, Unit Testing and Integration/System Testing
• Application Support
• Created production release notes and scripts
• Created documentatioin and manuals as necessary.
• Software Used: Peoplesoft Financial GL, AM, AP, AR, Billing and ePRO , PeopleTools 8.48, SQR and Crystal.

Confidential

PeopleSoft Manager

Responsibilities:

• QUINTILES - Peoplesoft Financial Upgrade
• Resposible to functional and technical involvement on Project PARIS Project especially in Technical Desiging on Application Engine, Crystal Reports, SQR Reports, and nVision, and Process Schdular optimization.
• Project PARIS, the upgrade of project accounting and reporting - New Project Accounting system - PeopleSoft Financials 8.9 Project Costing, Contracts and Billing modules , which is being used by the Product Development, Innovex Medical Communications and Quintiles Consulting Europe groups covering nearly 3500 active projects globally. We have implemented, customized and delevered in time for betterment of achieving the goals of QUINTILES.

Environment: PeopleSoft Financial 8.x Project Costing, Contracts and Billing modules , PeopleTools 8.xx/8.x SQR, Application Engine, Component Interface, Peoplecode, Data Mover, PS Query, PS Archive Manager, Oracle 10g/9.x, Unix.

Confidential

PeopleSoft Consultant

Responsibilities:

• Involved in upgrading PeopleSoft EPM V 8.4 to 8.8 to 8.9 to 9.0 while also supporting V 8.4
• Major responsibility was to perform total analysis of all custom SQRs, PeopleCode, Panels, Menus, and Records for compatibility in the new PeopleSoft release.
• Was involved in Fit-Gap analysis.
• Modified SQRs, that have been customized by the Board, to retrofit the structural changes in version 8.8 / 8.9 / 9.0 and tested the same using Process Scheduler and SQRW.
• Modified Crystal Reports and Nvision Reports, that have been customized by the Board, to retrofit the structural changes in version 8.8 / 8.9 / 9.0 and tested the same using Process Scheduler.
• Modified PSQUERY using in ORACLE 10g that have been customized by the Board, to retrofit the structural changes in version 8.8 / 8.9 / 9.0 and tested the same
• FRS Inbound Rearchitecture and Basel II Implementation :
• developed and modified SQR reports and Crystal Reports for the requirements of Basel-II FRS
• Technically developed and implemented Edit Quality Check, Function Definition, and etc for the requirements of Basel-II FRS
• Defined the Process Scheduler for basic requirements of the SQR reports and Crystal reports for the requirements of Basel-II FRS
• Maintained and implemented the Report Homes and Report Metadata.
• Introduction of new amount field and treatment for RWA balance amount field
• Modification of Edit and Quality checks
• Prior quarter checks for monthly BDLs
• Effective Date Status Check Metadata
• Developed Tree Flattener depending on Account, Account Attributes, Business Unit, Fiscal year and Accounting Period.
• Developed different types Standard and Daemon Types of Application Engine Programs depending on the requirements.
• Developed Metadata Migration tool using Component Interface exposing through Application Engine Programs.
• Developed and Maintained the Tree Manager for Winter Tree, Spring Tree and Summer Tree.
• Modified and Developed Combined Queries, Public Queries and Private Queries.
• Adapted Peoplesoft Securities on Roles assigned to User Profiles and Permission List using Securities Viewer.
• Adapted to setup EPM Foundation Data for business process.

Environment: PeopleSoft EPM 8.x/9.0 Global Consolidation, Activity-Based Management and Fund Transfer Pricing , PeopleTools 8.xx/8.x SQR, Application Engine, Component Interface, Peoplecode, Data Mover, PS Query, PS Archive Manager, Oracle 10g/9.x, Unix., XML Publisher with RTF word Template and eText Template.

Confidential

PeopleSoft Consultant

Responsibilities:

• Solved Cases in CapGemini as :
• Higher Priority 4, Medium Priority 7 and Low Priority 5
• Some of Higher Priority Problems :
  • GL Intermittent Problem with Upload Journals Journal Posting Excel Sheet Template with VBA Script, IBM MQ SERIES, Windows Shell Script
  • Inter/Intra Unit Problem Journal Posting and GL Journal Entry Template Validation issue for New Business Units Excel Sheet Template with VBA Script, IBM MQ SERIES, Windows Shell Script
  • SET OVERRIDE ID problem in SQR and 5 COBOL. PROGRAMS
• Got hands-on training on DATAWAREHOUSE with INFORMATICA Ver 5.2 and 6.2 in CAPGemini Itself
• Got further training on Peoplesoft ABM, and FTP CAPGemini Itself.
• Got further training on Peoplesoft GL, AM, and AR in CAPGemini Itself.
• Involved in upgrading PeopleSoft Financials V 8.0 to 8.4 while also supporting V 8.0
• Major responsibility was to perform total analysis of all custom SQRs, PeopleCode, Panels, Menus, and Records for compatibility in the new PeopleSoft release.
• Was involved in Fit-Gap analysis.
• Modified SQRs that have been customized by the Board, to retrofit the structural changes in version 8.4 and tested the same using Process Scheduler and SQRW.
• Handled Issues related to express checks and system checks in AP. Functional requirement analysis , technical design , presentations, development, unit testing , integration testing, user acceptance testing UAT , and sign-off for customization/development of complex SQRs for a Inbound/outbound Interfaces: Customers, Brokers, Polices, Lock box, Cash application, Corp Document extracts and Harbor Payment application. b Business processes: Billing Calculator, Commission calculator, Policy Cancellation processes. Legal transfer Processes, and Dunning Reports etc c Management reconciliation reports: GL0100, and GL0200 SQR Reports for Internal controls as per Sarbanes Oxley requirements
• Analysis, design and documentation for various customizations of Financial modules related to Insurance company business processes
• Worked on AP like PAY CYCLES BPR, PAY CYCLES Modification per OSC and Treasury Requirements entire Voucher life cycle, Payment cycle manager and reports like Manifest certification report, Payment schedule report, Audit ProForma, Invoice printing.
• Identified performance issues during the testing phase and fixed them for better performance
• Data Conversion of Assets and Proj Resource data using SQRs.
• Created Interfaces to send data from receiving tables to Asset Management
• Conversion of Assets from the legacy system to the PeopleSoft system using Component Interfaces
• Development of customized Crystal reports in Purchasing and AP.
• Developed multiple and complex SQR reports including file updates, flat files and writing interface reports Designed and developed a SQR Program to populate all fields, which are not provided by bank so that bank reconciliation can process that bank statement. Troubleshooting, co-ordinate and resolving day-to-day user issues, Scheduling and monitoring of Peoplesoft processes Invoice creation, Currency conversion, Load AR, Load GL, ARUPDATE, Payment Predictor, Aging Process/Reports etc Involved in the complete implementation Process of PeopleSoft Financials from analysis, design, data modeling, data transfers, customization, integration, Unit testing, parallel testing and user training. Created custom SQR to load employee flat file into PeopleSoft expenses table from a flat file. Modified the Mass Upload in the Asset Management functionality as per Business requirements. Resolved issues in Asset Management module during Production Support phase. Conversion of Legacy data into PeopleSoft, including Data Mapping and reports to validate the converted data
• Resolved issues in AM module related to the Retiring Assets
• Converted data in the History tables using the PS Data Archive Manager.
• Using PS Archive Manager archived the data in JRNL HEADER table and other tables of AR and AP modules.
• Involved in Production Support the AM while also assisting the development team.
• Provided technical and user support for any problems encountered during day-to-day operations
• Interacted with users to understand the business requirements and developing technical specifications for various tasks involving modifications, customizing delivered reports and other PS applications and creating Technical documentations.
• Created Crystal Checks from scratch and plugged them in the Pay Cycle process.
• Created custom Crystal reports from scratch as per Clients specific requirements: Voucher Register Report, Payment Register Report, Voucher Payment Exception Report, and ACH Direct Credit Report.
• Customized the Asset Pages as per Clients requirements
• Created custom SQRs in the AP and GL module
• Involved in the customizations of the Voucher Workflow process in the AP module.
• Major responsibility includes taking care of tickets assigned, in order of priority, and document in detail all the user problems and the solutions provided.
• Customized Record definitions, Pages, Components, Menus and Process Definitions for running SQRs online through Process Scheduler.
• Customized the delivered SQR reports in AM module.
• Customized the Asset Allocation App Engine in Asset Management module.
• Involved in debugging and performance tuning SQL.
• Resolved issues in the AP module during the Production support phase of the project.
• Extensively used application designer to create new views, tables, pages and components, later compared and migrated to production database.
• Used PS Archive Manager wrote specific query to archive the GL data.
• Customer the Voucher Entry Components as per the Business requirements in AP module.
• Created year end reports in SQR and Crystal Reports.
• Customized SQR also created new SQRs from scratch.

Coordinate with Development team, system testing , Integration testing and UAT sign off

Environment: PeopleSoft 8.4/8.0 General Ledger, Asset Management, Accounts Payables, Accounts Receivables, Billing , PeopleTools, SQR, Application Engine, Component Interface, SQL, SQR, Crystal Reports, nVision,, Data Mover, PS Query, PS Archive Manager, Oracle, Unix, COBOL.

Confidential

Team Lead - Enterprise Solutions

Responsibilities:

• Customized several pages/components like Billing, Journal Entry, Voucher Entry, Maintaining Vendors, Buying agreements and Requisition items using Application designer.
• Designed and Developed SQR programs for importing data from legacy system to PeopleSoft.
• Interacted with other PeopleSoft Financials Modules while generating the Purchase Order and sending same PO to the vendor.
• Involved in Fit-Gap analysis and developed functional/technical specifications for various processes.
• Involved in setting up the billing cycle, invoice formatting options and invoices layout ID.
• Created/Customized Security to give access to Asset Management module users.
• Established General Ledger BU, ledger, calendar, journal sources, and accounting entry templates to transfer journals from AM, AR, AP, PO, Expenses to GL. Transferred accounts payable voucher information into Asset Management using the Pay-Purchase Interface.
• Developed interface that will be used to generate the flat file with details of all checks for payment and cancellation, which is used for the Bank Reconciliation by the Client.
• Extensively used Application Designer to Create or modify tables, views, Pages and components as per the client requirements.
• Used People Code for the implementation of the new business rules.
• Generated SQR Reports for creating Slow Moving Inventory Report, Shipping Container Labels and Transaction Register Report.
• Customized Pages and Capital reports for Budget/Forecast variance by Region, Forecast by Building/Phase/Market, and Pursuit Options by Building/Land/CDF Lease reports.
• Developed SQR Programs for Vendor Conversion, Ledger Actual Budget Conversion and Journal.

• Used/Developed data conversion programs/scripts using SQL, SQR and data mover utilities to migrate data from Legacy system data to PeopleSoft application tables.

• Provided immediate technical and user support for Marriott international General Ledger, Marriott AP module, International Franchise billing Mosaic. Focused on reducing production abends and Monitor Maestro scheduler software that runs on UNIX .
• Modified / customized complex SQRs.
• Customized the Asset Allocation App Engine in Asset Management module.
• Wrote custom SQR to load Assets in to the Asset Management module.
• Created Queries in AM module as per Business requirements.
• Created Crystal Checks which are generated through Pay Cycle Process in AP module.
• Modified Records PS PERSONAL DATA, PS Ledger to prevent job abends.
• Created data mover scripts to move trees from one environment to another.
• Schedule jobs or modify job schedules in Tivoli Job scheduling console .
• Create/Modify PROSE for jobs and schedules in Mainframes.
• Created technical Documents, Change Track documentation, Migration Request forms, Job-Schedule Documentation.

Environment: PeopleSoft 8.0/8.12/8.4 General Ledger, Asset Management, Accounts Payables , PeopleTools, SQR, Application Engine, Component Interface, SQL, SQR, Crystal Reports, nVision,, Data Mover, PS Query, PS Archive Manager, Oracle, Unix, COBOL.

Responsibilities:

• Involved in the implementation of PeopleSoft Financials AP, AR and GL modules
• Worked with end users in collecting the design requirements for these modules during the fit-gap analysis
• Created design and system testing templates that would be used by developers during these phases
• Created many design documents related to the modifications identified by the end users
• Created new SQR and Crystal reports to fulfill the reporting requirements
• Created jobs and scheduled recurring process through Process Scheduler.
• Used Application Engine to populate PeopleSoft tables.
• Extended technical support to other developers on team and was also involved in setting the development standards that can be used by other developers
• Responsible for maintaining security in different environments during the development phase.
• Created Permissions and roles and assigned to users.
• Identified some of the performance issues during the testing phase and fixed them for better performance.

• Developed and customized on-line Pages and Menus using PeopleTools like Page Designer, Menu Designer in the Application Designer.
• Wrote detailed nVision reports and financial statements. Redesigned client chart of accounts.
• Provided post-implementation production support as needed by client.
• Trained both consulting staff and end-users. Developed training materials for end-users. Populated PeopleSoft Payables tables with data from the legacy systems.
• Involved in the Design and development of interface programs necessary to move data from the legacy system into PeopleSoft tables using SQR as the primary tool.

• Used PeopleSoft tools like Data Mover and Import Manager for migrating data from legacy system to PeopleSoft system.

Environment: PeopleSoft 8.12/8.0/7.5 Finance, People Tools, People Code, SQL, SQR, Crystal Reports, nVision, Windows NT, SQL Server.

Confidential

EDP Manager

Responsibilities:

• Multiple Business Financial Accounting Package
• Double-Entry System
• Environment - Visual Basic SQL Server
• Features of the Package : Receipt, Payment, Bank Transaction, Journal, Sales, Sales Return, Purchase Return, and Purchase. It consists of definable Ledger Accounts having Asset Management, Liability Management, Income Management, Expense Management, Sales Accounts maintained with Customer's Accounts, and Purchase Accounts with Party's Accounts.
• Generates Inventory Stock up to date, Bank Book, Cash Book, Daybook, Ledger, Trail Balance, manufacturing A/c, Trading A/c, Profit and Loss A/c and Balance sheet.
• Integrated with Manufacturing Unit.
• Role : Development and Maintenance
• CP Module : Costing For Production
• Client-Server Technology
• Environment : Visual Basic 6.0 SQL Server 6.5
• Features : Cost of Production, Costing, Budgetary Costing, and Actual Costing.
• Role : Development and Maintenance
• Leasing and Finance Accounting Package:
• Environment : Oracle 6.0 / 7.0/ 8.0, Developer 2000 and Report Writer
• Features of Leasing Modules: Leasing Actions such as Starting New Leasing Group, Enrolling, Members for each Leasing group, Subscription Amount for each Auction, Auction Control, Incentive for Leasing Group Members, Agent Inclusion, Agent Commission, Penalty amount for non-payment subscription on Leasing Members, Each Leasing Profit and Loss A/c up to date, and Over all the Leasing Profit and Loss A/c up to date.
• Features of Finance Modules: Money Lending/ Loan Scheme, Hire Purchase Scheme, Leasing Scheme, Deposit Scheme, Cumulative or Accrued or Reinvestment Scheme, Recurring Deposit Scheme and Property Loan Scheme.

Role : Development and Maintenance.

Environment: COBOL, C, C , VC , VB, VB Script, JDBC and ODBC, Report Writer, ORACLE 8.0/7.0, Developer 2000, Visual Foxpro

Confidential

Programmer Analyst

Responsibilities:

Started my career as Programmer and reached the Position as Director for Software Division. Worked on Duties and responsibilities included design, development and implementation of all in-house systems, modifications, and maintenance of existing systems, I/O control, training User Departments and Executives, overall designing and analyzing the software development with Industrial Domains .

Environment: COBOL, C, C , VC , VB, VB Script, JDBC and ODBC, Report Writer, ORACLE 7.x/6.x/5.x, Developer 2000, Visual Foxpro, UNIX, XENIX, FORTRAN, PASCAL, LISP, PROLOG