Preethi Sivakumar Email & Phone Number

Karlsruhe, Baden-Württemberg, Germany

Project Name ALICO ATLASResponsibilities/Tasks

Project Name Quality MetricsResponsibilities/Tasks * Implemented complex conceptual database design and database architect into SQL Server 2005/2008 using various constraints and triggers * 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 ; * Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube * Scheduled and maintained routine jobs, tasks, and alerts ; * Stored procedures, efficient triggers, required functions and indexes for performance ; * Error and Event Handling using precedence constraints, break points, check points and logging ; * Unit testing and Integration testing for various modules ; * Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table ; * Created complex stored procedures to generate reports using SSRS ; * Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexesTools Used: * SSIS, SSRS, SSAS and SQL Server 2005 /2008 * C#, VB.Net * Autosys and SQL server agent jobs.

Project Name Consolidated Data RepositoryResponsibilities/Tasks * Designed and analyzed the SQL Server database and involved in gathering the user requirements ; * Logical and Physical design of database for project on basis of user requirements ; * Created new tables, stored procedures for Application Developers and some user defined functions ; * Created SQL scripts for tuning and scheduling ; * Performed data conversions from flat files into a normalized database structure ; * Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) * Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, Slowly Changing Dimension * Used custom .NET assemblies for Script Task in SSIS ; * Designed and implemented Dimensions and Measures according to business requirement ; * Automated the SSIS packages using SQL server agent jobs, triggered emails to notify the users about the job execution * Stored procedures, efficient triggers, required functions and indexes for performance ; * Error and Event Handling using precedence constraints, break points, check points and logging ; * Used SQL Server Analysis Services (SSAS) to design cubes for summary reports ; * Unit testing and Integration testing for various modules ; * Created Triggers to enforce data and referential integrity ; * Defined Check constraints, Business Rules, Indexes, and Views ; * Created complex stored procedures to generate reports using SSRSTools Used: * SSIS, SSRS, SSAS and SQL Server 2005 /2008 * C#, VB.Net * Autosys and SQL server agent jobs

Chennai Area, India