Description
Professional Summary: * 7+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2005, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS, SSRS and Data-warehousing. * Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008 * Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity. * Extensive knowledge of Normalization and Relational Database Management Systems. * Good understanding in database and data warehousing concepts (OLTP & OLAP) * Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). * Great ability to create and manage various database objects like tables, views. * Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions. * Experience in Performance Tuning and Query Optimization. * Experienced in using ETL tools in (SSIS) MS SQL 2008, MS SQL 2005 and DTS in MS SQL 2000 * Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. * Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task. * Data analysis and data migration by transferring them using SSIS packages. * Experience with logical and physical data modeling and database design using Erwin. * Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS). * Experience in modifying MDX Cubes and Dimensions in SSAS. * Created sophisticated calculated members using MDX queries designed and created aggregations to speed up queries and improve performance in SSAS. * Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. * Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler. * Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). * Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill down reports using SSRS. * Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. * Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.
Accomplishments
Highlights:
Job Skills
Keywords
