* 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*
Anusha
* SQL BI*
7+ Years
CA
Immediately
*Summary*
Ø *7+ years* of IT Experience in Database Design, Development and
business intelligence of Microsoft *SQL Server 2008/2005/2000* in
Development, Test and Production Environments with various business domains
like healthcare, financial, pharmaceutical and manufacturing.
Ø Expertise in writing *T-SQL* Queries using joins, Sub queries and
Cursors in *MS SQL Server 2000/2005*.
Ø Experience in Extracting, Transforming and Loading (*ETL*) data from
Excel, Flat file, Oracle to MS SQL Server by using *BCP* utility, *DTS* and
*SSIS* services.
Ø Expertise in enhancing and deploying the *SSIS* Packages from
development server to production server.
Ø Excellent *T-SQL* development skills to write complex queries
involving multiple tables, great ability to develop and maintain stored
procedures, triggers, user defined functions.
Ø Extensively used Report Wizard, Report Builder and Report Manager
for developing reports and deploying reports in *SSRS*.
Ø Expertise in report writing according to the business requirement in
*SSRS*.
Ø Expert in creating SQL Server Reports using *SSRS 2008* in designing
stylish report layout parameterized, performance, Chart Reports, ad-hoc
reports.
Ø Developing reports on *SSAS* & *SSRS* on *SQL Server
(2000/2005).*Sound Experience and understanding of
*SSAS*, *OLAP* cube and Architecture.
Ø Expert in creating the *MDX* cubes and dimensions.(*SSAS*)
Ø Hands on experience on all phases of Software Development Life Cycle
(*SDLC*) of Data warehousing, including requirement gathering from business
users, analysis, design, creation of mapping documents, specification
writing, development, testing, and implementation.
Ø 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 different type of reports including Tabular forms,
Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary,
List items, Charts and Sub Reports.
Ø Experience in Logical modeling using the Dimensional Modeling
techniques such as Star Schema and Snow Flake Schema. Experience in creating
multidimensional cubes using *SSAS* (SQL Server Analytical Services) and *
OLAP* (Creating Cubes) including interfaces with *BIDS*.
Ø Monitored and Tuned MS SQL Server databases with tools like Index
Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal
Performance.
Ø Experience in managing and automating control flow, data flow,
events and logging programmatically using Microsoft *.NET *framework for *
SSIS* packages.
Ø Knowledge on integration of BI suite of products with Microsoft
Office range of products like *MOSS (SharePoint)*, Business Scorecard
Manager, Dashboards, Performance Point Server.
Ø Excellent skills in designing Logical and Physical Modeling using
ERWIN.
Ø Strong analytical, administration and problem solving skills
dedicated to maintain the high quality standards. Good communication skills,
ability to work independently.
* *
*TECHNICAL SKILLS***
Ø *Database Tools* *:* SQL Enterprises Manager, SQL
Profiler, Query Analyzer SQL
Server setup,
Security Manager, Service Manager, SQL Server
Analysis Services
(SSAS).
Ø *ETL Tools* *:* Data Transformation Services
(DTS), SQL Server 2008/2005/2000
Integration Services
(SSIS), Import Export* *Data, Bulk Insert, BCP.
Ø *Data Modeling Tools : *ERWIN 7.3, Power Designer 12.5, ER
Studio 8.0.1, MS Visio 6.0.
Ø *Programming Language : *T-SQL, PL/SQL, C, C++,C#, Assembly,
HTML, Java
Script, XML, .NET
2.0, Visual Basic 6.0, Visual FoxPro 5.0.
Ø *Web Tools* *:* MS-Front Page, MS-Outlook
Express.**
Ø *Reporting Tools :* SQL Server Reporting Services
(SSRS), Crystal Reports
9/10, MS Access, MS
Excel.
Ø *Databases : *SQL Server 7.0 / 2000/ 2005,
Oracle 8i /9i/10g/11g, MS Access.
Ø *Operating Systems : *Windows 9x/NT/XP/Vista, MS-DOS,
UNIX, Linux
Regards,
Ritesh Doddle
SVK Systems, Inc |Microsoft & Oracle Certified Partner
Direct : 205-538-2350, Alt : 205-510-7424 x 530
Email:-*[email protected]*
11465, Johns Creek Parkway, Suite #180
Johns Creek,Georgia, 30097
Yahoo : riteshsvk
Sing to the LORD a new song, for he has done marvelous things; his right
hand and his holy arm have worked salvation for him.
Psalm 98:1 <http://www.searchgodsword.org/desk/?query=Psalm+98%3A1>
<http://www.searchgodsword.org/desk/?query=Psalm+136%3A1>
--
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.
