SUMMARY:

• Over 9 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications.
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.2 8.1, 8.0, Tableau 7 and Tableau 6.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Expert in modelling Transactional Databases and Data Warehouse, Risk management.
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters.
• Working extensively in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Experience on scripting using Tab cmd and Tab admin
• Extensive experience on building Analytic Dashboards using Tableau.
• Experience in data warehousing using Amazon Redshift.
• In - depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Designed and Implemented scalable, secure, cloud architecture based on AWS.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Manage the Tableau solution architecture, administration and actively manage the performance and usability. Align/standardize team members on best practices around Tableau driven implementations
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Creating offline, online maps and also create custom geo coding and WMS-server to build spatial visualizations of non-geographic data.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and also use multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Working with ETL tools and Relational Database Management Systems (RDBMS) in multiple vendor products.
• Experienced in XML validation and XML Comparison testing.
• Expertise in writing TSQL, SQL Queries, Big query, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS)
• Expertise in working with different databases like Netezza, Teradata, Google Analytic, MS SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL Navigator, Teradata SQL Assistant.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Tableau Developer/Admin

Responsibilities:

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Manages platform admin functionalities including installations/ configuration, upgrades, patches, change management, performance tuning, meta data Management and user management scheduling
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summaryreport and Dashboard using KPI’s
• Experienced in data warehousing using Amazon Redshift when dealing with large sets of data. Developed complex visualizations using Amazon Redshift.
• Experience on scripting using Tabcmd and Tabadmin.
• Developed SQL Queries to retrieve or create test data from different Redshift databases Monitor loans and manage risk across geographies with interactive dashboards
• Business Intelligence, Operational Risk Loss Data Management.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Experience in creating and managing Tableau sites.
• Experience in creating filters, quick filters, data source filters, local & global filters, context filters and user filters.
• Responsible to Identifying and assessing risks, determining the impact to platform.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations. Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Creating calculated fields, groups, sets and hierarchies etc. Creating data blending in case of merging two different datasets.
• Built complex formulas in Tableau for various business calculations.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating dashboards by extracting data from different sources.
• Involved in creating calculated fields, mapping and hierarchies. Administered user, user groups.
• Write SQL statements to view database table. Pulling reports using PL / SQL Developer.
• Creating ad hoc queries and reports in support of the business process using SQL and excel formulas Via SQL provide data analysis and execute data validation from external vendors prior to import into Fannie Mae internal systems.
• Publishing the developed reports to production Tableau server environment.

Environment: Tableau Desktop 9.x, 8.3, Tableau server 9.x, 8.3 windows server 2008, Oracle 10g, Microsoft Excel, MS Access, Amazon Redshift, Data warehouse Teradata.

Confidential, PA

Tableau Developer

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Deep experience with the design and development of Tableau visualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Migrated existing Micro strategy Reports to Tableau workbooks.
• Created Tableau extract files for improving the performance.
• Installed and upgraded Tableau server and experienced in server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Creating calculated fields, groups, sets and hierarchies etc. Creating data blending in case of merging two different datasets.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Interacted professionally with a diverse group including executives, managers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Responsible for Developing a Dashboard.

Confidential, CA

Tableau/SQL Developer

Responsibilities:

• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• 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.

Environment: Tableau 7, Tableau Server, Teradata.13.0. SQL Server 2008, MS Office2007.

Confidential

SQL Developer

Responsibilities:

• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Good understanding of SSRS with Report authoring, created daily, weekly and monthly reports as per requirement using SSRS.
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS
• Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Worked on SSRS reports and fine-tuned SSRS MDX queries.Also worked as a part time BA in mappings of the reports.Created an SSIS Packages for loading mappings into Tables.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created forms and reports to implement front-end interface for users using Forms 6i/10g and Reports 6i/10g.
• Performance tuned the existing SSAS cubes in order to minimize the processing time.
• Created and fine-tuned various fact tables and dimension tables supporting numerous cubes.
• Worked extensively on SSAS storage and partitions, aggregations and calculations. Used MDX to create calculation formulae to enhance the cube productivity.

  Environment: SQL Server 2008R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, PL/ SQL, SSIS, SSRS, SSAS.

Confidential

Consultant

Responsibilities:

• Created SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by front end applications.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created database documentation for table and column dictionaries and other reference material.
• Implemented indexes on tables and views for optimum performance tuning.
• Involved in dimensional data modeling and story boarding ETL processes.
• Designed the ETL process using SQL Server 2005 DTS Packages with multiple data sources including Flat files, Access, Excel.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling.
• Wrote custom SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.

Environment: MS SQL Server 2008 R2/ 2005, SQL Server Management Studio.