Software Engineer Sql Server

Malli

Mobile: 91-961*******

Email: ********@*****.***

Professional Summary

. More than 3 years of IT experience which includes Development and Support

in PeopleSoft HCM,CRM v8.9/9.0

. Experience in People Soft NA Payroll and Time and Labor Modules.

. Involved in Maintenance/Support of PeopleSoft HCM,CRM projects

. Have good understanding of various Technical aspects of various tools.

. Proficient in using various People Tools like Application Designer and

Languages like Application Engine, People Code, SQR

. Working knowledge and experience in using Reporting Tools such as PS

Query

. Well versed with RDBMS concepts which include database programming using

MS SQL Server 2000/2005, Oracle 10g.

. Having knowledge in PeopleSoft Internet Architecture

. Good analytical, interpersonal, communication and presentation skills

. Good Business and System Analysis skills to understand the requirements

and design application to satisfy customers.

. Can quickly adapt to new skills and willingness to learn.

Technical Skills

Technologies : PeopleSoft

Internet : HTML, JSP

Technologies

Languages : SQL,C, JavaScript

Database and Tools : SQL Server 2000/2005, Oracle 10g, DB2

People Tools : v 8.49

ERP Package : PeopleSoft HCM,CRM v 9.0

Development Tools: Application Designer, Application Engine, Component

Interface, People Code

Reporting Tools : SQR 6.0, PS Query, XML Publisher

Operating System : Windows XP, Unix

Educational Qualifications

. Bachelor of Electronics and Computer Science, Nagarjuna University.

Professional Experience

. Working with HSBC Software Development (I) Pvt. Ltd., Hyderabad from

January 2012 to till date.

. Worked at Serenity Infotech Pvt. ltd as a Software Engineer from April

2010 to January 2012. Main clients are Robert Half International and

Radiant Film Management

Projects Profile

Client: HSBC Software Pvt. Ltd., Hyderabad January 2012- till date

Environment: PeopleSoft HCM 9.0, People Tools 8.49, DB2.

Responsibilities

. Worked on the PeopleSoft reporting to develop SQR, PS/Query Involved in

few customizations for upgrade project.

. Developed SQR program which will convert Peoplesoft queries i.e. PSQUERYS

from Public to Private and vice-versa.

. Supported production issues related to delivered & customized modules.

. Developed and modified People Code to implement specific business rules

and Validations to enable the system to perform the Business Process.

. Involved in modifying and creating new and delivered online objects like

Pages, Components and People Code.

. Created SQRs/SQCs for Data Extraction of tables with huge data.

. Created required documents

. Prepared the plan for Production Extraction, coordinated with various

onsite and offshore teams, verified the logs, etc.

Client: Robert Half International, USA April 2010 to January 2012

Environment: PeopleSoft HCM 9.0, People Tools 8.49, Oracle 10g.

Responsibilities

. Day to Day Production Support.

. Coordinating on-site and off-shore team.

. Used File Layout and developed Application Engine Process to import data

from legacy system to PeopleSoft Records.

. Work on enhancements and bug fixes as per requirement.

. New Developments like Inbound and Outbound interfaces using SQRs.

. Modification of App Engines programs as per requirement.

. Online customizations using People Code based on technical

specifications.

Production Support: Apart all other work Production support is critical

part of RHI People Soft project as data is processed from front office

system called Micro J. As part of the team I am on support (On-call) and

day support by giving my best performance as possible.

Reports: Created the required run control records, pages, and Application

Engine program to generate the various reports. Convertered SQR reports to

App Engine reports. Did the required documentation, testing and migrationed

to Test instance.

Talx i9 (first and second phase)

Designed the App Engine, File Layout, and related records to fetch data

from various tables to write a file with multiple segments.

Learning on Demand Interface

Created an App Engine to get the results of existing SQR, get the correct

reults as the existing SQR was getting wrong values due to mismatch and non

existing data

Declaration:

I hereby declare that all the above furnished information is true in belief

of my knowledge.

Date:-

Place: - Malli

Contact this candidate