• Responsible for creating critical compliance test analysis documents and Business Re-quirement Documents (BRD).• Created the Complex SQL Queries, User Functions, stored procedures, CTE’s, Views, In-dexes also created schema and Tables Using SSMS 2016. • Involved in writing complex SQL queries with multiple table inner and outer joins, tem-porary tables, table variables.• Rigorously tested and debugged the Stored Procedures and used Triggers to test the va-lidity of the data after the insert, update or delete.• Involved in Normalization and De-Normalization of existing tables for faster query re-trieval.• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.• Working on live site issues to fix slow running stored procedures, triggers etc. and pro-vide Root cause analysis.• Experience in Data Analysis, understanding trends and patterns in data.• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, vari-ous other data sources to MS SQL Server by developing SSIS (SQL Server Integration Ser-vices) packages.

• Analyzed company’s business practice and product performance to determine potential growth.• Involved in creating database objects – Tables, Indexes, Views, User defined functions, Parameterized Stored Procedures.• Wrote many stored procedures for cleaning, manipulating, and processing data between the databases.• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.• Extensively used SQL queries to translate data into valuable information for decision making. • Created SSIS packages to implement error/failure handling with row redirects.• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and Generated Named calculations and named queries.• Experience in Designing, Building the Dimensions, cubes with star schema, snowflakes schema using SQL Server Analysis Services (SSAS) for analyzing purpose.• Created partitions and designed aggregations in Cubes.• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS)

• Experience in using SQL Server tools like SQL Server Management Studio, SQL Server Data Tools, and SQL Server Visual Studio.• Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.• Use DDL and DML for writing triggers, stored procedures, and data manipulation• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.• Error handling using Try-Catch Block. • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server.• Design SSAS Cubes storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.• Creating Ad Hoc and Parameterized Reports using SQL server Reporting services.

• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.• Part of team for analyzing and implementing the physical design for the database.• Responsible for drafting documentation for describing the metadata and writing technical guides.• Created Stored Procedures, Triggers, Views and SQL Joins and other statements for vari-ous applications.• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.• Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Ser-vices (SSAS) and Reporting Services (SSRS).• Involved in designing cubes in SSAS environment using Snowflake/ and Star Schemas.• 2008.• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, and Sub re-ports using SQL Server Reporting Services 2008.• Created SQL Server Analysis Project using MS SSAS 2008.

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.• Involved in designing Flow charts, office layout for the business users and professionals using VISIO.• Created SQL reports, data extraction and data loading scripts for different databases and schemas.• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.• Wrote Transact SQL utilities to generate table insert and update statements.• Involved in performance tuning and monitoring of T-SQL blocks.• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures