We provide IT Staff Augmentation Services!

Senior Tableau Developer Resume

Danville, PA

PROFESSIONAL SUMMARY:

  • Around 10+ yrs of experience in Analysis, Design, Development, Testing, Implementation and Production support (24*7) in Tableau Developer DW/BI applications with Roles as Senior SAP Business Objects developer and Informatica Developer.
  • Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.x/9.x/10.x/2018.x/2019.x, and in various reporting objects like Facts, Attributes, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
  • Experience in SAP BOBJ 4.2/4.1/4.0/BOXI R3.1/R2/6.5, Universe Design Tool (UDT)& Information Design tool (IDT), Informatica Designer, BI Launch pad, Web Intelligence Rich Client, InfoView, Live Office, Desktop Intelligence, upgrade management tool, Central Management Console, Crystal Reports, Xcelsius, Dashboard Design.
  • Experience with ETL process using Informatica Power Center 9.x/8.x/7.x Power Exchange, Informatica Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema, also have vast experience in slowly changing Dimensions and Meta data management. Good Understanding of Data Modeling concepts, Erwin - Forward & Reverse Engineering, Dimensional Data Modeling - Bill Inman, Kimball.
  • Experience in Understanding SAP Business Requirements, Technical Design, Estimation, Project Management activities and Involved in gathering, analyzing, and documenting SAP Business requirements, functional requirementsand data specifications for SAP Business Objects Universes and Reports.
  • Excellent experience in designing SAP Business objects universes, complex BO reports both full client and Web Intelligence Reports.
  • Involved in creating dashboards, reports,maintaining user and server activities by extensively using data blending, embedded functionalities in Tableau and Defining best practices for Tableau report development and effectively using data blending feature in tableau.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
  • Experienced on Tableau activities, Multidimensional database and writing SQL queries.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
  • Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Have good understanding of Tableau architecture, design, development and end user experience.
  • Experience in understanding Fact Tables, Dimension Tables, Summary Tables, Dimensional Data Modeling using Star and Snow Flake Schema.
  • Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing with Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents and Profiling.
  • Proficient experience in designing SQL’s using Hadoop Hive, Oracle, Teradata, SQL Server, DB2, PL/SQLand working with flat files.
  • Extensive experience in Preparing Flow Charts, Analysis Reports, Technical Design documents, Profiling.
  • Creating user’s groups projects Data connections settings as a tableau administrator, Handled Tableau admin activities granting access managing extracts and Installations.
  • Have expertise in Industry’s best practices, Preparing User Manuals, Presentations, BugFixing, Troubleshooting, Root Cause analysis and Solution Development.
  • Have valuable experience in Managing Team Offshore and Onshore to Coordinate Work with effective communication skills, documentation skills, interpersonal skills and also self-motivated, quick learner, team player.

SKILL:

Reporting Tools: Tableau 8.0/9.x/10.x/2018.x/2019.x & SAP Business objects 4.1/4.0/3.1

Database: Hadoop Hive, Oracle, DB2, Teradata.

ETL Tools: Informatica 9.1/8.6.1

Database GUI: Teradata SQL assistant, TOAD, SQL Developer, Mainframe DB2.

Operating Systems: UNIX, Windows 2000/XP/7.

PROFESSIONAL EXPERIENCE:

Confidential, Danville, PA

Senior Tableau Developer

Responsibilities:

  • Responsibility as Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Extensively used data blending, embedded functionalities in Tableau by defining best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
  • Created Rich dashboards using Tableau Dashboard by Building, publishing, scheduling reports and dashboards using Tableau server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
  • Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
  • Provided 24/7 production support for Tableau users and conducting s to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
  • Created SQL Queries for testing the tableau Dashboards by connecting to Hadoop Hive directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Creation of executive dashboard volumes, imbalances, accounting details, and customer information related to acquisition and constructed dashboards to review data validation results and Improvement of existing dashboards organization and bug fixes.
  • Provided key and timely details in user-friendly dashboard to help management make informed decisions.
  • Responsible for interaction with business stake holders, gathered user requirements, analyzed and designed.
  • Develop, Organize, manage and maintain the graphs, tables, slides and document templates for the efficient creation of reports.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
  • Interacted with diverse group of professionals in the organization including managers and executives.
  • Extensively involved in user acceptance testing (UAT) and attended periodic meetings for changes in the application requirements and documents.
  • Prepared of TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents by creating users, folders, Categories and groups assigning the access levels.
  • Modified existing reports based on the business user’s requirement changes and successfully pushed them into Production.

Environment: Tableau desktop 2019.2/2018.3/10.5 , Tableau Server, SAP Business objects 4.2, Designer, Web Intelligence, Crystal reports 2016, Oracle, Windows XP, SQL, PL/SQL, Oracle, MS-Excel, Microsoft SQL Server.

Confidential, Belle Plaine, MN

Senior Tableau Developer / Senior SAP Business Objects Developer

Responsibilities:

  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
  • Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Extensively used data blending, embedded functionalities in Tableau and defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
  • Created Rich dashboards using Tableau Dashboard 10.3 by developing, Organizing, managing and maintaining graphs, tables, slides and document templates for the efficient creation of reports.
  • Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
  • Provided 24/7 production support for Tableau users and conducting s to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
  • Created SQL Queries for testing the tableau Dashboards and by connecting to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Developed Universe as per the Business requirements by resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.
  • Worked very closely with upper management to get detailed information on what information they require in each report.
  • Created Universes, Reports, and Linked with existing Universe, Resolved Loops and Traps by developing and creating classes with dimension, detailed and measure object and specified hierarchies.
  • Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus, considering best business Practices using Web intelligence Rich Client.
  • Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports.
  • Designing SAP Business Objects Universes and reports based on the Specifications and developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
  • Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes Meeting User Needs and Requirements from both technical and strategic views of an organization.
  • Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.

Environment: Tableau desktop 10.3, Tableau Server, SAP Business objects 4.2, Designer, Web Intelligence, Crystal reports 2016, Oracle, Windows XP, SQL, PL/SQL, Oracle, MS-Excel, Microsoft SQL Server.

Confidential, Rochester, MN

Senior Tableau Developer / Crystal Reports Developer

Responsibilities:

  • Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality in Tableau 9.0.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps in Tableau 9.0.
  • Extensively used data blending, embedded functionalities in Tableau 9.0.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau 9.0.
  • Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
  • Created Rich dashboards using Tableau 9.0 Dashboard by develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau 9.0.
  • Provided 24/7 production support for Tableau users and conducting s to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
  • Created SQL Queries for testing the tableau Dashboards and connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Extensive experience in SAP Business objects which include Web Intelligence (WebI), Universe designer, SAP Business objects dashboards, Crystal Reports.
  • Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
  • Created complex Crystal reports with standard sub reports, cross-tab reports, formulas, Running totals, Grand totals and calculations. Also, added sorting, grouping and summarizations to Crystal Reports.
  • Created the Reports using the Universes as the main Data providers and wrote complex queries including Sub Queries, Case and Decode functions, using Crystal reports.
  • Actively involved in with ETL team to get right data to create crystal and BO reports and worked as an IT support to solve issues/tickets related to SAP Business objects/Crystal reports.
  • Created various Dashboard reports to measure the performance of several marketing programs by creating and developing Analytics and Alerts for individual Dashboards, specific to functional heads.
  • Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.
  • Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Environment: Tableau desktop 10.0/9.0, Tableau Server, SAP Business objects 4.1, Designer, Web Intelligence, Crystal reports 2011/2016, Oracle, Windows XP, SQL, PL/SQL, Oracle, MS-Excel, Microsoft SQL Server.

Confidential, Madison, WI

Senior Tableau Developer/ Senior Business Objects Developer

Responsibilities:

  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality in Tableau 9.0.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps in Tableau 9.0.
  • Involved in creating dashboards and reports in Tableau 9.0 and maintaining user and server activities.
  • Extensively used data blending, embedded functionalities in Tableau 9.0.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau 9.0.
  • Extensively involved in user acceptance testing (UAT) in Tableau 9.0.
  • Performed Parallel Testing which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
  • Interacted with business Users and Managers in gathering SAP Business requirements and involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
  • Creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer and involved in the designing and Building of Universes, Classes and objects.
  • Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
  • Resolved loops and Traps using Contexts and Aliases while designing Universes.
  • Worked with database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies and check the integrity of the Universes and export the universes to Repository for making available to users.
  • Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes Meeting User Needs and Requirements from both technical and strategic views of an organization.
  • Developed new set of standard Web Intelligence 4.1/3.1 reports against the new universe. Completed ad-hoc data requests as required.
  • Set up Universe level conditions to restrict data based on report requirements and a nalyzing system functionality requirements, documents and scope of the work by converting business requirements in business/technical requirement documents.
  • Extensive experience in SAP Business objects which include Web Intelligence (WebI), Universe designer, SAP Business objects dashboards, Crystal Reports.
  • Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus, considering best business Practices using Web Intelligence Rich Client.
  • Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
  • Expertise in Resolving the Daily issues in the Daily Doc Production Environment by scheduling and publishing reports onto WEBI to different destinations and Trained end users in understanding the reports.
  • The project involved in the development of reports using SAP Business Objects Web Intelligence to cater Ad-hoc reporting needs.
  • Involved in the testing and migration process of SAP Business objects 3.1 to 4.1.
  • Created Standard Reports utilizing all the features on Web Intelligence in BO like Optional Prompts, Functions, and Alerters etc. by creating 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.

Environment: Tableau 9.0/8.1, Tableau Server, BO XI 3.1/4.1, Informatica, DB2, Windows Server 2008/2012, Oracle, Microsoft SQL Server, MS-Excel.

Confidential

Tableau Developer / SAP Business Objects/ SAP Crystal Reports / Informatica Developer

Responsibilities:

  • Involved in creating dashboards and reports in Tableau and maintaining user and server activities.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.
  • Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
  • Extensively used data blending, embedded functionalities in Tableau.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards with simple drag & drop method and access them from any browser.
  • Created Rich dashboards using Tableau Dashboard by develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
  • Extracting the data tables using custom generated queries from Excel files, SQL database and providing extracted data as an input to Tableau.
  • Provided 24/7 production support for Tableau users and conducting s to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
  • Created SQL Queries for testing the tableau Dashboards and connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
  • Performed analysis, design, develop, testing and Maintenance of IDT & UDT Universes and develop highly complex and formatted Webintelligence reports for internal management.
  • Involved in designing and Building of Universes, Classes and objects by creating, developing, maintaining and testing the Universe for running the queries against the Database using Designer.
  • Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.
  • Modified existing reports based on the business user’s requirement changes and successfully pushed them into Production.
  • Actively involved in with ETL team to get right data to create crystal and BO reports and worked as an IT support to solve issues/tickets related to SAP Business objects/Crystal reports.
  • Responsible for defining, developing and testing of processes/programs necessary to extract data from operational system, transforming and cleansing data, and Loading it into data warehouse using Informatica Power center.
  • Cleansing the source data, extracted and transformed data with business rules, and building reusable mappings, known as ‘Mapplets’ using Informatica Designer and Involved in the development of Informatica mappings and performing tuning for better performance.
  • Working with the Joiner transformation using Normal Join, Master outer join, Detail Outer Join, Full Outer Join Designed and developing sophisticated workflows and data transformations involving Informatica.

Environment: Tableau desktop 9.0/8.0, SAP Business objects 3.1, Web Intelligence, Crystal reports 2011, Oracle, Microsoft SQL Server, Designer, Windows XP, Windows Server 2008/2012, SQL, PL/SQL, MS-Excel.

Confidential

SAP Business Objects Developer/SAP Crystal Developer / Informatica Developer

Responsibilities:

  • Participated in gathering Business Requirements, client Meetings and preparing TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents.
  • Migrated reports using LCM tool to Dev, Pre-prod, Prod environmentsand Business Objects XI R2 content into Business Objects XI R3 environment using the Import Wizard.
  • Created Business Objects Universes against the Star Schema to support Users,universe classes, objects (measures, dimensions and details)and reports for various Portfolios using the Universes as the main data Providers.
  • Defined Aliases, Contexts to resolve the join issues in the Universe;performed analysis, design, develop, testing, Maintenance of Universes and solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps.
  • Implemented various types of joins including equi-joins, outer joins, self-joins on tables in schema& Object level security for different user group requirements.
  • Created Different types of Graphs (Bar, line, Pie chart etc) and Cross Tabs with all sorts of formatting for report level analysis, reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc In Web intelligence.
  • Worked with CMC for creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports and supporting user groups during User Acceptance Testing.
  • Regularly synchronized the QA, DEV environments with Production reports and Developed, Customized and Implemented reports using Crystal reports.
  • Configured the environment, Developed, Scheduled and Tested reports using Crystal reports and Business Objects (Business View Manager, Info view).
  • Responsible for definition, development and testing of processes/programs necessary to extract data from operational system, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
  • Worked with the Joiner transformation using Normal Join, Detail Outer Join and Full Outer Join and Involved in the development of Informatica mappings and also performed tuning for better performance.
  • Designed and developed sophisticated workflows and data transformations involving Informatica.
  • Interacted with Lead Developers, System Analysts, Business Users, Architects, Test Analysts, Project Managers and peer developers to analyze system requirements, design and develop software applications.
  • Created connected and unconnected Lookup transformations to look up the data from the source and target tables. Modeling and populating the business rules using mappings into the Repository for Meta Data management.

Hire Now