Certified SQL Server BI Developer SSIS, SSRS,SSAS available Immediately

on

Good Afternoon,

 Request: please take a minute andadd eric@svk-inc.com in your mailing list for current andfuture requisitions.

 

Consultant Name

Prasunna

Skill

Certified SQL Server BI Developer SSIS, SSRS,SSAS

Availability

Immediate

Total Exp

8+  Years

Relocation

Open

Current Location

CA


 

·         Summary: 8+ years of IT experience in the design, development, working experience MS SQL Server 2008/2005(SSIS, SSAS, SSRS)/2000/7.0, MDX, Database Migration, Database Administration, Physical/Logical design, T-SQL, Performance-Tuning, Troubleshooting, Backups and Restore of databases.

·         Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.

·         Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.

·         Created SQL Server reports using SQL Server Reporting Services (SSRS).

·         Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).

·         Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.

  • Experience in OLAP, OLTP, ODS, Snowflake schema, Star schema, ETL, MDX, Data mining, DBMS and Data Modeling.
  • Expertise in ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment

·         Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.

  • Experience with SQL Admin activities such as Installation, Configuration, maintenance, support, backup, recovery, Log Shipping,  Performance Tuning of SQL Server

·         Experience in building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server.

  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects

·         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 generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008

·         Expertise in generating reports using Business Objects 6.5/XI, Crystal Reports and SQL Server Reporting.

  • Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production servers.
  • Have excellent communication skills and have a strong experience in customer service support skills with ability to adapt to changing requirements.
  • Expert in developing data queries to interpret business requirements.
  • Have a strong experience in telecom industry and tele-communications field.
  • Developed reports from OLAP cubes using ProClarity and SSRS.
  • Involved on ProClarity's powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.

·         Worked on ProClarity to create OLAP data sets and queries are created directly from the Unified Dimensional Model.

·         Worked on ProClarity for creating, analyzing and deploying Reports.

  • Used ProClarity for analysis services in some cases.
  • Created simple Reports using SSRS, ProClarity.

·         Experience in ProClarity's powerful visualization tools, including the Decomposition Tree, Perspective View and Performance Map, to drill down, cross drill, pivot, chart, and investigate data.

·         Created views, books and libraries in ProClarity web professional.

 

 

Education:

  • B.S, Electronics & Communication Engineering Jawaharlal Nehru Technological University

Technical Skills:

Languages                        :                  T-SQL, PL/SQL, C, C#, Java, HTML, XML, VB script.

Operating Systems       :                 MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX

RDBMS/ Databases      :                MS SQL Server 7.0/2000/2005/2008, Oracle 8i/9i, Teradata

Applications                   : Pragmatic Works tools like BixPress, DocxPress and Task Factory, MS Team Foundation Server

Data Warehouse Tools:                 OLAP, SQL data transformation services (DTS)

Data Modeling and ETL tools:       ERWIN, MS Visio

Reporting Tools:                               Microsoft reporting server, Business Objects, Performance Point

Microsoft Technologies:               VB.Net, ASP.NET.

SharePoint Products and

Technologies:                                    MOSS 2007, WSS v3, SharePoint Designer 2007, 2010 and BizTalk.

 

 

 

 

 

 

 

Regards

 

Eric Dixon

Business Development Executive

SVK Systems, Inc.

Ph: 678 824 7753  Fax: 404-601-9507

eric@svk-inc.com : www.svksystems.com

 

If you donot want to receive email from me, please reply to this email with REMOVEin the subject

 

 



Safe Unsubscribe :
This email was sent to vikaschidura69.itstaffingus@blogger.com by eric@svk-inc.com.
Instant removal with SafeUnsubscribe | Privacy Policy.
Email Marketing by
mailsonics.com
NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include the contact information for removal from our mailing list. To be removed from our mailing list please click above SafeUnsubscribe link or reply to Eric Dixon: eric@svk-inc.com with 'remove' in the subject heading and your email address in the body. Include complete address and/or domain/aliases to be removed.

If you still get these emails, please call us at the numbers given above, my sincere apology.