* SQL BI Developer AVAILABLE IMMEDIATELY* **
*REQUEST**: **please take a minute and add **[email protected] ** in
your mailing list for current and future requisitions.***
* Please scroll down to know for other available consultant
Technologies.*
*Consultant*
*Skills*
*Exp*
*Location*
*Availability*
Preeti
*SQL BI*
7+ Years
OR
Immediately
*Summary*
· Over 7+ years of experience in Database Development of *MS SQL
Servers 2000/2005/2008*, in Production, QA, and Development environments.
· Extensive experience in Data-Warehousing projects as a Business
Intelligence developer worked in *SQL Server Reporting Services (SSRS)*, *SQL
Server Integration Services (SSIS)* and *SQL Server Analysis Services (SSAS)
SQL Server 2005/2008*.
· Very good understanding of SQL Server Architecture Design.
· Excellent backend skills in creating SQL objects like Tables, *Stored
Procedures*, *Views*, *Indexes*, Triggers, user defined data types and
functions.
· Experience in Creating *SSIS* and *DTS* package development and
implementation for different tasks.
· Experience in pulling the Data from XML Files, Excel, Flat file,
Oracle to MS SQL Server by using *MS SQL Server DTS* and *SSIS (2005/2008)*.
· Experience in migrating DTS Packages to SSIS using DTS using DTS
Exchange.
· Extensive Knowledge in tuning T-*SQL* queries and improving the
performance of the database Application
· Strong experience in creating *complex Stored Procedures*,
Replication, Index, Functions, DTS packages, triggers, cursors, tables,
views and other SQL joins and statements.
· Experience in loading Facts and Dimensions using SSIS Packages on
Data warehousing projects.
· Expert in creating SQL Server Reports using *SSRS 2005* in
designing report layout parameterized, performance, Chart Reports, ad-hoc
reports.
· Extensively worked with Parameterized Reports, Report Snapshots,
and Linked Reports and used Report Manager for deploying reports in *SSRS
(2005/2008).*
· Experience in report writing according to the business requirement
in SSRS.
· Very strong experience in ad-hoc reports using Report Builder 2.0.
· Experience in *SQL SERVER 2005 Analysis services*/*OLAP Design* &
*Implementation*.
· Familiar with *OLAP* cubes and fact table, star and snowflake
schemas
· Experience in Building *Multi Dimensional Cubes*, *Data Modeling*,
and *OLAP* *Cubes* using *SSAS*.
· Maintained production *OLAP* *cubes*, wrote *MDX* queries to
generate reports using SQL Server *2008* Reporting Services.
· Experience in MS SQL Server configuration manager, performance
tuning, SQL Profiler, client/server connectivity, query optimization,
back-up/recovery, running Database Consistency Checks using DBCC.
· Experience in designing and developing large number of enterprise
reports *(SSRS/Business Objects)* using the data from *ETL* *loads*,
*SSAS*Cubes and various heterogeneous data sources.
· Worked on all phases of data warehouse development lifecycle, from
gathering requirements to Unit testing, implementation, and support.
· Experience in creating packages, Jobs, Sending Alerts using SQL
Mail.
· Used Microsoft Source Safe for version control and configuration
management.
· Experience in using tools like *TOAD*, *PL/SQL Developer*, and SQL
Developer.
· Knowledge of Server Components using *.NET Framework* and *Visual
Studio 2005.*
· Strong communication skills and ability to work in a team and
individually.
* *
* *
* *
*Technical Skills *
* *
*Databases*:**
SQL Server 2008/20005/2000, Oracle 10g/9i, DB2, MS-Access 2000**
*SQL Server Tools*:**
Enterprise Manager, Query Analyzer, Export & Import (DTS), Business
Intelligence Development Studio, SSMS, ETL Tools, SQL
Profiler**
*Operating System***
Maintained production OLAP cubes, wrote MDX queries to generate reports
using SQL Server 2005 Reporting Service Server, Sp3, UNIX, Linux**
*Languages:***
C, PHP, T-SQL, PL/SQL, HTML, JavaScript, C#, .NET.**
* *
*Other Tools*:**
SQL Loader, ERWIN, ER Studio, Microsoft Visual Source Safe(VSS),
ProClarity,
Performance point, Microsoft Office, Microsoft
Viso, MS Visual Studio2003/2005/2008**
* *
Regards,
Ritesh Doddle
SVK Systems, Inc |Microsoft & Oracle Certified Partner
Ph : 205-510-7424 x 530 / Email:-*[email protected]*
11465, Johns Creek Parkway, Suite #180
Johns Creek,Georgia, 30097
Open my eyes that I may see wonderful things in your law.
— Psalm 119:18 <http://www.searchgodsword.org/desk/?query=Psalm+119%3A18>
--
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.
