SUMMARY

• Over 8 years of IT experience as Developer on Tableau, 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 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, Gantts, 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, 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, Albany, NY

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.
• Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• 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 and MS Excel.
• 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.

Tools: & Technologies: Tableau Desktop 8, Tableau Reader, Tableau Public, Tableau Server 8/7/6/5, SQL Server 2012/2008R2/2008, Server Integration Services 2008, SQL server Reporting Service 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN 7.2, .NET.

Confidential, Stamford, CT

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/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.

Tools: & Technologies: Tableau Desktop 7, Tableau Reader, Tableau Public, Tableau Server 8/7/6/5, MS SQL SERVER 2008/2005, SSRS 2008/2005, SSIS 2008/2005,T-SQL, MS Visio 2007/2003, Windows 2003/2000 Advanced Server, Erwin data modular 7.2, C#.Net 2005.

Confidential, Beaufort, SC

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.

Tools: & Technologies: Tableau Desktop 7, SQL Server 2008/2005, BIDS 2008/2005, Integration Services 2008/2005, Visual SourceSafe, T-SQL, MS Access, Windows XP/2007 Server, SQL Profiler, Index Tuning Wizard.

Confidential, Hartford, CT

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.

Tools: & Technologies: MSSQL Server 2008, SSIS2008, SSRS2008 with Microsoft Share point Integration 2007, SSAS 2008, Windows XP, MS EXCEL.

Confidential, New York, NY

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
• 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.

Tools: & Technologies: MS SQL SERVER 2005/2008, SSRS20005/2008, SSIS 20005/2008, Erwin, Visual Studio 2005, MS Office 2003, Windows 2003.

Confidential, Jersey City, NJ

Jr. Administrator/Programmer

Responsibilities:

• Easy-to-use, intuitive software - reduce training time. Touch screen interface pre-configured graphics - deliver fast, accurate service.
• Integrated credit card processing - provide customers with payment alternatives. Built-in redundancy - avoid data loss and POS system downtime
• Comprehensive front-of-house reporting - reduce time in back office. Modular, flexible design - implement a solution that grows with your business.
• Familiarity with basic office software tools, one or more programming languages as appropriate for the specific requirements in the department, classes related to the programming field.
• Good written and oral communication and interpersonal skills, highly logical, technically proficient. Highly self-motivated and directed and keen attention to detail.
• Recruit, interview, select, and retain outstanding management personnel. Consistently and continuously focus on developing management teams.
• Give feedback and coaching to team to help improve performance. Monitor and evaluate performance of store managers. Handle discipline and terminations of store managers.
• Ensuring completeness of paperwork submitted to office in a timely manner. Ensure that store records are in compliance with federal, state, and local laws.
• Conduct regularly and timely performance evaluations for store managers. Audit cash handling procedures and perform monthly safe audits.
• Demonstrate practical knowledge, problem solving, and decision-making skills; anticipate problems and develop workable solutions.
• Perform quarterly compliance audits. Updating back-office payroll system.
• Maintain the operational efficiency and profitability of the stores to meet or exceed their budget. Ensure that store budgets are met. Additional duties as assigned.

Tools: & Technologies: RDS (Retail Data System), MS SQL SERVER 2005, Visual Studio 2005, MS Office 2007, MS EXCEL, HTML.