SUMMARY

• Around 8 years of technical and functional expertise in Application/ Software Maintenance & Production Support.
• Sound knowledge of SQL, ETL and Data Warehousing methodologies and experience in using Microsoft Business Intelligence stack (SSIS, SSAS, SSRS, SSMS)
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle)
• Strong experience in Database installation, Capacity Planning, Implementing Backup and Recovery Strategy by Mirroring & Replication for applications and database.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Experience in troubleshooting and resolving database integrity, performance issues, blocking and deadlocking, connectivity, security issues etc
• Excellent in High Level Design ofSSISPackages for performing ETL operations on data from heterogeneous data sources by using multiple transformations provided bySSIS
• Experience in deployment and performance tuning of SSIS packages
• Experience in maintenance and Administration ofSSISby creating Jobs, Alerts, SQL Mail Agent and scheduleDTS/SSIS Packages.
• Experience in working withSSASin creatingmultidimensional cubes, data source views, named queries, dimensions, facts, partitions and deploying of analysis services projects
• Experience in StarandSnow Flake Schemas.
• Good experience in writingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS).
• Excellent technical and analytical skills with clear understanding of design goals of ER modelling for OLTP and dimension modelling for OLAP
• Sound understanding of BI/Reporting best practices/methodologies in developing and designing reports throughSSRSandExcel
• Expert in Ad - hoc reports, drill down and drill through SSRS reports and cross tab reports.
• Experience building analytic reports against an Enterprise Data Warehouse platform
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Views, Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
• Expertise inPerformance tuning, Optimization, Data integrityandStatisticsby usingSQL Profiler
• Involved inUATand Integration testing withQAteam and good experience in AGILE /SCRUM
• Ability to understand advanced concepts in data modelling and how those data models support business concepts and business metrics
• Good understanding of Inmon top down approach and Kimball bottom up approach
• Have good knowledge on cloud platforms like AWS (Amazon web services), Azure and bigdata technologies like Hive, Pig, HDFS and databases like Teradata and Oracle
• Ensure proper documentation and on-time delivery of all functional artefacts and deliverables
• Strong customer relationship skills with experience interfacing with customers to refine reporting requirements and build trusted relationships.
• Excellent problem-solving analytical, communication, presentation and interpersonal skills that help me be a core member of any team and passionate about innovation

PROFESSIONAL EXPERIENCE

SQL BI Developer

Confidential - Florida

Responsibilities:

• Involved in complete database design including conceptual, logical and physical models.
• Administrator tasks like managing users, roles and permissions.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Created SSIS packages for loading the data from Excels files, which get triggered when users upload files
• Enable error handling strategy i.e. transaction isolation to help rollback of transaction when package fails.
• Create various file and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation.
• DevelopedSSISTemplates which can be used to developSSISPackages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Deployed and scheduled SSIS ETL packages using SQL server job agent
• Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Designing, Analysing, building and testing of OLAP cubes in SSAS using Star Schema
• Created aggregations on SSAS cube partitions, partitioned per month to have increased performance.
• Deploying cubes using SQL Server Analysis Services(SSAS) involving multidimensional data.
• Created SSRS reports to retrieve data using Stored Procedures, MDX Queries that accept parameters.
• Developed dashboard reports usingSSRS Reporting Services, Report Model and ad-hoc reporting usingReport Builder.
• Written Parameterized Queries for generating SSRS reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports
• Scheduled SSRS reports to run weekly, quarterly, monthly based on the client requirement
• Automated the monthly reports and reduced the effort time
• Responsible for Monitoring and Tuning SSRS Report performance.
• Wrotestored proceduresandUser Define Functions (UDFs)to be used in the SSIS packages andSQL scripts.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Monitored the system utilization and checking the execution plan to improve the performance.

Environment: SQL Server 2012, SQL Server 2016, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Profiler, Excel, .NET, VB Scripting, SSMS

Sr. SQL Server SSIS/ SSAS Developer

Confidential - Tampa, Florida

Responsibilities:

• Migrated data from different sources (text based files, Excel spread sheets, Oracle) to SQL Server databases using SQL Server Integration Services (SSIS).
• Involved in the ETL phase of the project.
• Scheduled ETL packages using SQL Server Job Agent.
• DevelopedMultidimensional Objects(Cubes) using SQL Server Analysis Services (SSAS).
• Implemented MS Analysis Services setup, tuning, cube partitioning, Dimension design.
• Defined appropriate measure groups andKPIs&deployed cubes
• Created calculated measures and dimension members using multidimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Involved in Writing SQL Queries, Views and Stored Procedures

Environment: SQL Server 2012, Windows 8, MDX, T-SQL, SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), Visual Studio 2012, SSMS

Confidential

SQL Server/SSAS/SSIS/SSRS Developer

Responsibilities:

• Extract Transform and Load (ETL)source data into respective target tables to build the required datamarts
• Extracted and reviewed data from (Flat files, Teradata) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Scheduled Daily and weekly ETL Jobs and Alerting using SQL Server Agent.
• Identified thedimension,fact tablesand designed thedata warehouseusingSnowflake Schema.
• DevelopedMultidimensional Objects(Cubes) using SQL Server Analysis Services (SSAS).
• Created Hierarchies in Dimensional Modelling for cube with proper Attribute relationships.
• Involved in creating calculated members, Named Queries, Named Calculations in SSAS cube
• Created Partitions and Aggregations dynamically using Analysis Services Processing Task and Analysis Services Execute DDL Task and Fine-tuned SSAS cube.
• Defined appropriate measure groups andKPIs&deployed SSAS cubes.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services
• Created many complex store procedures/functions and used them in SSRS reports directly to generate reports on the fly
• Used SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2008R2, Teradata, MDX, T-SQL, SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SSRS, SQL Profiler, ADO .NET, SSMS

ETL Developer

Confidential

Responsibilities:

• Created staging database for temporary processing of data, consolidating data and Loading into Live database using Integration services(ETL).
• CreatedSSISPackages by using different dataTransformations likeDerivedColumn, Lookup,ConditionalSplit, Pivot, Union and ExecuteSQLTaskto load data intoDatabase.
• Based on design document created simple and complex SSRS reports.
• Scheduling the jobs to send the SSRS reports.
• Involved in the Stored Procedures, functions, triggers and DTS packages creation.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008R2 SSIS Packages.

Environment: SQL Server 2008R2, SSIS, SSRS, SQL, Excel, SSMS

SQL Developer

Confidential

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created queries for generating reports in SSRS
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL

Environment: SQL Server 2008, TSQL

Confidential

Responsibilities:

• Mapping roads and giving directions and routing ps according to heat map and satellite imagery
• Solving the bugs in the software and ensuring effective functioning of the application.
• Done Quality analysis of data.