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 APPLICATION DEVELOPER SQL SERVER 2012 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.
0 kommentar(er)
