- 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
- 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
- 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.
- 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.