Business intelligence development studio for mac

Business intelligence development studio for mac software#
Business intelligence development studio for mac code#

To keep track of data manipulations using Audit functionalities.

Created indexed views and appropriate indexes to reduce the running time for complex queries.

Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.

Monitored performance and optimized SQL queries for maximum efficiency.

Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.

Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.

Created the database for the reporting team.

Participated in developing logical model and implementing requirements on SQL Server 2012.

Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical requirements.

Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.

Created SQL Server Reports using SSRS for management.

Business intelligence development studio for mac code#

Testing of code functionality using testing environment.Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor.Documented the data such as entity relationships and attributes, file descriptions and definitions.Used different joins, sub queries and nested query in SQL query.Resolved production issues by modifying backend code as and when required.Creating views and prepares the Business Reports.Perform DML, DDL Operations as per the Business requirement.Analyzed business requirements and built logical data models that describe all the data and relationships between the data.

Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.

Installed SQL Server 2014 and Management tools using SQL Server Setup Program.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.

Business intelligence development studio for mac software#

Involved in Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.Flexible and versatile to adapt to any new environment and work on any project. *Strong inclination for finishing job before project deadline. User oriented with a desire to learn client's business requirements. Team-oriented, technically motivated and creative. *Experience in deploying created reports in various sources like Web browser, XML and PDF. *Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions. *Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions. *Standardize data collection by developing methods for database design and validation reports. *Proficient in the use of query and reporting analysis tools. *Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. *Works on multiple tasks/projects as team member. *Provides design support for the development of business intelligence solutions. *Evaluates and refine Business Intelligence goals, business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives. *Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan. *Demonstrated expertise in MS SQL Server 2012/2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts. *Strong DBA/Development skills writing T-SQL scripts, worked extensively on ETL process using DTS, SSIS packages, handling data quality issues and generating various types of reports using SSRS on OLAP databases.

*Proficient in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Created various Complex Formula Reports to query the database for business Intelligence. *Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). Over 5 year of IT Experience in Database Design and Bi development on MS SQL Server 2014, 2012,2008 versions on various development, test and production environments with various business domains.