We provide IT Staff Augmentation Services!

Tableau/sql Developer Resume

FL

SUMMARY:

  • Tableau Developer with 5+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications and the related Database Platforms.
  • Strong understanding of project life cycle, SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau.
  • Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
  • In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
  • Expertise in Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
  • Excellent analytical, problem solving and Tableau and SQL debugging skills.
  • Organized Joint Requirement Planning sessions, Interviews and Requirement Elicitation sessions with end-users, clients, Subject Matter Experts and the technology group.
  • In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
  • Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
  • Strong experience in SQL Development, ETL development using Microsoft SSIS, Business Intelligence delivery using SSAS and Reporting solutions using SSRS. Also generated reports using Crystal Reports.
  • Proficient in developing Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL, TOAD and PL/SQL.
  • Experience in using various MS office tools for analyzing, arranging and presenting data.
  • Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel on various environments.
  • Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows.
  • Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS. Also done reporting using Excel with Power pivot.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Experience in creating and implementing interactive charts, graphs, and other user interface elements.

TECHNICAL SKILLS:

Data Visualization, Business Intelligence (BI), Software Management, Data Collection, Tableau, Tableau Desktop, Tableau Server, Cognos, Crystal Reports, MS SQL Server, Oracle, MS Access, SQL Server Management studio, Toad, Microsoft Visual Studio, SQL, PL/SQL, HTML, XML, MS PowerPoint, MS Excel, MS Word, MS Visio, Office, Open Office, UNIX, LINUX, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, FL

Tableau/SQL Developer

Responsibilities:

  • Utilized Agile Methodology to configure, develop process, standards and procedures.
  • Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time.
  • Building the customized and interactive dashboards using multiple data sources.
  • Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created worksheets and dashboards by using custom queries and multiple tables.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Effectively used data blending feature in tableau.
  • Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
  • Defined best practices for Tableau report development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Developing Standard and Create reports using Tableau Desktop.
  • Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
  • Created Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports using SSRS and Crystal Reports.
  • Preparing Report Mapping Documents as per Specifications.
  • Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
  • Created database objects like tables, views, procedures, packages, and cursor using TOAD, PL SQL developer, SQL developer.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
  • Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Confidential

Tableau/SQL Developer

Responsibilities:

  • Liaison for project managers, managers, directors, and stakeholders.
  • Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
  • Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
  • Developed, derived and clarified functional specifications and Use cases.
  • Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
  • Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
  • Created standard reports, cross-tab, sub reports, drill down reports, on demand sub reports using Crystal reports.
  • Designed the conceptual and business process models.
  • Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
  • Tested the Installation of SQL Server.
  • Developed and maintained reports and cubes using the Cognos software package.
  • Implementation of new systems including the integration of the new system with existing systems.
  • Verifying installed systems to ensure that they adequately meet user requirements.
  • Physical design of data record data files and databases.
  • Data migration import export/BCP from Text to SQL Server.
  • Configured Replication Server.
  • Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.
  • Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Involved in writing Test Cases, procedures, reports and approval of software release.
  • Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
  • Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.

Hire Now