User talk:Ocprohit

Rohit Shrivastava ocprohit@yahoo.com ocprohit@gmail.com

Objective To advance in the field of Information Technology as a fine Oracle Professional.

Summary•	More than 6 year 8 months of rich experience in oracle PL/SQL, and SQL. •	Expertise in development and maintenance of Oracle objects like Tables, Packages, Procedures, Functions, and Triggers etc. •	Strong knowledge of Oracle DBA performance optimization and tuning activities and daily tasks. •	Expertise in Object-Oriented Analysis, Design and Application, Development, Functional Specification. •	Strong knowledge in RDBMS like Oracle, SQL Server, experience and expertise in PL/SQL, and SQL. •	Strong knowledge of Oracle 9i Forms. •	Strong practical knowledge of Job automation tool Autosys. •	Client Interaction, Project management & strong team leading skills with high productivity. •	Knowledge of Informatica and Datastage tools.

Academic Profile •	M.C.A. (Regular Course) with 74.5 % from Guru Ghasidas University Bilaspur (C.G) India in 2003. •	B.Sc. in Mathematics (Regular Course) with 59.16% marks from Government post graduate college, Sehore from Barkatullah University, Bhopal In 1999. •	Higher Secondary (12th) with 74% marks From CBSE In 1996. •	High School (10th) with 60 % marks from CBSE In 1994.

Certifications •	Oracle 9i Certified Developer Professional       ( D2K Track) ( Covers SQL,PL/SQL, Forms 9i )

•	Oracle Certified Database Administrator Associate ( DBA Track ) Technical Skills

Operating Systems      	:		MS DOS, Windows 95/98/2000, UNIX RDBMS	:		Oracle 9i Languages                    	:    		C, C++, SQL. Front end	:		Oracle Developer Forms DBMS	:		Microsoft Access 2000, SQL Server 2000 Tools 	:		Autosys, Toad, Sql developer, Informatica, Datastage. Awareness                  	:		Computer Networking, Digital Circuits, Data Structures and Software Engineering, OOAD, SAD, Computer Architecture.

Professional Experience: Summary Of Leading Projects

Job Duration 	:	July 2006 – Till Date Present Company	:	Tata Consultancy Services Limited, Mumbai, India

Job Duration 	:	Dec 2005 – July 2006 Present Company	:	3i Infotech Private Limited (Formerly ICICI Infotech), Mumbai, India

Job Duration 	:	July 2005 –Dec 2005 Present Company	:	Sony Entertainment Television, Software Division, Mumbai, India

Job Duration            	:  	July 2003 – July 2005 Company                   	:  	Matrix Technologies, Indore (M.P.), India

Relevant Experience	: 	6 Years 8 Months in Oracle PL/SQL Development and Oracle Database Design and optimization.

Responsibilities       	: 	To design and manage the of database systems and provide critical support to the business. To manage the team and resources for support and development activities. To develop oracle objects; Tables, Packages, Procedures, Functions, Views etc and to optimize database to get maximum performance.

Projects Completed (in reverse chronological order):

1.	Project Title : CMG-CRD Global Wealth Investment Management

Developed For 	: 	Bank Of America, USA. Developed By 	:       	Tata Consultancy Services Ltd, Bangalore Duration                          	:  	August 2009 – Till date Software and platform    	:  	Oracle 9i, Autosys Team Size	:  	15 Role                                     :        	Project Leader

The project objective is to develop and maintain the CRD application database with latest information, which is used by the Charles River application end users. The CRD database receives multiple files which are automatically loaded by using the autosys tool.

Contribution: •	Involved in development of Database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Involvement in problem solving in the automated load of data to oracle data base. •	Provide full time critical support from offshore to the Business. •	Automation of batch related activities. •	Scheduling and management of resources. Suggesting solutions to the batch related problems.

2.	Project Title : Siperian – Data Hub

Developed For 	: 	Merrill Lynch Investment Managers, USA. Developed By 	:       	Tata Consultancy Services Ltd, Mumbai Duration                          	:  	December 2008 – August 2009 Software and platform    	:  	Oracle 9i, Autosys, Data stage,UNIX Team Size	:  	20 Role                                     :        	Project Leader

The project objective is to develop and maintain the Siperian HUB. Siperian is a tool used to build and maintain data warehouse of client and portfolio information of Blackrock. The Siperian database receives multiple files from different sources including PATH and KD applications which are automatically loaded by using the Autosys and Datastage tools. These loads need to be monitored all the time to prevent the batch from failing and to correct the errors on time.

Contribution: •	Involved in development of Database objects; Tables, Views,Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization and tuning to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Development of load and extract procedures and integrate them with UNIX. •	Involvement in problem solving in the automated load of data to oracle data base. •	Provide full time critical support to the Business. •	Automation of batch related activities. •	Scheduling and management of resources. Suggesting solutions to the batch related problems.

3.	Project Title : Eagle Pace – Data Hub

Developed For 	: 	Black Rock Asset management Company, London (UK) Developed By 	:       	Tata Consultancy Services Ltd, Mumbai Duration                          	:  	April 2007 – November 2008 Software and platform    	:  	Oracle 9i, Autosys, Powercentre, UNIX Team Size	:  	15 Role                                     :        	Team Leader

Contribution: •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Involvement in problem solving in the automated load of data to oracle data base. •	Development of Oracle procedures for the load and export of data to various other systems. •	Solve the queries provided by business users. •	Provide full time critical support to the applications. •	As an onsite lead, direct involvement with business users to identify their requirements and suggest solutions.

4.	Project Title : Aviva Hibernian – Life Insurance

Developed For 	: 	Aviva Life Insurance, Ireland (UK) Developed By 	:       	Tata Consultancy Services Ltd, Mumbai Duration                          	:  	July 2006 – April 2007 Software and platform    	:  	Oracle 9i, Java Other Skills Used           	:   	Oracle 9i database development Team Size	:  	40 Role                                     :        	Module Leader (New Business Module).

The Project is developed as according to the requirements of AVIVA Life Insurance Company, UK. This System was developed to cater to the growing life insurance business of Aviva in UK, to help the Agents of the company to key new policies, enquire old policies and to help the company in automating the Policy Generation, Acceptance and Underwriting Processes. The system is one of the best and has helped Aviva achieve good business and save time.

Contribution: •	Involvement in the database development and design using oracle designer. •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization to get best performance and reduce load. •	Writing PL/SQL triggers so as to improve productivity and impose validation. •	Testing, providing technical support to team members and coding of the complex processes of system. •	Write the technical specifications for the business requirements.

5.	Project Title : Tangible Factoring Solutions – Banking Products

Developed For 	: 	Clients who are involved in Factoring Business Duration                          	:  	December 2005 to July 2006 Software and platform    	:  	Oracle 9i, Java Other Skills Used           	:   	Oracle Database design .Oracle PL/SQL Development Team Size	:  	15 Role                                     :        	Team Member.

The Project is developed and customized as according to the needs of clients of 3i-infotech in Banking Domain who are involved in the business of factoring solutions. The clients include SBI Bank in India and many other banks in Middle East and Asia.

Contribution: •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Writing PL/SQL triggers so as to improve productivity and impose validation. •	Testing, providing technical support to team members and coding of the complex processes of system. •	To continuously check and update the product so that it is widely acceptable with fewer requirements for customization.

6.	Project Title : System For Automated Management Of Broadcast Activities

Developed For 	: 	Sony Entertainment Television (In-house Development) Duration                          	:  	July 2005 to December 2005 Software and platform    	:  	Oracle 9i, Oracle PL/SQL, Oracle Forms Developer Other Skills Used           	:   	Oracle 9i database development Team Size	:  	20 Role                                     :        	Team Member.

Sony Entertainment Television is one of the prime broadcast group of channels including SET Max, SAB TV and others about 14 channels and has a wide distribution, marketing and customer base. To manage its operations, this software was developed for the real time scheduling of its programmes and commercials as well as to keep track of all the revenues and earnings from different operations

Contribution: •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization and tuning to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Writing PL/SQL triggers so as to improve productivity and impose validation. •	Testing, providing technical support to team members and coding of the complex processes of system. •	Involved in the coordination groups to understand the In-house needs which improve the productivity with introduction of new features in the system.

7.	Project Title : Employee Record Management

Client	: 	Ruchi InfoTech, Indore (Madhya Pradesh) Developed By 	:       	Matrix Technologies, Indore. Duration                          	:  	February 2004 to June 2005 Software and platform    	:  	Oracle 9i, Oracle Forms Developer Other Skills Used           	:   	Oracle 9i database development Team Size	:  	14 Role                                     :        	Team Leader.

The project involved setting up a real time data acquisition system using oracle and d2k for the     employees of Ruchi group companies (involved in multiple areas including steel manufacture, Soya oil manufacture etc.). I was responsible for developing the oracle forms which acquire data from the employee using online entries as well as from the database and storing the data in Oracle. Timely generation of reports was also a key feature.

Contribution: •	On site study of the existing system. •	Information Gathering and preparing software requirement and functional specification. •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization and tuning to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Testing, providing technical support to team members and coding of the complex processes of system.

8.	Project Title : Inventory Management System

Client	:  	Standard Electrodes limited, Bhopal (Madhya Pradesh) Duration                        	:    	July 2003 to Jan 2004 Software and platform   	:   	Oracle 9i, Oracle Forms Developer Other Skills Used          	:   	Visual Basic Team Size	:  	12 Role                              	:   	Team member /Oracle forms developer

The project involved the automation of inventory management system of standard electrodes limited, which is a company involved in manufacture of welding electrodes.

Contribution: •	On site study of the existing system. •	Information gathering and preparing software requirement and functional specification. •	Strongly involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. •	Involved in Database Optimization and tuning to get best performance and reduce load. •	Involved in optimization of SQL queries and PL/SQL code to reduce response time and improve performance. •	Involved in development of oracle forms and preparing guidelines for team members. •	Testing, providing technical support to team members and coding of the complex processes of system. •	Writing PL/SQL triggers so as to improve productivity and impose validation based on latest trends in inventory management. •	Involved in user training to explain the functionality and to understand the user desired functions which might be incorporated in the system.

Onsite experience

•	One year in London as an onsite Team leader for Eagle Pace Data Hub. As a team leader, I was involved in providing all round support for the intraday and overnight automated load of data and also in solving the critical queries related to Business. I was also involved in development and maintenance of database objects; Tables, Views, Packages, Procedures, Functions, Triggers etc. and in optimizing the Oracle database.

Speedy deletion nomination of Rohit Shrivastava
A tag has been placed on Rohit Shrivastava requesting that it be speedily deleted from Wikipedia. This has been done under section A7 of the criteria for speedy deletion, because the article appears to be about a person or group of people, but it does not indicate how or why the subject is important or significant: that is, why an article about that subject should be included in an encyclopedia. Under the criteria for speedy deletion, such articles may be deleted at any time. Please see the guidelines for what is generally accepted as notable, as well as our subject-specific notability guideline for biographies. You may also wish to consider using a Wizard to help you create articles - see the Article Wizard.

If you think that this notice was placed here in error, you may contest the deletion by adding  to the top of the page that has been nominated for deletion (just below the existing speedy deletion or "db" tag), coupled with adding a note on the talk page explaining your position, but be aware that once tagged for speedy deletion, if the page meets the criterion, it may be deleted without delay. Please do not remove the speedy deletion tag yourself, but don't hesitate to add information to the page that would render it more in conformance with Wikipedia's policies and guidelines. Lastly, please note that if the page does get deleted, you can contact one of these admins to request that they userfy the page or have a copy emailed to you. Shashwat986 (talk) 10:38, 11 March 2010 (UTC)

Svs sri nilayam
Hello ,

It seems to me that an article you worked on, Svs sri nilayam, may be copied from http://svsconstructions.in/svs-palms.php. It's entirely possible that I made a mistake, but I wanted to let you know because Wikipedia is strict about copying from other sites.

It's important that you edit the article and rewrite it in your own words, unless you're absolutely certain nothing in it is copied. If you're not sure how to fix the problem or have any questions, there are people at the help desk who are happy to assist you.

Thank you for helping build a free encyclopedia! MadmanBot (talk) 17:29, 7 October 2013 (UTC)

Speedy deletion nomination of Svs sri nilayam


A tag has been placed on Svs sri nilayam requesting that it be speedily deleted from Wikipedia. This has been done under section G12 of the criteria for speedy deletion, because the article or image appears to be a clear copyright infringement. This article or image appears to be a direct copy from http://svsconstructions.in/svs-palms.php. For legal reasons, we cannot accept copyrighted text or images borrowed from other web sites or printed material, and as a consequence, your addition will most likely be deleted. You may use external websites as a source of information, but not as a source of sentences. This part is crucial: say it in your own words. Wikipedia takes copyright violations very seriously and persistent violators will be blocked from editing.

If the external website or image belongs to you, and you want to allow Wikipedia to use the text or image — which means allowing other people to modify it — then you must verify that externally by one of the processes explained at Donating copyrighted materials. If you are not the owner of the external website or image but have permission from that owner, see Requesting copyright permission. You might want to look at Wikipedia's policies and guidelines for more details, or ask a question here.

If you think this page should not be deleted for this reason, you may contest the nomination by visiting the page and clicking the button labelled "Click here to contest this speedy deletion". This will give you the opportunity to explain why you believe the page should not be deleted. However, be aware that once a page is tagged for speedy deletion, it may be removed without delay. Please do not remove the speedy deletion tag from the page yourself, but do not hesitate to add information in line with Wikipedia's policies and guidelines. —Largo Plazo (talk) 17:31, 7 October 2013 (UTC)


 * Even apart from the copyright violation, |Wikipedia is not for advertising or promotion of any kind. JohnCD (talk) 17:51, 7 October 2013 (UTC)