SAP MSBI Consultant Resume Dallas Texas - Hire IT People

PROFESSIONAL SUMMARY:

Having around 5 years of IT experience in Microsoft Technologies SQL Server 2008.
Having 5 years of experience in SSIS, SSRS, SSAS.
Extensively worked on Microsoft Business intelligence suite.
Involved in creation and debugging of Complex SSIS packages using different kinds of sources and destinations.
Experienced in using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
Experienced in using Microsoft SQL Server Management Studio (SSMS)
Knowledge of relational and multi - dimensional database schemas
Having good knowledge on creation and scheduling of Sql server agent jobs to run daily ETL’s. T-SQL (Design & Development)
Expertise in writing T-SQL (DDL, DML) queries, stored procedures, database triggers and exception handlers
Expertise in Normalization and De-Normalization techniques
Performance tuning of stored procedures and slowly running queries
Upgrading DTS packages to SSIS 2005 and 2008 Packages
Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS hAccess, Oracle, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP & Bulk Insert utilities
Experience in providing logging, error handling by using event handler and custom logging for SSIS Packages.
Experience in performance tuning in SSIS packages by using row transformations, block and unblock Transformations
Experience in scheduling and monitoring ETL processes using DTS Exec utilities and batch files.
Extensively used control & data flow transformations like OLEDB command, execute SQL task, sequence generator, derived column, conditional split, lookup and script component task etc.,
Expert in generating drill down reports, parameterized reports, linked reports, sub reports, filters, charts using SQL Server Reporting Services, MS Excel.
Experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder
Experienced in using global variables, expressions and functions for the reports.

TECHNICAL SKILLS:

ETL Tool: SQL Server 2008,2012 Integration Services.

Reporting Tools: SQL Server 2008,2012 Reporting Services.

Analysis Services: SQL Server 2008,2012 Analysis Services.

RDBMS: SQL Server 2008.

Languages: PHP, HTML, CSS, C++, python, VB

Operating Systems: Windows9x, NT, 20003 server and XP,Windows7.

Utilities: MS Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas Texas

SAP MSBI Consultant

Responsibilities:

Creating staging database for temporary processing of data, consolidating data and Loading into Target database using Integration services.
Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.
Scheduling Jobs to execute SSIS packages.
Writing the Stored Procedures.

Environment: SQL Server 2008, SSIS, Windows 2003 server

Confidential

MSBI Consultant

Responsibilities:

Creating staging database for temporary processing of data, consolidating data and Loading into Target database using Integration services.
Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Sort and Execute SQL Task to load data into Database.
Scheduling Jobs to execute SSIS packages.
Writing the Stored Procedures.
Scheduling reports using Reporting services to e-mail with an attachment in the desired format of report to the top management.
Developing parameterized reports including multi-parameters.
As per the requirements, rendering the Reports in the form of Excel and .CSV formats for each module with credentials.

Environment: SQL Server 2008, SSIS, SSRS, Windows 2003 server

We provide IT Staff Augmentation Services!

Sap Msbi Consultant Resume

Dallas, TexaS

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship