Description
Professional Summary: * 5+ years in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008R2/2008/2005/2000 in Development, Test and Production Environments with various business domains. * Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables and sub-queries including commands, Join, Views, Stored Procedures and Triggers. * Experience in all phases of SDLC like Requirement Analysis, Implementation and Maintenance, Extensively worked in various software methodologies such as Waterfall, Agile, and Scrum. * Strong experience in Query Efficiency Optimization using SQL Server Profiler and tuning performance. * Sound understanding of Agile and Waterfall Methodology including Sprint and Scrum. * Strong experience of Data Mapping, Data Modeling and Data Profiling. * Expert in creating and using Stored Procedures, Views, User Defined Functions. * Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective functions and appropriate Triggers to assist efficient data manipulation and data consistency. * Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS). * Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. * Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS. * Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages. * Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard. * Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS. * Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users. * Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), and MDX interactive Reporting. * Developed reports on SSRS on SQL Server. * Sound Experience and understanding of SSAS, OLAP cube and Architecture. * Expert in Performance Tuning and Optimization of SQL Server. * Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema. * Installed and configured Visual Studio for developing and testing environments. * Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement. * Strong experience in creating complex reports that use cascaded parameters. * Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. 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.
Accomplishments
Highlights:
Job Skills
Keywords
