We provide IT Staff Augmentation Services!

Tableau Consultant Resume

0/5 (Submit Your Rating)

Naperville, IL

SUMMARY

  • 7+ years of experience in the field of Information Technology.
  • 5 years of experience in Tableau dashboard development and analytics includes experience as a BI Developer and 2 year as a SQL Developer.
  • Experience transforming complex business requirements into rich data visualizations using Tableau.
  • Experience working with both relational and multidimensional data sources and good understanding of client server architecture.
  • Data extraction, creation of metrics, attributes, filters, sets, ranks, parameters, aging bins, reports and dashboards.
  • Created advanced chart types, rich data visualizations and complex calculations to present the data in a meaningful way.
  • Strong experience working with SQL server databases.
  • Experience in all phases of SDLC including requirement gathering, analysis, design, implementation and testing.
  • Experience in coordinating with the business users and other interface teams effectively for any kind of requirements/impact analysis.
  • Good experience in managing all the change requests, bug fixes and data requests.
  • Excellent understanding of concepts like Star - schema, Snowflake Schema using fact and dimension tables
  • Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, Constraints, Indexes.
  • Knowledge of Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources to targets.
  • Working knowledge of Microsoft Office products such as Word, Excel and Visio.
  • Excellent presentation, communication and organizational skills.
  • A good team player with good analysis, problem-solving ability, verbal and written communication.
  • Ability to learn quickly and adapt to new technologies.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11i, SQL Server 2000/ 2005/2008 , Teradata, Microsoft Access.

Business Intelligence Tools: Tableau 9.0/8.2 / 8.1/ 7.0 , Microsoft BI (SSAS, SSIS & SSRS), Informatica

Languages: C, C#, Java, PL/SQL, T-SQL

Web Technologies: JavaScript, Ajax, HTML, CSS and XML.

Operating Systems: Windows 98/2000/2003/ XP, Windows 2008, UNIX

Applications: Eclipse, NetBeans, Oracle SQL Developer

Office Tools: MS Word, Excel, PowerPoint, MS Outlook

Data Modeling Tools: Star Schema, Snowflake Schema, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential - Naperville, IL

Tableau Consultant

Environment: Tableau 9.0/Oracle/Microsoft Data Cubes/Access/SQL server

Responsibilities:

  • BI Analyst responsible for developing and maintaining Tableau dashboards.
  • Creation of dashboards for business groups like finance, sales and health care.
  • Analysis of business requirements and creation of metrics required for the reports.
  • Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
  • Working on generating various dashboards using data sources such as Oracle, MS Access, Microsoft SQL Server and Microsoft Analysis Services.
  • Designing rich data visualizations of the complex business requirements using advanced chart types and metrics.
  • Designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
  • Resolving technical issues and managing all the change requests, bug fixes by delivering it in time without any issues.
  • Coordinating with business users effectively for any kind of requirements/impact analysis during the development of reports.
  • Maintaining project documentation, enhancements / bug fixes list and user access request approvals for the dashboards.
  • Translated business perspectives into technical perspectives and vice-versa.
  • Transformed manual reports into automated department KPI dashboards.
  • Used analytical methods and tools to extract data to authenticate its validity, applicability, efficiency, and accuracy.
  • Provide visual/graphic analysis based on data content.
  • Facilitated a common shared vision amongst departments of all deliverables including business, functional, and non-functional requirements.
  • Demonstrated proficiency with databases, analytics and business applications.
  • Developed and maintain tools to monitor and improve compliance processes and ensure data integrity.
  • Conducted Tableau training to inexperienced users and Business Analysts.

Confidential

BI Developer

Environment: MS BI (SSIS, SSAS, SSRS), Tableau 7.0, SQL Server 2000/2008, VS 2003/2008, C#, Asp.net 2.0

Responsibilities:

  • BI and web developer responsible for reporting for Confidential finance department.
  • Worked with Business Intelligence data visualization tools with specialization on Tableau.
  • Interacted with Business users to understand their requirements.
  • Analysis of business requirements and providing estimation.
  • Developed, Designed and supported interactive Tableau Dashboard reports, delivered them on a timely manner
  • Creation of SSIS packages and report generation using SSRS.
  • Worked upon full range of Tableau platform capabilities to design and implement proof of concept
  • Solutions and created advanced BI visualizations, including complex views and predictive models.
  • Translated business perspectives into technical perspectives and vice-versa
  • Transformed manual reports into automated department KPI dashboards
  • Automation of Payroll journal and accrual entry reports which was manually prepared by the Confidential Finance users.
  • Designed and maintained SSRS reports used to analyze timesheet and earning data.
  • DB upgrade from including conversion of DTS packages into SSIS packages.
  • Running the application process successfully every month and supporting the post process run issues or Queries raised by the users and resolving it in time without any escalation.
  • Performance tuning in the complex SQL stored procedures.
  • Involved in developing of star schema and snowflake schema dimensional data model.
  • Analyzed business process workflows and developed ETL procedures for moving data from source to Target systems.
  • Design and maintenance of internal Paycost website to be used by Confidential finance users.
  • Disaster Recovery system set up for the application.
  • Creation of all project documents, enhancements / bug fixes list and user access request approvals for the application in the project portal and updating the same whenever required.
  • Providing complete KT of the application to the new joiners in the team and also ensuring that any change in the Application process is being shared with them.
  • Also the changes are documented and shared it with the team for future reference.

Confidential

SQL Developer

Environment: MS SQL Server, SQL Developer, TOAD, SQL * Plus

Responsibilities:

  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Provide database coding to support business applications.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
  • Worked with internal and external clients for import and normalization of third-party data.
  • Documented and maintained database system specifications, diagrams, and connectivity charts.
  • Monitored and provided front-line support of daily processes.
  • Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
  • Provide technical support and guidance to staff and clients.
  • Generate reports and spreadsheets detailing database changes and performance.

We'd love your feedback!