Good Afternoon!
Certified Sr SQL BI (SSIS SSRSSSAS) Developer AVAILABLE IMMEDIATELY
Request: please take aminute and add ravi@svk-inc.com in your mailing listfor current and future requisitions.
Please scroll down to know for other available consultant Technologies.
| Consultant Name | Sravani | ||||||||||
| Skill | Certified Sr SQL BI (SSIS SSRS SSAS) Developer | ||||||||||
| Availability | Immediate | ||||||||||
| Total Exp | 7+ Years | ||||||||||
| Relocation | Open | ||||||||||
| Current Location | Fremont, CA | ||||||||||
| | Professional Summary: · 7+ years of strong experience with demonstrated success in the Database Design, development of SQL Server 2000/2005/2008R2/2012. · Expertise with DDL and DML statements, RDBMS's, data dictionaries and normal forms. · Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks. · Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling. · Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. · Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs. · Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs. · Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems · Excellent understanding of data mining algorithms, high performance and optimal algorithms. · Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources. · Extensive experience in writing MDX Scripting and MDX Queries. · Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. · Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints. · Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. · Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent. · Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers. · Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008. · Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS). · Solid Knowledge in developing cubes using Partitions, KPI's, and Perspectives, slow changing dimensions (SCD) etc and created various user roles (SSAS). · Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security. · Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). · Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS. · Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008/2012. · Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2005/2008/2012 Analysis Services. · TECHNICAL SKILLS:
|
REQUEST: Kindlysubmit our consultants to your direct client's only, as we don't work withlayers ie: Prime vendors / Gate Keepers / Implementation partners of yourcompany. Violation of this clause gives us the right to withdraw the submissionfor that particular requisition without your consent.
Thanks & Regards
B Ravi Kumar
Sr.IT Recruiter
SVK Systems, Inc.
11465, Johns Creek Parkway,
Suite #180 Johns Creek, GA – 30097
Ph: 678 824 7754 Fax: 404-601-9507
ravi@svk-inc.com : www.svksystems.comg-talk: svk.ravi007@gmail.com
If you do not want to receive email from me,please reply to this email with REMOVE in the subject
|
| |||||
| 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 Ravi Kumar: ravi@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. | ||||||
