VF=>user ID=> Login Register

Feedback FAQ Blog

679,304 quizzes played * 1,633 active players * US$57,334 in prizes awarded

Rankings

Players

PL/SQL Challenge Player: Vijay Mahawar Add to Favorites

Total points: 25381

: 1

: 9

: 38

: 175

Vijay Mahawar

Living in India

Using Oracle PL/SQL since 2002

Playing the PL/SQL Challenge since 13 January 2011

Contact Vijay Mahawar

Public URL:

http://plsqlchallenge.com/pls/apex/f?p=10000:PROFILE:0::NO::P1051_USER_ID:12876:

About Vijay Mahawar

A Commerce Graduate with Masters in Computer Application.

I am member of AIOUG, ODTUG and OTN.

I have expertise in writing Trigger, Procedures, Functions, Packages in PL/SQL and ETL procedures for Data warehousing environment. Especially in Batch Jobs and generating database setup scripts

Domains I have worked on are:
1. Investment Banking
2. Customer Billing Application.
3. Mortgage Payment Protection Insurance.
4. Incident Management.
5. Change and Release Management

I am candidate for CFA program and pursuing a role of Techno-Functional in Investment Banking.

Specialties
Oracle SQL, PLSQL, DBA, Oracle Warehouse Builder and Unix.

I am an Oracle Professional with following certifications:

OCP (Oracle Certified Professional) in DBA - 10g,11g
OCP (Oracle Certified Professional) in Oracle Advanced Developer - 11g

Your Technologies

Click on the name of the technology below to view activity and ranking history for this player in that technology.

View	Expertise	Using Since
Oracle PL/SQL	Advanced	2002
Logic	Intermediate	2011
SQL	Advanced	2002
Oracle Application Express	Beginner	2009
Toad for Oracle	Advanced	2005

Affiliations

All India Oracle User Group (AIOUG)

ODTUG - Oracle Developer Tools User Group

OTN - Oracle Technology Network

Personal Websites

http://www.mahawar.net/blog

http://https://www.mcpvirtualbusinesscard.com/VBCServer/vmahawar/profile

Employment Status

Current status:

Full-time Employee

Desired status:

Consultant

Availability:

Activity History for the Daily PL/SQL Quiz as of 21 May 2013

Total daily quizzes taken	597 of 808 given
Total time taking quizzes	3 days 07 hrs 42 mins
Last played on	20 May 2013
Lifetime correctness	82.7%
Average time per quiz	08 mins 01 secs
Current quarter's correctness	76.2%
Current month's correctness	78.9%
Current week's correctness	100%
Last quarter's correctness	81.4%
Last month's correctness	74.5%
Last week's correctness	77.1%

Ranking History for the Daily PL/SQL Quiz as of 21 May 2013

Lifetime ranking	195 of 9398
Current quarter's ranking	152 of 857
Current month's ranking	239 of 664
Current week's ranking	94 of 387
Last quarter's ranking	147 of 1044
Last month's ranking	115 of 761
Last week's ranking	309 of 562

Achievements

This section lists any awards received playing the PL/SQL Challenge, plus other achievements entered by Vijay Mahawar.

Played All Quizzes in Week Starting 13 May 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 6 May 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 29 April 2013 for Daily PL/SQL Quiz

Played All Quizzes in April 2013 for Weekly SQL Quiz

Played All Quizzes in April 2013 for Weekly Logic Puzzle

Played All Quizzes in April 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 22 April 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 15 April 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 8 April 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 1 April 2013 for Daily PL/SQL Quiz

Played All Quizzes in Q1 2013 for Weekly SQL Quiz

Played All Quizzes in Q1 2013 for Weekly Logic Puzzle

Played All Quizzes in Q1 2013 for Daily PL/SQL Quiz

Played All Quizzes in March 2013 for Daily PL/SQL Quiz

Played All Quizzes in March 2013 for Weekly SQL Quiz

Played All Quizzes in March 2013 for Weekly Logic Puzzle

Played All Quizzes in Week Starting 25 March 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 18 March 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 11 March 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 4 March 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 25 February 2013 for Daily PL/SQL Quiz

Played All Quizzes in February 2013 for Daily PL/SQL Quiz

Played All Quizzes in February 2013 for Weekly SQL Quiz

Played All Quizzes in February 2013 for Weekly Logic Puzzle

Weekly Participation Award for 22 February 2013

Played All Quizzes in Week Starting 18 February 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 11 February 2013 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 4 February 2013 for Daily PL/SQL Quiz

Played All Quizzes in January 2013 for Daily PL/SQL Quiz

Played All Quizzes in January 2013 for Weekly SQL Quiz

Played All Quizzes in January 2013 for Weekly Logic Puzzle

Played All Quizzes in 2012 for Weekly SQL Quiz

Played All Quizzes in 2012 for Daily PL/SQL Quiz

Played All Quizzes in 2012 for Weekly Logic Puzzle

Playoff Participant in Q3 2012

Ranked 37th in Q3 2012 Playoff

Weekly Participation Award for 31 August 2012

High Accuracy in Week for 17 February 2012

Played All Quizzes in 2011 for Weekly Toad Quiz

Oracle DBA Certification in Oracle 11g (Oracle Corporation) - 29 December 2011

Played All Quizzes in Week Starting 12 December 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 5 December 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 28 November 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 21 November 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 7 November 2011 for Daily PL/SQL Quiz

Played All Quizzes in October 2011 for Daily PL/SQL Quiz

Played All Quizzes in September 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 29 August 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 22 August 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 8 August 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 1 August 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 18 July 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 11 July 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 4 July 2011 for Daily PL/SQL Quiz

Played All Quizzes in Q2 2011 for Daily PL/SQL Quiz

Oracle Advanced PLSQL Certified Professional (OCP) in 11g (Oracle Corporation) - 14 May 2011

Played All Quizzes in March 2011 for Daily PL/SQL Quiz

Played All Quizzes in February 2011 for Daily PL/SQL Quiz

Played All Quizzes in Week Starting 31 January 2011 for Daily PL/SQL Quiz

Oracle DBA Certification in 10g (Oracle Corporation) - 24 April 2010

Oracle Certified Expert in SQL (Oracle Corporation) - 16 January 2010

Recommendations



Ask Tom	Ask Tom website is knowledge warehouse of all Oracle topics. Through this website you can get to know the inner workings of Oracle straight from the master. Here, Tom answers questions and the webiste provides the searchable archive of answers. Highly recommended for people who want to dwelve into the Oracle Internals.
Oracle PL/SQL for DBAs	I first read Oreilly book on PL/SQL for DBA in year 2006 and found it really impressive. I highly recommend it for Oracle DBA who want to use PL/SQL for better results
Oracle Technology Network	I found Oracle Technology Network as medium to get the first hand information on latest in Oracle Technologies directly from Oracle. It also gives you an opportunity to network with other Oracle enthusiasts in the Industry. For me OTN events has been a way to stay updated with the latest in Oracle Technologies in both Developer and DBA tracks. Some useful resource I recommend is http://events.oracle.com
Oracle-BASE	Tim Hall, the person behind Oracle-Base website has always been my role model. His indepth knowledge in Oracle Technologies both as PL/SQL Developer and DBA is mind boggling. I recommend him for people who are looking in both the tracks.
Steven Feuerstein	He is the Oracle PL/SQL Guru for me and highly recommend him to all beginner to experts in PL/SQL Programming. With his website www.plsqlchallenge.com I learn new PL/SQL skills everyday and stay abreast with the latest in PL/SQL technology.
ToadWorld	I had been using Toad from Quest Software since year 2005. I found it really a wonderful tool and good for beginners and experts. Toad really makes your job easier and you become more productive. Toad software also gives you option to configure the tool to the great extent. Its favorite among both the DBAs and Developers. Quest has launched various other tools for Oracle after the success of Toad among DBAs and Developers.