We provide IT Staff Augmentation Services!

Analytics Consultant Resume

SUMMARY

  • Extensive experience in Data warehousing and Business Intelligence technologies across various domain.
  • Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
  • Maintained and Installed Tableau Server in on AWS
  • Continuous monitoring of server status by automated scripts.
  • Automation of extract refresh on Tableau server.
  • Multiple Tableau server upgrades
  • Performance test by using TABMON.
  • Load test critical reports before release using TABJOLT.
  • Performed Site export import using tabcmd and also using TABMIGERATE
  • Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
  • Tableau tools include Tableau Desktop versions 8/8.1/9.x/10.x, Tableau Reader, Tableau Public, and Tableau Server versions 8/8.1/9.x/10.x.
  • Produced attractive visuals/dashboards to convey the story inside the data.
  • Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Have been working with various data sources such asOracle, Amazon Redshift SQL Server, Cloudera Hadoop, ODBCand flat file sources.
  • Involved inTroubleshooting, Performance tuning of reportsand resolving issues within Tableau Server andReports.
  • Designed and deployed reports with Drill Down drill up and Drop down menu option and Parameterized and Linked reports.
  • Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn fast.
  • Excellent communication skills in both written, oral along with ability to tell a story through data.
  • Strong analytical, logical, Communication and problem solving skills and abilityto quickly adapt to new technologies by self - learning.

TECHNICAL SKILLS

Operating System: Windows 98 / 2000, Windows

XPBI/Visualization Tools: Tableau Desktop 6/7/8.x/9, Tableau Public 8.1/9.x, Tableau Reader 8.x/9.x, Tableau Server 8.x/9.x, Qlikview 11

Programming Languages: SQL, PL/SQL

RDBMS: Oracle, MS Access

Application Software: MS Excel, MS Word, MS Power Point, Microsoft Visual Studio

PROFESSIONAL EXPERIENCE

Confidential

Analytics Consultant

Responsibilities:

  • Part of testing team for Tableau 10.3 Beta.
  • Architecting and building Analytics Rapid Deployment Solutions
  • Responsible for Client Delivery and Solution Design
  • Maintained and Installed Tableau Server in all the environments on AWS.
  • Added cores to the server and integrated extra nodes.
  • Worked extensively with Tableau support for several product issues.
  • Automated backup by integrating tabcmd with powershell.
  • Keeping a continuous watch of Tableau server inbound outbound connectivity by automated scripts.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Automated backup process and storing then in S3
  • Automated user management by integrating it with AD groups.
  • Handled smooth Tableau server upgrades
  • Performance test by using TABMON.
  • Load test critical reports before release using TABJOLT.
  • Performed Site export import using tabcmd and using TABMIGERATE.
  • Automated email push notification using METRIC INSIGHT
  • Involved in creating dashboards by extracting data from different sources.
  • Created dashboard using parameters, sets, groups and calculations.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Intergrating Row level security for Scoreboard to show up in different Confidential stores.
  • Integrating username function calculation to achieve geo specific security.
  • Created calculated fields, mapping and hierarchies.
  • Created drill through reports in dashboard.
  • Involved in creating data blending in case of merging different sources.
  • Involved in creating a dual-axis bar chart with multiple measures.
  • Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
  • Extensively used data blending in Tableau.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Created incremental refreshes for data sources on Tableau server.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server V9/V10.x, Tableau Desktop v9/v8/v10.x, Metric Insights, Windows Server 2012 R2

Confidential

Analytics Consultant

Responsibilities:

  • Architecting and building Analytics Rapid Deployment Solutions
  • Responsible for Client Delivery and Solution Design
  • Involved in creating dashboards by extracting data from different sources.
  • Handled smooth Tableau server upgrades
  • Created dashboard using parameters, sets, groups and calculations.
  • Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
  • Created calculated fields, mapping and hierarchies.
  • Created drill through reports in dashboard.
  • Kerberos authentication for Hadoop env.
  • Involved in creating data blending in case of merging different sources.
  • Involved in creating a dual-axis bar chart with multiple measures.
  • Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
  • Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
  • Extensively used data blending in Tableau.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Maintained and Installed Tableau Server in all the environments.
  • Created incremental refreshes for data sources on Tableau server.
  • Created report schedules, data connections, projects, groups in Tableau server.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Used ETL especially Talend 5.5 process to Extract, Transform and Load the data into data warehouse.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: s: Tableau Server v8/V9, Tableau Desktop v9/v8, Talend 5.5, Oracle

Confidential

System Analyst

Responsibilities:

  • Requirement Analysis and Data-extraction from Heterogeneous data sources.
  • Metadata modeling. Development of Reports and Dashboards using Tableau 8.3
  • Integrating the web-based application with Tableau 8.3 server
  • Created Tableau extract files for improving the performance.
  • Providing insights on the Dashboards.
  • Participation in Quarterly Business Reviews.
  • Development of Sales, Marketing, Finance, Operations and Infrastructure Reports in Qlikview 11.0
  • Propose workflows and data structures & Design mock-ups and templates
  • Evaluate customer needs effectively and evidence of using good judgment.
  • Worked with a dynamic and demanding environment where expectations for performance and productivity are high.
  • Integrating trusted authentication services to enable single sign-on using LDAP credentials
  • Load testing using Qlikview Scalability and Tableau Server Testing Environment
  • Used different Mark types and Mark properties in views to provide better insights into datasets.
  • Created various types of charts to provide better visualization
  • 5 weeks of hyper-care sustain post production release.
  • Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
  • Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
  • Published views and dashboards in Tableau Server for auditor review.
  • Documenting Technical and Functional specifications.
  • Completion and certification of modules from Compliancewire.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, Qlikview11, MS Excel, MS Access, Windows Server 2008 R2

Hire Now