We provide IT Staff Augmentation Services!

Sr. Tableau/bi Consultant Resume

5.00 Rating

Harrisburg, PA

SUMMARY

  • Strong analytical, conceptual design skills and strong problem - solving skills and have best Practices for Real-time Data Warehousing and Business intelligence
  • Expertise in Building Proof of concepts, Road Maps with cutting edge BI solutions
  • Leveraged Business Intelligence environments with cutting edge BI Technologies
  • Expertise in BI dashboards, Data Visualization, Predictive analytics, Advanced reporting, Business analytics, data analysis, Big data analytics, Data Warehousing, Database Programming, Data Modeling, and OLAP
  • Expertise in Documentation of Technical/ Functional Specifications, Best Work Book Designing Standards, POC’s, Impact Assessments
  • Strong experience in data analysis, data mapping, data warehousing, and data consumption from data sources.
  • Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements
  • Sound knowledge in Dimensional modeling and designing and implementing Star and Snowflake Schema
  • Excellent SQL, TSQL, PL/SQL coding, Triggers, Stored procedures, Views development skills.
  • Highly Proficient in preparing Functional Designs & Technical Specifications for Tableau BI reports / dashboards / analytics.
  • Strong analytical, conceptual design skills and strong problem-solving skills and have best Practices for Real-time Data Warehousing and Business intelligence
  • Expertise in Building Proof of concepts, Road Maps with cutting edge BI solutions
  • User experience design(UX)
  • Interest in adopting new technologies and gain proficiency in the technologies
  • Work under pressure with minimal guidance

TECHNICAL SKILLS

Business Intelligence: Tableau 9.x/8.x/7.x (Desktop, Server, Mobile, Online, Data Extracts, Tableau Performance Analyzer, Cloud), SAP BOBI 4.1(Dashboards, Web Intelligence, BI Launch Pad, Information Design Tool, CMC, SAP Crystal Reports), Microsoft BI (SSAS,SSIS, SSRS, Power BI) 2012/2008

ETL Tools: SSIS 2012/2008/2005 , Informatica Power Center 9.1.0/8.6/7.1 , SAP BODS 4.1/XI3.0

Databases: IBM DB2 10/9/8.2, Oracle12c/11g/10g/9i/8i, MS SQL Server 2012/2008/2005 /2000, MS Access 2013/2010/2007/2003 , Teradata 15/12, MySQL 6.x/5.x

Operating Systems: Windows Server 2016/2013/2008/2003 , Red Hat Enterprise Linux 7, HP-UX 11i, Solaris 10, Windows 10/7/NT/XP/Vista

Data Modeling: Oracle SQL Developer Data Modeler 3.0, ERwin Data Modeler Version 9.0.0

Programming: PL/SQL, TSQL, HTML5, XHTML,XML, C++, UNIX

Scheduling: Control M Enterprise Manager 7.0.0/ 6.4.01/6.3.01

MS-Suite: MS Word, MS Excel, MS Access, MS PowerPoint, MS Visio

Methodologies: Agile-Scrum, Waterfall-Model, Incremental, Iterative, Proto-type.

Tools: Tomcat 6/4.1/IIS 5, kdiff3 0.9.95, Control - D/Web Access Server Version 3.7.00.400 , DB2 Command Editor, UltraEdit Professional Text/HEX Editor, IBM data set commander for z/os, IBM Rational Manual Tester 7.0.1, PuTTY 0.65/0.61, Rational Suite (Rational Rose, Requisite Pro, Clear Case, Clear Quest), SQL*Plus, TOAD 5.1/4.5, PL/SQL Developer, SQL Navigator 5.5.1/4

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr. Tableau/BI Consultant

Responsibilities:

  • Lead BI Design and Development activities including developing the Data models, BI solutions, Analytic visualizations, Complex Reports
  • Followed Tableau Life cycle to generate Data Views
  • Provided POC’s for different types of Data Visualizations & BI analytics
  • Tableau has been extensively used to create Data Views, Workbooks, Dashboards, and Story boards
  • Effectively utilized features like Custom color palette, Bins, Groups, Table Calculations, Calendar control, key performance indicators (KPI), Cascading Quick Filters, Dimensions, Measures, Calculated fields, Context filters, Data Extracts, Relative date filter, Pages Shelf, Filters Shelf, Marks Shelf using Tableau Desktop
  • Tableau Workbooks, Dashboards, and Story boards has been using Hadoop Stack(Cloudera Impala & MapR Hadoop Hive)
  • Worked with the Tableau server side for creation of users, groups, permissions, Data sources, Workbooks, schedules and refresh tasks
  • Alteryx has been used for Faster Data Blending& Advanced Analytics.
  • Leveraged Tableau Desktop by connecting to R through calculated fields
  • Used R functions, libraries, packages and even saved models for Tableau Desktop
  • Stimulated the Users, business partners, and internal team members to support or improve the business process.
  • Effectively utilized Context Filter, Custom SQL Filters, Data Source filters and Quick filters for Tableau Desktop
  • Tableau Data Blending Has been used to merge data from different sources
  • Schedules are created and managed on the Tableau server
  • Standardizing Unstructured Data, Data Transposing, Polygon Creation for Tableau has been done using Alteryx for Tableau.
  • Worked on Tableau Server Monitor activities (Stop/Stat/Restart the Server, check the Server Activity & The Background Tasks)
  • Tableau Performance Analyzer has been used to address performance issues by analyzing the running times, total query time,% of total running time, Record count information
  • Designed Polygon Maps, Column Combination, Gantt, Heat map, Histogram, Box-and-whisker plot Charts using Tableau Desktop
  • Worked on Horizontal, Vertical, Text, Image Extract, Blank Page, Web Components of Tableau
  • Tableau has been used to Build Workbooks for different the Subject Areas and ARRA Reports(American Recovery& Reinvestment Act), Cash flow Management, HAPD(Highway Administration Performance Dashboard), Meds System, miscellaneous, PCA(Program centers analytics for Districts), PRP (Project revenue planning for project funds throughout the Commonwealth), Roadway Management application (ROAD),PMPA(Plant Maintenance performance analytics data reports)
  • Tableau has been used to connect Cloud Databases like Amazon Redshift, Google Analytics, Google Big Query and Tableau Online
  • Extraordinary Story boards with maximum insight and impact have been designed by using Tableau and got appraisals by the client for my efficient and In-Time delivery.

Environment: Tableau 9.1/9.0.2 (Desktop, Server, Reader, Mobile, Online& Tableau Performance Analyzer), Oracle 12c/11g, Red Hat Enterprise Linux 7, Oracle 12c/11g, Oracle PL/SQL, MS Access 2013, Agile-Scrum, MS office 2013, CDH (Cloudera Hadoop)5.x, PuTTY 0.65/0.61, R, Alteryx, DB2 Command Editor, UltraEdit Professional Text/HEX Editor and IBM Data Studio V4.1 for Db2 10

Confidential

Sr. Tableau/BI Consultant

Responsibilities:

  • Responsible to Drive Requirements for Data Visualizations & BI analytics using Tableau Desktop
  • Tableau has been used for the BI analytics to help the consumers see trends and make informed business decisions.
  • Worked functionalities like Custom color palette, Bins, Groups, Table Calculations, Calendar control, key performance indicators (KPI), Cascading Quick Filters, Dimensions, Measures, Calculated fields, Data Extracts, Relative date filter, Pages Shelf, Filters Shelf, Marks Shelf using Tableau Desktop
  • Used Tableau to create Work books, dashboards, score cards, Maps and Charts
  • Support of executive and operational reporting by connecting to Live using Tableau
  • Created interactive, and insightful charts and graphs using Tableau
  • Good Hands on with Quick Filters, Dimensions, Measures, Calculated fields, Context filters, Data Extracts, Hierarchies, Calendar control for Analytics using Tableau Desktop
  • Designed and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Tableau Server has been used for Administration activities
  • Improved the performance of Tableau Data Extracts, Data Views
  • Worked on Custom SQL with Dynamic Parameters using Tableau Desktop
  • Created Calendar control in Tableau Desktop for date parameters to selecting the start or end date of a filter
  • Worked on LOD(Level of Detail) expressions using Tableau Desktop

Environment: Tableau 8.1(Desktop, Server, Mobile, Tableau Performance Analyzer), SQL*Plus, TOAD 4.5, Oracle SQL &PL/SQL, kdiff3 0.9.95,UltraCompare Professional Version 14.0, IBM Rational Manual Tester 7.0.1, Rational Suite (Rational Rose, Requisite Pro, Clear Case, Clear Quest),SQL Server 2012/2008, Oracle SQL Developer Data Modeler 3.0

Confidential, Harrisburg, PA

Sr. Tableau/BI Consultant

Responsibilities:

  • Responsible for Data Visualizations & BI analytics using Tableau
  • Designed and developed 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 Visualizations
  • Extensively used Tableau for data visualization and to create dynamic, interactive dashboards.
  • Worked on refreshing data through Tableau Data Extracts, Tableau Server and Tableau Command Utility
  • Created Users, User Groups using Tableau Server
  • Improved the performance of the Tableau Data Extracts
  • Effectively utilized Bump Charts, Treemap, WordClouds, Bubble charts, Control Chart, Polygon maps, BoxPlots, Cumulative Histograms and Funnel Chart
  • Created Top N Analysis in Tableau Desktop by creating Parameters using Tableau Server
  • Created Trend Analysis with Story boards using Tableau Server
  • Extensively Created Hierarchies, Parameters and complex calculation fields in Tableau Desktop

Environment: Tableau Desktop and Server 8.1, Rational Clear Case Explorer 7.1.2.2, Rational Clear Quest 7.1.2, IBM Rational Manual Tester 7.0.1, Oracle SQL Developer 1.5.5 for Oracle 11g, UltraEdit Professional Text/HEX Editor kdiff3 0.9.95,Teradata 12.

Confidential, Harrisburg, PA

Tableau/BI Consultant

Responsibilities:

  • Responsible for Tableau Desktop Visualizations
  • Created Reports Specifications, Requirements Traceability Matrix, User Manuals, Documentation for PDE Users
  • Verified the accuracy and validity of the data including preparations of sample test data, unit testing approach and system testing.
  • Developed Tableau Desktop Visualizations based on existing Xcelcius Dashboards and changed as per new functionalities
  • Coded complex stored procedures in T-SQL &Custom SQL’s for Tableau Desktop
  • Develop SQL Server Integration Services (SSIS) ETL packages for Data Warehouse (DW) and Data Marts (DM)
  • Maintains data flow diagrams and documentation
  • Participated in requirement and technical specification sessions and provides data analysis and data mapping
  • Created the Custom SQL Queries for Tableau Data Extracts.
  • Provided end user support for new and existing Enterprise reporting Solutions and reports.

Environment: Tableau Desktop and Server 7.x, MS SQL Server 2008, Oracle PL/SQL, Ultra Edit 15.10, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MS SQL Server Management Studio(SSMS), Visual SourceSafe Explorer 2005/6.0

Confidential

Tableau/BI Consultant

Responsibilities:

  • Responsible for designing the Decision support systems using SAP Business Objects, Xcelcius, SAP Crystal Reports, Tableau Desktop in large data warehouse, data store environments and on large relational databases
  • Involved in Full SDLC which includes Requirement gathering, Development, Unit testing, UAT, Post Production testing and Production support.
  • Designed Dimensional Business Objects universes for Auto, Fire Insurances and helped the Business users by creating appropriate Filters for various stages of validation and successfully implemented in PRD
  • Worked on the Data Conversion, Apt tolerance to convert Illinois CSR and eMedical data into the ECS and BIRA databases and Investigated the Performance issues of the Reports
  • Created Documentation of Report Specifications/Designs, Reporting Team Process, Report development Checklist, Report Validation Checklist, Reports Scheduling, Report Formatting Standards & Universe Designs for knowledge transfer
  • Created manual test cases to Test the Reports after did though testing after the Unit testing
  • Helped with the Confidential BA’s &users for UAT Testing for the Sign off
  • Written the complex queries for Derived Tables, Dimensions, Measures of universes and WebI
  • Used Control-M 7.0.00 to Schedule Daily, weekly and monthly reports & to run the Jobs
  • Extensively Worked on Report Security, Reporting standards, Report Presentation, Multiple Queries, Predefined Conditions, Aggregate Awareness, Scope of Analysis, Sections and Breaks using Business Objects Web Intelligence, Interactive Analysis
  • Designed universe based on XML data & DB2 Database to build Adhoc Reports
  • Worked on Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center, Power Mart (Repository Manager, Designer, Server Manager/Workflow manager, Workflow Monitor).
  • Trained end-users on various functionalities of the Business Objects Enterprise, and Supported the users with their Business Objects related issues / problems
  • Interacted Daily basis with Business Analysts, DBA’s and End Users to gather the business needs and requirements to Create and modify existing Universes and Reports
  • Interacted directly with the clients to accommodate any changes, if required and making sure that the client is fully satisfied with the end results.

Environment: Tableau Desktop and Server 7.x, Business Objects XI 3.1(Designer, QAAWS, Live Office, Web Intelligence Rich Client 12.1.0.882 , Import Wizard, Business View Manager, Query Builder, Data Source Migration Wizard, Translation Manager, Universe Builder), Control M Enterprise Manager 6.4.01/6.3.01 , Control - D/Web Access Server Version 3.7.00.400 , IBM DB2 9/8.2, kdiff3 0.9.95, Xcelsius 2008, Report Conversion Tool 4.0, IBM ODA 2.2.3.0/2.2.2.1 , KPIs, Informatica Power Center 8.6, Lotus Notes 8.1, Performance Management Framework, OLAP Intelligence XI R3, SAP Crystal Reports 2008

Confidential, Kenilworth, NJ

BI Developer

Responsibilities:

  • Involved in Full project life cycle which includes Reporting Requirement gathering, Development, Unit testing, UAT, Change control, Migration, Post Production testing and Application support.
  • Developed several Complex Reports including multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulas, Running Totals and conditional suppressing, formatting using Crystal Reports.
  • Optimized the usage of user objects, conditions and universe level filters Migrated Legacy Business Objects (REP) reports migrated to Desktop Intelligence (REP) format with the Import Wizard
  • Performed data validation and data integrity checks by writing SQL queries, Increased the existing Queries performance
  • Collaborated with Data Modelers in designing and developing the new Reporting data marts and Reports and Changes accordingly in the Universes
  • Worked Extensively with Tableau Server to define Access levels for Groups, Create Server groups, Servers
  • Expertise with pharmaceutical industry, in particular clinical trials, IMS, Sales, Marketing data and CTMS
  • Worked as service team associate and investigated, fixed the daily issues
  • Migrated the Legacy Crystal Reports from V8.5 to Crystal Reports 2008 by creating a New Universes and Solved the issues during migration
  • Prepared Documentation and Created Report Requests in coordination with Business Analysts and Validation analysts.
  • Used Query Builder To extract list of Web Intelligence documents that are scheduled in a specified period of time, get a list of specific universes
  • Enabling and Disabling Universes/documents for un-authorized users and periodic Password maintenance.
  • Extensively used Live Office connector & Web connectivity components with Crystal Xcelsius XIR2
  • Using Xcelsius 2008 Created interactive dashboards using QAAWS Exported to Business Objects Platform
  • Migrated Desktop Intelligence reports to Web Intelligence using Report Conversion Tool XI R2 and published the converted reports to the CMS
  • Worked as offshore coordinator, managed and conducted effective communication with internationally located offshore teams.

Environment: Business Objects Enterprise XIR3/XIR2 ( CMC, Designer, Info view, Web Intelligence, Import Wizard, Report Conversion Tool, Business View Manager, Query Builder), Data Integrator (Designer, Management Console), IBM InfoSphere DataStage 8.5, Query Builder, SSIS 2008/2005, TOAD 5.1/4.5, Crystal Reports XIR2, Mercury Quality Center 9.0, Teradata V12, Xcelsius 2008/4.5, MS SQL Server 2005, Query Builder, Oracle 9i, SQL Navigator 5.5.1/4, MySQL 6.x,QAAWS

We'd love your feedback!