We provide IT Staff Augmentation Services!

Data Analyst/tableau Consultant Resume

Reston, VA

SUMMARY

  • Over 10+ years of years of experience in experience in IT industry as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts. As well as data Analytics using python/SQL/Tableau.
  • Expertise in Tableau /2019.x/2018.x/ 10.5/10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting.
  • Designed several business dashboards using Power BI, Tableau Desktop, Tableau server and hosted them across the client servers.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Expertise in Requirements gathering/analysis, Data Mining, Design, Development, Testing and Production rollover of Reporting and Business Intelligence Analysis projects.
  • Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
  • Extensively worked on Data Extraction from SAP ECC or Legacy Systems to SAP BW system as a Target By using SAP BODS.
  • Dealing with processes, governance, policies, standards and tools as part of MDM to consistently define and manage the critical data of the organization.
  • Extensively Created SAP BW connection to interact with SAP BODS using RFC connection.
  • Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Used Tableau Version 10.5 Hyper feature for faster data ingest and analytical query processing on large or complex data sets.
  • Extensive experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Used Tableau Versions for flexible data sharing and analytics firepower with enhanced statistical, parameter capabilities.
  • Extensively involved in MDM to help the organization with strategic decision making and process improvements. (Streamline data sharing among personnel and departments).
  • Well versed with Business Objects Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
  • Experienced in developing applications using Agile Methodologies and Scrum stories in a python - based environment.
  • Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.
  • Extensive experience in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
  • Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS).
  • Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
  • Management Systems, Apache Superset, Tableau, Looker, AWS cloud computing, Hadoop, Spark.
  • Used SSRS to create and manage a wide variety of different types of report and deliver them in a range of formats.
  • Extensive usage of AWS for connecting to data sources on cloud using Amazon Redshift.
  • Experience in Designing and deploying AWS solutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.
  • Used SSRS to create basic reports containing tables and graphs and more complex data visualizations, using charts, maps and spark lines.
  • Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
  • Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application, folder and user levels.
  • Worked on connecting tableau to various other data sources like Hive, Redshift AWS, Teradata, Oracle and experience in establishing respective driver connections.
  • Performed maintenance activities like Backing up, cleaning logs and archiving log files in prescribed intervals.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
  • Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side.
  • Used Kerberos for user authentication through Active directory (Win AD).
  • Used Sign in Method using the REST API for successful sign in operations
  • Setup of SSO between Tableau portal and Oracle.
  • Improved Reports performance in tableau using extracts and context filters.
  • Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
  • Hands on Programming skills in SQL, PL/SQL, Stored procedures, packages, functions, triggers.Managed all upgrades, maintenance, and support of the Business Objects System and Expertise in Migrating the Business objects from 5.1.x/6.1a/6.1b/6.1.5/XI r2 to XI 3.1.
  • Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
  • Created calculated fields to interact with parameters dynamically to visualize the data on the fly.
  • Worked on setting permissions on content for specific users or group on a per site basis.
  • Participated in day-to-day activities like creating workbooks, dashboard, published on server.
  • Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop/Server) 10.2/10.1/10.0/9.3/9.2 , SAP BOBJ 4.0, Power BI, Qlikview, BIRST, R, Python, and Spark, Pyspark, SSRS

ETL: Talend, Data Migrator, SAS Data Management, Oracle Warehouse Builder and SSIS

Databases: Oracle, MS SQL Server, T-SQL, DB2, No SQL, Teradata, Mongo DB, Cassandra

Languages: SQL, PL/SQL, R, PySpark Professional Experience

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Data Analyst/Tableau Consultant

Responsibilities:

  • Conducted meeting with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
  • Designed, developed, maintained Tableau functional reports based on the requirements of the user.
  • Experience in design and development of Tableau visualization solutions.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for
  • Experienced in creating the groups, users, workbooks and, also permission sets for the tableau server logons and checks
  • G athered and documented MDM application, conversion and integration requirements.
  • 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.
  • Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
  • Created and maintained around Crystal reports and Web Intelligence reports.
  • Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.
  • Hands on development in assisting the users in creating the worksheets and, also modifying them and data visualization dashboards.
  • Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
  • Used Alteryx Analytics to simplify the complex task of determining and gathering the relevant data and then cleansing the data for consumption.
  • Used Alteryx to enable integration with virtually any data source from any location and enrich them with third-party spatial, location-based, and demographic data to get the richest set of data available for analysis in Tableau.
  • Support Data and Analytics/Transformation Architecture teams who are building a data strategy aligned with global strategic direction - develop canonical and other models as required, implementing data architecture platforms and solutions and data services, develop MDM foundation, participate in the design and implementation of unified data warehouse; must be able to implement end to end solutions in support of the various data tracts and work streams
  • Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
  • Designed, developed and tested various Tableau/Tableau visualization for dashboard and ad-hoc reporting solutions.
  • Preparing Dashboards using the calculations, parameters in the Tableau and creating SQL datasets for Tableau and Ad-hoc reports.
  • Expert on creating the report schedules on Tableau server.
  • Developed story telling boards in desktop and published into the server which allowed users to understand the data with the filters when they needed certain information.
  • Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
  • Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects
  • Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Proficient in developing Entity- relationship diagrams, star/snowflake schema designs and expert in modelling the transactional databases and data warehouse.
  • Provided production support to Tableau users and written custom SQL to support business requirements.
  • Blended the data from the different databases in to one report by selecting the primary keys from each database for the data validation.
  • Extensively used LOD (Fixed, include, exclude function) and table calculation function Total, Window function in Tableau.
  • Designed, developed and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions.
  • Developed jobs to load the legacy system data into COND A04 IDOC (KOMG, KONH, KONP segments) by referencing SAP AIO SD pricing job.
  • Used Open Hub Services to push data out of SAP BI using BODS.
  • Worked closely with data architects to improve data's performance by reducing the number of calculated fields and thus optimizing performance.
  • Created Heat Map showing current store location by color that were broken into regions allowing business user to understand where we have most customer vs. least customer.
  • Managing timely and accurate delivery of information to various cross functional teams.
  • Expert in data preparation with experience in blending multiple data sources, and creating multiple joins within the same data source.
  • Designed interactive dashboard with drill down capability, roll back capability, customizations by using both live and extract data connections.
  • Used filters, parameters, sets, groups, hierarchies (Customer and default), calculated fields and table calculations to create interactive, user friendly and creative dashboards.
  • Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, grant charts, trend lines, waterfall charts, statistical models, heatmaps, geo-maps allowing end users to utilize full functionality of the dashboard.
  • Worked extensively with background imaging, custom geo-coding to plot KPIs on the dashboard.

Confidential - Mclean, VA

Sr. BI Consultant/Data Analyst

Responsibilities:

  • Designed, developed and tested various Power BI/Tableau visualization for dashboard and ad-hoc reporting solutions.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Revert to older version workbooks in Tableau Version 10.5 with improved workbook version compatibility.
  • Extensively involved in MDM to help the organization with strategic decision making and process improvements. (streamline data sharing among personnel and departments)
  • Involved in data profiling like source column data profiling, detail data profiling and used validation and address cleansing transformations by using data quality in SAP BODS 3.2, 4.1.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Customized the Tableau Server Home page and designed own Reporting landing Page to give the user feel of a web portal.
  • Design data load jobs in SAP BODS.
  • Performed as an enterprise MDM subject matter expert. Responsible for delivering customer information systems across North America and Canada. Took responsibility for integrating variety of data systems, and geographically fragmented customer information.
  • Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
  • Worked for major SAP partners for their SAP BO 4.1, SAP BO 4.0, SAP BODS 4.1, SAP BODS 4.0 implementations in Ramp up as well as Go Live environments
  • Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
  • Reports are made user friendly by implementing user prompts, conditions and filters.
  • Used various ETL tools to extract data into Tableau Desktop and data wrangling using Alteryx in data preparation phase. Performing end to end Data validation.
  • Used Alteryx and Tableau, for business users to easily consume deep spatial, location-based, and predictive analytics in a visually rich environment.
  • Expertise in creating Report Models for building Ad hoc reports using SSRS.
  • Created Heat Map showing current service subscribers by colors that were broken into regions allowing business user to understand where we have most users vs. least users.
  • Building mockups/POC’s using different KPI’s the organization mainly focuses on and to analyze data, reports and to dive into systems and formulate new and better ideas on how to better support stakeholders.
  • Extract data from business intelligence system and generate reports for planning/MDM, manufacturing and other areas of the supply chain.
  • Analyzed, designed, developed, and deployed a Global wide reporting solution using Business Objects and Gathered business requirements, developed Functional Specification Documents, Technical Specification Documents for Universes and reports.
  • Developed various analytical reports by connecting Tableau to Amazon Redshift data base and writing complex custom SQL queries to extract data and build Reports
  • Designed and developed Aggregate tables and views to improvise the performance on the reports and reducing the complexity load on the dashboards
  • Build rich and dynamic dashboards using out-of-the-box features, customizations, visualizations and advance functionalities like Groups in calculations, LODs, Cluster analysis, Cross Data Source Filters, Cross Database joins etc. in Tableau.
  • Deploying SSRS Reports across multiple environments including Test and supporting environments.
  • Create required shell or python scripts for data push from Tableau.
  • Design and maintain databases using Python and developed Python-based API (RESTful Web Service).
  • Writing python script to Automate the data from Teradata to cloud Environment.
  • Figured build failure which is due using multiple data frames used by developers & override those by adding nose test cases
  • Conducted meeting with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
  • Created many calculated columns and measure using DAX in Power BI based on report requirements.
  • Developed entire frontend and backend modules using Python on Django Web Framework.
  • Involved in UI Design for Power BI reports and design effective layouts.
  • Expertise in creating Power BI Embedded Reports.
  • Created roles and implemented Row level security for user Authentication in Power BI.
  • Created effective dashboard in Power BI service and made the reports user friendly and interactive.
  • Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.
  • Installed on premise data gateway and schedule daily data refresh in Power BI.
  • Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
  • Import data into power BI using different ETL methods, SQL Azure, Direct Query, and Restful API. Generator build relational model with in Power BI generate marketing Campaigns metrics related to landing pages, Email Analysis and visitors.
  • Expert in data preparation with experience in blending multiple data sources and creating multiple joins within the same data source.
  • Worked extensively with background imaging, custom geo-coding to plot KPIs on the dashboard.
  • Updated various documents like design document, business requirement document and technical specifications document.
  • Worked with various team including Business Analysts, ETL, Data Warehousing, and testing for smooth flow/transition of development life cycle.
  • Worked on Agile methodology and involved in scrum meetings to give inputs as technical expert to application design for performance tuning and admin requirements.
  • Created and tested various stored procedures, views, and triggers during data preparation stages. And suggested best practices for process improvements.
  • Monitoring schedules and extracts and debugging issues with data extracts if any.

Confidential

Data Engineer/ BI Consultant

Responsibilities:

  • Extensively used visual filters, page filters, report filters and drill through filters in Power BI reports
  • Strong knowledge in designing and developing Power BI visualization according to business requirement documents and plans for creating interactive dashboards
  • Migrated existing Tableau reports to Power BI reports for different teams to analyze log information/supply chain data
  • Managed access of reports and data for individual's users utilizing roles by embedding Power BI reports
  • Involved in providing maintenance and development of bug fixes for the existing and new Power BI reports
  • Attended weekly status meetings and represented the MDM Data platform
  • Documented business and technical requirements gathering for the development of MDM, Data Warehousing and Reporting implementation roadmaps
  • Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects
  • Gathered requirements for MDM tool implementation and user workflow processes
  • Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
  • 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.
  • Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
  • Created and maintained around Business Objects reports and Web Intelligence reports.
  • Used Alteryx Analytics to simplify the complex task of determining and gathering the relevant data and then cleansing the data for consumption.
  • Used Alteryx to enable integration with virtually any data source from any location and enrich them with third-party spatial, location-based, and demographic data to get the richest set of data available for analysis in Tableau.
  • Used various ETL tools to extract data into Tableau Desktop and data wrangling using Alteryx in data preparation phase. Performing end to end Data validation.
  • Designed dashboards utilizing custom filters and DAX expressions with Power BI
  • Presented data through dashboards and scorecards with different visuals such as funnel charts, donut charts, scatter plots in Power BI
  • Experience in Upgradation from SAP-BODS 3.2 to SAP-BODS 4.0.
  • Developed monitoring and notification tools using Python
  • Developed the transformation/business logic to load data into data warehouse
  • Designed Complex mappings for Slowly Changing Dimensions using Lookup (connected and unconnected), Update strategy and filter transformations for retaining consistent historical data
  • Created a mapping for the movement of data from oracle and used SCD1 and SCD2 mappings
  • Performed source data analysis and captured metadata, reviewed results with business. Corrected data anomalies as per business recommendation
  • Built a real-time data pipeline to channelize user's activity and transaction data and create ad profiles for individual users
  • Instigated duplicates removal mechanism using Spark data frame and executed 'Upsert' logic using SparkSQL
  • Implemented the entire flow of data processing in Spark using Scala API and optimized the processing time.
  • Designed and created Hive external and internal tables with partitioning and bucketing using ORC format
  • Worked on automated data pipelines
  • Designed and built ETL pipelines to automate ingestion of structures and unstructured data.

Confidential - Cleveland, OH

Tableau Developer/BI Analyst

Responsibilities:

  • Conversion of extreme level design specifications to detailed technical, functional specifications and interacted with business users for gathering requirements for Tableau Workbooks and Dashboards.
  • Developed or enhanced several strategic models to assist in long term planning of the health
  • Developed report automation processes using Tableau to improve turnaround time and reporting capabilities
  • Handling administration related issues for SAP BODS and Business Object Data Quality Management.
  • Installed Business Objects Server components installation, applied fixes/service packs and did tuning and monitoring the server performance in AIX.
  • Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.
  • Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
  • Involved in Data mapping, logical data modeling used SQL queries to filter data within the database tables.
  • MDM to resolve data issues to recognize the inconsistent and duplicate data and finding useful relationships to improve business performance.
  • Worked with the ETL tool like Informatica for data integration and data quality services.
  • Implemented Migration process for Business Objects 6.5.1 to XI r2, Crystal Report 9/10.0 to XI r2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and Education delivery.
  • Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
  • Provided advice and support in the usage of healthcare data within the product portfolio, and provided expert subject-matter support to product design and development initiatives
  • Responsible for analyzing health data and producing, verifying and interpreting client reports with very little oversight
  • Consolidated data in a cross functional environment from multiple data sources (i.e. membership, claims/encounters, pharmacy, lab, radiology) to create ad hoc reports to support large group proposals
  • Worked on editing data connections and changing data sources in Tableau
  • Specialized in analyzing and editing metadata (dimensions and measures) and saving data sources.
  • Created worksheets by creating join/data blending, custom SQL and data source filters.
  • Created non-hierarchical quick filter with sets.
  • Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
  • Created interactive visualizations by adding quick filters.
  • Conversion of extreme level design specifications to detailed technical, functional specifications and interacted with business users for gathering requirements for Tableau Workbooks and Dashboards
  • Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
  • Used Alteryx and Tableau, for business users to easily consume deep spatial, location-based, and predictive analytics in a visually rich environment.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
  • Created ETL packages using Heterogeneous data sources (DB2, ORACLE and Flat Files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
  • Created different types of reports such as tabular, matrix, drill down and sub reports
  • Worked in Agile development methodology environment

Hire Now