Post Job Free
Sign in

Developer Pvt Ltd

Location:
Hyderabad, AP, 500019, India
Salary:
5,000$ per month
Posted:
December 28, 2012

Contact this candidate

Resume:

Santosh.G

Oracle Apex Developer

Ph No:+91-916*******

E-Mail Id: **************@*****.***

PROFESSIONAL SUMMARY:-

. Having 2 years of experience as Oracle Developer.

. Good in SQL/PLSQL Programming.

. Experience in Design, Development, Implementation and support as

Oracle Apex Developer in Production and Development using Oracle

Tools.

. Expertise in creating Oracle Tables, Views.

. Well experienced in writing PL/SQL Packages, Functions,

Procedures,Cursors & Triggers to implement business logic.

. Experience in writing of complex SQL statements, complex joins and sub-

queries.

. Expertise in using collections and Types for coding of Procedures and

Functions.

. Experience in using oracle tools like SQL * Loader, Toad and SQL

Developer.

. Experience in creating Oracle Apex pages.

. Experience in creating Apex pages like Tabular Forms, Forms on a SQL

Query, Master Detail Forms.

. Experience in creating Apex Reports like Interactive Reports, Sql

Reports, Wizard Reports .

. Experience in creating Apex Access Controls based on users.

. Having Knowledge in HTML, JavaScript.

TECHNICAL SKILLS:-

Languages SQL, PLSQL, APEX 3.2,4.1

Scripting HTML

Database Oracle 10g/9i

Operating Systems Windows 7, XP, 2000 server

DB Utilities Toad, SQL Developer

ETL TOOLS Informatica 8.6.0

WORK EXPERIENCE:-

Oracle Developer, XT Global Pvt Ltd, Hyderabad, Jan 2011 -Till date.

EDUCATION:-

> B.Tech in the stream of Electronics & Communication Engineering from

Narayana Engineering College,Nellore

> Intermediate In MPC from Sri Chaitanya Junior College, Nellore.

> SSC from Dr.Srk School, Nellore.

PROJECTS CARRIED OUT:-

BSNL CAF Management Application :-

Oct 2011 - Till Date

Client : BSNL Kerala.

Role : Oracle Apex Developer.

This Application is designed for the BSNL

Kerala to carry out the details about lots.

Lots contain 500 customer authentication applications.

The application is used by the different users like ssa user,sdca user,csc

user etc. It consists of

pre-scan mobile numbers entry,post index data entry and assigning box to

the lots and stored at some rack location in particular rack. By this way

we can search a mobile number where it comes from and present where it is

exactly.

Responsibilities

. Created new Tables, Indexes, Synonyms and Sequences needed as per new

requirements.

. Created views where business requirements needed.

. Created tables with constraints applicable to the business rules.

. Created Explicit Cursors, Records, Tables.

. Involved in writing procedures, functions and packages based on

requirements.

. Creating Apex Forms and Reports based on user requirements.

. Creating Access Controls based on User roles.

. Creating Pre-Computations and item and page level validations.

. Also used JavaScript for some specific page validations.

. Train end users on the functionality and operability of the

application.

Tools Used: Oracle 10g,Apex 3.2,SQL/PLSQL, JavaScript.

HR Recuitment Portal :-

May 2011 - Sep 2011

XT Global Pvt Ltd,

Role :- Oracle Apex Developer.

This portal is designed for internal HR and recruitment team to

carry out their day to day activities.

This application is used by HR team to create a new employee, enter

his/her details and for maintenance of employees. It consists of leave

management and time sheets approval system. This is directly integrated

with pay roll information and it helps in generating the pay slips of

individuals every month based on certain calculations.

Responsibilities

. Created new Tables, Indexes, Synonyms and Sequences needed as per new

requirements.

. Created materialized views & normal views where business requirements

needed.

. Created tables with complex constraints applicable to the business

rules.

. Created Explicit Cursors, Records, Tables, Objects, Collections

(Nested Tables and Varrays) and Error Handling.

. Involved in writing procedures, functions and packages based on

requirements.

. Creating Apex Forms and Reports based on user requirements.

. Creating Access Controls based on User roles.

. Creating Pre-Computations and item and page level validations.

. Also used JavaScript for some specific page validations.

. Train end users on the functionality and operability of the

application.

. Involved in 24/7 Production support rotation.

Tools Used: Oracle 10g,Apex 4.1,SQL/PLSQL, JavaScript.

IT Receipts:-

Jan 2011 - Apr 2011

XT Global Pvt Ltd,

Role :- Oracle Apex Developer

This portal is designed for XT Global HR department to file the tax

returns, Leave calculator and pay slips repository.

Based on the Employee ID and few other parameters this application

automatically calculates the tax slabs and annual detections. And also

calculates leaves based on company's leave policy . And this application

also provide pay slip repository . Any employee in the company can log in

into the application and download his/her payslip by entering his employee

id and some other parameters.

Also gives us the history of an employee's tax details, with data

being centric on pan number and employee ID . It also gives complete

details about the payslips and leaves.

Responsibilities

. Created new Tables, Indexes, Synonyms and Sequences needed as per new

requirements.

. Created materialized views & normal views where business requirements

needed.

. Created tables with complex constraints applicable to the business

rules.

. Created Explicit Cursors, Records, Tables, Objects, Collections

(Nested Tables and Varrays) and Error Handling.

. Involved in writing procedures, functions and packages based on

requirements.

. Creating Apex Forms and Reports based on user requirements.

. Creating Access Controls based on User roles.

. Creating Pre-Computations and item and page level validations.

. Also used JavaScript for some specific page validations.

Tools Used: Oracle 10g,Apex 4.1, SQL/PLSQL, HTML, JavaScript.

Declaration

I do here by declare that the particulars of information and facts stated

here in above are true, correct and complete to the best of my knowledge

and belief.

Date:

Santosh .G



Contact this candidate