Summary :

• Have 8+ years of IT industry experience in implementation, Upgrade of PeopleSoft Finance and HRMS.Also having experience in web based applications using in ASP, JSP, VB.NET, Java, Tibco portal builder.
• Proficiency in upgrade, development & maintenance of PeopleSoft Applications
• Design, develop, test and maintain software to support the PeopleSoft Finance (AP, GL, AR, CM and PO) / PeopleSoft HRMS (Core HR, Payroll, Benefits Administration and Base Benefit).
• Hands on experience on PeopleSoft Development Tools like Application Designer, Process Scheduler, Workflow, Component Interface, People Tools, People Code, SQR, Application Engine, and PS Query File Layout.
• Strong RDBMS skills and hands on experience in Oracle 8i/9i/10g and SQL Server 2000, DB2 using tools like SQL Navigator, Toad for performing SQL and PL/SQL programming.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Have been involved in building and deployment of the applications by using build tools like STAT.
• Possess knowledge of the basic UNIX commands.
• Experience in retrofit of SQRs during upgrade from Finance 8.8 to Finance 9.0.
• Experience in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
• Involved in Unit Testing and Systems Integration Testing during up gradation of PeopleSoft
• Excellent in problem solving and self-learning attitude
  Strong analytical skills to convert Functional design specifications into Technical Design specifications.
• Ability to work well in a team based environment. Possess excellent communication and interpersonal skills.

Technical Proficiencies 
ERP : PeopleSoft Finance (8.8, 9.0) (PO, GL, AR, AP) / PeopleSoft HRMS(8.9, 
9.0) (HR, Payroll, Base Benefits, Benefits Administration)
People Tools : People Tools 8.48, 8.5 Application Designer, People Code, 
Application Engine, Component Interface, Workflow, File Layout.
Platform : MS DOS, Windows, UNIX.
Report Tools : XML Publisher, SQRs and PS Query, Crystal Report 
RDBMS : Oracle10g/9i/8i, SQL Server, DB2, Access.
SQL Programming Tool : Toad
Languages : Visual Basic, VB.NET, ASP.NET, JSP, SQL, HTML, Java, C, C++ 
Tools/Packages : MS Office, Tally, Lotus Smart suit ,Share point.
Operating Systems : Windows Vista, XP, UNIX, Windows 2000, Windows NT

Education

• Masters In Commerce and Diploma in Software Engineering

Awards

• Outstanding contribution Ace award for Tribune Chicago project in Hexaware.

Project Experience

• Confidential Project Oct 2010 – Present

Role : PeopleSoft Techno-functional Consultant.
Responsibilities

• Working as a Techno-Functional Consultant for PS Finance 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.
• Involved in developing and customizing the reports using the tools PS Query SQR, and crystal reports.
• 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.
• Development of Reports using SQR and crystal reports, Application Engine, People Code.

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

• Confidential– HRMS Project Nov 2008 – Sep 2009

Role : PeopleSoft Techno-functional Consultant.
Responsibilities

• Worked as a Techno-Functional Consultant for Workforce Administration
  and Base Benefits.
• Worked on workflow people code, and was involved in writing people code for business events.
• Customized PeopleSoft pages, records, menus, components, and People Code for user requirements.
• 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.

Environments : PeopleSoft 9, People Tools 8.49, Oracle 11, Core - HRMS, Core - HRMS, Workforce 
Administration and Base Benefits

• Confidential Project July 2008 – Oct 2008

Role : Technical Consultant.
Responsibilities:

• Development of XML Publisher Reports
• Work also involves the customizations, enhancements of Reports.
• Developed complex 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.
• Environments : PeopleSoft 9, People Tools 8.49, SQL Server, XML Publisher, PS Query, People Tools 8.49, Workforce Administration, Time and Labor.
• Confidential Jan 2007 – July 2008

Role : Techno Functional Consultant
Responsibilities:

• Effectively involve in the requirement gathering.
• Designed functional and technical specifications.
• Development and ownership of Projects.
• Developed an automated system to upload of HRMS transactions into PeopleSoft. For this an Application Engine program and Component Interface was used to insert data into PeopleSoft HRMS Tables.
• Primary and secondary support to PeopleSoft Finance and HRMS application.
• As part of production support the work comes in the form of tickets.
• These tickets are in AP, AR, GL, PO, Base Benefits, NA Payroll and Workforce Admin etc.
• Work also involves 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 Finance 8.8 to Finance 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.
• Involved in documentation of Unit and Integration Test Plans.
• Modification of SQR Reports as per user requests
• Environments : PeopleSoft 8.9, People Tools 8.46, Oracle, STAT and Unix, SQR, PS Query, People Tools 8.46, Application Engine, Accounts Payable,Accounts Receivable,, General Ledger , Core - HRMS, Workforce Administration, NA payroll and Base Benefits,.
• Confidential June2006–Jan 2007

Role : Techno-Functional Consultant.
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.
• Environments : PeopleSoft Finance, SQR, PS Query, DB2, People Tools 8.46, GL, Purchase Order.
• Command Center Portal Apr 2006–June 2006

Role : 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.

Environments : Tibco, Oracle, JSP, Java.

• ConfidentialNov 2005– Apr 2006

Role : Software Engineer
Responsibilities:

• Have written SQLs to pull data and created procedures.
• Development of Application.
• Developed Business Reports by using Crystal report tool.
•  Have used Visual SourceSafe tool as a Version Control tool for all source code files.
• Developed Web Forms using VB.net and ASP.NET.
• Handled many production issues and enhancement to the existing live portals.
• Performed unit testing for the application.

Environments : VB .NET, ASP.NET, Oracle, Crystal Report.

• Confidential Jun 2005–Nov 2005

Role : Software Engineer
Responsibilities:

• Development web Application using ASP.net.
• Developed User Documents for the users.
• Performed Unit and Functional Testing.
• Environments : ASP .NET, Oracle
• IDA System Project Mar2005 – Jun 2005

Role : Software Developer
Responsibilities:

• Written stored procedures, triggers using PL/SQL in SQL SERVER 2000.
• Designing of Database and Development.
• Performed Unit Testing.

Environments : VB.NET, SQL Server

• Hospital Management System Oct 2004 - Mar 2005

Role : Software Programmer/ Center Coordinator
Responsibilities:

• Designing of Database and Development.
• Performed Unit Testing.

Environment: VB 6.0, Oracle, Windows

• Service Center Management System Feb 2004 – Oct 2005

Role : Software Programmer/ Center Coordinator
Responsibilities:

• Designing of Database and Development.
• Performed Unit Testing.
• Conduct Corporate Trainings

Environment: VB 6.0, Oracle

• Institute Administration System Oct 2003 – Jan 2004

Role : Software Programmer/ Center Coordinator
Responsibilities:

• Designing of Database and Development.
• Performed Unit Testing.
• Conduct Corporate Trainings.

Environment: VB 6.0, Access

• Apr 2001 to Oct 2003 with Icon Computers as a Center Coordinator.
• June 1998 to April 2001 with Datapro InfoWorld Ltd. (Mumbai) as a Senior Faculty

Responsibilities:

• Providing Trainings
• Assist Student into Project Development