We provide IT Staff Augmentation Services!

Lead Tableau Developer Resume

Irving, 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 the reports using Crystal reports And SSRS to create reports for the end users.
  • Worked closely with Tableau support team during tableau server upgrades to 8.1
  • Worked on data blending and increased the 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 the permissions for groups and specific users.
  • Scheduled the workbooks according to the requirement - scheduled the 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, Irving, 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 the project on the same page, milestone tracking and avoiding scope creep issues.
  • Assisted the DBA in converting the logical models to physical.
  • Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly Dashboard reports on Tableau Server.
  • Involved in data validation of the results in Tableau or Power BI by validating the numbers against the data by querying the Database.
  • Built and published interactive reports and dashboards usingTableauDesktop andTableauServer.
  • Designed and developed the 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 the senior Management at the client as part of the Business Requirement Document.
  • Created Drill-down and Sub-Report using SQL Server Reporting Services (SSRS). Monitored the performance of the 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

Lead Tableau Developer/Admin /Architect

Responsibilities:

  • Designed dashboards on the theory of Dynamic Availability where in a Variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the 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 the Louisiana market at the state level PCP level
  • Created time series on BlueCross data and combined them in dashboard to show the 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 the usage of Tableau.
  • Created dashboards by using Alteryx and drive time calculations by using it.
  • Cloud implementation of data analytics developed on Tableau Desktop, and to make dashboards available on the cloud platform being implemented by the client.
  • Performed various Data Governance activities and reported the issues to the 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, Amazon Red Shift

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 the Tableau server on regular basis by using Tabadmin commands also developed restoration procedures to restore the server during system failures.
  • Created extract files for improving the 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 the 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 the usage of Tableau.
  • Installed patches on the 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 the various reporting requirements.
  • Developed various Reports in excel for the internal work of the 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

Environment: MS Visual Studio 2010, MS TFS, MS, XML, CSV, Java, Flat files

Confidential

SQL/ETL Informatica Developer

Responsibilities:

  • 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 the ETL process flow for better maintenance and analyzing the 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 the application by encryption, decryption during transmitting data from server to the client.
  • Gathered requirements, analyzed data, and designed software solutions based on the requirements.
  • Analyzing the existing System.
  • Analyze, design and coordinate the development of applications.
  • Involved in identifying the code changes.
  • Involved in resolving the issues.
  • Involved in the 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