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