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

Kranthi

Skill

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

Availability

Immediate

Total Exp

7+  Years

Relocation

Open

Current Location

NJ

 

PROFESSIONAL SUMMARY 

  • 7+ years of experience in the IT industry as a SQL Server Developer 2000/2005/2008.
  • Extensive experience in designing, development, implementation and administration of database systems using MSSQL Server 2000/2005/2008 for Batch Processing, Online Processing and Data warehousing Systems (SSRS, SSIS, SSAS).
  • Extensively worked on Normalization and De-Normalization techniques for both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
  • Experienced in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various Data Definition Language (DDL) and Data Manipulation Language (DML) commands.
  • Expert in writing Complex T-SQL queries, dynamic-queries, sub-queries and complex joins.

ยท         Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.

  • Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split and Derived columns.
  • Strong experience in using Data modeling for designing the logical and physical data models.
  • Worked extensively in designing, deploying and maintaining cubes in the data warehouse using SSAS.
  • Strong experience in creating MDX queries for SQL Server Analysis Services (SSAS).
  • Worked extensively on designing and maintaining data cubes using ODBC to access data from heterogeneous databases.
  • Expert as a Data modeler focusing on high-activity, normalized transaction systems (OLTP), de-normalized reporting systems as well as staging areas and data marts.
  • Highly experienced with Erwin tool and strong knowledge of Relational database modeling and dimensional database modeling concepts also expert in designing of logical and physical data modeling.
  • Expert in implementing star and snowflake schema methodologies.
  • Expert in creating Business Intelligence reports, defining queries for generating drill down reports, parameterized reports and in designing report layout using SQL Server Reporting Services (SSRS) 2005/2008.
  • Expert in handling parameterized reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
  • Strong experience on DTS, SSIS packages and jobs for MS SQL Server databases.
  • Highly experienced on evaluating existing DTS packages on SQL 2000 and upgrading them to SQL 2005 SSIS packages.
  • Expert in using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), SSIS, SSRS and SSAS with MS SQL Server 2000/2005/2008.
  • Experienced in Performance Tuning, Query Optimization and running database on SQL Server.
  • Excellent verbal and written communication skills with interpersonal skills and possesses strong analytical skills.

SKILLS:

 MS SQL Server 2008/2005/2000, Microsoft Integration services (SSIS), Analysis services (SSAS), Reporting services (SSRS), SharePoint Server, DTS 2000, MS SQL Server Management Studio 2005, MS Visio, Windows 95/98/NT/2000/XP, C ,C++, SQL, T-SQL,C#.NET, HTML, DHTML, ORACLE 7.x /8i, 9i, 10g , PL SQL,MS-Access,  Erwin Data Modeler r7.3, MS-Office



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 |BAAN |OBIEE |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