We provide IT Staff Augmentation Services!

Tableau Consultant/analyst Resume

5.00/5 (Submit Your Rating)

Blue Bell, PA

SUMMARY

  • Experienced Tableau BI Analyst having in - depth and comprehensive experience in design, development, testing, Security and support of Data warehousing and Client/server projects.
  • Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.
  • Extensive experience working with Tableau Software as a dashboard developer, administrator and SME
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
  • In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
  • Used ETL Informatica cloud, SQL server Integration services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle and DTS (i.e. Import and Export) also worked to Automate the ETL operations.
  • Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
  • Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML). Experience in Database modeling using data modeling tool.
  • Worked on loading data using Informatica cloud to S3 storage and Amazon Redshift. Used SQL workbench, NoSQL, PostgreSL, DynamoDB instances for creating tables on Amazon Management Console.
  • Good knowledge of Hive, Normalization/De-normalization, data design methodology and building Referential Integrity.
  • Experience on Teradata SQL assistant 14.1.0, MS SQL server, writing SQL queries, PL/SQL operations - functions, triggers and PL/SQL block statements
  • Proven experience in development and implementation of applications in various domains viz. Financial services, Pharmaceuticals, IT and Telecommunications Sector.
  • Used MS Excel, Oracle, Teradata as input data in Tableau database connection and use database extract for publishing database on Tableau server. Blended data from multiple resource like flat files, Excel, Redshift, Oracle and Tableau server environment.
  • Experience on analyzing large amount of data, used statistical tools like Minitab, JMP pro, SAS enterprise minor, VBA.
  • Experience in JAVA, JSP, HTML, XML and scripting language.
  • Certified as IBM Cognos 10 BI Administrator, Cognos BI Report studio.
  • Proficient in various Business Intelligence tools - Tableau, Alteryx, Qlik Sense, Cognos
  • Perform complex MS excel operations - Pivot table, filter operations on the underlying data
  • Experienced application developer with expertise in designing and developing Business Intelligence solutions in Data Warehousing using Cognos suite(Framework Manager, Cognos connection, Report Studio)
  • Expertise in developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modelling.
  • Complex Report building with Report Studio to customize the functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting and Ad-hoc reports using Cognos Query Studio.
  • Designed documentation in Confluence, maintained JIRA issue tracking in confluence and used MS office, sharepoint for sharing project documentation.
  • Integrated third party portals using Cognos Java SDK
  • Worked on creating workflows using Alteryx for creating data extracts and cleansing the data.
  • Worked on reporting tools like Alteryx, Qlik Sense, Qlik view and statistical tools like SAS, Advanced Excel (v-lookup, charts, dashboard design), Visual Basic using visual studio 8, MS office, MS Access (advanced)
  • Possess ability for critical thinking, analysis, good interpersonal and communication skills.
  • Ability to adapt and learn new technologies and get quickly proficient with them.

TECHNICAL SKILLS

BI Tools: Tableau desktop version 9.0, 9.2, 10.0 - Tableau Desktop, Tableau Reports and Dashboard Design, Data visualization and analysis, Tableau Server Alteryx v.11, Qlik Sense desktop version 10.7.3 - Reports and Dashboard design Cognos 10.X(10.1,10.2) (Report Studio, Query Studio, Cognos Connection, Cognos Administration, Framework Manager)

Languages: SQL, PL/SQL,T-SQL, SQL Plus, TOAD

Databases: Teradata SQL Assistant 14.1.0, ORACLE 8i, 9i, 10g,11g, MS SQL Server 2008/2012 and MS Access (Advance), DB2

Servers: Application Servers (Tomcat), Web Servers (IIS, Apache)

Statistical Tools: SAS Enterprise Minor, JMP Pro, MS Excel (Advanced V-lookups, charts, dashboard design), Data mining, Predictive analysis, Logistic regression using SAS Enterprise Minor tool

Programming Skills: Cognos SDK toolkit - 10.X, Struts 2.0, Eclipse IDE, JAVA/J2EE, HTML, CSS, JavaScript, Visual Basic using MS Visual Studio 8.

Documentation: Confluence, JIRA issue tracking, SharePoint, MS Office professional 2013 - Advanced MS Excel (Pivot table, V-lookup), MS office 2013.

PROFESSIONAL EXPERIENCE

Confidential, Blue Bell, PA

Tableau consultant/Analyst

Responsibilities:

  • Worked as a primary IT resource with major clients in pharmaceutical & IT to articulate the results, trends and forecast possibilities by analyzing data using various business Intelligence tools - Tableau desktop, Qlik Sense, Alteryx.
  • Accessed reports, analyzed raw data received from various sources - tableau data extracts, server, Excel and database. Transformed the data into creative and compelling insights.
  • Involved in gathering requirements from the client and identify metrics using Excel, Tableau and questionaries
  • Involved in full life cycle report development using BI tools - Tableau. Performed data blending, Join, union operation on data by connecting to data from multiple sources.
  • Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for brands and clients.
  • Used filters, calculations, parameters and charts to understand the opportunities for brands and clients.
  • Ustilized Teradata, MS SQL server and Oracle as a database for querying and validating data. Blended data from multiple resources.
  • Managed Tableau server tasks like publishing dashboard on server, creating user profiles, subscribing, scheduling full refresh, assigning user roles and permissions and managing user security roles.
  • Administered user, user groups and scheduled instances for reports in Tableau
  • Performed Tableau server backups scheduling, created multiple sites, user management activities, migrated the dashboard from one environement to another.
  • Utlized Qlik sense for creating reports, created data models and wrote scripts for dashboard development.
  • Involved in creating extracts, from multiple data source, published data source and provided user level security.
  • Worked on creating workflow in Alteryx, filtering data and creating tableau data extract using Alteryx tool
  • Worked on projects with sales, marketing and pharmaceutical firm and provided support through all phases of report development life cycle.
  • Maintained project documentation in SharePoint. Curated the dashboard to resolve any technical errors and provided 24/7 production support.

Confidential, Delaware

Tableau & Cognos Analyst

Responsibilities:

  • Worked as a primary IT resource in developing reports using Tableau BI tool.
  • Developed a technical spec by analyzing the business from the gathered BPR.
  • Designed the dashboard templates and created various dashboard reports for the business users.
  • Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with tables in them.
  • Extensively used Teradata to query data, MS SQL server, SQL developer to validate reports and to write views for some reports.
  • Worked on Creating complex dashboards using Tableau Desktop and published to Tableau Server for general user consumption.
  • Tested Tableau dashboards on various environments before publishing on production server, tracked issues in JIRA and resolved the technical errors before deployment
  • Installed and configured Cognos BI for IT team, created Cognos roles, performed Cognos security setup for the project.
  • Identified and mapped various database fields for reporting purpose using Teradata SQL assistant and documented the results in the excel file.
  • Maintained project documentation in confluence for both Tableau and cognos reports.
  • Installed Cognos framework manager, report studio for reporting purpose. Created Cognos framework manager model and tested report in the report studio.
  • Scheduled Tableau dashboard for full refresh on the tableau server and manage security
  • Co-ordinate with developers and ETL team identifying and verifying the database fields.
  • Worked extensively with developers, ETL team, users in tracking issues, providing training and resolving the errors.

Confidential

BI developer/Analyst

Responsibilities:

  • Worked as a Technical Lead, defined scope (requirements) and objective based on user needs and thorough understanding of business processes.
  • Gathered and analyzed requirements and provide recommendations to address and resolve root causes.
  • Responsible for development and enhancement of Cognos portal through Cognos SDK.
  • Set up POC environment.
  • Designed high level and low level technical design documents.
  • Troubleshot production issues and provide end-user training to the client.
  • Developed code for automating the process using JAVA Spring framework, JSP, Cognos SDK functions
  • Worked on Oracle database, SQL server for creating tables, writing complex SQL queries.
  • Involved in knowledge transfer to the team members and educate the end-users regarding the technical components.
  • Used Remedy ticketing tool for tracking issues and resolving issues.
  • Involved in all phases of (SDLC) software development life cycle phase - design, coding, testing and production support.
  • Participated in design and implementation of reports using Cognos business intelligence reporting tool
  • Develop filter, calculations and prompts using Cognos Report Studio. Created list, cross-tab and Drill-through reports.
  • Troubleshoot production issues and provide end-user training to the client.
  • Performed complex SQL query operation like writing aggregate functions, sub queries in Oracle and IBM DB2
  • Involved in knowledge transfer to the team members and educate the end-users regarding the technical components.
  • Work on large dataset, create dashboard design and analysis in Report Studio, define master detail relationship between reports and perform drill-through operations, charts.
  • Format the reports according to the client needs, perform conditional formatting
  • Remove duplicates using group/un-group functions, provide aggregated summarized data
  • Utilized Cognos BI Reporting tool to identify risks in the department and used best practices to manage such risks.
  • Gathered business requirements by conducting user interviews and document user requirements
  • Analyzed current vs. past trends, profit/loss trends using charts.
  • Worked with BI team to resolve database and technical issues.
  • Designed functional and technical design documents
  • Used Oracle SQL developer, putty and IBM DB2 for querying the database
  • Extensively worked on creating packages in Framework Manager as per BO Universe, create different Layers in FM Model and published Packages in Framework Manager
  • Defined joins and cardinality between different tables.
  • Interacted with Business User for any enhancements or Updates in Cognos FM model.

Confidential

Intern: Analyst

Responsibilities:

  • Developed an application designed to track activities and issues in server system and produce a performance report
  • Captured and tracked critical business data.
  • Monitored project progress by tracking activity and resolving problems.
  • Published progress reports and recommend actions. Used remedy ticketing tool for tracking issues
  • Determined number of loops involved in the server processing activity
  • Generated meaningful analytical web reports
  • Presented analytical reports and technical results during project discussions and meetings.

We'd love your feedback!