An SQL Developer with 5+ years of IT experience in database design, development, and administration with MSSQL Server 2016/2014/2012/2008/2005/2000 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS)
- Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
- Strong knowledge and Experience in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
- Expert in creating Power pivots, power query, Power views, and SSRS reports using tabular model (DAX), Cubes (MDX), and SQL queries.
- Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance.
- Experience in Dimensional Modelling, Designing of STAR, SNOWFLAKE Schemas.
- Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
- Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages, and Backup/Restore of a database.
- Experienced in creating Quick Table Calculations, Static and Dynamic sets, Parameters, and Level of Detail using advanced logical and statistical functions in Tableau Desktop.
- Experienced in URL Actions, passing parameters from Tableau to web applications.
- Highly proficient in design and development of prototype reports/ dashboards in Tableau during the requirement gathering phase to visualize the reports and clarify requirements.
- Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
- Worked Extensively on ETL process using SSIS package.
- Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries, and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
- Generated different reports using MS SQL Reporting Services and Crystal Reports.
- Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
- Expertise in SQL Server Analysis Services (SSAS) for Developing Tabular Model, Creating Measures, Key Performance Indicator, Hierarchies, Attribute Relations, Creating Prospective and Translations.
- Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modelling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
- Excellent knowledge in creating Databases, Tables, Stored Procedures, Common Table Expression (CTE), Views, User defined data types, functions, Cursors and Indexes using T-SQL.
- Expertise in Power BI, Power BI Pro, Power Bi Mobile.
- Expert in Creating and developing Power Bi Dashboards in to rich Look.
- Knowledge in all types of Database migrations with all the versions of SQL Server.
- Have basic knowledge on Informatica Power centre Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, and XML Source Qualifier.