Objective:

• Obtain a position, in Information Technology, in a challenging and fast pace
• environment where I can apply my best for the future growth of the company as well as enhance my abilities.

Personal Summary:

• I have about 13 years of solid experience in application development and support using Oracle/PeopleSoft 8x/9x technologies
• Solid Technical/Functional knowledge of PeopleSoft Financial Modules like BI, AR, AP, GL, TR etc.
• Work 12 years as PeopleSoft Developer and Primary Security Administrator for PeopleSoft Financial and HR.
• Lead various technical custom development projects following full System Development Life Cycle
• As a Team Lead, I prepared Estimate and Technical Assumption document for upgrade and/or new system.
• Create Business Interlink between PeopleSoft and External system to fetch XML files.
• Create Design document, user manuals and train end user on application.
• Creating and Scheduling jobs using Control M
• Move data between different environments using Data Mover.
• Migrate PeopleSoft Projects, SQRs and Unix scripts from Dev to Test and then from Test to Production
• Migrate PeopleSoft Projects, SQRs and between databases using STAT
• Work as a backup for Unix System Administrator PeopleSoft .
• Stop and/or start Unix servers as needed
• Configure Integration Broker to accept PeopleSoft Component Interface messages and load data into Staging tables.
• Configure to load Vouchers using Excel spreadsheet Component Interface
• Write PL/SQL Store Procedures and run them using SQR processes
• Working Experience in writing programs using: SQR, Application Engine programming, PeopleCode, PL/SQL , C , Visual Basic, VBA, Pick Basic, Java, Java Scripts, ASP, HTML and Unix shell scripts
• Working Experience in configuring and setting up PeopleSoft Financial data i.e., Setting up Business Units, Table Set Controls, Entry Item, Entry Reason Code, Combination Edits, Trees etc.
• Working Experience of writing new as well modifying existing nVision reports
• Advance knowledge of Microsoft Office Suite, Windows 2000, Windows NT, PeopleSoft, People Tools.
• Working Experience 4 years of Oracle Forms, Reports and Database
• Working Experience 12 years of Oracle 6i, 9i, 10g , Sybase, Access database and Other Relational databases.
• Working Experience 8 years of writing Procedures and Functions using PL/SQL and TSQL.
• Working Experience of developing Oracle packages
• Received Most Value able Person MVP Award of 2002 from Chicago Board of Trade
• I am analytical, quick learner, team player and a result oriented person.

Experience:

PeopleSoft Programmer

Confidential

• Design and implement custom dunning system that includes:
• Modification of delivered dunning data extract program so that data can be extracted based upon Business Units and update flags based upon the history of dunning letters
• Write Application Engine program to refresh and upload remit address information based upon Business Units.
• Created a Component Interface to schedule multiple Dunning jobs based upon days late, one after another.
• Create custom pages to configure various constraints and formats which are then use in later processes to create dunning letters accordingly.
• Create 5 different Crystal Report Templates for dunning letters. Add formulas and logic to these templates so that Dunning Letters can be printed in desired custom format and Billing language required by the Business Units.
• Write Queries for each Crystal template to select and print dunning data on Crystal Reports
• Write App Engine program to get dunning extracted data, validates it and using the newly created Component Interface, schedule dunning jobs that initializes crystal templates to create dunning letters in various language. The program save each and every dunning letters in MS Word format at a network drive and save all the required information in a custom build Email Table
• Write App Engine program to select data from custom Email table, Creates a Dunning email for each client, attach respective dunning letters to it and send it out to that client.
• Schedule to run the whole process as a nightly batch job.
• Project was implemented and running successfully since then and helped Receivables significantly to collect past due bills.
• Integrate Concur Invoices with PeopleSoft Account Payables that includes but not limited to:
• Work with Concur team on invoice configuration within Concur.
• Extract and create data file from PeopleSoft and load them in Concur.
• Get Invoice data file from Concur and load into PeopleSoft Voucher Staging tables and create vouchers.
• Get Invoice attachments image files from concur.
• Write program to attach invoice attachment from Concur to respective vouchers in PeopleSoft Account Payables.
• Create custom reports within concur, using Concur Reporting Tools, schedule them to run automatically as well as on demand.
• Actively Participate for PeopleSoft Globalization
• Customize and support Cash/Deal Management globally
• Create Bank Reconciliation reports
• Customize Reconciliation process
• Develop process to create and reconcile Bulk FX Transactions
• Develop new reconciliation rules.
• Configure New Banks, Branches, and Accounts
• Create Accounting Templates
• Configure and Support Deal Management.
• Write custom program to validate and convert bank statements
• Performance Tune up of Semi Reconciliation Process.ea
• Support Deal Management
• Work with users to setup Portfolios, Securities, Deals and Instruments.
• Write user documentations on Cash and Deal Management
• Create interface program between Custom FEE/SOB module and Accounts Payable/Billing
• Create interface between Concur Expense Reporting system and Accounts Payable.
• Write program to create Matadata files from PeopleSoft and load them into Concur Expense Reporting System.
• Extract Expense Reporting data from Concur and
• Load them in PeopleSoft custom tables
• Create Pages to interface that data and correct it as needed.
• Write program to load Concur data into Accounts Payable Voucher staging tables and then load it in PeopleSoft system tables
• Write Application Engine program to send emails to the users, with Payment information, upon expenses are paid.
• Administer Concur Security access.
• Support user on Concur related issues.
• Modify PeopleSoft AP Voucher Build program to calculate correct VAT amounts
• Configure PeopleSoft Component Interface to upload Vouchers using Excel Spreadsheet.
• Modify delivered CI excelsheet load voucher data by adding another sheet to it where user can copy the data in a custom format.
• Write a macro program that validates user provided data, format it and copy it to delivered DATA SHEET within CI.
• Configure Integration Broker to receive, process and load voucher data, from CI, into Voucher Staging tables.
• Configure PeopleSoft Component Interface to upload Journals using Excel Spreadsheet.
• Write Application Engine program to generate and send daily Payment Notification emails to consultants
• Create Component Interface and Application Engine program to schedule processes that generate Dunning Letters based upon Days Late. Write program to automatically sends emails to consultant with respective Dunning Letters attached.
• Write interface programs to receive Account Receivable Cash files, process them and reformat them in 823 and/or 820 format.
• Write programs to load 823 format Cash files into AR staging tables.
• Configure Payment Predictor to process international payments.
• Write new and modify existing complex PL/SQL Store procedures to manipulate data and make it ready for Billing.
• Write complex SQR Reporting program to create Cash Receipts detail and summary reports for executives
• Administer PeopleSoft Security
• Create new user profiles
• Create new role and permission list
• Assign roles to the user as per their duties and responsibilities.
• Administer Concur Expense Reporting tool security
• Assign Roles, Approvers, Delegates to the user.
• Support Concur related issues
• Configure PayCycle for Global Accounts Payable

2. PeopleSoft Technical Consultant

Confidential

System Integration Project:

• Provide technical expertise to integrate CBOT PeopleSoft, Membership Information and TimberLine Property Management System with Chicago Mercantile Exchange.
• Write SQR programs to extract data from CBOT PeopleSoft AR, BI and GL system.
• Write interface programs to load data into CME database
• Create PeopleSoft Pages to run programs.
• Generate Crystal Reports
• Generate data files from TimberLine Property Management System.
• Schedule jobs to run automatically using Control M scheduling system.
• Provide production support
• Run and monitor Daily, Weekly and Month End Jobs.
• Create new as well as modify existing nVision Reports for GL users
• Work with Managers to scheduling final jobs run and then shutting off those jobs.
• Run Monthly as well as Quarterly Trial Balances for users and external auditors
• Re-Open and close Accounting Periods upon user's request with appropriate approvals
• Provide PeopleSoft access to new as well as exiting users by analyzing their responsibilities.
• Work with Auditors to make sure that PeopleSoft Security access is compliant with the SOX controls
• Provide production support to users in running and resolving any issue with query, reports and data.
• Provide production support to users and upper management by running any report for them or resolving any issue with the data.
• Provide documentation and user manual for any new nVision report or query.
• Help I.T. Developer in SQR programming related issues.

3. Senior System Analyst Technical

Confidential

PeopleSoft Financial Employee Portal:

Actively participate in Initial PeopleSoft 8.0 Application, for HR and Finance, implementation. This includes:

• Analyzing PeopleSoft application and database
• Compare and map existing database tables with PeopleSoft database
• Extract data from existing database and create files
• Write interface program to load data into PeopleSoft
• Create custom records, panels, component and menus using PeopleTools
• Use PeopleSoft data load manager and data mover to load data into PeopleSoft
• Test Application
• Create user documentation
• Trained users

Actively participate in PeopleSoft 8.8 For Financial and PeopleSoft 8.9 For HRMS upgrade. This includes:

• Perform Compare reports
• Create and run SQL data export scripts
• Save existing projects in files
• Extract security data for all users and save it in files
• Run upgrade scripts in Unix
• Import data into PeopleSoft
• Run different upgrade cycles and test them along with users.
• Stop and Start servers
• Worked on any issue that come along

Exchange Fee Billing System: Develop a customize Exchange Fee Billing system within PeopleSoft. The system is enable to:

• Receive files and process them in PeopleSoft
• Generate data files for other systems as well as out side vendors
• Interface between multiple systems
• Receives daily client's transaction data files from clearing corporation
• Load and validates data into staging tables
• Price the transactions based upon customer's status
• Provide data to external clients to make changes
• Re-price modified transaction
• Make the data ready for monthly billing.
• Perform month end billing
• Generate invoices

Floor Performance Surcharge System:

• Develop a system that receives daily files from different sources and load them into system
• Tracks Members and Brokers activities and efficiency
• Tracks when and how a broker received a trade order
• Based upon the type of order and commodity, identifies when the order is accepted and executed
• Process weekly each and every transaction to calculate charge amount per order by commodity and order type for each broker, local and member firm who fails to meet certain criteria and floor performance standards.
• Insert data into reporting as well as billing tables weekly
• At month end, process all weekly transactions for month end billing. Validates if the charge amount is less or equal to the cap amount for certain types of Brokers, Locals and/or Firms
• Move the billing data to Billing Interface tables and generate invoices
• Provide Detail and Summary weekly as well as monthly reports to internal as well as external users.

Create Market Data Billing System

• This system generate invoices for the Vendors which uses CBOT data products like Datafeed, Delayed datafeed, Data Snapshot, eCbot data, License Fees etc.
• System import the data from a Flat file each month.
• Calculate fees using different pricing formula for different products.
• Calculate adjustments.
• Check for recurring vendors
• Check for waivers and cap amounts
• Create data for month end billing
• Generate invoices and reports for external vendors as well as reports for internal users

Create a system for Fee Audit

• Create database links between PeopleSoft and Fee Audit databases.
• Write SQR programs to load data directly from PeopleSoft Tables to Fee Audit tables.
• Write SQRs to create data files from PeopleSoft.
• Write Unix script to ftp files to Fee Audit servers
• Write SQL Loader scripts to load data from files into staging tables within Fee Audit
• Write Oracle Store procedures and packages to validate data in staging table and then load them in Fee Audit detail and summary tables

Support and maintain portal security for internal employees

• Primary Security Administrator for PeopleSoft Financial and HRMS portal
• Customize Permission List and Roles for internal and external users
• Provide appropriate access to internal and external users.
• Generate security reports for management review.
• Closely work with auditors to make security compliance with Sarban-Oxley standards
• Write security related documentations.
• Administer External users account within LDAP server
• Administer Super User access
• Modify existing as well as create new User Access Groups
• Manage Query Tree Structure. Create custom trees for users.
• Create interfaces programs for BI, AR, GL, and AP modules
• Write SQR programs to read and insert data from external files
• Write SQR programs to generate files from PeopleSoft database
• Create Crystal Reports
• Write Application Engine programs to validate, update and insert data into PeopleSoft
• Write PeopleCode routines to validate data as well as pages.
• Create system that involve PeopleSoft Technologies to load data into a separate oracle base system
• Involve in implementation/upgrade of PeopleSoft Financial from 8.0 to 8.8 and PeopleSoft HR from 8.0 to 8.9
• Support and maintain production.
• Provide support to internal and external users.
• Provide Support for Internal and External Audit
• Write system documentation for SOX compliance
• Write documentation for each procedure as well as for each system that I create