PROFESSIONAL SUMMARY:

• Having around 7 years of experience working with Business Intelligence data visualization tools with specialization on Tableau 10.0/10.2.1/10.3/10.4
• Experience in creating workbooks and dashboards using Tableau Desktop, Server and Reader with various versions 7/8/10.
• Experience in Tableau Desktop/Server in creating highly interactive Data Visualization Reports and Dashboards using complex functionalities such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Experience in developing dashboards with different chart types like heat maps, pie charts, geo maps, tree maps, symbol maps, gnats, scatter plots, line charts, area charts, and donut charts.
• Ability to build dashboards with techniques for analytics with interactive dashboard design with filtering, highlighting, ability to combine multiple data sources, fast creation by a user, easy sharing for visually best practices.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in SQL Server 2005/2008 R2/2014/2016 Reporting Services (SSRS), SQL Server 2005/2008 R2/2014/2016 Integration Services (SSIS) and in SQL Server 2005/2008 R2/2014/2016 Analysis Services (SSAS) in Business Intelligence (BI).
• Experience in creating complex visualizations such as creation of Pareto, Control charts, waterfalls & built - in charts.
• Preparation of Agile approach & detailed task identification, resource estimation to prepare project plan.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Analyzed & used Tableau Server system requirements based on many factors, including teh number of users & target workload.
• Tracked Tableau Server Performance for Alerts, Monitoring, Tuning and Troubleshooting.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled teh Reports in Report Manager.
• Integration of SSRS Reports using various web parts into Sharepoint (MOSS 2007) and various delivery mechanisms.
• Extensively worked with large database Teradata in Development, Test and Production environments.
• Extensive experience on building real-time Interactive dashboards in Tableau using drilling downs and customizations.
• Expertise in Teradata tools & Utilities like Fast Load, Multi Load, Fast Export, TPump and Teradata Parallel Transporter (TPT) & BTEQ.
• Experience in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL.
• Experience in creating Packages, Jobs and Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal
• Mastered teh ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameters using Tableau
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades
• Good Exposure on Power tools for Tableau desktop for Workbook Merge, Data Source Audit, Performance Analyzing and Data Source Discovery.

TECHNICAL SKILLS

Databases: MS SQL SERVER 2000/2005/2008R2/ 2014/2016, MYSQL 5.0, Teradata V2R6, DB2, Oracle 9i/11g, 10g, Sybase

Operating Systems: Windows 2007/XP/Vista/2003

BI Tools: Tableau Desktop (10.x/9.x/8.x), Tableau server (10.x/9.x/8.x), Reader, Online, Crystal reports, MS Excel, SSRS

ETL Tools: SQL Server Integration Services (SSIS).

SQL Server Tools: SQL server management Studio, BIDS, SQL server profiler, FTP, TOAD.

Programming languages: C, C++, Visual Basic, SQL, QA, Oracle PL/SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA

Data Modeling: Erwin 4.0/3.5.2, Rational Rose

Methodologies: Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/ Physical/ Dimensional, Snow Flake Schema, ETL

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Tableau Developer

Responsibilities:

• Took part in end to end implementation and enhancements from gathering requirements data and dashboards development in Tableau Desktop.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements for CCAR & DFAST 2016 submission.
• Worked Closely with ETL Architecture and reporting BA in creating teh Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.
• Worked on data from multiple data sources including Oracle, Hyperion Essbase, CSV file and ODBC connections. Created Reusable dashboards to utilize teh same process for all teh PPNR & Mortgage Models for Different Source systems.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Migrating reports from standard reporting tools like excel to tableau.
• Transformed raw data into Visual Analytics with projection of significant KPIs.
• Created Dashboards to allow teh users to dynamically interact with teh data to teh lowest level of granularity.
• Created Tableau Semantic Metadata dashboard, acts as a self-service tool to quickly pull teh DataMapping of in house 65 + Tableau Data Sources.
• Migrating all teh reports from tableau 9.3 to tableau 10.3 and publishing them on teh server.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Developed and reviewed SQL queries with use of join clauses in Tableau Desktop for validating static and dynamic data for data validation
• Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab, donut, pie and highlight tables
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed
• Executed and tested required queries and reports before publishing.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Crosstabs, Histograms etc.
• Developed TEMPeffective and interactive Dashboards using Parameters and Actions
• Developed donut charts for analyzing sales planning data.
• Created ETL meta-data reports using SSRS, reports including execution times for teh SSIS packages and failure reports with error description.
• Tableau desktop and server tickets resolution (primary contact for support)
• Mastered teh ability to design and deploy rich Graphic visualizations using Tableau.
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Created Actions in Worksheets and Dashboards and enhanced teh user interactivity.
• Followed SCRUM (Agile) methodology and developed a dashboard with value added product.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Developed KPI's and dashboards based on reports, spreadsheets, and charts.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Environment: Tableau Desktop 10.4, Tableau server, Windows XP, MSOffice (Word, PowerPoint, Excel, Visio), Oracle, SQL Server, Teradata.

Confidential, CA

BI Developer

Responsibilities:

• Involved in requirement gathering and analysis of business requirements, participated in requirements review meetings with business users, clients, project management and other teams.
• Involved in capacity planning, project estimations and setting teh projects timelines of projects or deliverables.
• Worked as an onsite coordinator and TEMPeffectively led offshore team by work assignment, code review and on-time delivery of teh projects or deliverables.
• Worked on creating dashboards and data visualizations, KPIs using Power BI.
• Good Experience of Data Analysis Expressions (DAX) usage in developing dashboards and reports using Power BI.
• Worked on publishing teh reports and dashboards from Power BI Desktop to Power BI Report web portal.
• Used most advanced visuals and slicers available in designing teh most user friendly and advanced reports and dashboards in Power BI.
• Created KPIs, Sankey charts, shape maps within Power BI reports.
• Experienced in managing datasets, reports, queries, workspace and dashboards in Power BI.
• Managing teh security and sharing teh reports within organization and outside organization.
• Scheduling teh data refresh in Power BI
• Used Power BI Power Pivot to develop data analysis reports and used power view and power map to visualize teh reports.
• Worked on cubes creation using SSAS.
• Involved in analyzing, designing and developing OLAP cubes with SSAS and adding calculations using MDX.
• Good knowledge on Tableau.
• Created SQL reporting services (SSRS) reports, sub-reports and taking care of teh deployment issues.
• Created various SSRS reports like linked reports, ad hoc reports, sub-reports, tabular reports, charts and matrix reports.
• Implemented automatic report sending using SSRS subscriptions.
• Created crystal reports on need basis.
• Migrated data from different sources (text based files, Excel spreadsheets, legacy systems and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on various tasks within an SSIS package like script tasks using C#, sequence container, for loop, for each loop container, SQL tasks, files system tasks and data flow tasks etc.
• Extensively worked on Deployment, Performance tuning of SSIS packages, data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.
• Implemented email notification, notifying teh support team on teh status of teh scheduled jobs.

Environment: SQL Server 2008/2012/2014, SSMS, BIDS, Visual Studio 2010/2013, SSMS, BIDS, TFS 2010/2013, IIS 7/8, ASP .Net 3/3.5/4, MVC 4/5, Entity framework 5, QNXT 4.8/5.3, Power BI, Power Pivot, Crystal Reports

Confidential, Dallas, TX

Sr. Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements for CCAR & DFAST 2016 submission.
• Worked Closely with ETL Architecture and reporting BA in creating teh Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.
• Work with business in understanding teh Nature of Data, accordingly will get teh best possible way to create dashboards in Tableau for different Domains using Oracle and Essbase data sources.
• Worked on data from multiple data sources including Oracle, Hyperion Essbase, CSV file and ODBC connections. Created Reusable dashboards to utilize teh same process for all teh PPNR & Mortgage Models for Different Source systems.
• Hands on experience on reports using Micro strategy and Qliksense and analyzed with Tableau reports for data consistency.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Provided Production support to Tableau users and fine-tuned Custom SQL scripts to support business requirements.
• Published and shared views on Tableau server and Scheduled extract refresh and subscriptions.
• Advocate teh use of Tableau solution and halp educate business users to facilitate early adoption of teh tool.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Generated Tableau dashboards with forecasting, Dual Axes and Reference Lines.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked on performing various dashboard activities such as grouping, sorting, ranking and ordering teh data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Trend Analysis (Data vs Time).
• Developed SSIS packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into teh SQL table.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Developed several Teradata SQL Queries using Teradata SQL Assistant for ad-hoc data pull request.
• Created customized reports with prompts and features like Conditional formatting, Master -Detail, Drill - through using Cognos Report Studio.
• Developed complex queries across various databases using MS Access to drive process automation and report development.
• Developed Cognos reports using Cascading Prompts, optional prompts and Report Bursting.
• Extracted large volumes of data from various data sources and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).

Environment: Tableau Desktop 8.3/9.0/9.2/10.0, IBM Cognos, SQL Server 2008/2013, Teradata, MS Excel, MS Access, SAP BO, SSIS.

Confidential

Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, UAT and Prod environments.
• Upgraded Tableau 8.1 environment to Tableau 8.2
• Generated reports using cognos
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser, tablets or ipad.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Composed documentation related to visualization dashboards and performed end user training.

Environment: Tableau Server 8.x, Tableau Reader 8.x, Tableau Public 8.x, Oracle ERP Systems, SQL Server, Teradata.

Confidential

SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Used Tortoise SVN version control for changing teh codes.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Defining processes for each department or service request category and building them in Right Now CX.
• Used Bulk Collections, Indexes, and Materialized Views to improve teh query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL Loader.
• Wrote conversion scripts using SQL, PL/SQL, Stored Procedures, Functions and Packages to migrate teh data from teh SQL server database to Oracle database
• Performed database administration of all database objects including Tables, Clusters, Indexes, Views, Sequence Packages and Procedures
• Implemented 11g and upgraded teh existing database from Oracle 9i to Oracle 11g
• Performance tuned teh Oracle databases and user applications
• Used SQL Loader as an ETL tool to load data into teh Staging Tables
• Used DTS packages as an ETL tool for migrating data from teh SQL Server 2000 to Oracle 10g
• Improved teh performance of teh application by rewriting teh SQL queries
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, 11g, Json, Reports 9i, Oracle Right Now CX Console, SQL, PL/SQL, TOAD, SQL*Loader, Visual Basic 6, UNIX, UNIX Shell script, MS, Oracle Development Suite.