Rajesh Gundavarapu Email & Phone Number

Easton, Ma, Us

Norwell, Ma, Us

Working as SQL Server BI Developer/Analyst creating Reports, Scorecards ,KPI's and Critical Dashboards usingSSRS ,Performance point server and Adhoc reports using Power Pivot and Report Builder 3.0.Creating OLAP cubes and build reports on top of these cubes.using SSAS and MDX.Integrating and maintaining Performance Point Dashboards in Sharepoint .

Monett, Missouri, Us

Worked in onboard project is a server-based, SQL database solution. Responsibilities include creating different Parameterized, Cross tab and ad-hoc reports using SSRS 2008, writing complex Stored procedures, tuning queries and Extract, Transfer and Loading (ETL) of data from flat file, XML, Oracle, etc using SSIS and performing daily DBA duties.• Successfully upgraded from SQL 2005 to SQL 2008 with side-by-side approach.• Configured SSRS in both Native and SharePoint mode.• Involved in creating the Domain model using Microsoft Entity Framework.• Writing SQL scripts for various daily database tasks like checking table fragmentation and reorganize/reindex, synchronizing data from one server to another etc.• Used Transparent Data Encryption (TDE) to encrypt sensitive data.• Used new XML data type for storing xml data and implemented XML indexing.• Improved the performance of the application by 22% by creating proper clustered, non clustered, covered indexes in a secondary file group (ndf) and partitioning.• Created Cross-Tab, Drill-down, Cascaded Parameterized, Charts and Sub-Reports • Created data models with Report Builder 2.0 to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables.• Used Expressions, Functions and wrote custom code using VB.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2008.• Created client side reports (RDLC) using Visual Studio 2008 for reports to be generated from session data.

offers a complete package of advanced technology-based solutions specifically designed for community financial institutions. They provide core data processing, item processing, check imaging and remote capture processing. Responsibilities:Monitoring the Production servers using Spotlight on SQL Server.Detection and resolving of blocking and deadlocks using Profiler, DBCC utilities and DMV's.Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.Used BCP command line utility to replicate a database.Used Recompile and with option query hints to avoid parameter sniffing problems.Improved query performance by adding covered indexes, adding file groups.Used sp_execsql, modified SET options to prevent recompilation of stored procedures.Used Red gate SQL Compare to create a report and SQL change script with schema differences between production, development and testing servers.Used Red gate SQL Data Compare to generate a script with data differences between production servers.Created standard Reports and Cross Tab Reports and Drill Through reports.Generated Reports using Global Variables, Expressions and Functions for the reports.Responsible for scheduling the subscription reports with the subscription report wizard.Created different chart reports helped in analyzing perfmon counters using SSRS 2008.Configured nodes and virtual server to set up Active/Active Clustering.Implemented Database Replication solution for Production critical application and synchronized the data with tablediff utility.Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Master'S Degree, Computer Engineering

Bachelor'S Degree, Electrical, Electronics And Communications Engineering