Bi Developer (sql/ Tableau/ Powerbi) Resume
Elizabeth, NJ
SUMMARY
- 7 years of work experience in IT industry as Database Developer/BI Consultant in designing and developing T - SQL queries, ETL package, and business reports using MS SQL Server 2008/2012 (T-SQL), SSIS and SSRS
- 5 years of professional experience and highly qualified in Tableau Desktop and Tableau Server by using various version Tableau (8x/9.x/10.x/2018.1).
- Highly motivated with the ability to work effectively in teams as well as independently.
- Experienced in generating different types of Reports like Ad-hoc reports, Dashboard reports, linked reports, Sub-reports, Parameterized reports, Drill-down and Drill-through reports by using T-SQL, SSRS, Tableau and PowerBI.
- Developed complex SSIS packages using various tasks, containers, data transformation like fuzzy lookup, for each loop and for loop sequence container.
- Defined report layouts for formatting the report design as per the need and identified and defined the data sets for report generation using SSRS.
- Expert in Data Visualization development using Tableau to create intuitive, innovative and highly interactive Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
- Excellent experience in optimizing report performance serving as Data Cleansing, Queries Optimization, wise choose of Cache/Snapshot/Extract in SSRS and Tableau.
- Worked closely with the business team and provided clear datasets and reports for business purpose.
- Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post-implementation support and maintenance.
- Strong experience in T-SQL (DDL, DML, DCL and TCL) in constructing Tables, Normalization / De-normalization techniques
- Highly proficient in SQL programming including Sub-Queries, Stored Procedures, Views, Triggers, CTEs, and User Defined Functions
- Strong experience in maintaining Batch Logging, Error Logging with Event Handlers
- Developed SQL queries, optimized stored procedures and subqueries for faster retrieval of data
- Strong experience in data Extraction, Transforming and Loading (ETL) by creating dynamic packages using containers and various transforms in SQL Server Integration Services (SSIS)
- Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot, Union all etc.
- Designed and developed SSIS model package for historical load and incremental load (daily updates) to feed the data warehouse from different sources including OLE DB, flat files, CSV files, and Excel.
- Worked with the management team to create a prioritized list of business and information needs.
TECHNICAL SKILLS
- Microsoft Office Suite
- MS SQL Server 2008 R2/2012/2016
- Server Integration Service(SSIS)
- Server Reporting Services(SSRS)
- Tableau Desktop (8.x/9.x/10.x)
- Tableau Server
- Tableau Public
- PowerBI
- SQL Server Management Studio
- R Studio
- SharePoint
PROFESSIONAL EXPERIENCE
Confidential | Elizabeth, NJ
BI Developer (SQL/ Tableau/ PowerBI)
Responsibilities:
- Worked with Customer Service, Marketing and IT department to analyze, understand and document business intelligence needs and determined optimum Tableau visualization solutions to meet requirements.
- Designed staging area database required for data processing (cleansing, validation, audition) and transformation (lookup, filter etc.).
- Created Data Marts to support reporting requirement of different dimensions (Appointments, Healthcare History, Transaction, Physicians etc.).
- Designed fact and dimension tables, required for the report building, in data marts using star schema.
- Collaborated with the data management team integrate the data mart built into the data warehouse.
- Used SSIS control flow tasks and data flow tasks to create ETL packages.
- Wrote T-SQL Stored Procedures to perform initial/incremental loading process in the staging area.
- Implemented system and user-defined functions(UDFs), CTEs and Views to improve the functionality of T-SQL code.
- Analyzed the execution plans for any discrepancies and advised on appropriate solutions for better response timings.
- Scheduled jobs to call SSIS packages and Stored Procedures.
- Created system-wide alerts for successful and unsuccessful completion of scheduled jobs (weekly, monthly, quarterly report).
- Created send mail task to notify operation team of the package automation status on a regular basis.
- Developed sub-reports, drill-down, summary, and matrix reports in SSRS and deployed them in SSRS server.
- Enabled snapshots, subscriptions, report caches and utilized stored procedures to improve response times and optimize report performance in SSRS.
- Experience in developing ETL process in Alteryx to full fill the performance requirements in tableau dashboard.
- Created action filters, parameters and calculation sets for preparing worksheets and dashboards in Tableau.
- Built organized, customized analysis and visualized worksheet and dashboards to present to Senior Level. Defined best practices forTableau report development.
- Utilized advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
- Trend Lines, Statistics, and Log Axes. Groups, Hierarchies, sets to create detail level summary report and Dashboard using KPI's.
- Worked on side by side bars, lines and pies, bubbles, Gantt, Scatter Plots, Stacked Bars, highlight tables, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Generate context filters and data source filters while handling huge volume of data.
- Created multiple extracts to quickly access historical data.
- Used filters to display information from various time ranges such as YTD, TTM, and Fiscal Year-to-date.
- Set user permissions in Tableau Server.
- Created various User groups by assigning row and column level security at application level, folder level and user level.
- CreatedTableauExtracts of historical data to quickly retrieve information for reports.
- Resolving various performance issues and analyzing the best process distribution for different projects.
- Published reports toTableauServer so that users could have daily updates via email subscriptions.
- Scheduled data refresh on Tableau Server for weekly and monthly increments to ensure that the worksheet and dashboard were displaying the changed data accurately.
- Wrote documentation on the solutions with enough details for operation, maintenance, troubleshooting and feature-expansion.
- Managed development changes for the BI solution with TFS.
Environment: MS SQL Server 2016/2014/2012 , SSIS, SSRS, SSMS, DAX, Data Model, Visual Studio 2014, TFS, Alteryx, Tableau (Desktop/Server) 10.x/ 2018.1.
Confidential | Pittsburgh, PA
BI/ Tableau Developer (SSRS/ SSIS/ Tableau)
Responsibilities:
- Implemented Tableau BI Dashboard reporting solution for different groups in the organization and published Dashboards onto Tableau Server for users to view in different mediums (laptop, pc, I Pad)
- Participated in technical walk-through meetings to develop the functional design for the implementation of dashboards
- Performed detailed requirement analysis and created data mapping documents.
- Involved in developing Informatica Mappings and writing complex T-SQL programs for the Data Warehouse.
- Provide data analysis support for the company's initiatives and projects and oversee the performance of these project designs are as per the requirement.
- Monitoring MS SQL Server performance using Performance Monitor, Profiler, Tuning Advisor and Execution Plan.
- Closely watch the SQL Server error logs, System error log for regular maintenance of SQL Server.
- Rebuilding indexes on various tables, Responsible for creating databases, tables, view and Store procedure as per the business need.
- Associated with Performance Monitoring and Tuning of the database system using System Stored Procedures, DBCC Commands, Dynamic Management Views and SQL Server Profiler.
- Developed Tableau scorecards, dashboards using stack bars, dual axis charts, geographical maps and Gantt charts. Built complex formulas in Tableau for various business calculations.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes.
- Created organized, customized analysis and visualized projects and dashboards for presenting to Senior Level Executives.
- Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
- Performed Tableau Server administration activities like Site and Project creations and adding users and providing permissions to workbooks.
- Conducted JAD sessions, design discussions and SOS meetings to develop the appropriate data mart.
- Conducted training sessions for users on Tableau to use it as a Self-service BI tool for ad-hoc reporting.
Environment: Tableau (Desktop/Server) 8.x/9.x, SSIS, Teradata, Oracle, SQL Developer, JIRA, MS Visio, MS Office
Confidential | Iselin, NJ
BI/Tableau Developer (SQL/ SSIS/ Tableau)
Responsibilities:
- Designed relational/dimensional SQL Server database/data mart, implemented in SQL Server Management Studio and migrated data using linked server and store procedure
- Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic
- Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending
- Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop
- Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements
- Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, sparklines, crosstabs etc.
- Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story
- Published workbooks and extract data sources to Tableau Server under row-level security environment and scheduled automatic extract refresh
- Tuned reports performance by recording and analyzing performance workbook on timeline and execution query, tuned andoptimized analysis, calculated fields, layout and data source
- Supported team and report readers as a subject matter expert (SME) through troubleshooting, recommendation solutions and identifying opportunities to solve business problems through BI
Environment: MS SQL Server 2008 R2 and 2012, Tableau (Desktop/Server) 10.x/9.x, SSIS, SharePoint
Confidential | Boston, MA
BI Developer (SSMS/SSIS/SSRS)
Responsibilities:
- Created Error and Performance reports on SSIS Packages and alerts for successful or unsuccessful completion of scheduled jobs using SQL Server Agent Job Task in Event Handlers.
- Accomplished various SSIS tasks like Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
- Developed various risk reports (FX, Interest Rate, Commodity, Credit and Issuer Risk) for Market and Credit Risk Managers from Fixed Income division.
- Designed, developed and deployed reports including Tabular Reports, Matrix Reports, Parameterized, Drill-down, Ad hoc and Sub-reports using Report Designer and Report Builder and generated these reports using variables, expressions and functions.
- Designed and created report templates, bar graphs, and pie charts based on financial data for analyzing performance counters using SSRS, Tableau, and Crystal Report.
- Translated business needs into data analysis, business intelligence data source and reporting solutions for business users from credit department, loan and mortgage department, and risk department.
- Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
- Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
- Created new database object like Stored Procedures, Functions, Triggers, Indexes and Views using SQL Server in development and production environment.
- Defined relationships created actions, filters, parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel.
- Re-created all excel reports to tableau also imported excel data to create reports in Tableau.
- Analyzed and developed Data Marts and OLAP cubes with SSAS based on a multidimensional database with star schema.
- Analyzed and developed Data Marts based on a multidimensional database with star schema.
- Designed new SSIS packages to extract data from Data Marts, transformed it based on business needs for further analysis.
- Created Parameterized SSRS reports and customized existing reports for interactive presentations using Cross-Tab reports, Sub-reports, Drill-though reports, and Linked reports.
Environment: MS SQL Server 2012, MS Excel, Microsoft Visual Studio, SSIS, SSRS
Confidential | Worcester, MA
MS SQL Server Developer (SSMS/SSIS/SSRS)
Responsibilities:
- Gathered business requirements, defined and designed data sourcing, working in conjunction with the data warehouse architect on the development of logical data models.
- Involved in schema objects creation: index, stored procedures, user defined functions, views.
- Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
- Optimized the performance of queries with modification in SQL queries, eliminated redundant and inconsistent data, normalized tables.
- Created SSIS packages for loading different types (Hospital, Clinic, Retail, Local) data from heterogeneous sources to SQL Server.
- In the staging phase of the ETL process, used lookup tables and fuzzy lookup tables to handle data cleansing and validation. Used stored procedures and user-defined functions to separate the clean and dirty data into different destinations.
- Created reports in SSRS about data cleansing and validation result, submitted them to business-wise people, worked with the clean data again and got whole valid data.
- Created drill-down, drill-through, parameterized reports for business purpose using SSRS to optimize business logic on different dimensions.
- Involved in setting up SQL Server Agent jobs for periodic patient information reports, backups.
Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, SQL Server Agent, MS Office Suite 2007.
