We provide IT Staff Augmentation Services!

Analytics Advisor/ Tableau Developer Resume

Houston, TX

SUMMARY:

  • Over 8 years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, Micro Strategy, Domo, etc. in Insurance,Healthcare claims, Finance, Banking, Pharmacy and Retail and Payroll Services industries.
  • Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.4/10.3/10.2/10.1/10. x/9.0,9.1.9.2,9.3x/8.x
  • Extensive experience upgrading Tableau Server versions, especially from 9.x to 10.x (more recently 10.5 version)
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
  • Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
  • Hands on Experience in Writing Python Scripts for Data Extract and Data Transfer.
  • Proficient in creating solution driven views and “high performance” dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
  • Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
  • Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
  • Extensively built “high performance” dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
  • Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL. Experience in developing and debugging Stored Procedures and Triggers.
  • Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Experience in T - SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.
  • Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
  • Experience in understanding and managing Hadoop Log Files.
  • Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
  • Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance.
  • Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
  • Experience in working with different type Dirty Data from Different sources.
  • Experience in working with Data Cleansing technique in ETL procedures.
  • Experience in working with Self Service MS BI end user tools such as Excel 2010 (Power pivot), Performance Point Server (PPS), and Power view.
  • Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
  • Experience in developing OLAP Cubes by using SQL Server Analysis Services, and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
  • Excellent hands on experience in creating groups and measures, KPIs.
  • Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
  • Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

ReportingTools: Tableau Desktop/Server 10.4,10.3,10.2,10.1,10.x/9.,9.1.9.2,9.3x/8.x/7.x/6.x, Micro Strategy (Desktop/WEB), SSRS, DWH, Business Intelligence, PVIOT, Power Query

Data Integration (ETL) Tools:  Informatica Power Center, SSIS

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, OBIEE

S QLTools: Teradata SQL Assistant, Rapid SQL, Toad, PL/SQL Developer, SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor.

RDBMS: Teradata, Oracle, OLAP, SAP HANA, SQL Server, DB2, Mongo, MS Access, Hadoop, NETTEZA

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: Documentum, SharePoint, HP Quality Center.

Scripting/Languages: C, C++, .NET, HTML, JavaScript, Python, PERL, SQL, PL/SQL,and XML, BTEQ, JSON, CSS, R language, VB Scripting

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 10/7/XP/2000, 2008/2003, Windows 9x

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Analytics Advisor/ Tableau Developer

Responsibilities:

  • Worked with key business stakeholders to understand the Tableau Report requirements and then worked with Designers to create Visual Design of the Reports as well as conducted detailed multiple stakeholder walkthroughs on each Tableau report developed.
  • Development of Key Performance Indicators (KPI) dashboards that provides internal employee productivity of specific period.
  • Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
  • Upgraded Tableau Server from 9.3 to 10.4. Currently planning for minor upgrade from Tableau Server 10.4 to 10.5 version.
  • Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableaudesktop & publish them to server.
  • Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.
  • Developed formatted, complex reusable formula reports.
  • Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
  • Created affinity analysis dashboard and Radical charts for better understanding data.
  • Optimized underlying SQL queries to create “high performance” reports.
  • Extensively used TabJolt for Load and Performance Testing of Tableau reports developed and resolved performance related issues as required.
  • Used Trend Lines, Reference Lines and statistical techniques to describe data.
  • Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts etc.
  • Enhancement of existing reports to improve performance by modifying the sql code used in extraction of data.
  • Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.
  • Used Context filters and Created Geographic map reports which explains the company financial keys according to the members.
  • Created Sets, Groups, and Data Bins as per user requirements.
  • Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
  • Created views using various axes like Individual Axes, Dual Axes.
  • 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.
  • Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards, Writing SQL queries for data validation by using join conditions.
  • Working with Level of Details expressions and Regular Expressions which are helpful in providing ETL functionality for tableau.
  • Created SQL Documentation for Benchmark queries and implemented new methods for better performance. Involved to create Documentation for debugging report for Tableau.
  • Designing excel based reports on tableau. And also designed Reports in excel by using Pivot charts and power Query, also used VB scripts.

Environment: Tableau Desktop 10.4, 10.3, 10.2, 10.1.3 /9.3, Tableau server 10.4/9.3, Microsoft SQL Server 2012/ MS Access Windows 2007 server/ Advanced Excel / HTML programming.

Confidential, Milwaukee, WI

Tableau Developer

Responsibilities:

  • Worked with key business stakeholders to understand the Tableau Report requirements and then worked with Designers to create Visual Design of the Reports as well as conducted detailed multiple stakeholder walkthroughs on each Tableau report developed.
  • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau and power bi.
  • Used Power BI and obtain insights into large data sets for the Ad-Hoc reports.
  • Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
  • Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
  • Played critical role in establishing Best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards.
  • Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.
  • Conducted Load and Performance Testing using TabJolt and resolved performance related issues on affected Tableau Reports.
  • Connected Tableau server with SharePoint portal and setup auto refresh.
  • Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
  • Wrote Custom SQL scripts for creating aggregate tables and generating views.
  • Worked on understanding of relational database structures, theories, principles and practices.
  • Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
  • Involved to create Documentation for debugging report for Tableau. Developing various dashboards in Tableau that would identify cost savings and highlight the errors in the insurance claim.
  • Successfully administered users, user groups, and scheduled instances for reports in Tableau.
  • Upgraded Tableau server from 9.3 to 10.2 in DEV and QA along with Migration of reports.
  • Developed a SSB BI Landing Page for all the reports and authored user guides of Tableau reports for the user community.
  • Designed and developed various analytic reports / dashboards using Tableau.
  • Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
  • Used SAP HANA as the underlying data source and created many Ad-hoc requests.
  • Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
  • Resolved various performance issues and analyzed the best process distribution for different projects.
  • Assisted power users in Tableau dashboard development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Environment: Tableau Desktop/Server 10.3/10.2/9.3/, 9.2/9.1/,9.0/,8.0, /Power BI/Hadoop / Teradata SQLAssistant, Teradata Administrator/ Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

  • Responsible for gathering/refining requirements from the customer for developing reports in Tableau and built the dashboard such as HR data such as Payroll Services dashboards
  • Created wireframes based on requirements analysis
  • Review wireframes with end users for design signoff
  • Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
  • Collaborate with business leadership to identify potential areas of analysis
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
  • Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
  • Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
  • Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report
  • Defined best practices for Tableau report development.
  • Designed multiple dashboards for CDI, helping them to convert from manual reporting
  • Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
  • Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
  • Presented the findings, graphs to c- suite, replicating the process across various customer segments.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop
  • Experience in understanding and managing Hadoop Log Files.
  • Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.

Environment: Tableau Desktop/Server, MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), R, JavaScript, Hadoop, SAP HANA.

Confidential, New Brunswick, NJ

BI developer/Tableau developer

Responsibilities:

  • Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
  • Collaborate with business leadership to identify potential areas of analysis
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
  • Created Web reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
  • Experience on building trending graph.
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. with HANA as an underlying database.
  • Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.
  • Designed multiple dashboards for CDI, helping them to convert from manual reporting
  • Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
  • Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
  • Presented the findings, graphs to key stakeholders and c-suiters, replicating the process across various customer segments.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop

Environment: Tableau Desktop/Server,SAP HANA MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), JavaScript.

Confidential

SQLDeveloper/BI Developer

Responsibilities:

  • Analyzing data, understanding data model, translating requirements and populating dimensions and facts in data warehouse
  • Creating reports from different data sources using SSRS.
  • Performance enhancement of already existing reports in development Report Manager.
  • Migrating data from different data sources to SQL server database using SSIS.
  • Load the configuration file into the database using the existing SSIS packages.
  • Helping SA's in the validation process after the load using the SQL scripts.
  • Creating stored procedures and some complex queries to embed this in SSRS reports.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS)
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.

Environment: SQL Server 2008, SSIS 2008, SSRS 2008, .NET Framework, T-SQL, XML, MS Excel, MS Access, Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

  • Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, & Functions.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval
  • Implement database systems based on solutions that are proposed.
  • Deployed and configured the reports in the Report Server. Created Subscription of reports in different formats.

Environment: MS SQL Server 2005/2008, Access, Management Studio, Visual Studio, SSIS,SSAS, SSRS, T-SQ

Hire Now