SUMMARY

• Around 7+ years of IT experience Specialized in Data visualization, Dash board Development, Implementation, testing of software applications to support reporting and Business Intelligence Initiatives.
• Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x versions, Tableau Server, Tableau online, Tableau reader.
• Experience in creating rich interactive visualization reports and dashboards in Tableau Desktop and server utilizing LOD, Filters, Actions, Parameters, sets, Groups, Extracts, Data Blending, Page Trails.
• Extensively involved in the development of various interactive dashboards and reports such as Dual Axis, Pie - charts, Heat Maps, Waterfall Charts, Bar Graphs, Bubble charts, Box plots, Tree Maps.
• Good understanding of Big Data concepts like Hadoop, Map - Reduce, YARN, Spark, RDD, Dataframes, Datasets, Streaming.
• Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.
• Extensive experience in publishing Tableau dashboards to Tableau Server.
• Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.
• Extracting data from data sources like Marklogic, SQL server, Oracle and Excel files for getting data to Tableau for creating various dashboards.
• Worked with various teams in gathering user needs and documenting them in business requirement documentation.
• Extensively involved in Unit, System, User Acceptance Testing also involved in performing data validation for the dashboards that are generated from various data source.
• Worked on MS Visiofor database design and development of Entity Relationship Diagrams.
• Effectively utilized various Tableau features such as Dashboards, Stories, Quick POCs and worked with senior managements in analyzing the data trends, well utilized future forecasting option.
• Solid understanding on Microsoft SQL Server Integration Service(SSIS), SQL Server Reporting Service, MS Access, MS Excel, MySQL, C#.
• Development level experience in Microsoft Azure, ASP.NET, ASP, andC #.NET, Web Services, WCF, Web API, JavaScript, JQuery, AngularJS, Bootstrap, PowerShell, CSS, HTML, UML and XML.
• Proficient in developing Stored Procedures, Triggers, User Functions, SQL joins, Sub queries.
• Excellent knowledge in developing Drill down and Drill through reports in SQL Server Reporting Services.
• Extensively worked on various filters such as Data Source filter, extract filter, Context filter, Measure filter and global filter.
• Extensive Knowledge in Media, health care provider management.
• Extensively involved in performance tuning of reportsand involved in resolving issues related to tableau server.
• Experience in report development, testing and publishing on to TableauServer.
• Experience in Creating Users, Groups and Projects on TableauServer, Involved in Tableau server upgradation activities.
• Experience in data modelling techniques like Snowflake Schema, Star schema, Fact, and dimension tables.
• Strong knowledge of Software Development Life Cycle(SDLC) methodologies like waterfall, Agile.
• Strong Individual contributor, good team player, problem solving skills, ability to work under pressure, fast learner.

TECHNICAL SKILLS

Reporting Tools: Tableau 10.5/10.3/10/9.4/9.2/8. x/7.x, SSRS

ETL Tools: SSIS

Databases: My SQL, SQL Server, Oracle 10g/ 11c/9i/8i,Marklogic, Azure

Data Warehousing Modeling: Snow flake schema, star schema, Fact Tables, Dimension Tables

Operating Systems: Windows, Unix, Red Hat Linux

Programming Languages: SQL,PL/SQL, JAVA, UNIX, SSIS, C#

Other Tools: TOAD, MS OFFICE, MS visio, Jira,HP ALM, Quality center

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Sr. Tableau Developer

Responsibilities:

• Worked with the Business Analyst, Provider management teams, Outreach teams for gathering reporting requirements.
• Involved in installation of Tableau desktop 9.3, Tableau server 9.3.
• Worked on latest versions of Tableau 10.x.
• Created visualization prototypes based on the reporting needs in the initial stages and demonstrated them to business to collect feedback.
• Created Tableau data visualization using Bar graphs, Pie charts, line graphs, Tree maps and heat maps, and tabular graphs.
• Developed SQL stored procedure based ETL with custom logging and performance tuning to comprehensively aggregate data sources including SAP Financial, Hyperion budgeting. Migrated legacy data to Azure.
• Utilized AngularJS, jQuery, MVC, C# and SQL application stack.
• Developed Executive Level Tableau dashboards to identify the overall costs, expenses and KPI's of the industry by using BI tool Tableau 2018.1.
• Involved in migrating all the dashboards from version Tableau 10.5 to Tableau 2018.1.
• Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
• Develop Unix Shell scripts to perform ELT operations on big data using functions like Sqoop, create external/internal Hive tables, initiate HQL scripts etc.
• Create Centralized repository for all code artifacts using Azure Data Catalog and TFS.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Created and published dashboards through Jenkins to the Tableau Server and Cloud application.
• Involved in writing .yaml and .py script to deploy Tableau Dashboards.
• Created an export data feature to allow users to download the dashboard data and create their own reports.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Create SSIS Packages to migrate data from / to Azure Cloud (Azure SQL Database), Azure Blob Storage.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic usingC# and SQL Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau through connecting to PostgreSQL on AWS platform.
• Developed Tableau workbooks to perform Last Month, Current Year, trailing 6 months and trailing 12 months to show the variance analysis.
• Involved in creating API filters for the Tableau Dashboards in the Cloud environment.
• Involved in scripting (JavaScript) to integrate with Tableau.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Created dashboards for measures with forecast, trend line and reference lines. created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Created Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau for the analyst's.
• Worked with Git repository to pull or push the working files to the Bit Bucket.
• Good understanding and Worked under Agile Environment and tools such as JIRA, Bit Bucket, Confluence.
• Worked on Tableau’s other ODBC connection by creating user, system DSN for resolving Marklogic date filed issues.
• Generated PDF’s for various dashboards for contracted partners conference.
• Created production deployment and implementation plans, generated data extracts in Excel files for MDM teams to load in good views.
• Prepared files for test, for updating current views in Marklogic.

Environment: Tableau 10.5/10.3, Hyper extracts, Tableau server, C#, SSIS, Jira, Marklogic, MS Excel, Azure, Oracle, SQL.

Confidential, Hartford, CT

Sr. Tableau Developer

Responsibilities:

• Interact with business subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business needs.
• Building, publishing interactive reports and dashboards, scheduling reports using server.
• Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
• Design and Develop Hadoop ETL solutions to move data to the data lake using big data tools like Sqoop, Hive, Spark, HDFS, Talend etc.
• Download & upload data from Hadoop HDFS & Azure HDInsight through SSIS
• Building Tableau dashboards using stack bars, lines, dual combination, heat maps, tree maps, symbol maps, filled maps, horizontal bars according to deliverable specifications.
• Effectively used data blending feature in tableau.
• Designed and developed graphic rich visualizations with Drill Down and Drop Down menu option.
• Designed different components using C# language and used Exception handling, Error providers to handle exceptions.
• Develop adhoc reports for users.
• Utilized the Azure polybase utility to run t-sql queries on external data in Hadoop and as well as to import and export data from Azure blob storage.
• Defined best practices for Tableau report development.
• Involved in automation of jobs in Tableau.
• Working on data sources such as Oracle and Hive.
• Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled Full/Incremental refreshes of dashboards depending on the business requirements for data sources on Tableau Server.
• Involved in creating Tableau reports using complex custom SQL queries.
• Involved in designing new projects and execute them with minimal human resources.
• Experience Depth in POWER BI With Tableau Background.
• Administered Tableau server and helped in tuning of server.
• Involved in gathering information from clients and Monitoring the Team.
• Worked with MySQL and optimization of SQL Queries.
• Created semantic/metadata layer in Tableau.
• Created executive dashboard with KPI visualization (1-2 dashboards, 4-8 KPIs)
• Created underlying drill through detailed reports
• Created Wide variety of dashboards.
• Involved in creation of aggregated tables using OLAP data source (DW)
• Worked with customers, internal and external, to define and document the scope and functional requirements for data and reporting needs.
• Involved in backup of tableau server and optimization of server performance
• Closely worked with manager for designing the requirements.
• Integrated Jasypt encrypted data into tableau and integrated special passwords for viewer to look the sensitive data.
• Created real-time streaming Operational Data Store environment with Azure event hubs and stream analytics which directly streamed into MS Power BI for corporate reporting.
• Worked in integrating the tableau into mobile applications.
• Configuring the analysis for scheduling auto emails from Tableau automation.

Environment: Tableau 10.5/10.3, Hyper extracts, Tableau server, Jira, Azure, Marklogic, MS Excel, C#, SSIS, Oracle, SQL.

Confidential, New York city, NY

Sr. Tableau Developer

Responsibilities:

• As Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created complex dashboard using parameters, sets, groups and calculations and also drill down and drill up in worksheets and customization using filters and actions.
• Experienced in developing Web Services with Python programming language.
• Used Informatica session variables/parameters and source audit tables for incremental data extracts from source applications.
• Developed ETL solutions in Alteryx.
• Responsible for the design, development and production support of interactive data visualizations used across the company.
• Solving P1 issues for the users in the production.
• Worked with Informatica Deployment Groups in migrating the ETL code across environments.
• Responsible for Optimization of Informatica mappings, sessions, SQL queries.
• Ensure that the Installation, support and management of WebLogic within the environments are in line with corporate standards.
• Built and maintained Microsoft Server 2012 R2
• Configuring SSL on WebLogic server development and QC environments and provide the step to configure in production environments.
• Installed and maintain Microsoft SQL Server 2016 to a Microsoft Server 2012 R2
• Involved in creating a dual-axis bar chart with multiple measures.
• Perform maintenance activities in a large environment composed of a mix of different UNIX/Linux, platforms and configurations. Trouble-shoot hardware, software and network related problems.
• Involved actively in coding PL/SQL based on business requirements.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Translated business logic from one system (SQL, Excel, etc) into Alteryx in a quick and accurate manner.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
• Demonstration of the tableau dashboards and its functionality to the business users for the self-service business intelligence.
• Developed PL/SQL triggers on master tables for automatic creation of primary key values.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Worked on Tabcmd to schedule the report's and setup email reports using command lines.

Environment: Windows XP, Tableau 10.3, Tableau server, SSIS, MS Excel, MS word, Jira, SQL server, SQL.

Confidential, Englewood, NJ

Tableau Developer

Responsibilities:

• Used best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel.
• Developed custom designed dynamically chart selection driven dashboard which shows 10+ data visualization in a single dashboard.
• Indexed all columns whichever are part of Tableau Table Join/Filter operation to ensure improved time efficiency.
• Used union table feature in Tableau during the Meta data connection window to leverage database structure and schema.
• Created multiple visualizations using Bubble chart, Bar chart, Line chart, Pie Chart, Donut chart, Scatter plot, Gantt Chart, side by side Bars, side by side circles, packed bubbles, Histograms, Filled geo-maps, Symbol geo-maps.
• Used Ranking feature in Crosstab worksheet to highlight the Top N ranks of custom chosen dimension based on specific measure.
• Created multiple story to describe systematic data analysis with areas of data security risks.
• Data Pulse Reports are used to analyze volume of Applications across sectors and their usage in terms of frequency and duration.
• Ensured precision and maintained sanity for data table calculation using the Tableau partitioning and addressing feature.
• Designing standards for database table, Column, Procedures and Views.
• Dramatically Increased Query Performance and enhanced response time for statistical reporting by more than 35% after Monitoring, Tuning and optimizing Indexes using Performance Monitor, SQL Profiler and Index tuning wizards (DTA).
• Written dynamic SQL batches to perform the bulk operation in OLTP environment.
• Designed Mappings between Sources to Operational Staging Targets, Using Star Schema, and designed logic for incremental load using slow changing dimension and Check sum.
• Designed SSIS Packages to transfer data between servers, load data into databases and archive data files from various heterogeneous sources like SQL Server OLTP, Flat Files, Excel and CSV into SQL Server 2012.
• Created SSIS packages to load data into Data Warehouse using various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Used SSIS to implement the Slowly Changing the Master Package has to be scheduled which will in turn fire the other packages.
• Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Implemented Master/Child Packages so only gathered requirements and coordinated with the business to assure satisfactory data content, quality, data integrity and receipt of desired information.
• Created charts (Pie, Column, line, Histogram, dual axis charts) and dashboard using Tableau. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently using tableau.
• Generated context filters and data source filters while handling huge volume of data using tableau.
• Built dashboards for measures with forecast, trend line and reference lines using tableau.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis using tableau.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Involved in Report generation using SSRS and Excel services, Power BI and deployed them on SharePoint Server.
• Used Power View and created various analytical reports and Dashboards to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Deployed SSRS reports to the reporting server in SharePoint Integrated mode and assisted in troubleshooting deployment problems.
• Generated different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Used the Analytics tab in Tableau and performed the forecasting feature to predict the portfolio composition in user holding in line with historical data.
• Published the created dashboard in production server and maintained load balancing feature on.
• Implemented advanced geographic mapping techniques and use custom geo coding to build spatial visualizations of non-geographic data.
• Transformed massive datasets through grouping, aggregation, and Complex table calculations.
• Consulted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
• Generated Tableau Dashboard with quick/context/global filters, parameters, and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security.
• Responsible for Publishing the desktop version dashboard to the server and maintenance of server activity (Versioning, Data extract refreshing via server scheduler).

Environment: Windows XP, Tableau 9.0, Tableau Server, SQL, MS-SQL 2008, MS-Access, MS Excel and Salesforce.

Confidential

SQL/Tableau Developer

Responsibilities:

• Created the Analytical visualizations based on the AIP data to provide the clear discrimination of in-scope vs. Out-of-scope Applications and Active vs. inactive Applications across Organization down to various departments.
• Responsible for conducting requirements gathering sessions with business and prepared high level functional specification document for the application.
• Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
• Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
• Created custom joins through calculations to bring multiple heterogeneous data source together.
• Used advance analytics features Reference line, Reference band, Distribution band, Trend lines in creation of Tableau dashboard.
• Responsible for tracking defects and issue raised by the business users and communicating the same to developers.
• Participated in change request session with business users and conveying the same to developers with functional document; and tracking the progress of change request with Jira.
• Responsible for the gap analysis during the assessment phase of changes.
• Published the dashboard to the server and maintained the server sanity with the use of in Tableau in memory feature and load balancing standards.
• Tuned the database after publishing content to Tableau server.
• Supported the Published Tableau dashboard while migrating to newer versions.
• Created SSIS packages using Pivot transformation, Fuzzy Lookup, Conditional Split, Term Extraction, Aggregate, Execute SQL Task, Data Flow Task, to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed and tested packages to extract, transform and load data(ETL) using SSIS, designs packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data conversion, For each Loop container.
• Intensively worked on transformations like derived columns, import columns, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.
• Created Drill-down and Drill-through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
• Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).
• Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements.

Environment: Tableau Desktop 8.2/8.0/7.0, Tableau Server, SQL Server 2008/2012, PL/SQL, MS-Access, MS Excel and SQL.

Confidential

Jr. SQL server Developer

Responsibilities:

• Interacted with Team and involved in Analysis, Design and Developing databases using ER Diagram, Normalization, and relational database concepts.
• Involved in Design, Development, and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for application development.
• Wrote SQL Scripts to select the data from the source. Designed and implemented data access stored procedures and triggers for automating tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.