SUMMARY

• Over 8+ years of extensive Experience in the Business Requirements Analysis, Development, Testing, Implementation and maintenance of Business Intelligence, Data warehousing, Client Server applications, Web applications and Tableau Platforms.
• 5+ years of extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Created 1000+ worksheets and 200+ Dashboards in large BI environments using Tableau.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Reports development using various reporting tools like Tableau, SAS, SSIS, Spotfire and SSRS.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Used R Programmingand SAS Enterprise data miner for the analysis.
• Experience in complete Software Development Life Cycle (SDLC).
• Good knowledge on Spotfire, QlikView and Qlik Sense.
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
• Compiled and generate excel spreadsheets capturing key data using formulas, Pivot Tables, and VBA
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Extensive used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Good Understanding of various analytical report KPI’s, Indicators and Gauges.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform Loading (ETL) using Spotfire and SSIS.
• Expertise in design, analysis and implementation of data warehousing/ Power BI solutions using Tableau, Teradata, Oracle, Alteryx, Spotfire and Informatica.
• Experienced in Data Analyticsand Machine Learning with strong skills in analyzing large datasets using R, Weka and AWS.
• Skilled in data manipulation & cleansing, visualization, predictive modeling, and regression analysis using R, Python and Tableau
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, Greenplum, Netezza, MySQL, MS SQL Server

TECHNICAL SKILLS

BI Tools: Tableau 9x, 10x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Spotfire and Crystal Reports, Alteryx, 2008 XI, QlikView, SAP, Qlik sense, Power BI, MicroStrategy and Cognos

ETL tool: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), Data stage

Databases: Teradata, Oracle, Server 2000/2005/2008/2008 R2/2012, DB/400, MS Access, Oracle 11g/10g, Excel Flat files, Sybase, Hadoop, DB2, Cloud Computing / Services Amazon Web services - AWS, Amazon Redshift, Hive (Cloudera Hadoop), Netezza, SAS, SQL server, Greenplum

Applications: Microsoft Office, ProClarity, AdobePhotoshop7, Adobe Illustrator, MS Visio, Visible Analyst

Operating Systems: Windows Server 2000/2003/2008, Windows 98/2000/XP/VISTA/7 UNIX, Linux, Solaris, Mac

Languages: C, C++, Confidential -SQL, XML, UNIX, Oracle, Java, Python, VB, PL/SQL

Web Scripting Languages: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio 2003/2005

Web Tools: MS-Front Page, Dream Weaver

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Created Tableau Bread Crumbs, using tableau filter actions for Scale with Digital Dashboard.
• Investing the data using Exploratory AnalysisDatafor Scale with Digital and FFS tax Reporting Dashboards
• Developed Tableau Excel incremental refresh for year 2017 and up to Jan 2018 Confidential for various financial dashboards.
• Utilized R-Studio and Tableau to clean, filter and merge datasets with over 200,000 rowsand 100 variables to provide preliminaryExploratory Analysisand data visualization.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data and Provided tableaudesktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on scheduling reports, managing data sources and refresh extracts and Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and Financial dashboard
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau and Develops and provides documentation, training, and support for Interactors and Power Users
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Work with clientand team members to understand and clarify visualization requirements and check performance tuning of dashboards.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata, Hadoop) using data blending.
• Worked in Tableauenvironment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Developed and Published the dynamic dashboard reports to Tableauserver for navigating the developed dashboards in web.
• Administered and provided production support for Enterprise wide Tableauapplication consisting of multiple key functional business domains.
• Worked on TableauAdmin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau. Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau(Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), Teradata Administrator.

Confidential, Rockville MD

Sr. Tableau Consultant

Responsibilities:

• Gathering the report requirements from various stakeholders, SME’s, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Worked on gathering and converting data over toTableauusing SQL/SAS/Excel data over totableau reports and Dashboards.
• PerformingExploratorydata analysis on time-series data of macroeconomic indicators in R over three decades time horizons
• Implemented ExploratoryData Analysis, Data Cleansing, Preprocessing and Feature Engineering.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Automated the incoming data intake using RProgramming.
• In-depth knowledge of Confidential -SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Prepared backups using Tab admin and Tab cmd commands.
• Experience in designing and developing complex Talend/Data Stage jobs, routines
• Use various data source like SQL server, SQL Analysis server (cube), Amazon Redshift, Hadoop and Hive
• Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Qlik view and Qlik Sense Environment
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS
• Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
• Strong experience in creating the extensions using Java script both in Qlik view and Qlik Sense.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAPReporting needs.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.

Environment: TableauDesktop 9.x, 10.x, Tableauserver, JavaScript API, Teradata, Tableau public, SQL Server, Data view, Alteryx, Hadoop,Oracle 10g, Excel files, Python, MySQL, API Development Toad, Netezza, SAP Hana, R Programming, AWS, VLOOKUP, SAS, Crystal Report, Data Microsoft Excel 2007, Cognos, Java Script API, MS Access, Windows 2007 server, Informatica.

Confidential, Tampa, FL

Tableau Developer/BI Developer/ Tableau Admin

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities
• Designed and built statistical and machine-learning models and feature extraction systems in Python and R Programming
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• ConductingExploratorydata analytics for the combined data sources In Tableau to evaluate the relationships.
• Studied various Statistical Data Mining Methods, Random Forests, Neural Nets and applied them on data to get insights using R Programming.
• Experience in configuring and deploying SSRSreports onto Microsoft Office SharePoint Server.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL, BIand Life Cycle Development including requirement analysis, design, development, testing and implementation
• Power BI developer with skills as well to help deliver a set of dashboards.
• Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI
• Good Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Review new API development specification releases and update portal content.
• Designed schema in Amazon Redshiftcluster to store EBS operational data optimally.
• Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards using R Programming.
• Design Amazon Redshift based Power BI solution platform for optimized performance and usability.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tab cmd to schedule the report's and setup email reports using command lines.

Environment: Tableau Desktop 9x, Tableau Server, SQL Assistant, SAP Lynx, SharePoint, Hadoop, Microsoft SQL Server, Terada, MS Visio, Greenplum, Excel files, MySQL, SSRS, SSIS, Toad, Python, VLOOKUP, JavaScript API, IVR, Cognos, AWS, R Programming, Microsoft Office Suite (Word, Excel, PowerPoint), Alteryx Designer, OLAP, MS Access

Confidential, Minneapolis, MN

Tableau Report Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Used Parameters, Calculated fields, LOD's, and sets to handle views more efficiently on Tableau Reports.
• Built complex formulas in Tableau for various business calculations.
• Extensively used SQL in command objects of Crystal Reports,
• Enhance/modify existing reportsby creating new Parameters, Formulas, Filters.
• Designed, developed, tested and deployed ECR (Enterprise Custom Reports) on internal and client environments using SQL Server Reporting Services(SSRS)
• Schedule the reportsusing Info View to run Confidential specific times in a day/week as desired by the Business Users using Business Objects Enterprise, Central Management Console.
• Provided 24/7 production support for Tableau users
• Combined views and reports into interactive dashboards in Tableau Desktop which are presented to End User.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards.
• Wrote complex SQL queries on Netezzaand used them in lookup SQL overrides and Source Qualifier overrides.
• Involves data collection, data cleanup, data transformation, Exploratory analysis, statistical Analysis and modeling.

Environment: Tableau 8.2, Tableau 7 desktop, Tableau server, Oracle 11i, Informatica 8.x, Sql server, TOAD, MS-Access, JavaScript, crystal report 2008

Confidential, Richardson, TX

Tableau Analyst (Tableau Developer\Tableau Admin)

Responsibilities:

• Involved in Exploring, Designing, Building, Testing and Deployment of the high-level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics usingTableauDesktop
• Involved in understanding the reporting requirements and providingTableaureporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards usingTableau Desktop and publish it toTableauServer to meet business specific challenges.
• Understanding and translation of the current existing reporting system Spotfire, SSRS reports to convert them as Tableau reports and dashboards.
• Configured Tableau server to use Kerberos, SSO solution so that all the authentication is handled by the SSO solution.
• Installation and configuration of Tableau Products Tableau Desktop and Tableau Server in different environments DEV, STAGE and PROD.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Created stored procedures on Netezzaand Oracle database to achieve complex ETL logic.
• Applying SAPNotes, maintaining OSS connections, Generating Developer/Object keys.
• Extensively used Talend Big data tool to load the big volume of source files from S3 to Amazon Redshift.
• Developed complexSASprograms, macros for data updates, data cleansing, and reporting
• Involved in publishing of various kinds of live interactive data visualizations dashboards reports and workbooks fromTableauDesktop toTableauservers.
• Created actions parameters Filter Local Global and calculated sets for preparing dashboards and worksheets usingTableauDesktop.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes statistics to improve the query turnaround time efficiently.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Environment: TableauDesktop 8, 9.1,tableauserver 8.0,9.1, MS office suite, Hadoop, Teradata, Oracle, SQL Server, visual Studio 2010/2012, Greenplum, Informatica, MySQL, SSRS, SSIS, Toad, Netezza, OLAP, Excel files, Python, JavaScript API, SAS, AWS, R programming, MS Excel, IVR, Flat File Microsoft SQL Server 2005\2008 data base.

Confidential

SQL Developer/ ETL Developer

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Expertise in developing SQL's and stored procedures for interacting with the database.
• Strong Experience in developing Sessions/Tasks, Worklets, and Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer.
• Experience working with ASP.NET as frontend team.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS2008.
• Used DDL and DML to be writing Triggers, Stored procedures to check the Data Integrity and payment verification Confidential early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data
• Involved in creating project related analysis, approach and testing documents.
• Created/Maintained clustered/non-clustered Indexes for fast and efficient reporting process
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Involved in writing Confidential -SQL statements for retrieval of data.
• Worked on performance tuning of Confidential -SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.

Environment: MS SQL Server 2000, Enterprise Manager, MySQL, Toad, Confidential -SQL, DTS, Netezza, OLAP, Query Analyzer, SQL Profiler, Star-schema, Snowflake schema, SSRS, SSIS, Crystal Reports, Teradata, Software Development Life Cycle - Agile, Tableau, Unix.