SUMMARY

• 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2016/2012/2008/2005 , T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Hands on Experience in MDM implementations using SQL Server Master Data Services 2012 (MDS 2012)
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2016 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience with logical and physical data modeling and database design using Erwin.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Experience in modifying MDX Cubes and Dimensions in SSAS.
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Worked on Tableau & PowerBI creating analytics reports, visualizations, dashboards, stories, Excel PowerPivot, PowerQuery, PowerViewer, DAX.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau & PowerBI.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Great exposure to Acuity Tools: AcuityConnect, AcPort, AcuStrat, AcuPrint.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Exposure to Automate Azure database creation, scaling up/down, enabling auditing and treat detection using PowerShell and ARM template.
• Expertised in using cloud based managed services for data warehousing in Microsoft Azure (Azure Data Factory, Azure Data Lake).
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008/2012/2016 , SQL Server Management Studio 2005/ 2008/2012/2016 , DTS, SSIS, SSRS, SSAS, Power BI, Azure SQL DW.

Database: MS SQL Server 2012,2016,2008,2005, MS-Access, Oracle, MySQL, HDFS

Language: C, C++, C#, T-SQL, VB, DAX

Operating System: Windows 7/10, Linux, Windows Server 2008/2012

Tools: RedGate, Microsoft Visual Studio 2013/2008/2005 , BIDS, SSDT, TFS, Tortoise Hg, Acuity Tools (Acuity Connect, Acuity, Acuport, Acuprint, Acustrat), Azure Datalake, Azure BLOB Storage.

Reporting Tools: SSRS 2008/2012/2016 , Crystal Reports, Power BI, Tableau 9.0

ETL Tools: SSIS 2008/2012/2016 , Informatica Power Center 9.1/8.6, DTS

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Azure SQL Devloper

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for business objects Universes and Reports.
• Worked with Analytics team which handles all Digital and Store inventory of and provides real time dashboards, analytics and score cards.
• Developed and created complex Stored Procedures, Dynamic SQL queries, Joins, Views, Triggers, Cursors, CTE, DML, and DDL etc.
• Migrated entire retail data from different sources and Involved in writing stored procedures to migrate data from External Tables to Staging (Raw data) to Datawarehouse and from Datawarehouse to actual fact tables
• Extensively used SQL for Data Analysis and to understand and documenting the data behavior within the company across various franchises.
• Involved in using ETL (Extract Transform Load) to get our new data and pull it into the database.
• Responsible for Generating and managing reports using SQL Server Reporting Services (SSRS).
• Experience in migrating the SSIS Packages to Azure datalake using Azure data factory.
• Used Azure Data Lake for data storage which holds the massive amount of data using the data factory.
• Well experienced in creating Parameters, hyperlinks to navigate to other reports and designing charts in SSRS
• Involved in using GIT for version controlling in designing.
• Strong understanding of agile methodology.

Environment: Azure Data Lake, Azure Data Factory, SSMS, SSRS, ETL, SQL Server, GIT, Agile.

Confidential, Montpelier, VT

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Developed various SSIS packages for migrating the Provider, Claims and Member data from PMHS to NASCO .
• Provided application support for different applications that support Providers, Member, Enrollment, Claims and Commissions Data.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Migrating existing SSIS packages from SSIS 2012 to SSIS 2016
• Migrated data from legacy systems like (flat files, excel and access) using SSIS and Stored procedures to SQL Server
• Written Complex SQL Queries by joining multiple tables, dynamic SQL and Subqueries in T-SQL
• Monitoring SQL Server performance using SQL Profiler to find performance issues and dead locks
• Worked on tuning the queries and fixing the stored procedures to get the data consistency in reports.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions , Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SSDT 2012.
• Implemented error handling and utilized Event Handlers for automated notifications in SSIS.
• Generated different SSRS reports for different providers and provided subscriptions on daily, weekly, bi-weekly, monthly, Quarterly and yearly basis
• Worked on different Break-fix SRs for different applications to resolve any issues
• Worked with offshore team to provide 24*7 support to client

Environment: : MS SQL Server 2008 /2016, MySQL, TortoiseHg, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau 9.0, Visual Studio 2008/2013, T-SQL

Confidential, Jacksonville, FL

SQL BI Developer

Responsibilities:

• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Migrated existing ad- hoc SSRS reports to Power BI and created new dashboards in Power BI.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as Sql Server, My SQL, Oracle etc.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all types of transformations that are available in Power bi query editor
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Provided continuous maintenance and development of bug fixes for both SSRS and power Bi reports
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Creating Reports as per user requirements using MS Reporting Services 2008/2012.
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Worked in developing queries in MySQL using MySQL workbench

Environment: : MS SQL Server2008/2012, MySQL, TortoiseHg, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Tableau 9.0, Visual Studio 2008/2013, T-SQL

Confidential, Indianapolis

T-SQL/BI Developer

Responsibilities:

• Migrated Data from Oracle Siebel CRM to GSX/PSX applications
• Created database structure that corresponds to the data that was migrated to PSX application
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Created various SSIS packages for moving the data from Oracle (Excel, Access etc.,) to SQL Server
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs/ System Monitoring jobs.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012/2008.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Experience in ETL Data Warehouse environment. Created Jobs in SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Creating Reports as per user requirements using MS Reporting Services 2005/2008/2012.
• Created different types of reports such as Cross-Tab, Drill-down, Drill-through, OLAP and Sub reports, and formatting them using both SSRS 2005/2008
• Designing and implementing data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views)
• Performance tuning, deploying and processing SSAS cubes
• Writing complex MDX queries
• Troubleshoot/research data issues that arise during cube development and validation.

Environment: : MS SQL Server2008/2012, Team Foundation Server, Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, SSAS, Visual Studio 2005/2008, Windows 7/8, T-SQL

Confidential, McLean, VA

T-SQL\BI developer

Responsibilities :

• Worked with Business Analysts in gathering requirements and translating them to technical specifications.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Used Script task to write custom code using Vb.net
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.

Environment:: MS SQL Server2005/2008, Team Foundation Server, Microsoft SharePoint Server, Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, VB.Net

Confidential

T-SQL\BI developer

Responsibilities:

• Migrated SQL server 2005 to SQL Server 2008 R2.
• Created efficient scripts for taking backups of databases
• Developed T-SQL queries and stored procedures with multiple parameters to created data Sets for reports
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2008
• Created subscriptions in SSRS to deliver reports to a shared file.
• Created User-defined functions, Triggers, Views for Audit and security purposes.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping tables to find out the missing attributes for the ETL process.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.

Environment: : SQL Server 2005/2008, T-SQL, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, SQL Profiler, MS Visio, Visual Studio 2008