Candidates About

 

Stepron Harridass

Sr. Tableau Developer/ Data Visualization Expert

PROFESSIONAL SUMMARY

Ø  A Tableau Developer with 8+ years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database, Data Warehouse, Data Modeling and maintenance of business applications.

Ø   Extensive Tableau Development and Tableau Administration Experience in Enterprise Environments in Tableau versions 7.x/8.x/9.x/10. x.

Ø  Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.

Ø  Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.

Ø   Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.

Ø   Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.

Ø  Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

Ø   End to end experience in designing and deploying data visualizations using Tableau.

Ø   Expertise in full life-cycle Data Warehouse activities, including defining project roles and responsibilities, detailing project plans, requirements gathering and specification, logical and physical database design in both relational and dimensional, reporting requirements specification, and implementation / ongoing support tasks.

Ø  Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.

Ø  Experience working with ETL tools like Informatic and SISS.

Ø  Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.

Ø  Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Ø  Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements.

Ø  Expertise in Data Warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.

Ø  Extensively worked on Databases like Oracle, MS SQL Server, Sybase, Hadoop, Teradata, MySQL and DB2.

Ø  Excellent analytical, problem solving, communication and time management skills.

 

 

TECHNICAL PORTFOLIO

 

Business Intelligence Tools	Tableau Desktop/Server/On-Line 10.x/9.x/8.x, Business Objects 3.x/4.x, Dashboard Designer, Xcelsius, BEX Query, Microsoft Power BI, SQL, Google Analytics, Google Sheets, Server Reporting Services (SSRS).
ETL Tools	Informatica Power Center 9.x, SQL Server Integration Services (SSIS)
Languages	SQL, Custom Sql, Stored Procedure, ANSI 89/92, PL/SQL, HTML, Python, R
Data Modeling	Star Schema/Snowflake Schema model, Fact & Dimensions tables, SCD Type 1/2/3, OLAP, OLTP, Conformed Dimensions
Databases	Oracle 10g/11g/12C, MS SQL Server 2008/2012/2014, Teradata, MS Access, Salesforce, MySQL, DB2, PostgreSQL, Hive.
Operating Systems	Windows XP/Vista/7/8/10, MAC OS X, Linux, Unix
Microsoft Tools	MS Excel, MS Word, MS Project, MS PowerPoint
Industries	Banking/Financial, Investment, Healthcare, Retail, Manufacturing, Pharmaceutical and Telecommunication.

 

EDUCATION

CUNY York College Bachelor Computer Science 2008

 

PROFESSIONAL EXPERIENCE

Bank of America NYC, NY                                                                                                    September 2015 – Present                Senior Tableau Developer/Data Visualization Consultant

Overview:

Ø  Worked with internal management and team members to understand and clarify reporting requirement needs.

Ø  Connected to Salesforce as a CRM tool for access to transactional data to create dashboards tailored towards up to date marketing  analysis

Ø  Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.

Ø  Connected Tableau directly or extract data from Google Sheets, allowing an extremely flexible and collaborative analytics environment within an organization.

Ø  Leveraged the Google Analytics API using Tableau's interface to find answers faster with drag-and-drop dimensions and measures to see only the relevant data, displayed in a simple and intuitive way.

Ø  Used advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.

Ø   Identified key business metrics measurements and develop methods to represent data in support of the measurements.

Ø  Provided guidance and insight on data visualization and dashboard design best practices in Tableau.

Ø  Performed Perfective Analysis using Tableau API such as Python and R.

Ø   Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.

Ø  Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

Ø   Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created several types of charts to provide better visualization.

Ø   Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.

Ø  Designed and developed Big Data analytics platform for processing customer viewing preferences using Java, Hadoop, Hive and Pig.

Ø   Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.

Ø  Embedded Tableau reports/dashboards on to the external web pages.

Ø  Scheduled frequency and time to refresh data for the when sources are published or extracted to server.

Ø  Designed and development of various reports and dashboards that can be easily accessible through Tableau App in I pads, iPhone, and other smart mobile phones.

Ø  Embedded Tableau reports/dashboards on to the external web pages.

Ø  Provided innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.

Ø   Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development

Ø  Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Ø   Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.

Environment: Tableau Desktop/Server 9.x/10.x, Xcelsius, Google Analytics, Informatica Power Center, MS SQL Server 2014, Oracle 12g, Windows 7, TOAD, Web Data Connector, Python, Management Studio 2008

 

Verizon Basking ridge, NJ                                                                                                           July 2014 – August 2015   Senior Tableau Developer

Overview:

Ø  Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.

Ø  Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Ø  Gathered business requirements from end users, analyzed and documented the same for various reporting needs.

Ø  Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.

Ø  Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.

Ø  Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.

Ø  Created side by side bar chart comparison of Vendors who were into Retail along with profit revenue generated.

Ø  Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.

Ø  Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently. Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.

Ø  Created Data extracts for better performance of dashboards and accessing data offline.

Ø  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.

Ø  Integrated dashboards with live Connection in Microsoft PowerPoint.

Ø   Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

Ø  Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Ø  Created reports using Custom SQL for complex report views.

Ø  Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business

Ø  Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Environment: Tableau Server/Tableau Desktop 8.x/9.x, Postgresql, Dashboard Designer, Windows Server Standard R2, SQL Server management studio, MS SQL Server 2008R2, Oracle 10g, UNIX.

 

Mt.Sinai  NYC,NY                                                                                                                             Jan 2013 - August 2015  Tableau Developer/ BI Developer

Overview:

Ø   Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

Ø  Created and modified Business Intelligence analytical reports using Tableau.

Ø  Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.

Ø  Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending,

Ø  Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.

Ø  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, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.

Ø  Executed and tested required queries and reports before publishing.

Ø  Hands-on development assisting users in creating and modifying worksheets.

Ø  Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Ø  Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Ø   Implemented best practices and standards in developing Tableau reports.

Ø  Integrated Tableau dashboards into internal web portal using Java Script API.

Ø  Worked on the backend database development which was the source data for the tableau.

Ø  Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Ø  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, allowing end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Ø  Environment: Tableau 8.x, Tableau Server 8.0, Oracle 10g, Oracle SQL Developer, JavaScript, SQL,

Ø  Share Point, Agile-Scrum, Rally, Asp.Net, JavaScript.

Environment: Tableau 8.x, Business Objects 4.x/3.x, Oracle, Teradata, DB2, MS SQL Server, Java, Tableau Server.

Hollister New Albany, OH                                                                                                    December 2011 -  Dec 2012 Tableau Consultant/Data Analyst

Overview: 

Ø  Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.

Ø  Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Ø  Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.

Ø  Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.

Ø  Embedded Tableau reports/dashboards on to the external web pages.

Ø  Provided innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.

Ø  Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development.

Ø   Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.

Ø  Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Ø  Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop

Ø  Performed Tableau administration tasks like creation of users, groups, projects, workbooks and permission.

Ø   Assisted with best practices during implementation and integration of Tableau Platform

Environment: Tableau Desktop 7.0 Tableau server / Administrator, Tabcmd, SQL developer, (Report studio, Query Studio, Analysis Studio), Powerplay Transformer, Oracle 11g, TOAD, Windows, Sun SOLARIS

 

Barnes & Noble NYC, NY                                                                                         September 2009- November 2011 Business Objects Developer/ Data Analyst

Overview:

Ø  Analyzed requirements and develop derived metrics, custom report objects as required.

Ø  Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.

Ø  Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps)

Ø  Leveraged BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements created monthly.

Ø  Created Complex Metrics forcing Dimensionality and Conditionality embedded with prompts.

Ø  Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up Tables, Indexes and Views.

Ø  Extensively involved in data modeling to create attribute relationships.

Ø  Developed new reports and converted existing reports for the business line to satisfy the specifications using Web Intelligence and Crystal Reports.

Ø  Responsible for testing of developed reports and report objects.

Ø  Created transformations to-do time series analysis and to compare the values at various times such as sales at this year versus last year, or month-to-date.

Ø  Supported all phases of the project such as, Analysis, Design, Development, Testing and Implementation of the project.

Ø  Created Applications, Dashboards, Metrics, Menus, Rules, Alerts and Analytics using application Foundation 6.5.

Ø  Used query as web (Qaaws) option to build visualizations based on the reports built in Business Objects

Environment: Business Objects 3.1, BW, BEX Queries, Xcelsius, Webi, Cognos, Crystal reports, SQL Server 2008, Teradata, MS SQL Server, UDT