Venkateswar R.

ABOUT ME

Experience Summary
 Having 13+ years of extensive experience in IT Industry in Analysis, Design, Development and Maintenance of various software applications in Data warehousing and .Net Technologies
 Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
 Experienced in full life cycle ETL development using SSIS.
 Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
 Experience working with huge databases in the volumes of Terabytes.
 Hands on Experience to Migrate the DTS Packages into SSIS.
 Expertise in providing Business Intelligence solutions in Data Warehousing using Cognos 8.0 Framework Manager, Report Studio and Query Studio.
 Experience as a developer in Microsoft .NET technologies using Visual Studio.NET, C#, ASP.NET, ADO.NET, XML, XSLT.
 Designed and mapped using Various SSIS Transformations like OLEDB Command, Conditional Split, Script, Multicast and Derived Column.
 Good knowledge on Oracle and SQL Server 2005/2008/2012
 Experience in migrating SQL Server SQL Server 2005 to 2008/2012.
 Experience in Physical Model and Logical Model by using Microsoft Visio.
 Experience in providing Logging, Error handling by using Event Handlers.
 Expert in installation of SSRS and Configuring Report Server.
 Expertise in generating reports using SQL Server Reporting Services (SSRS).
 Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler
 Experience in creating ad-hoc reports by using Report Builder in SSRS.
 Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
 Experience on writing the Stored Procedures, Functions and Views
 Experience on to Developing the T-SQL (Transact) Statements.
 Experience on Performance Tuning In Database and SSIS Packages.
 Strong Knowledge on Tableau.

SKILLS