Responsibilities: Designed, developed, and maintained relational databases.•Expert in analyzing, designing, developing, installing, configuring, and deploying My SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008, and SQL Server Integration Services.•Experience in using recursive CTEs, CTE, temp tables, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency and support the existing applications.• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers,Queries and Macros using MySQL Server 2008 and MS Access databases Involvedin Partitioning tables that have bulk inserts, deletes, and updates to improve theperformance•Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.•Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.• Expert in generating writing parameterized queries, drill through reports, and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.

The purpose of the work was to collect data from web pages containing citation information for a given publication and to get the related parameters like user name, author name and title of the paragraph and year of the publication. The collected information is converted and loaded into a relational database. The citation database can get aggregated data about authors and papers.