We provide IT Staff Augmentation Services!

Business Intelligence / Tableau Consultant Resume

San Diego, CA

SUMMARY:

  • Around 9 years of Software Development Life Cycle experience in Business Intelligence and Data Analytics. Turnaround expert with strategic and tactical leadership focus of small to large projects from start through finish with an ability to translate technical ideas and design concepts across all project levels. Demonstrated consultative process skills and emphasis on technical, written and relational development.
  • Experience in the field of Information Technology with the emphasis on Analysis, Design and Development in the field of Database, Data Warehouse, Business Intelligence, Data Modeling and Implementation of Tableau Desktop, Tableau Server, Tableau Public, Business Objects and SQL Server.
  • Installation, Configuration, Administration and Development experience in Business Intelligence Tools using Microsoft SQL Server, Tableau, SAP Business Intelligence Platform.
  • Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 8, Tableau 9 and Tableau 10.3.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and drivers setup activities.
  • Successfully upgraded Tableau platforms in clustered environment and performed content upgrades. In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
  • Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Worked extensively on multiple data connections using blending, worked on Data Extracts and managing queries.
  • Expertise in Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
  • Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
  • Experience in using various MS office tools for analyzing, arranging and presenting data.
  • An enthusiastic and project oriented team player with good interpersonal relations, strong communication skills and ability to quickly adapt to different project environments.
  • Highly motivated team player with strong organizational, leadership, analytical skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Big Data Ecosystems: Hadoop, Map Reduce, HDFS, YARN, Hive, Pig, Sqoop, and Flume

Business Intelligence: Tableau 10.3/9.x/8.x, Tableau Desktop, Tableau Server, SAP HANA, SAP BOBJ 4.2, 4.0, 3.x, SAP BW, SSRS, Lumira, Dashboard Design.

Databases: MS SQL Server 2012/2008, Oracle 11g/10g, DB2 9.0, Teradata, MS Access

Operating Systems: Windows Server 2012 R2, Windows XP Professional/2003 Server

ETL Tools: SSIS, BODS, Data Integrator XI, Informatica

Languages: SQL, PL/SQL, Toad, JSP, C++, C, JAVA

Front End Tools: AQT v9, TOAD, Squirrel SQL Client 2.6.1

Testing Tools: HP Quality Center, HP Service Manager and Service Now

PROFESSIONAL EXPERIENCE:

Confidential - San Diego, CA

Business Intelligence / Tableau Consultant

Responsibilities:

  • Working on the software development life cycle of Business Intelligence.
  • Building the customized and interactive dashboards using multiple data sources.
  • Installed Tableau Server in Dev, QA, UAT and Prod environments.
  • Upgraded Tableau Server and Desktop from 9.3 to 10.3 version.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Installed patches on server and documented upgrade plan for Tableau 9.3 to Tableau 10.3
  • Administered user, user groups, and scheduled instances for reports in Tableau Server.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Developed tableau server audit reports to view and analyze tableau server insights (health, tableau server usage, tableau server data extract failures etc.)
  • Experience in taking back ups and restoration of Tableau repository.
  • Tableau server status reporting and data extract management.
  • Backup and Restore of Tableau Servers using Tabadmin commands.
  • Extensive work on tabcmd utility for the custom scheduling and tableau server administration.
  • Automated tasks using APIs to manage Tableau Server content like workbooks, data sources and users.
  • Configured distributed Tableau Server environment for real-time replication and failover support.
  • Involved in administration tasks such as creating and managing Sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
  • Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
  • Creating HealthCare dashboards using Tableau to leverage interactive, reliable reporting and visually stunning, accurate dashboards.
  • Interacted with financial analysts to understand the requirements and present the dashboards to executive level.
  • Participated in discussions for Tableau Server architecture design, enhancing performance, scalability and high availability.
  • Manage the application’s users, groups, and integration with Active Directory.
  • Defined best practices for Tableau visualizations development.
  • Worked on change requests to make improvements to the dashboards.
  • Tableau desktop and server tickets resolution (primary contact for support)
  • Created different KPI’s using Table calculations, LOD’s and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
  • Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.
  • Troubleshooting and debugging production issues, maintaining production systems around application and infrastructure outages, participating in development project teams as needed.
  • Perform Unit Testing, System Integration testing based on the application and requirements.

Environment: Tableau 9.3/10.3, Tableau Server, Tableau Desktop, Oracle, ETL, Toad, Business Intelligence Reporting.

Confidential - Carlsbad, CA

Business Intelligence / Tableau Consultant

Responsibilities:

  • Working on the software development life cycle of Business Objects Enterprise.
  • Worked in Agile Scrum model software development life cycle.
  • Created several SSIS packages for performing ETL operations to transform data from different sources.
  • Designed SSIS Packages for Finance department to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Developed Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the frontend for Payroll Data.
  • Building the customized and interactive dashboards using multiple data sources
  • Knowledge of Tableau Licensing.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Installation, configuration, patching and upgrading of Tableau tool across the environments.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
  • Participated in discussions for Tableau Server architecture design, enhancing performance, scalability and high availability.
  • Effectively used tabcmd for the maintenance of server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd
  • Created Dashboards and Stories by using Table calculations and Quick Table Calculations (Year over Year Growth, YTD Total, and YTD Growth).
  • Created Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server logons and security checks.
  • Add users/groups from Active Directory; schedule instances in Tableau Server including weekly data dump.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.
  • Installed SAP BI 4.2, SAP HANA and Lumira and compared the functionalities of Tableau and Lumira.
  • Performed admin responsibilities for the complete BI applications in the IT department.
  • Troubleshooting and debugging production issues, maintaining production systems around application and infrastructure outages, participating in development project teams as needed.
  • Perform Unit Testing, System Integration testing based on the application and requirements.

Environment: SSIS, SSRS, Tableau 9.x/10.x, Microsoft SQL Server 2012, SAP BOBJ 4.2/4.0, SAP HANA, Lumira.

Confidential - Raleigh, NC

Business Intelligence / Tableau Consultant

Responsibilities:

  • Defined and prepared data delivery designs and provide development support to leverage technology investments to support business needs
  • Collaborate with the business to gather and define the business requirements, business definitions, process flows, dashboard design, and report design to create business intelligence solutions
  • Perform data analysis and data profiling against source systems and data warehouse
  • Developed Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the frontend.
  • Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
  • Performed Tableau Server admin duties like installation, configuration, security, migration, upgrades, maintenance and monitoring.
  • Performed admin activities including improving the scalability of the Tableau Server environment by distributing server components across several machines.
  • Creating dashboards using Tableau to leverage interactive, reliable reporting and visually stunning, accurate dashboards.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
  • Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
  • Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
  • Expertise in working with data building Groups, Hierarchies and sets.
  • Monitored Application Server and Tableau Data server activity to track performance and system availability
  • Worked with the management, staff and vendors translating business reporting needs and/or operational reporting requests into technical requirements.

Environment: SAP BOBJ 4.0/4.1, Oracle 11g, SQL Server, SSIS, SSRS, Tableau, SharePoint, HDFS (Sqoop, Spark, Hive, MapReduce, YARN)

Confidential - Sacramento, CA

Business Intelligence Developer / Consultant

Responsibilities:

  • Interacted with Business Users to gather, analyze and record requirements/specifications.
  • Analyzing data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
  • Design Universe for Ad-hoc and enterprise reporting using Information Design Tool and implement Data Layer and Business layer as per the business requirements.
  • Design and monitor construction of an enterprise data warehouse including SAP BI/BW on SAP HANA
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
  • Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily.
  • Create and manage tickets to Interact with SAP support center for identified bugs with Business Objects Technical Support to track and resolve technical issues.

Environment: SAP HANA, SAP BI/BW, SAP BOBJ 4.0/4.1, Tableau, Dashboard Designer, DB2, SQL Server.

Confidential - Minneapolis, MN

Business Intelligence Consultant

Responsibilities:

  • Interacted with Business Users to know their business needs and effectively develop and modify Reports.
  • Worked closely with the Data Architect Team to ensure the implementation of Business Logic/Rules in the ETL Process.
  • Implemented System Development Life Cycle (SDLC) and Validation and Verification.
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Interacted with the ETL and Database teams to create alternate views, indexes and summary tables as part of Performance tuning of the Universes

Environment: SAP HANA, SAP BOBJ 4.0/3.1, Xcelsius, DB2, SQL Server 2008, Advanced Query Tool

Confidential - Palo Alto, CA

SAP Business Objects/HANA Consultant

Responsibilities:

  • Participate in Agile Scrum model software development life cycle.
  • Worked closely with the Architect and supervised the team to ensure the implementation of Business Logic/Rules in the ETL Process.
  • Designing Workflows and Data flows using Business Objects Data Services (BODS) to implement the conversion logic for Master Data and Transactional Data with large volumes of history data.
  • Created BEx queries and imported data to BOBJ 4.0 multi source Universe for users that are used for reporting.
  • Created Universes on top of HANA calculation views and developed the Web Intelligence reports and dashboards using IDT (Information design tool).
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Troubleshooting and debugging production issues, maintaining production systems around application and infrastructure outages, participating in development project teams as needed.

Environment: SAP HANA, SAP BOBJ 4.0, SAP BOBJ Dashboard Design (Xcelsius), BODS, SAP BW.

Confidential - Austin, TX

Sr. Business Objects Developer

Responsibilities:

  • Interacted with Business Users and Business Analysts to gather the Requirements and Business logics.
  • Analyze data for designing & implementing Universes using Business Objects Designer including gathering of dashboard requirements
  • Successfully imported Business Objects Universes, Users and user groups from R2 to XI 3.1 using the Import Wizard and migrated full-client reports to Web Intelligence reports using the Report Conversion Utility
  • Designed the BI system to accommodate the functional limitations of the Data Stage tool, also redesigned currency conversion logics to enable correct extraction from R/3 system.
  • Extracted data from legacy systems and transformed the data, loaded into the Data warehouse (Marts) using Data Integrator.
  • Worked with the ETL team to create Automated Daily Load Status Check reports to validate the data between source and target data marts.

Environment: SAP BI/BW, SAP Business Objects XI 3.1/XI R2, SQL Server 2005, Xcelsius 2008/4.5, Erwin 3.0

Confidential - Alpharetta, GA

Business Objects Developer / Consultant

Responsibilities:

  • Interacted with Business Users to gather the requirements and Business logics/Rules.
  • Implemented Migration process for Business Objects XI R2 to XI 3.1, such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and Education delivery.
  • Designed Functional Specification for report creation based on the initial business requirements.
  • Developed Web Intelligence Reports and Dashboards which involved complexities like linking, and multiple data providers
  • Mentored the team in various issues related to Universe designs and Report Development.

Environment SAP Business Objects XI 3.1/ XI R2, Crystal Reports, Xcelsius, SQL Server 2005, DB2, TOAD.

Confidential, Austin, TX

Business Objects Developer

Responsibilities:

  • Interacted with business users, business owners to know their Business views in developing, modifying universes and report development.
  • Analyzed the existing database and created/modified the Universes using Business Objects Designer Module.
  • Used the functionality of linking universes so as to have the flexibility to use the objects defined in one universe in another.
  • Reports were formatted according to the user requirements using Business Objects functionalities like Breaks, Calculations, Slice and Dice, Drill Down and Variables.
  • Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.

Environment: SAP BW, SAP Business Objects XIR2, Crystal XI, Oracle 9i, SQL Server, TOAD, SQL, PL/SQL.

Confidential - Purchase, NY

Business Objects Developer / Consultant

Responsibilities:

  • Involved in Full project life cycle (requirement gathering to implementation phase) and gathered requirements for Business Objects Universe to support Ad hoc report needs and report requirements for Reports from the users.
  • Implemented Row/Object level restrictions according to different Business group requirements.
  • Created universes, classes and objects by retrieving the data from various data sources Generated Business Objects Reports by using Free Hand SQL as a data provider when universe did not contain necessary data.
  • Involved in migration from existing XIR2 systems to BO XI 3.0 in Development Environment.

Environment: SAP BO XI 3.0/XIR2, Crystal Reports, Oracle 9i/10g, MS SQL Server, Windows 2003 Server.

Confidential, Austin, TX

Business Objects Developer / Consultant

Responsibilities:

  • Participated in gathering functional requirements and data specifications.
  • Designed universe for standard reporting and ad hoc reporting requirements.
  • Analyzed Data using Slice and Dice and Drill Mode, etc. and Formatting Reports
  • Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
  • Implemented row level restrictions according to different business group requirements.
  • Responsible for maintaining the development, testing and production repositories and providing round the clock support during the production stage.

Environment: Business Objects, TOAD, Visual Basic, MS SQL Server, UNIX, Windows 2000 server.

Hire Now