Project Sql

S Priyadarshini Mob-+91-879*******

Email-priyamca48@ gmail.com Location-Bangalore

Career Objective

To be a part of an organization where I can significantly contribute by virtue of my knowledge, hard work & analytical best of my mind . My main objective is always to give the best of my performance which will both benefit the organization & me.

Professional Experience Summary

Having Oracle Certified Associate (OCA) certification from Oracle Corporation.

Having 2.8yrs. of Professional experience as Software Developer for the Position in Development and Support also.

Having good knowledge in SQL and PL/SQL.

Having user level knowledge in UNIX and Shell Scripting.

Having good knowledge on SDLC (Software Development Life Cycle).

Flexible in work and proactive.

Excellent communication and interpersonal skills with experience of functioning as morale owner of the team and also a good team player.

Professional / Academic Credentials:

Stream College / University Percentage

MCA(2010) B.P.U.T,Orissa 80%

Professional Status:

ORGANIZATION PERIOD DESIGNATION

Mastrone Software Services May 2010 to till date Software Developer

Idea Technosolutions Pvt ltd Jan 2010 to May 2010 Trainee Engineer

Technical Skill:

Language SQL,PL/SQL

Database: Oracle 9i,10g

Version Control SVN

Database Tools: TOAD,SQL DEVELOPER

Operating System Windows, Unix

Scripting Language: Unix Shell scripting, HTML and JavaScript

Ticketing Tool: Remedy, Cosima

Other Tools: Putty

Project Details:

#1. PROJECT TITLE RSCB

Domain Banking

Client SCB

Database Oracle 10g

Platform PL/SQL,UNIX

Tool Used TOAD,SQLDEVELOPER

Team Size 8

Duration November2011 -- tilldate

Description:

RSCB-Group Special Assets Management is a specialized unit, which manages the Bank’s non-performing assets(NPA’s).It will be the single system where data are entered initially, manually, eventually, electronically when the Basle Data warehouse(BDW)is up and running.

RSCB serves as a repository of data that will demonstrate GSAM’s effectiveness in making debt and interest recoveries, as well as reducing the problem account portfolio- all of which make a substantial positive contribution to the Bank’s profitability. This will also form an important element in the capital adequacy model that the Bank has to present to the regulators under the Basel II accord-GSAM’s success will ensure that we are able to justify a much lower capital adequacy requirement than would otherwise be the case, an outcome of long-term benefit to the Bank.

It is essential that RSCB be fed with timely and accurate data at all times, not only for the preparation of the relevant SARR, where applicable, and to keep GSAM senior management informed, but also for parties outside GSAM who have a legitimate interest in the data. All accounts under GSAM’s control, without exception, have to be maintained and updated in RSCB.

The objective of this application is to automate the existing applications (RSCB /SARR) into one single web based application.

This product has the following

• General

• Customer

• SARR(Special Assets Review Report)

• Outstanding and Variances

• Collateral

Responsibility:

Worked in back-end programs using SQL and PL/SQL.

Worked on procedure, function, package, SQL script, Performance Tuning.

Enhancement and Maintenance.

Production Support.

Involved in review meeting.

#2. PROJECT TITLE ISS

Client SHELL

Database Oracle 10g

Platform Windows,ICS,MQSeries

Team Size 5

Duration January2011 -- October2011

Description:

This application is used to integrate different types of Shell application.

It allows to connect multiple disparate systems to multiple business processes. Each system is connected via a connector over which data can flow for the many business processes within the Hub. With each business process based upon a building block (the Shell Collaboration Foundation) a centralized view of data flow and auditing and logging is available. The ability to rapidly develop, deploy and maintain complex business processes is made simpler.

Responsibility:

Worked in back-end programs using SQL and PL/SQL.

Worked on procedure, function, package, SQL script, Performance Tuning.

Monitoring the server.

Finding the reasons for failed flows.

Creating incidents

#3. PROJECT TITLE ANC

Domain Health

Client UNICEF

Database Oracle 10g

Platform PL/SQL

Team Size 8

Duration Jun2010 – December2011

Description:

It is a type of testing method where in babies of the age between 6 weeks to 6 months and 6 months to less than 18 months will be tested for HIV infection if they have born to HIV positive mother. The most important need of this project is to capture the information about the specimen dispatches and test results. This information is required to be instantly made available to the respective specimen collection centre, testing lab and to the lead agency . This application covers different aspects like data capture, alerts, dynamic reports, referral tracking. Major benefits of using this application are

• Assisting in tracking of HIV infected mother & child.

• Assisting in tracking of testing.

• Linking exposed and infected infants and children< 18 months to appropriate referral, and care and treatment services

• Ensure timely intervention to reduce morbidity and mortality due to HIV infection

• To increase the awareness in ICTC, ART & DBS/WBS collection centers.

Responsibility:

Involved in Analysis, Designing, Coding, Error Debugging, Unit Testing.

Worked in back-end programs using SQL and PL/SQL.

Worked on procedure, function, package, SQL script, Performance Tuning.

Worked on view,materialized view.

Worked on text indexing on table and materialized view.

Database Structure Modification and creation of Database Objects.

Prepared batch jobs using DBMS package.

#4. PROJECT TITLE ONLINE VOTING SYSTEM

Database Oracle 10g

Platform PL/SQL

Team Size 4

Duration January2010 – May2010

Description:

A website entitled “Online Voting System” developed for the fulfillment, the degree of MCA. The aforesaid website has been developed for IDEA TECHNO SOLUTION PVT.LTD.

On-line Voting System is a web based system that facilitates the running of elections and surveys online. This system has been developed to simplify the process of organizing elections and make it convenient for voters to vote remotely from their home computers. Users are individuals who interact with the system. All user interaction is performed remotely through the user's web browser. Users are categorized into three classes: Administrator, Returning Officers and Voters.

A system will have only one Administrator but it typically has multiple returning officers and voters. The administrator is responsible for managing user accounts, polls, system resources and safekeeping of the system .Returning officers have the responsibility of managing a poll as assigned by the administrator, whereas voters only have the ability to submit ballots on polls in which they are admitted.

This project involved for casting the votes through online which is the candidate for an election. Involved in developing a web based application which would enable online voting system gets automated publish the results after completing the voting procedure.

Responsibility:

Involved in Analysis, Designing, Coding, Error Debugging, Unit Testing.

Worked in back-end programs using SQL and PL/SQL.

Worked on procedure, function, package &Trigger.

Worked on view,materialized view. .

Personal Details:

Present Address #81/2,1st main road,2nd Cross, Saptagiri Layout,Munnekolal

Marathahalli,Pin-560013

Sex Female

Language English, Hindi & Oriya.

Nationality Indian

Declaration:

I hereby declare that all the above written particulars are true to the best of my knowledge and belief.

Place: Bangalore

Date: (Priyadarshini)

Contact this candidate