SUMMARY:

• Around 8+years' experience working in IT industry with SQL/ETL developer and Tableau report document delivery
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Around 8+years' experience working in IT industry with SQL/ETL developer and Tableau report document delivery.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go live and Reconciliation.
• Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Implemented and designed dashboards using Qlik view, Qlik sense.
• Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, Pmon/View Point, Data mover)
• Extensive experience as Micro Strategy Developer, Architect&Administrator building projects and creating reports and Dashboards using Micro Strategy, Narrowcast Server, Micro Strategy Desktop, Micro Strategy Web, Micro Strategy Intelligence Server.
• Expertise in Desktop creating and integrating Micro Strategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Created Tableau Scorecards, Dashboards, Heat maps 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 per the end user requirement.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience with MPP and columnar database like AWS Redshift.
• Experience with Big Data methods, topologies and tools, such as Map/Reduce (e.g. AWSEMR), ApacheSpark, etc., preferred.
• Extensive knowledge in Dimensional Data modelling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modelling.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
• Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BITools.
• Worked on Informatics tool Source Analyser, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager OBIEE,and Repository Manager.
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experienced in all aspects of Software Development Life-Cycle (SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
• Expertise in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs, SSRS/SSAS, and project implementations.
• Good knowledge of data warehouse (DWH) Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Hands on experience in developing reports and visualization against SAPHANA.
• Hands on installing, using and troubleshooting various software applications.
• Good knowledge on C, C++ programming language, DBMS, RDBMS and Visual basic concepts.
• Worked with Different Databases like DB2, Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spreadsheet etc.Hands on experience on Tableau Server administration including cloud based services.
• Able to work independently has a good interaction with team members.
• Good at understanding the client requirements and giving best solutions.

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential - Atlanta, GA

Responsibilities:

• Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Designed 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 colour that were broken into regions allowing business user to understand where we have most users vs. least users.
• Build dashboard using parameters, sets, groups and calculations.
• Involved in creating a dual-axis bar chart with multiple measures.
• Generated report schedules on Tableau server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Worked as Tableau architect in standardizing Tableau for enterprise wide deployment.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Collaborated with analysts, statisticians, data scientists and coders on global complaint data using Microsoft Excel
• 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.
• Experiences on Tableau 7.x, 8.x, 9.x, 10.x tools include Tableau Desktop, Tableau Reader, Tableau Public, and tableau Server.
• Wrote and modified various Stored Procedures used in the application using T-SQL.
• Schedule and maintain packages by daily, weekly and monthly in SQL Server Agent.
• Perform quality assurance checks and update databases to ensure data integrity.
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database, application or data content related issues.

Environment: Tableau Desktop, Tableau Server, Microsoft SQL Server, Salesforce, Visual Studio, SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, Actuate Decommissioning, C, Microsoft Visio, MS Access, Excel.

Tableau Developer

Confidential - Atlanta, GA

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
• Deployed the generated reports onto the report server.
• Formatted the reports using the Global variables and expressions.
• Cleaned the data and generated graphs in Microsoft Excel.
• Upgraded the existing server version to Tableau 10.4 and successfully migrated existing workbooks and data sources
• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Involved in license management SLA's with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Worked with SSIS Packages on SQL Server 2012 and SSIS packages on SQLServer2008 for the automation of day to day Maintenance Jobs.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• 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.
• Extensively used Alteryx for giving Data analysis and BI software with SQL Server.
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Strong hands on experience using Teradata utilities (SQL, FastLoad, Multi-Load, FastExport, T-pump, Visual Explain, Queryman) and Teradata parallel support.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• 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.
• Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while maintaining the accuracy of the core information content that is being communicated
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL.
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement

Environment: Tableau Server, Oracle SQL Developer, SQL server, HPQC, Oracle, java platform, Teradata, Microsoft office, Business objects, SQL, PL/SQL, T-SQL.

Tableau Developer

Confidential - Chicago, IL

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical &, functional specifications.
• Analysed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableau desktop server.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards.
• Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, quick filters, actions, hierarchies' features in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted Metric insight reports to tableau reports.
• Analysed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources are publishes ori extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhones, and other smart mobile phones.

Environment: Tableau Desktop, Alteryx, Tableau server, Oracle, PL/SQL, SQL*Plus, TOAD, Windows, UNIX.

Tableau Developer

Confidential - Oklahoma City, OK

Responsibilities:

• Designed automated scripts in PL/ SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.
• Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),
• Developed and maintained graphs, tables, slides and document templates for the efficient creation of reports.
• Interacted professionally with diverse group of professionals in the organization including managers and executives.
• Experienced in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Building, publishing customized interactive reports and dashboards, report scheduling using
• Tableau server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• 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 KPIs.
• Gathered user requirements, analysed and designed software solution based on the requirements.Interacted with Business Analysts and Data Modellers and defined Mapping documents and
• Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Environment: Tableau Server, Oracle SQL Developer, SQL Assistant, Oracle, java platform, Teradata, Microsoft Office, Business objects, SQL, PL/SQL, T-SQL.

Tableau Developer

Confidential

Responsibilities:

• Designing and develop Tableau Reports, Documents, Dashboards and Scorecards for specified requirements and timelines.
• Developed various reports based on customer requirements.
• Experience on KPI (Key Performance Indicators).
• Prepared Dashboards using Calculations, Parameters in Tableau.
• Designed visualizations using Different Data views like barcharts, Trend lines, Cross-Tab, Scatter-plots and bullet graphs.
• Customizing the Data views & implementing the various charts like Waterfall, Bump and Funnel charts.
• Created customized and interactive dashboards using data sources and custom objects.
• Understanding the KPIs and Requirements Documents.
• Involved in creating dashboards by extracting data from different sources.
• Working with Tableau Desktop.
• Created dashboard using parameters, sets, groups, and calculations.
• Measure Value fields to create visualizations with multiple measures and dimensions.
• Involved in creating of data blending in case merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in creating calculated fields, mapping, actions, and hierarchies.
• Participating Daily, Weekly and Ad-hoc meetings.
• Involved in end to end implementation of reporting projects.
• Publishing the dashboards on Tableau Servers.
• Preparation of Test Scenarios, Test Cases, and Execution of Test Cases.
• Attending the weekly Status call with the onsite team.
• Deployed reports in production.
• Created end to end Active Reports.

Environment: Tableau desktop, Table Server, MS Office, Oracle11g, SQL, Windows.

Software Engineer

Confidential

Responsibilities:

• Involved in architecting various Business Layer and Data Management components of multi-tiered web based system over J2EEarchitecture. Responsible for JAVA, J2EE and Groovy coding /development.
• Actively designed, developed and integrated the Metrics module with all other components. Used Scrum for managing product development.
• Development using Java, JSP and Servlets on WSAD.
• Developed the functionality for communicating between the modules mostly involved in VIEW and CONTROLLER section of MVC pattern for CMS project, it includes HTML, CSS, JavaScript, jQuery and AJAX which were used for UI development.
• Developed Struts Action and Form classes to access JavaBeans and UI.
• Designed and coded highly-available systems/web applications with JavaScript, Node.js. Provided Node.js for architecture. Used Hibernate to access database and perform database updating.
• Wrote SQL queries and stored procedures over server databases using SQL Server and HTML files.
• Wrote complex queries and mapped database views using DAO in java.
• Developed Use Cases, UML diagrams such as Sequence Diagrams, Activity Diagrams, and Class Diagrams, for my application modules (Metrics).
• Developed Web-Services using XML messages that use SOAP. Developed Web-Services for Payment Transaction and Payment Release.
• Developed the application using RAD as methodology and used Eclipse's features for editing, debugging, compiling, formatting, build automation and version control (CVS)
• Wrote test cases in JUnit for unit testing of classes and implemented the logging using Log4j.
• Retrieving code from the repository and deploying in Production using ANT.

Environment: Java1.6/1.7, JSP, Eclipse, Servlets, Struts, Spring, Hibernate, Git, EJB, Groovy, JNDI, Hibernate, HTML, XML, DHTML, Log4j, Ant, Web Sphere, Oracle, Windows, JSF, JBPM, Scrum, JDBC, Rational Software Architect, Web Services (SOAP/WSDL and REST), JUnit, Maven, SVN, JavaScript, CSS, UNIX.