Homepage
Give Private Classes
New Delhi 
₹950/hr
Unfortunately, this teacher is not available
Tutor profile verified
Response Time 24hr
Classes offered by Sanjay
  • Individual
  • In group
The classes will be held
  • at his home
  • at your home
  • By webcam
Taught subjects
  • SQL
  • Oracle
Levels
  • Primary School
  • Middle School
  • Class 10
  • Higher Secondary School
  • Class 12
  • Adult education
  • Undergraduate
  • Masters
  • Postgraduate Diploma
  • Doctorate
  • Beginner
  • Intermediate
  • Advanced
  • Professional
  • For children

Oracle RDBMS concepts and PLSQL & SQL, Delhi & Noida,18 yrs exper.as Developer

Methodology

classroom training,power point presentation,videos
20-30 students in class and printed study materials
Under graduate course & Degree level and industrial training and programming concepts in PLSQL and SQL and R and Analysis Software such as WEKA and R Studio and SAS

Background

Sr.Developer with 18 years experience & Developed School Admin & ERP software and Data Scientist with
3.5 years exp.in R & Statistical analysis,International certification(stanford and harvard extn.school) and I.I.T madras certification in Data Analytics( 8 weeks) and Business analytics and Data Mining Modelling in R (12 weeks) from I.I.T Roorkee

Rates

Transportation Fee : ₹400
Rate for online classes : ₹650/hr

Details

12 th pass students Rs. 700/- per hour
Graduate and above and Non experienced students: Rs.550 per hour

Classes offered by Sanjay
Individual
In group
The classes will be held
at his home
at your home
webcam
Taught subjects
  • SQL
  • Oracle
Levels
  • Primary School
  • Middle School
  • Class 10
  • Higher Secondary School
  • Class 12
  • Adult education
  • Undergraduate
  • Masters
  • Postgraduate Diploma
  • Doctorate
  • Beginner
  • Intermediate
  • Advanced
  • Professional
  • For children

Sanjay's CV

SANJAY PRATAP
Contact No.: +91-(concealed information)
E-Mail ID: (concealed information)

~SENIOR IT PROFESSIONAL~
Versatile, high-energy technocrat with the professional targeting senior level assignments in Data Analysis &Development/Coding with an organization of high repute preferably in IT industry



PROFILE SNAPSHOT

A competent professional with over 27 years of experience in:

~ Analysis & Implementation ~ Data Scientist / Analyst ~ Application Development
~ Requirement Gathering ~ Quality Assurance ~ Coding & support
~ Data Mining/ Machine Learning ~ Statistical Analysis ~ Big Data,R,WEKA
~ Oracle 8i/9i ~ D2k(Forms6i,Reports 6i,PLSQL) ~ Oracle DBA

• Insightful professional with knowledge of entire software development life cycle from requirement analysis to system study, development, coding, testing, de- bugging, documentation and implementation.
• Expertise in Data Science Field and Statistics and worked in Data Science; technical expertise entails D2k (Forms6i, Reports 6i, PL-SQL) and in-depth knowledge of WEKA, R Studio and Shiny
• Expertise technical expertise entails D2k (Forms6i, Reports 6i, PL-SQL,Database Triggers,Procedures,Functions) and in-depth knowledge of PLSQL
• Skilled in analysing information system needs, custom designing solutions, evaluating end-user requirements & troubleshooting web applications issues; expertise in the areas of Web Technologies, Client-server
• High integrity & energetic leader, capable of leading & motivating individuals to maximize levels of productivity

ORGANISATIONAL EXPERIENCE

Apr’03-Present
Synergy InfoNet Pvt. Ltd., Noida
Growth Path:
Apr’03-Apr’09 As Technical Leader
Apr’09-Till Date As Sr.Technical Leader/Data Analyst

Key Result Areas:
• Directing technology planning and direction, strategy development, leadership and implementation, business and operational transformation execution.
• collecting, processing and performing statistical data analysis on Raw Data.
• Mapping clients’ requirements and providing them best solutions within the scope of project requirements
• Meeting deadlines and Turn-Around-Time without compromising quality norms and adhering to SLA. Implementing short/long-term plans for achievement of process objectives
• Spearheading the functions pertaining to client/user interaction for requirement gathering, risk assessment, finalization of technical architecture and discussions for effort/cost/time estimation and client co-ordination and reporting
• Communicating with internal clients to determine specific requirements and expectations; managing client expectations as an indicator of quality; providing overall leadership to the entire project team including managing deliverables of other functional team leaders
• Strategizing resource requirements and multiple resourcing / delivery models, including resources to be working in-house or at the client site; optimizing system/database operations and resource utilization; performing system capacity analysis and planning
• Creating blueprint of the data for data management systems to integrate, centralize, protect and maintain data sources; analysing qualitative and quantitative data with statistical theories and method

Significant Accomplishments:
• Implemented 25 number of appraisals
• Led a team of 30 Database Programmers for building and managing Oracle databases and troubleshooting, debugging, evaluating, and resolving software issues in the organization’s custom and internal end-user applications
• Performed Oracle Apps upgradation in Production, User Acceptance Testing (UAT) and Development environments; conducted on-going tuning of database instances
• Spearheaded large-scale program management ranging from INR 1-2.5 Crores including iterative & waterfall project management, enterprise program governance, risk management, outsourcing/insourcing, and onshore development models.
• Built and led high-performing teams 8 members for projects such as ERP for manufacturing Unit ; enhanced morale, cross group collaboration, staff development and talent management
• Mentored and coached the project team on areas such as coding,analysis,support planned and integrated the work of multiple teams on a project; provided input on team performance and reward
• Acknowledged with 15 clients for managing multiple project modules with pre-calculated risk factor and delivering successful & complete technological transformation in a well-balanced way

PREVIOUS EXPERIENCE

May’93-Mar’03
Synergy Software Ltd., Noida
Growth Path:
May’93-May’99 As Application Developer
May’99-Mar’03 As Senior Application Developer

Oct’90-Apr’93
S. Kumar & Co., Noida as System In charge

IT SKILLS

• Operating Systems: Windows 8 / 7/ XP/2003/2000/NT/98/95, Unix, DOS
• Databases: Unify, Oracle 8i/9i, Foxpro, SQL-Server
• Reporting Tools: Crystal Report writer,D2k(Froms6i,Reports 6i)
• Languages: R, PL-SQL, Codebase, Codescreen (Libraries of C), ASP

CERTIFICATIONS/TRAININGS

• Big Data & Hadoop Courses Completed:
o IBM Certifications (Big Data University Online Courses)
o Hadoop Administration Level 1 on 3rd & 6th Jan’17.
o Big Data Foundations Level 1 on Dec’15
o Online Course on HDE 100, Apache Hadoop Essentials from MAPR Academy in Oct’15.
• Data Analysis & Machine Learning and Statistical Analysis Completed:
o 12 Weeks online course on Business Analytics & Data Mining Modeling Using R
From Department of Management Studies,I.I.T Roorkee - National Program on Technology Enhanced Learning.
Dec.2017 – Apr.2018 ( Result awaited)
o 8 Weeks online course on Data Analytics from Deptt.of Management Studies I.I.T Madras,National Program on
Technology Enhanced Learning.Jul-Sep.2107 got grade 52%.
o 9 Months online course on Data Science from Johns Hopkins University on Coursera Signature Track Program and got grade 94% in Sep’15.
o 4 weeks online course on Statistics & R from Harvard Extension School through edx.; secured: 97%
o SAS E course (SAS Programming 1 Essentials) from SAS Institute Inc., USA in Sep’16
o Merit of completing online course on Statistical Learning from Stanford University in Sep’16
o Oracle and D2k & Unix and C
o Certified Course on Unix & C from Computer Society of India, Delhi Chapter for 5 weeks in 1990.
o Certification course in Computing from Indra Gandhi National Open University
o ORACLE8i, D2K (Forms/Reports 6i, PLSQL/SQL) course from SQL Star International Ltd.(1997)

ACADEMIC DETAILS

• PGDCA from International Computer Institute, New Delhi in 1989.
• B.Sc. from Lucknow University, Lucknow in 1987 .

PERSONAL DETAILS

Date of Birth: 14th April 1966
Languages Known: English and Hindi
Address: N-908, Prateek Laurel, GH-01, Sector-120 ,Noida-201301, New Delhi
Passport Number: J0948036

Annexure

Synergy InfoNet Pvt. Ltd.
Title: BMI Analysis of Boys and Girls in Schools
Period: Dec-2017 to Feb.2018
Team size : 2
Tools used: Weka & R
Description: HOPE - An NGO who conducts monthly activity in various schools categorized in A(public
schools),B(private schools),C(Govt aided schools) in several districts in North India about
Hepatitis A,B,C in the age group of 10 to 19 years of students and impart knowledge about its
vaccination and knowledge about its cure and prevent the disease.They collect the Data
consists of Gender,Age,Height,Weight and their Lifestyles and food habits in an Excel file.We
calculate the BMI(Body Mass Index) -Weight & Height ratio and conculde the results with
statistical analysis that shows BMI of Boys & Girls of different age group categorywise(mean
and Analysis of variance using WEKA and R) and plot the graphs that shows BMI Analysis.

Title: Real Estate Analysis
Period: July’17 – Nov.-2017
Team Size: 4
Tools Used: WEKA and Rstudio
Description: The project deals with housing prices prediction for a well-known construction company (Builder) in Delhi region (NCR) based on historical data of about 10 years of various housing societies. An excel file Which contains multiple predictors (input) such as price per sq./ft., no. of bedrooms, air-conditioning, study/store option and no. of washrooms. A model is developed using Multivariate Regression Analysis using R and Shiny (web based application for R) for their future housing projects in various locations.

Title: School Admin Software- Examination Analytics
• Spearheading the analysis of School DataSet (Excel file) of examination & Monthly Fee and developing web application in Shiny & R using Statistical Analysis such as ANOVA and Regression
Period: Aug’16-Mar’17
Team Size: 2
Description: In this projects user upload excel file containing examination data such as Student Id, Examination Type (Unit Test/Half Yearly/Yearly) and Marks & Class & Section and Subject. The application reads excel file and based on user input shows output such as histogram and table of information of student in particular subject in particular exam. The User can view exam result information of particular student in all exams in all subjects as well as in particular subject. The analysis is done in WEKA and R.

Title: Fee Analytics
Period: Dec’15-June ’16
Team Size: 2
Description: This projects deals with analysing Master Fee Data which has various Fee heads such as Tuition, Activity Development and Annual in a particular year for each stream of each class. There is an another set of data containing school expense such as salaries of staff, transportation expenses, based on the data using statistical tools. This application suggests that in coming Year(s) administration has to increase / decrease (amount) in various fee heads subject to maximize revenue and minimize school expenses.

Title: School Admin Software.
Period: Apr’06 to Dec-08
Environment: Oracle 8i, D2k (Forms6i and Reports 6i & SQL/PL-SQL) .
Role:
• Spearheading design and development of software for Educational Institutes, Schools and Universities; leading a team of 7-8 developers
• Working as a DBA and performing daily/weekly activities; creating database and tablespaces for users and assign rights/roles to them
• Conducting fine tuning of SQL/PL-SQl statements for optimization and facilitating the backup & recovery procedures for taking incremental and full backups; troubleshooting of Applications in Oracle Database
• Develop and Implement customized & support Admin.Software in Lucknow Schools and Lucknow University.
• Software has 8 Modules such as Student Profile,Fee Processing Module,Library Module,Accounting Module,Payroll Module,Inventory Module,Examination System,Transportation Module.

Title: Call Management System
This is an Inhouse Software Developed to cater interdepartment Call management System that tracks Call made by Clients regarding Hardware/networking trouble and shows available hardware/Networking engineers and assign them to resolve issues at Client site and record the Status of the Call. System Generates various reports such as Daily Call sheet and pending call status and enginner wise Detailas well as Client wise Detail in a month.Also support the software after installation.
Period: Jan-09 to Apr 10
Environment: Oracle 9i.D2k(Forms 6i,Reports 6i,SQL & PLSQL)
Role: Develop and Implement inhouse Software requirement.

Title: Inventory Management System
This is also inhouse devloped software that manages various hardware & networking parts and issues to clients depending upon their AMC status and track repaired parts as well.It maintains replaced ,repair and new parts inventory as well clients AMC status and generates AMC letters to Clients and track reorder items and purchase through various vendors and generates various reports..
Period: July 10 to Jan-11
Environment: Oracle 9i and D2k(Forms 6i,Reports 6i,PLSQL)
Role: Develop and Implement inhouse Software requirement.


Synergy Software Ltd.
Title: Programmer / Developer
Period: May’93-Mar’03
Operating System: Dos6.22, Windows 95, 98, Vista, XP, NT, UNIX
Database: Oracle 8i, Unify, Codebase & CodeScreen
Role:
• Was a part of Development/Coding Team in ERP Projects such as :
o Multi Tech Ltd., Noida (Readymade Garments)
Role:Coding in Unify (Database)and C in Unix OS (Shell scripting).
Duration: 24 Months,Team Size: 4
o Tristar Products Ltd., Noida.(Makeup & Arts Brushes)
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 36 Months,Team Size: 3
o Financial & Insurance Management - for Zurich Insurance
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 20 Months,Team Size: 2
o Financial & Loan Management – for RR financial Services
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 18 Months,Team Size: 2
• Led the development of websites for various clients using ASP, HTML, Java; implemented and managed more than 10 client-server projects for various; mapped business requirement and designed functional specifications basis that provided coding logic to the team as per the requirement
• Interacted with the client and got UAT sign-off and the package implanted at client sites; extended support to the users, troubleshooting and managing enhancements requests

S.Kumar & Co., (Share & Stock Broker)
Title: System Incharge
Period: Nov.’89-Mar’93
Environment: Share Trading Package for Back Office Accounting
Role: Acted as an In charge for software & troubleshooting

Similar teachers

SQL classes closeby? Here's a selection of tutor listings that you can check out.
Superprof can also suggest oracle classes to help you.

New Delhi
A working Professional who can give classes on any of the subject
₹750
Prrabhh
1st class free!

My Teaching Method is Simple , depends on students psychic i can modify my style and method of teaching to give a better...

Classes by webcam Face-to-face classes Approved profile
Delhi
I was Student in engineering college and have completed Bachelor's of Computer Applications from IPU. I teach Python programming language and mysql, sql commands with oracle for classes 11th and 12th.
₹270
Ashna
  • (1 review)
1st class free!

I focus more on the individual student's needs rather than assuming all students are at the same level of understanding. My...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Quality of education gives a wings to fly and achieve your dreams
₹400
Prince
1st class free!

Clear the basic and then further go in details of topic

Classes by webcam Face-to-face classes Approved profile
New Delhi
Computer Science Expert who is currently working as a project engineer with Govt of India gives tuition on computer science subjects
₹750
Girish
1st class free!

My teaching method is very simple yet very powerful. Approach is to go step by step clearing all the doubts at the same time...

Classes by webcam Face-to-face classes Approved profile
Faridabad
Oracle pl/sql haivng 5 years of experience with teaching skills in delhi/ncr
₹1,000
Arun
1st class free!

I will tach you topic by topic. I will teach not only theoretical but also practical as well and we will not moved to the...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Give Computer Science Tuition's for Students in Colleges and schools in Delhi
₹800
Noman
1st class free!

I believe with the practical teaching methodologies with good student-teacher interaction. I can teach to students of 11th,...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Software Engineer with a Reputed MNC firm in Noida and gives Tuitions in Delhi/NCR for subjects - SQL, MySQL, Basic Computer, Excel, Tableau, C, C++ etc.
₹900
Mayank
1st class free!

My teaching methodology is practical than thereotical. I make the student understand basics in a very good maner so he/she...

Classes by webcam Face-to-face classes Approved profile
New Delhi
A software Developer working with iOS-Swift  java and SQL with more than 6 year experience
₹600
SHUBHAM
  • (6 reviews)
1st class free!

I am a software developer working on iOS APP Development also have good knowledge of JAVA and SQL DATABASE.AnyBody who want...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Get Coaching for Computer Languages, M.S.Office, and Basic in Delhi
₹450
Prabhu Dayal
  • (1 review)
1st class free!

I have completed MCA.I have 3 years experience in computer training. I have worked with NIIT and IIHT as a trainer. I...

Face-to-face classes Approved profile
New Delhi
Senior Software Developer with Expertise in Computer Programming, Wanna Learn Some Coding?
₹500
Shubham
1st class free!

I start with very basics of the subject. I explain each and every algo being used in the coding. Using my real time working...

Classes by webcam Face-to-face classes Approved profile
Delhi
Classes for computer subjects for which students are willing to attend are welcome
₹500
Shivangi
1st class free!

I teach practically mostly because it's easy to get computers through practicals.. I used to teach students of class 11th...

Classes by webcam Face-to-face classes Approved profile
Delhi
A proficient in computer languages gives tuitions in Computer Science and related technological languages in Delhi.
₹500
Chaitanya
1st class free!

The classes are majorly for anyone who shows an interesting in gaining the knowledge related to computers and the major...

Classes by webcam Face-to-face classes Approved profile
New Delhi
IT Professional with 27+ years experience giving Software development, Project management & MS office related knowledge
₹900
Mukesh
  • (4 reviews)
1st class free!

My teaching method simply involves getting right into the practical application post learning the basic theory. Anyone can...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Tuition for Big data analytics , R programming, Data science, Machine Learning, Hadoop Analytics
₹500
Sathya seelan
1st class free!

My teaching methodology is practicals through the real time test data. Basic theory only for few classes. Online tests and...

Classes by webcam Face-to-face classes Approved profile
New Delhi
An engineering student with proficiency in computer languages teaches SQL in Delhi.
₹700
Kriti
1st class free!

-My teaching methodology focusses first on the basics of the concept and then steadily studying advanced concepts. Also, I...

Classes by webcam Face-to-face classes Approved profile
New Delhi
Hi, I have 6year of experience in teaching : Hindi, Computer, SQL database and HTML.
₹200
Arvind
1st class free!

I am engineer and teacher and having 6 year experience in teaching. I have from New Delhi. I also coach free classes to...

Classes by webcam Face-to-face classes Approved profile
New Delhi
IITian with Mathematics Background and working Professional. The skills you'll learn- Python, Data Visualization Tools(Tableau), Big Data Analysis, Basic Data Science
₹600
Nitin
1st class free!

Skills - Machine Learning, SQL Python, Data Analysis, Numpy, Pandas, Matplotlib, Plotly, Sk-Learn, Big Data(ELK STack),...

Classes by webcam Face-to-face classes Approved profile
at his home at your home By webcam
1 hour ₹950 ₹1,350 ₹650
Unfortunately, this teacher is not available