Sql business intelligence development studio

SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO SOFTWARE

Responsible for gathering requirements, analysis, design, functional & technical specification, coding, testing and documentation of new module development.

Good Communication and interpersonal skills wif strong ability and experience in seeking solutions effectively in challenging environments.Дeveloper Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Visual Studio, BCP, Team Foundation Server (TFS)Д®TL & Reporting: SSIS, SSRS, SSAS, Excel, Power View, PowerPivot, TableauДatabases: MS SQL Server, Oracle, MySQL, MS Access.

Designed and developed QlikView and Qlik Sense dashboards by extracting data from different sources like SQL Server, Excel files, Oracle, SAP, Flat Files, XML Files.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Proficient in SSAS (Analysis services) functions like calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles wifin a cube.

Experience wif SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard for monitoring and tuning MS SQL Server performance.

Experience in designing and developing complex reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and Ad-hoc reports for Business Users using SQL Server Reporting Services (SSRS).

Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise Manager.

Expertise in merging data from various Heterogeneous Data sources, populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Experienced in implementing various logic using objects like Tables, Joins, Views and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML).

Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.

Hands-on experience wif Star & Snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.

Expertise in developing SQL Server databases wif T - SQL for constructing Triggers, Tables (DDL), Joins, Cursors, User Functions, Views, Indexes, User Profiles, Relational Database Models (RDBMS), data dictionaries and data integrity.

SQL BUSINESS INTELLIGENCE DEVELOPMENT STUDIO SOFTWARE

Acquainted wif all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

7 years of experience as Microsoft Business Intelligence Developer involved in developing solutions using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

Sql business intelligence development studio