We provide IT Staff Augmentation Services!

Lead Tableau Developer Resume

TX

SUMMARY

  • Over 9+ years of IT experience in Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms.
  • 5+ years of experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8/9/10/2018.
  • Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
  • Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
  • Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), CRM.
  • Well versed in query optimization for performance tuning and monitoring of processes.
  • Expert in creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
  • Extensive knowledge on visualization of data and knowledge of tools such as tableau.
  • Published dashboards on Tableau public.
  • Designed teh reports using Crystal reports And SSRS to create reports for teh end users.
  • Worked closely with Tableau support team during tableau server upgrades to 8.1
  • Worked on data blending and increased teh dashboard performance by extracting data.
  • Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
  • Good knowledge on OBIEE and Qlikview.
  • Experienced in connecting Tableau to IBM Netezza, Amazon Red Shift, Hadoop, and SQL Server.
  • Deployed tableau server in clustered environment by adding worker machines.
  • Developed complex reports using Business Objects XIR3/XIR2 Webi Rich Client and Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Sub reports and Grouping.
  • Good knowledge in development of ETL and ELT programs using various tools like Oracle PL/SQL.
  • Broad experience in resolving universe issues like Loops and Traps using Alias and context.
  • Created dashboards in areas like marketing, financial, social media monitoring, supply chain, procurement etc.
  • Worked on server side for setting up teh permissions for groups and specific users.
  • Scheduled teh workbooks according to teh requirement - scheduled teh extracts to refresh automatically.
  • Worked on large data sets within Hadoop ecosystem performing analysis using Hive.
  • In-depth knowledge in building/maintaining Repository, Universes, Forecasting and creating AdHoc reports.
  • Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
  • Strong analytical, logical, Communication and problem-solving skills and ability to quickly adapt to new technologies by self-learning.

SOFTWARE PROFICIENCY:

BI Tools: Tableau 9x, 10x, 2018x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI, Microstrategy, Cognos and Qlikview, Power BI

ETL Tools: SQL Server Integration Services (SSIS), Informatica, Data Stage, Alteryx, Talend

Data Bases: Server 2000/2005/2008/2008R2/2012, Greenplum, MS Access, Teradata, Oracle 11g/10g, Excel Flat files, Sybase, Hadoop, DB2, Amazon Red Shift, Cloud Computing, Amazon web services.

Programming Languages: C, C++, T-SQL, XML, Unix, Oracle, Java, Python, ABAP, VB, PL/SQL

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center, JIRA, Drupal

PROFESSIONAL EXPERIENCE

Confidential, Tx

Lead Tableau Developer

Responsibilities:

  • Involved in requirement gathering, reviewing requirements and data sources for design, development, and testing and production rollover of reporting and data visualization projects using Tableau.
  • Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues.
  • Assisted teh DBA in converting teh logical models to physical.
  • Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for teh weekly and monthly Dashboard reports on Tableau Server.
  • Involved in data validation of teh results in Tableau or Power BI by validating teh numbers against teh data by querying teh Database.
  • Built and published interactive reports and dashboards usingTableauDesktop andTableauServer.
  • Designed and developed teh most suitable User Interface such as multiple charts types, Dashboards, customer requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
  • Created views inTableauDesktop in Agile environment, dat were published to internal team for review and further data analysis and customization using filters and actions.
  • Experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
  • Created Tons of complex reports usingSAS.
  • Presented multiple demonstrations of Tableau functionalities and proficient data visualizations methods using Tableau to teh senior Management at teh client as part of teh Business Requirement Document.
  • Created Drill-down and Sub-Report using SQL Server Reporting Services (SSRS). Monitored teh performance of teh reports.

Environment: TableauDesktop 10.x, 2018.x,TableauServer, Toad, Teradata, Hadoop and Hive, Oracle, Alteryx, Power BI, Amazon Web Services, MS Excel, Business Objects, Salesforce, Talend, Microstrategy, JavaScript API, Excel, Python, S3, EMR, CRM, SAP Hana, C #, Google Analytics, Sap BW

Confidential, MN

Lead Tableau Developer/Admin /Architect

Responsibilities:

  • Designed dashboards on teh theory of Dynamic Availability where in a Variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of teh Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in teh developed dashboards.
  • Provided 24/7 production support forTableauusers.
  • Blended data from many databases into single report by selecting Primary keys from each database for data validation.
  • Developed complexSASprograms, macros for data updates, data cleansing, and reporting.
  • Used bothSASand Access VBA combined to read, write, import and export to another data file formats, includingdelimited files, Microsoft Excel, PDF and MS Access tables.
  • Connected to Amazon RedShift through Tableau to extract live data for real time analysis.
  • Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
  • Experience working with different teams for Data Modeling
  • Connected to Tableau through SQL, AWS Redshift databases to create customized interface for Tableau workbooks to provide native intranet style navigation
  • Created AdHoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used KPIs, Excel, flat files, CSV files to create Tableau AdHoc reports.
  • Worked with technical architect in developing strategy, architecture and technical specifications for implementing reporting portal or semantic layer in conjunction with data layer

Environment: TableauDesktop 9.x, 10.x,TableauServer, Sap Bw, MYSQL, SSAS, SSRS, T-SQL, Teradata, Athena, Hadoop, Hive, Informatica, PL/SQL, CRM, Power BI, EMR, Alteryx, Supply Chain, Drupal, Microstrategy, Amazon Web Services- Redshift, AWS, MS Excel, Python, Sap Hana, C#, Google Analytics, JavaScript APIAug 2015 TO Jan 2017

Confidential Baton Rouge, LA

Sr. Tableau Developer/Data Analyst

Responsibilities:

  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Developed geographic maps showcasing demographics broken into age, race, and income category dat showed content viewed by individual customers across all content providers.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, Forecasting and Tabular reports usingTableauDesktop.
  • Executed and tested required queries and reports before publishing dashboards.
  • Administered user, user groups, and scheduled instances for reports inTableauServer.
  • Created reports to show top high cost members for teh Louisiana market at teh state level PCP level
  • Created time series on BlueCross data and combined them in dashboard to show teh customers by Line of business for drill down analysis.
  • Involved in license management SLA's with Tableau support.
  • Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote teh usage of Tableau.
  • Created dashboards by using Alteryx and drive time calculations by using it.Interactive Tableau Dashboard Resume
  • Cloud implementation of data analytics developed on Tableau Desktop, and to make dashboards available on teh cloud platform being implemented by teh client.
  • Performed various Data Governance activities and reported teh issues to teh ETL team to rectify them.

Environment: TableauDesktop 9.x, 10.x,Sap BW, TableauServer, Toad, Teradata, Hadoop and Hive, Oracle, Talend, Alteryx, CRM, Amazon Web Services- Redshift, C#, Agile, Sap hana, Kanban, Athena, Excel, Business Objects, Salesforce, Microstrategy, Python, Javascript API, Supply Chain, D3.js

Confidential, Petersburg, FL

Sr. Tableau Developer

Responsibilities:

  • Installation and configuration of Tableau Server Cluster (Primary, Worker, Backup Primary) and its processes (SQL Server, Application Server, Data Server, Data Engine, Background Tasks, and Repository). Configured SMTP, SSL and Windows AD.
  • Handled Tableau admin activities like granting access, managing extracts, patches, upgrades and installations.
  • Created users, groups and domains from Active Directory and created different license levels for each user.
  • Took backup of teh Tableau server on regular basis by using Tabadmin commands also developed restoration procedures to restore teh server during system failures.
  • Created extract files for improving teh performance. Used different Mark types and Mark properties in views to provide better insight into large data sets.
  • Worked in Migration project Tableau 7.0 to Tableau 8.0. Worked with teh Tableau desktop users in migrating their local desktop workbooks to Tableau 8.0.
  • Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
  • Worked on lot of migrations from Micro strategy to Tableau.
  • Performed super user trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote teh usage of Tableau.
  • Installed patches on teh server and documented upgrade plan from tableau 8.0 to 9.0
  • Implemented row level security and windows AD authentication for Tableau reports

Environment: Tableau Desktop 8.x/9.x, Tableau Server 8.x/9.x, Alteryx, Tableau Reader 7.x/8.x, MYSQL, Designer, S3, CRM, EMR, BI, Dashboard/Xcelsius, AWS, C#, Athena, Supply Chain, Drupal, Red shift, Javascript API, Scheduler,D3.js, Toad, Teradata, Crystal Reports, Jira, Unix, MYSQL

Confidential Houston, Tx

Reports Developer - Teaching Assistant/Student Tech II

Responsibilities:

  • Created technical designs for teh various reporting requirements.
  • Developed various Reports in excel for teh internal work of teh department
  • Provided maintenance and IT support to various students and faculty
  • Maintained Test Log and wrote Test Evaluation, Summary Reports.
  • Created AdHoc reports using excel Used Excel, flat files, CSV files
  • Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations
  • Strong Experience in developing Sessions/Tasks, Worklets, and Workflows using Workflow Manager tools - Task Developer, Workflow & Worklet Designer.
  • Extensively used Informatica Repository Manager and Workflow Monitor.
  • Worked on forecasting of data, creating Aggregations, Calculated fields, Table calculations, Totals, Percentages using Key Performance Indicators (KPI) and measures.
  • Wrote different queries and stored procedures to make our daily data verification and conversion process faster, more accurate and automated.
  • Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
  • Good experience in documenting teh ETL process flow for better maintenance and analyzing teh process flow.
  • Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

Environment: SQL Server 2008 Enterprise Edition,C#, T-SQL, Excel, Salesforce Star-schema, Snowflake schema, Erwin, Oracle, Jira, Cognos, Visual Studio, Google Analytics, Informatica 7/8, Talend, UNIX.

Confidential

SQL/Lead developer

Responsibilities:

  • Provide security for teh application by encryption, decryption during transmitting data from server to teh client.
  • Gatheird requirements, analyzed data, and designed software solutions based on teh requirements.
  • Analyzing teh existing System.
  • Analyze, design and coordinate teh development of applications.
  • Involved in identifying teh code changes.
  • Involved in resolving teh issues.
  • Involved in teh Unit testing, served as a liaison between cross-functional and distributed teams.
  • Participated in team meetings and in client meetings for analyzing functional requirements.
  • Involved in Database design and maintenance.
  • Developed stored procedures, triggers and automated SQL, T-SQL scripts for database maintenance.

Environment: MS Visual Studio 2010, MYSQL, MS TFS, MS .Net Framework, XML, CSV, C, C++, Java, Matlab

Hire Now