Ramanuj Shah

Background

About Ramanuj Shah

More than 7 years of total experience in IT Industry which includes Business Intelligence, software development, maintenance involving the system study, analysis, development, implementation, documentation, service management, and transition management. 5+ years experience in Business Intelligence which includes SSIS and SSRS. Onsite exposure to Client site (Australia and Austria) Experience in migration of databases from older versions of SQL Server (2005) to SQL Server 2012. Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages. Performed several transformations and data cleansing on data including fuzzy lookup, union all, merge join and check points/break points. Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization. Expert in designing reports using SQL Server Reporting Services (SSRS). Adept in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports. Experience in configuring report manager for creating report subscriptions, snapshots, and caching. Excellent experience in Designing, Maintaining & Tuning various RDBMS like SQL server 2012. Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance. Excellent interpersonal communication, problem solving, documentation and business analytical skills. A multi tasking analytical thinker with the ability to work on fast paced work Environment. 6 months experience in Informatica 9.1.