Bi Consultant Resume Examples

bi consultant

  • Represented Google Express Merchant Direct customers and enhanced customer satisfaction by driving omni-channel customer support capabilities
  • Partnered with project management to develop comprehensive dashboards summarizing Google Express merchant performance
  • Defined business process flows using Microsoft Visio, data requirements using Excel, and report layouts for the Ops users
  • Developed ETL via SQL and App Scripts engine queries for over 200 merchants across 3 performance metrics (Days Outstanding, Refund SLA, Email Response Rate)
  • Decreased purchase lookup processing time by 30% and increased value recovery rate by 40% by automating scan operations for a critical piece in the value recovery value chain
  • Automated 6 hours of daily customer support email inquiries and implemented script that auto-generates email based on merchant, escalation type, and returns details
  • Spearheaded migration of Scan Ops department from Pittsburg to San Jose, thereby increasing efficiency and reducing head count

bi consultant

  •  Expert in providing Enterprise Reporting solutions using SSRS 2008/2012/2014/2016. 
  • Extensive ETL experience using DTS/SSIS/Alteryx for Data Extractions, Transformations and Load. 
  • Designed, developed, implemented, and supported Power BI dashboards. Integrated data sources and databases with Power BI, and designed and developed data models and back end queries for presenting data.
  • Designed testing plans and scripts in HP Quality Center based on requirements

bi consultant

  • Data warehouse development for Vodafone Hungary
  • Programming language: Oracle SQL
  • Knowledge following technologies: ETL, Oracle Data Integrator,Business Objects, PL-SQL
  • Knowledge in cloud data warehousing via Google Cloud Products

junior bi consultant

  • Responsible for Tableau Server Administrative functions, upgrades, installations and configurations.
  • Assigned permissions to different Lines of Businesses and users.
  • Schedule data refresh on Tableau server for weekly and monthly    increments based on business changes.
  • Tableau site admin – Published, revoked and granted permissions to the published dashboards.
  • Involved in development of the Reports and Graphs.
  • Maintained the module specifications documents for the reports.
  • Created compound reports in output formats of Excel and PDF. The compound reports included reports and graphs together which should be available in both Excel and PDF formats.

bi consultant

  • Prepare evaluations of software or hardware, and recommend improvements or upgrades, For Dundas BI Application.
  • Build, configure, and test RPA Processes using UiPath studio.
  • Build, develop and give consultations dashboards based on business needs.
  • Build a dashboard for Hajj season, to management and IT operations.
  • ETL to build dashboards from multiple sources.
  • Meeting Planner and follow up.

senior bi consultant

  • Attività di prevendita per prospect e clienti su vari prodotti di Business Analytics (Oracle BI, Essbase, Tableau) e Data Integration (Talend)
  • Attività di delivery su progetti di analisi dati, per aziende del settore TLC, Pharma e Manufacturing.
  • Developed reports in InfoAssist, which has given the capability to develop their own ad-hoc reports.
  • Created A2A validation document, which was used as a common template for all the folders.

bi consultant

  • Solve technical design issues in BI architecture.
  • Short assignments of performance tuning across several clients on the consumer goods domain. 
  • Develop Stored Procedures, SQL jobs, SSIS packages, Tableau dashbaords. 
  • Performed Regression and SIT Testing.

bi consultant

  • Demonstrate database technical functionality, such as performance,  and reliability.
  •  Assisted in fixing WebFOCUS reports cosmetic issues, browser related issues.
  • Converted complex MicroStrategy SQL into WebFOCUS using SQL Pass-through, with perfect data match.
  • Extracted SQL to generate reports in WebFOCUS and gathered default selections to replicate the same in WebFOCUS. 

bi consultant

  • Involved in Data Preparation and Cleaning process 
  • Creating Data Model.
  • Writing Mysql stored procedures and complex queries for reporting.
  • Involved in preparing & designing Data Models using R
  • Developing Insights Using Lumira

bi consultant

  • Schedule data refresh on Tableau server for weekly and monthly increments based on business changes.