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.
*Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
*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.
*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.
*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.
*Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
*Evaluates and refine Business Intelligence goals, business objectives, decision support needs, data and performance requirements to meet departmental/project level objectives.
*Provides design support for the development of business intelligence solutions.
*Works on multiple tasks/projects as team member.
*Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
*Proficient in the use of query and reporting analysis tools.
*Standardize data collection by developing methods for database design and validation reports.
*Evaluates and validate quality of performance on completeness of Business Intelligence models and solutions.
*Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions.
*Experience in deploying created reports in various sources like Web browser, XML and PDF. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
*Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
Languages: SQL. HTML, XML. MySQL, Oracle 11g/10g/9i, MS SQL Server 2016/14/12/08, DB2 v8.1.