SUMMARY

• Over 8 years of IT experience as Tableau Developer, data discovery, data visualization, data analysis, report development and SQL/SSIS/SSRS 2012/2008R2/2008.
• Conversant with all phase of Software Development life cycle (SDLC) including development, designing, analysis, coding, testing and implementation.
• Worked to a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating data models to designTableausolutions and in developing interactive visualizations.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues withinTableau ServerandTableau desktop report
• Experience in Installation, Config and Adminof Tableau Server in amulti - serverandmulti-tierenvironment.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Expert in Developing, Designing and supporting interactiveTableauDashboard reports
• Professional in communicating Dashboards perTableauvisualization features
• Proficient in Building compelling, interactive dashboards inTableauthat answer key business questions
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in MS SQL Server 2012/2008R2/2008/2005 BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Experience in using Change Data Capture for track DML Operation on Database level.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, Hadoop, DB2, Sybase, Excel and MS Access, CSV, Oracle, flat file.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Expert in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 8/7/6/5, Tabcmd, Tabadmin, SSIS 2005/2008/2010/20012 , SSRS 2005/2008/2010/20012 , DTS

Relational Database: Microsoft SQL Server 2012/2008R 2/2008/2005/2000 , Oracle, Microsoft Access 2007/2003

Data Modelling: Microsoft Visio 10.0/11.0, ERWIN 4.0/4.1/4.2/7.2

Programming Language: MS-SQL, C#, VB.NET, PL/SQL

Operating System: Windows XP/ 7/8/2003/2000 , UNIX, MacOS

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Tableau Developer / Administrator

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of TableauServer in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in Tableau environment.
• Created and managed schedules for users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
• Implemented various data connections from data source toTableauServer for report and dashboard development.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Created guided navigation links for Interactive dashboards in Tableau.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle, SQL Server, MS Excel, and other ODBC Databases.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Pushed all the created stored procedures and functions to the development, testing and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.

Confidential, Bowie, MD

Tableau Developer / Administrator

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further references.
• Involved in installation and configuration of Tableau Server.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Involved in creating dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations in Tableau Desktop
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Implemented data blending to blend related data from two different data sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Generated insights out of voluminous and complex datasets and built story lines.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements andanalyzingdata sources from Excel, Hadoop, Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing Analytical dashboards and worksheets for LOB mangers in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Expertise SQL Optimizing by using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Develop SSIS package for implement Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.

Confidential, Coral Springs, FL

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generating Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Confidential, Bellingham, WA

MS SQL SSIS/SSRS/SSAS Server developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8minutes.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Created Queries, Stored Procedures, and Views to store the data of clients, advisors, Created User Defined Functions, Triggers to store data into appropriate tables and when Data arrives and then creating indexes to the tables to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Created many complex Stored Procedures/Functions and used them in Reports.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008.
• Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008.
• Created reports to retrieve data using stored procedures that accept parameters.

Confidential

SQL Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.