Excellent SQL Server BI (SSIS/SSRS/SSAS) Developer Available Immediately.

4 views
Skip to first unread message

Mahesh [With LLC]

unread,
Jan 5, 2016, 2:46:02 PM1/5/16
to echecs-et...@googlegroups.com

Happy 2016,

 

Excellent SQL Server BI (SSIS/SSRS/SSAS) Developer AvailableImmediately.

 

Request:please take a minute and add mah...@withllc.comin your mailing list for currentand future requisitions.

 

Pleasescroll down to know for other available consultant Technologies.

 

Consultant Name

Nikitha

Skill

SQL Server BI (SSIS/SSRS/SSAS) Developer

Availability

Immediate

Total Exp

8 Years

Relocation

Open

Current Location

AL

 

Summary:

·         Around 8 years of experience as MS-SQL Server Developer in data modeling, data design, database

·         Programming, Development and Support of SQL Server for OLTP/OLAP/ETL environments.

·         Extensively worked on data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP.

·         Excellent knowledge in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands. 

·         Very good knowledge in designing database objects like Tables, Views, Constraints, Indexes and defaults.

·         Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling.

·         Implemented SQL Server Indexing, Index tuning using Index Tuning Wizard and Tuning Advisor

·         Excellent knowledge in performance tuning and query optimization Using SQL Profiler, Execution Plan,

·         Performance Monitor.

·         Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.

·         Experience DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Performance Tuning.

·         Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).

·         Created several Staging Databases.

·         Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities

·         Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying   the packages across Dev/UAT/Prod environments.

·         Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations

·         Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

·         Involved in adding KPI’s, Calculated Aggregates, Actions and Partitions.

·         Involved in Installation ,Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008 across various environments

·         Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.

TECHINCAL SKILLS:

Operating Systems:

Windows XP/2000/2003 Server/Vista/7             

RDBM/Databases:

MS SQL Server 2005/2008

Programming Languages:

T-SQL, Dynamic SQL,C

Data Modeling :

MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MS- Access.

Data Design Tools:   

ER/Studio, ERWIN, MS Visio.

BI Tools:

SQL Server Reporting Services (SSRS 2005/2008/2012), SQL Server Integration Services (SSIS 2005/2008/2012), SQL Server Analytical Services (SSAS 2005/2008), Visual Studio, BIDS.

Tools/Database Utilities:

 

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, Visual Studio Team Foundation Server (TFS)

Application Packages:

MS Office, Microsoft SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, ProClarity

 

Regards,

 

Mahesh

WITH LLC
Phone: 732-730-5630 | Fax: 517 827 4908
4700 S Hagadorn Rd, STE 195-K, East Lansing, MI - 48823  
Email ID:
mah...@withllc.com | Web: www.withllc.com

CONFIDENTIALITYNOTICE: This e-mail message, including any attachments, is for the sole use ofthe intended recipient(s) and may contain confidential and privilegedinformation. Any unauthorized review, use, disclosure or distribution isprohibited. If you are not the intended recipient, please contact the sender byreply e-mail and destroy all copies of the original message. 



Safe Unsubscribe :
This email was sent to echecs-et...@googlegroups.com by mah...@withllc.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 Mahesh [With LLC]: mah...@withllc.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.
Reply all
Reply to author
Forward
0 new messages