PROFESSIONAL SUMMARY:

• Over 8 Years of IT experience in ETL, Business Intelligence, Business Architecture, Data Warehousing, and Web based, Client/Server applications in Development, testing and implementation in various domain such as Insurance, Banking and Retail industries.
• Extensive experience in Data Modelling, Data Profiling, Data Integration, Data Migration and Data Mining.
• Experience in SQL Queries, E - R and Dimensional Model, Star/Snow Flake Schema design, Modelling dimensions, hierarchies and facts, Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Expert in Tableau 6.x/7.x/8.x/9.x/10.x (Desktop, Server, Mobile, Public), Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and Created dashboards by using Level of Detail concept (LOD’s)
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Bar Charts, Line Charts, Histograms, Tree maps, Pie-Charts, Dual Charts, Action Dashboards and cascading reports using Tableau
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
• Experience in configuring reports from different data sources using data blending
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems
• Expertise in Teradata, Oracle, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), UNIX, Microsoft Office Suite
• Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Developed reports using Advance Analytics like Reference Lines, Reference Bands, Trend Lines, Box plots and Custom Geocoding.
• Proficient in using SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Experience in developing source to target Mapping Document for migration and Data Transformation documents for the development team to facilitate the development of interfaces.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing.
• Experience in performing Data Analysis and Data Validations to ensure the Data is as per Business needs.
• Experience in creating various kinds of reports like Parameterized, Cached, Drill through, Drill down, Sub reports in SSRS.
• Familiar with SSIS Packages - Dataflow, Control flow items and SQL Import/Export wizard operations to move Data between different Sources.
• Experience in Requirement Gathering Methodologies with complete end to end participation in all areas of Software Development Life Cycle (SDLC) which includes traditional Waterfall and Agile (SCRUM) and Expertise in preparing Business Requirements Document (BRD), Software Requirements Specification (SRS), Functional Specifications Document (FSD) and assisting in developing test plans.

TECHNICAL SKILLS:

RDBMS/DBMS: Microsoft -SQL Server 2014/ 2012/2008/2005, Oracle 10 /11g/12c, MS Access, DB2, HANA, Teradata, DB2, Apache Hive/Spark, Sales Force.

BI /Data model Tools: Tableau Desktop 10.x /9.x/8.x, Tableau Server, Business Objects, Dashboard designer, SSRS 2012/2008/2005, Alteryx, Crystal Reports, DTS, SSIS, Visio. Visual Studio 2013/2015.

ETL Tools: SSIS, Informatica.

Operating Systems: Windows 7/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages: Python, SAS, SQL, T-SQL, PL SQL, Hive QL, R, Stored Procedure, SQL

Application Packages: MS Office, MS Outlook. Power Query, PowerPivot

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Team Foundation Server(TFS) Proficient, SQL Server Enterprise Manager, Toad, Query Analyzer, Bex, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, BCP

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Tableau Developer

Responsibilities:

• Responsible for Preparing the Report Design specifications based on the User's requirement.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Applied various types filters like Data source filters, Quick filters and Context Filters.
• Created table calculations, calculated fields and parameters.
• Extracted data from various sources and performed data blending.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Executed and tested required queries and reports before publishing.
• Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.
• Validate the data for each report and review the reports.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Generated high detail-oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.

Environment: Tableau Desktop10.5, 2018.2, Oracle 10g, Tableau Reader 10.3.x, Rapid SQL, PL/SQL, Microsoft Excel 2013, Microsoft office 2013.

Confidential, Conway, AR

Sr. Tableau Developer

Responsibilities:

• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Participated in sessions with the clients, project stakeholders, users, SME’s, development and testing team to get better understanding of the requirements and functionalities and accordingly came up with different analytical views by using appropriate charts that matches the requirement and developed interactive dashboards in Tableau to address the business problem.
• Part of BI’s Center of Excellency(COE) team as tableau technical expert to critique, review and certify tableau dashboards and make decisions whether to move production or Self-service analytics.
• Working closely with business in creating dashboards based on the data from various Data sources.
• Used web data connectors to bring data in Tableau from various websites and performed Predictive analysis by using Tabpy.
• Utilizing Tableau server to publish and share the reports with the business users.
• Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience.
• 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 the end user requirement.
• Distributing Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Extracting data from databases like Salesforce, SAS, DB2, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Trouble shoot problems with the various teams including network related issues.

Environment: Tableau 10.x/ 9.x, SAS, Alteryx, SQL Server, Salesforce, DB2, Excel, Access Database, CSV files, CDW, EDW, Windows 8.

Confidential, San diego, CA

Sr. Tableau developer

Responsibilities:

• Working as an active member of Reporting & Analytics team for providing critical analysis to multiple business groups across the company. Develop effective and scalable Business Intelligence solutions including Data Visualizations, Dashboards, Reporting Data Marts, operational Reports and Data Integration solutions.
• Preparing Dashboards using calculations, parameters in Tableau 10.4. Responsible for creating the complex Analytical, Executive and operational Tableau Reports.Connect to live databases and creating the Tableau data extracts for creating the workbooks.
• Connect to multiple data sources (excel files, flat files, SQL Server) to do analytics in Tableau Desktop and creating the Data extracts and data sources, publishing to Tableau server.
• Design, Develop, Test, Publish and maintain PowerBI Functional reports, Dashboards based on user requirements.
• Automated several critical reports and created reusable utilities using Unix Shell Scripting to reduce the number of repetitive requests from users.
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality. Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Involve in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handle the performance issues effectively.
• Use Spark cluster to manipulate RDD’s (resilient distributed datasets) and also used concepts of RDD partitions.
• Wrote Python modules to extract/load asset data from the MySQL source database.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• SQL Server (experience in designing database, writing and implementing SQL stored procedures and scripts, and performance tuning).

Environment: Tableau Desktop,10.4, Tableau Reader 10.3.x, Power BI, Rapid SQL, PL/SQL, python, Redshift, Microsoft Excel 2010, Microsoft office 2010.

Confidential, San Antonio, Texas

Sr. Tableau Developer

Responsibilities:

• Worked closely with Customer service and BO department for prompt and efficient delivery of Tableau Reports.
• Responsible for making reports using Tableau desktop (9.2), Teradata according to the user’s requirements.
• Responsible for maintaining reports in Tableau server, entity relational data modeling, giving appropriate access to users monitoring performances.
• Developed restricted user access to Tableau reports according to the users requirements at worksheet level.
• Developed different visualizations using bars, lines, scatter plots, bubbles and histograms based on the requirements.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.
• 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.
• Involved in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
• Developed different strategies for improving the performances of Tableau reports.
• Involved in data blending for pulling the required data for reporting.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Worked on loading excel files into the SQL server database using the SQL server integration services 2008.
• Worked on grouping to rollup products to their specific lines of business for reporting.
• Responsible for gathering user's requirements, analyzing and getting feedback.
• Responsible for validating the database, writing queries and getting appropriated data for reports.
• Worked on making metadata tables to load the excel files into the SQL server database using Stored Procedures.

Environment: Tableau Desktop 9.x/8.x, Tableau Server 9.x, MySQL, ETL, SQL Server and Windows.

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Involved in gathering client requirement and developed Tableau reports based on user defined ad hoc user Interface for end users.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements. Conceptualized and Designed Logical and Physical Data Models using Erwin.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with an incremental load.
• Experience in generating On-demand and Scheduled Reports for business analysis or Management decision using SQL Server Reporting Services.
• Designed complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tools Tableau and Qlik view.
• Involved in developing Tableau Dashboards using both relational and Multidimensional data.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Administered user, user groups, and scheduled instances for reports in Tableau. Converted metric insight reports to Tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.

Environment: SQL Server 2012, 2014, Management Studio, Business Intelligence Development Studio (SSIS, SSAS, SSRS), visual studio 2013, Tableau Desktop, Tableau server / Administrator, tabcmd.

Confidential

Tableau Developer/ Admin

Responsibilities:

• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Designed and deployed rich graphic visualizations with Drill Down and Drop-down menu option and used parameters using Tableau.
• Attended meetings with the Client SME’s, to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Generated Tableau dashboards with combination charts for presenting KPI’s, with different Data Visualization Techniques like Tree Maps, Geo Maps, Stack Bars and Line Graphs for Showing Trend with Dual-Axis and Data Blending Techniques.
• Developed key indicators and appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
• Worked on Custom complex SQL Queries to generate data from various data sources to generate Innovative and Powerful dashboards for easy data visualization and analytics in Tableau.

Environment: Tableau Desktop 8.0, Tableau Reader, Tableau Server 7/8, Tabcmd, MS SQL Server 2012TSQL, MS Excel, SQL Server Management Studio, Share Point, MS Office 2010/2013.