We provide IT Staff Augmentation Services!

Tableau Developer / Bi Data Analyst Resume

2.00 Rating

Dallas, TX

SUMMARY

  • Over 8+ years of IT experience in SQL, SQL Server, Tableau Desktop, Tableau Server, BI data analyst and Datawarehousing.
  • Experience in implementing Tableau Online, a SaaS application wif the same architecture as Tableau Server dat enables cloud implementation of analytics.
  • Expertise in Tableau BI reporting tools Tableau Dashboards Developments & Server Administration.
  • Created dashboards and Scorecards like analytical and operational reports.
  • Very good experience in designing, building, publishing data analysis reports/dashboards for large Volumes of data.
  • Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
  • Extensive experience in various DB/DW/BI technologies including Teradata, Oracle, SQL Server, and Informatica.
  • Creating dashboards in line wif the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
  • Provide database coding to support business applications using T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Extensive experience in troubleshooting and optimizing performance of SQL using fiddler, profiler and execution plans.
  • Experience training end users through online and in-class sessions.
  • Extensive experience interacting wif Department Managers and different levels of users and developers.
  • Expertise in Production Support related activities.
  • Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into target database.
  • Improved Reports performance in tableau using extracts and context filters.
  • Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
  • Implemented Tableau/Oracle BI security Confidential the Data (Data security) and object (Roles and Permissions) security.
  • Experience wif Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML.
  • Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
  • Developed best practices guide for Tableau implementation using Tableau and Tableau server online.
  • Involved in creating Dashboards using Tableau Desktop, Tableau Server, QlikView and Hyperion IR.
  • Created incremental refreshes for data sources on Tableau server.
  • Having strong analytical, logical, Communication and problem solving skills. Ability to adapt to new technologies by self-learning.

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop 9.x/8.x/7.x, Tableau Server, SAP BO 3.1, Qlikview, DataStage, Informatica 9.x.

Databases: SQL Server 2012, Oracle 11g/12c, MySQL, Hadoop, Hive, Teradata

Operating System: Windows, Unix, Macintosh.

Languages: C, Java, PHP, PL/SQL Java Script, XML.

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

Process tools: JIRA, HP Quality Centre, Synergy, VSS, SharePoint and Incident/Change Management

Testing Tools: Quality Center, QTP, Test Tracker, Selenium.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer / BI data analyst

Responsibilities:

  • Involved in Exploring, Designing, Building, Testing and Deployment of the high level Dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics.
  • Involved in understanding the reporting requirements and providing Tableau reporting solutions.
  • Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
  • Developed new reports and enhancing existing reports in Business Objects Web Intelligence environment.
  • Presented to higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
  • Coordinated and conducted business, system requirements analysis meetings wif business and technology partners, business analysts and DBA’s.
  • Analyzed the Business requirements and translated them into Application and operational requirements.
  • Performed PL/SQL validation queries by cross testing the resulting data from the reports.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
  • Configured AD during the Tableau Installation and imported Users and groups in Tableau Server and set their permissions as intended
  • Configured SMTP server for Tableau and ensured dat Users are getting the Alerts and subscriptions of different views dat users subscribed for.
  • Used Tableau's JavaScript API to integrate Tableau visualizations into web applications.
  • Extensively used Tabadm and Tabcmd utilities to perform several Server side tasks in migrating Tableau content and manage the Tableau server
  • Recommended and took lead on new ideas of implementation/developing of WebI reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
  • Created Classes and Objects for management system based on the warehouse schema in Universe.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
  • Analyze complex data from various data repositories and become familiar wif user base locations.
  • Blendeddata frommultiple databases into one report by selecting primary database for data.
  • Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Lov's.
  • Revised the Group Structure in both Development and Production Environments.
  • Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
  • Developed Webi, Webi Rich Client and Xcelsius Dashboards.
  • Design processes to minimize data quality risks and proactively identify potential data issues.
  • Involved in Tableau Licensing and Installation.
  • Worked on Tableau Metadata tables and Postgre SQL.
  • Provided support to different levels of Tableau developers.
  • Involved in Creating and Managing security rules for dashboards and views.

Environment: Windows XP, Linux, Windows 7, Tableau Desktop 9.x/8.x, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.

Confidential, New York, NY

Tableau Developer/BI data analyst

Responsibilities:

  • Creation of metrics, attributes, filters, reports and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
  • Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
  • Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
  • Work directly wif management to ensure dat Web-site's financial transactions and database management applications operate Confidential peak efficiency.
  • Ensured projects were completed on time.
  • Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
  • Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
  • Scheduled data extracts on a daily basis.
  • Sophisticated stored procedures and triggers to provide complete technical solutions.
  • Worked wif all levels of development from analysis through implementation and support.
  • Participated in test planning and test script definition.
  • Resolved end user reporting problems through collaboration wif IT.

Environment: Tableau Desktop 8.x/7.x, Tableau Server, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, MS Office 2010.

Confidential

SQL Server Developer

Responsibilities:

  • Installation and administration of MS SQL Server 2000 and Windows 2000.
  • Coding complex SQL Stored procedures according to the specs joining the different tables and conditions.
  • Created Temp tables in the stored procedure for different application.
  • Wrote stored procedures and T-SQL code to accomplish various tasks.
  • Created SQL functions.
  • Created index to increase performance of stored procedures.
  • Created database tables, constraints and indexes.
  • Reverse engineer the database code, data and model to extract the business rules and understand the current functionality of the system.
  • Created SQL queries to do data analysis and provide ad-hoc reports.
  • Created business rules to test incoming data feeds from upstream systems.
  • Interviewed Business/Process owners to gather requirements to enhance the existing application.
  • Developed complex Stored procedures for Insurance Budgeting and these were consumed by frontend reporting for the Performance needs
  • Created Snow-flake/Star schemas for designing the ODS
  • Set up Indexes and constraints for various dimensions and measures to speed up the Query processing
  • Provide high level design in the form of process maps
  • Prepared Use Cases for each requirement along wif the supporting document (like input and output fields from the database, their data type, validations).
  • Involved in performing a data mapping, quality assessment converting multiple databases for all product types.
  • Partitioned tables, which had frequent inserts, deletes and updates to improve the overall performance.

Environment: SQL Server 2000, T-SQL, VB 6.0, MS Office, and Windows 2000.

Confidential

SQL Developer

Responsibilities:

  • Programmed clients website and applications - worked collaboratively wif clients.
  • Provided insightful ideas for developing TEMPeffective and accurate codes - Evaluated latest technology on the market and made recommendations to clients to integrate new designs as available by new technology.
  • Collaborated wif end users and other related departments to ensure dat the website is meeting the client's expectations and business requirements.
  • Extracted and collected data to create needed reports.
  • Validated accuracy of data to ensure database integrity.
  • Created Pl/Sql logic for web-based applications for data entry & extraction.
  • Generated various SQL queries to be used in Reporting tools.
  • Created database tables, constraints, triggers, packages, procedures & functions.
  • Represented database team in various high-scale projects.
  • Developed installation scripts to migrate the developed components into further instances and eventually Production.
  • Performed tuning of SQL queries using Explain Plan and created indexes on tables to improve the efficiency of the queries.
  • Collaborated wif technical team members to integrate back-end and front-end elements.
  • Worked on oracle utility, scheduling tool and versioning tool.
  • Worked on Perl scripting.
  • Created PL/SQL procedures for certain Business Requirements
  • Designed SQL overrides in source Qualifier according to business requirements
  • Created sessions and workflows for designed mappings and created Sequential Workflow using
  • Monitoring the session logs to check the progress of data load.

Environment: Windows XP, SQL Developer, MS-SQL 2008 R2, MS Access, MS Excel, SQL-PLU and ava.

We'd love your feedback!