PROFESSIONAL SUMMARY:

• Over 15+ years of IT experience in design, development, customization, upgrade, and support various application based on PeopleSoft FSCM (9.2/9.1/8.8/7.5 ) and HCM (9.1, 8.9, 8.0) system and web based applications using in ASP, .NET, Java, TM1.
• As a senior PeopleSoft Confidential functional lead involved in Technical architecture design and Functional Design, develop and maintain software to support the Financial applications (Billing, AP, EX, GL, AR, PO,AM ) / Confidential (Core HR, Payroll, Benefits Administration and Base Benefit).
• Recommended new technologies and tools to support technical architects.
• Handled Security configuration. Created Users profile, Permission list, Roles.
• Handled page level security, Query security to tables and business users.
• Confidential to Business users related to new modules.
• Led architecture and development disciplines for redesign of the BI publisher reports
• Developed reusable components and subsystems for technical architecture
• Excellent communication with business users in gathering the requirements and analyzing those requirements and evaluates on more enhancements of the product which suits the company for better performance and user convenience.
• Ensured that technical architectures met performance and security requirements. .
• Developed architectural solutions based on business requirements
• Works effectively with colleagues and clients at all levels. Strategic thinker and planner, skilled in the design and execution of effective IT solutions.
• Experience in PeopleSoft Internet Architecture and extensively used PeopleTools including Application Designer, Workflow, Application Engine, People Code, Component Interface, File layout, Security configuration, Process Scheduler, Query, Tree Manager, SQL/SQR languages, Crystal, Confidential .
• Proficient knowledge and experience of database performance tuning, including complex query optimization.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports, Crystal Reports, XML publisher report.
• Proficient in Confidential TM1 Planning software to intact with PeopleSoft Confidential .
• Closely worked with Confidential team to understand requirement and provide different options to get required result.
• Excellent customer skills and ability to understand and communicate customer issues.
• Excellent in problem solving and self - learning attitude
• Ability to work well in a team based environment. Possess excellent communication and interpersonal skills.

TECHNICAL PROFICIENCIES:

Products: Billing General Ledger Purchasing eProcurement Asset Management Accounts Receivables Project Costing Accounts Payable Expenses Projects Contracts Core HR Benefit Admin Base Benefit Payroll

People tools: App Designer Application Engine Process Scheduler PeopleCode Component Interface App Messaging Data Mover Workflow File Layout

Reports: SQR n/Vision Crystal Reports XML Publisher

Database: Oracle MS Access SQL Server DB2

Operating System: Windows Dos Unix

Programming Languages: SQL SQR People code C, C++ .NET / Java FoxPro

Tools: Packages Ms office MS Projects Tally SharePoint TM1

PROJECT EXPERIENCE

Confidential

Functional Lead, Atlanta, GA

Responsibilities:

• Design and development of bunch complicated billing invoices using Crystal Report. Used optimization skills to generate reports and invoice.
• Prepared various process documents with detail process flow.
• Monitoring Process scheduler to take action on issued process.
• Gather the required from business users mostly related to Billing, AP, GL modules.
• Provided major support for Billing module which was connected to contract and project costing.
• Designed and developed an automation system to bring the billing data from Confidential system to PeopleSoft which was major automation work saved lots of time of manual billing.
• Led architecture and development disciplines for redesign of the BI publisher reports.
• Designed and Mapping of database to integrate with billing system such as Confidential, 4D, CDR.
• Created architecture Design and developed Automatic Query tool which helped billing users to provide support files to clients on time.
• Lead PeopleSoft upgrade from 8.8 to 9.2. Involved in Fit/GAP analysis, Interfaces Process flow documentation, system Testing.
• Coordinated with Business Users to finalize designs and confirm requirements.
• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
• Diagnosed and troubles hooted processing problems and applied solutions to increase company efficiency.
• Designed strategic plan for component development practices to support future projects.
• Provided security access to various Users in Production and Testing system.
• Handled page level security, Query security to tables and business users. Optimize roles and permission list.
• Consistently met deadlines and requirements for all enhancements.
• Provided month End support to all modules like Billing, AP, AR, AM, GL.
• Maintaining complicated Expenses module which invoices custom workflow.
• Maintaining and developing various third party interfaces like Confidential, Payroll, Confidential Positive pay, Reconciliation by using Application Engine, File layout, Components, pages.
• Developed various Billing, Expenses, AP, AR reports using SQR, Crystal Reports, xml Publisher.
• Maintain and Confidential support for Confidential report queries.
• Having Ownership of proving support to financial team for Confidential TM1 planning software.
• Co-ordinated with various internal teams like offshore team, database, FTP, networking to resolve various dependent issues in system.
• Co-Ordinated with Third party services while handling interfaces.
• Mentoring team member in resolving various technical and functional issue.
• Designed migration documents for new development or new change in system. Attending CAB meeting to approve this change.
• Designed and developed Custom Allocation process.
• Worked on Integration Broker, Messages, Interfaces, Application Designer, People code, PS Query, Crystal Reports, XML Publisher Reports, Workcenter, Pagelets, Pivot Grids, Drill Down Query, Workflow Technology.

Environment: s: PeopleSoft 9.2/ 8.8, People Tools 8.5/8.4, SQL server 2008, Billing, Contract/Project Costing EX, AP, PO,AR, GL, AM.

Confidential, Atlanta, GA

PeopleSoft Analyst

Responsibilities:

• Modified and tested various SQR. Unit testing of application.
• Developed an application using App Engine People code.
• Developed SQR reports to display critical process reports.
• Involved in creating Permission list, Role and assign it users. Resolved the login related issues.
• Involved in creating department tree.
• Worked on the Performance tuning of PS/Queries.
• Developed SQR Interface to send employees job details, tax details, and to ADP.
• Modification done in an Application Engine Interface between Brass Ring and Confidential which handles New hire process.
• Modification done in Application Engine process which is an interface between PeopleSoft and OIM.
• Written PS/Query to get contractors data. Optimize existing queries
• Interacting with users to get requirement for change request.
• Worked with Confidential server team, Acquire team to resolve the issue related to Organization Chart.
• Coordinating with Ad Security team to resolve the issues regarding SSO registration, Email addressing, login issues.
• Worked with Application Security team to assign roles, add table into Query tree, modify Department tree.
• Modification done in Death Master Report SQR as per new format of input file received by Social Administration Office.
• Modification done in App Message, Application Engine to fix the issue of Department Messages sending to Brass Ring.
• Developed Daily Termination Report, PS to MISS, Valid Email Report, and report in SQR.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.

Environment: s: PeopleSoft 8.8, People Tools 8.46, Oracle SQL, SQR, PS Query, People code, Component Interface, Application Engine, Core - Confidential, Workforce Administration, NA payroll, Benefits Administration, MSS, ESS, e-Performance and Base Benefits.

Confidential, Denver, CO

PeopleSoft Developer

Responsibilities:

• Working as a Confidential - Functional Consultant for PS Confidential 9.1 Reimplementation.
• Interacting with users and collecting business requirements and prepared functional and technical specification documents.
• Involved in developing new People Code and customizing existing People Code based on user requirements.
• Created user profiles and handled page level security.
• Involved in developing and customizing the reports using the tools PS Query SQR, and crystal reports.
• Worked with Accounts Payable, General Ledger Cash Management.
• Developed Pages, Component for handling functionality of Positive Pay
• Modification done in SQR interface for Vendor Interface Developed and modification done in Automation of journal entries, Service Fee Automation, Cash Reserve Priority by using Application Engine, Component, Pages and Menu.
• Development of Reports using SQR and crystal reports, Application Engine, People Code.

Environment: s: PeopleSoft 9.1, People Tools 8.5, Oracle 11, CM, AP, AR, GL.

Confidential

PeopleSoft Developer

Responsibilities:

• Worked as a Confidential - Functional Consultant for Workforce Administration and Base Benefits.
• Worked on workflow people code, and was involved in writing people code for business events.
• Handled Permission lists, Roles and created user profiles.
• Customized PeopleSoft pages, records, menus, components, and People Code for user requirements.
• Worked on the Performance tuning of Queries.
• Involved in developing and customizing the reports using the tools PS Query SQR, and XML Publisher reports.
• Involved in documentation of Unit and Integration Test Plans.

Environment: s: PeopleSoft 9, People Tools 8.49, Oracle SQL, Core - Confidential, Core - Confidential, Workforce Administration and Base Benefits

Confidential

PeopleSoft Developer

Responsibilities:

• Work also Confidential the customizations, enhancements of Reports.
• Developed complex SQL, SQR reports and SQCs to suit the business requirements of the company.
• Interacting with Functional consultants and users to discuss new requirements across the business
• Mentor junior Developers on PeopleSoft functionalities and tools.
• Involved in documentation of Unit and Integration Test Plans.

Environment: PeopleSoft 9, People Tools 8.49, SQL Server, XML Publisher, PS Query, People Tools 8.49, Workforce Administration, Time and Labor.

Confidential

Responsibilities:

• Resolve support tickets are in AP, AR, GL, PO, Base Benefits, NA Payroll and Workforce Admin etc.
• Work also Confidential the customizations, enhancements and maintenance.
• Modified and tested various SQR interfaces like General Ledger activity, Posted Journal summary and Journal entry details.
• Retrofit of SQRs during upgrade from Confidential 8.9 to Confidential 9.0.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Developed multiple report by using Oracle SQL, queries.
• Involved in documentation of Unit and Integration Test Plans.
• Modification of SQR Reports as per user requests

Environment: s: PeopleSoft 8.9, People Tools 8.46, Oracle, STAT and Unix, SQR, PS Query, People Tools 8.46, Component Interface, Application Engine, Accounts Payable, Accounts Receivable,, General Ledger, Core - Confidential, Workforce Administration, NA payroll and Base Benefits,.

Confidential, New York

PeopleSoft Developer

Responsibilities:

• Analysis and evaluation of functional specifications
• Designing functional and technical specifications.
• Developed complex Inbound Interface to populate the tables in Procurement database from CSV files.
• Development of Interface Developed an Outbound Interface to transfer data to ARIBA system.
• Generate Reports by using SQR and PS query.
• Developed SQR Interfaces (inbound & outbound) and Reports to load data from external systems into PeopleSoft GL.
• Customized PO pages and Modified Purchase Order SQR as per requirements.
• Created Permission lists, users, roles and assigned roles to users through Maintain
• Performed Unit and Functional Testing.

Environment: s: PeopleSoft Confidential, SQR, PS Query, DB2, People Tools 8.46, GL, PO.

Confidential

Software Engineer

Responsibilities:

• Written stored procedures, triggers using PL/SQL in Oracle10g.
• Keen focus on performance tuning, testing, and quality assurance.
• Worked on web technology Java, JSP to build front end web framework
• Documented functional and technical designs, test cases, and user guides.

Environment: s: Tibco, Oracle, JSP, JavaScript, Java

Confidential

Software Engineer

Responsibilities:

• Development web Application using ASP. Net.
• Developed User Documents for the users.
• Performed Unit and Functional Testing.

Environment: s: ASP .NET, Oracle