Venkatesh R.

Database Developer

60 dollar
Freelancer
8 years
Pune, INDIA

My experience

More

UnileverAugust 2013 - Present

Client: Unilever
Responsible for design and implementation. Provide thought leadership and architectural expertise to a cross-functional team in charged with deploying a host of customer-related applications and data to the cloud.

RESPONSIBILITIES
* Coordinating the Developing activities with the development team And QA team.
* Writing and worked on complex stored procedures, triggers, functions and views.
* Performance Tuning.
* Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
* Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
* Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio.
* Used Table variables inside functions and stored procedures.
* Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications
* Performed data import and data transformation activities.
* Create functions to provide custom functionality as per the requirements.
* Created Indexes on Tables in order to improve the Performance.

My stack

Computer Tools

Microsoft Excel

Languages

TCL/TK, T-SQL, SQL

Others

Teamwork, Design

Technologies

TortoiseSVN

IT Infrastructure

Git

Databases

Microsoft SQL Server

Business Intelligence

SQL Server Integration Services, SQL Server Reporting Services, ETL

Other

MS-SQLServer 2008r2, Bachelors Degree > Bachelor of Technology, Version Control, Back End, DML, Indian > Tamil, Indian > Telugu, Indian > Hindi, Stored Procedures, communication skills, Microsoft SQL Server 2008, Microsoft Access, industry~it, English, Data Warehousing, most of the SQL Server Enterprise Manager, resolution planning, Good Inter Personal skills, Error handling, Analyst/Programmer, develop jobs, Microsoft Transact-SQL

My education and trainings

Bachelor of Technology - Jawaharlal Nehru Technological University