Certified SQL SERVER BI (SSIS , SSAS, SSRS) consultant AVAILABLE IMMEDIATELY
Please Call Anil Kushnapalli @ ( 205-267-5716 ext 517) or e-mail [email protected] , if you have any requirements.
Please scroll down to know for other available consultant Technologies.
Consultant Name | Yeshwant |
Skill | Certified Sql Server BI ( SSIS, SSAS, SSRS) Developer |
Availability | Immediate |
Total Exp | 7+ Years |
Relocation | Open |
Current Location | Dallas,TX |
| PROFESSIONAL SUMMARY - 7+ years of professional experience in system analysis, design, development and testing in various projects executed in Client/Server and Data warehouse environments.
- Hands-on experience in Upgrade/Migration of MS SQL Server 2005 to 2008, 2000 to 2005 using any suitable approach
- Expert in creating various SQL server objects like database, schemas, tables, indexes, indexed views.
- Expertise in creating complex Stored Procedures (Dynamic and static), effective functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.
- Hands on Experience in using tools like Dynamic Management Views, Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.
- Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
- Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
- Developed, monitored and deployed SSIS packages.
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
- Created stored procedure for generating reports using SSRS.
- Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.
- Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
- Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000
- Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
- Strong inclination for finishing job before project deadline and maintaining security.
- Worked on Exception Handling with @@error and with Try/catch.
- Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
- Good SQL Server Administration skills using various backup recovery, replication, restoration and DTS servers, Model (simple, Bulk and full), database maintenance plan, user (NT/SQL) security authorizations and clusters creation.
- Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
- Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
- Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills and ability to acquaint to fast changing skills.
- Experience in interacting with business analyst and other front end developers.
- Expertise in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
- Experience using REDGATE to compare and synchronize all database objects.
CERTIFICATIONS: · Microsoft Certified in Designing Database Infrastructure Using SQL Server 2005 · Microsoft Certified in Administering and Managing SQL Server 2005 |
AVAILABLE CONSULTANTS - JAVA |.NET |SHAREPOINT |BIZTALK |SQL SERVER BI DEV/DBA COLDFUSION| SAN ADMIN | BO |HYPERION |UI / GUI DEVELOPER |REMEDY |TERADATA |C++ | POWER BUILDER |ADOBE FLEX | WEBSPHERE ADMIN | COGNOS | UNIX LINUX ADMIN | BA |ORACLE DBA | ORACLE DEV | WEB DESIGNER |
Thanks & Regards
ANIL KUSHNAPALLI
SVK Systems, Inc
8415 crossland loop,
Montgomery, AL - 36117
Phone : 205-267-5716 ext 517
Direct : 205-510-7431
Fax : 404-601-9507
[email protected]
www.svksystems.com
“Three sentences for getting success –Know more than others |Work more than others |Expect less than others –WILLAM SHAKESPEARE”
Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience.
--
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.
