SUMMARY

• Highly motivated SQL Server/BI Developer with 6+ years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2016/2008 , SSRS, Tableau and SSIS.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T - SQL.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services(SSIS) MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS) and Tableau.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SSRS and Tableau.
• Strong experience in developing parameterized, Sub Reports, Matrix Reports, Charts, Drill down, Drill Through reports, using SQL Server Reporting Services (SSRS) and Tableau.
• Excellent knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar Graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and Global filters according to the end user requirement.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

TECHNICAL SKILLS

Operating Systems: Windows2010, 2008, 2007, Server, Windows NT, Unix.

RDBMS: MSSQL SERVER 2016/2014/2012/2008 R2

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS) SQL Server Analysis Services (SSAS), ETL,Tableau, Cognos, Self BI with Excel, Power BI

Languages: C, C#, T-SQL, Dynamic SQL.

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013/2015/2017 , SQL Profiler, DQS.

PROFESSIONAL EXPERIENCE

Confidential, PA

Tableau/SQL Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with project teams and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Built Tableau visualizations against various Data Sources like AWS, Flat Files (Excel, Access), Relational Databases SQL Server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets. Effectively used Data blending feature in Tableau
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, LOOKUPs, and Quick Table calculations.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Modified and Created Joins and custom SQL queries to import data from AWS to Tableau.
• Created SQL statements to extract data from data tables and verify the output data of the reports along with creation of tables, Sub queries, Joins, Views, Indexes, SQL Functions, Set Operators and other Functionalities in AWS
• Building, publishing customized interactive reports, dashboards and report scheduling using Tableau server. Creating new schedules and checking the tasks daily on the server.
• Created calculated fields with MDX code to meet additional measures need that are calculated from existing measures in Tableau.
• Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using Tableau based on client requirement.
• Extensively worked on developing various kinds of reports in Cognos 8.x/10x Report Studio, Analysis Studio and Query Studio.
• Manually modified the SQL in Report Studio to tune and/or to write reports using Report Studio and designed complex dashboards and reports using Active Reports.

Environment: Agile Methodology, MY SQL, AWS, Tableau 10.4, Cognos 10.2, MS Excel, MS Office, Windows Server

Confidential, Charlotte, NC

Tableau/MSBI Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to data warehouse using SSIS packages.
• Used Tableau Desktop to design interactive reports and data visualization.
• Developed Tableau reports and dashboards from multiple data sources using data blending.
• Explored data in a variety of ways and across multiple visualizations using Tableau. Strategic expertise in design of experiments, data collection, analysis and visualization.
• Used SSIS script tasks, look up transformations and data flow tasks using T-SQL, C# and VB scripts.
• Used multi-dimensional models such as star schemas and snowflake schema for developing cubes.
• Designed and developed matrix, tabular and parametric reports using SSRS 2016.
• Designed and developed drill down and drill through reports with drop down menu option using SSRS.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including status.
• Wrote new stored procedures for new system and optimized old store procedures and functions on production server. Improved data load performance by analyzing database design and query plans.
• Modified and created joins to improve the database and execution speed.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in data visualization using Tableau to create complex, intuitive and innovative dashboards.
• Involved in performance tuning using SQL Server Profiler and SQL server hints.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source and Excel spreadsheet to SQL Server 2016.
• Designed ETL packages dealing with different data sources (SQL Server, flat files, and XMLs, etc.) and loaded the data into target data sources by performing various kinds of transformations using SSIS.
• Created Time Calculations like MTD, QTD, YTD, YoY and %YoY based requirement
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Environment: Microsoft SQL Server SSRS, SSAS, SSIS 2016/ 2012, T-SQL, MySQL, PL/SQL, MS Visio 2008, SharePoint 2010, Tableau, Windows Server, Power Map, Power Pivot, Power View, MS Office, Microsoft Visual Studio 2008, Reports Builder.

Confidential, Kansas City, Missouri

MSBI (SSIS, Tableau, SSAS)/ETL Developer

Responsibilities:

• Involved in different stage of System Development Life Cycle from defining, designing and developing the new system to testing evaluating and maintaining the system.
• Working with different business users to adopt the data visualization - Tableau in the Organization and get insights from the data.
• Work with the technical Team to gain a good understanding of the database models used for Tableau reporting.
• Design and development of ETL packages to load the data into Marts implemented to perform Cleansing t mapping, profiling and whole governance on a real time process.
• Experience in creating SQL data models/Queries for Tableau and Ad-hoc Reports.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Tableau.
• Develop Tableau reports & effective dashboards after gathering and translating end user requirements.
• Experience in writing stored procedures and functions on numerous SQL server.
• Extensively used different transformations i.e., looping, data formatting, check points, error handling, email notification in SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Utilized Power Query in Tableau to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2014.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups and Implemented Event Handlers and Error Handling in SSIS packages.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Tableau Reports.
• Designed a Data Model with Multiple Fact Tables and Dimensions depending on the business user requirements.
• Responsible for building reports in Tableau from the Scratch.
• Experience in Custom Visuals and Groups Creation in Tableau.
• Responsible for creating and changing the visualizations in Tableau reports and Dashboards on client requests.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Tableau and generate reports with different visualizations.
• Created calculated columns and measures in Tableau and Excel depending on the requirement using DAX and MDX queries
• Created reports by using Joins in multiple tables from multiples database using complex SQL queries.
• Writing MDX queries to get the data from a tabular model.
• Has extensively done Data profiling and data quality analysis.
• Design and development of SSAS Tabular cubes to satisfy the end user reports by creating different types of Reports and Dashboards in Tableau.
• Created complicated DAX measures in the Tableau reports as per the requirements of the Business Users.
• Experience in Implementing Performance testing and Load Testing.
• Involved in Bug/Root Cause Analysis and providing the resolution.
• Worked on Identifying the slow running ad-hoc reports and came up with the performance improvements.
• Implemented the test automation suite in C# which helped the test team to enforce high quality testing and effort saving.

Environment: MS Visual Studio 2015, SSAS (Tabular), SQL Server Management Studio2016, SQL Server Reporting Services (SSRS), Tableau, SQL Server Integration Services (SSIS), MS SharePoint, GIT Hub.

Confidential, St. Louis, Missouri

SQL Server/SSIS/SSAS/Tableau

Responsibilities:

• Created and modified stored procedures, functions, views and indexes to provide best performance.
• SQL Development & Troubleshooting included indexes, stored procedures, triggers and table structures for application behavior manipulation.
• Involved in the creation and deployment of the reports using Tableau
• Installed and configured SQL Server 2008 and 2008 R2 Enterprise Edition Environment.
• Designed, Developed and tested packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Developed advanced ETL import packages using SSIS, T-SQL to transform and import raw index data into database tables.
• Implemented Triggers, Views, Clustered and Non-clustered indexing. Extensive work on performance tuning of SQL Server ETL process.
• Wrote calculated columns, Measures query’s in Tableau desktop to show good data analysis techniques
• Created tables needed for ETL processing and develop ETL framework.
• Developed SSIS packages to Migrate data to staging server and then to production server.
• Processed data from flat files excel files, .csv files into proprietary hierarchical data structure system through SSIS packages and custom procedures.
• Implemented Type I, II changes in slowly changing dimension (SCD) tables.
• Analyzed data importing processes and design processes/applications to help increase automation, efficiency, flexibility and extensibility.
• Scheduled Automatic refresh and scheduling refresh in Tableau service and Worked on all types of transformations that are available in Tableau query editor
• Created various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Tableau.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS and Tableau.
• Added new facts and dimensions to the data warehouse.
• Reviewed cube changes and documented according to the requirement based on product valuation and revenue opportunities.
• Developed cubes by defining data sources and data source views and using SQL Server Analysis Services (SSAS).
• Created reports from cubes by writing MDX queries and Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily in Tableau
• Worked in cooperation with other teams and business analysts for achievement of efficient database access and for processing applications. This includes activities like designing, adding, eliminating, or maintaining indexes, organizing tables, recommending SQL scripts to application development teams.

Environment: MS Visual Studio 2012, SQL Server Management Studio, SSRS, Tableau, SSAS(Tabular), SQL Server Integration Services (SSIS), AZURE, MS SharePoint, IIS 7.5/7.0/6.0, Visual Source Safe (VSS), Team Foundation Server (TFS), GIT Hub.