Peoplesoft Programmer/Analyst, Financials, Student adminstration

S UMMARY

* ***** ** ********** ** implementing ERP using Peoplesoft 9.0 Campus Solutions/Student

Administration, Student Financial, Financial & Supply Chain Modules and Purchasing &

Inventory modules.

Experience integrating Peoplesoft with other ERP systems like Salesforce using Integration

Broker

Experience in developing custom reports using Crystal Reports, SQR, nVision, OBIEE.

Extensively using Application Engine, PeopleCode and PeopleTools, Process Scheduler,

Application Configuration

Worked on database development using SQL, PL/SQL on Oracle 10g and SQL Server

databases

Experience in developing Java based web applications using Object Oriented concepts,

Webservices and Javascript.

Good understanding of Datawarehousing and ETL concepts using Informatica.

Collaborated with end-users and technical teams in integrating applications.

SKILLS

Languages: SQR, SQL, PL/SQL, C, Java, JSP, Servlets, HTML, XML, JavaScript

ERP: Peoplesoft 9.0 Campus Solutions modules - Admissions and Recruitment,

Curriculum Management, Student Financials, PeopleSoft 8.4/8.8 Financial

& Supply Chain Management Modules, Inventory, Purchasing, Accounts

Payable and General Ledger Modules,, Self Service, SQR, Application

Engine, Peopletools, Peoplesoft Security, Salesforce.com

Databases: Oracle 9i/10g, SQLServer 2005, MS SQL Server2000

Data Warehousing: Informatica Power Center 7.x/8.x Mapping Designer, Mapplets

Reporting Tools: Crystal Reports, OBIEE, Business Objects, SQR, MS-Office

Version Controls: Microsoft SourceSafe, CVS

Operating Systems: Windows, DOS, UNIX, Linux

Tools: TOAD, SQL Developer

EXPERIENCE

Mar’ 2009 – May 2014

Academy of Art University, San Francisco, CA

Role: PeopleSoft Application Programmer/Analyst

Configure Communication Codes, Category, created query, created Email templates

●

using XML Publisher, created mappings between queries and XML Publisher.

Automated the process of comments and remarks generation for the Academy Resource

●

Center(ARC) by creating SQR Code and developing UI Components using Application

Designer.

Improved Process Scheduler performance by using XML Publisher instead, for

●

customization of Academic Advisement Report and Transcript Report.

Created PeopleCode to export Student Transcript data from Peoplesoft to Salesforce

●

using Webservices.

Performed Search Match for Student Leads in Peoplesoft for data obtained from

●

Salesforce using Integration Broker

Generated UI components using Application Designer and PeopleTools to support

●

Student Transcript creation in Peoplesoft system. (Student Records)

Pavana Chitti

43555 Grimmer Blvd Cell: 510-***-****

#M2107, Fremont, CA 94538

Created various reports and customized various reports and pages for Finance

●

department using Crystal Reports

Implemented Peoplesoft Security by creating Users, Assigning Roles and Permission

●

Lists. Also implemented Row Security

Testing and finding out the reasons if there are any disparities between student finance

●

and finance department.(Student Finance and Finance)

Creating and modifying various reports for student records department like attendance

●

reports and for online, onsite students or for international and domestic students. (Student

Records)

Created various reports for curriculum department to decide about assigning classes to

●

various full time and part time faculty members.(Curriculum Management)

Collaborated with end-users, collected requirements, analyzed and provided technical

●

implementation. (Student Records, Curriculum management, Financial Aid, Student

Finance, Records and Enrollment)

Supported the application in Production and Test environments for high availability and

●

integration testing respectively.

Decipher Software Solutions, St. Petersburg, FL Mar’ 2008 – Dec’ 2008

Role: Techno-Functional Analyst.

As a part of a client engagement was involved in the implementation of Peoplesoft 8.8 General Ledger,

Accounts Payable, Billing and Accounts Receivable modules of the client. As a techno-functional analyst

was responsible for the following;

Configured General Ledger, Billing and Accounts Receivable modules as per the new

●

requirement.

Executed data integrity reports DDDAUDIT, SYSAUDIT and ALTERAUDIT and fixed

●

anomalies that were surfaced in these reports.

Developed new object and new pages and enforced new PeopleCode for new ACH

●

payment details information in Accounts Payable Module.

Created various critical queries in Accounts Payable modules to identify if there are any

●

data related omissions with regards to vouchers and payments information.

Created reports for business users using PS Query and SQL. Worked directly with

●

clients to develop and/or refine monthly billing statements/invoices and related summary

reporting.

Responsible for the design and functional training for Accounts Receivable, Accounts

●

Payable, General ledger, Billing.

Created a process for effective receivable collection by generating weekly reports for

●

business partners.

Created various Trees for reporting purposes.

●

Conducted Change Control Meetings. Provided solutions to variety of time critical

●

reporting needs.

Prepared and conducted Unit Test and Integration test cases and conducted code review.

●

Designed workflows for PO and Payables system using Virtual approval and email

●

capabilities.

Responsible for developing reports using Trees, nVision, SQR and Crystal. Used

●

Datamover to run various configuration scripts.

Pavana Chitti

43555 Grimmer Blvd Cell: 510-***-****

#M2107, Fremont, CA 94538

Resolved various production issues in Requisition Loader Process and PO creation

●

process for replenishment items.

Responsible for setting up of control set up information that include new chart of

●

accounts, Calendars to process the year-end financial statements. Ran various reports for

business users for financial year closing using time spans and calendars.

Responsible for fixing various process related issues in Requisition Loading, PO

●

Sourcing Put away processes.

Created various new SQRs and modified existing SQRs as per the requirements of the

●

business users. Customized Pay cycle managers to add new processes in the pay cycle.

Resolved various issues related with payroll interface with GL.

Responsible for Configuration and Installation of File Server.

●

Resolved various issues related to data issues in PeopleSoft Inventory, Purchasing and

●

AP modules.

Having good knowledge of creating Tabular and Matrix Layouts using PeopleSoft

●

nVision Reports.

Built various queries using PeopleSoft Query tool that helps the users in retrieving

●

various accounting information and reports from time to time.

Worked extensively in Application Engine in resolving various process-related issues.

●

Developed various panels and PeopleSoft objects to suit the business process

●

requirement. Worked extensively used PeopleCode to enforce functionality.

Actively involved in the PeopleSoft Project Team in providing Production Support for

●

Supply Chain modules.

Company: Infosys, Hyderabad, India August 2006 – Jan 2007

Role: Trainee Software Engineer/ Peoplesoft Developer

Infosys is one of the world’s leading software companies. As a part of extensive training and

subsequent client engagement, was trained and involved in the implementation of Inventory and

Purchase Order of PeopleSoft based ERP solution. The 3 month long training also involved extensive

training or Oracle PL/SQL, SQL Queries, Unix and scripting languages. As a part of the client

implementation was responsible for:

Involved in first level customization of PeopleSoft Financial (Accounts Receivable,

Accounts Payable, Inventory and Purchasing).

Executed Data entry reports DDAUDIT, SYSAUDIT and ALTERAUDIT and fixed

anomalies that were surfaced

Involved in the Study of requirements, Design of the Financial System, Establishing the

Business Rules, System Testing of the Business Processes.

Created various permission lists and attached those permission lists to the various roles

based on the organizational roles in the company.

Extensively worked on creating Workflow, Application Engine, and Tree Manager for

Chart fields, Summarization and Consolidation and Query.

• Gained good experience in customizing using People Tools and People Code as well as creating

new processes and reports using nVision, SQR, Crystal and modifying existing processes and

reports.

• Creation and installing Peoplesoft Internet Architecture, Web server and PeopleSoft application.

• Responsible for running various DMS scripts in boot strap mode as a part of preparation for the

installation of PeopleSoft

Pavana Chitti

43555 Grimmer Blvd Cell: 510-***-****

#M2107, Fremont, CA 94538

• Played a partial role of System Administrator in maintaining App Server and Process Scheduler

Server.

• Created training manuals for PeopleSoft Inventory, Purchasing and Accounts Payable Modules.

ACADEMIC PROJECTS

Student Intern

Defense Electronics Research Labs. Hyderabad, India Feb’ 2005 thru Apr’ 2005

This Project is about developing software for ARISTOMAT 401 photo plotter machine. This machine is

used to hatch the film for making of circuits.

Developed Embedded Software for Photo Plotter using C Language

Developers Math based functions invoked by the Printer.

Used C Graphics library as a part of application development.

Student Intern

Indian Petroleum Consumer Services, Hyderabad, India. Feb’2002 – April 2002

Designed and developed an Inventory Management. This system keeps track of inventory, Customer

Order Processing and Billing and Invoicing

Developed Java based user interface using Java AWT.

Developed business logic using Java

Designed database table in Oracle and generated reporting using Oracle Reports.

EDUCATION

Masters in Computer Applications, Andhra University, India, July 2005

Bachelors in Computer Applications, Andhra University, India July 2002

TRAINING

● Underwent Training in Peoplesoft 8.0 Financials and Supply Chain Management including

modules Purchase Order, Inventory, Accounts Payable. Also underwent training in

Application Engine, Peoplecode, and SQR. Training also covered advanced concepts in Oracle

SQL, PL/SQL and Unix Shell Scripting

Underwent training in Data Warehousing methodologies including Star Schema, Snow Flake

●

Model, ETL using Informatica PowerCenter 8.1.

Reports development using Oracle Business Intelligence OBIEE.

●

VISA STATUS: Green Card

Contact this candidate