SUMMARY:

• Above 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 of SSIS Packages for performing ETL operations on data from heterogeneous data sources by using multiple transformations provided by SSIS
• Experience in deployment and performance tuning of SSIS packages
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule DTS/SSIS Packages.
• Experience in working with SSAS in creating multidimensional cubes, data source views, named queries, dimensions, facts, partitions and deploying of analysis services projects
• Experience in Star and Snow Flake Schemas.
• Good experience in writing MDX queries 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 through SSRS and Excel
• 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 in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler
• Involved in UAT and Integration testing with QA team 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, Oracle and MongoDB
• 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 Server Developer

Confidential - Nashville

Responsibilities:

• Design, build, and support all components of a data warehouse, such as ETL processes, databases and reporting environments
• Develop and automate ETL processes that involve data cleansing, error, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS)
• Collaborates with Project Managers to resolve requirements gaps uncovered in design or within specifications or requirements.
• Prepares technical documentation for platform, service or infrastructure technical components.
• Design dimensional models with conformed dimensions, following the business processes
• Create stored procedures, Views, cursors and leverage a variety of other Database Objects to efficiently translate and manipulate healthcare data
• Troubleshoot current processes and maintain business continuity as required
• Deployed and scheduled SSIS ETL packages using SQL server job agent
• Develop and maintain business intelligence applications including operational reports, dashboards, scorecards, and ad hoc reporting requests

Environment: SQL Server 2014, T-SQL, SQL Server Integration Services(SSIS), SQL Profiler, Excel, Microsoft Visio, VB Scripting, SSMS, Visual Studio 2015, Tableau

SQL BI Developer

Confidential

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.
• Developed SSIS Templates which can be used to develop SSIS Packages 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 using SSRS Reporting Services, Report Model and ad-hoc reporting using Report 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.
• Wrote stored procedures and User Define Functions (UDFs) to be used in the SSIS packages and SQL 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, T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Profiler, Excel, .NET, VB Scripting, SSMS, Visual Studio, SAP Source

Sr. SQL Server SSIS/ SSAS Developer

Confidential

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.
• Developed Multidimensional Objects (Cubes) using SQL Server Analysis Services (SSAS).
• Implemented MS Analysis Services setup, tuning, cube partitioning, Dimension design.
• Defined appropriate measure groups and KPIs & 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, Oracle

SQL Server/SSAS/SSIS/SSRS Developer

Confidential

Responsibilities:

• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Extracted and reviewed data from (Flat files, Teradata) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Scheduled Daily and weekly ETL Jobs and Alerting using SQL Server Agent.
• Identified the dimension, fact tables and designed the data warehouse using Snowflake Schema.
• Developed Multidimensional 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 and KPIs & 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

SQL/ETL 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.
• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
• Based on design document created SSRS reports like Drilldown, Sub reports.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Created queries for generating reports in SSRS and scheduled jobs to send the SSRS reports.
• 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, SSIS, SSRS, BIDS

GIS Analyst

Confidential

Responsibilities:

• Mapping roads and giving directions and routing preferences according to heat map and satellite imagery on GIS tool
• Solving the rendering issues and ensuring effective marker locations for addresses.
• Done Quality analysis of data.