Career Objective:

To work with an organization that encourages me to grow by providing challenging , exciting and competitive work opportunities.

Summary:

• B.E (Computer Engineering).
• Total Experience of more than 5 years in application of Oracle (SQL ,PLSQL)
• Experience in handling Quality related work like attending audits,Process Improvements.
• Received a certificate, as an appreciation of work as the best person in my team.

Educational Qualifications:

B.E. (Hons )(Computer Engineering)

Professional Experience:

Organization

Confidential

Period

Dec 2005 to Aug-2011

Total Experience

5 Years 10 Months

Skill Set:

Operating Systems

Basics of Unix and basic shell scripting

Languages

Oracle (SQL, PL/SQL )

Version Control Systems

VSS, CVS

Project Details:

Overview:

Project Thesis

Project

IDV Overnight

Customer

Confidential

Period

Dec-2010 to Aug-2011

Solution Environment

Oracle 11g

Tools

SQL Developer, SQL Navigator, Version one ,WINSCP,PUTTY

Description

IDV is a backend process which runs in Oracle and processes data by each browsing session and assigns a member to that session from that household. Each household will have several members and anyone from that home can use the PC for browsing, we will have several modules which will analyze the activity within that session on different parameters and assign a score for that module to that session, after that total weighted score is calculated for each member in that household and person with maximum score becomes the winner for that browsing session.
Prime objective of this project to reduce the time taken by existing IDV processing.

Role

Team Lead

Highlights

Major responsibilities in this project are listed below :

• Creating procedures in oracle.
• Writing SQL scripts
• Writing shell scripts
• Code Review
• To ensure on time code delivery
• Testing of Optimized code in terms of data as well time taken by the process.

Project

Ad Relevance Rewrite

Customer

Confidential

Period

Feb-2009 – Nov 2010

Solution Environment

Oracle 9i, Netezza Performance Server,SQL Server 2005

Tools

PL/SQL Developer, SQL Navigator, SQL Workbench , Version one ,WINSCP,PUTTY

Description

Ad Relevance project captures online ad’s by running its application on Internet , and provides analysis of the Advertisement to the Advertiser publishing an Ad on various sites. Earlier there were two applications maintained by Nielsen. However, intent of this is to develop a single standalone system for all countries. Currently, this exists as AdR – US and AdR – International.

AdR – International system was built in SQL Server 2005 while Adr – US exists in Oracle.

Role

Team Lead / Developer

Highlights

Major responsibilities in this project are listed below :
· Creating procedures in oracle.
· Writing SQL scripts
· Writing shell scripts
· Writing Netezza to Oracle Shell script for loading tables

• Converting Existing Ad – International code which is in SQL server with US as baseline (which is in oracle)
• Scheduling jobs using cronjobs
• Data Migration

Project

P2.2 QA – Tools

Customer

Confidential

Period

Sep – 2008 to Feb – 2009

Description

This project is to be used by Nielsen Online QA users for flexibility in their internal purposes.
Through this project, i worked as developer and have written scripts and procedures for loading data from Netezza into the Oracle and also handled the Databases for different QA Tools ((BASEQA,SEARCHQA,RETAILQA and LOCALQA)) and prepared reports using Java for these tools.

Role

Developer

Highlights

Major responsibilities in this project are listed below :
· Writing database queries for QA Tools
· Handling of QA Tools databases
· Creation of Production databases for QA Tools
· Writing Netezza to Oracle Shell script for loading tables which are required by QA Tools from Netezza in to the Oracle.
· Writing of import scripts for loading data from mirror db’s into QA tool’s DB.And front end reports for these tools using Java
· Production support during monthly data loading from Netezza to Oracle for QA Tools

Project

Ultimatix-Globalnet

Customer

Confidential

Period

Feb-2006 to Sep-2008

Description

Through Globalnet, I was quality coordinator for project, also was leading Advance module of Ultimatix – Globalnet. Ultimatix-globalnet system dealt with all associates deputed onsite.

Role

Software Developer/Module Leader/VQAF.

Highlights

During my tenure in this project, I worked in different roles as Team member (Production Support Executive and Software Developer) , Module Leader for GlobalNet-Advance Module and VQAF (Quality co-ordinator for GlobalNet)
Major responsibilities in this project are listed below:
· Requirement Gathering and Analysis.
· Solution Design.
· Coding (Front-End and Back-End).
· Testing.
· Work distribution among the team members.
· Review of the Work performed by the team members.
· Monitoring the Expensing of GlobalNet data to TCS General Ledgers.
· Organizing & Conducting Knowledge Sharing Sessions for GlobalNet team members.
·Handling Quality part of project like attending audit, Project management activities.

Certifications
The details of certifications.

Date

NCFM – Beginners Module

6-Mar-2008

1Z0-007 Introduction to Oracle9i: SQL

29-Aug-2008