We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

Columbus, OH

SUMMARY:

  • 9+ Years of Business Intelligence Experience in Analysis, Design, Development, Quality Assurance and Implementation and Tableau Reporting.
  • Involved in the installation and configuration of Tableau server. Have also configured distributed installation for Improved Performance
  • Extensive experience in tableau dashboard design and development, troubleshooting, technical support and monitoring of system usage.
  • In - depth Experience on Tableau Desktop, Tableau Viewer and Tableau Server.
  • Extensive experience in data analysis, profiling, data validation and data visualization.
  • Experience in writing Business requirements and Functional requirements document.
  • Extensive experience in design and development of reports,worksheets and dashboards.
  • Experience on data modeling in relational and dimensional data model.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
  • Ability to deliver strategic and tactical solutions for critical reporting requirements.
  • Extensive experience in designing and building Webi reports using Business Objects.
  • Expertise in using Business Objects reporting functionalities such asDrilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Experience in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
  • Experience in developing Dashboards using Xcelsius.
  • Strong experience of designing, building, testing, documenting the Universe.
  • Strong SQL Query experience using various RDBMS like Oracle, Teradata, Microsoft SQL Server and DB2 databases.
  • Expert in Crystal Reports Enterprise, Crystal Reports 2008/2011, WEBI Reports, Universe and IDT development.
  • Experienced in tuning Long running SQL queries for better performance.
  • Excellent problem solver and solution provider; ability to work in a fast-paced, complex and time sensitive environment.
  • Excellent written and verbal communication skills.
  • Excellent experience in Banking and Finance domain.

TECHNICAL SKILLS:

REPORTING TOOLS: Tableau Desktopv8/v9,Tableau Server v8/v9, Business Objects XI4.0, Crystal Reports 2011,Xcelsius 4.5

DATABASES: Oracle 11g/10g, Teradata, Microsoft SQLServer 2005/2008, DB2.

LANGUAGES: SQL, PL/SQL, C, HTML.

OPERATING SYSTEMS: UNIX, Linux, Windows NT/2000/XP/7 and MS DOS.

SQL TOOLS: Teradata SQL Assistant, SQL Developer, Rapid SQL, TOAD, SQL Server MANAGEMENT STUDIO

OTHER TOOLs: Microsoft Office, Microsoft TFS.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

SR. TABLEAU DEVELOPER

Responsibilities:

  • Working as a Tableau Desktop Consultant focusing on developing high-end visualizations driven by data from SQL Server.
  • Convert business requirements into story-telling viz by developing dashboards in Tableau Desktop and publish them to Tableau Server allowing end-users to control data and filter down further as desired.
  • Attended requirement gathering sessions with end-users.
  • Created functional and technical specification document and test cases documents.
  • Created customized Calculations, Filters (Local, Global), Parameters, Sets and Combinedsets for various analytical dashboards.
  • Worked on creating aggregates, Annotate,hierarchies, sorting and grouping.
  • Proficient in creating Actions in Worksheet level and Dashboard level.
  • Experience in building Maps manually by using Custom Geo-coding.
  • Created customized reports using various chart types like text tables, tree maps, heat maps, line charts, combination charts,bar charts, pie charts, bubble chartsin tableau using excel and other data sources.
  • Worked on Drill down, Drill up analysis, custom hierarchies using tableau desktop.
  • Created Ad hoc worksheets from the given data.
  • Generated a consolidated report on weekly and monthly basis.
  • Createdguided navigation links within InteractiveDashboards.
  • Extensively used analytical features in Tableau like Statistical functions, reference lines, trend lines,forecasting in many tableau worksheets.
  • Publish the developed worksheets and dashboards to Tableau Server for end users to view.
  • Scheduled frequency and time to refresh data when source data is published.
  • Created Test Scripts, Test hierarchy to represent the features and functionality that need to be tested in the application.
  • Exercised best practices for Tableau report development.
  • Knowledge on tableau installation and configuration.
  • Conducted Training sessions to the end users.

Environment: Tableau Desktop v9, Tableau Server v9, Windows Server Standard R2, SQL Server, Crystal 2011, CMS, CMC, MS Excel, UNIX.

Confidential, CHICAGO, IL

SR. BO/CRYSTAL/TABLEAU DEVELOPER

Responsibilities:

  • Performed data analysis on large data volumes to support business decision making.
  • Working with business users to create business requirements and translate them into functional specifications.
  • Understanding of business and technical metadata, data lineage and data models.
  • Worked with data modelers to identify required fields, data types and default values.
  • Worked with different source systems to identify the required data points for data mapping.
  • Worked on data validation to make sure data loads were accurate as per mapping rules.
  • Identified discrepancies in source data and found alternative mapping for attributes.
  • Created Webi reports, Crystal reports and Charles river reports according to user requirements.
  • Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
  • Involved in the designing and Building of Universes, Classes and objects.
  • Resolved loops and Traps using Contexts and Aliases while designing Universes.
  • Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
  • Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
  • Customized Universe Level Prompts as per Functional Requirements.
  • Check the integrity of the Universes, and export the universes to Repository for making available to users.
  • Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail, Formulae, Optional Prompts, Functions, Alerters etc.
  • Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
  • Extensively worked with formatting the reports according to the user requirements.
  • Used Web intelligence to create, edit and set different options for the corporate documents.
  • Created Cross tab crystal reports using various cross tab complex and nested formulas.
  • Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
  • Created Crystal reports using add command, stored procedures and universes.
  • Migrated reports to SIT, UAT and PROD using promotion management.
  • Assisted Business Users in building and understanding reports during UAT and postproduction support.
  • Worked with quality assurance team in BRD walk through sessions and in testing phase.
  • Created Tableau worksheets and dashboards for Charles River trading application reports.
  • Created Advanced connections, join new tables, create & manage live and extract connections in Tableau.
  • Created Data blending, Relationships, Filters, Quick filters, Context filters, Parameters, Hierarchies, Sorting, Groupings.
  • Worked extensively with Advance analysis Actions, Calculations, Background images, Maps.
  • Implemented Individual Axis, Axis Blending and Dual axis in Tableau.
  • Extensively used Marks section and Page shelf.
  • Proficient in creating Data bins and histograms.
  • Meticulously formatted reports and dashboards as per user’s inputs.
  • Created, sorted and managed groups according to report requirement.
  • Supported Testing team during SIT and UAT and created unit test case documents.
  • Involved in publishing various kinds of interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau servers.
  • Helped business users with Post production activities and issues.
  • Given KT to new team members.
  • Worked on various emergency production fixes.

Environment: Tableau Desktop v8, Tableau Server v8, Business Objects 4.0/XIR2, Crystal Reports 2011, ORACLE 11g,Rapid SQL, Microsoft Office, Charles River Application.

Confidential, DEERFIELD, IL

BO/CRYSTAL DEVELOPER

Responsibilities:

  • Involved in gathering the requirements from Business Users.
  • Maintained metadata repositories and data dictionaries.
  • Worked with data governance team to maintain consistency with attributes and data definitions.
  • Analyzed these requirements and prepared Technical Specifications Document for crystal reports.
  • Fetched new data sources that are required for reporting.
  • Involved in data modeling discussions with system analysts and data modelers.
  • Worked on data lineage initiative to track the attributes from system of record till the reporting layer.
  • Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
  • Used On-demand, normal sub reports concepts in the Crystal reports.
  • Formatted the Various Crystal reports according to the specifications by the end user.
  • Created Unit Testing Documents, FD and TD’s.
  • Validated warehouse data to ensure the consistency between multiple monthly loads.
  • Created Webi and Crystal reports and dashboards according to user requirements.
  • Involved in Beta testing of Data Warehouse project.
  • Validated the data such that it is pulling the intended data from SAP BW to reports and created a Unit test document for those reports.
  • Modified already existing Crystal reports according to customer requirements.
  • Created groups according to the report requirement, sorted the data in groups, managed the groups, giving different header names. Used specified order for the groups.
  • Modified the Crystal reports to increase the performance of reports.
  • Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins.
  • External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
  • Developed Universes, Webi, Webi Rich Client reports.
  • Involved in Building universe, Inserting tables, Detecting joins, Detecting cardinalities and checking the integrity.
  • In Universes, created classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
  • Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
  • Implemented the Object-Level Security and Row-level security in Universe.
  • Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables.
  • Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
  • Created users, groups, server groups and setup security architecture.
  • Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail, Formulas, Optional Prompts, Functions, Alerters etc.
  • Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

Environment: Business Objects XI3.1/XIR2, Web Intelligence, Universe Designer, Business View Manager, Desktop Intelligence, Crystal Reports 2008, Tableau v7,SQL Server 2008, ORACLE 10g

Confidential

BO/CRYSTAL DEVELOPER

Responsibilities:

  • Connecting to the different databases like SQL Server / Oracle / Sybase etc.
  • Creating different kinds of reports like Standard reports, mailing label reports, Cross Tab reports.
  • Creating complex formulas.
  • Creating sub-reports.
  • Creating different kinds of charts.
  • Creating dynamic cascading parameter.
  • Creating static / dynamic- parameters.
  • Publishing the developed report to the repository.
  • Formatting the reports with conditional formatting or non-conditional formatting.
  • Writing commands at the crystal reports level.
  • Trouble shooting of various issues faced by customers.
  • Creating different complex report as per the customer requirements.
  • Inserting summaries’ and running totals using default crystal option.
  • Creating manual running total formulas.
  • Applying Row Level / Column Level security through crystal reports.
  • Exporting the reports to various formats like PDF, Excel and Data Definition etc.
  • Creating data connection to the database.
  • Creating a dynamic data connection to the database.
  • Creating a data foundation.
  • Creating a business element.
  • Creating a business view.
  • Creating a list of values for the report (Dynamic parameter).
  • Setting up of user right business views.
  • Applying row level security and column level security using BVM.
  • Creating filters at data foundation and business element level.

Environment: Business Objects XI R2, Broadcast Agent, Infoview, Crystal Reports XI, Xcelsius 4.5, Performance Management, Dashboards, Toad, SQL, PL/SQL, Oracle 8i, Windows 2000, MS SQL Server 2000, MS Office.

Confidential

TECHNICAL ASSOCIATE

Responsibilities:

  • Worked on data profiling to see whether data met the expectations of business requirements.
  • Worked on documenting functional specifications and data mapping rules.
  • Worked on data validation in different environments like UAT and PROD.
  • Worked on multiple data feeds from different source systems.
  • Created Crystal reports using complex multiple sub reports, passing data from sub reports to main reports and managing the report.
  • Used On-demand, normal sub reports concepts in the Crystal reports.
  • Formatted the Various Crystal reports so that the end product will look as specified by the end user. Used Forms.
  • Very good in formatting crystal reports.
  • Used fetching data from command objects and various databases.
  • Modified existingCrystal reports according to customer requirements.
  • Modified the Crystal reports to increase the performance of reports.
  • Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
  • Applied row level and object level securities on different groups and users.
  • Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
  • Use the slice and dice feature, set variables, and set alerts and group values in a report.
  • Built queries to retrieve data through a universe and set up query conditions.
  • Created Cross-tab and Master Detail reports in Business Objects.
  • Creating complex reports using features like slice and dice, Drill capabilities, Functions and Cross Tab tables with multiple breaks.
  • Used alerts to highlight critical data based on business conditions.
  • Created various MTD, YTD and daily reports.
  • Extensively used Calculations, Sorting, Rank, Drill, Slice and Dice.
  • Created classes and objects and logically grouped them together and defined business names for the classes and objects.

Environment: Crystal Reports, Business Objects Enterprise, SQL Server 2000/2005, Oracle 9i/10g, TOAD, MS Access, MS Office Suite, Windows XP / Windows 2003 Server.

Hire Now