Shiva Shankar V.

• Implemented replication between SQL Server 2005 and SQL Server 2008 to put only result portion to end-users. Client wanted to work offline and keep separate data for each branches. It was then synchronized with database on the web. • Designed and developed Crystal reports for a Finance company, to analyze the increase in the earned revenue on a monthly basis and help the Management to draw business plans on the basis of these reports. • Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table. Built MDN Dashboard and BA Dashboard Reports on the Microsoft Analysis Services Cube using MDX by using SQL Server Reporting Services. • Involved in writing MDX queries and performance optimization of the SSAS cubes. Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX. • Provided consultations on developing software solution for import-export trading company. The project was developing a database to store all their vendors and customers, their transactions and workflow to manage day-to-day business. • Developed a tax-engine to calculate taxes based on latest Tax-law changes; It was developed using VB.NET with MS-Access as backend. It is now migrated to MS SQL server 2008. • Developed a movie database using ASP.net and SQL Server 2008. Registration done on the basis of paid subscription. Database of movies containing thousands of records. Many types of users with different roles to manage the database. • Currently working on analyzing existing data warehouse reporting, and developing a custom application to publish the contents of the data dictionary via clients Intranet.