Tableau Developer/ Admin Resume
Baltimore, MD
SUMMARY
- Over 7+Years of experience in enterprise environment on as BI Developer, Analyst and Admin. In - depth knowledge on all Tableau products, Business Objects, QlikView. Extensive use of advanced SQL and some standard applications like Excel, SharePoint and PowerShell
- Excellent analytical and problem solving using QlikView, tableau and SQL debugging skills.
- Expertise in Reports and Dashboards development in Tableau using advanced development concepts.
- Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
- Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
- Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple data sources using Tableau tool.
- Experience working with visualization tools like Tableau and OBIEE.
- Worked on the development of Tableau Dashboard reports for the Key Performance Indicators (KPI) for the top management.
- Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
- Experience in aggregating data and configuring reports from different data sources using data blending.
- Used Tableau with AWS cloud connecting to AWS EMR and AWS redshift.
- Identifies and validates solution interfaces, dependencies, and integration points.
- Ensures that developed code is compliant with best practices, standards, and enterprise architecture.
- Including technical support, troubleshooting, report design and monitoring of system usage
- Setup trusted authentication in Tableau server and pass requests from Web server
- Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
- Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
- Worked on data warehouses with expertise in all phases of data warehousing lifecycle along with implementation and testing of software products.
- Excellent analytical and problem solving using QlikView, tableau and SQL debugging skills
- Expertise in ETL tools like SQL Server Integration Services (SSIS) and Relational Database Management Systems.
- Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
- Expert on creating multiple kind of reports in Power BI like Tabular Reports
- Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across the client servers.
- Experience in Migrating the Business Objects Reports from BO XI 3.x to BI 4.0, 4.2.
- Specialized in creating Web Intelligence/Crystal/Analysis for OLAP reports using BEx queries, Oracle, SQL Server, SAP HANA, MS Access, local files and Analysis Views
- Created interactive, tabular, graphical and free-form reports from relational, multidimensional, or XML-based data sources using SSRS.
- Setup and configuration of Tableau server 9.3 in various environments and used TabCMD and Tableau admin tools to configure the server according to best practices.
- Designed and setup user security for the entire landscape to facilitate Windows AD login.
- Used Tableau Cmd for various Dashboard migrations from one environment to another.
- Setup of Distributed Server environments for optimum load balancing.
- Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application, folder and user levels.
- Worked on connecting tableau to various other data sources like Hive, Redshift AWS, TeradSetup of SSO between Tableau portal and Oracle.
- Installed and setup cluster environment for Tableau server and used Jmeter for load balancing and load analysis.
- Used SAML for configuration ofTableauServer SSO supplementing Kerberos authentication on the side.
- Used Kerberos for user authentication through Active directory (Win AD).
- Used Sign in Method using the REST API for successful sign in operations
- Setup of SSO betweenTableauportal and Oracle.
- Performance tuning for theTableauVisualizations andTableauserver for more than 250 concurrent users.
- Experience in Agile and Scrum (Scrum master) Methodology.
- Capable of forming and keeping up positive and gainful working connections in interior/ external and team environments.
TECHNICAL SKILLS
Tableau: 10.1/10.2/9. X/8.0/7.0, Tableau Server, Tableau Mobile, Tableau Public, Tableau Reader, Power BI, SSRS, SASVersion 9.1.3, SAS Enterprise Guide PowerCenter Informatica.
ETL Tools: Informatica, SSIS SAP-BI, BW, SAP BOBJ 4.0/3.1, HANA
BIG Data Ecosystems: Hive, pig, Cassandra C, C+ +, ASP.NET.
Platform: UNIX, Win UNIX LINUX, Web Sphere, Apache/Tomcat.
Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0, Caboodle EPIC
Database: Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5 , Access, SAS, AWS (Redshift, EMR and cloud), DB2, Teradata
PROFESSIONAL EXPERIENCE
Confidential
Tableau Developer/ Admin
Responsibilities:
- Primarily worked on recreating reports from legacy EMR to Epic on Tableau
- Installation and Configuration ofTableauServer 9.3 and 10.1 test and production environment.
- Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
- Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
- Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
- Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
- Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
- Found efficient ways to make tables and graphs, which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
- Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
- Connected to the AWS Redshift directly from tableau to access cloud data warehouse and quickly perform visual analysis.
- Utilize SSIS to develop ETL mechanisms to populate the CMDB with data from multiple sources including event management, ERP/MRP and discovery components.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
- Used ProClarity for accessing and analyzing cubes and dimensions, and worked on integration of SharePoint with SSRS.
- Created ETL packages using Heterogeneous data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc.,) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
- Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
- Conducted User acceptance testing (UAT) and mentored business users how to slice and dice data using filters and parameters.
- Performed performance tuning of the dashboard in Tableau desktop.
- Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
- Created views, stored procedures and custom SQL queries to import data from Oracle SQL server.
- Working with Epic reporting databases including Clarity and Caboodle Data Warehouse.
- Created reports on Epic Revenue Cycle Hospital billing module.
- Working on performance tuning on workbooks to reduce the runtime of the dashboard.
- Trained end users how to use the Tableau interactive dashboards and Drill downs and process of mitigation for any modification.
Confidential, Baltimore, MD
Senior BI SME
Responsibilities:
- Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
- Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
- Extracted data from the database usingSAS/SQL,SAS/Macros from different databases such as Teradata, Oracle.
- Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
- Worked on creating interactive, real-time dashboards using drilling downs and customizations.
- Effectively worked on recreating Cognos reports into Tableau.
- Reverse engineered and recreated SAS reports into Tableau for better visualization as per the user requirement.
- Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
- Setup trusted authentication in Tableau server and pass requests from Web server
- Designed and setup user security for the entire landscape to facilitate Windows AD login.
- Used Tableau Cmd for various Dashboard migrations from one environment to another.
- Setup of Distributed Server environments for optimum load balancing.
- 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.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
- Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
- Involved in installation and upgrade of Tableau Server and Server performance tuning for Optimization.
- Involved in building Dashboards using parameters, sets, groups and calculations.
- Designed Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
Confidential, Denver, CO
Senior BI Consultant
Responsibilities:
- Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
- Going through Report Specification Documents and Understanding the User requirements.
- Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
- Created of dashboards for business groups like finance and sales.
- Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters
- Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
- Created Sets, Groups and Data Bins as per user requirements.
- Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
- Created custom Denodo views by joining tables from multiple data-sources.
- Provided visual/graphic analysis based on data content.
- Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
- Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
- Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
- Used Trend Lines, Reference Lines and Annotations to describe the data.
- Created Data extracts for better performance and accessing data offline.
- Used parameters and input controls to give users control over certain values.
- Implemented Data blending with multiple data sources on a single worksheet for data analysis.
- Created and Published Tableau Dashboards into Tableau Server.
- Writing SQL queries for data validation by using join conditions.
- Gathered data and documented it for further reference and designed Database using Erwin data modeler.
- Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
- Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
- Modified the existing SSIS packages to meet the changes specified by the users.
- Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
- Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
- Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
- Designed and implemented Stored Procedures and Triggers for automating tasks.
Confidential, Washington, DC
ETL/Business Intelligence Developer
Responsibilities:
- Design the dashboard application with multiple dashboards as required as per the security requirements.
- Developed Life Cycle (SDLC) efforts required to deliver on EIM-related projects and deliverables and used these estimates to assign completion date and milestones for EIM-related deliverables, tasks, etc.
- Developed the web-intelligence reports, provided a supporting role in building the universes
- Ensured solutions meet the expectations of end users and train users
- Gather and analyze the business requirements and then translate them to technical specifications.
- Created different views in workbook to visually analyze data.
- Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
- Worked on Performance Tuning of the Workbook and improved the performance of the report running for 15 min to 90 seconds execution time.
- Effectively used data blending feature in tableau to get data from SQL Server & MS Excel
- Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations with ODBC connection
- Created out of the box charts for complex end user Requirements. Converted Heat map to funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
- Executed and tested required queries and data before publishing Dashboard
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
- Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.