Certified SQL Server BI Developer (OLAP/SSAS/SSIS/SSRS) consultant available immediately
Please Call Anil Kushnapalli (205-267-5716 ext 119) or e-mail [email protected] , if you have any requirements. Please scroll down to know for other available consultant Technologies. Consultant Name Srikanth S Skill Certified SQL Server BI Developer (OLAP/SSAS/SSIS/SSRS) Consultant Availability Immediate Total Exp 7+ Years Relocation Open Current Location AL . 7+ years experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding, SSIS/SSRS/SSAS,OLTP and OLAP . Expert in installing, configuring, monitoring and troubleshooting MS SQL server 2000/2005/2008. . Good hands on exposure with SSAS, SSIS and SSRS in SQL Server 2005 and 2008. . Expert in developing stored procedures, functions, triggers, views, optimizing queries, table normalization . Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval. . Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS 2005 and 2008. . Experience in designing high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata . Experience in Creating SSIS Packages and migrating DTS Packages from SQL 2000 to SQL2005. . Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008. . Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2008/2005. . Proficient in handling parameterized reports in SSRS 2008. . Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting. . Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager. . Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations. . Experience in working with SSAS in creating data source views, named queries, dimensions and deploying of analysis services projects. . Transformed data from one server to other servers using Bulk Copy Programming and Data Transformation Services . Experience in creating packages, jobs, sending alerts using SQL Mail and customized extended procedures. . Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures. . Expert in creating normalized databases, authentication, query tuning, assigning proper indexes creating stored procedures, functions, triggers and data types. . Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Index Tuning Wizard, DBCC commands, Statistics. Technical Skills: Databases MS SQL server 7.0/2000/2005/2008, Oracle, Teradata, MS Access Languages Transact- SQL, SQL,HTML, XHTML, C, PERL,UNIX Operating Systems Windows NT/98/2000/XP/Vista/2003, MS-DOS OLAP/Reporting Tools SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), MDX, Crystal Reports 9/10/XI, Business Objects 6.x, Cognos ETL Tools SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica. Other Tools Erwin, Microsoft Visual Source Safe, Microsoft Office, MS Visio. Data Modeling Tools Erwin tool, Microsoft Visio 2000/2003 SQL Server Tools SQL server Management Studio, SQL server Query Analyzer, SQL server mail service , DBCC, BCP , SQL server profiler AVAILABLE CONSULTNATS - JAVA |.NET |SHAREPOINT |BIZTALK |SQL SERVER BI DEV/DBA COLDFUSION| SAN ADMIN | BO |HYPERION |UI / GUI DEVELOPER |REMEDY |TERADATA |C++ | POWER BUILDER |ADOBE FLEX | WEBSPHERE ADMIN | COGNOS | UNIX LINUX ADMIN | BA |ORACLE DBA | ORACLE DEV | WEB DESIGNER | Thanks & Regards ANIL KUSHNAPALLI SVK Systems, Inc 8415 crossland loop, Montgomery, AL - 36117 Direct :205-267-5716 ext 119 Cell : 201-604-3582 Fax : 404-601-9507 <mailto:[email protected]> [email protected] www.svksystems.com <http://www.svksystems.com/> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en -~----------~----~----~----~------~----~------~--~---
