*+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test, and Production Environments with various business domains.
Good Knowledge with all phases of the Software Development Life Cycle (SDLC).
Experience in Tableau Desktop, Tableau Reader, Tableau Prep, and experienced in analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
Creating dashboards, stories and developing different charts styles including Bar Charts, Line Charts, Tree-Maps, Gantts, Circle views, Scatter Plots, Bullet Graphs, Histograms, Heat Maps, Geo Maps, Text Graphs, and advanced visualizations sparkline model and developed reports and using advanced analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding in Tableau desktop environment.
Good knowledge of Database Administration operations like Backup, Restore, and excellent knowledge in SQL.
Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS), and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
Knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP, and OLAP.
Working Knowledge on Microsoft Power BI and Tableau reports dashboards and publishing to the end-users for executive-level Business Decision.
Experience in managing users, groups, sites, permissions, and roles on the Tableau server.
Highly Proficient in creating SQL Server Reports, handling sub-reports, and writing queries to perform Drill through and drill down operations in SSRS.
Working knowledge with transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
Experience creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
Create Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.
Develop complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
Efficient at the use of Microsoft Visio/Office as technical documentation and presentation tools.
Excellent problem solving, analytical, technical, interpersonal, and communication skills and an extremely diligent strong team player with an ability to take new roles.
SDLC, Tableau, Power BI, MYSQL, SQL Server, ETL, SSRS, SSAS, SSIS, Tableau Desktop, Tableau Reader, Tableau Prep, Tableau Report, Tableau Server, MS Excel, MS Visio, MS Access, GitHub, MS Office, Linux, Windows
Master of Science in Engineering Management
New Jersey Institute of Technology, NJ
PNC Financial Services, NJ Mar 2019 - Current
Role: MSBI Developer
Created and managed schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.
Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server.
Involved in Exploring, Designing, Building, and Deployment of the high-level and rich dashboards for decision making of critical metrics using Tableau.
Performed analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
Experience in Data Warehouses such as Relational, Dimensional, Multidimensional Modeling, Star and Snowflake schemas, Data marts, Fact and Dimension tables identification, and OLAP/OLTP.
Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets.
Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
Designing the Reports as per client requirements and created the reports using the Excel file and SQL Server database.
Analysis of the metrics dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
Used the version control tool GitHub to check-in our code to the higher environments on release basis.
Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
In-depth knowledge in Tableau Advanced Analysis features like Actions, Calculations, forecasting, Parameters, and Trend lines.
Prop Technology, India Jan-2016 - Dec-2017
Role: MSBI Developer
Involved in the Agile/Scrum team and participated in Stand up, grooming, planning, and retrospective meetings.
Performed Data Modelling to know about the relationships between entities in a database.
Worked with SQL server designed and developed SSIS (ETL) packages to validate, extract, transform, and load data from the OLTP system to the data warehouse.
Analysed the Data quality, Data validation, Data Mapping to migrate data to the SQL Server database.
Analysed business requirements and implemented data mart solutions for data mining and reporting
Strong knowledge of Data Warehousing methodologies, concepts, and implementation of star schemas, snowflakes schemas, facts & dimensions.
Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in a time-restricted environment using SQL Server Reporting Services (SSRS).
Used Lookups Transformation to get the data from reference data sets.
Created conditional filters and Action links to filter the data on the dashboard with Tableau.
Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
Developed application using Web API using Visual Studio and SQL Server.
Developed using event-driven Web forms using Visual Studio.
Worked on Exception Handling with error and with Try/catch and resolving locking/deadlocks.