Certified SQL SERVER BI (SSIS, SSAS, SSRS) consultant AVAILABLE IMMEDIATELY

Request: please take a minute and add a...@svksystems.com in your mailing list for current and future requisitions.

Please scroll down to know for other available consultant Technologies.

 

Consultant Name

Bharath

Skill

Certified Sr Sql Server BI ( SSIS, SSAS, SSRS, ETL) Developer

Availability

Immediate

Total Exp

7+  Years

Relocation

Open

Current Location

VA

 

PROFESSIONAL SUMMARY 

·          7+ years of experience in IT industry as a SQL Server Developer/BI 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.

§          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 Creating SSIS Packages and migrating DTS Packages from SQL 2000 to SQL 2005.

§          Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.

§          Proficient in handling parameterized reports in SSRS 2008.

§          Created ETL packages using SSIS to move data from various heterogeneous data sources.

§          Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

§          Implemented error handling and roll back process in ETL load.

§          Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

§          Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

§          Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS

§          Worked with Financial companies for application related pricing and security applications

§          Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented  Snow Flakes Schema and Star Schema

§          Experience in integrating the SSRS reports into web applications using Report viewer control

§          Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube

§          Transformed data from one server to other servers using Bulk Copy Programming and Data Transformation Services

§          Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.

§          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.

 

  Certifications:

§          Microsoft SQL Server 2008 Implementation & Maintenance

 

  Technical Skills:

SQL Server Tools                          : SQL Server Enterprise Manager, T-SQL, Data Transformation  Services (DTS), SQL Server Query Analyzer, SQL Server Agent,  SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server 2008                                                       Reporting Services (SSRS), DBCC, BCP, SQL Server Profiler

ETL                                                   : DTS, SSIS

Reporting Tool                               : SSRS, Crystal Reports, Business Objects

Programming Languages             : C, C++, Java,T-SQL,PL-SQL

Databases                                        : MS SQL Server 2005/2008, Oracle 9i/10g, MS Access 2000/2003

Data Modeling Tool                      : Erwin, Microsoft Visio 2000/2003

Operating System                          : Windows server 2003, Windows NT/2000/XP, Windows 98

Backup Tools                                  : LiteSpeed, Veritas.

 




AVAILABLE CONSULTANTS - JAVA |.NET |SHAREPOINT | SQL SERVER BI DEV/DBA | COLDFUSION | BO ADMIN / DEV | UI / GUI DEVELOPER |REMEDY |JAVA ADOBE FLEX  | COGNOS | BA | WEB DESIGNER |PEGA | ETL INFORMATICA | QA | SAS | ACTUATE DEV|

Thanks & Regards

ANIL  KUSHNAPALLI

SVK Systems, Inc

11465, Johns Creek Parkway, Suite #180,

Johns Creek, GA - 30097

Direct :205-267-5716 ext 517

Cell    : 205 510 7431

Fax    : 404-601-9507

[email protected]

www.svksystems.com



Safe Unsubscribe :
This email was sent to [email protected] by [email protected].
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 Anil Kushnapalli: [email protected] 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.

--
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.

Reply via email to