PROFESSIONAL SUMMARY:

• Having 8 Years of total IT experience in Analysis, design, development administration, and Implementation of Business Intelligence solutions & Tableau dashboards.
• 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).
• Successfully developed a Semantic layer using wide range of data sources, created data visualizations and allowed the end - users to interact with the UI dynamically.
• 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 the number of users & target workload.
• Designed and developed scripts to support UI visualization, ETL processes, automation, and workflow and dashboard presentation framework.
• Tracked Tableau Server Performance for Alerts, Monitoring, Tuning and Troubleshooting.
• Experience in developing Teradata databases, manipulating data and making change to dimensions in databases using Teradata Utilities.
• 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 the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• 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.
• Expertise in creating custom views using Tableau Server repository database & slicing and reshaping data for Tableau.
• Extensive experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• 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 the 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.
• Expert in creating semantic layer in tableau desktop and often used data blending to connect to different databases.

TECHNICAL SKILLS:

Databases: MS SQL SERVER 2000/2005/2008 R2/ 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, NC

Sr. Tableau Developer

Responsibilities:

• Took part in end to end implementation and enhancements from gathering requirements data and dashboards development in Tableau Desktop.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor
• Worked on data from multiple data sources including Oracle, Hyperion Essbase, CSV file and ODBC connections. Created Reusable dashboards to utilize the same process for all the PPNR & Mortgage Models for Different Source systems.
• Created Data loads, Data Quality Checks for ensuring data accuracy and reproducibility.
• 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.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and MS-SQL Server.
• 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 the users to dynamically interact with the data to the lowest level of granularity.
• Migrating all the reports from tableau 9.3 to tableau 10.3 and publishing them on the server.
• 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
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Crosstabs, Histograms etc.
• Developed effective 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 the SSIS packages and failure reports with error description.
• Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL
• Improved the performance of the application by rewriting the SQL queries.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created different KPI's using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Tableau desktop and server tickets resolution (primary contact for support)
• Mastered the 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 the 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.
• Hands on experience on reports using micro strategy and Qliksense and analyzed with Tableau reports for data consistency.
• 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 the Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.
• Worked extensively with Advance analytics like 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, DALLAS, TX

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 the projects timelines of projects or deliverables.
• Worked as an onsite coordinator and effectively led offshore team by work assignment, code review and on-time delivery of the 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 the reports and dashboards from Power BI Desktop to Power BI Report web portal.
• Used most advanced visuals and slicers available in designing the 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 the security and sharing the reports within organization and outside organization.
• Scheduling the data refresh in Power BI
• Used Power BI Power Pivot to develop data analysis reports and used power view and power map to visualize the 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 the 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 the support team on the status of the 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, CA

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 the Architecture Diagram for Different Source systems for Pro Provision Net Revenue Models and Mortgage Process.
• Work with business in understanding the Nature of Data, accordingly will get the 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 the same process for all the PPNR & Mortgage Models for Different Source systems.
• Created Data loads, Data Quality Checks for ensuring data accuracy and reproducibility.
• Hands on experience on reports using Micro strategy and Qliksense and analyzed with Tableau reports for data consistency.
• Worked extensively with Advance analytics like Lines and Bands, Trend Lines.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Calculated Fields and Parameters across Multiple Data Sources
• Strong Dashboard design experience and passionate practitioner of effective data visualization.
• 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 the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Generated Tableau dashboards with forecasting, Dual Axes and 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 the 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 the SQL table.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Conducted necessary ad-hoc data analysis and quantitative investigations for supporting business groups.
• 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.
• Worked on optimizing and tuning the Teradata views and queries to improve the performance of batch and response time of data for users.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Conducted user acceptance testing and mentored business users to slice and dice data using filters and parameters.
• Involved in Onsite & Offshore coordination to ensure the completeness of deliverables.

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

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 the 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 the 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 the 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 the 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 the data from the 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 the existing database from Oracle 9i to Oracle 11g
• Performance tuned the Oracle databases and user applications
• Used SQL Loader as an ETL tool to load data into the Staging Tables
• Used DTS packages as an ETL tool for migrating data from the SQL Server 2000 to Oracle 10g
• Improved the performance of the application by rewriting the 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.