PROFESSIONAL SUMMARY:

• Having 8+ years of IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI, Tableau
• Hands - on Experience on Creating Azure Data Factory for transferring and transforming the data.
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
• Developed and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Experience in Creating packages, Jobs, Sending Alerts using SQL Mail.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server
• Experience in Error handling, Debugging and logging for production support in SSIS.
• Hands on experience in Performance Tuning, Query Optimization
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Expertise in creating cubes with dimensions and facts tables in Warehouse using SQL Server Analysis Services (SSAS).
• Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Experience in designing report with rich UI including Tabular forms, Matrix (Cross /tab Report) form, Drill down, Parameter, Cascadingparameters, Charts and SubReports.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Involved in Unit Testing the data and worked with QA team to resolve the defects.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc...,
• Technically hands-on commercially experience mainly with creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting, Tableau designs, proto types and Tableau mock up reports, Wireframes, Frame works, Design documents (HLD, LLD), Data mapping documents and reporting.
• Using the Tableau Desktop for the Data Analysis, Data Visualizations, and Data Discovery and for the data explorations.
• Experience in creating various visualizations in tableau for dashboards using tableau various charts and graphs.
• Expertise in creating Report Inventory, Report Mapping document, Report Business Requirement Documents (BRD), Reports Functional Requirements Documents (FRD), Use cases diagrams and report inventory document.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2014/2016 , Azure SQL DB

Operating Systems: Windows 7 & 10

Languages: T SQL, SQL SERVER, Java, C#

Business Intelligence Tools: SQL Server Integration Services(SSIS)Azure Data Factory(ADF)SQL Server Analysis Services(SSAS)SQL Server Reporting Services(SSRS)Power BI DesktopTableau Desktop

WEB Design: HTML with CSS

PROFESSIONAL EXPERIENCE:

Power BI Developer

Confidential, Herndon, Virginia

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Involved in defining d relationships with the measure groups and fact tables.
• Created Azure Blob Storage for Import/Export data to/from .CSV File.
• Worked on Azure Data Factory to move data from SQL Server DB to Azure SQL DB.
• Created a ADF pipeline to pull data from various sources to Azure Blob Storage.
• Scheduled jobs and alerts using ADF Triggers.
• Azure Storage development and design utilizing Blobs, Tables, Queues, Files.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Published reports and dashboards using Power BI.

Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Tableau Developer

Confidential, Irving, Texas

Responsibilities:

• Involved in creating dashboards and reports in Tableau.
• Created dashboards by extracting data from different sources using parameters and calculations.
• Involved in reviewing Business Requirements and analyzing data sources and databases for design, development of reports and analysis.
• Developed various analytics reports from multiple data sources
• Designed Tree Map, created calculated fields, KPIs, dual-axis bar chart, Pie chart and Bubble chart with multiple measures
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards and created proof of concept / prototype of the same using Tableau desktop
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively developed different types of visualizations in Tableau like Dual Axis, bar charts, Bullet graphs, Box and whisker plots.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios
• Implemented Grand Totals, Sub-totals, and Changing Aggregation for Customizing the Data.
• Created Hierarchies, sets, combined sets and Groups in Tableau.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Desktop 9.x, MS Excel, SQL Server, Windows O.S

SQL Server Developer/SSIS/SSRS

Confidential

Responsibilities:

• Involved in gathering user requirements and system specifications.
• Using Red Gate SQL Data Compare compares and synchronize data from within SSMS.
• Created Views to validate the data and facilate easy user interface implementation.
• Created Stored Procedure to move data from old structure to new structure.
• Involved in creating Indexes for faster retrieval of data.
• Using SQL to query database performing various validation and mapping activities.
• Maintain, Update and Monitor the existing databases on daily basis.
• Created SSIS Package to import and export data from Flat Files and csv files to SSMS.
• Imported data from various sources into a staging area, merge the data into OLTP data model and Presents it to all levels of users.
• Data Migration (Import & Export utility/BCP) from text files to SQL Server.
• Created drill down, drill through, sub report using SSRS.
• Generated Multi parameterized reports and make them user friendly.
• Created drill down, drill through, sub reports using SSRS as well as managed subscription reports as per client's requirements using SSRS.
• Created join and sub queries to involving multiple tables.
• Developed Table, CTE, Temporary table, Function as per Business Requirement.
• Involved in Testing and Validation of Automation Process.

Environment: MS SQL Server Management Studio2012, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Visual studio, MS Excel, Windows XP, Red Gate

SQL Server Developer/SSIS

Confidential

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2008R2, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2008R2.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created Custom ETL packages using SSIS and develops and unit test SSIS load processes for performance check.
• Created and scheduled SQL jobs to run SSIS packages daily.
• Involved in usage of various SSIS components and features like For loop, For Each loop, Lookup Transformation, Variables, Error Handling and Package Configurations.
• Developed Query for generating drill down reports in SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Maintained the consistency of the client’s Database using DBCC.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2008R2, MS Access, SSIS, SSRS, Query Analyzer, DTS, SQL ProfilerImport & Export Data, Windows 2000 Server.

SQL Developer

Confidential

Responsibilities:

• Designed and created databases, DB Objects based on the business requirements.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Involve in create table-valued functions.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Improved performance of SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Worked with SQL server profiler to generate traces.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
• Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Designed ETL packages dealing with different data sources (SQL Server and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including status.
• Involved in creating report datasets and using stored procedure parameters in SSRS.

Environment: MS SQL Server 2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT).