SUMMARY:

• 7 years of IT experience in Database Design, Development, Testing and Implementation of Business Intelligence, Reporting and Data Warehouse applications.
• Experienced in using Tableau Desktop 2018.x/10.x/9.x/8.x Tableau Reader and Tableau Server in analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis Charts, Bar Charts, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Gantts, Circle views, Bullet Graphs, Histograms, Geographic Visualization making use of actions according to the business/client requirement.
• Developed dashboards using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots Scatter plots, Funnel Charts, Waterfall Charts and Custom Geocoding.
• Experience in Tableau Data Extracts, Data Blending, Storytelling, and Row Level Security using User filters.
• Experience in creating joins, sets, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, parameters and Level of detail expressions (LOD).
• Experience in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in configuration of report server and report manager scheduling, giving permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in Design ETL DTS & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union
• Excellent communication, analytical and problem-solving skills with critical thinking and can work independently as well as collectively.

TECHNICAL SKILLS:

Tableau 2018/10/9/8, Tableau desktop, Tableau server, Tableau online, Tableau Public, Tableau Reader, Tableau Prep, Power BI, SSRS, Microsoft Excel Reports, MS SQL Server 2016/2 / 2008 R2/ 2005, SQL CMD, MS office, MS Outlook, MS Project, Erwin, R, R Studio, C, C++, HTML, T-SQL, My SQL, C#, MS SQL Server, Oracle, Windows, IOS, Unix, SQL Profiler, Query Analyzer, DTS, SSIS, SSAS, BI, Hyperion, Informatica, Development studio, micro strategy, Analysis Manager, Visual Studio, Modeler, MS Visio, SAS/Access, Crystal Reports 8 /10, Toad, Team Foundation Server(TFS).

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. Tableau Developer

Responsibilities:

• Worked on Planning, Designing, Publishing of new Dashboards for the Managers and Director to analyze the metrics along with improving and upgrading the existing reports.
• Worked closely with the team of data analysts and planned the data staging according to the requirements and using views and custom SQL queries.
• Created summarized reports for Sales, Production, Commission to analyze the different metric performances and effects on overall profit, loss or expenditure.
• Created reports for the representatives of the company and interacted with the representative trainers for the feedback on the reports created.
• Also created reports for analyzing individual performances of the agencies through trends and scatter plots to identify the outliers.
• Used analytics like LODs, KPIs, Viz in tooltips, forecasting, maps to present detailed reports on risk factors, seasonal competitions and market trends for the department.
• Used different data sources from Microsoft SQL, DB2, excel sheets, Microsoft Power pivot and Tableau Prep cleaned files using data blending or cross database joins.
• Involved in publishing the dashboards to server with email enabled for certain thresholds as notifications to the users.
• Involved in planning and migrating SSRS reports to Tableau Dashboards for the Department.

Environment: Tableau Professional 10.5,2018.1, Tableau Server 2018.1.1, MS SQL Server 2016/2014/2012, MS SQL Server Reporting Services, TFS, MS ACCESS, DB 2, Tableau Prep 2018.2

Confidential, Princeton, NJ

Tableau Developer

Responsibilities:

• Worked on Exploring, Designing, Building, and Deployment of the high-level dashboards for Board of Directors, Decision makers for critical metrics using Tableau.
• Developed, maintained and documented highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Coordinated and conducted business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and Project Managers.
• Created Filter and URL actions to navigate from the Executive Dashboard to the Detail Report and implemented the back button logic to navigate back to it.
• Developed dashboards using calculated fields with different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.
• Worked extensively with Advance Analysis using LOD expressions, Scatter plots, Box plots, Background images, Maps, Trend Lines and Log Axes, groups, hierarchies and sets to create detail level summary report and Dashboard using KPI's.
• Developed and reviewed SQL queries with use of stored procedures, joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
• Assisted Business users and recommended features, charts, KPI’s for their business analysis in Tableau.
• Presented discovered trends and analysis, forecast data, recommendations on risks identified to the higher management.
• Involved in publishing workbooks, views and also did performance tuning using performance recorder.
• Used data sources from SQL, Oracle and excel files to generate reports in Tableau.
• Operated in all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse system and participated in data modeling to improve the Tableau performance.

Environment: Tableau Desktop 9, Tableau Server 9, MS SQL Server 2016/2014/2012, MS SQL Server Integration Services, TFS, SQL Server Analytical Services, Erwin, MS ACCESS, MS Visual Studio 2015.

Confidential, Stamford, CT

Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager to get a better understanding of the Business Processes.
• Developed, organized, managed and maintained graphs, tables and document templates for the efficient creation of reports.
• Created various reports on Daily, Weekly, Monthly and Annual basis.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extracted data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters
• Used Multiple Measures like Individual Axes, Blended Axes and Dual Axes.
• Various Slicing and Dicing capabilities like by the Activation Plan, Credit Score Buckets, Language etc. are provided in the form of filters to give ad-hoc reporting capability
• Leveraged dashboard actions to provide drill through capability to individual account level
• Extensively used calculated fields for different logics for Trend, Extended loan calculations for the different account types
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create proof of concept while ETL team were cleaning data from source systems
• Validated the results in Tableau by running SQL queries in MS SQL developer
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Developed tableau functional design document.
• Performed performance tuning of the dashboard in Tableau desktop.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Environment: Tableau Desktop 9/8, Tableau Server 9/8, MS SQL Server 2016/2014/2012, MS SQL Server Integration Services, TFS, MS ACCESS, MS SQL Server Reporting Services, MS Visual Studio 2012, Erwin.

Confidential, Princeton, NJ

Tableau/SQL BI Developer

Responsibilities:

• Involved in the requirements gathering process to prepare the business requirement documents.
• Developed executive dashboards to show reports from various departments.
• Used complex calculated fields to meet exact requirements provided by users.
• Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Restructured data using Initial SQL Queries, to allow flexibility in chart developments according to requirements by closely working with SQL team.
• Involved in working with ETL team collecting, cleansing and integrating data from various sources involved and modeling data and creating Reports.
• Worked with data blends and joins to ensure maximum efficiency in dashboard performance.
• Optimized reports and created performance analysis dashboards
• Used calculated fields, quick-filters, parameters and action filters to create dynamic charts and tooltips
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Conducted in-depth analysis of requirements to provide efficient solution to users and to ensure best practices.
• Prepared design documents, training and UAT documents.
• Implemented solutions using action filters and URLs to navigate between various dashboards.
• Used Extract and Live connections of data to develop reports with efficiency
• Implemented permissions for users and ensure user security according to various clearance levels of business users
• Scheduled reports and ensured users were informed with each dashboard refresh.

Environment: Tableau Desktop 9/8, Tableau Server 9/8, MS SQL Server 2016/2014/2012, MS SQL Server Integration Services, TFS, MS ACCESS, MS SQL Server Reporting Services, MS Visual Studio 2012, Erwin.

Confidential

SQ BI Developer

Responsibilities:

• Involved in gathering the requirements and identifying the key performance metrics for end users.
• Designed new data sources for developing analytical reports from multiple data sources like Microsoft SQL Server, Microsoft Access.
• Developed SQL Scripts for creation of various Database Objects (Stored Procedures, Indexes, Triggers, and User Defined Functions).
• Developed complex queries using joins and sub-queries and Created multiple views and queries.
• Involved in Extract, Transform and Load (ETL) process framework.
• Involved in user interface design and developed scripts to support business needs.
• Designed and Developed dynamic dashboards and enhancements to existing reports and capabilities in alignment with business needs.
• Worked on designing and developing various reports using different chart visualizations like Gantt charts, bar graphs and bullet graphs.
• Managed Metadata and Extracts using Tableau Desktop and published the Data source to the Tableau Server.
• Created bar charts, tree maps, bullet charts and Gantt charts.
• Created ad-hoc reports and Dashboards according to User requirements.

Environment: Microsoft Access, SQL Server Management Studio, SQL server, Visual Basics, Crystal Reports, Tableau Desktop 8.x, Tableau Server.

Confidential

SQL Server Developer

Responsibilities:

• Understood the requirement and technical direction of the programming from BAs and Database Architects.
• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams
• Developed database objects like tables, views, stored procedures, indexes etc.
• Performed data management projects and fulfilling ad-hoc requests per user specifications by utilizing data management software like SQL and tools like Excel.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimal performance.
• Created Indexes on tables of new database for faster retrieval of data for the Reports.
• Worked on SSRS with many complex stored procedures.
• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram

Environment: MS SQL Server, SQL Server Management Studio, MS Excel, SQL Server Reporting Services