Peoplesoft Developer. Smitaz

Email: *****.******@*****.*** . Cell: 404-***-****

SUMMARY :

Have 7+ 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, 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

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

AIMCO – FINANCE Project Oct 20010 – Present

Role : PeopleSoft Techno-functional Consultant.

Responsibilities

• Worked as a Techno-Functional Consultant for PS Finance 9.1 Reimplementation.

• Worked on Change Request of CM, AR, AP.

• Development of Reports using SQR Publisher and crystal reports.

• Designed Technical Specification.

• Involved in documentation of Unit and Integration Test Plans.

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

Universal Studio – HRMS Project Nov 2008 – Sep 2009

Role : PeopleSoft Techno-functional Consultant.

Responsibilities

• Worked as a Techno-Functional Consultant for Workforce Administration

and Base Benefits.

• Customized the Approvals workflow process to allow n-level of approvals.

• Development of Reports using SQR, XML Publisher and crystal reports.

• Involved in documentation of Unit and Integration Test Plans.

• Conducting Peer reviews.

Environments : PeopleSoft 9, People Tools 8.49, Oracle 11, Core - HRMS, Core - HRMS, Workforce

Administration and Base Benefits

AXA E-Performance – HRMS 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.

• Conducting Peer reviews.

• Designing technical specifications.

• 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.

Tribune – HRMS/Finance Project 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,.

AXA Equitable – Finance Project June2006–Jan 2007

Role : Techno-Functional Consultant.

Responsibilities:

• Analysis and evaluation of functional specifications

• Designing functional and technical specifications.

• Developed an 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.

Stock Express Nov 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.

Network Performance Analysis (NPA) Portal 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 Mar 2005 – 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

Contact this candidate