HOTLIST: SQL BI(SSIS/SSRS/SSAS) Consultant Available Immediate

Name: VINAY

Location: CA

Available Immediate

Open to relocate

 

Professional Summary

 

·         Highly experienced Business Intelligence Professional using SQL server 2005 and 2008 offering over 7 years of commercial experience working for various organizations within several industries such as health, manufacturing, supply chain management, banking, retail and private

·         Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS)

·         Diagnosed query optimization, client/server connectivity, and running database consistency checks using DBCC Utilities

·         Developed database objects such as tables, views, stored procedures, triggers, row-level audit tables, cursors, indexes, user-defined data-types, functions, constraints

·         Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages

·         Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

·         Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP

·         Experience in Database Backup and Recovery

·         Debugging Stored Procedures, Views, User Defined Functions and Triggers

·         Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon

·         Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects

·         Experience in writing Multidimensional Expressions (MDX) and used the MDX queries in the report generation

·         4+ years’ experience in working with Reporting tools like Crystal Reports, Microsoft Reporting services, (SSRS)

·         Experienced in Development and Deployment of Reports (Tabular forms, Matrix (Cross Tab report) form, Conditional, List Items, Charts and Sub Reports) using SSRS

·         Experienced in SharePoint providing central management, governance, and security controls for implementation of project requirements

·         Experience with software development life cycle (SDLC) and project management methodologies.

·         Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements

·         Possess excellent management skills of outstanding decision making with excellent verbal and written communication skills

·         Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients

 

Technical Skillset

 

RDBMS/Data Access	MS SQL Server, SSIS, SSRS, SSAS 2005/2008 R2
Development Tool	BIDS, SSMS, VSTS 2008/2010, Report Builder 2.0/3.0
Language	C#, VB, C++
Reporting Tools	SQL Server 2005/2008 /R2 Reporting Services, Report Builder 2.0/3.0, Excel
Web Technologies	ASP.NET, JavaScript, HTML , XML, XSLT, SOAP, WSDL, CSS,  Web Services, Ajax
Source Control	Source Depot, CVS
Operating Systems	XP, Vista, Server 2003/2008, window 7

 

 

 

 

Regards,
 
Rao

Key Business Solutions, Inc.

|| Phone: 916 668 9539|| Fax: 916 646 2081 || || Email: rao@key-soft.com || Website: www.key-soft.com ||

Note: This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.

P   7 Ways You Can Easily Save Paper and Avoid Killing the Environment