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.