SUMMARY

• Over 7+ years of Data warehousing experience wif Business Intelligence Tableau 8.0/ 7.0, SAS, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies.
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1, 8.2 and 9.0 as a developer.
• Extensive noledge in creating wide number of Dashboards and worksheets in large BI environments using Tableau 9.0/8.1/8.0/7.0.
• Good hands on experience in handling Master tickets and resolving issues of users.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Good experience on Security measures that teh cloud service provider (AWS) implements and operates.
• Experience in developing and implementing tableau changes such as upgrades and migration.
• Experienced wif Performance Tuning and Optimization of teh Rendering Time on teh Visualizations and Dashboards.
• Reports development using various reporting tools like Tableau, SAS and SSRS.
• Experience wif CISCO’s Composite Data Virtualization Platform.
• Excellent noledge in RDBMS concepts and constructs along wif Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• 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 teh end user requirement.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 9.0
• 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 DTS and SSIS.
• Expert in generating Drill down and Drill through reports wif Drop down menu option, sorting teh data, defining subtotals in SSRS.
• Proficient in handling parameterized reports in SSRS.
• Good noledge on scripting languages like python, bash and ruby.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Good ability to Provide 7/24 Production Support for Tableau
• Good ability to work independently and well in a team.

TECHNICAL SKILLS

Data Warehousing ETL Tools: SSIS, Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2

Databases: SQL Server 2012,SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MYSQL, Data warehouse.

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Reporting Tools: Tableau 8.0/7.0, SAS, SSRS, Crystal Reports 9.0/8.5,OLAP

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop.
• Worked directly wif business customers to build reports, dashboards and ad-hoc reports.
• Good hands on experience on terra data DBA and modern data ware housing.
• Good experience on security measures that teh cloud service provider (AWS) implements and operates.
• Good noledge on security measures that teh customer implements and operates, related to teh security of customer content and applications that make use of AWS services.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Experience wif CISCO’s Composite Data Virtualization Platform.
• Implementing best-practices for teh dashboards wif a solid understanding of teh use of Contexts and their impact on performance.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving teh problems by coordinating wif senior managers in emergency and normal issues to meet teh goals.
• Functional Lead role in defining teh dashboard requirements and providing teh best practices/approach to perform ETL and publish data to teh reports/dashboards.
• In charge of teh team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server.
• Good noledge on scripting languages like python, bash and ruby.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Participated in Preparing Detailed technical documents from teh functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Executed and tested required queries and reports before publishing dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Good ability to Provide 7/24 Production Support for Tableau
• Good ability to work independently and well in a team.

Environment: Tableau Desktop 8.2, Tableau Server, MS Office Suite, Teradata, MS Excel.

Confidential, Hartford, CT

Tableau Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• 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 wifin Tableau Desktop.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Good hands on experience on terra data DBA and modern data ware housing.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created report schedules, data connections, projects, groups inTableauserver.
• Experience wif CISCO’s Composite Data Virtualization Platform.
• Involved in license management SLA's wifTableausupport.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableaurepository.
• Worked on various reports using best practices and different visualizations like Donut charts, Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected teh most.
• 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 SQL Server and MS Excel.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement teh business logic and also created clustered and non-clustered indexes.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Tested dashboards to ensure data was matching as per teh business requirements and if their were any changes in underlying data.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel.

Confidential, Tampa, FL

Tableau Analyst

Responsibilities:

• Effectively interacted wif Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gatheird user requirements, analyzed and designed software solution based on teh requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good hands on experience on terra data DBA and modern data ware housing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Data Connections, published on Tableau Server for usage wif Operational/Monitoring Dashboards.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in installation of Tableau desktop 7.0, Tableau server Application software
• 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.
• Creating New Schedule's and checking teh task's daily on teh server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tabcmd to schedule teh report's and setup email reports using command lines.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Environment: Tableau Desktop 8x/7x, Tableau Server/Administrator, Tabcmd, SSRS, SSIS

Confidential, Canonsburg, PA

Tableau Developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related wif each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure teh forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring teh correct selection of toolset available across teh Tableau BI suite.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting teh reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure

Environment: Tableau 7.0, SQL Server 2008 R2, SSMS, MS Excel, T-SQL.

Confidential

SQL BI Developer

Responsibilities:

• Directly interacting wif clients to elicit teh requirements and translate them into terms that development team can comprehend.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS
• Created star schema in SSAS and developed SSRS reports based on teh cube.
• Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and teh defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings wif developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in teh team wif appropriate documentation and domain noledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace teh slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Interaction and coordination wif end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Assisted clients wif 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.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored teh performance of teh Server.
• Tuned teh SQL queries using SQL profiler. Involved in tuning teh database. Created necessary indexes to make data retrieval process faster.

Environnent: MS SQL Server 2000, Enterprise Manager, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.